Jump to content
TrinityCore

Weapon is not visible (Only when holding it in hand)


NeoTwoK
 Share

Recommended Posts

Hello everyone,

I have a problem with custom weapons.

I created the weapons in the DB. (Here the SQL query)

INSERT INTO `wow_335_dev_world`.`item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`) VALUES (70000, 2, 7, -1, 'Chronos GM Schwert', 45776, 5, 0, 0, 1, 0, 0, 13, -1, -1, 50, 70, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 5, 4, 9999, 3, 9999, 7, 9999, 5, 9999, 6, 9999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 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, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 2, 3, 4, 3, 3303, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);


And I also entered my custom weapon ID properly in the Items.dbc.

grafik.png.dfd86d0616072960b1beb2ee4707a525.png

 

The weapons work too.

I also get an icon displayed and the weapon looks like it should. But if I equip the weapon now, it disappears. Only when I hold the weapons in my hand are they visible.

Here some pictures of it. The first shows the weapons when I carry them on my back, the second picture as they are visible in my hand.

wow1.jpg.9ce58cd0656b6cd058274c876370ea88.jpg

wow2.jpg.1a5eeb29a67934757faa13fa5c1ee962.jpg

 

Anyone know how to solve the problem?

 

thank in advance

 

best regards

Neo2k

Edited by NeoTwoK
Link to comment
Share on other sites

Hello again,

 

i have changed some data in the item_teamplate SQL Data and now it worked.. I dont know why, but now i can see my weapons on my back.

 

This is the INSERT Query of my working Weapon, for everyone who has the same problems like me:

INSERT INTO `wow_335_dev_world`.`item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`) VALUES (70000, 2, 7, -1, 'Chronos GM Schwert', 45776, 5, 8, 0, 1, 0, 0, 13, -1, -1, 277, 80, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 5, 4, 9999, 3, 9999, 7, 9999, 5, 9999, 6, 9999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 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, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 2, 3, 4, 3, 3303, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340);

 

wow3.jpg.9e996894efe8168a0f85ef47b3aefb4e.jpg

 

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By asura227
      Hi Everyone! I'm trying to install the master branch. When running 'worldserver' for the first time, i get this:
      Using configuration file /home/trinity/server/etc/worldserver.conf.
      Using SSL version: OpenSSL 1.1.1c  28 May 2019 (library: OpenSSL 1.1.1c  28 May 2019)
      Using Boost version: 1.67.0
      Database Auth is empty, auto populating it...
      >> Applying '/home/trinity/TrinityCore/sql/base/auth_database.sql'...
      >> Done!
      Database Character is empty, auto populating it...
      >> Applying '/home/trinity/TrinityCore/sql/base/characters_database.sql'...
      >> Done!
      Database World is empty, auto populating it...
      >> Applying 'TDB_full_world_820.19071_2019_07_15.sql'...
      >> Done!
      Database Hotfixes is empty, auto populating it...
      >> Applying 'TDB_full_hotfixes_820.19071_2019_07_15.sql'...
      >> Done!
      Updating Auth database...
      >> Auth database is up-to-date! Containing 33 new and 115 archived updates.
      Updating Character database...
      >> Reapplying update "2020_02_17_00_characters.sql" 'E1519A8' -> '5FB4640' (it changed)...
      ERROR 1060 (42S21) at line 3: Duplicate column name 'selectedAzeriteEssences1azeriteEssenceId4'

      Applying of file '/home/trinity/TrinityCore/sql/updates/characters/master/2020_02_17_00_characters.sql' to database 'characters' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
      Could not update the Character database, see log for details.
      The content of '/home/trinity/TrinityCore/sql/updates/characters/master/2020_02_17_00_characters.sql' is as follows:
      UPDATE `character_inventory` SET `slot`=`slot`+4 WHERE `slot`>=47 AND `bag`=0;
      ALTER TABLE `item_instance_azerite`
        ADD `selectedAzeriteEssences1azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences1azeriteEssenceId3`,
        ADD `selectedAzeriteEssences2azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences2azeriteEssenceId3`,
        ADD `selectedAzeriteEssences3azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences3azeriteEssenceId3`,
        ADD `selectedAzeriteEssences4azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences4azeriteEssenceId3`;

      I'm using Ubuntu 19.10 in an LXC container on an Ubuntu 18.04 host,  mariadb 10.3, database 8.2.5/32978 from the releases page, as this was the file that worldserver requested. I did take a look through the FAQs related to the database. Any help you can offer would be greatly appreciated.
×
×
  • Create New...