[RELEASE] Secure PHP Web Registration Script

[STIV123]

I have a problem with this. I do all as i should do, on the end that happens is i make an account, click "Create game Account" It loads to BLANK page. I did all good. And it doesn't make one acc either tried to log in.



If anyone have any clue would be nice

EDIT: I fixed it.

[tracker62]

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'UserUID', table 'PS_UserData.dbo.Users_Detail'; column does not allow nulls. INSERT fails. (severity 16) in C:\xampp\htdocs\teste\verify.php on line 74

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\teste\verify.php on line 74

Fatal error: Uncaught exception 'phpmailerException' with message 'SMTP Error: Could not connect to SMTP host.' in C:\xampp\htdocs\teste\PHPMailer\class.phpmailer.ph p:820 Stack trace: #0 C:\xampp\htdocs\teste\PHPMailer\class.phpmailer.ph p(705): PHPMailer->SmtpConnect() #1 C:\xampp\htdocs\teste\PHPMailer\class.phpmailer.ph p(576): PHPMailer->SmtpSend('Date: Thu, 16 A...', '--b1_bf23e3bea6...') #2 C:\xampp\htdocs\teste\mail.php(33): PHPMailer->Send() #3 C:\xampp\htdocs\teste\verify.php(80): require('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\teste\PHPMailer\class.phpmailer.ph p on line 820

[JohnHeatz]

That has been explained multiple times already, please use the search function.

[tracker62]

I did every topic I find nothing

Register email

[..Zeus..]

For All People i have Scripted the Register from Abrasive (the style looks very better) When you intressting PM ME i can send you

[Sky4story]

Hi, I have erro , I did everything right, and says Database Connect Error, Can you help?

[deadly.pro]

What's this? It comes in creating account

MSSQL functions non existant!
ODBC functions existing...and connections are possible!
PHP version: 5.5.9
Account Registration

[deadly.pro]

Can anyone tell me where my mistake


USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 03/20/2014 21:59:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** Object: Stored Procedure dbo.usp_Try_GameLogin_Taiwan Script Date: 2008-6-7 18:34:05 ******/

/*================================================= =
@date 2007-12-04
@brief Login Proc( Taiwan )
================================================== */

ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

@UserID varchar(18),
@InPassword varchar(32),

@SessionID bigint,
@UserIP varchar(15),

-- 罹晦梱雖 ?蹂? 檣濠, 釭該雖朝 頂睡 滲熱

@UserUID int = -1,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE



@Leave tinyint,
@Status smallint,

@CompanyIP varchar(15),
@TempIP varchar(15),
@Check int,
@LeaveDate datetime

/*================================================= =
-1 Invalid ID and Password
-2 Can't connect with the account since it's not selected as free challenger
-3 Account doesn't exist
-4 ID inprocess of termination follwing user's request.
-5 Your account is blocked now. You can't log into the game.
-6 Your account is blocked now. You can't log into the game.
-7 Account still restricted
================================================== */

SET @Status = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

SELECT @UserUID=[UserUID], @Status=[Status], @Leave=[Leave], @LeaveDate=LeaveDate
FROM Users_Master
WHERE UserID = @UserID AND Pw = @InPassword

-- NotExist User OR Leave User
IF( @UserUID = 0)
BEGIN
SET @Status = -3
END
ELSE IF (@Leave = 1) --This blocks a logged in account from being kicked
BEGIN
SET @Status = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)--This is the time delay
BEGIN
SET @Status = -7
END

-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
END
END
END

-- Admin IP Check(2006-02-21)
/*
IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
SET @TempIP = LEFT(@UserIP, 9)
IF( @TempIP <> @CompanyIP )
BEGIN
SET @Status = -999
END
END
*/

-- Select
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 1 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
UPDATE Users_Master SET Leave = 0, JoinDate = GETDATE() WHERE UserUID = @UserUID
END
SET NOCOUNT OFF

[blutotxonline]

good day sir. amm sir can u help me with my problem its when i online my page, the register file wont show, not like in localhost. Should i change some code when i online it sir?my host is 000webhost. what do i need to configure?

[beetols]

Originally Posted by blutotxonline

good day sir. amm sir can u help me with my problem its when i online my page, the register file wont show, not like in localhost. Should i change some code when i online it sir?my host is 000webhost. what do i need to configure?

If nobody answers is why your question have no sense!

btw not, you have not to change any code from localhost to a online website.

and if you want a valid answer please be more specific on the error/problem that you have.

[blutotxonline]

Originally Posted by beetols

If nobody answers is why your question have no sense!

btw not, you have not to change any code from localhost to a online website.

and if you want a valid answer please be more specific on the error/problem that you have.

i mean my problem sir is when i test my page to localhost the register page appears and i can register accounts i used the abrasive, but when i put in onlineweb the register page wont appear and no error message appears just wont appear the register page.. ...i add php_dll extensions on xampp's php.ini on localhost, should i add or change something too on online?

[-spAik-]

Works perfectly.

[ronbell]

Can u do a Video on Youtube its Really hard to create a Registration on P-Server plss Help

[[ADM]Festa]

sempre da erro ao cadastra