Changeset 289 for trunk/img_statistic.php

Timestamp:

Dec 23, 2009, 9:03:16 AM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazení obrázku statistiky dokončení překladové skupiny pro neexistujícího uživatele.
• Opraveno: Používat absolutní cestu pro obrázky šipek řezení tabulek.

File:

• trunk/img_statistic.php (modified) (1 diff)

trunk/img_statistic.php

@@ -10 +10 @@
 if(array_key_exists('team', $_GET)) 
 {
-  $team = ' AND `User` IN (SELECT `ID` FROM `user` WHERE `team` = '.$_GET['team'].')';
+  $team = ' AND `User` IN (SELECT `ID` FROM `user` WHERE `team` = '.($_GET['team'] * 1).')';
 } else $team = '';
+
 if(array_key_exists('language', $_GET)) 
 {
   $language = ' AND `Language` = '.$_GET['language'].'';
 } else $language = '';
+
 if(array_key_exists('user', $_GET)) 
 {
-  $DbResult = $Database->SQLCommand('SELECT `user`,`ExportSetting` FROM `user` WHERE ID='.$_GET['user']);
-  $User = mysql_fetch_assoc($DbResult);
-  $ExportSetting = unserialize($User['ExportSetting']);
-  $SelectedUsers = ''; 
-  foreach($ExportSetting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-  $user_sql = ' AND `User` IN ('.$SelectedUsers.')';
+  $DbResult = $Database->SQLCommand('SELECT `user`,`ExportSetting` FROM `user` WHERE ID='.($_GET['user'] * 1));
+  if(mysql_num_rows($DbResult) > 0)
+  {
+    $User = mysql_fetch_assoc($DbResult);
+    $ExportSetting = unserialize($User['ExportSetting']);
+    $SelectedUsers = ''; 
+    foreach($ExportSetting['users-selection'] as $Item)
+      $SelectedUsers .= ','.$Item;
+    $SelectedUsers = substr($SelectedUsers, 1);
+    $user_sql = ' AND `User` IN ('.$SelectedUsers.')';
+  } else $user_sql = '';
 } else $user_sql = '';
+
 
 $ID = mysql_fetch_row($Database->SQLCommand('SELECT MAX(`VersionEnd`) FROM '.$Group['TablePrefix']));