In your sql database, can two people have the same name. Are you getting their name from a form input are from a login cookie?
Also do you have a unique id column?
This is a basic kind of script. Is this what your looking for. You would have to fill in the details.
<?php
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
$result = mysql_query("SELECT * FROM `table` WHERE `name`='their name'") or die(mysql_error());
$row = mysql_fetch_array( $result );
$math = time();
$science = $row['time'];
$english = $math-$science;
if ( $english < "10800" ) {
die(' You have already submitted a vote within the last twenty four hours');
} else{
}
?>
I think it should work. If it won't, let me know.
How do I get my time column the same as your format?
No I do not have a unique ID column
They put their username in a field, no verification, because it doesn't need it yet.
No, two people can not use the same username twice, until the username is pruned for outdateness (24 hours from the time they are entered into the table.
I don't know what your current code/system even looks like. Please post the code you currently have and your table structure, and we'll work from there.
Table structure: username | diamonds | voted | alias | date
You also need to know, a single username can be listed several times, but as long as its not on the same voting website, which is what alias says.
Code:
<?php
$vote=$_POST['vote'];
$user=$_POST['playername'];
if($vote==ms){
ob_start();
$host2="CUT"; // Host name
$uname="CUT"; // Mysql username
$passwd="CUT"; // Mysql password
$db_name="minecraft"; // Database name
$tbl_name="votes"; // Table name
// Connect to server and select databse.
mysql_connect("$host2", "$uname", "$passwd")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$user' and alias='Minestatus'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
echo "<div align='center'>Minecity Voting Error</div>";
include('/vote/error.php');
}
else{
$datenow = date('Y-m-d H:i:s');
$sql2="INSERT INTO votes (username, diamonds, voted, alias, date) VALUES ('$user', '1', 'yes', 'Minestatus', '$datenow')";
$result2=mysql_query($sql2);
header('Location: CUT');
}
ob_end_flush();
}
if($vote==gtop){
ob_start();
$host2="CUT"; // Host name
$uname="CUT"; // Mysql username
$passwd="CUT"; // Mysql password
$db_name="minecraft"; // Database name
$tbl_name="votes"; // Table name
// Connect to server and select databse.
mysql_connect("$host2", "$uname", "$passwd")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$user' AND alias='GTop100'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
echo "<div align='center'>Minecity Voting Error</div>";
include('/vote/error.php');
}
else{
$datenow = date('Y-m-d H:i:s');
$sql2="INSERT INTO votes (username, diamonds, voted, alias, date) VALUES ('$user', '1', 'yes', 'GTop100', '$datenow')";
$result2=mysql_query($sql2);
header('Location: http://www.gtop100.com/in.php?site=64552');
}
ob_end_flush();
}
else{
echo "<br>";
}
?>
I wrote it all myself :)
Also, I have some extra variables in there, so try to ignore them.
Generally good practices is never to delete any records, except for certain specific circumstances.
Easiest thing to do is set up a VIEW that excludes anything older than a day based on timestamp and use that for your SELECTS.
If I were to do that, I can't let them use the same username again, it'll conflict when the person is being checked for if they voted.