[PizzaPuntjes]

well,, as the titel says; how can i save kills per weaponid of a user the most efficient?

i have no idea so thats why i am coming here

[Scenario]

What exactly do you mean by weaponid? Do you mean the ID that signifies what weapon was used to kill a player?

[xVIP3Rx]

What database system are you using, SQL or Files ?

[Vince]

Table: userid - weaponid - killed, with userid and weaponid as the composite primary key.

Query to add kills:

PHP код:

INSERT INTO table (userid, weaponid, killed) VALUES (%d, %d, %d) ON DUPLICATE KEY UPDATE killed = killed + %d 


[PizzaPuntjes]

Thank you a lot,