Направете файл под името vote.php в него запишете този код
След това запишете друг файл с името vote1.php в него запишете този код
Изпълнете този SQL Code
and edit accounts and put in
votingpoints int(11) (tick notnull) (untick autoinc, unsigned and zerofill) and put 0 in the end.
PHP:
<center><p>
<table cellspacing=1 cellpadding=5>
<tr>
<form action="vote1.php" method="POST">
<tr><td class=list align=right><font size="5">Username:</font></td><td class=list><input type=text name=name maxlength="15"></td></tr>
<tr><td colspan=2 class=list><font color="#FF0000">This will give you 'one' votepoint. <br /> </font></td></tr>
<tr><td class=listtitle align=center colspan=2><input type=submit name=submit value='Vote'></td></tr>
</form>
</table>
</center>След това запишете друг файл с името vote1.php в него запишете този код
PHP:
<?php
$conn = mysql_connect("localhost", "root", "root") or die ('Error connecting to MySQL!');
mysql_select_db("shootsource");
$earnedpoints = false;
$account = $_POST['name'];
$account = mysql_real_escape_string($account);
if ($account == "") {
echo 'Enter an account name!';
exit();
}
$ip = $_SERVER['REMOTE_ADDR'];
$time = time();
$query = mysql_query("SELECT *, SUM(`times`) as amount FROM votingrecords WHERE account='$account' OR ip='$ip'");
$lasttime = mysql_fetch_array($query);
$amount = $lasttime['amount'];
$insertnew = false;
if ($amount == "") {
$insertnew = true;
}
$timecalc = $time - $lasttime['date'];
if (!$insertnew) {
if ($timecalc < 43200) {
echo ' Hello '. $account .' you have already voted with this account ('. $account .') or IP ('. $ip .') in the last 12 hours!';
echo ' Last voted on: '. date('M d\, h:i:s A', $lasttime['date']) .'';
echo '<html>';
echo '<head>';
echo '<meta HTTP-EQUIV="REFRESH" content="10; url=/">';
echo '</head>';
echo '<body>';
echo '<br><br>You will be redirected to the main website in 10 seconds.';
echo '</body>';
echo '</html>';
exit();
} else {
$update = mysql_query("UPDATE votingrecords SET account='$account', date='$time', times=times+1 WHERE ip='$ip'");
if (!$update) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $update;
die($message);
} else {
$earnedpoints = true;
}
}
} else {
$success = mysql_query("INSERT INTO votingrecords (`account`, `ip`, `date`, `times`) VALUES ('$account', '$ip', '$time', 1)");
if (!$success) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $success;
die($message);
} else {
$earnedpoints = true;
}
}
if ($earnedpoints) {
$points = mysql_query("UPDATE accounts SET votingpoints = votingpoints + 1 WHERE name='$account'");
if (!$points) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
mysql_close($conn);
echo '<html>';
echo '<head>';
echo '<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.gtop100.com/in.php?site=9999999">';
echo '</head>';
echo '</html>';
} else {
echo 'There was an error processing your request.';
exit();
}
?>Изпълнете този SQL Code
PHP:
DROP TABLE IF EXISTS `votingrecords`;
CREATE TABLE `votingrecords` (
`account` varchar(13) NOT NULL default '0',
`ip` varchar(30) NOT NULL default '0',
`date` int(11) NOT NULL default '0',
`times` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;and edit accounts and put in
votingpoints int(11) (tick notnull) (untick autoinc, unsigned and zerofill) and put 0 in the end.
