code

$query = "CREATE TABLE IF NOT EXISTS team (

userID BIGINT(20) NOT NULL ,

nome VARCHAR(100) NOT NULL);";

$connessione->query($query);

$query = "CREATE TABLE IF NOT EXISTS utenti (

userID BIGINT(20) NOT NULL ,

username VARCHAR(100) NOT NULL,

nome VARCHAR(100) NOT NULL,

teamID VARCHAR(20) NOT NULL);";

$connessione->query($query);

if(stripos($cmd, 'leaveteam')===0)

{

 $a = $connessione->prepare('SELECT * FROM utenti WHERE userID = ?');

 $a->execute([$userID]);

 while($info = $a->fetch(PDO::FETCH_ASSOC))

 {

 $nomedb = $info['nome'];

 $usernamedb = $info['username'];

 $userIDdb = $info['userID'];

 $teamIDdb = $info['teamID'];

 }

if($teamIDdb)

{

 $af = $connessione->prepare('SELECT * FROM team WHERE userID = ?');

 $af->execute([$teamIDdb]);

 while($b = $af->fetch(PDO::FETCH_ASSOC))

 {

 $bla = $b['userID'];

 $nometeamdb = $b['nome'];

 }

if($bla == $userID)

{

 $e = $connessione->prepare("DELETE FROM team WHERE userID = ?");

 $e->execute([$userID]);

 $e = $connessione->prepare("UPDATE utenti SET teamID = ? WHERE userID = $userID");

 $e->execute(['']);

 $zz = $connessione->prepare('SELECT * FROM utenti WHERE teamID = ?');

 $idk = $zz->execute([$teamIDdb]);

 foreach($zz->fetch_all(PDO::FETCH_ASSOC) as $user){

 $connessione->prepare("UPDATE utenti SET teamID = '' WHERE UserID = ?");

  $ehe->execute([$teamIDdb]);

 }

 sm($chat_id, "<a href='tg://user?id=$userID'>$nome</> hai eliminato il team -> $nometeamdb");

} else {

 $e = $connessione->prepare("UPDATE utenti SET teamID = ? WHERE userID = $userID");

 $e->execute(['']);

 sm($chat_id, "<a href='tg://user?id=$userID'>$nome</> hai abbandonato il team -> $nometeamdb");

}

} else {

 sm($chat_id, "<a href='tg://user?id=$userID'>$nome</> non sei in nessun team.");

}

}