AdrenalineX Forums
General => AdrenalineX Development => Bug Reports => Topic started by: [LSR]Cypher on April 19, 2010, 09:46:04 pm
-
When i goto the http://highscores.adrenalinex.co.uk/stats/Cypher
I see this:
ERROR
Cypher's statistics could not be retrieved for one of the following reasons:
+They have not registered an account on the server.
+Their account on the server was deleted/renamed.
Yes i was renamed 3 times but how to see my highscores now?
-
the player stats haven't been updated for a week now since i have to recode the update script due to our new account system
-
i really dont mean to sound rude or anything, but is the highscore page gonna be fixed by 2012?
-
i can't fix it unless someone makes a change to the gamemode. i could make it so it updates every hour like before, but with a few changes by r or pod, it could be 5 minutes again and i've decided i'm not going to waste my time fixing it once just to have to fix it again when the changes are made.
http://forum.adrenalinex.co.uk/index.php/topic,23.msg43558.html#msg43558
so, for once, i'm not being lazy :P
-
kk cool, err i cant see r doing it anytime soon, unless we wait 5 years lol
soooo pod? hmmm pod scares me... i dont like to remind him about stuff :(
i always think hes gonna shout at me lol :-[
-
i don't like reminding anyone about anything.. probably why this is taking so long hah
-
yeah haha (http://imgur.com/ZXNNZ.jpg)
-
can i have score in the online player table please. i also need a new table for the records that tells me when a track's records were last modfied (by either a new record or cheatdelete). the same thing for tt records would be good too i guess.
done
score isn't updated after the player joins yet
races table has lastupdate for records updates, lasttime for the last time it was raced, and times for # of times it has been raced
-
thanks :) btw, i don't know whether or not you implemented the change records when renaming thing i suggested, but i just realised that it'd need to update the lastupdate too (if it doesn't already).
-
i did implement that and it doesn't change lastupdate :(
makes it a little more complicated, right now it's just a blanket update statement, i'll try to make a trigger to handle it maybe
-
oops didn't think of that :(/me 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
-
/me doesn't even know what a trigger is :-[
(http://imgur.com/asfRc.jpg)
-
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 ;
Added to mysql, seems to work nicely
-
nice work :D
-
goo moo
-
highscores are fixed at last. player stats will be fixed very soon! )
-
yayyyyyyyy ty! :-*
-
;D
I hope that god exists, I hope, I pray (8)
-
;D
I hope that god exists, I hope, I pray (8)
haha loool. I read pod instead of god.
-
Haha, easy mistake to make ;)
-
especially if ur stoned and pissed from the night before huh ush? :P
-
Hahhah yeah, I've been drunk queensnight(from 29 on 30 april) and when I woke up at queensday(30 april) I started drinking again. Yesterday I haven't drunk anything else as beer, and some water when I woke up with a hangover.. :P