help please!!!

SeanPreston · 10-20-2006, 09:12 AM

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 · 10-21-2006, 12:03 PM

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 · 10-21-2006, 01:34 PM

Just use this sql:

Code:

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.

10-20-2006, 09:12 AM	THREAD STARTER #1 (permalink)
SeanPreston Senior Member Join Date: Nov 2005 Location: UK Posts: 1,278	help please!!! 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

10-21-2006, 01:34 PM	#3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Just use this sql: Code: 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. __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-21-2006, 12:03 PM	#2 (permalink)
JulyWeb New Member Join Date: Apr 2006 Posts: 2	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 ...

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)