TULOA

I looked through the SQL command list and the other places for GM Commands yet I don't see one for implementing Refer a Friend. I know I can link it by SQL but is there a command for this with the worldserver? Otherwise where would be a good place to suggest adding one? This way we can use Soap to add it during signup instead of SQL.

For whatever reason apparently the server is saying There is no such subcommand. Do I need to enable this in the build process from cmake?

I sure can. Is this process in a faq somewhere on how to do this as being new to it im not sure how to do so.

Yup didnt see that setting enabled and for the life of me I was stumped for the time there. Now im just trying to get enchant scrolls in the AH. If I cant ill just have to make a tool to add auctions. Which will likely at this point be the easiest way to do it.

Ok well based on testing for the last hour I have to conclude that was indeed it. I have also made a change to AuctionHouseBotSeller.cpp to add a query line to a customer database with my enchants I want shown in found from a search for scrolls on the item_template in world passed it all into a table and added a select line matching the others. If this goes well I will be all set. I am not versed enough in git to try to make an upload for a fix for this but it should be fairly simple. Edit: Well so far no good lol. Im sure not giving up on this but I guess I need to keep checking the code to see how it checks items. I assumed with the extra select and items in there it would be fine but those are loot tables. Back to the drawing board it seems lol.

Ok so for clarity maybe its the: AuctionHouseBot.Items.Misc = 0 Setting? They no longer seem to show up but also there is no other enchants so far. Ill keep an eye but could use some input on this. Also fixed a few issues and did an init on git to fix the revision stuff so heres mine: TrinityCore revision : 331e463de83e 2017-07-21 23:00:14 +0200 (3.3.5 branch)

Looks like for whatever reason the bot is using items that are no longer available to the players. Any idea what would be causing this? See attached screenshot. Its using this ItemID: 35420 for `Enchant Bracer - Brawn` when it should be using ItemID: 38897 This apparently isnt the only one doing this. Most all enchants are this way that are scrolls except Enchant Weapon - Major Spirit. My version was pulled on July 18th. I thought it was a migration issue from Mangos but its not. Its the bot sadly somehow.

Had just finished moving everything over to trinitycore from a mangos server. I only moved characters and items and what quests they were on. Along with guild data. Apaprently though and I dont know if this was happening on mangos also but the Arena Grandmaster quest has above it on the quest log: "Missing header! (quest designers)" Seen in the attached file. Anyone know by chance how this can be fixed offhand? I read through the quest template database in the world section but its not off hand showing me anything I personally can see to cause the issue. If you need any further debug info I will be glad to get it. I cant get the version info from the server itself however as its all 0's

Ok I figured it out. I had to pull all entries from character_queststatus_rewarded and delete matching entries in character_queststatus for that guid quest numbers. Example: Had this Line in characters.character_queststatus: guid, quest, status, explored, timer, mobcount1, mobcount2, mobcount3, mobcount4, itemcount1, itemcount2, itemcount3, itemcount4, playercount 3,9569,3,0,1500417612,0,0,0,0,0,0,0,0,0 And in character_queststatus_rewarded: guid, quest, active 3,9569,1 Once I removed these in rewarded from the queststatus they are out of the quest log. I may have to do additional checks but it should be fine and I need to do more testing lol. Thanks for the help.

Ill check... Running 3.3.5a myself. I wasnt sure why it ported all quests into the quest log but those in progress but must be something different with the layout of how they handle the quest log. Edit: I checked it and its completely blank after completing a couple on the server and abandoning the rest. So it must be somewhere else in the databases. Maybe Ill search for a completed quest ID now that they are dealt with.

I was migrating over from a CMaNGOS server to this and got a fun glitch occur with the quest log. It shows a full list of quests already completed. All I did for the migration was backup all databases and import fields that existed in the Trinity DB. It all runs fine however it lists them to what appears to be in order of number. I likely moved something over without knowing and while I suppose its not an entirely big still just starting the both up I would end up either restarting the quests I cant see or do them without being able to track them. Where would I find where Trinity tracks what quests are in the quest log?