Changeset 54

Timestamp:

Feb 2, 2009, 7:38:10 PM (16 years ago)

Author:

george

Message:

• Opraveno: Dokončené překlady se jevily jako rozepsané i při dokončení.

Location:

trunk

Files:

• TranslationList.php (modified) (3 diffs)
• form.php (modified) (3 diffs)
• index.php (modified) (1 diff)
• save.php (modified) (2 diffs)

trunk/TranslationList.php

@@ -200 +200 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
     <a title="Nedokončené texty" href="?group='.$GroupId.'&amp;action=mydevelop">Rozepsané překlady</a><br /><br />');
-  WriteQuests('SELECT * FROM '.$Table.' Where user = '.$_SESSION['UserID'].' AND complete = 0', '', 'mydevelop');
+  WriteQuests('SELECT * FROM '.$Table.' Where user = '.$_SESSION['UserID'].' AND Complete = 0', '', 'mydevelop');
 }
       
@@ -243 +243 @@
     OR `Vote` LIKE "%'.$Search.'%"
     OR `User` LIKE "%'.$Search.'%"
-    OR `complete` LIKE "%'.$Search.'%"';
+    OR `Complete` LIKE "%'.$Search.'%"';
   foreach($TranslationTree[$GroupId]['Items'] as $Item)
   {
@@ -324 +324 @@
                                                 
   echo('</table>');
-  //  WriteQuests("SELECT * FROM quests Where user = ".$_SESSION['UserID']." AND complete = '0'", '', 'mydevelop');
+  //  WriteQuests("SELECT * FROM quests Where user = ".$_SESSION['UserID']." AND Complete = '0'", '', 'mydevelop');
 }
       

trunk/form.php

@@ -11 +11 @@
   $TextID = $_GET['ID'];  
 
-  $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
+  $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
   if(!$Line) die('Překlad nenalezen.');
     
-  $LineAJ = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE Language = 0  AND entry = '.$Line['entry']));
+  $LineAJ = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE Language = 0  AND entry = '.$Line['entry']));
   if(!$Line) die('Anglický originál k překladu nenalezen.');
   
@@ -25 +25 @@
   if(($Line['Take'] <> 0) and ($Line['Take'] <> $Line['ID'])) 
   {
-    $Language = mysql_fetch_array($Database->SQLCommand('SELECT Language FROM '.$Table.' Where ID = '.$Line['Take']));
+    $Language = mysql_fetch_assoc($Database->SQLCommand('SELECT Language FROM '.$Table.' Where ID = '.$Line['Take']));
     // echo $Language['Language'].'  '.$Line['Take'];
     if($Language['Language'] <> 0)
@@ -33 +33 @@
   if($Line['Language'] <> 0) 
   {
-    if($Line['complete'] == 1) echo(' <b>Hotov</b><br />');
+    if($Line['Complete'] == 1) echo(' <b>Hotov</b><br />');
       else echo(' <b> Uložen v rozepsaných</b><br />');
   } else 

trunk/index.php

@@ -50 +50 @@
 /*
     $UserID = $_SESSION['UserID'];
-    $ID = $Database->SQLCommand("SELECT COUNT(*) FROM quests WHERE User='$UserID' AND complete = 0");
+    $ID = $Database->SQLCommand("SELECT COUNT(*) FROM quests WHERE User='$UserID' AND Complete = 0");
     $Line = mysql_fetch_array($ID);        
     if($Line[0] > 0) 

trunk/save.php

@@ -32 +32 @@
   if(!$Line) 
   {
-        $Columns = '`entry`, `Language` , `User` , `complete` , `Take` , `Vote` , `CountVote`';
+        $Columns = '`entry`, `Language` , `User` , `Complete` , `Take` , `Vote` , `CountVote`';
         $Values = $entry.','.$Language.','.$UserID.','.$complete.','.$TextID.', 3 ,1';
         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
@@ -46 +46 @@
   } else 
   {
-    $sql = 'UPDATE '.$Table.' SET `complete` = '.$complete;
+    $sql = 'UPDATE '.$Table.' SET `Complete` = '.$complete;
         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
           $sql .= ', `'.$GroupItem['Column'].'`="'.@$_POST[$GroupItem['Column']].'"';