# locales $all_locales = get_available_locales(); $locales_with_label = array(array('id' => '', 'name' => getlocal("notifications.locale.all"))); foreach ($all_locales as $id) { $locales_with_label[] = array('id' => $id, 'name' => getlocal_($id, "names")); } $page['locales'] = $locales_with_label; $lang = verifyparam("lang", "/^([\\w-]{2,5})?\$/", ""); if ($lang && !in_array($lang, $all_locales)) { $lang = ""; } # kind $kind = verifyparam("kind", "/^(mail|xmpp)?\$/", ""); $page['allkinds'] = array('', 'mail', 'xmpp'); # fetch $conditions = array(); if ($kind) { $conditions[] = "vckind = '{$kind}'"; } if ($lang) { $conditions[] = "locale = '{$lang}'"; } $link = connect(); select_with_pagintation("id, locale, vckind, vcto, unix_timestamp(dtmcreated) as created, vcsubject, tmessage, refoperator", "{$mysqlprefix}chatnotification", $conditions, "order by created desc", "", $link); mysql_close($link); $page['formlang'] = $lang; $page['formkind'] = $kind; prepare_menu($operator); start_html_output(); require '../view/notifications.php'; exit;
* Pavel Petroshenko - initial API and implementation */ require_once '../libs/common.php'; require_once '../libs/operator.php'; require_once '../libs/chat.php'; require_once '../libs/userinfo.php'; require_once '../libs/pagination.php'; $operator = check_login(); loadsettings(); setlocale(LC_TIME, getstring("time.locale")); $page = array(); $query = isset($_GET['q']) ? myiconv(getoutputenc(), $webim_encoding, $_GET['q']) : false; if ($query !== false) { $link = connect(); $result = mysql_query("select {$mysqlprefix}chatgroup.groupid as groupid, vclocalname " . "from {$mysqlprefix}chatgroup order by vclocalname", $link); $groupName = array(); while ($group = mysql_fetch_array($result, MYSQL_ASSOC)) { $groupName[$group['groupid']] = $group['vclocalname']; } mysql_free_result($result); $page['groupName'] = $groupName; $escapedQuery = mysql_real_escape_string($query, $link); select_with_pagintation("DISTINCT unix_timestamp({$mysqlprefix}chatthread.dtmcreated) as created, " . "unix_timestamp({$mysqlprefix}chatthread.dtmmodified) as modified, {$mysqlprefix}chatthread.threadid, " . "{$mysqlprefix}chatthread.remote, {$mysqlprefix}chatthread.agentName, {$mysqlprefix}chatthread.userName, groupid, " . "messageCount as size", "{$mysqlprefix}chatthread, {$mysqlprefix}chatmessage", array("{$mysqlprefix}chatmessage.threadid = {$mysqlprefix}chatthread.threadid", "(({$mysqlprefix}chatthread.userName LIKE '%%{$escapedQuery}%%') or ({$mysqlprefix}chatmessage.tmessage LIKE '%%{$escapedQuery}%%'))"), "order by created DESC", "DISTINCT {$mysqlprefix}chatthread.dtmcreated", $link); mysql_close($link); $page['formq'] = topage($query); } else { setup_empty_pagination(); } prepare_menu($operator); start_html_output(); require '../view/thread_search.php';