[Repack] Mangos Zero 1.12.1 by KrisBG "Shadows Of The Past"PreTBC

[stickeykeys]

Thanks for the Repack, how do i import databases, im using navicat mySQL i dont know if i should be, but it wont let me connect, and i cant find any import functions. (im a complete noob to this stuff)

[WoWTech]

Really great pack indeed! I do personal, love PreBC the most. But I would like to hear if any other testers of this pack got "Another action is in progress" bug? Makes it difficult to tame a beast, use of spells and others. I would also like to get a fix for the pet feeding. I tamed a Boar, and I couldn't feed it with anything, cheese/fish/meat/crap etc. So it can't gain happiness. So sad. And then I tried to use the "Feed Pet EFFECT". It says in log it gains happiness +10 like normal, but the mood doesn't change just a bit. Anyways, +Rep

[Dj-Dejan]

nice very nice

[nirracca]

Can someone import the DB and put it out for download?
becouse i don't know how to import it ?

[WoWTech]

Can someone import the DB and put it out for download?
becouse i don't know how to import it ?

I recommend SQLyog and not Navicat.

When you have created a world database in SQLyog/Navicat, then Right-Click on it and click "Restore from SQL Dump...". Go find "Mangos Database.sql" which should be located in the folder named "sql". And the sql folder is located in the mangos main folder.

- If this were any good for you, why not +REP me?

thanks for this.... so far all is working pretty nice.... is there anyway you could point me in the direction of a proper way to make items in this database/a list of commands for this version of wow/mangos... any help would be much appreciated!!!
nice repack +rep

EDIT: Actually I kinda got the hang of it... but im having trouble creating accounts
think anyone could help me out?
Like im clueless with this structure of database

EDIT: I was having trouble getting Majordomo to spawn... I wasn't able to extinguish the runes with either item.
Just thought I might throw that out there.

I can help you with your "Account Management Problem". If you want to create an account without using the website included with the repack, then you simple have to run mangosd.exe like you do, let it finish loading and then type following in mangosd.exe: account create #name #pass

Please +Rep if this were any good to you. :wave:

[nirracca]

I recommend SQLyog and not Navicat.

When you have created a world database in SQLyog/Navicat, then Right-Click on it and click "Restore from SQL Dump...". Go find "Mangos Database.sql" which should be located in the folder named "sql". And the sql folder is located in the mangos main folder.

- If this were any good for you, why not +REP me?

Okey, i have done that with the SQLyog and imported the Mangos and he otherone, but it is like millions of updates? shall i do same with All of them?
Or is it just to import mangos and the otherone then ready to start?

[WoWTech]

Okey, i have done that with the SQLyog and imported the Mangos and he otherone, but it is like millions of updates? shall i do same with All of them?
Or is it just to import mangos and the otherone then ready to start?

In update folder, you'll see the main updates:
Execute z0002_083_01_mangos_mangos_string.sql to Mangos Database
Execute z0001_xxx_02_mangos_db_version.sql to Mangos Database
Execute z0002_083_02_mangos_command.sql to Mangos Database

Execute z0001_xxx_03_realmd_realmd_db_version.sql to Realm Database
Execute z0003_086_01_realmd_realmlist.sql to Realm Database

Execute z0001_xxx_01_characters_character_db_version.sql to Char Database

For ScriptDev2 updates, do following:
Execute scriptdev_1.sql, then scriptdev_2.sql and scriptdev_3.sql to scriptdev2 db

For your final update, open the 1.0.0_acid_mangoszero folder and:
Execute 1.0.0_acid_mangoszero.sql to Mangos Database

If you have any trouble with executing, then PM me. :wave:

[jejuasji]

Thanks! works correctly, i love Pre-BC

[joness]

I keep getting the following error message when trying to import the z0001_xxx_02_mangos_db_version update.

Here is what is says using Navicat Lite:
[Err] 1054 - Unknown column 'required_078_8749_01_mangos_mail_loot_template' in 'db_version'
[Err] ALTER TABLE db_version CHANGE COLUMN required_078_8749_01_mangos_mail_loot_template required_z0001_xxx_02_mangos_db_version bit;
[Msg] Finished - Unsuccessfully



And this is what it says when using SQLyog:
Error occured at:2010-01-09 21:52:55
Line no.:1
Error Code: 1054 - Unknown column 'required_078_8749_01_mangos_mail_loot_template' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_078_8749_01_mangos_mail_loot_template required_z0001_xxx_02_mangos_db_version bit



Can anyone help me with this? I will +rep if so!

[EmuX]

Say's map 0004331 is outdated but I am extracting them from my 1.12.1 client...

