Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Version 4.4 unique drop fix

Newbie Spellweaver
Joined
May 21, 2004
Messages
18
Reaction score
0
Seems some line in drop item is missing some text. Edit your Specialitem1 table and allow nulls on ONLY GameID. All others MUST be no allow nulls.

Then find RMS_ADDSPECIALITEM and replace the code with :

CREATE PROCEDURE RMS_ADDSPECIALITEM
@ItemKind int,
@ItemIndex int,
@ItemDurability int,
@Position int,
@Map int,
@X int,
@Y int,
@TileKind int,
@bNeedCheckLimit int

AS

set nocount on

declare @ItemCountLimit int, @CurrentItemCount int

select @ItemCountLimit = 1000

begin transaction

if @bNeedCheckLimit=1
begin
select @ItemCountLimit = ItemCountLimit from RedMoon.dbo.tblSpecialItemLimit1 where ItemKind = @ItemKind and ItemIndex = @ItemIndex
select @CurrentItemCount = @ItemCountLimit
if @ItemIndex>=100 and @ItemIndex<=114 -- Total count of growth special item includes rating, generaion, speciality, perfect item.
begin
select @CurrentItemCount =count(*) from RedMoon.dbo.tblSpecialItem8 where ItemKind = @ItemKind and (ItemIndex = @ItemIndex or ItemIndex = @ItemIndex+20 or ItemIndex = @ItemIndex+40 or ItemIndex = @ItemIndex+60 or ItemIndex = @ItemIndex+80)
end
else
begin
select @CurrentItemCount = count(*) from RedMoon.dbo.tblSpecialItem8 where ItemKind = @ItemKind and ItemIndex = @ItemIndex
end
end
else
begin
set @ItemCountLimit =1000
set @CurrentItemCount = 0
end


if @ItemCountLimit > @CurrentItemCount
begin

insert RedMoon.dbo.tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (@ItemKind, @ItemIndex, @ItemDurability,@Position, @Map, @X, @Y, @TileKind, 1, 0, 1200, 0, 0, 0, 0, 0)

end

commit transaction
GO
 
Newbie Spellweaver
Joined
May 11, 2004
Messages
38
Reaction score
0
Bump, I have a couple of question.

1. How do I make GameID null?

2. Where is RMS_ADDSPECIALITEM? Is that a table found in Enterprise Manager, a query or just a data file?

Please help out, thanks.
 
Newbie Spellweaver
Joined
Jan 15, 2004
Messages
17
Reaction score
0
1. Right click the Specialitem1 table, and press design table. Then find the GameID field, and set it as allow null.

2. RMS_ADDSPECIALITEM is under stored procedures.
 
Back
Top