Hi all, i’m new here and i’m also quite noob with Trinity.
I’ve searched on forums but didn’t find anything i understand 
I want to create a ITEM, JUNK as a category wich teleport players on exact coordinates. I know how to create item i know how to obtain coordinates but i’m not able to make it work.
I know there is a table for spell_targetposition and i’ve created the entry with coordinates there but i need help for the rest
Thanks so much for any help!!
Supplying the queries that you made will get you a lot further in getting help.
More than likely you didn’t put the proper spell ID in the spell_target_position table, or you picked a spell that doesn’t have target dest DB…
– Brian
Hi Brian, first of all thanks for replying!
The item i’ve created is not clickable and show a question mark when in inventory, i suppose because i must use a item which is on the client and unused like these:
I’ve created a item with this:
INSERT INTO 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
(20737, 0, 8, -1, ‘Ridgepoint Teleport Stone’, 49274, 3, 0, 0, 1, 9003, 1903, 0, -1, -1, 20, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 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, 100001, 0, 999, 0, 0, 1141, 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, 3, ‘Made in Dalaran’, 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, 0, 0, ‘internalitemhanler’, 0, 0, 0, 0, 0, 0);
Spell_id1 is 100001, if i remember correctly i’ve duplicated a teleport spell. Maybe i’ve duplicated a wrong one.
Spell_dbc
Id Dispel Mechanic Attributes AttributesEx AttributesEx2 AttributesEx3 AttributesEx4 AttributesEx5 AttributesEx6 AttributesEx7 Stances StancesNot Targets CastingTimeIndex AuraInterruptFlags ProcFlags ProcChance ProcCharges MaxLevel BaseLevel SpellLevel DurationIndex RangeIndex StackAmount EquippedItemClass EquippedItemSubClassMask EquippedItemInventoryTypeMask Effect1 Effect2 Effect3 EffectDieSides1 EffectDieSides2 EffectDieSides3 EffectRealPointsPerLevel1 EffectRealPointsPerLevel2 EffectRealPointsPerLevel3 EffectBasePoints1 EffectBasePoints2 EffectBasePoints3 EffectMechanic1 EffectMechanic2 EffectMechanic3 EffectImplicitTargetA1 EffectImplicitTargetA2 EffectImplicitTargetA3 EffectImplicitTargetB1 EffectImplicitTargetB2 EffectImplicitTargetB3 EffectRadiusIndex1 EffectRadiusIndex2 EffectRadiusIndex3 EffectApplyAuraName1 EffectApplyAuraName2 EffectApplyAuraName3 EffectAmplitude1 EffectAmplitude2 EffectAmplitude3 EffectMultipleValue1 EffectMultipleValue2 EffectMultipleValue3 EffectItemType1 EffectItemType2 EffectItemType3 EffectMiscValue1 EffectMiscValue2 EffectMiscValue3 EffectMiscValueB1 EffectMiscValueB2 EffectMiscValueB3 EffectTriggerSpell1 EffectTriggerSpell2 EffectTriggerSpell3 EffectSpellClassMaskA1 EffectSpellClassMaskA2 EffectSpellClassMaskA3 EffectSpellClassMaskB1 EffectSpellClassMaskB2 EffectSpellClassMaskB3 EffectSpellClassMaskC1 EffectSpellClassMaskC2 EffectSpellClassMaskC3 MaxTargetLevel SpellFamilyName SpellFamilyFlags1 SpellFamilyFlags2 SpellFamilyFlags3 MaxAffectedTargets DmgClass PreventionType DmgMultiplier1 DmgMultiplier2 DmgMultiplier3 AreaGroupId SchoolMask Comment100001 0 0 536871296 268435456 0 0 0 0 0 0 0 0 0 1 0 0 101 0 0 0 0 0 1 0 -1 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 72 0 0 9 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 1 1 1 0 1 Teleport
spell_target_position
id effIndex target_map target_position_x target_position_y target_position_z target_orientation VerifiedBuild
100001 0 0 -9767.18 -1385.41 62.7928 1.08491 0
Any idea?
What is the ID of the spell that you copied?
Ugh… i don’t remmeber. I followed a guide. Do you know a spell ID which should work?