[Help Thread] Please post your questions here.

Quote:

Originally Posted by thndr Yes All of them except 1433 or whatever you set as database port. You should read the guide on server security linked in the tools thread if you are opening the database port for remote management.

Quote:

Spoiler --All stats +25% INSERT INTO [ItemResource] VALUES('3630382','13630382','23630382','1','110',' 607','21','0','0','0','1','1','0','0','0','1','1', '1','15','1','1','1','1','0','0','0','0','0.00','1 .00','10','0','0','0','0','3','0','-1090553351','0','2','0.00','0','0.00','0.00','0',' 0.00','0.00','0','0.00','0.00','0','0.00','0.00',' 98','63.00','0.25','98','8192.00','0.10','0','0.00 ','0.00','0','0.00','0.00','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','archangels_w ings_black_red','archangels_wings_black_red','arch angels_wings_black_red','archangels_wings_black_re d','archangels_wings_black_red','archangels_wings_ black_red','archangels_wings_black_red','archangel s_wings_black_red','archangels_wings_black_red','a rchangels_wings_black_red','archangels_wings_black _red','archangels_wings_black_red','archangels_win gs_black_red','archangels_wings_black_red','archan gels_wings_black_red','archangels_wings_black_red' ,'archangels_wings_black_red','archangels_wings_bl ack_red','0','drop_etc_pouch','0','icons_archangel s_wings_black_red','null','18901607','1')

Quote:

Originally Posted by gresk3k hello guys, today I write for help since I have made my own server with files rappelz 9.1 revolution. Everything works fine, you can logging, create character, leveling etc ... the problem is that: From one moment to another, without warning, trying to re-enter to rappelz, the account is crashed, all accounts, mine and all that are created, then inside the game i give an error message: --- Notice: ??????? ??????? ?????. ??????? ??? ???????? ??? ????. (1) --- And I can not use the keyboard, the bar of skills not charged and I can only move with the mouse. attached a screenshot. hopefully prompt help, thanks. IMAGE ---> [Only registered and activated users can see links. Click Here To Register...] :bandit:

USE [Telecaster]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER 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() AND isCancel = 0

	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 AND isCancel = 0

		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 BIGINT
	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

	SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND valid_time > GETDATE() AND isCancel = 0
	SELECT @OUT_NEW_ITEM_COUNT   = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0

RETURN @@ERROR

Quote:

Originally Posted by TheOnlyOneRaskim Edit: i guess you followed all steps from the 9.1 guide of smoke. But in the smps for the shopbox there was a huge mistake of declaration. @NO_Total_JP was declared as INT but it has to be BIGINT, because of the amount wich this value can reach execute this script Code: USE [Telecaster] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER 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() AND isCancel = 0 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 AND isCancel = 0 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 BIGINT 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 SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND valid_time > GETDATE() AND isCancel = 0 SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0 RETURN @@ERROR

Quote:

Originally Posted by Sherock what is the problem and how to solve it ?? Code: 2015/12/04 08:01:25 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateGlobalVariable(dbo.smp_set_global_variable) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Code: USE [TelecasterH] GO /****** Object: StoredProcedure [dbo].[smp_set_global_variable] Script Date: 12/4/2015 10:43:00 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[smp_set_global_variable] @IN_KEY NVARCHAR(128), @IN_VALUE NVARCHAR(1024) AS SET NOCOUNT ON update GlobalVariable set value = @IN_VALUE where name = @IN_KEY if @IN_KEY like '%_query' begin exec (@IN_VALUE) end

Select * from Arcadia.dbo.ItemResource

Select * from Arcadia.dbo.ItemResource where id = 910000

Quote:

Originally Posted by Space() Hi, I have two small requests for information. - How to open shops in town players ? (I saw a message, but I did not understand) - I wanted to know how to remove the enchantment fail (break) ? Thank you.

Quote:

Originally Posted by SilentWisdom From 6.2 Code: enum LOCATION_TYPE { LOCATION_ETC = 0, LOCATION_TOWN = 1, LOCATION_FIELD = 2, LOCATION_NON_PK_FIELD = 3, LOCATION_DUNGEON = 4, LOCATION_BATTLE_FIELD = 5, LOCATION_EVENTMAP = 7, LOCATION_HUNTAHOLIC_LOBBY = 8, LOCATION_HUNTAHOLIC_DUNGEON = 9, LOCATION_MARICAT_MARKET = 10, LOCATION_DEATHMATCH = 11, LOCATION_SECRET_DUNGEON = 12, };

Quote:

Originally Posted by TheOnlyOneRaskim Let me Quote SilentWisdom All Options to PK / Enable Shops / Fight Mobs etc are stored in the Worldlocation. You only need to update the right colum at the right ID. To the Enchantment .... game.enhance_fail_type is what youre searching for

Quote:

Originally Posted by Space() I would like a launcher for my server, I encountered a problem during launch. I used the source code by [Only registered and activated users can see links. Click Here To Register...] But I have an error, and it does not launch sframe. The code : Code: Process.Start("SFrame.exe /auth_ip:<IP_SERVER> /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:windows-1252 /country:US /use_nprotect:0 /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631"); this.Close(); I want to know what's wrong with my code. Thank :c