[Help Thread] Please post your questions here.

Quote:

Originally Posted by thndr @tokesbowls Change the followingin ETC_Script_Functions.lua...  Spoiler function is_premium() -- ±¹°¡ ÄÚµå Àоî¿À±â -- get_local_info()ÀÇ ¹Ýȯ°ªµé --LOCAL_INFO_KOREA = 1 --LOCAL_INFO_HONGKONG = 2 --LOCAL_INFO_AMERICA = 4 --LOCAL_INFO_GERMANY = 8 --LOCAL_INFO_JAPAN = 16 --LOCAL_INFO_TAIWAN = 32 --LOCAL_INFO_CHINA = 64 --LOCAL_INFO_FRANCE = 128 --LOCAL_INFO_RUSSIA = 256 --¸»·¹ÀÌ½Ã¾Æ 512, ½Ì°¡Æú 1024, º£Æ®³² 2048, ű¹ 4096, Áßµ¿ 8192, ÅÍÅ° 16384 local state_code = get_local_info() -- Çѱ¹ÀÇ °æ¿ì º»¼·/Å×¼· ¸ðµÎ ½ÃÅ©·çÆ® ÇÁ¸®Æнº°¡ ÀÖÀ¸¸é true if state_code == 1 and gv( "premium" ) == 1 then return true end -- ½ÃÅ©·çÆ® ÇÁ¸®Æнº°¡ ÀÖÀ¸¸é true if gv( "premium" ) == 1 and scf_is_official_server( get_server_category() ) then return true end -- Å×½ºÆ® ¼*¹öÀÌ¸é ¹«Á¶°Ç true if scf_is_official_server( get_server_category() ) == false then -- return true end return false end To this...  Spoiler function is_premium() return true end @Stormyblueyes There are two monster resource tables in the repack the active table is called arcadia.dbo.MonsterResource. I am not sure what the other table is called as the repack come unpacked maybe dbo.MonsterResource_old or something like that. Change the name on the active one and change the name on the other one to the active name. This information is right on the first page of the repack release... [Only registered and activated users can see links. Click Here To Register...] @claro28111 There are a few different things you can do. 1. You can restore an original billing database. 2. You can create the billing.dbo.PaidItem in the Arcadia database and rewrite the dbo.smp_check_purchased_item to direct the inquiry to the new table in Arcadia, arcadia.dbo.PaidItem Here is some of the information you will need to create the table...  Spoiler USE [Arcadia] GO /****** Object: Table [dbo].[PaidItem] Script Date: 12/26/2014 8:37:11 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PaidItem]( [sid] [bigint] IDENTITY(1,1) NOT NULL, [buy_id] [bigint] NOT NULL, [account_id] [int] NOT NULL, [avatar_id] [int] NOT NULL, [avatar_name] [nvarchar](60) NOT NULL, [server_name] [varchar](30) NOT NULL, [taken_account_id] [int] NOT NULL, [taken_avatar_id] [int] NOT NULL, [taken_avatar_name] [nvarchar](60) NOT NULL, [taken_server_name] [varchar](30) NOT NULL, [item_code] [int] NOT NULL, [item_count] [int] NOT NULL, [type] [int] NOT NULL, [rest_item_count] [int] NOT NULL, [confirmed] [bit] NOT NULL, [confirmed_time] [datetime] NOT NULL, [bought_time] [datetime] NOT NULL, [valid_time] [datetime] NOT NULL, [taken_time] [datetime] NOT NULL, [isCancel] [bit] NOT NULL, [creationDate_] [bigint] NULL, [updateDate_] [bigint] NULL, [accessDate_] [bigint] NULL, [creatorId_] [varchar](200) NULL, [updatorId_] [varchar](200) NULL, [portId_] [varchar](200) NULL, [elixirType] [varchar](200) NULL, [pk_] [bigint] NULL, [gift] [int] NOT NULL, CONSTRAINT [PK_IDX_PaidItem] PRIMARY KEY CLUSTERED ( [sid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_avatar_id] DEFAULT ((0)) FOR [avatar_id] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_avatar_name] DEFAULT ('') FOR [avatar_name] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_server_name] DEFAULT ('') FOR [server_name] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_taken_account_id] DEFAULT ((0)) FOR [taken_account_id] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_taken_avatar_id] DEFAULT ((0)) FOR [taken_avatar_id] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_taken_avatar_name] DEFAULT ('') FOR [taken_avatar_name] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_taken_server_name] DEFAULT ('') FOR [taken_server_name] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_type] DEFAULT ((0)) FOR [type] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_rest_item_count] DEFAULT ((0)) FOR [rest_item_count] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_confirmed] DEFAULT ((0)) FOR [confirmed] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_confirmed_time] DEFAULT ('9999-12-31') FOR [confirmed_time] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_valid_time] DEFAULT ('9999-12-31') FOR [valid_time] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_taken_time] DEFAULT ('9999-12-31') FOR [taken_time] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_isCancel] DEFAULT ((0)) FOR [isCancel] GO ALTER TABLE [dbo].[PaidItem] ADD CONSTRAINT [DF_PaidItem_gift] DEFAULT ((0)) FOR [gift] GO Here is some information you will need to altar the SMP script...  Spoiler USE [Telecaster] GO /****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 12/26/2014 8:41:26 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- smp_read_purchased_item_list -- start of smp_check_purchased_item 캐쉬템 창고에 아이템 있는지 여부 검사 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 = 1, @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( GETDATE()+30 ) ) /*SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM billing.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 BILLING.Billing.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 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 Arcadia.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 Arcadia.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 You can also alternatively put the table in Auth or Telecaster. If you put it in Auth then you may never have to recreate the table unless you change Auth. Not sure what you are trying to edit in the opt files and what is not working for you. It obviously worked for you at one time because you can start your servers.

Quote:

Originally Posted by claro28111 how can i remove the abomination pet timer

Quote:

Originally Posted by Stormyblueyez Arcadia.dbo.ItemResource Find the ID# you are wanting to take timer from in this case #540073, the Abomination card Go to "decrease_type" and make it 0... "available_period" controls the time if there is a timer on it, though once "decrease_type" is 0 it is irrelevant. :) HAPPY NEW YEAR!!

Quote:

Originally Posted by claro28111 thanks but how can i edit the table (i can only edit first 200 row ) and happy new year

Quote:

Originally Posted by thndr Change your edit options to be able to edit more rows or learn how to write SQL queries to edit the SQL database. Working with SQL it might not be a bad idea to learn a little SQL  Spoiler update arcadia.dbo.ItemResource set decrease_type = 0 where id = 540073 update arcadia.dbo.ItemResource set available_period = 0 where id = 540073 Setting available_period to 0 actually does more for you the setting decrease type. If you set decrease_type the card will still say it is a timed card the time just will not ever run out. Timer but it will not decrease. If you set available_period when you make a new db_item.rdb for the client you will not have any timer on the card. Not timer to decrease.

Quote:

Originally Posted by tokesbowls Thank you all for helping me fix that issues, Now on to my next one So when i got to enchant my weapon i keep getting this error, Can anyone point me in the right direction of fixing this please and thank you Bump

Quote:

Originally Posted by tokesbowls; I have the same problem, I saw a post by someone and the reply was to sort the Mixresource.dbo out, I have had a look at it but haven't managed to sort out the problem yet

Quote:

Originally Posted by Stormyblueyez Hi All! I have searched and cannot find a fix for loot pets. The only one that works in game is the heart you get from the quest on trainee island. The rest give me an error "you cannot use this item under current conditions" when i click to name it. Would someone please inform me where I can go to and how to fix this issue? Also....... Anyone know the codes for the AOE looters? Thanks a ton!