Changeset 70 for trunk/userlist.php
- Timestamp:
- Feb 6, 2009, 9:20:10 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/userlist.php
r67 r70 30 30 echo('<tr><th><a href="?Order=user&Desc='.$desc.'">Jméno</a></th> 31 31 <th><a href="?Order=NumberTranslate&Desc='.$desc.'" title="Počet přeložených textů">Přeložených</a></th> 32 <th><a href="?Order=Vote&Desc='.$desc.'" title="Průměrná známka textů">Hodnocení</a></th>33 32 <th><a href="?Order=GM&Desc='.$desc.'">Oprávnění</a></th> 34 33 <th><a href="?Order=LastLogin&Desc='.$desc.'">Poslední připojení</a></th></tr>'); … … 38 37 if($Group['TablePrefix'] != '') 39 38 $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)) + '; 40 $Query .= '0) as NumberTranslate, ('; 41 foreach($TranslationTree as $Group) 42 if($Group['TablePrefix'] != '') 43 $Query .= 'IFNULL((SELECT sum(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)), 0) + '; 44 $Query .= '0) / ('; 45 foreach($TranslationTree as $Group) 46 if($Group['TablePrefix'] != '') 47 $Query .= '(SELECT count(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)) + '; 48 $Query .= '0) AS Vote FROM `user` ORDER BY '.$order.' '.$desc.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']; 39 $Query .= '0) as NumberTranslate FROM `user` ORDER BY '.$order.' '.$desc.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']; 49 40 $ID = $Database->SQLCommand($Query); 50 41 while($Line = mysql_fetch_array($ID)) … … 56 47 echo('<tr><td>'.$Name.'</td> 57 48 <td style="text-align: center;">'.$Line['NumberTranslate'].'</td> 58 <td style="text-align: center;">'.substr($Line['Vote'], 0, 4).'</td>59 49 <td>'.$Moderators[$Line['GM']].'</td> 60 50 <td>'.$Line['LastLogin'].'</td></tr>');
Note:
See TracChangeset
for help on using the changeset viewer.