looking for the happy number 404...

[rumpilstilskin]

Hello all,

Ok a bunch of questions !

I tried a few weeks ago to upgrade to the 404 udb revision and failed.

Now my 401 udb server is working fine so I'm not quite sure I want to “break” it all by attempting to update... in an other hand I really would like to know how to update ! Also I don't understand since a year ago I updated with success from my original install in 399 to 401.

A solution would be to create a new 404 server on my laptop and keep the 401 on my desktop.

First question : if I upload this new server with characters, mangos, realmd and scriptdev2 sql files from my desktop server to my laptop will I have all the modification I created in quests, npc and items? If not is there a file where I can find all these modifications?

Other question : If I finaly I decide to have my 401 server on my laptop can I just download the necessary programs ( Git, Tortoise SVN, Visual Studio, MySQL and SQL) and just transport my WoW and Mangos files on the C disk of my laptop? Or should in any case I have to go thru the whole process of installation?

Finally, I would very much appreciate if you guys could check the following process of installation and update, I have with no doubt something wrong there ! If you could be kind enough to tell what is wrong it would be great !

A/ Install process

1 – Install Git, Tortoise SVN, Visual Studio ++ 2008 Express, MySQL and SQL

2 – Cloning Mangos;

“GIT GUI”, “Clone Existing Repository”, enter git://github.com/mangos/mangos.git. Target Directory C:\\Mangos (The Target Directory must not exist)

Click “Clone” and wait for the task to finish – Close your “GIT GUI”

3- Cloning Scriptdev2;

Right click on C:\\Mangos and choose “Git Bash”

Type the following command replacing the XXXX by the numbers within the file name located in C:\\Mangos\\src\\bindings\\ScriptDev2\\patches :

git am src/bindings/ScriptDev2/patches/MaNGOS-XXXX-ScriptDev2.patch

Close the GIT Bash

4 – Compiling Mangos and Scrptdev2

Open the “sln” file that fit your version of C++

mangosdVC80 for C++ 2005

mangosdVC90 for C++ 2008

mangosdVC100 for a newer version of C++

Wait for C++ to finish loading. You’ll see a message on the bottom saying “Updating Intellisense”. It will change for “Ready” it’s done.

Click “Build” in the menu and select “Configuration Manager”

Click “Release” in the drop down box for “Active Solution Configuration”

The drop down box “Active Solution Platform” should already be set to “Win32”

Click on “Close”

Then, click “Build” in the menu and select “Build Solution”

Close the window when it’s done

Go to your C:\\Mangos\\src\\bindings\\ScriptDev2

Open the “sln” file that fit your version of C++

scriptVC80 For C++ 2005

scriptVC90.sln For C++ 2008

Wait for C++ to finish loading. You’ll see a message on the bottom saying “Updating Intellisense”. It will change for “Ready” it’s done.

Click “Build” in the menu and select “Configuration Manager”

Click “Release” in the drop down box for “Active Solution Configuration”

The drop down box “Active Solution Platform” should already be set to “Win32”

Click on “Close”

Then, click “Build” in the menu and select “Build Solution”

Close the window when it’s done

5 -Installing Mangos

Transfer the files from your compile folder into C:\\Mangos

They should be in C:\\Mangos\\bin\\Win32_Release

Go to C:\\Mangos\\src\\mangosd and copy “mangosd.conf.dist.in” to “mangosd.conf” in C:\\Mangos

Go to C:\\Mangos\\src\\realmd and copy “realmd.conf.dist.in” to “realmd.conf” in C:\\Mangos

Go to C:\\Mangos\\src\\bindings\\ScriptDev2 and copy “scriptdev2.conf.dist.in” to “scriptdev2.conf” in C:\\Mangos

Verify your Versions

Open the file C:\\Mangos\\News in notepad. (The file doesn’t have an extension)

The version of the supported World of Warcraft client will be mentioned

Ex.: “Upgrade to client version 3.3.3 (build 11723)”

