Thread: Buff Npc

Hey, this is a very nice script, but i was wondering about something, when i try to execute the INSERT INTO `creature_proto` VALUES ('66698', '70', '70', '35', '10000000', '10000000', '10000000', '1', '1', '1800', '0', '1500', '2500', '1800', '500', '650', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '1', '0', 'MEMO', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0');

it says

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('66698', '70', '70', '35', '10000000', '10000000', '10000000', '1', '1', '1800', '0', '1500', '2500', '1800', '500', '650', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '1', '0', 'MEMO', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully

could someone give me some help?

Originally Posted by Kreegoth

Hey Noob.. I've tried this a few times.. Sorry not your Script but it pertains to a script such as yours so i thought id respond here..

is it possible using LUa to make the NPC do a check for a certain item in persons inventory and remove it upon completing the function.. Ie you need a Runed copper rod to be buffed with Str.. After buffing str it removes 1 runed copper rod from players inventory?.. I know thats a stupid example but its just off the top of my head.. or perhaps maybe even simply gold?....

here is the code

if pMisc:GetItemCount(998000) > 1 then
pUnit:CastSpellOnTarget(33077, player)
pMisc:RemoveItem(998000)
end