Jump to content

[Wiki] From Nothing To Online Server (mangos Zero) (Windows)


lostone1993

Recommended Posts

please note I did not write this I am mearly Preserving it

Hey

Well, it's a sunny day and I'm in a good mood so I'll make this extremly detailed description to get a server up and running on your own. This tutorial will end up with you have a server online with the latest MaNGOSZero core, ScriptdevZero, ZeroProjectDB including ACID and an Blizzlike website with forums and armory.

In this part you will learn what programs you need to have an up-to-date mangoszero server, how to install MySQL with Apache, how to make it secure from hackers and how to download and from where

Part 2 - How to compile the core and fixing the database

Part 3 - How to extract what you need from your World of Warcraft folder and configurate it

Part 4 - How to get a Blizzlike Website and how to make your server go public!

Step 1

It begins: You will need a bunch of programs to be able to get everything you need, in this tutorial I will be using the following:

XAMPP for Windows - Including phpMyAdmin

Git-1.7.6

Microsoft Visual C++ 2010 Express

Step 2

Installation: Install all the programs listed above and if you can't do that I sincerely advice you to stop reading this tutorial. The only thing that I'm going to go a little deeper into in the installation part is the XAMPP installation:

- When installing BE SURE TO CHOOSE: Install Apache as service AND Install MySQL as service because otherwise you'll end up with some troubles later on.

Step 3

Security: Now when we have the XAMPP server installed, let's make it secure with a password for the databases to prevent hackers from getting in a little easier. Move into the folder where you have chosen to install XAMPP, for example: C:\\xampp\\

-Start up the XAMPP Control Panel Application, the file: xampp-control.exe

-Click on Start button for both Apache and MySQL, it should take some seconds and then they will be running. If you end up with having some problems using the control panel, simple use the file: xampp_restart.exe instead.

-Open up your internet (internet explorer / firefox / opera / etc) and write : http://127.0.0.1/security/xamppsecurity.php OR http://localhost/security/xamppsecurity.php , it's the same thing.

- You will now be in the security section where you are to choose a password. In this guide we will use the password: root

- Write down your password somewhere because you will need it later to access your databases. The password you've chosen will not be changed until you restart MySQL and Apache.

Step 4

Preparations: And then it's time to get all the things we need for the server; MaNGOSZero Core, ScriptDevZero and ZeroDB. We'll start with having a folder for everything:

- Move to a suitable location on your computer and create a folder named: Classic Server, in this tutorial we'll use the following location:

C:\\Classic Server\\

- Right click on the Classic Server folder and choose Git bash.

- The CMD will start up and in here you write: git clone git://github.com/mangos-zero/server.git and press enter!

- Continue the tutorial when it says: Resolving deltas: 100%(*/*), done. (* = number)

- The folder where the mangos core has been downloaded to probably is at this location in your computer:

C:\\Classic Server\\server\\

- We can download the ScriptdevZero aswell, move in to the folder:

C:\\Classic Server\\server\\src\\

- Right click on the folder bindings and choose Git bash

- Write in the CMD: git clone git://github.com/mangos-zero/scriptdev0.git and press enter!

- Continue the tutorial when it says: Resolving deltas: 100%(*/*), done.

- The folder where the ScriptdevZero has been downloaded to probably is at this location in your computer:

C:\\Classic Server\\src\\bindings\\scriptdev0\\

- Core side is now downloaded and ready to be compiled, we'll do that later.

- Time to get the datas for the Database, right click on the Classic Server folder and choose Git bash

- Write in the CMD: git clone git://github.com/mangos-zero/database.git and press enter!

