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

you can just do 'git apply -R' (or was it -r ?) to do it the 'reverse' way. so update, then extract the commit as a patch ('git show [commit] > my.diff') and then reverse-apply the created diff.

-- DasBlub

Why not just to

git revert [commit]

EDIT: Sorry didnt see last post

Weird problem, first time I started the server I was unable to walk through some doorways. I restarted server (but didn't restart client, just disconnected) and it works fine now. I can't seem to reproduce it.

Anyone else have this problem?

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 am pretty impressed. I might actually help out now, but I can't officially support whatever Lua engine work I do for 2 reasons:

1 - I am very busy with other work right now.

2 - I really can't deal with all the "doesnt compil plz fixxx!!111" that patch authors seem to get.

But that aside, I might definitely contribute some stuff to help you guys get started.

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

Retrieves the ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).

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

Bumps, i have a quesiton with the last patch, in my script PhP how have the good id mail_external with the good mail_id mail_external_items ?

I make this bur it's not good because the mail_id it's always = 0 >< ...

mysql_query("INSERT INTO mail_external (`id`, `receiver`, `subject`, `message`, `money`) VALUES
('', $guid, 'Items', 'Thanks for your items', 0)");

$mail_id_num = mysql_query("SELECT id FROM mail_external WHERE receiver='$guid'") or die("ERREUR SQL!!");    

mysql_query("INSERT INTO mail_external_items (`id`, `mail_id`, `item`, `count`) VALUES
('', '$mail_id_num', 29434, 10)");

Thanks if you can help

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

While some admins might like this idea as being more "hardcore" than retail, I see Patman's point. Why does the core need modifying to support this behavior when proper scripting could achieve the same effect?

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