Changeset 251 for quests

Timestamp:

Jan 20, 2008, 8:44:37 PM (17 years ago)

Author:

maron

Message:

NPC_text

Location:

quests

Files:

• export.php (modified) (9 diffs)
• form.php (modified) (1 diff)
• includes/global.php (modified) (3 diffs)
• includes/global_function.php (modified) (2 diffs)
• npc_action.php (added)
• npc_form.php (added)
• npc_list.php (added)
• npc_save.php (added)
• npc_statistic.php (added)
• quests_statistic.php (modified) (1 diff)
• save.php (modified) (3 diffs)
• statistic.php (modified) (3 diffs)
• structure/npc_text.sql (added)
• structure/npc_vote.sql (added)

quests/export.php

@@ -23 +23 @@
     $Vote = $_POST['Vote'];
     $users = @$_POST['users'];
-    
-
-      $AddDetails = @$_POST['AddDetails'];
-      $AddObjectives = @$_POST['AddObjectives'];
-      $AddOfferRewardText = @$_POST['AddOfferRewardText'];
-      $AddRequestItemsText = @$_POST['AddRequestItemsText'];
-      $AddEndText = @$_POST['AddEndText'];
-      $AddObjectiveText1 = @$_POST['AddObjectiveText1'];        
-      $AddObjectiveText2 = @$_POST['AddObjectiveText2'];        
-      $AddObjectiveText3 = @$_POST['AddObjectiveText3'];        
-      $AddObjectiveText4 = @$_POST['AddObjectiveText4'];        
-
-      if (($Export == 'Mangos') and (Licence(2) == False)) {die('Nemáte oprávnìní');}
-    
-    
-    $Buffer = '
+
+    $BufferHeader = '
 /*  File made by maron web aplikacion 
     =================================
@@ -44 +30 @@
     WebProject: http://wow.zdechov.net/quests/
     email: maron2@cetrum.cz 
-    DateExport: '.date("m.d.y  H:i").'   */
+    DateExport: '.date("m.d.y  H:i").'
+    Diakritika: '.$Diacritical.'
+    Poèet nutných hlasù: '.$NumberVote.'
+    Známka vy¾¹í jak: '.$Vote.'
+    Tabluky: Quests: '.@$_POST['Quests'].' , NPC_text: '.@$_POST['NPC_texts'].'   */
     
     ';
     
-    if (isset($Use)) $Buffer .= 'USE `mangos`;
+    if (isset($Use)) $BufferHeader .= 'USE `mangos`;
     
     ';
 
-    $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
+
     $WhereLang = '';
     if (isset($CZ)) $WhereLang .= " Language = '1'";
@@ -76 +66 @@
         $WhereUsers .= " User = ".$users[$i];
     endfor;    
+
+    
+    if (array_key_exists('Quests', $_POST)) {
+      $AddDetails = @$_POST['AddDetails'];
+      $AddObjectives = @$_POST['AddObjectives'];
+      $AddOfferRewardText = @$_POST['AddOfferRewardText'];
+      $AddRequestItemsText = @$_POST['AddRequestItemsText'];
+      $AddEndText = @$_POST['AddEndText'];
+      $AddObjectiveText1 = @$_POST['AddObjectiveText1'];        
+      $AddObjectiveText2 = @$_POST['AddObjectiveText2'];        
+      $AddObjectiveText3 = @$_POST['AddObjectiveText3'];        
+      $AddObjectiveText4 = @$_POST['AddObjectiveText4'];        
+
+      if (($Export == 'Mangos') and (Licence(2) == False)) {die('Nemáte oprávnìní');}
+    
+    
+    $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
     
     if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
@@ -82 +89 @@
    // echo $sql;
 
-
+    $i = 0;
     $ID = $Database->SQLCommand($sql." ORDER BY vote");
     while ($Line = mysql_fetch_array($ID)) {
@@ -127 +134 @@
     if ($Diacritical == False) $sql=WithOutDiacritical($sql);
     
-    if ($Export == 'Mangos') {     
-      $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
-      $Database->SQLCommand($sql);
-    }  
-    $Buffer .= $sql." 
-    ";
-    
+    $Buffer[$i] = $sql;
+    ++$i;
+    
+  }
   }  
   
