Error when tracker updates

[Ward]

Code: Select all

CACHE: Cache couldn't find it. Sucks for you.
STAT:Overall 4984 2228 196778429
STAT:Attack 107737 94 8603724
STAT:Defence 78780 94 8600869
STAT:Strength 153178 94 8606556
STAT:Hitpoints 98486 96 10380636
STAT:Ranged 78365 93 7600969
STAT:Prayer 27048 88 4465596
STAT:Magic 10363 99 15316277
STAT:Cooking 105229 96 10496084
STAT:Woodcutting 56169 99 13036528
STAT:Fletching 37279 99 13189132
STAT:Fishing 34597 94 8347187
STAT:Firemaking 10645 99 13369045
STAT:Crafting 7542 99 13041786
STAT:Smithing 12631 90 5352179
STAT:Mining 10841 92 6580293
STAT:Herblore 16251 86 3768911
STAT:Agility 8638 90 5356028
STAT:Thieving 17675 89 5182527
STAT:Slayer 37741 87 4232191
STAT:Farming 3904 99 13535871
STAT:Runecraft 7626 91 5971795
STAT:Hunter 27882 86 3651850
STAT:Construction 7454 86 3643462
STAT:Summoning 18475 88 4448933
STAT:BA-Attacker 10111 1945
STAT:BA-Defender 6640 1939
STAT:BA-Collector 6393 1936
STAT:BA-Healer 22572 1947
Q2: 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 ' 24, 0, "semeur", 40002, "1265401161")' at line 1


@ http://runetracker.org/updateUserJS.php

Though sometimes it seems to not give that error and just say "NOCHANGE" (despite xp having changed). Might just be something temporary but thought I'd mention it

[micksam7]

Fixed now. It still updated the data, just crapped out when updating the rank of skill 24 due to a earlier change.. described below.

[tech babble:]
To make code updates easier, we use a single function to handle stat fetching, which also is used in lookup.php [it fetches stats, prints it out for bot use, then updates the tracker in one go], just output is suppressed when using elsewhere. But, when it encounters a error, it prints out whatever the buffer is and exits, hence the usual lookup.php bit showing up...

I implemented saving user's ranks between record/ranking updates last night, loading previous ranks into a array at once, defaulting to NULL when it doesn't know the previous rank [we only update ranks in runetracker every 5 minutes because it requires a DB sort each update otherwise], and forgot to fill that array up to 24.. that's fixed now and for future skills [fills to every skill column we have in the database now..]