|
|
|
Welcome to Fine Scottish Gifts |
langargs = "&row=$row&catSearch=$catSearch";
$page->showHeader();
$limit = $rowsPerPage * $cardsPerRow;
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$conn = &ADONewConnection('mysql');
if (!$conn->Connect($dbhost,$dbuser,$dbpass,$dbdatabase))
{
echo "Error: Could not connect to database";
$page->showFooter();
exit;
}
if ($deleteDays != 0)
{
$deletePriorTime = time() - ($deleteDays * 24 * 60 * 60);
$deleteCardsSQL = 'DELETE FROM '.$tablePrefix.'sentcards WHERE cardid<'.$deletePriorTime;
$conn->Execute($deleteCardsSQL);
}
if ($stats_unique_index_hits_enabled == true)
{
if (!isset($_SESSION['stat_userhits']))
{
$sql = "UPDATE ".$tablePrefix."statistics set statval=(statval +1) WHERE stat='userhits'";
$conn->Execute($sql);
unset($sql);
$_SESSION['stat_userhits'] = true;
}
}
$rowsInTableSQL = "SELECT COUNT(*) from ".$tablePrefix."cardinfo";
if ($catSearch) $rowsInTableSQL .= " where catid = '$catSearch'";
if ($orderPop == 'yes') $orderArg = "senttimes DESC,"; else $orderArg = " ";
$sqlstmt = 'select * from '.$tablePrefix.'cardinfo';
$sqlstmt .= ($catSearch) ? " where catid = '$catSearch' order by $orderArg imageid $order" : " order by $orderArg imageid $order";
$pager = new pager($conn, $row, $limit, $rowsInTableSQL);
$recordSet = $pager->getrecords($conn, $sqlstmt);
if (!$recordSet) print $conn->ErrorMsg();
?>
|
|
RecordCount();
$cardCount = 0;
echo "\n\t";
while (!$recordSet->EOF)
{
$imageid = $recordSet->fields['imageid'];
$cardname = $recordSet->fields['cardname'];
$thumbpath = rawurlencode($recordSet->fields['thumbpath']);
if ((($cardCount % $cardsPerRow) == 0) && (!($cardCount == 0))) echo "\n\t \n\t";
if ($dropShadow == 'yes')
{
?>
|
|
|
MoveNext();
$cardCount++;
}
$emptyCells = ($cardsPerRow - ($numCards % $cardsPerRow));
for ($i=0; $i < $emptyCells; $i++) echo "\n\t\t | ";
echo "\n\t \n ";
}
$recordSet->Close();
?>
| |
|
| |
showpagernav($nav01, $nav02, "&catSearch=$catSearch");
?>
|
| ';
include('inc/newssummary.php');
echo " |
";
}
echo ' | ';
if (($enableNews == 'yes') && ($newsLocation == 'right'))
{
echo '';
include('inc/newssummary.php');
echo ' | ';
}
echo ' ';
$conn->Close();
$page->showFooter();
?> |
|
