site_process($_GET); require_once '../includes/header.php'; require_once '../includes/icon_msg.php'; if ($g_no_login) { exit(); } //$db->debug=1; //Get Module List $sql = 'select * ' .'from message_category a ' .'where a.state = 1 ' .'and a.is_show<>1 ' .'order by a.ordering desc;'; $rs_category = $db->query($sql); foreach ((array) $rs_category as $value) { $arr_category[$value['message_category_id']] = $value; } //generate where $where[] = 'a.state=1'; $where[] = 'a.message_category_id in ('.implode(',', array_keys((array) $arr_category)).')'; if ($arr_category && !$_GET['pno'] && !$_GET['id'] && !isset($_GET['search'])) { $_GET['pno'] = key((array) $arr_category); } if (isset($_GET['search'])) { $_SESSION['s_message_message_search'] = $_GET['search']; } $search = mysql_escape_string($_SESSION['s_message_message_search']); $where[] = " ( a.subject like '%$search%' or a.body like '%$search%') "; if ($_GET['pno']) { $pno = mysql_escape_string($_GET['pno']); $where[] = "a.message_category_id='{$pno}'"; } //get message content count $sql_count = 'SELECT count(*) as cnt ' .'FROM `message` a ' .'where '.implode(' and ', (array) $where); $rs_count = $db->query($sql_count); if ($rs_count) { $count = $rs_count[0]['cnt']; } else { $count = 0; } //pager $image_url = '../'.$g_theme_path; $pageClass = new pager($count); $pageLink = $pageClass->getPageLink(); //get message content list $sql_content = 'SELECT a.`message_id`, ' .' a.`message_category_id`, ' .' a.`subject`, ' .' a.`body`, ' .' a.`created_time`, ' .' a.`created_by`, ' .' a.`ordering`, ' .' a.`state`, ' .' a.`is_show`, ' .' b.user_name ' .'FROM `message` a left join ' .' users b on a.created_by = b.user_id ' .'where '.implode(' and ', (array) $where) .'order by a.ordering desc ' ."limit $pageClass->_offsize,$pageClass->_limit;"; $arr_content = $db->query($sql_content); if (!$_GET['pno'] && $_GET['id']) { $_GET['pno'] = $arr_content ? $arr_content[0]['message_id'] : 0; } ?>
|
|||||||||||||||
|