Changeset 404

Timestamp:

Mar 24, 2010, 8:43:02 AM (15 years ago)

Author:

george

Message:

• Opraveno: Chybějící SQL uvozovky ve funkci výpočtu XP překladatelů.

File:

• trunk/img_level.php (modified) (3 diffs)

trunk/img_level.php

@@ -6 +6 @@
 $xp_from_word = 1;
 $index_level = 100;
-$from_diakrit = 3; //zvýšené xp za slovo s diakritikou
+$from_diakrit = 3; // zvýšené xp za slovo s diakritikou
 $FontFile = 'images/FRIZQT__.ttf';
 
-function CheckDiakrit($word)
+function CheckDiakrit($Word)
 {
-  $result = false;
-  $Diakrit = Array("á","č","ď","é","ě","í","ľ","ň","ó","ř","š","ť","ú",
+  $Result = false;
+  $Diakrit = array("á","č","ď","é","ě","í","ľ","ň","ó","ř","š","ť","ú",
   "ů","ý","ž","Á","Č","Ď","É","Ě","Í","Ľ","Ň","Ó","Ř","Š","Ť","Ú","Ů","Ý","Ž");
   for($i = 0; $i < count($Diakrit); $i = $i + 1) 
   {
-    if(strpos($word, $Diakrit[$i]) <> false) 
-    {
-      $result = true;
-    }
+    if(strpos($Word, $Diakrit[$i]) <> false) 
+      $Result = true;
   }
-  return($result);
+  return($Result);
 }
 
@@ -57 +55 @@
 }
 
-function GetXPFromTranslation($user_ID) 
+function GetXPFromTranslation($UserId) 
 {
   global $Database, $TranslationTree, $xp_from_word, $from_diakrit;
+  
   $xp = 0;
-
   foreach($TranslationTree as $Group) 
-  { //překladové skupiny
+  { 
     if($Group['TablePrefix'] != '') 
     {
-      $groupby = 'GROUP BY';
+      $GroupBy = 'GROUP BY ';
       foreach($TranslationTree[$Group['Id']]['Items'] as $Index => $TextItem) 
       {  
-        if($groupby == 'GROUP BY') $groupby .= ' '.$TextItem['Column'];
-          else $groupby .= ', '.$TextItem['Column'];
+         $GroupBy .= '`'.$TextItem['Column'].'`, ';
       } 
-      $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE `User` = '.$user_ID.' AND `Complete` = 1 '.$groupby);
+      $GroupBy = substr($GroupBy, 0, -2);
+      
+      $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE (`User` = '.$UserId.') AND (`Complete` = 1) '.$GroupBy);
       while($Line = mysql_fetch_array($IDtran)) 
-      {   //jednotlivé překlady
-        $LineComparison = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE ID = '.$Line['Take']));
-        $xp_translation = 0;   //mazání posledního
+      {   
+        $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE `ID` = '.$Line['Take']);
+        $LineComparison = mysql_fetch_assoc($DbResult);
+        $xp_translation = 0;   
         $translated = true;
         foreach($TranslationTree[$Group['Id']]['Items'] as $Index => $TextItem) 
-        {          //jednotlivé položky překladu
+        { 
           if(($Line[$TextItem['Column']] <> $LineComparison[$TextItem['Column']]) and (strlen($Line[$TextItem['Column']]) > (strlen($LineComparison[$TextItem['Column']]) * 0.5))) 
-          {  //zda není stejný, zda je aspoň dlouhý jako polovina
-            $TextArr = explode(' ',$Line[$TextItem['Column']]);
-            for ($i = 0; $i < count($TextArr); $i = $i + 1) 
-            {  //pro každé slovo
-              if(CheckDiakrit($TextArr[$i])) $indikator = $from_diakrit;
+          {  
+            $TextArr = explode(' ', $Line[$TextItem['Column']]);
+            foreach($TextArr as $Word) 
+            {  
+              if(CheckDiakrit($Word)) $indikator = $from_diakrit;
                 else $indikator = 1;
               $xp_translation = $xp_translation + ($indikator * $xp_from_word);
@@ -94 +94 @@
           }
         }       
-        if($translated) $xp = $xp + $xp_translation;   //přičítání XP za celý překlad, pokud je celý přeložený
+        if($translated) $xp = $xp + $xp_translation;   // Přičítání XP za celý překlad, pokud je celý přeložený
       }
     }
   }
-  return $xp;
+  return($xp);
 }