[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

Warlords of Draenor 6.2.3&6.2.4 , Legion 7.3.5 , Battle for Azeroth 8.3.7, Shadowlands 9.2.7, Dragonflight 10.2.7, The War Within 11.2.5

the alien god said:
I should've tested that download and not just do it on a presumption or maybe search about it
My apologies it's a third party link which I copied from discord without testing it myself, it says 11.2.5.63906 since that's a patch number I thought it's a client.It mislead me and it turn I mislead you

Since you require an older build and need to downgrade the client it doesn't hurt to downgrade it further with several more builds
just put the .exe in your _retail folder allow it to run for some time , should not download more game assets just the initial files to launch give it a few minutes (
replacing the wow.exe works for upgrading but a very tiny chanche for downgrading that it might redownload already downloaded game assets over and increase the wow folder size ) You can report on that if the background file redownloads while you play . Hopefully not

I give you the older repack 63976 and a wow.exe it's the backup I made, you do no sql queries

Wow.exe

drive.google.com drive.google.com

63796Precompiled.rar

drive.google.com drive.google.com

https://drive.google.com/drive/folders/1gaYbk27UJiOZqvO-j4GgxwReBH4SnMT0?usp=drive_link the map files
if you already got the map files try using them first
you can try using the one you already got by mistake by using that misleading link

hope they didn't change the version of the data files between updates, if they didn't then you can
personally I didn't backup them, using a third party link and hope they are still compatible
low chance they made changes to the map files but it has happened, usually they do between patch numbers ig 11.1 to 11.2 or 11.2 to 11.2.5

there's datadir setting in worldconfig for the location of their placement-check that or edit it, can use relative paths

and something that has happened to me which you should avoid folder nesting-maps folder inside maps folder upon extraction and so on

if the map files you already got don't work you can check if the 63976 repack has extractors it should extract the exact version of the map files needed to work-map, db, vmaps etc, not sure if they gave it, right now at the moment can't check if they gave the extractors

since the patch numbers are the same 11.2.5 it's just a build difference the background downloader shouldn't download more game assets while you play and the server should work throughout all 11.2.5 builds without needing to reextract the map files
wasting so much time and trying what not for broken software, they will fix it now that people report it
Click to expand...
Ok you won't beleive this but I found out what the issue was! It was this SQL not fully writing to the database

DELETE FROM `build_info` WHERE `build` IN (64154);
INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
(64154,11,2,5,NULL);

DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
DELETE FROM `build_auth_key` WHERE `build`=64154 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
(64154,'Mac','A64','WoW',0x2B47687B97FB51EFCC28274BF094EF7B),
(64154,'Mac','A64','WoWC',0x676F3B5CD92799B5CE6ECBFD42EBBC96),
(64154,'Mac','x64','WoW',0xD39F3B03CD34DC2CDDB7173EA9DA008E),
(64154,'Mac','x64','WoWC',0x410B672FD200829F2B39E91CA637DDBD),
(64154,'Win','A64','WoW',0xBDE661AFFD07520A536913612098913A),
(64154,'Win','x64','WoW',0x205D71769E2A1C2C04516A5CE36B35C2),
(64154,'Win','x64','WoWC',0x38F784495ED0129FF391B27EC34548E0);

UPDATE `realmlist` SET `gamebuild`=64154 WHERE `gamebuild`=63906;

ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '64154';
Click to expand...

What was happening was purely user error, of course :LOL: I was using DBeaver to manage the databases and instead of writing all of the above I was only actually writing the first line! Of course I was then adding the build info manually but the authorization key was missing! Hence why it never worked.

I switched to using the provided SQLyogCommunty editor and that is when I realised what was happening because I used ctrl + f9 to write the query and I could see it applied the whole thing!

So I now have the 63906Precompiled running with the Blizzard 11.2.5.64154 client. It logs in fine with gm@gm and password gm and I can see the existing 3 characters and create my own etc. GM commands work fine.

Some of the quests are not implemented properly yet so quest chains can be a bit glitchy but they are easy enough to to work around. The only issue I can see right now that is a problem is flying. Dragonflight seems to not be fully implemented and neither is ordinary flying although perhaps I need to tweak a few things but, we are a whole way further on than we were earlier.

Thanks for all your help. Without you and your suggestions I don't think I would have got this far. (y)
 
hey, i got a little problem, when i host the SPP-V2 server on my pc, have my DynDNS URL as external set in the realmlist and bnetserver.conf then i can play on the server but my friends cant connect from WAN. i have checked the ports on the router and the win-firewall also is open and when i set REST.localaddress to the URL aswell then they can play but i cant since i have no NATloopback, i currently use a tunnel but i want to move the server to a dedicated machine without tunnel.
 
Makishi said:
hey, i got a little problem, when i host the SPP-V2 server on my pc, have my DynDNS URL as external set in the realmlist and bnetserver.conf then i can play on the server but my friends cant connect from WAN. i have checked the ports on the router and the win-firewall also is open and when i set REST.localaddress to the URL aswell then they can play but i cant since i have no NATloopback, i currently use a tunnel but i want to move the server to a dedicated machine without tunnel.
Click to expand...
Hello, yes the correct is external Ip or dns as address in realmlist table and loginreset.externalIP in bnetserver.conf. That's alright
localaddress in db and loginrest.internaladdress they use the internal Ip of the pc you host the server on
as portal address in the game config,if they are on the same network they use the localaddress if they are on a different they use the externalIP/dns
if you try to connect on the host pc it can't connect via the externalIP since it's on the same network hence you need a loopback , moreover it's the same pc you host the server on, now uses the internalIP although I think I did it with 127.0.0.1 since it's the same pc I host the server on
Others asked similar questions and that's what I told them to do and worked for them
Hope it helps, cheers mate
 
Last edited:
Perslane said:
Ok you won't beleive this but I found out what the issue was! It was this SQL not fully writing to the database



What was happening was purely user error, of course :LOL: I was using DBeaver to manage the databases and instead of writing all of the above I was only actually writing the first line! Of course I was then adding the build info manually but the authorization key was missing! Hence why it never worked.

I switched to using the provided SQLyogCommunty editor and that is when I realised what was happening because I used ctrl + f9 to write the query and I could see it applied the whole thing!

So I now have the 63906Precompiled running with the Blizzard 11.2.5.64154 client. It logs in fine with gm@gm and password gm and I can see the existing 3 characters and create my own etc. GM commands work fine.

Some of the quests are not implemented properly yet so quest chains can be a bit glitchy but they are easy enough to to work around. The only issue I can see right now that is a problem is flying. Dragonflight seems to not be fully implemented and neither is ordinary flying although perhaps I need to tweak a few things but, we are a whole way further on than we were earlier.

Thanks for all your help. Without you and your suggestions I don't think I would have got this far. (y)
Click to expand...
At long last it works, congratulations, enjoy tww
It's always the most stupid mistakes that cause the most amount of trouble isn't it, as if it hasn't happened to me and then went above and beyond and spent too much time trying again and again to fix it, simple mistakes happened to me time and time again I guess my brain is blocking the negative memories associated with it or the times I forgot stuff and how I manged to do it, these guides are as much about the people as they are about me, need to have it written out in order to remember next time when I do it what I did before to manage to run it
and I've deleted the older expansions to free up space some of them I haven't run recently,
I've never heart about dbeaver, I've only ever used heidisql, sqlyog and navicat
your db manager executed the query one line at a time, since I've never used it I guess it's some default setting or there's a seperate button to do it all at once
don't remember personally experiencing this, it always executed the whole query in one fell swoop,
well I had problems with importing world databases and it crashes in the middle of it, turns out there are variables related to the session max packet size and connection time out and by default they were set too low and then boom heidisql crashes, importing the same sql files wasn't a problem on sqlyog I guess in sqlyoug by default they are set to higher number , probably how they both handle sessions could be different and maybe there are some variables in heidisql that potentialy could not even exist in sqlyog connections or vice versa, don't know the details specifically let alone the differences between the two, don't remember what happened in navicat at all

dragonriding/dynamic flight they had it working they claim to still have but the switch between normal flying ad dynamic isn't working, the only repack that has it is dekkcore for df, yesterday I read sicalicous promised to fix it
1762276603072.png
 
Last edited:
I think with database tools it is what works for you. I have used Heidi and a few others but I am more used to phpMyAdmin because that is what I use daily with websites. Not a lot of use in this case though. I only thought to use sqlyog when I watched that short tutorial video that Sicalicious put up.

Every day is a learning experience :)

