Малко помощ за анкета за гласуване на 24 през Ip

embata

Registered
Това е код от анкета която искам да я направя да се гласува на по един път на ден обаче не мога.... Намерих един код за гласува по IP и един път на ден ама незнам къде да го копирам
Код:
<?php
function poll($promenliva) {
$ip = getenv("REMOTE_ADDR");
mysql_select_db($db, $conn);
if ($_POST['submit']) {
$ip = $_SERVER['REMOTE_ADDR']; // vzimame IP to na usera
$otg = $_POST['otgovor']; //vzimame otgovora poso4en ot potrebitelq
$time = time(); // vzimame sega6noto vreme
$result = mysql_query("SELECT * FROM vote WHERE ip LIKE '$ip%' ORDER BY time DESC LIMIT 1"); // izvejdame posledniq vot na potrebitelq s tova I
$newtime = $res[time] + (24 * 60 * 60); // kym nego vreme dobavqme 1 den
$result1 = mysql_query("SELECT * FROM vote WHERE ip LIKE '$ip%' AND time < $newtime"); // tuk proverqvame dali e minal 1 den ot posledniq vot na potrebitel s tova IP
$res = mysql_num_rows($result1);
if ($res == 0) { // ako proverkata dade rezultat 0 koeto ozna4ava 4e sa minali 24 4asa otkakto e glasuval za posledno usera
mysql_query("INSERT INTO vote (`otg`, `ip`, `time`) VALUES ('$otg', '$ip', '$time')");
include("config_poll.php");
if (isset($promenliva) && is_numeric($promenliva)) {
$poll_here = mysql_num_rows(mysql_query("SELECT * FROM poll WHERE id = '$promenliva' LIMIT 1"));
if ($poll_here > 0) {
$poll_query = mysql_query("SELECT * FROM poll WHERE id = '$promenliva' LIMIT 1");
$poll = mysql_fetch_array($poll_query);
$poll_broi = mysql_num_rows($poll_query);
} else {
$poll_query = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1");
$poll = mysql_fetch_array($poll_query);
$poll_broi = mysql_num_rows($poll_query);
}
} else {
$poll_query = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1");
$poll = mysql_fetch_array($poll_query);
$poll_broi = mysql_num_rows($poll_query);
}

if ($poll_broi > 0) {
if ($poll['status'] == 1) {
$dali_si_glasuval = mysql_num_rows(mysql_query("SELECT * FROM ips WHERE ip = '$ip' AND id = '".$poll['id']."'"));
if ($dali_si_glasuval == 0) {
$vote = $_POST['vote'];
$return = 0;
if (isset($_POST['submit']) && $poll['otgovori_max'] > 1) {
$i = 0;
$otgovori_k = 0;
$kolkoo = count($vote);
while ($i < $kolkoo) {
$dali_taq_anketa = mysql_fetch_array(mysql_query("SELECT * FROM otgovori WHERE id = '$vote[$i]' LIMIT 1"));
if ($dali_taq_anketa['id_poll'] == $poll['id']) {
$otgovori_k++;
}
$i++;
}
if ($poll['otgovori_min'] <= $otgovori_k && $poll['otgovori_max'] >= $otgovori_k && $otgovori_k == $kolkoo) { $return = 1; }
} else {
if (isset($_POST['vote']) && is_numeric($vote)) {
$dali_taq_anketa = mysql_fetch_array(mysql_query("SELECT * FROM otgovori WHERE id = '$vote' LIMIT 1"));
if ($dali_taq_anketa['id_poll'] == $poll['id']) { $return = 1; }
}
}

if (isset($_POST['submit']) && $return == 1) {
if ($poll['otgovori_max'] > 1) {
$i = 0;
while ($i < $kolkoo) {
mysql_query("UPDATE otgovori SET broi = broi + 1 WHERE id = '$vote[$i]' LIMIT 1");
$i++;
}
} else {
mysql_query("UPDATE otgovori SET broi = broi + 1 WHERE id = '$vote' LIMIT 1");
}
mysql_query("INSERT INTO ips (id,ip) VALUES ('".$poll['id']."','$ip')");

if ($poll['podrejdane'] == 1) { $order_by = "ORDER BY id ASC"; }
elseif ($poll['podrejdane'] == 2) { $order_by = "ORDER BY broi DESC"; }

$query_otgovori = mysql_query("SELECT * FROM otgovori WHERE id_poll = '".$poll['id']."' $order_by");
$query = mysql_query("SELECT SUM(broi) as kolko FROM otgovori WHERE id_poll = '".$poll['id']."' GROUP BY id_poll");
$votes = mysql_fetch_array($query);
$votes = $votes['kolko'];
?>
<b><?=$poll['vapros']?></b><br><br>
<table border="0">
<?php
while ($row_otgovori = mysql_fetch_array($query_otgovori)) {
$procent = $row_otgovori['broi'] * (100/$votes);

?>
<tr><td><font color=black><?=$row_otgovori['otgovor']?></font></td><td><img src="bar_left.bmp" height="9" border="0"><img src="vote.bmp" width="<?=$procent?>" height="9" border="0"><img src="bar_right.bmp" height="9" border="0"></td><td><?=$row_otgovori['broi']?> </td></tr>
<?php
}
?>
</table><br>
Îáùî ãëàñîâå: <font color=black><b><?=$votes?></b></font>
<?php
} else {
$query_otgovori = mysql_query("SELECT * FROM otgovori WHERE id_poll = '".$poll['id']."' ORDER BY id ASC");
?>
<b><?=$poll['vapros']?></b><br><br>
<form action="" method="post">
<?php
while ($row_otgovori = mysql_fetch_array($query_otgovori)) { ?>
<?php if ($poll['otgovori_max'] > 1) { ?><input type="checkbox" name="vote[]" value="<?=$row_otgovori['id']?>"><?php } else { ?><input type="radio" name="vote" value="<?=$row_otgovori['id']?>"><?php } ?> <?=$row_otgovori['otgovor']?><br>
<?php } ?>
<input type="submit" name="submit" value="Ãëàñóâàé">
</form>
<?php
}
} else {
if ($poll['podrejdane'] == 1) { $order_by = "ORDER BY id ASC"; }
elseif ($poll['podrejdane'] == 2) { $order_by = "ORDER BY broi DESC"; }

$query_otgovori = mysql_query("SELECT * FROM otgovori WHERE id_poll = '".$poll['id']."' $order_by");
$query = mysql_query("SELECT SUM(broi) as kolko FROM otgovori WHERE id_poll = '".$poll['id']."' GROUP BY id_poll");
$votes = mysql_fetch_array($query);
$votes = $votes['kolko'];
?>
<b><?=$poll['vapros']?></b><br><br>
<table border="0">
<?php
while ($row_otgovori = mysql_fetch_array($query_otgovori)) {
$procent = $row_otgovori['broi'] * (100/$votes);
$procent = round($procent);
?>
<tr><td><?=$row_otgovori['otgovor']?></td><td><img src="bar_left.bmp" height="9" border="0"><img src="vote.bmp" width="<?=$procent?>" height="9" border="0"><img src="bar_right.bmp" height="9" border="0"></td><td> </td></tr>
<?php
}
?>
</table><br>
Îáùî ãëàñîâå: <b><?=$votes?></b>
<?php
}
} else {
if ($poll['podrejdane'] == 1) { $order_by = "ORDER BY id ASC"; }
elseif ($poll['podrejdane'] == 2) { $order_by = "ORDER BY broi DESC"; }

$query_otgovori = mysql_query("SELECT * FROM otgovori WHERE id_poll = '".$poll['id']."' $order_by");
$query = mysql_query("SELECT SUM(broi) as kolko FROM otgovori WHERE id_poll = '".$poll['id']."' GROUP BY id_poll");
$votes = mysql_fetch_array($query);
$votes = $votes['kolko'];
?>
<b><?=$poll['vapros']?></b><br><br>
<table border="0">
<?php
while ($row_otgovori = mysql_fetch_array($query_otgovori)) {
$procent = $row_otgovori['broi'] * (100/$votes);
$procent = round($procent);
?>
<tr><td><?=$row_otgovori['otgovor']?></td><td><img src="bar_left.bmp" height="9" border="0"><img src="vote.bmp" width="<?=$procent?>" height="9" border="0"><img src="bar_right.bmp" height="9" border="0"></td><td>Ãëàñîâå: <?=$row_otgovori['broi']?> (<?=$procent?>%)</td></tr>
<?php
}
?>
</table><br>
Îáùî ãëàñîâå: <b><?=$votes?></b>
<?php
}
} else {
echo "Íÿìà òàêàâà àíêåòà èëè âñå îùå íÿìà äîáàâåíè àíêåòè!";
}
}
?>

Това е кода за копиране ама нз къде да го копирам
Код:
<?php
$username = "root";
$pass = "";
$host = "localhost";
$db = "nova";
$conn = mysql_connect($host, $username, $pass);
mysql_select_db($db, $conn);
if ($_POST['submit']) {
$ip = $_SERVER['REMOTE_ADDR']; // vzimame IP to na usera
$otg = $_POST['otgovor']; //vzimame otgovora poso4en ot potrebitelq
$time = time(); // vzimame sega6noto vreme
$result = mysql_query("SELECT * FROM vote WHERE ip LIKE '$ip%' ORDER BY time DESC LIMIT 1"); // izvejdame posledniq vot na potrebitelq s tova IP
$res = mysql_fetch_array($result);
$newtime = $res[time] + (24 * 60 * 60); // kym nego vreme dobavqme 1 den
$result1 = mysql_query("SELECT * FROM vote WHERE ip LIKE '$ip%' AND time < $newtime"); // tuk proverqvame dali e minal 1 den ot posledniq vot na potrebitel s tova IP
$res = mysql_num_rows($result1);
if ($res == 0) { // ako proverkata dade rezultat 0 koeto ozna4ava 4e sa minali 24 4asa otkakto e glasuval za posledno usera
mysql_query("INSERT INTO vote (`otg`, `ip`, `time`) VALUES ('$otg', '$ip', '$time')"); // dobavqme vota na potrebitelq
echo "Вие гласувахте успешно";
echo "<a href='viewvote.php'>Виж анкетата</а>";
}
else
{
echo "Вие вече сте гласували през последните 24 часа."; // kazvame 4e ne sa minali 24 4asa otkakto e glasuval.
echo "<a href='viewvote.php'>Виж анкетата</а>";
}
}
else
{ // tuka po4va html koda na anketata
?>
който знае да помага плс
 
еми то 1 код е от нея обаче аз искам да се гласува на време и по ip като в тази http://web-tourist.net/login/login/view.php?st=2323 а формата е като в тази дето ти са дал линк
 

Back
Горе