[Help Thread] Please post your questions here.

[claro28111]

worked ( don't run the .exe file in admin per ^^ )

thanks you ^^

[Stormyblueyez]

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



@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.

Oh wow, Thndr, I totally missed that on the front page of the Royal Repack, I guess I have read so much I cant seem to remember what I read, where.
LOL
Thanks!!


-----------------------------------------------------------------------------------------


Hi Folks... need more soul taming help PLEASE!

I could use some soul taming help.
Running RappelzMania with Slayer Repack.
I have managed to solve most of the issues and my soul taming skill is FINALLY working up to the actual tame. It will cast, and when cast will run me up to a mob to kill it.
(Thank you thndr!)
However, now, when I click on a mob, there is no indication that I can tame that mob, (the little box in the top window that says the mob is tamable is not there). When I cast and kill, nothing happens. No errors... just nothing.

>I do have the proper empties in my inventory
>I do know to kill the mob
>script_on_dead column in my dbo.monsterresource does show new taming system
>Arcadia.dbo.skillresource = state id: 48400 = state level base: 2 (is good)
>arcadia.dbo.StateResource has been checked and is good

I have checked everything that I have read in here going way back... and cannot get this skill to tame for me.

HELP please!
Thank you in advance!


Oo fixed the issue, yea me!!

[tokesbowls]

[QUOTE=tokesbowls;30556063]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

[claro28111]

how can i remove the abomination pet timer

[Stormyblueyez]

Originally Posted by claro28111

how can i remove the abomination pet timer

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

[claro28111]

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

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

[ThunderNikk]

Originally Posted by claro28111

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

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.

[Stormyblueyez]

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.

Thank for clearing that up for me as well, Thndr.
As you know I am still learning SQL too. Thanks a ton!!

HAPPY NEW YEAR!!

[Domesday Brock]

[quote=tokesbowls;30580671]

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

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

[bertie2008]

[quote=Domesday Brock;]

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 bertie2008 View Post]
Sorry, I don't understand your solution, when I try to use a strike or defense cube I get an error, This item cannot be combined/enchanted. You need to try a different combination.

I am trying to enhance R4 weapon and armor using R4 strike and defense cubes, I was trying R3 before and that did not work either

Answer by Raskim
Than your mixresource does not match with the rdb/server.

I have not fixed the pronlem yet either

[ThunderNikk]

Well I don't work with the old files so I may not be of too much help to you but what I know is...

The old files used the combine box and the newer versions use the enhance box.

You will not be able to use any newer rdb files with your older client because of this reason.

There are three database tables you may need to look at, MixResource, MixCategoryResource, ItemResource. I can not see the link between item resource cube entries and the mix tables because I enhance with cubes.

The item use flag for combining items and enhancing items is probably a different item use flag.

I am not sure what you guys have or have not tried to do to fix this but, have you tried creating the rdb files directly from the server tables.

If that has not worked then there is probably some value that you will still need to change in the server tables.

[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!

[Domesday Brock]

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!

I have the same problem with looters if I use a GM command to give myself one whereas using a NPC shop they work fine.

Ciph3r once answered someone with the same problem ike this, Quote:
if you use the gmtool to insert them you have to set the flag to 32

[ThunderNikk]

To add to what Brock posted.

AOE looters are hard coded into the 9.1 game server.

It is not an item but rather a coding in how the looter handles dropped items.

[tokesbowls]

Hello,
Im confused to why when i equipt gear to my pets it doesnt increae thier p.atk or m.atk but it increase and decrease all the rest of stats it give.

Any clue to why this is happening and how to maybe fix it?

Thank you