Paysafecard simple function

Results 1 to 2 of 2
  1. #1
    Account Upgraded | Title Enabled! Taxic is offline
    MemberRank
    Nov 2011 Join Date
    The NetherlandsLocation
    203Posts

    Paysafecard simple function




    I have already created a dbo.PaySafe:

    PHP Code:
    USE [GunzDB]
    GO

    /****** Object:  Table [dbo].[PaySafe]    Script Date: 12/20/2015 19:26:59 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE 
    [dbo].[PaySafe](
        [
    Username] [varchar](20NOT NULL,
        [
    Paysafecard Code1] [varchar](60NOT NULL,
        [
    Paysafecard Code2] [varchar](60NOT NULL,
        [
    Paysafecard Code3] [varchar](60NOT NULL,
        [
    Amount] [varchar](maxNULL,
     
    CONSTRAINT [PK_PaySafePRIMARY KEY CLUSTERED 
    (
        [
    Paysafecard Code1ASC
    )WITH (PAD_INDEX  OFFSTATISTICS_NORECOMPUTE  OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS  ONALLOW_PAGE_LOCKS  ONON [PRIMARY]
    ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO 

    I was trying to edit my register sql function to this one but failed many times. Can someone help me with edit this to dbo.Paysafe sql? So when player press Buy Item button that it will showup in my dbo.Paysafe? They must fill in at least 1 Paysafecard code or it will not sent to my dbo.Paysafe

    Here is the php code:

    PHP Code:
    <div class="anounce"><marquee direction="left" loop="true" width="475px"><? $sqlf->anouncement(); ?></marquee></div><div class="t">




    Buy coins

    </div>
    <div class="m">

                    <p>
                        <form action="" method="post" class="buycoins"><center>
                                <b>Username: </br><input type="text" name="username" maxlength="20" class="inputbg" onfocus="this.value=''" style="text-align:center;"/><br>
                                <b>Amount: </br><input type="text" name="amount" maxlength="20" class="inputbg" onfocus="this.type='password'; this.value='';" style="text-align:center;"/><br>
                                <b>Paysafecard Code 1: </br><input type="text" name="paysafecard1" maxlength="20" class="inputbg" onfocus="this.type='password'; this.value='';" style="text-align:center;"/><br><br>
                                <b>Paysafecard Code 2: </br><input type="text" name="paysafecard2" maxlength="20" class="inputbg" onfocus="this.type='password'; this.value='';" style="text-align:center;"/><br><br>
                                <b>Paysafecard Code 3: </br><input type="text" name="paysafecard3" maxlength="20" class="inputbg" onfocus="this.type='password'; this.value='';" style="text-align:center;"/><br><br>
                                                        <br><div id="bar">You will receive your Coins in 10 minutes.</div><br><br><br>
                               <input type="reset" value="" id="resetbtn"><input type="submit" name="buyitem" value="" class="buyitem"/><br><br>
                            </center>
                        </form>
                        <?php
                        
    if(isset($_POST['buyitem']))
                        {
                          
    $username clean_alert($_POST['username']);
                          
    $pass1    clean_alert($_POST['pass1']);
                          
    $pass2    clean_alert($_POST['pass2']);
                          
    $email    clean_alert($_POST['email']);
                          
    $captcha  clean_alert($_POST['captcha']);
                          
    $question  clean_alert($_POST['question']);
                          
    $answer  clean_alert($_POST['answer']);

                          if(
    $username != "" && $pass1 != "" && $pass2 != "" && $email != "" && $captcha != "")
                          {
                            if(
    checknl($username) && checknl($pass1) && checknl($pass2) && checknl($captcha))
                            {
                              if(
    $securimage->check($_POST['captcha']) != false)
                              {
                                if(
    $pass1 == $pass2)
                                {
                                  if(
    $sqlf->checkrow("SELECT * FROM Account WHERE UserID = '".$username."'") == false)
                                  {
                                    if(
    $sqlf->checkrow("SELECT * FROM Account WHERE Email = '".$email."'") == false && eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,4})$"$email))
                                    {
                                      
    mssql_query("DECLARE [MENTION=78370]Aidid[/MENTION]ent int INSERT INTO Account (UserID,UGradeID,PGradeID,Name,RegDate,Email,Coins,eCoins,pCoins,question,answer) VALUES ('".$username."',0,0,'',GETDATE(),'".$email."',0,0,0,'".$question."','".$answer."') SET [MENTION=78370]Aidid[/MENTION]ent = @@IDENTITY INSERT INTO Login (UserID,AID,Password) VALUES ('".$username."' [MENTION=78370]Aidid[/MENTION]ent,'".$pass2."')");
                                      echo 
    '<p class="errormsg"><font color="red">The account "'.$username.'" has been successfully made!</font></p>';
                                    }
                                    else
                                    {
                                      echo 
    '<p class="errormsg"><font color="red">This E-mail address is already in use or the E-mail address is incorrect!</font></p>';
                                    }
                                  }
                                  else
                                  {
                                    echo 
    '<p class="errormsg"><font color="red">This username is already in use!</font></p>';
                                  }
                                }
                                else
                                {
                                  echo 
    '<p class="errormsg"><font color="red">Password and confirm password are not the same!</font></p>';
                                }
                              }
                              else
                              {
                                echo 
    '<p class="errormsg"><font color="red">Captcha code is incorrect!</font></p>';
                              }
                            }
                            else
                            {
                              echo 
    '<p class="errormsg"><font color="red">Please, use only numbers and letters!</font></p>';
                            }
                          }
                          else
                          {
                            echo 
    '<p class="errormsg"><font color="red">Please fill in all of the fields!</font></p>';
                          }
                        }
              
                        
    ?>
                    </p>

    </div>
    <div class="b"></div>
    Last edited by Taxic; 20-12-15 at 07:30 PM.


  2. #2
    Account Upgraded | Title Enabled! Taxic is offline
    MemberRank
    Nov 2011 Join Date
    The NetherlandsLocation
    203Posts

    Re: Paysafecard simple function

    Can someone help me please..?



Advertisement