L2O [HOWTO] Create accounts by "hand"

[Megatronpt]

Here's a little info for all those that can't use L2ASP like me.

Needed:
l2pass.exe

Steps to create an account:

1 - Open SQL Server Management Studio
2 - Click on "New Query"
3 - Paste the code below, inside the query window:

insert into user_auth (account, password, quiz1, quiz2, answer1, answer2)
values ('<nick>',<value outputed by l2pass.exe>,'quiz1' ,'quiz2',<value outputed by l2pass.exe>,<value outputed by l2pass.exe>)

insert into user_account (account, pay_stat)
values ('<nick>',1)

a) Replace <nick> by the nick you want to insert.

b) Replace <value outputed by l2pass.exe> by value.
DON'T USE THE ' ', or else it'll output an error.

4 - Click on Execute.

There.. account created! Easy, right?



And a password changer:

1 - Open SQL Server Management Studio
2 - Click on "New Query"
3 - Paste the code below, inside the query window:

update lin2db.dbo.user_auth 
set password = <value outputed by l2pass.exe> 
where account like '<nick>';

/*Checking if the value is correct*/

select * from lin2db.dbo.user_auth
where account like '<nick>';

4 - Click on Execute.

You changed the password!

Hope this helps!

Have fun!

 

[tiobriner]

no funciona :S...entonces para que necesito el l2pass.exe? ...

esto si q esta mal explicado =/

 

[gmoney]

l2pass.exe? how do you use the l2pass.exe? please explain things better.

put your l2pass in your c:/l2pass.exe then open comand promp. the just type:
l2pass and watever password u want example:

c:/l2pass pasword

 

[tiobriner]

no encuentro la relacion que tiene el l2pass.exe esta muy mal explicado...plz if any body know hoy to create accounts plz say in this post...sorry for my inglish

 

[xt198]

Please login after changing your temporary password.

wtf?!?!?!?! :crash:

 

[FaiscA]

Please login after changing your temporary password.

same problem

 

[diaremi]

just reshare cool tool to create acc

:smileysex
RapidShare Webhosting + Webspace