Changeset 683 for trunk/pages/realmlist.php
- Timestamp:
- Jan 23, 2010, 5:23:04 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
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 {
Note:
See TracChangeset
for help on using the changeset viewer.