nelson25
Active Member
- Joined
- Apr 1, 2017
- Messages
- 209
- Reaction score
- 65
25 December, will be like a christmass present@DarkMaster When would the launch of the next update be planned?
@DarkMaster + Fixed /move command not checking terrain attr+ Fixed /move command not checking terrain attr
+ Added Dungeon Race event
+ Added /summonchar command
+ Added /changepartyleader command
EledoradoDevilLizardKingRegenTime = 60
EledoradoDevilTantarosRegenTime = 60
EledoradoGoldGoblenItemDropRate = 90
EledoradoGoldGoblenExItemDropRate = 60
EledoradoTitanItemDropRate = 80
EledoradoTitanExItemDropRate = 50
EledoradoGoldDerconItemDropRate = 70
EledoradoGoldDerconExItemDropRate = 40
EledoradoDevilLizardKingItemDropRate = 60
EledoradoDevilLizardKingExItemDropRate = 30
EledoradoDevilTantarosItemDropRate = 50
EledoradoDevilTantarosExItemDropRate = 20
This has nothing to do with the .dll. You are trying to drop a non-excellent items while there are none in the eventitembags, hence leading to a crash /another gap of Webzen/.@DarkMaster, I can't change the BOK drop rate lower than 100 be cause it crashes the gameserver.
Code:EledoradoDevilLizardKingRegenTime = 60 EledoradoDevilTantarosRegenTime = 60 EledoradoGoldGoblenItemDropRate = 90 EledoradoGoldGoblenExItemDropRate = 60 EledoradoTitanItemDropRate = 80 EledoradoTitanExItemDropRate = 50 EledoradoGoldDerconItemDropRate = 70 EledoradoGoldDerconExItemDropRate = 40 EledoradoDevilLizardKingItemDropRate = 60 EledoradoDevilLizardKingExItemDropRate = 30 EledoradoDevilTantarosItemDropRate = 50 EledoradoDevilTantarosExItemDropRate = 20
Is it not possible to have a config similar to the snippet above? Or is there config in DTData I can manage drop rate for BOK? I wanted BOK to not always drop item 100%. In gameserver without the darksteam.dll it's doable.
Many thanks.
Thanks for the enlightenment. Will test an updated eventitembags . I agree with /another gap of Webzen/This has nothing to do with the .dll. You are trying to drop a non-excellent items while there are none in the eventitembags, hence leading to a crash /another gap of Webzen/.
Your eventitembags are not configured properly.
What should this command do? Do you mean /createmob?DarkMaster add Comand /createmod
anyone knows how to add starting reset in stored procedure... thanks
-- Update query for the resets and levelup points
declare @totalpoints int -- Declare integer variable totalpoints
if (@Class = 2) or (@Class = 1) or (@Class = 0) -- SM
begin
SET @totalpoints = 500
end
else if(@Class = 16) or (@Class = 17) or (@Class = 18) -- BK
begin
SET @totalpoints = 600
end
else if(@Class = 32) or (@Class = 33) or (@Class = 34) -- Elf
begin
SET @totalpoints = 700
end
else if(@Class = 48) or (@Class = 49) -- MG
begin
SET @totalpoints = 800
end
else if(@Class = 64) or (@Class = 65) -- MG
begin
SET @totalpoints = 900
end
UPDATE Dbo.Character SET Resets = @Resets, LevelUpPoint = @totalpoints WHERE Name = @Name
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CreateCharacter] Script Date: 12/15/2018 11:04:26 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/*
1) 橇肺矫廉疙 : WZ_CreateCharacter
2) 累诀老 : 2003. 09. 15.
3) 累诀磊疙 : 眠槛
4) 傈崔牢磊 :
拌沥沥焊, 某腐磐疙, 努贰胶 鸥涝, 己傍咯何 馆券沥焊
5) 馆券牢磊(Result) :
1 : 悼老 某腐磐疙 粮犁
2 : 后浇吩捞 粮犁 窍瘤 臼澜
3 何磐 ~ : SQL Error Code
6) 努贰胶 鸥涝
0 : 孺付过荤
16 : 孺扁荤
32 : 夸沥
48 : 付八荤
64:促农肺靛
7) VERSION
1
8) Last Update Date : 2004.06.15
2003.10.16 : 飘罚黎记 困摹 坷幅 (SaemSong)
BEGIN TRAN 巩捞 甸绢啊扁 傈俊 悼老某腐疙 粮犁矫 ProcEnd 肺 GOTO 茄促
捞锭, ProcEnd俊急 费归捞唱 目乖阑 角青窍骨肺 牢秦
TranProcEnd甫 眠啊窍咯 飘罚璃记 贸府甫 窍瘤 臼绰 镑栏肺 GOTO茄促.
*/
ALTER Procedure [dbo].[WZ_CreateCharacter]
@AccountID varchar(10), --// 拌沥 沥焊
@Name varchar(10), --// 某腐磐
@Class tinyint, --// Class Type
@Resets INT,
@LevelUpPoint INT
AS
Begin
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @Result tinyint
--// 搬苞蔼 檬扁拳
SET @Result = 0x00
SET @Resets = 0 -- // Put your resets here
SET @LevelUpPoint = 0 -- // Put your leveluppoints here
--====================================================================================
-- 某腐磐 粮犁咯何 犬牢
--====================================================================================
If EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
begin
SET @Result = 0x01 --// 悼老 某腐磐疙 粮犁
GOTO ProcEnd
end
BEGIN TRAN
--====================================================================================
-- 拌沥 粮犁 咯何 犬牢 棺 后 浇吩 沥焊 犬牢窍咯 历厘
--====================================================================================
If NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID )
begin
INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)
SET @Result = @@Error
end
else
begin
--// 某腐磐 后 浇吩 汲沥
Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID
if( ( @g1 Is NULL) OR (Len(@g1) = 0))
begin
UPDATE AccountCharacter SET GameID1 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else if( @g2 Is NULL OR Len(@g2) = 0)
begin
UPDATE AccountCharacter SET GameID2 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else if( @g3 Is NULL OR Len(@g3) = 0)
begin
UPDATE AccountCharacter SET GameID3 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else if( @g4 Is NULL OR Len(@g4) = 0)
begin
UPDATE AccountCharacter SET GameID4 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else if( @g5 Is NULL OR Len(@g5) = 0)
begin
UPDATE AccountCharacter SET GameID5 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else
--// 秦寸 后 浇吩 沥焊啊 粮犁 窍瘤 臼促.
begin
SET @Result = 0x03
GOTO TranProcEnd
end
end
--====================================================================================
-- 某腐磐 沥焊 历厘
--====================================================================================
if( @Result <> 0 )
begin
GOTO TranProcEnd
end
else
begin
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership )
SELECT @AccountID As AccountID, @Name As Name, Level, LevelUpPoint, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership
FROM DefaultClassType WHERE Class = @Class
-- Update query for the resets and levelup points
UPDATE Dbo.Character SET Resets = @Resets, LevelUpPoint = @LevelUpPoint WHERE Name = @Name
SET @Result = @@Error
end
TranProcEnd: -- GOTO
IF ( @Result <> 0 )
ROLLBACK TRAN
ELSE
COMMIT TRAN
ProcEnd:
SET NOCOUNT OFF
SET XACT_ABORT OFF
--====================================================================================
-- 搬苞蔼 馆券 贸府
-- 0x00 : 某腐磐 粮犁, 0x01 : 己傍肯丰, 0x02 : 某腐磐 积己 角菩 , 0x03 : 后浇吩 粮犁窍瘤 臼绰促
--====================================================================================
SELECT
CASE @Result
WHEN 0x00 THEN 0x01 --// 己傍 馆券
WHEN 0x01 THEN 0x00 --// 某腐磐 粮犁
WHEN 0x03 THEN 0x03 --// 后浇吩捞 粮犁窍瘤 臼绰促.
ELSE 0x02 --// 扁鸥 俊矾内靛绰 积己 圾菩 馆券
END AS Result
End
Try this edited procedure. Bare in mind that your create character procedure may be different and if that is so, just use the logic behind. I left comments where are needed. I have not tested it, because do not server running but should work.
You have another option as well instead of using a procedure to re-design the Resets and Leveluppoints column in character with the required defaults. Say you want a character to have 1 reset on start, you just put 1 as a default and so on for the rest.
PS. Little adding to that if you give the players more or less points depending on the class type something like this should do the job. Of course the points and classes are just for an example:
SQL:-- Update query for the resets and levelup points declare @totalpoints int -- Declare integer variable totalpoints if (@Class = 2) or (@Class = 1) or (@Class = 0) -- SM begin SET @totalpoints = 500 end else if(@Class = 16) or (@Class = 17) or (@Class = 18) -- BK begin SET @totalpoints = 600 end else if(@Class = 32) or (@Class = 33) or (@Class = 34) -- Elf begin SET @totalpoints = 700 end else if(@Class = 48) or (@Class = 49) -- MG begin SET @totalpoints = 800 end else if(@Class = 64) or (@Class = 65) -- MG begin SET @totalpoints = 900 end UPDATE Dbo.Character SET Resets = @Resets, LevelUpPoint = @totalpoints WHERE Name = @Name
SQL:USE [MuOnline] GO /****** Object: StoredProcedure [dbo].[WZ_CreateCharacter] Script Date: 12/15/2018 11:04:26 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO /* 1) 橇肺矫廉疙 : WZ_CreateCharacter 2) 累诀老 : 2003. 09. 15. 3) 累诀磊疙 : 眠槛 4) 傈崔牢磊 : 拌沥沥焊, 某腐磐疙, 努贰胶 鸥涝, 己傍咯何 馆券沥焊 5) 馆券牢磊(Result) : 1 : 悼老 某腐磐疙 粮犁 2 : 后浇吩捞 粮犁 窍瘤 臼澜 3 何磐 ~ : SQL Error Code 6) 努贰胶 鸥涝 0 : 孺付过荤 16 : 孺扁荤 32 : 夸沥 48 : 付八荤 64:促农肺靛 7) VERSION 1 8) Last Update Date : 2004.06.15 2003.10.16 : 飘罚黎记 困摹 坷幅 (SaemSong) BEGIN TRAN 巩捞 甸绢啊扁 傈俊 悼老某腐疙 粮犁矫 ProcEnd 肺 GOTO 茄促 捞锭, ProcEnd俊急 费归捞唱 目乖阑 角青窍骨肺 牢秦 TranProcEnd甫 眠啊窍咯 飘罚璃记 贸府甫 窍瘤 臼绰 镑栏肺 GOTO茄促. */ ALTER Procedure [dbo].[WZ_CreateCharacter] @AccountID varchar(10), --// 拌沥 沥焊 @Name varchar(10), --// 某腐磐 @Class tinyint, --// Class Type @Resets INT, @LevelUpPoint INT AS Begin SET NOCOUNT ON SET XACT_ABORT ON DECLARE @Result tinyint --// 搬苞蔼 檬扁拳 SET @Result = 0x00 SET @Resets = 0 -- // Put your resets here SET @LevelUpPoint = 0 -- // Put your leveluppoints here --==================================================================================== -- 某腐磐 粮犁咯何 犬牢 --==================================================================================== If EXISTS ( SELECT Name FROM Character WHERE Name = @Name ) begin SET @Result = 0x01 --// 悼老 某腐磐疙 粮犁 GOTO ProcEnd end BEGIN TRAN --==================================================================================== -- 拌沥 粮犁 咯何 犬牢 棺 后 浇吩 沥焊 犬牢窍咯 历厘 --==================================================================================== If NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID ) begin INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL) SET @Result = @@Error end else begin --// 某腐磐 后 浇吩 汲沥 Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10) SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID if( ( @g1 Is NULL) OR (Len(@g1) = 0)) begin UPDATE AccountCharacter SET GameID1 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g2 Is NULL OR Len(@g2) = 0) begin UPDATE AccountCharacter SET GameID2 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g3 Is NULL OR Len(@g3) = 0) begin UPDATE AccountCharacter SET GameID3 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g4 Is NULL OR Len(@g4) = 0) begin UPDATE AccountCharacter SET GameID4 = @Name WHERE Id = @AccountID SET @Result = @@Error end else if( @g5 Is NULL OR Len(@g5) = 0) begin UPDATE AccountCharacter SET GameID5 = @Name WHERE Id = @AccountID SET @Result = @@Error end else --// 秦寸 后 浇吩 沥焊啊 粮犁 窍瘤 臼促. begin SET @Result = 0x03 GOTO TranProcEnd end end --==================================================================================== -- 某腐磐 沥焊 历厘 --==================================================================================== if( @Result <> 0 ) begin GOTO TranProcEnd end else begin INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership ) SELECT @AccountID As AccountID, @Name As Name, Level, LevelUpPoint, @Class As Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership FROM DefaultClassType WHERE Class = @Class -- Update query for the resets and levelup points UPDATE Dbo.Character SET Resets = @Resets, LevelUpPoint = @LevelUpPoint WHERE Name = @Name SET @Result = @@Error end TranProcEnd: -- GOTO IF ( @Result <> 0 ) ROLLBACK TRAN ELSE COMMIT TRAN ProcEnd: SET NOCOUNT OFF SET XACT_ABORT OFF --==================================================================================== -- 搬苞蔼 馆券 贸府 -- 0x00 : 某腐磐 粮犁, 0x01 : 己傍肯丰, 0x02 : 某腐磐 积己 角菩 , 0x03 : 后浇吩 粮犁窍瘤 臼绰促 --==================================================================================== SELECT CASE @Result WHEN 0x00 THEN 0x01 --// 己傍 馆券 WHEN 0x01 THEN 0x00 --// 某腐磐 粮犁 WHEN 0x03 THEN 0x03 --// 后浇吩捞 粮犁窍瘤 臼绰促. ELSE 0x02 --// 扁鸥 俊矾内靛绰 积己 圾菩 馆券 END AS Result End
+ Added /deposit, /withdraw and /zenbank commands[Diamond Edition - Work in progress]
Fixed another dupe bug
Added ability to specify Sky event reward item min/max level and count
Added ability to disable custom CalCharacter
Fixed another /vault dupe bug
Fixed Happy Hour event message
Fixed Quest system counting monsters multiple times when using Poison skill
Improved Sky event monster spawner - no more monster spawning issues
Added ability to control elf and npc buff duration
Added ability to toggle anti afk chat check
Ability ability to control elf buffs
Added ability to set Blood Castle minimum completion time
Added ability to disable Ice Arrow's effect on specific mobs (ie golden monsters)
Added new Worm event with ability to drop custom items, zen, credits and save kills in SQL
Added ability to disallow elf buffs in Blood Castle /per blood castle level/
Added ability to disable Poison effect on specific mobs
Added new Trivia event with ability to drop custom items, zen, credits and save answers (count) in SQL
Optimized VIP expiration SQL query
Added new Scramble Words event with ability to drop custom items, zen, credits and save answers (count) in SQL
Added player vs player damage multiplier /per class/
Added ability to save post logs to a file
Post bans are now saved in the database
Tweaked post ban system to support time-based bans with automatic expiration
Tweaked /banpost to work with the new time-based banning system (/banpost <player> <time>)
/tracemarry cooldown is now saved in the database
Quest system is now using QuestInProgress column instead of QuestInCurse (old data will be automatically synced)
Tweaked /banchar and /unbanchar commands
Tweaked quest system rewards configuration
Added ability to change /post, /buy and /sell commands prefix
Added ability to change marry request timeout
Added a message when marry request expires
Added new quest system npc
Improved custom commands handler
Dynamic exp system can now be enabled/disabled directly from its configuration file
Tweaked VIP system to support multiple packages with different price/exp/drop/points per level/duration
Added ability to save GM logs to a file
Added ability to change /gg command format
Tweaked GM system to support custom tags (ie [GM], [ADMIN])
Added player joining message with ability to select between 4 colors
Added ability to disallow elf buffs in Devil Square /per room/
Added ability to save chat logs to a file (regular chat, whisper, party chat, guild chat, post)
Added ability to change MEMB_CREDITS table and columns
All customs can now be reloaded with /reload 3 as well as directly from the gameserver
Added ability to control npc buffers buff (mana shield, swell of life, elf damage, elf defense and buff duration)
! (global chat), /trace and /disconnect commands can now be controled through the gm system
Added ability to change max zen in trade
Fixed 2nd level wings mix not counting other items
Added min/max success rate for 2nd level wings
Added separate Blood Castle awards file with ability to set multiple rewards /per blood castle level/
Elf summons and Transformation rings now supports values higher than 127
Improved shadow bug detection
Fixed another Golden Archer dupe
Fixed character deletion during gameplay packet
Fixed inventory item move dupe packet
Fixed party with npc crash packet
Added ip banning system
Added /banip and /unbanip commands
Added ability to limit Swell of Life's additional life and time
Added ability to limit Mana Shield's additional defense and time
Event Manager now starts custom events instantly, instead of every 60 seconds
You can now include character's name in the connect notice
Improved anti-afk detection
Added ability to limit specific afk safe-zones to VIPs only
Added ability to set different points per level/resets/grand resets
Added ability to limit maximum connections per ip
Tweaked npc buffers loading and spawning process
Added /banchat and /unbanchat commands with ability to ban for a certain period of time
Added ability to set which chat logs to be saved to a file (general, whisper, party, guild, post)
Added Chat Filter (censoring) system with ability to ban chatting for a certain period of time
Added /addcredits command
Added /getip command
Added ability to create zones where no items/zen will be dropped from mobs - useful when there are lots of drops and monsters become "invisible"
Tweaked item drop system with ability to set min/max excellent options
Fixed Sky Event not unregistering players upon death
/drop command now shows dropped item name
Added ability to drop multiple items with /drop
/evo command no longer requires a relog to complete the quest
Added Bring Me Event
Added ability to change switch character/select server/exit game delay
Characters in GMSystem.dat are now shown as game masters in the character select screen
Added ability to save player kills/deaths in SQL
Added ability to limit warps to game masters only
Tweaked /add command to add points without relog
Tweaked /reset command to reset character's data without relog
Fixed speed bug - all skills now work properly with 32767 agility
Added basic hand attack limiter (anti speed hack)
Added ability to disable character buffs (/buffon & /buffoff <duration>)
Added ability to prevent murderers from using /tracemarry
Added ability to allow/disallow killing party members
Added ability to turn off game master's protection (/invul on/off)
Fixed guildwar ending delay
Quest points are now saved in a separate column (with ability to include them when resetting/grand resetting)
Added /addzen <player name> <amount> command
Added ability to skip quests (/skipquest) + ability to set a limit
Added /resetstats command
Added /autoparty <level gap> command (automatically accept party requests fron players within the level gap)
Added /dcfriend <player name> <personal id> command
Added ability to save specific monster kills in SQL
Added ability to save pvp kills in SQL (killer, victim, date)
Added /totalkills command
Pk count will no longer be resetted when using the /pkclear command
Marriage date will now be saved in a separate column
Added ability to set min/max success rate of 1st level wings chaos mix
Added /setparty <password> command (automatically adds you to the party when private messaging the password)
Added /hide on/off command
Fixed dynamic exp system not working properly in Devil Square
Added ability to give custom item award in Devil Square
Added ability to automatically reload ConnectMember.txt file
Added /pkset command
Added /pack (and /unpack) chaos/bless/soul/life command
Fixed /move command not checking terrain attr
Added Dungeon Race event
Added /summonchar command
Added /changepartyleader command
25 december, christmas present, i posted before)@DarkMaster When would the launch of the next update be planned?