Kod:
#
#-----[ OPEN ]-------------------------------------------
#
viewforum.php
#
#-----[ FIND ]-------------------------------------------
#
// Obtain list of moderators of each forum
// First users, then groups ... broken into two queries
//
$sql = "SELECT u.user_id, u.username
#
#-----[ IN LINE, FIND ]----------------------------------
#
SELECT u.user_id, u.username
#
#-----[ IN LINE, ADD ]-----------------------------------
#
, u.user_rank, u.user_posts
#
#-----[ FIND ]-------------------------------------------
#
$moderators[] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '">' . $row['username'] . '</a>';
#
#-----[ REPLACE WITH ]-----------------------------------
#
$moderators[]=color_username($row['user_id'],$row['username'],$row['user_rank'],$row['user_posts']);
#
#-----[ FIND ]-------------------------------------------
#
$sql = "SELECT g.group_id, g.group_name
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
WHERE aa.forum_id = $forum_id
AND aa.auth_mod = " . TRUE . "
AND g.group_single_user = 0
AND g.group_type <> ". GROUP_HIDDEN ."
AND ug.group_id = aa.group_id
AND g.group_id = aa.group_id
GROUP BY g.group_id, g.group_name
ORDER BY g.group_id";
#
#-----[ IN LINE, FIND ]----------------------------------
#
g.group_name
#
#-----[ IN LINE, AFTER ADD ]-----------------------------
#
,g.group_rank
#
#-----[ FIND ]-------------------------------------------
#
$moderators[] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' . $row['group_name'] . '</a>';
#
#-----[ REPLACE WITH ]-----------------------------------
#
$moderators[] = color_group($row['group_id'],$row['group_name'],$row['group_rank'], GROUP_LINK);
#
#-----[ FIND ]-------------------------------------------
#
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
#
#-----[ IN LINE, ADD ]-----------------------------------
#
, u.user_rank, u.user_posts, u2.user_rank AS rank2, u2.user_posts AS posts2
#
#-----[ FIND ]-------------------------------------------
#
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
#
#-----[ IN LINE, ADD ]-----------------------------------
#
, u.user_rank, u.user_posts, u2.user_rank AS rank2, u2.user_posts AS posts2
#
#-----[ FIND ]-------------------------------------------
#
$topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $topic_rowset[$i]['user_id']) . '">' : '';
$topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? $topic_rowset[$i]['username'] : ( ( $topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] );
$topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '</a>' : '';
#
#-----[ REPLACE WITH ]-----------------------------------
#
$topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? color_username($topic_rowset[$i]['user_id'],$topic_rowset[$i]['username'],$topic_rowset[$i]['user_rank'],$topic_rowset[$i]['user_posts']) : ( ( $topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] );
#
#-----[ FIND ]-------------------------------------------
#
$last_post_author = ( $topic_rowset[$i]['id2'] == ANONYMOUS ) ? ( ($topic_rowset[$i]['post_username2'] != '' ) ? $topic_rowset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $topic_rowset[$i]['id2']) . '">' . $topic_rowset[$i]['user2'] . '</a>';
#
#-----[ REPLACE WITH ]-----------------------------------
#
$last_post_author = ( $topic_rowset[$i]['id2'] == ANONYMOUS ) ? ( ($topic_rowset[$i]['post_username2'] != '' ) ? $topic_rowset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : color_username($topic_rowset[$i]['id2'],$topic_rowset[$i]['user2'],$topic_rowset[$i]['rank2'],$topic_rowset[$i]['posts2']) ;
#
Zrobiłeś to?
[url=http://www.link-vault.com/?ss=13287][color=#D70000][b]Wymiana linkami[/b][/color][/url]
[url=http://forum.wpc.net.pl]Warcraft Players Community[/url]