[HELP]Edit items which character has from beginning.

03/04/2013 17:42 hiderian#1
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.
03/04/2013 20:49 Ne0@NCarbon#2
I don't know but maybe have a look at dbo.smp_insert_character, near the end of the script .........
03/04/2013 21:27 cs189#3
on_first_login.lua
dont make other useless threads
03/04/2013 22:32 xxexx#4
Quote:
Originally Posted by cs189 View Post
on_first_login.lua
dont make other useless threads
Lol, read before posting useless shit :rtfm:

@TE sorry, don't know ^^
03/05/2013 15:36 hiderian#5
Quote:
Originally Posted by Ne0@NCarbon View Post
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.
03/05/2013 23:43 ThunderNikk#6
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.
03/06/2013 05:32 hiderian#7
Quote:
Originally Posted by thndr View Post
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.
03/06/2013 07:46 TheOnlyOneRaskim#8
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 shit. :) )
03/06/2013 08:38 hiderian#9
Quote:
Originally Posted by TheOnlyOneRaskim View Post
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 shit. :) )
It doesn't have dbo.paiditem in Arcadia.
I'm using all files from [Only registered and activated users can see links. Click Here To Register...]

I edited something though.
03/06/2013 10:33 Fido Dido#10
dbo.paiditem is in Telecaster
03/06/2013 11:10 hiderian#11
Quote:
Originally Posted by Fido Dido View Post
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
03/06/2013 12:40 Fido Dido#12
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 :)
03/06/2013 12:57 hiderian#13
Quote:
Originally Posted by Fido Dido View Post
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.
03/06/2013 20:49 Ne0@NCarbon#14
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.
03/08/2013 12:59 hiderian#15
Quote:
Originally Posted by Ne0@NCarbon View Post
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.