[HELP]Edit items which character has from beginning.

hiderian · 03/04/2013, 17:42

I want to edit the items which character has from beginning.

I mean when I create a character, some items added from the beginning.
Then, the character equips weapon, armor and bag already when I start the game as you know usually.

I'm using 8.1 server file with Arcadia and Telecaster but when I start the game with new character, the character has +20 weapons and armors. I don't want to do that so I would like to change +20 to normal (+0) or changing the other items. Also, the character has 30days Hidden Village Pass and HV Premium status so I want to remove the status too.

Well, I know how to add items with lua but I don't know how to edit it so please anyone help me...
I guess it is possible to edit them in Telecaster but I don't know how so.

Thank you very much.

Ne0@NCarbon · 03/04/2013, 20:49

I don't know but maybe have a look at dbo.smp_insert_character, near the end of the script .........

~~cs189~~ · 03/04/2013, 21:27

on_first_login.lua
dont make other useless threads

xxexx · 03/04/2013, 22:32

Quote:

Originally Posted by cs189

on_first_login.lua
dont make other useless threads

Lol, read before posting useless ****

@TE sorry, don't know ^^

hiderian · 03/05/2013, 15:36

Quote:

Originally Posted by Ne0@NCarbon

I don't know but maybe have a look at dbo.smp_insert_character, near the end of the script .........

Thank you very much. I solved this problem with dbo.smp_insert_character.

However, still not solve Hidden Village problem.

I don't know how to remove HV 30 days pass and HV state from beginning.
I checked all smp but cannot solve and also lua too.

Does anyone help me please? Thank you.

ThunderNikk · 03/05/2013, 23:43

Check lua...

ETC Script Function (c403d1bd9f1aff14710688c4358b34c2).lua

Mine looks like this...

Code:

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

The last return true is commented out.

There is an end before return false.

I don't think it can return false in this case, It may also have nothing to do with it but I did not find anything in Server Init, On Login, or On First Login.

hiderian · 03/06/2013, 05:32

Quote:

Originally Posted by thndr

Check lua...

ETC Script Function (c403d1bd9f1aff14710688c4358b34c2).lua

Mine looks like this...

Code:

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

The last return true is commented out.

There is an end before return false.

I don't think it can return false in this case, It may also have nothing to do with it but I did not find anything in Server Init, On Login, or On First Login.

Mine is also all same with yours...
Probably it's not about lua problem because when I used 7.4, I used same that lua and the player does not have HV. I think I need to fix db but I don't know where should I fix.

TheOnlyOneRaskim · 03/06/2013, 07:46

check your dbo.paiditem for the code of 910000 or 010023 and if they exist. delete them.

Otherwise you should edit the worldbuffs wich were given on the server init. (im pretty sure youre using gavstas ****.

)

hiderian · 03/06/2013, 08:38

Quote:

Originally Posted by TheOnlyOneRaskim

check your dbo.paiditem for the code of 910000 or 010023 and if they exist. delete them.

Otherwise you should edit the worldbuffs wich were given on the server init. (im pretty sure youre using gavstas ****. )

It doesn't have dbo.paiditem in Arcadia.
I'm using all files from

I edited something though.

Fido Dido · 03/06/2013, 10:33

dbo.paiditem is in Telecaster

hiderian · 03/06/2013, 11:10

Quote:

Originally Posted by Fido Dido

dbo.paiditem is in Telecaster

Mmm... There is no dbo.paiditem in Telecaster and also Arcadia too. However there's in Billing but no information added in dbo.paiditem in Billing.

By the way, I found the code that 91000 in dbo.smp_read_purchased_item_list for dbo.paiditem. But it's not necessary to fix here right?

Code:

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_read_purchased_item_list]    Script Date: 2013/03/06 19:02:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- smp_takeout_commercial_item

-- start of smp_read_purchased_item_list   캐쉬템 창고 보는거
ALTER PROCEDURE [dbo].[smp_read_purchased_item_list]

@IN_ACCOUNT_ID		INT
 
AS
SET NOCOUNT ON


UPDATE billing.dbo.PaidItem set confirmed = 1 WHERE taken_account_id = @IN_ACCOUNT_ID and confirmed = 0;

