Gens Rank Problem

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 :)

http://i62.tinypic.com/2jdjkoj.png

thanks

4FUNer

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

Find

Code:

---

$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

Code:

---

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

---

Quote:

---

Originally Posted by 4FUNer

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

Find

Code:

---

$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

Code:

---

$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 :)