Changeset 178 for trunk/global.php

Timestamp:

Mar 24, 2009, 9:00:06 PM (16 years ago)

Author:

george

Message:

• Opraveno: Zobrazování stavu účetních operací pro subjekty namísto uživatelů.

File:

• trunk/global.php (modified) (1 diff)

trunk/global.php

@@ -190 +190 @@
   global $Database;
   
-  $DbResult = $Database->query('SELECT Id FROM User WHERE (SELECT user FROM hosts WHERE IP="'.$IP.'") = User.Id');
-  $DbRow = $DbResult->fetch_assoc();
-  return($DbRow['Id']);
+  $DbResult = $Database->query('SELECT Id FROM Member WHERE (SELECT user FROM hosts WHERE IP="'.$IP.'") = Member.Id');
+  if($DbResult->num_rows > 0)
+  {
+    $DbRow = $DbResult->fetch_assoc();  
+    return($DbRow['Id']);
+  } else return('');
 }