Changeset 215

Timestamp:

Jan 12, 2008, 3:37:31 PM (17 years ago)

Author:

maron

Message:

Nejdůležitější Q a ochrana AJ Q

Location:

quests

Files:

• ListQuests.php (modified) (2 diffs)
• includes/global.php (modified) (2 diffs)
• save.php (modified) (1 diff)

quests/ListQuests.php

@@ -61 +61 @@
     }
 
-        if(array_key_exists('selection', $_GET)) {
-    
+        if(array_key_exists('selection', $_GET)) {              
+                
+                echo '<br /><b>Prioritnì by jste mìli pøekládat tyto questy:</b><br />';
+                
+          $ID = $Database->SQLCommand("SELECT * FROM `quests_status` ORDER BY CountQuest DESC");
+          echo '<table border="1" cellpadding="2" cellspacing="0">
+              <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>Poèet splnìní na serveru</th></tr>';
+          $i = 0;
+          while ($Line = mysql_fetch_array($ID)) {
+            if ($i < '6') {
+            $LineTranslate = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language <> 0 AND entry = '".$Line['QuestEntry']."'"));
+            if (!$LineTranslate) {
+              $LineAJQuest = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language = 0 AND entry = '".$Line['QuestEntry']."'"));
+              echo '<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
+              <td>'.$LineAJQuest['entry'].'</td>
+              <td>'.$LineAJQuest['Title'].'</td>
+              <td>'.$Line['CountQuest'].'</td></tr>';
+              $i = $i +1;
+              }
+            }
+          }
+                
+          echo '</table><br />';
+          
+          echo '<b>Ostatní:</b><br /><br />';
+
           for ($i=0; $i<30; ++$i) {
             $limity = 200;
@@ -70 +94 @@
           }
                 echo '<a href="ListQuests.php?limitx='.$limitx.'&amp;limity=6000">Zbytek</a><br />';
+
+
     //  echo '<a href="ListQuests.php?limitx=3500&amp;limity=4000">3500-4000</a><br />';
         }

quests/includes/global.php

@@ -8 +8 @@
 $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
 $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
-$Database->SelectDatabase('quests');    
+$Database->SelectDatabase($Config['Database']['Database']);    
 
 //pøihlá¹ení
@@ -95 +95 @@
       <br />
       <a href="ListQuests.php?selection">Nepøelo¾ené questy</a><br />
-      <a href="ListQuests.php?Translate">Pøelo¾ené questy</a><br />
-      <a href="ListQuests.php?mydevelop">Rozepsané questy</a><br />
-      <a href="ListQuests.php?my">Moje questy</a><br />
-      <br />
+      <a href="ListQuests.php?Translate">Pøelo¾ené questy</a><br />';
+
+  if (Licence(0)) {
+      echo '<a href="ListQuests.php?mydevelop">Rozepsané questy</a><br />
+      <a href="ListQuests.php?my">Moje questy</a><br />';
+  }
+      echo '<br />
       <a href="http://wow.zdechov.net/forum/viewforum.php?f=22">Forum projektu</a><br />
       <a href="http://wow.zdechov.net/">Web serveru</a><br /><br />

quests/save.php

@@ -51 +51 @@
        OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText',
        EndText = '$EndText', ObjectiveText1 = '$ObjectiveText1', ObjectiveText2 = '$ObjectiveText2',
-       ObjectiveText3 = '$ObjectiveText3', ObjectiveText4 = '$ObjectiveText4', Language = '$Language' WHERE  user='$UserID' AND entry = '$entry'";
+       ObjectiveText3 = '$ObjectiveText3', ObjectiveText4 = '$ObjectiveText4', Language = '$Language'
+        WHERE  user='$UserID' AND entry = '$entry' AND Language <> 0";
       $Database->SQLCommand($sql);
     //  echo $sql.'<br />';