function get_subscribed_topic_func()
{
global $config, $db, $user, $auth, $mobiquo_config;
// Only registered users can go beyond this point
if (!$user->data['is_registered']) {
return get_error(9);
}
$topic_list = array();
if ($config['allow_topic_notify']) {
$forbidden_forums = $auth->acl_getf('!f_read', true);
$forbidden_forums = array_unique(array_keys($forbidden_forums));
if (isset($mobiquo_config['hide_forum_id'])) {
$forbidden_forums = array_unique(array_merge($forbidden_forums, $mobiquo_config['hide_forum_id']));
}
$sql_array = array('SELECT' => 't.*,
f.forum_name,
u.user_avatar,
u.user_avatar_type', 'FROM' => array(TOPICS_WATCH_TABLE => 'tw', TOPICS_TABLE => 't', USERS_TABLE => 'u'), 'WHERE' => 'tw.user_id = ' . $user->data['user_id'] . '
AND t.topic_id = tw.topic_id
AND u.user_id = t.topic_last_poster_id
AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true), 'ORDER_BY' => 't.topic_last_post_time DESC');
$sql_array['LEFT_JOIN'] = array();
$sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TABLE => 'f'), 'ON' => 't.forum_id = f.forum_id');
if ($config['allow_bookmarks']) {
$sql_array['SELECT'] .= ', bm.topic_id as bookmarked';
$sql_array['LEFT_JOIN'][] = array('FROM' => array(BOOKMARKS_TABLE => 'bm'), 'ON' => 'bm.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = bm.topic_id');
}
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, 20);
$topic_list = array();
while ($row = $db->sql_fetchrow($result)) {
$forum_id = $row['forum_id'];
$topic_id = isset($row['b_topic_id']) ? $row['b_topic_id'] : $row['topic_id'];
// Replies
$replies = $auth->acl_get('m_approve', $forum_id) ? $row['topic_replies_real'] : $row['topic_replies'];
if ($row['topic_status'] == ITEM_MOVED && !empty($row['topic_moved_id'])) {
$topic_id = $row['topic_moved_id'];
}
// Get folder img, topic status/type related information
$folder_img = $folder_alt = $topic_type = '';
topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);
$short_content = get_short_content($row['topic_last_post_id']);
if ($forum_id) {
$topic_tracking = get_complete_topic_tracking($forum_id, $topic_id);
$new_post = $topic_tracking[$topic_id] < $row['topic_last_post_time'] ? true : false;
} else {
$new_post = false;
}
$user_avatar_url = get_user_avatar_url($row['user_avatar'], $row['user_avatar_type']);
$allow_change_type = $auth->acl_get('m_', $forum_id) || $user->data['is_registered'] && $user->data['user_id'] == $row['topic_poster'] ? true : false;
$xmlrpc_topic = new xmlrpcval(array('forum_id' => new xmlrpcval($forum_id), 'forum_name' => new xmlrpcval(html_entity_decode($row['forum_name']), 'base64'), 'topic_id' => new xmlrpcval($topic_id), 'topic_title' => new xmlrpcval(html_entity_decode(strip_tags(censor_text($row['topic_title']))), 'base64'), 'reply_number' => new xmlrpcval(intval($replies), 'int'), 'view_number' => new xmlrpcval(intval($row['topic_views']), 'int'), 'short_content' => new xmlrpcval($short_content, 'base64'), 'post_author_id' => new xmlrpcval($row['topic_last_poster_id']), 'post_author_name' => new xmlrpcval(html_entity_decode($row['topic_last_poster_name']), 'base64'), 'new_post' => new xmlrpcval($new_post, 'boolean'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($row['topic_last_post_time']), 'dateTime.iso8601'), 'icon_url' => new xmlrpcval($user_avatar_url), 'can_delete' => new xmlrpcval($auth->acl_get('m_delete', $forum_id), 'boolean'), 'can_bookmark' => new xmlrpcval($user->data['is_registered'] && $config['allow_bookmarks'], 'boolean'), 'isbookmarked' => new xmlrpcval($row['bookmarked'] ? true : false, 'boolean'), 'can_close' => new xmlrpcval($auth->acl_get('m_lock', $forum_id) || $auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $row['topic_poster'], 'boolean'), 'is_closed' => new xmlrpcval($row['topic_status'] == ITEM_LOCKED, 'boolean'), 'can_stick' => new xmlrpcval($allow_change_type && $auth->acl_get('f_sticky', $forum_id) && $row['topic_type'] != POST_STICKY, 'boolean')), 'struct');
$topic_list[] = $xmlrpc_topic;
}
$db->sql_freeresult($result);
}
$topic_num = count($topic_list);
$response = new xmlrpcval(array('total_topic_num' => new xmlrpcval($topic_num, 'int'), 'topics' => new xmlrpcval($topic_list, 'array')), 'struct');
return new xmlrpcresp($response);
}
function m_get_moderate_post_func($xmlrpc_params)
{
global $input, $post, $thread, $forum, $pid, $tid, $fid, $modlogdata, $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups, $moderation, $parser;
$input = Tapatalk_Input::filterXmlInput(array('start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT), $xmlrpc_params);
mod_setup();
list($start, $limit) = process_page($input['start_num'], $input['last_num']);
// Load global language phrases
$lang->load("modcp");
if ($mybb->user['uid'] == 0 || $mybb->usergroup['canmodcp'] != 1) {
return tt_no_permission();
}
$errors = '';
// SQL for fetching items only related to forums this user moderates
$moderated_forums = array();
if ($mybb->usergroup['issupermod'] != 1) {
$query = $db->simple_select("moderators", "*", "id='{$mybb->user['uid']}' AND isgroup = '0'");
while ($forum = $db->fetch_array($query)) {
$flist .= ",'{$forum['fid']}'";
$children = get_child_list($forum['fid']);
if (!empty($children)) {
$flist .= ",'" . implode("','", $children) . "'";
}
$moderated_forums[] = $forum['fid'];
}
if ($flist) {
$tflist = " AND t.fid IN (0{$flist})";
$flist = " AND fid IN (0{$flist})";
}
} else {
$flist = $tflist = '';
}
$forum_cache = $cache->read("forums");
$query = $db->query("\n SELECT COUNT(pid) AS unapprovedposts\n FROM " . TABLE_PREFIX . "posts p\n LEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid=p.tid)\n WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid\n ");
$unapproved_posts = $db->fetch_field($query, "unapprovedposts");
$query = $db->query("\n SELECT p.pid, p.subject, p.message, t.subject AS threadsubject, t.tid, u.username, p.uid, t.fid, p.dateline, u.avatar, t.views, t.replies, IF(b.lifted > UNIX_TIMESTAMP() OR b.lifted = 0, 1, 0) as isbanned\n FROM " . TABLE_PREFIX . "posts p\n LEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid=p.tid)\n LEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid=p.uid)\n LEFT JOIN " . TABLE_PREFIX . "banned b ON (b.uid = p.uid)\n left join " . TABLE_PREFIX . "forums f on f.fid = t.fid\n WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid\n ORDER BY p.dateline DESC\n LIMIT {$start}, {$limit}\n ");
$forumcache = $cache->read("forums");
$post_list = array();
while ($post = $db->fetch_array($query)) {
$post['threadsubject'] = $parser->parse_badwords($post['threadsubject']);
$forumpermissions = forum_permissions($post['fid']);
$can_delete = 0;
if ($mybb->user['uid'] == $post['uid']) {
if ($forumpermissions['candeletethreads'] == 1 && $post['replies'] == 0) {
$can_delete = 1;
} else {
if ($forumpermissions['candeleteposts'] == 1 && $post['replies'] > 0) {
$can_delete = 1;
}
}
}
$can_delete = (is_moderator($post['fid'], "candeleteposts") || $can_delete == 1) && $mybb->user['uid'] != 0;
$post_list[] = new xmlrpcval(array('forum_id' => new xmlrpcval($post['fid'], 'string'), 'forum_name' => new xmlrpcval(basic_clean($forumcache[$post['fid']]['name']), 'base64'), 'topic_id' => new xmlrpcval($post['tid'], 'string'), 'topic_title' => new xmlrpcval($post['threadsubject'], 'base64'), 'post_id' => new xmlrpcval($post['pid'], 'string'), 'post_title' => new xmlrpcval($post['subject'], 'base64'), 'post_author_name' => new xmlrpcval($post['username'], 'base64'), 'icon_url' => new xmlrpcval(absolute_url($post['avatar']), 'string'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($post['dateline']), 'dateTime.iso8601'), 'short_content' => new xmlrpcval(process_short_content($post['message'], $parser), 'base64'), 'reply_number' => new xmlrpcval($post['replies'], 'int'), 'view_number' => new xmlrpcval($post['views'], 'int'), 'can_delete' => new xmlrpcval($can_delete, 'boolean'), 'can_approve' => new xmlrpcval(is_moderator($post['fid'], "canmanagethreads"), 'boolean'), 'can_move' => new xmlrpcval(is_moderator($post['fid'], "canmovetononmodforum"), 'boolean'), 'can_ban' => new xmlrpcval($mybb->usergroup['canmodcp'] == 1, 'boolean'), 'is_ban' => new xmlrpcval($post['isbanned'], 'boolean'), 'is_approved' => new xmlrpcval(false, 'boolean'), 'is_deleted' => new xmlrpcval(false, 'boolean')), "struct");
}
$result = new xmlrpcval(array('total_post_num' => new xmlrpcval($unapproved_posts, 'int'), 'posts' => new xmlrpcval($post_list, 'array')), 'struct');
return new xmlrpcresp($result);
}
function get_announcement_func($xmlrpc_params)
{
global $db, $lang, $mybb, $position, $plugins, $pids, $groupscache;
$input = Tapatalk_Input::filterXmlInput(array('topic_id' => Tapatalk_Input::STRING, 'start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT, 'return_html' => Tapatalk_Input::INT), $xmlrpc_params);
$parser = new Tapatalk_Parser();
// Load global language phrases
$lang->load("announcements");
$aid = intval($_GET['aid']);
// Get announcement fid
$query = $db->simple_select("announcements", "fid", "aid='{$aid}'");
$announcement = $db->fetch_array($query);
$plugins->run_hooks("announcements_start");
if (!$announcement) {
error($lang->error_invalidannouncement);
}
// Get forum info
$fid = $announcement['fid'];
if ($fid > 0) {
$forum = get_forum($fid);
if (!$forum) {
error($lang->error_invalidforum);
}
// Make navigation
build_forum_breadcrumb($forum['fid']);
// Permissions
$forumpermissions = forum_permissions($forum['fid']);
if ($forumpermissions['canview'] == 0 || $forumpermissions['canviewthreads'] == 0) {
error_no_permission();
}
// Check if this forum is password protected and we have a valid password
check_forum_password($forum['fid']);
}
add_breadcrumb($lang->nav_announcements);
$archive_url = build_archive_link("announcement", $aid);
// Get announcement info
$time = TIME_NOW;
$query = $db->query("\n\t\tSELECT u.*, u.username AS userusername, a.*, f.*\n\t\tFROM " . TABLE_PREFIX . "announcements a\n\t\tLEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid=a.uid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "userfields f ON (f.ufid=u.uid)\n\t\tWHERE a.startdate<='{$time}' AND (a.enddate>='{$time}' OR a.enddate='0') AND a.aid='{$aid}'\n\t");
$announcementarray = $db->fetch_array($query);
if (!$announcementarray) {
error($lang->error_invalidannouncement);
}
// Gather usergroup data from the cache
// Field => Array Key
$data_key = array('title' => 'grouptitle', 'usertitle' => 'groupusertitle', 'stars' => 'groupstars', 'starimage' => 'groupstarimage', 'image' => 'groupimage', 'namestyle' => 'namestyle', 'usereputationsystem' => 'usereputationsystem');
foreach ($data_key as $field => $key) {
$announcementarray[$key] = $groupscache[$announcementarray['usergroup']][$field];
}
$announcementarray['dateline'] = $announcementarray['startdate'];
$announcementarray['userusername'] = $announcementarray['username'];
$announcement = build_postbit($announcementarray, 3);
$announcementarray['subject'] = $parser->parse_badwords($announcementarray['subject']);
$lang->forum_announcement = $lang->sprintf($lang->forum_announcement, htmlspecialchars_uni($announcementarray['subject']));
if ($announcementarray['startdate'] > $mybb->user['lastvisit']) {
$setcookie = true;
if (isset($mybb->cookies['mybb']['announcements']) && is_scalar($mybb->cookies['mybb']['announcements'])) {
$cookie = my_unserialize(stripslashes($mybb->cookies['mybb']['announcements']));
if (isset($cookie[$announcementarray['aid']])) {
$setcookie = false;
}
}
if ($setcookie) {
my_set_array_cookie('announcements', $announcementarray['aid'], $announcementarray['startdate'], -1);
}
}
$user_info = get_user($announcementarray['aid']);
$icon_url = absolute_url($user_info['avatar']);
// prepare xmlrpc return
$xmlrpc_post = new xmlrpcval(array('topic_id' => new xmlrpcval('ann_' . $announcementarray['aid']), 'post_title' => new xmlrpcval(basic_clean($announcementarray['subject']), 'base64'), 'post_content' => new xmlrpcval(process_post($announcementarray['message'], $input['return_html']), 'base64'), 'post_author_id' => new xmlrpcval($announcementarray['uid']), 'post_author_name' => new xmlrpcval(basic_clean($announcementarray['username']), 'base64'), 'user_type' => new xmlrpcval(check_return_user_type($announcementarray['username']), 'base64'), 'icon_url' => new xmlrpcval(absolute_url($icon_url)), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($announcementarray['dateline']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($announcementarray['dateline'], 'string')), 'struct');
$result = array('total_post_num' => new xmlrpcval(1, 'int'), 'can_reply' => new xmlrpcval(false, 'boolean'), 'can_subscribe' => new xmlrpcval(false, 'boolean'), 'posts' => new xmlrpcval(array($xmlrpc_post), 'array'));
return new xmlrpcresp(new xmlrpcval($result, 'struct'));
}
function get_user_info_func($xmlrpc_params)
{
global $db, $user, $auth, $template, $config, $phpbb_root_path, $phpEx, $table_prefix;
$user->setup(array('memberlist', 'groups'));
if (!$auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel')) {
if ($user->data['user_id'] != ANONYMOUS) {
trigger_error('NO_VIEW_USERS');
}
trigger_error('LOGIN_EXPLAIN_VIEWPROFILE');
}
$params = php_xmlrpc_decode($xmlrpc_params);
$username = $params[0];
if (isset($params[1]) && !empty($params[1])) {
$user_id = $params[1];
} elseif (isset($params[0]) && !empty($params[0])) {
$username = $params[0];
$user_id = get_user_id_by_name($username);
} else {
$user_id = $user->data['user_id'];
}
$user_id = intval($user_id);
// Display a profile
if (!$user_id) {
trigger_error('NO_USER');
}
// Get user...
$sql = 'SELECT *
FROM ' . USERS_TABLE . "\r\r\n WHERE user_id = '{$user_id}'";
$result = $db->sql_query($sql);
$member = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$member) {
trigger_error('NO_USER');
}
// a_user admins and founder are able to view inactive users and bots to be able to manage them more easily
// Normal users are able to see at least users having only changed their profile settings but not yet reactivated.
if (!$auth->acl_get('a_user') && $user->data['user_type'] != USER_FOUNDER) {
if ($member['user_type'] == USER_IGNORE) {
trigger_error('NO_USER');
} else {
if ($member['user_type'] == USER_INACTIVE && $member['user_inactive_reason'] != INACTIVE_PROFILE) {
trigger_error('NO_USER');
}
}
}
$user_id = (int) $member['user_id'];
// Do the SQL thang
$sql = 'SELECT g.group_id, g.group_name, g.group_type
FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug\r\r\n WHERE ug.user_id = {$user_id}\r\r\n AND g.group_id = ug.group_id" . (!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') ? ' AND g.group_type <> ' . GROUP_HIDDEN : '') . '
AND ug.user_pending = 0
ORDER BY g.group_type, g.group_name';
$result = $db->sql_query($sql);
$group_options = '';
while ($row = $db->sql_fetchrow($result)) {
if ($row['group_type'] == GROUP_SPECIAL) {
// Lookup group name in language dictionary
if (isset($user->lang['G_' . $row['group_name']])) {
$row['group_name'] = $user->lang['G_' . $row['group_name']];
}
} else {
if (!$auth_hidden_groups && $row['group_type'] == GROUP_HIDDEN && !isset($user_groups[$row['group_id']])) {
// Skip over hidden groups the user cannot see
continue;
}
}
$group_options .= $row['group_id'] == $member['group_id'] ? $row['group_name'] . " *\n" : $row['group_name'] . "\n";
}
$group_options = trim($group_options);
$db->sql_freeresult($result);
// What colour is the zebra
$sql = 'SELECT friend, foe
FROM ' . ZEBRA_TABLE . "\r\r\n WHERE zebra_id = {$user_id}\r\r\n AND user_id = {$user->data['user_id']}";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$foe = $row['foe'] ? true : false;
$friend = $row['friend'] ? true : false;
$db->sql_freeresult($result);
if ($config['load_onlinetrack']) {
if ($config['version'] < '3.0.3') {
$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline, session_page
FROM ' . SESSIONS_TABLE . "\r\r\n WHERE session_user_id = {$user_id}\r\r\n GROUP BY session_page\r\r\n ORDER BY session_time DESC";
} else {
$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline, session_page, session_forum_id
FROM ' . SESSIONS_TABLE . "\r\r\n WHERE session_user_id = {$user_id}\r\r\n GROUP BY session_page, session_forum_id\r\r\n ORDER BY session_time DESC";
}
$result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$member['session_time'] = isset($row['session_time']) ? $row['session_time'] : 0;
$member['session_viewonline'] = isset($row['session_viewonline']) ? $row['session_viewonline'] : 0;
$member['session_page'] = isset($row['session_page']) ? $row['session_page'] : 0;
$member['session_forum_id'] = isset($row['session_forum_id']) ? $row['session_forum_id'] : 0;
unset($row);
}
if ($config['load_user_activity']) {
display_user_activity($member);
}
// Do the relevant calculations
$memberdays = max(1, round((time() - $member['user_regdate']) / 86400));
$posts_per_day = $member['user_posts'] / $memberdays;
$percentage = $config['num_posts'] ? min(100, $member['user_posts'] / $config['num_posts'] * 100) : 0;
if ($member['user_sig']) {
$member['user_sig'] = censor_text($member['user_sig']);
if ($member['user_sig_bbcode_bitfield']) {
include_once $phpbb_root_path . 'includes/bbcode.' . $phpEx;
$bbcode = new bbcode();
$bbcode->bbcode_second_pass($member['user_sig'], $member['user_sig_bbcode_uid'], $member['user_sig_bbcode_bitfield']);
}
$member['user_sig'] = bbcode_nl2br($member['user_sig']);
$member['user_sig'] = smiley_text($member['user_sig']);
}
$poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height']);
// We need to check if the modules 'zebra' ('friends' & 'foes' mode), 'notes' ('user_notes' mode) and 'warn' ('warn_user' mode) are accessible to decide if we can display appropriate links
$zebra_enabled = $friends_enabled = $foes_enabled = $user_notes_enabled = $warn_user_enabled = false;
// Only check if the user is logged in
if ($user->data['is_registered']) {
if (!class_exists('p_master')) {
include $phpbb_root_path . 'includes/functions_module.' . $phpEx;
}
$module = new p_master();
$module->list_modules('ucp');
$module->list_modules('mcp');
$user_notes_enabled = $module->loaded('notes', 'user_notes') ? true : false;
$warn_user_enabled = $module->loaded('warn', 'warn_user') ? true : false;
$zebra_enabled = $module->loaded('zebra') ? true : false;
$friends_enabled = $module->loaded('zebra', 'friends') ? true : false;
$foes_enabled = $module->loaded('zebra', 'foes') ? true : false;
unset($module);
}
$template->assign_vars(show_profile($member, $user_notes_enabled, $warn_user_enabled));
// Custom Profile Fields
$profile_fields = array();
if ($config['load_cpf_viewprofile']) {
include_once $phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx;
$cp = new custom_profile();
$profile_fields = $cp->generate_profile_fields_template('grab', $user_id);
$profile_fields = isset($profile_fields[$user_id]) ? $cp->generate_profile_fields_template('show', false, $profile_fields[$user_id]) : array();
}
// If the user has m_approve permission or a_user permission, then list then display unapproved posts
if ($auth->acl_getf_global('m_approve') || $auth->acl_get('a_user')) {
$sql = 'SELECT COUNT(post_id) as posts_in_queue
FROM ' . POSTS_TABLE . '
WHERE poster_id = ' . $user_id . '
AND post_approved = 0';
$result = $db->sql_query($sql);
$member['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');
$db->sql_freeresult($result);
} else {
$member['posts_in_queue'] = 0;
}
$template->assign_vars(array('OCCUPATION' => !empty($member['user_occ']) ? censor_text($member['user_occ']) : '', 'INTERESTS' => !empty($member['user_interests']) ? censor_text($member['user_interests']) : '', 'SIGNATURE' => $member['user_sig'], 'POSTS_IN_QUEUE' => $member['posts_in_queue'], 'AVATAR_IMG' => $poster_avatar, 'PM_IMG' => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']), 'EMAIL_IMG' => $user->img('icon_contact_email', $user->lang['EMAIL']), 'WWW_IMG' => $user->img('icon_contact_www', $user->lang['WWW']), 'ICQ_IMG' => $user->img('icon_contact_icq', $user->lang['ICQ']), 'AIM_IMG' => $user->img('icon_contact_aim', $user->lang['AIM']), 'MSN_IMG' => $user->img('icon_contact_msnm', $user->lang['MSNM']), 'YIM_IMG' => $user->img('icon_contact_yahoo', $user->lang['YIM']), 'JABBER_IMG' => $user->img('icon_contact_jabber', $user->lang['JABBER']), 'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']), 'S_PROFILE_ACTION' => append_sid("{$phpbb_root_path}memberlist.{$phpEx}", 'mode=group'), 'S_GROUP_OPTIONS' => $group_options, 'S_CUSTOM_FIELDS' => isset($profile_fields['row']) && sizeof($profile_fields['row']) ? true : false, 'U_USER_ADMIN' => $auth->acl_get('a_user') ? append_sid("{$phpbb_root_path}adm/index.{$phpEx}", 'i=users&mode=overview&u=' . $user_id, true, $user->session_id) : '', 'U_USER_BAN' => $auth->acl_get('m_ban') && $user_id != $user->data['user_id'] ? append_sid("{$phpbb_root_path}mcp.{$phpEx}", 'i=ban&mode=user&u=' . $user_id, true, $user->session_id) : '', 'U_MCP_QUEUE' => $auth->acl_getf_global('m_approve') ? append_sid("{$phpbb_root_path}mcp.{$phpEx}", 'i=queue', true, $user->session_id) : '', 'S_USER_NOTES' => $user_notes_enabled ? true : false, 'S_WARN_USER' => $warn_user_enabled ? true : false, 'S_ZEBRA' => $user->data['user_id'] != $user_id && $user->data['is_registered'] && $zebra_enabled ? true : false, 'U_ADD_FRIEND' => !$friend && !$foe && $friends_enabled ? append_sid("{$phpbb_root_path}ucp.{$phpEx}", 'i=zebra&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '', 'U_ADD_FOE' => !$friend && !$foe && $foes_enabled ? append_sid("{$phpbb_root_path}ucp.{$phpEx}", 'i=zebra&mode=foes&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '', 'U_REMOVE_FRIEND' => $friend && $friends_enabled ? append_sid("{$phpbb_root_path}ucp.{$phpEx}", 'i=zebra&remove=1&usernames[]=' . $user_id) : '', 'U_REMOVE_FOE' => $foe && $foes_enabled ? append_sid("{$phpbb_root_path}ucp.{$phpEx}", 'i=zebra&remove=1&mode=foes&usernames[]=' . $user_id) : ''));
if (!empty($profile_fields['row'])) {
$template->assign_vars($profile_fields['row']);
}
if (!empty($profile_fields['blockrow'])) {
foreach ($profile_fields['blockrow'] as $field_data) {
$template->assign_block_vars('custom_fields', $field_data);
}
}
// Inactive reason/account?
if ($member['user_type'] == USER_INACTIVE) {
$user->add_lang('acp/common');
$inactive_reason = $user->lang['INACTIVE_REASON_UNKNOWN'];
switch ($member['user_inactive_reason']) {
case INACTIVE_REGISTER:
$inactive_reason = $user->lang['INACTIVE_REASON_REGISTER'];
break;
case INACTIVE_PROFILE:
$inactive_reason = $user->lang['INACTIVE_REASON_PROFILE'];
break;
case INACTIVE_MANUAL:
$inactive_reason = $user->lang['INACTIVE_REASON_MANUAL'];
break;
case INACTIVE_REMIND:
$inactive_reason = $user->lang['INACTIVE_REASON_REMIND'];
break;
}
$template->assign_vars(array('S_USER_INACTIVE' => true, 'USER_INACTIVE_REASON' => $inactive_reason));
}
$custom_fields_list = get_custom_fields();
if (!empty($member['user_sig'])) {
$custom_fields_list[] = new xmlrpcval(array('name' => new xmlrpcval($user->lang['SIGNATURE'], 'base64'), 'value' => new xmlrpcval(basic_clean($member['user_sig']), 'base64')), 'struct');
}
if ($member['user_id'] == $user->data['user_id'] && push_table_exists()) {
$sql = "SELECT * FROM " . $table_prefix . "tapatalk_users WHERE userid = '" . $member['user_id'] . "'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
if (!empty($row)) {
array_push($custom_fields_list, new xmlrpcval(array('name' => new xmlrpcval('Notification - Message', 'base64'), 'value' => new xmlrpcval($row['pm'] ? 'On' : 'Off', 'base64')), 'struct'));
array_push($custom_fields_list, new xmlrpcval(array('name' => new xmlrpcval('Notification - Quoted', 'base64'), 'value' => new xmlrpcval($row['quote'] ? 'On' : 'Off', 'base64')), 'struct'));
array_push($custom_fields_list, new xmlrpcval(array('name' => new xmlrpcval('Notification - Mentioned', 'base64'), 'value' => new xmlrpcval($row['tag'] ? 'On' : 'Off', 'base64')), 'struct'));
array_push($custom_fields_list, new xmlrpcval(array('name' => new xmlrpcval('Notification - New Topic', 'base64'), 'value' => new xmlrpcval($row['newtopic'] ? 'On' : 'Off', 'base64')), 'struct'));
array_push($custom_fields_list, new xmlrpcval(array('name' => new xmlrpcval('Notification - Replies', 'base64'), 'value' => new xmlrpcval($row['subscribe'] ? 'On' : 'Off', 'base64')), 'struct'));
}
}
$user_avatar_url = get_user_avatar_url($member['user_avatar'], $member['user_avatar_type']);
// Forum info
$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id
FROM ' . FORUMS_TABLE . '
ORDER BY left_id ASC';
$result = $db->sql_query($sql, 600);
$forum_data = array();
while ($row = $db->sql_fetchrow($result)) {
$forum_data[$row['forum_id']] = $row;
}
$db->sql_freeresult($result);
// get user current activity
preg_match('#^([a-z0-9/_-]+)#i', $member['session_page'], $on_page);
if (!sizeof($on_page)) {
$on_page[1] = '';
}
switch ($on_page[1]) {
case 'index':
$location = $user->lang['INDEX'];
break;
case 'adm/index':
$location = $user->lang['ACP'];
break;
case 'posting':
case 'viewforum':
case 'viewtopic':
$forum_id = $member['session_forum_id'];
if ($forum_id && $auth->acl_get('f_list', $forum_id)) {
$location = '';
if ($forum_data[$forum_id]['forum_type'] == FORUM_LINK) {
$location = sprintf($user->lang['READING_LINK'], $forum_data[$forum_id]['forum_name']);
break;
}
switch ($on_page[1]) {
case 'posting':
preg_match('#mode=([a-z]+)#', $member['session_page'], $on_page);
$posting_mode = !empty($on_page[1]) ? $on_page[1] : '';
switch ($posting_mode) {
case 'reply':
case 'quote':
$location = sprintf($user->lang['REPLYING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
break;
default:
$location = sprintf($user->lang['POSTING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
break;
}
break;
case 'viewtopic':
$location = sprintf($user->lang['READING_TOPIC'], $forum_data[$forum_id]['forum_name']);
break;
case 'viewforum':
$location = sprintf($user->lang['READING_FORUM'], $forum_data[$forum_id]['forum_name']);
break;
}
} else {
$location = $user->lang['INDEX'];
}
break;
case 'search':
$location = $user->lang['SEARCHING_FORUMS'];
break;
case 'faq':
$location = $user->lang['VIEWING_FAQ'];
break;
case 'viewonline':
$location = $user->lang['VIEWING_ONLINE'];
break;
case 'memberlist':
$location = strpos($member['session_page'], 'mode=viewprofile') !== false ? $user->lang['VIEWING_MEMBER_PROFILE'] : $user->lang['VIEWING_MEMBERS'];
break;
case 'mcp':
$location = $user->lang['VIEWING_MCP'];
break;
case 'ucp':
$location = $user->lang['VIEWING_UCP'];
// Grab some common modules
$url_params = array('mode=register' => 'VIEWING_REGISTER', 'i=pm&mode=compose' => 'POSTING_PRIVATE_MESSAGE', 'i=pm&' => 'VIEWING_PRIVATE_MESSAGES', 'i=profile&' => 'CHANGING_PROFILE', 'i=prefs&' => 'CHANGING_PREFERENCES');
foreach ($url_params as $param => $lang) {
if (strpos($member['session_page'], $param) !== false) {
$location = $user->lang[$lang];
break;
}
}
break;
case 'download/file':
$location = $user->lang['DOWNLOADING_FILE'];
break;
case 'report':
$location = $user->lang['REPORTING_POST'];
break;
case 'mobiquo/mobiquo':
$location = 'On Tapatalk';
break;
default:
$location = $user->lang['INDEX'];
break;
}
$user_info = array('user_id' => new xmlrpcval($member['user_id']), 'username' => new xmlrpcval(basic_clean($member['username']), 'base64'), 'user_type' => check_return_user_type($member['username']), 'post_count' => new xmlrpcval($member['user_posts'], 'int'), 'reg_time' => new xmlrpcval(mobiquo_iso8601_encode($member['user_regdate']), 'dateTime.iso8601'), 'timestamp_reg' => new xmlrpcval($member['user_regdate'], 'string'), 'last_activity_time' => new xmlrpcval(mobiquo_iso8601_encode($template->_rootref['VISITED']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($template->_rootref['VISITED'], 'string'), 'is_online' => new xmlrpcval($template->_rootref['S_ONLINE'], 'boolean'), 'accept_pm' => new xmlrpcval($template->_rootref['U_PM'] ? true : false, 'boolean'), 'display_text' => new xmlrpcval('', 'base64'), 'icon_url' => new xmlrpcval($user_avatar_url), 'current_activity' => new xmlrpcval($location, 'base64'), 'custom_fields_list' => new xmlrpcval($custom_fields_list, 'array'));
$xmlrpc_user_info = new xmlrpcval($user_info, 'struct');
return new xmlrpcresp($xmlrpc_user_info);
}
function get_user_info_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups, $parser, $displaygroupfields;
$lang->load("member");
$input = Tapatalk_Input::filterXmlInput(array('user_name' => Tapatalk_Input::STRING, 'user_id' => Tapatalk_Input::INT), $xmlrpc_params);
if ($mybb->usergroup['canviewprofiles'] == 0) {
error_no_permission();
}
if (isset($input['user_id']) && !empty($input['user_id'])) {
$uid = $input['user_id'];
} elseif (!empty($input['user_name'])) {
$query = $db->simple_select("users", "uid", "username='******'user_name_esc']}'");
$uid = $db->fetch_field($query, "uid");
} else {
$uid = $mybb->user['uid'];
}
if ($mybb->user['uid'] != $uid) {
$memprofile = get_user($uid);
} else {
$memprofile = $mybb->user;
}
if (!$memprofile['uid']) {
error($lang->error_nomember);
}
// Get member's permissions
$memperms = user_permissions($memprofile['uid']);
if (!$memprofile['displaygroup']) {
$memprofile['displaygroup'] = $memprofile['usergroup'];
}
// Grab the following fields from the user's displaygroup
$displaygroupfields = array("title", "usertitle", "stars", "starimage", "image", "usereputationsystem");
$displaygroup = usergroup_displaygroup($memprofile['displaygroup']);
// Get the user title for this user
unset($usertitle);
unset($stars);
if (trim($memprofile['usertitle']) != '') {
// User has custom user title
$usertitle = $memprofile['usertitle'];
} elseif (trim($displaygroup['usertitle']) != '') {
// User has group title
$usertitle = $displaygroup['usertitle'];
} else {
// No usergroup title so get a default one
$query = $db->simple_select("usertitles", "*", "", array('order_by' => 'posts', 'order_dir' => 'DESC'));
while ($title = $db->fetch_array($query)) {
if ($memprofile['postnum'] >= $title['posts']) {
$usertitle = $title['title'];
$stars = $title['stars'];
$starimage = $title['starimage'];
break;
}
}
}
// User is currently online and this user has permissions to view the user on the WOL
$timesearch = TIME_NOW - $mybb->settings['wolcutoffmins'] * 60;
$query = $db->simple_select("sessions", "location,nopermission", "uid='{$uid}' AND time>'{$timesearch}'", array('order_by' => 'time', 'order_dir' => 'DESC', 'limit' => 1));
$session = $db->fetch_array($query);
if (($memprofile['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $memprofile['uid'] == $mybb->user['uid']) && !empty($session)) {
// Fetch their current location
$lang->load("online");
require_once MYBB_ROOT . "inc/functions_online.php";
$activity = fetch_wol_activity($session['location'], $session['nopermission']);
/*unset($activity['tid']);
unset($activity['fid']);
unset($activity['pid']);
unset($activity['eid']);
unset($activity['aid']);*/
$location = strip_tags(build_friendly_wol_location($activity));
$location_time = my_date($mybb->settings['timeformat'], $memprofile['lastactive']);
$online = true;
} else {
$online = false;
}
// Get custom fields start
$custom_fields_list = array();
if ($memprofile['birthday']) {
$membday = explode("-", $memprofile['birthday']);
if ($memprofile['birthdayprivacy'] != 'none') {
if ($membday[0] && $membday[1] && $membday[2]) {
$lang->membdayage = $lang->sprintf($lang->membdayage, get_age($memprofile['birthday']));
if ($membday[2] >= 1970) {
$w_day = date("l", mktime(0, 0, 0, $membday[1], $membday[0], $membday[2]));
$membday = format_bdays($mybb->settings['dateformat'], $membday[1], $membday[0], $membday[2], $w_day);
} else {
$bdayformat = fix_mktime($mybb->settings['dateformat'], $membday[2]);
$membday = mktime(0, 0, 0, $membday[1], $membday[0], $membday[2]);
$membday = date($bdayformat, $membday);
}
$membdayage = $lang->membdayage;
} elseif ($membday[2]) {
$membday = mktime(0, 0, 0, 1, 1, $membday[2]);
$membday = date("Y", $membday);
$membdayage = '';
} else {
$membday = mktime(0, 0, 0, $membday[1], $membday[0], 0);
$membday = date("F j", $membday);
$membdayage = '';
}
}
if ($memprofile['birthdayprivacy'] == 'age') {
$membday = $lang->birthdayhidden;
} else {
if ($memprofile['birthdayprivacy'] == 'none') {
$membday = $lang->birthdayhidden;
$membdayage = '';
}
}
$custom_fields_list[] = new xmlrpcval(array('name' => new xmlrpcval(basic_clean($lang->date_of_birth), 'base64'), 'value' => new xmlrpcval(basic_clean("{$membday} {$membdayage}"), 'base64')), 'struct');
}
// thank you/like field
global $mobiquo_config;
$prefix = $mobiquo_config['thlprefix'];
if ($mybb->settings[$prefix . 'enabled'] == "1") {
$lang->load("thankyoulike");
if ($mybb->settings[$prefix . 'thankslike'] == "like") {
$lang->tyl_total_tyls_given = $lang->tyl_total_likes_given;
$lang->tyl_total_tyls_rcvd = $lang->tyl_total_likes_rcvd;
} else {
if ($mybb->settings[$prefix . 'thankslike'] == "thanks") {
$lang->tyl_total_tyls_given = $lang->tyl_total_thanks_given;
$lang->tyl_total_tyls_rcvd = $lang->tyl_total_thanks_rcvd;
}
}
$daysreg = (TIME_NOW - $memprofile['regdate']) / (24 * 3600);
$tylpd = $memprofile['tyl_unumtyls'] / $daysreg;
$tylpd = round($tylpd, 2);
if ($tylpd > $memprofile['tyl_unumtyls']) {
$tylpd = $memprofile['tyl_unumtyls'];
}
$tylrcvpd = $memprofile['tyl_unumrcvtyls'] / $daysreg;
$tylrcvpd = round($tylrcvpd, 2);
if ($tylrcvpd > $memprofile['tyl_unumrcvtyls']) {
$tylrcvpd = $memprofile['tyl_unumrcvtyls'];
}
// Get total tyl and percentage
$options = array("limit" => 1);
$query = $db->simple_select($prefix . "stats", "*", "title='total'", $options);
$total = $db->fetch_array($query);
if ($total['value'] == 0) {
$percent = "0";
$percent_rcv = "0";
} else {
$percent = $memprofile['tyl_unumtyls'] * 100 / $total['value'];
$percent = round($percent, 2);
$percent_rcv = $memprofile['tyl_unumrcvtyls'] * 100 / $total['value'];
$percent_rcv = round($percent_rcv, 2);
}
if ($percent > 100) {
$percent = 100;
}
if ($percent_rcv > 100) {
$percent_rcv = 100;
}
$memprofile['tyl_unumtyls'] = my_number_format($memprofile['tyl_unumtyls']);
$memprofile['tyl_unumrcvtyls'] = my_number_format($memprofile['tyl_unumrcvtyls']);
$tylpd_percent_total = $lang->sprintf($lang->tyl_tylpd_percent_total, my_number_format($tylpd), $tyl_thankslikes_given, $percent);
$tylrcvpd_percent_total = $lang->sprintf($lang->tyl_tylpd_percent_total, my_number_format($tylrcvpd), $tyl_thankslikes_rcvd, $percent_rcv);
addCustomField($lang->tyl_total_tyls_given, "{$memprofile['tyl_unumtyls']} ({$tylpd_percent_total})", $custom_fields_list);
addCustomField($lang->tyl_total_tyls_rcvd, "{$memprofile['tyl_unumrcvtyls']} ({$tylrcvpd_percent_total})", $custom_fields_list);
}
if ($memprofile['timeonline'] > 0) {
$timeonline = nice_time($memprofile['timeonline']);
addCustomField($lang->timeonline, $timeonline, $custom_fields_list);
}
if ($mybb->settings['usereferrals'] == 1 && $memprofile['referrals'] > 0) {
addCustomField($lang->members_referred, $memprofile['referrals'], $custom_fields_list);
}
if ($memperms['usereputationsystem'] == 1 && $displaygroup['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1 && ($mybb->settings['posrep'] || $mybb->settings['neurep'] || $mybb->settings['negrep'])) {
addCustomField($lang->reputation, $memprofile['reputation'], $custom_fields_list);
}
if ($mybb->settings['enablewarningsystem'] != 0 && $memperms['canreceivewarnings'] != 0 && ($mybb->usergroup['canwarnusers'] != 0 || $mybb->user['uid'] == $memprofile['uid'] && $mybb->settings['canviewownwarning'] != 0)) {
$warning_level = round($memprofile['warningpoints'] / $mybb->settings['maxwarningpoints'] * 100);
if ($warning_level > 100) {
$warning_level = 100;
}
addCustomField($lang->warning_level, $warning_level . '%', $custom_fields_list);
}
if ($memprofile['website']) {
$memprofile['website'] = htmlspecialchars_uni($memprofile['website']);
addCustomField($lang->homepage, $memprofile['website'], $custom_fields_list);
}
if ($memprofile['icq']) {
addCustomField($lang->icq_number, $memprofile['icq'], $custom_fields_list);
}
if ($memprofile['aim']) {
addCustomField($lang->aim_screenname, $memprofile['aim'], $custom_fields_list);
}
if ($memprofile['yahoo']) {
addCustomField($lang->yahoo_id, $memprofile['yahoo'], $custom_fields_list);
}
if ($memprofile['msn']) {
addCustomField($lang->msn, $memprofile['msn'], $custom_fields_list);
}
$query = $db->simple_select("userfields", "*", "ufid='{$uid}'");
$userfields = $db->fetch_array($query);
if ($mybb->usergroup['cancp'] == 1 || $mybb->usergroup['issupermod'] == 1 || $mybb->usergroup['canmodcp'] == 1) {
$field_hidden = '1=1';
} else {
$field_hidden = "hidden=0";
}
$query = $db->simple_select("profilefields", "*", "{$field_hidden}", array('order_by' => 'disporder'));
while ($customfield = $db->fetch_array($query)) {
$thing = explode("\n", $customfield['type'], "2");
$type = trim($thing[0]);
$field = "fid{$customfield['fid']}";
$useropts = explode("\n", $userfields[$field]);
$customfieldval = $comma = '';
if (is_array($useropts) && ($type == "multiselect" || $type == "checkbox")) {
$customfieldval = $userfields[$field];
} else {
$customfieldval = $parser->parse_badwords($userfields[$field]);
}
$customfield['name'] = htmlspecialchars_uni($customfield['name']);
if ($customfieldval) {
addCustomField($customfield['name'], $customfieldval, $custom_fields_list);
}
}
if ($memprofile['signature'] && ($memprofile['suspendsignature'] == 0 || $memprofile['suspendsigtime'] < TIME_NOW)) {
$sig_parser = array("allow_html" => $mybb->settings['sightml'], "allow_mycode" => $mybb->settings['sigmycode'], "allow_smilies" => $mybb->settings['sigsmilies'], "allow_imgcode" => $mybb->settings['sigimgcode'], "me_username" => $memprofile['username'], "filter_badwords" => 1);
$memprofile['signature'] = $parser->parse_message($memprofile['signature'], $sig_parser);
$lang->users_signature = $lang->sprintf($lang->users_signature, $memprofile['username']);
addCustomField($lang->users_signature, $memprofile['signature'], $custom_fields_list);
}
// Get custom fields end
$query = $db->simple_select("banned", "uid", "uid='{$uid}'");
$isbanned = !!$db->fetch_field($query, "uid");
$xmlrpc_user_info = array('user_id' => new xmlrpcval($memprofile['uid'], 'string'), 'username' => new xmlrpcval(basic_clean($memprofile['username']), 'base64'), 'user_name' => new xmlrpcval(basic_clean($memprofile['username']), 'base64'), 'user_type' => check_return_user_type($memprofile['username']), 'post_count' => new xmlrpcval($memprofile['postnum'], 'int'), 'reg_time' => new xmlrpcval(mobiquo_iso8601_encode($memprofile['regdate']), 'dateTime.iso8601'), 'timestamp_reg' => new xmlrpcval($memprofile['regdate'], 'string'), 'last_activity_time' => new xmlrpcval(mobiquo_iso8601_encode($memprofile['lastactive']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($memprofile['lastactive'], 'string'), 'is_online' => new xmlrpcval($online, 'boolean'), 'accept_pm' => new xmlrpcval($memprofile['receivepms'], 'boolean'), 'display_text' => new xmlrpcval($usertitle, 'base64'), 'icon_url' => new xmlrpcval(absolute_url($memprofile['avatar']), 'string'), 'current_activity' => new xmlrpcval($location, 'base64'));
if ($mybb->usergroup['canmodcp'] == 1 && $uid != $mybb->user['uid']) {
$xmlrpc_user_info['can_ban'] = new xmlrpcval(ture, 'boolean');
}
if ($isbanned) {
$xmlrpc_user_info['is_ban'] = new xmlrpcval(ture, 'boolean');
}
$xmlrpc_user_info['custom_fields_list'] = new xmlrpcval($custom_fields_list, 'array');
return new xmlrpcresp(new xmlrpcval($xmlrpc_user_info, 'struct'));
}
function search_func()
{
global $search_data, $include_topic_num, $mybb;
$return_list = array();
foreach ($search_data['results'] as $item) {
$fid = $item['fid'];
if ($search_data['type'] == 'threads') {
$lastpost = $item['lastpost'];
$isbanned = $lastpost['isbanned'];
$return_thread = array('forum_id' => new xmlrpcval($item['fid'], 'string'), 'forum_name' => new xmlrpcval(basic_clean($item['forumname']), 'base64'), 'topic_id' => new xmlrpcval($item['tid'], 'string'), 'topic_title' => new xmlrpcval(basic_clean($item['subject']), 'base64'), 'post_id' => new xmlrpcval($item['lastpost']['pid'], 'string'), 'post_author_id' => new xmlrpcval($lastpost ? $lastpost['uid'] : $item['lastposteruid'], 'string'), 'post_author_name' => new xmlrpcval(basic_clean($lastpost ? $lastpost['username'] : $item['lastposter']), 'base64'), 'last_reply_time' => new xmlrpcval(mobiquo_iso8601_encode($lastpost ? $lastpost['dateline'] : $item['lastpost']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($lastpost ? $lastpost['dateline'] : $item['lastpost'], 'string'), 'icon_url' => new xmlrpcval(absolute_url($lastpost ? $lastpost['avatar'] : $item['avatar']), 'string'), 'short_content' => new xmlrpcval(basic_clean($lastpost ? $lastpost['prev'] : ''), 'base64'), 'last_reply_author_id' => new xmlrpcval($lastpost ? $lastpost['uid'] : $item['lastposteruid'], 'string'), 'last_reply_author_name' => new xmlrpcval(basic_clean($lastpost ? $lastpost['username'] : $item['lastposter']), 'base64'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($lastpost ? $lastpost['dateline'] : $item['lastpost']), 'dateTime.iso8601'), 'reply_number' => new xmlrpcval($item['replies'], 'int'), 'view_number' => new xmlrpcval($item['views'], 'int'), 'attachment' => new xmlrpcval($item['attachmentcount'], 'string'), 'can_subscribe' => new xmlrpcval(true, 'boolean'), 'is_approved' => new xmlrpcval($item['visible'], 'boolean'));
if ($item['threadprefix']) {
$return_thread['prefix'] = new xmlrpcval(basic_clean($item['threadprefix']), 'base64');
}
if (is_moderator($fid, "canopenclosethreads")) {
$return_thread['can_close'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "candeleteposts")) {
$return_thread['can_delete'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canmanagethreads")) {
$return_thread['can_stick'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canmanagethreads")) {
$return_thread['can_move'] = new xmlrpcval(true, 'boolean');
$return_thread['can_merge'] = new xmlrpcval(true, 'boolean');
$return_thread['can_merge_post'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canopenclosethreads")) {
$return_thread['can_approve'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "caneditposts")) {
$return_thread['can_rename'] = new xmlrpcval(true, 'boolean');
}
if ($mybb->usergroup['canmodcp'] == 1) {
$return_thread['can_ban'] = new xmlrpcval(true, 'boolean');
}
if ($isbanned) {
$return_thread['is_ban'] = new xmlrpcval(true, 'boolean');
}
if ($item['unread']) {
$return_thread['new_post'] = new xmlrpcval(true, 'boolean');
}
if ($item['closed']) {
$return_thread['is_closed'] = new xmlrpcval(true, 'boolean');
}
if ($item['sticky']) {
$return_thread['is_sticky'] = new xmlrpcval(true, 'boolean');
}
if ($item['is_sub']) {
$return_thread['is_subscribed'] = new xmlrpcval(true, 'boolean');
}
$xmlrpc_thread = new xmlrpcval($return_thread, 'struct');
array_push($return_list, $xmlrpc_thread);
} else {
$return_post = array('forum_id' => new xmlrpcval($item['fid'], 'string'), 'forum_name' => new xmlrpcval(basic_clean($item['forumname']), 'base64'), 'topic_id' => new xmlrpcval($item['tid'], 'string'), 'topic_title' => new xmlrpcval(basic_clean($item['thread_subject']), 'base64'), 'post_id' => new xmlrpcval($item['pid'], 'string'), 'post_title' => new xmlrpcval(basic_clean($item['subject']), 'base64'), 'post_author_id' => new xmlrpcval($item['uid'], 'string'), 'post_author_name' => new xmlrpcval(basic_clean($item['username']), 'base64'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($item['dateline']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($item['dateline'], 'string'), 'reply_number' => new xmlrpcval($item['thread_replies'], 'int'), 'view_number' => new xmlrpcval($item['thread_views'], 'int'), 'icon_url' => new xmlrpcval(absolute_url($item['avatar']), 'string'), 'short_content' => new xmlrpcval(basic_clean($item['prev']), 'base64'), 'is_approved' => new xmlrpcval($item['visible'], 'boolean'));
if (is_moderator($fid, "canmanagethreads")) {
$return_post['can_approve'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "candeleteposts")) {
$return_post['can_delete'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canmanagethreads")) {
$return_post['can_move'] = new xmlrpcval(true, 'boolean');
}
if ($mybb->usergroup['canmodcp'] == 1) {
$return_post['can_ban'] = new xmlrpcval(true, 'boolean');
}
if ($item['isbanned']) {
$return_post['is_ban'] = new xmlrpcval(true, 'boolean');
}
if ($item['unread']) {
$return_post['new_post'] = new xmlrpcval(true, 'boolean');
}
$xmlrpc_post = new xmlrpcval($return_post, 'struct');
array_push($return_list, $xmlrpc_post);
}
}
if ($include_topic_num) {
if ($search_data['type'] == 'threads') {
return new xmlrpcresp(new xmlrpcval(array('result' => new xmlrpcval(true, 'boolean'), 'search_id' => new xmlrpcval($search_data['sid'], 'string'), 'total_topic_num' => new xmlrpcval($search_data['total'], 'int'), 'topics' => new xmlrpcval($return_list, 'array')), 'struct'));
} else {
return new xmlrpcresp(new xmlrpcval(array('result' => new xmlrpcval(true, 'boolean'), 'search_id' => new xmlrpcval($search_data['sid'], 'string'), 'total_post_num' => new xmlrpcval($search_data['total'], 'int'), 'posts' => new xmlrpcval($return_list, 'array')), 'struct'));
}
} else {
return new xmlrpcresp(new xmlrpcval($return_list, 'array'));
}
}
function get_topic_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $time, $mybbgroups;
$lang->load("member");
$parser = new postParser();
$input = Tapatalk_Input::filterXmlInput(array('forum_id' => Tapatalk_Input::INT, 'start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT, 'mode' => Tapatalk_Input::STRING), $xmlrpc_params);
$lang->load("forumdisplay");
$fid = $input['forum_id'];
$foruminfo = get_forum($fid);
if (!$foruminfo) {
return xmlrespfalse($lang->error_invalidforum);
}
list($start, $limit) = process_page($input['start_num'], $input['last_num']);
$forumpermissions = forum_permissions();
$fpermissions = $forumpermissions[$fid];
if ($fpermissions['canview'] != 1) {
return tt_no_permission();
}
switch ($input['mode']) {
case 'TOP':
$stickyonly = " AND sticky=1 ";
$tstickyonly = " AND t.sticky=1 ";
break;
case 'ANN':
return get_announcement_list($foruminfo, $fid);
break;
default:
$stickyonly = " AND sticky=0 ";
$tstickyonly = " AND t.sticky=0 ";
break;
}
if ($mybb->user['uid'] == 0) {
// Build a forum cache.
$query = $db->query("\n SELECT *\n FROM " . TABLE_PREFIX . "forums\n WHERE active != 0\n ORDER BY pid, disporder\n ");
$forumsread = unserialize($mybb->cookies['mybb']['forumread']);
if (!is_array($forumsread)) {
$forumsread = array();
}
} else {
// Build a forum cache.
$query = $db->query("\n SELECT f.*, fr.dateline AS lastread\n FROM " . TABLE_PREFIX . "forums f\n LEFT JOIN " . TABLE_PREFIX . "forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')\n WHERE f.active != 0\n ORDER BY pid, disporder\n ");
}
while ($forum = $db->fetch_array($query)) {
if ($mybb->user['uid'] == 0) {
if ($forumsread[$forum['fid']]) {
$forum['lastread'] = $forumsread[$forum['fid']];
}
}
$fcache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum;
}
tt_check_forum_password($foruminfo['fid']);
if ($foruminfo['linkto']) {
return xmlrespfalse('This forum is a link');
}
$visibleonly = "AND visible='1'";
$tvisibleonly = "AND t.visible='1'";
// Check if the active user is a moderator and get the inline moderation tools.
if (is_moderator($fid)) {
$ismod = true;
$inlinecount = "0";
$inlinecookie = "inlinemod_forum" . $fid;
$visibleonly = " AND (visible='1' OR visible='0')";
$tvisibleonly = " AND (t.visible='1' OR t.visible='0')";
} else {
$inlinemod = '';
$ismod = false;
}
if (is_moderator($fid, "caneditposts") || $fpermissions['caneditposts'] == 1) {
$can_edit_titles = 1;
} else {
$can_edit_titles = 0;
}
$t = "t.";
$sortby = "lastpost";
$sortfield = "lastpost";
$sortordernow = "desc";
$threadcount = 0;
$useronly = $tuseronly = "";
if ($fpermissions['canonlyviewownthreads'] == 1) {
$useronly = "AND uid={$mybb->user['uid']}";
$tuseronly = "AND t.uid={$mybb->user['uid']}";
}
if ($fpermissions['canviewthreads'] != 0) {
// How many posts are there?
if ($datecut > 0 || $fpermissions['canonlyviewownthreads'] == 1) {
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '{$fid}' {$useronly} {$visibleonly} {$stickyonly}");
$threadcount = $db->fetch_field($query, "threads");
} else {
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '{$fid}' {$useronly} {$visibleonly} {$stickyonly}", array('limit' => 1));
$threadcount = $db->fetch_field($query, "threads");
}
}
// count unread stickies
$query = $db->query("\n select COUNT(t.tid) AS threads\n from " . TABLE_PREFIX . "threads t\n left join " . TABLE_PREFIX . "threadsread tr on t.tid = tr.tid and tr.uid = '{$mybb->user['uid']}'\n where t.fid = '{$fid}' {$tuseronly} {$tvisibleonly} and t.sticky=1 and (tr.dateline < t.lastpost or tr.dateline is null)\n ");
$unreadStickyCount = $db->fetch_field($query, "threads");
if ($fpermissions['canviewthreads'] != 0) {
// Start Getting Threads
$query = $db->query("\n SELECT t.*, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username, u.avatar, s.sid as subscribed, po.message, IF(b.lifted > UNIX_TIMESTAMP() OR b.lifted = 0, 1, 0) as isbanned\n FROM " . TABLE_PREFIX . "threads t\n LEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid = t.uid){$select_voting}\n LEFT JOIN " . TABLE_PREFIX . "banned b ON (b.uid = t.uid) \n LEFT JOIN " . TABLE_PREFIX . "threadsubscriptions s ON (s.tid = t.tid) AND (s.uid = '{$mybb->user['uid']}')\n LEFT JOIN " . TABLE_PREFIX . "posts po ON (po.pid = t.firstpost)\n WHERE t.fid='{$fid}' {$tuseronly} {$tvisibleonly} {$tstickyonly}\n GROUP BY t.tid\n ORDER BY t.sticky DESC, {$t}{$sortfield} {$sortordernow} {$sortfield2}\n LIMIT {$start}, {$limit}\n ");
while ($thread = $db->fetch_array($query)) {
$threadcache[$thread['tid']] = $thread;
// If this is a moved thread - set the tid for participation marking and thread read marking to that of the moved thread
if (substr($thread['closed'], 0, 5) == "moved") {
$tid = substr($thread['closed'], 6);
if (!$tids[$tid]) {
$moved_threads[$tid] = $thread['tid'];
$tids[$thread['tid']] = $tid;
}
} else {
$tids[$thread['tid']] = $thread['tid'];
if ($moved_threads[$tid]) {
unset($moved_threads[$tid]);
}
}
}
} else {
$threadcache = $tids = null;
}
if ($tids) {
$tids = implode(",", $tids);
}
if ($mybb->settings['dotfolders'] != 0 && $mybb->user['uid'] && $threadcache) {
$query = $db->simple_select("posts", "tid,uid", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");
while ($post = $db->fetch_array($query)) {
if ($moved_threads[$post['tid']]) {
$post['tid'] = $moved_threads[$post['tid']];
}
if ($threadcache[$post['tid']]) {
$threadcache[$post['tid']]['doticon'] = 1;
}
}
}
if ($mybb->user['uid'] && $mybb->settings['threadreadcut'] > 0 && $threadcache) {
$query = $db->simple_select("threadsread", "*", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");
while ($readthread = $db->fetch_array($query)) {
if ($moved_threads[$readthread['tid']]) {
$readthread['tid'] = $moved_threads[$readthread['tid']];
}
if ($threadcache[$readthread['tid']]) {
$threadcache[$readthread['tid']]['lastread'] = $readthread['dateline'];
}
}
}
if ($mybb->settings['threadreadcut'] > 0 && $mybb->user['uid']) {
$query = $db->simple_select("forumsread", "dateline", "fid='{$fid}' AND uid='{$mybb->user['uid']}'");
$forum_read = $db->fetch_field($query, "dateline");
$read_cutoff = TIME_NOW - $mybb->settings['threadreadcut'] * 60 * 60 * 24;
if ($forum_read == 0 || $forum_read < $read_cutoff) {
$forum_read = $read_cutoff;
}
} else {
$forum_read = my_get_array_cookie("forumread", $fid);
}
$threads = '';
$load_inline_edit_js = 0;
$topic_list = array();
if (is_array($threadcache)) {
reset($threadcache);
foreach ($threadcache as $thread) {
$unreadpost = false;
$moved = explode("|", $thread['closed']);
$thread['author'] = $thread['uid'];
if (!$thread['username']) {
$thread['username'] = $thread['threadusername'];
$thread['profilelink'] = $thread['threadusername'];
} else {
$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
}
// If this thread has a prefix, insert a space between prefix and subject
if ($thread['prefix'] != 0) {
$threadprefix = build_prefixes($thread['prefix']);
$thread['displayprefix'] = $threadprefix['displaystyle'];
}
$thread['subject'] = $parser->parse_badwords($thread['subject']);
$prefix = '';
if ($thread['poll']) {
$prefix = $lang->poll_prefix;
}
$thread['posts'] = $thread['replies'] + 1;
if ($moved[0] == "moved") {
$prefix = $lang->moved_prefix;
$thread['replies'] = "-";
$thread['views'] = "-";
}
$gotounread = '';
$isnew = 0;
$donenew = 0;
if ($mybb->settings['threadreadcut'] > 0 && $mybb->user['uid'] && $thread['lastpost'] > $forum_read) {
if ($thread['lastread']) {
$last_read = $thread['lastread'];
} else {
$last_read = $read_cutoff;
}
} else {
$last_read = my_get_array_cookie("threadread", $thread['tid']);
}
if ($forum_read > $last_read) {
$last_read = $forum_read;
}
if ($thread['lastpost'] > $last_read && $moved[0] != "moved") {
$folder .= "new";
$folder_label .= $lang->icon_new;
$new_class = "subject_new";
$unreadpost = true;
} else {
$folder_label .= $lang->icon_no_new;
$new_class = "subject_old";
}
if (!empty($thread['closed'])) {
$moved = explode("|", $thread['closed']);
if ($moved[0] == "moved") {
$thread['subject'] = $lang->moved_prefix . ' ' . $thread['subject'];
}
}
$new_topic = array('forum_id' => new xmlrpcval($thread['fid'], 'string'), 'topic_id' => new xmlrpcval($thread['tid'], 'string'), 'topic_title' => new xmlrpcval(basic_clean($thread['subject']), 'base64'), 'prefix' => new xmlrpcval(basic_clean($thread['displayprefix']), 'base64'), 'topic_author_id' => new xmlrpcval($thread['uid'], 'string'), 'topic_author_name' => new xmlrpcval(basic_clean($thread['username']), 'base64'), 'icon_url' => new xmlrpcval(absolute_url($thread['avatar']), 'string'), 'last_reply_time' => new xmlrpcval(mobiquo_iso8601_encode($thread['lastpost']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($thread['lastpost'], 'string'), 'short_content' => new xmlrpcval(process_short_content($thread['message'], $parser), 'base64'), 'reply_number' => new xmlrpcval(intval($thread['replies']), 'int'), 'view_number' => new xmlrpcval(intval($thread['views']), 'int'), 'is_approved' => new xmlrpcval($thread['visible'], 'boolean'), 'is_moved' => new xmlrpcval(isset($moved[0]) && $moved[0] == "moved" ? true : false, 'boolean'), 'real_topic_id' => new xmlrpcval(isset($moved[1]) ? $moved[1] : $thread['tid']));
$forumpermissions = forum_permissions($thread['fid']);
if ($forumpermissions['canview'] == 0 || $forumpermissions['canviewthreads'] == 0) {
$new_topic['can_subscribe'] = new xmlrpcval(false, 'boolean');
} else {
$new_topic['can_subscribe'] = new xmlrpcval(true, 'boolean');
}
//can_rename topic
$can_rename = (is_moderator($fid, "caneditposts") || $forumpermissions['caneditposts'] == 1 && $mybb->user['uid'] == $thread['uid']) && $mybb->user['uid'] != 0;
if ($unreadpost) {
$new_topic['new_post'] = new xmlrpcval(true, 'boolean');
}
if ($thread['sticky']) {
$new_topic['is_sticky'] = new xmlrpcval(true, 'boolean');
}
if (!empty($thread['subscribed'])) {
$new_topic['is_subscribed'] = new xmlrpcval(true, 'boolean');
} else {
$new_topic['is_subscribed'] = new xmlrpcval(false, 'boolean');
}
if ($thread['closed']) {
$new_topic['is_closed'] = new xmlrpcval(true, 'boolean');
}
if ($thread['isbanned']) {
$new_topic['is_ban'] = new xmlrpcval(true, 'boolean');
}
if ($mybb->usergroup['canmodcp'] == 1) {
$new_topic['can_ban'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canmanagethreads")) {
$new_topic['can_move'] = new xmlrpcval(true, 'boolean');
$new_topic['can_merge'] = new xmlrpcval(true, 'boolean');
$new_topic['can_merge_post'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canopenclosethreads")) {
$new_topic['can_close'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "candeleteposts")) {
$new_topic['can_delete'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canmanagethreads")) {
$new_topic['can_stick'] = new xmlrpcval(true, 'boolean');
}
if (is_moderator($fid, "canopenclosethreads")) {
$new_topic['can_approve'] = new xmlrpcval(true, 'boolean');
}
if ($can_rename) {
$new_topic['can_rename'] = new xmlrpcval(true, 'boolean');
}
$topic_list[] = new xmlrpcval($new_topic, 'struct');
}
$customthreadtools = '';
}
// If there are no unread threads in this forum and no unread child forums - mark it as read
require_once MYBB_ROOT . "inc/functions_indicators.php";
if (fetch_unread_count($fid) == 0 && $unread_forums == 0) {
mark_forum_read($fid);
}
$prefix_list = array();
// Does this user have additional groups?
if ($mybb->user['additionalgroups']) {
$exp = explode(",", $mybb->user['additionalgroups']);
// Because we like apostrophes...
$imps = array();
foreach ($exp as $group) {
$imps[] = "'{$group}'";
}
$additional_groups = implode(",", $imps);
$extra_sql = "groups IN ({$additional_groups}) OR ";
} else {
$extra_sql = '';
}
if ($mybb->version_code >= 1600 && $mybb->user['uid']) {
$prefixes = get_prefix_list($fid);
foreach ($prefixes as $prefix) {
$prefix_list[] = new xmlrpcval(array('prefix_id' => new xmlrpcval($prefix['pid'], "string"), 'prefix_display_name' => new xmlrpcval(basic_clean($prefix['prefix']), "base64")), "struct");
}
}
$read_only_forums = explode(",", $settings['tapatalk_forum_read_only']);
$can_post = true;
if (empty($read_only_forums) || !is_array($read_only_forums)) {
$read_only_forums = array();
}
if (!($foruminfo['type'] == "f" && $foruminfo['open'] != 0 && $mybb->user['uid'] > 0 && $mybb->usergroup['canpostthreads']) || in_array($fid, $read_only_forums)) {
$can_post = false;
}
$result = array('total_topic_num' => new xmlrpcval($threadcount, 'int'), 'forum_id' => new xmlrpcval($fid, 'string'), 'forum_name' => new xmlrpcval(basic_clean($foruminfo['name']), 'base64'), 'can_post' => new xmlrpcval($can_post, 'boolean'), 'prefixes' => new xmlrpcval($prefix_list, 'array'), 'can_upload' => new xmlrpcval($fpermissions['canpostattachments'], 'boolean'));
if ($unreadStickyCount) {
$result['unread_sticky_count'] = new xmlrpcval($unreadStickyCount, 'int');
}
if ($mybb->user['uid']) {
$query = $db->simple_select("forumsubscriptions", "fid", "fid='" . $fid . "' AND uid='{$mybb->user['uid']}'", array('limit' => 1));
if ($db->fetch_field($query, 'fid')) {
$result['is_subscribed'] = new xmlrpcval(true, 'boolean');
}
}
$result['topics'] = new xmlrpcval($topic_list, 'array');
return new xmlrpcresp(new xmlrpcval($result, 'struct'));
}
function get_unread_topic_func($xmlrpc_params)
{
global $db, $auth, $user, $userinfo, $prefix, $config, $mobiquo_config, $phpbb_home;
$params = php_xmlrpc_decode($xmlrpc_params);
$start_num = 0;
$end_num = 19;
if (isset($params[0]) && is_int($params[0])) {
$start_num = $params[0];
}
// get end index of topic from parameters
if (isset($params[1]) && is_int($params[1])) {
$end_num = $params[1];
}
// check if topic index is out of range
if ($start_num > $end_num) {
return get_error(5);
}
// return at most 50 topics
if ($end_num - $start_num >= 50) {
$end_num = $start_num + 49;
}
$sql_limit = $end_num - $start_num + 1;
$not_in_fid = '';
//$ex_fid_ary = array_unique(array_merge(array_keys($auth->acl_getf('!f_read', true)), array_keys($auth->acl_getf('!f_search', true))));
//if (isset($mobiquo_config['hide_forum_id']))
//{
//$ex_fid_ary = array_unique(array_merge($ex_fid_ary, $mobiquo_config['hide_forum_id']));
//}
//$not_in_fid = (sizeof($ex_fid_ary)) ? 'WHERE ' . $db->sql_in_set('f.forum_id', $ex_fid_ary, true) . ';
$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, forum_order
FROM ' . $prefix . '_bbforums
' . $not_in_fid . '
ORDER BY forum_order';
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
// find out in which forums the user is allowed to view approved posts
$sql = 'SELECT t.topic_id, t.forum_id, t.topic_last_post_id, p.post_time AS topic_last_post_time FROM ' . $prefix . '_bbtopics t, ' . $prefix . '_bbposts p
WHERE p.topic_id = t.topic_id AND p.post_time > ' . $userinfo['user_lastvisit'] . ' ORDER BY topic_last_post_time DESC LIMIT ' . $sql_limit . '';
//if ($fh = fopen('log.txt', 'w'))
//{
//fwrite($fh, $userinfo['username']);
//fclose($fh);
//}
$result = $db->sql_query($sql);
$unread_tids = array();
while ($row = $db->sql_fetchrow($result)) {
$topic_id = $row['topic_id'];
//$forum_id = $row['forum_id'];
//$topic_tracking = get_complete_topic_tracking($forum_id, $topic_id);
//if ($topic_tracking[$topic_id] < $row['topic_last_post_time'])
//{
$unread_tids[] = $topic_id;
//}
}
$db->sql_freeresult($result);
$topic_list = array();
$ur_tids = implode(",", $unread_tids);
if (count($unread_tids)) {
$sql = 'SELECT f.forum_id,
f.forum_name,
t.topic_id,
t.topic_title,
t.topic_replies,
t.topic_views,
t.topic_poster,
t.topic_status,
t.topic_type,
t.topic_last_post_id,
u.user_avatar,
u.user_avatar_type,
tw.notify_status,
p.post_time AS topic_last_post_time,
u.username AS topic_last_poster_name,
p.poster_id AS topic_last_poster_id
FROM ' . $prefix . '_bbtopics t
LEFT JOIN ' . $prefix . '_bbposts p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN ' . $prefix . '_bbforums f ON (t.forum_id = f.forum_id)
LEFT JOIN ' . $prefix . '_users u ON (p.poster_id = u.user_id)
LEFT JOIN ' . $prefix . '_bbtopics_watch tw ON (tw.user_id = ' . $userinfo['user_id'] . ' AND t.topic_id = tw.topic_id)
WHERE t.topic_id IN (' . $ur_tids . ')
ORDER BY topic_last_post_time DESC LIMIT ' . $sql_limit . '';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$topic_id = $row['topic_id'];
$forum_id = $row['forum_id'];
$short_content = get_short_content($row['topic_last_post_id']);
$user_avatar_url = get_user_avatar_url($row['user_avatar'], $row['user_avatar_type']);
//$allow_change_type = ($auth->acl_get('m_', $forum_id) || ($user->data['is_registered'] && $user->data['user_id'] == $row['topic_poster'])) ? true : false;
$xmlrpc_topic = new xmlrpcval(array('forum_id' => new xmlrpcval($forum_id), 'forum_name' => new xmlrpcval(html_entity_decode($row['forum_name']), 'base64'), 'topic_id' => new xmlrpcval($topic_id), 'topic_title' => new xmlrpcval(html_entity_decode(strip_tags($row['topic_title'])), 'base64'), 'reply_number' => new xmlrpcval($row['topic_replies'], 'int'), 'new_post' => new xmlrpcval(true, 'boolean'), 'view_number' => new xmlrpcval($row['topic_views'], 'int'), 'short_content' => new xmlrpcval($short_content, 'base64'), 'post_author_id' => new xmlrpcval($row['topic_last_poster_id']), 'post_author_name' => new xmlrpcval(html_entity_decode($row['topic_last_poster_name']), 'base64'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($row['topic_last_post_time']), 'dateTime.iso8601'), 'icon_url' => new xmlrpcval($user_avatar_url), 'can_delete' => new xmlrpcval(false, 'boolean'), 'can_subscribe' => new xmlrpcval(($config['email_enable'] || $config['jab_enable']) && $config['allow_topic_notify'] && $user->data['is_registered'], 'boolean'), 'can_bookmark' => new xmlrpcval($user->data['is_registered'] && $config['allow_bookmarks'], 'boolean'), 'issubscribed' => new xmlrpcval(!is_null($row['notify_status']) && $row['notify_status'] !== '' ? true : false, 'boolean'), 'is_subscribed' => new xmlrpcval(!is_null($row['notify_status']) && $row['notify_status'] !== '' ? true : false, 'boolean'), 'isbookmarked' => new xmlrpcval($row['bookmarked'] ? true : false, 'boolean'), 'can_close' => new xmlrpcval(false, 'boolean'), 'is_closed' => new xmlrpcval($row['topic_status'] == ITEM_LOCKED, 'boolean'), 'can_stick' => new xmlrpcval(false, 'boolean')), 'struct');
$topic_list[] = $xmlrpc_topic;
}
$db->sql_freeresult($result);
}
$response = new xmlrpcval(array('total_topic_num' => new xmlrpcval(count($unread_tids), 'int'), 'topics' => new xmlrpcval($topic_list, 'array')), 'struct');
return new xmlrpcresp($response);
}
function get_subscribed_topic_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups;
$lang->load("usercp");
$parser = new postParser();
$input = Tapatalk_Input::filterXmlInput(array('start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT), $xmlrpc_params);
if ($mybb->user['uid'] == 0 || $mybb->usergroup['canusercp'] == 0) {
return tt_no_permission();
}
$query = $db->simple_select("forumpermissions", "*", "gid='" . $db->escape_string($mybb->user['usergroup']) . "'");
while ($permissions = $db->fetch_array($query)) {
$permissioncache[$permissions['gid']][$permissions['fid']] = $permissions;
}
while ($forum = $db->fetch_array($query)) {
if ($mybb->user['uid'] == 0) {
if ($forumsread[$forum['fid']]) {
$forum['lastread'] = $forumsread[$forum['fid']];
}
}
$readforums[$forum['fid']] = $forum['lastread'];
}
require_once MYBB_ROOT . "inc/functions_forumlist.php";
$fpermissions = forum_permissions();
list($start, $limit) = process_page($input['start_num'], $input['last_num']);
// Thread visiblity
$visible = "AND t.visible != 0";
if (is_moderator() == true) {
$visible = '';
}
// Do Multi Pages
$query = $db->query("\n\t\tSELECT COUNT(ts.tid) as threads\n\t\tFROM " . TABLE_PREFIX . "threadsubscriptions ts\n\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid = ts.tid)\n\t\tWHERE ts.uid = '" . $mybb->user['uid'] . "' {$visible}\n\t");
$threadcount = $db->fetch_field($query, "threads");
// Fetch subscriptions
$query = $db->query("\n\t\tSELECT s.*, t.*, t.username AS threadusername, u.username, u.username, u.avatar, if({$mybb->user['uid']} > 0 and s.uid = {$mybb->user['uid']}, 1, 0) as subscribed, po.message, f.name as forumname, IF(b.lifted > UNIX_TIMESTAMP() OR b.lifted = 0, 1, 0) as isbanned\n\t\tFROM " . TABLE_PREFIX . "threadsubscriptions s\n\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (s.tid=t.tid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid = t.uid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "banned b ON (b.uid = t.uid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "posts po ON (po.pid = t.firstpost)\n\t\tleft join " . TABLE_PREFIX . "forums f on f.fid = t.fid\n\t\tWHERE s.uid='" . $mybb->user['uid'] . "' {$visible}\n\t\tORDER BY t.lastpost DESC\n\t\tLIMIT {$start}, {$limit}\n\t");
while ($subscription = $db->fetch_array($query)) {
$forumpermissions = $fpermissions[$subscription['fid']];
if ($forumpermissions['canview'] == 0 || $forumpermissions['canviewthreads'] == 0) {
// Hmm, you don't have permission to view this thread - unsubscribe!
$del_subscriptions[] = $subscription['tid'];
} else {
if ($subscription['tid']) {
$subscriptions[$subscription['tid']] = $subscription;
}
}
}
if (is_array($del_subscriptions)) {
$tids = implode(',', $del_subscriptions);
if ($tids) {
$db->delete_query("threadsubscriptions", "tid IN ({$tids}) AND uid='{$mybb->user['uid']}'");
}
}
$topic_list = array();
if (is_array($subscriptions)) {
$tids = implode(",", array_keys($subscriptions));
// Build a forum cache.
$query = $db->query("\n\t\t\tSELECT f.fid, fr.dateline AS lastread\n\t\t\tFROM " . TABLE_PREFIX . "forums f\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "forumsread fr ON (fr.fid=f.fid AND fr.uid='{$mybb->user['uid']}')\n\t\t\tWHERE f.active != 0\n\t\t\tORDER BY pid, disporder\n\t\t");
while ($forum = $db->fetch_array($query)) {
if ($mybb->user['uid'] == 0) {
if ($forumsread[$forum['fid']]) {
$forum['lastread'] = $forumsread[$forum['fid']];
}
}
$readforums[$forum['fid']] = $forum['lastread'];
}
// Read threads
if ($mybb->settings['threadreadcut'] > 0) {
$query = $db->simple_select("threadsread", "*", "uid='{$mybb->user['uid']}' AND tid IN ({$tids})");
while ($readthread = $db->fetch_array($query)) {
$subscriptions[$readthread['tid']]['lastread'] = $readthread['dateline'];
}
}
// Now we can build our subscription list
foreach ($subscriptions as $thread) {
$bgcolor = alt_trow();
$folder = '';
$prefix = '';
// If this thread has a prefix, insert a space between prefix and subject
if ($thread['prefix'] != 0) {
$thread['threadprefix'] .= ' ';
}
// Sanitize
$thread['subject'] = $parser->parse_badwords($thread['subject']);
$gotounread = '';
$isnew = 0;
$donenew = 0;
$lastread = 0;
$unreadpost = 0;
if ($mybb->settings['threadreadcut'] > 0 && $mybb->user['uid']) {
$forum_read = $readforums[$thread['fid']];
$read_cutoff = TIME_NOW - $mybb->settings['threadreadcut'] * 60 * 60 * 24;
if ($forum_read == 0 || $forum_read < $read_cutoff) {
$forum_read = $read_cutoff;
}
} else {
$forum_read = $forumsread[$thread['fid']];
}
if ($mybb->settings['threadreadcut'] > 0 && $thread['lastpost'] > $forum_read) {
$cutoff = TIME_NOW - $mybb->settings['threadreadcut'] * 60 * 60 * 24;
}
if ($thread['lastpost'] > $cutoff) {
if ($thread['lastpost'] > $cutoff) {
if ($thread['lastread']) {
$lastread = $thread['lastread'];
} else {
$lastread = 1;
}
}
}
if (!$lastread) {
$readcookie = $threadread = my_get_array_cookie("threadread", $thread['tid']);
if ($readcookie > $forum_read) {
$lastread = $readcookie;
} else {
$lastread = $forum_read;
}
}
if ($thread['lastpost'] > $lastread && $lastread) {
$unreadpost = 1;
}
$topic_list[] = new xmlrpcval(array('forum_id' => new xmlrpcval($thread['fid'], 'string'), 'forum_name' => new xmlrpcval(basic_clean($thread['forumname']), 'base64'), 'topic_id' => new xmlrpcval($thread['tid'], 'string'), 'topic_title' => new xmlrpcval($thread['subject'], 'base64'), 'topic_author_id' => new xmlrpcval($thread['uid'], 'string'), 'post_author_name' => new xmlrpcval($thread['username'], 'base64'), 'can_subscribe' => new xmlrpcval(true, 'boolean'), 'is_subscribed' => new xmlrpcval((bool) $thread['subscribed'], 'boolean'), 'is_closed' => new xmlrpcval((bool) $thread['closed'], 'boolean'), 'short_content' => new xmlrpcval(process_short_content($thread['message'], $parser), 'base64'), 'icon_url' => new xmlrpcval(absolute_url($thread['avatar']), 'string'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($thread['lastpost']), 'dateTime.iso8601'), 'reply_number' => new xmlrpcval($thread['replies'], 'int'), 'view_number' => new xmlrpcval($thread['views'], 'int'), 'new_post' => new xmlrpcval($unreadpost, 'boolean'), 'can_delete' => new xmlrpcval(is_moderator($thread['fid'], "candeleteposts"), 'boolean'), 'can_close' => new xmlrpcval(is_moderator($thread['fid'], "canopenclosethreads"), 'boolean'), 'can_approve' => new xmlrpcval(is_moderator($thread['fid'], "canopenclosethreads"), 'boolean'), 'can_stick' => new xmlrpcval(is_moderator($thread['fid'], "canmanagethreads"), 'boolean'), 'can_merge' => new xmlrpcval(is_moderator($thread['fid'], "canmanagethreads"), 'boolean'), 'can_merge_post' => new xmlrpcval(is_moderator($thread['fid'], "canmanagethreads"), 'boolean'), 'can_move' => new xmlrpcval(is_moderator($thread['fid'], "canmovetononmodforum"), 'boolean'), 'can_ban' => new xmlrpcval($mybb->usergroup['canmodcp'] == 1, 'boolean'), 'can_rename' => new xmlrpcval(false, 'boolean'), 'is_ban' => new xmlrpcval($thread['isbanned'], 'boolean'), 'is_sticky' => new xmlrpcval($thread['sticky'], 'boolean'), 'is_approved' => new xmlrpcval(!!$thread['visible'], 'boolean'), 'is_deleted' => new xmlrpcval(false, 'boolean')), 'struct');
}
}
$result = new xmlrpcval(array('total_topic_num' => new xmlrpcval($threadcount, 'int'), 'topics' => new xmlrpcval($topic_list, 'array')), 'struct');
return new xmlrpcresp($result);
}
function get_message_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups;
$input = Tapatalk_Input::filterXmlInput(array('message_id' => Tapatalk_Input::INT, 'box_id' => Tapatalk_Input::INT, 'return_html' => Tapatalk_Input::INT), $xmlrpc_params);
$lang->load("private");
$parser = new postParser();
if ($mybb->settings['enablepms'] == 0) {
return xmlrespfalse($lang->pms_disabled);
}
if ($mybb->user['uid'] == '/' || $mybb->user['uid'] == 0 || $mybb->usergroup['canusepms'] == 0) {
return tt_no_permission();
}
if (!$mybb->user['pmfolders']) {
$mybb->user['pmfolders'] = "1**\$%%\$2**\$%%\$3**\$%%\$4**";
$sql_array = array("pmfolders" => $mybb->user['pmfolders']);
$db->update_query("users", $sql_array, "uid = " . $mybb->user['uid']);
}
$rand = my_rand(0, 9);
if ($rand == 5) {
update_pm_count();
}
$foldernames = array();
$foldersexploded = explode("\$%%\$", $mybb->user['pmfolders']);
foreach ($foldersexploded as $key => $folders) {
$folderinfo = explode("**", $folders, 2);
$folderinfo[1] = get_pm_folder_name($folderinfo[0], $folderinfo[1]);
$foldernames[$folderinfo[0]] = $folderinfo[1];
}
$pmid = $input['message_id'];
$query = $db->query("\n\t\tSELECT pm.*, u.*, f.*, g.title AS grouptitle, g.usertitle AS groupusertitle, g.stars AS groupstars, g.starimage AS groupstarimage, g.image AS groupimage, g.namestyle\n\t\tFROM " . TABLE_PREFIX . "privatemessages pm\n\t\tLEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid=pm.fromid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "userfields f ON (f.ufid=u.uid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "usergroups g ON (g.gid=u.usergroup)\n\t\tWHERE pm.pmid='{$pmid}' AND pm.uid='" . $mybb->user['uid'] . "'\n\t");
$pm = $db->fetch_array($query);
if ($pm['folder'] == 3) {
return xmlrespfalse("Draft PMs are not supported by Tapatalk");
}
if (!$pm['pmid']) {
return xmlrespfalse($lang->error_invalidpm);
}
$parser = new Tapatalk_Parser();
$parser_options = array();
$parser_options['allow_html'] = false;
$parser_options['allow_mycode'] = true;
$parser_options['allow_smilies'] = false;
$parser_options['allow_imgcode'] = true;
$parser_options['allow_videocode'] = true;
$parser_options['nl2br'] = (bool) $input['return_html'];
$parser_options['filter_badwords'] = 1;
$pm['message'] = post_bbcode_clean($pm['message']);
$pm['message'] = $parser->parse_message($pm['message'], $parser_options);
if ($pm['receipt'] == 1) {
if ($mybb->usergroup['cantrackpms'] == 1 && $mybb->usergroup['candenypmreceipts'] == 1 && $mybb->input['denyreceipt'] == 1) {
$receiptadd = 0;
} else {
$receiptadd = 2;
}
}
if ($pm['status'] == 0) {
$time = TIME_NOW;
$updatearray = array('status' => 1, 'readtime' => $time);
if (isset($receiptadd)) {
$updatearray['receipt'] = $receiptadd;
}
$db->update_query('privatemessages', $updatearray, "pmid='{$pmid}'");
// Update the unread count - it has now changed.
update_pm_count($mybb->user['uid'], 6);
// Update PM notice value if this is our last unread PM
if ($mybb->user['unreadpms'] - 1 <= 0 && $mybb->user['pmnotice'] == 2) {
$updated_user = array("pmnotice" => 1);
$db->update_query("users", $updated_user, "uid='{$mybb->user['uid']}'");
}
}
$pm['subject'] = $parser->parse_badwords($pm['subject']);
if ($pm['fromid'] == 0) {
$pm['username'] = $lang->mybb_engine;
}
if (!$pm['username']) {
$pm['username'] = $lang->na;
}
// Fetch the recipients for this message
$pm['recipients'] = @unserialize($pm['recipients']);
if (is_array($pm['recipients']['to'])) {
$uid_sql = implode(',', $pm['recipients']['to']);
foreach ($pm['recipients']['to'] as $uid) {
$user = get_user($uid);
$msg_to_list[] = new xmlrpcval(array('user_id' => new xmlrpcval($user['uid'], 'string'), 'username' => new xmlrpcval(basic_clean($user['username']), 'base64'), 'user_type' => check_return_user_type($user['username'])), 'struct');
if (($pm['folder'] == 2 or $pm['folder'] == 3) && !$avatar) {
$avatar = $user['avatar'];
}
}
} else {
$user = get_user($pm['toid']);
$msg_to_list[] = new xmlrpcval(array('user_id' => new xmlrpcval($user['uid'], 'string'), 'username' => new xmlrpcval(basic_clean($user['username']), 'base64'), 'user_type' => check_return_user_type($user['username'])), 'struct');
if ($pm['folder'] == 2 or $pm['folder'] == 3) {
$avatar = $user['avatar'];
}
}
$show_bcc = 0;
// If we have any BCC recipients and this user is an Administrator, add them on to the query
if (count($pm['recipients']['bcc']) > 0 && $mybb->usergroup['cancp'] == 1) {
foreach ($pm['recipients']['bcc'] as $uid) {
$user = get_user($uid);
$msg_to_list[] = new xmlrpcval(array('user_id' => new xmlrpcval($user['uid'], 'string'), 'username' => new xmlrpcval(basic_clean($user['username']), 'base64'), 'user_type' => check_return_user_type($user['username'])), 'struct');
}
}
if (!$avatar) {
$avatar = $pm['avatar'];
}
//$display_user = ($box_id == 'inbox') ? $message['from'] : $msg_to[0];
$is_online = false;
$timecut = TIME_NOW - $mybb->settings['wolcutoff'];
if ($pm['lastactive'] > $timecut && ($pm['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1) && $pm['lastvisit'] != $pm['lastactive']) {
$is_online = true;
}
$result = new xmlrpcval(array('result' => new xmlrpcval(true, 'boolean'), 'result_text' => new xmlrpcval('', 'base64'), 'msg_from' => new xmlrpcval($pm['username'], 'base64'), 'msg_from_id' => new xmlrpcval($pm['fromid'], 'string'), 'msg_to' => new xmlrpcval($msg_to_list, 'array'), 'icon_url' => new xmlrpcval(absolute_url($avatar), 'string'), 'sent_date' => new xmlrpcval(mobiquo_iso8601_encode($pm['dateline']), 'dateTime.iso8601'), 'msg_subject' => new xmlrpcval($pm['subject'], 'base64'), 'text_body' => new xmlrpcval(process_post($pm['message'], $input['return_html']), 'base64'), 'is_online' => new xmlrpcval($is_online, 'boolean'), 'allow_smilies' => new xmlrpcval(true, 'boolean')), 'struct');
return new xmlrpcresp($result);
}
function get_box_func($xmlrpc_params)
{
global $db, $auth, $user, $cache, $config, $phpbb_home, $phpbb_root_path, $phpEx;
$params = php_xmlrpc_decode($xmlrpc_params);
$user->setup('ucp');
if (!$user->data['is_registered']) {
trigger_error('LOGIN_EXPLAIN_UCP');
}
if (!$config['allow_privmsg']) {
trigger_error('Module not accessible');
}
if (!isset($params[0])) {
trigger_error('UNKNOWN_FOLDER');
}
// get folder id from parameters
$folder_id = intval($params[0]);
if (PRIVMSGS_INBOX !== $folder_id) {
$folder_id = PRIVMSGS_SENTBOX;
}
list($start, $limit, $page) = process_page($params[1], $params[2]);
// Grab icons
//$icons = $cache->obtain_icons();
$user_id = $user->data['user_id'];
include_once $phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx;
$folder = get_folder($user_id, $folder_id);
include $phpbb_root_path . 'includes/ucp/ucp_pm_viewfolder.' . $phpEx;
$folder_info = get_pm_from($folder_id, $folder, $user_id);
$address_list = array();
// Build Recipient List if in outbox/sentbox - max two additional queries
if ($folder_id == PRIVMSGS_OUTBOX || $folder_id == PRIVMSGS_SENTBOX) {
$recipient_list = $address = array();
foreach ($folder_info['rowset'] as $message_id => $row) {
$address[$message_id] = rebuild_header(array('to' => $row['to_address'], 'bcc' => $row['bcc_address']));
$_save = array('u', 'g');
foreach ($_save as $save) {
if (isset($address[$message_id][$save]) && sizeof($address[$message_id][$save])) {
foreach (array_keys($address[$message_id][$save]) as $ug_id) {
$recipient_list[$save][$ug_id] = array('name' => $user->lang['NA'], 'colour' => '');
}
}
}
}
$_types = array('u', 'g');
foreach ($_types as $ug_type) {
if (!empty($recipient_list[$ug_type])) {
if ($ug_type == 'u') {
$sql = 'SELECT user_id as id, username as name, user_colour as colour
FROM ' . USERS_TABLE . '
WHERE ';
} else {
$sql = 'SELECT group_id as id, group_name as name, group_colour as colour, group_type
FROM ' . GROUPS_TABLE . '
WHERE ';
}
$sql .= $db->sql_in_set($ug_type == 'u' ? 'user_id' : 'group_id', array_map('intval', array_keys($recipient_list[$ug_type])));
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if ($ug_type == 'g') {
$row['name'] = $row['group_type'] == GROUP_SPECIAL ? $user->lang['G_' . $row['name']] : $row['name'];
}
$recipient_list[$ug_type][$row['id']] = array('id' => $row['id'], 'name' => $row['name'], 'colour' => $row['colour']);
}
$db->sql_freeresult($result);
}
}
foreach ($address as $message_id => $adr_ary) {
foreach ($adr_ary as $type => $id_ary) {
foreach ($id_ary as $ug_id => $_id) {
$address_list[$message_id][] = $recipient_list[$type][$ug_id];
}
}
}
unset($recipient_list, $address);
}
// get unread count in inbox only
if (PRIVMSGS_INBOX === $folder_id) {
$sql = 'SELECT COUNT(msg_id) as num_messages
FROM ' . PRIVMSGS_TO_TABLE . '
WHERE pm_unread = 1
AND folder_id = ' . PRIVMSGS_INBOX . '
AND user_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$unread_num = (int) $db->sql_fetchfield('num_messages');
$db->sql_freeresult($result);
} else {
$unread_num = 0;
}
$sql = 'SELECT COUNT(msg_id) as num_messages
FROM ' . PRIVMSGS_TO_TABLE . '
WHERE folder_id = ' . $folder_id . '
AND user_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$total_num = (int) $db->sql_fetchfield('num_messages');
$db->sql_freeresult($result);
$sql = 'SELECT t.*, p.*, u.username, u.user_avatar, u.user_avatar_type, u.user_id
FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . " u\r\r\n WHERE t.user_id = {$user_id}\r\r\n AND p.author_id = u.user_id\r\r\n AND t.folder_id = {$folder_id}\r\r\n AND t.msg_id = p.msg_id\r\r\n ORDER BY p.message_time DESC";
$result = $db->sql_query_limit($sql, $limit, $start);
$total_message_count = $total_unread_count = 0;
$online_cache = array();
while ($row = $db->sql_fetchrow($result)) {
$msg_state = 2;
// message read
if ($row['pm_unread']) {
$msg_state = 1;
} else {
if ($row['pm_replied']) {
$msg_state = 3;
} else {
if ($row['pm_forwarded']) {
$msg_state = 4;
}
}
}
if ($folder_id == PRIVMSGS_OUTBOX || $folder_id == PRIVMSGS_SENTBOX) {
$msg_to_list = $address_list[$row['msg_id']];
} else {
$msg_to_list = array(array('id' => $user->data['user_id'], 'name' => $user->data['username']));
}
$msg_to = array();
foreach ($msg_to_list as $address) {
$msg_to[] = new xmlrpcval(array('user_id' => new xmlrpcval($address['id'], 'string'), 'username' => new xmlrpcval(basic_clean($address['name']), 'base64'), 'user_type' => check_return_user_type($address['name'])), 'struct');
}
$sent_date = mobiquo_iso8601_encode($row['message_time']);
//$icon_url = (!empty($icons[$row['icon_id']])) ? $phpbb_home . $config['icons_path'] . '/' . $icons[$row['icon_id']]['img'] : '';
$icon_url = $user->optionget('viewavatars') ? get_user_avatar_url($row['user_avatar'], $row['user_avatar_type']) : '';
$msg_subject = html_entity_decode(strip_tags(censor_text($row['message_subject'])));
$short_content = censor_text($row['message_text']);
$short_content = preg_replace('/\\[url.*?\\].*?\\[\\/url.*?\\]/', '[url]', $short_content);
$short_content = preg_replace('/\\[img.*?\\].*?\\[\\/img.*?\\]/', '[img]', $short_content);
$short_content = preg_replace('/[\\n\\r\\t]+/', ' ', $short_content);
strip_bbcode($short_content);
$short_content = html_entity_decode($short_content);
$short_content = substr($short_content, 0, 200);
if ($config['load_onlinetrack'] && !isset($online_cache[$row['user_id']])) {
$sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline
FROM ' . SESSIONS_TABLE . '
WHERE session_user_id=' . $row['user_id'] . '
GROUP BY session_user_id';
$online_result = $db->sql_query($sql);
$online_info = $db->sql_fetchrow($online_result);
$db->sql_freeresult($online_result);
$update_time = $config['load_online_time'] * 60;
$online_cache[$row['user_id']] = time() - $update_time < $online_info['online_time'] && ($online_info['viewonline'] || $auth->acl_get('u_viewonline')) ? true : false;
}
$is_online = isset($online_cache[$row['user_id']]) ? $online_cache[$row['user_id']] : false;
$pm_list[] = new xmlrpcval(array('msg_id' => new xmlrpcval($row['msg_id']), 'msg_state' => new xmlrpcval($msg_state, 'int'), 'sent_date' => new xmlrpcval($sent_date, 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($row['message_time'], 'string'), 'msg_from' => new xmlrpcval(basic_clean($row['username']), 'base64'), 'msg_from_id' => new xmlrpcval($row['user_id']), 'icon_url' => new xmlrpcval($icon_url), 'msg_to' => new xmlrpcval($msg_to, 'array'), 'msg_subject' => new xmlrpcval($msg_subject, 'base64'), 'short_content' => new xmlrpcval($short_content, 'base64'), 'is_online' => new xmlrpcval($is_online, 'boolean')), 'struct');
}
$db->sql_freeresult($result);
$result = new xmlrpcval(array('total_message_count' => new xmlrpcval($total_num, 'int'), 'total_unread_count' => new xmlrpcval($unread_num, 'int'), 'list' => new xmlrpcval($pm_list, 'array')), 'struct');
return new xmlrpcresp($result);
}
function m_get_report_post_func()
{
global $template, $auth, $user;
$posts = array();
foreach ($template->_tpldata['postrow'] as $postinfo) {
$posts[] = $postinfo['POST_ID'];
}
$posts = get_post_data($posts);
$post_list = array();
foreach ($template->_tpldata['postrow'] as $postinfo) {
$post = $posts[$postinfo['POST_ID']];
if (empty($post['forum_id'])) {
$user->setup('viewforum');
$post['forum_id'] = 0;
$post['forum_name'] = $user->lang['ANNOUNCEMENTS'];
}
$post_list[] = new xmlrpcval(array('forum_id' => new xmlrpcval($post['forum_id']), 'forum_name' => new xmlrpcval(basic_clean($post['forum_name']), 'base64'), 'topic_id' => new xmlrpcval($post['topic_id']), 'topic_title' => new xmlrpcval(basic_clean($post['topic_title']), 'base64'), 'post_id' => new xmlrpcval($post['post_id']), 'post_title' => new xmlrpcval(basic_clean($post['post_subject']), 'base64'), 'post_author_name' => new xmlrpcval(basic_clean($post['username']), 'base64'), 'icon_url' => new xmlrpcval(get_user_avatar_url($post['user_avatar'], $post['user_avatar_type'])), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($post['post_time']), 'dateTime.iso8601'), 'short_content' => new xmlrpcval(process_short_content($post['post_text']), 'base64'), 'can_delete' => new xmlrpcval($auth->acl_get('m_delete', $forum_id), 'boolean')), 'struct');
}
$response = new xmlrpcval(array('total_report_num' => new xmlrpcval($template->_rootref['TOTAL'], 'int'), 'reports' => new xmlrpcval($post_list, 'array')), 'struct');
return new xmlrpcresp($response);
}
function get_topic_func($xmlrpc_params)
{
global $db, $auth, $user, $config;
$user->setup('viewforum');
$params = php_xmlrpc_decode($xmlrpc_params);
list($start, $limit) = process_page($params[1], $params[2]);
// get forum id from parameters
$forum_id = intval($params[0]);
if (!$forum_id) {
trigger_error('NO_FORUM');
}
// check if need sticky/announce topic only
$topic_type = '';
if (isset($params[3])) {
// check if need sticky topic only
if ($params[3] == 'TOP') {
$topic_type = POST_STICKY;
$start = 0;
$limit = 20;
} else {
if ($params[3] == 'ANN') {
$topic_type = POST_ANNOUNCE . ', ' . POST_GLOBAL;
$start = 0;
$limit = 20;
}
}
}
// $default_sort_days = (!empty($user->data['user_topic_show_days'])) ? $user->data['user_topic_show_days'] : 0;
// $default_sort_key = (!empty($user->data['user_topic_sortby_type'])) ? $user->data['user_topic_sortby_type'] : 't';
// $default_sort_dir = (!empty($user->data['user_topic_sortby_dir'])) ? $user->data['user_topic_sortby_dir'] : 'd';
//
// $sort_days = request_var('st', $default_sort_days); // default to get all topic
// $sort_key = request_var('sk', $default_sort_key); // default sort by last post time
// $sort_dir = request_var('sd', $default_sort_dir); // default sort as DESC
$sort_days = 0;
$sort_key = 't';
$sort_dir = 'd';
//------- Grab appropriate forum data --------
$sql = "SELECT f.* FROM " . FORUMS_TABLE . " f WHERE f.forum_id = {$forum_id}";
$result = $db->sql_query($sql);
$forum_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// Forum does not exist
if (!$forum_data) {
trigger_error('NO_FORUM');
}
// Can not get topics from link forum
if ($forum_data['forum_type'] == FORUM_LINK) {
trigger_error('NO_FORUM');
}
// Permissions check
if (!$auth->acl_gets('f_list', 'f_read', $forum_id) || $forum_data['forum_type'] == FORUM_LINK && $forum_data['forum_link'] && !$auth->acl_get('f_read', $forum_id)) {
if ($user->data['user_id'] != ANONYMOUS) {
trigger_error('SORRY_AUTH_READ');
}
trigger_error('LOGIN_VIEWFORUM');
}
// Forum is passworded
if ($forum_data['forum_password'] && !check_forum_password($forum_id)) {
trigger_error('LOGIN_FORUM');
}
if (!$auth->acl_get('f_read', $forum_id)) {
trigger_error('NO_READ_ACCESS');
}
// Topic ordering options
$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');
// Limit topics to certain time frame, obtain correct topic count
// global announcements must not be counted, normal announcements have to
// be counted, as forum_topics(_real) includes them
$sql_approved = $auth->acl_get('m_approve', $forum_id) ? '' : ' AND t.topic_approved = 1 ';
// Get all shadow topics in this forum
$sql = 'SELECT t.topic_moved_id, t.topic_id
FROM ' . TOPICS_TABLE . ' t
WHERE t.forum_id = ' . $forum_id . '
AND t.topic_type IN (' . POST_NORMAL . ', ' . POST_STICKY . ', ' . POST_ANNOUNCE . ', ' . POST_GLOBAL . ')
AND t.topic_status = ' . ITEM_MOVED . ' ' . $sql_approved;
$result = $db->sql_query($sql);
$shadow_topic_list = array();
while ($row = $db->sql_fetchrow($result)) {
$shadow_topic_list[$row['topic_moved_id']] = $row['topic_id'];
}
$db->sql_freeresult($result);
// Pick out those shadow topics that the user has no permission to access
if (!empty($shadow_topic_list)) {
$sql = 'SELECT t.topic_id, t.forum_id
FROM ' . TOPICS_TABLE . ' t
WHERE ' . $db->sql_in_set('t.topic_id', array_keys($shadow_topic_list));
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if ($auth->acl_get('f_read', $row['forum_id'])) {
unset($shadow_topic_list[$row['topic_id']]);
}
}
$db->sql_freeresult($result);
}
// Grab all topic data
$topic_list = array();
$sql_limit = $limit;
// num of topics needs to be return, default is 20, at most 50
$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . ($sort_dir == 'd' ? 'DESC' : 'ASC');
$sql_shadow_out = empty($shadow_topic_list) ? '' : 'AND ' . $db->sql_in_set('t.topic_moved_id', $shadow_topic_list, true);
// If the user is trying to reach late pages, start searching from the end
$store_reverse = false;
$unread_sticky_num = $unread_announce_count = 0;
//get subscribe users
$user_watch_row = array();
$sql = 'SELECT * FROM ' . TOPICS_WATCH_TABLE . ' WHERE user_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$user_watch_row[$row['topic_id']] = $row['notify_status'];
}
$db->sql_freeresult($result);
if (!empty($topic_type)) {
$sql = 'SELECT t.*, u.user_avatar, u.user_avatar_type,bm.topic_id as bookmarked
FROM ' . TOPICS_TABLE . ' t
LEFT JOIN ' . USERS_TABLE . ' u ON (t.topic_poster = u.user_id)
LEFT JOIN ' . BOOKMARKS_TABLE . ' bm ON (bm.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = bm.topic_id)
WHERE t.forum_id IN (' . $forum_id . ', 0)
AND t.topic_type IN (' . $topic_type . ') ' . $sql_shadow_out . ' ' . $sql_approved . '
ORDER BY ' . $sql_sort_order;
$result = $db->sql_query_limit($sql, $sql_limit, $start);
} else {
if ($user->data['user_id'] != ANONYMOUS) {
// get total number of unread sticky topics number
$sql = 'SELECT t.topic_id, t.topic_last_post_time
FROM ' . TOPICS_TABLE . ' t
WHERE t.forum_id = ' . $forum_id . '
AND t.topic_type = ' . POST_STICKY . ' ' . $sql_shadow_out . ' ' . $sql_approved;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if (empty($forum_id) || empty($row['topic_id'])) {
continue;
}
$topic_tracking = get_complete_topic_tracking($forum_id, $row['topic_id']);
if (isset($topic_tracking[$row['topic_id']]) && $topic_tracking[$row['topic_id']] < $row['topic_last_post_time']) {
$unread_sticky_num++;
}
}
$db->sql_freeresult($result);
// get total number of unread announce topics number
$sql = 'SELECT t.topic_id, t.topic_last_post_time
FROM ' . TOPICS_TABLE . ' t
WHERE t.forum_id IN (' . $forum_id . ', 0)
AND t.topic_type IN (' . POST_ANNOUNCE . ', ' . POST_GLOBAL . ') ' . $sql_shadow_out . ' ' . $sql_approved;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if (empty($forum_id) || empty($row['topic_id'])) {
continue;
}
$topic_tracking = get_complete_topic_tracking($forum_id, $row['topic_id']);
if (isset($topic_tracking[$row['topic_id']]) && $topic_tracking[$row['topic_id']] < $row['topic_last_post_time']) {
$unread_announce_count++;
}
}
$db->sql_freeresult($result);
}
// get total number of normal topics
$sql = 'SELECT count(t.topic_id) AS num_topics
FROM ' . TOPICS_TABLE . ' t
WHERE t.forum_id = ' . $forum_id . '
AND t.topic_type = ' . POST_NORMAL . ' ' . $sql_shadow_out . ' ' . $sql_approved;
$result = $db->sql_query($sql);
$topics_count = (int) $db->sql_fetchfield('num_topics');
$db->sql_freeresult($result);
if ($start > $topics_count / 2) {
$store_reverse = true;
if ($start + $sql_limit > $topics_count) {
$sql_limit = min($sql_limit, max(1, $topics_count - $start));
}
// Select the sort order
$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . ($sort_dir == 'd' ? 'ASC' : 'DESC');
$start = max(0, $topics_count - $sql_limit - $start);
}
$sql = 'SELECT t.*, u.user_avatar, u.user_avatar_type,bm.topic_id as bookmarked
FROM ' . TOPICS_TABLE . ' t
LEFT JOIN ' . USERS_TABLE . ' u ON (t.topic_poster = u.user_id)
LEFT JOIN ' . BOOKMARKS_TABLE . ' bm ON (bm.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = bm.topic_id)
WHERE t.forum_id = ' . $forum_id . '
AND t.topic_type = ' . POST_NORMAL . ' ' . $sql_shadow_out . ' ' . $sql_approved . '
ORDER BY ' . $sql_sort_order;
$result = $db->sql_query_limit($sql, $sql_limit, $start);
}
$tids = array();
$rowset = array();
while ($row = $db->sql_fetchrow($result)) {
$rowset[] = $row;
$tids[] = $row['topic_moved_id'] ? $row['topic_moved_id'] : $row['topic_id'];
}
$db->sql_freeresult($result);
// get participated users of each topic
// get_participated_user_avatars($tids);
// global $topic_users, $user_avatar;
$topic_list = array();
foreach ($rowset as $row) {
$replies = $auth->acl_get('m_approve', $forum_id) ? $row['topic_replies_real'] : $row['topic_replies'];
$short_content = get_short_content($row['topic_first_post_id']);
$user_avatar_url = get_user_avatar_url($row['user_avatar'], $row['user_avatar_type']);
$new_post = false;
if ($user->data['user_id'] != ANONYMOUS) {
if (empty($forum_id) || empty($row['topic_id'])) {
continue;
}
$topic_tracking = get_complete_topic_tracking($forum_id, $row['topic_id']);
$new_post = $topic_tracking[$row['topic_id']] < $row['topic_last_post_time'] ? true : false;
}
$allow_change_type = $auth->acl_get('m_', $forum_id) || $user->data['is_registered'] && $user->data['user_id'] == $row['topic_poster'] ? true : false;
$topic_id = $row['topic_moved_id'] ? $row['topic_moved_id'] : $row['topic_id'];
// $icon_urls = array();
// foreach($topic_users[$topic_id] as $posterid){
// $icon_urls[] = new xmlrpcval($user_avatar[$posterid], 'string');
// }
$can_rename = $user->data['is_registered'] && ($auth->acl_get('m_edit', $forum_id) || $user->data['user_id'] == $row['topic_poster'] && $auth->acl_get('f_edit', $forum_id) && ($row['topic_time'] > time() - $config['edit_time'] * 60 || !$config['edit_time']));
$xmlrpc_topic = new xmlrpcval(array('forum_id' => new xmlrpcval($forum_id), 'topic_id' => new xmlrpcval($row['topic_moved_id'] ? $row['topic_moved_id'] : $row['topic_id']), 'topic_title' => new xmlrpcval(html_entity_decode(strip_tags(censor_text($row['topic_title'])), ENT_QUOTES, 'UTF-8'), 'base64'), 'topic_author_id' => new xmlrpcval($row['topic_first_post_id'], 'string'), 'topic_author_name' => new xmlrpcval(html_entity_decode($row['topic_first_poster_name']), 'base64'), 'last_reply_time' => new xmlrpcval(mobiquo_iso8601_encode($row['topic_last_post_time']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($row['topic_last_post_time'], 'string'), 'reply_number' => new xmlrpcval($replies, 'int'), 'view_number' => new xmlrpcval($row['topic_views'], 'int'), 'short_content' => new xmlrpcval($short_content, 'base64'), 'new_post' => new xmlrpcval($new_post, 'boolean'), 'icon_url' => new xmlrpcval($user_avatar_url), 'attachment' => new xmlrpcval($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment'] ? 1 : 0, 'string'), 'can_delete' => new xmlrpcval($auth->acl_get('m_delete', $forum_id), 'boolean'), 'can_move' => new xmlrpcval($auth->acl_get('m_move', $forum_id), 'boolean'), 'can_subscribe' => new xmlrpcval(($config['email_enable'] || $config['jab_enable']) && $config['allow_topic_notify'] && $user->data['is_registered'], 'boolean'), 'is_subscribed' => new xmlrpcval(isset($user_watch_row[$topic_id]) ? true : false, 'boolean'), 'can_close' => new xmlrpcval($auth->acl_get('m_lock', $forum_id) || $auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $row['topic_poster'], 'boolean'), 'is_closed' => new xmlrpcval($row['topic_status'] == ITEM_LOCKED, 'boolean'), 'can_stick' => new xmlrpcval($allow_change_type && $auth->acl_get('f_sticky', $forum_id), 'boolean'), 'is_sticky' => new xmlrpcval($row['topic_type'] == POST_STICKY, 'boolean'), 'can_approve' => new xmlrpcval($auth->acl_get('m_approve', $forum_id) && !$row['topic_approved'], 'boolean'), 'is_approved' => new xmlrpcval($row['topic_approved'] ? true : false, 'boolean'), 'can_rename' => new xmlrpcval($can_rename, 'boolean')), 'struct');
$topic_list[] = $xmlrpc_topic;
unset($xmlrpc_topic);
}
if ($store_reverse) {
$topic_list = array_reverse($topic_list);
}
if (!empty($topic_type)) {
$topic_num = count($topic_list);
} else {
$topic_num = $topics_count;
}
$allowed = $config['max_attachments'] && $auth->acl_get('f_attach', $forum_id) && $auth->acl_get('u_attach') && $config['allow_attachments'] && @ini_get('file_uploads') != '0' && strtolower(@ini_get('file_uploads')) != 'off';
$max_attachment = $auth->acl_get('a_') || $auth->acl_get('m_', $forum_id) ? 99 : ($allowed ? $config['max_attachments'] : 0);
$max_png_size = $auth->acl_get('a_') || $auth->acl_get('m_', $forum_id) ? 10485760 : ($allowed ? $config['max_filesize'] === '0' ? 10485760 : $config['max_filesize'] : 0);
$max_jpg_size = $auth->acl_get('a_') || $auth->acl_get('m_', $forum_id) ? 10485760 : ($allowed ? $config['max_filesize'] === '0' ? 10485760 : $config['max_filesize'] : 0);
$read_only_forums = explode(",", $config['tapatalk_forum_read_only']);
$can_post = true;
if (empty($read_only_forums) || !is_array($read_only_forums)) {
$read_only_forums = array();
}
if (!$auth->acl_get('f_post', $forum_id) || in_array($forum_id, $read_only_forums)) {
$can_post = false;
}
$response = new xmlrpcval(array('total_topic_num' => new xmlrpcval($topic_num, 'int'), 'unread_sticky_count' => new xmlrpcval($unread_sticky_num, 'int'), 'unread_announce_count' => new xmlrpcval($unread_announce_count, 'int'), 'forum_id' => new xmlrpcval($forum_id, 'string'), 'forum_name' => new xmlrpcval(html_entity_decode($forum_data['forum_name']), 'base64'), 'can_post' => new xmlrpcval($can_post, 'boolean'), 'can_upload' => new xmlrpcval($allowed, 'boolean'), 'max_attachment' => new xmlrpcval($max_attachment, 'int'), 'max_png_size' => new xmlrpcval($max_png_size, 'int'), 'max_jpg_size' => new xmlrpcval($max_jpg_size, 'int'), 'topics' => new xmlrpcval($topic_list, 'array')), 'struct');
return new xmlrpcresp($response);
}
function reply_post_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups, $tid, $pid, $visible, $thread, $post;
$input = Tapatalk_Input::filterXmlInput(array('forum_id' => Tapatalk_Input::INT, 'topic_id' => Tapatalk_Input::INT, 'subject' => Tapatalk_Input::STRING, 'text_body' => Tapatalk_Input::STRING, 'attachment_id_array' => Tapatalk_Input::RAW, 'group_id' => Tapatalk_Input::STRING, 'return_html' => Tapatalk_Input::INT), $xmlrpc_params);
$lang->load("newreply");
$parser = new Tapatalk_Parser();
$tid = $input['topic_id'];
$options = array("limit" => 1);
$query = $db->simple_select("threads", "*", "tid='" . $tid . "'");
if ($db->num_rows($query) == 0) {
return xmlrespfalse($lang->error_invalidthread);
}
$thread = $db->fetch_array($query);
$fid = $thread['fid'];
// Get forum info
$forum = get_forum($fid);
if (!$forum) {
return xmlrespfalse($lang->error_invalidforum);
}
$forumpermissions = forum_permissions($fid);
if ($thread['visible'] == 0 && !is_moderator($fid) || $thread['visible'] < 0) {
return xmlrespfalse($lang->error_invalidthread);
}
if ($forum['open'] == 0 || $forum['type'] != "f") {
return xmlrespfalse($lang->error_closedinvalidforum);
}
if ($mybb->user['uid'] < 1 || $forumpermissions['canview'] == 0 || $forumpermissions['canpostreplys'] == 0 || $mybb->user['suspendposting'] == 1) {
return tt_no_permission();
}
if ($forumpermissions['canonlyviewthreads'] == 1 && $thread['uid'] != $mybb->user['uid']) {
return tt_no_permission();
}
tt_check_forum_password($forum['fid']);
// Check to see if the thread is closed, and if the user is a mod.
if (!is_moderator($fid, "caneditposts")) {
if ($thread['closed'] == 1) {
return xmlrespfalse($lang->redirect_threadclosed);
}
}
// Is the currently logged in user a moderator of this forum?
if (is_moderator($fid)) {
$ismod = true;
} else {
$ismod = false;
}
if (!empty($input['group_id'])) {
$posthash = $input['group_id'];
} else {
$posthash = md5($thread['tid'] . $mybb->user['uid'] . random_str());
}
if ($mybb->settings['maxposts'] > 0 && $mybb->usergroup['cancp'] != 1) {
$daycut = TIME_NOW - 60 * 60 * 24;
$query = $db->simple_select("posts", "COUNT(*) AS posts_today", "uid='{$mybb->user['uid']}' AND visible='1' AND dateline>{$daycut}");
$post_count = $db->fetch_field($query, "posts_today");
if ($post_count >= $mybb->settings['maxposts']) {
$lang->error_maxposts = $lang->sprintf($lang->error_maxposts, $mybb->settings['maxposts']);
return xmlrespfalse($lang->error_maxposts);
}
}
$username = $mybb->user['username'];
$uid = $mybb->user['uid'];
$user_check = "p.uid='{$uid}'";
if (version_compare($mybb->version, '1.8.0', '<')) {
$query = $db->simple_select("posts p", "p.pid, p.visible", "{$user_check} AND p.tid='{$thread['tid']}' AND p.subject='" . $db->escape_string($mybb->input['subject']) . "' AND p.message='" . $db->escape_string($mybb->input['message']) . "' AND p.posthash='" . $db->escape_string($mybb->input['posthash']) . "' AND p.visible != '-2'");
} else {
$query = $db->simple_select("posts p", "p.pid, p.visible", "{$user_check} AND p.tid='{$thread['tid']}' AND p.subject='" . $db->escape_string($mybb->get_input('subject')) . "' AND p.message='" . $db->escape_string($mybb->get_input('message')) . "' AND p.visible != '-2' AND p.dateline>" . (TIME_NOW - 600));
}
$duplicate_check = $db->fetch_field($query, "pid");
if ($duplicate_check) {
return xmlrespfalse($lang->error_post_already_submitted);
}
require_once MYBB_ROOT . "inc/datahandlers/post.php";
$posthandler = new PostDataHandler("insert");
$post = array("tid" => $input['topic_id'], "replyto" => 0, "fid" => $thread['fid'], "subject" => $input['subject'], "icon" => 0, "uid" => $uid, "username" => $username, "message" => $input['text_body'], "ipaddress" => get_ip(), "posthash" => $posthash);
if ($mybb->input['pid']) {
$post['pid'] = $mybb->input['pid'];
}
$post['savedraft'] = 0;
// Set up the post options from the input.
$post['options'] = array("signature" => 1, "subscriptionmethod" => $mybb->user['subscriptionmethod'] == 0 ? '' : $mybb->user['subscriptionmethod'], "disablesmilies" => 0);
$post['modoptions']['stickthread'] = $thread['sticky'];
$post['modoptions']['closethread'] = $thread['closed'];
$posthandler->set_data($post);
// Now let the post handler do all the hard work.
$valid_post = $posthandler->validate_post();
$post_errors = array();
// Fetch friendly error messages if this is an invalid post
if (!$valid_post) {
$post_errors = $posthandler->get_friendly_errors();
}
// Mark thread as read
require_once MYBB_ROOT . "inc/functions_indicators.php";
mark_thread_read($tid, $fid);
// One or more errors returned, fetch error list and throw to newreply page
if (count($post_errors) > 0) {
return xmlrespfalse(implode(" :: ", $post_errors));
} else {
$postinfo = $posthandler->insert_post();
$pid = $postinfo['pid'];
$visible = $postinfo['visible'];
tapatalk_push_reply();
tapatalk_push_quote();
tapatalk_push_tag();
// Deciding the fate
if ($visible == -2) {
$state = 1;
} elseif ($visible == 1) {
$state = 0;
} else {
$state = 1;
}
}
$pid = intval($pid);
if (!empty($input['group_id_esc'])) {
$db->update_query("attachments", array("pid" => $pid), "posthash='{$input['group_id_esc']}'");
}
// update thread attachment account
if (count($input['attachment_id_array']) > 0) {
update_thread_counters($tid, array("attachmentcount" => "+" . count($input['attachment_id_array'])));
}
$post = get_post($pid);
$parser_options = array();
$parser_options['allow_html'] = false;
$parser_options['allow_mycode'] = true;
$parser_options['allow_smilies'] = false;
$parser_options['allow_imgcode'] = true;
$parser_options['allow_videocode'] = true;
$parser_options['nl2br'] = (bool) $input['return_html'];
$parser_options['filter_badwords'] = 1;
if (!$post['username']) {
$post['username'] = $lang->guest;
}
if ($post['userusername']) {
$parser_options['me_username'] = $post['userusername'];
} else {
$parser_options['me_username'] = $post['username'];
}
$post['message'] = post_bbcode_clean($post['message']);
$post['message'] = $parser->parse_message($post['message'], $parser_options);
global $attachcache;
$attachcache = array();
if ($thread['attachmentcount'] > 0) {
// Now lets fetch all of the attachments for these posts.
$query = $db->simple_select("attachments", "*", "pid='{$pid}'");
while ($attachment = $db->fetch_array($query)) {
$attachcache[$attachment['pid']][$attachment['aid']] = $attachment;
}
}
$attachment_list = process_post_attachments($post['pid'], $post);
$can_delete = 0;
if ($mybb->user['uid'] == $post['uid']) {
if ($forumpermissions['candeletethreads'] == 1 && $postcounter == 1) {
$can_delete = 1;
} else {
if ($forumpermissions['candeleteposts'] == 1 && $postcounter != 1) {
$can_delete = 1;
}
}
}
$can_delete = (is_moderator($fid, "candeleteposts") || $can_delete == 1) && $mybb->user['uid'] != 0;
$result = new xmlrpcval(array('result' => new xmlrpcval(true, 'boolean'), 'result_text' => new xmlrpcval('', 'base64'), 'post_id' => new xmlrpcval($postinfo['pid'], 'string'), 'state' => new xmlrpcval($state, 'int'), 'post_author_id' => new xmlrpcval($mybb->user['uid'], 'string'), 'post_author_name' => new xmlrpcval(basic_clean($mybb->user['username']), 'base64'), 'icon_url' => new xmlrpcval(absolute_url($mybb->user['avatar']), 'string'), 'post_content' => new xmlrpcval(process_post($post['message'], $input['return_html']), 'base64'), 'can_edit' => new xmlrpcval(is_moderator($fid, "caneditposts") || $thread['closed'] == 0 && $forumpermissions['caneditposts'] == 1, 'boolean'), 'can_delete' => new xmlrpcval($can_delete, 'boolean'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode(TIME_NOW), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval(TIME_NOW, 'string'), 'attachments' => new xmlrpcval($attachment_list, 'array')), 'struct');
return new xmlrpcresp($result);
}
function reply_post_func($xmlrpc_params)
{
global $db, $auth, $user, $config, $phpbb_root_path, $phpEx, $mobiquo_config, $phpbb_home;
require_once 'include/emoji.php';
$user->setup('posting');
if (!$user->data['is_registered']) {
trigger_error('LOGIN_EXPLAIN_POST');
}
$params = php_xmlrpc_decode($xmlrpc_params);
// get parameters
$forum_id = isset($params[0]) ? intval($params[0]) : '';
$topic_id = isset($params[1]) ? intval($params[1]) : '';
$subject = isset($params[2]) ? $params[2] : '';
$text_body = isset($params[3]) ? $params[3] : '';
$text_body = emoji_unified_to_names($text_body);
$attach_list = isset($params[4]) ? $params[4] : array();
$_POST['attachment_data'] = isset($params[5]) && $params[5] ? unserialize(base64_decode($params[5])) : array();
$GLOBALS['return_html'] = isset($params[6]) ? $params[6] : false;
if (!$topic_id) {
trigger_error('NO_TOPIC');
}
if (utf8_clean_string($text_body) === '') {
trigger_error('TOO_FEW_CHARS');
}
$post_data = array();
$current_time = time();
// get topic data
$sql = 'SELECT *
FROM ' . TOPICS_TABLE . '
WHERE topic_id = ' . $topic_id;
$result = $db->sql_query($sql);
$post_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// get forum data
$sql = 'SELECT *
FROM ' . FORUMS_TABLE . "\n WHERE forum_type = " . FORUM_POST . ($post_data['forum_id'] ? "\n AND forum_id = '{$post_data['forum_id']}' " : '');
$result = $db->sql_query_limit($sql, 1);
$forum_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$post_data = array_merge($post_data, $forum_data);
if (!$post_data) {
trigger_error('NO_TOPIC');
}
// Use post_row values in favor of submitted ones...
$forum_id = !empty($post_data['forum_id']) ? (int) $post_data['forum_id'] : (int) $forum_id;
$topic_id = !empty($post_data['topic_id']) ? (int) $post_data['topic_id'] : (int) $topic_id;
// Need to login to passworded forum first?
if ($post_data['forum_password'] && !check_forum_password($forum_id)) {
trigger_error('LOGIN_FORUM');
}
// Check permissions
if ($user->data['is_bot']) {
trigger_error('NOT_AUTHORISED');
}
// Is the user able to read within this forum?
if (!$auth->acl_get('f_read', $forum_id)) {
if ($user->data['user_id'] != ANONYMOUS) {
trigger_error('USER_CANNOT_READ');
}
trigger_error('LOGIN_EXPLAIN_POST');
}
// Permission to do the reply
if (!$auth->acl_get('f_reply', $forum_id)) {
if ($user->data['user_id'] != ANONYMOUS) {
trigger_error('USER_CANNOT_REPLY');
}
trigger_error('LOGIN_EXPLAIN_POST');
}
// Is the user able to post within this forum?
if ($post_data['forum_type'] != FORUM_POST) {
trigger_error('USER_CANNOT_FORUM_POST');
}
// Forum/Topic locked?
if (($post_data['forum_status'] == ITEM_LOCKED || isset($post_data['topic_status']) && $post_data['topic_status'] == ITEM_LOCKED) && !$auth->acl_get('m_edit', $forum_id)) {
trigger_error($post_data['forum_status'] == ITEM_LOCKED ? 'FORUM_LOCKED' : 'TOPIC_LOCKED');
}
$subject = (strpos($subject, 'Re: ') !== 0 ? 'Re: ' : '') . ($subject ? $subject : censor_text($post_data['topic_title']));
$post_data['post_edit_locked'] = isset($post_data['post_edit_locked']) ? (int) $post_data['post_edit_locked'] : 0;
$post_data['post_subject'] = isset($post_data['topic_title']) ? $post_data['topic_title'] : '';
$post_data['topic_time_limit'] = isset($post_data['topic_time_limit']) ? $post_data['topic_time_limit'] ? (int) $post_data['topic_time_limit'] / 86400 : (int) $post_data['topic_time_limit'] : 0;
$post_data['poll_length'] = !empty($post_data['poll_length']) ? (int) $post_data['poll_length'] / 86400 : 0;
$post_data['poll_start'] = !empty($post_data['poll_start']) ? (int) $post_data['poll_start'] : 0;
$post_data['icon_id'] = 0;
$post_data['poll_options'] = array();
// Get Poll Data
if ($post_data['poll_start']) {
$sql = 'SELECT poll_option_text
FROM ' . POLL_OPTIONS_TABLE . "\n WHERE topic_id = {$topic_id}\n ORDER BY poll_option_id";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$post_data['poll_options'][] = trim($row['poll_option_text']);
}
$db->sql_freeresult($result);
}
$orig_poll_options_size = sizeof($post_data['poll_options']);
include $phpbb_root_path . 'includes/message_parser.' . $phpEx;
$message_parser = new parse_message();
// Set some default variables
$uninit = array('post_attachment' => 0, 'poster_id' => $user->data['user_id'], 'enable_magic_url' => 0, 'topic_status' => 0, 'topic_type' => POST_NORMAL, 'post_subject' => '', 'topic_title' => '', 'post_time' => 0, 'post_edit_reason' => '', 'notify_set' => 0);
foreach ($uninit as $var_name => $default_value) {
if (!isset($post_data[$var_name])) {
$post_data[$var_name] = $default_value;
}
}
unset($uninit);
// Always check if the submitted attachment data is valid and belongs to the user.
// Further down (especially in submit_post()) we do not check this again.
$message_parser->get_submitted_attachment_data($post_data['poster_id']);
$post_data['username'] = '';
$post_data['enable_urls'] = $post_data['enable_magic_url'];
$post_data['enable_sig'] = $config['allow_sig'] && $user->optionget('attachsig') ? true : false;
$post_data['enable_smilies'] = $config['allow_smilies'] && $user->optionget('smilies') ? true : false;
$post_data['enable_bbcode'] = $config['allow_bbcode'] && $user->optionget('bbcode') ? true : false;
$post_data['enable_urls'] = true;
$post_data['enable_magic_url'] = $post_data['drafts'] = false;
$check_value = ($post_data['enable_bbcode'] + 1 << 8) + ($post_data['enable_smilies'] + 1 << 4) + ($post_data['enable_urls'] + 1 << 2) + ($post_data['enable_sig'] + 1 << 1);
// Check if user is watching this topic
if ($config['allow_topic_notify'] && $user->data['is_registered']) {
$sql = 'SELECT topic_id
FROM ' . TOPICS_WATCH_TABLE . '
WHERE topic_id = ' . $topic_id . '
AND user_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$post_data['notify_set'] = (int) $db->sql_fetchfield('topic_id');
$db->sql_freeresult($result);
}
// HTML, BBCode, Smilies, Images and Flash status
$bbcode_status = $config['allow_bbcode'] && $auth->acl_get('f_bbcode', $forum_id) ? true : false;
$smilies_status = $bbcode_status && $config['allow_smilies'] && $auth->acl_get('f_smilies', $forum_id) ? true : false;
$img_status = $bbcode_status && $auth->acl_get('f_img', $forum_id) ? true : false;
$url_status = $config['allow_post_links'] ? true : false;
$flash_status = $bbcode_status && $auth->acl_get('f_flash', $forum_id) && $config['allow_post_flash'] ? true : false;
$quote_status = $auth->acl_get('f_reply', $forum_id) ? true : false;
$post_data['topic_cur_post_id'] = request_var('topic_cur_post_id', 0);
$post_data['post_subject'] = utf8_normalize_nfc($subject);
$message_parser->message = utf8_normalize_nfc(htmlspecialchars($text_body));
$post_data['username'] = utf8_normalize_nfc(request_var('username', $post_data['username'], true));
$post_data['post_edit_reason'] = '';
$post_data['orig_topic_type'] = $post_data['topic_type'];
$post_data['topic_type'] = request_var('topic_type', (int) $post_data['topic_type']);
$post_data['topic_time_limit'] = request_var('topic_time_limit', (int) $post_data['topic_time_limit']);
$post_data['icon_id'] = request_var('icon', 0);
$post_data['enable_bbcode'] = !$bbcode_status || isset($_POST['disable_bbcode']) ? false : true;
$post_data['enable_smilies'] = !$smilies_status || isset($_POST['disable_smilies']) ? false : true;
$post_data['enable_urls'] = isset($_POST['disable_magic_url']) ? 0 : 1;
$post_data['enable_sig'] = !$config['allow_sig'] || !$auth->acl_get('f_sigs', $forum_id) || !$auth->acl_get('u_sig') ? false : ($user->data['is_registered'] ? true : false);
if ($config['allow_topic_notify'] && $user->data['is_registered']) {
$notify = !$post_data['notify_set'] ? $user->data['user_notify'] : $post_data['notify_set'] ? true : false;
} else {
$notify = false;
}
$post_data['poll_title'] = utf8_normalize_nfc(request_var('poll_title', '', true));
$post_data['poll_length'] = request_var('poll_length', 0);
$post_data['poll_option_text'] = utf8_normalize_nfc(request_var('poll_option_text', '', true));
$post_data['poll_max_options'] = request_var('poll_max_options', 1);
$post_data['poll_vote_change'] = $auth->acl_get('f_votechg', $forum_id) && isset($_POST['poll_vote_change']) ? 1 : 0;
// Parse Attachments - before checksum is calculated
$message_parser->parse_attachments('fileupload', 'reply', $forum_id, true, false, false);
// Grab md5 'checksum' of new message
$message_md5 = md5($message_parser->message);
// Check checksum ... don't re-parse message if the same
if (sizeof($message_parser->warn_msg)) {
trigger_error(join("\n", $message_parser->warn_msg));
}
$message_parser->parse($post_data['enable_bbcode'], $config['allow_post_links'] ? $post_data['enable_urls'] : false, $post_data['enable_smilies'], $img_status, $flash_status, $quote_status, $config['allow_post_links']);
if ($config['flood_interval'] && !$auth->acl_get('f_ignoreflood', $forum_id)) {
// Flood check
$last_post_time = 0;
if ($user->data['is_registered']) {
$last_post_time = $user->data['user_lastpost_time'];
} else {
$sql = 'SELECT post_time AS last_post_time
FROM ' . POSTS_TABLE . "\n WHERE poster_ip = '" . $user->ip . "'\n AND post_time > " . ($current_time - $config['flood_interval']);
$result = $db->sql_query_limit($sql, 1);
if ($row = $db->sql_fetchrow($result)) {
$last_post_time = $row['last_post_time'];
}
$db->sql_freeresult($result);
}
if ($last_post_time && $current_time - $last_post_time < intval($config['flood_interval'])) {
trigger_error('FLOOD_ERROR');
}
}
// Validate username
if ($post_data['username'] && !$user->data['is_registered']) {
include $phpbb_root_path . 'includes/functions_user.' . $phpEx;
if (($result = validate_username($post_data['username'], !empty($post_data['post_username']) ? $post_data['post_username'] : '')) !== false) {
$user->add_lang('ucp');
trigger_error($result . '_USERNAME');
}
}
$post_data['poll_last_vote'] = isset($post_data['poll_last_vote']) ? $post_data['poll_last_vote'] : 0;
$poll = array();
// if (sizeof($message_parser->warn_msg))
// {
// return get_error();
// }
// DNSBL check
if ($config['check_dnsbl'] && $mobiquo_config['check_dnsbl']) {
if (($dnsbl = $user->check_dnsbl('post')) !== false) {
trigger_error(sprintf($user->lang['IP_BLACKLISTED'], $user->ip, $dnsbl[1]));
}
}
// Store message, sync counters
$data = array('topic_title' => empty($post_data['topic_title']) ? $post_data['post_subject'] : $post_data['topic_title'], 'topic_first_post_id' => isset($post_data['topic_first_post_id']) ? (int) $post_data['topic_first_post_id'] : 0, 'topic_last_post_id' => isset($post_data['topic_last_post_id']) ? (int) $post_data['topic_last_post_id'] : 0, 'topic_time_limit' => (int) $post_data['topic_time_limit'], 'topic_attachment' => isset($post_data['topic_attachment']) ? (int) $post_data['topic_attachment'] : 0, 'post_id' => 0, 'topic_id' => (int) $topic_id, 'forum_id' => (int) $forum_id, 'icon_id' => (int) $post_data['icon_id'], 'poster_id' => (int) $post_data['poster_id'], 'enable_sig' => (bool) $post_data['enable_sig'], 'enable_bbcode' => (bool) $post_data['enable_bbcode'], 'enable_smilies' => (bool) $post_data['enable_smilies'], 'enable_urls' => (bool) $post_data['enable_urls'], 'enable_indexing' => (bool) $post_data['enable_indexing'], 'message_md5' => (string) $message_md5, 'post_time' => isset($post_data['post_time']) ? (int) $post_data['post_time'] : $current_time, 'post_checksum' => isset($post_data['post_checksum']) ? (string) $post_data['post_checksum'] : '', 'post_edit_reason' => $post_data['post_edit_reason'], 'post_edit_user' => isset($post_data['post_edit_user']) ? (int) $post_data['post_edit_user'] : 0, 'forum_parents' => $post_data['forum_parents'], 'forum_name' => $post_data['forum_name'], 'notify' => $notify, 'notify_set' => $post_data['notify_set'], 'poster_ip' => isset($post_data['poster_ip']) ? $post_data['poster_ip'] : $user->ip, 'post_edit_locked' => (int) $post_data['post_edit_locked'], 'bbcode_bitfield' => $message_parser->bbcode_bitfield, 'bbcode_uid' => $message_parser->bbcode_uid, 'message' => $message_parser->message, 'attachment_data' => $message_parser->attachment_data, 'filename_data' => $message_parser->filename_data, 'topic_approved' => isset($post_data['topic_approved']) ? $post_data['topic_approved'] : false, 'post_approved' => isset($post_data['post_approved']) ? $post_data['post_approved'] : false, 'post_expire_time' => -1);
include $phpbb_root_path . 'includes/functions_posting.' . $phpEx;
$update_message = true;
$cwd = getcwd();
chdir('../');
$phpbb_root_path_tmp = $phpbb_root_path;
$phpbb_root_path = './';
$redirect_url = submit_post('reply', $post_data['post_subject'], $post_data['username'], $post_data['topic_type'], $poll, $data, $update_message);
chdir($cwd);
$phpbb_root_path = $phpbb_root_path_tmp;
// Check the permissions for post approval, as well as the queue trigger where users are put on approval with a post count lower than specified. Moderators are not affected.
$approved = true;
if (($config['enable_queue_trigger'] && $user->data['user_posts'] < $config['queue_trigger_posts'] || !$auth->acl_get('f_noapprove', $data['forum_id'])) && !$auth->acl_get('m_approve', $data['forum_id'])) {
$approved = false;
}
$reply_success = false;
$post_id = '';
if ($redirect_url) {
preg_match('/&p=(\\d+)/', $redirect_url, $matches);
$post_id = $matches[1];
$reply_success = true;
// get new post_content
$message = censor_text($data['message']);
$quote_wrote_string = $user->lang['WROTE'];
$message = str_replace('[/quote:' . $data['bbcode_uid'] . ']', '[/quote]', $message);
$message = preg_replace('/\\[quote(?:="(.*?)")?:' . $data['bbcode_uid'] . '\\]/ise', "'[quote]' . ('\$1' ? '\$1' . ' {$quote_wrote_string}:\n' : '\n')", $message);
$blocks = preg_split('/(\\[\\/?quote\\])/i', $message, -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);
$quote_level = 0;
$message = '';
foreach ($blocks as $block) {
if ($block == '[quote]') {
if ($quote_level == 0) {
$message .= $block;
}
$quote_level++;
} else {
if ($block == '[/quote]') {
if ($quote_level <= 1) {
$message .= $block;
}
if ($quote_level >= 1) {
$quote_level--;
}
} else {
if ($quote_level <= 1) {
$message .= $block;
}
}
}
}
$message = preg_replace('/\\[(youtube|video|googlevideo|gvideo):' . $data['bbcode_uid'] . '\\](.*?)\\[\\/\\1:' . $data['bbcode_uid'] . '\\]/sie', "video_bbcode_format('\$1', '\$2')", $message);
$message = preg_replace('/\\[(BBvideo)[\\d, ]+:' . $row['bbcode_uid'] . '\\](.*?)\\[\\/\\1:' . $row['bbcode_uid'] . '\\]/si', "[url=\$2]YouTube Video[/url]", $message);
$message = preg_replace('/\\[(spoil|spoiler):' . $row['bbcode_uid'] . '\\](.*?)\\[\\/\\1:' . $row['bbcode_uid'] . '\\]/si', "[spoiler]\$2[/spoiler]", $message);
$message = preg_replace('/\\[b:' . $data['bbcode_uid'] . '\\](.*?)\\[\\/b:' . $data['bbcode_uid'] . '\\]/si', '[b]$1[/b]', $message);
$message = preg_replace('/\\[i:' . $data['bbcode_uid'] . '\\](.*?)\\[\\/i:' . $data['bbcode_uid'] . '\\]/si', '[i]$1[/i]', $message);
$message = preg_replace('/\\[u:' . $data['bbcode_uid'] . '\\](.*?)\\[\\/u:' . $data['bbcode_uid'] . '\\]/si', '[u]$1[/u]', $message);
$message = preg_replace('/\\[color=#(\\w{6}):' . $data['bbcode_uid'] . '\\](.*?)\\[\\/color:' . $data['bbcode_uid'] . '\\]/si', '[color=#$1]$2[/color]', $message);
// Second parse bbcode here
if ($data['bbcode_bitfield']) {
$bbcode = new bbcode(base64_encode($data['bbcode_bitfield']));
$bbcode->bbcode_second_pass($message, $data['bbcode_uid'], $data['bbcode_bitfield']);
}
$message = bbcode_nl2br($message);
$message = smiley_text($message);
if (!empty($data['attachment_data'])) {
parse_attachments($forum_id, $message, $data['attachment_data'], $update_count);
}
$updated_post_title = html_entity_decode(strip_tags(censor_text($data['topic_title'])), ENT_QUOTES, 'UTF-8');
$edit_allowed = $auth->acl_get('m_edit', $forum_id) || $auth->acl_get('f_edit', $forum_id) && !$data['post_edit_locked'] && ($data['post_time'] > time() - $config['edit_time'] * 60 || !$config['edit_time']);
$delete_allowed = $auth->acl_get('m_delete', $forum_id) || $auth->acl_get('f_delete', $forum_id) && ($data['post_time'] > time() - $config['delete_time'] * 60 || !$config['delete_time']) && !$data['post_edit_locked'];
$attachments = array();
if (sizeof($attach_list) && sizeof($data['attachment_data'])) {
$sql = 'SELECT *
FROM ' . ATTACHMENTS_TABLE . '
WHERE ' . $db->sql_in_set('attach_id', $attach_list) . '
AND in_message = 0
ORDER BY filetime DESC';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$attachment_by_id[$row['attach_id']] = $row;
}
$db->sql_freeresult($result);
foreach ($data['attachment_data'] as $attachment) {
if (preg_match('/<img src=\\".*?(\\/download\\/file.php\\?id=(\\d+).*?)\\"/is', $attachment, $matches)) {
$file_url = html_entity_decode($phpbb_home . $matches[1]);
$attach_id = $matches[2];
unset($matches);
$xmlrpc_attachment = new xmlrpcval(array('filename' => new xmlrpcval($attachment_by_id[$attach_id]['real_filename'], 'base64'), 'filesize' => new xmlrpcval($attachment_by_id[$attach_id]['filesize'], 'int'), 'content_type' => new xmlrpcval('image'), 'thumbnail_url' => new xmlrpcval(''), 'url' => new xmlrpcval($file_url)), 'struct');
$attachments[] = $xmlrpc_attachment;
}
}
}
}
$xmlrpc_reply_topic = new xmlrpcval(array('result' => new xmlrpcval($reply_success, 'boolean'), 'post_id' => new xmlrpcval($post_id, 'string'), 'state' => new xmlrpcval($approved ? 0 : 1, 'int'), 'post_title' => new xmlrpcval($updated_post_title, 'base64'), 'post_content' => new xmlrpcval(post_html_clean($message), 'base64'), 'post_author_name' => new xmlrpcval(html_entity_decode($user->data['username']), 'base64'), 'is_online' => new xmlrpcval(true, 'boolean'), 'can_edit' => new xmlrpcval($edit_allowed, 'boolean'), 'icon_url' => new xmlrpcval($user->optionget('viewavatars') ? get_user_avatar_url($user->data['user_avatar'], $user->data['user_avatar_type']) : ''), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($current_time), 'dateTime.iso8601'), 'can_delete' => new xmlrpcval($delete_allowed, 'boolean'), 'allow_smilies' => new xmlrpcval($data['enable_smilies'] ? true : false, 'boolean'), 'attachments' => new xmlrpcval($attachments, 'array')), 'struct');
return new xmlrpcresp($xmlrpc_reply_topic);
}
function get_message_func($xmlrpc_params)
{
global $db, $auth, $user, $config, $template, $phpbb_root_path, $phpEx;
if (file_exists($phpbb_root_path . 'includes/functions_profile_control.' . $phpEx)) {
require_once $phpbb_root_path . 'includes/functions_profile_control.' . $phpEx;
}
$user->setup('ucp');
$params = php_xmlrpc_decode($xmlrpc_params);
if (!$user->data['is_registered']) {
trigger_error('LOGIN_EXPLAIN_UCP');
}
if (!$config['allow_privmsg']) {
trigger_error('Module not accessible');
}
// get msg id from parameters
$msg_id = intval($params[0]);
if (!$msg_id) {
trigger_error('NO_MESSAGE');
}
$GLOBALS['return_html'] = isset($params[2]) ? $params[2] : false;
$message_row = array();
// Get Message user want to see
$sql = 'SELECT t.*, p.*, u.*
FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . ' u
WHERE t.user_id = ' . $user->data['user_id'] . "\r\r\n AND p.author_id = u.user_id\r\r\n AND t.msg_id = p.msg_id\r\r\n AND p.msg_id = {$msg_id}";
$result = $db->sql_query($sql);
$message_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$message_row) {
trigger_error('NO_MESSAGE');
}
$message_row['message_text'] = preg_replace('/\\[b:' . $message_row['bbcode_uid'] . '\\](.*?)\\[\\/b:' . $message_row['bbcode_uid'] . '\\]/si', '[b]$1[/b]', $message_row['message_text']);
$message_row['message_text'] = preg_replace('/\\[i:' . $message_row['bbcode_uid'] . '\\](.*?)\\[\\/i:' . $message_row['bbcode_uid'] . '\\]/si', '[i]$1[/i]', $message_row['message_text']);
$message_row['message_text'] = preg_replace('/\\[u:' . $message_row['bbcode_uid'] . '\\](.*?)\\[\\/u:' . $message_row['bbcode_uid'] . '\\]/si', '[u]$1[/u]', $message_row['message_text']);
$message_row['message_text'] = preg_replace('/\\[color=#(\\w{6}):' . $message_row['bbcode_uid'] . '\\](.*?)\\[\\/color:' . $message_row['bbcode_uid'] . '\\]/si', '[color=#$1]$2[/color]', $message_row['message_text']);
// Update unread status
$user->add_lang('posting');
include_once $phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx;
update_unread_status($message_row['pm_unread'], $message_row['msg_id'], $user->data['user_id'], $message_row['folder_id']);
include $phpbb_root_path . 'includes/ucp/ucp_pm_viewmessage.' . $phpEx;
view_message('', '', $message_row['folder_id'], $msg_id, '', $message_row);
$msg_to = array();
foreach ($template->_tpldata['to_recipient'] as $address_row) {
$msg_to[] = new xmlrpcval(array('user_id' => new xmlrpcval($address_row['UG_ID'], 'string'), 'username' => new xmlrpcval($address_row['NAME'], 'base64'), 'user_type' => check_return_user_type($address_row['NAME'])), 'struct');
}
$sent_date = mobiquo_iso8601_encode($message_row['message_time']);
$icon_url = $user->optionget('viewavatars') ? get_user_avatar_url($message_row['user_avatar'], $message_row['user_avatar_type']) : '';
$msg_subject = html_entity_decode(strip_tags(censor_text($message_row['message_subject'])));
$msg_body = post_html_clean(parse_quote($template->_rootref['MESSAGE']));
if ($config['load_onlinetrack']) {
$sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline
FROM ' . SESSIONS_TABLE . '
WHERE session_user_id=' . $message_row['user_id'] . '
GROUP BY session_user_id';
$result = $db->sql_query($sql);
$online_info = $db->sql_fetchrow($result);
$update_time = $config['load_online_time'] * 60;
$is_online = time() - $update_time < $online_info['online_time'] && ($online_info['viewonline'] || $auth->acl_get('u_viewonline')) ? true : false;
} else {
$is_online = false;
}
$result = new xmlrpcval(array('msg_from' => new xmlrpcval($message_row['username'], 'base64'), 'msg_from_id' => new xmlrpcval($message_row['user_id'], 'string'), 'msg_to' => new xmlrpcval($msg_to, 'array'), 'icon_url' => new xmlrpcval($icon_url), 'sent_date' => new xmlrpcval($sent_date, 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($message_row['message_time'], 'string'), 'msg_subject' => new xmlrpcval($msg_subject, 'base64'), 'text_body' => new xmlrpcval($msg_body, 'base64'), 'is_online' => new xmlrpcval($is_online, 'boolean'), 'allow_smilies' => new xmlrpcval($message_row['enable_smilies'] ? true : false, 'boolean')), 'struct');
return new xmlrpcresp($result);
}
function get_box_func($xmlrpc_params)
{
global $db, $lang, $theme, $plugins, $mybb, $session, $settings, $cache, $time, $mybbgroups;
$input = Tapatalk_Input::filterXmlInput(array('box_id' => Tapatalk_Input::INT, 'start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT), $xmlrpc_params);
list($start, $limit) = process_page($input['start_num'], $input['last_num']);
$lang->load("private");
$parser = new postParser();
if ($mybb->settings['enablepms'] == 0) {
return xmlrespfalse($lang->pms_disabled);
}
if ($mybb->user['uid'] == '/' || $mybb->user['uid'] == 0 || $mybb->usergroup['canusepms'] == 0) {
return tt_no_permission();
}
if (!$mybb->user['pmfolders']) {
$mybb->user['pmfolders'] = "1**\$%%\$2**\$%%\$3**\$%%\$4**";
$sql_array = array("pmfolders" => $mybb->user['pmfolders']);
$db->update_query("users", $sql_array, "uid = " . $mybb->user['uid']);
}
$rand = my_rand(0, 9);
if ($rand == 5) {
update_pm_count();
}
$foldernames = array();
$foldersexploded = explode("\$%%\$", $mybb->user['pmfolders']);
foreach ($foldersexploded as $key => $folders) {
$folderinfo = explode("**", $folders, 2);
$folderinfo[1] = get_pm_folder_name($folderinfo[0], $folderinfo[1]);
$foldernames[$folderinfo[0]] = $folderinfo[1];
}
if (!$input['box_id'] || !array_key_exists($input['box_id'], $foldernames)) {
$input['box_id'] = 1;
}
$folder = $input['box_id'];
$foldername = $foldernames[$folder];
$lang->pms_in_folder = $lang->sprintf($lang->pms_in_folder, $foldername);
if ($folder == 2 || $folder == 3) {
$sender = $lang->sentto;
} else {
$sender = $lang->sender;
}
// Do Multi Pages
$query = $db->simple_select("privatemessages", "COUNT(*) AS total", "uid='" . $mybb->user['uid'] . "' AND folder='{$folder}'");
$count_total = $db->fetch_field($query, 'total');
$query = $db->simple_select("privatemessages", "COUNT(*) AS unread", "uid='" . $mybb->user['uid'] . "' AND folder='{$folder}' AND readtime = 0");
$count_unread = $db->fetch_field($query, 'unread');
// Get all recipients into an array
$cached_users = $get_users = array();
$users_query = $db->simple_select("privatemessages", "recipients", "folder='{$folder}' AND uid='{$mybb->user['uid']}'", array('limit_start' => $start, 'limit' => $limit, 'order_by' => 'dateline', 'order_dir' => 'DESC'));
while ($row = $db->fetch_array($users_query)) {
$recipients = unserialize($row['recipients']);
if (is_array($recipients['to']) && count($recipients['to'])) {
$get_users = array_merge($get_users, $recipients['to']);
}
if (is_array($recipients['bcc']) && count($recipients['bcc'])) {
$get_users = array_merge($get_users, $recipients['bcc']);
}
}
$get_users = implode(',', array_unique($get_users));
// Grab info
if ($get_users) {
$users_query = $db->simple_select("users", "uid, username, usergroup, displaygroup", "uid IN ({$get_users})");
while ($user = $db->fetch_array($users_query)) {
$cached_users[$user['uid']] = $user;
}
}
$user_online = $folder == 1 ? ', fu.lastactive, fu.invisible, fu.lastvisit ' : ', tu.lastactive, tu.invisible, tu.lastvisit ';
$query = $db->query("\n\t\tSELECT pm.*, fu.username AS fromusername, tu.username as tousername, fu.avatar as favatar, tu.avatar as tavatar {$user_online}\n\t\tFROM " . TABLE_PREFIX . "privatemessages pm\n\t\tLEFT JOIN " . TABLE_PREFIX . "users fu ON (fu.uid=pm.fromid)\n\t\tLEFT JOIN " . TABLE_PREFIX . "users tu ON (tu.uid=pm.toid)\n\t\tWHERE pm.folder='{$folder}' AND pm.uid='" . $mybb->user['uid'] . "'\n\t\tORDER BY pm.dateline DESC\n\t\tLIMIT {$start}, {$limit}\n\t");
$message_list = array();
if ($db->num_rows($query) > 0) {
while ($message = $db->fetch_array($query)) {
$status = 1;
if ($message['status'] == 0) {
$msgalt = $lang->new_pm;
} elseif ($message['status'] == 1) {
$msgalt = $lang->old_pm;
$status = 2;
} elseif ($message['status'] == 3) {
$msgalt = $lang->reply_pm;
$status = 3;
} elseif ($message['status'] == 4) {
$msgalt = $lang->fwd_pm;
$status = 4;
}
$msg_from = null;
$msg_to = array();
$avatar = "";
$outboxdisplayuserid = 0;
// Sent Items or Drafts Folder Check
$recipients = unserialize($message['recipients']);
if (count($recipients['to']) > 1 || count($recipients['to']) == 1 && count($recipients['bcc']) > 0) {
foreach ($recipients['to'] as $uid) {
$profilelink = get_profile_link($uid);
$user = $cached_users[$uid];
if (!empty($user['username'])) {
$msg_to[] = new xmlrpcval(array("username" => new xmlrpcval($user['username'], "base64"), "user_id" => new xmlrpcval($uid, "string"), "user_type" => check_return_user_type($user['username'])), "struct");
}
if (($folder == 2 or $folder == 3) && !$outboxdisplayuserid) {
$outboxdisplayuserid = $uid;
}
}
/*if(is_array($recipients['bcc']) && count($recipients['bcc']))
{
foreach($recipients['bcc'] as $uid)
{
$profilelink = get_profile_link($uid);
$user = $cached_users[$uid];
$msg_to[]=new xmlrpcval($user['username'], "base64");
}
}*/
} else {
if ($message['toid']) {
$tofromusername = $message['tousername'];
$tofromuid = $message['toid'];
if (!empty($tofromusername)) {
$msg_to[] = new xmlrpcval(array("username" => new xmlrpcval($tofromusername, "base64"), "user_id" => new xmlrpcval($message['toid'], "string"), "user_type" => check_return_user_type($tofromusername)), "struct");
}
}
}
$avatar = $message['tavatar'];
if ($folder != 2 && $folder != 3) {
$tofromusername = $message['fromusername'];
$tofromuid = $message['fromid'];
if ($tofromuid == 0) {
$tofromusername = $lang->mybb_engine;
}
if (!$tofromusername) {
$tofromuid = 0;
$tofromusername = $lang->na;
}
$msg_from = $tofromusername;
$avatar = $message['favatar'];
} else {
if ($outboxdisplayuserid) {
$outboxdisplayuser = get_user($outboxdisplayuserid);
$avatar = $outboxdisplayuser['avatar'];
}
}
if (!trim($message['subject'])) {
$message['subject'] = $lang->pm_no_subject;
}
$is_online = false;
$timecut = TIME_NOW - $mybb->settings['wolcutoff'];
if ($message['lastactive'] > $timecut && ($message['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1) && $message['lastvisit'] != $message['lastactive']) {
$is_online = true;
}
$new_message = array('msg_id' => new xmlrpcval($message['pmid'], 'string'), 'msg_state' => new xmlrpcval($status, 'int'), 'sent_date' => new xmlrpcval(mobiquo_iso8601_encode($message['dateline']), 'dateTime.iso8601'), 'msg_to' => new xmlrpcval($msg_to, 'array'), 'icon_url' => new xmlrpcval(absolute_url($avatar), 'string'), 'msg_subject' => new xmlrpcval($message['subject'], 'base64'), 'short_content' => new xmlrpcval(process_short_content($message['message'], $parser), 'base64'), 'is_online' => new xmlrpcval($is_online, 'boolean'));
if ($msg_from !== null) {
$new_message['msg_from'] = new xmlrpcval($msg_from, 'base64');
}
$message_list[] = new xmlrpcval($new_message, "struct");
}
}
$result = new xmlrpcval(array('result' => new xmlrpcval(true, 'boolean'), 'result_text' => new xmlrpcval('', 'base64'), 'total_message_count' => new xmlrpcval($count_total, 'int'), 'total_unread_count' => new xmlrpcval($count_unread, 'int'), 'list' => new xmlrpcval($message_list, 'array')), 'struct');
return new xmlrpcresp($result);
}
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'));
}
