MU Core 1.0.8 Rankings Problem
http://img545.imageshack.us/img545/9486/pq88.png
Pretty self explanatory.. the problem is that altho the server has 6 characters or more it only shows a couple of them in the rankings in this case 1 if you look at the top 5 thing bellow the info panel at the right it shows 2 but still not all 6..
Re: MU Core 1.0.8 Rankings Problem
Maybe u have disabled ranking for game masters ?
also you have enabled cache on ranking, so result aren't live (to be 100 % sure, delete cron job for rankings via admincp and check)
if other issues, debug would be helpful, maybe 97d doesnt support somth.
Re: MU Core 1.0.8 Rankings Problem
test is a GM hero and shows in top5 rest are normal heroes
Deleted cron jobs for rankings - no difference
here is debug of rankings all players
(mssql): Select next_cron from MUCore_Cron_Jobs where cron_id=? [ (0=>'1') ] sp_executesql N'Select next_cron from MUCore_Cron_Jobs where cron_id=@P0',N'@P0 NVARCHAR(1)',@P0=N'1'
(mssql): Update MUCore_Cron_Jobs set next_cron=(1385223768+cron_time_set) where cron_id=? [ (0=>'1') ] sp_executesql N'Update MUCore_Cron_Jobs set next_cron=(1385223768+cron_time_set) where cron_id=@P0',N'@P0 NVARCHAR(1)',@P0=N'1'
(mssql): Select top 100 mu_id,name,class,clevel,resets,strength,dexterity,vitality,energy,ctlcode,accountid,leadership,pklevel,grand_resets from character order by grand_resets desc, resets desc, clevel desc
Re: MU Core 1.0.8 Rankings Problem
ok i think i know wtf :P
try add 1 rr to 1 of these 5 missing characters
and when cron-job for characters is deleted, check again :P
Re: MU Core 1.0.8 Rankings Problem
When i changed the level of the missing hereos the apeared on ranking, to test out if it's fully working now i made a new hero and upped 20 levels on him but he didn't apear, then i edited him to have 48 levels and he apeared...
Why only edited characters apear lol :D
Re: MU Core 1.0.8 Rankings Problem
Quote:
Originally Posted by
LasTCursE
When i changed the level of the missing hereos the apeared on ranking, to test out if it's fully working now i made a new hero and upped 20 levels on him but he didn't apear, then i edited him to have 48 levels and he apeared...
Why only edited characters apear lol :D
i think because default value of Resets GR is NULL
ranking is order by these, so if they have NULL means emtpy they wont appear :P
Have fun ;)
Re: MU Core 1.0.8 Rankings Problem
I don't have grand resets or at least i don't want them :D i deleted in rankings everywhere it says leadership or grand resets and still the same :(
Re: MU Core 1.0.8 Rankings Problem
Quote:
Originally Posted by
LasTCursE
I don't have grand resets or at least i don't want them :D i deleted in rankings everywhere it says leadership or grand resets and still the same :(
Weird, i check again and see Resets, GR got default 0 so its not NULL ...
I created new char 1 lvl and appear fine...
There is no req specified... no error on debug somth must be wrong with ur 97d
anw try change for test
order by grand_resets desc, resets desc, clevel desc
to
order by cLevel desc
and check what happens, like i said Cron Job must deleted, bcz when it's enabled ranking isn't live !
Re: MU Core 1.0.8 Rankings Problem
I thought about what you said regarding the null's and i've figured out what's the problem!! (YEY)
I've looked where a character that shows on the rankings dosen't have a null compared to one that's hidden and found out that CtlCode did allow to have nulls and there lied the whole problem when i changed it to 0 they showed up
so i modified the Character table' s ctlcode to not allow null's and to have default value of "0" and made a new character to test it and he showed up :P
Thanks again 4funer :)
Now pk level shows as Unknown tho and Status as N/a ..
Re: MU Core 1.0.8 Rankings Problem
Oh you see ;) cool
Status as n/a it's cracked release bug, get.php must be modified as well, but when u configure correct url on AdminCP it will be lets say half working.
about pklevel, maybe as well somth wrong in db or diff codes, since when it can't retrieve data from array it return "Unknown"