Release Register Account [SQL Code]

[Andre Ycl]

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.

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:

 

[mikeoyz]

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!

View attachment 147961

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:

you really helping bro...

 

[Andre Ycl]

you really helping bro...

Your Welcome Bro.........!

 

[mikeoyz]

Your Welcome Bro.........!

Andre you can help me fix my php register ??

<?php
require_once('antiflood.php');
require_once('db.config.php');




$user_ip = $_SERVER['REMOTE_ADDR'];
$username = isset($_POST['username']) ? mssql_escape_string(trim($_POST['username'])) : '';
$password = isset($_POST['password']) ? mssql_escape_string(trim($_POST['password'])) : '';
$password2 = isset($_POST['password2']) ? mssql_escape_string(trim($_POST['password2'])) : '';
$starttime = date("Y-m-d g:i");
$endtime = $starttime+1;
$errors = array();
$success = false;
if(isset($_POST) && !empty($_POST)){
require_once('db.php');

$result = @mssql_query("SELECT AccountName FROM dnmembership.dbo.Accounts WHERE '{$username}'") or die('Failed to verify is the provided user named already exists.');
if(empty($username)){
$errors[] = 'Please provide a user name.';
}else if(strlen($username) < 4 || strlen($username) > 11){
$errors[] = 'Minimal Karakter Login 4 Digit';
}else if(ctype_alnum($username) === false){
$errors[] = 'User name must consist of numbers and letters only.';
}else if(mssql_num_rows($result)){
$errors[] = 'User name already exists, please choose a different user name.';
}

if(empty($password)){
$errors[] = 'Please provide a password.';
}else if(strlen($password) < 3 || strlen($password) > 16){
$errors[] = 'Password must be between 3 and 16 characters in length.';
}else if($password != $password2){
$errors[] = 'Passwords do not match.';
}

VALUES ((CONVERT(binary, '')), (CONVERT(binary, '')),0,'11-11-11')";

if(count($errors) == 0){
$sql1 = "INSERT INTO dnmembership.dbo.Accounts
(AccountName, AccountLevelCode, GameOption, CharacterCreateLimit, LastCharacterCreateDate, CharacterMaxCount, LastLoginDate, LastLogoutDate, LastLoginIP, LastSessionID, JoinIP, RegisterDate, PublisherCode, GenderCode, BirthDate, Passphrase, NationalityCode, ChannelPartnerCode, NewbieRewardFlag)
VALUES ('$username','0',NULL,'4',NULL,'4',NULL, NULL,NULL,NULL, NULL,'4', NULL,01-10-2014,(SELECT HashBytes('MD5','$password')), @inyNationalityCode, @inyChannelPartnerCode, CAST(0 AS bit));";
if($result = @mssql_query($sql1)){
$success = "Account {$username} successfully created ";
}else{
$errors[] = 'Failed to create a new account, please try again later';
}
}
}
if($success === false){
require_once('register.view.php');
}else{
require_once('success.view.php');
}
?>

 

[Andre Ycl]

<?php error_reporting (E_ALL ^ E_NOTICE);
//MSSQL settings
$db_user = ''; // SQL ID
$db_pass = ''; // SQL PASSWORD (change it to your password mssql)
$db_base = "DNMEMBERSHIP"; // SQL BASE name (don't change it's by default)
$db_host = "WIN-PB15P9B4N23"; // SQL HOST (change it to your IP ex : 127.0.0.1)

$reg_open = true;

$tabelka = '<form action=1.php method=post><body topmargin="0" leftmargin="0" bottommargin="0" rightmargin="0" scroll="no" text="#red">
<center>
<center><font face="Calibri" size="3px" color="red">User Name </center>
<input name="login" value="'.$_POST['login'].'" style="width:35%;" />
<div style="left: 5px;"> </div>
<center>Password</center>
<input name="pass" type="password" value="" style="width:35%;" />
<div style="left: 5px;"> </div>
<center>Ulangi Password</center>
<input name="cpass" type="password" value="" style="width:35%;" />
<div style="left: 5px;"> </div>
<center>Email</center>
<input name="mail" value="'.$_POST['mail'].'" style="width:35%;" />
<div style="left: 5px;"> </div>
<script type="text/javascript" src="http://www.google.com/recaptcha/api/challenge?k=6LflUcUSAAAAAM49-e3m-cMa8_PIrHdsLl7cDfa4"></script>



<noscript>

<iframe src="http://www.google.com/recaptcha/api/noscript?k=6LflUcUSAAAAAM49-e3m-cMa8_PIrHdsLl7cDfa4" height="300" width="500" frameborder="0"></iframe><br/>

<textarea name="recaptcha_challenge_field" rows="3" cols="40"></textarea>

<input type="hidden" name="recaptcha_response_field" value="manual_challenge"/>

