include("common.php");
require_once("$HeaderFile");
if(empty($_GET[Start])){
$Start = '0';
}else{
$Start = $_GET[Start];
}
$ByPage = $aset[pagina];
$query = array();
if(!empty($_GET[what])){
$query[] = " (ItemName like '%$_GET[what]%' or ItemDesc like '%$_GET[what]%') ";
}
if(!empty($_GET[pagename])){
$qcatalognum = "SELECT CategoryID FROM categories WHERE CategoryPageName = '$_GET[pagename]'";
$rcatalognum = mysql_query($qcatalognum) or die(mysql_error());
$catalognum = mysql_fetch_array($rcatalognum);
$query[] = " ItemCategory = '$catalognum[CategoryID]' ";
/*********************************** BEGINNING OF THE BIG IF *****************************/
if($catalognum[CategoryID]){
if(!empty($_GET[SubcategoryID])){
$query[] = " ItemSubcategory = '$_GET[SubcategoryID]' ";
}
if(!empty($query)){
$my_query = implode(" and ", $query);
$my_query = " WHERE $my_query";
}
if(!empty($_GET[ord1])){
$order_by = " ORDER BY $_GET[ord1] ";
}else{
$order_by = " ORDER BY ItemName ";
}
// Modified On July 11, 2005 by Patrick Mahoney for Online-Net-Business.Com - Killer SEO Website Builder System
if ($catalognum > 0) {
$sel = mysql_query("SELECT CategoryDescInfo FROM categories WHERE CategoryPageName = '$_GET[pagename]'");
if (mysql_num_rows($sel) > 0) {
while ($fet = mysql_fetch_array($sel)) {
?>
}
} else echo '';
} else echo '';
// End Added Modified
// include("pagina.php");
// Show The Catalog Content
$q1 = "SELECT * FROM items $my_query ORDER BY ItemID LIMIT $Start, $ByPage";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) > '0'){
$col = "#D7D7D7";
while($a1 = mysql_fetch_array($r1)){
if($col == "#ffffff"){
$col = "#ffffff";
}else{
$col = "#ffffff";
} // old link item.php?item=$a1[ItemID]
if($PageFolder == "Folder"){
$result_rows .= " |
\n\t$a1[ItemName] | \n\t\n
\n\n";
}elseif($PageFolder == "Page"){
$result_rows .= "\n\t$a1[ItemName] | \n\t\n
\n\n";
}else{
echo " - Please Set Your Page View Preference In The Settings Area - ";
}
}
$qnav = "select count(*) from items $my_query";
$rnav = mysql_query($qnav) or die(mysql_error());
$anav = mysql_fetch_array($rnav);
$rows = $anav[0];
if($rows > $ByPage){
$NextPrev = "
";
$NextPrev .= " | ";
$pages = ceil($rows/$ByPage);
for($i = 0; $i <= ($pages); $i++){
$PageStart = $ByPage*$i;
$i2 = $i + 1;
if($PageStart == $Start){
$links[] = " $i2\n\t ";
}elseif($PageStart < $rows){
if($PageFolder == "Folder"){
$links[] = "$i2\n\t ";
}elseif($PageFolder == "Page"){
$links[] = "$i2\n\t ";
}else{
echo " - Please Set Your Page View Preference In The Settings Area - ";
}
}
}
// Below Is The Original Version Before Mod Rewrite
// $links[] = "$i2\n\t ";
// Below Was The First Attempt Before Mod Rewrite That Worked
// $links[] = "$i2\n\t ";
$links2 = implode(" | ", $links);
$NextPrev .= $links2;
$NextPrev .= "| | ";
$NextPrev .= "
\n";
}
include_once("templates/ResultsTemplate.php");
}else{
include_once("templates/NoResultsTemplate.php");
}
}else{
/*******************************************************/
$q1 = "SELECT * FROM items WHERE ItemPageName = '$_GET[pagename]'";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);
include_once("templates/ViewItemTemplate.php");
}
} /********************************** END OF THE BIG IF **********************************/
require_once("$FooterFile");
?>