"; $query = "DELETE FROM {$CONFIG['TABLE_ECARDS']} WHERE eid='$key'"; $result = db_query($query); } } switch ($sort) { case 'snd' : $sortBy = 'sender_name'; $sortDirection = 'DESC'; $sortText = $lang_db_ecard_php['ecard_by_sender_name']; break; case 'sna' : $sortBy = 'sender_name'; $sortDirection = 'ASC'; $sortText = $lang_db_ecard_php['ecard_by_sender_name']; break; case 'sed' : $sortBy = 'sender_email'; $sortDirection = 'DESC'; $sortText = $lang_db_ecard_php['ecard_by_sender_email']; break; case 'sea' : $sortBy = 'sender_email'; $sortDirection = 'ASC'; $sortText = $lang_db_ecard_php['ecard_by_sender_email']; break; case 'id' : $sortBy = 'sender_ip'; $sortDirection = 'DESC'; $sortText = $lang_db_ecard_php['ecard_by_sender_ip']; break; case 'ia' : $sortBy = 'sender_ip'; $sortDirection = 'ASC'; $sortText = $lang_db_ecard_php['ecard_by_sender_ip']; break; case 'rnd' : $sortBy = 'recipient_name'; $sortDirection = 'DESC'; $sortText = $lang_db_ecard_php['ecard_by_recipient_name']; break; case 'rna' : $sortBy = 'recipient_name'; $sortDirection = 'ASC'; $sortText = $lang_db_ecard_php['ecard_by_recipient_name']; break; case 'red' : $sortBy = 'recipient_email'; $sortDirection = 'DESC'; $sortText = $lang_db_ecard_php['ecard_by_recipient_email']; break; case 'rea' : $sortBy = 'recipient_email'; $sortDirection = 'ASC'; $sortText = $lang_db_ecard_php['ecard_by_recipient_email']; break; case 'da' : $sortBy = 'date'; $sortDirection = 'ASC'; break; } if ($sortDirection == 'ASC'){$sortDirectionText = $lang_db_ecard_php['ecard_ascending'];} // determine the total number of entries $result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_ECARDS']}"); if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_errors['ecards_empty'], __FILE__, __LINE__, false); $totalEcards = mysql_fetch_array($result); $totalEcards = $totalEcards[0]; $result = db_query("SELECT eid, sender_name, sender_email, recipient_name, recipient_email, link, date, sender_ip FROM {$CONFIG['TABLE_ECARDS']} ORDER BY $sortBy $sortDirection LIMIT $startFrom,$countTo"); if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_errors['ecards_empty'], __FILE__, __LINE__, false); pageheader($lang_db_ecard_php['title']); $formTarget = cpgGetUrlVars('count'); print '

'; ?> $value) { if ($key!='start' && $key!='count'){$urlWithoutStart.= $key . "=" . $value . "&";} } //print $pageTotal; //step 3: loop through the pages & create the links for ($page = 1 ; $page <= $pageTotal; $page++) { if ($page != $startFrom/$countTo+1) { $tabOutput .= ''; } else { $currentPage = $page; $currentStart = ($page-1)*$countTo+1; $currentEnd = $currentStart+$countTo-1; if ($currentEnd > $totalEcards) {$currentEnd =$totalEcards;} } $tabOutput .= $page; //$tabOutput .= '('.$page.'/'.$startFrom/$countTo.') '; if ($page != $startFrom/$countTo+1) { $tabOutput .= ''; } $tabOutput .= ' '; } $maxPage = $page-1; $tableHeader1 = $lang_db_ecard_php['title']." (".$lang_db_ecard_php['ecard_sorted']." ".$sortText.", ".$sortDirectionText.")"; starttable('100%',$tableHeader1,3); print ''; printf($lang_db_ecard_php['ecard_number'], $currentStart, $currentEnd, $totalEcards); print ''; if ($maxPage > 1) { print $lang_db_ecard_php['ecard_goto_page'].' '; print $tabOutput; } print ''; print $lang_db_ecard_php['ecard_records_per_page']; print ' '; foreach ($selectOptions as $key ) { print ' '.$key.''; } print ' '; print ''; endtable(); print '
'; $urlWithoutSort = cpgGetUrlVars('sort'); starttable('100%'); //print ''; print ""; print ""; $tempClass = ' class="tableb"'; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; print "\n"; print "".$line['sender_name']."\n"; print "".$line['sender_email']."\n"; print "".$line['sender_ip']."\n"; print "".$line['recipient_name']."\n"; print "".$line['recipient_email']."\n"; print "".strftime($lastcom_date_fmt,$line['date'])."\n"; print "\n"; print "\t\n"; if ($tempClass == ' class="tableb"'){$tempClass = ' class="tableh2"';}else{$tempClass = ' class="tableb"';} } print ''; print ''; print ''; print ''; endtable(); print "\n"; pagefooter(); function cpgGetUrlVars($exception) // get the url vars { $cpgGetUrl = $_SERVER["SCRIPT_NAME"]."?"; foreach ($_GET as $key => $value) { if ($key!=$exception){$cpgGetUrl.= $key . "=" . $value . "&";} } return $cpgGetUrl; } ?>

	".$lang_db_ecard_php['ecard_sender']."	".$lang_db_ecard_php['ecard_recipient']."	".$lang_db_ecard_php['ecard_date']."
".$lang_db_ecard_php['ecard_name']."	".$lang_db_ecard_php['ecard_email']."	".$lang_db_ecard_php['ecard_ip']."	".$lang_db_ecard_php['ecard_name']."	".$lang_db_ecard_php['ecard_email']."
	'; print ' '; print ''; print '			'; print ' '; print ''.$lang_db_ecard_php['ecards_delete_sure']; print '