[Question] Plus notice only shows Weapons ?

04/10/2018 14:44 multiuses#1

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

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

[Only registered and activated users can see links. Click Here To Register...]

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 :confused:
if someone could help me i will really appreciate your help :handsdown:

thanks.

04/11/2018 04:24 Isoline*#2

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

04/11/2018 13:32 multiuses#3

Quote:

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 ?

04/11/2018 15:34 Isoline*#4

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

04/11/2018 17:17 #HB#5

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:

Code:

strDesc=(1 [dec-dura 49%)

and that's a weapon:

Code:

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.

Quote:

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"

04/11/2018 17:33 Isoline*#6

Quote:
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:
Code:
strDesc=(1 [dec-dura 49%)
and that's a weapon:
Code:
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

04/11/2018 18:14 #HB#7

lol, and who said that you forced him

04/11/2018 22:07 multiuses#8

Quote:
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:
Code:
strDesc=(1 [dec-dura 49%)
and that's a weapon:
Code:
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 :handsdown:

04/11/2018 23:12 #HB#9

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 fucking optlevel and item ID!

Copypaste? Here you are: [Only registered and activated users can see links. Click Here To Register...]

04/12/2018 02:58 multiuses#10

Quote:

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 @[Only registered and activated users can see links. Click Here To Register...]From declaration and @[Only registered and activated users can see links. Click Here To Register...]D, so you got the ID64 now! so what are you waiting for, get the fucking optlevel and item ID!

Copypaste? Here you are: [Only registered and activated users can see links. Click Here To Register...]

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