[Help] DaoPay Claiming System

Code:

---

<?php

$tidkey = 45983;
$subkey = $_POST['subkey'];
$pin = $_POST['pin'];
echo'<b>SubKeys List:
<br>SubKey | Description
<br>
11 - a 10 USD Donation for #2! 
<br>
12 - a 5 USD donation for #2!
<br>
13 - a 15 USD donation for #2
<br>
14 - a 20 USD donation for #2
<br></br>';
    echo '<td class="alt1"><center><FORM method=post name=regform action=index.php?act=user&actu=pcheck&do=pcheck style="margin:0px; padding:0px">
        <table  width="300px">
        <tr>
        <td>DaoPay PinCode:</td>
        <td><input type="text" class="input" name="pin" value="" maxlength="21" size="20"></td>
        <tr>
        <tr>
                <td>Product SubKey:</td>
        <td><input type="text" class="input" name="subkey" value="" maxlength="21" size="20"></td>
        <tr>
        </table>
        <center><input class="input" type="submit" value="Check Pin"></center></br></br>
        </form>
        </center>
        </td>
        ';
if( isset($tidkey) && isset($subkey) && isset($pin) ){
    $handle = fopen('http://DaoPay.com/svc/pincheck?appcode='.$tidkey.'&subkey='.$subkey.'&pin='.$pin, "r");
    if( $handle ){
        $reply = fgets($handle);
        if(substr($reply, 0, 2) == "ok"){
           
$accname = ($_SESSION['sesuser']);
$dbname = "KN_online"; // Database Name
$dbuser = "knight"; // Username
$dbpass = "knight"; // Password
    $msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
    $getdonation = "SELECT Account,Pin,Subkey FROM dp_claim WHERE Account = '$accname'";
    $getexec=odbc_exec($msconnect,$getdonation) or die(odbc_error());

    while(odbc_fetch_row($getexec)) {

   
    $Pin1 = odbc_result($getexec, 2);

if ($Pin1=='$pin')

    {
        parth1('50%',4,'center');
    echo'<font color="red">This donation has already been claimed.</font>';
                   
        parth2();   
   

    } 
      else
        {

        echo'Congratulations You have received the rank: <font color="gold">Gold Member</font>!';
            $msquery="UPDATE TB_USER SET donator='1' WHERE strAccountID='$accname'";
            $mssquery="INSERT INTO dp_claim (Account, Pin, Date, Subkey  ) VALUES  ('$accname', '$pin', 'NULL', '$subkey' )";
            $msresults=odbc_exec($msconnect,$msquery);
    $msresults=odbc_exec($msconnect,$mssquery);

        if ($Subkey == "11") {
    $getknightcash = "SELECT KnightCash FROM TB_USER WHERE strAccountID = '$accname'";
    $kncash=odbc_exec($msconnect,$getknightcash) or die(odbc_error());
    odbc_fetch_row($kncash);
    $knightcash = odbc_result($kncash, 1);
    $cash = 2500;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery11 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery11);
      echo'Your account has been recharged with '.$cash.'!!';

        } elseif ($Subkey == "12") {
    $getknightcash = "SELECT KnightCash FROM TB_USER WHERE strAccountID = '$accname'";
    $kncash=odbc_exec($msconnect,$getknightcash) or die(odbc_error());
    odbc_fetch_row($kncash);
    $knightcash = odbc_result($kncash, 1);
    $cash = 1250;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery12 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery12);
echo'Your account has been recharged with '.$cash.'!!';

        } elseif ($Subkey == "13") {
    $getknightcash = "SELECT KnightCash FROM TB_USER WHERE strAccountID = '$accname'";
    $kncash=odbc_exec($msconnect,$getknightcash) or die(odbc_error());
    odbc_fetch_row($kncash);
    $knightcash = odbc_result($kncash, 1);
    $cash = 3750;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery13 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery13);
echo'Your account has been recharged with '.$cash.'!!';

    } elseif ($Subkey == "14") {
    $getknightcash = "SELECT KnightCash FROM TB_USER WHERE strAccountID = '$accname'";
    $kncash=odbc_exec($msconnect,$getknightcash) or die(odbc_error());
    odbc_fetch_row($kncash);
    $knightcash = odbc_result($kncash, 1);
    $cash = 5000;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery14 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery14);
echo'Your account has been recharged with '.$cash.'!!';


 

        }
      else
        {
echo'Subkey or Pin Invalid!';
 }
}
}
}
}
}
?>

---

This basically checks if the pin exists, and if the pin+subkey is valid. and it also adds knightcash depending on subkey.
the problem is whenever i insert for example subkey 11 and pincode: leet it automatically inserts like 8000 rows in table dp_claim. can anyone scan this script, improve it and then repost or private message it to me. Necromancer probaly leeches it for ko-cuce like last time-.-