+  //export npc_textù
+  $x = 0;
+  if (array_key_exists('NPC_texts', $_POST)) {
+    
+    $sql = "SELECT * FROM NPC_text WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
+    
+    if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
+    if ($WhereUsers <> '') $sql .=  "AND ($WhereUsers)";
+
+    $ID = $Database->SQLCommand($sql." ORDER BY vote");
+    while ($Line = mysql_fetch_array($ID)) {
+    
+      $sql = "UPDATE npc_text SET ";
+      for ($i=0; $i<count($npc_text); ++$i) {
+        if ($Line[$npc_text[$i]] <> '')
+          $sql .= " ".$npc_text[$i]." = '".$Line[$npc_text[$i]]."' , ";
+      }
+      $sql .= " ID = '".$Line['entry']."' WHERE ID = ".$Line['entry'];
+      if ($Diacritical == False) $sql=WithOutDiacritical($sql);
+      
+    $BufferNPC[$x] = $sql;
+    ++$x;
+    }
+  }  
+  
+  //vypisování
   if ($Export == 'Display') {
     echo 'Vygenerovaný SQL kód: <br /><textarea rows="30" cols="100">';
-    echo $Buffer;
+      echo $BufferHeader;
+      for ($i=0; $i<count(@$Buffer); ++$i) {
+        echo $Buffer[$i].'
+        ';
+      }
+      for ($i=0; $i<count(@$BufferNPC); ++$i) {
+        echo $BufferNPC[$i].'
+        ';
+      }
     echo '</textarea>';
   }
-  if ($Export == 'Mangos') {
-    echo 'Hotovo';
-  }
+
+  if ($Export == 'Mangos') {     
+    $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
+      for ($i=0; $i<count(@$Buffer); ++$i) {
+        $Database->SQLCommand($Buffer[$i]);
+      }
+      for ($i=0; $i<count(@$BufferNPC); ++$i) {
+        $Database->SQLCommand($BufferNPC[$i]);
+      }
+  }  
   
   if ($Export == 'Zip') {
@@ -149 +194 @@
         $save_filename = 'SqlTranslate.zip';
         $SQL_filename = 'SqlTranslate.sql';
-          
+        
+        $BufferZip = $BufferHeader;
+        for ($i=0; $i<count(@$Buffer); ++$i) {
+          $BufferZip .= $Buffer[$i];
+        }
+        for ($i=0; $i<count(@$BufferNPC); ++$i) {
+          $BufferZip .= $BufferNPC[$i];
+        }
+
+        $Buffer  = $BufferZip;
+        
         $zipfile = new zipfile();
         $zipfile -> addFile($Buffer, $SQL_filename);
@@ -188 +243 @@
         <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br> 
         <br /> 
+        <input type="checkbox" name="Quests" checked="true"> Questy <br> 
+        <input type="checkbox" name="NPC_texts" checked="true"> NPC_texts <br> 
       </td><td>
         &nbsp; <input type="text" name="NumberVote" value="3" size="1"> Poèet nutných hlasù <br>                                                               
@@ -197 +254 @@
 // multiple="multiple"
     $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
-          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) ORDER BY user");
+          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) OR 
+          EXISTS(SELECT 1 FROM npc_text WHERE user = user.ID) ORDER BY user");
       while ($Line = mysql_fetch_array($ID))
         echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
@@ -225 +283 @@
       </td></tr>
     </table>
-    <br><input type="submit" value="Generovat SQL soubor Questù"> (Sta¾ení)
+    <br><input type="submit" value="Generovat SQL soubor pøekladu"> (Sta¾ení)
   </form>  
   <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />

quests/form.php

@@ -80 +80 @@
         <td width="300">Anglický</td>
         <td>
-          Pøekládám do: <?php 
+          Pøelo¾eno do: <?php 
           if ($Line['Language'] <> 0) 
               $Language = $Line['Language']; 

quests/includes/global.php

@@ -26 +26 @@
   <script type="text/javascript" language="JavaScript">
   <!--
