> //
> // 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