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 kunden_ID = '$catSearch'"; if ($orderPop == 'yes') $orderArg = "senttimes DESC,"; else $orderArg = " "; $sqlstmt = 'select * from '.$tablePrefix.'cardinfo'; $sqlstmt .= ($catSearch) ? " where kunden_ID = '$catSearch' order by $orderArg imageid $order" : " order by $orderArg imageid $order"; $gestsqlstmt = "SELECT * FROM tb_adressen WHERE adressen_ID = $catSearch"; $gestrecordset = &$conn->Execute($gestsqlstmt); $adressen_name = $gestrecordset->fields['adressen_name']; $pager = new pager($conn, $row, $limit, $rowsInTableSQL); $recordSet = $pager->getrecords($conn, $sqlstmt); if (!$recordSet) print $conn->ErrorMsg(); ?>
Execute($catsqlstmt); $totalCardsSQL = "SELECT COUNT(*) from ".$tablePrefix."cardinfo"; $totalCards = $conn->GetOne($totalCardsSQL); if (!$catrecordset) print $conn->ErrorMsg(); else { ?> EOF) { $catid = $catrecordset->fields['catid']; $category = $catrecordset->fields['category']; $numCardsInCatSQL = "SELECT COUNT(*) from ".$tablePrefix."cardinfo where catid=$catid"; $cardsInRow = $conn->GetOne($numCardsInCatSQL); if ($cardsInRow > 0) { if (isset($catSearch) && $catSearch == $catid) { "\n\t\n\t\t\n\t\t\t $category"; $selectedCategory = $category; } else { "\n\t\n\t\t\n\t\t\t $category"; } " ($cardsInRow)\n\t\t\n\t"; } $catrecordset->MoveNext(); } "\n"; } ?>

:

RecordCount(); $cardCount = 0; echo "\n\t"; while (!$recordSet->EOF) { $imageid = $recordSet->fields['imageid']; $cardname = $recordSet->fields['cardname']; $imagepath = rawurlencode($recordSet->fields['imagepath']); 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 '';?>


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