Monthly reset for data

[tango88]

Hi and I hope someone could help me here.

I have some flash games where the high scores are saved in a mySQL database via php. I was so happy when I finally got it to work.

Thing is, I'd like to reset it at the beginning of each month and I'm trying to figure out a way to do that.

My FTP program has a scheduler, but of course, my PC has to be on for it to work.

I thought of pulling a trick using the my_date.getUTCMonth(); script, but it reads the date from the user's machine, which may be totally wrong.

Or is there some kind of scheduler built into mySQL? I'm a real beginner when it comes to databasing! Anyone there that can help me?

[Cota]

Find out of your web host supports cron jobs. If so, set up a script to reset everything and have the cron job trigger the script once a month.

[tango88]

Thanks, Cota

Have to admit that I have no idea what a 'cron job' is, but it shouldn't take me long to find out.

Best wishes to you

[tango88]

got it.

I'm running of a cheap webhosting server, but there's a workaround here:

http://www.bitfolge.de/pseudocron-en.html

This little app simulates a cron job using php by simply checking if anything is scheduled whenever a user visits the page.

This is what I had in mind originally, but I was stuck where flash reads the date from the USER's machine, which could be wrong.

[Cota]

Glad you got it sorted.

[jsebrech]

Yeah, the best way to go is probably checking whenever someone tries to read or save the highscores whether a month has passed, and clearing the highscores if it is the case. You should read the date on the PHP side instead of on the flash side. It's more reliable that way.