Changeset 249 for quests/export.php

Timestamp:

Jan 19, 2008, 10:51:11 PM (17 years ago)

Author:

maron

Message:

Ve vyhledávání pouze uživatelé, kteří mají questy, vyhledávání podle ID questu

File:

• quests/export.php (modified) (1 diff)

quests/export.php

@@ -196 +196 @@
 <?php
 // multiple="multiple"
-    $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
+    $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
+          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) ORDER BY user");
       while ($Line = mysql_fetch_array($ID))
         echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';