Code: Select all
<?
require( "common.php" );
dbConnect();
if( isset( $cat ) )
{
$result = mysql_query( "SELECT cat_name, root_id FROM category WHERE papa_id=$cat ORDER BY add_date" ) or error( mysql_error() );
if( mysql_num_rows( $result ) != 0 )
{
displayHeader( "$ADVT_NAME > " . displayLocationNoLink( $cat ) );
include( "menu.php" );
echo "\n<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700">\n";
echo " <tr>\n";
echo " <td height="20">\n";
displayLocation( $cat ) . "\n";
echo " </td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
echo "<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700">\n";
echo " <tr>\n";
echo " <td>\n";
while( $row = mysql_fetch_array( $result ) )
echo " <li><a href="$PHP_SELF?cat={$rowї'root_id']}">{$rowї'cat_name']}</a>(" . findTotalAds( $rowї'root_id'] ) . ")</li>\n";
echo " </td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
displayMoreCat();
}
else
{
$time = time();
$maxAds = 10;
$result = mysql_query( "SELECT cat_id FROM ads WHERE cat_id=$cat AND exp_date>$time " ) or error( mysql_error() );
$totalAds = mysql_num_rows( $result );
if( $totalAds <= $maxAds ) $totalPages = 1;
elseif( $totalAds % $maxAds == 0 ) $totalPages = $totalAds / $maxAds;
else $totalPages = ceil( $totalAds / $maxAds );
if( !isset( $page ) ) $page = 1;
elseif( $page > $totalPages || $page < 1 ) $page = 1;
if( $totalAds == 0 ) $adsStart = 0;
else $adsStart = $maxAds * $page - $maxAds + 1;
if( $page == $totalPages ) $adsEnd = $totalAds;
else $adsEnd = $maxAds * $page;
$prePage = $page - 1;
$nextPage = $page + 1;
$initAds = $maxAds * $page - $maxAds;
$result = mysql_query( "SELECT * FROM ads WHERE cat_id=$cat AND exp_date>$time ORDER BY add_date DESC LIMIT $initAds, $maxAds" ) or error( mysql_error() );
displayHeader( "$ADVT_NAME > " . displayLocationNoLink( $cat ) );
include( "menu.php" );
echo "\n<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700" height="20">\n";
echo " <tr>\n";
echo " <td>\n";
displayLocation( $cat ) . "\n";
echo " </td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
echo "<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700">\n";
echo " <tr class="frame">\n";
echo " <td width="20" height="25" align="right"><font color="#FFFFFF"><b>#</b></font></td>\n";
echo " <td width="450" height="25" align="left"><font color="#FFFFFF"><b>Subject</b></font></td>\n";
echo " <td width="80" height="25" align="center"><font color="#FFFFFF"><b>Added on</b></font></td>\n";
echo " <td width="75" height="25" align="center"><font color="#FFFFFF"><b>Photo</b></font></td>\n";
echo " <td width="75" height="25" align="center"><font color="#FFFFFF"><b>Detail</b></font></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width="100%" height="1" colspan="5" bgcolor="#FFFFFF"></td>\n";
echo " </tr>\n";
if( $totalAds == 0 )
{
echo " <tr>\n";
echo " <td width="100%" height="25" colspan="5" align="center"><font size="4">No ads currently listed in this category</font>\n";
echo " </tr>\n";
}
$i = $adsStart;
while( $row = mysql_fetch_array( $result ) )
{
echo " <tr class="detail">\n";
echo " <td height="25" align="right">{$i}.</td>\n";
echo " <td height="25">" . substr( $rowї'subject'], 0, 50 );
if( strlen( $rowї'subject'] ) > 50 ) echo "... ...";
echo "</td>\n";
echo " <td height="25" align="center"><small>" . date( "m/d/y h:i", $rowї'add_date'] ) . "</small></td>\n";
echo " <td height="25" align="center">";
$photo = mysql_query( "SELECT photo_id FROM photo WHERE ad_id={$rowї'ad_id']}" ) or error( mysql_error() );
if( mysql_num_rows( $photo ) >= 1 ) echo "Yes";
else echo "No";
echo "</td>\n";
echo " <td height="25" align="center"><a href="detail.php?cat=$cat&de={$rowї'ad_id']}">Detail</a></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td></td>\n";
echo " <td colspan="4">" . substr( $rowї'descript'], 0, 300 );
if( strlen( $rowї'descript'] ) > 300 ) echo "... ...";
echo "</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td colspan="5" align="right"><a href="detail.php?cat=$cat&de={$rowї'ad_id']}"><small>More...</small></a></td>\n";
echo " </tr>\n";
$i++;
}
echo " <tr>\n";
echo " <td width="100%" height="1" colspan="5" bgcolor="#808080"></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width="100%" height="20" colspan="5"><small>Found <b>$totalAds</b> listings, now displaying <b>$adsStart</b> - <b>$adsEnd</b></small></td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
echo "<p align="center">";
if( $page != 1 ) echo "<a href="$PHP_SELF?cat=$cat&page=$prePage"><<</a> ";
for( $i = 1; $i <= $totalPages; $i++ )
{
if( $page == $i ) echo "<b>$i</b> ";
else echo "<a href="$PHP_SELF?cat=$cat&page=$i">$i</a> ";
}
if( $page != $totalPages ) echo " <a href="$PHP_SELF?cat=$cat&page=$nextPage">>></a>";
echo "</p>\n";
echo "<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700">\n";
echo " <tr>\n";
echo " <td align="center">\n";
echo " <form method="post" action="search.php?action=search">\n";
echo " <b>Search <input type="text" name="keywords" size="20" maxlength="100">\n";
echo " <input type="submit" value=" Go "></b>\n";
echo " </form></td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
}
}
else
{
$cats = mysql_query( "SELECT cat_name, root_id FROM category WHERE papa_id='' ORDER BY add_date DESC" ) or error( mysql_error() );
displayHeader( $ADVT_NAME );
if( mysql_num_rows( $cats ) == 0 )
echo "<p align="center"><font size="4">No Category Found</font></p>\n";
else
{
include( "menu.php" );
echo "\n<div align="center">\n";
echo " <center>\n";
echo " <table border="0" cellpaddig="0" cellspacing="0" width="700">\n";
$i = 1;
while( $catsrow = mysql_fetch_array( $cats ) )
{
$subcats = mysql_query( "SELECT cat_name, root_id, add_date FROM category WHERE papa_id={$catsrowї'root_id']} ORDER BY add_date DESC" ) or error( mysql_error() );
echo $i % 2 == 1 ? " <tr>\n" : "";
echo " <td width="50%">";
echo "<a href="$PHP_SELF?cat={$catsrowї'root_id']}"><b>{$catsrowї'cat_name']}</b></a>(" . findTotalAds( $catsrowї'root_id'] ) . ")<br>\n";
$num = mysql_num_rows( $subcats );
$j = 1;
$time = time();
while( $subcatsrow = mysql_fetch_array( $subcats ) )
{
$subcatsrowї'add_date'] > $time - 3600 * 24 * 3 ? $isnew = "<img src="new.gif" align="top">" : $isnew = "";
if( $num != $j )
echo " <a href="$PHP_SELF?cat={$subcatsrowї'root_id']}">{$subcatsrowї'cat_name']}</a>{$isnew}, \n";
else echo " <a href="$PHP_SELF?cat={$subcatsrowї'root_id']}">{$subcatsrowї'cat_name']}</a>$isnew\n";
$j++;
}
echo " <br> \n";
echo " </td>\n";
echo $i % 2 == 0 ? " </tr>\n" : "";
$i++;
}
echo " </table>\n";
echo " </center>\n";
echo "</div>\n";
}
}
displayFooter();
?>