Quest Tracker

TrinityCore Development TrinityCore Code Discussion
1

Quest Tracker is a tool for TrinityCore that tracks most abandoned quests (see details) and show them in a web interface.

You need to enable your Quest Tracker in your worldserver.conf file by setting:

Quests.EnableQuestTracker = 1

To install the web interface, go in your web server folder and type:

git clone https://github.com/ShinDarth/TC-Quest-Tracker.git

then open the [B]TC-Quest-Tracker[/B] folder, copy the file [B]config.php.dist[/B], rename the copy to [B]config.php[/B] and edit it properly (it's quite commented).

Released under AGPL license.

2

Great work, you are the best!

Thx for share this.

+rep

3

Update: fixed several minor bugs and added displaying of “Last Abandoned” and “Last Completed” datetime

4

Error querying: SELECT t1.id, t2.title, COUNT(t1.quest_abandon_time) AS abandoned_times, COUNT(t1.quest_complete_time) AS completed_times, MAX(t1.quest_abandon_time) AS last_abandoned, MAX(t1.quest_complete_time) AS last_completed FROM (SELECT id, quest_abandon_time, quest_complete_time, core_hash, core_revision FROM characters.quest_tracker) AS t1 JOIN (SELECT id, title FROM world.quest_template) AS t2 ON t1.id = t2.id GROUP BY t1.id HAVING abandoned_times > 0 ORDER BY abandoned_times DESC LIMIT 0, 20

5

Error querying: SELECT t1.id, t2.title, COUNT(t1.quest_abandon_time) AS abandoned_times, COUNT(t1.quest_complete_time) AS completed_times, MAX(t1.quest_abandon_time) AS last_abandoned, MAX(t1.quest_complete_time) AS last_completed FROM (SELECT id, quest_abandon_time, quest_complete_time, core_hash, core_revision FROM characters.quest_tracker) AS t1 JOIN (SELECT id, title FROM world.quest_template) AS t2 ON t1.id = t2.id GROUP BY t1.id HAVING abandoned_times > 0 ORDER BY abandoned_times DESC LIMIT 0, 20

​Thank you for reporting it, fixed: https://github.com/ShinDarth/TC-Quest-Tracker/commit/193443115c28e3046eef5fa24c2c8d34a3f33b0b