function smartsection_items_recent_show($options)
{
include_once XOOPS_ROOT_PATH . "/modules/smartsection/include/common.php";
$myts =& MyTextSanitizer::getInstance();
$smartModule =& smartsection_getModuleInfo();
$block = array();
$selectedcatids = explode(',', $options[0]);
if (in_array(0, $selectedcatids)) {
$allcats = true;
} else {
$allcats = false;
}
$sort = $options[1];
$order = smartsection_getOrderBy($sort);
$limit = $options[2];
$smartsection_item_handler =& smartsection_gethandler('item');
// creating the ITEM objects that belong to the selected category
if ($allcats) {
$criteria = null;
} else {
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('categoryid', '(' . $options[0] . ')', 'IN'));
}
$itemsObj = $smartsection_item_handler->getItems($limit, $start, array(_SSECTION_STATUS_PUBLISHED), -1, $sort, $order, '', true, $criteria, true);
$totalItems = count($itemsObj);
if ($itemsObj) {
for ($i = 0; $i < $totalItems; $i++) {
$newItems['itemid'] = $itemsObj[$i]->itemid();
$newItems['title'] = $itemsObj[$i]->title();
$newItems['categoryname'] = $itemsObj[$i]->getCategoryName();
$newItems['categoryid'] = $itemsObj[$i]->categoryid();
$newItems['date'] = $itemsObj[$i]->datesub();
$newItems['poster'] = xoops_getLinkedUnameFromId($itemsObj[$i]->uid());
$newItems['itemlink'] = $itemsObj[$i]->getItemLink(false, isset($options[3]) ? $options[3] : 65);
$newItems['categorylink'] = $itemsObj[$i]->getCategoryLink();
$block['items'][] = $newItems;
}
$block['lang_title'] = _MB_SSECTION_ITEMS;
$block['lang_category'] = _MB_SSECTION_CATEGORY;
$block['lang_poster'] = _MB_SSECTION_POSTEDBY;
$block['lang_date'] = _MB_SSECTION_DATE;
$modulename = $myts->makeTboxData4Show($smartModule->getVar('name'));
$block['lang_visitItem'] = _MB_SSECTION_VISITITEM . " " . $modulename;
}
return $block;
}
function smartsection_date_to_date_show($options)
{
include_once XOOPS_ROOT_PATH . "/modules/smartsection/include/common.php";
$myts =& MyTextSanitizer::getInstance();
$smartModule =& smartsection_getModuleInfo();
$block = array();
$fromArray = explode('/', $options[0]);
//month, day, year
$fromStamp = mktime(0, 0, 0, $fromArray[0], $fromArray[1], $fromArray[2]);
$untilArray = explode('/', $options[1]);
$untilStamp = mktime(0, 0, 0, $untilArray[0], $untilArray[1], $untilArray[2]);
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('datesub', $fromStamp, '>'));
$criteria->add(new Criteria('datesub', $untilStamp, '<'));
$criteria->setSort('datesub');
$criteria->setOrder('DESC');
$smartsection_item_handler =& smartsection_gethandler('item');
// creating the ITEM objects that belong to the selected category
$itemsObj = $smartsection_item_handler->getObjects($criteria);
$totalItems = count($itemsObj);
if ($itemsObj) {
for ($i = 0; $i < $totalItems; $i++) {
$newItems['itemid'] = $itemsObj[$i]->itemid();
$newItems['title'] = $itemsObj[$i]->title();
$newItems['categoryname'] = $itemsObj[$i]->getCategoryName();
$newItems['categoryid'] = $itemsObj[$i]->categoryid();
$newItems['date'] = $itemsObj[$i]->datesub();
$newItems['poster'] = xoops_getLinkedUnameFromId($itemsObj[$i]->uid());
$newItems['itemlink'] = $itemsObj[$i]->getItemLink(false, isset($options[3]) ? $options[3] : 65);
$newItems['categorylink'] = $itemsObj[$i]->getCategoryLink();
$block['items'][] = $newItems;
}
$block['lang_title'] = _MB_SSECTION_ITEMS;
$block['lang_category'] = _MB_SSECTION_CATEGORY;
$block['lang_poster'] = _MB_SSECTION_POSTEDBY;
$block['lang_date'] = _MB_SSECTION_DATE;
$modulename = $myts->makeTboxData4Show($smartModule->getVar('name'));
$block['lang_visitItem'] = _MB_SSECTION_VISITITEM . " " . $modulename;
$block['lang_articles_from_to'] = sprintf(_MB_SSECTION_ARTICLES_FROM_TO, $options[0], $options[1]);
}
return $block;
}
/**
* $Id: items_recent.php,v 1.2 2005/08/02 03:47:51 mauriciodelima Exp $
* Module: SmartSection
* Author: The SmartFactory <www.smartfactory.ca>
* Licence: GNU
*/
function b_items_recent_show($options)
{
include_once XOOPS_ROOT_PATH . "/modules/smartsection/include/common.php";
$myts =& MyTextSanitizer::getInstance();
$smartModule =& ss_getModuleInfo();
$block = array();
if ($options[0] == 0) {
$categoryid = -1;
} else {
$categoryid = $options[0];
}
$sort = $options[1];
$order = smartsection_getOrderBy($sort);
$limit = $options[2];
$smartsection_item_handler =& ss_gethandler('item');
// creating the ITEM objects that belong to the selected category
$itemsObj = $smartsection_item_handler->getAllPublished($limit, 0, $categoryid, $sort, $order);
$totalItems = count($itemsObj);
if ($itemsObj) {
for ($i = 0; $i < $totalItems; $i++) {
$newItems['itemid'] = $itemsObj[$i]->itemid();
$newItems['title'] = $itemsObj[$i]->title();
$newItems['categoryname'] = $itemsObj[$i]->getCategoryName();
$newItems['categoryid'] = $itemsObj[$i]->categoryid();
$newItems['date'] = $itemsObj[$i]->datesub();
$newItems['poster'] = xoops_getLinkedUnameFromId($itemsObj[$i]->uid());
$block['items'][] = $newItems;
}
$block['lang_title'] = _MB_SS_ITEMS;
$block['lang_category'] = _MB_SS_CATEGORY;
$block['lang_poster'] = _MB_SS_POSTEDBY;
$block['lang_date'] = _MB_SS_DATE;
$modulename = $myts->makeTboxData4Show($smartModule->getVar('name'));
$block['lang_visitItem'] = _MB_SS_VISITITEM . " " . $modulename;
}
return $block;
}
function b_marquee_smartsection($limit, $dateformat, $itemssize)
{
include_once XOOPS_ROOT_PATH . '/modules/smartsection/include/common.php';
$myts =& MyTextSanitizer::getInstance();
$smartModule =& smartsection_getModuleInfo();
$block = array();
$categoryid = -1;
$sort = 'datesub';
$order = smartsection_getOrderBy($sort);
$smartsection_item_handler =& smartsection_gethandler('item');
$itemsObj = $smartsection_item_handler->getAllPublished($limit, 0, $categoryid, $sort, $order);
$totalItems = count($itemsObj);
if ($itemsObj) {
for ($i = 0; $i < $totalItems; $i++) {
if ($itemssize > 0) {
$title = xoops_substr($itemsObj[$i]->title(), 0, $itemssize + 3);
} else {
$title = $itemsObj[$i]->title();
}
$block[] = array('date' => $itemsObj[$i]->datesub(), 'category' => $itemsObj[$i]->getCategoryName(), 'author' => xoops_getLinkedUnameFromId($itemsObj[$i]->uid()), 'title' => $title, 'link' => "<a href='" . XOOPS_URL . '/modules/smartsection/item.php?itemid=' . $itemsObj[$i]->itemid() . "'>" . $title . '</a>');
}
}
return $block;
}
function entryEdit( $entryID = '' )
{
global $xoopsUser,$xoopsConfig,$xoopsModuleConfig,$mydirname,$MYDIRNAME,$spaw_root,$cat_table,$ent_table,$xoopsGTicket;
$xoopsDB =& Database::getInstance();
$xoopsModule = XoopsModule::getByDirname("$mydirname");
$myts =& MyTextSanitizer::getInstance();
$op = 'default';
if ( !empty( $_GET['op'] ) ) $op = trim($_GET['op']);
if ( !empty( $_POST['op'] ) ) $op = trim($_POST['op']);
$entryID = !empty( $_GET['entryID'] ) ? intval($_GET['entryID']) : '';
/**
* Clear all variables before we start
*/
if(!isset($block)) { $block = 0; }
if(!isset($html)) { $html = 0; }
if(!isset($smiley)) { $smiley = 0; }
if(!isset($xcodes)) { $xcodes = 0; }
if(!isset($breaks)) { $breaks = 0; }
if(!isset($offline)) { $offline = 0; }
if(!isset($submit)) { $submit = 0; }
if(!isset($request)) { $request = 0; }
if(!isset($notifypub)) { $notifypub = 0; }
if(!isset($categoryID)) { $categoryID = 0; }
if(!isset($term)) { $term = ""; }
if(!isset($proc)) { $proc = ""; }
if(!isset($definition))
{
$definition = constant("_AM_{$MYDIRNAME}_WRITEHERE");
}
if(!isset($ref)) { $ref = ""; }
if(!isset($url)) { $url = ""; }
if(!isset($renewdate)) { $renewdate = 0; }
if(!isset($datesub)) { $datesub = 0; }
// If there is a parameter, and the id exists, retrieve data: were editing an entry
if ( $entryID > 0 )
{
$result = $xoopsDB -> query( "SELECT categoryID, term, proc, definition, ref, url, uid, submit, datesub, html, smiley, xcodes, breaks, block, offline, notifypub, request FROM $ent_table WHERE entryID = '$entryID'" );
list( $categoryID, $term, $proc, $definition, $ref, $url, $uid, $submit, $datesub, $html, $smiley, $xcodes, $breaks, $block, $offline, $notifypub, $request ) = $xoopsDB -> fetchrow( $result );
if ( !$xoopsDB -> getRowsNum( $result ) )
{
redirect_header( "index.php", 1, constant("_AM_{$MYDIRNAME}_NOENTRYTOEDIT") );
}
$term = $myts -> htmlspecialchars($term);
if ($proc)
{
list($temp,$proc) = explode(",",$proc);
}
$proc = $myts -> htmlSpecialChars($proc);
$ref = $myts -> htmlSpecialChars($ref);
$url = $myts -> htmlSpecialChars($url);
$datesub = intval( $datesub );
$block = intval( $block );
$html = intval( $html );
$smiley = intval( $smiley );
$xcodes = intval( $xcodes );
$breaks = intval( $breaks );
$notifypub = intval( $notifypub );
xoops_cp_header();
adminMenu(2, constant("_AM_{$MYDIRNAME}_ENTRIES")." » ".constant("_AM_{$MYDIRNAME}_MODIFY"));
include('./mymenu.php');
echo "<fieldset style='margin:1em 0em 0em 0em;border:1px solid #778;'><legend style='font-weight: bold; color: #900;'>" . constant("_AM_{$MYDIRNAME}_ENTRIES") . "</legend><br />\n";
$sform = new XoopsThemeForm( constant("_AM_{$MYDIRNAME}_MODENTRY") . ": " .$myts -> htmlSpecialChars($term) , "op", xoops_getenv( 'PHP_SELF' ) );
}
else // there's no parameter, so we're adding an entry
{
$result01 = $xoopsDB -> query( "SELECT COUNT(*) FROM $cat_table" );
list( $totalcats ) = $xoopsDB -> fetchRow( $result01 );
if ( $totalcats == 0 && $xoopsModuleConfig['multicats'] == 1 )
{
redirect_header( "index.php", 1, constant("_AM_{$MYDIRNAME}_NEEDONECOLUMN") );
}
xoops_cp_header();
adminMenu(2, constant("_AM_{$MYDIRNAME}_ENTRIES")." » ".constant("_AM_{$MYDIRNAME}_ADMINENTRYMNGMT"));
include('./mymenu.php');
echo "<fieldset style='margin:1em 0em 0em 0em;border:1px solid #778;'><legend style='font-weight: bold; color: #900;'>" . constant("_AM_{$MYDIRNAME}_ENTRIES") . "</legend><br />\n";
$uid = $xoopsUser->getVar('uid');
$sform = new XoopsThemeForm( constant("_AM_{$MYDIRNAME}_NEWENTRY"), "op", xoops_getenv( 'PHP_SELF' ) );
$html = $smiley = $xcodes = $breaks = 1;
}
$sform -> setExtra( 'enctype="multipart/form-data"' );
// Author selector
ob_start();
echo xoops_getLinkedUnameFromId( intval($uid) );
$sform -> addElement( new XoopsFormLabel( constant("_AM_{$MYDIRNAME}_AUTHOR"), ob_get_contents() ) );
ob_end_clean();
// Category selector
if ($xoopsModuleConfig['multicats'] == 1)
{
$mytree = new XoopsTree( $cat_table, "categoryID" , "0" );
ob_start();
//okino $sform -> addElement( new XoopsFormHidden( 'categoryID', intval($categoryID) ) );
$mytree -> makeMySelBox( "name", "weight", $categoryID );
$sform -> addElement( new XoopsFormLabel( constant("_AM_{$MYDIRNAME}_CATNAME"), ob_get_contents() ) );
ob_end_clean();
}
// Term, definition, reference and related URL
$sform -> addElement( new XoopsFormText( constant("_AM_{$MYDIRNAME}_ENTRYTERM"), 'term', 50, 80, $term), true );
$sform -> addElement( new XoopsFormText( constant("_AM_{$MYDIRNAME}_ENTRYPROC"), 'proc', 50, 80, $proc), true );
if( !empty( $_GET['usespaw'] ) && $spaw_root )
{
// SPAW Config
include_once $spaw_root."spaw_control.class.php";
ob_start() ;
$sw = new SPAW_Wysiwyg( 'definition', $definition, _LANGCODE, 'full', 'default', '100%', '400px' );
$def_block = new XoopsFormLabel( constant("_AM_{$MYDIRNAME}_ENTRYDEF")."[<a href=\"".xoops_getenv( 'PHP_SELF')."?op=$op&entryID=$entryID\" title=\"".constant("_AM_{$MYDIRNAME}_BB")."\">".constant("_AM_{$MYDIRNAME}_SPAWTOBB")."</a>]" , $sw->getHtml() ) ;
ob_end_clean() ;
}
elseif( $spaw_root )
{
$def_block = new XoopsFormDhtmlTextArea( constant("_AM_{$MYDIRNAME}_ENTRYDEF")."[<a href=\"".xoops_getenv( 'PHP_SELF')."?op=$op&entryID=$entryID&usespaw=1\" title=\"".constant("_AM_{$MYDIRNAME}_SPAW")."\">".constant("_AM_{$MYDIRNAME}_BBTOSPAW")."</a>]", 'definition', $myts -> htmlSpecialChars($definition), 15, 60 );
}
else
{
$def_block = new XoopsFormDhtmlTextArea( constant("_AM_{$MYDIRNAME}_ENTRYDEF"), 'definition', $myts -> htmlSpecialChars($definition), 15, 60 );
}
if ($definition == constant("_AM_{$MYDIRNAME}_WRITEHERE"))
{
$def_block -> setExtra( 'onfocus="this.select()"' );
}
$sform -> addElement ( $def_block );
if ($xoopsModuleConfig['allowedtypes'])
{
$butt_upfile = new XoopsFormButton( constant("_AM_{$MYDIRNAME}_UPFILES"), '', constant("_AM_{$MYDIRNAME}_UPLOADOPEN"), 'button' );
$butt_upfile->setExtra('onclick="window.open (\'upload.php\', \'wbupload\', \'width=550,height=360,location=0,menubar=0,resizable=1,scrollbars=yes,status=1,toolbar=0\')"');
$sform->addElement( $butt_upfile );
}
$sform -> addElement( new XoopsFormTextArea( constant("_AM_{$MYDIRNAME}_ENTRYREFERENCE"), 'ref', $ref, 5, 60 ), false );
$sform -> addElement( new XoopsFormText( constant("_AM_{$MYDIRNAME}_ENTRYURL"), 'url', 50, 80, $url ), false );
// Code to take entry offline, for maintenance purposes
$offline_radio = new XoopsFormRadioYN(constant("_AM_{$MYDIRNAME}_SWITCHOFFLINE"), 'offline', intval($offline), ' '.constant("_AM_{$MYDIRNAME}_YES").'', ' '.constant("_AM_{$MYDIRNAME}_NO").'');
$sform -> addElement($offline_radio);
// Code to put entry in block
// $block_radio = new XoopsFormRadioYN( _AM_XWORDS_BLOCK, 'block', $block , ' ' . _AM_XWORDS_YES . '', ' ' . _AM_XWORDS_NO . '' );
// $sform -> addElement( $block_radio );
if ( $entryID > 0)
{
$renewdate_checkbox = new XoopsFormCheckBox( constant("_AM_{$MYDIRNAME}_ENTRYCREATED")."<br /><span style='font-size: xx-small; font-weight: normal;'>(".constant("_AM_{$MYDIRNAME}_RENEWDATE_DEFAULT").formatTimestamp($datesub).")</span>", 'renewdate', $renewdate );
$renewdate_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_RENEWDATE")."<br />".getSetTimeForm($datesub) );
}
else
{
$renewdate_checkbox = new XoopsFormCheckBox( constant("_AM_{$MYDIRNAME}_ENTRYCREATED")."<br /><span style='font-size: xx-small; font-weight: normal;'>(".constant("_AM_{$MYDIRNAME}_RENEWDATE_DEFAULT").formatTimestamp(time()).")</span>", 'renewdate', $renewdate );
$renewdate_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_SETNEWDATE")."<br />".getSetTimeForm(time()) );
}
$sform -> addElement( $renewdate_checkbox );
// VARIOUS OPTIONS
$options_tray = new XoopsFormElementTray(constant("_AM_{$MYDIRNAME}_OPTIONS"),'<br />');
$html_checkbox = new XoopsFormCheckBox( '', 'html', intval($html) );
$html_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_DOHTML") );
$options_tray -> addElement( $html_checkbox );
$smiley_checkbox = new XoopsFormCheckBox( '', 'smiley', intval($smiley) );
$smiley_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_DOSMILEY") );
$options_tray -> addElement( $smiley_checkbox );
$xcodes_checkbox = new XoopsFormCheckBox( '', 'xcodes', intval($xcodes) );
$xcodes_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_DOXCODE") );
$options_tray -> addElement( $xcodes_checkbox );
$breaks_checkbox = new XoopsFormCheckBox( '', 'breaks', intval($breaks) );
$breaks_checkbox -> addOption( 1, constant("_AM_{$MYDIRNAME}_BREAKS") );
$options_tray -> addElement( $breaks_checkbox );
$sform -> addElement( $options_tray );
$button_tray = new XoopsFormElementTray( '', '' );
$hidden = new XoopsFormHidden( 'op', 'addentry' );
$button_tray -> addElement( $hidden );
$hidden_date = new XoopsFormHidden( 'datesub', $datesub );
$button_tray -> addElement( $hidden_date );
$hidden_id = new XoopsFormHidden( 'entryID', $entryID );
$button_tray -> addElement( $hidden_id );
$hidden_uid = new XoopsFormHidden( 'uid', $uid );
$button_tray -> addElement( $hidden_uid );
$hidden_block = new XoopsFormHidden( 'block', $block );
$button_tray -> addElement( $hidden_block );
if ( !$entryID)
{
$hidden_renewdate = new XoopsFormHidden( 'renewdate', 1 );
$button_tray -> addElement( $hidden_renewdate );
}
//PREVIEW(ver0.31)
$butt_preview = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_PREVIEWOPEN"), 'button' );
$butt_preview->setExtra('onclick="document.op.action=\'../preview.php\';document.op.target=\'_blank\';document.op.submit();"');
$button_tray->addElement( $butt_preview );
if ( !$entryID ) // therez no entryID? Then its a new entry
{
$butt_create = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_CREATE"), 'submit' );
$butt_create->setExtra('onclick="document.op.action=\'./entry.php\';document.op.target=\'_self\';this.form.elements.op.value=\'addentry\'"');
$button_tray->addElement( $butt_create );
$butt_clear = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_CLEAR"), 'reset' );
$button_tray->addElement( $butt_clear );
$butt_cancel = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_CANCEL"), 'button' );
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement( $butt_cancel );
}
else // else, were editing an existing entry
{
$butt_create = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_MODIFY"), 'submit' );
$butt_create->setExtra('onclick="document.op.action=\'./entry.php\';document.op.target=\'_self\';this.form.elements.op.value=\'addentry\'"');
$button_tray->addElement( $butt_create );
$butt_cancel = new XoopsFormButton( '', '', constant("_AM_{$MYDIRNAME}_CANCEL"), 'button' );
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement( $butt_cancel );
}
$button_tray->addElement( $xoopsGTicket->getTicketXoopsForm( __LINE__ ) );//GIJ
$sform -> addElement( $button_tray );
$sform -> display();
unset( $hidden );
echo "</fieldset>\n";
xoops_cp_footer();
}
$breadcrumbs->set(_MD_CCENTER_RECEPTION, "reception.php");
if ($xoopsDB->getRowsNum($res) > 1) {
include XOOPS_ROOT_PATH . "/header.php";
$xoopsOption['template_main'] = "ccenter_reception.html";
$breadcrumbs->assign();
$forms = array();
$member_handler =& xoops_gethandler('member');
$groups = $member_handler->getGroupList(new Criteria('groupid', XOOPS_GROUP_ANONYMOUS, '!='));
while ($form = $xoopsDB->fetchArray($res)) {
$form['title'] = htmlspecialchars($form['title']);
$form['ltime'] = $form['ltime'] ? formatTimestamp($form['ltime']) : "";
if ($form['priuid']) {
if ($form['priuid'] < 0) {
$form['contact'] = '[' . $groups[-$form['priuid']] . ']';
} else {
$form['contact'] = xoops_getLinkedUnameFromId($form['priuid']);
}
} elseif ($form['cgroup']) {
$form['contact'] = '[' . $groups[$form['cgroup']] . ']';
} else {
$form['contact'] = _MD_CONTACT_NOTYET;
}
$forms[] = $form;
}
$xoopsTpl->assign('forms', $forms);
include XOOPS_ROOT_PATH . "/footer.php";
exit;
}
// check access permition
$form = $xoopsDB->fetchArray($res);
if (!cc_check_perm($form)) {
}
// recording contactee access time
$now = time();
if ($uid == $data['uid'] && $now > $data['atime']) {
$xoopsDB->queryF("UPDATE " . CCMES . " SET atime={$now} WHERE msgid={$msgid}");
}
include XOOPS_ROOT_PATH . "/header.php";
$breadcrumbs = new XoopsBreadcrumbs(_MD_CCENTER_RECEPTION, 'reception.php');
$pass = isset($_GET['p']) ? $_GET['p'] : '';
$add = $pass ? "p=" . urlencode($pass) : "";
$to_uname = XoopsUser::getUnameFromId($data['touid']);
$res = $xoopsDB->query("SELECT * FROM " . FORMS . " WHERE formid=" . $data['fidref']);
$form = $xoopsDB->fetchArray($res);
$items = get_form_attribute($form['defs']);
$raws = unserialize_text($data['body']);
$values = cc_display_values($raws, $items, $data['msgid'], $add);
$data['comment'] = $myts->displayTarea($data['comment']);
$isadmin = $uid && $xoopsUser->isAdmin($xoopsModule->getVar('mid'));
$title = $data['title'];
if ($isadmin) {
$breadcrumbs->set($title, "reception.php?form=" . $data['fidref']);
} else {
$breadcrumbs->set($title, "index.php?form=" . $data['fidref']);
}
list($lab) = array_keys($raws);
$breadcrumbs->set($lab . ': ' . $raws[$lab], '');
$breadcrumbs->assign();
$has_mail = !empty($data['email']);
$xoopsTpl->assign(array('subject' => $title, 'sender' => xoops_getLinkedUnameFromId($data['uid']), 'sendto' => $data['touid'] ? xoops_getLinkedUnameFromId($data['touid']) : _MD_CONTACT_NOTYET, 'cdate' => formatTimestamp($data['ctime']), 'mdate' => myTimestamp($data['mtime'], 'l', _MD_TIME_UNIT), 'adate' => myTimestamp($data['atime'], 'l', _MD_TIME_UNIT), 'readit' => $data['atime'] >= $data['mtime'], 'data' => $data, 'items' => $values, 'status' => $msg_status[$data['status']], 'is_eval' => is_cc_evaluate($msgid, $uid, $pass), 'is_mine' => $data['touid'] == $uid, 'is_getmine' => $data['touid'] == 0 && $uid && in_array($data['cgroup'], $xoopsUser->getGroups()), 'own_status' => array_slice($msg_status, 1, $isadmin ? 4 : 3), 'xoops_pagetitle' => htmlspecialchars($xoopsModule->getVar('name') . " | " . $data['title']), 'has_mail' => $has_mail));
include XOOPS_ROOT_PATH . '/include/comment_view.php';
include XOOPS_ROOT_PATH . "/footer.php";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_SUBMITTER") . "</b></td>";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYCREATED") . "</b></td>";
echo "<td width='60' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ACTION") . "</b></td>";
echo "</tr>";
$resultS1 = $xoopsDB -> query("SELECT COUNT(*) FROM $ent_table WHERE offline = '1'");
list( $numrows ) = $xoopsDB -> fetchRow( $resultS1 );
if ( $numrows > 0 ) // That is, if there ARE submitted entries in the system
{
$sql = "SELECT e.entryID, e.categoryID, e.term, e.uid, e.datesub, c.name FROM $ent_table e LEFT JOIN $cat_table c ON e.categoryID = c.categoryID WHERE offline = '1' ORDER BY datesub DESC";
$resultS2 = $xoopsDB -> query( $sql, $xoopsModuleConfig['perpage'], $startsub );
while ( list( $entryID, $categoryID, $term, $uid, $created, $name ) = $xoopsDB -> fetchrow( $resultS2 ) )
{
$sentby = xoops_getLinkedUnameFromId(intval($uid));
$entryID = intval($entryID);
$categoryID = intval($categoryID);
$catname = $myts -> htmlSpecialChars( $name );
$term = $myts -> htmlSpecialChars( $term );
$created = formatTimestamp( $created, 's' );
$modify = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/entry.php?op=mod&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/edit.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_EDITSUBM")."' /></a>";
$delete = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/entry.php?op=del&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/delete.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_DELETESUBM")."' /></a>";
echo "<tr>";
echo "<td class='head' align='center'> $entryID </td>";
if ($xoopsModuleConfig['multicats'] == 1)
{
echo "<td class='even' align='left'> $catname </td>";
}
echo "<td class='even' align='left'> $term </td>";
echo "<td class='even' align='center'> $sentby </td>";
function cc_message_entry($data, $link = "message.php")
{
global $msg_status;
$id = $data['msgid'];
return array('msgid' => $id, 'mdate' => myTimestamp($data['mtime'], 'm', _MD_TIME_UNIT), 'title' => "<a href='message.php?id={$id}'>" . $data['title'] . "</a>", 'uname' => xoops_getLinkedUnameFromId($data['uid']), 'status' => $msg_status[$data['status']], 'raw' => $data);
}
if (isset($_GET['m'])) {
$month = intval($_GET['m']);
}
if (isset($_GET['d'])) {
$day = intval($_GET['d']);
}
if (!isset($_GET['m']) && !isset($_GET['d']) && $day < $bdef) {
$month--;
}
if (!isset($_GET['d']) && time() < mktime($hour, $min)) {
$day--;
}
include XOOPS_ROOT_PATH . '/header.php';
$xoopsOption['template_main'] = 'logtick_summary.html';
if (preg_match('/^\\d+$/', $uid)) {
$title = sprintf(_MD_LOGTICK_SUMMARY, xoops_getLinkedUnameFromId($uid));
} else {
$title = _MD_LOGTICK_SUM;
}
set_logtick_breadcrumbs(array(strip_tags($title) => 'summary.php'));
$xoopsTpl->assign('title', $title);
$sums = array();
get_summary($sums, $uid);
$labs = array(_MD_SUM_TOTAL);
if (is_numeric($uid)) {
$cond = "luid={$uid}";
} elseif (preg_match('/^\\d+(,\\d+)+$/', $uid)) {
$cond = "luid IN ({$uid})";
} else {
$cond = "1";
}
if (!empty($bu) && preg_match("/" . $bu . "/i", $uname)) {
$errors[] .= _US_NAMERESERVED . "<br />";
break;
}
}
$count = 0;
if ($uname) {
$sql = sprintf('SELECT COUNT(*) FROM %s WHERE uname = %s', icms::$xoopsDB->prefix('users'), icms::$xoopsDB->quoteString(addslashes($uname)));
$result = icms::$xoopsDB->query($sql);
list($count) = icms::$xoopsDB->fetchRow($result);
if ($count > 1) {
$errors[] .= _US_NICKNAMETAKEN . "<br />";
}
}
}
$username = xoops_getLinkedUnameFromId($uid);
$password = $oldpass = '';
if (!empty($_POST['password'])) {
$password = icms_core_DataFilter::stripSlashesGPC(trim($_POST['password']));
$oldpass = !empty($_POST['old_password']) ? icms_core_DataFilter::stripSlashesGPC(trim($_POST['old_password'])) : '';
}
if ($password !== '' && $_POST['change_pass'] == 1) {
$member_handler = icms::handler('icms_member');
if (!$member_handler->loginUser(addslashes($uname), addslashes($oldpass))) {
$errors[] = _US_BADPWD;
}
if (strlen($password) < $icmsConfigUser['minpass']) {
$errors[] = sprintf(_US_PWDTOOSHORT, $icmsConfigUser['minpass']);
}
$vpass = '';
if (!empty($_POST['vpass'])) {
list($temp,$proc) = explode(",",$proc);
}
$thisterm['proc'] = $myts -> makeTboxData4Show( $proc );
if ( !$xoopsModuleConfig['linktermsposition'] )
{
$thisterm['definition'] = $myts->displayTarea( $definition, intval($html), intval($smiley), intval($xcodes), 1, intval($breaks) );
$thisterm['linkedterms'] = $myts->getAutoLinkTerms( $definition, intval($html), $mydirname, $entryID, 0 );
}
else
{
$thisterm['definition'] = $myts->displayTarea( $definition, intval($html), intval($smiley), intval($xcodes), 1, intval($breaks), $mydirname, $entryID );
}
$thisterm['ref'] = $myts -> makeTboxData4Show( $ref );
$thisterm['url'] = $myts->makeClickable(formatURL($url), $allowimage = 0);
$thisterm['submitter'] = xoops_getLinkedUnameFromId ( intval($uid) );
if ( $xoopsModuleConfig['strfformat'] )
{
$thisterm['datesub'] = $myts->makeTboxData4Show(formatTimestamp(xoops_getUserTimestamp(intval($datesub)), $xoopsModuleConfig['strfformat']));
}
else
{
$thisterm['datesub'] = formatTimestampJ(xoops_getUserTimestamp(intval($datesub)));
}
$thisterm['counter'] = intval($counter);
$thisterm['block'] = intval($block);
$thisterm['notifypub'] = intval($notifypub);
$thisterm['dir'] = $xoopsModule->dirname();
if ( $xoopsModuleConfig['multicats'] == 1 )
{
function entryz()
{
include_once( XOOPS_ROOT_PATH . '/class/pagenav.php' );
global $cat_table,$ent_table,$xoopsConfig,$xoopsModuleConfig,$xoopsModule,$MYDIRNAME;
$xoopsDB =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$startsub = !empty( $_GET['startsub'] ) ? intval( $_GET['startsub'] ) : 0;
$entryID = !empty( $_GET['entryID'] ) ? intval($_GET['entryID']) : 0;
xoops_cp_header();
adminMenu(0, constant("_AM_{$MYDIRNAME}_AUTHORIZE"));
include('./mymenu.php');
/* -- Code to show submitted entries -- */
echo "<fieldset style='margin:1em 0em 0em 0em;border:1px solid #778;'><legend style='font-weight: bold; color: #900;'>" . constant("_AM_{$MYDIRNAME}_SHOWSUBMISSIONS") . "</legend><br />";
echo "<table width='100%' cellspacing='1' cellpadding='3' border='0' class='outer'>";
echo "<tr>";
echo "<td width='40' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYID") . "</b></td>";
if ($xoopsModuleConfig['multicats'] == 1)
{
echo "<td width='20%' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYCATNAME") . "</b></td>";
$colspan = 6;
}
else
{
$colspan = 5;
}
echo "<td class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYTERM") . "</b></td>";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_SUBMITTER") . "</b></td>";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYCREATED") . "</b></td>";
echo "<td width='60' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ACTION") . "</b></td>";
echo "</tr>";
$resultS1 = $xoopsDB -> query("SELECT COUNT(*) FROM $ent_table WHERE submit = '1'");
list( $numrows ) = $xoopsDB -> fetchRow( $resultS1 );
if ( $numrows > 0 ) // That is, if there ARE submitted entries in the system
{
$sql = "SELECT e.entryID, e.categoryID, e.term, e.uid, e.datesub, c.name FROM $ent_table e LEFT JOIN $cat_table c ON e.categoryID = c.categoryID WHERE submit = '1' ORDER BY datesub DESC";
$resultS2 = $xoopsDB -> query( $sql, $xoopsModuleConfig['perpage'], $startsub );
while ( list( $entryID, $categoryID, $term, $uid, $created, $name ) = $xoopsDB -> fetchrow( $resultS2 ) )
{
$sentby = xoops_getLinkedUnameFromId(intval($uid));
$entryID = intval($entryID);
$categoryID = intval($categoryID);
$catname = $myts -> htmlSpecialChars( $name );
$term = $myts -> htmlSpecialChars( $term );
$created = formatTimestamp( $created, 's' );
$modify = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/submissions.php?op=mod&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/edit.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_EDITSUBM")."' /></a>";
$delete = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/submissions.php?op=del&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/delete.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_DELETESUBM")."' /></a>";
echo "<tr>";
echo "<td class='head' align='center'> $entryID </td>";
if ($xoopsModuleConfig['multicats'] == 1)
{
echo "<td class='even' align='left'> $catname </td>";
}
echo "<td class='even' align='left'> $term </td>";
echo "<td class='even' align='center'> $sentby </td>";
echo "<td class='even' align='center'> $created </td>";
echo "<td class='even' align='center'> $modify $delete </td>";
echo "</tr>";
}
}
else // that is, $numrows = 0, therez no columns yet
{
echo "<tr>";
echo "<td class='head' align='center' colspan='".$colspan."'>".constant("_AM_{$MYDIRNAME}_NOSUBMISSYET")."</td>";
echo "</tr>";
}
echo "</table>";
$pagenav = new XoopsPageNav( $numrows, $xoopsModuleConfig['perpage'], $startsub, 'startsub', 'entryID =' . $entryID );
echo "<div style='text-align:right;'>" . $pagenav -> renderNav() . "</div>";
echo "</fieldset>";
echo "<br />";
/* -- Code to show requested entries -- */
echo "<fieldset style='margin:1em 0em 0em 0em;border:1px solid #778;'><legend style='font-weight: bold; color: #900;'>" . constant("_AM_{$MYDIRNAME}_SHOWREQUESTS") . "</legend><br />";
echo "<table width='100%' cellspacing='1' cellpadding='3' border='0' class='outer'>";
echo "<tr>";
echo "<td width='40' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYID") . "</b></td>";
echo "<td class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYTERM") . "</b></td>";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_SUBMITTER") . "</b></td>";
echo "<td width='90' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ENTRYCREATED") . "</b></td>";
echo "<td width='60' class='bg3' align='center'><b>" . constant("_AM_{$MYDIRNAME}_ACTION") . "</b></td>";
echo "</tr>";
$resultS2 = $xoopsDB -> query( "SELECT COUNT(*) FROM $ent_table WHERE request = '1'" );
list( $numrowsX ) = $xoopsDB -> fetchRow( $resultS2 );
if ( $numrowsX > 0 ) // That is, if there ARE unauthorized articles in the system
{
$sql4 = "SELECT entryID, term, uid, datesub FROM $ent_table WHERE request = '1' ORDER BY datesub DESC";
$resultS4 = $xoopsDB -> query( $sql4, $xoopsModuleConfig['perpage'], $startsub );
while ( list( $entryID, $term, $uid, $created) = $xoopsDB -> fetchrow( $resultS4 ) )
{
$sentby = xoops_getLinkedUnameFromId(intval($uid));
$entryID = intval($entryID);
$term = $myts -> htmlSpecialChars( $term );
$created = formatTimestamp( $created, 's' );
$modify = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/submissions.php?op=mod&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/edit.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_EDITSUBM")."' /></a>";
$delete = "<a href='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/submissions.php?op=del&entryID=" . $entryID . "'><img src='" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/delete.gif' border='0' width='20' height='20' alt='".constant("_AM_{$MYDIRNAME}_DELETESUBM")."' /></a>";
echo "<tr>";
echo "<td class='head' align='center'> $entryID </td>";
echo "<td class='even' align='left'> $term </td>";
echo "<td class='even' align='center'> $sentby </td>";
echo "<td class='even' align='center'> $created </td>";
echo "<td class='even' align='center'> $modify $delete </td>";
echo "</tr>";
}
}
else // that is, $numrows = 0, therez no columns yet
{
echo "<tr>";
echo "<td class='head' align='center' colspan='5'>".constant("_AM_{$MYDIRNAME}_NOREQSYET")."</td>";
echo "</tr>";
}
echo "</table>";
$pagenav = new XoopsPageNav( $numrows, $xoopsModuleConfig['perpage'], $startsub, 'startsub', 'entryID =' . $entryID );
echo "<div style='text-align:right;'>" . $pagenav -> renderNav() . "</div>";
echo "</fieldset>";
echo "<br />";
xoops_cp_footer();
}
function show_list($uid, $catid = "", $after = 0, $style = LT_STYLE_OWNER)
{
global $xoopsDB, $xoopsConfig, $xoopsModule, $xoopsModuleConfig, $xoopsUser;
require_once XOOPS_ROOT_PATH . '/class/template.php';
require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$myts =& MyTextSanitizer::getInstance();
$tpl = new XoopsTpl();
$title = _MD_LOGTICK_TITLE;
if (preg_match('/^\\d+(,\\d+)+$/', $uid)) {
// show multiple user log
$cond = "luid IN ({$uid})";
$disp = true;
} elseif ($uid) {
// show a user log
$cond = "luid={$uid}";
$title = sprintf(_MD_LOGTICK_USER, xoops_getLinkedUnameFromId($uid));
$disp = false;
} else {
// show any user log
$cond = '1';
$disp = true;
}
$now = time();
$timestamp = _MD_SHOW_TIMESTAMP . " " . formatTimestamp($now, "m") . "<!-- now: <{$now}> -->";
$tpl->assign(array('now' => $now, 'timestamp' => $timestamp, 'anonymous' => $xoopsConfig['anonymous'], 'showuser' => $disp, 'title' => $title));
if (preg_match('/^\\d+(,\\d+)+$/', $catid)) {
// show multiple categories
$cond .= " AND pcat IN ({$catid})";
} elseif ($catid) {
// show a category
$cond .= " AND pcat={$catid}";
}
$users = $xoopsDB->prefix('users');
$res = $xoopsDB->query("SELECT count(*) FROM " . TLOG . " WHERE {$cond}");
list($count) = $xoopsDB->fetchRow($res);
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$max = $xoopsModuleConfig['maxlist'];
$args = array();
if ($uid) {
$args[] = "uid={$uid}";
}
if ($catid) {
$args[] = "catid={$catid}";
}
$nav = new XoopsPageNav($count, $max, $start, "start", join("&", $args));
$euid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
$upnew = $xoopsModuleConfig['newentry'];
if ($euid) {
$cond = "({$cond}) OR (luid={$euid} AND ({$now}-ltime)<={$upnew})";
}
$tpl->assign(array('pagenav' => $nav->renderNav(), 'count' => $count, 'maxpage' => intval(($count + $max - 1) / $max), 'current' => intval($start / $max) + 1));
$res = $xoopsDB->query("SELECT l.*, cname, uname, user_avatar FROM " . TLOG . " l LEFT JOIN " . TCAT . " ON pcat=catid LEFT JOIN {$users} ON luid=uid WHERE {$cond} ORDER BY mtime DESC", $max, $start);
$logs = array();
if ($xoopsDB->getRowsNum($res)) {
$ptime = new pastTime();
while ($data = $xoopsDB->fetchArray($res)) {
if ($after) {
// check newer
if ($after > $data['ltime']) {
return $timestamp;
}
$after = 0;
}
$data['span'] = $ptime->getSpan($data['lspan']);
if ($now - $data['ltime'] < $upnew) {
$data['class'] = ' new';
}
$data['mdate'] = $ptime->getDate($data['mtime']);
$data['comment'] = $myts->displayTarea($data['comment']);
if ($style == LT_STYLE_OWNER && $data['luid'] == $euid) {
$data['comment'] .= " [<a href='editlog.php?logid=" . $data['logid'] . "'>" . _EDIT . "</a>]";
}
$data['cname'] = htmlspecialchars($data['cname']);
$logs[] = $data;
}
}
$tpl->assign('logs', $logs);
return $tpl->fetch('db:logtick_result.html');
}
// XOOPS - PHP Content Management System // // Copyright (c) 2000 XOOPS.org // // <http://www.xoops.org/> // // ------------------------------------------------------------------------ // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // You may not change or alter any portion of this comment or credits // // of supporting developers from this source code or any supporting // // source code which is considered copyrighted (c) material of the // // original comment or credit authors. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // // ------------------------------------------------------------------------ // include '../../mainfile.php'; include 'functions.php'; $myts =& MyTextSanitizer::getInstance(); $com_itemid = isset($_GET['com_itemid']) ? intval($_GET['com_itemid']) : 0; $data = cc_get_message($com_itemid); $com_replytext = _POSTEDBY . ' <b>' . xoops_getLinkedUnameFromId($data['uid']) . '</b> ' . _DATE . ' <b>' . formatTimestamp($data['mtime']) . '</b> <br /><br />' . $myts->displayTarea($data['body']) . "<br/><br/>" . ($com_replytitle = $data['title']); include XOOPS_ROOT_PATH . '/include/comment_new.php';
function list_forms()
{
global $xoopsDB, $xoopsUser;
$dirname = basename(dirname(dirname(__FILE__)));
$res = $xoopsDB->query("SELECT formid,title,count(msgid) nmes,priuid,cgroup,\nsum(if(status='-',1,0)) nwait,\nsum(if(status='a',1,0)) nwork,\nsum(if(status='b',1,0)) nreply,\nsum(if(status='c',1,0)) nclose,\nstore\nFROM " . FORMS . " LEFT JOIN " . CCMES . " ON fidref=formid AND status<>'x' GROUP BY formid");
if (!$res || $xoopsDB->getRowsNum($res) == 0) {
return false;
}
echo "<style>td.num { text-align: right; }</style>";
echo "<table class='outer' border='0' cellspacing='1'>\n";
echo "<tr><th>ID</th><th>" . _AM_FORM_TITLE . "</th><th>" . _AM_FORM_PRIM_CONTACT . "</th><th>" . _AM_MSG_COUNT . "</th><th>" . _AM_MSG_WAIT . "</th><th>" . _AM_MSG_WORK . "</th><th>" . _AM_MSG_REPLY . "</th><th>" . _AM_MSG_CLOSE . "</th><th>" . _AM_OPERATION . "</th></tr>\n";
$n = 0;
$mbase = XOOPS_URL . "/modules/{$dirname}";
$ancfmt = "<td class='num'><a href='msgadm.php?stat=%s&formid=%d'>%d</a></td>\n";
$nodata = "<td class='num'>--</td>";
$msgs = array('- a b c' => 'nmes', '-' => 'nwait', 'a' => 'nwork', 'b' => 'nreply', 'c' => 'nclose');
$member_handler =& xoops_gethandler('member');
$groups = $member_handler->getGroupList(new Criteria('groupid', XOOPS_GROUP_ANONYMOUS, '!='));
while ($data = $xoopsDB->fetchArray($res)) {
$id = $data['formid'];
$title = htmlspecialchars($data['title'], ENT_QUOTES);
$url = "{$mbase}?form={$id}";
$priuid = $data['priuid'];
$form = $url;
if ($priuid < 0) {
$form .= "&uid=" . $xoopsUser->getVar('uid');
$contact = sprintf(_CC_FORM_PRIM_GROUP, $groups[-$priuid]);
} elseif ($priuid) {
$contact = xoops_getLinkedUnameFromId($priuid);
} elseif ($form['cgroup']) {
$contact = '[' . $groups[$data['cgroup']] . ']';
} else {
$contact = _MD_CONTACT_NOTYET;
}
$bg = $n++ % 2 ? 'even' : 'odd';
$ope = "<a href='?formid={$id}'>" . _EDIT . "</a>" . " | <a href='?op=delete&formid={$id}'>" . _DELETE . "</a>" . " | <a href='{$mbase}/reception.php?form={$id}'>" . _AM_DETAIL . "</a>";
echo "<tr class='{$bg}'><td>{$id}</td>\n<td><a href='{$form}' target='preview'>{$title}</a></td>\n<td>{$contact}</td>";
foreach ($msgs as $stat => $name) {
$value = $data[$name];
if ($data['store'] == _DB_STORE_YES) {
$value = sprintf($ancfmt, urlencode($stat), $id, $value);
} else {
$value = $value ? sprintf($ancfmt, urlencode($stat), $id, $value) : $nodata;
}
echo $value;
}
echo "<td>{$ope}</td></tr>\n";
}
echo "</table><hr/>\n";
return true;
}
echo "<tr><th>ID</th><th>" . _MD_EXTENT_DATE . "</th><th>" . _AM_TITLE . "</th>" . "<th>" . _AM_POSTER . "</th><th>" . _MD_RESERV_PERSONS . "</th><th>" . _AM_RESERVATION . "</th></tr>\n";
while ($data = $xoopsDB->fetchArray($result)) {
$bg = $tags[$n++ % 2];
$eid = $data['eid'];
$exid = $data['exid'];
$id = $eid;
if ($exid) {
$id .= '-' . $exid;
}
$param = 'eid=' . $eid;
if ($exid) {
$param .= '&sub=' . $exid;
}
$date = eventdate($data['exdate']);
$title = "<a href='{$show}?{$param}'>" . $myts->makeTboxData4Show($data['title']) . "</a>";
$uname = xoops_getLinkedUnameFromId($data['uid']);
$reserved = $data['reserved'];
if ($reserved) {
$reserved = "<a href='{$receipt}?{$param}'>{$reserved}</a>";
}
echo "<tr class='{$bg}'><td>{$id}<td>{$date}</td><td>{$title}</td>" . "<td>{$uname}</td><td align='right'>" . $data['persons'] . "</td><td align='right'>{$reserved}</td></tr>\n";
}
echo "</table>";
break;
}
xoops_cp_footer();
function show_categories()
{
global $xoopsDB;
$myts =& MyTextSanitizer::getInstance();
$res = $xoopsDB->query('SELECT c.*,count(topicid) count, if (p.weight, p.weight, c.weight) ord1, if(p.weight IS NULL, -1, c.weight) ord2 FROM ' . CATBL . ' c LEFT JOIN ' . CATBL . ' p ON c.catpri=p.catid LEFT JOIN ' . EGTBL . ' ON c.catid=topicid GROUP BY c.catid ORDER BY ord1,ord2,c.catid');
break;
case 'one':
$xoopsOption['template_main'] = EGPREFIX . '_confirm.html';
$xoopsTpl->assign('lang_title', _MD_RESERV_REC);
$edit = "<a href='receipt.php?op=edit&rvid={$rvid}'>" . _EDIT . "</a>";
$del = "<a href='reserv.php?op=cancel&rvid={$rvid}&back='>" . _MD_RESERV_DEL . "</a>";
$items = array();
$items[] = array('label' => _MD_RVID, 'value' => "{$rvid} [{$edit}] [{$del}]");
if ($data['email']) {
$items[] = array('label' => _MD_EMAIL, 'value' => $myts->displayTarea($data['email']));
}
if ($data['uid']) {
$items[] = array('label' => _MD_UNAME, 'value' => display_username($data['uid'], true));
}
if ($rvdata['operator']) {
$items[] = array('label' => _MD_RESERV_REGISTER, 'value' => xoops_getLinkedUnameFromId($rvdata['operator']));
}
$items[] = array('label' => _MD_STATUS, 'value' => $rv_stats[$data['status']]);
$items[] = array('label' => _MD_ORDER_DATE, 'value' => formatTimestamp($data['rdate'], _MD_TIME_FMT));
foreach (unserialize_text($rvdata['info']) as $lab => $v) {
$items[] = array('label' => $lab, 'value' => $myts->displayTarea($v));
}
edit_eventdata($head);
$xoopsTpl->assign('event', edit_eventdata($head));
$xoopsTpl->assign('items', $items);
$xoopsTpl->assign('submit', $backanc);
break;
default:
$xoopsOption['template_main'] = EGPREFIX . '_receipt.html';
$xoopsTpl->assign('lang_title', _MD_RESERVATION);
$status = 0;
