Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /// Roster Display Code ///
- <?
- // Check for Individual Game ID
- $gameid = filter_input(INPUT_GET,'id',FILTER_SANITIZE_SPECIAL_CHARS);
- // Check for Missing in Action Roster
- if (filter_input(INPUT_GET,'mia',FILTER_SANITIZE_NUMBER_INT) != 1 ) {$mia = false;} else {$mia = true;}
- if ($gameid == null) {$default = true;} else {$default = false;}
- require_once('custom/functions.php');
- // Check for Sort By
- $sortby = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_SPECIAL_CHARS);
- //Check for Sort Order
- $sortorder = filter_input(INPUT_GET,'order',FILTER_SANITIZE_SPECIAL_CHARS);
- // Define Games and Lists //
- $sql = "SELECT gamename, abbreviation, ingamename, profilefield, status FROM " . TABLE_PREFIX . "gamelist ORDER BY gamename";
- $result = $db->query_read_slave($sql);
- while ($a = mysql_fetch_array($result)) {
- $gameslist[] = $a;
- }
- // Add Other Games
- $gameslist[] = array("Other Game", "other", "", "", "Miscellaneous");
- page_header("Clan Rosters");
- $divs = $guilds = $divdev = $misc = array();
- foreach ($gameslist as $game) {
- switch ($game[4]){
- case "Divisions":
- $divs[] = array($game[0],$game[1]);
- break;
- case "Guilds":
- $guilds[] = array($game[0],$game[1]);
- break;
- case "Divisions in Development":
- $divdev[] = array($game[0],$game[1]);
- break;
- case "Miscellaneous":
- $misc[] = array($game[0],$game[1]);
- break;
- }
- }
- roster_list("Divisions",$divs,$mia);
- roster_list("Guilds",$guilds,$mia);
- roster_list("Divisions in Development",$divdev,$mia);
- roster_list("Miscellaneous",$misc,$mia);
- echo "</table></div></div></div>";
- // End Roster Navigation List
- // Check if Main Page or Specific Game
- if ($default == true) {
- // Default page is Leadership Roster
- // Query the database for leaders only //
- $leaderq = $db->query_read_slave("SELECT user.username, user.usertitle, usergroup.usergroupid, usergroup.opentag, userfield.userid, userfield.field5 FROM " . TABLE_PREFIX . "user AS user LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON (user.usergroupid=usergroup.usergroupid) LEFT JOIN " . TABLE_PREFIX . "userfield as userfield ON (userfield.userid=user.userid) WHERE user.username!='' AND user.usergroupid IN (5,6,17,18,55,56,38,50,24,54) ORDER BY title, field5, username");
- // Convert query into a useable array //
- $leaders = array();
- while ($leadersarray = mysql_fetch_array($leaderq)) {
- $leaders[] = $leadersarray;
- }
- leadership_roster($leaders);
- } else {
- unset($gameslist[$movekey]);
- $gameslist[] = $move;
- // Find Key //
- for ($i=0;$i<count($gameslist);$i++) {
- if (in_array($gameid, $gameslist[$i])) {$key = $i;}
- }
- $maingame = $gameslist[$key][0];
- $link = $gameslist[$key][1];
- $ign = $gameslist[$key][2];
- $field = $gameslist[$key][3];
- $bitcheck = 1<<$key;
- // Check for in-game field
- if ($field != "") { $userfield = "userfield." . $field . ","; } else { $userfield = ""; }
- // User Query
- $mainusers = $db->query_read_slave("SELECT user.username, user.joindate, user.lastactivity, user.posts, usergroup.usergroupid, usergroup.title, usergroup.opentag, userfield.field5, " . $userfield . " userfield.userid FROM " . TABLE_PREFIX . "user AS user LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON (user.usergroupid = usergroup.usergroupid) LEFT JOIN " . TABLE_PREFIX . "userfield as userfield ON (userfield.userid = user.userid) WHERE userfield.field5='" . $maingame . "' AND user.username != '' ORDER BY field(user.usergroupid,17,18,55,56,38,50,6,5,24,58,54,49,47,53,52,51,35,2,27,45,21,20,23,8,3,4,0)" . $addedsort . ", username");
- // Set the Main Game Users
- $maingameusers = array();
- while ($userarray = mysql_fetch_array($mainusers)) {
- $maingameusers[] = $userarray;
- }
- // Get Other Game Members
- $otherusers = $db->query_read_slave("SELECT user.username, user.joindate, user.lastactivity, usergroup.usergroupid, usergroup.title, usergroup.opentag, userfield.field6, " . $userfield . " userfield.userid FROM " . TABLE_PREFIX . "user AS user LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON (user.usergroupid = usergroup.usergroupid) LEFT JOIN " . TABLE_PREFIX . "userfield as userfield ON (userfield.userid = user.userid) WHERE (userfield.field5 != '" . $maingame . "') AND (userfield.field6 & " . $bitcheck . ") AND (user.username != '') ORDER BY title, username");
- // Set the Users Aray
- $othergameusers = array();
- while ($userarray = mysql_fetch_array($otherusers)) {
- $othergameusers[] = $userarray;
- }
- game_roster($maingame,$link,$ign,$field,$mia,$sortby,$sortorder,$maingameusers,$othergameusers);
- }
- page_footer();
- ?>
- /// BACKEND ///
- <?php
- // Rosters
- // by DrMath
- // ######################## SET PHP ENVIRONMENT ###########################
- error_reporting(E_ALL & ~E_NOTICE);
- // #################### PRE-CACHE TEMPLATES AND DATA ######################
- $phrasegroups = array('style');
- $specialtemplates = array('products');
- // ########################## REQUIRE BACK-END ############################
- require_once('./global.php');
- require_once(DIR . '/includes/adminfunctions_template.php');
- $this_script = 'rosters';
- $rpm_ver = 1.0;
- $rpm_mouseover_fontcolor = '#D04850';
- // ######################## CHECK ADMIN PERMISSIONS #######################
- if (!can_administer('canadminusers'))
- {
- print_cp_no_permission();
- }
- print_cp_header();
- echo "<div class='pagetitle'>Edit Clan Rosters</div>";
- // Get Profile Fields //
- $sql = "SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield";
- $result = $db->query_read_slave($sql);
- $fields = array();
- $fields[] = "Select a Field";
- while( $a = mysql_fetch_array($result) ) {
- $fields[] = "field" . $a[0];
- }
- // Get Main Games //
- $sql = "SELECT profilefieldid, data FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid = 5";
- $result = $db->query_read_slave($sql);
- $gamesbase = mysql_fetch_array($result);
- $gamesbase = unserialize($gamesbase[1]);
- $games = array();
- $games[] = "Select a Game";
- foreach ($gamesbase as $game) {
- $games[] = $game;
- }
- // Get Current Games //
- $sql = "SELECT gamename FROM " . TABLE_PREFIX . "gamelist ORDER BY gamename ASC";
- $result = $db->query_read_slave($sql);
- $currentgames = array();
- while( $a = mysql_fetch_array($result) ) {
- $currentgames[] = "$a[0]";
- }
- // Game Status //
- $gamestatuses = array("Select a Status","Divisions", "Guilds", "Divisions in Development", "Miscellaneous");
- /////////////////////// front page
- if ( empty($_POST['do']) ) {
- print_form_header($this_script, 'add');
- print_table_header('Add Game');
- print_select_row('Main Game', 'game', $games);
- print_input_row('Abbreviation', 'abbrev');
- print_input_row('Account Name', 'acctname');
- print_select_row('Account Profile Field', 'proffield', $fields);
- print_select_row('Game Status', 'status', $gamestatuses);
- print_submit_row('Add Game');
- ////////////////////// get current games
- $sql = "SELECT * FROM " . TABLE_PREFIX . "gamelist ORDER BY gamename ASC";
- $result = $db->query_read_slave($sql);
- print_form_header($this_script, 'remove');
- print_table_header('Current Games in Roster',6);
- echo "<tr><th>Game</th><th>Abbreviation</th><th>In-Game Name</th><th>Profile Field</th><th>Status</th><th>Delete?</th></tr>";
- $i = 0;
- while ($game = mysql_fetch_array($result)) {
- if ($i & 1) {$added = "class='alt1' style='text-align:center;'";} else {$added = "class='alt2' style='text-align:center;'";}
- echo "<tr>
- <td $added>$game[1]</td>
- <td $added>$game[2]</td>
- <td $added>$game[3]</td>
- <td $added>$game[4]</td>
- <td $added>$game[5]</td>
- <td $added><input type='checkbox' name='delete[]' value='$game[0]'></td>
- </tr>";
- $i ++;
- }
- print_submit_row('Remove Selected',"Reset",6);
- ////////////////////// edit a game
- print_form_header($this_script, 'editg');
- print_table_header('Edit an Entry');
- print_label_row('Notice', 'If this does not work, delete entry and re-enter.');
- print_select_row('Game to Edit', 'editgame', $currentgames);
- print_submit_row('Edit Game');
- }
- /////////////////////// add
- if ( $_POST['do'] == 'add' ) {
- if ( empty($_POST['game']) OR empty($_POST['abbrev']) OR empty($_POST['status']) ) { rpm_print_stop_back('Please be sure every required field is filled out before submitting.'); }
- $vbulletin->input->clean_array_gpc('p', array(
- 'game' => TYPE_UNIT,
- 'abbrev' => TYPE_STR,
- 'acctname' => TYPE_STR,
- 'proffield' => TYPE_UNIT,
- 'status' => TYPE_UNIT
- ));
- $pgame = $db->escape_string($games[$vbulletin->GPC['game']]);
- $pabr = $db->escape_string($vbulletin->GPC['abbrev']);
- $pacctname = $db->escape_string($vbulletin->GPC['acctname']);
- $pfield = $db->escape_string($fields[$vbulletin->GPC['proffield']]);
- $pstatus = $db->escape_string($gamestatuses[$vbulletin->GPC['status']]);
- $sql = "INSERT INTO " . TABLE_PREFIX . "gamelist (gamename, abbreviation, ingamename, profilefield, status) VALUES ('$pgame', '$pabr', '$pacctname', '$pfield', '$pstatus')";
- $db->query_write($sql);
- define('CP_REDIRECT', 'rosters.php');
- print_stop_message('roster_game_added');
- }
- /////////////////////// edit
- if ( $_POST['do'] == 'editg' ) {
- if ( empty($_POST['editgame']) ) { rpm_print_stop_back('Please be sure every required field is filled out before submitting.'); }
- $vbulletin->input->clean_array_gpc('p', array(
- 'editgame' => TYPE_UNIT
- ));
- $egame = $db->escape_string($currentgames[$vbulletin->GPC['editgame']]);
- $sql = "SELECT * FROM " . TABLE_PREFIX . "gamelist WHERE gamename = '$egame'";
- $result = $db->query_read_slave($sql);
- $ugame = mysql_fetch_row($result);
- foreach ($fields as $key => $f) {
- if ($f == $ugame[4]) {$field = $key;}
- }
- foreach ($gamestatuses as $key => $s) {
- if ($s == $ugame[5]) {$status = $key;}
- }
- print_form_header($this_script, 'update');
- print_table_header('Update '.$egame);
- // print_select_row('Main Game', 'mgame', $currentgames, $ugame[1]);
- echo "<input type='hidden' name='game' value='$egame'>";
- print_input_row('Abbreviation', 'abbrev', $ugame[2]);
- print_input_row('Account Name', 'acctname', $ugame[3]);
- print_select_row('Account Profile Field', 'proffield', $fields, $field);
- print_select_row('Game Status', 'status', $gamestatuses, $status);
- print_submit_row('Update Game');
- }
- /////////////////////// add
- if ( $_POST['do'] == 'update' ) {
- if ( empty($_POST['game']) OR empty($_POST['abbrev']) OR empty($_POST['status']) ) { rpm_print_stop_back('Please be sure every required field is filled out before submitting.'); }
- $vbulletin->input->clean_array_gpc('p', array(
- 'game' => TYPE_STR,
- 'abbrev' => TYPE_STR,
- 'acctname' => TYPE_STR,
- 'proffield' => TYPE_UNIT,
- 'status' => TYPE_UNIT
- ));
- $pgame = $db->escape_string($vbulletin->GPC['game']);
- $pabr = $db->escape_string($vbulletin->GPC['abbrev']);
- $pacctname = $db->escape_string($vbulletin->GPC['acctname']);
- $pfield = $db->escape_string($fields[$vbulletin->GPC['proffield']]);
- $pstatus = $db->escape_string($gamestatuses[$vbulletin->GPC['status']]);
- $sql = "UPDATE " . TABLE_PREFIX . "gamelist SET abbreviation='$pabr', ingamename='$pacctname', profilefield='$pfield', status='$pstatus' WHERE gamename = '$pgame'";
- $db->query_write($sql);
- define('CP_REDIRECT', 'rosters.php');
- print_stop_message('roster_game_updated');
- }
- /////////////////////// remove
- if ( $_POST['do'] == 'remove' ) {
- $vbulletin->input->clean_array_gpc('p', array(
- 'delete' => TYPE_ARRAY));
- foreach ($vbulletin->GPC['delete'] as $deleted) {
- if(isset($deleted)){
- $removed[] = (int)$deleted;
- }
- }
- foreach ($removed as $delete) {
- $sql = "DELETE FROM " . TABLE_PREFIX . "gamelist WHERE gameid = $delete";
- $db->query_write($sql);
- }
- define('CP_REDIRECT', 'rosters.php');
- print_stop_message('roster_game_removed');
- }
- print_cp_footer();
- ?>
- /// Needed Functions for Roster ///
- <?php
- function page_header($pagetitle) {
- echo "<!-- Start Forum tcat Heading PureVB -->
- <div class='tcat'>
- <div class='tcatLeft'>
- <div class='tcatRight foruminfo L1 collapse'>
- <h2> <span class='forumtitle'>$pagetitle</span> </h2>
- </div>
- </div>
- </div>
- <div class='clearfix'></div>
- <div class='forumBitBoxTB'>
- <div class='forumbitBoxTL'>
- <div class='forumBitBoxTR'>
- <div class='forumBitBoxTWrap'></div>
- </div>
- </div>
- </div>
- <div class='forumbitBoxLeft'>
- <div class='forumbitBoxRight'>
- <div class='forumbitBox'>
- <blockquote class='postcontent restore '>";
- if ($pagetitle == "Clan Rosters") {
- // Create Roster Navigation List
- echo "<div id='sidebar_container' class='sidebar_closed'><div class='block smaller' style='width:20%; float:left;'><div class='widget_content blockbody'>
- <table width='100%'>
- <tbody>
- <tr><th class='blocksubhead'>Clan Leadership</th></tr>
- <tr><td> <a href='pages.php?pageid=15'>Clan Leaders</a></td></tr>";
- }
- }
- function page_footer() {
- echo "</td>
- </tr>
- </tbody>
- </table>
- </div>
- </blockquote>
- <div class='bottomBar'>
- <div class='bottomBarLeft'>
- <div class='bottomBarRight'> </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class='forumBitBoxTBB'>
- <div class='forumbitBoxBL'>
- <div class='forumBitBoxBR'>
- <div class='forumBitBoxBWrap'></div>
- </div>
- </div>
- </div>"; }
- // Function for Roster Games List
- function roster_list($heading, $games, $mia) {
- if (!empty($games)) {
- echo "<tr><th class='blocksubhead'>$heading</th></tr>";
- foreach ($games as $game) {
- $maingame = $game[0];
- $link = $game[1];
- if ($mia) {$link .= "&mia=1";}
- echo "<tr><td> <a href='pages.php?pageid=15&id=$link'>$maingame</a></td></tr>";
- }
- }
- }
- function leadership_roster($leadersarray) {
- // Defined Needed Arrays
- $ceo = $coo = $cdl = $cde = $cdj = $adl = $ade = $adj = $dls = $dos = $ecs = $gls = $gos = $gms = $mms = array();
- // Start the page code
- echo "<div style='width:80%; float:left;'>
- <div class='blockhead'>
- <h4>Clan Leadership Roster</h4>
- </div>
- <div class='blockbody'>
- <table width='100%' border='0' cellspacing='10' cellpadding='1'>
- <tbody>";
- // Check for Each Rank specialties //
- foreach ($leadersarray as $leader) {
- // Check each Leadergroup //
- switch ($leader['usergroupid']) {
- // Check for CDs //
- case '6':
- if (stristr($leader['usertitle'],'_exec') !== false) {
- $ceo = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_asex') !== false) {
- $coo = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_lead') !== false) {
- $cdl = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_exp') !== false) {
- $cde = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_ja') !== false) {
- $cdj = $leader;
- break;
- }
- // Check for ADs //
- case '5':
- if (stristr($leader['usertitle'],'_lead') !== false) {
- $adl[] = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_exp') !== false) {
- $ade[] = $leader;
- break;
- } elseif (stristr($leader['usertitle'],'_ja') !== false) {
- $adj[] = $leader;
- break;
- }
- // Check for DLs //
- case '17':
- $dls[] = $leader;
- break;
- // Check for DOs //
- case '18':
- $dos[] = $leader;
- break;
- // Check for ECs //
- case '24':
- $ecs[] = $leader;
- break;
- // Check for LTs //
- case '38':
- $lts[] = $leader;
- break;
- // Check for GLs //
- case '55':
- $gls[] = $leader;
- break;
- // Check for GOs //
- case '56':
- $gos[] = $leader;
- break;
- // Check for GMs //
- case '50':
- $gms[] = $leader;
- break;
- // Check for MMs //
- case '54':
- $mms[] = $leader;
- break;
- }
- // Sort Non-Game Specific Roles //
- //array_multisort($ecs['username'],SORT_ASC,SORT_STRING);
- //array_multisort($mms['username'],SORT_ASC,SORT_STRING);
- }
- // Clan Directors //
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/cdir.png' alt='Clan Director' /></th></tr>";
- echo "<tr style='background-color: #1e1e1e;'>
- <td width='33%' style='border:none;'><a href='member.php?u=".$ceo['userid']."'>".$ceo['opentag'].$ceo['username']."</span></a></td>
- <td width='33%' style='border:none;'>Executive Director</td>
- <td width='33%' style='border:none;'>".$ceo['field5']."</td>
- </tr>";
- if (empty($coo) == false) {
- echo "<tr>
- <td width='33%' style='border:none;'><a href='member.php?u=".$coo['userid']."'>".$coo['opentag'].$coo['username']."</span></a></td>
- <td width='33%' style='border:none;'>Assistant Executive Director</td>
- <td width='33%' style='border:none;'>".$coo['field5']."</td>
- </tr>";
- } else {
- echo "<tr>
- <td width='33%' style='border:none;'><span style='color:#1f4fae; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td width='33%' style='border:none;'>Assistant Executive Director</td>
- <td width='33%' style='border:none;'>N/A</td>
- </tr>";
- }
- if (empty($cdl) == false) {
- echo "<tr style='background-color: #1e1e1e;'>
- <td style='border:none;'><a href='member.php?u=".$cdl['userid']."'>".$cdl['opentag'].$cdl['username']."</span></a></td>
- <td style='border:none;'>Director of Leadership</td>
- <td style='border:none;'>".$cdl['field5']."</td>
- </tr>";
- } else {
- echo "<tr style='background-color: #1e1e1e;'>
- <td style='border:none;'><span style='color:#1f4fae; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Director of Leadership</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- if (empty($cde) == false) {
- echo "<tr>
- <td style='border:none;'><a href='member.php?u=".$cde['userid']."'>".$cde['opentag'].$cde['username']."</span></a></td>
- <td style='border:none;'>Director of Expansion</td>
- <td style='border:none;'>".$cde['field5']."</td>
- </tr>";
- } else {
- echo "<tr>
- <td style='border:none;'><span style='color:#1f4fae; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Director of Expansion</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- if (empty($cdj) == false) {
- echo "<tr>
- <td style='border:none;'><a href='member.php?u=".$cdj['userid']."'>".$cdj['opentag'].$cdj['username']."</span></a></td>
- <td style='border:none;'>Director Judge Arbiter</td>
- <td style='border:none;'>".$cdj['field5']."</td>
- </tr>";
- } else {
- echo "<tr>
- <td style='border:none;'><span style='color:#1f4fae; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Director Judge Arbiter</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- // Assistant Directors //
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/adir.png' alt='Assistant Director' /></th></tr>";
- if (empty($adl) == false) {
- $rownum = 0;
- foreach ($adl as $ad) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$ad['userid']."'>".$ad['opentag'].$ad['username']."</span></a></td>
- <td style='border:none;'>Assistant Director of Leadership</td>
- <td style='border:none;'>".$ad['field5']."</td>
- </tr>";
- }
- } else {
- echo "<tr style='background-color: #1e1e1e;'>
- <td style='border:none;'><span style='color:#1f4fae; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Assistant Director of Leadership</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- if (empty($ade) == false) {
- $rownum = 0;
- foreach ($ade as $ad) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$ad['userid']."'>".$ad['opentag'].$ad['username']."</span></a></td>
- <td style='border:none;'>Assistant Director of Expansion</td>
- <td style='border:none;'>".$ad['field5']."</td>
- </tr>";
- }
- } else {
- echo "<tr style='background-color: #1e1e1e;'>
- <td style='border:none;'><span style='color:#3391bd; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Assistant Director of Expansion</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- if (empty($adj) == false) {
- $rownum = 0;
- foreach ($adj as $ad) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$ad['userid']."'>".$ad['opentag'].$ad['username']."</span></a></td>
- <td style='border:none;'>Assistant Director Judge Arbiter</td>
- <td style='border:none;'>".$ad['field5']."</td>
- </tr>";
- }
- } else {
- echo "<tr style='background-color: #1e1e1e;'>
- <td style='border:none;'><span style='color:#3391bd; font-weight:bold; text-decoration:underline;'>Open</span></td>
- <td style='border:none;'>Assistant Director Judge Arbiter</td>
- <td style='border:none;'>N/A</td>
- </tr>";
- }
- // Division Leaders //
- if (empty($dls) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/dlead.png' alt='Division Leader' /></th></tr>";
- $rownum = 0;
- foreach ($dls as $dl) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$dl['userid']."'>".$dl['opentag'].$dl['username']."</span></a></td>
- <td style='border:none;'>Division Leader</td>
- <td style='border:none;'>".$dl['field5']."</td>
- </tr>";
- }
- }
- // Division Officers //
- if (empty($dos) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/doff.png' alt='Division Officer' /></th></tr>";
- $rownum = 0;
- foreach ($dos as $do) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$do['userid']."'>".$do['opentag'].$do['username']."</span></a></td>
- <td style='border:none;'>Division Officer</td>
- <td style='border:none;'>".$do['field5']."</td>
- </tr>";
- }
- }
- // Guild Leaders //
- if (empty($gls) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/glead.png' alt='Guild Leader' /></th></tr>";
- $rownum = 0;
- foreach ($gls as $gl) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$gl['userid']."'>".$gl['opentag'].$gl['username']."</span></a></td>
- <td style='border:none;'>Guild Leader</td>
- <td style='border:none;'>".$gl['field5']."</td>
- </tr>";
- }
- }
- // Guild Officers //
- if (empty($gos) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/goff.png' alt='Guild Officer' /></th></tr>";
- $rownum = 0;
- foreach ($gos as $go) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$go['userid']."'>".$go['opentag'].$go['username']."</span></a></td>
- <td style='border:none;'>Guild Officer</td>
- <td style='border:none;'>".$go['field5']."</td>
- </tr>";
- }
- }
- // Expansion Coordinators //
- if (empty($ecs) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/coor_exp.png' alt='Development Coordinator' /></th></tr>";
- $rownum = 0;
- foreach ($ecs as $ec) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$ec['userid']."'>".$ec['opentag'].$ec['username']."</span></a></td>
- <td style='border:none;'>Expansion Coordinator</td>
- <td style='border:none;'>".$ec['field5']."</td>
- </tr>";
- }
- }
- // Leadership Trainees //
- if (empty($lts) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/ltrain.png' alt='Leadership Trainee' /></th></tr>";
- $rownum = 0;
- foreach ($lts as $lt) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$lt['userid']."'>".$lt['opentag'].$lt['username']."</span></a></td>
- <td style='border:none;'>Leadership Trainee</td>
- <td style='border:none;'>".$lt['field5']."</td>
- </tr>";
- }
- }
- // Group Managers //
- if (empty($gms) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/gmgr.png' alt='Group Manager' /></th></tr>";
- $rownum = 0;
- foreach ($gms as $gm) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$gm['userid']."'>".$gm['opentag'].$gm['username']."</span></a></td>
- <td style='border:none;'>Group Manager</td>
- <td style='border:none;'>".$gm['field5']."</td>
- </tr>";
- }
- }
- // Media Managers //
- if (empty($mms) == false) {
- echo "<tr><th colspan='3' style='border:none; border-collapse:collapse;' class='blocksubhead'><img src='images/ranks/v9/mgr_media.png' alt='Media Manager' /></th></tr>";
- $rownum = 0;
- foreach ($mms as $mm) {
- $added = "";
- $rownum ++;
- if ($rownum & 1) { $added = "style='background-color: #1e1e1e;'"; }
- echo "<tr $added>
- <td style='border:none;'><a href='member.php?u=".$mm['userid']."'>".$mm['opentag'].$mm['username']."</span></a></td>
- <td style='border:none;'>Media Manager</td>
- <td style='border:none;'>".$mm['field5']."</td>
- </tr>";
- }
- }
- // //End for of Table//
- echo "</tbody>
- </table>
- </div>
- </div>";
- }
- function game_roster($maingame,$link,$ign,$field,$mia,$sortby,$sortorder,$mainusers,$otherusers) {
- $nonactive = array(1,3,4,7,8,20,21,23);
- echo "<div style='width:80%; float:left;'>";
- if ($field != null) { $numfields = 5; } else { $numfields = 4; }
- $colwidth = (100 / $numfields)."%";
- // Check for MIA Roster
- if ($mia) {$link .= "&mia=1";}
- $addedsort = $sortlink = "";
- // Check for possible sort
- switch ($sortby) {
- case "joindate":
- $addedsort .= ", joindate";
- break;
- case "lastactive":
- $addedsort .= ", lastactivity";
- break;
- case "posts":
- $addedsort .= ", posts";
- break;
- }
- // Check for possible sort order and create links
- switch ($sortorder) {
- case "":
- $sortlink = "&order=desc";
- break;
- case "asc":
- $addedsort .= " ASC";
- $sortlink = "&order=desc";
- break;
- case "desc":
- $addedsort .= " DESC";
- $sortlink = "&order=asc";
- break;
- }
- echo "<div class='blockhead'><h4>$maingame - Main Game Members</h4></div>
- <div class='blockbody'>
- <table width='100%' style='border:none; border-collapse:collapse;'>
- <tbody>
- <tr>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Username</strong></th>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Rank</strong></th>";
- if ($ign != "") { echo "<th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>$ign</strong></th>"; }
- echo "<th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong><a href='pages.php?pageid=15&id=$link&sort=joindate$sortlink'>Join Date</a></strong></th>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong><a href='pages.php?pageid=15&id=$link&sort=lastactive$sortlink'>Last Active</a></strong></th>";
- echo "</tr>";
- $total = 0;
- $rownum = 0;
- foreach ($mainusers as $userinfo) {
- //Define Variables //
- $username = $userinfo['username'];
- $userid = $userinfo['userid'];
- // get field if there is one //
- if ($field != "") { $userign = $userinfo[$field]; }
- $groupid = $userinfo['usergroupid'];
- $userrank = $userinfo['title'];
- $opentag = $userinfo['opentag'];
- $userjoin = new DateTime(date("Y-m-d", $userinfo['joindate']));
- $userjoin = $userjoin->format('m-d-Y');
- $useractive = new DateTime(date("Y-m-d", $userinfo['lastactivity']));
- $useractive = $useractive->format('m-d-Y');
- $added = "";
- if ($username != NULL) {
- if ($mia == false) {
- if (!in_array($groupid, $nonactive)) {
- $rownum ++;
- if ($rownum & 1) {
- $added = "style='background-color: #1e1e1e;'";
- }
- echo "<tr $added>
- <td style='border:none; border-collapse:collapse;' class='blockrow'><a href='member.php?u=$userid'>" . $opentag . $username . "</span></a></td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userrank . "</td>";
- if ($field != "") { echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userign . "</td>"; }
- echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userjoin . "</td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $useractive . "</td>
- </tr>";
- $total += 1;
- }
- } else {
- if ($groupid == 21) {
- $rownum ++;
- if ($rownum & 1) {
- $added = "style='background-color: #1e1e1e;'";
- }
- echo "<tr $added>
- <td style='border:none; border-collapse:collapse;' class='blockrow'><a href='member.php?u=$userid'>" . $opentag . $username . "</span></a></td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userrank . "</td>";
- if ($field != "") { echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userign . "</td>"; }
- echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userjoin . "</td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $useractive . "</td>
- </tr>";
- $total += 1;
- }
- }
- }
- }
- echo "<tr><td colspan='$numfields' style='border:none; border-collapse:collapse;' class='blocksubhead'>Total Main Members: $total</td></tr></table></div><br/><br/>";
- if ($mia == false) {
- if ($maingame != "Other Game") {
- echo "<div class='blockhead'><h4>$maingame - Other Game Members</h4></div>
- <div class='blockbody'>
- <table width='100%'>
- <tbody>
- <tr>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Username</strong></th>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Rank</strong></th>";
- if ($ign != "") { echo "<th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>$ign</strong></th>"; }
- echo "<th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Join Date</strong></th>
- <th width='$colwidth' style='border:none; border-collapse:collapse;' class='blocksubhead'><strong>Last Active</strong></th>
- </tr>";
- $total = 0;
- $rownum = 0;
- foreach ($otherusers as $userinfo) {
- //Define Variables //
- $username = $userinfo['username'];
- $userid = $userinfo['userid'];
- // get field if there is one //
- if ($field != "") { $userign = $userinfo[$field]; }
- $groupid = $userinfo['usergroupid'];
- $userrank = $userinfo['title'];
- $opentag = $userinfo['opentag'];
- $userjoin = new DateTime(date("Y-m-d", $userinfo['joindate']));
- $userjoin = $userjoin->format('m-d-Y');
- $useractive = new DateTime(date("Y-m-d", $userinfo['lastactivity']));
- $useractive = $useractive->format('m-d-Y');
- $added = "";
- if ($username != NULL) {
- if (!in_array($groupid, $nonactive)) {
- $rownum ++;
- if ($rownum & 1) {
- $added = "style='background-color: #1e1e1e;'";
- }
- echo "<tr $added>
- <td style='border:none; border-collapse:collapse;' class='blockrow'><a href='member.php?u=$userid'>" . $opentag . $username . "</span></a></td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userrank . "</td>";
- if ($field != "") { echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userign . "</td>"; }
- echo "<td style='border:none; border-collapse:collapse;' class='blockrow'>" . $userjoin . "</td>
- <td style='border:none; border-collapse:collapse;' class='blockrow'>" . $useractive . "</td>
- </tr>";
- $total += 1;
- }
- }
- }
- echo "<tr><td colspan='$numfields' class='blocksubhead'>Total Other Members: $total</td></tr></table></div><br/><br/>";
- }
- }
- echo "</div>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement