queryf("DELETE from ".$xoopsDB->prefix("xcgal_ecard")." WHERE s_time < ".$delete_time.""); $result = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("xcgal_ecard")." as e, ".$xoopsDB->prefix("xcgal_pictures")." as p WHERE e_id ='".$data."' AND e.pid=p.pid"); if (!$xoopsDB->getRowsNum($result)) redirect_header('index.php',2,"Sorry, can't find e-card!"); else $row = $xoopsDB->fetchArray($result); if ($xoopsModuleConfig['make_intermediate'] && max($row['pwidth'], $row['pheight']) > $xoopsModuleConfig['picture_width']) { $n_picname = get_pic_url($row, 'normal'); } else { $n_picname = get_pic_url($row, 'fullsize'); } $msg_content = $myts->makeTareaData4Show($row['message'],0); if(!stristr($n_picname, 'http:')) $n_picname = XOOPS_URL."/modules/xcgal/".$n_picname; require_once XOOPS_ROOT_PATH.'/class/template.php'; $xoopsTpl = new XoopsTpl(); $xoopsTpl->assign('sitename', $xoopsConfig['sitename']); $xoopsTpl->assign('ecard_title', sprintf(_MD_CARD_ECARD_TITLE, $myts->makeTboxData4Show($row['sender_name']))); $xoopsTpl->assign('charset',_CHARSET); $xoopsTpl->assign('view_ecard_tgt', 0); $xoopsTpl->assign('view_ecard_lnk',_MD_CARD_VIEW_ECARD); $xoopsTpl->assign('pic_url',$n_picname); //$xoopsTpl->assign('url_prefix',$gallery_url_prefix); $xoopsTpl->assign('greetings',$row['greetings']); $xoopsTpl->assign('message',$msg_content); $xoopsTpl->assign('sender_email',$myts->makeTboxData4Show($row['sender_email'])); $xoopsTpl->assign('sender_name',$myts->makeTboxData4Show($row['sender_name'])); $xoopsTpl->assign('view_more_tgt',$xoopsModuleConfig['ecards_more_pic_target']); $xoopsTpl->assign('view_more_lnk', _MD_CARD_VIEW_MORE_PICS); $xoopsTpl->display('db:xcgal_discard.html'); $xoopsDB->queryf("UPDATE ".$xoopsDB->prefix("xcgal_ecard")." SET picked=1 WHERE e_id='".$data."'"); exit(); ?>