Changeset 365 for trunk/includes/global_function.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (15 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

• trunk/includes/global_function.php (modified) (3 diffs)

trunk/includes/global_function.php

@@ -223 +223 @@
     // $User = $_SESSION['User'];
     $Pass = $_SESSION['Pass'];
-    $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM user WHERE ID = '.$_SESSION['UserID'].' AND GM >= '.$Licence.' AND pass = sha1(CONCAT(sha1("'.$Pass.'"), Salt))'));
+    $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID'].' AND `GM` >= '.$Licence.' AND `Pass` = sha1(CONCAT(sha1("'.$Pass.'"), `Salt`))'));
     return($Line);
   } else 
@@ -245 +245 @@
   
   $Result = array();
-  $DbResult = $Database->SQLCommand('SELECT * FROM `language` WHERE `Enabled` = 1');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `Language` WHERE `Enabled` = 1');
   while($DbRow = mysql_fetch_assoc($DbResult))
     $Result[$DbRow['Id']] = $DbRow;
@@ -288 +288 @@
 
   $Database->SelectDatabase($Config['Database']['Database']);    
-  $Query = 'INSERT INTO `log` ( `user` , `type` , `text` , `date` , `IP` )
+  $Query = 'INSERT INTO `Log` ( `User` , `Type` , `Text` , `Date` , `IP` )
    VALUES ('.$user.', '.$Type.', "'.addslashes($Text).'", NOW(), "'.$ip.'")';
   $Database->SQLCommand($Query);