I tried to fix LuckyCoin event but without success...
Add these lines in commonserver.cfg section GameServerInfo:
Attachment 146740Quote:
LuckyCoinEventOn = 1
LuckyCoinDropRate = 100
Printable View
I tried to fix LuckyCoin event but without success...
Add these lines in commonserver.cfg section GameServerInfo:
Attachment 146740Quote:
LuckyCoinEventOn = 1
LuckyCoinDropRate = 100
TableQuote:
Originally Posted by aecrimch
T_LUCKY_ITEM_INFO
ProceduresCode: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
WZ_LuckyItemDelete
WZ_LuckyItemInsertCode: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_LuckyItemSelectCode: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
Code: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
Thanks 4FUNer, my mistake, this has nothing to do with LuckyCoin event...:(
@Quote:
Originally Posted by Ema Leto
Ema Leto : you can sahre me yopru main plzease? i need you help, i want test with main GMO, plz help me! thank bro!
Can some one share GameServer that even works??
@Th3AnG3LQuote:
Originally Posted by Shever
Try every Gs that is in here but still not responding.
oh yes i will fix it for you npQuote:
Originally Posted by LarvasFaint
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)Quote:
Originally Posted by BladeKnight109
maybe they've added procedures there..
it not have in DB season 8.2 zteam.Quote:
Originally Posted by ftewegw1
ok then create them urself, sp_req_get_coin_count should check if there are enough coins and the other increase the countQuote:
Originally Posted by BladeKnight109
Event IllusionTemple bug from file ttlci.dll
- - - Updated - - -
missing procedure
Code:"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'"
How to add zen drop after 3rd quest?
Why not be loaded files, please reload?
