Home

eaiLilly

You like eventAI, but you hate writing cryptic SQL statements?

You prefer:

myConditions = new conditions()
myConditions.ScriptComment = "Item \"The Greatmother's Soulcatcher\" (35401) can only be used on the corpses of \"Fizzcrank Mechagnome\" (25814)"
myConditions.SourceTypeOrReferenceId = conditions.CONDITION_SOURCE_TYPE_ITEM_REQUIRED_TARGET // 18
myConditions.SourceGroup = 0
myConditions.SourceEntry = 35401 // Item ID
myConditions.ConditionTypeOrReference = conditions.CONDITION_ITEM_TARGET // 24
myConditions.ElseGroup = 0 
myConditions.ConditionValue1 = 2 // ConditionValue1: ItemRequiredTargetType (CREATURE[1], DEAD[2])  
myConditions.ConditionValue2 = 25814 // ConditionValue2: creature entry
myConditions.ConditionValue3 = 0
myConditions.ErrorTextId = 0
myConditions.Comment = 'Quest: Souls of the Decursed -- The Greatmother s Soulcatcher'
myConditions.toSQLExtend()

over

-- Item "The Greatmother's Soulcatcher" (35401) can only be used on the corpses of "Fizzcrank Mechagnome" (25814)
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceEntry`=35401;
INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ElseGroup`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`Comment`)
VALUES 
(18,0,35401,24,0,2,25814,0,0, 'Quest: Souls of the Decursed -- The Greatmother s Soulcatcher');

Then this is your place.

Get eclipse and the groovy plugin and read the WIKI.

kizura