query("DELETE FROM ".$xoopsDB->prefix("xcgal_ecard")." WHERE e_id = '".$e_id."'"); } } $card_per_page= 25; $delete_time = time() - ($xoopsModuleConfig['ecards_saved_db'] * 86400); $xoopsDB->queryf("DELETE from ".$xoopsDB->prefix("xcgal_ecard")." WHERE s_time < ".$delete_time.""); if(isset($HTTP_POST_VARS['card_action'])){ if ($HTTP_POST_VARS['card_action'] == 1){ if (isset($HTTP_POST_VARS['ecard']) && is_array($HTTP_POST_VARS['ecard'])){ $ecard_array = &$HTTP_POST_VARS['ecard']; delete_cards($ecard_array); } } elseif ($HTTP_POST_VARS['card_action'] == 2){ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("xcgal_ecard").""); } elseif ($HTTP_POST_VARS['card_action'] == 3){ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("xcgal_ecard")." WHERE picked=1"); } elseif ($HTTP_POST_VARS['card_action'] == 4){ $xoopsDB->query("DELETE FROM ".$xoopsDB->prefix("xcgal_ecard")." WHERE picked=0"); } } $tab_tmpl = array( 'left_text' => ''._AM_CARDMGR_CONPAGE.''."\n", 'tab_header' => '', 'tab_trailer' => '', 'active_tab' => ''."\n".'%d', 'inactive_tab' => ''."\n".'%d'."\n" ); $page = isset($HTTP_GET_VARS['page']) ? (int)$HTTP_GET_VARS['page'] : 1; $lower_limit = ($page-1) * $card_per_page; $result=$xoopsDB->query("SELECT count(*) FROM ".$xoopsDB->prefix("xcgal_ecard")." WHERE 1"); $nbEnr = $xoopsDB->fetchArray($result); $card_count = $nbEnr['count(*)']; $xoopsDB->freeRecordSet($result); $total_pages = ceil($card_count / $card_per_page); $tabs = create_tabs($card_count, $page, $total_pages, $tab_tmpl); $result=$xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("xcgal_ecard")." ORDER BY s_time DESC LIMIT $lower_limit, $card_per_page"); xoops_cp_header(); echo "

"; echo ""; echo ""; $tdstyle ="even"; $user_handler =& xoops_gethandler('member'); while($row = $xoopsDB->fetchArray($result)){ if ($tdstyle== "even") $tdstyle = "odd"; else $tdstyle = "even"; echo ""; if ($row['sender_uid']> 0 ){ $sender =& $user_handler->getUser($row['sender_uid']); echo ""; } else echo ""; echo ""; echo ""; if ($row['picked'] == 0) $picked = _NO; else $picked = _YES; echo ""; } echo ""; echo "

"._AM_CARDMGR_TITLE."
	"._AM_CARDMGR_TIME."	"._AM_CARDMGR_SUNAME."	"._AM_CARDMGR_SEMAIL."	"._AM_CARDMGR_SIP."	"._AM_CARDMGR_PID."	"._AM_CARDMGR_STATUS."
	".formatTimestamp($row['s_time'],'m')."	".$sender->uname()."	".$xoopsConfig['anonymous']."	".$row['sender_email']."	".$row['sender_ip']."	".$row['pid']."	$picked
$tabs

"; echo ""; echo ""; echo "

"; echo ""._AM_CARDMGR_DEL_SELECTED.""; echo ""._AM_CARDMGR_DEL_ALL.""; echo ""._AM_CARDMGR_DEL_PICKED.""; echo ""._AM_CARDMGR_DEL_UNPICKED.""; echo ""; echo "

"; echo "

"; xoops_cp_footer(); ?>