Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <link rel="stylesheet" href="StylesTSL.css" type="text/css" media="screen">
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Terraria Server List</title>
- </head>
- <body>
- <div id="page">
- <div id="logobase">
- <div class="filler"></div>
- <center><img src="logo.png" width="400" height="100"/></center>
- </div>
- <div class="filler"></div>
- <div class="header"><center><a href="http://bobcraft-games.com/TSL/search.php">Search</a> - <a href="http://bobcraft-games.com/TSL/">Home</a> - <a href="http://bobcraft-games.com/TSL/guide.php">Guide to submitting a server</a></center></div>
- <div class="filler"></div>
- <?php
- $cip = $_SERVER['REMOTE_ADDR'];
- $page = $_GET['id'];
- addslashes($page);
- $conn = mysql_connect("localhost","x","px");
- if (!$conn) {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db("x", $conn);
- $check = mysql_query("SELECT * FROM `Servers_votes` WHERE `id` = '$page'");
- $checka = mysql_fetch_assoc($check);
- if (strpos($checka['clientIP'], $cip)) {
- ` echo "<div class='header'><center>You've already voted for this server!<br><a href='http://bobcraft-games.com/TSL/'>Return to our homepage</a></center></div>";
- }
- else {
- mysql_query("INSERT INTO `Servers_votes` (`id`, `clientIP`) VALUES('".mysql_real_escape_string($page)."', '".mysql_real_escape_string($cip)."')") or die(mysql_error());
- $voting = mysql_query("SELECT SUM(vote) AS fCount FROM `Servers_votes` WHERE `id` = '$page'");
- $result = mysql_fetch_array($voting);
- $fCount = $result["fCount"];
- $result = mysql_query("SELECT * FROM Servers WHERE id = '$page'");
- mysql_query("UPDATE `Servers` SET `votes`='".$fCount."' WHERE `Servers`.`id`='".$page."'") or die(mysql_error());
- echo "<div class='header'><center>You've successfully voted for this server!<br><a href='http://bobcraft-games.com/TSL/'>Return to our homepage</a></center></div>";
- }
- ?>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement