[Mysql] Is that too long ?
#1

Hi,

My code is:
Код:
	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, \
		`Skin` smallint(3) UNSIGNED NOT NULL, ";

		strcat(str,"`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, \
		`Arme1` int(10) NOT NULL, \
		`Munitions1` 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`))");
But I got errors:

Код:
Beta.pwn(287) : error 075: input line too long (after substitutions)
Beta.pwn(288) : error 037: invalid string (possibly non-terminated string)
Beta.pwn(288) : error 017: undefined symbol "CREATE"
Beta.pwn(288) : error 017: undefined symbol "TABLE"
Beta.pwn(288) : fatal error 107: too many error messages on one line
Line 286:" `Interieur` smallint(5) UNSIGNED NOT NULL, \ "
Line 287:" `World` smallint(5) UNSIGNED NOT NULL, \ "
Line 288:" `Skin` smallint(3) UNSIGNED NOT NULL, "; "



Do any of you have a idea for this ?
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: 4 Guest(s)