الموقع العربي الاول للعبة Silkroad Online

انا عندي Vote كل 1 sec عاوز اخلية كل 12 ساعة
كود PHP:

		
			
<?php

    if(isset($_SESSION['loggedin'])) {

        if(isset($_GET['action']) and ($_GET['action'] == 'final')) {

            $found = 0;

            mssql_select_db($dbName1);             

            $query = mssql_query("SELECT JID FROM TB_User WHERE StrUserID ='$_SESSION[name]'") or die("Cant connect to database!");

            while ($row = mssql_fetch_array($query)) {

                $UserJID = $row['JID'];

                mssql_select_db($dbName2);

                $query2 = mssql_query("SELECT CharID FROM _User WHERE UserJID ='$UserJID'") or die("Cant connect to database!");

                while ($row2 = mssql_fetch_array($query2)) {

                    $query3 = mssql_query("SELECT * FROM _Char WHERE CharID ='$row2[CharID]' and CurLevel >= 64") or die("Cant connect to database!");                

                    while ($row3 = mssql_fetch_array($query3)) {

                        $found++;

                    }

                }

            }

            

            if($found > 0) {

            $time_now = time();            

            $sec = new Security;

            $vote = $sec->secure($_POST['votenum']);

            $num = $_POST['image'];

            if((is_numeric($vote)) and (($vote == 1) or ($vote == 2))) {

                switch($vote) {

                    case 1:

                        $url = "http://www.xtremetop100.com/in.php?site=1132352770";

                        $p = 50;

                    break;

                    case 2:

                        $url = "http://www.gtop100.com/in.php?site=80952";

                        $p = 50;

                    break;                        

                }

            

                mssql_select_db($dbName1, $dbConn);

                $query = mssql_query("SELECT TOP 1 * FROM dbo.Vote_Log WHERE UserID = '$_SESSION[name]' AND vote_web = '$vote' ORDER BY ID DESC");            

                if($row = mssql_fetch_array($query)) {

                    if($time_now - $row['vote_time'] >=  43200) {

                        

                                mssql_query("INSERT INTO dbo.Vote_Log VALUES ('$_SESSION[name]', '$time_now', '$vote', null, '$_SERVER[HTTP_CF_CONNECTING_IP]')");

                                $getUserJID = mssql_query("select * from TB_User where StrUserID = '$_SESSION[name]'");

                                while ($row = mssql_fetch_array($getUserJID)) {

                                    $userJID = $row['JID'];                

                                }

                            

                                $silkCount = mssql_query("SELECT * FROM SK_Silk where JID = '$userJID'");

                                if(mssql_fetch_array($silkCount))

                                    mssql_query("UPDATE SK_Silk SET silk_own = silk_own + $p where JID = '$userJID'");

                                else

                                    mssql_query("INSERT INTO SK_Silk VALUES ($userJID, $p, 0, 0)");

                                    

                                header('Location:'. $url .'');

                        

                    }

                    else {

                    

                        $query = mssql_query("SELECT TOP 1 * FROM dbo.Vote_Log WHERE vote_web = '$vote' AND UserID = '$_SESSION[name]' ORDER BY ID DESC");

                        $now = time();

                        $till = ($row['vote_time'] + 43200);

                        $wait = $till - $now;

                        while ($row = mssql_fetch_array($query)) {

                            $ho = date('H', $wait);                            

                            echo "<div class='vote'>                

                                <div class='vbox' style='width:auto;height:auto;'>

                                    <h2>THERE WAS A</h2>

                                    <h3>ERROR</h3>

                                    <p style='padding:0 10px 10px 10px;'>

                                        UserID already voted for <b>Falcon - Silkcore</b> in this web.<br />

                                        You still have to wait ".$ho.":".date('i', $wait).":".date('s', $wait)." hours<br /><br />

                                    

                                        <a href='?topic=vote'>You can try voting in another web.</a>

                                    </p>

                                </div>

                            </div>";

                            /*echo '<div style="line-height:2">UserID already voted for <b>Falcon - Silkcore</b> in this web.<br />

                                You still have to wait '.$ho.':'.date('i', $wait).':'.date('s', $wait).' hours<br /><br /><a href="?topic=vote">You can try voting in another web.</a>

                            </div>';*/

                        }

                    }

                }

                else {            

                

                        mssql_query("INSERT INTO dbo.Vote_Log VALUES ('$_SESSION[name]', '$time_now', '$vote', null, '$_SERVER[HTTP_CF_CONNECTING_IP]')");

                        $getUserJID = mssql_query("select * from TB_User where StrUserID = '$_SESSION[name]'");

                        if($row = mssql_fetch_array($getUserJID)) {

                            $userJID = $row['JID'];                

                        }

                        

                        $silkCount = mssql_query("SELECT * FROM SK_Silk where JID = '$userJID'");

                        if(mssql_fetch_array($silkCount))

                            mssql_query("UPDATE SK_Silk SET silk_own = silk_own + $p where JID = '$userJID'");

                        else

                            mssql_query("INSERT INTO SK_Silk VALUES ($userJID, $p, 0, 0)");

                            

                        header('Location:'. $url .'');

                        

                }

            }

            else {

                echo "<div class='vote'>                

                    <div class='vbox' style='width:auto;height:auto;'>

                        <h2>THERE WAS A WEIRD</h2>

                        <h3>ERROR</h3>

                        <p style='padding:0 10px 10px 10px;'>Invalid voting website, please <a href='?topic=vote'>try again</a>.</p>

                    </div>

                </div>";

            }

            }

            else {

                echo "<div class='vote'>                

                    <div class='vbox' style='width:auto;height:auto;'>

                        <h2>THERE WAS A</h2>

                        <h3>ERROR</h3>

                        <p style='padding:0 10px 10px 10px;'>You need at least one character level <b>64</b> or higher to get free silk.</p>

                    </div>

                </div>";

            }

        }

        else {

            $rand = rand(1000, 9999);

            echo "<div class='vote'>

                <div class='form'>

                    <div class='vbox'>

                        <h2>CHOOSE VOTING</h2>

                        <h3>PAGE</h3>

                        <form name='form' method='post' action='?topic=vote&action=final' style='padding:10px;'> 

                            <table width='90%'>";

                            /*<tr>

                                <td><input type='text' style='width:199px; height:33px; background:url(../imgs/input2.png) 0 0 no-repeat; outline:none; border:none; color:#fff; font-size:12px; padding:0 10px; margin-bottom:14px;'></td>

                            </tr>

                            <tr>

                                <td><input type='text' style='width:199px; height:33px; background:url(../imgs/input2.png) 0 0 no-repeat; outline:none; border:none; color:#fff; font-size:12px; padding:0 10px; margin-bottom:14px;'></td>

                            </tr>*/

                            echo "<tr>

                                <td><select name='votenum' class='slct'> 

                                    <option value='1' style='magin-top:5px;'> XtremeTop100 - Get 50 Silk</option>

                                    <option value='2' style='magin-top:5px;'> GTop100 - Get 50 Silk</option>

                                </select></td>

                                <td><input type='submit' value='Vote!' class='submit'/></td>

                            </tr>

                            </table>

                            <input type='text' name='image' value='$rand' style='display:none'>

                        </form>

                    </div>

                </div>

                

                <div class='inst'>

                <b>How to get free silk every 12 hours by voting for us</b><br /><br />

                    1.1 On the select box, choose the page where you want to vote for us..<br /><br />

                    1.2 When selected, click on 'VOTE!' buttom and you will be redirected.<br /><br />

                    1.3 Once you get redirected you can vote to get your free silk.<br /><br />

                    1.4 You can only vote 1 time per page each 12 hours.

                </div>                

            </div>";

        }

    }

    else {

        echo "You need to be logged in to see this content..<br />Please write your userid and password to log in.<br />

        <a href='?topic=createacc'>Create an account</a> if you do not have one yet.<br /><br />        

        <form action='?topic=vote' method='POST'>

            <table width='65%' cellspacing='10'>

                <tr>

                    <td>User ID:</td>

                    <td><input type='text' name='username' placeholder='USERID' style='width:170px; height:33px; margin-right:11px; padding:0 10px; background:#192526; outline:none; border:solid 1px #000; float:left; color:#fff; font-size:12px;'></td>

                </tr>

                <tr>

                    <td>Password:</td>

                    <td><input type='password' name='password' placeholder='PASSWORD' style='width:170px; height:33px; margin-right:11px; padding:0 10px; background:#192526; outline:none; border:solid 1px #000; float:left; color:#fff; font-size:12px;'></td>

                </tr>

                <tr>

                    <td><font size='1px'><i><a href=?topic=manageacc&action=forgotpass><center>Lost Account?</center></a></i></font></td>

                    <td><input type='submit' name='submit' value='Submit' style='width:140px; height:33px; background:#192526; outline:none; border:none; float:left; color:#bff0f4; text-transform:uppercase; font-size:14px; text-align:center; cursor:pointer;'></td>

                </tr>

            </table>

        </form>";

    }

?>