$result = $db->sql_query($sql);

$group_id_ary = array();

while ($row = $db->sql_fetchrow($result))

{

$block = ($row['group_leader']) ? 'leader' : (($row['user_pending']) ? 'pending' : 'member');

'U_VIEW_GROUP' => append_sid('memberlist', 'mode=group&g=' . $row['group_id']),

);

$group_id_ary[] = $row['group_id'];

ORDER BY group_type DESC, group_name";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

switch ($row['group_type'])

'S_CAN_JOIN' => ($row['group_type'] == GROUP_OPEN || $row['group_type'] == GROUP_FREE) ? true : false,

'GROUP_COLOUR' => $row['group_colour'],

);

}

$db->sql_freeresult($result);

<ul class="topiclist topics">

<!-- BEGIN draftrow -->

<dl>

<dt>

<a href="{draftrow.U_INSERT}" title="{L_LOAD_DRAFT}" class="topictitle">{draftrow.DRAFT_SUBJECT}</a><br />

<div class="inner"><span class="corners-top"><span></span></span>

<div class="column1">

<!-- BEGIN faq_block -->

</div>

<div class="column2">

<dl class="faq">

<dt><strong>{faq_block.BLOCK_TITLE}</strong></dt>

<!-- BEGIN faq_row -->

<!-- END faq_row -->

</dl>

<!-- END faq_block -->

<div class="clear"></div>

<!-- BEGIN faq_block -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="content">

<h2>{faq_block.BLOCK_TITLE}</h2>

<!-- BEGIN faq_row -->

<dl class="faq">

<dd>{faq_block.faq_row.FAQ_ANSWER}</dd>

<dd><a href="#faqlinks" class="top2">{L_BACK_TO_TOP}</a></dd>

</dl>

<ul class="topiclist cplist">

<!-- BEGIN topicrow -->

<dl class="icon" style="background-image: url({topicrow.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt <!-- IF topicrow.TOPIC_ICON_IMG and S_TOPIC_ICONS -->style="background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF -->>

<!-- IF topicrow.S_SELECT_TOPIC --><a href="{topicrow.U_SELECT_TOPIC}" class="topictitle">[ {L_SELECT_MERGE} ]</a>&nbsp;&nbsp; <!-- ENDIF -->

<ul class="topiclist cplist">

<!-- BEGIN unapproved -->

<dl>

<dt>

<a href="{unapproved.U_POST_DETAILS}" class="topictitle">{unapproved.SUBJECT}</a> {unapproved.ATTACH_ICON_IMG}<br />

<ul class="topiclist cplist">

<!-- BEGIN report -->

<dl>

<dt>

<a href="{report.U_POST_DETAILS}#reports" class="topictitle">{report.SUBJECT}</a> {report.ATTACH_ICON_IMG}<br />

</thead>

<tbody>

<!-- BEGIN log -->

<td>{log.ACTION}</td>

<td><span>{log.USERNAME}</span></td>

<td><span>{log.IP}</span></td>

<tbody>

<!-- IF S_LOGS -->

<!-- BEGIN log -->

<td>{log.USERNAME}</td>

<td style="text-align: center">{log.IP}</td>

<td style="text-align: center">{log.DATE}</td>

</thead>

<tbody>

<!-- BEGIN usernotes -->

<td>{usernotes.REPORT_BY}</td>

<td style="text-align: center">{usernotes.IP}</td>

<td style="text-align: center">{usernotes.REPORT_AT}</td>

</thead>

<tbody>

<!-- BEGIN userrow -->

<td><!-- IF userrow.U_PROFILE --><a href="{userrow.U_PROFILE}">{userrow.USERNAME}</a><!-- ELSE -->{userrow.USERNAME}<!-- ENDIF --></td>

<td class="posts"><a href="{userrow.U_SEARCHPOSTS}" title="{L_SEARCH_POSTS_BY} {userrow.USERNAME}">{userrow.NUM_POSTS}</a></td>

</tr>

</thead>

<tbody>

<!-- BEGIN iprow -->

<td><!-- IF iprow.HOSTNAME --><a href="{iprow.U_WHOIS}">{iprow.HOSTNAME}</a> ({iprow.IP})<!-- ELSE --><a href="{iprow.U_WHOIS}">{iprow.IP}</a> (<a href="{iprow.U_LOOKUP_IP}">{L_LOOKUP_IP}</a>)<!-- ENDIF --></td>

<td class="posts">{iprow.NUM_POSTS}</td>

</tr>

<li><p class="notopics">{L_DELETED_TOPIC}</p></li>

<!-- ELSE -->

<dl>

<dt>

<a href="{postrow.U_VIEW_DETAILS}" class="topictitle">{postrow.POST_SUBJECT}</a> <br />

<ul class="topiclist cplist">

<!-- BEGIN postrow -->

