Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $DB_SERVER = 'localhost';
- $DB_USERNAME = 'jlarnes_admin';
- $DB_PASSWORD = 'admin!';
- $DB_NAME = 'jlarnes_db';
- $DB_TABLE = 'sploders';
- $sqllink = mysql_connect($DB_SERVER, $DB_USERNAME, $DB_PASSWORD);
- if (!$sqllink) {
- die('FAILED 1 ' . mysql_error());
- }
- $sqldb = mysql_select_db("$DB_NAME", $sqllink);
- if (!$sqldb) {
- die('FAILED 2 ' . mysql_error());
- }
- // ID, LOC, TIME, MONEY, COORDS
- $sql = "CREATE TABLE IF NOT EXISTS sploders " .
- "(id VARCHAR(40), " .
- "loc VARCHAR(40), " .
- "time INT, " .
- "money INT, " .
- "coords VARCHAR(40))";
- mysql_query($sql);
- $CMD = $_GET['action'];
- if ($CMD == 'update') {
- $id = $_GET['id'];
- $loc = $_GET['l'];
- $time = $_GET['t'];
- $money = $_GET['m'];
- $coords = $_GET['c'];
- $sql = "UPDATE $DB_TABLE " .
- "SET loc='$loc', money=$money, time=$time, coords='$coords' " .
- "WHERE id='$id'";
- mysql_query($sql);
- }
- if ($CMD == 'insert') {
- $id = $_GET['id'];
- $loc = $_GET['l'];
- $time = $_GET['t'];
- $money = $_GET['m'];
- $coords = $_GET['c'];
- $sql = "INSERT INTO $DB_TABLE " .
- "VALUES ('$id', '$loc', $time, $money, '$coords')";
- mysql_query($sql);
- }
- if ($CMD == 'getlist') {
- $t = $_GET['t'];
- $p = $_GET['p'] * 10;
- if ($p == '') $p = 0;
- $e = $p + 10;
- $sql = "SELECT * FROM $DB_TABLE WHERE time >= $t - 100 ORDER BY money DESC LIMIT $p, $e";
- $result = mysql_query($sql);
- while ($row = mysql_fetch_assoc($result)) {
- echo $row['id'] . "," . $row['loc'] . "," .
- $row['money'] . "," . $row['coords'] . "|";
- }
- mysql_query("DELETE FROM $DB_TABLE WHERE time < $t - 100");
- }
- if ($CMD == 'showlist') {
- $p = $_GET['p'] * 10;
- if ($p == '') $p = 0;
- $e = $p + 10;
- $sql = "SELECT * FROM $DB_TABLE WHERE time >= 0 ORDER BY money DESC LIMIT $p, $e";
- $result = mysql_query($sql);
- echo "<html>\n <table border=1>\n <tr>\n <td width=100>id</td>\n <td width=100>loc</td>\n " .
- "<td width=100>time</td>\n <td width=100>money</td>\n <td width=100>coords</td>\n";
- while ($row = mysql_fetch_assoc($result)) {
- echo " <tr>\n";
- echo " <td width=100>" . $row['id'] . "</td>\n";
- echo " <td width=100>" . $row['loc'] . "</td>\n";
- echo " <td width=100>" . $row['time'] . "</td>\n";
- echo " <td width=100>" . $row['money'] . "</td>\n";
- echo " <td width=100>" . $row['coords'] . "</td>\n";
- echo " </tr>\n";
- }
- echo " </table>\n</html>";
- }
- if ($CMD == 'droptable') {
- $sql = "DROP TABLE $DB_TABLE";
- mysql_query($sql);
- }
- mysql_close($sqllink);
- ?>
Add Comment
Please, Sign In to add comment