3.3.3 (build 11723) is your World of Warcraft client requirement. Big patch will change the version number although smaller patch will only affect the build number within the same version. You must match the exact build version with your client

The version can also be found later on in PART 15 - Updating your Database with SQL Files in the Mangos Database

Download newest UDB database and the latest UDB update packs

Update your World of Warcraft client to the supported version

Place the sql files uploaded in C:\\Mangos

6 - Extracting Files From Your Client

Verify that you WoW folder is not on read only mod

(right clic)

Copy exerything in C:\\Mangos\\contrib\\extractor_binary in your C:\\World of Warcraft

Run Ad.exe from your C:\\World of Warcraft

It all depends of your computer speed but this will take few minutes to extract the files

When finish, move the folders Maps, Vmaps and DBC that has been created in your C:\\World of Warcraft to your C:\\Mangos

Extracting mmaps (movement maps... you need them!)

1) right-click on your WoW file and choose Git Bash from the menu - a new window should open

2) type in ExtractResources.sh

3) WAIT A LOOOOONG TIME

4) put the mmap file created in C:\\Mangos file

7 - Installing and Configuring MySQL

Install MySQL Server choosing Typical or Complete setup

When the installation is completed

Keep the check mark to “configure the MySQL server now”

Remove the check mark from “register the MySQL server now”

Choose “Standard Configuration” when asked

Put a check mark to “Install as Windows Service” and “Launch MySQL Server Automatically”

The service name stays “MySQL”

Click next

Keep the check mark to “Modify Security Settings”

Choose a password for your Mangos Server

Put a check mark to “Enable root access from remote machines” unless you know your won’t need it

Default server password is mangos, you should change it if you are making an online server for other players or activating that last option

If you plan to use the IP of the machine instead of localhost, you plan on having a registration page on another machine, or plan on being able to access the database from another machine other than the one the databases are hosted on, “Enable Root Access from Remote Machines” needs to be activated

Complete the configuration clicking on next and execute

8 - Setting Up the SQL Connection

Install and Run your SQLclient. In this case “SQLyog”

Click the “New...” button at the top of the window to create a new connection

Name the connection anything you like such “World Of Warcraft SQL Server”

Fill out the fields as indicated below:

MySQL Host Address: This is “127.0.0.1” or “localhost” if your SQLclient is on the same machine as the MySQL server. If you’re accessing this from another computer, put the LAN IP address or the Internet IP address depending on your needs.

Username: Type in “root”

Password: This is the password you set up when you’ve installed the MySQL Community Server - Installing and Configuring MySQL)

Database(s): Leave this blank for now

Click “Connect” and save the change

9 - Adding Databases

In the top left-hand side, right-click “root@(IP here)”

Click “Create Database” and create the following database:

realmd

mangos

characters

Select mangos database on the left (any database could do for now)

Open with notepad

C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\scriptdev2_create_database.sql

Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file

Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog

Click “File” in the menu at the top of SQLyog

Click “New Connection”

This time in the databases field, type:

realmd;mangos;characters;scriptdev2

Click “Save”

Click “Connect”

Now, in the left-hand database list, right-click “realmd” and select “Import”, “Restore from SQL Dump”

Click “Browse”, and select C:\\Mangos\\sql\\realmd.sql

Click “Execute”

Right-click “characters” and select “Import”, “Restore from SQL Dump”

Click “Browse”, and select C:\\Mangos\\sql\\characters.sql

Click “Execute”

Right-click “mangos” and select “Import”, “Restore from SQL Dump”

Click “Browse”, and select the UDB database Core file you’ve download

Ex.: UDB_0.11.6_Core_8734_SD2_1480.sql

Click “Execute”

Select the ScriptDev2 database on the left

Open with notepad:

C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\scriptdev2_create_structure_mysql.sql

Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file

Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog

Keep ScriptDev2 database selected and do the same for:

C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\scriptdev2_script_full.sql

Select the Mangos database on the left and do the same for:

C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\mangos_scriptname_full.sql

10 - Updating your Database with SQL Files

Update by increasing numbers; first the corepatch (this creats the table) then the updatepacks (this will populate your table)