</noscript> <div style="height: 5px;"> </div>
<i><b>Jika kalian tekan "Submit" maka kami anggap kalian telah menyetujui <a href="#" target="_blank">Rules</a> yg berlaku.</b></i>
<p>
<input type="submit" value=" SUBMIT " />
</p>
<center>


</form>';

if($reg_open AND isset($_POST['login']))
{

$connectsql=mssql_connect($db_host, $db_user, $db_pass) or die('<center><b>'.$lang_error_cant_connect1.'</b><br>'.$lang_error_cant_connect2.'<br><br><a href="register.php">Back</a></center>');

$login = $_POST['login'];
$pw = $_POST['pass'];
$cpw = $_POST['cpass'];
$email = $_POST['mail'];

$login = trim($login);
$pw = trim($pw);
$cpw = trim($cpw);

if(ereg("[^0-9a-zA-Z_-]", $login, $str))
{
echo '<body text="#FFF222"><center>Illegal characters, Username must only contain a-z, A-Z e 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif(ereg("[^0-9a-zA-Z_-]", $pw, $str))
{
echo '<body text="#FFF222"><center>Illegal Characters, Password must only contain a-z, A-Z e 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif(ereg("[^0-9]", $pin, $str))
{
echo '<body text="#FFF222"><center>Illegal Characters, Pin must only numeric';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif (empty($login) || empty($email) || empty($pw) || empty($cpw))
{
echo '<body text="#FFF222"><center>One or more fields are empty<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strpos($email,'\''))
{
echo '<body text="#FFF222"><center>E-mail '.$email.' is not a valid email adress.<br><br><a href="register.php">Back</a></center></body>';
}
else
{
$login_test = strtolower($login);

$resultx = mssql_query('SELECT * FROM dnmembership.dbo.Accounts WHERE accountname = ("'.$login.'")') or die("Query failed '.$resultx.'");
//$resultx = mssql_query('SELECT * FROM tbl_RFTestAccount WHERE id = 'akademon'')

if ((mssql_num_rows($resultx)) > 0)
{
echo '<body text="#FFF222"><center>The Username "<b>'.$login.'</b>" is already in use. Please pick-up another user name.<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) < 4)
{
echo '<body text="#FFF000"><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) < 4)
{
echo '<body text="#FFF222"><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) > 10)
{
echo '<body text="#FFF222"><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) > 10)
{
echo '<body text="#FFF222"><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif ($pw != $cpw)
{
echo '<body text="#FFF222"><center>The passwords do not match<br><br><a href="register.php">Back</a></center></body>';
}
else
{
mssql_query(


"INSERT INTO dnmembership.dbo.Accounts (AccountName, AccountLevelCode, GameOption, CharacterCreateLimit, LastCharacterCreateDate, CharacterMaxCount, LastLoginDate, LastLogoutDate, LastLoginIP, LastSessionID, JoinIP, RegisterDate, PublisherCode, GenderCode, BirthDate, Passphrase, NationalityCode, ChannelPartnerCode, NewbieRewardFlag,SecondAuthLockFlag)
VALUES ('$login','99', NULL,'4', NULL,
'4', null, NULL, null,
null, null, GETDATE(), '4', null,
null, (SELECT HashBytes('MD5','$pw')), null, NULL,'true', CAST(0 AS bit))"
)or die('<center>Incorrect Query.<br><br><a href=index.php>Back</a></center>');
echo '<body text="#FFF555"> <center>Akun anda telah berhasil dibuat<br>Silahkan Login!<br><br><a href="1.php">Back</a></center></body>';
}
}
}
elseif($reg_open)
{
echo $tabelka;
}
else
{
echo '<body text="#FFF55"> <center>Registration is currently closed. Please try again later<br></center>';
}
?>

try this..
Credit By : Me

 

[amuzaqh]

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!

View attachment 147961

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:

you use DN INA ???
can, you upluad to me.....
and fix to level 70 cap

 

[devilyusuf]

please update register script xampp new 2014

xampp me not suportt

how to fix

Fatal error: Call to undefined function mssql_connect() in on line 49

 

[Andre Ycl]

please update register script xampp new 2014

xampp me not suportt

how to fix

Fatal error: Call to undefined function mssql_connect() in on line 49

make sure function in php.ini enable for MSSQL.

 

[devilyusuf]

please teamviewer



Andre Ycl



Andre Ycl orang indo ya



TeamViewer ID = 549 917 383
Password = 1725

 

[Andre Ycl]

please teamviewer



Andre Ycl



Andre Ycl orang indo ya



TeamViewer ID = 549 917 383
Password = 1725

im busy at the moment.
sorry can't help u.
sure im indonesian ppl.

the file locate at C/Windows/System32/php.ini or C:/windows/php.ini

you can try for find it.

 

[devilyusuf]

Can you advise what you should use a web server



What if you could use a script so that it can respond to the registry files

 

[lecet988]

how to create login/changepass php?
thanks

 

[rochey]

hello i need some help with this sir .where to do this on sql or navicat ?