Vote 4 Coins

~~Ielinque~~ · 05/27/2012, 21:15

Gute abend , liebe com..

Könnt ihr mir bitte sagen wieso das nicht funktioniert??

PHP Code:


			
<div id="content">            <div class="postui2 text-title">

                    <h2>

                  Vote

                    

                    </h2>

</div>

                <div class="postui2 text-con">

                <div class="con-wrap">

<?PHP

  if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {

?>

<?php



class Vote

{



    ## Edit the info to your liking

    

    var $config = array(

        'db_host'        =>    '5.5.131.100',

        'db_user'        =>    'root',

        'db_pass'        =>    'meinpw',

        'db_database'    =>    'account',

        ## Wie viele Stunden müssen die Spieler warten bis sie wieder Voten können ?

        'vote_int'       =>    24,

        ## Wie Viel Coins bekommt man fürs Voten ?

        'vote_points'    =>    1000

    );

    

    

    public function __construct()

    {

        $connect = mysql_connect($this->config['db_host'], $this->config['db_user'], $this->config['db_pass']);

        

        if(!$connect)

            die(mysql_error());

            

        $db = mysql_select_db($this->config['db_database'], $connect);

        

        if(!$db)

            die(mysql_error());

        

    }



  

    

    public function do_vote()

    {

        $name = mysql_real_escape_string($_POST['name']);

        



            $fetch = mysql_query("SELECT * FROM `account` WHERE `login` LIKE '".$_SESSION['user_name']."'" . "LIMIT 1") or die(mysql_error());

            $get = mysql_fetch_array($fetch);

            

        

            

            if((time() - $get['lastvote']) < (3600 * $this->config['vote_int']) && $get['lastvote'] != 0)

            {

                $hours_left = round((((($get['lastvote'] + (3600 * $this->config['vote_int'])) - time()) / 3600)), 0);

                die('Du kanns er wieder in '.$hours_left.' stunden Voten!.');

            }

            

            else

            {

                mysql_query("UPDATE `account` SET `coins` = (`coins` + ".$this->config['vote_points']."), `lastvote` = '".time()."' WHERE `login` LIKE '".$_SESSION['user_name']."' LIMIT 1") or die(mysql_error());

?>





<meta http-equiv="refresh" content="2;url=http://votelink/">





<?php

                echo "Sie werden jetzt zur Vote seite weitergeleitet ...";

                

            }

        

        

    }

    

    public function vote_forms()

    {

        if(!isset($_POST['submit']))

        {

            echo "

                <span style='color: red; font-weight: bold;'>Du bekommst Coins fuer jeden Vote! (Alle 12 Stunden)</span><br /><br>Das Voten mit mehreren Accounts wird mit einer Account-Sperre bestraft.<br /><br />die Coins werden erst nach dem Voten gutgeschrieben.<br>

                <form method='post' action=''>

                    <input type='submit' name='submit' value='Vote!' />

                </form>

            ";

            

        }

        else

        {

            $this->do_vote();

        }

    }

}

?>

<?php



$vote = new Vote();

$vote->vote_forms();

?> 

<?php

$str = 'PHA+IDxwPg==';

echo base64_decode($str);

?>

<?PHP

  }

  else {

    echo'<p class="meldung">Sie müssen für diesen Bereich angemeldet sein.</p>';

  }

?>

</div> 

                <div class="postui2 text-end">

             

                

                  

    </div></div>

Aze /.. · 05/27/2012, 21:29

Was genau funktioniert daran nicht?

~~Ielinque~~ · 05/27/2012, 21:32

Wenn man auf vote 4 coins dann auf der xammp hp drück kommt folgendes.

Spoiler

#push

~~DerMitDerSense~~ · 05/28/2012, 09:38

PHP Code:


			
<div id="content_top">

Vote 4 Coins

</div>

<div id="content_main">

<div style="width:480px;">

<font color="white">

<?



if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {

    

    /*

     * Vote Page

     */

    $VotePage = "http://www.topliste.****************/In/8000-darknight2-de.htm";

    

    /*

     * 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        = 100;

                $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'] + 500;

                

                $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:</p>

<br>

<a href="<? echo $_SERVER['PHP_SELF']; ?>?s=vote&f=true"><img src="./img/vote.png" alt="Vote 4 Coins"></a>

<?

    } 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>';

}



?>

 </div>

</div>

<div id="content_footer"><br><br>

</div>

nimm das dan kommste da rein und es geht

DarkPlugin · 05/28/2012, 14:01

Quote:

Originally Posted by [ST]Hydra

Gute abend , liebe com..

Könnt ihr mir bitte sagen wieso das nicht funktioniert??

PHP Code:

'db_host' => '5.5.131.100', 'db_user' => 'root', <-------- 'db_pass' => 'meinpw', <--------- 'db_database' => 'account',

hast vergessen anzupassen

und musst die query noch einfügen

Code:

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `vote`
-- ----------------------------
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `vote` (
  `account` varchar(13) NOT NULL DEFAULT '0',
  `ip` varchar(30) NOT NULL DEFAULT '0',
  `times` bigint(20) unsigned NOT NULL DEFAULT '0',
  `Site0` int(11) DEFAULT NULL,
  `Site1` int(11) DEFAULT NULL,
  `Site2` int(11) DEFAULT NULL,
  `Site3` int(11) DEFAULT NULL,
  `Site4` int(11) DEFAULT NULL,
  `Site5` int(11) DEFAULT NULL,
  PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

~~Ielinque~~ · 05/28/2012, 15:09

Spoiler

Verstehe ich nicht

Vote? --->

Spoiler

PHP Code:


			
<div id="content_top">
Vote 4 Coins
</div>
<div id="content_main">
<div style="width:480px;">
<font color="white">
<?

if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
    
    /*
     * Vote Page
     */
    $VotePage = "http://www.topliste.****************/In/8000-darknight2-de.htm";
    
    /*
     * 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        = 100;
                $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'] + 500;
                
                $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:</p>
<br>
<a href="<? echo $_SERVER['PHP_SELF']; ?>?s=vote&f=true"><img src="./img/vote.png" alt="Vote 4 Coins"></a>
<?
    } 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>';
}

?>
 </div>
</div>
<div id="content_footer"><br><br>

Geht imme noch nicht :/

DarkPlugin · 05/28/2012, 16:24

geh in navicat in die db account mach ne neue query und hau das rein :

Code:

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `vote`
-- ----------------------------
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `vote` (
  `account` varchar(13) NOT NULL DEFAULT '0',
  `ip` varchar(30) NOT NULL DEFAULT '0',
  `times` bigint(20) unsigned NOT NULL DEFAULT '0',
  `Site0` int(11) DEFAULT NULL,
  `Site1` int(11) DEFAULT NULL,
  `Site2` int(11) DEFAULT NULL,
  `Site3` int(11) DEFAULT NULL,
  `Site4` int(11) DEFAULT NULL,
  `Site5` int(11) DEFAULT NULL,
  PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

und in der vote.php musst du noch deine daten anpassen

~~Ielinque~~ · 05/28/2012, 17:19

Da gibts doch keine daten zum anpassen

DarkPlugin · 05/28/2012, 18:52

doch dasda -.-

Code:

        'db_host'        =>    '5.5.131.100',
        'db_user'        =>    'root', <--------
        'db_pass'        =>    'meinpw',    <---------
        'db_database'    =>    'account',