source: pages/a_servers.php@ 8

Last change on this file since 8 was 8, checked in by george, 17 years ago

Přidáno: Zaznamenávání a zobrazování údaje o odezevně serverů.
Upraveno: Šablony stránek a použití jazykových proměnných ve větší míře.

File size: 3.3 KB
Line 
1<?php
2$tpl->output['th_players'] = $text['th_players'];
3$tpl->output['servers_h2'] = $text['abroad_servers'];
4$tpl->output['th_players'] = $text['th_players'];
5$tpl->output['th_name'] = $text['name'];
6$tpl->output['th_latency'] = $text['th_latency'];
7$tpl->output['th_version'] = $text['th_version'];
8$tpl->output['th_xp'] = $text['th_xp'];
9$tpl->output['th_online_state'] = $text['th_online_state'];
10$tpl->output['th_type'] = $text['th_type'];
11$tpl->output['th_rating'] = $text['th_rating'];
12$tpl->output['th_recommend'] = $text['th_recommend'];
13$tpl->output['order_by'] = $text['order_by'];
14$tpl->output['place'] = $text['info_place'];
15
16if(!array_key_exists('order', $_GET)) $_GET['order'] = 0;
17$order_index = (int) $_GET['order'];
18switch ($order_index)
19 {
20 case 0: $order = ' order by `name`'; break;
21 case 1: $order = ' order by `rating` desc '; break;
22 case 2: $order = ' order by `version` desc '; break;
23 case 3: $order = ' order by `type` desc '; break;
24 case 4: $order = ' order by `xp` desc '; break;
25 case 5: $order = ' order by `players` desc '; break;
26 case 6: $order = ' order by `online` desc '; break;
27 case 7: $order = ' order by `online` desc,`latency`'; break;
28 }
29$tpl->output['s0'] = '';
30$tpl->output['s1'] = '';
31$tpl->output['s2'] = '';
32$tpl->output['s3'] = '';
33$tpl->output['s4'] = '';
34$tpl->output['s5'] = '';
35$tpl->output['s6'] = '';
36$tpl->output['s7'] = '';
37if (empty($order_index))
38 {
39 $tpl->output['s0'] = 'SELECTED';
40 }
41else
42 {
43 $tpl->output['s'.$order_index] = 'SELECTED';
44 }
45
46$pa = new CleverPager('select `id`,`wss_partner`,LEFT(`name`, 25) as `name`, `place`, `rating_sum`/`ratings` as `rating`, `version`, `type`, `xp`, `online`, `online_players_sum`/`player_checks` as `players`, `latency` from `servers` where `place`=2 '.$order, 'p');
47$pa->PageSize = 20;
48$pa->PageLinksDisplayed = 5;
49$pa->CountCommand = 'select count(*) as Count from `servers` where `place`=2';
50$pa->DataBind();
51$tpl->output['servers_data'] = '';
52while ($row = $pa->GetOne())
53 {
54 switch ($row['xp'])
55 {
56 case 1: $xp = 'Very low'; break;
57 case 2: $xp = 'Low'; break;
58 case 3: $xp = 'Normal'; break;
59 case 4: $xp = 'High'; break;
60 case 5: $xp = 'Very high'; break;
61 }
62 if ($row['place']==1)
63 {
64 $place = $text['reg_czech'];
65 }
66 else
67 {
68 $place = $text['reg_abroad'];
69 }
70 $tpl->output['servers_data'] .= '<tr>';
71 $tpl->output['servers_data'] .= ($row['wss_partner']==1)?'<td><img src="templates/img/hvezda.gif" alt="Doporučujeme" title="Doporučujeme"></td>':'<td></td>';
72 $tpl->output['servers_data'] .='<td align="left">'.ulink('server/'.$row['id'], $row['name']).'</td>';
73 $tpl->output['servers_data'] .='<td>'.round($row['rating'],2).'</td>';
74 $tpl->output['servers_data'] .='<td>'.$row['version'].'</td>';
75 $tpl->output['servers_data'] .='<td>'.$row['type'].'</td>';
76 $tpl->output['servers_data'] .='<td>'.$xp.'</td>';
77 $tpl->output['servers_data'] .='<td>'.(int)$row['players'].'</td>';
78 $tpl->output['servers_data'] .='<td>'.($row['online']).'%</td>';
79 if($row['latency'] == 0) $Latency = '?'; else $Latency = round($row['latency']).'ms';
80 $tpl->output['servers_data'] .='<td>'.$Latency.'</td>';
81 $tpl->output['servers_data'] .='</tr>';
82 }
83ob_start();
84$pa->DrawPager();
85$tpl->output['pager'] = ob_get_contents();
86ob_clean();
87?>
Note: See TracBrowser for help on using the repository browser.