代碼: 選擇全部
#
#-----[ FIND ]------------------------------------------------
#
[color=red]$topic_rowset = array();
$total_announcements = 0;[/color]
#
#-----[ REPLACE WITH ]----------------------------------------
#
// 2 rows deleted - Global announcement MOD
代碼: 選擇全部
#
#-----[ FIND ]------------------------------------------------
#
//
// All announcement data, this keeps announcements
// on each viewforum page ...
#
#-----[ BEFORE, ADD ]-----------------------------------------
#
//
// All GLOBAL announcement data, this keeps GLOBAL announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_GLOBAL_ANNOUNCE . "
ORDER BY t.topic_last_post_id DESC ";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain topic information", "", __LINE__, __FILE__, $sql);
}
[color=blue]$topic_rowset = array();
$total_announcements = 0; [/color]
while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
$total_announcements++;
}
$db->sql_freeresult($result);
// End add - Global announcement MOD代碼: 選擇全部
//
// All announcement data, this keeps announcements
// on each viewforum page ...代碼: 選擇全部
//
[color=darkred]// All announcement data, this keeps announcements
// on each viewforum page ...[/color]
//
$sql = "SELECT t.*, u.username, u.user_color_gc, u.user_id, u2.username as user2, u2.user_color_gc as color2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_ANNOUNCE . "
ORDER BY t.topic_last_post_id DESC ";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}
[color=darkred]$topic_rowset = array();
$total_announcements = 0;[/color]
while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
$total_announcements++;