yu_raider

I also have a crash when my sql server is overloaded.

Then maybe to use mana fileds in db, just handle them as energy for vehicles. Vehicles don't need mana, right?

Just a brief question: how to setup damage to e.g. cannon? It shoots, but no damage.

Gr8, so few more tweaks and it is ready for the official commit

@Wowka321

I don't think that crash is produced because of this patch, 0.14 mangos is a bit unstable and there are many client and server craches for now. Especially in areas like Wintergrasp, Naxx and others...

Thank you

VC7 was recently removed, so I can't merge with my files for some reason. Gig, can you update your repo or give me a clue how to merge it please.

I've tested with vmaps off and no patches applied to the core, and grids DO get unloaded. I will test with vmaps on tomorrow.

It looks that the problem comes from this line under src/realmd/AuthSocket.cpp:

result = dbRealmServer.PQuery( "SELECT gmlevel, numchars FROM realmcharacters WHERE realmid = '%d' AND acctid='%u'", i->second.m_ID, id);

Since it is located under for cycle, it seems that i takes a wrong realm id value and therefore gm rights are randomly selected from one of the realms.

Vlad, this patch of yours won't work as it should. I've setup 2 realms to test and both realms take gm rights from the same realm. Sometimes they take gm rights from realm 1, sometimes from realm 2. Looks like there is a problem with resolving realmid. And some commands like .pinfo do not work.

git diff > filename.patch would create patch for already existing files, but will not add newly created ones if they exist, right?

Yes, client lag confirmed. For me it also takes about 20-30 sec for character, objects, mobs to spawn upon login. Until they are spawned I can move around seeing only my shadow on the floor lol.

I also have the similar problem. I have 2 realms on the same computer with 2GB ram running Ubuntu server 9.04. Server is only for me and my friends, there are never more then 10 players online, so don't mind the configuration. Anyway when realms are started at the beginning they take about 400-500 MB (with vmaps on and grid unload on). As the time goes by both realms grow in memory untill both take about 1GB (1 can be 700MB, other one 1400MB it doesn't matter, the point is they fill out the memory), then one realm dies, and if the restarter is turned off other one continues to grow until he takes about 2GB of memory, then it dies too. I've noticed that sometimes it take more than a day for both realms to fill up the memory and crash, sometimes they crash 2 times per day with same number of players online. I am now using rev 7721, but it happened before too.

Ok thank you

Haven't tested the AH Bot but there is a conflict with this and the AV patch.

Do you know where exactly conflict is, so we can try to resolve it?