Connect($dbhost,$dbuser,$dbpass,$dbdatabase); // Get the total number of cards, or the number of cards in a category if a category is selected $rowsInTableSQL = "SELECT COUNT(*) from ".$tablePrefix."cardinfo"; if ($catSearch) $numrows = $conn->GetOne("$rowsInTableSQL where catid = '$catSearch'"); else $numrows = $conn->GetOne($rowsInTableSQL); // calculate the number of pages needed to show the cards if (($numrows % $limit) == 0) $pages = ($numrows/$limit); else $pages = intval($numrows/$limit) + 1; $current = ($row/$limit) + 1; // Current Page if ($orderPop == 'yes') { $orderArg = "senttimes DESC,"; } else $orderArg = " "; $sqlstmt = 'select * from '.$tablePrefix.'cardinfo'; if ($catSearch) $recordSet = &$conn->SelectLimit("$sqlstmt where catid = '$catSearch' order by $orderArg imageid $order",$limit,$row ); else $recordSet = &$conn->SelectLimit("$sqlstmt order by $orderArg imageid $order",$limit,$row); 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"; echo "\n\t\t"; $recordSet->MoveNext(); $cardCount++; } $emptyCells = ($cardsPerRow - ($numCards % $cardsPerRow)); for ($i=0; $i < $emptyCells; $i++) echo "\n\t\t"; echo "\n\t\n \n\t\t\t \n\t\t\t$cardname\n\t\t   "; } $recordSet->Close(); # optional echo ""; if (!($pages == 1)) { echo ""; } echo "     "; if ($row != 0) { // if not the first page create back link with record set 1 page back (record - limit) $backPage = $row - $limit; echo "$nav01   \n";} for ($i=1; $i <= $pages; $i++) { $ppage = $limit*($i - 1); // ppage is record at a certain page if ($ppage == $row){ echo "$i   \n";} // if current page just show page number else { echo "$i   \n";}} // else show link to page number if ($current < $pages) { // Give next link if not last page $nextPage = $row + $limit; echo("$nav02");} echo " "; if (($enableNews == 'yes') && ($newsLocation == 'bottom')) { echo " "; include('inc/newssummary.php'); echo " "; } echo "

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

"; $currentTime = time(); $timeToSeconds = ($deleteDays * 24 * 60 * 60); $deletePriorTime = $currentTime - $timeToSeconds; $deleteCardsSQL = "DELETE FROM ".$tablePrefix."sentcards WHERE cardid < $deletePriorTime"; $conn->Execute($deleteCardsSQL); $conn->Close(); showFooter(); ?>