<dl>

<dt>

<a href="{postrow.U_VIEW_DETAILS}" class="topictitle">{postrow.POST_SUBJECT}</a> {postrow.ATTACH_ICON_IMG}<br />

<div id="topicreview">

<!-- BEGIN postrow -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="postbody" id="pr{postrow.POST_ID}">

<tbody>

<!-- BEGIN highest -->

<td>{highest.USERNAME_FULL}</td>

<td>{highest.WARNINGS}</td>

<td>{highest.WARNING_TIME}</td>

</thead>

<tbody>

<!-- BEGIN latest -->

<td>{latest.USERNAME_FULL}</td>

<td>{latest.WARNING_TIME}</td>

<td>{latest.WARNINGS}</td>

<tbody>

<!-- BEGIN user -->

<td>{user.USERNAME_FULL}</td>

<td>{user.WARNINGS}</td>

<td>{user.WARNING_TIME}</td>

<!-- ENDIF -->

<!-- ENDIF -->

<td><!-- IF memberrow.RANK_IMG --><span class="rank-img">{memberrow.RANK_IMG}</span><!-- ELSE --><span class="rank-img">{memberrow.RANK_TITLE}</span><!-- ENDIF --><!-- IF S_IN_SEARCH_POPUP and not S_SELECT_SINGLE --><input type="checkbox" name="user" value="{memberrow.USERNAME}" /> <!-- ENDIF -->{memberrow.USERNAME_FULL}<!-- IF S_SELECT_SINGLE --><br />[&nbsp;<a href="#" onclick="insert_single('{memberrow.A_USERNAME}'); return false;">{L_SELECT}</a>&nbsp;]<!-- ENDIF --></td>

<td class="posts"><!-- IF memberrow.POSTS --><a href="{memberrow.U_SEARCH_USER}" title="{L_SEARCH_USER_POSTS}">{memberrow.POSTS}</a><!-- ELSE -->{memberrow.POSTS}<!-- ENDIF --></td>

<td class="info"><!-- IF memberrow.U_WWW or memberrow.LOCATION --><!-- IF memberrow.U_WWW --><div><a href="{memberrow.U_WWW}" title="{L_VISIT_WEBSITE}: {memberrow.U_WWW}">{memberrow.U_WWW}</a></div><!-- ENDIF --><!-- IF memberrow.LOCATION --><div>{memberrow.LOCATION}</div><!-- ENDIF --><!-- ELSE -->&nbsp;<!-- ENDIF --></td>

</thead>

<tbody>

<!-- BEGIN admin -->

<td><!-- IF admin.RANK_IMG --><span class="rank-img">{admin.RANK_IMG}</span><!-- ELSE --><span class="rank-img">{admin.RANK_TITLE}</span><!-- ENDIF -->{admin.USERNAME_FULL}</td>

<td class="info"><!-- IF admin.U_GROUP -->

<a<!-- IF admin.GROUP_COLOR --> style="font-weight: bold; color:#{admin.GROUP_COLOR}"<!-- ENDIF --> href="{admin.U_GROUP}">{admin.GROUP_NAME}</a>

</thead>

<tbody>

<!-- BEGIN mod -->

<td><!-- IF mod.RANK_IMG --><span class="rank-img">{mod.RANK_IMG}</span><!-- ELSE --><span class="rank-img">{mod.RANK_TITLE}</span><!-- ENDIF -->{mod.USERNAME_FULL}</td>

<td class="info"><!-- IF mod.U_GROUP -->

<a<!-- IF mod.GROUP_COLOR --> style="font-weight: bold; color:#{mod.GROUP_COLOR}"<!-- ENDIF --> href="{mod.U_GROUP}">{mod.GROUP_NAME}</a>

<dt><label>{L_TO}:</label></dt>

<dd>

<!-- BEGIN to_recipient -->

<!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a>&nbsp;<!-- ELSE -->{to_recipient.NAME_FULL}&nbsp;<!-- ENDIF -->

<!-- IF not S_EDIT_POST --><input type="submit" name="remove_{to_recipient.TYPE}[{to_recipient.UG_ID}]" value="x" class="button2" />&nbsp;<!-- ENDIF -->

<!-- END to_recipient -->

<dt><label>{L_BCC}:</label></dt>

<dd>

<!-- BEGIN bcc_recipient -->

<!-- IF bcc_recipient.IS_GROUP --><a href="{bcc_recipient.U_VIEW}"><strong>{bcc_recipient.NAME}</strong></a><!-- ELSE -->{bcc_recipient.NAME_FULL}&nbsp;<!-- ENDIF -->

<!-- IF not S_EDIT_POST --><input type="submit" name="remove_{bcc_recipient.TYPE}[{bcc_recipient.UG_ID}]" value="x" class="button2" />&nbsp;<!-- ENDIF -->

