Changeset 357 for trunk/includes/global.php

Timestamp:

Mar 5, 2010, 7:42:00 AM (15 years ago)

Author:

george

Message:

• Upraveno: Definice typů logovacích záznamů přesunuta do databáze do tabulky LogType. Doplněny konstanty začínající LOG_TYPE_ pro přehlednější používaní v kódu.
• Přidáno: Odkaz a stránka zobrazení všech aktualit.

File:

• trunk/includes/global.php (modified) (6 diffs)

trunk/includes/global.php

@@ -41 +41 @@
   global $Database, $Config;
   
-  echo('<strong><a href="'.$Config['Web']['BaseURL'].'action.php?action=ShoutBoxView">Shoutbox:</a></strong>');
+  echo('<strong><a href="'.$Config['Web']['BaseURL'].'action.php?action=ShoutBoxView">Kecátko:</a></strong>');
   if(Licence(LICENCE_USER)) echo(' <a href="'.$Config['Web']['BaseURL'].'action.php?action=shoutbox">Vložit</a>');
   echo('<div class="box"><table>');
@@ -189 +189 @@
   
   echo('Online překladatelé:<br />');
-  $ID = $Database->SQLCommand('SELECT user, GM, ID FROM `user` WHERE LastLogin >= Now() - 300 AND ((LastLogout < LastLogin) OR (ISNULL(LastLogout)))');
+  $ID = $Database->SQLCommand('SELECT `user`, `GM`, `ID` FROM `user` WHERE `LastLogin` >= NOW() - 300 AND ((`LastLogout` < `LastLogin`) OR (ISNULL(`LastLogout`)))');
   while ($Line = mysql_fetch_assoc($ID))
   {
@@ -215 +215 @@
     $_SESSION['Pass'] = $_POST['LoginPass'];
 
-    $DbResult = $Database->SQLCommand('SELECT * FROM user WHERE LOWER(user) = LOWER("'.$_SESSION['User'].'") AND pass = sha1(CONCAT(sha1("'.$_SESSION['Pass'].'"), Salt))');
+    $DbResult = $Database->SQLCommand('SELECT * FROM `user` WHERE LOWER(`user`) = LOWER("'.$_SESSION['User'].'") AND `pass` = sha1(CONCAT(sha1("'.$_SESSION['Pass'].'"), `Salt`))');
     if(mysql_num_rows($DbResult) == 0)
     {
@@ -227 +227 @@
       $_SESSION['UserID'] = $User['ID']; 
       $_SESSION['User'] = $User['user'];
-      WriteLog('Login: '.$_SESSION['User'], 3);
+      WriteLog('Login: '.$_SESSION['User'], LOG_TYPE_USER);
     }
   }
@@ -234 +234 @@
   if(array_key_exists('Logout', $_GET) and ($_SESSION['User'] != ''))  
   {
-    WriteLog('Odhlášení', 3);
+    WriteLog('Odhlášení', LOG_TYPE_USER);
     if(is_numeric($_SESSION['UserID']))
-      $Database->SQLCommand('UPDATE user SET LastLogout = NOW() WHERE ID = '.$_SESSION['UserID']);
+      $Database->SQLCommand('UPDATE `user` SET `LastLogout` = NOW() WHERE `ID` = '.$_SESSION['UserID']);
     $_SESSION['User'] = '';
     $_SESSION['Pass'] = '';
@@ -243 +243 @@
 
   // Záznam o aktivitě
-  if(Licence(0) and array_key_exists('REMOTE_ADDR', $_SERVER)) 
-    $Database->SQLCommand('UPDATE user SET LastIP = "'.$_SERVER['REMOTE_ADDR'].'", LastLogin = NOW() WHERE ID = '.$_SESSION['UserID']);
+  if(Licence(LICENCE_USER) and array_key_exists('REMOTE_ADDR', $_SERVER)) 
+    $Database->SQLCommand('UPDATE `user` SET `LastIP` = "'.$_SERVER['REMOTE_ADDR'].'", `LastLogin` = NOW() WHERE `ID` = '.$_SESSION['UserID']);
 }