Update: Fixed, just needed to use the Ad.exe that came with it.

[WoWTech]

I keep getting the following error message when trying to import the z0001_xxx_02_mangos_db_version update.

Here is what is says using Navicat Lite:
[Err] 1054 - Unknown column 'required_078_8749_01_mangos_mail_loot_template' in 'db_version'
[Err] ALTER TABLE db_version CHANGE COLUMN required_078_8749_01_mangos_mail_loot_template required_z0001_xxx_02_mangos_db_version bit;
[Msg] Finished - Unsuccessfully



And this is what it says when using SQLyog:
Error occured at:2010-01-09 21:52:55
Line no.:1
Error Code: 1054 - Unknown column 'required_078_8749_01_mangos_mail_loot_template' in 'db_version'
Query:
ALTER TABLE db_version CHANGE COLUMN required_078_8749_01_mangos_mail_loot_template required_z0001_xxx_02_mangos_db_version bit



Can anyone help me with this? I will +rep if so!

You shouldn't worry about it my friend. I can try to re-write the sql files, and upload them for you. I won't guarantee it will make any difference, but I'll PM link for downloading hnoes:

[nirracca]

Nice repack, works fine now and THanks WoWTech For all help +Rep

[joness]

You shouldn't worry about it my friend. I can try to re-write the sql files, and upload them for you. I won't guarantee it will make any difference, but I'll PM link for downloading hnoes:

You are amazing! +Rep

[Hyldran0]

Hey ! i getting this error when i opening mangos.exe

2010-01-11 01:16:26 Using configuration file mangosd.conf.
2010-01-11 01:16:26 World Database: 127.0.0.1;3306;root;fhw8phnv2p;mangos
2010-01-11 01:16:26 MySQL client library: 5.0.56
2010-01-11 01:16:26 MySQL server ver: 5.0.89-community-nt
2010-01-11 01:16:26 ERROR:SQL: SELECT required_z0002_083_02_mangos_command FROM db_version LIMIT 1
2010-01-11 01:16:26 ERROR:query ERROR: Unknown column 'required_z0002_083_02_mangos_command' in 'field list'
2010-01-11 01:16:26 ERROR:Table `db_version` have field `required_z0002_083_01_mangos_mangos_string` but expected `required_z0002_083_02_mangos_command`! Not all sql updates applied?

I'v been updateing all my DB's and so on whit the Updates in the Repack.. it took a while but finally i made it and tryed to start the server but it was the same error as first i started it whit not all updates.. please help !

[XatoKazuko]

2010-01-11 02:07:13 MaNGOSZero/0.12.1 (* * Revision 3 - *) for Win32 (little-endian) [world-daemon]
2010-01-11 02:07:13 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://getmangos.com
MMMMMM


2010-01-11 02:07:13 Using configuration file mangosd.conf.
2010-01-11 02:07:13 World Database: 127.0.0.1;3306;root;ascent;mangos
2010-01-11 02:07:13 MySQL client library: 5.0.56
2010-01-11 02:07:13 MySQL server ver: 5.0.45-community-nt
2010-01-11 02:07:13 Character Database: 127.0.0.1;3306;root;ascent;characters
2010-01-11 02:07:13 MySQL client library: 5.0.56
2010-01-11 02:07:13 MySQL server ver: 5.0.45-community-nt
2010-01-11 02:07:13 Login Database: 127.0.0.1;3306;root;ascent;realmd
2010-01-11 02:07:13 MySQL client library: 5.0.56
2010-01-11 02:07:13 MySQL server ver: 5.0.45-community-nt
2010-01-11 02:07:13 Realm running as realm ID 1
2010-01-11 02:07:13 Using World DB: Mangos default database.
2010-01-11 02:07:13 Using creature EventAI: Creature EventAI not provided.
2010-01-11 02:07:13 Using DataDir ./
2010-01-11 02:07:13 WORLD: VMap support included. LineOfSight:0, getHeight:0
2010-01-11 02:07:13 WORLD: VMap data directory is: ./vmaps
2010-01-11 02:07:13 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2010-01-11 02:07:13
2010-01-11 02:07:13 Loading MaNGOS strings...
2010-01-11 02:07:14
2010-01-11 02:07:14 >> Loaded 665 MaNGOS strings from table mangos_string
2010-01-11 02:07:14 Initialize data stores...
2010-01-11 02:07:14 ERROR:
Some required *.dbc files (1 from 46) not found or not compatible:
./dbc/BankBagSlotPrices.dbc (exist, but have 0 fields instead 2) Wrong client version DBC file?