1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
| 1. / 2. / ...
<?php
$cs_lang = cs_translate('wars');
$select = 'war.games_id AS games_id, cln.clans_short AS clans_short, war.wars_score1 AS ';
$select .= 'wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id';
$from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id ';
$from .= 'INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id';
$order = 'wars_date DESC';
$cs_wars = cs_sql_select(__FILE__,$from,$select,"war.wars_status = 'played'",$order,0,4);
if (!empty($cs_wars)) {
for ($i = 0; $i < 4; $i++) {
$data = array();
if (!empty($cs_wars[$i]['wars_id'])) {
$cs_wars[$i]['game_icon'] = file_exists('uploads/games/' . $cs_wars[$i]['games_id'] . '.gif') ?
cs_html_img('uploads/games/' . $cs_wars[$i]['games_id'] . '.gif') : '';
// ab hier
$enemy = strlen($cs_wars[$i]['clans_short']) <= 12 ? $cs_wars[$i]['clans_short'] :
substr($cs_wars[$i]['clans_short'],0,12) . '...';
$enemy = cs_secure($enemy);
$fullenemy = cs_secure($cs_wars[$i]['clans_short']);
$cs_wars[$i]['enemy'] = cs_link($enemy,'wars','view','id=' . $cs_wars[$i]['wars_id'],0,$fullenemy);
// ende
$cs_wars[$i]['wars_score1'] = !empty($cs_wars[$i]['wars_score1']) ? $cs_wars[$i]['wars_score1'] : 0;
$cs_wars[$i]['wars_score2'] = !empty($cs_wars[$i]['wars_score2']) ? $cs_wars[$i]['wars_score2'] : 0;
$result = $cs_wars[$i]['wars_score1'] - $cs_wars[$i]['wars_score2'];
$result >= 1 ? $icon = 'green' : $icon = 'red';
if(empty($result)) {
$icon = 'grey';
}
$cs_wars[$i]['icon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');
}
}
$data['wars'] = $cs_wars;
echo cs_subtemplate(__FILE__,$data,'wars','navlist');
} else {
echo $cs_lang['no_data'];
}
?> |