Azerothcore WoTLK Repack (Playerbots + Individual Progression + 32 other modules)

[Aldebaraan]

Could you please add the following modules? Or give the source code?

Faction Free, ARAC, Worgoblin, Black Market. My friends and I would really like to be able to use all races
AzerothCore
AzerothCore
AzerothCore
AzerothCore

mod-arac = can be applied on your end. Just follow the instructions on that page.
mod-Faction-Free, Black-Market-Auction-House = requires Eluna. I won't add Eluna for reasons mentioned in the FAQ.
mod-worgoblin = i tried this before. The module is too old (and abandoned) to be added to the current core.

[Remster]

Hello again. I wanted to ask about two things to do with bots and dungeons.

When I queue into a dungeon, bots will get summoned, except ones that are flagged for PVP (usually due to quests). Is there a way around this? I can summon them individually but it's just a bit annoying.

Also when I queue in BC dungeons it looks like DKs can't join. They mess up the queue and can't queue with them anyways because for BC dungeons it says they are locked behind completing a required quest. I'm guessing this has something to do with individual progression or them skipping their starting zone. Not sure. Do you know a fix for this?

Thanks again for any help.

[Aldebaraan]

Hello again. I wanted to ask about two things to do with bots and dungeons.

When I queue into a dungeon, bots will get summoned, except ones that are flagged for PVP (usually due to quests). Is there a way around this? I can summon them individually but it's just a bit annoying.

Also when I queue in BC dungeons it looks like DKs can't join. They mess up the queue and can't queue with them anyways because for BC dungeons it says they are locked behind completing a required quest. I'm guessing this has something to do with individual progression or them skipping their starting zone. Not sure. Do you know a fix for this?

Thanks again for any help.

Hi. You have better luck asking about playerbot issues on the playerbot discord itself. And please do not mention use of a repack.

[Alderian]

Hello.

For starter, thanks a lot for your work on this repack, I really like it a lot. I've really been enjoying my time with it.

I just have an issue that I don't really understand. After completing a raid, then logging out, some items in my inventory just disappear when I'm logging back.
For example, I was doing the quest for the Hydraxian Lords, where you have to obtain the hands of the bosses in Molten Core. I got the four hands required, but before handing the quest, I logged out. And when I logged back, one of the hands was missing from my inventory, with some of the loot I got from the raid. And so I had to go back to the raid, to kill the boss again.

Am I the only one that got this problem, and do you know what could be causing it, and how to avoid it ? I never got this problem when I was leveling from level 1 to level 60, it only happened from the moment I started to do the raids.

Thanks again for any help, and once again, thanks a lot for this repack

[HolliValentine]

Is there a way to basically wipe your server and restart? Asking out of curiosity.

[hanyang]

Hello, what should I do if I want to set up the server to be played locally in different PCs?

[Aldebaraan]

Is there a way to basically wipe your server and restart? Asking out of curiosity.

Yes.

Delete all playerbot data:

