Diablox

I think the start locations for all races and classes are stored in the mangos.playercreateinfo table.

Yes but i do not think he can set them to AV (at least not without changing BG code).

Maybe this. But idk what is the id

setFactionForRace(factionID)

It works with those lines and it's not just a warning it is there to stop you from importing it in DB thats is not on same version as one from witch you get your pdump

Whats wrong with

UPDATE `npc_trainer` SET `spellcost` = 0;

Use the command "pdump write filename playerguid" in the console to save.

Open it with an editor and delete the first rows to the first insert line.

Then use the command "pdump load filename accountid newname newguid"

Hope this help.

Those lines are there for a good reason its not a good idea to delete them.

I think you forgot something

3. You need vmaps

I noticed this bug when i entered the game first time on 3.3 patch (before 3.3 it wasn't there).

So it will only work with vmaps turned on for northend? Btw my vmaps are now off(need to upload new version of vmaps).

* stability: does memory leak indefinitely, or the core crash more often?

Last few weeks i been switching from old to new and back to old and now i am compiling again new vmaps. About memory leak i didnt notice any. When my mangos is warmed up it is using about 2 - 2.1GB of RAM and with new vmaps it is always there (right up to the moment when i need to restart it becose instance locks wont reset) so as far as i can tell it hasn't got any leaks. If i on other hand i use old vmaps server usualy is dead before he get even close to 2GB and today i had so many crashes with old vmaps that i had to turn them off. My OS is Ubuntu 10.04 x32. Vmaps are turned on on all maps and im using clean mangos with my fork of sd2 and ah bot. And at the end about cpu and memory usage in my case has gone down 5% - 10% depending on what was my playerd doing. Botom line is it is very stable and i didnt notice any memory leaks. This is just my expirience with this project maybe someone alse did had some isues but for me it is working (and working very good). Thx for this awsome patch

EDIT: idk if this is related to this patch but i do not have this problem with clean mangos. Dalaran now is not a sanctuary. Server does not even say that you are in dalaran. Sorry if it is not related

Good idea. Like the "DO NOT MAKE A THREAD ON MANGOS PROJECT FORUMS". I hope it works with new users

@Diablox

Thanks for your help, I will try that the next thing in the morning and keep you updated

Just do not forget to do a backup

@Endon

Well your config is good for the size of your DB and number of queries per second. I once had a problem with mysql using much cpu but in my case mangos could not connect to mysql so i do not think this could help you much. Only solution was MySQL reinstall (i remove it with purge). Beside that idk what could be the problem.

@ilija

ibdata1 is file where innodb keeps all data for innodb tables or in mangos case that is the size of characters db (if you dont have any other tables that are using innodb). There is no reason to panic if it is that big. Run mysqlreport and you will se what you need to change in your config.

First of all go to /var/lib/mysql i check how big is ibdata1 to see how much memory pool you need. Then open your /etc/mysql/my.cnf and add these lines after [mysqld]

innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 32M

This is just example. Set the first value to be as bigger as you can afford (the best value is the one bigger then ibdata1). Keep in mind that you must avoid to run out of memory so be careful. Second value is recommended to bee arround 25% of innodb_buffer_pool_size.

Start with something simple. Start with mysqlreport -u username -pass (replace username with your mysq user). Check how much slow queries you have and how big your InnoDB Buffer Pool Read hit. Did you changed your mysql config?

I do not have anything disabled. Vmaps turned on on all maps and compression is on 6

I'm using Ubuntu 10.04LTS and 3.3.3 mangos using some old celeron and 3gb of ram no problems with 70 "testers" and some player bots online. Try finding out what is forcing mysql to work so hard.

@ilija

You posted your server name mysql username and password.

Didn't try it but I think this should work:

DELETE FROM corpse WHERE player = GUID;
DELETE FROM character_aura WHERE guid = GUID AND (spell = 20584 OR spell = 8326);
UPDATE characters SET health=1 WHERE guid = GUID;

Just to point out that this will only work when player is offline

Sorry i mixed up git fetch and git merge. Use git fetch origin master and then git rebase

Since you were using git merge try git rebase to check is everything where you want it to be

Sorry it took me a bit longer. Those areas in Searing Gorge now work as they should. Didn't tested WSG. I'm using MaNGOS 9856 and latest from http://github.com/Lynx3d/mangos/commits/vmap_rewrite

Did you try that commit? http://github.com/Lynx3d/mangos/commit/ca35635a767b52c99891581bd3f6bb303724d2f5

No i do not have this commit. I will try it today.

Searing gorge around X=-6682 Y=-1196 Z=241 map 0 same problem as in WSG.

i think, its unsafe, can be easy to steal account by others

Why do you think that?

libmpq, extractor, assembler can compile only in win32 and i did compile them and i can compile mangos release in win32 but it wont work in x64. This error for almost every file in tbbmalloc

6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(84) : error C4235: nonstandard extension used : '_asm' keyword not supported on this architecture
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(86) : error C2065: 'fld' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(86) : error C2146: syntax error : missing ';' before identifier 'flt'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(86) : error C2146: syntax error : missing ';' before identifier 'fistp'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(87) : error C2065: 'fistp' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(87) : error C2146: syntax error : missing ';' before identifier 'intgr'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(87) : error C2143: syntax error : missing ';' before '}'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(95) : error C4235: nonstandard extension used : '_asm' keyword not supported on this architecture
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(97) : error C2065: 'fld' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(97) : error C2146: syntax error : missing ';' before identifier 'flt'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(97) : error C2146: syntax error : missing ';' before identifier 'fistp'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(98) : error C2065: 'fistp' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(98) : error C2146: syntax error : missing ';' before identifier 'intgr'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/g3dmath.h(98) : error C2143: syntax error : missing ';' before '}'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(448) : error C4235: nonstandard extension used : '__asm' keyword not supported on this architecture
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(450) : error C2065: 'rdtsc' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(451) : error C2065: 'mov' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(451) : error C2146: syntax error : missing ';' before identifier 'timehi'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(451) : error C2065: 'edx' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(452) : error C2065: 'mov' : undeclared identifier
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(452) : error C2146: syntax error : missing ';' before identifier 'timelo'
6>c:\\Users\\Alex\\Desktop\\mangos-new\\dep\\include\\g3dlite\\G3D/System.h(452) : error C2065: 'eax' : undeclared identifier

MaNGOS release x64 wont compile on windows ( VS2008 Windows7 x64 ). Using faramir118 repo.