-
Notifications
You must be signed in to change notification settings - Fork 1
/
defence-report.php
104 lines (90 loc) · 2.26 KB
/
defence-report.php
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<?
include("config.php");
updatecookie();
include("languages/$lang");
$title=$l_sdf_title;
include("header.php");
connectdb();
if(checklogin())
{
die();
}
$res = $db->Execute("SELECT * FROM $dbtables[players] WHERE email='$username'");
$playerinfo = $res->fields;
$query = "SELECT * FROM $dbtables[sector_defence] WHERE player_id=$playerinfo[player_id]";
if(!empty($sort))
{
$query .= " ORDER BY";
if($sort == "quantity")
{
$query .= " quantity ASC";
}
elseif($sort == "mode")
{
$query .= " fm_setting ASC";
}
elseif($sort == "type")
{
$query .= " defence_type ASC";
}
else
{
$query .= " sector_id ASC";
}
}
$res = $db->Execute($query);
bigtitle();
$i = 0;
if($res)
{
while(!$res->EOF)
{
$sector[$i] = $res->fields;
$i++;
$res->MoveNext();
}
}
$num_sectors = $i;
if($num_sectors < 1)
{
echo "<BR>$l_sdf_none";
}
else
{
echo "$l_pr_clicktosort<BR><BR>";
echo "<TABLE WIDTH=\"100%\" BORDER=0 CELLSPACING=0 CELLPADDING=2>";
echo "<TR BGCOLOR=\"$color_header\">";
echo "<TD><B><A HREF=defence-report.php?sort=sector>$l_sector</A></B></TD>";
echo "<TD><B><A HREF=defence-report.php?sort=quantity>$l_qty</A></B></TD>";
echo "<TD><B><A HREF=defence-report.php?sort=type>$l_sdf_type</A></B></TD>";
echo "<TD><B><A HREF=defence-report.php?sort=mode>$l_sdf_mode</A></B></TD>";
echo "</TR>";
$color = $color_line1;
for($i=0; $i<$num_sectors; $i++) {
echo "<TR BGCOLOR=\"$color\">";
echo "<TD><A HREF=rsmove.php?engage=1&destination=". $sector[$i][sector_id] . ">". $sector[$i][sector_id] ."</A></TD>";
echo "<TD>" . NUMBER($sector[$i]['quantity']) . "</TD>";
$defence_type = $sector[$i]['defence_type'] == 'F' ? $l_fighters : $l_mines;
echo "<TD> $defence_type </TD>";
$mode = $sector[$i]['defence_type'] == 'F' ? $sector[$i]['fm_setting'] : $l_n_a;
//if($mode == 'attack')
// $mode = $l_md_attack;
//else
// $mode = $l_md_toll;
echo "<TD> $mode </TD>";
echo "</TR>";
if($color == $color_line1)
{
$color = $color_line2;
}
else
{
$color = $color_line1;
}
}
echo "</TABLE>";
}
echo "<BR><BR>";
TEXT_GOTOMAIN();
include("footer.php");
?>