DELETE FROM `acore_playerbots`.`playerbots_random_bots`;
DELETE FROM `acore_characters`.`characters` WHERE `account` IN (SELECT `id` FROM `acore_auth`.`account` WHERE `username` LIKE 'RNDBOT%') OR `account` NOT IN (SELECT `id` FROM `acore_auth`.`account`);
DELETE FROM `acore_characters`.`arena_team_member` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`arena_team` WHERE `arenaTeamId` NOT IN (SELECT `arenaTeamId` FROM `acore_characters`.`arena_team_member`);
DELETE FROM `acore_characters`.`character_account_data` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_achievement` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_achievement_progress` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_action` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_aura` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_glyphs` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_homebind` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`item_instance` WHERE `owner_guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`) AND `owner_guid` > 0;
DELETE FROM `acore_characters`.`character_inventory` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_pet` WHERE `owner` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`pet_aura` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`pet_spell` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`pet_spell_cooldown` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`character_queststatus` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_queststatus_rewarded` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_reputation` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_skills` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_social` WHERE `friend` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_spell` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_spell_cooldown` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_talent` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`corpse` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`groups` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`group_member` WHERE `memberGuid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`mail` WHERE `receiver` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`mail_items` WHERE `receiver` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild` WHERE `leaderguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild_bank_eventlog` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`);
DELETE FROM `acore_characters`.`guild_member` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`) OR `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild_rank` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`);
DELETE FROM `acore_characters`.`petition` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`petition_sign` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`) OR `playerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
-- DELETE FROM `acore_auth`.`account` WHERE `username` LIKE 'RNDBOT%';

Delete all user character data:

DELETE FROM `acore_characters`.`characters`;
DELETE FROM `acore_characters`.`arena_team_member` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`arena_team` WHERE `arenaTeamId` NOT IN (SELECT `arenaTeamId` FROM `acore_characters`.`arena_team_member`);
DELETE FROM `acore_characters`.`character_account_data` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_achievement` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_achievement_progress` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_action` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_aura` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_glyphs` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_homebind` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`item_instance` WHERE `owner_guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`) AND `owner_guid` > 0;
DELETE FROM `acore_characters`.`character_inventory` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_pet` WHERE `owner` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`pet_aura` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`pet_spell` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`pet_spell_cooldown` WHERE `guid` NOT IN (SELECT `id` FROM `acore_characters`.`character_pet`);
DELETE FROM `acore_characters`.`character_queststatus` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_queststatus_rewarded` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_reputation` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_skills` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_social` WHERE `friend` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_spell` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_spell_cooldown` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`character_talent` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`corpse` WHERE `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`groups` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`group_member` WHERE `memberGuid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`mail` WHERE `receiver` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`mail_items` WHERE `receiver` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild` WHERE `leaderguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild_bank_eventlog` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`);
DELETE FROM `acore_characters`.`guild_member` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`) OR `guid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`guild_rank` WHERE `guildid` NOT IN (SELECT `guildid` FROM `acore_characters`.`guild`);
DELETE FROM `acore_characters`.`petition` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`petition_sign` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`) OR `playerguid` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`custom_reagent_bank` WHERE `character_id` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`custom_transmogrification` WHERE `Owner` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`custom_transmogrification_sets` WHERE `Owner` NOT IN (SELECT `guid` FROM `acore_characters`.`characters`);
DELETE FROM `acore_characters`.`custom_unlocked_appearances`
DELETE FROM `acore_auth`.`account` WHERE `username` LIKE 'RNDBOT%';

[Aldebaraan]

Hello, what should I do if I want to set up the server to be played locally in different PCs?

1. Open up ports 8085 and 3724 in your router.
2. Change realm IP to the IP of the computer where the server is running.
3. Send the IP to whoever will play in it, and change realmlist.wtf IP to that IP.

[Aldebaraan]

Hello.

For starter, thanks a lot for your work on this repack, I really like it a lot. I've really been enjoying my time with it.

I just have an issue that I don't really understand. After completing a raid, then logging out, some items in my inventory just disappear when I'm logging back.
For example, I was doing the quest for the Hydraxian Lords, where you have to obtain the hands of the bosses in Molten Core. I got the four hands required, but before handing the quest, I logged out. And when I logged back, one of the hands was missing from my inventory, with some of the loot I got from the raid. And so I had to go back to the raid, to kill the boss again.

Am I the only one that got this problem, and do you know what could be causing it, and how to avoid it ? I never got this problem when I was leveling from level 1 to level 60, it only happened from the moment I started to do the raids.

Thanks again for any help, and once again, thanks a lot for this repack

Did this happen in the previous update?

[Alderian]

Did this happen in the previous update?

Hey, thanks a lot for your time

I installed everything, I think it was in June, it was the version where you added the accountwide mounts module, I haven't changed the version since then.

[Aldebaraan]

Hey, thanks a lot for your time

I installed everything, I think it was in June, it was the version where you added the accountwide mounts module, I haven't changed the version since then.

Then please update to the latest august version and check if the issue still occurs.

[Alderian]

Then please update to the latest august version and check if the issue still occurs.

Well, indeed, I updated to the latest version, I did a full run of Molten Core, and this time, I didn't loose any items after logging out. It seems that it was linked to my older version, then. I hope it stays that way

Thanks again for your time !

[GuybrushThreepwood]

1. Open up ports 8085 and 3724 in your router.
2. Change realm IP to the IP of the computer where the server is running.
3. Send the IP to whoever will play in it, and change realmlist.wtf IP to that IP.

Hi!

I just want to add that if you can't edit your router settings (like me) you are forced to use something like Hamachi.
However, I've tried them all and the only thing that worked for me and my friend was Tailscale.

You'll have to edit the IP address in the mysql database as well if you go that route.

[hellowndcore]

Are the links for Updates ( 19-08 and 20-08 ) and the other download links working ?
Any time they just lead to health care stuff and scam pages.

nvm - with the helpful video to get to the correct links everything went well !

[Blyzard]

Are the links for Updates ( 19-08 and 20-08 ) and the other download links working ?
Any time they just lead to health care stuff and scam pages.

nvm - with the helpful video to get to the correct links everything went well !

Seems all links on the first page has been modified by adverts links. Maybe Aldebaraan account has been compromised ?