-    var Open = ""
-    var Closed = ""
-
     function show(what){
       what.style.display=\'\';
@@ -39 +36 @@
   
   ';
-
-
-// SQL injection hack protection
-foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
-foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
 
   
@@ -89 +81 @@
         echo '<a Title="Registrace u¾ivatele pro pøekládání" href="registrace.php" style="color: red">Registrace</a><br />';
 
-      echo '<br /><div style="background-color: #ffff66" onMouseMove="show(menu2outline)" onmouseout="hide(menu2outline)"><a Title="Pøekládání questù" 
-       href="ListQuests.php?filter">Questy</a></div>
+      //questy rolovací menu
+      echo '<br /><div style="background-color: #ffff66" onMouseMove="show(menu2outline)" onmouseout="hide(menu2outline)">
+      <a href="ListQuests.php?filter">Questy</a></div>       
        
-       
-       <div style="position: absolute; left: 70; top: 165; 
-        display:none; width: 200; font-family: Verdana;font-size: 13px; background-color: #ffff66;
-        border: 2px dotted black;       padding: 5px 5px 5px 5px;"
-        id="menu2outline" onMouseMove="show(menu2outline)" onmouseout="hide(menu2outline)">
-        &nbsp;<a Title="Zde mù¾ete zaèít pøekládat" href="ListQuests.php?selection">Nepøelo¾ené questy</a><br>
-        &nbsp;<a Title="Pøelo¾ené questy, mù¾ete zde hlasovat, nebo opravovat Quest" href="ListQuests.php?Translate">Pøelo¾ené questy</a><br>
+       <div id="menu2outline" style="position: absolute; left: 100; top: 170; display:none; width: 200; background-color: #ffff66; border: 2px dotted black;    padding: 5px 5px 5px 5px;" onMouseMove="show(menu2outline)" onmouseout="hide(menu2outline)">
+        &nbsp;<a href="ListQuests.php?selection">Nepøelo¾ené questy</a><br>
+        &nbsp;<a href="ListQuests.php?Translate">Pøelo¾ené questy</a><br>
         ';
         if  (Licence(0)) {
-          echo '&nbsp;<a Title="Nedokonèené questy" href="ListQuests.php?mydevelop">Rozepsané questy</a><br />
-          &nbsp;<a Title="Pøelo¾ené questy pøilá¹eného u¾ivatele" href="ListQuests.php?my">Moje questy</a><br />
-          &nbsp;<a Title="Zatím neznámkované questy" href="ListQuests.php?notvote">Neznámkované questy</a><br />';
+          echo '&nbsp;<a href="ListQuests.php?mydevelop">Rozepsané questy</a><br>
+          &nbsp;<a href="ListQuests.php?my">Moje questy</a><br>
+          &nbsp;<a href="ListQuests.php?notvote">Neznámkované questy</a><br>';
         }
-        echo '&nbsp;<a Title="Zobrazit questy podle vlastního fitru" href="ListQuests.php?filter">Filtr questù ...</a><br>';
+        echo '&nbsp;<a href="ListQuests.php?filter">Filtr questù ...</a><br>';
+      echo '</div>';
+      
+      //npc rolovací menu
+      echo '<br /><div style="background-color: #ffff66" onMouseMove="show(npc_menu)" onmouseout="hide(npc_menu)">
+      <a href="npc_list.php?filter">NPC_texty</a></div>       
+       
+       <div id="npc_menu" style="position: absolute; left: 100; top: 213; display:none; width: 200; background-color: #ffff66; border: 2px dotted black;        padding: 0px 5px 5px 5px;" onMouseMove="show(npc_menu)" onmouseout="hide(npc_menu)">
+        &nbsp;<a href="npc_list.php?notran">Nepøelo¾ené npc_text</a><br>
+        &nbsp;<a href="npc_list.php?Translate">Pøelo¾ené npc_text</a><br>
+        ';
+  /*      if  (Licence(0)) {
+          echo '&nbsp;<a href="npc_list.php?mydevelop">Rozepsané npc_text</a><br>
+          &nbsp;<a href="npc_list.php?my">Moje npc_text</a><br>
+          &nbsp;<a href="npc_list.php?notvote">Neznámkované npc_text</a><br>';
+        }   */
+        echo '&nbsp;<a href="npc_list.php?filter">Filtr npc_text ...</a><br>';
       echo '</div>
       

quests/includes/global_function.php

@@ -63 +63 @@
   array('4','Moderátor', 'red', 'Pøihlá¹ení u¾ivatelù'),
   array('5','Hlasování', 'yellowgreen', 'Pøihlá¹ení u¾ivatelù'),
+  array('6','Npc_text', 'tomato', 'Operace s NPC_texty'),
 );
 
@@ -81 +82 @@
   } // END function Log
 
+$npc_text = array(
+  '0' => 'text0_0',
+  '1' => 'text0_1',
+  '2' => 'text1_0',
+  '3' => 'text1_1',
+  '4' => 'text2_0',
+  '5' => 'text2_1',
+  '6' => 'text3_0',
+  '7' => 'text3_1',
+  '8' => 'text4_0',
+  '9' => 'text4_1',
+  '10' => 'text5_0',
+  '11' => 'text5_1',
+  '12' => 'text6_0',
+  '13' => 'text6_1',
+  '14' => 'text7_0',
+  '15' => 'text7_1',
+);
+
 ?>

quests/quests_statistic.php

@@ -28 +28 @@
   imagefilledrectangle($obrazek,0,0,$PercentBar,59,$Color2);
   imagestring($obrazek, 10, 120, 15, $NumberTranslate.'/'.$NumberAJQuests, $Color3);
