TuX

Guys maybe you should talk to xfurry before start writing.

He mentioned yesterday that he wants to extend the EventAI Tool to support those stuff

GreeZ

ZuSe

PS: stfx if he writes it in C#/Mono it should also work on every OS, though Java might be the better choice.. for PHP you would need a wwwserver

Allright,

first of all thanks for your help, it just came a little bit to late, i ve already find out myself how the data field is build, even the difference beetween containers and items.

My personal view is to drop the field and seperate the data, as it is done with trinity db.

Ofc it is faster to load one blob instead of 14 columns, but thats no argument. The DMS isnt the bottleneck at all, therefore its easier to deal with separeted data in corescripts.

would be nice if someone could split the data

Hello guys,

i just need some help. I started writing a db-converter from TDB to mangos (YTDB).

It works, so i get no errors or other stuff, you can also login successfully to the mangos-realmd and load your characters, but they wont have any item in the inventory.

I also took a look into the character_inventory after login with one of the converted chars.... all entries of this char are deleted, but i don't know why.

At my first try he delete the whole character_inventory table when i started the mangosd.exe, but this was because i forget to convert the item_instance table.

This leads to my general question of this post.

Is there an up to date description of the data field in item_instance? I guess that he didn't convert this table as it should be done.

This is trinity's one

This mango's one

as you see in TDB there is an extra column for each data, in mangos i have to create the data text my own, but todays database is a bit different from the entry in the wiki, so it would be awesome if someone can tell me how the data-field is made up.

Just one example from a the data-field of an item which was created by the core

2 1191182336 3 1396 1065353216 0 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 25 0 0 

What is the second value? (119....)

I really hope someone has a clue how to solve this problem

GreeZ

TuX

Do you have to use unix_sockets with Postgres? Is there a way to tell the realmd binary that I"m using postgres, because it's just hanging when connecting to the database. Thanks

edit:

Found what I was looking for in the mangos conf file, I think the same should be reflected in the realmd conf

#        Database connection settings for the world server.
#        Default:
#                ---MYSQL---
#                    hostname;port;username;password;database
#                    .;somenumber;username;password;database - use named pipes at Windows
#                        Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
#                    .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
#                ---PGSQL---
#                    hostname;port;username;password;database
#                    .;/path/to/unix_socket/DIRECTORY or . for default path;username;password;database - use Unix sockets at Unix/Linux

I changed it to the correct settings

127.0.0.1:5432:postgres:mangos:realmd

still hanging...weird

I have the same problem.

Core runs under windows 64bit

Postgre-Server 9.0.3 under Ubuntu 64bit.

GreeZ

TuX

PS: i have excuted postgre-compatibilty_addon.sql

I guess u forgot to patch the core.

There has to be some extra-columns in the char-db, without them you will get your error

GreeZ

TuX

Trinity patch doesent work with newest core

#:~/TrinityServer/trinitycore$ git apply --check /media/fritzbox/Netzwerkordner/Trinity_Mangos_Armory/wowarmory/tools/trinity_core/wowarmory_arena_chart.patch

error: patch failed: src/server/game/Battlegrounds/Battleground.h:208
error: src/server/game/Battlegrounds/Battleground.h: patch does not apply

wowarmory_patch.patch works fine

Does anyone know a solution?

GreeZ

TuX

Seems like the two tc-patches do not work with rev 10695

GreeZ

TuX