Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 18:01

  • 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 You must register and activate your account in order to view images.



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: 296
Received Thanks: 432
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 +2. The time now is 18:01.


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

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