server_userlist.php

<?php
/*
Tombola
Il classico gioco natalizio online.

Copyright (C) 2020  Vincenzo Padula

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <https://www.gnu.org/licenses/>.
*/

include("connect.php");

if(isset($idserver)) {

  // Ho un server valido?
  $query = mysqli_query($dbh, "select * from ".PREFIX."server where idserver = '$idserver' and accessibile = 1;");

  if(mysqli_num_rows($query) == 1) {

    $risposta = array(
      "cartelleLibere" => 48,
      "connessi" => 0,
      "utente" => array());

    $query = "select u.nick, a.idcartella from ".PREFIX."utente u left join ".PREFIX."avere a on a.idutente = u.idutente where u.idserver = $idserver and u.uscito is null and u.privato is null";

    $ris = mysqli_query($dbh, $query);

    $risposta["connessi"] = mysqli_num_rows($ris);

    for($i = 0; $i < $risposta["connessi"]; $i++) {
      $cicle = mysqli_fetch_array($ris);
      $nick = $cicle['nick'];
      $cartella = $cicle['idcartella'];

      $risposta["utente"][$i]["nick"] = $nick;
      if($cartella != null) {
        $risposta["utente"][$i]["cartella"] = $cartella;
        $risposta["cartelleLibere"] = $risposta["cartelleLibere"] - 1;
      } else {
        $risposta["utente"][$i]["cartella"] = "-";
      }
    }

    echo urlencode(json_encode($risposta));
  }
}

mysqli_close($dbh);
?>