Jump to content

sickbastard

Members
  • Posts

    20
  • Credits

  • Joined

  • Last visited

    Never
  • Feedback

    0%

Posts posted by sickbastard

  1. Could someone share the dvamp 1.75mb SQL fixes?

    For example the fix for the lin_SaveCharacter SP (so that the char wont lose his exp, sp, loc, etc..)

    Also im missing the lin_ReloadRatedByAccountID SP and a fix for lin_UpdateActiveSKill, lin_CrateActiveSkill too many arguments error.

     

    I tried to correct them myself but i dont know the datatypes of the extra SP arguments.

     

    Anyway, little help would be greatly appreciated. Ty.

     

    - Edit -

     

    Ok, i read the cache error log and figured my lin_SaceCharacter SP is missing 11 arguments, which i found in advext forum that they are:

    @ST_HairAll INT,

    @ST_Agathon INT,

    @ST_LeftBracelet INT,

    @ST_RightBracelet INT,

    @ST_Talisman1 INT,

    @ST_Talisman2 INT,

    @ST_Talisman3 INT,

    @ST_Talisman4 INT,

    @ST_Talisman5 INT,

    @ST_Talisman6 INT,

    @Souls INT

     

    so i also added these extra 11 columns to my user_data table.

    But now im getting cache error:

     

    09/03/2012 18:29:30.171, Error sql: EXEC lin_SaveCharacter 0,0,93,1,-71453,258305,-3104,0,4484.198000,1607.808000,4484.198000,1607.808000,0,6000000000,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,0,1,93,-1,-1,-1,1793.679200,1793.679200,0,0,0,0,0,0,0,0,0,16777215,0,0,103795584,0,0,0,0,0,0,0,0,0 (0)

    09/03/2012 18:29:30.187, Error 42000:[Microsoft]

    [sql Server][u]Error converting data type numeric to int.[/u]

     

    So the new argument datatypes are false? All of them or some? Any help?

  2. Ok, figured it out. The server name in the selection screen is changed from the client side. Need to open the file system/servername-e.dat with FileEdit.

     

    As for the 9999 ping problem, i had to change the [AuthD] address in file l2server.ini to 127.0.0.1 and

    also in my lin2db.dbo.server I had to change the ip column to my internal ip (192.168.1.34) and the inner_ip to 127.0.0.1.

     

    Turns out i couldnt connect from the same PC if I used the WAN IP, despite the fact that all ports were open and forwarded to my internal ip correctly.

  3. Hello all, I've been trying to connect to the l2server (dvamp IL 1.75mb extender)

    but as you can see, when trying to connect with the gm1 account I created using the AccountCreator provided somewhere in these fourms and Im passing the login screen but im stuck in the server selection screen.

    Also, I have create a dbo.server in lin2db and I have used my WAN IP: (94.66...) in the ip column and my internal LAN ip: (192.168.1.34) in the inner_ip column

     

    Obviously, im doing something terribly wrong cause i dont think im supposed to see Bartz as server nor 9999 ping...

    So, any ideas?

    logD, hAuthD, cacheD all are loaded and connecting with my mssql server instance.

    l2server gives me couple minor errors about botcheck.ini, inspector.u (or are they not minor?)

     

    problem3v.jpg

     

    my l2server.ini

    [CacheD]

    address="127.0.0.1"

    port=2006

     

    [AuthD]

    address="192.168.1.34"

    port=2104

     

    [LogD]

    address="127.0.0.1"

    port=3999

     

    [World]

    WorldId=1

    UserLimit=2000

    LetBuilder=1

     

    [setting]

    UserPort=7777

     

    my l2cache.ini

    [LogD]

    address=127.0.0.1

    port=3999

     

    [World]

    WorldId=1

    ;DeleteAccount=1

    Pair=0

     

    my l2.ini (client_side)

    Port=7777

    ServerAddr=127.0.0.1

     

  4. Hello all, I've been trying to connect to the l2server (dvamp IL 1.75mb extender)

    but as you can see, when trying to connect with the gm1 account I created using the AccountCreator provided somewhere in these fourms and Im passing the login screen but im stuck in the server selection screen.

    Also, I have create a dbo.server in lin2db and I have used my WAN IP: (94.66...) in the ip column and my internal LAN ip: (192.168.1.34) in the inner_ip column

     

    Obviously, im doing something terribly wrong cause i dont think im supposed to see Bartz as server nor 9999 ping...

    So, any ideas?

    logD, hAuthD, cacheD all are loaded and connecting with my mssql server instance.

    l2server gives me couple minor errors about botcheck.ini, inspector.u (or are they not minor?)

     

    problem3v.jpg

     

    my l2server.ini

    [CacheD]

    address="127.0.0.1"

    port=2006

     

    [AuthD]

    address="192.168.1.34"

    port=2104

     

    [LogD]

    address="127.0.0.1"

    port=3999

     

    [World]

    WorldId=1

    UserLimit=2000

    LetBuilder=1

     

    [setting]

    UserPort=7777

     

    my l2cache.ini

    [LogD]

    address=127.0.0.1

    port=3999

     

    [World]

    WorldId=1

    ;DeleteAccount=1

    Pair=0

     

    my l2.ini (client_side)

    Port=7777

    ServerAddr=127.0.0.1

     

  5. Βγάζεις το Seraphim για να μην γελάει ο κόσμος και βάζεις στη θέση του ένα από τα Agility/Song of Water/Elemental prot/Noblesse.

     

    Επίσης, dyes +5 dex/-5 str, +4 con/-4 str (to +4 wit στον elf δαγγερά είναι κομματάκι άχρηστο... στον δάρκ έλφ κάτι χρησιμεύει).

     

    (σημείωση: για Ιντερλουδ μιλάω πάντα)

  6. Interlude mid-rate (x15-20)... μετά το Interlude και ειδικά μετά το Hellbound το l2 έγινε πολύ περίπλοκο χωρίς κάποιον ιδιαίτερο λόγο... μόνο και μόνο για να συνεχίσει το grinding...

    Στα τελευταία clients θυμίζει ελάχιστα l2 και περισσότερο Starwars...

     

×
×
  • Create New...