Open SQLyog and connect to your server if you’re not already there

For each Database check the udate required and apply by increasing number to the end of the updates in “Updates” file.

Locate the updates you will need to apply on the database. Either in your C:\\Mangos\\SQL\\Updates folder or from the files you’ve downloaded (UDB Updates Pack)

Open with Notepad the .sql file you are going to use to update the database

Select the database to be updated

Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file

Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog

Parts of the application will become greyed, wait for the query to finish executing

11 - Adding ACID

Download ACID for your Client version if it’s not done (Basic, The Burning Crusade or Wrath Of The Lich King)

Still in SQLYog, select your Mangos Database.

Empty the “query” textbox to the right of SQLyog, past the contents of the .sql file you’ve downloaded

Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog and wait for this to be complete

Close SQLYog

It is recommended that ACID be added at the very end of all your database manipulation

12 - Configuring Mangos

Open C:\\Mangos\\mangosd.conf in Notepad

Look for the following codes (and change them if necessary):

Datadir=“C:/Mangos”

WorldDatabaseInfo = “[server IP];3306;root;

;mangos”

LoginDatabaseInfo = “[server IP];3306;root;[sql password];realmd”

CharacterDatabaseInfo = “[server IP];3306;root;[sql password];characters”

vmap.enableLOS = 1

vmap.enableHeight = 1

vmap.ignoreMapIds = “369”

vmap.ignoreSpellIds = “7720”

GameType = 8

RealmZone = 1

Expansion = 2

AllowTwoSide.Accounts = 1

AllowTwoSide.Interaction.Chat = 1

AllowTwoSide.Interaction.Channel = 1

AllowTwoSide.Interaction.Group = 1

AllowTwoSide.Interaction.Guild = 1

AllowTwoSide.Interaction.Auction = 1

AllowTwoSide.Interaction.Mail = 1

AllowTwoSide.WhoList = 1

AllowTwoSide.AddFriend = 1

TalentsInspecting = 1

While tuning your configuration file, if you intend to use the Auction House Add-On, you might want to configure your Addon as well (See AHBot Part 3 – Tuning the AHBot.conf.dist.in)

Save and exit

Open C:\\Mangos\\realmd.conf in Notepad

Look for the following code (and change it if necessary):

LoginDatabaseInfo = “[server IP];3306;root;[sql password];realmd”

Save, exit

Open C:\\Mangos\\scriptdev2.conf in Notepad

Look for the following code (and change it if necessary):

ScriptDev2DatabaseInfo = “[server IP];3306;root;[sql password];scriptdev2”

Save, exit

Copy C:\\Mangos\\mangosd.conf into C:\\Mangos\\mangosd.conf.old

Copy C:\\Mangos\\realmd.conf into C:\\Mangos\\realmd.conf.old

Copy C:\\Mangos\\scriptdev2.conf into C:\\Mangos\\scriptdev2.conf.old

[b] 13[/b] - Setting Up your World Of Warcraft Client

Copy C:\\World Of Warcraft\\Data\\enUS\\realmlist.wtf to realmlist.old within the same folder

Your locale folder may be named differently according to your region (“enUS”, “enGB”, “frFR”, “deDE”, etc)

Open realmlist.wtf in Notepad and change the contents to the following:

set realmlist [server IP]

set patchlist [server IP]

[b] 14[/b] - Running your Server

Launch C:\\Mangos\\mangosd.exe and C:\\Mangos\\realmd.exe

[b]B/ How to Update your Server[/b]

[b]1 [/b]- Write your supported version of Mangos.

Verify your Versions

Open the file C:\\Mangos\\News in notepad.

The version of the supported World of Warcraft client will be mentioned

Ex.: “Upgrade to client version 3.3.3 (build 11723)”

[b]2 [/b]– Mangos update

Right click on your C:\\Mangos folder and choose “GIT GUI Here”

Click on the menu “Remote”, “Fetch From”, “origin”

Wait until completion

Then close the Fetch window

