Hii Leute habe Problem mit Vote4Coins Script Bitte sagt mir wo der Fehler liegt.
vote.php
<font color="white">
<?
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
/*
* Vote Page
*/
$VotePage = "http://google.de/";
/*
* Check if User can vote
*/
$VoteLinkClick = trim(mysql_real_escape_string(@$_REQUEST['f']));
$EnableVotePage = true;
$ShowMSG = false;
$SuccessMSG = "";
$CheckPlayerVotes_SQL = "SELECT * FROM account.account_votes WHERE account_id = '".$_SESSION['user_id']."'";
$CheckPlayerVotes_Query = mysql_query($CheckPlayerVotes_SQL);
$CheckPlayerVotes_Result = mysql_fetch_array($CheckPlayerVotes_Query);
/*
* Insert Player's Vote-Log in account_votes, if non-existent
*/
if( $CheckPlayerVotes_Result['account_id'] != $_SESSION['user_id'] or empty($CheckPlayerVotes_Result['account_id']) ) {
$Account_AddVoteEntry = "INSERT INTO account.account_votes
(account_id, last_vote_at, votes_given, coins_received, new_vote_at)
VALUES
('".$_SESSION['user_id']."', '0', '0', '0', '0')";
@mysql_query($Account_AddVoteEntry);
}
mysql_free_result($CheckPlayerVotes_Query);
$CheckPlayerVotes_Query = mysql_query($CheckPlayerVotes_SQL);
$CheckPlayerVotes_Result = mysql_fetch_array($CheckPlayerVotes_Query);
/*
* Check if User has an entry in our Vote-Log Table
*/
if( $CheckPlayerVotes_Result['account_id'] == $_SESSION['user_id'] ) {
/*
* Initialize Voting variables
*/
$Player_LastVoteAt = $CheckPlayerVotes_Result['last_vote_at'];
$Player_VotesGiven = $CheckPlayerVotes_Result['votes_given'];
$Player_CoinsReceived = $CheckPlayerVotes_Result['coins_received'];
$Player_NewVoteAt = $CheckPlayerVotes_Result['new_vote_at'];
$TimeNow = time();
/*
* Check if IP is already logged and can vote
*/
$IPCheck = false;
$PlayerIP = $_SERVER['REMOTE_ADDR'];
$PlayerIPCheck_SQL = "SELECT * FROM account.account_vote_ip WHERE ip = '$PlayerIP'";
$PlayerIPCheck_Query = mysql_query($PlayerIPCheck_SQL);
$PlayerIPCheck_Result = mysql_fetch_array($PlayerIPCheck_Query);
$VoteExpire = $PlayerIPCheck_Result['vote_expire'];
if( mysql_num_rows($PlayerIPCheck_Query) <= 0 ) {
$InsertIPLogEntry_SQL = "INSERT INTO account.account_vote_ip (ip, vote_expire) VALUES ('$PlayerIP', '0')";
$InsertIPLogEntry_Query = mysql_query($InsertIPLogEntry_SQL);
$VoteExpire = 0;
}
if( $TimeNow >= $VoteExpire ) {
$IPCheck = true;
} else {
$IPCheck = false;
}
/*
* Check if Player is allowed to vote
*/
if( $TimeNow >= $Player_NewVoteAt and $IPCheck == true ) {
/*
* Check if User has clicked on the Link
*/
if( $VoteLinkClick == true and $IPCheck == true ) {
/*
* Initialize new Vote-Log entry
*/
$VoteBonusCoins = 500;
$NewVoteAt_Time = $TimeNow + 60*60*24;
$LastVoteAt_Time = $TimeNow;
$Player_VotesGiven += 1;
$NewCoinsAmount = $Player_CoinsReceived + $VoteBonusCoins;
$NewVoteLog_SQL = "UPDATE account.account_votes
SET last_vote_at = '$LastVoteAt_Time',
votes_given = '$Player_VotesGiven',
coins_received = '$NewCoinsAmount',
new_vote_at = '$NewVoteAt_Time'
WHERE account_id = '".$_SESSION['user_id']."'";
$IPLog_SQL = "UPDATE account.account_vote_ip
SET vote_expire = '$NewVoteAt_Time'
WHERE ip = '$PlayerIP'";
/*
* Initialize Player Coins + Bonus for Voting
*/
$GetPlayerCoins_SQL = "SELECT coins FROM account.account WHERE id = '".$_SESSION['user_id']."'";
$GetPlayerCoins_Query = mysql_query($GetPlayerCoins_SQL);
$GetPlayerCoins_Result = mysql_fetch_array($GetPlayerCoins_Query);
$PlayerCoins = $GetPlayerCoins_Result['coins'] + 75;
$PlayerNewCoins_SQL = "UPDATE account.account
SET coins = $PlayerCoins
WHERE id = '".$_SESSION['user_id']."'";
/*
* Update Database entries
*/
mysql_query($NewVoteLog_SQL);
mysql_query($PlayerNewCoins_SQL);
mysql_query($IPLog_SQL);
$EnableVotePage = false;
$ShowMSG = true;
$SuccessMSG .= "Du wirst in kürze deine Coins erhalten, sobald du gevoted hast.<br>";
/*
* Redirect User to Vote Page
*/
?>
<script type="text/javascript" language="javascript">
<!--
window.location.href = '<? echo $VotePage; ?>';
//-->
</script>
<?
exit;
} else {
$EnableVotePage = true;
}
} else {
$EnableVotePage = false;
}
}
if( $EnableVotePage == true ) {
?>
<p class="meldung">
Für jeden Vote bekommst du eine Gutschrift von DEINE COINS Coins. <br>
Missbrauch dieser Funktion wird ein permanenter Bann zur folge haben! <br>
</p>
<p>Um voten zu können, klicke auf dem folgenden link:
<a href="<? echo $_SERVER['PHP_SELF']; ?>?s=vote&f=true">Vote!</a></p>
<?
} else {
if( $ShowMSG == true ) {
echo "<p>$SuccessMSG</p>";
} else {
echo "<p>Du kannst nur alle 24 Stunden voten!</p>";
echo "<br>";
if( $Player_NewVoteAt > 0 ) {
echo "<div align=\"center\">Du kannst wieder um ". date("d.m.Y H:i:s", $Player_NewVoteAt) ." Server Zeit voten.</div>";
}
}
}
} else {
echo'<p class="meldung">Das Voten steht nur angemeldeten Spielers zur verfügung.</p>';
}
?>
Homepage Fehler anzeige;
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/customers/webs/ni48500_1/pages/vote.php on line 21 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /var/customers/webs/ni48500_1/pages/vote.php on line 35 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/customers/webs/ni48500_1/pages/vote.php on line 37
 |
