Developer items missing

These were in MaNGOS years back, along with Peep the phoenix and others. No clue why we don't have them now. In Zero, and One I believe, the items were tied to the area death spell and killed everything in a 30 yard radius. Somehow these items made it onto a live server so they changed it to kill the caster. In Zero it should kill everything in a 30 yard radius around the caster In Lich King it should be suicide. Not sure about BC, but I know at one point in BC it was the same as in vanilla, though they may have been changed prior to the final version of BC.

*EDIT*

Alex's Ring of Audacity and Alex's Text Beatdown Staff are in-game, along with the Ring of Critical Testing 2.

Thanks, Xenithar :D

I'll implement them based on that info :D unless someone else does it :)

These are in our DBC files, so why can't we just pull the info from there?

Okay, will look into that. I don't really know much about the dbc files, so a good time to learn something :)

Well it works like this. You can't create an item server-side which is not in the client. If the server says item 7000 is on a corpse and your DBC files do not have an entry for item 7000, it will either show up as a red question mark on a black background and be useless, or it won't show up at all. Antz or Reaper could probably explain this better than I can, but it boils down to things matching up on the client and server.

That should only be happening on client versions > 2.4.3, that's why a lot of custom servers run on older client versions, no need for custom client side patches.

Wait, you're saying in vanilla I can create my own custom weapons? How would that work? Assume I took a Thunderfury, cloned it, gave it id 9000, made it have 500dps or something crazy. How would the client react if I added it to my inventory? I was under the impression that we were only passing ID numbers back and forth.

Easiest way to explain it... It would just... Work :) The item information is sent from the server and cached client side, no DBC or custom patch is required at all to use the item. Only from WoTLK and forward you're required to have a custom patch.

I see that. I tried it and 8250dps daggers are, shall we say, OP? I must have been remembering information pertaining to LK. Still, if those items existed in vanilla, they SHOULD be in our DBC files. Peep was added in BC. Flying phoenix mount given to some kid dying of cancer. The Blizzard team had him out to their place and played with him all day. Gave him Peep and also some rad gear. Made me all blurry-eyed when I first read about it.

[quote=Xenithar]I see that. I tried it and 8250dps daggers are, shall we say, OP? I must have been remembering information pertaining to LK. Still, if those items existed in vanilla, they SHOULD be in our DBC files. Peep was added in BC. Flying phoenix mount given to some kid dying of cancer. The Blizzard team had him out to their place and played with him all day. Gave him Peep and also some rad gear. Made me all blurry-eyed when I first read about it.[/quote]

Love it! I'm with you there. Is that the one who had a quest made for him in the Tauren area. You have to find food for his dog ?

Not sure, I just remember them giving him Peep, epic gear, and then the entire staff joined him for a day of raiding and fun. This was during BC, prior to LK coming out. I hope the kid is still around.

Looking like these will have to be created from scratch. I'll have to locate the appropriate image for each. The display ID for the shirt/chest is not showing as that pictured on wowhead: 5661
-- Hmm, it looks like the image is not updating on my machine; no matter what I enter as the DisplayId, it shows the same image. Reboot time!!!

[url]http://www.wowhead.com/item=17&xml[/url]
------------------------------------------------------------------------------------------------------------------------

*************** [B][COLOR="#008000"]SQL Script[/COLOR][/B] ***************

[B][SIZE=3][COLOR="#800080"]VANILLA (includes sprinkles)[/COLOR][/SIZE][/B]

- [B][SIZE=3]Martin Fury (pre patch 3.2.0) [/SIZE][/B]
- [url]http://www.wowwiki.com/Martin_Fury[/url]
[IMG]http://o.aolcdn.com/hss/storage/midas/11f34b2c49492d94903e7fd90da55071/200053540/fury+stats.PNG[/IMG]

[COLOR="#0000FF"]DELETE FROM item_template WHERE entry = 17;
INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, block, itemset, MaxDurability, area, Map, BagFamily, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration, ExtraFlags) VALUES (17, 4, 4, 'Martin Fury', 27348, 5, 64, 1, 7, 7, 4, -1, -1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 34, 4, 34, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 265, 0, 100, 0, 5000, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 100, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);[/COLOR]


- [B][SIZE=3]Martin Thunder[/SIZE][/B]
- [url]http://www.wowwiki.com/Martin_Thunder[/url]
[IMG]http://i1.2pcdn.com/node14/image/article/201407/11/20140711042126a0du1yumnmxyi43w.jpg[/IMG]

