if ($sql->count_rows()) {
$query = "SELECT account_id,name,class,lv,exp,position FROM {$CONFIG_sql_dbname}.guild_member WHERE guild_id=\"" . mysql_res($GET_guild_id) . "\" ORDER BY position ASC";
$sql->result = $sql->execute_query($query, 'guildinfo.php');
$sql->total_query++;
$IS_SEARCHING_ID = checkprivilege_action($CP[login_id], g_searching_id) ? 1 : 0;
$countstanding = 0;
$i = 0;
while ($grow = $sql->fetch_row()) {
$i++;
$countstanding = 1;
$jobid = $grow['class'];
$query = "SELECT name FROM {$CONFIG_sql_dbname}.guild_position WHERE guild_id=\"" . mysql_res($GET_guild_id) . "\" and position=\"" . $grow['position'] . "\"";
$sql->result2 = $sql->execute_query($query, 'guildinfo.php');
$prow = $sql->fetch_row($sql->result2);
$name = $IS_SEARCHING_ID ? "<a href=\"index.php?act=searching_id&account_id={$grow['account_id']}\">" . htmlspecialchars($grow['name']) . "</a>" : "" . htmlspecialchars($grow['name']) . "";
echo "\n\t\t<TR align=\"center\" class=\"topic_title4\">\n\t\t\t<TD>{$i}</TD>\n\t\t\t<TD>{$name}</TD>\n\t\t\t<TD>{$jobname[$jobid]}</TD>\n\t\t\t<TD>{$grow['lv']}</TD>\n\t\t\t<TD>{$grow['exp']}</TD>\n\t\t\t<TD>" . htmlspecialchars($prow['name']) . "</TD>\n\t\t</TR>\n";
}
if (isset($emblems)) {
session_register(emblems);
$_SESSION['emblems'] = $emblems;
}
} else {
$countstanding = 1;
echo "\n\t\t<TR align=\"center\" class=\"topic_title4\">\n\t\t\t<TD colspan=\"6\">\n\t\t\t\tNo guilds in database!\n\t\t\t</TD>\n\t\t</TR>\n";
}
if (!$countstanding) {
echo "\n\t\t<TR align=\"center\" class=\"topic_title4\">\n\t\t\t<TD colspan=\"6\">\n\t\t\t\tNo guilds in database!\n\t\t\t</TD>\n\t\t</TR>\n";
}
echo "\n\t</TBODY>\n</TABLE>\n";
clmain_body();
function redir_back($message)
{
global $lang;
if (empty($message)) {
$message_ = "";
} else {
$message_ = "" . htmlspecialchars($message) . "<br /><br />";
$message_ = exceptchars_decode($message_);
}
echo "\n\t<TABLE width=\"100%\" height=\"85%\" align=\"center\">\n\t\t<TR>\n\t\t\t<TD valign=\"top\">\n";
opmain_body("CP Message", 0, 0);
echo "\t\t\t\t<TABLE align=\"center\" cellpadding=\"4\" cellspacing=\"0\">\n\t\t\t\t\t<TR class=\"topic_title5\">\n\t\t\t\t\t\t<TD height=\"20\"></TD>\n\t\t\t\t\t</TR>\n\t\t\t\t\t<TR class=\"topic_title6\">\n\t\t\t\t\t\t<TD width=\"250\" height=\"50\" align=\"center\" nowrap=\"nowrap\" align=\"center\">\n\t\t\t\t\t\t\t{$message_}\n\t\t\t\t\t\t</TD>\n\t\t\t\t\t</TR>\n\t\t\t\t\t<TR class=\"topic_title5\" align=\"center\">\n\t\t\t\t\t\t<TD height=\"20\"><B><a href=\"javascript:history.back();\">{$lang['Wait_Back']}</a></B></TD>\n\t\t\t\t\t</TR>\n\t\t\t\t</TABLE>\n";
clmain_body();
echo "\t\t\t</TD>\n\t\t</TR>\n\t</TABLE>\n";
}