Help please!!!

[SeanPreston]

Hi, im the owner of globalconflict.info. Its basically an online rpg game. Each member gets 500 attack points(1-10 are used for every time they attack another player). They are asposed to update every 24 hours but they dont. I am willing to go online every day and update the "attack points" table in phpmyadmin. Instead of going through every member and editing that feild, is there a way that i can reset them all to 500 realy quickly?
thanks
sean

 

[JulyWeb]

Hey there,

You will just have to run a SQL query, but can't say more unless you give more details on the database structure ...

 

[Barrucadu]

Just use this sql:

update [name of your users table] set [name of attacks field] = 500

You could put it into a script and set up a cron to run it every 24 hours.