[Release] zTeam Season 6 EP3 + Source

[aecrimch]

I tried to fix LuckyCoin event but without success...
Add these lines in commonserver.cfg section GameServerInfo:

LuckyCoinEventOn = 1
LuckyCoinDropRate = 100

[2009x2014]

i found error: missing WZ_LuckyItemInsert procedure...does anybody have this procedure and maybe missing tables?

Table
T_LUCKY_ITEM_INFO

USE [MuOnline]
GO
/****** Object:  Table [dbo].[T_LUCKY_ITEM_INFO]    Script Date: 07/12/2014 09:47:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_LUCKY_ITEM_INFO](
	[nIndex] [int] IDENTITY(1,1) NOT NULL,
	[UserGuid] [int] NOT NULL,
	[CharName] [varchar](10) NOT NULL,
	[ItemCode] [int] NOT NULL,
	[ItemSerial] [bigint] NOT NULL,
	[DurabilitySmall] [smallint] NOT NULL,
 CONSTRAINT [PK_T_LUCKY_ITEM_INFO] PRIMARY KEY CLUSTERED 
(
	[CharName] ASC,
	[ItemCode] ASC,
	[ItemSerial] 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 ON
GO

Procedures

WZ_LuckyItemDelete

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_LuckyItemDelete]    Script Date: 07/12/2014 09:39:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




/****************************************************************
-- 2.CREATE PROC
*****************************************************************/

/****************************************************************
TITLE    :	钒虐酒捞袍 昏力

EX       :	WZ_LuckyItemDelete

PROJECT  :	Season 6

CALL     : 

INPUT    : 

OUTPUT   :  @ErrorCode 
			0 : 己傍
			2 : 角菩

REVERSION:
-------------------------------------------------------------------
DATE		Author				Description		
-------------------------------------------------------------------
2010-09-16	傍饶琶[MU_STUDIO]	弥檬 累己
-------------------------------------------------------------------	
*****************************************************************/
ALTER  PROC  [dbo].[WZ_LuckyItemDelete]
  @CharacterName varchar(10)
,@ItemCode	int
,@ItemSerial	bigint
AS  
DELETE	T_LUCKY_ITEM_INFO 
WHERE	CharName =  @CharacterName AND ItemCode = @ItemCode AND ItemSerial = @ItemSerial

WZ_LuckyItemInsert

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_LuckyItemInsert]    Script Date: 07/12/2014 09:39:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




/****************************************************************
TITLE    :	钒虐酒捞袍 积己

EX       :	WZ_LuckyItemInsert

PROJECT  :	Season 6

CALL     : 

INPUT    : 

OUTPUT   :  @ErrorCode 
			0 : 己傍
			2 : 角菩

REVERSION:
-------------------------------------------------------------------
DATE		Author				Description		
-------------------------------------------------------------------
2010-09-16	傍饶琶[MU_STUDIO]	弥檬 累己
2011-04-14	C.H.O			  @durabilitySmall tinyint -> smallint
-------------------------------------------------------------------	
*****************************************************************/
ALTER  PROC  [dbo].[WZ_LuckyItemInsert]  
  @userGuid 			int
  @CharName			varchar(10)
,@ItemCode			int
,@ItemSerial		bigint
  @durabilitySmall	smallint
AS         
DECLARE  @ErrorCode int        
SET  @ErrorCode = 0        

SET NOCOUNT ON    
SET	XACT_ABORT ON
        
BEGIN TRAN

-- -----------------------------------------------------------------
-- 沥焊啊 绝促搁....        
-- -----------------------------------------------------------------
IF NOT EXISTS (SELECT ItemCode FROM T_LUCKY_ITEM_INFO  WITH ( READUNCOMMITTED )         
WHERE CharName =  @CharName AND ItemCode = @ItemCode AND ItemSerial  = @ItemSerial
and	UserGuid =  @userGuid)
BEGIN            
	INSERT INTO T_LUCKY_ITEM_INFO (UserGuid, CharName, ItemCode, ItemSerial, DurabilitySmall) 
	VALUES    @userGuid,  @CharName, @ItemCode, @ItemSerial,  @durabilitySmall)    
END       

-- ----------------------------------------------------------------- 
--沥焊啊 乐促搁 盎脚
-- -----------------------------------------------------------------
ELSE        
BEGIN    
	UPDATE T_LUCKY_ITEM_INFO 
	SET	DurabilitySmall =  @durabilitySmall
	WHERE CharName =  @CharName AND ItemCode = @ItemCode AND ItemSerial  = @ItemSerial 
	and	UserGuid =  @userGuid
