Changeset 220 for quests/priorite.php

Timestamp:

Jan 13, 2008, 11:25:19 AM (17 years ago)

Author:

maron

Message:

Různé opravy

File:

• quests/priorite.php (modified) (3 diffs)

quests/priorite.php

@@ -5 +5 @@
   $Database->SQLCommand("TRUNCATE TABLE `quests`.quests_status");
 
-  //plnìní entry
+/*  //plnìní entry
   $ID = $Database->SQLCommand("SELECT entry FROM `quests`.`quests` WHERE Language = 0");
   while ($Line = mysql_fetch_array($ID)) {
@@ -14 +14 @@
   }
      
-  echo 'Nahrávání ID questù hotovo<br />';  
+  echo 'Nahrávání ID questù hotovo<br />
+  ';  
+*/  
+  //Plnìní poètu
+  $ID = $Database->SQLCommand("SELECT DISTINCT(quest) as QuestEntry, COUNT(*) as QuestCount FROM `".$Config['Database']['DatabaseCharacters']."`.`character_queststatus` GROUP BY quest");
+  while ($Line = mysql_fetch_array($ID)) {
+    echo 'Poèet Q pro '.$Line['QuestEntry'].'/11558 hotov <br />
+    ';
+    $Database->SQLCommand("INSERT INTO `quests`.`quests_status` ( `QuestEntry`, `CountQuest`) VALUES ( '".$Line['QuestEntry']."','".$Line['QuestCount']."')");
+ //   echo 'Poèet Q pro '.$QuestEntry.'/11558 hotov <br />
+  }
+
+  echo 'Nahrávání poètu questù od ú¾ivatelù<br />
   
+  ';
   //mazání pøelo¾ených Q
   $ID = $Database->SQLCommand("SELECT entry FROM `quests`.`quests` WHERE Language <> 0 AND Complete = 1");
@@ -25 +38 @@
   }
   
-  echo 'Mazání pøelo¾ených ve statusu hotovo<br />';  
+  echo 'Mazání pøelo¾ených ve statusu hotovo<br />
+  ';  
   
-  //Plnìní poètu
-  $ID = $Database->SQLCommand("SELECT QuestEntry FROM `quests_status`");
-  while ($Line = mysql_fetch_array($ID)) {
-  $QuestEntry = $Line['QuestEntry'];
-//  echo "UPDATE `quests_status` SET CountQuest = (SELECT Count(quest) FROM `".$Config['Database']['DatabaseCharacters']."`.`character_queststatus` WHERE quest = '$QuestEntry')";
-    $Database->SQLCommand("UPDATE `quests_status` SET CountQuest = 
-    (SELECT Count(quest) FROM `".$Config['Database']['DatabaseCharacters']."`.`character_queststatus` WHERE quest = '$QuestEntry')
-     WHERE QuestEntry = '$QuestEntry'");
-  }
-
-  echo 'Nahrávání poètu questù od ú¾ivatelù<br />';