Completing Quests

[Sikuri]

Hello there.
So I had an issue where my repack shat itself, I lost character data/character data was mixed up between characters on an account.

Anyways, I simply unzipped a new V9.1 repack.
I levelled up the two main characters on the last server to where they were.

Now I want to know how to auto complete those characters quests for them?
I got some quest ID's from WoW-Head, but in-game I need to add a single quest, then complete that single quest using the '.quest reward' command, otherwise the characters need to go back and hand it in.

Anywho, can someone help me find a better, faster way to add/flag these quest ID's as completed for the characters?

Thank you guys!

 

[Sikuri]

... I now see that no loot drops from kills on one character, unless that account logs out, then back in. And the loot is only for the monsters that are killed before logging out. Anything killed after logging back in doesn't drop loot.

And a party can't be formed, on one account, nothing happens, when the other account invites, it's states 'cant find player'

So bummed out.

 

[Titesusy]

Only for these characters you mentioned, i don't really know a better way than the ".quest add / .quest complete" ingame. But if you want these quest autocomplete for EVERY players, in sql you can auto them by :
In the example, you can replace the list of numbers by your list of questId:

-- Auto complete a quest:
UPDATE `quest_template` SET `Method`='0', `Flags`='65536' WHERE id IN ( '1111', '1112', '1113' );

 

[Sikuri]

Interesting... Thank you for your insight!!
This may be what I'm looking for.

 

[Titesusy]

(( small update ))