Categories
Open Classifieds PHP

OC Mod: Ads only in child categories

Just a simple mod to allow publishing advertisement in child categories.

Edit the files:

/content/item-new.php
/content/item-manage.php

Search for:

$query="SELECT idCategory,name,(select name from ".TABLE_PREFIX."categories where idCategory=C.idCategoryParent) FROM ".TABLE_PREFIX."categories C order by idCategoryParent, `order`";

Replace in both files for:

$query="SELECT idCategory,name,(select name from ".TABLE_PREFIX."categories where idCategory=C.idCategoryParent)
	FROM ".TABLE_PREFIX."categories C where C.idCategoryParent!=0 order by idCategoryParent, `order`";