Author Topic: Can't get the Highscore info [FIXED]  (Read 7298 times)

0 Members and 1 Guest are viewing this topic.

Offline [LSR]Cypher

  • Manager
  • Posts: 350
  • Right behind you
    • View Profile
Can't get the Highscore info [FIXED]
« 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?
« Last Edit: July 14, 2010, 12:33:37 pm by mooman »

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #1 on: April 19, 2010, 09:47:26 pm »
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
will read and answer your forum PMs when I'm less busy!

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #2 on: April 27, 2010, 10:53:56 pm »
i really dont mean to sound rude or anything, but is the highscore page gonna be fixed by 2012?

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #3 on: April 27, 2010, 10:59:52 pm »
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
will read and answer your forum PMs when I'm less busy!

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #4 on: April 27, 2010, 11:01:46 pm »
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 :-[

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #5 on: April 27, 2010, 11:03:48 pm »
i don't like reminding anyone about anything.. probably why this is taking so long hah
will read and answer your forum PMs when I'm less busy!

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #6 on: April 27, 2010, 11:10:10 pm »
yeah haha

Offline pod

  • Scripter
  • Posts: 417
    • View Profile
  • In-game name: pod
Re: Can't get the Highscore info
« Reply #7 on: April 28, 2010, 06:52:08 pm »
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

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #8 on: April 28, 2010, 08:02:01 pm »
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).
will read and answer your forum PMs when I'm less busy!

Offline pod

  • Scripter
  • Posts: 417
    • View Profile
  • In-game name: pod
Re: Can't get the Highscore info
« Reply #9 on: April 28, 2010, 08:42:53 pm »
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

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #10 on: April 28, 2010, 08:58:53 pm »
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
will read and answer your forum PMs when I'm less busy!

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #11 on: April 28, 2010, 09:01:40 pm »
* [UK]mooman doesn't even know what a trigger is  :-[


Offline pod

  • Scripter
  • Posts: 417
    • View Profile
  • In-game name: pod
Re: Can't get the Highscore info
« Reply #12 on: April 28, 2010, 09:25:40 pm »
Code: [Select]
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

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #13 on: April 28, 2010, 09:27:33 pm »
nice work :D
will read and answer your forum PMs when I'm less busy!

Offline [FSR]Ush

  • Admin
  • Posts: 13,449
  • Aart
    • View Profile
Re: Can't get the Highscore info
« Reply #14 on: April 29, 2010, 03:13:48 pm »
goo moo

Offline [MAF]mooman

  • Leader
  • Posts: 6,299
    • View Profile
Re: Can't get the Highscore info
« Reply #15 on: April 29, 2010, 09:20:29 pm »
highscores are fixed at last. player stats will be fixed very soon! )
will read and answer your forum PMs when I'm less busy!

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #16 on: April 29, 2010, 09:41:19 pm »
yayyyyyyyy ty!  :-*

Offline [MAF]Rac3r

  • Leader
  • Posts: 2,807
  • Well, this is embarrassing.
    • View Profile
Re: Can't get the Highscore info
« Reply #17 on: May 01, 2010, 08:17:43 am »
 ;D

I hope that god exists, I hope, I pray (8)

Offline [FSR]Ush

  • Admin
  • Posts: 13,449
  • Aart
    • View Profile
Re: Can't get the Highscore info
« Reply #18 on: May 01, 2010, 11:21:14 am »
;D

I hope that god exists, I hope, I pray (8)

haha loool. I read pod instead of god.

Offline [MAF]Rac3r

  • Leader
  • Posts: 2,807
  • Well, this is embarrassing.
    • View Profile
Re: Can't get the Highscore info
« Reply #19 on: May 01, 2010, 12:06:12 pm »
Haha, easy mistake to make ;)

Offline [MAF]Snoopy

  • Posts: 14,540
    • View Profile
Re: Can't get the Highscore info
« Reply #20 on: May 01, 2010, 12:08:13 pm »
especially if ur stoned and pissed from the night before huh ush? :P

Offline [FSR]Ush

  • Admin
  • Posts: 13,449
  • Aart
    • View Profile
Re: Can't get the Highscore info
« Reply #21 on: May 01, 2010, 01:10:24 pm »
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