Hi all. I've been playing-modding the u3j sever and I found some info that might be useful to u guys.

When stuck with a bugged quest: get the quest ID, then go to 'player quests' via Navicat (aj_server). Locate the player_quest table then change the number in the quest_vars column to the subsequent one, this fixes most of the bugged quests for that specific character, eg:

player_id/quest_id/status/quest_vars/complete_count/complete_time 96369 2101 START 0(changeto1) 0 somedate-time

You can change to other variables like REWARD or COMPLETE, in which cases u must modify the quest-vars and complete_count columns.

Here are some quests/id/variables I have fixed for some of my chars with this method:

Ashes to Ashes 2122 COMPLETE 1 1 +anydate Suspicious Activity 2129 COMPLETE 1 1 +anydate Where’s Rae This Time? 2007 7 Manir´s uncle 2221 COMPLETE 1 1 +anydate Odella for Vuet 28503 COMPLETE 1 1 +anydate Hammertime 28507 REWARD 1 0 A Captive Flame 2036 5

I'm aware this is not a 'real' fix but it allows u to continue playing. Besides I dont know how to really fix the bugs, so this works for now. I hope this might help u.

Thx undergoer ^^

Pls, use the forum for collaborations.