[Share] Ran CP Add-on (Activation Page)

[Ultimate Ran]

I noticed that most of our ran private servers are not open for registration 24/7 and others are closed and you need to request it to be open just to register 1 account. Their main reason is probably to avoid spamming of accounts in their database so to prevent lag. Now this adds more work for admin and gm's of private servers if every minute they open their registration page so to grant the request of their player.

Now, with this Activation Page, you can now open your registration permanently.

To add this on your ran cp, follow this steps: (Note: use the files i've provided to avoid some errors)

1. Open your SQL server management. (I use SQL 2k5, don't know if this works for other sql)
2. Add this table under RanUser>dbo.UserInfo

Column Name: ActivationDate
Data Type: datetime
Allow Nulls: Yes

Next...

Column Name: ActivationCode
Data Type: varchar(21)
Allow Nulls: No

ScreenShot:

3. Now, were still on sql server management. Create a new query and paste this scripts:

USE [RanUser]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[Delete_Inactive] ON [dbo].[UserInfo]
after update
as
BEGIN

DELETE FROM UserInfo
WHERE UserAvailable = 0 and
DATEDIFF(day,[UserInfo].ActivationDate, GETDATE()) >= 2

END

This script will delete the account which are not activated within 2 days. To change the day, edit the red text. This script has two requirements before it automatically execute, first is UserAvailable and second is the ActivationDate. If one of this two requirements were not met, the script won't execute. ALTER TRIGGER for those who have this trigger before.

Now another script is this:

USE RanUser

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Account_Activated] ON [dbo].[UserInfo]
after update
as
BEGIN

Update [UserInfo] set [UserInfo].ActivationDate=Null
From UserInfo
Where UserAvailable = 1

End

About this script. This makes safe your UserInfo database. The action of this script is once the account is activated, ActivationDate will be set to Null making the first script invalid since it won't meet its requirements.

4. Add this to your query.php

DEFINE("SELECT_USER_FULLINFO1", "SELECT UserName, UserPass, UserPass2, UserLoginState, UserEmail, UserNum, UserPoint, ActivationCode FROM UserInfo WHERE UserName = '%s' ");

DEFINE("UPDATE_ACCOUNT","UPDATE UserInfo SET UserAvailable = '%s' WHERE UserName = '%s' ");

Since we don't have the same tables in our dbo.UserInfo, add this at the end of your INSERT_USERAUTH

(ActivationDate, ActivationCode)
VALUES (getdate(),'%s')");

It should look like this:

DEFINE("INSERT_USERAUTH", "INSERT INTO UserInfo (UserName, UserID, UserPass, UserPass2, UserType, UserAvailable, CreateDate, ChaRemain, ChaTestRemain, UserEmail, UserPoint, WebLoginState, ActivationDate, ActivationCode)
VALUES ('%s','%s','%s','%s','1','0',getdate(),'2','2','%s','0','1',getdate(),'%s')");

The red text are the one we insert.

5. Now is to download my files which contain the ff:

config.php (or you can use your old config.php no problem with that)
index.php
activateaccount.php
register.php
login.php

put index.php and config.php to your
C:\Program Files\Abyss Web Server\htdocs\ran

and put activateaccount.php register.php and login.php to your
C:\Program Files\Abyss Web Server\htdocs\ran\page

i've also included the buttons just paste them to C:\Program Files\Abyss Web Server\htdocs\ran\img

6. Your finish, try to browse your activateaccount.php

You must be registered to see links

That's all and thank you...

Addition:
If you wanna send their account info upon finish registration.. Open register.php find and replace this lines:

echo "<div align=center><font color=green size=2><strong>Account has been created sucessfully under the ff info:<br><br>
<font color=orange size=2><strong>UserName :</strong></font> <font color=red size=2><strong>$account</strong></font><br>
<font color=orange size=2><strong>Password :</strong></font> <font color=red size=2><strong>$password</strong></font><br>
<font color=orange size=2><strong>Password #2 :</strong></font> <font color=red size=2><strong>$sandi</strong></font><br>
<font color=orange size=2><strong>Email :</strong></font> <font color=red size=2><strong>$email</strong></font><br><br>
Please save your account info for future use.</strong></font><br><br></div>";

with this one:

if($CONFIG['email']==0) {
echo "<font color=green size=2><strong>Your password has been reseted to...</strong></font><br><font color=green size=2>{$newpassword}</font><br><br>";
} elseif($CONFIG['email']==1) {
sendemail($CONFIG['emailsmtp'], $CONFIG['emailuser'], $CONFIG['emailpass'], $CONFIG['emailaddress'], $CONFIG['servername'], "Lost Password", $useremail, $account, $newpassword, $ssn, "<strong>Your password has been reseted and sent to your email.</strong>");
}

and open your config.php and find this line:

$CONFIG['email'] = "1"; //1=send 0=not send

 

[SeiferXIII]

@Sir UltimateRan

sir how can i make a SMTP account??

 

[Ultimate Ran]

@Sir UltimateRan

sir how can i make a SMTP account??

google it and you can see free smtp host

 

[SeiferXIII]

google it and you can see free smtp host

thnx dude i will test this^^

 

[lastiko]

thanks sir UltimateRan this is very useful to avoid account spamming on my server, im gonna try this...

btw for those who want to setup SMTP check this:

You must be registered to see links

 

[Ultimate Ran]

thanks sir UltimateRan this is very useful to avoid account spamming on my server, im gonna try this...

btw for those who want to setup SMTP check this:

You must be registered to see links

no problem.. please post for comments and some errors so i can fix them..

 

[ushpen]

Wow, thanks for sharing dude, gonna try this.

 

[bk2483]

what i use for my smtp server is postcastserver. I use this for my helpdesk.

You must be registered to see links

 

[elomeco]

awesome dude for sharing this..^^,
..gonno try dis one..

 

[alsyundawy]

waooooooooooooo thx sir


good jobs bro

 

[Ultimate Ran]

waooooooooooooo thx sir


good jobs bro

no problem.. have you tried it? is it working?

i know 1 error you will encounter.. the INSERT_USERAUTH query.. we don't have same tables in our dbo.UserInfo

 

[alsyundawy]

no problem.. have you tried it? is it working?

i know 1 error you will encounter.. the INSERT_USERAUTH query.. we don't have same tables in our dbo.UserInfo

can u make mirror link, becouse my isp is mediafire suck

 

[Ultimate Ran]

don't know what hosting site is good.. i always use mediafire.. tell me where to upload and i'll upload it there

 

[alsyundawy]

don't know what hosting site is good.. i always use mediafire.. tell me where to upload and i'll upload it there

just attachement here sir

 

[edilon09]

ouch it's good but i dont know how to use...the outlook express....the link that ultimate ran has given in a guide on how to use gmail as an smtp host....hmmmmm, i think that guide is not for a beginner in outlook express it's just a guide on using the gmail accnts on it...hayz.............i gotta sent those verification's via manual..T_T

 

[evilcyberx28]

when i use this my ran cp error. i log in my rancp then message box appear then say no such account.
then i look in my database my character was deleted in charinfo table T_T and all my players went to rancp was also deleted T_T how can i avoid this error T_T pls need your fast reply!

 

[smarkies]

Waiting for positive response before it goes to sticky threads.

 

[Ultimate Ran]

when i use this my ran cp error. i log in my rancp then message box appear then say no such account.
then i look in my database my character was deleted in charinfo table T_T and all my players went to rancp was also deleted T_T how can i avoid this error T_T pls need your fast reply!

just use the files i've provided.. backup first yours and paste overwrite.. you have that error because we have different tables in dbo.UserInfo or edit your query.php find INSERT_USERAUTH then at the end add this:

ActivationCode
'%s'

 

[smarkies]

Thread Starter if you want to add something.. just edit the first post.. to make the guide complete.. members might ignore that post and ask some redundant questions.

 

[evilcyberx28]

its work for me but my question brother Ultimate Ran after i done i try it and old player when he log in my ran cp there message box appear and look my database my character has remove charinfo and other player? can we fix of this because haft my player log in rancp then i look her in database his / her registration in charinfo has delete when he log in mya ran cp!
[URL="http://forum.ragezone.com/attachments/f248/53023d1209551000-help-ran-cp-error-untitled.jpg"]

[/URL]