$query = "SELECT `config_name`, `config_value` " . "FROM `" . $roster->db->table('config_guild', $addon['basename']) . "` " . "WHERE `guild_id` = " . $roster->data['guild_id'] . ";";
$result = $roster->db->query($query);
while ($row = $roster->db->fetch($result, SQL_ASSOC)) {
$addon['rules'][$row['config_name']] = $row['config_value'];
}
$mainQuery = 'SELECT ' . '`members`.`member_id`, ' . '`members`.`name`, ' . '`members`.`note`, ' . "IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', " . '`members`.`officer_note`, ' . "IF( `members`.`officer_note` IS NULL OR `members`.`officer_note` = '', 1, 0 ) AS 'onisnull', " . '`alts`.`main_id`, ' . '`alts`.`alt_type`, ' . '`mains`.`name` AS main_name ' . 'FROM `' . $roster->db->table('members') . '` AS members ' . 'LEFT JOIN `' . $roster->db->table('alts', $addon['basename']) . '` AS alts ON `members`.`member_id` = `alts`.`member_id` ' . 'LEFT JOIN `' . $roster->db->table('members') . '` AS mains ON `alts`.`main_id` = `mains`.`member_id` ' . 'WHERE `members`.`guild_id` = "' . $roster->data['guild_id'] . '" ' . 'ORDER BY IF(`members`.`member_id` = `alts`.`member_id`,1,0), ';
$always_sort = ' `members`.`level` DESC, `members`.`name` ASC';
$FIELD['name'] = array('lang_field' => 'name', 'order' => array('`members`.`name` ASC'), 'order_d' => array('`members`.`name` DESC'), 'js_type' => 'ts_string', 'display' => 3);
$FIELD['main_name'] = array('lang_field' => 'main_name', 'order' => array('`mains`.`name` ASC'), 'order_d' => array('`mains`.`name` DESC'), 'js_type' => 'ts_string', 'display' => 3);
$FIELD['alt_type'] = array('lang_field' => 'alt_type', 'order' => array('`alts`.`alt_type` ASC'), 'order_d' => array('`alts`.`alt_type` DESC'), 'js_type' => 'ts_number', 'display' => 3);
$FIELD['note'] = array('lang_field' => 'note', 'order' => array('nisnull', '`members`.`note` ASC'), 'order_d' => array('nisnull', '`members`.`note` DESC'), 'js_type' => 'ts_string', 'display' => 3, 'value' => 'debugNote');
$FIELD['officer_note'] = array('lang_field' => 'officer_note', 'order' => array('onisnull', '`members`.`note` ASC'), 'order_d' => array('onisnull', '`members`.`note` DESC'), 'js_type' => 'ts_string', 'display' => $addon['config']['member_onote'] ? 3 : 0, 'value' => 'debugNote');
include_once $addon['inc_dir'] . 'memberslist.php';
$memberlist = new memberslist();
$memberlist->prepareData($mainQuery, $always_sort, $FIELD, 'memberslist');
$memberlist->makeFilterBox();
echo $memberlist->makeMembersList('syellow');
echo "<br />\n" . scrollbox(aprint($addon, '$addon', true), 'Config data', 'sgray');
function debugNote($row, $field, $data)
{
global $addon;
$rules = $addon['rules']['use_global'] ? $addon['config'] : $addon['rules'];
if (preg_match($rules['getmain_regex'], $row[$field], $regs)) {
$tooltip_h = $regs[$rules['getmain_match']];
$tooltip = aprint($regs, '', true);
} else {
$tooltip_h = '';
$tooltip = 'No main match';
}
return '<div ' . makeOverlib($tooltip, $tooltip_h) . '>' . $row[$field] . '</div>' . "\n";
}
$op = '';
}
switch ($op) {
case 'getlast':
global $toggleboxes;
$toggleboxes++;
$query = "SELECT * FROM " . ANNOUNCE_TABLE . " WHERE active = '1' order by date DESC LIMIT " . $howmany . "";
$results = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
while ($row = $wowdb->fetch_array($results)) {
$message = $row['post'];
$title = $row['title'];
$style = 'sgray';
$open = false;
$width = '550px';
$height = '100px';
echo '<div id="toggleCol' . $toggleboxes . '" style="display:' . ($open ? 'none' : 'inline') . ';">' . border($style, 'start', "<div style=\"cursor:pointer;width:" . $width . ";\" onclick=\"swapShow('toggleCol" . $toggleboxes . "','toggle" . $toggleboxes . "')\"><img src=\"" . $roster_conf['img_url'] . "plus.gif\" style=\"float:right;\" /> Announcement: " . $title . "</div>") . border($style, 'end') . '</div>' . '<div id="toggle' . $toggleboxes . '" style="display:' . ($open ? 'inline' : 'none') . ';">' . scrollbox($message, "<div style=\"cursor:pointer;width:" . $width . ";\" onclick=\"swapShow('toggleCol" . $toggleboxes . "','toggle" . $toggleboxes . "')\"><img src=\"" . $roster_conf['img_url'] . "minus.gif\" style=\"float:right;\" /> Announcement: " . $title . "</div>", $style, $width, $height) . '</div><br>';
}
break;
default:
$query = "SELECT * FROM " . ANNOUNCE_TABLE . " WHERE active='1' order by date DESC";
$results = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
while ($row = $wowdb->fetch_array($results)) {
// Convert the date to readable time
$date = get_local_date($row['date'], $roster_conf['localtimeoffset']);
// In the archive, display all boxes open.
echo border('syellow', 'start');
?>
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class='simpleborderheader syellowborderheader'><div class="membersGroup">
// Display MySQL Tables
$sql_tables = '';
$result = $roster->db->query("SHOW TABLES;");
if (!$result) {
$table_list .= 'DB Error, could not list tables<br />' . "\n";
$table_list .= 'MySQL Error: ' . $roster->db->error() . '' . "\n";
} else {
$rowstripe = 1;
$table_list = "\n<table class=\"border_frame\" style=\"width:100%;\" cellspacing=\"0\">\n";
while ($row = $roster->db->fetch($result)) {
$table_list .= '<tr><td class="membersRow' . (++$rowstripe % 2 + 1) . '">' . $row[0] . '</td></tr>' . "\n";
}
$table_list .= "</table>\n";
$roster->db->free_result($result);
}
$sql_tables .= scrollbox($table_list, 'MySQL Tables', '', '100%', '231px');
echo $sql_tables;
// Table display fix
echo "</td></tr></table>\n";
// File Versioning Information
if (GrabRemoteVersions() !== false) {
//GrabRemoteVersions();
VerifyVersions();
$zippackage_files = '';
// Make a post form for the download of a Zip Package
foreach ($directories as $directory => $filecount) {
if (isset($files[$directory])) {
foreach ($files[$directory] as $file => $filedata) {
if ($filedata['update']) {
if (isset($file) && $file != 'newer' && $file != 'severity' && $file != 'tooltip' && $file != 'rollup' && $file != 'rev' && $file != 'date' && $file != 'author' && $file != 'md5' && $file != 'update' && $file != 'missing') {
if ($zippackage_files != '') {
