Search the Community

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. 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. Anyone know how to solve the problem? thank in advance best regards Neo2k

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.