Flying sometimes works, although not regular flying. It depends which zone you are in. I also have the dekkcore df repack running and yes flying works pretty well in that one. I would think the fix is going to be fairly simple and Sicalicious will get to it with the next update.

All in all though I think this repack works pretty well. Once the flying issue is sorted I will be happy (y)
 
Hello!

First of all, thank you for sharing this valuable information.

I'm trying to play BfA, but I can't find the MySQL.bat file in the BFA Core Reforged-Midgard folder during the repack. I thought it might have been blocked by a security program while unzipping, so I disabled Windows Defender before proceeding.

Oh, is that the MySQL file inside the _Server folder?

Thank you in advance for your response.
 
zero.ryushin said:
Hello!

First of all, thank you for sharing this valuable information.

I'm trying to play BfA, but I can't find the MySQL.bat file in the BFA Core Reforged-Midgard folder during the repack. I thought it might have been blocked by a security program while unzipping, so I disabled Windows Defender before proceeding.

Oh, is that the MySQL file inside the _Server folder?

Thank you in advance for your response.
Click to expand...
Greetings
It seems that you have found it,
if it isn't in the parent folder than it's inside some of the subfolders
I have deleted the repack and BFA long ago but I'm sure it run on my system before packing it
I don't remember the specifics the location of mysql.bat or even if that was the name of it,
My advice to anyone not being able to find the database starter is to do a *bat search in the parent folder of the repack and it would come up
Well some of the repacks have launchers that do that and don't have bats, if can't find the batch then look for a launcher
Personally I'm not sure which repacks needed to be run manually and which via a launcher and if there are path settings left to be set/changed
Well the guide slaped on the first page is as much about me as it is about other people, need to remember in the future what I had done before