thanks, my msn: hellish@live.nl

any help?
im not planning on letting this script *disappear* its a good php script.

This script is crap lol.

Quote:

---

This script is crap lol.

---

coming from the biggest leacher in ko. A thanks is all thats needed if its of no use to you just keep quiet.

Quote:

---

Originally Posted by spamman

This script is crap lol.

---

this guy is trying .. dont be so rude and come up with something youreself then.

so anyone can help me a bit?:S

I have come up with something myself lol. Have you seen my server? Mine works yours doesn't Don't be a prick. I was going to post mine. Wait, since i leached it as you say, I don't think I will. It must be leached, you won't want it then. Maybe I'll post how to fix /prize, nah forget it. Wait! I got it, maybe I'll post how to make a perfect power up store. One that you don't even have to login to... Wait I forgot it's prolly leached right. MY bad DAWG. You'll receive no help from me acting like a prick. I'm pro php/sql but guess you don't need help right xD

Quote:

---

Originally Posted by spamman

I have come up with something myself lol. Have you seen my server? Mine works yours doesn't Don't be a prick. I was going to post mine. Wait, since i leached it as you say, I don't think I will. It must be leached, you won't want it then. Maybe I'll post how to fix /prize, nah forget it. Wait! I got it, maybe I'll post how to make a perfect power up store. One that you don't even have to login to... Wait I forgot it's prolly leached right. MY bad DAWG. You'll receive no help from me acting like a prick. I'm pro php/sql but guess you don't need help right xD

---

hi god, can i have a cookie? no wait that cookie is leetched.
you act like youre the god of private servers

what is this daopay? hard to set up? what is required

Advocate, I think it's a way more secure way for securing donations because a lot of people are ditching PayPal and going to DaoPay O_o

daopay is just another way to accept donations. I prefer money bookers. People can't charge back you there :D. paypal is just as secure as daopay, but some people don't have cc's or anything. so they can donate via phone if they want with daopay.

@extinquisher - I'm not proclaiming myself as the "god of private servers" as you so sarcasticly put, I am simply saying that I have done my own work. My private server is the longest running server, and one of the best. I've written my own php and sql. The only php that i use that isn't mine is Gerydeft's powerup store which i recoded to work with a database, and work with the ingame P button. as well as get the forwarded accountid and character id from the client when they open the power up store. I see no other servers with these features, But Si just likes to start problems. Like when he was dosing my server with his dedicated box lol. What a joke. I called his hosters and they pulled the plug lols xD. I don't see why you hate me Si. Props on your web design skills Si. Your "OurKO" website looks mighty fine. how much did you buy that server for? lol. You bought out Hell Awaits Ko cuz KnightsTemplar sucked. I'm assuming you turned HAKO to shit, and you had to buy some1 else's server again lol.

Quote:

---

Originally Posted by spamman

daopay is just another way to accept donations. I prefer money bookers. People can't charge back you there :D. paypal is just as secure as daopay, but some people don't have cc's or anything. so they can donate via phone if they want with daopay.

@extinquisher - I'm not proclaiming myself as the "god of private servers" as you so sarcasticly put, I am simply saying that I have done my own work. My private server is the longest running server, and one of the best. I've written my own php and sql. The only php that i use that isn't mine is Gerydeft's powerup store which i recoded to work with a database, and work with the ingame P button. as well as get the forwarded accountid and character id from the client when they open the power up store. I see no other servers with these features, But Si just likes to start problems. Like when he was dosing my server with his dedicated box lol. What a joke. I called his hosters and they pulled the plug lols xD. I don't see why you hate me Si. Props on your web design skills Si. Your "OurKO" website looks mighty fine. how much did you buy that server for? lol. You bought out Hell Awaits Ko cuz KnightsTemplar sucked. I'm assuming you turned HAKO to shit, and you had to buy some1 else's server again lol.

---

thats all well and good if you did evrything youreself. but if you don't want to share it dont openly brag about it that way.

and to all you people who say 'omg this is a leetcher and zomg he leetched evrything'
what do you understand under leetching? if one guy puts a file or fix on the internet and one guy gets serveral fixes together and starts his server you call that a leetcher? files/fixes put on the internet and being used is not really leetching and if it is evryone is one
but this is just going offtopic

Code:

---

<?php

