{SuperGuide} Create,Compile,Configure,MaNGOS + UDB + Scriptdev2(IMAGES)

[Xees]

I Advise you all Guys to Update your mangos to latest rev , MaNGOS SAOP and Gob Gossip is Implanted

[S0rcerer88]

When if Something is Wrong with ur patch then it might not work ,

You might have to do it manully , or Do it by Applying Each File at a time




Please Import From The Number Above Your Table in db Revision .

The Table Called Required_XXXX_XX_YYYY


The Number Above that

i dont understand sorry if u can help me step by step would be nice

[mmjklsm]

when making sure the udb is updated i got errors on the following files: 9339_01, 9349_01, 9354_01, 9477_01 and all after that any ideas? After a second attempt at it from the start i did get it set up but in game its not wotlk or bc any help would b great

[Gameo]

I'm stuck at the XXX importing step. I have these three files in the "0.12.0_additions" folder:

388_corepatch_characters_9311_to_9582
388_corepatch_mangos_9311_to_9582
388_updatepack_mangos

The 388_updatepack_mangos file imported fine, but the two other files won't import, SQLYog just gives me an import error. I assure you that I have followed the tutorial word by word, letter by letter, so do you have any idea what's going wrong here?

Here's the error that I get when I import one of those two files, it seems to be the same:

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-03-17 13:31:36
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-03-17 13:46:33
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-03-17 13:47:13
Line no.:2
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-03-17 13:47:41
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-03-17 14:36:01
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-03-17 14:36:27
Line no.:2
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-03-17 14:36:43
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

[mmjklsm]

try and do the "388_updatepack_mangos" in the mangos database, that worked for me, took me to DB version 9582 bypassing alot of the updates. This worked for me wish u luck I have built 2 successful by this way!

[Gameo]

try and do the "388_updatepack_mangos" in the mangos database, that worked for me, took me to DB version 9582 bypassing alot of the updates. This worked for me wish u luck I have built 2 successful by this way!

Yeah but the thing is, I can import the "388_updatepack_mangos" without problems, but it doesn't do anything about the other files, I still can't import them afterwards.

[Endbringer]

 	 	

Compiling...
sc_defines.cpp
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : see declaration of '_interlockedbittestandset'
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : see declaration of '_interlockedbittestandreset'
sc_default.cpp
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : see declaration of '_interlockedbittestandset'
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : see declaration of '_interlockedbittestandreset'
system.cpp
ScriptMgr.cpp
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : see declaration of '_interlockedbittestandset'
c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed
        c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : see declaration of '_interlockedbittestandreset'
Generating Code...

ideas?

[Xees]

c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040)

maybe something wrong with your version of VS

[Endbringer]

meh... downloadin other one <.<

[masimao]

Thanks for the great guide

[Gameo]

c:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040)

maybe something wrong with your version of VS

I don't want to sound annoying or bother you or anything, but could you have a look at my problem please?

[Xees]

Yeah but the thing is, I can import the "388_updatepack_mangos" without problems, but it doesn't do anything about the other files, I still can't import them afterwards.

Go To Your Desktop , Create a new text file , Change the Extension to .bat

Open it in Notepad++ and write this down inside it

dir *.sql /b > filelist.txt
FOR %%1 in (*.sql) do type %%1 >> project.sql

Then Copy all SQL files inside update folder to new File ,

Name This file "SQLZ"

Go to your SQLZ file and copy bat inside this file

double click Bat file

Go to your file project.sql that was just created inside SQLZ folder

Copy all SQL statements inside this file

go to your Database manager and paste this quarry and run it all

now your good to go

[[IceCreaM]]

>C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed
1> C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : see declaration of '_interlockedbittestandset'
1>C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed
1> C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1040) : see declaration of '_interlockedbittestandset'
1>C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed
1> C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : see declaration of '_interlockedbittestandreset'
1>C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed
1> C:\Program Files\Microsoft Visual Studio 9.0\VC\include\intrin.h(1041) : see declaration of '_interlockedbittestandreset'

[Xees]

If a Lot of people keep getting the same error , then its possibly from MaNGOS Source

[Zixie]

thank you this guide is very helpful

can you please make a guide to compile under ytdb