![[S]Jemand der mit ne MySQL DB erstellen kann](https://www.elitepvpers.com/forum/iconimages/elite-gold-trading/s-jemand-der-mit-ne-mysql-db-erstellen-kann_ltr.gif){kind=small}
suche jemanden der mir ne MySQL DB erstellen kann, da ich das backup davon verloren habe.
Script ist vorhanden:
PHP Code:
<div id="content_top">Vote 4 Coins</div>
<div id="content_main">
<?
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
/*
* Vote Page
*/
$VotePage = "#";
/*
* 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 = 0;
$NewVoteAt_Time = $TimeNow + 60*60*20;
$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'] + 250;
$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 250 Coins. <br>
</p>
<a href="index.php?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'Sie müssen für diesen Bereich angemeldet sein.';
}
?>
</div>
<div id="content_footer"></div>
