help plz RM 4.4 Uniques, Ppills etc Don't Work

[DiLanK]

I successfully set up the redmoon 4.4 server and got mostly everythign workign, maps, logins, lvlin and so on. THe only problem I encountered was with Uniques and Ppills and any special items. I tried a lot of things and i have searched through this forum many times. :ranting2:

I tried sending a ppill or a blue uni in the mail but it won't come out of the mail.
I then tried putting the item directly into inventory and then when I double clicked the item nothing would happen.

I sent items using both GM tools and SQL queries but both yielded the same results.
I checked through the tables and the items were appearing but they would not work.
I have made tables corresponding to year and month for all the ones that required it and my daylight savings time is disabled.

I am stumped and have no idea how to fix this, I would really like to get 4.4 working, the server is just for friends and family.

Please any help would be appreciated,
Thank you for your time,
Dilan

also does any1 have the item list for the 4.4 specific items liek fireworks and masks to name a few.

[MentaL]

[Nickyy]

Unique item problem sounds like you didnt set the SpecialItemLimit maybe. Ppill procedure is just plain wrong though it has to be re-written in most versions of the 4.4 db Ive seen.

[DiLanK]

I've set all the limits, but it still won't work can any1 advise me on how to fix this issue?
When I look in the database or in GM tools the limits are set and it even shows the number of the items in game.

I would really appreciate it.

[MG1978]

4.4 fixes read below I dont remeber who posted it originaly but I saved this info in a text file worked for me should work for you.



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

[Jackel66]

tblSpecialItem8 << thats one problem it should be tblSpecialItem1 not 8 unless you have specified this on your .ini files. i would check the specialitemlimt tbl see if its correct

[MG1978]

What ever you have specified in your ini is what you should edit.....