[Mysql] Is that too long ?
#7

Correct me if I'm wrong, but shouldn't it be the following.
pawn Код:
new str[2048];
        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, \
        `DerniereIP` varchar(16) NOT NULL, \
        `Admin` int(10) NOT NULL, \
        `VIP` int(10) NOT NULL, \
        `Argent` int(10) NOT NULL,\
        `Banque` int(10) NOT NULL, \
        `posX` float NOT NULL, \
        `posY` float NOT NULL, \
        `posZ` float NOT NULL, \
        `Interieur` smallint(5) UNSIGNED NOT NULL, \
        `World` smallint(5) UNSIGNED NOT NULL, "
;

        strcat(str,"`Skin` smallint(3) UNSIGNED NOT NULL, \
        `Niveau` int(10) NOT NULL, \
        `DateInscription` varchar(24) NOT NULL, \
        `Bannis` int(10) NOT NULL, \
        `RaisonBan` varchar(128) NOT NULL, \
        `BannisPar` varchar(24) NOT NULL, \
        `Vie` float NOT NULL, \
        `Armure` float NOT NULL, \
        `MinutesJouees` int(10) NOT NULL, \
        `HeuresJouees` int(10) NOT NULL, \
        `JoursJoues` int(10) NOT NULL, \
        `Prison` int(10) NOT NULL, \
        `TempsPrison` int(10) NOT NULL, \
        `Tues` int(10) NOT NULL, \
        `Morts int(10) NOT NULL, "
sizeof(str));
       
        strcat(str,"`Arme1` int(10) NOT NULL, \
        `Munition1` int(10) NOT NULL, \
        `Arme2` int(10) NOT NULL, \
        `Munition2` int(10) NOT NULL, \
        `Arme3` int(10) NOT NULL, \
        `Munition3` int(10) NOT NULL, \
        `Arme4` int(10) NOT NULL, \
        `Munition4` int(10) NOT NULL, \
        PRIMARY KEY (`ID`))"
, sizeof(str));
       
        mysql_tquery(mysql, str, "", "");
Reply


Messages In This Thread
[Mysql] Is that too long ? - by anou1 - 21.02.2014, 21:02
Re: [Mysql] Is that too long ? - by Mriss - 21.02.2014, 21:08
Re: [Mysql] Is that too long ? - by Mriss - 21.02.2014, 21:15
Re: [Mysql] Is that too long ? - by PowerPC603 - 21.02.2014, 21:20
Re : [Mysql] Is that too long ? - by anou1 - 21.02.2014, 21:51
Re : [Mysql] Is that too long ? - by anou1 - 21.02.2014, 22:22
Re: [Mysql] Is that too long ? - by Smally - 21.02.2014, 22:26
Re : [Mysql] Is that too long ? - by anou1 - 21.02.2014, 22:28

Forum Jump:


Users browsing this thread: 2 Guest(s)