Diablox

You are just usign clean db. Ok since it is your first serve just run characters.sql from sql folder

LoL i just noticed required_7644_01_characters_character_pet. How old is your DB? Anyway start in sql/updates/0.13 folder from 7802_01_characters_character_achievement.sql and execute every file that has characters in file name. Then move to 0.14 and 0.15 folder doing exactly same thing. And after 0.15 run all charaters updates from sql/updates al the way to 9767_03_characters_characters

OMFG It's the same thing like with mangos but instead of using XXXX_YY_mangos_something.sql you use XXXX_YY_characters_something.sql

Why do you go back with updates. If it says `db_version` have field `required_9704_01_mangos_achievement_reward` then you need to apply the next update witch is 9710_01_mangos_command.sql and next 9716_01_mangos_npc_vendor.sql and next 9716_02_mangos_mangos_string.sql all the way to ERROR: Unknown column 'required_9794_02_mangos_command' in 'field list'. I cant understand that so much people failed to understand this very simple thing.

Look at mangosd.conf SOAP.Enabled = 0 SOAP.IP = 127.0.0.1 SOAP.Port = 7878

MaNGOS now has SOAP and it will only return output from commands but you cant use all commands via console

Why not just to git revert [commit] EDIT: Sorry didnt see last post

I can confirm this even with mangos vmaps but just on the first start with fresh vmaps idk why.

Run this on your characters db UPDATE `characters` SET `level` = '80' WHERE `level` = '255';

shutdown the server Set the rate back to Rate.Talent = 1 and then run this query on characters DB UPDATE `characters` SET `at_login` = `at_login` + 4; Start the server and everyone's talents should be reset and set to 71. I think it should do the trick

I can help with 2

If it is not compiled in 64bit then mangos cannot allocate more then 4gb of memory. You need to start compiling in 64 bit

Since no one else wants to do it here is my github repo with ahbot http://github.com/Alex-V/mangos/tree/ahbot

You must set ChanceOrQuestChance to 100% in reference_loot_template if you want always 2 items to drop

Maybe because it is one year old (or 7 in dog years).

Very simple. If you can compile it on your computer then you can run it there.

I'm guessing but i think it's in PlayerbotAI.cpp

Your not doing anything wrong. His ahbot and broadcaster are in conflict with clean mangos

From http://php.net/manual/en/function.mysql-insert-id.php

That is not the best way to send mail. Insert mail is done this way mysql_query('INSERT INTO mail_external (`receiver`, `subject`, `message`, `money`) VALUES ('.$reciver_guid.', "'.$subject.'", "'.$message.'", '.$money.')')or die(mysql_error()); $mail_id = mysql_insert_id(); mysql_query('INSERT INTO mail_external_items (`mail_id`, `item`, `count`) VALUES ('.$mail_id.', '.$item_id.', '.$count.')')or die(mysql_error());

mangosd.conf # LogTimestamp # Logfile with timestamp of server start in name # Default: 0 - no timestamp in name # 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext

It is a bug with the client not with the server.

I do not see how this is a bug. You can only have 3 gems

There is a third way. I for example do not care if players interact only with one NPC. Only thing i care about is the quest itself working as it should (aside from the fact that you can talk to one NPC instead of 5 and still complete the quest).

Try apt-get update and then apt-get install mysql-server-5.1