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