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})";
}
