Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 08:54

  • Please register to post and access all features, it's quick, easy and FREE!

 

Hello, I have a problem with a stored procedure when you log into the game.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2012
Posts: 13
Received Thanks: 0
Hello, I have a problem with a stored procedure when you log into the game.

Posts Forum on this thread did not help me! Any thoughts about this problem, screen



KLaratel is offline  
Old   #2
 
elite*gold: 0
Join Date: Apr 2012
Posts: 26
Received Thanks: 0
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 '@%'

--IF @NO_LV < 30 AND @NO_Total_JP < 100000
--BEGIN
--SET @OUT_PREMIUM_TICKET = 1
--SET @OUT_PREMIUM_REST_TIME = 3600 * 5
--END

END

--IF @OUT_PREMIUM_REST_TIME < 3600 * 5
--BEGIN

--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 '@%'

--IF @LV < 30 AND @Total_JP < 100000
--BEGIN
--SET @OUT_PREMIUM_TICKET = 1
--SET @OUT_PREMIUM_REST_TIME = 3600 * 5
--END
--END

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

RETURN @@ERROR


trev1 is offline  
Old   #3
 
elite*gold: 0
Join Date: Mar 2010
Posts: 8
Received Thanks: 0
Errors

Attached Images
File Type: jpg 12.081.jpg (17.9 KB, 37 views)
andreas19933 is offline  
Old   #4
 
elite*gold: 0
Join Date: Oct 2010
Posts: 297
Received Thanks: 449
The smp should be in your telecaster, not in arcadia.


Pyrok is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 84
Received Thanks: 11
Quote:
Originally Posted by Pyrok View Post
The smp should be in your telecaster, not in arcadia.

+1 when i put the fix i write use telecaster not arcadia ~~
pprfds is offline  
Old   #6
 
elite*gold: 0
Join Date: Mar 2010
Posts: 8
Received Thanks: 0
Quote:
Originally Posted by Pyrok View Post
The smp should be in your telecaster, not in arcadia.
thx


andreas19933 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[BR Files] Missing stored procedure: _ResetQuestByCharName
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...
2 Replies - SRO PServer Ask the Experts
GM Stored Procs
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...
2 Replies - Shaiya Private Server
i got a problem with finding a item, stored in npc
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...
6 Replies - Kal Online
[HELP]Res toon stored Procedure
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...
0 Replies - Shaiya Private Server



All times are GMT +1. The time now is 08:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.