Changeset 30 for branches

Timestamp:

Oct 14, 2008, 7:16:06 PM (16 years ago)

Author:

maron

Message:

Oprava, adresování tabulek, jména online uživatelů

Location:

branches/3

Files:

• class/database.php (modified) (1 diff)
• frontend.php (modified) (2 diffs)

branches/3/class/database.php

@@ -21 +21 @@
     $this->LastQuery = "SELECT ".$What." FROM `".$this->Prefix.$Table."` WHERE ".$Condition; 
     $resul = $this->query($this->LastQuery);
+   // echo $this->error;
     
     $this->LastNumRows = $resul->num_rows;

branches/3/frontend.php

@@ -54 +54 @@
   { // BEGIN function WriteTranslatedGroups
         global $database;
-      $Query = $database->select('translationgroup', '*');
+      $Query = $database->select('TranslationGroup', '*');
       while($DbRow = $Query->fetch_array())
       { 
@@ -70 +70 @@
   { // BEGIN function WriteOnlineUsers
         global $database;
-    $Query = $database->select('useronline', '*,count(*) as count_online_user');
+    $Query = $database->select('UserOnline', '*,count(*) as count_online_user,(SELECT Name FROM User WHERE User.Id = UserOnline.User) as Name');
     if ($database->LastDataSet) {
       echo '<p>'.ONLINE_USERS;
       while($DbRow = $Query->fetch_array())
       { 
-        echo ''.$DbRow['count_online_user'].'';
+        echo ''.$DbRow['Name'].'';
       }
       echo '</p>';