<th>Hk's</th> <th>Level</th> </tr> <?php if ($GLOBALS['playersOnline']['moduleResults'] > 0) { $count = mysql_result($count, 0); if ($count > 10) { $count = $count - 10; } $rand = rand(1, $count); $result = mysql_query("SELECT guid, name, totalKills, level, race, class, gender, account FROM characters WHERE name!='' \r\n\t\t\t\t\t\t\t\tAND online=1 LIMIT " . $rand . "," . $GLOBALS['playersOnline']['moduleResults']); } else { $result = mysql_query("SELECT guid, name, totalKills, level, race, class, gender, account FROM characters WHERE name!='' \r\n\t\t\t\t\t\t\t\t AND online=1"); } while ($row = mysql_fetch_assoc($result)) { connect::connectToRealmDB($rid); $getGuild = mysql_query("SELECT guildid FROM guild_member WHERE guid='" . $row['guid'] . "'"); if (mysql_num_rows($getGuild) == 0) { $guild = "None"; } else { $g = mysql_fetch_assoc($getGuild); $getGName = mysql_query("SELECT name FROM guild WHERE guildid='" . $g['guildid'] . "'"); $x = mysql_fetch_assoc($getGName); $guild = '< ' . $x['name'] . ' >'; } if ($GLOBALS['playersOnline']['display_GMS'] == false) { //Check if GM. connect::selectDB('logondb'); $checkGM = mysql_query("SELECT COUNT(*) FROM account_access WHERE id='" . $row['account'] . "' AND gmlevel >0"); if (mysql_result($checkGM, 0) == 0) { echo '<tr style="text-align: center;">
public static function getAccountIDFromCharId($char_id, $realm_id) { $char_id = (int) $char_id; $realm_id = (int) $realm_id; connect::selectDB('webdb'); connect::connectToRealmDB($realm_id); $result = mysql_query("SELECT account FROM characters WHERE guid='" . $char_id . "'"); $row = mysql_fetch_assoc($result); return $row['account']; }
public static function serverStatus($realm_id) { //Get status $fp = fsockopen($GLOBALS['realms'][$realm_id]['host'], $GLOBALS['realms'][$realm_id]['port'], $errno, $errstr, 1); if (!$fp) { echo $status = '<h4 class="realm_status_title_offline">' . $GLOBALS['realms'][$realm_id]['name'] . ' - Offline</h4>'; } else { echo $status = '<h4 class="realm_status_title_online">' . $GLOBALS['realms'][$realm_id]['name'] . ' - Online</h4>'; echo '<span class="realm_status_text">'; /* Players online bar */ if ($GLOBALS['serverStatus']['factionBar'] == TRUE) { connect::connectToRealmDB($realm_id); $getChars = mysql_query("SELECT COUNT(online) FROM characters WHERE online=1"); $total_online = mysql_result($getChars, 0); $getAlliance = mysql_query("SELECT COUNT(online) FROM characters WHERE online=1 AND race IN('3','4','7','11','1','22')"); $alliance = mysql_result($getAlliance, 0); $getHorde = mysql_query("SELECT COUNT(online) FROM characters WHERE online=1 AND race IN('2','5','6','8','10','9')"); $horde = mysql_result($getHorde, 0); if ($total_online == 0) { $per_alliance = 50; $per_horde = 50; } else { if ($alliance == 0) { $per_alliance = 0; } else { $per_alliance = round($alliance / $total_online * 100); } if ($horde == 0) { $per_horde = 0; } else { $per_horde = round($horde / $total_online * 100); } } if ($per_alliance + $per_horde > 100) { $per_horde = $per_horde - 1; } ?> <div class='srv_status_po'> <div class='srv_status_po_alliance' style="width: <?php echo $per_alliance; ?> %;"></div> <div class='srv_status_po_horde' style="width: <?php echo $per_horde; ?> %;"></div> <div class='srv_status_text'>Alliance: <?php echo $alliance; ?> Horde: <?php echo $horde; ?> </div> </div> <?php } echo '<table width="100%"><tr>'; //Get players online if ($GLOBALS['serverStatus']['playersOnline'] == TRUE) { connect::connectToRealmDB($realm_id); $getChars = mysql_query("SELECT COUNT(online) FROM characters WHERE online=1"); $pOnline = mysql_result($getChars, 0); echo '<td> <b>', $pOnline, '</b> Players online </td>'; } //Get uptime if ($GLOBALS['serverStatus']['uptime'] == TRUE) { connect::selectDB('logondb'); $getUp = mysql_query("SELECT starttime FROM uptime WHERE realmid='" . $realm_id . "' ORDER BY starttime DESC LIMIT 1"); $row = mysql_fetch_assoc($getUp); $time = time(); $uptime = $time - $row['starttime']; echo ' <td> <b>' . convTime($uptime) . '</b> uptime </td> </tr>'; } } if ($GLOBALS['serverStatus']['nextArenaFlush'] == TRUE) { //Arena flush connect::connectToRealmDB($realm_id); $getFlush = mysql_query("SELECT value FROM worldstates WHERE comment='NextArenaPointDistributionTime'"); $row = mysql_fetch_assoc($getFlush); $flush = date('d M H:i', $row['value']); echo '<tr> <td> Next arena flush: <b>' . $flush . '</b> </td>'; } echo '</tr> </table> </span>'; }
public static function getCharName($id, $realm_id) { $id = (int) $id; connect::connectToRealmDB($realm_id); $result = mysql_query("SELECT name FROM characters WHERE guid='" . $id . "'"); $row = mysql_fetch_assoc($result); return $row['name']; }
echo $GLOBALS['service'][$service]['price'] . ' ' . website::convertCurrency($GLOBALS['service'][$service]['currency']); ?> </span> <?php if ($GLOBALS['service'][$service]['currency'] == "vp") { echo "<span class='currency'>Vote Points: " . account::loadVP($_SESSION['cw_user']) . "</span>"; } elseif ($GLOBALS['service'][$service]['currency'] == "dp") { echo "<span class='currency'>" . $GLOBALS['donation']['coins_name'] . ": " . account::loadDP($_SESSION['cw_user']) . "</span>"; } } account::isNotLoggedIn(); connect::selectDB('webdb'); $result = mysql_query("SELECT name FROM realms WHERE id='" . $realm_id . "'"); $row = mysql_fetch_assoc($result); $realm = $row['name']; connect::connectToRealmDB($realm_id); $result = mysql_query("SELECT name,guid,gender,class,race,level,online FROM characters WHERE guid='" . $guid . "'"); $row = mysql_fetch_assoc($result); ?> <h4>Selected character:</h4> <div class='charBox'> <table width="100%"> <tr> <td width="73"> <?php if (!file_exists('styles/global/images/portraits/' . $row['gender'] . '-' . $row['race'] . '-' . $row['class'] . '.gif')) { echo '<img src="styles/' . $GLOBALS['template']['path'] . '/images/unknown.png" />'; } else { ?> <img src="styles/global/images/portraits/<?php echo $row['gender'] . '-' . $row['race'] . '-' . $row['class'];