public static function loadVotingLinks() { connect::selectDB('webdb'); $result = mysql_query("SELECT * FROM votingsites ORDER BY id DESC"); if (mysql_num_rows($result) == 0) { buildError("Couldnt fetch any voting links from the database. " . mysql_error()); } else { while ($row = mysql_fetch_assoc($result)) { ?> <div class='votelink'> <table width="100%"> <tr> <td width="20%"><img src="<?php echo $row['image']; ?> " /></td> <td width="50%"><strong><?php echo $row['title']; ?> </strong> (<?php echo $row['points']; ?> Vote Points)<td> <td width="40%"> <?php if (website::checkIfVoted($row['id']) == FALSE) { ?> <input type='submit' value='Vote' onclick="vote('<?php echo $row['id']; ?> ',this)"> <?php } else { $getNext = mysql_query("SELECT next_vote FROM " . $GLOBALS['connection']['webdb'] . ".votelog\n\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE userid='" . account::getAccountID($_SESSION['cw_user']) . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t AND siteid='" . $row['id'] . "' ORDER BY id DESC LIMIT 1"); $row = mysql_fetch_assoc($getNext); $time = $row['next_vote'] - time(); echo 'Time until reset: ' . convTime($time); } ?> </td> </tr> </table> </div> <?php } } }
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>'; }