Gens Rank Problem

[Maddox]

Hello im using Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

but i have problem in Gens Rank anyone can help?
im using zTeam File :)



thanks

4FUNer

[MentaL]

[2009x2014]

Yea there is 1 typo in query, since its very old & made for TT.

Find

$topgensdata = $core_db->Execute("Select top ".$corecr['TopGensTop']." Name, ".$corecr['GensContributionColumn'].",".$corecr['GensFamilly'].",AccountID from ".$corecr['GensTable']." where CtlCode ".$corecr['ShowGM']." order by ".$corecr['TopGensOrderBy']." desc");

and replace with

$topgensdata = $core_db->Execute("Select top ".$corecr['TopGensTop']." memb_char, ".$corecr['GensContributionColumn'].",".$corecr['GensFamilly']." from ".$corecr['GensTable']." order by ".$corecr['TopGensOrderBy']." desc");

[Maddox]

Yea there is 1 typo in query, since its very old & made for TT.

Find

$topgensdata = $core_db->Execute("Select top ".$corecr['TopGensTop']." Name, ".$corecr['GensContributionColumn'].",".$corecr['GensFamilly'].",AccountID from ".$corecr['GensTable']." where CtlCode ".$corecr['ShowGM']." order by ".$corecr['TopGensOrderBy']." desc");

and replace with

$topgensdata = $core_db->Execute("Select top ".$corecr['TopGensTop']." memb_char, ".$corecr['GensContributionColumn'].",".$corecr['GensFamilly']." from ".$corecr['GensTable']." order by ".$corecr['TopGensOrderBy']." desc");

wow nice it works, Thanks a lot for helping as always, God Bless :)