How to setup a WoTLK Trinity Server 32 & 64 Bit. All Downloads Included.

[Monolith]

Well..navicat is not really good for big sql imports...best to use sqlyog...

probably missed that table along the way or something...

[pqthanh80]

Dear Monolith,
could you please show us a process for update from old repack to new repack ?
That mean we'll replace all new files by old file and restore all new database ?
Because I use repack 15 , 18 , 20..... now 23 .

Thanks all for support

[Monolith]

Updated the original post with the newest release....





Best way to update using these repacks is to copy your mangos and realmd executables somewhere safe.

Overwrite your old executables with the new ones and run it.

If all works fine then there were only changes in the mangos source code...

If database errors were thrown at you...then you have to do some fixing....

The easiest way I have found to do this is to execute the new database under another name...such as update or something...

Then you can simply dump whatever sql you need to a .sql and execute it on the original mangos using the update command.

EX: You copy over the new core and it says..."Missing row respawn_time in creatures table."

In the test database...dump creatures table to a .sql...then use the update command in it...

Execute it on your original mangos and it should update the tables with the new rows....keeping your existing information intact...

Just make sure you remove any commands in the .sql dump such as DROP table...ect ect...


I only use this method because I have ALOT of custom content added into my database....

If you really have a baseline server...the easiest way is to simply backup the player info and install the new database completely....then update the player info into the new database....

[bulgarian]

my mangosd.exe is giving me this error :
2009-04-02 15:45:51 ERROR:Check existing of map file './maps/0004331.map': not exist!
2009-04-02 15:45:51 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.


my vmap files are in C:/appserv/mangos/data/vmaps


and another thing when i try to connect it only gives me "loging in to game server"

[Monolith]

Did you extract your maps?

Did you let it completely extract?

First mistake I have seen people make is they do not let the program completely extract the vmaps....

It will look like it's done...but it's rebuilding the maps.....

Make sure your mangos.conf is pointing to the correct file that you have your maps in....

Make sure you use the map extractor included with the server files...

If you are trying to use your own from a previous version they will not work....things have been altered...

[bulgarian]

tnx for the info i`ll try :P and i think this is why i cant get in the server....


EDIT:
OOOKKKK i got everything but now i have problems with the db no creatures when create hero and log the hero dissapears can`t find a good db :S help

[Monolith]

Which db did you use?

There are 2 different db's made by 2 different developers included...

YTDB and PSDB....

I know for a fact that at least 100+ people have installed this with no such problems...

Being you had the problem with the previous tables....I am thinking alot of your tables did not create correctly...

Download sqlyog and re-execute the db. Navicat does not work correctly on database backup these size.

[bulgarian]

tnx i have sqlog and i`ll try P.S.
I have used Mangos 7606 3.0.9 + Sdev 978

EDIT:
NOPE still don`t have NPC ;ITEMS;GAME OBJECTS
and the mangos queries are only 671 witch is strange :|

[Monolith]

I am at wits end then.....

You can try and say your problem where I got the repack from....the person whom actually compiles the releases and puts it all in one package is on there frequently...

Go here to make a post explaining your problem...

[pqthanh80]

each repack has some changes they relate each other , so we have to update every patches by order , right ?
That mean if I want to use repack 24 and my version is 18 , so I must update step by step repack 19, 20, 21,..24 ?

Thanks & see you soon
Anyway , have you got any chat contact : yahoo message , ICQ , Skype ....

[Monolith]

Actually each download is the complete working server repack. No updates needed....

Being that was becoming confusing I removed the old downloads and will only keep 2 present....being the new one...and the previous version in case new one contains issues.

I'm not big on the chat scene...you could always pm me here if you have further questions.

[Killerkev0]

Yeah monolith Do you have Any query/script to implent custom npc teleporter?? Thanks alot

[Monolith]

I have been working on that myself....for a clean non quest using npc you have to add it to a scriptdev2 core and compile it....for a kind of sloppy quest npc you can simply make quests for each teleport location...and then add them to an npc....I did that on my server.

[Killerkev0]

Yeah I wanna use the non quest npc scriptdev2 way... But I still don't understand the proceding way -.- on some website I saw about a script/scriptdev2 folder in the files but there is none in mine. I can handle C+/C++/C# So it won't be a problem Thanks for the info once again

[Monolith]

ScriptDev2 is actually a independently C++ coded project, not affiliated with Mangos source.

They have their own SVN you have to checkout and compile with the source....there are patches to add the clean NPC..I am learning it slowly...haven't had much time lately with my own server and life in general.