/
player_stat.php
144 lines (132 loc) · 5.64 KB
/
player_stat.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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
<?php
require("user.inc.php");
$filename = 'player_stat.php';
$text = $st[985];
if(isset($change_dir) && $change_dir == 1){
$order_dir = "asc";
} else {
$order_dir = "desc";
}
if(!isset($table)){
$table = 1;
}
if ($table == 2) {
$text .= "<a href='$filename'>".$cw['general']."</a> - ".$cw['misc']." - <a href='$filename?table=3'>".$st[986]."</a><br />";
$text .= "<br />".$st[987].":";
$text .= "<br /><a href='$filename?table=2&su=1'>".$cw['signed_up']."</a> - <a href='$filename?table=2&lab=1'>".$cw['last_attack']."</a> - <a href='$filename?table=2&la=1'>".$st[988]."</a> - <a href='$filename?table=2&clan=1'>".$cw['clan']."</a> - <a href='$filename?table=2'>Score</a><br />";
if(isset($su)) {
$sql_order_str = "joined_game";
$order_by_str = $st[989];
} elseif(isset($lab)) {
$sql_order_str = "last_attack_by";
$order_by_str = $st[990];
} elseif(isset($la)) {
$sql_order_str = "last_attack";
$order_by_str = $st[991];
} elseif(isset($clan)) {
$sql_order_str = "clan_id";
$order_by_str = $cw['clan'];
} else {
$sql_order_str = "score";
$order_by_str = $cw['score'];
}
$text .= "<br />".$st[992]." <b>$order_by_str</b>";
$text .= make_table(array($cw['name'],$cw['signed_up'],$cw['last_attack'],$st[988],$cw['clan'],$cw['score']));
db("select login_name,joined_game,last_attack_by,last_attack,clan_sym,score,clan_sym_color,login_id from ${db_name}_users where login_id > 5 order by $sql_order_str $order_dir");
} elseif ($table == 3) {
$text .= "<a href='$filename'>".$cw['general']."</a> - <a href='$filename?table=2'>".$cw['misc']."</a> - ".$st[986]."<br />";
$sql_order_str = 0;
$not_at_zero = 0;
$sql_select_ships = "";
db("select count(*) as count, login_id from ${db_name}_ships where login_id > 5 group by login_id order by count desc");
while($return = dbr(1)){
if($return['count'] < 1){
echo $return['count'];
echo $cw['here'];
break;
}
$sql_select_ships .= "login_id = $return[login_id] || ";
}
if(empty($sql_select_ships)){
print_page($st[986],$st[993]);
} else {
$sql_select_ships = preg_replace("/\|\| $/", "", $sql_select_ships);
}
db("select cash,login_name,fighters_killed,ships_killed,ships_lost,turns_run,score,login_id from ${db_name}_users where ".$sql_select_ships." order by score $order_dir, fighters_killed $order_dir, ships_killed $order_dir,login_name");
$text .= '<br />'.$st[994];
$text .= make_table(array("",$cw['name'],$cw['fighters']."<br />".$cw['killed'],$cw['ships']." <br />".$cw['killed'],$cw['ships']." <br />".$st[995],$cw['turns']." <br />".$st[996],$cw['score']));
} else {
$text .= $cw['general']." - <a href='$filename?table=2'>Divers</a> - <a href='$filename?table=3'>".$st[986]."</a><br />";
if(!isset($dir_array)){
$dir_array = array_fill(1,6,"");
}
if(!isset($change_dir) && isset($gen_tab)){
$dir_array[$gen_tab] = "&change_dir=1";
} elseif(!isset($gen_tab)){
$gen_tab = "6";
}
$text .= "<br />".$st[987].":";
$text .= "<br /><a href=$filename?gen_tab=1".$dir_array[1].">".$cw['login_name']."</a> - <a href=$filename?gen_tab=2".$dir_array[2].">".$st[997]."</a> - <a href=$filename?gen_tab=3".$dir_array[3].">".$cw['ship_kills']."</a> - <a href=$filename?gen_tab=4".$dir_array[4].">".$st[998]."</a> - <a href=$filename?gen_tab=5".$dir_array[5].">".$cw['turns_run']."</a> - <a href=$filename?gen_tab=6".$dir_array[6].">".$cw['score']."<br /></a>";
if(isset($gen_tab) && $gen_tab ==1) {
$sql_order_str = "login_name";
$order_by_str = $cw['login_name'];
} elseif(isset($gen_tab) && $gen_tab ==2) {
$sql_order_str = "fighters_killed";
$order_by_str = $cw['fighters_killed'];
} elseif(isset($gen_tab) && $gen_tab ==3) {
$sql_order_str = "ships_killed";
$order_by_str = $st[999];
} elseif(isset($gen_tab) && $gen_tab ==4) {
$sql_order_str = "ships_lost";
$order_by_str = $st[998];
} elseif(isset($gen_tab) && $gen_tab ==5) {
$sql_order_str = "turns_run";
$order_by_str = $cw['turns_run'];
} else {
$sql_order_str = "score";
$order_by_str = $cw['score'];
}
db("select cash,login_name,fighters_killed,ships_killed,ships_lost,turns_run,score,login_id from ${db_name}_users where login_id > 5 order by $sql_order_str $order_dir");
$text .= "<br />".$st[992]." <b>$order_by_str</b>";
$text .= make_table(array($cw['rank'],$cw['name'],$cw['fighters']."<br />".$cw['killed'],$cw['ships']." <br />".$cw['killed'],$cw['ships']." <br />".$st[995],$cw['turns']." <br />".$st[996],$cw['score']));
}
$text .= '<br />';
$ct1 = 1;
$ct2 = 1;
$last = "";
while($player = dbr(1)) {
if(isset($player[$sql_order_str]) && $player[$sql_order_str] != $last) {
$last = $player[$sql_order_str];
if($ct2 > 1){
$ct1 = $ct2;
}
}
if($table != 2){
$player['cash'] = $ct1;
}
if (!isset($player['last_attack_by']) && $table == 2) {
$player['last_attack_by']="~";
}
if (isset($player['clan_sym']) && $table == 2) {
$player['clan_sym'] = "<font color=#$player[clan_sym_color]>$player[clan_sym]</font>";
$player['clan_sym_color'] = "";
} elseif(isset($table) && $table == 2) {
$player['clan_sym'] = "~";
}
if (isset($player['last_attack']) && $player['last_attack'] == 1) {
$player['last_attack']="~";
} elseif (isset($player['last_attack'])) {
$player['last_attack'] = date( "M d - H:i",$player['last_attack']);
}
if (isset($player['joined_game'])) {
$player['joined_game'] = date( "M d - H:i",$player['joined_game']);
}
$dis_name = print_name($player);
$player['login_name'] = $dis_name;
unset($player['login_id'], $player['clan_sym_color']);
$text .= make_row($player);
$ct2++;
}
$text .= "</table><br />";
print_page($cw['player_ranking'],$text);
?>