What is the SQL script for autocompleting quest in trinitycore - master ?

[Zaco420]

What is the SQL script for autocompleting quest in trinitycore - master ?
Tried in quest_template to change tab to 0 and 65536 but after restarting server nothing changes

 

[Alexstrasza]

To autocomplete a quest in TrinityCore, you don't usually need to alter the quest_template. Instead, what you would usually do is to alter the character_queststatus table. Basically, you need to update the status of the quest for a specific character to "Complete".

Here's a basic SQL script that can be used to autocomplete a quest. Please replace the `QUEST_ID` and `CHARACTER_GUID` with your actual quest ID and character GUID:

```SQL
INSERT INTO character_queststatus (guid, quest, status)
VALUES (CHARACTER_GUID, QUEST_ID, 3)
ON DUPLICATE KEY UPDATE status=3;
```

This will set the status of the quest to '3', which is the code for 'Complete'. If the character already has a status for that quest, it will be updated to 'Complete'.

Please make sure to backup your database before running any SQL scripts to prevent accidental data loss.

Also, you might need to log out and log back in, or use the `.reload` command in order for the server to recognize the change.

If you still can't see the changes, please check your server logs for any errors. It's also worth noting that the server might not display changes in real-time. So you might need to wait for a few minutes or even restart your server for the changes to take effect.

 

[Zaco420]

Where l can check for the CHARACTER_GUID ?

 

[Thewarlock]

Quests bugs are being corrected by trinitycore staff but il will take a wile. For now, to complete the quest, run this command:

Necesitas, Acceder o Registrarse para ver el contenido.

.

You have to go find the #questid on wowhead.



For example, for the quest: From ashes to wisdom, which is ID: quest=84933 in wowhead you have to execute:

Necesitas, Acceder o Registrarse para ver el contenido.

Los errores de las misiones se van corrigiendo poco a poco.Por el momento para completar la misión, ejecuta este comando:

Necesitas, Acceder o Registrarse para ver el contenido.

.
Tienes que ir a buscar el #questid en wowhead.

Por ejemplo para la misione : De las cenizas a la sabiduríaz que es ID : quest=84933 in wowhead tienes de ejecutar :

Necesitas, Acceder o Registrarse para ver el contenido.

 

[Thewarlock]

Where l can check for the CHARACTER_GUID ?

If you mean your character infos, as GM just execute :

Necesitas, Acceder o Registrarse para ver el contenido.

If you mean npc infos, as GM just select the npc and execute :

Necesitas, Acceder o Registrarse para ver el contenido.

It will display all informations ingame.