Well here's the most important again. To find the db starter search in the parent folder for *bat files and if can't find any search for a launcher in the parent folder usually an .exe or in some cases there's one batch to run all
 
the alien god said:
Greetings
It seems that you have found it,
if it isn't in the parent folder than it's inside some of the subfolders
I have deleted the repack and BFA long ago but I'm sure it run on my system before packing it
I don't remember the specifics the location of mysql.bat or even if that was the name of it,
My advice to anyone not being able to find the database starter is to do a *bat search in the parent folder of the repack and it would come up
Well some of the repacks have launchers that do that and don't have bats, if can't find the batch then look for a launcher
Personally I'm not sure which repacks needed to be run manually and which via a launcher and if there are path settings left to be set/changed
Well the guide slaped on the first page is as much about me as it is about other people, need to remember in the future what I had done before

Well here's the most important again. To find the db starter search in the parent folder for *bat files and if can't find any search for a launcher in the parent folder usually an .exe or in some cases there's one batch to run all
Click to expand...
Hi alien god, is there a known way to get into the database of legion spp v2 year 5 update 4 as root admin ?

i can only seem to get into spp_user which leaves out the world tables that i need to change some things in
any help is appreciated thanks
 
akumavenom said:
Hi alien god, is there a known way to get into the database of legion spp v2 year 5 update 4 as root admin ?

i can only seem to get into spp_user which leaves out the world tables that i need to change some things in
any help is appreciated thanks
Click to expand...
Hello
I can't help you here, I can't login into an account that I don't know unless someone told me the username and password, I can only infer a db account from the db login settings of bnetserver.conf and worldserver.conf just as you did, As for the reasons the world db is hidden-they have their reasons I can only speculate but I think it could be to prevent people from stealing it and then selling it, Apologies but I'm not the person you should be asking this, you can try asking on their official discord: https://discord.com/invite/single-player-project-291115666097045506 but personally I don't think they would want to give you the root account, but noone can stop you from trying
Best regards
 
akumavenom said:
i thought that might have been the case but i thought i might ask just in case and thanks non the less
Click to expand...
It doesn't hurt anybody to ask, just in case
hints I forgot to tell you there are ways to reset the root@localhost password without login into it, you start mysql with skip grant tables, start it with -u root -p, alter the user and flush priveleges
It was something among these lines,I haven't done it recently and I pretty much forgot the exact order of the commands but you can check online, since you can manipulate dbs you can find a tutorial
but I think they are smarter than this-to leave the username of the root account as root
There are ways to reset the pw of the root without loging in but I'm not sure if there are ways to reset the username without login, take this as a hint, may or may not be useful to you, probably the later, cheers mate
 
Last edited:
You must log in or register to reply here.
Back
Top