[Item] Range not working on a few?

[trygon11]

Ok so every weapon in my DB works as intended except the Wrathful Bows/guns
they for some reason have no range?
u cant fire your gun/bow unless your within melee range and i cant figure out why
ive tried altering them to the exact stats of a working bow/gun and still nothing
(all the stats that made any sence to me)

Any help is really appreciated this honestly doesnt make any sense to me.

[Kiev]

If you are using ArcEmu, go into the database and find the item, scroll across till you find "ranged_range" or something..., it will contain range, and change that to the number of another bow.

[trygon11]

ya ive down that, like.. honestly i cant figure it out im not really new to all the database editting i even copyed another item out of the DB that worked and changed the appropriate damage stats to the ones of the wrathful guns/bows and still the range is 5-6 yrds and it shud be 5-35

[Aellya]

As the range checks are handled client side (aditional checks on the server to prevent cheating) you'll need to clear your cache after changing an item but the 'range' column in the sql handles your maximum distance.

Try just clonging a gun or bow and giving it a new id like 100000, reload your tables (or restart the emu) and try the new item. It should be identical to the original, if it works you can start altering the model, damage, stats, etc...

[Kiev]

But if you are using patch 3.3 or higher, then do not make it a custom id as stated, or it will not work properly.

[trygon11]

Is that only with items kiev? because ive made tons of custom id vendors that all work
My only issue is ya my custom items and items only are not working right.

[Kiev]

Its only Custom Items that have the issue, this is because blizzard implemented a test to see if the item is in the game .dbc, if not, it wont function.

[Algorithm]

custom items work, however you wont be able to enchant them with any scroll, enchant, e.t.c. unless you replace your custom item ids with already existent ids in database.

As far as range goes, you need to put range value in -range- or -ranged- in your items table. restart server, delete cache folder.

[trygon11]

Alright well ive tested out quite abit and ive noticed without it being an actual entry id it just turns into a stat stick even when i copy and paste the SQL of a real item change the entry ID to something not in the database the item doesn't function, the game says its not an item at all, like if you make a dagger on a rogue with a custom ID it will tell you its not even a weapon. same with if you make a custom bow, its not a bow so it has no range, so i had to remake the wrathful gun/bow/crossbow and use already ingame IDs of level 30ish weps and delete those from the DB.

So basicly i got it working thanks Keiv +Rep and those are my findings for anyone who may have the same issue

[Kiev]

Your welcome.

If you need help again PM me.

[Aellya]

I knew you needed to edit eh Item.dbc file to make the client display the correct icon but i didn't know that they had increased the requirement in 3.3, usually it just displayed the wrong icon (red question mark) if the item entry wasn't in Item.dbc.

[Kiev]

They did this i guess to crack down on WoW Emu slowly, and this is there step, next it might be the same for NPCs etc.