Запрос на разработку: AEC
Код: Выделить всё
[sql]
ALTER TABLE `phpbb_posts` ADD `post_editor` MEDIUMINT( 8 ) NOT NULL ;
UPDATE `phpbb_posts` SET `post_editor` = `poster_id` WHERE 1 ;
[open]
includes/functions_post.php
[find]
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";
[replace with]
$edited_sql = ( ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) || ($mode == 'editpost' && !$post_data['poster_post']) ) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1, post_editor = $userdata['user_id'] " : "";
[find]
$sql = ($mode != "editpost") ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";
[in-line find]
poster_ip,
[inline after add]
post_editor,
[in-line find]
'$user_ip',
[inline after add]
" . $userdata['user_id'] . ",
[open]
viewtopic.php
[find]
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
[in-line find]
u.user_id,
[inline after add]
u2.username AS p_editor,
[in-line find]
POSTS_TEXT_TABLE . " pt
[inline after add]
, " . USERS_TABLE . " u2
[find]
AND u.user_id = p.poster_id
[after add]
AND u2.user_id = p.post_editor
[find]
$l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, $poster, create_date($board_config['default_dateformat'], $postrow[$i]['post_edit_time'], $board_config['board_timezone']), $postrow[$i]['post_edit_count']);
[in-line find]
$poster
[in-line replace]
$postrow[$i]['p_editor']
[eom]