I've reworked the [Only registered and activated users can see links. Click Here To Register...] 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:
After doing that, add this table to your database:
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.
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 = "[Only registered and activated users can see links. Click Here To Register...]"; //Your gmail email | ex. [Only registered and activated users can see links. Click Here To Register...]
$smtp_pass = "Shaiya123"; //Your gmail password
$reply_to_email = "[Only registered and activated users can see links. Click Here To Register...]"; //Email players can reply to
$reply_to_name = "Shaiya Server"; //Can be your server's name
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
If you find any bugs, or have any comments, I'll be glad to know.
