
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](20) NOT NULL,
[Paysafecard Code1] [varchar](60) NOT NULL,
[Paysafecard Code2] [varchar](60) NOT NULL,
[Paysafecard Code3] [varchar](60) NOT NULL,
[Amount] [varchar](max) NULL,
CONSTRAINT [PK_PaySafe] PRIMARY KEY CLUSTERED
(
[Paysafecard Code1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [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>