Diablox

if( $val["extra_flags"]%2)
   $chars["gmState"] = true;

But this will give notices in php

Stop mysql server change that setting and then delete ib_logfile0 and ib_logfile1 from mysql data folder. It should work

Let it run for a while. If it runs go with this. When mysql starts to act slow then go to your config and start changing. Only thing i can point out is innodb settings

innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=128M
innodb_log_file_size=128M
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1

But i think that DB for 600 testers online is a little bigger then 1gb.

When you recompile your mangos you need to check all 3 databases for updates ( or start mangos and he will check it for you ).

tnx , btw did any one know some web account manager? where the ppl can log in and change his expan,password, etc i found one project hungarian but its for TC http://wam.nwhost.hu/?p=55

I wanted to create a simple website for MaNGOS but im very stupid when it comes to design. If someone could work out some cool design i can work on php part and create small cms for mangos

Characters.sql should be always at latest reversion but sometimes devs forget to update it . Since you are starting with mangos my advice is to compile the latest version and then try to run mangos and it will tell you what you need to apply from updates folder if there is any to apply (just read slowly). Another way is to take a look at characters DB character_db_version table where you will see what was the latest sql update file imported in your char db. Just start importing every file after that. And one more thing http://github.com/mangos/mangos/blob/master/sql/updates/README for more info

Try .gm chat on

I think he is asking where did you get the formula !?

Only thing you need on your SSD is mysql data folder.

Maybe we need it to be both. This patch can certainly find a use outside of instances, so it should be both guid and entry. What about positive value for entry and negative for guid (or positive = guid and negative = entry)?

Just a thought.

That query only gets number of aly online. You need another one for horde. And you have double echo $total.

<?
require_once ( 'config.php');
$conn = mysql_connect($host, $user, $pass) or die('Connection failed: ' . mysql_error());

mysql_select_db($mangoscharacters, $conn) or die('Select DB failed: ' . mysql_error());

$query = mysql_query('SELECT race FROM characters WHERE online = 1 ');
$horde = 0; $aly = 0;
while($data = mysql_fetch_array($query))
{
   if(in_array($data['race'], array(1, 3, 4, 7, 11)))
       $aly ++;
   else
       $horde ++;
}
echo 'Horde Online: '.$horde.' Aliance Online: '.$aly;
?>

Is it just me or words Server and user friendly don't go together.

Maybe this can help

http://udbwiki.webhop.net/index.php/Item_template#AllowableClass

I always thought I could run realmd on another machine with a separate database.

Isn't that separate db caled realmd db ?

Everything after connected is handled by mangosd and i think your answer are session_key, v, s rows in account table. Or i was wrong all this time

Here is SQL if you need it. It will extend auction time for 2 weeks.

UPDATE `auctionhouse` SET `time` = `time` + 172800;

My players are sure it is happening when you received a heal and deadly blow in the same moment. I was unable to reproduce but i just think i was unlucky with matching those two.

Anyway i can confirm this bug

FunkyBit i can't understand why do you need 2 new tables with so many fields. Can you put some light on that idea if you want?

thx

.ban ftw

There is no good anticheat for mangos. They all just do more harm then good.

I found out the answer to first question. From heidisql.com HeidiSQL - a free MySQL front-end.

/on topic

I think ghalan is trying to connect to remote MySQL server. Did you check is your user allowed to connect from remote hosts ?

Why is Linux better then windows server

Because the people who make Linux wants to make high-quality stable and secure OS for free, while MS just wants to earn money.

realmd DB account_banned table

Divide GM commands in groups. Give each group a unique id in this order 1, 2, 4, 8, 16... and then just add sum of all group id's you want to give to one account in account table. You can easily add more command groups and even make commands repeat in some groups.

What are you using to compile?

Even reloading a single NPC in some cases can lead to same problems. For example if NPC is spawned on many places and some players interact with them while you reload that single NPC.