Hi, Thank you for trying so hard, you are wonderful. I’m afraid your explanation went over my head. Here is the index page
[code]<?php
*/
include ( “./defaults.php” );
$getcat = $_GET[cat];
$getcategory = $_GET[category];
$getsubcat = $_GET[subcat];
$getsubsubcat = $_GET[subsubcat];
if ( file_exists (“install.php”) )
{
error ( "I/O Error", "Please, remove / rename <b>install.php</b> file after you have created all the tables. This file may cause a security risk." );
}
if ( !is_writable (“counter.txt”) )
{
error ( "I/O Error", "Please, set correct permissions on counter.txt file (chmod 666)." );
}
if ( (!is_writable("./banner")) or (!is_writable("./banner2")) or (!is_writable("./gallery")) or (!is_writable("./logo")) or (!is_writable("./upload")) )
{
error ( "I/O Error", "Please, set correct permissions on the following folders: banner, banner2, gallery, logo, upload (chmod 777)." );
}
$show_banner=“YES”;
if ( $_GET[“OUT”] == “logout” )
{
@session_start(); session_unset(); session_destroy();
}
// *********************************************************
if ( ( !isset($_GET[“REQ”] ) ) and ( !isset ( $_GET[“cat”] ) ) and ( !isset ( $_GET[“category”] ) ) )
{
$incomingline = "$def_catalogue";
$help_section = "$cat_help_1";
$show_banner="NO";
include ( "./template/$def_template/header.php" );
include ("./searchform.inc.php");
if ($def_allow_index == "YES")
{
?>
<?php
$letters = explode("#", $def_index_search);
echo " ";
for ($a=0;$a<count($letters);$a++)
{
if ($def_rewrite == "YES")
echo "$letters[$a] ";
else
echo "$letters[$a] ";
}
echo " ";
?>
</td>
|
<?php } ?>
<table cellspacing="0" cellpadding="0" border="0" width="90%">
<tr>
<td width="50%" valign="top">
<ul>
<?php
if ($def_empty_hidden == "YES") $sql = "WHERE fcounter > 0"; else $sql = "";
$r = $db->query ( "SELECT * FROM $db_category $sql ORDER BY category " );
if (!$r) error ("mySQL error", mysql_error() );
$results = $db->numrows ( $r );
$res = round ( $results/2 );
for ( $i=0;$i<$res;$i++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > 0 )
{
echo "";
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f[category] »
";
if ($def_show_indexes == "YES")
{
if (($f[sccounter] != 0) and ($f[ssccounter] != 0))
echo "[$f[sccounter]/$f[ssccounter]/$f[fcounter]]";
if (($f[sccounter] != 0) and ($f[ssccounter] == 0))
echo "[$f[sccounter]/$f[fcounter]]";
if (($f[sccounter] == 0) and ($f[ssccounter] == 0))
echo "[$f[fcounter]]";
}
echo "";
if ($def_show_subcategories == "YES")
{
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0"; else $sql = "";
$r_subs = $db->query ( "SELECT * FROM $db_subcategory WHERE catsel=$f[selector] $sql ORDER BY subcategory LIMIT $def_show_subs_number" );
$results2 = $db->numrows ( $r_subs );
if ($results2 > 0) echo "
";
for ( $i2=0;$i2<$results2;$i2++ )
{
$f_subs = $db->fetcharray ( $r_subs );
if ( $f_subs[fcounter] > 0 )
{
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f_subs[subcategory] ";
if ($def_show_indexes == "YES")
echo "[$f_subs[fcounter]]";
if ($results2 > $i2+1) echo ", ";
}
else
{
echo "
$f_subs[subcategory]";
if ($results2 > $i2+1) echo ", ";
}
}
if ($results2 > 0) echo "
";
}
}
else
{
echo "
$f[category]
";
}
}
echo "
|
";
for ( $x=$res;$x<$results;$x++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > 0 )
{
echo "- ";
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f[category] »
";
if ($def_show_indexes == "YES")
{
if (($f[sccounter] != 0) and ($f[ssccounter] != 0))
echo "[$f[sccounter]/$f[ssccounter]/$f[fcounter]]";
if (($f[sccounter] != 0) and ($f[ssccounter] == 0))
echo "[$f[sccounter]/$f[fcounter]]";
if (($f[sccounter] == 0) and ($f[ssccounter] == 0))
echo "[$f[fcounter]]";
}
echo "";
if ($def_show_subcategories == "YES")
{
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0"; else $sql = "";
$r_subs = $db->query ( "SELECT * FROM $db_subcategory WHERE catsel=$f[selector] $sql ORDER BY subcategory LIMIT $def_show_subs_number" );
if (!$r_subs) error ("mySQL error", mysql_error() );
$results2 = $db->numrows ( $r_subs );
if ($results2 > 0) echo "
";
for ( $i2=0;$i2<$results2;$i2++ )
{
$f_subs = $db->fetcharray ( $r_subs );
if ( $f_subs[fcounter] > 0 )
{
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f_subs[subcategory] ";
if ($def_show_indexes == "YES")
echo "[$f_subs[fcounter]]";
if ($results2 > $i2+1) echo ", ";
}
else
{
echo "
$f_subs[subcategory]";
if ($results2 > $i2+1) echo ", ";
}
}
if ($results2 > 0) echo "
";
}
}
else
{
echo "
-
$f[category]
";
}
}
?>
|
<?php
include ("./cron.php");
include ( "./template/$def_template/footer.php" );
}
// *********************************************************
if ( isset ( $_GET["category"] ) )
{
$ra = $db->query ( "SELECT * FROM $db_category WHERE selector=$_GET[category]" );
$fa = $db->fetcharray ( $ra );
$db->freeresult ( $ra );
$ip = $_SERVER["REMOTE_ADDR"];
$top=$fa[top] + 1;
if ($ip != "$fa[ip]")
$db->query ( "UPDATE $db_category SET top = '$top', ip = '$ip' WHERE selector=$_GET[category]" );
$incomingline = "
$def_catalogue
| $fa[category]";
$help_section = "$cat_help_2";
include ( "./template/$def_template/header.php" );
?>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="100%" valign="top" align="center">
<table cellspacing="0" cellpadding="0" border="0" width="90%">
<tr>
<td width="50%" valign="top">
<?php
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0 "; else $sql = "";
$r = $db->query ( "SELECT * FROM $db_subcategory WHERE catsel=$_GET[category] $sql ORDER BY subcategory" );
$results = $db->numrows ( $r );
$res = round ( $results/2 );
if ($res > 0) echo "
";
for ( $i=0;$i<$res;$i++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > 0 )
{
echo "- ";
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f[subcategory] »
";
if ($def_show_indexes == "YES")
{
if (($f[sccounter] == 0) and ($f[ssccounter] != 0))
echo "[$f[ssccounter]/$f[fcounter]]";
if (($f[sccounter] == 0) and ($f[ssccounter] == 0))
echo "[$f[fcounter]]";
}
echo "";
// SHOW SUBSUBCATEGORIES
if ($def_show_subsubcategories == "YES")
{
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0 "; else $sql = "";
$r_subs = $db->query ( "SELECT * FROM $db_subsubcategory WHERE catsubsel=$f[catsubsel] AND catsel=$_GET[category] $sql ORDER BY subsubcategory LIMIT $def_show_subs_number" );
$results2 = $db->numrows ( $r_subs );
if ($results2 > 0) echo "
";
for ( $i2=0;$i2<$results2;$i2++ )
{
$f_subs = $db->fetcharray ( $r_subs );
if ( $f_subs[fcounter] > 0 )
{
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f_subs[subsubcategory]";
if ($def_show_indexes == "YES")
echo "[$f_subs[fcounter]]";
if ($results2 > $i2+1) echo ", ";
}
else
{
echo "
$f_subs[subsubcategory]";
if ($results2 > $i2+1) echo ", ";
}
}
if ($results2 > 0) echo "
";
}
}
else
{
echo "
-
$f[subcategory]
";
}
}
if ($res > 0) echo "
";
echo "
";
if ($res > 0) echo "";
for ( $i=$res;$i<$results;$i++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > "0" )
{
echo "- ";
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f[subcategory] »
";
if ($def_show_indexes == "YES")
{
if (($f[sccounter] == 0) and ($f[ssccounter] != 0))
echo "[$f[ssccounter]/$f[fcounter]]";
if (($f[sccounter] == 0) and ($f[ssccounter] == 0))
echo "[$f[fcounter]]";
}
echo "";
// SHOW SUBSUBCATEGORIES
if ($def_show_subsubcategories == "YES")
{
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0 "; else $sql = "";
$r_subs = $db->query ( "SELECT * FROM $db_subsubcategory WHERE catsubsel=$f[catsubsel] AND catsel=$_GET[category] $sql ORDER BY subsubcategory LIMIT $def_show_subs_number" );
$results2 = $db->numrows ( $r_subs );
if ($results2 > 0) echo "
";
for ( $i2=0;$i2<$results2;$i2++ )
{
$f_subs = $db->fetcharray ( $r_subs );
if ( $f_subs[fcounter] > 0 )
{
if ($def_rewrite == "YES")
{
echo "";
}
else
echo "";
echo "$f_subs[subsubcategory]";
if ($def_show_indexes == "YES")
echo "[$f_subs[fcounter]]";
if ($results2 > $i2+1) echo ", ";
}
else
{
echo "
$f_subs[subsubcategory]";
if ($results2 > $i2+1) echo ", ";
}
}
if ($results2 > 0) echo "
";
}
}
else
{
echo "
-
$f[subcategory]
";
}
}
if ($res > 0) echo "
";
?>
|
</td>
<?php
$npage = $_GET["page"] + 1;
$ppage = $_GET["page"] - 1;
$page1 = $_GET["page"] * $def_count_dir;
if ($def_onlypaid == "YES") $hide_d=" AND flag <> 'D' ";
$r = $db->query ( "SELECT * FROM $db_users WHERE (category LIKE '$_GET[category]#0#0:%' or category LIKE '%:$_GET[category]#0#0:%' or category LIKE '%:$_GET[category]#0#0' or category LIKE '$_GET[category]#0#0') and firmstate = 'on' $hide_d ORDER BY flag, firmname LIMIT $page1, $def_count_dir" );
$r1 = $db->query ( "SELECT * FROM $db_category WHERE selector= '$_GET[category]'" );
$f1= $db->fetcharray($r1);
if ($f1[sccounter] > 0) $results_amount=0;
else $results_amount=$f1[fcounter];
$fetchcounter = $def_count_dir;
$f = $results_amount - $page1;
if ( $f < $def_count_dir ) { $fetchcounter = $results_amount - $page1; }
if ($results_amount > 0)
{
include ("./includes/sub.php");
if ( $results_amount > $def_count_dir )
{
if ((($_GET[page]*$def_count_dir)-($def_count_dir*5)) >= 0) $first=($_GET[page]*$def_count_dir)-($def_count_dir*5);
else $first=0;
if ((($_GET[page]*$def_count_dir)+($def_count_dir*6)) <= $results_amount) $last =($_GET[page]*$def_count_dir)+($def_count_dir*6);
else $last = $results_amount;
@ $z=$first/$def_count_dir;
if ($_GET["page"] > 0)
{
if ($def_rewrite == "YES")
echo "
$def_previous ";
else
echo "
$def_previous ";
}
for ( $x=$first; $x<$last;$x=$x+$def_count_dir )
{
if ( $z == $_GET[page] )
{
echo "[
", $z+1 ," ] ";
$z++;
}
else
{
if ($def_rewrite == "YES")
echo "
", $z+1 ," ";
else
echo "
", $z+1 ," ";
$z++;
}
}
}
if ($_GET[page] - (($results_amount / $def_count_dir) - 1) < 0)
{
if ($def_rewrite == "YES")
echo "
$def_next";
else
echo "
$def_next";
}
echo "
";
}
include ( "./template/$def_template/footer.php" );
}
// *********************************************************
if ( (isset ( $_GET["cat"] ) and (isset ( $_GET["subcat"] )) and (!isset ( $_GET["subsubcat"] ) ) and (!isset ( $_GET["REQ"] ) )) )
{
$ra = $db->query ( "SELECT * FROM $db_category WHERE selector=$_GET[cat]" );
$fa = $db->fetcharray ( $ra );
$db->freeresult ( $ra );
$ra2 = $db->query ( "SELECT * FROM $db_subcategory WHERE catsel=$_GET[cat] and catsubsel=$_GET[subcat]" );
$fa2 = $db->fetcharray ( $ra2 );
$db->freeresult ( $ra2 );
$incomingline = "
$def_catalogue
|";
if ($def_rewrite == "YES")
{
$incomingline.= "
";
}
else
$incomingline.= "";
$incomingline.= "
$fa[category]
|
$fa2[subcategory]
";
$help_section = "$cat_help_2";
include ("./template/$def_template/header.php");
?>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="100%" valign="top" align="center">
<table cellspacing="0" cellpadding="0" border="0" width="90%">
<tr>
<td width="50%" valign="top">
<?php
if ($def_empty_hidden == "YES") $sql = " AND fcounter > 0 "; else $sql = "";
$r = $db->query ( "SELECT * FROM $db_subsubcategory WHERE catsel=$_GET[cat] and catsubsel=$_GET[subcat] $sql ORDER BY subsubcategory" );
$results = $db->numrows ( $r );
$res = round ( $results/2 );
if ($res > 0) echo "
";
for ( $i=0;$i<$res;$i++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > 0 )
{
echo "- ";
if ($def_rewrite == "YES")
echo "";
else
echo "";
echo "$f[subsubcategory] » ";
if ($def_show_indexes == "YES")
echo "
[$f[fcounter]]
";
}
else
{
echo "
-
$f[subsubcategory]";
}
}
if ($res > 0) echo "
";
echo "
";
if ($res > 0) echo "";
for ( $i=$res;$i<$results;$i++ )
{
$f = $db->fetcharray ( $r );
if ( $f[fcounter] > "0" )
{
echo "- ";
if ($def_rewrite == "YES")
echo "";
else
echo "";
echo "$f[subsubcategory] » ";
if ($def_show_indexes == "YES")
echo "
[$f[fcounter]]
";
}
else
{
if ($def_empty_hidden != "YES")
echo "
-
$f[subsubcategory]";
}
}
if ($res > 0) echo "
";
?>
|
</td>
<?php
$npage = $_GET["page"] + 1;
$ppage = $_GET["page"] - 1;
$page1 = $_GET["page"] * $def_count_dir;
if ($def_onlypaid == "YES") $hide_d=" AND flag <> 'D' ";
$r1 = $db-> query ( "SELECT * FROM $db_subcategory WHERE catsel= '$_GET[cat]' and catsubsel='$_GET[subcat]'" );
$f1 = $db-> fetcharray($r1);
$r = $db->query ( "SELECT * FROM $db_users WHERE ((category LIKE '%:$_GET[cat]#$_GET[subcat]#0:%') or (category LIKE '$_GET[cat]#$_GET[subcat]#0:%') or (category LIKE '%:$_GET[cat]#$_GET[subcat]#0') or (category LIKE '$_GET[cat]#$_GET[subcat]#0')) and firmstate = 'on' $hide_d ORDER BY flag, firmname LIMIT $page1, $def_count_dir" );
if ($f1[ssccounter] > 0) $results_amount=0;
else $results_amount=$f1[fcounter];
$fetchcounter = $def_count_dir;
$f = $results_amount - $page1;
if ( $f < $def_count_dir ) { $fetchcounter = $results_amount - $page1; }
if ($results_amount > 0)
{
include ("./includes/sub.php");
if ( $results_amount > $def_count_dir )
{
if ((($_GET[page]*$def_count_dir)-($def_count_dir*5)) >= 0) $first=($_GET[page]*$def_count_dir)-($def_count_dir*5);
else $first=0;
if ((($_GET[page]*$def_count_dir)+($def_count_dir*6)) <= $results_amount) $last =($_GET[page]*$def_count_dir)+($def_count_dir*6);
else $last = $results_amount;
@ $z=$first/$def_count_dir;
if ($_GET["page"] > 0)
{
if ($def_rewrite == "YES")
echo "
$def_previous ";
else
echo "
$def_previous ";
}
for ( $x=$first; $x<$last;$x=$x+$def_count_dir )
{
if ( $z == $_GET[page] )
{
echo "[
", $z+1 ," ] ";
$z++;
}
else
{
if ($def_rewrite == "YES")
echo "
", $z+1 ," ";
else
echo "
", $z+1 ," ";
$z++;
}
}
}
if ($_GET[page] - (($results_amount / $def_count_dir) - 1) < 0)
{
if ($def_rewrite == "YES")
echo "
$def_next";
else
echo "
$def_next";
}
echo "
";
}
include ( "./template/$def_template/footer.php" );
}
// *********************************************************
$r = $db->query ( "SELECT * FROM $db_subsubcategory WHERE catsubsubsel='$_GET[subsubcat]'" );
$f = $db->fetcharray ( $r );
$showsubcategory = $f["subsubcategory"];
$r = $db->query ( "SELECT * FROM $db_subcategory WHERE catsubsel='$_GET[subcat]'" );
$f = $db->fetcharray ( $r );
$showcategory = $f["subcategory"];
$r = $db->query ( "SELECT * FROM $db_category WHERE selector='$_GET[cat]'" );
$f = $db->fetcharray ( $r );
$showmaincategory = $f["category"];
$npage = $_GET["page"] + 1;
$ppage = $_GET["page"] - 1;
$page1 = $_GET["page"] * $def_count_dir;
if ($def_onlypaid == "YES") $hide_d=" AND flag <> 'D' ";
$r = $db->query ( "SELECT * FROM $db_subsubcategory WHERE catsel = '$_GET[cat]' and catsubsel = '$_GET[subcat]' and catsubsubsel = '$_GET[subsubcat]'" );
$results_amount_1 = $db->fetcharray ( $r );
$results_amount = $results_amount_1[fcounter];
$incomingline = "
$def_catalogue
| ";
if ($def_rewrite == "YES")
$incomingline.= "
";
else
$incomingline.= "";
$incomingline.= "
$showmaincategory
| ";
if ($def_rewrite == "YES")
$incomingline.= "
";
else
$incomingline.= "";
$incomingline.= "
$showcategory
|
$showsubcategory
";
$help_section = "$cat_help_4";
include ( "./template/$def_template/header.php" );
if ($def_onlypaid == "YES") $hide_d=" AND flag <> 'D' ";
$r = $db->query ( "SELECT * FROM $db_users WHERE (category LIKE '$_GET[cat]#$_GET[subcat]#$_GET[subsubcat]%' or category LIKE '%:$_GET[cat]#$_GET[subcat]#$_GET[subsubcat]:%' or category LIKE '%:$_GET[cat]#$_GET[subcat]#$_GET[subsubcat]' or category LIKE '$_GET[cat]#$_GET[subcat]#$_GET[subsubcat]') and firmstate = 'on' $hide_d ORDER BY flag, firmname LIMIT $page1, $def_count_dir" );
$fetchcounter = $def_count_dir;
$f = $results_amount - $page1;
if ( $f < $def_count_dir ) { $fetchcounter = $results_amount - $page1; }
include ("./includes/sub.php");
if ( $results_amount > $def_count_dir )
{
if ((($_GET[page]*$def_count_dir)-($def_count_dir*5)) >= 0) $first=($_GET[page]*$def_count_dir)-($def_count_dir*5);
else $first=0;
if ((($_GET[page]*$def_count_dir)+($def_count_dir*6)) <= $results_amount) $last =($_GET[page]*$def_count_dir)+($def_count_dir*6);
else $last = $results_amount;
@ $z=$first/$def_count_dir;
if ($_GET["page"] > 0)
{
if ($def_rewrite == "YES")
echo "
$def_previous ";
else
echo "
$def_previous ";
}
for ( $x=$first; $x<$last;$x=$x+$def_count_dir )
{
if ( $z == $_GET[page] )
{
echo "[
", $z+1 ," ] ";
$z++;
}
else
{
if ($def_rewrite == "YES")
echo "
", $z+1 ," ";
else
echo "
", $z+1 ," ";
$z++;
}
}
}
if ($_GET[page] - (($results_amount / $def_count_dir) - 1) < 0)
{
if ($def_rewrite == "YES")
echo "
$def_next ";
else
echo "
$def_next ";
}
echo "
";
include ( "./template/$def_template/footer.php" );
?>[/code]