proudnerd

I have a question about making a virtual pet site (you probably don't need any virtual pet site-making experience to answer it, though). My question is would I make the amount of spending points the user has part of a MySQL database and update it everytime they earn more, buy something, etc. or would I do it a different way? Thank you for taking the time to read my newbish question.

RAzR Creations

i would actually set up a timer to update every time or just to update everyone every second if thats what you are talking about but i dont clearly understand tottally what you are talking about tho

Booooze

Everytime the user log on, record the time into the Mysql DB. Then, everytime the session refreshes, record the time, and compare it to the record you have. Calaculate the difference and assign the correct number of points or money or w/e. That is how it's done most of the time.

@Razr - Good idea, but it won't work with PHP and MySQL. It would only work with application programming

proudnerd

I never thought of doing that, Booooze. How would I do it, though? I just started programming in PHP yesterday so I have no clue.

Booooze

That's fine, not to worry. Unfortuantley, I have the code at home, but try and get a start on it for now and I'll be happy to help you out with problems later on tonight (Im at work right now, posting on and off, but dont have php).

For a start, figure out how to display the time in PHP. I'd start by simply writing to a text file. Once you have that, get the ability to read it as well, and display it on the page. At the same time, write the current time. At this point you should have 2 times. Then try and compare the too. Unfortunatley I can't remember how to do it, so simply google it, and see what you can come up with. Onc eyou have taht, look up a cookies and sessions tutorial. Then post back. gtg

Booooze

Good Links:

http://www.highlystructured.com/comp...dates_php.html

http://ca.php.net/date

Bookmark php.net, if you havent already php.net has the whole manual to php if you didn't know that. Have fun

proudnerd

Thanks for the links Booooze.