redigaffi

Thank you !

Very nice thanks for all.

in the linux guide of contnt dbs is this: cd ~ && mkdir udb && cd udb svn co https://unifieddb.svn.sourceforge.net/svnroot/unifieddb unifiedd but svn co is outdated also where can i get tne newest version?

xDD i repaired it myself, thanks.

I followe ALL EXACTLY PERFECTLY IN THE WIKI GUIDE: http://getmangos.eu/wiki/Compile_MaNGOS_On_Linux I USED THIS COMMAND: cmake ../ -DPREFIX=/opt/mangos -DPCH=1 -DACE_USE_EXTERNAL=0 -DDEBUG=0 -DTBB_USE_EXTERNAL=0 AND GET: Linking CXX static library libgsoap.a [ 7%] Built target gsoap Scanning dependencies of target mangosscript [ 7%] Building CXX object src/bindings/ScriptDev2/CMakeFiles/mangosscript.dir/include/sc_grid_searchers.cpp.o In file included from /root/mangos/src/game/CreatureAI.h:25, from /root/mangos/src/bindings/ScriptDev2/include/sc_creature.h:8, from /root/mangos/src/bindings/ScriptDev2/include/precompiled.h:9, from /root/mangos/src/bindings/ScriptDev2/include/sc_grid_searchers.cpp:5: /root/mangos/src/framework/Dynamic/ObjectRegistry.h: In member function âbool ObjectRegistry<T, Key>::InsertItem(T*, Key, bool)â: /root/mangos/src/framework/Dynamic/ObjectRegistry.h:51: error: expected primary-expression before â)â token make[2]: *** [src/bindings/ScriptDev2/CMakeFiles/mangosscript.dir/include/sc_grid_searchers.cpp.o] Error 1 make[1]: *** [src/bindings/ScriptDev2/CMakeFiles/mangosscript.dir/all] Error 2 make: *** [all] Error 2 root@h1750370:~/mangos/build#

Please, For linux?

Maybe you must look in the realmd database in table realms - (or a name like this), and the nyou will see a lot of things to edit, name, and IP. This ip can't be localhost, it must be your public ip (:

[vladimir: deleted]

Don't use deamon, use this command: nohup ./mangosd & and nohup ./realmd & I use this and works perfect

Must i copy the patch file to the mangos source file dir?

[vladimir: at forum forbidden compare DB projects for avoid flame wars.]

I think im udb db user, i used this code: cd ~/udb/trunk/Full_DB unzip *.zip mysql -u mangos -pmangos mangos < ./<file_you_just_unzipped>.sql mysql -u mangos -pmangos mangos < ~/acid/sd2-acid/trunk/wotlk/<highest-number>/<highest-number>_acid.sql mysql -u mangos -pmangos mangos < ~/mangos/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql also from: http://getmangos.eu/wiki/Compile_MaNGOS_On_Ubuntu#World_Database i think this is udb? and where can i look?

Also, where can i get translations for my content database, i wanna one in spanish!?

I really recommend you to use Linux, and use option in compiling steep, serveral cores

also i'm in steep whn i must patch some cpp files to my mangos server, also i execute this: and i get returned error

i dont know why you are in trouble, 1% is nothing

Hello, i gonna show you how to update the database with a little application that i found on the wiki: Compiling MangOS On Ubuntu, But the problem is, it doesn't explain it right, and doesn't have a download link. The problem of updating is there are a lot of SQL patches, and one per one is very hard and bored.. Also, read: AUTOR: redigaffi PYTHON SCRIPT CREATOR: Not me, anyone in the wiki. DIFFICULTY: Easy - Normal FIRST STEEP - All what you need is to have python installed on your server, also i gonna show you how to install it in both platforms: Windows: Go to http://www.python.org/download/ and select the most recent release, download & install. LINUX: Open Console and copy: (Code by ubuntuForums) SECOND STEEP - Download the file and put it in: THIRD STEEP Executing the file. WINDOWS: Only execute the update.py file, windows will recognize it! LINUX: Use this command line: DOWLOADS: NOTE: This is only for users who has default database acces, also i mean the user of database mangos and password mangos, if you have another details you can give me the details and i edit it for you. SOURCE CODE: #!/usr/bin/env python import glob, os patches = glob.glob('*.sql') patches = sorted(patches) for x in patches: db = x.split("_")[2].replace('.sql', '') os.system("mysql -u mangos -pmangos -v " + db + " < " + x) Thank you all for watching, my first tutorial helping in getmangos, i received a lot of help to of all users, also thank you. I hope this is useful

i fixed it with an python script, also i gonna do a tutorial for all peopple who has the same problem!

Ok, now i get this error executing ./mangosd: oading MaNGOS strings... SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM mangos_string query ERROR: Unknown column 'content_loc8' in 'field list' [**************************************************] 100% >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue. PLease help

OK, i moved all directories to updates all, and i have a lot of sql files, now i executed: for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done Hopefully it works!

Sorry i think you doesn't understand, this are too much files to update, isn't there a command to go faste

LOL when i execute sql command: 10551_01_mangos_spell_proc_event.sql i get Line no.:1 Error Code: 1054 - Unknown column 'required_10537_01_mangos_command' in 'db_version'

yes but ins't there a command what execute all ?

i get error in your command please help :'( ERROR 1054 (42S22) at line 1: Unknown column 'required_10503_04_mangos_gameobject_respawn' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10537_01_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10551_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10582_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10604_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10621_01_mangos_quest_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10628_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10629_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10654_01_mangos_game_event_creature_quest' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10660_01_mangos_game_event_quest' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10679_01_mangos_npc_vendor_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10679_02_mangos_creature_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10682_01_mangos_item_convert' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10704_01_mangos_gossip_menu_option' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10742_01_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10743_01_mangos_spell_chain' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10743_02_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10746_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10749_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10762_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10764_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10786_01_mangos_spell_proc_item_enchant' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10786_02_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10788_01_mangos_creature_addon' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10788_02_mangos_creature_template_addon' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10835_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10863_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10864_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10867_01_mangos_npc_trainer_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10867_02_mangos_creature_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10883_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10906_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10906_02_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10932_01_mangos_game_event_creature_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10945_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10946_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10949_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10951_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10972_01_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10973_01_mangos_game_event_mail' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10988_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10989_01_mangos_loot_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10993_01_mangos_loot_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_10998_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11002_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11018_01_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11023_01_mangos_spell_threat' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11036_01_mangos_spell_threat' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11040_01_mangos_spell_chain' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11040_02_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11058_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11115_01_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11117_01_mangos_world_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11169_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11169_02_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11190_01_mangos_pool_creature_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11190_01_mangos_pool_gameobject_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11200_01_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11205_01_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11214_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11214_02_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11217_01_mangos_creature_addon' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11234_01_mangos_command' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11310_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11312_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11335_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11335_02_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11337_01_mangos_mangos_string' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11348_01_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11385_01_mangos_creature_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11433_01_mangos_item_template' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11452_01_mangos_spell_bonus_data' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11452_02_mangos_spell_proc_event' in 'db_version' ERROR 1054 (42S22) at line 1: Unknown column 'required_11453_01_mangos_spell_proc_event' in 'db_version' root@h1750370:~/mangos/sql/updates/tmp#

Bigger not, because im on: 10537_01_ and i need: 11489_01_