nelson25
Active Member
- Joined
- Apr 1, 2017
- Messages
- 211
- Reaction score
- 66
[Release] DarksTeam MuServer 97d+99i Beta 43.3
- Thread starter DarkMaster
- Start date
Speedy
Dorin
- Joined
- Mar 12, 2014
- Messages
- 124
- Reaction score
- 44
25 December, will be like a christmass present
nelson25
Active Member
- Joined
- Apr 1, 2017
- Messages
- 211
- Reaction score
- 66
nelson25
Active Member
- Joined
- Apr 1, 2017
- Messages
- 211
- Reaction score
- 66
pdnet
New Member
- Joined
- Oct 17, 2018
- Messages
- 19
- Reaction score
- 7
@DarkMaster, I can't change the BOK drop rate lower than 100 be cause it crashes the gameserver.
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.
Code:
EledoradoDevilLizardKingRegenTime = 60
EledoradoDevilTantarosRegenTime = 60
EledoradoGoldGoblenItemDropRate = 90
EledoradoGoldGoblenExItemDropRate = 60
EledoradoTitanItemDropRate = 80
EledoradoTitanExItemDropRate = 50
EledoradoGoldDerconItemDropRate = 70
EledoradoGoldDerconExItemDropRate = 40
EledoradoDevilLizardKingItemDropRate = 60
EledoradoDevilLizardKingExItemDropRate = 30
EledoradoDevilTantarosItemDropRate = 50
EledoradoDevilTantarosExItemDropRate = 20Is 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.
- Joined
- Apr 8, 2008
- Messages
- 2,465
- Reaction score
- 11,169
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.
pdnet
New Member
- Joined
- Oct 17, 2018
- Messages
- 19
- Reaction score
- 7
Thanks for the enlightenment. Will test an updated eventitembags . I agree with /another gap of Webzen/
dedicadobk
Member
- Joined
- Mar 8, 2015
- Messages
- 32
- Reaction score
- 7
- Joined
- Apr 8, 2008
- Messages
- 2,465
- Reaction score
- 11,169
dedicadobk
Member
- Joined
- Mar 8, 2015
- Messages
- 32
- Reaction score
- 7
create a monster at a particular location on the map
Adicionado comando / createmonster <mob> <mapa> <x> <y>
Adicionado comando / createmonster <mob> <mapa> <x> <y>
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
Last edited:
- Joined
- Apr 8, 2008
- Messages
- 2,465
- Reaction score
- 11,169
+ Added /deposit, /withdraw and /zenbank commands
+ Added /spawnmob command
+ Added /credits command
+ Anti afk system will now take into account when players drop/pickup items
+ Added ability to change default stats of newly created characters (level up points, zen, strength, agility, vitality, energy, resets, grand resets, vip status)
+ Added /mail send/read/clear command(s)
Attachments
I think the server is staying pretty. good darkmaster! the only thing that would be serious for me to contemplate would be the support of new maps!
Speedy
Dorin
- Joined
- Mar 12, 2014
- Messages
- 124
- Reaction score
- 44
Similar threads
