function themes_nav($count, $url = '') { $ret = false; $lines_per_page = 20; $max_nav = 5; $num = ceil($count / $lines_per_page); $nav = _NAV_ ? _NAV_ : 1; $page = _PAGE_ ? _PAGE_ : 1; $url = trim($url) ? trim($url) : $_SERVER['REQUEST_URI']; if ($ret['form'] = themes_navbar($num, $nav, $max_nav, $url, $page)) { $ret['limit'] = $lines_per_page; $ret['offset'] = ($page - 1) * $lines_per_page; $ret['top'] = $count - $lines_per_page * ($page - 1) + 1; $ret['nav'] = $nav; $ret['page'] = $page; $ret['url'] = $url; } $_SESSION['tmp']['themes_nav'] = $ret; return $ret; }
switch ($op) { case "all_outgoing": if (!$page) { $page = 1; } if (!$nav) { $nav = 1; } $line_per_page = 50; $max_nav = 15; $db_query = "SELECT count(*) as count FROM " . _DB_PREF_ . "_tblSMSOutgoing WHERE flag_deleted='0'"; $db_result = dba_query($db_query); $db_row = dba_fetch_array($db_result); $num_rows = $db_row['count']; $pages = ceil($num_rows / $line_per_page); $nav_pages = themes_navbar($pages, $nav, $max_nav, "index.php?app=menu&inc=all_outgoing&op=all_outgoing", $page); $limit = ($page - 1) * $line_per_page; $content = "\n\t <h2>" . _('All outgoing SMS') . "</h2>\n\t <p>{$nav_pages}</p>\n\t <form name=\"fm_outgoing\" action=\"index.php?app=menu&inc=all_outgoing&op=act_del\" method=post onSubmit=\"return SureConfirm()\">\n\t <table width=100% cellpadding=1 cellspacing=2 border=0 class=\"sortable\">\n <thead>\n\t <tr>\n\t <th align=center width=4>*</th>\n\t <th align=center width=10%>" . _('User') . "</th>\n\t <th align=center width=20%>" . _('Time') . "</th>\n\t <th align=center width=10%>" . _('Gateway') . "</th>\n\t <th align=center width=10%>" . _('Receiver') . "</th>\n\t <th align=center width=40%>" . _('Message') . "</th>\n\t <th align=center width=10%>" . _('Status') . "</th>\n\t <th align=center width=4>" . _('Group') . "</th>\n\t <th align=center width=4 class=\"sorttable_nosort\">" . _('Action') . "</th>\n\t <th width=4 class=\"sorttable_nosort\"><input type=checkbox onclick=CheckUncheckAll(document.fm_outgoing)></td>\n\t </tr>\n </thead>\n <tbody>\n\t"; $db_query = "SELECT * FROM " . _DB_PREF_ . "_tblSMSOutgoing WHERE flag_deleted='0' ORDER BY smslog_id DESC LIMIT {$limit},{$line_per_page}"; $db_result = dba_query($db_query); $i = $num_rows - $line_per_page * ($page - 1) + 1; $j = 0; while ($db_row = dba_fetch_array($db_result)) { $j++; $current_slid = $db_row['smslog_id']; $p_username = uid2username($db_row['uid']); $p_dst = $db_row['p_dst']; $p_desc = phonebook_number2name($p_dst); $current_p_dst = $p_dst; if ($p_desc) { $current_p_dst = "{$p_dst}<br>({$p_desc})";
case "user_inbox": if (!$page) { $page = 1; } if (!$nav) { $nav = 1; } $line_per_page = 50; $max_nav = 15; $db_query = ""; $db_query = "SELECT count(*) as count FROM " . _DB_PREF_ . "_tblUserInbox WHERE in_uid='{$uid}' AND in_hidden='0'"; $db_result = dba_query($db_query); $db_row = dba_fetch_array($db_result); $num_rows = $db_row['count']; $pages = ceil($num_rows / $line_per_page); $nav_pages = themes_navbar($pages, $nav, $max_nav, "index.php?app=menu&inc=user_inbox&op=user_inbox", $page); $limit = ($page - 1) * $line_per_page; $content = "\n\t <h2>" . _('Inbox') . "</h2>\n\t <p>{$nav_pages}</p>\n\t <form name=\"fm_inbox\" action=\"index.php?app=menu&inc=user_inbox&op=act_del\" method=post onSubmit=\"return SureConfirm()\">\n\t <table cellpadding=1 cellspacing=2 border=0 width=100% class=\"sortable\">\n <thead>\n\t <tr>\n\t <th align=center width=4>*</th>\n\t <th align=center width=20%>" . _('Time') . "</th>\n\t <th align=center width=10%>" . _('From') . "</th>\n\t <th align=center width=70%>" . _('Message') . "</th>\n\t <th align=center class=\"sorttable_nosort\">" . _('Action') . "</td>\n\t <th width=4 class=\"sorttable_nosort\"><input type=checkbox onclick=CheckUncheckAll(document.fm_inbox)></td>\n\t </tr>\n </thead>\n <tbody>\n\t"; $db_query = "SELECT * FROM " . _DB_PREF_ . "_tblUserInbox WHERE in_uid='{$uid}' AND in_hidden='0' ORDER BY in_id DESC LIMIT {$limit},{$line_per_page}"; $db_result = dba_query($db_query); $i = $num_rows - $line_per_page * ($page - 1) + 1; $j = 0; while ($db_row = dba_fetch_array($db_result)) { $j++; $in_id = $db_row['in_id']; $in_sender = $db_row['in_sender']; $p_desc = phonebook_number2name($in_sender); $current_sender = $in_sender; if ($p_desc) { $current_sender = "{$in_sender}<br>({$p_desc})"; }