| [ Index ] |
PHP Cross Reference of phpBB-3.3.14-deutsch |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * 4 * This file is part of the phpBB Forum Software package. 5 * 6 * @copyright (c) phpBB Limited <https://www.phpbb.com> 7 * @license GNU General Public License, version 2 (GPL-2.0) 8 * 9 * For full copyright and license information, please see 10 * the docs/CREDITS.txt file. 11 * 12 */ 13 14 /** 15 * @ignore 16 */ 17 if (!defined('IN_PHPBB')) 18 { 19 exit; 20 } 21 22 /** 23 * Handling actions in post details screen 24 */ 25 function mcp_post_details($id, $mode, $action) 26 { 27 global $phpEx, $phpbb_root_path, $config, $request; 28 global $template, $db, $user, $auth; 29 global $phpbb_container, $phpbb_dispatcher; 30 31 $user->add_lang('posting'); 32 33 $post_id = $request->variable('p', 0); 34 $start = $request->variable('start', 0); 35 36 // Get post data 37 $post_info = phpbb_get_post_data(array($post_id), false, true); 38 39 add_form_key('mcp_post_details'); 40 41 if (!count($post_info)) 42 { 43 trigger_error('POST_NOT_EXIST'); 44 } 45 46 $post_info = $post_info[$post_id]; 47 $url = append_sid("{$phpbb_root_path}mcp.$phpEx?" . phpbb_extra_url()); 48 49 switch ($action) 50 { 51 case 'whois': 52 53 if ($auth->acl_get('m_info', $post_info['forum_id'])) 54 { 55 $ip = $request->variable('ip', ''); 56 if (!function_exists('user_ipwhois')) 57 { 58 include($phpbb_root_path . 'includes/functions_user.' . $phpEx); 59 } 60 61 $template->assign_vars(array( 62 'RETURN_POST' => sprintf($user->lang['RETURN_POST'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&mode=$mode&p=$post_id") . '">', '</a>'), 63 'U_RETURN_POST' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&mode=$mode&p=$post_id"), 64 'L_RETURN_POST' => sprintf($user->lang['RETURN_POST'], '', ''), 65 'WHOIS' => user_ipwhois($ip), 66 )); 67 } 68 69 // We're done with the whois page so return 70 return; 71 72 break; 73 74 case 'chgposter': 75 case 'chgposter_ip': 76 77 if ($action == 'chgposter') 78 { 79 $username = $request->variable('username', '', true); 80 $sql_where = "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'"; 81 } 82 else 83 { 84 $new_user_id = $request->variable('u', 0); 85 $sql_where = 'user_id = ' . $new_user_id; 86 } 87 88 $sql = 'SELECT * 89 FROM ' . USERS_TABLE . ' 90 WHERE ' . $sql_where; 91 $result = $db->sql_query($sql); 92 $row = $db->sql_fetchrow($result); 93 $db->sql_freeresult($result); 94 95 if (!$row) 96 { 97 trigger_error('NO_USER'); 98 } 99 100 if ($auth->acl_get('m_chgposter', $post_info['forum_id'])) 101 { 102 if (check_form_key('mcp_post_details')) 103 { 104 change_poster($post_info, $row); 105 } 106 else 107 { 108 trigger_error('FORM_INVALID'); 109 } 110 } 111 112 break; 113 114 default: 115 116 /** 117 * This event allows you to handle custom post moderation options 118 * 119 * @event core.mcp_post_additional_options 120 * @var string action Post moderation action name 121 * @var array post_info Information on the affected post 122 * @since 3.1.5-RC1 123 */ 124 $vars = array('action', 'post_info'); 125 extract($phpbb_dispatcher->trigger_event('core.mcp_post_additional_options', compact($vars))); 126 127 break; 128 } 129 130 // Set some vars 131 $users_ary = $usernames_ary = array(); 132 $attachments = $extensions = array(); 133 $post_id = $post_info['post_id']; 134 135 // Get topic tracking info 136 if ($config['load_db_lastread']) 137 { 138 $tmp_topic_data = array($post_info['topic_id'] => $post_info); 139 $topic_tracking_info = get_topic_tracking($post_info['forum_id'], $post_info['topic_id'], $tmp_topic_data, array($post_info['forum_id'] => $post_info['forum_mark_time'])); 140 unset($tmp_topic_data); 141 } 142 else 143 { 144 $topic_tracking_info = get_complete_topic_tracking($post_info['forum_id'], $post_info['topic_id']); 145 } 146 147 $post_unread = (isset($topic_tracking_info[$post_info['topic_id']]) && $post_info['post_time'] > $topic_tracking_info[$post_info['topic_id']]) ? true : false; 148 149 // Process message, leave it uncensored 150 $parse_flags = ($post_info['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES; 151 $message = generate_text_for_display($post_info['post_text'], $post_info['bbcode_uid'], $post_info['bbcode_bitfield'], $parse_flags, false); 152 153 if ($post_info['post_attachment'] && $auth->acl_get('u_download') && $auth->acl_get('f_download', $post_info['forum_id'])) 154 { 155 $sql = 'SELECT * 156 FROM ' . ATTACHMENTS_TABLE . ' 157 WHERE post_msg_id = ' . $post_id . ' 158 AND in_message = 0 159 ORDER BY filetime DESC, post_msg_id ASC'; 160 $result = $db->sql_query($sql); 161 162 while ($row = $db->sql_fetchrow($result)) 163 { 164 $attachments[] = $row; 165 } 166 $db->sql_freeresult($result); 167 168 if (count($attachments)) 169 { 170 $user->add_lang('viewtopic'); 171 $update_count = array(); 172 parse_attachments($post_info['forum_id'], $message, $attachments, $update_count); 173 } 174 175 // Display not already displayed Attachments for this post, we already parsed them. ;) 176 if (!empty($attachments)) 177 { 178 $template->assign_var('S_HAS_ATTACHMENTS', true); 179 180 foreach ($attachments as $attachment) 181 { 182 $template->assign_block_vars('attachment', array( 183 'DISPLAY_ATTACHMENT' => $attachment) 184 ); 185 } 186 } 187 } 188 189 // Deleting information 190 if ($post_info['post_visibility'] == ITEM_DELETED && $post_info['post_delete_user']) 191 { 192 // User having deleted the post also being the post author? 193 if (!$post_info['post_delete_user'] || $post_info['post_delete_user'] == $post_info['poster_id']) 194 { 195 $display_username = get_username_string('full', $post_info['poster_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']); 196 } 197 else 198 { 199 $sql = 'SELECT user_id, username, user_colour 200 FROM ' . USERS_TABLE . ' 201 WHERE user_id = ' . (int) $post_info['post_delete_user']; 202 $result = $db->sql_query($sql); 203 $user_delete_row = $db->sql_fetchrow($result); 204 $db->sql_freeresult($result); 205 $display_username = get_username_string('full', $post_info['post_delete_user'], $user_delete_row['username'], $user_delete_row['user_colour']); 206 } 207 208 $user->add_lang('viewtopic'); 209 $l_deleted_by = $user->lang('DELETED_INFORMATION', $display_username, $user->format_date($post_info['post_delete_time'], false, true)); 210 } 211 else 212 { 213 $l_deleted_by = ''; 214 } 215 216 // parse signature 217 $parse_flags = ($post_info['user_sig_bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES; 218 $post_info['user_sig'] = generate_text_for_display($post_info['user_sig'], $post_info['user_sig_bbcode_uid'], $post_info['user_sig_bbcode_bitfield'], $parse_flags, true); 219 220 $mcp_post_template_data = array( 221 'U_MCP_ACTION' => "$url&i=main&quickmod=1&mode=post_details", // Use this for mode paramaters 222 'U_POST_ACTION' => "$url&i=$id&mode=post_details", // Use this for action parameters 223 'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&p=$post_id"), 224 225 'S_CAN_APPROVE' => $auth->acl_get('m_approve', $post_info['forum_id']), 226 'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']), 227 'S_CAN_CHGPOSTER' => $auth->acl_get('m_chgposter', $post_info['forum_id']), 228 'S_CAN_LOCK_POST' => $auth->acl_get('m_lock', $post_info['forum_id']), 229 'S_CAN_DELETE_POST' => $auth->acl_get('m_delete', $post_info['forum_id']), 230 231 'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false, 232 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED || $post_info['post_visibility'] == ITEM_REAPPROVE) ? true : false, 233 'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false, 234 'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false, 235 'S_USER_NOTES' => true, 236 'S_CLEAR_ALLOWED' => ($auth->acl_get('a_clearlogs')) ? true : false, 237 'DELETED_MESSAGE' => $l_deleted_by, 238 'DELETE_REASON' => $post_info['post_delete_reason'], 239 240 'U_EDIT' => ($auth->acl_get('m_edit', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=edit&p={$post_info['post_id']}") : '', 241 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=mcp_chgposter&field=username&select_single=true'), 242 'U_MCP_APPROVE' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=approve_details&p=' . $post_id), 243 'U_MCP_REPORT' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=report_details&p=' . $post_id), 244 'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $post_info['user_id']), 245 'U_MCP_WARN_USER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&mode=warn_user&u=' . $post_info['user_id']) : '', 246 'U_VIEW_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'p=' . $post_info['post_id'] . '#p' . $post_info['post_id']), 247 'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $post_info['topic_id']), 248 249 'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'), 250 251 'RETURN_TOPIC' => sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "p=$post_id") . "#p$post_id\">", '</a>'), 252 'RETURN_FORUM' => sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", "f={$post_info['forum_id']}&start={$start}") . '">', '</a>'), 253 'REPORTED_IMG' => $user->img('icon_topic_reported', $user->lang['POST_REPORTED']), 254 'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', $user->lang['POST_UNAPPROVED']), 255 'DELETED_IMG' => $user->img('icon_topic_deleted', $user->lang['POST_DELETED']), 256 'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']), 257 'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']), 258 259 'POST_AUTHOR_FULL' => get_username_string('full', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), 260 'POST_AUTHOR_COLOUR' => get_username_string('colour', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), 261 'POST_AUTHOR' => get_username_string('username', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), 262 'U_POST_AUTHOR' => get_username_string('profile', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), 263 264 'POST_PREVIEW' => $message, 265 'POST_SUBJECT' => $post_info['post_subject'], 266 'POST_DATE' => $user->format_date($post_info['post_time']), 267 'POST_IP' => $post_info['poster_ip'], 268 'POST_IPADDR' => ($auth->acl_get('m_info', $post_info['forum_id']) && $request->variable('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '', 269 'POST_ID' => $post_info['post_id'], 270 'SIGNATURE' => $post_info['user_sig'], 271 272 'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? "$url&i=$id&mode=$mode&lookup={$post_info['poster_ip']}#ip" : '', 273 'U_WHOIS' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&mode=$mode&action=whois&p=$post_id&ip={$post_info['poster_ip']}") : '', 274 ); 275 276 $s_additional_opts = false; 277 278 /** 279 * Event to add/modify MCP post template data 280 * 281 * @event core.mcp_post_template_data 282 * @var array post_info Array with the post information 283 * @var array mcp_post_template_data Array with the MCP post template data 284 * @var array attachments Array with the post attachments, if any 285 * @var bool s_additional_opts Must be set to true in extension if additional options are presented in MCP post panel 286 * @since 3.1.5-RC1 287 */ 288 $vars = array( 289 'post_info', 290 'mcp_post_template_data', 291 'attachments', 292 's_additional_opts', 293 ); 294 extract($phpbb_dispatcher->trigger_event('core.mcp_post_template_data', compact($vars))); 295 296 $template->assign_vars($mcp_post_template_data); 297 $template->assign_var('S_MCP_POST_ADDITIONAL_OPTS', $s_additional_opts); 298 299 unset($mcp_post_template_data); 300 301 // Get User Notes 302 $log_data = array(); 303 $log_count = false; 304 view_log('user', $log_data, $log_count, $config['posts_per_page'], 0, 0, 0, $post_info['user_id']); 305 306 if (!empty($log_data)) 307 { 308 $template->assign_var('S_USER_NOTES', true); 309 310 foreach ($log_data as $row) 311 { 312 $template->assign_block_vars('usernotes', array( 313 'REPORT_BY' => $row['username_full'], 314 'REPORT_AT' => $user->format_date($row['time']), 315 'ACTION' => $row['action'], 316 'ID' => $row['id']) 317 ); 318 } 319 } 320 321 // Get Reports 322 if ($auth->acl_get('m_report', $post_info['forum_id'])) 323 { 324 $sql = 'SELECT r.*, re.*, u.user_id, u.username 325 FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re 326 WHERE r.post_id = $post_id 327 AND r.reason_id = re.reason_id 328 AND u.user_id = r.user_id 329 ORDER BY r.report_time DESC"; 330 $result = $db->sql_query($sql); 331 332 if ($row = $db->sql_fetchrow($result)) 333 { 334 $template->assign_var('S_SHOW_REPORTS', true); 335 336 do 337 { 338 // If the reason is defined within the language file, we will use the localized version, else just use the database entry... 339 if (isset($user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])])) 340 { 341 $row['reson_description'] = $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]; 342 $row['reason_title'] = $user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]; 343 } 344 345 $template->assign_block_vars('reports', array( 346 'REPORT_ID' => $row['report_id'], 347 'REASON_TITLE' => $row['reason_title'], 348 'REASON_DESC' => $row['reason_description'], 349 'REPORTER' => get_username_string('username', $row['user_id'], $row['username']), 350 'U_REPORTER' => get_username_string('profile', $row['user_id'], $row['username']), 351 'USER_NOTIFY' => ($row['user_notify']) ? true : false, 352 'REPORT_TIME' => $user->format_date($row['report_time']), 353 'REPORT_TEXT' => bbcode_nl2br(trim($row['report_text'])), 354 )); 355 } 356 while ($row = $db->sql_fetchrow($result)); 357 } 358 $db->sql_freeresult($result); 359 } 360 361 // Get IP 362 if ($auth->acl_get('m_info', $post_info['forum_id'])) 363 { 364 /** @var \phpbb\pagination $pagination */ 365 $pagination = $phpbb_container->get('pagination'); 366 367 $start_users = $request->variable('start_users', 0); 368 $rdns_ip_num = $request->variable('rdns', ''); 369 $lookup_all = $rdns_ip_num === 'all'; 370 371 $base_url = $url . '&i=main&mode=post_details'; 372 $base_url .= $lookup_all ? '&rdns=all' : ''; 373 374 if (!$lookup_all) 375 { 376 $template->assign_var('U_LOOKUP_ALL', $base_url . '&rdns=all'); 377 } 378 379 $num_users = false; 380 if ($start_users) 381 { 382 $num_users = phpbb_get_num_posters_for_ip($db, $post_info['poster_ip']); 383 $start_users = $pagination->validate_start($start_users, $config['posts_per_page'], $num_users); 384 } 385 386 // Get other users who've posted under this IP 387 $sql = 'SELECT poster_id, COUNT(poster_id) as postings 388 FROM ' . POSTS_TABLE . " 389 WHERE poster_ip = '" . $db->sql_escape($post_info['poster_ip']) . "' 390 AND poster_id <> " . (int) $post_info['poster_id'] . " 391 GROUP BY poster_id 392 ORDER BY postings DESC, poster_id ASC"; 393 $result = $db->sql_query_limit($sql, $config['posts_per_page'], $start_users); 394 395 $page_users = 0; 396 while ($row = $db->sql_fetchrow($result)) 397 { 398 $page_users++; 399 $users_ary[$row['poster_id']] = $row; 400 } 401 $db->sql_freeresult($result); 402 403 if ($page_users == $config['posts_per_page'] || $start_users) 404 { 405 if ($num_users === false) 406 { 407 $num_users = phpbb_get_num_posters_for_ip($db, $post_info['poster_ip']); 408 } 409 410 $pagination->generate_template_pagination( 411 $base_url, 412 'pagination', 413 'start_users', 414 $num_users, 415 $config['posts_per_page'], 416 $start_users 417 ); 418 } 419 420 if (count($users_ary)) 421 { 422 // Get the usernames 423 $sql = 'SELECT user_id, username 424 FROM ' . USERS_TABLE . ' 425 WHERE ' . $db->sql_in_set('user_id', array_keys($users_ary)); 426 $result = $db->sql_query($sql); 427 428 while ($row = $db->sql_fetchrow($result)) 429 { 430 $users_ary[$row['user_id']]['username'] = $row['username']; 431 $usernames_ary[utf8_clean_string($row['username'])] = $users_ary[$row['user_id']]; 432 } 433 $db->sql_freeresult($result); 434 435 foreach ($users_ary as $user_id => $user_row) 436 { 437 $template->assign_block_vars('userrow', array( 438 'USERNAME' => get_username_string('username', $user_id, $user_row['username']), 439 'NUM_POSTS' => $user_row['postings'], 440 'L_POST_S' => ($user_row['postings'] == 1) ? $user->lang['POST'] : $user->lang['POSTS'], 441 442 'U_PROFILE' => get_username_string('profile', $user_id, $user_row['username']), 443 'U_SEARCHPOSTS' => append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user_id . '&sr=topics')) 444 ); 445 } 446 } 447 448 // Get other IP's this user has posted under 449 450 // A compound index on poster_id, poster_ip (posts table) would help speed up this query a lot, 451 // but the extra size is only valuable if there are persons having more than a thousands posts. 452 // This is better left to the really really big forums. 453 $start_ips = $request->variable('start_ips', 0); 454 455 $num_ips = false; 456 if ($start_ips) 457 { 458 $num_ips = phpbb_get_num_ips_for_poster($db, $post_info['poster_id']); 459 $start_ips = $pagination->validate_start($start_ips, $config['posts_per_page'], $num_ips); 460 } 461 462 $sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings 463 FROM ' . POSTS_TABLE . ' 464 WHERE poster_id = ' . $post_info['poster_id'] . " 465 GROUP BY poster_ip 466 ORDER BY postings DESC, poster_ip ASC"; 467 $result = $db->sql_query_limit($sql, $config['posts_per_page'], $start_ips); 468 469 $page_ips = 0; 470 while ($row = $db->sql_fetchrow($result)) 471 { 472 $page_ips++; 473 $hostname = (($rdns_ip_num == $row['poster_ip'] || $rdns_ip_num == 'all') && $row['poster_ip']) ? @gethostbyaddr($row['poster_ip']) : ''; 474 475 $template->assign_block_vars('iprow', array( 476 'IP' => $row['poster_ip'], 477 'HOSTNAME' => $hostname, 478 'NUM_POSTS' => $row['postings'], 479 'L_POST_S' => ($row['postings'] == 1) ? $user->lang['POST'] : $user->lang['POSTS'], 480 481 'U_LOOKUP_IP' => (!$lookup_all && $rdns_ip_num != $row['poster_ip']) ? "$base_url&start_ips={$start_ips}&rdns={$row['poster_ip']}#ip" : '', 482 'U_WHOIS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&mode=$mode&action=whois&p=$post_id&ip={$row['poster_ip']}")) 483 ); 484 } 485 $db->sql_freeresult($result); 486 487 if ($page_ips == $config['posts_per_page'] || $start_ips) 488 { 489 if ($num_ips === false) 490 { 491 $num_ips = phpbb_get_num_ips_for_poster($db, $post_info['poster_id']); 492 } 493 494 $pagination->generate_template_pagination( 495 $base_url, 496 'pagination_ips', 497 'start_ips', 498 $num_ips, 499 $config['posts_per_page'], 500 $start_ips 501 ); 502 } 503 504 $user_select = ''; 505 506 if (count($usernames_ary)) 507 { 508 ksort($usernames_ary); 509 510 foreach ($usernames_ary as $row) 511 { 512 $user_select .= '<option value="' . $row['poster_id'] . '">' . $row['username'] . "</option>\n"; 513 } 514 } 515 516 $template->assign_var('S_USER_SELECT', $user_select); 517 } 518 519 } 520 521 /** 522 * Get the number of posters for a given ip 523 * 524 * @param \phpbb\db\driver\driver_interface $db DBAL interface 525 * @param string $poster_ip IP 526 * @return int Number of posters 527 */ 528 function phpbb_get_num_posters_for_ip(\phpbb\db\driver\driver_interface $db, $poster_ip) 529 { 530 $sql = 'SELECT COUNT(DISTINCT poster_id) as num_users 531 FROM ' . POSTS_TABLE . " 532 WHERE poster_ip = '" . $db->sql_escape($poster_ip) . "'"; 533 $result = $db->sql_query($sql); 534 $num_users = (int) $db->sql_fetchfield('num_users'); 535 $db->sql_freeresult($result); 536 537 return $num_users; 538 } 539 540 /** 541 * Get the number of ips for a given poster 542 * 543 * @param \phpbb\db\driver\driver_interface $db 544 * @param int $poster_id Poster user ID 545 * @return int Number of IPs for given poster 546 */ 547 function phpbb_get_num_ips_for_poster(\phpbb\db\driver\driver_interface $db, $poster_id) 548 { 549 $sql = 'SELECT COUNT(DISTINCT poster_ip) as num_ips 550 FROM ' . POSTS_TABLE . ' 551 WHERE poster_id = ' . (int) $poster_id; 552 $result = $db->sql_query($sql); 553 $num_ips = (int) $db->sql_fetchfield('num_ips'); 554 $db->sql_freeresult($result); 555 556 return $num_ips; 557 } 558 559 /** 560 * Change a post's poster 561 */ 562 function change_poster(&$post_info, $userdata) 563 { 564 global $auth, $db, $config, $phpbb_root_path, $phpEx, $user, $phpbb_log, $phpbb_dispatcher; 565 566 if (empty($userdata) || $userdata['user_id'] == $post_info['user_id']) 567 { 568 return; 569 } 570 571 $post_id = $post_info['post_id']; 572 573 $sql = 'UPDATE ' . POSTS_TABLE . " 574 SET poster_id = {$userdata['user_id']} 575 WHERE post_id = $post_id"; 576 $db->sql_query($sql); 577 578 // Resync topic/forum if needed 579 if ($post_info['topic_last_post_id'] == $post_id || $post_info['forum_last_post_id'] == $post_id || $post_info['topic_first_post_id'] == $post_id) 580 { 581 sync('topic', 'topic_id', $post_info['topic_id'], false, false); 582 sync('forum', 'forum_id', $post_info['forum_id'], false, false); 583 } 584 585 // Adjust post counts... only if the post is approved (else, it was not added the users post count anyway) 586 if ($post_info['post_postcount'] && $post_info['post_visibility'] == ITEM_APPROVED) 587 { 588 $sql = 'UPDATE ' . USERS_TABLE . ' 589 SET user_posts = user_posts - 1 590 WHERE user_id = ' . $post_info['user_id'] .' 591 AND user_posts > 0'; 592 $db->sql_query($sql); 593 594 $sql = 'UPDATE ' . USERS_TABLE . ' 595 SET user_posts = user_posts + 1 596 WHERE user_id = ' . $userdata['user_id']; 597 $db->sql_query($sql); 598 } 599 600 // Add posted to information for this topic for the new user 601 markread('post', $post_info['forum_id'], $post_info['topic_id'], time(), $userdata['user_id']); 602 603 // Remove the dotted topic option if the old user has no more posts within this topic 604 if ($config['load_db_track'] && $post_info['user_id'] != ANONYMOUS) 605 { 606 $sql = 'SELECT topic_id 607 FROM ' . POSTS_TABLE . ' 608 WHERE topic_id = ' . $post_info['topic_id'] . ' 609 AND poster_id = ' . $post_info['user_id']; 610 $result = $db->sql_query_limit($sql, 1); 611 $topic_id = (int) $db->sql_fetchfield('topic_id'); 612 $db->sql_freeresult($result); 613 614 if (!$topic_id) 615 { 616 $sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . ' 617 WHERE user_id = ' . $post_info['user_id'] . ' 618 AND topic_id = ' . $post_info['topic_id']; 619 $db->sql_query($sql); 620 } 621 } 622 623 // change the poster_id within the attachments table, else the data becomes out of sync and errors displayed because of wrong ownership 624 if ($post_info['post_attachment']) 625 { 626 $sql = 'UPDATE ' . ATTACHMENTS_TABLE . ' 627 SET poster_id = ' . $userdata['user_id'] . ' 628 WHERE poster_id = ' . $post_info['user_id'] . ' 629 AND post_msg_id = ' . $post_info['post_id'] . ' 630 AND topic_id = ' . $post_info['topic_id']; 631 $db->sql_query($sql); 632 } 633 634 // refresh search cache of this post 635 $search_type = $config['search_type']; 636 637 if (class_exists($search_type)) 638 { 639 // We do some additional checks in the module to ensure it can actually be utilised 640 $error = false; 641 $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher); 642 643 if (!$error && method_exists($search, 'destroy_cache')) 644 { 645 $search->destroy_cache(array(), array($post_info['user_id'], $userdata['user_id'])); 646 } 647 } 648 649 $from_username = $post_info['username']; 650 $to_username = $userdata['username']; 651 652 /** 653 * This event allows you to perform additional tasks after changing a post's poster 654 * 655 * @event core.mcp_change_poster_after 656 * @var array userdata Information on a post's new poster 657 * @var array post_info Information on the affected post 658 * @since 3.1.6-RC1 659 * @changed 3.1.7-RC1 Change location to prevent post_info from being set to the new post information 660 */ 661 $vars = array('userdata', 'post_info'); 662 extract($phpbb_dispatcher->trigger_event('core.mcp_change_poster_after', compact($vars))); 663 664 // Renew post info 665 $post_info = phpbb_get_post_data(array($post_id), false, true); 666 667 if (!count($post_info)) 668 { 669 trigger_error('POST_NOT_EXIST'); 670 } 671 672 $post_info = $post_info[$post_id]; 673 674 // Now add log entry 675 $phpbb_log->add('mod', $user->data['user_id'], $user->ip, 'LOG_MCP_CHANGE_POSTER', false, array( 676 'forum_id' => $post_info['forum_id'], 677 'topic_id' => $post_info['topic_id'], 678 'post_id' => $post_info['post_id'], 679 $post_info['topic_title'], 680 $from_username, 681 $to_username 682 )); 683 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Mon Nov 25 19:05:08 2024 | Cross-referenced by PHPXref 0.7.1 |