Conditions | 3 |
Paths | 4 |
Total Lines | 24 |
Code Lines | 14 |
Lines | 0 |
Ratio | 0 % |
Changes | 1 | ||
Bugs | 0 | Features | 0 |
1 | <?php |
||
18 | function ali_relations($ally_from, $ally_to = 0) { |
||
19 | $ally_to = intval($ally_to); |
||
20 | $ally_to = $ally_to ? " AND alliance_diplomacy_contr_ally_id = {$ally_to}" : ''; |
||
21 | |||
22 | $temp_array = array(); |
||
23 | $query = doquery( |
||
24 | "SELECT b.* |
||
25 | FROM |
||
26 | {{alliance_diplomacy}} AS b, |
||
27 | (SELECT alliance_diplomacy_contr_ally_id, MAX(alliance_diplomacy_time) AS alliance_diplomacy_time |
||
28 | FROM {{alliance_diplomacy}} |
||
29 | WHERE alliance_diplomacy_ally_id = {$ally_from} {$ally_to} |
||
30 | GROUP BY alliance_diplomacy_ally_id, alliance_diplomacy_contr_ally_id |
||
31 | ) AS m |
||
32 | WHERE b.alliance_diplomacy_contr_ally_id = m.alliance_diplomacy_contr_ally_id |
||
33 | AND b.alliance_diplomacy_time = m.alliance_diplomacy_time AND b.alliance_diplomacy_ally_id = {$ally_from} |
||
34 | ORDER BY alliance_diplomacy_time, alliance_diplomacy_id;" |
||
35 | ); |
||
36 | |||
37 | while ($record = db_fetch($query)) { |
||
38 | $temp_array[$record['alliance_diplomacy_contr_ally_id']] = $record; |
||
39 | } |
||
40 | |||
41 | return $temp_array; |
||
42 | } |
||
49 |