Changeset 70 for trunk/user.php
- Timestamp:
- Feb 6, 2009, 9:20:10 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/user.php
r67 r70 31 31 if($Group['TablePrefix'] != '') 32 32 $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND User <> 0 AND Complete = 1) + '; 33 $Query .= '0) as NumberTranslate, ('; 34 foreach($TranslationTree as $Group) 35 if($Group['TablePrefix'] != '') 36 $Query .= 'IFNULL((SELECT sum(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND Complete = 1), 0) + '; 37 $Query .= '0) / ('; 38 foreach($TranslationTree as $Group) 39 if($Group['TablePrefix'] != '') 40 $Query .= '(SELECT count(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND Complete = 1) +'; 41 $Query .= '0) AS Vote FROM `user` WHERE ID = '.$_GET['user']; 33 $Query .= '0) as NumberTranslate, FROM `user` WHERE ID = '.$_GET['user']; 42 34 $LineUser = mysql_fetch_array($Database->SQLCommand($Query)); 43 35 … … 48 40 echo('Poslední IP: <b>'.$LineUser['LastIP'].'</b><br />'); 49 41 echo('Počet přeložených: <b>'.$LineUser['NumberTranslate'].'</b><br />'); 50 echo('Průměrná známka: <b>'.$LineUser['Vote'].'</b><br />');51 42 echo('Email: <b>'.$LineUser['Email'].'</b><br />'); 52 43 echo('<br />
Note:
See TracChangeset
for help on using the changeset viewer.