rendered paste body> //
> // 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);
> }
>
> // 2 rows deleted - Global announcement MOD
> while( $row = $db->sql_fetchrow($result) )
> {
> $topic_rowset[] = $row;
> $total_announcements++;
> }
>
> $db->sql_freeresult($result);
> // End add - Global announcement MOD
>
321a348
> AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
412a440,443
> // Start add - Global announcement MOD
> 'FOLDER_GLOBAL_ANNOUNCE_IMG' => $images['folder_global_announce'],
> 'FOLDER_GLOBAL_ANNOUNCE_NEW_IMG' => $images['folder_global_announce_new'],
> // End add - Global announcement MOD
428a460,462
> // Start add - Global announcement MOD
> 'L_GLOBAL_ANNOUNCEMENT' => $lang['Post_global_announcement'],
> // End add - Global announcement MOD
462a497,502
> // Start add - Global announcement MOD
> else if( $topic_type == POST_GLOBAL_ANNOUNCE )
> {
> $topic_type = $lang['Topic_global_announcement'] . ' ';
> }
> // End add - Global announcement MOD
487a528,535
> // Start add - Global announcement MOD
> if( $topic_rowset[$i]['topic_type'] == POST_GLOBAL_ANNOUNCE )
> {
> $folder = $images['folder_global_announce'];
> $folder_new = $images['folder_global_announce_new'];
> }
> else
> // End add - Global announcement MOD