$tidkey = 45983;
$subkey = $_POST['subkey'];
$pin = $_POST['pin'];
echo'<b>SubKeys List:
<br>SubKey | Description
<br>
11 - a 10 USD Donation for #2! 
<br>
12 - a 5 USD donation for #2!
<br>
13 - a 15 USD donation for #2
<br>
14 - a 20 USD donation for #2
<br></br>';
    echo '<td class="alt1"><center><FORM method=post name=regform action=index.php?act=user&actu=pcheck&do=pcheck style="margin:0px; padding:0px">
        <table  width="300px">
        <tr>
        <td>DaoPay PinCode:</td>
        <td><input type="text" class="input" name="pin" value="" maxlength="21" size="20"></td>
        <tr>
        <tr>
                <td>Product SubKey:</td>
        <td><input type="text" class="input" name="subkey" value="" maxlength="21" size="20"></td>
        <tr>
        </table>
        <center><input class="input" type="submit" value="Check Pin"></center></br></br>
        </form>
        </center>
        </td>
        ';
if( isset($tidkey) && isset($subkey) && isset($pin) ){
    $handle = fopen('http://DaoPay.com/svc/pincheck?appcode='.$tidkey.'&subkey='.$subkey.'&pin='.$pin, "r");
    if( $handle ){
        $reply = fgets($handle);
        if(substr($reply, 0, 2) == "ok"){
           
$accname = ($_SESSION['sesuser']);

    $msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
    $getdonation = "SELECT count(*)from dp_claim where pin = '$pin'";
    $getexec=odbc_exec($msconnect,$getdonation) or die(odbc_error());
        $errorlog_report="U2NyaXB0ZWQgdG8gYWN0dWFsbHkgd29yayBieSBKb25ueS4=";
        $error=base64_decode($errorlog_report);
    while(odbc_fetch_row($getexec)) {
    $Pin1 = odbc_result($getexec, 1);
        }

//See if the pin already exists
if (($Pin1)>0)

    {
        parth1('50%',4,'center');
    echo'<font color="red">This donation has already been claimed.</font>';
                        die();//add a die(); function. Ends the script.
        parth2();   
   
    } 
      else
        {
        echo'Congratulations You have received the rank: <font color="gold">Gold Member</font>!';
            $msquery="UPDATE TB_USER SET donator='1' WHERE strAccountID='$accname'";
            $mssquery="INSERT INTO dp_claim (Account, Pin, Date, Subkey  ) VALUES  ('$accname', '$pin', 'NULL', '$subkey' )";
            $msresults=odbc_exec($msconnect,$msquery);
    $msresults=odbc_exec($msconnect,$mssquery);
        //Only seelct Knight Cash 1 time. Speeds up script a little.
    $getknightcash = "SELECT KnightCash FROM TB_USER WHERE strAccountID = '$accname'";
    $kncash=odbc_exec($msconnect,$getknightcash) or die(odbc_error());
    odbc_fetch_row($kncash);
    $knightcash = odbc_result($kncash, 1);
       
        if (($Subkey) == "11") {
    $cash = 2500;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery11 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery11);
      echo'Your account has been recharged with '.$cash.'!!';
          die($error);

        } elseif ((($Subkey)  == "12") {
    $cash = 1250;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery12 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery12);
echo'Your account has been recharged with '.$cash.'!!<br>';
die($error);

        } elseif (($Subkey) == "13") {
    $cash = 3750;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery13 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery13);
echo'Your account has been recharged with '.$cash.'!! <br>';
die($error);

    } elseif (($Subkey) == "14") {
    $cash = 5000;
    $NewKnightCash = $knightcash + $cash;
    $KCQuery14 = "UPDATE TB_USER SET KnightCash = '".$NewKnightCash."' WHERE strAccountID = '$accname'";
      $msresults=odbc_exec($msconnect,KCQuery14);
echo'Your account has been recharged with '.$cash.'!!<br>';
die($error);
        }
      else
        {
echo'Subkey or Pin Invalid!';
die($error);
 }
}
}
}
}
?>

---

Try that.

thanks so much, it works:p

Code:

---

$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
    $getdonation = "SELECT Account,Pin,Subkey FROM dp_claim WHERE Account = '$accname'";
    $getexec=odbc_exec($msconnect,$getdonation) or die(odbc_error());

    while(odbc_fetch_row($getexec)) {

   
    $Pin1 = odbc_result($getexec, 2);

if ($Pin1=='$pin')

    {
        parth1('50%',4,'center');
    echo'<font color="red">This donation has already been claimed.</font>';
                   
        parth2();   
   

    }

---

that was a major mistake. what you did there was select 1 row from the table where the claiming account = the account in db. in reality you should do a count(*) check to see if the pin already exists at all. if it does die();. Done. btw, keep my creditz plx XD

someone with general knowledge of daopay could help me get it set up never mess with it before.

Quote:

---

Originally Posted by spamman

I see no other servers with these features, But Si just likes to start problems.

---

We have those features. :2gunsfiring_v1:

iceman, I didn't know you guys set that up. I thought you had to login when you opened your power up store : P. I'm just bashing Si in that post because he buys successful servers and turns them to crap lol. He has skills, I will be the first to admit that, but he's using them in all the wrong ways xD. Not to mention a total prick.