blob: 4d60302461f4511db095cd8c74b94255efcd7035 (
plain)
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
|
<?php
if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');
if (isset($_REQUEST['droptable'])) {
$droptable = my_addslashes($_REQUEST['droptable']);
if (substr($droptable, 0, 9) == 'uts_temp_' and strlen($droptable) == 17) {
mysql_query("DROP TABLE $droptable;") or die(mysql_error());
} else {
die('NO!');
}
}
// Graph width
$max_width = 150;
function nf($number) {
return(number_format($number));
}
echo'<table class = "box" border="0" cellpadding="1" cellspacing="2" width="600">
<tr>
<td class="smheading" align="center" height="25" colspan="4">Database Statistics</td>
</tr>';
$q_dbsize = mysql_query("SHOW table STATUS") or die(mysql_error());
$tot_size = 0;
$tot_rows = 0;
$max_size = 0;
while ($r_dbsize = mysql_fetch_array($q_dbsize)) {
if (substr($r_dbsize['Name'], 0, 4) != 'uts_') continue;
$size = $r_dbsize['Data_length'] + $r_dbsize['Index_length'];
$rows = $r_dbsize['Rows'];
$tables[] = array (
'name' => $r_dbsize['Name'],
'size' => $size,
'rows' => $rows
);
$tot_size += $size;
$tot_rows += $rows;
if ($max_size < $size) $max_size = $size;
}
$i = 0;
foreach($tables as $table) {
$i++;
$class = ($i%2) ? 'grey' : 'grey2';
$d_size = file_size_info($table['size']);
$title = get_dp($table['size'] / $tot_size * 100) .' %';
echo'<tr>
<td class="smheading" align="left" width="200">';
if (substr($table['name'], 0, 9) == 'uts_temp_' and strlen($table['name']) == 17) {
echo '<a href="admin.php?key='. urlencode($adminkey) .'&action=main&droptable='.htmlentities($table['name']).'"><img src="images/del.png" border="0" width="16" height="16" title="Click to drop this table" alt="Delete" /></a><em>'.$table['name'].'</em>';
} else {
echo $table['name'];
}
echo '</td>
<td class="'.$class.'" align="right">'.nf($table['rows']).' rows</td>
<td class="'.$class.'" align="right">'.$d_size['size'] .' '. $d_size['type'].'</td>
<td class="'.$class.'" width="'.($max_width + 5).'"><img border="0" src="images/bars/h_bar'. ($i % 16 + 1) .'.png" height="10" width="'.(int)($table['size'] / $max_size * $max_width).'" alt="'. $title .'" title="'. $title .'"></td>
</tr>';
}
$d_size = file_size_info($tot_size);
echo'<tr>
<td class="smheading" align="left" width="200">Total Database Size</td>
<td class="darkgrey" align="right">'.nf($tot_rows).' rows</td>
<td class="darkgrey" align="right">'.$d_size['size'] .' '. $d_size['type'].'</td>
<td class="darkgrey" > </td>
</tr>
</table><br>';
echo'<table border="0" cellpadding="1" cellspacing="2" width="600">
<tr><td width="100%">';
echo '
<ul>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=mplayers">Merge Players</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=mservers">Merge Servers</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=plm">Merge IPs with more than 1 Player</a></li>';
echo '<br>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=dmatch">Delete Match</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=dpmatch">Delete Player From Match</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=dplayer">Delete Player</a></li>';
echo '<br>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=pban&saction=ban">Ban Player</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=pban&saction=unban">Unban Player</a></li>';
echo '<br>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=pinfo">Extended Player Info</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=ipsearch">Search IP</a></li>';
if ($import_utdc_download_enable) {
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=utdclog">View UTDC logs</a></li>';
}
if ($import_ac_download_enable) {
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=aclog">View AnthChecker logs</a></li>';
}
if ($import_ace_download_enable) {
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=acelog">View ACE logs</a></li>';
}
echo '<br>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=editweapons">Edit Weapons</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=editgames">Add/Edit Game Names</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=editgamestype">Add/Edit Game Types</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=recalcranking">Recalculate Rankings</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=recalcflags">Recalculate Countryflags</a></li>';
echo '<br>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=check">Check server settings</a></li>';
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&action=emptydb">Empty the database</a></li>';
echo '
</ul>
';
echo'</td></tr></table>';
?>
|
