NukeCoder

Posted: Wed Jan 18, 2006 1:45 am

HI,

My Main category is showing a zero when there is a sub category with 11 maps in it.

here is main http://www.cybersquads.com/modules.php?name=Maps

here is sub http://www.cybersquads.com/modules.php?name=Maps&cat=Black_Hawk_Down&id=1

Could you please point me in theright direction to fix this.

Site Admin Joined: Oct 25, 2004 Posts: 921

GuNS-365th wrote:

HI,

My Main category is showing a zero when there is a sub category with 11 maps in it.

here is main http://www.cybersquads.com/modules.php?name=Maps

here is sub http://www.cybersquads.com/modules.php?name=Maps&cat=Black_Hawk_Down&id=1

Could you please point me in theright direction to fix this.

OK give this a shot, (I haven't tested it)

open modules/Maps/index.php

around line 65 find..

Code:

$mapsincat = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_mapmap where cat='$catid'"));

And change it to

Code:

$mapsincat = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_mapmap where cat='$catid' OR cat='$main_id'"));

Let me know if it works

Posted: Wed Jan 18, 2006 10:20 am

hi there thanks for the reply. unfortunately that did not work. i will look back later to see if you have had time to look at it again.

Posted: Tue Jan 24, 2006 2:01 am

just checking back on this.