Changeset 434
- Timestamp:
- Apr 8, 2010, 10:54:50 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/TranslationList.php
r432 r434 162 162 ' -> <strong>Počty překladů uživatele '.$Line[0].': </strong><br /><br />'); 163 163 164 echo('<table class="BaseTable"><tr><th>Skupina</th><th> Překladů</th></tr>');164 echo('<table class="BaseTable"><tr><th>Skupina</th><th>Rozpracovaných</th><th>Hotových</th></tr>'); 165 165 $Total = 0; 166 $Total2 = 0; 166 167 foreach($TranslationTree as $Group) 167 168 if($Group['TablePrefix'] != '') 168 169 { 169 if(array_key_exists('not', $_GET)) 170 { 171 $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `Complete` = 0 AND `User`='.$_GET['user']; 172 $ID = $Database->SQLCommand($sql); 173 $Line = mysql_fetch_row($ID); 174 $GroupId = $Group['Id']; 175 echo('<tr><td><a href="?group='.$GroupId.'&action=userid&not&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>'); 176 $Total += $Line[0]; 177 } else 178 { 179 $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `User`='.$_GET['user']; 180 $ID = $Database->SQLCommand($sql); 181 $Line = mysql_fetch_row($ID); 182 $GroupId = $Group['Id']; 183 echo('<tr><td><a href="?group='.$GroupId.'&action=userid&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>'); 184 $Total += $Line[0]; 185 } 170 $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 0) AND (`User`='.$_GET['user'].')'; 171 $ID = $Database->SQLCommand($sql); 172 $Line = mysql_fetch_row($ID); 173 $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`User`='.$_GET['user'].')'; 174 $ID = $Database->SQLCommand($sql); 175 $Line2 = mysql_fetch_row($ID); 176 $GroupId = $Group['Id']; 177 echo('<tr><td><a href="?group='.$GroupId.'&action=userid&not&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td><td>'.$Line2[0].'</td></tr>'); 178 $Total += $Line[0]; 179 $Total2 += $Line2[0]; 186 180 } 187 echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td>< /tr>');181 echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.$Total2.'</strong></td></tr>'); 188 182 echo('</table>'); 189 183 }
Note:
See TracChangeset
for help on using the changeset viewer.