[SOLVED] ItemGossip and no scriptname in item_template

[DrBronx]

Hello guys.

I just successfully add Item and player Gossip from Rochet2 to my core.

its a WOWSource fork and its 5.x.x core.

there is no problem on adding the codes and compiling the core. the compile was successfully passed and server is running normally.


what happen is when i click on the item which i created nothing happens.

i search all the forums here and there. they all have a field called "scriptname" in item_template to add the script name to it. like the creature_template and creature script.

so i tried to add somethings in spell_script_name with the id of my item. FAIL
then tried to add the spell to spell_script_name and then add the id to spellid_1 field. FAIL again


here is my item

INSERT INTO `worldmop`.`item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `Unk430_1`, `Unk430_2`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_unk1_1`, `stat_unk2_1`, `stat_type2`, `stat_value2`, `stat_unk1_2`, `stat_unk2_2`, `stat_type3`, `stat_value3`, `stat_unk1_3`, `stat_unk2_3`, `stat_type4`, `stat_value4`, `stat_unk1_4`, `stat_unk2_4`, `stat_type5`, `stat_value5`, `stat_unk1_5`, `stat_unk2_5`, `stat_type6`, `stat_value6`, `stat_unk1_6`, `stat_unk2_6`, `stat_type7`, `stat_value7`, `stat_unk1_7`, `stat_unk2_7`, `stat_type8`, `stat_value8`, `stat_unk1_8`, `stat_unk2_8`, `stat_type9`, `stat_value9`, `stat_unk1_9`, `stat_unk2_9`, `stat_type10`, `stat_value10`, `stat_unk1_10`, `stat_unk2_10`, `ScalingStatDistribution`, `DamageType`, `delay`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `StatScalingFactor`, `CurrencySubstitutionId`, `CurrencySubstitutionCount`, `flagsCustom`, `WDBVerified`) VALUES ('900010', '15', '1', '-1', 'Magic Stone', '118958', '6', '268435456', '0', '0.988', '1', '1', '0', '0', '0', '-1', '-1', '90', '90', '0', '0', '0', '0', '0', '0', '0', '1', '1', '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', '0', '0', '0', '0', '9090', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '1', '', '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', '16048');

what am i doing wrong?

also here is the item script : http://pastebin.com/F5RwLasq

 

[blackmetal]

Maybe you forgot to insert script into Table: item_script_names
I was used wowsource before and has no problem with Rochet2 Code( His code alway great )

 

[DrBronx]

Maybe you forgot to insert script into Table: item_script_names
I was used wowsource before and has no problem with Rochet2 Code( His code alway great )

Thank you for your kind reply.
here is my row in item_script_names

INSERT INTO `worldmop`.`item_script_names` (`Id`, `ScriptName`) VALUES ('9090', 'charstone_ItemGossip');

and also

INSERT INTO `worldmop`.`item_script_names` (`Id`, `ScriptName`) VALUES ('900010', 'charstone_ItemGossip');

what do you think. is it ok ?

 

[blackmetal]

Hmm, ID of Item is 900010. And try insert spell 33227 to column spellid of item template. Restart Server and check it again.

 

[DrBronx]

Hmm, ID of Item is 900010. And try insert spell 33227 to column spellid of item template. Restart Server and check it again.

ok. trying now with this

update item_template set spellid_1 = 33227 where entry = 900010;

i will post the update soon.


UPDATE -----------

nothing happen.
i click on the item and nothing will happen.

is the "Flags" and "FlagsExtra" is ok in the item_template ?

 

[blackmetal]

Well. It is hard to explain, but used some modified source will receive some weird thing like that. So try to spend more time. First time i used Rochet2 code in wowsource, it costs about almost a week to make it successful .

 

[Rochet2]

Test the script on hearthstone. Add the script to the item's scriptname and try it ingame.
Hearthstone is an item that should work by default. If it doesnt work then most likely your script is bad or somehow its not in the core.
Also take a close look at the startup errors for the scriptname and item entry of yours.

 

[DrBronx]

Test the script on hearthstone. Add the script to the item's scriptname and try it ingame.
Hearthstone is an item that should work by default. If it doesnt work then most likely your script is bad or somehow its not in the core.
Also take a close look at the startup errors for the scriptname and item entry of yours.

I saw somewhere else that you say that too and because of that first I tried it before.
I added the spellid to the spell_script_names and then add it to the spellid_1 in the hearthstone item_template
but what happened is when i click on hearthstone it cast the teleport spell which is had it before. (i removed my cache and wtf folder and restarted the server)

just for you to know I add all of your codes in the core without any single modification and i have no problem on compiling.

about the error in console I did not see any error in the logs about the script nor the item.

is it possible to send you my core in private to check the script ?( nothing really fancy but i have a lot modifications)?

 

[DrBronx]

**Solved**

with the help of Rochet2 I not know i miss understood the concept of spell_script_names

I should of add the item id to the entry i spell_script_names and not messed up with the spellid_1.