I´d like to add a stored procedure to my database and run it every X hours.
I have no idea how to setup so Im asking here for some help and I´m willing to donate some Paypal $$.
Stored Procedure db.smp_check_purchased_item? 06/23/2013 - Rappelz Private Server - 1 Replies I've come across an error on the Captain Herlock server while logging on my character. This is the error I get:
DB COM ERROR(Thread:2, HRESULT:80040E37, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D):DB_GetC ommercialStorageInfo(dbo.smp_check_purchased_item) : Invalid object name 'billing.dbo.PaidItem'.
I've narrowed down the stored procedure and here is the problematic code: dbo.smp_check_purchased_item
SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from billing.dbo.PaidItem WHERE...
[SQL] Stored Procedure for TitleUpdating Automatic 05/08/2013 - SRO PServer Guides & Releases - 11 Replies heya guys,
this was made a looooooong time ago when we wanted to make title giving automatic on devias. however, it was never used cuz of lazyness.
Just found it again and thought i´d release it. This is to be executed each time a new uniquelog is added.
It works like this
gets the first charname that killed the MOB "Devias".
If you kill devias for the first time u get the title Devias Slayer #1
for the second time Devias Slayer #2
etc.
[HELP]Res toon stored Procedure 07/23/2010 - Shaiya Private Server - 0 Replies Hi all,
hopefully someone can tell me what i am doing wrong.
I am trying to use the dbo.usp_GM_Recovery_Char and it completes without errors but it doesn't res the toon.
can anyone tell me how to fix this. I am tired of ressing them manually.
thanks alot!!