IL2ClodCommander Update

[wildwillie]

Attached is the update to IL2ClodCommander.

It now includes setting mission objectives by Trigger (Target Area, Specific Targets) setup in the mission as well as general Object Types (Trucks, Tanks, ships, etc)

It also has a "Auto-Start" switch to start running missions when started.

Installation and setup is the same as prior release, but you should re-create the database if you are upgrading.

Sorry it took so long for me to release this.

Also included is the source code if you need to make modifications to suite your needs.

WildWillie

[_79_dev]

Thanks mate, will test it this evening...

[5./JG27.Farber]

Sounds great, thanks WW.

[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]

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.@

[chn6]

Thx for Great work, but my il2ClodCommander can't contrl server.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
( 2012-8-15 20:23:11 ) Form1.textBoxMissionCompleteTimer_TextChanged - Mission Complete Timer changed new value: (10)
( 2012-8-15 20:23:11 ) IL2ClodCommander Started
( 2012-8-15 20:23:11 ) DBConnect.getGameObjects - Loaded (241) Game Objects
( 2012-8-15 20:23:11 ) DBConnect.getGameMultiObjects - Loaded (36) Multi Game Objects
( 2012-8-15 20:23:11 ) ServerConnection.OnConsoleDataReceived - Exception: Since a thread exit or an application request, has given up the I / O operations
( 2012-8-15 20:23:11 ) *** Mission Processor Started by User ***
( 2012-8-15 20:23:11 ) MissionController.getNextMission - Next Mission to Run: (Channel.mis)
( 2012-8-15 20:23:11 ) MissionProcessor.runMissions - Mission Cycle Index Reset to 0
( 2012-8-15 20:23:11 ) MissionProcessor.runMissions - Loading Mission (Channel.mis)
( 2012-8-15 20:23:11 ) MissionLoadController.loadMissionData - Loaded (51) Static, (0) Chiefs, & (0) Chief NPC Objects
( 2012-8-15 20:23:11 ) ***** Mission Objectives ****
( 2012-8-15 20:23:11 ) **** End Mission Objectives ****
( 2012-8-15 20:23:11 ) MissionController.startMission - Unhandled Exception: System.IO.IOException: The operation is not allowed on non-connected sockets.
at System.Net.Sockets.NetworkStream.InitNetworkStream (Socket socket, FileAccess Access)
at System.Net.Sockets.NetworkStream..ctor(Socket socket)
at IL2CloDCommander.ServerConsoleConnection.SendConso leMessage(String msg)
at IL2CloDCommander.Controller.MissionController.star tMission(MissionCycle mission)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I check everything carefully
confs.ini
IL2CloDCommanderConfig.ini
MIssion Script

and use Online_Map for testing.

My start-up order is:
1. il2cod Server
2. cmd for difficulty setting only, no mission load and start
3. il2ClodCommander

can you help me?