reload a function after a while time

[alexcsandru]

I want to reload a function from 10 in 10 minutes ... (a mysql query function)...

Maybe work in event mysql , but i don't know event mysql ...

My function reload_rank() work's perfectly!

function reload_rank() {
global $dataabse;
$rank_update = $database->query("SET @rank=0");
$rank_update .= $database->query("UPDATE users SET rank=@rank:=@rank+1 ORDER BY points DESC");
}

I want to make another function reload_time() , to include reload_rank() after 10 in 10 minute , and so on!

I tried with event

CREATE EVENT Rank
ON SCHEDULE 
EVERY 30 SECOND
DO SET @rank=0;
UPDATE users SET rank=@rank:=@rank+1 ORDER BY points DESC;

but don't work , and I don't know why! (I am a biginner in mysql event) ...

My users table (work's to update rank table with function reload_rank() ) :

+----+-------------+----------+--------+--------------+--------+------+
| id | username    | password | banned | colonization | points | rank |
+----+-------------+----------+--------+--------------+--------+------+
|  1 | alexcsandru | ******   | N      |            1 |     10 |    1 |
|  2 | ovidiu      | ******   | N      |            1 |      2 |    3 |
|  3 | ropy        | ******   | N      |            1 |      1 |    4 |
|  4 | bobo        | ******   | N      |            1 |      7 |    2 |
+----+-------------+----------+--------+--------------+--------+------+

Reload players rank after points desc.

Thanks

[johanafm]

What is the purpose? I doubt the code will do what you are looking for, even if you change it so that it will work.
That aside, the problem with your create event is that you have missed some crucial points. The SQL statement following DO contains the statement delimiter, ;, which means that you create an event which will set @rank to 0 every thirty seconds, and right away after your event is created, the following statement is also executed, i.e. UPDATE users...

DELIMITER #
...
DO BEGIN
	SET ... ;
	UPDATE ... ;
END #
DELIMITER ;

[alexcsandru]

Sorry , I am a stupid , this is good?

CREATE EVENT Rank
ON SCHEDULE 
EVERY 30 SECOND
DO BEGIN
          SET @rank=0;
          UPDATE users SET rank=@rank:=@rank+1 ORDER BY points DESC;
END

Or , give me a example!

this is error! 😃 for code up!

SQL query:

CREATE EVENT Rank ON SCHEDULEEVERY30 SECOND DO BEGIN SET @rank =0;


MySQL said: 

#1064 - 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 '' at line 5 

MYSQL - Server version: 5.1.37 Source distribution

[johanafm]

Did you set the delimiter to something else before creating the event?

[alexcsandru]

No , just code :

CREATE EVENT Rank
ON SCHEDULE 
EVERY 30 SECOND
DO BEGIN
          SET @rank=0;
          UPDATE users SET rank=@rank:=@rank+1 ORDER BY points DESC;
END

Insert the code with phpmyadmin sql comand!

[johanafm]

So, set the delimiter then.

reposting...

johanafm wrote:

DELIMITER #
...
DO BEGIN
	SET ... ;
	UPDATE ... ;
END #
DELIMITER ;

And do use the reference manual: http://dev.mysql.com/doc/refman/5.1/en/create-event.html