Click on the menu “Merge”, “Local Merge”, “origin/master” and click on “Merge”

Wait until completion

If you get an error that says that a file is being modified, select the appropriate file in the list on the left and then click on the “Commit” button located in the middle

For any other errors on the above, try the menu ”Branch”, Reset...”

To see what changes happened, go to the menu “Repository”, “Visualise Master's History”

Close the GIT application windows

[b]3[/b] – ScriptDev2 Update

Right click on your C:\\Mangos\\src\\bindings\\ScriptDev2 folder and choose “SVN Update”

[b]4[/b]– Patch Update

Get all other Add-on updates that you're using and reapply them. (AHBot for example)

[b]5[/b] - Updating the files

Re-compile Mangos and ScriptDev2.

See 4 in Install process

[b]6[/b] – Install Mangos

See 5 in Install process

[b]7[/b] – Extract new maps, dbc, vmaps and mmaps

See : 6 - Extracting Files From Your Client in Install Process

[b]8[/b]- Download the newest UDB updates and update

SEE : 10 - Updating your Database with SQL Files in install Process

[b]9 [/b]– configure mangos

see: 12 - Configuring Mangos in Install process

your done... well you should be if nothing is wrong above... but obviously there is something wrong since it doesn't work

[b]

Thanks for helping ![/b]

[rumpilstilskin]

Thank you Antz, but I decided to do a brand new 404 install from scratch

Might come back here with more precise questions^^

[rumpilstilskin]

OK trouble is starting...

Installed, Git, Tortoise, Visual Studio 2008, MySQL and SQlog community.

Installed wow 3.3.5

launched Git Gui

Entered

Source Location: git://github.com/mangos/mangos.git

Target Directory: C:\\Mangos

Clicked "Clone"

got the following error message :

fatal: remote error:

Repository not found.

[amaru]

git://github.com/mangos-wotlk/server.git

[rumpilstilskin]

Thank you Amaru

[rumpilstilskin]

ok another problem :

Everything went smoothly for compiling Mangos. no error.

But I failed compiling ScriptDev2.

A small part of the compiling messages up to the last ligne with the failed message :

"

1> Le constructeur pour class 'ObjectGuid' est déclaré 'explicit'

1>..\\base\\escort_ai.cpp(344) : error C2039: 'HasSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(345) : error C2039: 'RemoveSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(346) : error C2039: 'HasSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(347) : error C2039: 'AddSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(435) : error C2039: 'RemoveSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(442) : error C2039: 'AddSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>..\\base\\escort_ai.cpp(503) : error C2039: 'RemoveSplineFlag' : n'est pas membre de 'Creature'

1> c:\\mangos\\src\\game\\Creature.h(455) : voir la déclaration de 'Creature'

1>Le journal de génération a été enregistré à l'emplacement "file://c:\\Mangos\\src\\bindings\\ScriptDev2\\VC90\\ScriptDev2__Win32_Release\\BuildLog.htm"

1>ScriptDev2 - 2336 erreur(s), 0 avertissement(s)

========== Génération : 0 a réussi, 1 a échoué, 0 mis à jour, 0 a été ignoré ==========

[antz]

Scriptdev2 must be placed in the following location and compiled from there:-

mangos\\src\\bindings\\ScriptDev2

Something else to check is that the scriptdev2 you have matches the version of mangos your are compiling, please see post:-

http://getmangos.eu/bb/topic/206/mangos-sourceproject-list/

[rumpilstilskin]

Thank you Antz. I had an old link for compiling ScriptDev2.

Since I already right click SVN Checkout C:\\Mangos\\src\\bindings\\ScriptDev2, I cant SVN Checkout any more. I have SVN Update or SVN Commit.

How should I proceed please?

[antz]

ohh not sure the SVN version is upto date anymore !!

- always used to use SVN Update

I now grab scriptdev2 from git

[rumpilstilskin]

I see.

Could you please explain me how to proceed?

I guess you GIT GUI on C:\\Mangos\\src\\bindings\\ScriptDev2, but I dont want to doo any think without beeing sure.

