This repository has been archived by the owner on Jan 25, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
stats.php
441 lines (441 loc) · 14.9 KB
/
stats.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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
<?php
if (!$section)
{
$player = $myGame->getPlayerStats();
$cols = $myGame->getColStats();
$ships = $myGame->getShipStats();
$ress = $myGame->getRessStats();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td width=100% class=tdmain>/ <strong>Statistiken</strong></td>
</tr>
</table><br>
<table>
<tr>
<td width=150 valign=top>
<table width=150 bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain align=center>Spielerstats</td>
</tr>
<tr>
<td class=tdmainobg>Spieler: ".$player[active]."<br>
|-online: ".$player[online]."<br>
|-im Urlaub: ".$player[vac]."<br>
|-werden gelöscht: ".$player[nrdel]."<br>
|-Ø Sympathie: ".$player[symp]."<br>
|-Föderation: ".$player[fed]."<br>
|-Romulaner: ".$player[rom]."<br>
|-Klingonen: ".$player[kli]."<br>
|-Cardassianer: ".$player[car]."<br>
|-Ferengi: ".$player[fer]."<br>
|-<a href=?page=stats§ion=allywars>Allianzkriege: ".$player[allywar]."</a>
</td>
</tr>
</table>
</td>
<td width=150 valign=top>
<table width=150 bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain align=center>Koloniestats</td>
</tr>
<tr>
<td class=tdmainobg>Kolonisiert: ".$cols[settled]."<br>
|-Einwohner: ".$cols[bev]."<br>
|-kol. Klasse M: ".$cols[cm]."<br>
|-kol. Klasse L: ".$cols[cl]."<br>
|-kol. Klasse N: ".$cols[cn]."<br>
|-kol. Klasse G: ".$cols[cg]."<br>
|-kol. Klasse K: ".$cols[ck]."<br>
|-kol. Klasse D: ".$cols[cd]."<br>
|-kol. Klasse H: ".$cols[ch]."<br>
|-kol. Klasse X: ".$cols[cx]."<br>
|-kol. Klasse J: ".$cols[cj]."<br>
</td>
</tr>
</table>
</td>
<td width=150 valign=top>
<table width=150 bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain align=center>Schiffstats</td>
</tr>
<tr>
<td class=tdmainobg>Schiffe: ".$ships[ships]."<br>
|-inaktiv: ".$ships[inaktiv]."<br>
|-Ø Crew/Schiff: ".$ships[crew]."<br>
|-Ø Torps/Schiff: ".$ships[torp]."<br>
|-Trümmerfelder: ".$ships[trums]."<br></td>
</tr>
</table>
</td>
<td width=150 valign=top>
<table width=150 bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain align=center>Ressourcenstats</td>
</tr>
<tr>
<td class=tdmainobg>Ressourcen: ".$ress[ress]."<br>
|-Ø Ress/Spieler: ".round($ress[ress]/$player[active])."
</td>
</tr>
<tr>
<td class=tdmain align=Center>Kolonieschau</td>
</tr>
<tr>
<td class=tdmainobg>
<table width=100% cellspacing=0 cellpadding=0>
<tr>
<td class=tdmainobg rowspan=2><img src=".$grafik."/planets/".$cols[wm][colonies_classes_id].".gif title='Kolonieschau'></td>
<td class=tdmainobg>".stripslashes($cols[wm][name])."</td>
</tr>
<tr>
<td class=tdmainobg>Temperatur ".$cols[wm][temp]."°C</td>
</tr>
</table></td>
</tr>
</table>
</td>
<td width=150 valign=top>
<table width=150 bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain align=center>Wirtschaftsstats</td>
</tr>
<tr>
<td class=tdmainobg>G-Wirtschaft: ";
$cols[lrw] >= 0 ? print("<font color=green>+".$cols[lrw]." %</font>") : print("<font color=red>".$cols[lrw]." %</font>");
echo "<br>
|-Ø Wirtschaft: ".$cols[wirtschaft]."<br>
|-Arbeitslose %: ".round($cols[jless],2)."<br>
</td>
</tr>
</table>
</td>
</tr>
</table><br>
<table>
<tr>
<td valign=top>
<table cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain align=center>Bestenlisten</td>
</tr>
<tr>
<td class=tdmainobg>
<a href=main.php?page=stats§ion=bestcols>Die 10 größten Kolonien</a><br>
<a href=main.php?page=stats§ion=bestfleet>Die 10 größten Flotten</a><br>
<a href=main.php?page=stats§ion=bestweap>Die 10 bestbewaffnetsten Flotten</a><br>
<a href=main.php?page=stats§ion=bestwirt>Die 10 stärksten Wirtschaftsmächte</a><br>
<a href=main.php?page=stats§ion=mostbev>Die 10 bevölkerungsreichsten Kolonisten</a><br>
<a href=main.php?page=stats§ion=mostjobless>Die 10 miesesten Arbeitgeber</a><br>
<a href=main.php?page=stats§ion=bestresearch>Die 10 fortgeschrittensten Kolonisten</a><br>
<a href=main.php?page=stats§ion=richestuser>Die 10 reichsten Kolonisten</a></td>
</tr>
<tr>
<td class=tdmainobg><a href=main.php?page=hally§ion=goodview>Warenübersicht</a></td>
</tr></table>
</td><td valign=top>
<table cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain align=center>Detaillisten</td>
</tr>
<tr>
<td class=tdmainobg>
<a href=main.php?page=stats§ion=shipclasses>Details: Schiffe</a><br>
<a href=main.php?page=stats§ion=buildclasses>Details: Gebäude</a><br>
(Aktualisierung alle 15mins)</td>
</tr>
</table>
</td>";
$ships = $myDB->query("SELECT ship_count FROM stu_stats WHERE user_id=".$user,1);
$wirt = $myDB->query("SELECT wirtschaft FROM stu_stats WHERE user_id=".$user,1);
$bev = $myDB->query("SELECT bev FROM stu_stats WHERE user_id=".$user,1);
if (!$wirt) $wirt = 0;
echo "<td valign=top>
<table cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain align=center>Mein Account</td>
</tr>
<tr>
<td class=tdmainobg>Schiffe: ".$ships." (".($myDB->query("SELECT COUNT(user_id) FROM stu_stats WHERE ship_count>".$ships,1)+1).".)<br>
Wirtschaft: ".$wirt." (".($myDB->query("SELECT COUNT(user_id) FROM stu_stats WHERE wirtschaft>".$wirt,1)+1).".)<br>
Bevölkerung: ".$bev." (".($myDB->query("SELECT COUNT(user_id) FROM stu_stats WHERE bev>".$bev,1)+1).".)</td>
</tr>
</table>
</td>
</tr>
</table>";
}
elseif ($section == "tick")
{
$ticks = $myGame->getTickStats();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Tickverlauf</strong></td>
</tr>
</table><br>
<table width=70% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>Runde</b></td>
<td class=tdmain><b>Start</b></td>
<td class=tdmain><strong>Ende</strong></td>
</tr>";
for ($i=0;$i<count($ticks);$i++) {
$ticks[$i][ende] != 0 ? $ende = date("d.m.Y H:i:s",$ticks[$i][ende]) : $ende = "-";
echo "<tr>
<td class=tdmainobg>".$ticks[$i][runde]."</td>
<td class=tdmainobg>".date("d.m.Y H:i:s",$ticks[$i][start_tsp])."</td>
<td class=tdmainobg>".$ende."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "bestcols")
{
$cols = $myColony->getbestcols();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 größten Kolonien</strong></td>
</tr>
</table><br><br>
<table width=90% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>Koloniename</b></td>
<td class=tdmain align=center><b>Einwohner</b></td>
<td class=tdmain><b>Besitzer</b></td>
</tr>";
for ($i=0;$i<count($cols);$i++)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($cols[$i][name])."</td>
<td class=tdmainobg align=center>".$cols[$i][bevcount]."</td>
<td class=tdmainobg>".stripslashes($cols[$i][user])."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "mostbev")
{
$cols = $myColony->getmostbev();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 bevölkerungsreichsten Kolonisten</strong></td>
</tr>
</table><br>
<table width=50% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmainobg><strong>User</strong></td>
<td class=tdmainobg><strong>Bevölkerung</strong></td>
</tr>";
for ($i=0;$i<count($cols);$i++)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($cols[$i][user])."</td>
<td class=tdmainobg>".$cols[$i][maxsum]."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "mostjobless")
{
$cols = $myColony->getmostjobless();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 miesesten Arbeitgeber</strong></td>
</tr>
</table><br>
<table width=50% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmainobg><strong>User</strong></td>
<td class=tdmainobg><strong>Arbeitslose</strong></td>
</tr>";
while($data=mysql_fetch_assoc($cols))
{
echo "<tr>
<td class=tdmainobg>".stripslashes($data[user])."</td>
<td class=tdmainobg>".$data[maxsum]."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "bestfleet")
{
if (!$runde)
{
$runde = $myGame->getcurrentround();
$runde = $runde[runde]-1;
}
$cols = $myHistory->getShipTtHistory($runde);
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 größten Flotten</strong></td>
</tr>
</table><br>
<table width=70% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>User</b></td>
<td class=tdmain align=center><b>Schiffe</b></td>
</tr>";
if ($cols == 0) echo "<tr><td class=tdmainobg colspan=2 align=Center>Für diese Runde sind keine Daten gespeichert</td></tr>";
else
{
for ($i=0;$i<count($cols);$i++) {
echo "<tr>
<td class=tdmainobg>".stripslashes($cols[$i][user])."</td>
<td class=tdmainobg align=Center>".$cols[$i]['count']."</td>
</tr>";
}
}
echo "<form action=main.php method=post>
<input type=hidden name=page value=stats>
<input type=hidden name=section value=bestfleet>
<tr>
<td colspan=2 align=Center class=tdmainobg>Runde anzeigen: <input type=text size=4 name=runde class=text> <input type=submit value=Anzeigen class=button></td>
</tr></form>
</table>";
}
elseif ($section == "shipclasses") include_once("inc/sstats.html");
elseif ($section == "buildclasses") include_once("inc/bstats.html");
elseif ($section == "bestwirt")
{
$cols = $myColony->getbestwirt();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 größten Wirtschaftsmächte</strong></td>
</tr>
</table><br>
<table width=50% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain align=center><b>User</b></td>
</tr>";
for ($i=0;$i<count($cols);$i++)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($cols[$i][user])."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "bestresearch")
{
$cols = $myColony->getbestresearch();
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 fortgeschrittensten User</strong></td>
</tr>
</table><br>
<table width=50% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>User</b></td>
<td class=tdmain align=center><b>Forschungen</b></td>
</tr>";
for ($i=0;$i<count($cols);$i++)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($cols[$i][user])."</td>
<td class=tdmainobg align=Center>".$cols[$i][idcount]."</td>
</tr>";
}
echo "</table>";
}
elseif ($section == "richestuser")
{
function fsort(&$array, $sort, $d = 1)
{
usort ($array , create_function(
'$a,$b',
'return strnatcmp($a["'.$sort.'"],$b["'.$sort.'"])* '.$d.';'));
}
$data = $myColony->getrichestuser();
if (is_array($data))
{
fsort($data,'latinum',-1);
reset($data);
}
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 reichsten Kolonisten</strong></td>
</tr>
</table><br>
<table width=70% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>User</b></td>
<td class=tdmain align=center><b>Latinum</b></td>
</tr>";
if (is_array($data))
{
foreach($data as $key => $unit)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($unit[user])."</td>
<td class=tdmainobg align=Center>".$unit[latinum]."</td>
</tr>";
if ($key >=9) break;
}
}
else echo "<tr><td class=tdmainobg colspan=2 align=center>Kein Latinum vorhanden</td></tr>";
echo "</table>";
}
elseif ($section == "bestweap")
{
function fsort(&$array, $sort, $d = 1)
{
usort ($array , create_function(
'$a,$b',
'return strnatcmp($a["'.$sort.'"],$b["'.$sort.'"])* '.$d.';'));
}
$result = $myDB->query("SELECT SUM(a.torps) as torps,COUNT(b.id) as shipcount,b.user_id FROM stu_ships_rumps as a LEFT JOIN stu_ships as b ON a.id=b.ships_rumps_id WHERE b.user_id>100 AND torps>0 AND a.id!=5 AND a.slots=0 AND a.id!=65 AND a.id!=66 AND a.id!=67 AND a.id!=68 GROUP BY b.user_id");
for ($i=0;$i<mysql_num_rows($result);$i++)
{
$data[$i] = mysql_fetch_assoc($result);
$pho = $myDB->query("SELECT SUM(a.count) FROM stu_ships_storage as a LEFT JOIN stu_ships as b ON a.ships_id=b.id WHERE a.user_id=".$data[$i][user_id]." AND a.goods_id=7 AND b.ships_rumps_id!=5 AND b.ships_rumps_id!=65 AND b.ships_rumps_id!=66 AND b.ships_rumps_id!=67 AND b.ships_rumps_id!=68",1);
$pla = $myDB->query("SELECT SUM(a.count) FROM stu_ships_storage as a LEFT JOIN stu_ships as b ON a.ships_id=b.id WHERE a.user_id=".$data[$i][user_id]." AND a.goods_id=16 AND b.ships_rumps_id!=5 AND b.ships_rumps_id!=65 AND b.ships_rumps_id!=66 AND b.ships_rumps_id!=67 AND b.ships_rumps_id!=68",1);
$qua = $myDB->query("SELECT SUM(a.count) FROM stu_ships_storage as a LEFT JOIN stu_ships as b ON a.ships_id=b.id WHERE a.user_id=".$data[$i][user_id]." AND a.goods_id=17 AND b.ships_rumps_id!=5 AND b.ships_rumps_id!=65 AND b.ships_rumps_id!=66 AND b.ships_rumps_id!=67 AND b.ships_rumps_id!=68",1);
$data[$i][points] = ($pho + $pla*2 + $qua*3)*round($data[$i][torps]/$data[$i][shipcount]);
}
fsort($data,'points',-1);
reset($data);
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Die 10 bestbewaffnetsten Flotten</strong></td>
</tr>
</table><br>
<table width=90% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>Spieler</b></td>
<td class=tdmain align=center><b>Punkte</b></td>
</tr>";
if (is_array($data))
{
foreach($data as $key => $unit)
{
echo "<tr>
<td class=tdmainobg>".stripslashes($myUser->getfield("user",$unit[user_id]))."</td>
<td class=tdmainobg align=Center>".$unit[points]."</td>
</tr>";
if ($key >=9) break;
}
}
} elseif ($section == "allywars") {
echo "<table width=100% bgcolor=#262323 cellspacing=1 cellpadding=1>
<tr>
<td class=tdmain>/ <a href=?page=stats>Statistiken</a> / <strong>Allianzkriege</strong></td>
</tr>
</table><br>
<table width=100% cellpadding=1 cellspacing=1 bgcolor=#262323>
<tr>
<td class=tdmain><b>Allianz</b></td>
<td class=tdmain><b>Krieg mit</b></td>
<td class=tdmain><b>Kriegsbeginn</b></td>
</tr>";
$result = $myDB->query("SELECT *,UNIX_TIMESTAMP(date) as date_tsp FROM stu_allys_beziehungen WHERE type=1");
while($data=mysql_fetch_assoc($result))
{
echo "<tr>
<td class=tdmainobg>".stripslashes($myDB->query("SELECT name FROM stu_allys WHERE id=".$data[allys_id1],1))."</td>
<td class=tdmainobg>".stripslashes($myDB->query("SELECT name FROM stu_allys WHERE id=".$data[allys_id2],1))."</td>
<td class=tdmainobg>".date("d.m.Y",$data[date_tsp])."</td>
</tr>";
}
echo "</table>";
}
?>