function nvweb_list_parse_tag($tag, $item, $source = 'item', $item_relative_position, $item_absolute_position, $total)
{
global $current;
global $website;
global $structure;
global $DB;
$out = '';
switch ($tag['attributes']['source']) {
// special condition, return direct query result values
case 'query':
$out = $item->_query->{$tag}['attributes']['value'];
break;
// special: return element position in list
// special: return element position in list
case 'position':
$position = $item_relative_position;
if ($tag['attributes']['absolute'] == 'true') {
$position = $item_absolute_position;
}
switch ($tag['attributes']['type']) {
case 'alphabetic':
$out = number2alphabet($position);
break;
case 'numeric':
default:
$out = $position + 1;
// first element is 1, but in list is zero
break;
}
break;
// NOTE: the following refers to structure information of an ITEM, useless if the source are categories!
// NOTE: the following refers to structure information of an ITEM, useless if the source are categories!
case 'structure':
case 'category':
nvweb_menu_load_dictionary();
// load menu translations if not already done
nvweb_menu_load_routes();
// load menu paths if not already done
switch ($tag['attributes']['value']) {
case 'title':
if ($source == 'structure' || $source == 'category') {
$out = $structure['dictionary'][$item->id];
} else {
$out = $structure['dictionary'][$item->category];
}
if (!empty($tag['attributes']['length'])) {
$out = core_string_cut($out, $tag['attributes']['length'], '…');
}
break;
case 'slug':
if ($source == 'structure' || $source == 'category') {
$out = $structure['dictionary'][$item->id];
} else {
$out = $structure['dictionary'][$item->category];
}
// remove spaces, special chars, etc.
$out = core_string_clean($out);
$out = slug($out);
break;
case 'property':
$id = $item->id;
if ($source != 'structure' && $source != 'category') {
$id = $item->category;
}
$nvweb_properties_parameters = array_replace($tag['attributes'], array('mode' => !isset($tag['attributes']['mode']) ? 'structure' : $tag['attributes']['mode'], 'id' => $id, 'property' => !empty($tag['attributes']['property']) ? $tag['attributes']['property'] : $tag['attributes']['name']));
$out = nvweb_properties($nvweb_properties_parameters);
break;
case 'url':
case 'path':
if ($source == 'structure' || $source == 'category') {
$out = $structure['routes'][$item->id];
} else {
$out = $structure['routes'][$item->category];
}
$out = nvweb_prepare_link($out);
break;
case 'id':
if ($source == 'structure' || $source == 'category') {
$out = $item->id;
} else {
// source = 'item'?
$out = $item->category;
}
break;
default:
break;
}
break;
// ITEM comments
// ITEM comments
case 'comment':
case 'comments':
switch ($tag['attributes']['value']) {
case 'id':
$out = $item->id;
break;
case 'avatar':
$size = '48';
$extra = '';
if (!empty($tag['attributes']['size'])) {
$size = intval($tag['attributes']['size']);
}
if (!empty($tag['attributes']['border'])) {
$extra .= '&border=' . $tag['attributes']['border'];
}
if (!empty($item->avatar)) {
$out = '<img class="' . $tag['attributes']['class'] . '" src="' . NVWEB_OBJECT . '?type=image' . $extra . '&id=' . $item->avatar . '" width="' . $size . 'px" height="' . $size . 'px"/>';
} else {
if (!empty($tag['attributes']['default'])) {
// the comment creator has not an avatar, but the template wants to show a default one
// 3 cases:
// numerical -> ID of the avatar image file in Navigate CMS
// absolute path (http://www...)
// relative path (/img/avatar.png) -> path to the avatar file included in the THEME used
if (is_numeric($tag['attributes']['default'])) {
$out = '<img class="' . $tag['attributes']['class'] . '" src="' . NVWEB_OBJECT . '?type=image' . $extra . '&id=' . $tag['attributes']['default'] . '" width="' . $size . 'px" height="' . $size . 'px"/>';
} else {
if (strpos($tag['attributes']['default'], 'http://') === 0) {
$out = '<img class="' . $tag['attributes']['class'] . '" src="' . $tag['attributes']['default'] . '" width="' . $size . 'px" height="' . $size . 'px"/>';
} else {
if ($tag['attributes']['default'] == 'none') {
$out = '';
} else {
$out = '<img class="' . $tag['attributes']['class'] . '"src="' . NAVIGATE_URL . '/themes/' . $website->theme . '/' . $tag['attributes']['default'] . '" width="' . $size . 'px" height="' . $size . 'px"/>';
}
}
}
} else {
$gravatar_hash = "";
$gravatar_default = 'blank';
if (!empty($tag['attributes']['gravatar_default'])) {
$gravatar_default = $tag['attributes']['gravatar_default'];
}
if (!empty($item->email)) {
$gravatar_hash = md5(strtolower(trim($item->email)));
} else {
if (!empty($item->user)) {
$email = $DB->query_single('email', 'nv_webusers', 'id = ' . protect($item->user));
if (!empty($email)) {
$gravatar_hash = md5(strtolower(trim($item->email)));
}
}
}
if (!empty($gravatar_hash) && $gravatar_default != 'none') {
// gravatar real url: https://www.gravatar.com/avatar/
// we use libravatar to get more userbase
$gravatar_url = 'https://seccdn.libravatar.org/avatar/' . $gravatar_hash . '?s=' . $size . '&d=' . $gravatar_default;
$out = '<img class="' . $tag['attributes']['class'] . '" src="' . $gravatar_url . '" width="' . $size . 'px" height="' . $size . 'px"/>';
} else {
$out = '<img class="' . $tag['attributes']['class'] . '" src="data:image/gif;base64,R0lGODlhAQABAPAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==" width="' . $size . 'px" height="' . $size . 'px"/>';
}
}
}
if ($tag['attributes']['linked'] == 'true' && !empty($out)) {
if (!empty($item->url)) {
$comment_link = $item->url;
} else {
if (!empty($item->user)) {
$wu = new webuser();
$wu->load($item->user);
$comment_link = $wu->social_website;
}
}
if (!empty($comment_link)) {
$out = '<a href="' . $comment_link . '" target="_blank">' . $out . '</a>';
}
}
break;
case 'username':
$out = !empty($item->username) ? $item->username : $item->name;
if ($tag['attributes']['linked'] == 'true' && !empty($out)) {
if (!empty($item->url)) {
$comment_link = $item->url;
} else {
if (!empty($item->user)) {
$wu = new webuser();
$wu->load($item->user);
$comment_link = $wu->social_website;
}
}
if (!empty($comment_link)) {
$out = '<a href="' . $comment_link . '" target="_blank">' . $out . '</a>';
}
}
break;
case 'website':
if (!empty($item->url)) {
$out = $item->url;
} else {
if (!empty($item->user)) {
$wu = new webuser();
$wu->load($item->user);
$out = $wu->social_website;
}
}
if (empty($out)) {
$out = '#';
}
break;
case 'message':
if (!empty($tag['attributes']['length'])) {
$out = core_string_cut($item->message, $tag['attributes']['length'], '…');
} else {
$out = nl2br($item->message);
}
break;
case 'date':
// Navigate CMS 1.6.6 compatibility
if (empty($tag['attributes']['format']) && !empty($tag['attributes']['date_format'])) {
$tag['attributes']['format'] = $tag['attributes']['date_format'];
}
if (!empty($tag['attributes']['format'])) {
// custom date format
$out = nvweb_content_date_format($tag['attributes']['format'], $item->date_created);
} else {
$out = date($website->date_format . ' H:i', $item->date_created);
}
break;
case 'item_url':
$out = nvweb_source_url('item', $item->item, $current['lang']);
break;
case 'item_title':
$out = $item->item_title;
break;
case 'reply_to':
$out = $item->reply_to;
break;
case 'depth':
$c = new comment();
$c->load_from_resultset(array($item));
$out = $c->depth();
break;
case 'property':
$c = new comment();
$c->load_from_resultset(array($item));
// pass all nvlist tag parameters to properties nvweb, but some attribute/values take preference
$nvweb_properties_parameters = array_replace($tag['attributes'], array('mode' => 'comment', 'id' => $c->id, 'template' => $c->element_template(), 'property' => !empty($tag['attributes']['property']) ? $tag['attributes']['property'] : $tag['attributes']['name']));
$out = nvweb_properties($nvweb_properties_parameters);
break;
}
break;
case 'block':
switch ($tag['attributes']['value']) {
case 'id':
$out = $item->id;
break;
// only for blocks in a block group!
// only for blocks in a block group!
case 'uid':
$out = $item->uid;
break;
case 'block':
// generate the full block code
if ($item->type == "extension") {
if (function_exists('nvweb_' . $item->extension . '_' . $item->id)) {
// load extension block property values
$item->properties = property::load_properties(NULL, $item->id, "extension_block", NULL, $item->uid);
$out = call_user_func('nvweb_' . $item->extension . '_' . $item->id, $item);
}
} else {
$out = nvweb_blocks_render($item->type, $item->trigger, $item->action, NULL, NULL, $tag['attributes']);
}
break;
// not for extension_blocks
// not for extension_blocks
case 'title':
$out = $item->dictionary[$current['lang']]['title'];
if (!empty($tag['attributes']['length'])) {
$out = core_string_cut($out, $tag['attributes']['length'], '…');
}
break;
case 'content':
if ($item->type == "extension") {
if (function_exists('nvweb_' . $item->extension . '_' . $item->id)) {
// load extension block property values
$item->properties = property::load_properties(NULL, $item->id, "extension_block", NULL, $item->uid);
$out = call_user_func('nvweb_' . $item->extension . '_' . $item->id, $item);
}
} else {
$out = nvweb_blocks_render($item->type, $item->trigger, $item->action, 'content', $item, $tag['attributes']);
}
break;
// not for extension_blocks
// not for extension_blocks
case 'url':
case 'path':
$out = nvweb_blocks_render_action($item->action, '', $current['lang'], true);
if (empty($out)) {
$out = '#';
} else {
$out = nvweb_prepare_link($out);
}
break;
// not for extension_blocks
// not for extension_blocks
case 'target':
if ($item->action['action-type'][$current['lang']] == 'web-n') {
$out = '_blank';
} else {
$out = '_self';
}
break;
// not for extension_blocks (only for standard blocks and block group blocks)
// not for extension_blocks (only for standard blocks and block group blocks)
case 'property':
$properties_mode = 'block';
if (!is_numeric($item->id)) {
$properties_mode = 'block_group_block';
}
$nvweb_properties_parameters = array_replace($tag['attributes'], array('mode' => !isset($tag['attributes']['mode']) ? $properties_mode : $tag['attributes']['mode'], 'id' => $item->id, 'property' => !empty($tag['attributes']['property']) ? $tag['attributes']['property'] : $tag['attributes']['name'], 'uid' => @$item->uid));
$out = nvweb_properties($nvweb_properties_parameters);
break;
// not for extension_blocks
// not for extension_blocks
case 'poll_answers':
$out = nvweb_blocks_render_poll($item);
break;
default:
break;
}
break;
case 'block_link':
switch ($tag['attributes']['value']) {
case 'id':
$out = $item->id;
break;
case 'title':
$out = $item->title;
if (!empty($tag['attributes']['length'])) {
$out = core_string_cut($out, $tag['attributes']['length'], '…');
}
break;
case 'url':
case 'path':
$out = $item->link;
if (empty($out)) {
$out = '#';
} else {
$out = nvweb_prepare_link($out);
}
break;
case 'target':
if ($item->new_window == 1) {
$out = '_blank';
} else {
$out = '_self';
}
break;
case 'icon':
$out = @$item->icon;
break;
default:
break;
}
break;
case 'block_type':
switch ($tag['attributes']['value']) {
case 'title':
$title_obj = json_decode($item->title, true);
if (empty($title_obj)) {
// not json
$out = $item->title;
} else {
$out = $title_obj[$current['lang']];
}
break;
}
break;
case 'gallery':
switch ($tag['attributes']['value']) {
case 'url':
case 'path':
$out = NVWEB_OBJECT . '?wid=' . $website->id . '&id=' . $item['file'] . '&disposition=inline';
break;
case 'thumbnail':
case 'thumbnail_url':
$thumbnail_url = NVWEB_OBJECT . '?wid=' . $website->id . '&id=' . $item['file'] . '&disposition=inline&width=' . $tag['attributes']['width'] . '&height=' . $tag['attributes']['height'] . '&border=' . $tag['attributes']['border'];
if ($tag['attributes']['value'] == 'thumbnail_url' || @$tag['attributes']['return'] == 'url') {
$out = $thumbnail_url;
} else {
$out = '<img src="' . $thumbnail_url . '" alt="' . $item[$current['lang']] . '" title="' . $item[$current['lang']] . '" />';
}
break;
case 'title':
$f = new file();
$f->load($item['file']);
$out = $f->title[$current['lang']];
break;
case 'alt':
case 'description':
$f = new file();
$f->load($item['file']);
$out = $f->description[$current['lang']];
break;
default:
$out = '<a href="' . NVWEB_OBJECT . '?wid=' . $website->id . '&id=' . $item['file'] . '&disposition=inline">
<img src="' . NVWEB_OBJECT . '?wid=' . $website->id . '&id=' . $item['file'] . '&disposition=inline&width=' . $tag['attributes']['width'] . '&height=' . $tag['attributes']['height'] . '&border=' . $tag['attributes']['border'] . '"
alt="' . $item[$current['lang']] . '" title="' . $item[$current['lang']] . '" />
</a>';
break;
}
break;
case 'item':
// useful also for source="structure" (but some are nonsense: title, comments, etc)
// useful also for source="structure" (but some are nonsense: title, comments, etc)
default:
switch ($tag['attributes']['value']) {
case 'id':
$out = $item->id;
break;
case 'slug':
$lang = $current['lang'];
if (!empty($tag['attributes']['lang'])) {
$lang = $tag['attributes']['lang'];
}
$out = $item->dictionary[$lang]['title'];
// remove spaces, special chars, etc.
$out = core_string_clean($out);
$out = slug($out);
break;
case 'title':
$lang = $current['lang'];
if (!empty($tag['attributes']['lang'])) {
$lang = $tag['attributes']['lang'];
}
$out = $item->dictionary[$lang]['title'];
if (!empty($tag['attributes']['length'])) {
$out = core_string_cut($out, $tag['attributes']['length'], '…', $tag['attributes']['length']);
}
break;
case 'author':
if (!empty($item->author)) {
$nu = new user();
$nu->load($item->author);
$out = $nu->username;
unset($nu);
}
if (empty($out)) {
$out = $website->name;
}
break;
case 'date':
case 'date_post':
if (!empty($tag['attributes']['format'])) {
// custom date format
$out = nvweb_content_date_format($tag['attributes']['format'], $item->date_to_display);
} else {
$out = date($website->date_format, $item->date_to_display);
}
break;
case 'content':
case 'section':
if ($source == 'structure' && $tag['attributes']['source'] == 'item') {
$items = nvweb_content_items($item->id, true, 1, false, 'priority');
// we force finding the first non-embedded item ordered by priority
if (empty($items)) {
$items = nvweb_content_items($item->id, true, 1, true, 'priority');
}
// find the first embedded item ordered by priority
$item = $items[0];
}
$section = $tag['attributes']['section'];
if (empty($section)) {
$section = 'main';
}
$out = $item->dictionary[$current['lang']]['section-' . $section];
if (!empty($tag['attributes']['length'])) {
$allowed_tags = '';
if (!empty($tag['attributes']['allowed_tags'])) {
$allowed_tags = explode(',', $tag['attributes']['allowed_tags']);
}
$out = core_string_cut($out, $tag['attributes']['length'], '…', $allowed_tags);
}
break;
case 'comments':
$out = nvweb_content_comments_count($item->id);
break;
case 'gallery':
$params = array('item' => $item->id);
$params = array_merge($params, $tag['attributes']);
$out = nvweb_gallery($params);
break;
case 'image':
case 'photo':
$photo = @array_shift(array_keys($item->galleries[0]));
if (empty($photo)) {
$out = NVWEB_OBJECT . '?type=transparent';
} else {
$out = NVWEB_OBJECT . '?wid=' . $website->id . '&id=' . $photo . '&disposition=inline&width=' . $tag['attributes']['width'] . '&height=' . $tag['attributes']['height'] . '&border=' . $tag['attributes']['border'];
}
break;
case 'url':
case 'path':
// rss -> full url
// item -> relative url
// embedded item -> category url
if ($item->embedding == 1 && $item->association == 'category') {
nvweb_menu_load_routes();
// load menu paths if not already done
$out = nvweb_prepare_link($structure['routes'][$item->category]);
} else {
$path = $item->paths[$current['lang']];
if (empty($path)) {
$path = '/node/' . $item->id;
}
$out = nvweb_prepare_link($path);
}
break;
case 'tags':
// pass all nvlist tag parameters to the content nvweb, but some attribute/values take preference
$nvweb_parameters = array_replace($tag['attributes'], array('mode' => 'tags', 'id' => $item->id));
$out = nvweb_content($nvweb_parameters);
break;
case 'score':
$out = nvweb_votes_calc($item, $tag['attributes']['round'], $tag['attributes']['half'], $tag['attributes']['min'], $tag['attributes']['max']);
break;
case 'votes':
$out = intval($item->votes);
break;
case 'views':
$out = intval($item->views);
break;
case 'property':
if ($source == 'structure' && $tag['attributes']['source'] == 'item') {
$items = nvweb_content_items($item->id, true, 1, false, 'priority');
// we force finding the first non-embedded item ordered by priority
if (empty($items)) {
$items = nvweb_content_items($item->id, true, 1, true, 'priority');
}
// find the first embedded item ordered by priority
$item = $items[0];
$source = "item";
}
// pass all nvlist tag parameters to properties nvweb, but some attribute/values take preference
$nvweb_properties_parameters = array_replace($tag['attributes'], array('mode' => $source == 'structure' || $source == 'category' ? 'structure' : 'item', 'id' => $item->id, 'template' => $item->template, 'property' => !empty($tag['attributes']['property']) ? $tag['attributes']['property'] : $tag['attributes']['name']));
$out = nvweb_properties($nvweb_properties_parameters);
break;
default:
// maybe a special tag not related to a source? (unimplemented)
}
break;
}
return $out;
}
function run()
{
global $user;
global $layout;
global $DB;
global $website;
$out = '';
$item = new comment();
switch ($_REQUEST['act']) {
case 'json':
case 1:
// json data retrieval & operations
switch ($_REQUEST['oper']) {
case 'del':
// remove rows
$ids = $_REQUEST['ids'];
foreach ($ids as $id) {
$item->load($id);
$item->delete();
}
echo json_encode(true);
break;
default:
// list or search
$page = intval($_REQUEST['page']);
$max = intval($_REQUEST['rows']);
$offset = ($page - 1) * $max;
$orderby = $_REQUEST['sidx'] . ' ' . $_REQUEST['sord'];
$where = ' website = ' . $website->id;
if ($_REQUEST['_search'] == 'true' || isset($_REQUEST['quicksearch'])) {
if (isset($_REQUEST['quicksearch'])) {
$where .= $item->quicksearch($_REQUEST['quicksearch']);
} else {
if (isset($_REQUEST['filters'])) {
$where .= navitable::jqgridsearch($_REQUEST['filters']);
} else {
// single search
$where .= ' AND ' . navitable::jqgridcompare($_REQUEST['searchField'], $_REQUEST['searchOper'], $_REQUEST['searchString']);
}
}
}
$DB->queryLimit('id,item,user,email,date_created,status,message', 'nv_comments', $where, $orderby, $offset, $max);
$dataset = $DB->result();
$total = $DB->foundRows();
//echo $DB->get_last_error();
$out = array();
$permissions = array(-1 => '<img src="img/icons/silk/new.png" align="absmiddle" /> ' . t(257, 'To review'), 0 => '<img src="img/icons/silk/world.png" align="absmiddle" /> ' . t(64, 'Published'), 1 => '<img src="img/icons/silk/world_dawn.png" align="absmiddle" /> ' . t(251, 'Private'), 2 => '<img src="img/icons/silk/world_night.png" align="absmiddle" /> ' . t(181, 'Hidden'), 3 => '<img src="img/icons/silk/error.png" align="absmiddle" /> ' . t(466, 'Spam'));
for ($i = 0; $i < count($dataset); $i++) {
if (empty($dataset[$i])) {
continue;
}
// retrieve webuser name
$webuser = $DB->query_single('username', 'nv_webusers', ' id = ' . $dataset[$i]['user']);
// retrieve item title
$item = new item();
$item->load($dataset[$i]['item']);
$title = $item->dictionary[$website->languages_list[0]]['title'];
$message = core_string_clean($dataset[$i]['message']);
$message = core_string_cut($message, 60, '…');
$out[$i] = array(0 => $dataset[$i]['id'], 1 => $title, 2 => core_ts2date($dataset[$i]['date_created'], true), 3 => empty($dataset[$i]['user']) ? $dataset[$i]['email'] : $webuser, 4 => strip_tags($message), 5 => $permissions[$dataset[$i]['status']]);
}
navitable::jqgridJson($out, $page, $offset, $max, $total);
break;
}
session_write_close();
exit;
break;
case 2:
// edit/new form
// edit/new form
case 'edit':
if (!empty($_REQUEST['id'])) {
$item->load(intval($_REQUEST['id']));
}
if (isset($_REQUEST['form-sent'])) {
$item->load_from_post();
try {
$item->save();
property::save_properties_from_post('comment', $item->id);
$layout->navigate_notification(t(53, "Data saved successfully."), false, false, 'fa fa-check');
} catch (Exception $e) {
$layout->navigate_notification($e->getMessage(), true, true);
}
if (!empty($item->id)) {
users_log::action($_REQUEST['fid'], $item->id, 'save', $item->name, json_encode($_REQUEST));
}
} else {
if (!empty($item->id)) {
users_log::action($_REQUEST['fid'], $item->id, 'load', $item->name);
}
}
$out = comments_form($item);
break;
case 4:
// remove
// remove
case 'remove':
if (!empty($_REQUEST['id'])) {
$item->load(intval($_REQUEST['id']));
if ($item->delete() > 0) {
$layout->navigate_notification(t(55, 'Item removed successfully.'), false);
$out = comments_list();
if (!empty($item->id)) {
users_log::action($_REQUEST['fid'], $item->id, 'remove', $item->name, json_encode($_REQUEST));
}
} else {
$layout->navigate_notification(t(56, 'Unexpected error.'), false);
$out = comments_form($item);
}
}
break;
case 'remove_spam':
$count = comment::remove_spam();
$layout->navigate_notification(t(524, 'Items removed successfully') . ': <strong>' . $count . '</strong>', false);
$out = comments_list();
users_log::action($_REQUEST['fid'], $website->id, 'remove_spam', "", json_encode($_REQUEST));
break;
case 'json_find_webuser':
// json find webuser by name (for "user" autocomplete)
$DB->query('SELECT id, username as text
FROM nv_webusers
WHERE username LIKE ' . protect('%' . $_REQUEST['username'] . '%') . '
ORDER BY username ASC
LIMIT 30', 'array');
$rows = $DB->result();
$total = $DB->foundRows();
echo json_encode(array('items' => $rows, 'totalCount' => $total));
core_terminate();
break;
case 'json_find_comment':
// json find comment by text search (for "in reply to" autocomplete)
$DB->query('SELECT c.id, c.date_created, c.name, u.username, c.message
FROM nv_comments c
LEFT JOIN nv_webusers u ON c.user = u.id
WHERE
c.website = ' . $website->id . ' AND
c.item = ' . $_REQUEST['node_id'] . ' AND
c.date_created <= ' . $_REQUEST['maxdate'] . ' AND
c.id <> ' . $_REQUEST['exclude'] . ' AND
( c.name LIKE ' . protect('%' . $_REQUEST['search'] . '%') . ' OR
c.message LIKE ' . protect('%' . $_REQUEST['search'] . '%') . ' OR
u.username LIKE ' . protect('%' . $_REQUEST['search'] . '%') . '
)
ORDER BY c.date_created DESC
LIMIT 30', 'array');
$rows = $DB->result();
$total = $DB->foundRows();
for ($r = 0; $r < count($rows); $r++) {
$rows[$r]['text'] = '<span title="' . core_string_cut($rows[$r]['message'], 100) . '"><i class="fa fa-user"></i> ' . $rows[$r]['name'] . $rows[$r]['username'] . ' <i class="fa fa-clock-o"></i> ' . core_ts2date($rows[$r]['date_created'], true) . '</span>';
}
echo json_encode(array('items' => $rows, 'totalCount' => $total));
core_terminate();
break;
case 91:
// json search title request (for "item" autocomplete)
$DB->query('SELECT DISTINCT node_id as id, text as label, text as value
FROM nv_webdictionary
WHERE node_type = "item"
AND subtype = "title"
AND website = ' . $website->id . '
AND text LIKE ' . protect('%' . $_REQUEST['title'] . '%') . '
ORDER BY text ASC
LIMIT 30', 'array');
// AND lang = '.protect($_REQUEST['lang']).'
echo json_encode($DB->result());
session_write_close();
exit;
break;
case 0:
// list / search result
// list / search result
default:
$out = comments_list();
break;
}
return $out;
}