if(ISSET($_POST['c'])){
if($_POST['c'] == 0){
$host_db = "localhost";
$user_db = "";
$pass_db = "";
$db_name = "";
$tbl_name = "";
// Connect to server and select databse.
mysql_connect("$host_db", "$user_db", "$pass_db")or die("Cannot Connect to Data Base.");
mysql_select_db("$db_name")or die("Cannot Select Data Base");
$tiempoactual = date("y-m-d H:i:s");
$sqlc= "SELECT * FROM usertbl WHERE id='".$_SESSION['iduser']."'";
$resultc=mysql_query($sqlc);
$rowc = mysql_fetch_array($resultc);
$ultim = $rowc['tiempo'];
$queryg = "select time_to_sec(timediff('$tiempoactual','$ultim'))as intervalo;";
$resultado = mysql_query ($queryg);
$rowd = mysql_fetch_array($resultado);
if ($rowd['intervalo'] <= 86400){
$puntos = $rowc['points'];
echo '<script>alert("¡Error! '.$_SESSION['username'].' tienes que esperar al menos 24 horas para volver a obtener puntos.");</script>';
}else{
$sqlb= "UPDATE usertbl SET tiempo = '$tiempoactual', points = points+1 WHERE id='".$_SESSION['iduser']."'";
$resultb=mysql_query($sqlb);
$sql= "SELECT * FROM usertbl WHERE id='".$_SESSION['iduser']."'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
$puntos = $row['points'];
}
}
}
