Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 341537" data-attributes="member: 36373">When they vote , they get redirected to a secret page, which redirects them back to client. On the secret page just few lines of code:[PHP]&lt;?php$amount = 5000;$lastTime = mysql_fetch_assoc(mysql_query(&quot;SELECT lastGiven FROM user_rewards WHERE username='&quot;.$_SESSION['user']['username'].&quot;'&quot;));if(mysql_num_rows($lastTime) &lt; 1){mysql_query(&quot;INSERT INTO user_rewards (lastGiven, username) VALUES ('&quot;.time().&quot;', '&quot;.$_SESSION['user']['username'].&quot;')&quot;);mysql_query(&quot;UPDATE users SET `credits` = (`credits` + '&quot;.$amount.&quot;') WHERE username='&quot;.$_SESSION['user']['username'].&quot;'&quot;);mysql_query(&quot;UPDATE user_rewards SET lastGiven = '&quot;.time().&quot;' WHERE username='&quot;.$_SESSION['user']['username'].&quot;'&quot;);}if((date(H, $lastTime) - time()) &gt; 23){mysql_query(&quot;UPDATE users SET `credits` = (`credits` + '&quot;.$amount.&quot;') WHERE username='&quot;.$_SESSION['user']['username'].&quot;'&quot;);mysql_query(&quot;UPDATE user_rewards SET lastGiven = '&quot;.time().&quot;' WHERE username='&quot;.$_SESSION['user']['username'].&quot;'&quot;);}header(Location: &quot;/client&quot;);?&gt;[/PHP]And Create This Table:user_rewardslastGiven -&gt; Timestamp (Length 0 , Decimal 0)username -&gt; Varchar (Length 50, Decimal 0)Okay. Rest is up to you ! This is just something I coded real fast.</blockquote>

[QUOTE="JayC, post: 341537, member: 36373"] When they vote , they get redirected to a secret page, which redirects them back to client. On the secret page just few lines of code: [PHP] <?php $amount = 5000; $lastTime = mysql_fetch_assoc(mysql_query("SELECT lastGiven FROM user_rewards WHERE username='".$_SESSION['user']['username']."'")); if(mysql_num_rows($lastTime) < 1){ mysql_query("INSERT INTO user_rewards (lastGiven, username) VALUES ('".time()."', '".$_SESSION['user']['username']."')"); mysql_query("UPDATE users SET `credits` = (`credits` + '".$amount."') WHERE username='".$_SESSION['user']['username']."'"); mysql_query("UPDATE user_rewards SET lastGiven = '".time()."' WHERE username='".$_SESSION['user']['username']."'"); } if((date(H, $lastTime) - time()) > 23){ mysql_query("UPDATE users SET `credits` = (`credits` + '".$amount."') WHERE username='".$_SESSION['user']['username']."'"); mysql_query("UPDATE user_rewards SET lastGiven = '".time()."' WHERE username='".$_SESSION['user']['username']."'"); } header(Location: "/client"); ?> [/PHP] And Create This Table: user_rewards lastGiven -> Timestamp (Length 0 , Decimal 0) username -> Varchar (Length 50, Decimal 0) Okay. Rest is up to you ! This is just something I coded real fast. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members