- Continue the tutorial when it says: Resolving deltas: 100%(*/*), done.

- After it is finished simply shut Git Bash down by writing: exit OR click on: Ctrl + C

- The folder where the ZeroDatabase has been downloaded to probably is at this location in your computer:

C:\\Classic Server\\database\\

- You should have 2 folders inside the Classic Server now:

:: database

:: server

- You do? Good!

- Now you have all the things you need for to compile and put in to your MySQL! One step closer to gaming

Link to comment
Share on other sites

  • Replies 57
  • Created
  • Last Reply

Top Posters In This Topic

In this part you learn how to compile the core and fixing the database

Part 1 - What programs you need, how to install MySQL/Apache, secure it from hackers and how to download and from where

Part 2 - How to compile the core and fixing the database

Part 3 - How to extract what you need from your World of Warcraft folder and configurate it

Part 4 - How to get a Blizzlike Website and how to make your server go public!

Step 5

Compiling: Compiling your core isn't as hard as it sounds, it's quite easy. Move into the following folder:

C:\\Classic Server\\server\\win\\

- Double click on the mangosdVC100.sln file, this will start up OR choose to start it up with Microsoft Visual C++ Express 2010. If you need to get a registration code; registrate! It's free and will only take around 30 seconds.

- Click on Build and then on Configuration Manager on the top.

- A box will appear and instead of having Debug as an Active Solution Configuration, choose Release and Close it.

- Click on Build again and then on Build Solution.

- The compiling of your core has begun. It will take some time, be patience.

- After the compile is done it should say, for exampel: "Build: 11 succeeded, 0 failed, 0 up-to-date, 0 skipped" as long as there isn't any FAILED ones you are good to go.

- Move back to the ScriptdevZero folder:

C:\\Classic Server\\server\\src\\bindings\\scriptdev0\\

- Double click on the scriptVC100.sln file and do the same thing as you did with the MaNGOS core.

- Your ScriptdevZero and MaNGOSZero core has been compiled and can be found in the:

C:\\Classic Server\\server\\bin\\Win32_release\\

- One more thing you have to do is to copy over your configurations files, they can be found in the:

C:\\Classic Server\\server\\src\\mangosd\\ ::: for mangosd.conf.dist.in

C:\\Classic Server\\server\\src\\realmd\\ ::: for realmd.conf.dist.in

C:\\Classic Server\\server\\src\\bindings\\scriptdev0\\ ::: for scriptdevzero.conf.dist.in

- Copy these three configuration files over to the:

C:\\Classic Server\\server\\bin\\Win32_release\\

where you have the compiled core and change their names by deleting the ".dist.in" in the end.

- Create a new folder next to the Classic Server called Compiled

- Copy all files in:

C:\\Classic Server\\server\\bin\\Win32_release\\

to

C:\\Compiled\\

Step 6

Database: Wow, let's take a break, na I'm just kidding, KEEP ON WORKING!

- Make sure you have MySQL up and running with the new password you've chosen.

- Move to the folder:

C:\\Classic Server\\database\\

- Double click on the mysql_info file and open with wordpad. You will see the following lines a bit down:

USER=zp

PASS=zpdb

HOST=localhost

- Change USER= and PASS= to your chosen information. For this tutorial it will be:

USER=root

PASS=root

HOST=localhost

- SAVE! and close wordpad.

- Right click on the database folder in the Classic Server and choose Git bash

- In the CMD, write the following: mysql_import

- If you get errors, check the mysql_info file so that it contains correct information.

- If it did, please follow this guide: How to set the windows path in Windows 7

(- What you need to add is the path to the mysql bin files. These are in the Xampp installation folder. Example:

C:\\xampp\\mysql\\bin)

- If you did the step above with path, restart you computer and redo the CMD command with mysql_import

- If all is well, the import will start and you can relax for a moment.

- When it's done, close Git bash and move on in the tutorial.

Link to comment
Share on other sites

In this part you will learn how to extract what you need from your World of Warcraft folder and configurate it

Part 1 - What programs you need, how to install MySQL/Apache, secure it from hackers and how to download and from where

Part 2 - How to compile the core and fixing the database

Part 3 - How to extract what you need from your World of Warcraft folder and configurate it

Part 4 - How to get a Blizzlike Website and how to make your server go public!

Step 7

Maps, Vmaps & DBC: Jumping directly over to extracting the maps, Vmaps, Buildings & the DBC's from your world of warcraft folder.

- ad.exe only extracts the Maps & DBC files and can be found in:

C:\\Classic Server\\server\\contrib\\extractor\\

- Copy ad.exe over from that folder over to your World of Warcraft folder and double click it, the extraction of DBC's and maps will begin. Two folders will be created, Maps and DBC. Just let them be for now.

-To get the Vmaps you need to use the file: makevmaps_SIMPLE.bat found in

C:\\Classic Server\\server\\contrib\\vmap_extract_assembler_bin\\

-Be sure to copy ALL the files in that folder over to your World of Warcraft folder and click on file I mentioned above. It will take some time, get some coffee or some cookies, read the news, whatever. DO NOT CLOSE DOWN THE PROGRAM OR MOVE THE FOLDERS during the extract even if it looks done, just wait until it says it's done.

- When the extraction is done you will have 4 folders having the name: Maps, Vmaps, Buildings and DBC.

- Cut them and paste them in your Compiled folder.

Step 8

Configuration: You copied three configurations files over to the Compiled folder before and now we need to make them connect the right way to the database. First off is the mangosd.conf file.

- Right click on the file and open it with wordpad.

- Inside you will find something like this or change it to this:

RealmID = 1

DataDir = "."

LogsDir = ""

LoginDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);zp_realm"

WorldDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);zp_world"

CharacterDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);zp_characters"

MaxPingTime = 30

WorldServerPort = 8085

BindIP = "0.0.0.0"

It's really easy actually, there is great descriptions of what every line does and I suggest you read the whole thing through before you move on to the next step. The most important things is that you have written the right password at the right place and that the following for vmaps:

vmap.enableLOS = 1

vmap.enableHeight = 1

vmap.ignoreMapIds = "369"

vmap.ignoreSpellIds = "7720"

- Vmaps will be activated for use if it's "= 1"

- Do the same thing for the scriptdevzero.conf and the realmd.conf with the right password, username and database name. So it would look like this:

scriptdevzero.conf

ScriptDevZeroDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);zp_scripts"

realmd.conf

LoginDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);zp_realm"

- You could actually try to start up your server right now and hopefully play. Double click on the file mangosd.exe in your Compiled folder.

- If you get a following error like this: (check the Server.log file)

2011-11-09 21:52:21 ERROR:SQL: SELECT required_z1809_xxxxx_01_mangos_spell_affect_event FROM db_version LIMIT 1

2011-11-09 21:52:21 ERROR:query ERROR: Unknown column 'required_z1809_xxxxx_01_mangos_spell_affect_event' in 'field list'

2011-11-09 21:52:21 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2011-11-09 21:52:21 ERROR:

2011-11-09 21:52:21 ERROR: [A] You have: --> `z1807_xxxxx_01_mangos_spell_proc_event.sql`

2011-11-09 21:52:21 ERROR:

2011-11-09 21:52:21 ERROR: B You need: --> `z1809_xxxxx_01_mangos_spell_affect_event.sql`

2011-11-09 21:52:21 ERROR:

2011-11-09 21:52:21 ERROR:You must apply all updates after [A] to B to use mangos with this database.

2011-11-09 21:52:21 ERROR:These updates are included in the sql/updates folder.

- This means that the database is outdated compared to the core and we have to manually update it.

- Becuase of the new fixes for the core, the DB is not up-to-date with the newest core and will not work unless you read the ALL of the following instructions on how to manually update you Database!

- The mangoszero sql updates are found from the update folder(C:\\Classic Server\\server\\sql\\updates\\) and may be individually imported, for example:

:: z0385_099_01_mangos_item_template.sql ---> mangos database

- Now, let's say the error mentioned above pops up, it says:

2011-11-09 21:52:21 ERROR: [A] You have: --> `z1807_xxxxx_01_mangos_spell_proc_event.sql`

- So the database have all the updates up to and the z1807_xxxxx_01_mangos_spell_proc_event.sql

- But you need to have:

2011-11-09 21:52:21 ERROR: B You need: --> `z1809_xxxxx_01_mangos_spell_affect_event.sql`

- Alright, simple: we need to manually import the updates after z1807_xxxxx_01_mangos_spell_proc_event.sql until we have imported the

z1809_xxxxx_01_mangos_spell_affect_event.sql file.

- You import it using the oncoming phpMyAdmin in Xampp.

- Start up your browser(Firefox, Opera, Chrome..)

- And type the following: http://127.0.0.1/phpmyadmin/index.php

- Log on with your information, in this tutorial it's root for both.

- To the left, you will see your databases that you created before. Click on the _world (XXX) (XXX = numbers)

- At the top, click Import and then using the File to import, find the files after:

z1807_xxxxx_01_mangos_spell_proc_event.sql

and individually import them to the database, up until you imported the

z1809_xxxxx_01_mangos_spell_affect_event.sql

If you don't understand what files, please read the descriptions below.

------------------------------------------------------

While I'm writing here I'll just continue on explaining how to know what updates to apply if someone else got problems with that.

I'll take the following as an example:

z0013_088_01_mangos_command.sql :::: This shows to which core the database will be supported to.

z0013_088_01_mangos_command.sqll :::: This shows to which database this update shall be imported to.

So if you have imported all the updates from the MaNGOSZero updates folder then the database should support: The newest MaNGOSZero core

------------------------------------------------------

- And now when the Databases are up-to-date with the newest core, will we be able to move on

Link to comment
Share on other sites

Re: [Tutorial] From Nothing To Online Server

This is the last part and here you will learn how to get a Blizzlike Website and how to make your server go public!

And also some clarification on how to join your server

Part 1 - What programs you need, how to install MySQL/Apache, secure it from hackers and how to download and from where

Part 2 - How to compile the core and fixing the database

Part 3 - How to extract what you need from your World of Warcraft folder and configurate it

Part 4 - How to get a Blizzlike Website and how to make your server go public!

Step 9

Webpage and making the server Online!: Alright, we need a webpage for the players to post whatever they want to, a creation page and some other random stuff so they are happy. In this tutorial we will be using the following webpage:

:: Webow Blizzlike Website by Zynaga, configured by the WebowTeam and modified to work with MaNGOSZero by Yenza (dead was hosted on megaupload)

- First we need to download everything.

- Create a folder anywhere and name it "Blizzlike Webpage". Download the website from here: Webwow

- Wait for it to finish the download and unzip/unrar the Webwow3.x.x file. After the process have been done, move all the files to the Blizzlike Webpage folder.

- Copy everything in the Blizzlike Webpage folder and paste it in the htdocs folder inside the XAMPP folder, for example:

C:\\xampp\\htdocs\\

- If you restart Apache and MySQL and then start up your internet again and writes, http://127.0.0.1/ you will end up at the new webpage and it's installation, follow the guide and when it asks for an username and password use the following:

username: webow

password: webow

- Hopefully will it be success and you have installed your Webpage for the players!

Step 10

The last touch!: We are here! Finally, after all the hard work.

- Go to your World of Warcraft folder -> realmlist.wtf , for example:

C:\\Program\\World of Warcraft\\

- Open the file realmlist.wtf with wordpad and it could say this:

set realmlist eu.logon.worldofwarcraft.com

set patchlist eu.version.worldofwarcraft.com

Change it to this :::

set realmlist 127.0.0.1

set patchlist 127.0.0.1

-Removed section on making server public-lostone1993 if the luda dosent mind this being in there I will restore it or a mod can tell me if it is ok otherwise it shall remain gone

- Save and Close.

- Start up your server by clicking on the mangosd.exe & the realmd.exe file being in your Compiled folder.

- Wait for it to finish loading.

- Start World of Warcraft and log in with an account you've made on the website or the ones that are already created in the zp_realm database.

- PLAY!

Link to comment
Share on other sites

I cant belive, ill need thousand years to install this fucking server... I done evrything and on step 6 i stucked. When i neter command mysql_import i got error

"Importing ./zp_characters/auction.sql into zp_characters ...[creting zp_characters]

DATABSE zp-characters DOES NOT EXIST AND I FAILED TO CREATE IT, ABORTING"

I done part with user and password corectly, i made new user and pass on

http://127.0.0.1/security/xamppsecurity.php

and i checked in xampp/security folder and it mach, so i entered that in mysql info as u said and now i got this error, pls explain me what is problem here ???

Link to comment
Share on other sites

snip

did you try this ?

- If it did, please follow this guide: How to set the windows path in Windows 7

(- What you need to add is the path to the mysql bin files. These are in the Xampp installation folder. Example:

C:\\xampp\\mysql\\bin)

- If you did the step above with path, restart you computer and redo the CMD command with mysql_import

and what windows are you running?

Link to comment
Share on other sites

I just dont undertsand where to add path, i understand that path is " C:\\xampp\\mysql\\bin " but i dont understand where to add it, what requires this path ???

this a guide to setting the path, http://www.computerhope.com/issues/ch000549.htm

just make sure you have added this to the path veriable,

C:\\xampp\\mysql\\bin

i am fairly certain that will fix your problems, how ever failing that I will send you my backup databases and show you how to install them

incidently, I know your fustration, my first time was pretty rough too

Link to comment
Share on other sites

Now i am done ALL. FUCK YEA, on step 8 i started mangosd.exe and iy works , no errors... Webwow have some problems and i cant register now but nvm that i can make manually my acc, i dont need it public.... But whats with realmlist.wtf ??? You didnt finished ur tutorial, removed section ???

derp, sorry removed more then I should. I will fix that

ah the part i removed was to make the server public, something I remember seeing somewhere that the luda does not support

also this is not my tutorial, its a copy of a really good one

EDIT:Fixed missing info

Link to comment
Share on other sites

I created two accounts with command account create #name #pass in mangosd.exe, than i opened SQLyog and under zp_realm > account found my two accounts created successfuly.

I also in realmlist.wtf typed set realmlist 127.0.0.1 and when i enter WoW and type my accounts its not working, than i saw ur update and adde to realmlist.wtf set patchlist 127.0.0.1, but problem stayed. I cant enter , it displays like i used wrong pass or username, just cant access my acc i created.... what can be problem ?

Link to comment
Share on other sites

i checked realmd and mangos.conf and evertyhing seems ok but i found some errors in servr log from step 8, but errors showed in tutorial and in my server log doesnt mach... Ill copy all errors...

2012-07-29 11:12:32 ERROR:Table `creature_template` have creature (Entry: 14764) with equipment_id 4192 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.

2012-07-29 11:12:32 ERROR:Table `creature_template` have creature (Entry: 14765) with equipment_id 4192 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.

2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) has nonexistent modelid_1 (17192), can crash client

2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) are using modelid_1 (0), but creature_model_info are missing for this model.

2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) has nonexistent modelid in modelid_1/modelid_2

2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) has nonexistent modelid_1 (15676), can crash client

2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) are using modelid_1 (0), but creature_model_info are missing for this model.

2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) has nonexistent modelid in modelid_1/modelid_2

2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) has nonexistent modelid_1 (17312), can crash client

2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) are using modelid_1 (0), but creature_model_info are missing for this model.

2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) has nonexistent modelid in modelid_1/modelid_2

2012-07-29 11:12:41 ERROR:Table 'gameobject_loot_template' entry 8387 isn't gameobject lootid and not referenced from loot, and then useless.

2012-07-29 11:12:47 Loading BattleGround event indexes...

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150874 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150908 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150875 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150909 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150720 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150877 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150722 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150878 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150739 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150884 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150741 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150892 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150861 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150896 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150866 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150898 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150869 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150900 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150870 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150901 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150871 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150903 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150872 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150904 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150873 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150905 for event: map:0, event1:50, event2:2 ("(null)")

2012-07-29 11:12:47 >> Loaded 68 script definitions

2012-07-29 11:12:48 ERROR:Table `gameobject_scripts` has not existing gameobject (GUID: 28683) as script id

2012-07-29 11:12:48 event_scripts :

2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600016) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9425

2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600017) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9426

2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600015) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9427

2012-07-29 11:12:48 >> Loaded 16 CreatureEventAI summon definitions

2012-07-29 11:12:48 Loading CreatureEventAI Scripts...

2012-07-29 11:12:49 ERROR:CreatureEventAI: Creature 12143 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1214301.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Creature 15215 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1521501.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -1144 in table `creature_ai_texts` but not used in EventAI scripts.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -931 in table `creature_ai_texts` but not used in EventAI scripts.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -930 in table `creature_ai_texts` but not used in EventAI scripts.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -929 in table `creature_ai_texts` but not used in EventAI scripts.

2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -928 in table `creature_ai_texts` but not used in EventAI scripts.

2012-07-29 11:12:49

2012-07-29 11:12:49 >> Loaded 13438 CreatureEventAI scripts

Link to comment
Share on other sites

those errors are fine, I just went though and checked the errors happen anyway

what do you mean you cant access the account, I dont under stand. could you post the steps you have taken and where the error hapens.I know of an error in the database that needs to be fixed before you can use it

anyway just post the steps you have taken from starting up the server

Link to comment
Share on other sites

I think problem can be mysql_info, cause that file is used for access to database

The mysql_ files are Unix-only importers for the mangos-zero database. You can not use them on Windows. Currently for Windows it is only possible to import table by table if you want to use the zero darabase.

Link to comment
Share on other sites

I think problem can be mysql_info, cause that file is used for access to database

The mysql_ files are Unix-only importers for the mangos-zero database. You can not use them on Windows. Currently for Windows it is only possible to import table by table if you want to use the zero darabase.

I’m afraid i disagree git can understand and use them, if you don’t believe me try it yourself. I can record proof if you so require it

For windows you git bash the same folder as they are located and assuming the info is correct in mysql_info it will import it for you

Link to comment
Share on other sites

I’m afraid i disagree git can understand and use them, if you don’t believe me try it yourself. I can record proof if you so require it

For windows you git bash the same folder as they are located and assuming the info is correct in mysql_info it will import it for you

I meant that Windows usually can not use Bash as it does not have it. Forgot that git includes Bash on Windows.

Link to comment
Share on other sites

Do not import with a database gateway! Then it will hung up since of the big queries, use mysql -u root -p mangos < mangos.sql

If you want to merge all tables to one in linux use:

cat *.sql > merged.sql

windows:

cp *.sql merged.sql

then mysql -u root -p mangos < merged.sql (mangos is database name)

Regards

Link to comment
Share on other sites

i done all i need, made gm account.....

Now i am interested how to start fixing...

For example on server 1.12.1 where i play (live) Snarler when tamed dont have +100 resistance on all, Lupos dont progress (dont leveling up) and do not do shadow dmg as physical dmg, and that is his special ability ???

I had idea to find them in DB (and i dont know where are they in DB) and to setup they stats, but maybe ill need some scripting to fix this buggs i wrote above ???

Btw i am familiar with SQL, i studied it on college, but i wasnt working on it for some time so i forgot some things but ill start learning again........

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use