select('menus', "*", "menu_name='chatbox_menu'"))
{
$row = $sql->fetch();
if(!check_class((int) $row['menu_class']))
{
$mes->addError(CHATBOX_L24);
$ns->tablerender(LAN_ERROR, $mes->render());
require_once(FOOTERF);
exit;
}
}
if ( ! isset($pref['cb_mod'])) {
$pref['cb_mod'] = e_UC_ADMIN;
}
if(!defined('CB_MOD'))
{
define('CB_MOD', check_class($pref['cb_mod']));
}
if ( ! empty($_POST['moderate']) && CB_MOD) {
if (isset($_POST['block']))
{
$kk = array();
foreach (array_keys($_POST['block']) as $k) {
$kk[] = intval($k);
}
$blocklist = implode(",", $kk);
$sql->gen("UPDATE #chatbox SET cb_blocked=1 WHERE cb_id IN ({$blocklist})");
}
if (isset($_POST['unblock']))
{
$k = array();
$kk = array();
foreach (array_keys($_POST['unblock']) as $k) {
$kk[] = intval($k);
}
$unblocklist = implode(",", $kk);
$sql->gen("UPDATE #chatbox SET cb_blocked=0 WHERE cb_id IN ({$unblocklist})");
}
if (isset($_POST['delete'])) {
$deletelist = implode(",", array_keys($_POST['delete']));
$query = "SELECT c.cb_id, u.user_id FROM #chatbox AS c
LEFT JOIN #user AS u ON SUBSTRING_INDEX(c.cb_nick,'.',1) = u.user_id
WHERE c.cb_id IN (" . $deletelist . ")";
$sql->gen($query);
$rowlist = $sql->rows();
foreach ($rowlist as $row) {
$userId = (int)$row['user_id'];
$sql->gen("UPDATE #user SET user_chats=user_chats-1 WHERE user_id = {$userId} ");
}
$sql->gen("DELETE FROM #chatbox WHERE cb_id IN ({$deletelist})");
}
e107::getCache()->clear("nq_chatbox");
$mes->addSuccess(CHATBOX_L18);
}
// when coming from search.php
$fs = false;
if (strpos(e_QUERY, "fs") !== false) {
$cgtm = intval(str_replace(".fs", "", e_QUERY));
$fs = true;
}
// end search
//if (e_QUERY ? $from = intval(e_QUERY) : $from = 0) {
//}
$chat_total = $sql->count('chatbox');
$qry_where = (CB_MOD ? "1" : "cb_blocked=0");
$from = 0;
// when coming from search.php calculate page number
if ($fs) {
$page_count = 0;
$row_count = 0;
$sql->select("chatbox", "*", "{$qry_where} ORDER BY cb_datestamp DESC");
while ($row = $sql->fetch()) {
if ($row['cb_id'] == $cgtm)
{
$from = $page_count;
break;
}
$row_count++;
if ($row_count == 30)
{
$row_count = 0;
$page_count += 30;
}
}
}
// end search
/** Render chat posts **/
$sql->select("chatbox", "*",
"{$qry_where} ORDER BY cb_datestamp DESC LIMIT " . intval($from) . ", 30");
$chatList = $sql->rows();
$CHATBOX_LIST_TEMPLATE =
e107::getTemplate('chatbox_menu', 'chatbox_menu', 'list');
$sc = e107::getScBatch('chatbox_menu', true);
$textstring = '';
foreach ($chatList as $row) {
$sc->setVars($row);
$textstring .= $tp->parseTemplate($CHATBOX_LIST_TEMPLATE['item'], false, $sc);
}
$textstart = $tp->parseTemplate($CHATBOX_LIST_TEMPLATE['start'], true, $sc);
$textend = $tp->parseTemplate($CHATBOX_LIST_TEMPLATE['end'], true, $sc);
$text = $textstart . $textstring . $textend;
if (CB_MOD) {
$text =
"";
}
$parms = "{$chat_total},30,{$from}," . e_SELF . '?[FROM]';
$text .= "" . $tp->parseTemplate("{NEXTPREV={$parms}}") . '
';
$ns->tablerender(CHATBOX_L20, $mes->render() . $text);
require_once(FOOTERF);