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(); ?> '; if (($enableNews == 'yes') && ($newsLocation == 'right')) { echo ''; } echo '

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 '

'; include('inc/newssummary.php'); echo '

'; $conn->Close(); $page->showFooter(); ?>