Manual account creation in DB

[ToonS]

hiya ppl is there any way whatsoever to manually create a user account in the DB as i cant get the website reg to work correctly.
And if i try to manually create an account in DB all i get is some error msg telling me i cant edit this cell ...

All help would be appreciated thx in advance

[MentaL]

[BiGBoY1]

Yes u can use the stored procedure with SQL Query Analizer.
Open up db lin2db and select last procedure called dbo.l2p_TempCreateAccount.

[ToonS]

TY BB1 but im kind of a newb to this not totally 100% sure exactly what your telling me to do ive opened the lin2db with query analyzer found the dbo.l2p_TempCreateAccount part in the text but thats as far as my inteligence takes me :D could you kinda run me through what i need to do please i do appologize if i sound stupid but thx again BB1 appreciated.

[ElvenGatesB]

This is SQL part from the PHP registration page

//Adding account to DB^M
$query = mssql_query("INSERT INTO [ssn](ssn,name,email,job,phone,zip,addr_main,addr_etc,account_num) VALUES('".$ssn."','".$account."','user@rst.lan',0,'telphone','123456','','',1)");^M
$query = mssql_query("INSERT INTO [user_account](account,pay_stat) VALUES('".$account."',1)");
$query = mssql_query("INSERT INTO [user_info](account,ssn,kind) VALUES('".$account."','".$ssn."',99)");
$query = mssql_query("INSERT INTO [user_auth](account,password,quiz1,quiz2,answer1,answer2) VALUES('".$account."',".$l2encpass.",'".$qst1."','".$qst2."',0x".$asw1.",0x".$asw2.")");

If you'r know what sql is it should help you.

You also should encrypt password to put it into user_auth table and code is to complicated to do it by hands.

$key = array();
$dst = array();

//bu_String2Bytes
$nBytes = strlen($str);
while ($i < $nBytes){
$i++;
$key[$i] = ord(substr($str, $i - 1, 1));
$dst[$i] = $key[$i];
**

//bu_Bytes2Int
$rslt = $key[1] + $key[2]*256 + $key[3]*65536 + $key[4]*16777216;
$one = $rslt * 213119 + 2529077;
$one = $one - intval($one/ 4294967296) * 4294967296;

$rslt = $key[5] + $key[6]*256 + $key[7]*65536 + $key[8]*16777216;
$two = $rslt * 213247 + 2529089;
$two = $two - intval($two/ 4294967296) * 4294967296;

$rslt = $key[9] + $key[10]*256 + $key[11]*65536 + $key[12]*16777216;
$three = $rslt * 213203 + 2529589;
$three = $three - intval($three/ 4294967296) * 4294967296;

$rslt = $key[13] + $key[14]*256 + $key[15]*65536 + $key[16]*16777216;
$four = $rslt * 213821 + 2529997;
$four = $four - intval($four/ 4294967296) * 4294967296;
//bu_Bytes2Int end

//MyuwSplit
$key[4] = intval($one/16777216);
$key[3] = intval(($one - $key[4] * 16777216) / 65535);
$key[2] = intval(($one - $key[4] * 16777216 - $key[3] * 65536) / 256);
$key[1] = intval(($one - $key[4] * 16777216 - $key[3] * 65536 - $key[2] * 256));

$key[8] = intval($two/16777216);
$key[7] = intval(($two - $key[8] * 16777216) / 65535);
$key[6] = intval(($two - $key[8] * 16777216 - $key[7] * 65536) / 256);
$key[5] = intval(($two - $key[8] * 16777216 - $key[7] * 65536 - $key[6] * 256));

$key[12] = intval($three/16777216);
$key[11] = intval(($three - $key[12] * 16777216) / 65535);
$key[10] = intval(($three - $key[12] * 16777216 - $key[11] * 65536) / 256);
$key[9] = intval(($three - $key[12] * 16777216 - $key[11] * 65536 - $key[10] * 256));

$key[16] = intval($four/16777216);
$key[15] = intval(($four - $key[16] * 16777216) / 65535);
$key[14] = intval(($four - $key[16] * 16777216 - $key[15] * 65536) / 256);
$key[13] = intval(($four - $key[16] * 16777216 - $key[15] * 65536 - $key[14] * 256));
//MyuwSplit end

$dst[1] = $dst[1] ^ $key[1];

$i=1;
while ($i<16){
$i++;
$dst[$i] = $dst[$i] ^ $dst[$i-1] ^ $key[$i];
**

$i=0;
while ($i<16){
$i++;
if ($dst[$i] == 0) {
$dst[$i] = 102;
**
**
return $encrypt;
**

Hope this helps

[fileburner]

can someone explain more please :D I have problem with IIS installation and this is my last chance

[Oxzygen]

Why don't you use l2toolz instead?

[john_d]

it would be difficult for u to do a manual register job on mssql since password is encrypted.

[Airamags]

it is possible and a guy once explained it to me - the password encryption was made via l2j account creator :]

[Kapoios]

In 4 easy steps:
1) Run L2PWD.exe, enter the password in the upper text box and press make.
Copy the whole text in the second text box (you need to scroll to the
right a bit).
2) Open SQL Query Analyzer, open the NewL2Acc.sql file and select the
lin2db as the database.
3) Replace <acc> with account name, <ssn> with any random number and
<pwd> with the copied text. Do not remove the ' characters.
4) Run the script.

[Kapoios]

Notes: You need to have the VB6 runtimes to use L2PWD. And of course if you are using an unencrypted l2authd you don't need it, just replace the <pwd> with the unencrypted password enclosed in apostrophes (').

[rodier]

u can use l2pass.exe (find on net) instead this l2pwd.
its easy
1. fire your SQL query client (I prefer the one what u get with MS SQL 2000)
and put this code to query:

insert into lin2db.dbo.user_account (account, pay_stat, block_flag, block_flag2 ) values ('ACCOUNT_NAME', 1, 0, 0)
insert into lin2db.dbo.user_auth (account, password, quiz1, quiz2, answer1, answer2 ) values ('ACCOUNT_NAME', CRYPTED_PASS, 'FIRSTQUESTION_FOR_RESET_PASS', 'SECONDQUESTION_FOR_RESET_PASS', CRYPTED_ANSWER1, CRYPTED_ANSWER2)

Now, find on the net l2pass.exe and get crypted password and answers there. Its simply
l2pass whatpasswordyouwant
you get hash like 0XASDJSHDJSH paste to query..
l2pass whatAnswer1YouWant
l2pass whatAnswer2YouWant
same as password..

example:

insert into lin2db.dbo.user_account (account, pay_stat, block_flag, block_flag2 ) values ('CZJirka2', 1, 0, 0)
insert into lin2db.dbo.user_auth (account, password, quiz1, quiz2, answer1, answer2 ) values ('CZJirka2', 0x31FF11E855682537029BBDBD70EACCCC, 'my name', 'name of my mom', 0xA19AF1BE3F087408D575EA6A4DF87B7A, 0xA5175826A7909259109D359409DDFCC2)

[geralnet]

Hola Necesito ayuda , no entiendo nada de esto please por el momento me sale error L2Db
de color rojo ayuda

[jhnjohnny]

Plz, post Coder Oper (sourcer) of L2 PWD

I need of encrypt password for VB or .Net (Aspx)

tks