Hi i need some help from some one who has some pretty good knowledge in mysql, php based websites. Me and my sqd from il2 want to implement a kill tally on our site where we can all go in and put in our kills. I was thinking that this could be done at any time if two or more of us were to fly together on any server and get kills, whether planes or ground kills.

I was thinking that the only kills that were to be counted would be ones that were confirmed by your flying partner or partners. The names of that or those persons could be added next to the kills as a confirmation.

 

so basicaly when two or more people fly together they can go to the site and enter how many kills that got and it would update it self and keep a running tally eg:

 

Me and Pierre fly and i shoot down two bf109 g6 an he shoots down 1 FW190 and once were finished i log into the site and go to the kill tally section, enter my password then choose from a drop down box the type of plane and then the number of kills, press enter and bobs your uncle it updates my kill tally!

 

Now how would i do this?

a two dimentional array should be what you want. basically have all your planes across the top, and your peeps down the side, and in the middle have a number under each plane.

What you will want to do though is to have a temporary variable set up and an Old and Variable too when you are inputting.

Put your old number from the table into old, and your temp variable will house your new number plus you old number.

 

But if you wanted to get fully complicated you could have two tables with a relational tie where one hold the planes, and the other the dates players and numbers...Oy Veh!

simplest way would be to have one table in mysql

 

name

plane 1

plane 2

etc etc

then in PHP create the link tothe database and have it just look up the value for said plan and then add the input field. and save. Probably easier to have an input field for each type of plane - can then have pretty pictures of each - like on the side of a plane as kills.

 

Of course if you want to add more information in to the mix like indivuals passwords, flight time, plane flying in at the time of kill, person flying with then its all possible. Just need to create tables that have a unique identifier ie

name (unique key)

p/w

flight time

mouse size

etc etc

 

Second table

ie

 

plane name (unique id)

Plane type

Plane flown by bot / real person

etc etc

 

then have a link table

 

Kill ratio

name_id

planename_id

 

Then comes the php.