1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| if (!empty($op_events['show_wars'])) {
$tables = 'wars war INNER JOIN {pre}_clans cl ON war.clans_id = cl.clans_id';
$tables .= ' INNER JOIN {pre}_squads sqd ON war.squads_id = sqd.squads_id';
$select = 'war.wars_date AS events_time, war.wars_id AS wars_id, cl.clans_name AS clans_name, sqd.squads_name AS squads_name';
$where = 'war.wars_date >= \'' . $unix . '\' AND war.wars_date <= \'' . $max . '\'';
$cs_events2 = cs_sql_select(__FILE__,$tables,$select,$where,'wars_date ASC',0,0);
$count_events2 = count($cs_events2);
for ($run = 0; $run < $count_events2; $run++) {
$cs_events2[$run]['events_name'] = $cs_events2[$run]['squads_name'] . ' gegen ' . $cs_events2[$run]['clans_name'];
}
$cs_events = !is_array($cs_events) ? array() : $cs_events;
$cs_events2 = !is_array($cs_events2) ? array() : $cs_events2;
$cs_events = array_merge($cs_events, $cs_events2);
} |