diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-01-08 23:47:23 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-01-08 23:47:23 +0100 |
| commit | e861eafbeae0560add7956530d76de6cc285be20 (patch) | |
| tree | c32e746977fde711cecd716570989014bf2d3592 /html/pages/admin/emptydb.php | |
| parent | 66b162b5f01c996fd8a5cd4e570e31f8483cdffa (diff) | |
| parent | 730c20dd04b5753cb372a289923e39516d1f8b87 (diff) | |
Merge pull request #5 from randommonk/develop4.3.0
Bumped version to 4.3. Added jpgraph stats developed by killerEye
Diffstat (limited to 'html/pages/admin/emptydb.php')
| -rwxr-xr-x | html/pages/admin/emptydb.php | 75 |
1 files changed, 40 insertions, 35 deletions
diff --git a/html/pages/admin/emptydb.php b/html/pages/admin/emptydb.php index 9eee7d2..63599fc 100755 --- a/html/pages/admin/emptydb.php +++ b/html/pages/admin/emptydb.php @@ -20,43 +20,48 @@ $i++; $results = adminselect($options);
-
IF ($results['sure'] == "Yes" and $results['really'] == "Yes") {
- echo'<br><table border="0" cellpadding="1" cellspacing="2" width="600">
- <tr>
- <td class="smheading" align="center" colspan="2">Empty Database</td>
- </tr>
- <tr>
- <td class="smheading" align="left" width="300">Emptying All Tables but uts_ip2country and uts_weaponstats</td>';
- mysql_query("TRUNCATE uts_events;") or die(mysql_error());
- mysql_query("TRUNCATE uts_games;") or die(mysql_error());
- mysql_query("TRUNCATE uts_gamestype;") or die(mysql_error());
- mysql_query("TRUNCATE uts_killsmatrix;") or die(mysql_error());
- mysql_query("TRUNCATE uts_match;") or die(mysql_error());
- mysql_query("TRUNCATE uts_pinfo;") or die(mysql_error());
- mysql_query("TRUNCATE uts_player;") or die(mysql_error());
- mysql_query("TRUNCATE uts_rank;") or die(mysql_error());
- mysql_query("DELETE FROM uts_weapons WHERE id > 19") or die(mysql_error());
- mysql_query("ALTER TABLE uts_weapons AUTO_INCREMENT=20") or die(mysql_error());
- mysql_query("TRUNCATE uts_weaponstats;") or die(mysql_error());
- echo'<td class="grey" align="left" width="300">Done</td>
- </tr>
- <tr>
- <td class="smheading" align="center" colspan="2">Database Emptied - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
- </tr></table>';
+ echo '<br><table border="0" cellpadding="1" cellspacing="2" width="600">
+ <tr>
+ <td class="smheading" align="center" colspan="2">Empty Database</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="left" width="300">
+ Emptying All Tables except uts_ip2country, uts_weaponstats and uts_charttypes
+ </td>';
+
+ mysql_query("TRUNCATE uts_chartdata;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_events;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_games;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_gamestype;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_killsmatrix;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_match;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_pinfo;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_player;") or die(mysql_error());
+ mysql_query("TRUNCATE uts_rank;") or die(mysql_error());
+ mysql_query("DELETE FROM uts_weapons WHERE id > 19") or die(mysql_error());
+ mysql_query("ALTER TABLE uts_weapons AUTO_INCREMENT=20") or die(mysql_error());
+ mysql_query("TRUNCATE uts_weaponstats;") or die(mysql_error());
+
+ echo '<td class="grey" align="left" width="300">Done</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="center" colspan="2">
+ Database Emptied - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a>
+ </td>
+ </tr></table>';
} else {
- echo'<br><table border="0" cellpadding="1" cellspacing="2" width="600">
- <tr>
- <td class="smheading" align="center" colspan="2">Empty Database</td>
- </tr>
- <tr>
- <td class="smheading" align="left" width="300">Database Not Emptied</td>
- <td class="grey" align="left" width="300">Answer Was No</td>
- </tr>
- <tr>
- <td class="smheading" align="center" colspan="2">Database Not Emptied - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
- </tr></table>';
+ echo '<br><table border="0" cellpadding="1" cellspacing="2" width="600">
+ <tr>
+ <td class="smheading" align="center" colspan="2">Empty Database</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="left" width="300">Database Not Emptied</td>
+ <td class="grey" align="left" width="300">Answer Was No</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="center" colspan="2">Database Not Emptied - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
+ </tr></table>';
}
-
?>
|