Changeset 683
- Timestamp:
- Jan 23, 2010, 5:23:04 PM (15 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/inc/realm.php
r681 r683 11 11 parent::__construct($System); 12 12 $this->Id = $Id; 13 $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Id='.$Id );13 $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Id='.$Id.' AND Enabled=1'); 14 14 $this->Data = $DbResult->fetch_assoc(); 15 15 $this->CharactersDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseCharacters']); -
trunk/inc/server.php
r681 r683 13 13 parent::__construct($System); 14 14 $this->Id = $Id; 15 $DbResult = $this->Database->query('SELECT * FROM Logon WHERE Id='.$Id );15 $DbResult = $this->Database->query('SELECT * FROM Logon WHERE Id='.$Id.' AND Enabled=1' ); 16 16 $this->Data = $DbResult->fetch_assoc(); 17 17 $this->ServerDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseRealmd']); … … 53 53 { 54 54 $TotalCount = 0; 55 $DbResult = $this->Database->query('SELECT Id FROM Realm ');55 $DbResult = $this->Database->query('SELECT Id FROM Realm WHERE Enabled=1'); 56 56 while($DbRow = $DbResult->fetch_assoc()) 57 57 { … … 71 71 { 72 72 $TotalCount = 0; 73 $DbResult = $this->Database->query('SELECT Id FROM Realm ');73 $DbResult = $this->Database->query('SELECT Id FROM Realm WHERE Enabled=1'); 74 74 while($DbRow = $DbResult->fetch_assoc()) 75 75 { … … 372 372 { 373 373 $Output = ''; 374 $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm ');374 $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm WHERE Enabled=1'); 375 375 $DbRow = $DbResult->fetch_row(); 376 376 $RealmCount = $DbRow[0]; -
trunk/inc/update_state.php
r682 r683 13 13 // Check logon servers 14 14 $System = new System($Config); 15 $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host ');15 $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host AND Logon.Enabled=1'); 16 16 while($Logon = $DbResult->fetch_assoc()) 17 17 { … … 23 23 24 24 // Check realms 25 $DbResult = $System->Database->query('SELECT Realm.Id, Host.Address, Realm.Port FROM Realm JOIN Host ON Host.Id=Realm.Host ');25 $DbResult = $System->Database->query('SELECT Realm.Id, Host.Address, Realm.Port FROM Realm JOIN Host ON Host.Id=Realm.Host AND Realm.Enabled=1'); 26 26 while($Realm = $DbResult->fetch_assoc()) 27 27 { -
trunk/pages/gmteam.php
r682 r683 55 55 56 56 $Output .= ShowGMList(array('Id' => 0, 'Name' => 'Všechny světy')); 57 $DbResult = $System->Database->query('SELECT * FROM Realm ');57 $DbResult = $System->Database->query('SELECT * FROM Realm WHERE Enabled=1'); 58 58 while($Realm = $DbResult->fetch_assoc()) 59 59 { -
trunk/pages/realmlist.php
r681 r683 3 3 if(array_key_exists('Server', $_GET)) 4 4 { 5 $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host WHERE Logon.Id='.$_GET['Server'] );5 $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host WHERE Logon.Id='.$_GET['Server'].' AND Logon.Enabled=1'); 6 6 if($DbResult->num_rows > 0) 7 7 { … … 15 15 $Output = '<h2 align="center">Seznam světů</h2>'; 16 16 17 $DbResult = $System->Database->query('SELECT Logon. Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host');17 $DbResult = $System->Database->query('SELECT Logon.Name, Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host WHERE Logon.Enabled=1'); 18 18 while($DbRow = $DbResult->fetch_assoc()) 19 19 { 20 20 $Server = new Server($System, $DbRow['Id']); 21 $Output .= '<div style="text-align: center"> Realmlist<a href="?page=realmlist&Server='.$DbRow['Id'].'">'.$DbRow['Address'];21 $Output .= '<div style="text-align: center">'.$DbRow['Name'].' <a href="?page=realmlist&Server='.$DbRow['Id'].'">'.$DbRow['Address']; 22 22 if($DbRow['Port'] != 3724) $Output .= ':'.$DbRow['Port']; 23 23 $Output .= '</a></div>'; … … 31 31 '</tr>'; 32 32 33 $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' ORDER BY Name');33 $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name'); 34 34 while($DbRow = $DbResult2->fetch_assoc()) 35 35 { -
trunk/pages/server.php
r682 r683 1 1 <?php 2 2 3 $DbResult = $System->Database->query('SELECT COUNT(*) FROM Realm ');3 $DbResult = $System->Database->query('SELECT COUNT(*) FROM Realm WHERE Enabled=1'); 4 4 $DbRow = $DbResult->fetch_row(); 5 5 $RealmCount = $DbRow[0]; 6 7 // Check servers online state. 8 $DbResult = $System->Database->query('SELECT COUNT(*) FROM Logon WHERE Online = 1 AND Enabled=1'); 9 $DbRow = $DbResult->fetch_row(); 10 $OnlineState = $DbRow[0] > 0; // Report online state if one of all servers is online. 6 11 7 12 $Output = '<h3 class="PageTitle">Server Heroes of Fantasy</h3>'. … … 12 17 <tr> 13 18 <td>Přihlašovací server je</td> 14 <td>'.$server->OnlineStateImage($ System->NetworkPortState($Config['Web']['WoWServerAddr'], 3724)).'</td>19 <td>'.$server->OnlineStateImage($OnlineState).'</td> 15 20 </tr> 16 21 <tr>
Note:
See TracChangeset
for help on using the changeset viewer.