Server Editor

[Shursan]

hi all,

a lots of functions have been updated in the program.

Now in and working:

Area Editor
BattleGround Editor
Craft Editor
Faction Editor
OTD Editor
NPCTemplate Editor
Region Editor
Spell Editor
Style Editor
Zone Editor

Mass Mob Editor

[Graveen]

Excellent, thank you !

[Wolfe]

Hi all,

I am trying to get the editor running, but I don't get a database connection. I've donwloaded the project from svn, installed mysql-connector to build the tool and changed the port (I'm not using port 3306) in the source code before.

Sadly I receive the error message "Unable to connect to any of the specified MySQL hosts.". The connection to the database with HeidiSQL is working.

Any ideas what I'm doing wrong?

Best regards
Wolfe

PS: I tried the install version (1.41) with a field to enter the port within the settings, too. Same problem...

[Shursan]

this version don't take advantage of the Port Number parameter. That's why i have removed them for now.

I need to work on it soon.

[Shursan]

Ok this is done, i have commited the new version with port number.

[Belthax]

Dunno if im doing something wrong but im getting a ton of MySql errors when trying to Build Solution.

Might be becouse of a missing referance to MySql.Data

[Wolfe]

@ Ysia: It's working now, thanks alot!

@ Belthax: I've had the same error and installed the mysql-connector: http://dev.mysql.com/downloads/connector/net/
(just click "No thanks, just start my download!" below the registration window, you don't need to register).
Then I was able to compile.

[Belthax]

Thanks Wolfe that did the trick.

I am getting an error though when trying to connect to MySQL

Error unable to connect to any of the specified MySQL hosts.

Im guessing it has something to do with me using a port that isnt the default one.

I get a green light when testing the connection but after that no connection.

[Wolfe]

You are right, some functions do not work due to another port.
I have the same problem when trying to create a new NPC template for example. It seems to be that the port entered in the settings is not used, so the error "no connection" occurs again.

[Shursan]

hmmmm ... did you have checked Origins Server Database in Preferences ? if yes, uncheck it. That's just a settings for my server and can throw somes errors because you don't have have some sql table.columun specific to my server.

[Wolfe]

It's already unchecked... selecting "Add new style" doesn't result in a crash, but the other "Add new..." button are not working. I'm getting "MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.[...]".

[Shursan]

ok i have find a bug in style editor,modified and commited. Now working as intended.

[Shursan]

Dol Server Editor Update

Added First write of Mob Editor. (Need to work on data validation)
Modified Faction Editor for update a combobox value.
Modified MobsModelChoice for work with npctemplate and mob. (mob can't have multiple model value)

Actived Mass Editor Update database button.

[Graveen]

Thx mate !

[Shursan]

You are right, some functions do not work due to another port.
I have the same problem when trying to create a new NPC template for example. It seems to be that the port entered in the settings is not used, so the error "no connection" occurs again.

Now Solved with rev 3161.