PDA

View Full Version : No query if on refresh?

Koutaru
07-05-2004, 10:45 PM
What I'm basically trying to do is add $$ to the user's account for every page he/she surfs. HOWEVER. The query will NOT add if the person keeps refreshing or hits back or forward

:ermm: is this possible with PHP and queries? :(
Zachery
07-05-2004, 11:10 PM
What I'm basically trying to do is add $$ to the user's account for every page he/she surfs. HOWEVER. The query will NOT add if the person keeps refreshing or hits back or forward

:ermm: is this possible with PHP and queries? :(
This could add to an insane ammount of querys on your site.

You may wish to give them money instead for, referals, or even thread views.
Koutaru
07-05-2004, 11:24 PM
This could add to an insane ammount of querys on your site.

You may wish to give them money instead for, referals, or even thread views.
Yes I know :( sadly

Well, it would only add one query, an update query to each page which I think would be semi-worth it.. kinda

:/ I'm still considering, but where would I start?
Zachery
07-05-2004, 11:42 PM
Yes I know :( sadly

Well, it would only add one query, an update query to each page which I think would be semi-worth it.. kinda

:/ I'm still considering, but where would I start?
You would be updating the users table, almost every pageview, which will lock the whole table.

if your forum gets busy, this could litterly bring a server to its knees
Koutaru
07-06-2004, 12:12 AM
You would be updating the users table, almost every pageview, which will lock the whole table.

if your forum gets busy, this could litterly bring a server to its knees
Yes, but :p I'm trying to copy off of GaiaOnline.. I wonder how they managed it. Strange

If it's not smart, I definately wont try it
Thanks Zach :)
Zachery
07-06-2004, 12:18 AM
Yes, but :p I'm trying to copy off of GaiaOnline.. I wonder how they managed it. Strange

If it's not smart, I definately wont try it
Thanks Zach :)
Are you sure Gaia actualy does it every pageview?

They do have 40~ some odd servers to run their site
Koutaru
07-06-2004, 12:39 AM
Are you sure Gaia actualy does it every pageview?

They do have 40~ some odd servers to run their site
I guess I'll hold off on it for now ;) Even though that would be a neat feature..
:D I can wait