[COLOR="#0000FF"]DELETE FROM item_template WHERE entry = 192;
INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, block, itemset, MaxDurability, area, Map, BagFamily, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration, ExtraFlags) VALUES (192, 2, 14, 'Martin Thunder', 5279, 5, 64, 1, 9999999, 210533, 21, -1, -1, 75, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 37, 0, 5, 10, 2, 6, 60, 4, 0, 0, 0, 0, 0, 0, 100, 0, 110, 100, 100, 100, 0, 0, 0, 0, 265, 0, 100, 0, 5000, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 100, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);[/COLOR]


[B][SIZE=3][COLOR="#800080"]WOTLK[/COLOR][/SIZE][/B]

Need to locate the suicide spell

[B][SIZE=3]Martin Fury[/SIZE][/B]

[url]http://www.wowhead.com/item=17/martin-fury[/url]

[COLOR="#0000FF"]DELETE FROM item_template WHERE entry = 17;
INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, block, itemset, MaxDurability, area, Map, BagFamily, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration, ExtraFlags) VALUES (17, 4, 4, 'Martin Fury', 27348, 5, 64, 1, 7, 7, 4, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 34, 4, 34, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 100, 0, 5000, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 100, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);[/COLOR]

[B][SIZE=3]Martin's Broken Staff[/SIZE][/B]

[url]http://www.wowhead.com/item=192/martins-broken-staff[/url]

[IMG]http://i1.2pcdn.com/node14/image/article/201407/11/20140711042200a0du1yv70v3h11ra.jpg[/IMG]

[COLOR="#0000FF"]DELETE FROM item_template WHERE entry = 192;
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration, ExtraFlags) VALUES (192, 2, 14, -1, 'Martin\s Broken Staff', 5279, 0, 64, 1, 9999999, 21053, 21, -1, -1, 75, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 110, 100, 100, 100, 0, 0, 0, 0, 7, 0, 100, 0, 5000, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '', 0, 0, 0, 0, 0, 0);[/COLOR]

*************** [B][COLOR="#008000"]ScriptDev Script[/COLOR][/B] ***************

Yah, pItemUse(): now for some fun ;-)


[B]scripts/world/item_scripts.cpp[/B]

[PHP]

bool ItemUse_item_martin_fury(Player* pPlayer, GameObject* pGo)
{
// KILL EVERYTHING!!!

return true;
}

void AddSC_item_scripts()
{
Script* pNewScript;

pNewScript = new Script;
pNewScript->Name = "item_martin_fury";
pNewScript->pItemUse = &ItemUse_item_martin_fury;
pNewScript->RegisterSelf();
}
[/PHP]

[B][SIZE=3][COLOR="#B22222"]THIS WAS NOT REQUIRED[/COLOR][/SIZE][/B]

When adding an item you need to exit your client and delete your WDB folder. Also, reboot the server. There is no way to reload the item table right now.

Thanks, Xenithar. That was REALLY peeing me off, to put it mildly :D

I have been told this before - damn memory!

I start WoW with a batch file. Below is what I have in it, from memory.
[code]
@ECHO OFF
DEL WDB\*.* /Y
WOW.EXE
[/code]
It clears the cache and then starts WoW. Useful because I do so many rebuilds and DB changes.

Ah, very useful! Thanks, Xenithar :D

Yey, I have found the spell to kill all up to 30 yards (265) :)

[IMG]http://s1.postimg.org/fl8s4pz8v/Martin_Fury_Wo_W.jpg[/IMG]

Now to finish that and Martin Thunder

---------------------------------------------------------------------------

[IMG]http://s7.postimg.org/phxfd0mm3/Martin_Thunder_Wo_W.jpg[/IMG]

Just need to figure out how to set the DPS and speed! And how does it get that yellow text for the title (see original image) ?

Martin Thunder had speed that wasn't 0 if I recall correctly. I also don't remember that text. I'll try to find some old screenshots. Also, I am loading my new server, so hopefully I will be up soon.

Here you go. This shows them. They SHOULD be in the DBC. They have item numbers from the player DBC files.