Could you please detail the differents steeps?

Thanks !

[antz]

i normally do the following:-

From the Git Shell....

CD mangos\\src\\bindings then
git clone 
[url]https://github.com/scriptdev2/scriptdev2[/url] ScriptDev2

(this is the WOLK release)

Once Complete, go into the scriptdev folder and build it

and for updates, just simply.....

CD mangos\\src\\bindings\\ScriptDev2 then
git pull

But from what i remember, Update pulls down the updates, and commit sends your changes

[rumpilstilskin]

ok so if I understand clearly

You launch GIT GUI

click on "Clone Existing Repository"

source Location : git://github.com/mangos/scripts.git ScriptDev2

Target Directory : mangos\\src\\bindings

then click "Clone"

Is that right?

If it's right what do you mean by :

"Once Complete, go into the scriptdev folder and build the project" ?

[antz]

yep thats correct.

ScriptDev2 is a separate project to mangos and needs to be compiled.

if you look in the scriptdev2 folder you should see all the relevent files to compile it

(much the same as mangos itself)

[rumpilstilskin]

Yes finaly compiled ScriptDev2 !

Thank you

... but still stuff to be made... might be back to you with more trouble

[rumpilstilskin]

Doesn't work.

I have the error message : mangos\\src\\bindings already exists

and : repositery not found.

Are you sure of this procedure?

What do you mean by CD mangos/src/bindings? I don't understand and the detailed of procedure I thought understood doesn't work.

could you please check this I cant continue my install without compiling ScripDev

[antz]

To use your instructions from your previous post....

Close the window when it’s done

Go to your C:\\Mangos\\src\\bindings\\ScriptDev2

Open the “sln” file that fit your version of C++

scriptVC80 For C++ 2005

scriptVC90.sln For C++ 2008

Wait for C++ to finish loading. You’ll see a message on the bottom saying “Updating Intellisense”. It will change for “Ready” it’s done.

Click “Build” in the menu and select “Configuration Manager”

Click “Release” in the drop down box for “Active Solution Configuration”

The drop down box “Active Solution Platform” should already be set to “Win32”

Click on “Close”

Then, click “Build” in the menu and select “Build Solution”

Close the window when it’s done

[rumpilstilskin]

Thanks a milion velvet ! Your explanation is perfectly clear ! Exactly what I needed

ScriptDev2 is cloned !

Starting to compile !

[rumpilstilskin]

More trouble.

Trashed my previous Mangos install and created a new mangos folder.

Followed you steep by steep velvet. Everything went smoothly with no error messages in cloning core and scripts.

Compiled server with no problems.

Failed in compiling Scripts :

...

1>guard_ai.cpp

1>follower_ai.cpp

1>escort_ai.cpp

1>Le journal de génération a été enregistré à l'emplacement "file://c:\\mangos\\src\\bindings\\Scripts\\VC90\\ScriptDev2__Win32_Release\\BuildLog.htm"

1>ScriptDev2 - 71 erreur(s), 1 avertissement(s)

========== Génération : 0 a réussi, 1 a échoué, 0 mis à jour, 0 a été ignoré ==========

translation : 0 succeded, 1 failed, 0 updated, 0 ignored

71 errors, 1 warning

[rumpilstilskin]

Yes I compile server before script. This is what is mentionned in the tutorial I found here and I give at the beggining of my post. Succeded installing two years ago with this methode... and a lot of help^^

Here is the end of the data when compiling script translated by Google translate :

1> guard_ai.cpp

1> follower_ai.cpp

1> escort_ai.cpp

1> Build log was saved at "file / c: \\ mangos \\ src \\ bindings \\ Scripts \\ vc90 \\ ScriptDev2__Win32_Release \\ BuildLog.htm"

1> ScriptDev2 - 71 error (s), 1 warning (s)

========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

If it's not to much asking, why dont you give me, like you detailed before, all your procedure, steep by steep to install and also to update?

I might make it then, since it seems my links are not accurate... and my procedure isn't good !

Thanks !