Help With getting xp from a Quest.

[ghostrevan]

hi, Im using WoW Vendetta - Wage Your War | WoW-V.com (http://wow-v.com/)
To Create My own Vendors Npc's ETC.
know there is an option to tell how much xp you get from the quest i put in like 5000 and the how many gold you get from the quest i typ like 500 g
oke the quest has been made i put it in my DB and restart server works fine
i add the npc Who gives the quest Works fine
but when i finish the quest it dos not give me any xp ....
how can i change this ore is there anyway to put xp into a Quest???

[Bing]

Look in your quests table and see the problem there!

[ghostrevan]

i cant find the quest in the table?

[ghostrevan]

oke well i found the quest know 1 problem solved but where do i change the xp you get from the quesT?

[hax0rz]

it should say XP somewhere at the top you should be able to find the column

[Dimman]

UPDATE `quest_template` SET `XPCOLUMNNAMEHERE` = 1337 WHERE `entry` = QUEST ID;

[Bing]

Fatcow has the right way to do it, follow that!

[ghostrevan]

thax man ;) good Job ^^

[ghostrevan]

Fatcow How do i place this code in:
UPDATE `quest_template` SET `XPCOLUMNNAMEHERE` = 1337 WHERE `entry` = QUEST ID;

Mangos DB?
Ore how plz respond

[Bing]

Right-click the database you want to execute it in, and click Console! It'll bring up a another GUI, all you have to do is copy and paste that sql line in there and hit enter. Then you're all set!

[ghostrevan]

cant find console option and entering it to a query and save it to my mangosDB gives me an error.
plz help?

[Avidgamer]

All I can really suggest is having a good look through the Quest Table in your Database, as I'm not to familiar with Mangos I can't help that much, however, it shouldn't be too difficult, if the ways other users have explained haven't worked, just search through the Database looking for what you need, that's one way of learning a new database.

[ghostrevan]

thx found it ;)