General > Bug Reports

Can't get the Highscore info [FIXED]

<< < (3/5) > >>

[MAF]mooman:
oops didn't think of that :(* [UK]mooman doesn't even know what a trigger is  :-[i would've just searched the recs db for the new player name and then updated all the lastupdates for the highscores it finds, bet your way is faster though  :P

[MAF]Snoopy:

--- Quote from: [UK]mooman on April 28, 2010, 08:58:53 pm ---* [UK]mooman doesn't even know what a trigger is  :-[
--- End quote ---

pod:

--- Code: ---DELIMITER //
CREATE TRIGGER on_records_update
AFTER UPDATE ON records
FOR EACH ROW
BEGIN
INSERT INTO races VALUES (NEW.race, 0, UNIX_TIMESTAMP(), 0)
ON DUPLICATE KEY UPDATE lastupdate = UNIX_TIMESTAMP();
END//
DELIMITER ;

--- End code ---

Added to mysql, seems to work nicely

[MAF]mooman:
nice work :D

[FSR]Ush:
goo moo

Navigation

[0] Message Index

[#] Next page

[*] Previous page