END        

IF(   @ERROR <> 0 )        
BEGIN        
SET  @ErrorCode = 2        
END        

IF (  @ErrorCode  <> 0 ) 
ROLLBACK TRAN       
ELSE        
COMMIT TRAN

SELECT  @ErrorCode        

SET	XACT_ABORT OFF        
SET NOCOUNT OFF

WZ_LuckyItemSelect

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_LuckyItemSelect]    Script Date: 07/12/2014 09:40:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





/****************************************************************
TITLE    :	钒虐酒捞袍 炼雀

EX       :	WZ_LuckyItemSelect

PROJECT  :	Season 6

CALL     : 

INPUT    :   @CharacterName

OUTPUT   :	

REVERSION:
-------------------------------------------------------------------
DATE		Author				Description		
-------------------------------------------------------------------
2010-09-16	傍饶琶[MU_STUDIO]	弥檬 累己
-------------------------------------------------------------------	
*****************************************************************/
ALTER  PROC [dbo].[WZ_LuckyItemSelect]
  @CharacterName varchar(10)  
AS  
SELECT	ItemCode, ItemSerial, DurabilitySmall 
FROM	T_LUCKY_ITEM_INFO 
WHERE	CharName =  @CharacterName

[aecrimch]

Thanks 4FUNer, my mistake, this has nothing to do with LuckyCoin event...:(

[tranphuoctai]

No lucky items... this:

@

Ema Leto : you can sahre me yopru main plzease? i need you help, i want test with main GMO, plz help me! thank bro!

[Shever]

Can some one share GameServer that even works??

[LarvasFaint]

Can some one share GameServer that even works??

@Th3AnG3L

[Shever]

Try every Gs that is in here but still not responding.

[Th3AnG3L]

@Th3AnG3L

oh yes i will fix it for you np

[BladeKnight109]

who have Database Season 6 ep 3 original Webzen? please share me.

- - - Updated - - -

missing procedure 'SP_REQ_GET_COIN_COUNT' and procedure 'SP_REQ_REGEIST_COIN'

[ftewegw1]

who have Database Season 6 ep 3 original Webzen? please share me.

- - - Updated - - -

missing procedure 'SP_REQ_GET_COIN_COUNT' and procedure 'SP_REQ_REGEIST_COIN'

did u try downloading latest zteam dbs? (s 8.2)
maybe they've added procedures there..

[BladeKnight109]

did u try downloading latest zteam dbs? (s 8.2)
maybe they've added procedures there..

it not have in DB season 8.2 zteam.

[ftewegw1]

it not have in DB season 8.2 zteam.

ok then create them urself, sp_req_get_coin_count should check if there are enough coins and the other increase the count

[BladeKnight109]

Event IllusionTemple bug from file ttlci.dll

- - - Updated - - -

missing procedure

"EXEC SP_REG_HT_OFFLINE_GIFT '%s', '%s', %d"
"EXEC SP_REQ_POSSIBLE_PCBANG_COUPON_EVENT '%s'"
"EXEC SP_REQ_USE_PCBANG_COUPON_EVENT '%s'"
"EXEC SP_CHECK_WHITEANGEL_GET_ITEM_EVENT '%s'"
"EXEC SP_REQ_WHITEANGEL_GET_ITEM '%s'"
"EXEC SP_REQ_PCBANG_POINT_INFO_TS '%s'"
"EXEC SP_REQ_PCBANG_POINT_INFO '%s'"
"EXEC SP_REQ_PCBANG_POINT_UPDATE_TS '%s', %d"
"EXEC SP_REQ_PCBANG_POINT_UPDATE '%s', %d"
"EXEC SP_UPDATE_PCBANG_POINT_RANKING_EVENT_TS '%s', %d"
"EXEC SP_REG_ILLUSION_TEMPLE_RANKPOINT '%s', '%s', %d, %d, %d, %d, %d, %d, %d"
"EXEC SP_CHECK_ALANS_LIST '%s'"
"EXEC SP_GET_ALANS_ITEM '%s'"
"EXEC SP_REQ_GET_COIN_COUNT %d, '%s', '%s' "
"EXEC SP_REQ_REGEIST_COIN %d, '%s', '%s', 1 "
"EXEC SP_REQ_IMPERIALGUARDIAN_EVENT %d, '%s', '%s', 1 "
"EXEC SP_REG_DOPPELGANGER_CLEAR %d, '%s', '%s'"

[bukiet]

How to add zen drop after 3rd quest?

[ponteleymon]

Why not be loaded files, please reload?