[Help Thread] Please post your questions here.

Anothers · 12/24/2014, 19:15

thdr inventory slot add nui

underground dungeon pk off ?

Stormyblueyez · 12/25/2014, 03:47

Can someone please tell me why I am getting this error:

[string “NPC_hidden_village_buffer()”]:1: attempt to call global `NPC_hidden_village_buffer’ (a nil value)

...and not just on the hidden village buffer but most of my NPC's are the same

Thanks in advance!

tokesbowls · 12/25/2014, 04:00

Quote:

Originally Posted by Stormyblueyez

Can someone please tell me why I am getting this error:

[string “NPC_hidden_village_buffer()”]:1: attempt to call global `NPC_hidden_village_buffer’ (a nil value)

...and not just on the hidden village buffer but most of my NPC's are the same

Thanks in advance!

If im correct and dont hold me to it. But you have no .lua

Would anyone happen to have the hidden village buffer .lua
Im looking for a clean version, one that hasnt been added to or changed

Thank you.

Merry Xmas, Hope everyone has a wonderful time with their family

Stormyblueyez · 12/25/2014, 05:32

Thanks Tokes I did finally figure it out the NPC_name in Arcadia was different than my LUA so it was missing the communication between the two...

I do have a clean hidden village NPC:

Code:

Spoiler

I have adjusted this exact same code, (only addition is to buff pets too), if you want that one, let me know.

Happy Holiday!

tokesbowls · 12/25/2014, 07:28

Hello,
So im having issues access-in hv, Not sure what im doing wrong
Ive tried these codes:
910023
910001
910000

If possible id just like chars to have hv when they log in, So they can access it and buff

Thank you

Stormyblueyez · 12/26/2014, 08:03

Could someone please point me in the right direction for editing the drops in my game?
I assume there is a drop table, but not sure where to find it, and the only thing I get as drops is ingots. Prefer drops to be more normal.

Thanks in advance!

claro28111 · 12/26/2014, 12:46

guys can any one help me

every time i enter the game it's working for a little time then i got disconnected

and i got this in ( server )

p.s when i try to edit gameserver.opt or authserver

when i put them in rappelz compressor (work normally but no changes )

ThunderNikk · 12/26/2014, 14:46

@tokesbowls

Change the followingin ETC_Script_Functions.lua...

Spoiler

To this...

Spoiler

@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

Here is some information you will need to altar the SMP script...

Spoiler

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.

claro28111 · 12/26/2014, 16:09

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

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

okay where can i restore the original one and what about the rappelz compressor issue ( i can't edit any thing even the server name )

p.s (royal repack database )

ThunderNikk · 12/26/2014, 16:58

Compressor only works on C: drive but obviously it worked at one time for you.

The easiest way to see if it is working is to remove the .eop file from the folder then when you use it on the .opt file it should create a new .eop file

Let us know what happens.

I got the original billing database in the 7.4 server release.

claro28111 · 12/26/2014, 17:16

Quote:

Originally Posted by thndr

Compressor only works on C: drive but obviously it worked at one time for you.

The easiest way to see if it is working is to remove the .eop file from the folder then when you use it on the .opt file it should create a new .eop file

Let us know what happens.

I got the original billing database in the 7.4 server release.

got (no new file created

)

GAME DB INIT ERROR:[DBNETLIB][ConnectionOpen(Connect()).]Specified SQL server not found

ThunderNikk · 12/26/2014, 17:43

Did it create a new .eop file or not?

Are you using it on C: drive?

claro28111 · 12/26/2014, 17:56

it didn't create a .eop file

and i'm using c drive ^^

ThunderNikk · 12/26/2014, 18:10

So when you double click on the .exe it does open a window?

Then you drag the .opt file and drop it into the middle of the window and it does not create a new .eop file?

tokesbowls · 12/26/2014, 18:21

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

Also seems im unable to tame anything above t1, any clue why