[SOLVED] [H] Use an item to complete a quest objective SQL

[Syphex]

Basically what im trying to do is that You have a Item (companion), And to complete a quest you have to add this creature/Companion to your collection and the quest objective will get completed.
So simply the quest gets completed on using the item.

Been on this for a while(1-2 hours), have not found it yet, and i have not find any results on any search engine, There may be others with the same problem, but i do not know what else i should type to find it.

I want to have this done in SQL as i'm not anywhere good at C++ or LUA.


Thanks in advance.

 

[blackmetal]

Here is a list of quest type

    QUEST_OBJECTIVE_TYPE_NPC              = 0,
    QUEST_OBJECTIVE_TYPE_ITEM             = 1,
    QUEST_OBJECTIVE_TYPE_GO               = 2,
    QUEST_OBJECTIVE_TYPE_NPC_INTERACT     = 3,
    QUEST_OBJECTIVE_TYPE_CURRENCY         = 4,
    QUEST_OBJECTIVE_TYPE_SPELL            = 5,
    QUEST_OBJECTIVE_TYPE_FACTION_REP      = 6,
    QUEST_OBJECTIVE_TYPE_FACTION_REP2     = 7,
    QUEST_OBJECTIVE_TYPE_MONEY            = 8,
    QUEST_OBJECTIVE_TYPE_PLAYER           = 9,
    QUEST_OBJECTIVE_TYPE_DUMMY            = 10,
    QUEST_OBJECTIVE_TYPE_PET_BATTLE_TAMER = 11,
    QUEST_OBJECTIVE_TYPE_PET_BATTLE_ELITE = 12,
    QUEST_OBJECTIVE_TYPE_PET_BATTLE_PVP   = 13,

I'm using Trinity 5.4.x so it has a table called "quest_objective". Never try do it before but i think you can try quest type = 5 (QUEST_OBJECTIVE_TYPE_SPELL) to check if player has that spell ( in your case is pet spell ) then complete quest. This is just what i'm thinking and it can be done with SQL Scripts. :determination:

 

[Syphex]

It'a alot different 3.3.5 and 5.4.x.

What that would do is cast a spell on the player when he completes the quest.

 

[FoxGaming]

It'a alot different 3.3.5 and 5.4.x.

What that would do is cast a spell on the player when he completes the quest.

You're thinking of reward type, that portion he linked would require a player to cast X spell Y number of times. You just need the equivalent in 3.3.5. Not that I remember everything but I do not remember a Cast Mechanic in quests in Wotlk.

 

[Syphex]

I was tierd when at that time, what i was thinking of would be SourceSpellID, Where the creature casts a spell on the player whenever he takes the quest.