<?php
$cmd=$_GET['cmd'];
$id=$_GET['sec'];
$key=$_GET['key'];
$val=$_GET['val'];

$mysqldb=$_GET['db'];
$mysqltable=$_GET['tb'];
$ret=1;
$nom=$_GET['nom'];
$admin=$_GET['createur'];
$joueur=$_GET['joueur'];
$max=$_GET['max'];
$carte=$_GET['carte'];
$niveau=$_GET['niveau'];
$ip=$_GET['ip'];
$chat=$_GET['chat'];
$ban=$_GET['ban'];
// Make a MySQL Connection
$link=mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db($mysqldb,$link) or die(mysql_error());

// Create a MySQL table in the selected database
//$mysqltable! id,ip,var,val
$sql = "
CREATE TABLE IF NOT EXISTS ".$mysqltable." (
  `id` int(11) NOT NULL auto_increment,
  `nom` text,
  `createur` text,
  `joueur` smallint(20) default NULL,
  `max` smallint(20) default NULL,
  `carte` text,
  `niveau` smallint(20) default NULL,
  `ip` text,
  `chat` longtext,
  `ban` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
";
mysql_query($sql);

//la creation
if ($cmd==c){
$id=mysql_query("SELECT id FROM ".$mysqltable." ORDER BY id LIMIT 1");
$idfinal=$id;
mysql_query("INSERT INTO ".$mysqltable." VALUES('".$idfinal."','".$nom."','".$admin."','".$joueur."','".$max."','".$carte."','".$niveau."','".$ip."','".$chat."','".$ban."')")
or die(mysql_error()); 
echo $idfinal;
}
//Avoir le id le plus haut
if ($cmd==i){
$id=mysql_query("SELECT id FROM ".$mysqltable." ORDER BY id LIMIT 1");
echo $id;
}
//Mise a jour
if ($cmd==w){
mysql_query("UPDATE ".$mysqltable." SET
'".$key."'='".$val."' ")
or die(mysql_error()); 
echo '1';
}
// la supréssion
if ($cmd==d){
mysql_query("DELETE FROM ".$mysqltable." WHERE id='".$id."'")
or die(mysql_error()); 
echo '1';
}
//selection toutes
if ($cmd==r){
   
// Retrieve all the data from the "$mysqltable" table
$result = mysql_query("SELECT * FROM ".$mysqltable." WHERE id='".$id."' ")
or die(mysql_error()); 
   
// store the record of the table into $row
$row = mysql_fetch_array( $result );
// Print out the contents of the entry

echo "!ID!".$row['id']."!NOM!".$row['nom']."!CREATEUR!".$row['createur']."!JOUEUR!".$row['joueur']."!MAX!".$row['max']."!CARTE!".$row['carte']."!NIVEAU!".$row['niveau']."!IP!".$row['ip']."!CHAT!".$row['chat']."!BAN!".$row['ban']."";
}
//selection une seule
if ($cmd==rs){
   
// Retrieve all the data from the "$mysqltable" table
$result = mysql_query("SELECT ".$key." FROM ".$mysqltable." WHERE id='".$id."' ")
or die(mysql_error()); 
   
// store the record of the table into $row
$row = mysql_fetch_array( $result );
// Print out the contents of the entry

echo $row["'".$key."'"];
}

mysql_close()
?>

//Créer un partie et renvoie le od
src=NetRead('http://localhost/save.php?db=cbnaonline&tb=test&cmd=c&nom=caca&createur=cbna&joueur=2&max=2&carte=cbnaland&niveau=2&ip=2.2.2.2&chat=!Bienvenue&ban=0','5000')

//Ravoir toutes les donners
NetRead('http://localhost/save.php?db=cbnaonline&tb=test&cmd=r&sec=1','5000')

if (password <> "") { ... }