temporary

juste double click on the file in your folder... doesn't need to be in wow client ...folder

Well its always nice to have up to date software such VC++ 2010 ... of course for mangos it works but it seem to me soo far that ScriptDev2 is only compatible with 2005 and 2008

Good job...

Comme ca tu parles français? haha

Ask Southpark lmao...

Well actualy it was the blizzard guys who did the cinematic for them...

Dunno how

Means you've extracted your files from a version of world of warcraft that isn't the one supported by your mangos version

If your Mangos version is 3.3.3 build 17000 (random number), then you need to patch your world of warcraft client up to build 17000 and then extract the maps files

seanb, no i don't take your comment the wrong way... i think its bin the part that most people asked question about and perhaps the hardess part to describ the right way...

I've re-wrote everything this week, i don't know if your talking about the new version or the old one.....

Yes UDB Corepatch and sql/updates is the same.... The Corepatch is a bunch of sql/updates...

theres 2 way to see it ...when you take the core from UDB to create your database, well you have a number there... theres a version for your mangos database... when you start updating the first time, its best to follow the next number from UDB ...its simple 388... 389....390 ... but when you check the version of your database, mangos won't launch because its not up to latest vesion... since theres still files in sql/update that can be use to upgrade your table even though UDB doesn't have them

UDB will only make pack of Core files that fits their UDB Updatepack ....because to be able to put content in the table, you need to create the table

Thanks for the example Vindir

Its a great idea Alteron, for my part i was just puting more item on the server... but as we do know, the more item you got, harder it is on the server especialy at login screen....

Hum, you should perhaps drop your table and restart part 14-15-16

When you update a table, make sur you've looked at the table version, this will help choose wich update to do first...

And please read all the **

Win 7!!! lol ..... well i use that and its doiing fine.... i don't know about the long run since my server's pc is always closed... haha

Users...?

Can you get more detail...

I assume its when they double click on the server in the realm list?

Is it people from outside your network?

Is it only some people or everyone?

Does it happen at some time of the day?

etc...

I don't think scriptdev2 supports VS2010 .... but you can ask them on their forum to be sur...

WernerCD, well i did use Turtoise SVN instead of GIT to clone Scriptdev2

CDProjets, i assume that you made a LAN server and an Internet server?

i also assume that connecting with an other computer on the network it does work with the LAN connection...you could also try the internet connection with your own pc see if it works but as soon as your going to redirect the ports, it may not work anymore with the internet conenction within the lan

So i guess, you may need to redirect your ports on your router....

Well in Part 15, theres a way to see every database version, it's describe there

No you don't need to do UDB Core pack if you've done one by one the C:\\Mangos\\sql\\Updates since they are the same, a UDB Core pack is a bunch of sql\\updates in one pack...since they do not release as much Core pack as Mangos release sql\\updates (obvious reason), by using the core pack, you will need to complete them with the sql\\updates missing update...

Of course, you need to do the UDB Updatepack to get data in your table after your done with the Core pack

lol you should remove your password from here...

It's simple, you haven't upgrade your database completely...

Check Part 15

** Now for the updates, you need to update the Core for your Mangos version witch you can get from either your C:\\Mangos\\sql\\Updates (This will contain the files from your last repository clone) or from the UDB team called “corepatch”. After that you’ll need to update your Contents with the “updatepack” from the UDB team

** Although, the UDB pack will give you a head start, it is better at the end to check your C:\\Mangos\\sql\\Updates folder since UDB doesn’t always have the core up to date

Well, did you check the realmlist file after you've run WoW Client to see if it has change back to the default settings because if you launch the game in a particular way, i think its gonna verify if your settings are correct, if not put back the settings in the file.... I've never had this problem but i heard about it....

Bah its simple, Mangos keep releasing new updates for the mangos core database...altough UDB only make patch once in a while ... 388, 389, 390 ... so the fact is they can't always be up to date unless they put as many as Mangos release...

Look, you keep gettings errors and errors and errors .... why just don't you erase everything and follow the guide i've made step by step downloading only the files that are in the link of this guide

I'm not going to add you on msn and do the work for you...

Theses errors seem to be about ScriptDev2

Look its simple, you're mangos wants 9803 to start ..... so find the updates in your sql\\updates folders and apply them to your mangos sql database

A couple of people have ask lately about this error, i can't find the post ...but i was wondering why a couple of people...

"Table `db_version` have field `required_9763_01_mangos_battleground_template` bu

t expected `required_9794_02_mangos_command`! Not all sql updates applied?"

Now i understand... its because UDB core pack for mangos doesn't have the latest, you need to complete it with your C:\\Mangos\\sql\\updates sql files...

have fun

An other little thing to improve

Executing characters_auctionhousebot_update.sql, it will say that this column already exist:

