Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 06:08

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release]Email Verification Registration

Discussion on [Release]Email Verification Registration within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old 08/14/2015, 13:43   #31
 
elite*gold: 0
Join Date: Jul 2009
Posts: 330
Received Thanks: 81
Fatal error: Uncaught exception 'phpmailerException' with message 'SMTP Error: Could not authenticate.' in C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php:814 Stack trace: #0 C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php(705): PHPMailer->SmtpConnect() #1 C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php(576): PHPMailer->SmtpSend('Date: Fri, 14 A...', '--b1_904c41f5f2...') #2 C:\xampp\htdocs\Register\verify.php(69): PHPMailer->Send() #3 {main} thrown in C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php on line 814



Big_ is offline  
Old 08/14/2015, 18:53   #32
 
elite*gold: 0
Join Date: Jan 2013
Posts: 439
Received Thanks: 535
Quote:
Originally Posted by Big_ View Post
Fatal error: Uncaught exception 'phpmailerException' with message 'SMTP Error: Could not authenticate.' in C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php:814 Stack trace: #0 C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php(705): PHPMailer->SmtpConnect() #1 C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php(576): PHPMailer->SmtpSend('Date: Fri, 14 A...', '--b1_904c41f5f2...') #2 C:\xampp\htdocs\Register\verify.php(69): PHPMailer->Send() #3 {main} thrown in C:\xampp\htdocs\Register\PHPMailer\class.phpmailer .php on line 814
Check with your host. Perhaps port 587 is blocked.

thanks google


beetols is offline  
Old 08/15/2015, 00:11   #33
 
elite*gold: 0
Join Date: Jul 2009
Posts: 330
Received Thanks: 81
ok thanx
Big_ is offline  
Old 02/11/2016, 23:44   #34
 
elite*gold: 0
Join Date: Jun 2013
Posts: 5
Received Thanks: 0
Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'UserUID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails. (severity 16) in C:\wamp\www\register\verify.php on line 63

Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\register\verify.php on line 63

Fatal error: Uncaught exception 'phpmailerException' with message 'Invalid address: your reply to email' in C:\wamp\www\register\PHPMailer\class.phpmailer.php :462 Stack trace: #0 C:\wamp\www\register\PHPMailer\class.phpmailer.php (440): PHPMailer->AddAnAddress('ReplyTo', 'your reply to e...', 'your name/serve...') #1 C:\wamp\www\register\mail.php(16): PHPMailer->AddReplyTo('your reply to e...', 'your name/serve...') #2 C:\wamp\www\register\verify.php(68): require_once('C:\wamp\www\register...') #3 {main} thrown in C:\wamp\www\register\PHPMailer\class.phpmailer.php on line 462


SaviorAngel is offline  
Old 03/20/2016, 01:04   #35
 
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 0
Quote:
Originally Posted by RebeccaBlack View Post
*Note to the mods before I begin* I know I have a previous thread relating to this exact (almost) thing []. But I thought I should make a new thread for it, as the old one was made when I was a horrible PHP developer (not saying I'm good now, just better than I was) and it's highly inefficient and should be forgotten about.


I just finished reworking this registration that I had made awhile back when I was first learning PHP. I cleaned up a lot of it, and made it overall more efficient, though probably not as efficient as most people on here could do.

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

//Configuration for email (Configured for gmail currently)
$smtp_user ""//Your gmail email | ex. 
$smtp_pass "yourpassword"//Your gmail password
$reply_to_email "your reply to email"//Email players can reply to
$reply_to_name "your name/server's name"//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](18NOT NULL,
    [
VerifyKey] [varchar](maxNOT NULL,
    [
RegisterDate] [datetimeNOT NULL CONSTRAINT [DF_User_Verification_RegisterDate]  DEFAULT (getdate()),
    [
VerifiedDate] [datetimeNULL,
    [
isVerified] [bitNOT NULL CONSTRAINT [DF_User_Verification_isVerified]  DEFAULT ((0))
ON [PRIMARY]

GO
SET ANSI_PADDING OFF 

I hope you enjoy this script, and it all works well for you. I've tested it and it works. What it does, is register the user with a status of -5 (one of the various banned status'), then adds the UserID/VerifyKey to the table you insert into your database. Once the user goes to his email, and clicks the link, it checks if the key exists, and hasn't been used (so the same key can't be used twice for the same user, so the user can't use it to unban his account if he's naughty). If the key is found, it'll show the key as verified in the new table and set the user as a normal user.

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


and I would like it and if you can help me because I am not conceguindo ussar your cadatro of the page always menssagen.
sepuder make video showing how un to me and the other members would appreciate much for his work and very good.
I thank you and look forward.

my email is




Warning: mssql_query() [function.mssql-query]: message: There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. (severity 15) in C:\wamp\www\Register\verify.php on line 63

Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\Register\verify.php on line 63

Fatal error: Uncaught exception 'phpmailerException' with message 'Invalid address: bem vindo' in C:\wamp\www\Register\PHPMailer\class.phpmailer.php :462 Stack trace: #0 C:\wamp\www\Register\PHPMailer\class.phpmailer.php (440): PHPMailer->AddAnAddress('ReplyTo', 'bem vindo', 'Shaiya the ca...') #1 C:\wamp\www\Register\mail.php(16): PHPMailer->AddReplyTo('bem vindo', 'Shaiya the ca...') #2 C:\wamp\www\Register\verify.php(68): require_once('C:\wamp\www\Reg...') #3 {main} thrown in C:\wamp\www\Register\PHPMailer\class.phpmailer.php on line 462


jumentodoido is offline  
Reply



« [Guide]Shaiya5.3 server | [Release]Costume »

Similar Threads
ISRO - EMAIL VERIFICATION FIX READ IT !!!
12/14/2011 - Silkroad Online Trading - 6 Replies
Hello All I See Very Peoples Say WTS 110lv Warrior / Cleric (example) and other ask him have verification and the seller say yes hotmail safe mail - whatever!!!!!!!!!! Have a Way How To Change ur Email 1-Step go to JOYMAX.COM - Global Hub of Fun :: JOYMAX 2-Step Log Ur Account 3-Step Click My Account 4-Step Click Update Email Adress 4.1 Press Confirm 5-Step Go To The email of ur isro account You get email verification 6-Step click at the link at ur email from joymax.com 7-Step Write...
ABout email verification
11/02/2010 - Silkroad Online - 5 Replies
Guys, if i buy one account with E.Verification, how can i keep my EMAIL safely? PS: Hotmail.com
Help|Email Verification
07/09/2009 - Silkroad Online - 2 Replies
What's Email verification is making ? And is it possible to cancel it after you make it ? I want to do it because I got a character that someone know his secret answer ,and I gave the player to someone(not the same person) ,and I afraid that the person who know the answer will give it to the other one and he will be able to change my password and details ...
Question|Email Verification
07/07/2009 - Silkroad Online - 3 Replies
What's Email verification is making ? And is it possible to cancel it after you make it ? I want to do it because I got a character that someone know his secret answer ,and I gave the player to someone(not the same person) ,and I afraid that the person who know the answer will give it to the other one and he will be able to change my password and details ...
Email Verification
09/15/2008 - Silkroad Online - 3 Replies
Is it possible to switch it off? It's damn annoying while trading accounts-.- I have to give my important e-mail accounts! So, is there a way to disable it???



All times are GMT +1. The time now is 06:08.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2020 elitepvpers All Rights Reserved.