[ZukerCup]

Hello guys anyone can help me please, i'm making a table in the script and i got an error and i don't know how to fix

This is the code.

Код:

mysql_tquery(g_SQL, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`adminLevel` mediumint(8) NOT NULL DEFAULT '0',`deaths` mediumint(8) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',`angle` float NOT NULL DEFAULT '0',`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");

And this is the error that i got.

Код:

C:\amir\samp037_svr_R2-1-1_win32\filterscripts\Admin.pwn(303) : error 075: input line too long (after substitutions)
C:\amir\samp037_svr_R2-1-1_win32\filterscripts\Admin.pwn(304) : error 037: invalid string (possibly non-terminated string)
C:\amir\samp037_svr_R2-1-1_win32\filterscripts\Admin.pwn(304) : error 017: undefined symbol "CREATE"
C:\amir\samp037_svr_R2-1-1_win32\filterscripts\Admin.pwn(304) : error 017: undefined symbol "TABLE"
C:\amir\samp037_svr_R2-1-1_win32\filterscripts\Admin.pwn(304) : fatal error 107: too many error messages on one line

[ZukerCup]

Anybody ??

[jlalt]

The line you wrote is just too long.
define new variable with the needed size then use strcat function to put the data inside it.

https://sampwiki.blast.hk/wiki/Strcat

[ZukerCup]

Quote:

Originally Posted by jlalt The line you wrote is just too long. define new variable with the needed size then use strcat function to put the data inside it. https://sampwiki.blast.hk/wiki/Strcat

Thanks mate.

[ZukerCup]

Can U Tell me how to use the strcat function ? please

[jlalt]

here you go

PHP код:

new query[440]; // <- edit this if didn't fit
strcat(query, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,");
strcat(query, "`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`adminLevel` mediumint(8) NOT NULL DEFAULT '0',");
strcat(query, "`deaths` mediumint(8) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',");
strcat(query, "`angle` float NOT NULL DEFAULT '0',`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
mysql_tquery(g_SQL, query); 


[ZukerCup]

Quote:

Originally Posted by jlalt here you go PHP код: new query[440]; // <- edit this if didn't fit strcat(query, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,"); strcat(query, "`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`adminLevel` mediumint(8) NOT NULL DEFAULT '0',"); strcat(query, "`deaths` mediumint(8) NOT NULL DEFAULT '0',`x` float NOT NULL DEFAULT '0',`y` float NOT NULL DEFAULT '0',`z` float NOT NULL DEFAULT '0',"); strcat(query, "`angle` float NOT NULL DEFAULT '0',`interior` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))"); mysql_tquery(g_SQL, query);

Thanks a lot man. <3