Ajouter un commentaire

invision
problème avec le temps, de 24 heures en 2 heures

Bonjour

Voila, je voudrais savoir si je peut modifier le temps de vote, les votes sont programmées A 24 heures (dons sa fais que je peut voter qu'une seule foi par jour), je souhaiterais les mettre à 2 heures,
mon petit souci c'est que je vote qu'une Seul foi par jour, je voudrais savoir si je peut le remettre toutes les 2 heures, (les votes me servent pour des classements sur des site d'annuaire) code ci-joint des en php .

<?php
function change_db($db)
{
	global $array_db;
	$mysql_link = mysql_connect($array_db['host'], $array_db['user'], $array_db['pass']) or die ("Connexion impossible !");
	mysql_select_db($db, $mysql_link) or die (mysql_error());
}
function create_vote_lists($id,$db)
{
	change_db($db);
	$check_exist = "SELECT * FROM `voting_points` WHERE `id` LIKE '$id'";
	$check = mysql_query($check_exist) or die (mysql_error());
	if(!mysql_num_rows($check))
	{
		$create_list = "INSERT INTO `voting_points` (`id`) VALUES ('$id')";
		$create = mysql_query($create_list) or die (mysql_error());
	}
	$user_ip = getenv("REMOTE_ADDR");
	$check_exist = "SELECT * FROM `voting` WHERE `user_ip` LIKE '$user_ip'";
	$check = mysql_query($check_exist) or die (mysql_error());
	$row = mysql_fetch_array($check);
	$today = time();
	if(!mysql_num_rows($check))
	{
		$create_list = "INSERT INTO `voting` (`user_ip`) VALUES ('$user_ip')";
		$create = mysql_query($create_list) or die (mysql_error());
	}
	else 
		if(($today - $row['time']) > 7200)
		{
			$create_list = "UPDATE `voting` SET `sites` = 0 WHERE `user_ip` LIKE '$user_ip'";
			$create = mysql_query($create_list) or die (mysql_error());
		}
}

function show_points($id,$db)
{
	change_db($db);
	$sql = "SELECT `points` FROM `voting_points` WHERE `id` LIKE '$id'";
	$result = mysql_query($sql) or die (mysql_error());
	$row = mysql_fetch_array($result);
	$acc_points = $row['points'];
	return $acc_points;
}
$points = show_points($_SESSION['id'],$array_db['db_realmd']);

function show_passed_time($db)
{
	change_db($db);
	$user_ip = getenv("REMOTE_ADDR");
	$sql = "SELECT * FROM `voting` WHERE `user_ip` LIKE '$user_ip'";
	$result = mysql_query($sql) or die (mysql_error());
	$row = mysql_fetch_array($result);
	$user_time = $row['time'];
	if ($user_time == 0)
		return 0;
	else
	{
		$today = time();
		$passed = $today - $user_time;
		$passed_seconds = $passed %60;
		$passed_minutes_in_seconds = ($passed - $passed_seconds)%3200;
		$passed_minutes = $passed_minutes_in_seconds/60;
		$passed_hours = ($passed - ($passed_seconds + $passed_minutes_in_seconds))/2;
		$user_passed_time = $passed_hours."h ".$passed_minutes."m et ".$passed_seconds."s";
		return $user_passed_time;
	}
}
function return_voted_sites($db)
{
	change_db($db);
	$user_ip = getenv("REMOTE_ADDR");
	$sql = "SELECT `sites` FROM `voting` WHERE `user_ip` LIKE '$user_ip'";
	$result = mysql_query($sql) or die (mysql_error());
	$row = mysql_fetch_array($result);
	$sites = $row['sites'];
	return $sites;
}
function vote($site,$id,$db)
{
	global $tab_sites;
	if(array_key_exists($site, $tab_sites))
	{
		if(!($site & return_voted_sites($db)))
		{
			$user_ip = getenv("REMOTE_ADDR");
			echo "<script language='javascript'>setTimeout(window.open(\"".$tab_sites[$site][1]."\", \"_self\", \"\"),0);</script>";
			$today = time();
			change_db($db);
			$vote_user = "UPDATE `voting` SET `sites`=(`sites` + $site), `time`='$today' WHERE `user_ip` LIKE '$user_ip'";
			$results = mysql_query($vote_user) or die(mysql_error());
			$vote_acc = "UPDATE `voting_points` SET `points`=(`points` + 1), `date_points`=(`date_points` + 1) WHERE `id` = '$id'";
			$results = mysql_query($vote_acc) or die(mysql_error());
		}
	}
}
function count_tab_sites()
{
	global $tab_sites;
	$counter = 0;
	foreach($tab_sites as $key => $value)
		$counter+=$key;
	return $counter;
}
function show_sites_menu($db)
{
	global $tab_sites;
	$user_ip = getenv("REMOTE_ADDR");
	change_db($db);
	foreach($tab_sites as $key => $value)
	{
		$sql = "SELECT `sites` FROM `voting` WHERE `user_ip` LIKE '$user_ip'";
		$result = mysql_query($sql) or die(mysql_error());
		$row = mysql_fetch_array($result);
		$sites = $row['sites'];
		if (!($sites & $key))
			echo "<option value='".$key."'>".$value[0]."</option>";
	}
}
function show_time_to_vote($db)
{
	change_db($db);
	$user_ip = getenv("REMOTE_ADDR");
	$sql = "SELECT * FROM `voting` WHERE `user_ip` LIKE '$user_ip'";
	$result = mysql_query($sql) or die (mysql_error());
	$row = mysql_fetch_array($result);
	$user_time = $row['time'];
	
	$today = time();
	$remaining = 7200 -($today - $user_time);
	$remaining_seconds = $remaining%60;
	$remaining_minutes_in_seconds = ($remaining - $remaining_seconds)%3600;
	$remaining_minutes = $remaining_minutes_in_seconds/60;
	$remaining_hours = ($remaining - ($remaining_seconds + $remaining_minutes_in_seconds))/3600;
	$user_remaining_time = $remaining_hours."h ".$remaining_minutes."m et ".$remaining_seconds."s";
	return $user_remaining_time;
}
function check_date_points($id,$db)
{
	global $tab_sites;
	change_db($db);
	$sql = "SELECT * FROM `voting_points` WHERE `id` = $id";
	$result = mysql_query($sql) or die (mysql_error());
	$row = mysql_fetch_array($result);
	$date = $row['date'];
	$date_points = $row['date_points'];
	$today = date("Ymd");
	if($date <> $today)
	{
		$reset_date_and_datepoints = "UPDATE `voting_points` SET `date`='$today', `date_points`='0' WHERE `id` = $id";
		$reset = mysql_query($reset_date_and_datepoints) or die (mysql_error());
		return 1;
	}
	else
		if($date_points >= sizeof($tab_sites))
			return 0;
		else
			return 1;
}
?>

Cordialement

Filtered HTML

Plain text

CAPTCHA
Cette question permet de vérifier que vous n'êtes pas un robot spammeur :-)
 K  K  BBBB    SSS   BBBB   X   X 
K K B B S B B X X
KK BBBB SSS BBBB X
K K B B S B B X X
K K BBBB SSSS BBBB X X