IL2ClodCommander Update

[melasuda]

thx _79_dev

[lotaria]

Thanks a lot for this, wildewillie !

[_79_dev]

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?

[wildwillie]

_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:

    	setcookie("auth", "1", 0, "/", "192.168.1.5", 0);

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 :

INSERT INTO `adminUsers` (`lastName`, `firstName`, `username`, `password`) VALUES
( 'Default', 'Administrator', 'clodadmin', password('clodadmin'));

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

[_79_dev]

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:

PHP Code:

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\ClodStats\squadPilot.php on line 62 


thats part of code for file, last line is 62

PHP Code:

 // Get Pilot ID
    $sql = "SELECT pilotID
              FROM pilots
             WHERE pilotName = '".$pilotName."' COLLATE utf8_bin";

    $getResults = mysqli_query($mysqliAdmin, $sql) or die(mysqli_error($mysqliAdmin));
    if (mysqli_num_rows($getResults) > 0)
    {
       while ($row = @mysqli_fetch_array($getResults))
       {
        $pilotID = stripslashes($row["pilotID"]);
       }
        mysqli_free_result($getResults);

        $sql = "UPDATE pilots
                   SET squadronID = $squadronID
                 WHERE pilotID= $pilotID";

        $getResults = mysqli_query($mysqliAdmin, $sql) or die(mysqli_error($mysqliAdmin));
         mysqli_free_result($getResults); 


and if I edit last line like that

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

it disconnect from database...

[wildwillie]

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

[_79_dev]

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.

[D_F_C]

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.

[5./JG27.Farber]

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

[wildwillie]

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