[Release] Voting Reward Script

[powerbar]

All this does for me is redirect me to the index

Will rep if you can help

[TheSpidey]

Will help if you shed more light on your problem. Did you follow my instructions to the letter?

[powerbar]

Well I changed all the database info, i changed the votegateway to my voting url, I added this to its own page, so i made it action= vote.php instead of index.php. But all it does is reloads the page.

<?php
$user="my database username";
$password="My database password";
$database="cr"; //Char+login DB

$nochar=false;
$voted=false;
$disp = true;
if(($_COOKIE['vote']) != '1')
{
if(!empty($_POST['name']))
{
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$name = strtolower(mysql_real_escape_string($_POST['name']));
$today = date("mdHi");
$query="SELECT * FROM characters WHERE name='$name' LIMIT 1";
$result = mysql_query($query);
if($row = mysql_fetch_array($result))
{
$guid = $row['guid'];
$acct = $row['acct'];
$res = mysql_query("SELECT * FROM votewatch WHERE acct='$acct' LIMIT 1");
if($r2 = mysql_fetch_array($res))
{
$ct = $r2['ctime'];
if($today-$ct < 1200)
{
$disp = false;
mysql_close();
return;
}
else
{
mysql_query("DELETE FROM votewatch WHERE acct='$acct' LIMIT 1");
}
}
$reward = mysql_real_escape_string($_POST['reward']);
if($reward == 0)
{
mysql_query("INSERT INTO mailbox_insert_queue(sender_guid, receiver_guid, subject, body, stationary, money, item_id, item_stack) VALUES ($guid, $guid, 'Thank you for voting!', 'Have this item as a reward', 0, 100000, 0, 1)");
}
else
{
mysql_query("INSERT INTO mailbox_insert_queue(sender_guid, receiver_guid, subject, body, stationary, money, item_id, item_stack) VALUES ($guid, $guid, 'Thank you for voting!', 'Have this item as a reward', 0, 0, $reward, 1)");
}
mysql_query("INSERT INTO votewatch(acct, ctime) VALUES($acct, $today)");
$voted = true;
}
else
{
$nochar = true;
}
mysql_close();
}
}
else
{
$disp = false;
}

?>
<div id='container' style='-moz-user-select: none; -khtml-user-select: none; user-select: none; cursor:default; padding-bottom:5px; width:320px; border: 4px double red; position: absolute; top:20px; left:20px; background-color:black; color:white;'>
<div id='header' style='font-family: Arial; margin-bottom: 0.5em; border-bottom: 1px solid red; text-align: center; background-color:gray; color:#ffffff'>
Please vote for our server!
<span align='right' style='position:absolute; left: 305px; text-align: right;'>
<a href='javascript:void();' style='font-size:10px; color:white; text-decoration:none;' onclick='javascript:document.getElementById("container").style.display="none";'>
[X]
</a>
</span>
</div>
<div id='text' style='padding: 5px; padding-left: 7px; font-size: 12px; border-bottom: 1px solid red;'>
Voting for our server helps us grow and evolve,
and eventually become better than before.
You can vote once every 12 hours, and you'll get a reward for doing so!
</div>
<form style='text-align: center; margin-bottom: 2px; margin-top: 5px;' method='post' action='index.html'>
<div style='font-size: 12px; valign:center;'>
Character Name:&nbsp;&nbsp;

<input type='text' name='name' style='font-size: 12px; width: 80px; background-color: black; color: white; border: 1px solid red;' />
<input type='submit' style='font-size: 12px; position:relative; top:1px; color:white; height: 17px; border:1px solid red; background-color:black;' value='Vote!' />
</div>
<div style='font-size: 12px; valign:center; margin-top: 5px; padding-top: 3px;'>
Choose a reward:&nbsp;&nbsp;
<select name='reward' style='background-color: black; color: white; font-family: Arial; font-size: 12px; border: 1px solid red; height: 17px; font-size: 10px;'>
<option value='0'>10 Gold</option>
<option value='27498'>Scroll of Agility V</option>
<option value='27499'>Scroll of Intellect V</option>
<option value='27500'>Scroll of Protection V</option>
<option value='27501'>Scroll of Spirit V</option>
<option value='27502'>Scroll of Stamina V</option>
<option value='27503'>Scroll of Strength V</option>
</select>
</div>
<?php
if($nochar)
{
echo "<br /><span style='font-size: 12px; color: black; background-colorink; padding: 3px; position: relative; top: -8px; border: 1px solid red;'>A character with that name was not found</span>";
}
if($voted)
{
echo "<br /><span style='font-size: 12px; color: white; background-color:black; padding: 3px; position: relative; top: -8px; border: 1px solid red;'>Thank you for voting!</span>";
echo "<script language='javascript'>setTimeout(\"location.href='votegateway.php'\",3000);</script>";
}
?>
</form>
</div>

[TheSpidey]

Your index should be in PHP

[powerbar]

Sorry i meant to change that to vote.php, but i am still getting redirected back to the vote.php page

[mager1794]

thanks jsut what i needed for my new server

[Kiyoshi]

@Erlingi: You can make the popup redirect you to a voting panel (if that helps).

[ArticBlue]

COOL!
+Reputation ^_^

[Klexicon]

This doesnt seem to work, it either says unable to select database, or it just refreshes the page.
Any one know what I'm doing wrong?

[TheSpidey]

Unable to select database means you entered the wrong DB name

[Kyoshero]

i need help

[Kyoshero]

where do i put

<?php
setcookie('vote', '1', time() + 43200);
?>
<script language='javascript'>
setTimeout("location.href='http://www.xtremetop100.com/in.php?site=1132237313'",1);
</script>

[xShadowbladex]

Heres my problem..:

1: It doesn't send the items whatsoever, and the mail is on refresh.

2: It doesn't stop a user from voting every 12 hours. It lets you submit over and over again.

3: It won't put into the SQL "mysql_query("INSERT INTO votewatch(acct, ctime) VALUES($acct, $today)");" part either.

What do I do? ;o

[Nebels]

Replying, all it does is send me back to the first page that it was on.

[capzi]

nice great job