[Release] Email Verification Registration & Password Change

[Hazious]

I've reworked the of this registration and changed it from mssql to sqlsrv also created a secure way to change your password via email verification.

To use this, add it to your web server, and navigate to register.php. You must first add a table to your database, and edit config.php to add your SMTP User/Pass. As of now, I currently use PHPMailer, and have it configured to use gmail. You can edit this if you wish.

You must edit these variables in config.php:

PHP Code:

// Database configuration parameters
$db_host = "127.0.0.1"; // Your database host
$db_user = "Shaiya"; // Your database username
$db_pass = "Shaiya123"; // Your database password

// Server URL and Script Directory
$url = "http://127.0.0.1/Register/";

// Configuration for email (Configured for gmail currently)
$smtp_user = ""; //Your gmail email | ex. 
$smtp_pass = "Shaiya123"; //Your gmail password
$reply_to_email = ""; //Email players can reply to
$reply_to_name = "Shaiya Server"; //Can be your server's name 


After doing that, add this table to your database:

PHP Code:

USE [PS_UserData] 
GO 
/****** Object:  Table [dbo].[User_Verification]    Script Date: 01/24/2012 13:40:58 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[User_Verification]( 
    [UserID] [varchar](18) NOT NULL, 
    [VerifyKey] [varchar](max) NOT NULL,
    [email] [varchar](max) NOT NULL,
    [RegisterDate] [datetime] NOT NULL CONSTRAINT [DF_User_Verification_RegisterDate]  DEFAULT (getdate()), 
    [VerifiedDate] [datetime] NULL, 
    [isVerified] [bit] NOT NULL CONSTRAINT [DF_User_Verification_isVerified]  DEFAULT ((0)) 
) ON [PRIMARY] 

GO 
SET ANSI_PADDING OFF 


I know it's not perfect but feel free to make changes.

If you find any bugs, or have any comments, I'll be glad to know.

[[Admin]Slice]

delete

[AxelMac]

This script is of a other, please delete it -.-'

[[Admin]Slice]

Originally Posted by AxelMac

This script is of a other, please delete it -.-'

read the post, he mentioned that he edited the other script, changed it to sqlsrv and some other things. please read before u judge.-.

[AxelMac]

Originally Posted by [Admin]Slice

read the post, he mentioned that he edited the other script, changed it to sqlsrv and some other things. please read before u judge.-.

it's not is changed...