help please!!!

SeanPreston · 10-20-2006, 08: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, 11:03 AM

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, 12: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, 08:12 AM	#1 (permalink)
SeanPreston Senior Member Join Date: Nov 2005 Location: Staffordshire, UK Posts: 1,054 50.00 NP$ (Donate)	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 __________________ Google - an idiots best friend, Search before you ask! AjaxDen - Free Ajax Scripts!

10-21-2006, 12:34 PM	#3 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	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 \| Uzbl (my branch) 9thSeptember2009.com

10-21-2006, 11:03 AM	#2 (permalink)
JulyWeb New Member Join Date: Apr 2006 Posts: 2 5.00 NP$ (Donate)	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)