Help please with a Clan website

[Wookie76]

Hopefuly someone can point me in the general direction.

I have a Call of Duty clan website which I would like to add a voting system too. To award medals and awards so heres the logical steps I would like...

1. Clan match finishes
2. I enter clan mebers in at a web page.
3. The clan members listed on said page can vote to award medals.
4. Clan members see a list of awards and a drop down menu by side each award including all clan members entered on point 1.
4. Clan members select who they want to recieve each award... they press submit when finished voting.
5. When all voting is complete and any member recieves 4 or more votes for any award it will insert the html code to each members medal page to add there medal ( Pic ).

Hmmm how does that sound..... I have the medals page done and the voting page but no code in the back ground... how would I go about it..

Thanks for your help

Wookie

[graham.edmon]

you would need a database or flat file system to store members pages and the other relevant information, your main site (or the pages that you want dynamic content on) would need to be re-written in a dynamic server side language such as PHP, Perl or ASP.

[Wookie76]

you would need a database or flat file system to store members pages and the other relevant information, your main site (or the pages that you want dynamic content on) would need to be re-written in a dynamic server side language such as PHP, Perl or ASP.

The site ia a PHP Nuke site with a mysql backend... Heres the site and heres the medals page

http://www.1st-ib.net/index.php
http://www.1st-ib.net/modules.php?na...ap&page=medals
and heres the medals page for me http://www.1st-ib.net/medals/1st-ib/Wookie_medals.htm at the moment we have a manual vote on who gets medals and such when we agree I edit the members page.... but I'd like a way to automate it. But I have limited PHP knowledge... so I'm looking for a method and maybe some functions to automate this...any help would be greatly appreciated.

[Wookie76]

Is there anbody who can help with any element of this please?? Or even have any suggetions?

[webslinger2k]

what clan are you from wookie?

[Wookie76]

what clan are you from wookie?

I'm in -<{1ST-IB}>- http://www.1st-ib.net/ We're a Call Of Duty Clan.

I've just noticed your involved with http://www.lanrg.co.uk/ I'm involved with http://www.irishlans.com/ we recently helped promote one of there lans... I was supposed to attend but couldn't due to work.

[empo]

hope these help m8

Part 1

h**p://www.devarticles.com/c/a/MySQL/Creating-a-Voting-Poll-With-PHP-And-MySQL-Part-1/

Part 2

h**p://www.devarticles.com/c/a/MySQL/Creating-a-Voting-Poll-With-PHP-And-MySQL-Part-2/

[Wookie76]

hope these help m8

Part 1

h**p://www.devarticles.com/c/a/MySQL/Creating-a-Voting-Poll-With-PHP-And-MySQL-Part-1/

Part 2

h**p://www.devarticles.com/c/a/MySQL/Creating-a-Voting-Poll-With-PHP-And-MySQL-Part-2/

Thanks Man...I not even to pushed on a voting system.... The big thing is an admin page for the medals... So we can display medals for each user ie An Admin with go to the admin users page and select the clanmember...that page would have a list of medals and a check box a radio button to disply the medal.... I have the pages done... just need a way of turning on and off the images.... the voting can come later.

[Pulse]

I'm not exactly sure if this is what you need but from what I understand this is what you should do:

For the admin page you would have to have all of the user names come from a database then in a pull down menu or something when you select one you would have radio buttons with all of the medal images or names.

In the table with all of your username information have a field "medals" .

Each medal shoudl be assigned a different name or number.

The "medals" field should start at 0 or something like that.

When the radio button is chosen and the page is submited (using forums) the field "medals" changes to the corresponding number/name.

The display page will have an if statement with an array, if "medals" is 0 then don't display anything but if it's "bronze" (just an example) then go to the corresponding array and display the right medal.

Like I said I'm not sure if this is what you were talking about. If you have anymore questions you can pm me. Also if you need code help (PHP or MySQL) let me know.

[Wookie76]

Cheers m8 thats exactly it....but the thing is I've no PHP or MySQL experience...could you post info on creating the table and table settings.. and maybe some PHP code samples...heres a sample of the html for a medal.

<!-- <P><SPAN style="LEFT: 289px; POSITION: absolute; TOP: 287px"><A 
title="Awarded for skilled use of Assault Weapons" 
href="http://www.1st-ib.net/medals/1st-ib/1stib_all_medals.htm"><IMG height=91 
src="1stib_medals_files/assualt.jpg" width=65 border=0></A></SPAN></P> --> 

I'm not sure how I display the image based on a 1 or 0 from the database etc

[Pulse]

if what you should do is download and install phpmyadmin (free) this will interface with you mysql database and make it really easy to add and edit table and such. It's all windows based.
Well your asking for a lot of stuff, I though you had some coding experience. This stuff is really pretty basic. You can look up most of the code online. I'm sorry I really don't have time NOW to go into all of it.

But here is what you do..

You make the table with any information you need/want about each person.
Make a index field that is (auto_incremented) so you have a different and unique number for every one.

For admin page.
using mysql retreive all of the user (and all info) by number from the user table
also make a table of all the medals
have two pull down menus
1st one displays all the users
2nd one displays all of the medals
this goes all in one forum
on submit that users "medal" field changes to what ever value the medals pull down menu had (I would also add "no medal" in the medals table)


The display would retreive all of the medals from the medals table and store them in an array
then retreive just the number of the "medal" field from that user and compare it to the array and then you know what medal the person has.

I do this for a living and I'm sorry I don't have time to post the actual code, also if I do all of the work for you then you wont learn. If I get time at work on monday I'll just copy and paste some stuff in here to help you out.

[Wookie76]

Cheers m8...