Experienced Elementalist
- Joined
- Jun 21, 2012
- Messages
- 246
- Reaction score
- 61
Hello everyone.
I try my best work for create sql code for register auth loginserver for call password.
so this simple guide for make it work.
1. Change your value column Passphrase to Binary(20), And dont forget save your change value!
2. insert this code for DragonNest registration.
This Preview video after using this script. AND IT'S WORK FOR ME..!
1. ID NULL PASSWORD.
2. ID VALUE PASSWORD.
ENJOY....! tt1:tt1:
I try my best work for create sql code for register auth loginserver for call password.
so this simple guide for make it work.
1. Change your value column Passphrase to Binary(20), And dont forget save your change value!
2. insert this code for DragonNest registration.
USE [DNMEMBERSHIP]
SET ANSI_NULLS ON
/**Credit By : Andre YCL.
Don't Change Anything execpt Your ID and Your Password*/
GO
declare @inyAccountLevelCode nvarchar(50)
declare @inyCharacterCreateLimit tinyint
declare @inyCharacterMaxCount int
declare @dt2LastLoginDate date
declare @vchLastLoginIP date
declare @intLastSessionID int
declare @vchJoinIP int
declare @inyPublisherCode int
declare @inyGenderCode int
declare @datBirthDate date
declare @inyNationalityCode int
declare @inyChannelPartnerCode int
INSERT dbo.Accounts (AccountName, AccountLevelCode, GameOption, CharacterCreateLimit, LastCharacterCreateDate, CharacterMaxCount, LastLoginDate, LastLogoutDate, LastLoginIP, LastSessionID, JoinIP, RegisterDate, PublisherCode, GenderCode, BirthDate, Passphrase, NationalityCode, ChannelPartnerCode, NewbieRewardFlag)
VALUES ('YourID','99', NULL,'4', NULL,
'4', @dt2LastLoginDate, NULL, dbo.FN_IP2IPNumber(@vchLastLoginIP),
@intLastSessionID, dbo.FN_IP2IPNumber(@vchJoinIP), GETDATE(), '4', @inyGenderCode,
@datBirthDate, (SELECT HashBytes('MD5','PASSWD')), @inyNationalityCode, @inyChannelPartnerCode, CAST(0 AS bit));
This Preview video after using this script. AND IT'S WORK FOR ME..!
1. ID NULL PASSWORD.
2. ID VALUE PASSWORD.
ENJOY....! tt1:tt1:
Attachments
You must be registered for see attachments list
Last edited: