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

