IL2ClodCommander Update
 

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

Thanks mate, will test it this evening...

Sounds great, thanks WW.

Great,
will test it asap

many THX for sharing it

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

thats the result I`am getting for the moment:

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

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

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

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.

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

thx _79_dev:-):-)

Thanks a lot for this, wildewillie ! :grin:

Willie I got server running for 48 hours and I got no problem at all with commander. Anyway have a couple of issues about .php fo stats page:

1: cant get through cookies authorisation in certain files, have to remove this part of code form all files to go to admin section:

if (!$_COOKIE["auth"] == "1")
{
//If not Authorized Exit
exit;
}

2: for example I want to add pilot into squad and got error in java box:

Notice: Undefined index: squadronName in C:\xampp\htdocs\ClodStats\squadPilot.php on line 80

Notice: Undefined index: pilotName in C:\xampp\htdocs\ClodStats\squadPilot.php on line 81

Select a Squadron then enter the Pilot name to Add to it


Squadron Name:
None5./JG27No Pilots to associate


How to fix it?

_79_dev -

Did you update the adminLogin2.php file to reflect your web servers IP address. This was from FBDj and I probably have not documented it in IL2ClodCommander yet.

Anyhow the section of code:
you need to change 192.168.1.5 to the IP address of your Web Server.

Also make sure that there is an entry in the adminUsers table in MySQL. There was a line in the clodstats database insert file :
Which created the default login information (UN: clodadmin PW: clodadmin)

That is all you need to do. Unless there is something on your Web Server/Web browser that is preventing cookies. I'm not the best php coder, but this whole process is to have an admin section where only select people can access.


WildWillie

still can`t get throuh cookies autorisation, IP is set and admins and users exist in database so it must be something on my side....


after adding pilot into squadron got error message:
thats part of code for file, last line is 62
and if I edit last line like that

mysqli_free_result($getResults)or die (mysql_error());

it disconnect from database...

I think that code section is broken and needs to be reviewed.

It is not too hard to just use the MySQL Workbench to set the squadrons.

Once connected you can right click on a table and select to 'Edit table data' which is easy enough to do.

Just add a new squadron in the squadron table and commit those changes.

Then select the rows from the squadron table to get the squadronId you want and edit the pilots table to set the squadronID for all pilots you want in that squadron.

WildWillie

I am not php programer my self only started to learn few weeks ago... Your database and webstats page is like learning book for me at the moment. Anyway most of theme error messages are just messages and I learned That they can be not visisible by simply turning off error reports in .php config file for web server. Code for webstats it self is maybe too old for new browsers and php version, but still works great. I can edit tables of database manually my self by using just MyPhpAdmin wich I use so there is no problem there. I was just curious about automatisation of admin options here... Ok nevermind, thanks for clearing out everything, and for all work on Commander, will try to update bugs, if any... server is running no problems so far.

Hello,

i am working to fill the object and multiobject databasetables for the Clodcommander, when i am ready i want to share it. It will have different points for the objects than the original one, but you are able to setup it by your own in the Clodcommander if you want. The object databasetable has now over 200 entries, and at the moment i fill the multiobject databasetable.

Hope it helps WildWillie a little bit.

Is there any chance the stats will record AI kill/ground targets?

Yes stats are kept for all destroyed objects and the attacker, be it AI, Player, or another Ground Object.

Look into the aiEvents table.

WildWillie

Here are the databasetables i filled with datas.

-- Attention -- Deletes the Clodstats gameobjects and multigameobjects tables and creates new tables with the new datas.
-- Attention -- Different scoring to the original datas are in the database.

Hope there are no errors in. Please test and give a little reply if it works. I tested it on my local system and it seems to run well.

Initial glance everything looks OK.

I'll check it out more later this week.

Thanks for the work

Willie

Works with no errors so far..... Thank You D_F_C

Thanks WW and DFC.

S!

got the database error for mission and plane details solved half way there...

first of all add objectiveType column into missions table in database..that fixed mission details

second: in file aircraftdetails.php change plane columns into planeName anywhere script is asking for that value from database.

still working on weapons :)

If you check it and something is missing please report here, i hope i can add it as soon as possible to the database. But at the moment i cant can tell you if some objects are missing because there are no more missing entries in the logfile of Clodcommander, so far as i saw it.

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?

I try to adjust connection to MySQL and to me gives out a mistake in attempt to make sql-request of the table clodstats Database Insert.sql
What's the problem?

chn6

Did you copy IL2ClodCommanderStats.dll to game folder ?

INSERT INTO `adminUsers` ( `lastName` , `firstName` , `username` , `password` )
VALUES (

'Default', 'Administrator', 'clodadmin', PASSWORD( 'clodadmin' )
);

answer MySQL:

#1146 - Table 'clodstats.adminusers' doesn't exist

---------------------------------------------------------------------
Insert = adminUsers

table = adminusers

if you use Linux the names must be exact the same:

Insert = adminUsers

table = adminUsers

maybee this is the problem.

No problems with installing the Database here by my side. I installed it on Win.

I cant see which database are u trying to use:

Have u got: use "your_dabase_name" at the beginning of file?

Hi first sorry for refloting the post, and for my English

this is my cuestion.

how can i set Target Area to red or blue army?.

I create oner mission, but i can not setup on Comander destroy area to red or blue.

I only can setup to destroy a create group (tjis work good), but no a multiple staticks objet to destroy

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

Nice to you to have provided the source files with the cod controller application.

And also it is nice to have choosen C# as a prefered language. You seem to choose your language based on what the game actually uses, like Java for 1946, C# for CoD, which will make life much easier for people that would like to modify your application, since it uses the same language as the mission scripts (which is very fun to learn actually).

C# is a much easier read than Java IMHO.

I try to use IL2 CLoD Commander and when i click on "Start Mission" button, i got the following message in the server terminal and the mission isn't loaded, what is wrong in my procedure ?

http://i55.servimg.com/u/f55/17/86/51/08/server11.jpg

If i use the command "missLoad missions/OnLine_Map.mis" directly in the server terminal, everthing works fine.