Hello, I have a problem with a stored procedure when you log into the game.
Discussion on Hello, I have a problem with a stored procedure when you log into the game. within the Rappelz Private Server forum part of the Rappelz category.
sure us this it fixed mine
USE [Arcadia]
GO
/****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 7/24/2012 9:40:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- smp_read_purchased_item_list
-- start of smp_check_purchased_item 캐쉬템 창고에 아이템 있는지 여부 검사
CREATE PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID INT,
@IN_CHARACTER_ID INT,
@OUT_TOTAL_ITEM_COUNT INT OUTPUT,
@OUT_NEW_ITEM_COUNT INT OUTPUT,
@OUT_PREMIUM_TICKET INT OUTPUT,
@OUT_PREMIUM_REST_TIME INT OUTPUT,
@OUT_STAMINA_REGEN_TIME INT OUTPUT
AS
SET NOCOUNT ON
SET @OUT_PREMIUM_TICKET = 0
SET @OUT_PREMIUM_REST_TIME = 0
SET @OUT_STAMINA_REGEN_TIME = 0
SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()
IF @OUT_PREMIUM_TICKET < 1
BEGIN
SET @OUT_PREMIUM_REST_TIME = 0
DECLARE @LOGOUT_TIME DATETIME
SET @LOGOUT_TIME = GETDATE()
SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME
IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
BEGIN
SET @OUT_STAMINA_REGEN_TIME = 0
END
--DECLARE @NO_LV INT
--DECLARE @NO_Total_JP INT
--SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'
--DECLARE @LV INT
--DECLARE @Total_JP INT
--SELECT @LV = MAX(lv), @Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'
SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000
SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000 AND confirmed = 0
[BR Files] Missing stored procedure: _ResetQuestByCharName 04/27/2012 - SRO Private Server - 2 Replies Anyone have this stored procedure for Black Rogue DB? o.O
I keep getting this error in GS and it's really annoying (doesn't affect performance, just annoying -_-):
Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )}
SQL Error State:42000, Native Error Code: AFC, ODBC Error: Could not find stored procedure '_ResetQuestByCharName'.
{CALL _ResetQuestByCharName ( 'RainyDays' )}
Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName (...
GM Stored Procs 11/11/2010 - Shaiya Private Server - 2 Replies I had asked in another thread, but should have known better since the original problem was resolved.
There are some GM Stored procs that would make certain jobs much easier from a GM perspective, but there's a piece of information I have no clue what it is, or where to get it: @GroupName
Can anyone point me in the right direction?
i got a problem with finding a item, stored in npc 08/01/2010 - Kal Online - 6 Replies yeah... my problem is this: i tryed to make a easy shophack on a pserver with following tut that was really easy to understand
6. Put at "Value type" > "Arrey Of Bytes"
At the "16-bit , 32-bit , All" << PRESS ON ALL
Vink the box at "Hyper search"
7. Now search this value : 3600370055005600BD
8. You got 1 address, Right Mouse on the address and press "Browse this memory Region"
9. You see a new window,
Upper Section & The Below Section
We are going to use the BELOW section ONLY
[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!!