[url=http://www.wowwiki.com/Martin_Thunder]Martin Thunder[/url]
[url=http://www.wowwiki.com/Martin_Fury]Martin Fury[/url]

Funny story:
[url]http://wow.joystiq.com/2009/04/29/player-receives-developer-item-in-the-mail-one-shots-ulduar/[/url]

:D Ignore the text, that's just me being silly. It won't be in the committed version :D

I cannot figure out how to set the Speed and DPS. Tried a number of things, but no joy :-(

Also, there seems to be an issue with the stat bonuses (mana, strength, etc). It's resulting in being displayed many times in the details of the item in the game client. As a result, it's not allowing anything else to show, such as the Armor, Resistance, Durabilty, Use, etc.

I am/was looking at the core code related to adding items (as a starting point), but my copy of VS is playing up. Gonna switch to the Linux machine and cmake.

-----------------------------------------------------------------------

Ah ha, they are artifacts - yellow colouring, nice one, Xenithar - re the links :)
hmm, that does not appear to exist in Vanilla, or any yellow colouring. I'll leave it as is, for now.

Very odd, if you start the list of stats for the item with 0 (mana) it totally fracks it up. I started the list with 4 (strength) and that worked fine, but of course the stat order will be wrong (re original image).

It looks like, at some point, the decision of the number of stats was based on the contents of a field: StatsCount, but this was removed. Whatever it is doing now to decide on what stats are there, is now being borked by stat_type1 equaling zero.

Will continue with this tomorrow... chill time, me thinks :D

---------------------------------------------------------------------------------

Note to self, this thread is related: [url]https://www.getmangos.eu/developer-area-private-no-public-access-/10250-enums-matching-stats.html[/url]

ItemProtoTypes.h, Player.cpp

DPS is cake. 1000 is 1sec, 500 is 0.5sec, 1500 is 1.5sec. I forget the column, but the DPS is in milliseconds.

*EDIT*

Also, if something is displayed many times (normally this would be mana), you have an invalid stat type in one of the ten stat type fields. The stats are NOT sequential. Hang on and I will list the stats for you.

*UPDATE*

Here's the list of base stats.

[list]
[*]Mana = 0
[*]Health = 1
[*]Agility = 3
[*]Strength = 4
[*]Intellect = 5
[*]Spirit = 6
[*]Stamina = 7
[/list]

ALso, there is MUCH more help in src/game/ItemPrototype.h for things including enchantments and triggers.

[quote=Xenithar]DPS is cake. 1000 is 1sec, 500 is 0.5sec, 1500 is 1.5sec. I forget the column, but the DPS is in milliseconds.

*EDIT*

Also, if something is displayed many times (normally this would be mana), you have an invalid stat type in one of the ten stat type fields. The stats are NOT sequential. Hang on and I will list the stats for you.

*UPDATE*

Here's the list of base stats.

[list]
[*]Mana = 0
[*]Health = 1
[*]Agility = 3
[*]Strength = 4
[*]Intellect = 5
[*]Spirit = 6
[*]Stamina = 7
[/list]

ALso, there is MUCH more help in src/game/ItemPrototype.h for things including enchantments and triggers.[/quote]

Thanks for the info :)

After testing, I believe the fault to be with the client, as I monitored the server as it passed the stat data to the client. Whenever a batch of stats was passed that included Mana (0), that cocked up the item's tooltip display. All other stats worked fine.

data passed to the client via:
ItemHandler.cpp
function WorldSession::HandleItemQuerySingleOpcode(WorldPacket& recv_data)
line 420
SendPacket(&data);
The values in the [B]item_template[/B] table are all correct. Nothing amiss.

Gonna try patching up the client. Right now I've got the first of the classic version supported by MaNGOS Zero.

Martin Fury item working at it should (incl. correct image), MaNGOS One (TBC)

[IMG]http://s8.postimg.org/48x2plt85/Martin_Fury_Item_BC.jpg[/IMG]

And my toon showing what he thinks of the whole thing ;)

That's using the same data as I used for Zero (SQL script posted in this thread).

Gonna just check one more thing.

Oh, and I upgraded to 1.12.2, but still had the issue, so it looks like we'll have to suffer it.

Probably best not to include Mana on Zero ??????

--------------------------------------------------------------------

Final check: I compared the code between Zero and One, and they are the same, therefore it has to be the client that is bugged.

Unless there is another official patch that fixes the spamming, the only other thing we could do is to hack it, but that would lead to legal issues, so nuts to that.