Update every minute

gunmetal

Hi every one.

I start make my site, but there is one problem.
I need code who every minute give each user +points
"UPDATE members SET point=point+1";

I think that it is "CREATE EVENT pointer ON SCHEDULE EVERY 1 MINUTE DO UPDATE members SET point=point+1;"

but it isn't work for me!

Pleas help me

Sory about my english I am from latvia, but i realy need this code

dagon

if every user is having one point added, you can just add 1 point per minute from the start date\time when ever you need to reference any users points.

points_out = points +(TIME_TO_SEC(TIMEDIFF(NOW(), START_DATE)\60)

gunmetal

but i need add evry minute points when user is online and when isn't online. ;(

bradgrafelman

gunmetal;10966566 wrote:
but i need add evry minute points when user is online and when isn't online. ;(

If you absolutely must keep the points updated even when the user isn't on the site, then it does indeed sound like the MySQL event scheduler might be the best option.

Going back to your original post...

gunmetal;10966541 wrote:
it isn't work for me!

What does that mean? What's the MySQL error message? (You are using MySQL, yes?)

gunmetal

mysql_query("CREATE EVENT pointer ON SCHEDULE EVERY 1 MINUTE DO UPDATE members SET point=point+1");

but how can i know that it works?
+points it don't give

bradgrafelman

gunmetal wrote:
but how can i know that it works?

The same way you should be checking that all other MySQL queries work; ensure that [man]mysql_query/man doesn't return boolean FALSE and, if it does, log (or display) the [man]mysql_error/man error message.

EDIT: You could also manually verify that the event was created by using the SHOW EVENTS command.

gunmetal

i have error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT pointes ON SCHEDULE EVERY 1 MINUTE DO UPDATE members SET k

gunmetal

whot i need to do?

bradgrafelman

Sounds like your MySQL server doesn't support the CREATE EVENT command; which version are you using?

gunmetal

MySQL Database Version 5.0.24a

bradgrafelman

gunmetal;10966586 wrote:
MySQL Database Version 5.0.24a

Ah, well that's your problem - you're using an old version of MySQL. As per the manual page for events:

MySQL Manual wrote:
Event support was added in MySQL 5.1.6.

gunmetal

well i hope it works!

gunmetal

db	name	body	definer	execute_at	interval_value	interval_field	created	modified	last_executed	starts	ends	status	on_completion	sql_mode	comment	originator	time_zone	character_set_client	collation_connection	db_collation	body_utf8
			king	pointes	[BLOB - 33 baiti]	root@localhost	NULL	1	MINUTE	2010-10-25 16:57:11	2010-10-25 16:57:11	NULL	2010-10-25 13:57:11	NULL	ENABLED	DROP	NO_AUTO_CREATE_USER	 	0	SYSTEM	utf8	utf8_general_ci	utf8_general_ci	[BLOB - 33 baiti]

It works I make event, but +points don't go to users ;(

mysql_query("CREATE EVENT pointes ON SCHEDULE EVERY 1 MINUTE DO UPDATE members SET koks = koks +1;") or die(mysql_error());

gunmetal

I don't know where is the problem ;(
pleas help me

Bonesnap

You could always try a cron job or a Scheduled Task if on a Windows box. I currently have a PHP script that runs once every 8 hours that updates a bunch of tables for me.

Is your site hosted at home or do you have actual web space?

gunmetal

now i hosted at home, but have idea to buy web hosting!
But why event doesn't work? 🙁

gunmetal

Ou and about cron job I don't know eny code who make UPDATE
I watch some video about cron job, but there are strange codes like this

MAILTO=user@domain.com 
0 0 1,15 * 1 /big/dom/xdomain/cgi-bin/scriptname.cgi

But how make UPDATES? 😃

gunmetal

pleas some one help.
I need this code!
😕