Code: Select all
$attacks_check = mysql_query("SELECT `id` FROM `logs` WHERE `attacker`='".$_SESSION['uid']."' AND `guards`='".$id."' AND `time`>'".(time() - 86400)."'") or die(mysql_error());
Table that holds the users information is User
Code: Select all
id
username
Code: Select all
id
attacker - Person that attacked another person
guards - Person that was attacked
time - Time they were attacked
My problems been trying to pull the attacker out of the database, line it up with the users table username, and then make it specific for each player to see their own last attackers.
And would also like to display how many mins/seconds are left before they can be hit again...
Any Idears? Thank you!