<!-- END bcc_recipient -->

<!-- IF .to_recipient -->

<dd>

<!-- BEGIN to_recipient -->

<!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a><!-- ELSE -->{to_recipient.NAME_FULL}&nbsp;<!-- ENDIF -->

<!-- IF not S_EDIT_POST --><input type="submit" name="remove_{to_recipient.TYPE}[{to_recipient.UG_ID}]" value="x" class="button2" />&nbsp;<!-- ENDIF -->

<!-- END to_recipient -->

<p>{L_POST_REVIEW_EXPLAIN}</p>

<!-- BEGIN post_review_row -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="postbody">

<div id="topicreview">

<!-- BEGIN topic_review_row -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="postbody" id="pr{topic_review_row.POST_ID}">

</thead>

<tbody>

<!-- BEGIN recentsearch -->

<td><a href="{recentsearch.U_KEYWORDS}">{recentsearch.KEYWORDS}</a></td>

<td class="active"><span>&nbsp;{recentsearch.TIME}</span></td>

</tr>

<ul class="topiclist topics">

<!-- BEGIN searchresults -->

<dl class="icon" style="background-image: url({searchresults.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt <!-- IF searchresults.TOPIC_ICON_IMG -->style="background-image: url({T_ICONS_PATH}{searchresults.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF -->>

<!-- IF searchresults.S_UNREAD_TOPIC --><a href="{searchresults.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF -->

<!-- ELSE -->

<!-- BEGIN searchresults -->

<div class="inner"><span class="corners-top"><span></span></span>

<!-- IF searchresults.S_IGNORE_POST -->

<ul class="topiclist cplist">

<!-- BEGIN attachrow -->

<dl>

<dt style="width: 40%"><a href="{attachrow.U_VIEW_ATTACHMENT}" class="topictitle">{attachrow.FILENAME}</a> ({attachrow.SIZE})<br />

<!-- IF attachrow.S_IN_MESSAGE -->{L_PM}: <!-- ELSE -->{L_TOPIC}: <!-- ENDIF --><a href="{attachrow.U_VIEW_TOPIC}">{attachrow.TOPIC_TITLE}</a></dt>

<div id="gallery">

<!-- BEGIN avatar_row --><!-- BEGIN avatar_column -->

<!-- END avatar_column --><!-- END avatar_row -->

</div>

</thead>

<tbody>

<!-- BEGIN leader -->

<td class="name">{leader.USERNAME_FULL}</td>

<td><!-- IF leader.S_GROUP_DEFAULT -->{L_YES}<!-- ELSE -->{L_NO}<!-- ENDIF --></td>

<td class="posts">{leader.USER_POSTS}</td>

</thead>

<tbody>

<!-- ELSE -->

<td class="name">{member.USERNAME_FULL}</td>

<td><!-- IF member.S_GROUP_DEFAULT -->{L_YES}<!-- ELSE -->{L_NO}<!-- ENDIF --></td>

<td class="posts">{member.USER_POSTS}</td>

<ul class="topiclist cplist">

<!-- BEGIN leader -->

<dl>

<dt><a href="{leader.U_EDIT}" class="topictitle"<!-- IF leader.GROUP_COLOUR --> style="color: #{leader.GROUP_COLOUR};"<!-- ENDIF -->>{leader.GROUP_NAME}</a>

<!-- IF leader.GROUP_DESC --><br />{leader.GROUP_DESC}<!-- ENDIF --></dt>

<!-- IF not leader.GROUP_SPECIAL -->

<!-- DEFINE $SHOW_BUTTONS = 1 -->

<!-- ENDIF -->

<dl>

<dt><!-- IF S_CHANGE_DEFAULT --><input title="{L_CHANGE_DEFAULT_GROUP}" type="radio" name="default"<!-- IF leader.S_GROUP_DEFAULT --> checked="checked"<!-- ENDIF --> value="{leader.GROUP_ID}" /> <!-- ENDIF -->

<a href="{leader.U_VIEW_GROUP}" class="forumtitle"<!-- IF leader.GROUP_COLOUR --> style="color:#{leader.GROUP_COLOUR}"<!-- ENDIF -->>{leader.GROUP_NAME}</a>

<!-- IF not member.GROUP_SPECIAL -->

<!-- DEFINE $SHOW_BUTTONS = 1 -->

<!-- ENDIF -->

<dl>

<dt><!-- IF S_CHANGE_DEFAULT --><input title="{L_CHANGE_DEFAULT_GROUP}" type="radio" name="default"<!-- IF member.S_GROUP_DEFAULT --> checked="checked"<!-- ENDIF --> value="{member.GROUP_ID}" /> <!-- ENDIF -->

<a href="{member.U_VIEW_GROUP}" class="forumtitle"<!-- IF member.GROUP_COLOUR --> style="color:#{member.GROUP_COLOUR}"<!-- ENDIF -->>{member.GROUP_NAME}</a>

<!-- IF not pending.GROUP_SPECIAL -->

<!-- DEFINE $SHOW_BUTTONS = 1 -->

<!-- ENDIF -->

<dl>

<dt>

<a href="{pending.U_VIEW_GROUP}" class="forumtitle"<!-- IF pending.GROUP_COLOUR --> style="color:#{pending.GROUP_COLOUR}"<!-- ENDIF -->>{pending.GROUP_NAME}</a>

<!-- IF nonmember.S_CAN_JOIN -->

<!-- DEFINE $SHOW_BUTTONS = 1 -->

<!-- ENDIF -->

<dl>

<dt>

<a href="{nonmember.U_VIEW_GROUP}" class="forumtitle"<!-- IF nonmember.GROUP_COLOUR --> style="color:#{nonmember.GROUP_COLOUR}"<!-- ENDIF -->>{nonmember.GROUP_NAME}</a>

<ul class="topiclist cplist">

<!-- BEGIN topicrow -->

<!-- IF topicrow.S_DELETED_TOPIC -->

<dl><dt><strong>{L_DELETED_TOPIC}</strong></dt>

<dd class="mark"><input type="checkbox" name="t[{topicrow.TOPIC_ID}]" id="t{topicrow.TOPIC_ID}" /></dd>

<ul class="topiclist cplist">

<!-- BEGIN draftrow -->

<dl>

<dt>

<a class="topictitle" href="{draftrow.U_VIEW_EDIT}">{draftrow.DRAFT_SUBJECT}</a><br />

<ul class="topiclist cplist">

<!-- BEGIN topicrow -->

<dl class="icon" style="background-image: url({topicrow.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt <!-- IF topicrow.TOPIC_ICON_IMG -->style="background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF -->>

<!-- IF topicrow.S_UNREAD --><a href="{topicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a><br />

<ul class="topiclist cplist">

<!-- BEGIN forumrow -->

<dl class="icon" style="background-image: url({forumrow.FORUM_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt><a href="{forumrow.U_VIEWFORUM}" class="forumtitle">{forumrow.FORUM_NAME}</a><br />

<!-- IF forumrow.LAST_POST_TIME -->{L_LAST_POST} {forumrow.LAST_POST_AUTHOR_FULL} <a href="{forumrow.U_LAST_POST}">{LAST_POST_IMG}</a> {L_POSTED_ON_DATE} {forumrow.LAST_POST_TIME}

<ul class="topiclist cplist">

<!-- BEGIN topicrow -->

<dl class="icon" style="background-image: url({topicrow.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt style="<!-- IF topicrow.TOPIC_ICON_IMG -->background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;<!-- ENDIF -->" title="{topicrow.TOPIC_FOLDER_IMG_ALT}">

<!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a>

<div id="topicreview">

<!-- BEGIN history_row -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="postbody" id="pr{history_row.MSG_ID}">

<ul class="topiclist cplist pmlist">

<!-- BEGIN messagerow -->

<dl class="icon" style="background-image: url({messagerow.FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt<!-- IF messagerow.PM_ICON_URL and S_PM_ICONS --> style="background-image: url({messagerow.PM_ICON_URL}); background-repeat: no-repeat;"<!-- ENDIF -->>

<ul class="topiclist topics">

<!-- ENDIF -->

<dl class="icon" style="background-image: url({topicrow.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt<!-- IF topicrow.TOPIC_ICON_IMG and S_TOPIC_ICONS --> style="background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF --> title="{topicrow.TOPIC_FOLDER_IMG_ALT}"><!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a>

<!-- IF topicrow.S_TOPIC_UNAPPROVED or topicrow.S_POSTS_UNAPPROVED --><a href="{topicrow.U_MCP_QUEUE}">{topicrow.UNAPPROVED_IMG}</a> <!-- ENDIF -->

</thead>

<tbody>

<!-- BEGIN user_row -->

<td>{user_row.USERNAME_FULL}<!-- IF user_row.USER_IP --> <span style="margin-left: 30px;">{L_IP}: <a href="{user_row.U_USER_IP}">{user_row.USER_IP}</a> &#187; <a href="{user_row.U_WHOIS}" onclick="popup(this.href, 750, 500); return false;">{L_WHOIS}</a></span><!-- ENDIF -->

<!-- IF user_row.USER_BROWSER --><br />{user_row.USER_BROWSER}<!-- ENDIF --></td>

<td class="info"><a href="{user_row.U_FORUM_LOCATION}">{user_row.FORUM_LOCATION}</a></td>

<!-- BEGIN postrow -->

<!-- IF postrow.S_FIRST_UNREAD --><a id="unread"></a><!-- ENDIF -->

<div class="inner"><span class="corners-top"><span></span></span>

<div class="postbody">