Jump to content

Trader Change Tool


MuhKuh

Recommended Posts

Hi, thanks for this great utility, it is exactly what i was looking for..

BUT..

I can't make it works.. its really confusing, i'm pretty sure that i filled all form fields correct, so login data should be ok.

Also, im hosted by Vilayer and i have no problem to connect to my database trough f.e. HeidiSQL, so external connection to database is IMHO not problem.. 

If i try to connect to the database with same login data as i have in HeidiSQL, Trader Editor shows me this:

MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at TraderEditor.DatabaseConnector.getTraders(String instance)

Here is screenshot of my database & trader editor together just for control that i don't mess up something..

https://www.dropbox.com/s/epweo6c8pp781ey/Screenshot%202014-03-14%2014.06.45.png

 

I have Epoch ver. 1.0.4.2 and map Chernarus

 

Can you help me please? Thank you..

Link to comment
Share on other sites

Are you sure all parameters are coorect ?

 

- the port is not the standard one, may its 3306 ?

- take care fore case sentitivity, may "Root" have to be "root" ?

- try to create another identity instead of root, in my case I had some kind of problem.

- are you using encryption in HeidiSQL?

 

Good luck.

Link to comment
Share on other sites

Tkanks for reply..

yes, i'm pretty sure that i filled correct host, password, port, database name and user name.. (because it works in HeidiSQL and Vilayer reports me that login data).

Unfortunetly, i don't know how to create another identity under Vilayer hosting :( I'll try to contact them if is it possible..)

And not, I dont use encryption in Heidi SQL...

 

Maybe is some problem on my server side by Vilayer.. I really don't know..

Link to comment
Share on other sites

Thanks for the nice tool!

I can get this to work just fine with my localhost server (Cherno with instance 17, not 11, some patches ago there was a revision of trader handling, but I haven't understood the whys or whats).

 

Trying to connect to our Vilayer DBs, however, does not work (the same error messages as shown by 2 people in the previous posts) even though I use the same connection parameters as in my working phpMyAdmin config.inc.php....

 

There seems to be a thing 'password hashing' that is mysql version dependent?....

Link to comment
Share on other sites

  • 2 months later...
  • 4 weeks later...

Where does it pull the currency types from? Is that hard coded into the program, or from a list somewhere?

 

Lots of servers have additional currency options, such as Topaz, Emerald, Ruby....So, if I add that to my my server, will they become selectable in the list?

Link to comment
Share on other sites

  • 4 weeks later...
  • 2 weeks later...

Help, I can see the trader and the categories, but I can't see the items... I am 100 procent sure the settings are right, and I even rewrote the database once to see if that makes any difference... It does not. Help? :P

Link to comment
Share on other sites

 

 

I am wondering if this is intended or not; maybe vbAWOL will see this and chime in (or maybe someone else knows). It appears (I think I am looking at this right) the Epoch Chernarus 11 (the one I am using) is using the TID's of Epoch Chernarus 17. I put in the instance ID of 17 in the Trader Config Tool and all is well with the world.

 

Epoch Chernarus 11 server_traders.sqf (GITHUB)

// Aircraft Dealer
menu_Soldier_Sniper_PMC = [
	[["Airplanes",517],["Helicopter Unarmed",519]],
	[],
	"neutral"
];

Epoch Chernarus 17 server_traders.sqf (GITHUB)

 

// Aircraft Dealer
menu_Soldier_Sniper_PMC = [
	[["Airplanes",517],["Helicopter Unarmed",519]],
	[],
	"neutral"
];

Weird, same for me. I suggest anyone else having probs with empty menus tries instance 17 and edit away....lol

Link to comment
Share on other sites

I coded some new application because I couldn't find a (good) non web based one :)

 

All you need:

- MYSQL login data

- instance number (found in table Server_TRADERS)

 

 

Suggestions and bugs to [email protected].

 

 

https://www.dropbox.com/sh/nxf0l24lgaaqbdh/60beSYJqAD

 

 

uvb5cah6wuaa.png

Nice work dude! Works a charm, once I got my head round actually using instance 17...lol

Link to comment
Share on other sites

  • 7 months later...
  • 6 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...