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!

Server 4.4 Uniques problem

Newbie Spellweaver
Joined
May 21, 2004
Messages
18
Reaction score
0
they dont drop?

if you are saying they do nothing then you're wrong. They just dont do the same as 3.8 apart from FB.

If it's drops you're missing then you need to edit the procedure ADDSPECIALITEM and tell it to insert values into MiscTime , Attack , Str , Spr , Dex , Pwr in tblspecialitem1 , tblspecialitem1 also need allow nulls on GameID
 
Newbie Spellweaver
Joined
Mar 11, 2004
Messages
13
Reaction score
0
no they drop but dont give stats looks like items in ItemInfo0x.rsi must be fixed in some way cuz if i put fixed ItemInfo0x.rsi from 3.8 most of the items work correct :(
this is my RMS_ADDSPECIALITEM dont see field for stats









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 = 0

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 =1
set @CurrentItemCount = 0
end


if @ItemCountLimit > @CurrentItemCount
begin

insert RedMoon.dbo.tblSpecialItem8 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind) values (@ItemKind, @ItemIndex, @ItemDurability,@Position, @Map, @X, @Y, @TileKind)

end

commit transaction



GO
and i dont have any error logs
 
Last edited:
Newbie Spellweaver
Joined
Mar 11, 2004
Messages
13
Reaction score
0
Ok what i noticed
if i use original \Data\Item\Info\ItemInfo0x.rsi files
for example Jupiter set work correct but Minerva's Tears give not more then 50-100 spirit its funny ...
Erineas shield give funny stats too ...
id i use fixed Item files from 3.8 and put it into 4.4 Minerva Minerva's Tears give normal stats but Jup set dont work at all
:(
 
Newbie Spellweaver
Joined
May 8, 2004
Messages
36
Reaction score
0
If someone got to understood how to edit ItemInfo0x.rsi plz tell :)
 
Back
Top