I got a scheme for my users accounts and point system, using folders, and php, which generates there points, which is read and printed to there page, when ever they login or pass a mission...
ex:
- user logs in
- account page is generated and sent to there folder which is also generated at login, overwritting the one already there wether they exists or not...
- if the user completes a mission, their points are written to an html page which is also generated at login and included in their generated folder as well as their accounts page and the points page is then read and the value of the points page is then printed inside there accounts page.
thus a self updating account and points scheme... however, this is not a perfect world and nothing works like it should, the first, second or third time, so sometimes the user gets the folder with the two files inside, and sometimes they get nothing... this is not going to work obviously, so I would like to do this with SQL now, so can I throw there generated files, minus the folder, in a row??? and have them updated when they login and complete a mission???
How, would you go about doing this??
thanks
p.s. should make better sense now