function get_forum_func($xmlrpc_params)
{
$params = php_xmlrpc_decode($xmlrpc_params);
$desc = isset($params[0]) ? true : false;
$parent_id = isset($params[1]) ? intval($params[1]) : 0;
global $db;
$cats = $db->sql_ufetchrowset('SELECT cat_id, cat_title FROM ' . CATEGORIES_TABLE . ' ORDER BY cat_order', SQL_ASSOC);
$forums = mobi_forums($parent_id);
for ($i = 0, $c = count($cats); $i < $c; ++$i) {
$cats[$i]['forum_id'] = $cats[$i]['cat_id'] + 99999;
$cats[$i]['forum_name'] = $cats[$i]['cat_title'];
$cats[$i]['parent_id'] = '-1';
$cats[$i]['sub_only'] = true;
$cats[$i]['child'] = array();
foreach ($forums as &$forum) {
if ($cats[$i]['cat_id'] != $forum['cat_id']) {
continue;
}
if (!$forum['parent_id']) {
$forum['parent_id'] = $forum['cat_id'] + 99999;
}
$cats[$i]['child'][] = assocToStruct($forum);
unset($forum);
}
if (empty($cats[$i]['child'])) {
unset($cats[$i]);
continue;
}
$cats[$i] = assocToStruct($cats[$i], $desc);
}
return new xmlrpcresp(new xmlrpcval($cats, 'array'));
}
function get_topic_func($xmlrpc_params)
{
$params = php_xmlrpc_decode($xmlrpc_params);
$forum_id = isset($params[0]) ? intval($params[0]) : 0;
if (!$forum_id) {
return get_error(3);
}
$offset = 0;
$limit = 20;
$topic_type = '0,1,2';
switch (count($params)) {
case 4:
$offset = intval($params[1]);
// start_num
$limit = intval($params[2]);
// end_num
$topic_type = $params[3] == 'TOP' ? '1' : ($params[3] == 'ANN' ? '2' : $topic_type);
break;
case 3:
$offset = intval($params[1]);
$limit = intval($params[2]);
break;
case 2:
$topic_type = $params[1] == 'TOP' ? '1' : ($params[1] == 'ANN' ? '2' : $topic_type);
}
if ($offset > $limit) {
# check if topic index is out of range
return get_error(5);
} else {
if ($limit - $offset >= 50) {
# return at most 50 topics
$limit = 50;
} else {
if (0 === $offset && 0 === $limit) {
# if both are present and are set to 0, return the first topic only
$limit = 1;
} else {
if ($offset || $limit) {
$limit = 1 + $limit - $offset;
}
}
}
}
global $db, $prefix;
$forum = mobi_forums($forum_id);
$forum = !empty($forum[0]) ? $forum[0] : 0;
if (!$forum) {
return get_error(3);
}
if (!$forum['auth_read']) {
get_error(7);
}
if (isset($forum['subforums'])) {
unset($forum['subforums']);
}
if (FORUM_LINK == $forum['forum_type']) {
return get_error(4);
}
$result = $db->sql_query("SELECT t.*, u.username, u.user_avatar, u.user_avatar_type, u.user_allowavatar\n\t\tFROM {$prefix}_bbtopics t\n\t\tLEFT JOIN {$prefix}_users u\n\t\tON t.topic_poster=u.user_id\n\t\tWHERE t.forum_id = {$forum_id}\n\t\tAND t.topic_type IN ({$topic_type})\n\t\tORDER BY t.topic_id DESC\n\t\tLIMIT {$limit} OFFSET {$offset}");
$topic_list = array();
$unread_sticky_num = $unread_announce_count = 0;
while ($row = $db->sql_fetchrow($result, SQL_ASSOC)) {
if (is_user()) {
if (POST_ANNOUNCE == $row['type']) {
++$unread_announce_count;
} elseif (POST_STICKY == $row['type']) {
++$unread_sticky_num;
}
}
$short_content = get_short_content($row['topic_first_post_id']);
$user_avatar_url = $row['user_allowavatar'] ? get_user_avatar_url($row['user_avatar'], $row['user_avatar_type']) : '';
$rpc = array('forum_id' => new xmlrpcval($forum_id), 'topic_id' => new xmlrpcval($row['topic_moved_id'] ?: $row['topic_id']), 'topic_title' => new xmlrpcval(html_entity_decode(strip_tags($row['topic_title']), ENT_QUOTES, 'UTF-8'), 'base64'), 'topic_author_id' => new xmlrpcval($row['topic_poster']), 'topic_author_name' => new xmlrpcval(html_entity_decode($row['username']), 'base64'), 'is_subscribed' => new xmlrpcval($forum['auth_read'] && !empty($_SESSION['CPG_SESS']['Forums']['track_topics'][$row['topic_id']]), 'boolean'), 'can_subscribe' => new xmlrpcval($forum['auth_read'], 'boolean'), 'is_closed' => new xmlrpcval(TOPIC_LOCKED == $row['topic_status'], 'boolean'), 'last_reply_time' => new xmlrpcval(mobiquo_iso8601_encode($row['topic_time']), 'dateTime.iso8601'), 'reply_number' => new xmlrpcval($row['topic_replies'], 'int'), 'new_post' => new xmlrpcval(false, 'boolean'), 'view_number' => new xmlrpcval($row['topic_views'], 'int'), 'short_content' => new xmlrpcval(get_short_content($row['topic_first_post_id']), 'base64'));
if ($user_avatar_url) {
$rpc['icon_url'] = new xmlrpcval($user_avatar_url);
}
$topic_list[] = new xmlrpcval($rpc, 'struct');
}
$db->sql_freeresult($result);
$rpc = array('total_topic_num' => new xmlrpcval($forum['forum_topics'], 'int'), 'forum_id' => new xmlrpcval($forum['forum_id'], 'string'), 'forum_name' => new xmlrpcval(html_entity_decode($forum['forum_name']), 'base64'), 'can_post' => new xmlrpcval($forum['auth_post'], 'boolean'), 'unread_sticky_count' => new xmlrpcval($unread_sticky_num, 'int'), 'unread_announce_count' => new xmlrpcval($unread_announce_count, 'int'), 'can_subscribe' => new xmlrpcval($forum['auth_read'], 'boolean'), 'is_subscribed' => new xmlrpcval($forum['auth_read'] && !empty($_SESSION['CPG_SESS']['Forums']['track_forums'][$forum['forum_id']]), 'boolean'), 'require_prefix' => new xmlrpcval(false, 'boolean'), 'prefixes' => new xmlrpcval(array(), 'array'));
if ($topic_list) {
$rpc['topics'] = new xmlrpcval($topic_list, 'array');
}
return new xmlrpcresp(new xmlrpcval($rpc, 'struct'));
}
