Share L2Off - Shares - Tools - Stuff And Preconfigured Server Files.

[Levitate]

ok..ive got it...no i have another problem..when i relog, i lose my buffs..this is what CacheD say:

 

 

6/16/2017 17: 20: 22.625, Error sql: SELECT augmentation, ST_hair_deco, effective_mana0, effective_mana1, effective_mana2, effective_mana3 FROM user_data where char_id = 30 (0)
06/16/2017 17: 20: 22.625, Error 42S22: [Microsoft] [ODBC SQL Server Driver]

 Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.269, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 57 (0)
06/16/2017 17: 20: 27.269, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27,270, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 58 (0)
06/16/2017 17: 20: 27,270, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.271, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 59 (0)
06/16/2017 17: 20: 27.271, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27,271, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 60 (0)
06/16/2017 17: 20: 27.271, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.272, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 61 (0)
06/16/2017 17: 20: 27.272, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17:20:27,274, Error sql: EXEC lin_GetActiveSkills 30 (0)
[sql] The stored procedure 'lin_GetActiveSkills' was not found.
(B3), [b4], [b5], [b6], [b7], [b8] , [b15], [b16], [b17], [b18], [b19], [b20], [b9], [b10] B31], [b24], [b25], [b26], [b27], [b28], [b29], [b30], [b31], [b32], [b33], [ , [b34], [b35], [b36], [b35], [b38] FROM [buffList] WHERE char_id = 30 AND summon = 1 AND subjob_idx = 0 (0)
06/16/2017 17: 20: 27.274, Error 42S02: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid object name 'BuffList'.
06/16/2017 17: 20: 27.274, Error sql: SELECT aio_data FROM user_data WHERE char_id = 30 (0)
06/16/2017 17: 20: 27.274, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'aio_data'.
(B2), [b3], [b4], [b5], [b6], [b7], [b8] , [b15], [b16], [b17], [b18], [b19], [b20], [b9], [b10] B31], [b24], [b25], [b26], [b27], [b28], [b29], [b30], [b31], [b32], [b33], [ , [b34], [b35], [b36], [b37], [b38], [bL] WHERE char_id = 30 AND summon = 0 AND subjob_idx = 0 (0)
06/16/2017 17: 20: 27.275, Error 42S02: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid object name 'BuffList'.

 

ive tryed every sql file i have but i always get this error

Pleas Help me

[Pastorious]

ok..ive got it...no i have another problem..when i relog, i lose my buffs..this is what CacheD say:

 

 

ive tryed every sql file i have but i always get this error

Pleas Help me

Broken database. One from this packs include correct one. I don't remember which one ;(.

Read logs, search for broken names in sql files shipped with packs, make new query (copy & paste missing objects)

[Levitate]

i dont get it working

**** this..stupid files..even the official trail files arent working and the support from depmax64.com is just shit ...

[Pastorious]

i dont get it working

**** this..stupid files..even the official trail files arent working and the support from depmax64.com is just shit ...

send me your email address via pm

[Outlaw™]

Oh damn, i have been a bit away guys sorry.

Have you sorted your issue out ? If not drop me a message with your skype and i can attempt to sort it out.

[Akken]

Oh damn, i have been a bit away guys sorry.

Have you sorted your issue out ? If not drop me a message with your skype and i can attempt to sort it out.

i still wait xD

[Outlaw™]

Contact me via PM with your skype, i will solve your issue out if there is any now.
Sorry i was away and busy quite alot.

[alexmata]

Please.

How to fix cracked vang files?

Char does not gain item when creating new char. And it's kick the server.

[Outlaw™]

About what item are you reffering at ?

[Pastorious]

Please.

How to fix cracked vang files?

Char does not gain item when creating new char. And it's kick the server.

Blind guess - fix sql databases

[victor33]

Broke Nanna's password?
Thanks.

[McBane]

Hi Outlaw, fantastic thread mate.. Keep up the great work.

 

I don't suppose you could advise on what High Five server files I would need, and if there are any packs available.

 

I've been out of the server side a few years but feel like getting back into it again :)

 

Also there is no good tutorials out there, your knowledge would be an asset in either YouTube, or text based version... Just a thought :)

[ogman]

Hi can you please fix the links some of them seems to be broken (example the first one) :) 

Do you or anyone else here have l2server_l2off_gracia_final_83 files? Thanks

[sandeagle]

seems alll links broken...

[Pastorious]

seems alll links broken...

Author of topic, Outlaw is banned from forum, dunno why.  He seems for me as a nice man. He helped me a lot on PM with all my noob questions.

I really want to know reason behind the ban....