+  imagestring($obrazek, 3, 300, 15, 'Questy', $Color3);
   imagestring($obrazek, 10, 120, 30, $Percent.' %', $Color3);
   imagestring($obrazek, 1, 240, 50, 'Aktualizováno: '.date("m.d.y  H:i"), $Color3);

quests/save.php

@@ -2 +2 @@
 
   include('includes/global.php');
+
+  // SQL injection hack protection
+  foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
+  foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
 
   if (array_key_exists('entry', $_POST)) {
@@ -39 +43 @@
     if (!$Line) {
     
-      $Database->SQLCommand("INSERT INTO `quests` (`entry` , `Title` , `Details` , `Objectives` , `OfferRewardText` , `RequestItemsText` , `EndText` , `ObjectiveText1` , `ObjectiveText2` , `ObjectiveText3` , `ObjectiveText4` , `Language` , `User` , `complete` , `Take` )
-      VALUES('$entry','$Title','$Details','$Objectives','$OfferRewardText','$RequestItemsText','$EndText','$ObjectiveText1','$ObjectiveText2','$ObjectiveText3','$ObjectiveText4','$Language','$UserID','$complete','$QuestID')");
+      $Database->SQLCommand("INSERT INTO `quests` (`entry` , `Title` , `Details` , `Objectives` , `OfferRewardText` , `RequestItemsText` ,
+      `EndText` , `ObjectiveText1` , `ObjectiveText2` , `ObjectiveText3` , `ObjectiveText4` , `Language` , `User` , `complete` , `Take` , `Vote` , `CountVote` )
+      VALUES('$entry','$Title','$Details','$Objectives','$OfferRewardText','$RequestItemsText','$EndText','$ObjectiveText1',
+      '$ObjectiveText2','$ObjectiveText3','$ObjectiveText4','$Language','$UserID','$complete','$QuestID','3','1')");
       echo 'Quest: '.$entry.' ulo¾en!<br />';
-      WriteLog('Quest: '.$entry.' ulo¾en! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
+      WriteLog('Quest: '.$entry.' uloµen! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
     } else {
       $sql = "UPDATE quests SET complete = '$complete', Title = '$Title',
@@ -54 +60 @@
     //  echo $sql.'<br />';      
       echo 'Zmìny v Questu: '.$entry.' ulo¾eny!<br />';
-      WriteLog('Zmìny v Questu: '.$entry.' ulo¾eny! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
+      WriteLog('Zmìny v Questu: '.$entry.' uloµeny! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
       $Database->SQLCommand("DELETE FROM `quests_vote` WHERE `quests_vote`.`IDquest` = ".$QuestID);
     }
     
-    echo 'Pøekládat: <a href="ListQuests.php?selection">Nepøeloµené</a> ';
+    echo 'Pøekládat: <a href="ListQuests.php?selection">Nepøeloœené</a> ';
       
   }

quests/statistic.php

@@ -5 +5 @@
 ?>
 
-<b>Statistika pøelo¾ených questù:</b><br>
+<b>Statistika:</b><br>
  <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù"><br />
+<br />
+ <img alt="npc_text" src="npc_statistic.php" title="statistika pøekladu NPC_textù"><br />
 <br />
 <b>Statistika v závislosti na èase: </b><a href="http://game-server.zdechov.net/statistic/?Measure=18">Pøelo¾ených textù</a><br>
@@ -33 +35 @@
 
   echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
-  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
-  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Známka</a></th>
+  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøel. Q.</a></th>
+  <th><a href="statistic.php?order=NumberTranslateNPC&amp;desc='.$desc.'" Title="Poèet pøelo¾ených NPC_textù">Pøel. N.</a></th>
+  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Z. Q</a></th>
+  <th><a href="statistic.php?order=voteNPC&amp;desc='.$desc.'" Title="Prùmìrná známka NPC_text">Z. N.</a></th>
   <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
   <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
@@ -40 +44 @@
   $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
   (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
-  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote
+  (SELECT count(*) FROM `npc_text` WHERE User = user.id AND User <> 0) as NumberTranslateNPC,
+  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote,
+  (SELECT avg(Vote) FROM `npc_text` WHERE User = user.id AND Complete = 1) as voteNPC
    FROM `user` ORDER BY $order $desc");
       while ($Line = mysql_fetch_array($ID))
         echo '<tr><td>'.$Line['user'].'</td>
         <td>'.$Line['NumberTranslate'].'</td>
+        <td>'.$Line['NumberTranslateNPC'].'</td>
         <td>'.substr($Line['vote'], 0, 4).'</td>
+        <td>'.substr($Line['voteNPC'], 0, 4).'</td>
         <td>'.$Moderators[$Line['GM']].'</td>
         <td>'.$Line['LastLogin'].'</td></tr>';