redigaffi

June 7, 2011

Thank you !

June 7, 2011

Very nice thanks for all.

June 3, 2011

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?

June 3, 2011

xDD i repaired it myself, thanks.

June 2, 2011

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#

June 1, 2011

Please, For linux?

June 1, 2011

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 (:

May 29, 2011

[vladimir: deleted]

May 28, 2011

Don't use deamon, use this command:

nohup ./mangosd &

and

nohup ./realmd &

I use this and works perfect

May 27, 2011

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

May 27, 2011

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

May 26, 2011

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?

May 26, 2011

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

May 26, 2011

Hi!
I have a dedicated server with i7 920 with Windows 2003 x64, but I have notice that only one core is working, as you can see in this link

http://imageshack.us/m/28/8978/coreso.jpg

Is this normal? Can I force use all cores?

Thank you!

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

May 25, 2011

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

patch -p1 < wowarmory_patch.patch

and i get returned error

root@h1750370:/var/www/vhosts/gamingfive.com/httpdocs/tools/mangos# patch -p1 < wowarmory_patch.patch
patching file src/game/AchievementMgr.cpp

Hunk #1 FAILED at 2065.

1 out of 1 hunk FAILED -- saving rejects to file src/game/AchievementMgr.cpp.rej

patching file src/game/Item.cpp

Hunk #1 FAILED at 258.

Hunk #2 FAILED at 267.

2 out of 2 hunks FAILED -- saving rejects to file src/game/Item.cpp.rej

patching file src/game/Player.cpp

Hunk #1 FAILED at 4319.

Hunk #2 FAILED at 15340.

Hunk #3 FAILED at 17306.

Hunk #4 FAILED at 22800.

4 out of 4 hunks FAILED -- saving rejects to file src/game/Player.cpp.rej

patching file src/game/Player.h

Hunk #1 FAILED at 1027.

Hunk #2 FAILED at 2251.

Hunk #3 FAILED at 2643.

3 out of 3 hunks FAILED -- saving rejects to file src/game/Player.h.rej

patching file src/game/Unit.cpp

Hunk #1 FAILED at 873.

1 out of 1 hunk FAILED -- saving rejects to file src/game/Unit.cpp.rej

May 23, 2011

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

May 23, 2011

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)

sudo apt-get update&&sudo apt-get install python-gtk2 python-glade2

SECOND STEEP

- Download the file and put it in:

<MANGOS_SOURCEFILE_DIR>/sql/updates/

THIRD STEEP

Executing the file.

WINDOWS:

Only execute the update.py file, windows will recognize it!

LINUX:

Use this command line:

python update.py

DOWLOADS:

http://www.mediafire.com/?dszdgr5g9hh1efy

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

May 22, 2011

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

May 22, 2011

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

May 22, 2011

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!

May 22, 2011

And what is so "lol" about using a wrong update file?

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

May 22, 2011

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'

May 22, 2011

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

May 22, 2011

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#

May 22, 2011

the smoothest way is to copy all files that are _bigger_ than 11489 into a temp folder, and then use
for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done

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

Sign In

Profiles

Bug Tracker

Wiki

Release Notes

Forums

Downloads

Blogs

Events

Posts posted by redigaffi

Contact Us

Repositories

Important Information