IL2ClodCommander Update

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

[D_F_C]

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.