Query : /*Table structure for table `auctionhousebot` */ ALTER TABLE `auctionhousebot` ADD COLUMN `percentgreytradegoods` int(11) defa...

Error Code : 1060

Duplicate column name 'percentgreytradegoods'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Erixel:

• Type the following command replacing the XXXX number with the number of the file located at the specified path:

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

Krak:

Must be the browser, mine doesn't even show the file...

lol i know how i would be able to fix it...

Anyway, it was only warning, the patch applied...

but its always best to have it cleaned at the sources

Reporting 4 warnings

Reinstalling everything so i've download everything ...i'm patching mangos with the AHBot before compiling the software....

So heres what i did soo far:

** AHBot Part 1 – Creating the Patch file

** This will download a Mangos repository made by Xeros including the patch file. Unless you know that his version of mangos is being kept up to date, I believe its best to create the patch file and use it on our own mangos folder. Of course if you’ve bin able to acquire the patch file, you do not need to create one

• Create a folder name C:\\AHBotTemp

• Right click on the folder and choose “Git Bash”

• Type the following commands:

git clone git://github.com/xeross/mangos.git ahbot

cd ahbot

git checkout -b ahbot origin/ahbot

git diff master ahbot > ../ahbot.patch

• You’ve just created you’re patch file located in C:\\AHBotTemp

• Close your GIT window

** AHBot Part 2 – Auction House Patch – Require the software to be re-compile

• Create the folders C:\\Mangos\\Addon\\AHBot and put your patch file there

• Delete the C:\\AHBotTemp folder if you had to create the patch file

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

• You will need to test the patch to make sure your not going to run into trouble, type the following command replacing the X number with the number of the file located at the specified path:

git apply --check Addon/AHBot/ahbot.patch

• If the patch did not encountered any trouble, you can continue to the next point

• Type the following command replacing the X number with the number of the file located at the specified path:

git apply Addon/AHBot/ahbot.patch

Heres the message when i apply the patch:

Welcome to Git (version 1.7.0.2-preview20100309)

Run 'git help git' to display the help index.

Run 'git help <command>' to display help for specific commands.

Random@RANDOM-PC c:/Mangos (master)

$ git apply --check Addon/AHBot/ahbot.patch

Random@RANDOM-PC c:/Mangos (master)

$ git apply Addon/AHBot/ahbot.patch

Addon/AHBot/ahbot.patch:3461: trailing whitespace.

Addon/AHBot/ahbot.patch:3477: trailing whitespace.

Addon/AHBot/ahbot.patch:157: new blank line at EOF.

+

Addon/AHBot/ahbot.patch:258: new blank line at EOF.

+

warning: 4 lines add whitespace errors.

Random@RANDOM-PC c:/Mangos (master)

$

You map file error is because you probably run your ad.exe on a world of warcraft client that wasn't the right version ....exemple if your mangos revision is version 3.3.3a and you took the map from a client that was 3.0 ....then heres your error

For the other errors.... i beleive its your scriptdev2 update that isnt correct....had that before....

i don't know how you've worked your way out ....was it from try and error etc etc ...so i would simply suggest you drop your mangos database and scriptdev2 and restart over... it shouldnt be that long ...15min ....and try to get it clean installed....

download all the latest files btw...

Tyler:

PART 15 - UPDATING YOUR DATABASE WITH SQL FILES

** Core updates and Contents updates aren’t the same. Core files made by the Mangos team are the structure of your tables in the database. UDB will take the Core and populate them. So the UDB Core will have your Mangos structure and the Data up to a certain version.

So if we recap....

You have a DATABASE called MANGOS

We will refer to 2 things: the UDB CORE_PATCH and the UDB UPDATE_PATCH

a CORE_PATCH contain the tables, columns etc etc but they are Empty.....theres no value, theres no row....its like the frame of a car but without the seat ...the engine ...etc...

an UDB UPDATE_PATCH, theres goes your value in your columns.... theres your rows.... theres your seats....lmao

the CORE_PATCH is always made by the MANGOS team .... but you will also find them in them on the UDB download site ...because of course you can't populate the table if the table doesn't exist....

why they are split up ...simple .... you may not want to have a creature do 50 damage....you might want it to do 1000 damage....so the MANGOS team will give you the basic.... the tools....the tables...

Then you go find your data... such UDB ... or some other prefer YTDP or wahtever its called....

so when you UPDATE your Mangos software (not talking about core update or udb update...im talking about getting mangos repository up to date) , in the sql/updates you will find the CORE updates.... but you can also find them on the UDB Core pack as they took them from mangos and provided them to you in a patch ..... called CORE_PATCH....

So its simply logic that you need to run the CORE_PATCH file before the UPDATE_PATCH file in your sql database....

that you do Mangos first or Characters or realm, it doesnt matter.... they are separate database.... but you may need to update them all as i don't know if one may refer to an other.....