public OnGameModeInit()
{
	SetGameModeText("Apprend A script");
	mysql_debug(1); //Let's enable debugging so we can detect a problem(if there is)
    mysql = mysql_connect(host, user, db, pass); //This function will connect your server to database. Remember we have defined our host, username, database and password. It's time to use it here.
    if(mysql_errno(mysql) != 0) print(" Erreur de connexion a la BDD !"); //This will tell if your connection to database is successful or not. If it's not, check your host, username, database and password. Make sure they all right.
    
    //If we're cool, it's time to create a table for your database.
    mysql_tquery(mysql, "CREATE TABLE IF NOT EXISTS `joueurs`(\
                        `ID` int(10) NOT NULL AUTO_INCREMENT, \
                        `Username` varchar(24) NOT NULL, \
                        `Password` varchar(129) NOT NULL, \
                        `IP` varchar(16) NOT NULL, \
                        `Admin` int(10) NOT NULL, \
                        `VIP` int(10) NOT NULL, \
                        `Argent` int(10) NOT NULL, \
                        `posX` float NOT NULL, \
                        `posY` float NOT NULL, \
                        `posZ` float NOT NULL, \
			`Interieur` int(11) NOT NULL, \
			`World` int(11) NOT NULL, \
			`Skin` int(10) NOT NULL, \
			`Niveau` int(10) NOT NULL, \
                        PRIMARY KEY (`ID`))", "", "");
             return 1;
}

mysql_tquery(mysql, "CREATE TABLE IF NOT EXISTS `joueurs`( 
                        `ID` int(10) NOT NULL AUTO_INCREMENT, `Username` varchar(24) NOT NULL, `Password` varchar(129) NOT NULL, \
                        `IP` varchar(16) NOT NULL, `Admin` int(10) NOT NULL, `VIP` int(10) NOT NULL, \
                        `Argent` int(10) NOT NULL, `posX` float NOT NULL, `posY` float NOT NULL, \
                        `posZ` float NOT NULL, `Interieur` int(11) NOT NULL, `World` int(11) NOT NULL, \
                        `Skin` int(10) NOT NULL, `Niveau` int(10) NOT NULL, PRIMARY KEY (`ID`))", "", "");

new str[500];
str = "CREATE TABLE IF NOT EXISTS `joueurs`(\
`ID` int(10) NOT NULL AUTO_INCREMENT, \
`Username` varchar(24) NOT NULL, \
`Password` varchar(128) NOT NULL, \
`IP` varchar(16) NOT NULL, \
`Admin` int(10) NOT NULL, \
`VIP` int(10) NOT NULL, \
`Argent` int(10) NOT NULL,";

strcat(str,"`posX` float NOT NULL, \
`posY` float NOT NULL, \
`posZ` float NOT NULL, \
`Interieur` smallint(5) UNSIGNED NOT NULL, \
`World` smallint(5) UNSIGNED NOT NULL, \
`Skin` smallint(3) UNSIGNED NOT NULL, \
`Niveau` int(10) NOT NULL, \
PRIMARY KEY (`ID`))");

printf("CREATE TABLE LEN: %d",strlen(str));

mysql_tquery(mysql, str, "", "");