<?php $db_host = "";
$db_user = "";
$db_pass = "";
$db_name = "";
$connection = @mysql_connect("$db_host", "$db_user", "$db_pass") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
function mysql_prevent($string){ // Prevents mysql attacks on the database
$string = stripslahses(stripslashes($string));
$string = htmlentities(trim($string));
$string = str_replace("#", "#", $string);
$string = str_replace("%", "%", $string);
return mysql_real_escape_string($string);
}
if(mysql_prevent($_POST['id']) != null){ // Update data base here
$username = mysql_prevent($_POST['user']);
$date = date("m/d/y",time());
$downVotes = mysql_prevent($_POST['votesDown']);
$totalVotes = mysql_prevent($_POST['totalVotes']);
$url = mysql_prevent($_POST['videoUrl']);
$views = mysql_prevent($_POST['views']);
if($username != null && $url != null){
$sql = "INSERT INTO `TG_logs` (`user` ,`date` ,`downvotes` ,`totalvotes` ,`url` ,`views`)VALUES (\"".$username."\", \"".$date."\", \"".$downVotes."\", \"".$totalVotes."\", \"".$url."\", \"".$views."\")";
mysql_query($sql);
echo "Updated";
}
else{ echo "Error"; }
}else{ // Our print out page ?>
<html>
<head><title>Tube Guardian Stats</title></head>
<body>
<table>
<tr><td>Username</td><td>Date</td><td>Down Votes</td>
<td>Total Votes</td><td>Url</td><td>Views</td>
</tr>
<?php $sql = mysql_query("SELECT * FROM `TG_logs`");
$TotalBottedVids = mysql_num_rows($sql);
for($i = 0; $i < $TotalBottedVids; $i++){
$sql = mysql_query("SELECT * FROM `TG_logs` LIMIT \"$i\",0");
$row = mysql_fetch_array($sql); ?>
<tr><td><?php echo $row['user']; ?></td>
<td><?php echo $row['date']; ?></td>
<td><?php echo $row['downvotes']; ?></td>
<td><?php echo $row['totalvotes'];?></td>
<td><?php echo $row['url']; ?></td>
<td><?php echo $row['views']; ?></td>
</tr><?php } ?>
<table>
</body>
</html> <?php } ?>
<a href="/user/EvoBiologist" onmousedown="urchinTracker('/Events/VideoWatch/RecentRating');" class="hLink smallText">EvoBiologist</a>