Changeset 365 for trunk/download.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/download.php (modified) (6 diffs)

trunk/download.php

@@ -13 +13 @@
   $Group = $TranslationTree[$TableID];
 
-  $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE (Language <> 0) AND (Complete = 1) AND User IN('.$Users.')'));
+  $ID = mysql_fetch_row($Database->SQLCommand('SELECT COUNT(DISTINCT(`Entry`)) FROM '.$Group['TablePrefix'].' WHERE (`Language` <> 0) AND (`Complete` = 1) AND `User` IN('.$Users.')'));
   $NumberTranslate = $ID[0];
   
-  $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Group['TablePrefix'].' WHERE (Language = 0)'));
+  $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Language` = 0)'));
   $NumberAJ = $ID[0];
 
@@ -28 +28 @@
 }
 
-  if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
+  /*
+   if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
     if (array_key_exists('verse', $_POST)) { //ukládání
-        $Database->SQLCommand('INSERT INTO `verseclient` (`verse` ,`date` ,`text` ,`user`)
+        $Database->SQLCommand('INSERT INTO `verseclient` (`verse` ,`date` ,`text` ,`User`)
                   VALUES ( "'.$_POST['verse'].'", NOW( ) , "'.$_POST['text'].'", "'.$_SESSION['UserID'].'");');
       WriteLog('Nová verze ('.$_POST['verse'].') češtiny pro clienta uložena.', LOG_TYPE_MODERATOR);
@@ -37 +38 @@
       'Verze: <input type="text" name="verse" /> <input type="submit" value="Uložit" /><br />'.
       'Popis: <textarea rows="20" cols="60" name="text">');
-      $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT ExportSetting FROM user Where ID = '.$_SESSION['UserID']));
+      $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT `ExportSetting` FROM `User` WHERE `ID` = '.$_SESSION['UserID']));
       $ExportSetting = unserialize($Line['ExportSetting']);     
        
@@ -44 +45 @@
       foreach($ExportSetting['groups'] as $Index) $Tables .= GetPercentOfTable($Index,implode(',', $ExportSetting['users-selection']));
       
-      $ID = $Database->SQLCommand('SELECT user FROM user WHERE ID IN('.implode(',', $ExportSetting['users-selection']).')'); 
+      $ID = $Database->SQLCommand('SELECT `Name` FROM `User` WHERE `ID` IN('.implode(',', $ExportSetting['users-selection']).')'); 
       $Users = 'Vyexportovány překlady od uživatelů: ( '; 
-      while($Line = mysql_fetch_assoc($ID)) $Users .= $Line['user'].', '; $Users .= ' )';
+      while($User = mysql_fetch_assoc($ID)) $Users .= $User['Name'].', '; $Users .= ' )';
       //Výpis
       echo ('
@@ -55 +56 @@
     }
   }
+  */
 
 if(array_key_exists('addon', $_GET)) 
@@ -60 +62 @@
   echo('<br />Stažený soubor pouze rozbalte a zkopírujte do kořenové složky wow (C:\Program Files\World Of Warcraft\). Hru spouštějte přes soubor WoWME.exe <br /><br />'.
   '<table  class="BaseTable"><tr><th>Verze/datum</th><th>Popis</th></tr>');
-  $ID = $Database->SQLCommand('SELECT * FROM verseclient ORDER BY DATE DESC');
+  $ID = $Database->SQLCommand('SELECT * FROM `verseclient` ORDER BY `Date` DESC');
   while($Line = mysql_fetch_assoc($ID)) 
   {