days old sql query?

[spazz]

well, I messed up the days old in my game. Testing some stuff and manually running the daily cron. didn't realize the results :? learn by mistakes I guess. Now my days old doesn't correspond with the signed update. Is there a query that I can run on the db to fix this or am I doomed to change each one manually.

Thanks

[spazz]

Re: days old sql query?

hmmmm....set everyone to 1 day old.... :-D

[spazz]

Re: days old sql query?

it looks like a $ was missing on the following line:

$amount = amount - 86400;

I will have to verify that it was the correct amount of days now.

Thank you lostone

I am almost scared to run this on my live site..... :-o

LostOne...thankyou very much that did the trick.