Anyone know how to fix this error? (will pay for fix)

some stored procedures link the both databases together.

Quote:

Originally Posted by ✗EpicSoul✗ some stored procedures link the both databases together.

Oh yeah, two stored procedures, _strg_buy_cash_item something. They are correct. But that's just for buying silk items.

sorry, i wasn't know that blackrouge files doesn't have billing XD

Quote:

Originally Posted by pH33n1x<3 Oh yeah, two stored procedures, _strg_buy_cash_item something. They are correct. But that's just for buying silk items.

They still caused instant crash.

Quote:

Originally Posted by ✗EpicSoul✗ They still caused instant crash.

But I don't get DC instantly.. I get DC if i pick up an item.

Quote:

Originally Posted by pH33n1x<3 But I don't get DC instantly.. I get DC if i pick up an item.

:facepalm: i should have read all of the thread xD. hmm all items crash or ?

Quote:

Originally Posted by ✗EpicSoul✗ :facepalm: i should have read all of the thread xD. hmm all items crash or ?

yeah all items..

i would try to help you, because i messed around with br files for around but :
1. i don't have them
2. i know you don't trust people with the files.

The operation values for the item handling procedures might be wrong - you should track the operations by creating either logs or by using an SQL Profiler to have a look at the queries which are executed on the database.
I might send you a pretty neat and free SQL Profiler if you want me to ;o

Or could you post the notice which appears when you DC ingame?

Quote:

Originally Posted by IceAmStiel Or could you post the notice which appears when you DC ingame?

DB Query Error(100): {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 7,13, 251,0,15206435,46, 1,17179869233,0,0,0,0,0,0,0,0,0,0,0)}
Storage Operation Failed!!! [OperationType: 6, ErrorCode: 0]
Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 7,13, 251,0,15206435,46, 1,17179869233,0,0,0,0,0,0,0,0,0,0,0)}
AQ Failed! Log out!! [AQType: 1]

Quote:

Originally Posted by pH33n1x<3 DB Query Error(100): {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 7,13, 251,0,15206435,46, 1,17179869233,0,0,0,0,0,0,0,0,0,0,0)} Storage Operation Failed!!! [OperationType: 6, ErrorCode: 0] Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 7,13, 251,0,15206435,46, 1,17179869233,0,0,0,0,0,0,0,0,0,0,0)} AQ Failed! Log out!! [AQType: 1]

Oh well, basically if you try to pick up an item -> request to DB initialize item at the inventory -> wrong parameters return an error -> DC

Mind adding me at Skype? in order to help you I'd have to know what the content of the SP's is - since I dun have your BR files.

But those errors are pretty easy to fix and luckily also easy to trigger - might be an advantage sometimes

Problems solved.. thanks to Caipi :)

#closed by request