Changeset 48


Ignore:
Timestamp:
Jun 20, 2009, 1:46:49 PM (15 years ago)
Author:
george
Message:
  • Upraveno: Změna typu databáze z MyISAM na InnoDB a doplnění cizích klíčů.
  • Přidáno: Zobrazení počtu databází ve stavu systému.
Location:
trunk/www
Files:
1 added
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/www/index.php

    r47 r48  
    6565    $ServerStatus = $Server->GetState();
    6666    $Form->Values['Realmlist'] = $Config['Web']['Host'].':'.$Form->Values['NetworkPortRealmd'];
    67     unset($Form->Values['NetworkPortRealmd']);
     67    unset($Form->Definition['Items']['NetworkPortRealmd']);
    6868    $Form->Values['Uptime'] = $this->System->AddPrefixMultipliers($ServerStatus['Uptime'], '', 4, 'Time');
    6969    $Form->Values['UsedMemory'] = $this->System->AddPrefixMultipliers($ServerStatus['UsedMemory'] * 1024, 'B', 4, 'Binary');
     
    815815        '<tr><td>Počet emulátorů</td><td>'.$State['EmulatorCount'].'</td></tr>'.
    816816        '<tr><td>Počet uživatelů</td><td>'.$State['UserCount'].'</td></tr>'.
     817        '<tr><td>Počet databází</td><td>'.$State['DatabaseCount'].'</td></tr>'.
    817818        '<tr><td>Počet záloh</td><td>'.$State['BackupCount'].'</td></tr>'.
    818819        '<tr><td>Čekajících/všech úloh ve frontě</td><td>'.$State['TaskQueued'].' / '.$State['TaskCount'].'</td></tr>'.
  • trunk/www/platform.php

    r38 r48  
    5050    $State['MemoryTotal'] = $this->MemoryTotal();
    5151    $State['Uptime'] = $this->SystemUptime();
    52     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server');
     52    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Server`');
    5353    $DbRow = $DbResult->fetch_row();
    5454    $State['ServerCount'] = $DbRow[0];
    55     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE Online = 1');
     55    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Server` WHERE `Online` = 1');
    5656    $DbRow = $DbResult->fetch_row();
    5757    $State['ServerOnlineCount'] = $DbRow[0];
    58     $DbResult = $this->Database->query('SELECT COUNT(*) FROM User');
     58    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `User`');
    5959    $DbRow = $DbResult->fetch_row();
    6060    $State['UserCount'] = $DbRow[0];
    61     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Emulator');
     61    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Emulator`');
    6262    $DbRow = $DbResult->fetch_row();
    6363    $State['EmulatorCount'] = $DbRow[0];
    64     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Backup');
     64    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Backup`');
    6565    $DbRow = $DbResult->fetch_row();
    6666    $State['BackupCount'] = $DbRow[0];
    67     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Task');
     67    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Task`');
    6868    $DbRow = $DbResult->fetch_row();
    6969    $State['TaskCount'] = $DbRow[0];
    70     $DbResult = $this->Database->query('SELECT COUNT(*) FROM Task WHERE State != 2');
     70    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Database`');
     71    $DbRow = $DbResult->fetch_row();
     72    $State['DatabaseCount'] = $DbRow[0];
     73    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Task` WHERE `State` != 2');
    7174    $DbRow = $DbResult->fetch_row();
    7275    $State['TaskQueued'] = $DbRow[0];
  • trunk/www/server.php

    r46 r48  
    162162      $State['CharacterCount'] = 0;
    163163      $State['AccountCount'] = 0;
     164      $State['Uptime'] = 0;
    164165    }
    165166    $State['UsedMemory'] = $this->GetUsedMemory();
Note: See TracChangeset for help on using the changeset viewer.