Making account with l2pass.exe

Results 1 to 1 of 1
  1. #1
    Member Sesshoumaru is offline
    MemberRank
    Apr 2003 Join Date
    SwedenLocation
    60Posts

    Making account with l2pass.exe

    I found the l2pass.exe and got it to run, but still some things are simply beyond my small brain (like everything SQL), but...

    I found this in the forum, that Im suposed to add into the sql querie:

    Try this: it's sql queries...
    "account" in values -acc name
    ssn is random number
    l2encpass - encrypted password ... use l2pass.exe


    INSERT INTO [ssn](ssn,name,email,job,phone,zip,addr_main,addr_etc,a ccount_num)
    VALUES('ssn','account','user@rst.lan',0,'telphone' ,'123456','','',1)

    INSERT INTO [user_account](account,pay_stat) VALUES('account',1)

    INSERT INTO [user_info](account,ssn,kind) VALUES('account','ssn',99)

    INSERT INTO [user_auth](account,password,quiz1,quiz2,answer1,answer2)
    VALUES('account',l2encpass,'blabla','blabla',0x0,0x0)



    p.s. l2encpass is binary data
    p.p.s. 0x0 in the end is without space... don't know why forum puts it there...

    ---
    Well, I get the sql queire part I think - insert that thing, use l2pass.exe for the password, and hit the green arrow and all should work. BUT... there is always the but...
    I should change some of the above, and some not?
    Would this work?
    ---


    INSERT INTO [ssn](1,Gneet,anemail@somewhere.com,fisher,0078211,36100,smallcave,awayinafganistahn,1)
    VALUES('1','MyAccount','anemail@somewhere.com',0,'0078211' ,'36100','','',1)

    INSERT INTO [user_account](account,pay_stat) VALUES('MyAccount',1)

    INSERT INTO [user_info](account,ssn,kind) VALUES('MyAccount','1',99)

    INSERT INTO [user_auth](MyAccount,0xB53B56EDAC3B1D1D28B197975AC0E6E6,Bush?,Sadam?,sux,himtoo)
    VALUES('MyAccount',0xB53B56EDAC3B1D1D28B197975AC0E6E6,'Bush?','Sadam?',0x0,0x0)

    Is this correct (the numbers for pass being what l2pass.exe gives for "test")?
    Or is "VALUES" rows not to be printed but a hint of how to really type? In that case, most is correct except I should leave "ssn" in, and erase the "VALUES" rows from what I type in the queire?

    So confused.




Advertisement