SELECT  sid,                          -- ID
        account_id,            -- 구매한 계정 ID
        avatar_id,             -- 구매한 캐릭 ID        ( -1 일경우홈피에서구매한것임)
        avatar_name,           -- 구매한 캐릭 이름        ( -1 일경우홈피에서구매한것임)
        server_name,			  -- 구매한 서버 이름
        item_code,             -- 아이템코드
        item_count,            -- 구매한 아이템갯수
        rest_item_count,		  -- 남은 아이템 갯수
        bought_time,           -- 구매시간
        valid_time             -- 유효시간( 제한없을경우-12-31 )
               
        FROM billing.dbo.PaidItem WITH (NOLOCK) WHERE taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0 
	AND item_code <> 910000 AND isCancel = 0 ORDER BY sid;
	
	RETURN @@ERROR

Fido Dido · 03/06/2013, 12:40

i don't know a fix for youre issue, i have that table in my db @ telecaster and so do others i think, i would make a new db (for test) and restore the telecaster you used in the new db, the see if paiditem is still missing.

Though i looked in my paiditem table, its empty and i do have a HV item so im not sure if its stored in there maybe its a lua issue. check the on login and on first login to see if you find the hv code there (not sure if you looked both

)

else this script can add the table into ur db but remember its older version (i think repack was from like early epic 7 or maybe even modded from 6)

Code:

USE [Telecaster]
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaidItem](
	[sid] [int] IDENTITY(1,1) NOT NULL,
	[account_id] [int] NULL,
	[avatar_id] [int] NULL,
	[avatar_name] [varchar](61) NULL,
	[item_code] [int] NULL,
	[item_count] [int] NULL,
	[rest_item_count] [int] NULL,
	[bought_time] [datetime] NULL,
	[valid_time] [datetime] NULL,
	[server_name] [varchar](30) NULL,
	[taken_avatar_id] [int] NULL,
	[taken_avatar_name] [varchar](61) NULL,
	[taken_server_name] [varchar](30) NULL,
	[taken_time] [datetime] NULL,
	[taken_account_id] [int] NULL,
	[confirmed] [int] NULL,
	[confirmed_time] [date] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Just for the record, im still running the 1.3 repack from ncarbon, never tried the newer ones, perhaps they changed a name or whatever

.

good luck on solving it

hiderian · 03/06/2013, 12:57

Quote:

Originally Posted by Fido Dido

i don't know a fix for youre issue, i have that table in my db @ telecaster and so do others i think, i would make a new db (for test) and restore the telecaster you used in the new db, the see if paiditem is still missing.

else this script can add the table into ur db but remember its older version (i think repack was from like early epic 7 or maybe even modded from 6)

USE [Telecaster]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaidItem](
[sid] [int] IDENTITY(1,1) NOT NULL,
[account_id] [int] NULL,
[avatar_id] [int] NULL,
[avatar_name] [varchar](61) NULL,
[item_code] [int] NULL,
[item_count] [int] NULL,
[rest_item_count] [int] NULL,
[bought_time] [datetime] NULL,
[valid_time] [datetime] NULL,
[server_name] [varchar](30) NULL,
[taken_avatar_id] [int] NULL,
[taken_avatar_name] [varchar](61) NULL,
[taken_server_name] [varchar](30) NULL,
[taken_time] [datetime] NULL,
[taken_account_id] [int] NULL,
[confirmed] [int] NULL,
[confirmed_time] [date] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Just for the record, im still running the 1.3 repack from ncarbon, never tried the newer ones, perhaps they changed a name or whatever .

good luck on solving it

Thank you for your advice.
I added dbo.paiditem however no information has recorded... But I appreciate it. I'm going to try to fix with other way.

Ne0@NCarbon · 03/06/2013, 20:49

Hidden Village Passport as Raskim said is given on server init as a world buff.
Go to the end of the lua file (b4e51c7c6f9cd671cf2bb33b2aa2d263.lua) and search for add_event_state(9004,1)
Remove this and restart gs, it will remove the passport.

hiderian · 03/08/2013, 12:59

Quote:

Originally Posted by Ne0@NCarbon

Hidden Village Passport as Raskim said is given on server init as a world buff.
Go to the end of the lua file (b4e51c7c6f9cd671cf2bb33b2aa2d263.lua) and search for add_event_state(9004,1)
Remove this and restart gs, it will remove the passport.

It doesn't have add_event_state(9004,1). I've checked all luas and chenged to lua files which I used at 7.4(it doesn't have HV pass) but it still adding HV pass. So I guess it's not lua problem.