ich habe ein Problem mit dem Vote 4 Coins Script von .Tobias, ich verstehe
nicht wo ich die MySQL Daten eingeben soll. Schließlich muss er sich doch mit
der Datenbank verbinden. Bitte ich brauch Hilfe
Mit API Key undso komme ich klar
PHP Code:
<script language="JavaScript" type="text/javascript">
function popup(url) {
w = window.open(url, "", "toolbar=0, scrollbars=1, location=0, statusbar=0, menubar=0, resizable=1, width=900, height=900, left = 740, top = 275");
}
</script>
<?php
if(isset($_SESSION['user_id']))
{
mysql_select_db("account");
$zeit = time();
$ip = $_SERVER['REMOTE_ADDR'];
$date_now = time();
$date_tommorrow = $date_now + 86400;
$getInfos = mysql_fetch_assoc(mysql_query("SELECT last_ip, coins, last_vote, vote_free FROM account.account WHERE id='".$_SESSION['user_id']."'"));
$search_ip = mysql_query("SELECT last_vote FROM account.account WHERE last_ip='".$getInfos['last_ip']."'");
if(($getInfos['vote_free'] <= $date_now) || $getInfos['last_vote'] == "")
{
if(isset($_POST['v4c']) && $_POST['v4c']=="Vote 4 Coins")
{
$ID='xxxxx';
$API_KEY='xxxxxxxxx';
$REQUEST='stats';
$topl_curl = curl_init();
curl_setopt($topl_curl, CURLOPT_URL,
'http://www.topliste.*****************/api?id=' . urlencode($ID) .
'&request=' . urlencode($REQUEST));
curl_setopt($topl_curl, CURLOPT_HEADER, 0);
curl_setopt($topl_curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($topl_curl, CURLOPT_HTTPHEADER, array('X_APIKEY: ' . $API_KEY));
$topl_data=curl_exec($topl_curl);
$topl_info=curl_getinfo($topl_curl);
if (!curl_errno($topl_curl))
{
if ($topl_info['http_code'] == 200)
{
$Data=json_decode($topl_data, true);
//echo $Data["unq_in_0_weekly"]."</br>";
}
else
{
echo $topl_data;
}
}
else
{
echo 'Curl error: ' . curl_error($topl_curl);
}
curl_close($topl_curl);
$sql = "UPDATE account.vote4coins2 SET actualVotes = ".$Data["unq_in_0_weekly"]."";
$sqlCmd = mysql_query($sql);
}
if(isset($_POST['v4p']) && $_POST['v4p']=="Prüfen")
{
$ID='683';
$API_KEY='60ea4e59c849f85';
$REQUEST='stats';
$topl_curl = curl_init();
curl_setopt($topl_curl, CURLOPT_URL,
'http://www.topliste.*****************/api?id=' . urlencode($ID) .
'&request=' . urlencode($REQUEST));
curl_setopt($topl_curl, CURLOPT_HEADER, 0);
curl_setopt($topl_curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($topl_curl, CURLOPT_HTTPHEADER, array('X_APIKEY: ' . $API_KEY));
$topl_data=curl_exec($topl_curl);
$topl_info=curl_getinfo($topl_curl);
if (!curl_errno($topl_curl))
{
if ($topl_info['http_code'] == 200)
{
$Data2=json_decode($topl_data, true);
//echo $Data2["unq_in_0_weekly"]."</br>";
}
else
{
echo $topl_data;
}
}
else
{
echo 'Curl error: ' . curl_error($topl_curl);
}
curl_close($topl_curl);
$sql = "SELECT actualVotes FROM account.vote4coins";
$sqlCmd = mysql_query($sql);
$ergebnis = mysql_fetch_array($sqlCmd);
$dataPrüf = $ergebnis['actualVotes'] + 1;
if($Data2["unq_in_0_weekly"] > $dataPrüf)
{
$sql2 = "UPDATE account.vote4coins SET actualVotes = ".$Data2["unq_in_0_weekly"]."";
$sqlCmd2 = mysql_query($sql2);
//VOTE 4 COINS
mysql_select_db("account");
$zeit = time();
$ip = $_SERVER['REMOTE_ADDR'];
$QueryFix = mysql_query("UPDATE account.account SET last_ip='5' WHERE vote_free<='$zeit'");
$Update22 = mysql_query("UPDATE account.account SET last_ip='$ip' WHERE id='".$_SESSION['user_id']."'");
$coins = 200;
$date_now = time();
$date_tommorrow = $date_now + 86400;
$getInfos = mysql_fetch_assoc(mysql_query("SELECT last_ip, coins, last_vote, vote_free FROM account.account WHERE id='".$_SESSION['user_id']."'"));
$search_ip = mysql_query("SELECT last_vote FROM account.account WHERE last_ip='".$getInfos['last_ip']."'");
$new_coins = $getInfos['coins'] + $coins;
if(($getInfos['vote_free'] <= $date_now) || $getInfos['last_vote'] == "") {
if((mysql_num_rows($search_ip) == 1) || ($getInfos['last_ip'] == 5) || $getInfos['last_ip'] == ""){
$ip = $_SERVER['REMOTE_ADDR'];
$Update = mysql_query("UPDATE account.account SET last_ip='$ip' WHERE id='".$_SESSION['user_id']."'");
$Update2 = mysql_query("UPDATE account.account SET last_vote='$date_now' WHERE id='".$_SESSION['user_id']."'");
$Update3 = mysql_query("UPDATE account.account SET vote_free='$date_tommorrow' WHERE id='".$_SESSION['user_id']."'");
$Update4 = mysql_query("UPDATE account.account SET coins='$new_coins' WHERE id='".$_SESSION['user_id']."'");
if($Update4) {
echo'<p>Du hast erfolgreich gevotet !</p>';
//echo '<meta http-equiv="refresh" content="1; url=http://www.topliste.*****************/in/2-utopiamt2-com.html" />';
}
else {
echo'<p>Es ist ein Fehler aufgetreten</p>';
}
}
else {
echo'<h2>Man darf pro Ip nur 1x Voten !</h2>';
echo'<p>Man darf pro IP nur 1x am Tag Voten</h2>';
}
}
else {
echo'<h2>Es ist noch nicht Zeit!</h2>';
echo'<p>Du hast noch keine 24 Stunden seit deinem letzen Vote gewartet.</p>';
$wait = $getInfos['vote_free'] - $date_now;
$wait = $wait / 3600;
$waits = 24 - $wait;
$timemin = 60 / substr($waits,0,1);
echo'<p>Du musst noch '.substr($wait,0,2).' Stunden warten.</p>';
}
}
else
{
echo '<font color="red">Du hast nicht Gevotet !</font>';
echo '</br>';
}
}
?>
Anleitung:</br>
1) Klicke auf Vote 4 Coins und Vote !</br>
2) Klicke auf Prüfen und erhalte deine Coins !
<form action="index.php?s=vote4coins" method="POST">
<?PHP if(!isset($_POST['v4c'])){?>
<input type="submit" name="v4c" value="Vote 4 Coins" target="_blank" onClick="javascript:popup('http://www.topliste.*****************/in/LINK');">
<?PHP } ?>
<?PHP if(isset($_POST['v4c']) && $_POST['v4c']=="Vote 4 Coins"){?>
<input type="submit" name="v4p" value="Prüfen">
</br>Kein Vote Fenster ? <a href="http://www.topliste.*****************/in/LINK" target="new" >Klick</a>
<?PHP
}
}
else
{
echo'<h2>Man darf pro Ip nur 1x Voten !</h2>';
echo'<p>Man darf pro IP nur 1x am Tag Voten</h2>';
}
}
else
{
echo 'Du bist nicht eingeloggt !';
}
?>
</form>
