[Question] Plus notice only shows Weapons ?

[multiuses]

hi there
i dunno whats happening but it works fine with any weapon/shield/accessories
but not working with armors (light-armor-clothes)
i think the problem is the item gender


my code is :

 Spoiler

begin
declare @ varchar(129)
declare @iid int
declare @me varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @erial
set @ = (select Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 = (select NameStrID128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid))
select @me = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @D
begin
insert into lol.dbo._Notice (Sent, Message,added) values (0 @me + ' has increased ( ' + @ + ' ) to ( Plus ' + CAST(@strDesc_separado AS NVARCHAR) + ' ) ( With Adv. ' + @value + ' )',GETDATE())
end
else
insert into lol.dbo._Notice (Sent, Message,added) values (0 @me + ' has increased ( ' + @ + ' ) to ( Plus ' + CAST(@strDesc_separado AS NVARCHAR) + ' ) ( No Adv. )',GETDATE())

and it shows [Null] message in Notice Tab.:



P.S : i checked well the _itemname Tab.
i added the full item names

i dunno how to get rid of this issue

i dunno whats wrong
if someone could help me i will really appreciate your help

thanks.

[Isoline*]

you do realize that this is nothing to go on ,right?

[multiuses]

Originally Posted by eitai123

you do realize that this is nothing to go on ,right?

you mean that this is a useless method and ill wont find a fix , right ?

[Isoline*]

execute it manually given an "armor set" type of parameters it has to be a sql issue while your inserting to the table, also you should not allow nulls on these columns, since you always gonna expect a result set.

or you can simple use my filter and discard all of that, simply use the autonotice feature

[#HB]

First of all, doing it in a filter is much better than SQL

Second, the problem is nearly in that 'strDesc' because it sometimes returns the plus value and sometimes it contains a string/varchar like:

That's an armor one:

strDesc=(1 [dec-dura 49%)

and that's a weapon:

strDesc=(1)

so the problem is basically at that 'strDesc'

What to do: I prefer declaring the item plus and item ID using Slot_From column, it will cause no problems if you want to use SQL at that point.

Originally Posted by eitai123

execute it manually given an "armor set" type of parameters it has to be a sql issue while your inserting to the table, also you should not allow nulls on these columns, since you always gonna expect a result set.

or you can simple use my filter and discard all of that, simply use the autonotice feature

Also, you shouldn't tell people to use your own filter to solve a problem there's a lot of filters just tell 'em to use a filter, that's called "exploitation"

[Isoline*]

Originally Posted by #HB

First of all, doing it in a filter is much better than SQL

Second, the problem is nearly in that 'strDesc' because it sometimes returns the plus value and sometimes it contains a string/varchar like:

That's an armor one:

strDesc=(1 [dec-dura 49%)

and that's a weapon:

strDesc=(1)

so the problem is basically at that 'strDesc'

What to do: I prefer declaring the item plus and item ID using Slot_From column, it will cause no problems if you want to use SQL at that point.



Also, you shouldn't tell people to use your own filter to solve a problem there's a lot of filters just tell 'em to use a filter, that's called "exploitation"

it was merely a suggestion to solve an issue with a much simpler solution, i didnt force him to do anything lol

[#HB]

lol, and who said that you forced him

[multiuses]

Originally Posted by #HB

First of all, doing it in a filter is much better than SQL

Second, the problem is nearly in that 'strDesc' because it sometimes returns the plus value and sometimes it contains a string/varchar like:

That's an armor one:

strDesc=(1 [dec-dura 49%)

and that's a weapon:

strDesc=(1)

so the problem is basically at that 'strDesc'

What to do: I prefer declaring the item plus and item ID using Slot_From column, it will cause no problems if you want to use SQL at that point.



Also, you shouldn't tell people to use your own filter to solve a problem there's a lot of filters just tell 'em to use a filter, that's called "exploitation"

man i tried and without any success
can u share with me the correct script
i will really appreciate your help

[#HB]

I don't want to share write a code for you and you just copypaste it.. but I guess will do it only one time..

All you have to do is to declare the ID64 of _Items table using _Invetory table and '@'Slot_From declaration and '@'CharID, so you got the ID64 now! so what are you waiting for, get the ******* optlevel and item ID!

Copypaste? Here you are:

[multiuses]

Originally Posted by #HB

I don't want to share write a code for you and you just copypaste it.. but I guess will do it only one time..

All you have to do is to declare the ID64 of _Items table using _Invetory table and @From declaration and @D, so you got the ID64 now! so what are you waiting for, get the ******* optlevel and item ID!

Copypaste? Here you are:

Man u saved my day
I really appreciate ur help
I was expecting that no one will help
u r the best and i really thank you