https://www.icyphoenix.com/viewtopic.php?f=35&t=4486&p=30723#p30723
-----------------------------------
Mighty Gorgon
Mon 18 Aug, 2008 02:43

Re: Global Announce Out Of Topic,how?
-----------------------------------
To achieve this you need to create a new SQL which retrieve the Global Announcements in the Forum Index.

Something like this:
[codeblock]		$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);
		}

		$topic_rowset = array();
		$total_announcements = 0;
		while($row = $db->sql_fetchrow($result))
		{
			$topic_rowset[] = $row;
			$total_announcements++;
		}

		$db->sql_freeresult($result);[/codeblock]


