query("select * from category_details"); $mods = ""; while ($details->next_record()){ $mods[$details->f("cat_id")]["field"] = $details->f("field"); $mods[$details->f("cat_id")]["template"] = $details->f("template"); $mods[$details->f("cat_id")]["storefront"] = $details->f("storefront"); $mods[$details->f("cat_id")]["pricing"] = $details->f("pricing"); } $groups = ""; $details->query("select c.group_id, c.cat_id, g.title from groups_categories c, groups g where c.group_id = g.id"); while ($details->next_record()){ //print $details->f("cat_id"); if (isset($groups[$details->f("cat_id")])) $groups[$details->f("cat_id")] .= ", " . $details->f("title"); else $groups[$details->f("cat_id")] = $details->f("title"); } $cattable = " \n"; $cattable .= " \n"; $cattable .= " \n"; $cattable .= " \n"; $cattable .= " \n"; $catlist = new clsDBDBNetConnect(); $catlist->query("select * from categories where sub_cat_id=0"); while($catlist->next_record()) { $custom_template[0] = ""; $custom_field = ""; $custom_pricing = ""; $thisgroups = ""; $bgcolor = "#54B81A"; if ($_GET["cat"] == $catlist->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; $catlist2 = new clsDBDBNetConnect(); $catlist2->query("select * from categories where sub_cat_id=" . $catlist->f("cat_id")); while($catlist2->next_record()) { $custom_template[1] = ""; $bgcolor = "FFFFFF"; if ($_GET["cat"] == $catlist2->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; $catlist3 = new clsDBDBNetConnect(); $catlist3->query("select * from categories where sub_cat_id=" . $catlist2->f("cat_id")); while($catlist3->next_record()) { $custom_template[2] = ""; $bgcolor = "#CCCCCC"; if ($_GET["cat"] == $catlist3->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; $catlist4 = new clsDBDBNetConnect(); $catlist4->query("select * from categories where sub_cat_id=" . $catlist3->f("cat_id")); while($catlist4->next_record()) { $custom_template[3] = ""; $bgcolor = "#C0C0C0"; if ($_GET["cat"] == $catlist4->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; $catlist5 = new clsDBDBNetConnect(); $catlist5->query("select * from categories where sub_cat_id=" . $catlist4->f("cat_id")); while($catlist5->next_record()) { $custom_template[4] = ""; $bgcolor = "#999999"; if ($_GET["cat"] == $catlist5->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; $catlist6 = new clsDBDBNetConnect(); $catlist6->query("select * from categories where sub_cat_id=" . $catlist5->f("cat_id")); while($catlist6->next_record()) { $custom_template[4] = ""; $bgcolor = "#808080"; if ($_GET["cat"] == $catlist6->f("cat_id")) $bgcolor = "#FFFF66"; $cattable .= " \n "; } } } } } } $cattable .= "

Category Details	Group \n"; $cattable .= " Membership
"; $cattable .= "" . $catlist->f("name") . ""; if ($mods[$catlist->f("cat_id")]["storefront"] == 1){ $cattable .= " "; } if ($mods[$catlist->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[0] = 1; } else { $custom_template[0] = 0; } if ($mods[$catlist->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($mods[$catlist->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; if (isset($groups[$catlist->f("cat_id")])){ $cattable .= "" . $groups[$catlist->f("cat_id")] . ""; $thisgroups = "" . $groups[$catlist->f("cat_id")] . ""; } $cattable .= "
"; $cattable .= "--" . $catlist2->f("name") . ""; if ($custom_field) { $cattable .= " "; } if ($mods[$catlist2->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($custom_pricing) { $cattable .= " "; } if ($mods[$catlist2->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } if (($custom_template[0]) && $mods[$catlist2->f("cat_id")]["template"] != 1){ $cattable .= " "; } elseif ($mods[$catlist2->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[1] = 1; } else { $custom_template[1] = 0; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; $cattable .= $thisgroups; $cattable .= "
"; $cattable .= "------" . $catlist3->f("name") . ""; if ($custom_field) { $cattable .= " "; } if ($mods[$catlist3->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($custom_pricing) { $cattable .= " "; } if ($mods[$catlist3->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } if (($custom_template[0] || $custom_template[1]) && $mods[$catlist3->f("cat_id")]["template"] != 1){ $cattable .= " "; } elseif ($mods[$catlist3->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[2] = 1; } else { $custom_template[2] = 0; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; $cattable .= $thisgroups; $cattable .= "
"; $cattable .= "----------" . $catlist4->f("name") . ""; if ($custom_field) { $cattable .= " "; } if ($mods[$catlist4->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($custom_pricing) { $cattable .= " "; } if ($mods[$catlist4->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } if (($custom_template[0] || $custom_template[1] || $custom_template[2]) && $mods[$catlist4->f("cat_id")]["template"] != 1){ $cattable .= " "; } elseif ($mods[$catlist4->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[3] = 1; } else { $custom_template[3] = 0; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; $cattable .= $thisgroups; $cattable .= "
"; $cattable .= "--------------" . $catlist5->f("name") . ""; if ($custom_field) { $cattable .= " "; } if ($mods[$catlist5->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($custom_pricing) { $cattable .= " "; } if ($mods[$catlist5->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } if (($custom_template[0] || $custom_template[1] ||$custom_template[2] || $custom_template[3]) && $mods[$catlist5->f("cat_id")]["template"] != 1){ $cattable .= " "; } elseif ($mods[$catlist5->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[4] = 1; } else { $custom_template[4] = 0; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; $cattable .= $thisgroups; $cattable .= "
"; $cattable .= "------------------" . $catlist6->f("name") . ""; if ($custom_field) { $cattable .= " "; } if ($mods[$catlist6->f("cat_id")]["field"] == 1){ $cattable .= " "; $custom_field = 1; } if ($custom_pricing) { $cattable .= " "; } if ($mods[$catlist6->f("cat_id")]["pricing"] == 1){ $cattable .= " "; $custom_pricing = 1; } if (($custom_template[0] || $custom_template[1] ||$custom_template[2] || $custom_template[3]) && $mods[$catlist6->f("cat_id")]["template"] != 1){ $cattable .= " "; } elseif ($mods[$catlist6->f("cat_id")]["template"] == 1){ $cattable .= " "; $custom_template[4] = 1; } else { $custom_template[4] = 0; } $cattable .= " f("cat_id") . "\" border=\"0\">	"; $cattable .= $thisgroups; $cattable .= "

"; if ($_GET["cat"]){ $cattemplate = 0; $storefront = 0; $galtemplate = 0; $itemtemplate = 0; $textarea = 0; $textbox = 0; $dropdown = 0; $db = new clsDBNetConnect; $query = "select * from templates_cat where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $template = 1; $query = "select * from templates_items where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $itemtemplate = 1; $query = "select sub_cat_id from categories where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("sub_cat_id") == 1){ $storefront = "allowed"; $query = "select * from templates_storefront where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $storefront = "active"; } $query = "select * from templates_gal where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $galtemplate = 1; $query = "select * from templates_newitem where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $newitemtemplate = 1; $query = "select * from custom_textarea where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $textarea = 1; $query = "select * from custom_textbox where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $textbox = 1; $query = "select * from custom_dropdown where cat_id = $cat"; $db->query($query); $db->next_record(); if ($db->f("id")) $dropdown = 1; $query = "select * from custom_textarea where cat_id = $cat"; $db->query($query); $ta = ""; while ($db->next_record()){ $ta .= "f("id") . "\">   " . $db->f("name") . " ---Edit
"; } $query = "select * from custom_textbox where cat_id = $cat"; $db->query($query); $tb = ""; while ($db->next_record()){ $tb .= "f("id") . "\">   " . $db->f("name") . " ---Edit
"; } $query = "select * from custom_dropdown where cat_id = $cat"; $db->query($query); $dd = ""; $dropd = new clsDBNetConnect; while ($db->next_record()){ $query = "select * from custom_dropdown_options where field_id=" . $db->f("id"); $dd .= "f("id") . "\">   " . $db->f("name") . " ---Edit
"; $dropd->query($query); $dd .= "

"; while ($dropd->next_record()){ if ($dropd->f("default") == 1) $picked = " ---Default Option"; else $picked = ""; $dd .= "f("id") . "\">
• " . $dropd->f("option") . $picked . "
"; } $dd .= "

"; } $links = ""; if ($storefront){ if ($storefront == "allowed") $links .= "Create a \"StoreFront\" Template

\n"; if ($storefront == "active") $links .= "Edit this \"StoreFront\" Template

\n"; } if ($template == 1 && $storefront) $links .= "Edit this Category's \"ViewCat\" Template (A \"Storefront\" template will over-ride this on this category, but this template will still filter down to all the sub-categories)

\n"; if ($template == 0 && $storefront) $links .= "Create a \"ViewCat\" Template for this Category (A \"Storefront\" template will over-ride this on this category, but this template will still filter down to all the sub-categories)

\n"; if ($template == 1 && !$storefront) $links .= "Edit this Category's \"ViewCat\" Template

\n"; if ($template == 0 && !$storefront) $links .= "Create a \"ViewCat\" Template for this Category

\n"; if ($galtemplate == 1) $links .= "Edit this Category's Gallery Template

\n"; if ($galtemplate == 0) $links .= "Create a Gallery Template for this Category

\n"; if ($itemtemplate == 1) $links .= "Edit this Category's Item Page Template

\n"; if ($itemtemplate == 0) $links .= "Create an Item Page Template for this Category

\n"; if ($newitemtemplate == 1) $links .= "Edit this Category's NewItem (Listing Creation) Page Template
(This is not required to make your custom fields show up, they will by default automatically show up on the newitem page, this is just if you want to customize the way they are laid out on the newitem page)

\n"; if ($newitemtemplate == 0) $links .= "Create a NewItem (Listing Creation) Page Template for this Category
(This is not required to make your custom fields show up, they will by default automatically show up on the newitem page, this is just if you want to customize the way they are laid out on the newitem page)

\n"; $links .= "

---

"; $links .= "Custom Text Area Fields ---Add New

\n"; $links .= $ta; $links .= "

---

"; $links .= "Custom Text Box Fields ---Add New

\n"; $links .= $tb; $links .= "

---

"; $links .= "Custom DropDown Boxes ---Add New

\n"; $links .= $dd; $links .= "

---

"; $links .= "Custom Pricing Structures

\n"; $links .= "Edit this Category's Listing Features Prices

\n"; $links .= "Edit this Category's Listing Days Values

\n"; } //Include Page implementation @34-353B2997 include("./Footer.php"); //End Include Page implementation //Initialize Page @1-4491C9BD // Variables $FileName = ""; $Redirect = ""; $Tpl = ""; $TemplateFileName = ""; $BlockToParse = ""; $ComponentName = ""; // Events; $CCSEvents = ""; $CCSEventResult = ""; $FileName = "CatDetails.php"; $Redirect = ""; $TemplateFileName = "CatDetails.html"; $BlockToParse = "main"; $PathToRoot = "./"; //End Initialize Page //Authenticate User @1-FFD44987 CCSecurityRedirect("1", "", $FileName, CCGetQueryString("QueryString", "")); //End Authenticate User //Initialize Objects @1-9EBE738D $DBDBNetConnect = new clsDBDBNetConnect(); // Controls $Header = new clsHeader(); $Header->BindEvents(); $Header->TemplatePath = "./"; $Header->Initialize(); $Footer = new clsFooter(); $Footer->BindEvents(); $Footer->TemplatePath = "./"; $Footer->Initialize(); $CCSEventResult = CCGetEvent($CCSEvents, "AfterInitialize"); //End Initialize Objects //Execute Components @1-351F985C $Header->Operations(); $Footer->Operations(); //End Execute Components //Go to destination page @1-BEB91355 if($Redirect) { $CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload"); header("Location: " . $Redirect); exit; } //End Go to destination page //Initialize HTML Template @1-A0111C9D $CCSEventResult = CCGetEvent($CCSEvents, "OnInitializeView"); $Tpl = new clsTemplate(); $Tpl->LoadTemplate(TemplatePath . $TemplateFileName, "main"); $CCSEventResult = CCGetEvent($CCSEvents, "BeforeShow"); //End Initialize HTML Template //Show Page @1-F9F38336 $Header->Show("Header"); $Footer->Show("Footer"); $Tpl->setVar("cattable",$cattable); $Tpl->setVar("catlinks",$links); $Tpl->PParse("main", false); //End Show Page //Unload Page @1-AB7622EF $CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload"); unset($Tpl); //End Unload Page ?>