IL2ClodCommander Update

[D_F_C]

Great,
will test it asap

many THX for sharing it

[wildwillie]

Just a few comments about This release:

There is one known issue that I have not been able to fix yet and it relates to saving info to the database. The MySQL connector for C# does not allow multiple database readers (Unlike the Java version) and you will sometimes get a MySQL Exception in the log file. IL2ClodCommander will keep running, but some stats data is lost. If anyone knows of a setting in MySQL connector to allow multiple connections that would be great, otherwise the Database section will need to be re-written so statements are done serially.


There are two tables (gameOjbects, & gameMultiObjects) which hold info about objects used as targets, planes, etc. There are some entries in there already, and the program will try and automatically add objects that are not found and show up in the stats, but you should check the log file if you are getting an Object not found message. You will manually need to enter MultiGameObject, I hope to have it auto-create these for Custom-chiefs, but it is not done yet.

WildWillie

[_79_dev]

thats the result I`am getting for the moment:

PHP Code:

************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.4.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
File name: 'MySql.Data, Version=6.4.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
   at IL2CloDCommander.Form1.buttonDBConnection_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. 


Old IL2commander still works though on new database... any idea about this error???

[_79_dev]

Ok got this one sorted. Was missing Data folder and MySql.dll in main catalog there....

[wildwillie]

Oops -

Forgot the MySQL.Data.Dll in the download. thanks for pointing that out _79_Dev.

All - You can re-download from below, or just copy the Mysql.data.dll file from the previous download. The file needs to be placed with the IL2ClodCommander.exe file
WildWillie

[melasuda]

Hi, wildwillie

I have a problem.

When launch missión, apears this message.

Blue completed their planes objectives....., and the mission restarts automaticaly.

This mission works well on the first beta of the cod comander.

I'm thinking, my problem is on Triggers air spaw wroup. Is this possible?.

Thank you very much.

[_79_dev]

You have to set up victory conditions. Simply add your map and in missions section, then edit it before You launch server. I got options set for 50 planes and 50 pilots for each side. Works fine...

[_79_dev]

Originally Posted by wildwillie

Just a few comments about This release:

There is one known issue that I have not been able to fix yet and it relates to saving info to the database. The MySQL connector for C# does not allow multiple database readers (Unlike the Java version) and you will sometimes get a MySQL Exception in the log file. IL2ClodCommander will keep running, but some stats data is lost. If anyone knows of a setting in MySQL connector to allow multiple connections that would be great, otherwise the Database section will need to be re-written so statements are done serially.



WildWillie

@I see you're using a DataReader. You can only have 1 DataReader open at a time per connection. using blocks come in handy for those:

using( var reader = myCommand.ExecuteReader() ) {
while (reader.Read()) {
// get values, do stuff
}
}// reader gets closed

You only hint at it in the code in your question (currently), but it's possible that is part of your problem. You haven't shown how you're using the DataReader, so I'm not certain. Just a possibility.@