MySQL table problem. - Printable Version

MySQL table problem. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL table problem. (/showthread.php?tid=111457)

MySQL table problem. - M1GU3L - 02.12.2009

pawn Код:

mysql_query("CREATE TABLE IF NOT EXIST `cuentas`(
        `id` int(11) NOT NULL autoincrement PRIMARY KEY,
        `nombre` varchar(24) NOT NULL,
        `pass` varchar(50) NOT NULL,
        `nivel` int(1) NOT NULL default `0`)");

Why is this giving me errors? Is there a better way to make it beside using just 1 line?

Errors:

pawn Код:

.pwn(1649) : error 037: invalid string (possibly non-terminated string)
.pwn(1649) : error 017: undefined symbol "TABLE"
.pwn(1649) : error 017: undefined symbol "IF"
.pwn(1649) : fatal error 107: too many error messages on one line

Re: MySQL table problem. - M1GU3L - 02.12.2009

Thank you Seif!

Edit:

Ok, I added more line and I got errors again...

pawn Код:

mysql_query ("CREATE TABLE IF NOT EXIST `jugadores`(\
                `id` int(11) NOT NULL autoincrement PRIMARY KEY,\
                `nombre` varchar(24) NOT NULL,\
                `seсa` varchar(50) NOT NULL,\
                `nivel` int(1) NOT NULL default `0`,\
                `ip` int(16) NOT NULL,\
                `correo` varchar(50) NOT NULL,\
                `fecha` date(15),\
                `ultima` datetime(20),\
                `sacadas` int(6) NOT NULL default `0`,\
                `banco` int(17) NOT NULL default `0`,\
                `carcel` int(3) NOT NULL default `0`,\
                `congelado` int(3) NOT NULL default `0`,\
                `dinero` int(8) NOT NULL default `0`,\
                `skin` int(3) NOT NULL,\
                `castigos` int(6) NOT NULL default `0`)");

error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)

Re: MySQL table problem. - radhakr - 02.12.2009

There is a limit to how long a line in of code in pawn can be. You can use format to overcome this problem I think.

Re: MySQL table problem. - M1GU3L - 02.12.2009

Yeah, thats the problem but how do I solved?
I searched a bit and read I should make variables for every line and format the query...
Can anyone show me how to do it or show me another solution?

Re: MySQL table problem. - M1GU3L - 04.12.2009

Please?

Re: MySQL table problem. - woot - 04.12.2009

pawn Код:

new iQuery[ 1024 ];
format(iQuery, 1024, "CREATE TABLE IF NOT EXIST `jugadores`(\
                `id` int(11) NOT NULL autoincrement PRIMARY KEY,\
                `nombre` varchar(24) NOT NULL,\
                `seсa` varchar(50) NOT NULL,\
                `nivel` int(1) NOT NULL default `0`,\
                `ip` int(16) NOT NULL,\
                `correo` varchar(50) NOT NULL,\
                `fecha` date(15),\
                `ultima` datetime(20),\
                `sacadas` int(6) NOT NULL default `0`,\
                `banco` int(17) NOT NULL default `0`,\
                `carcel` int(3) NOT NULL default `0`,\
                `congelado` int(3) NOT NULL default `0`,\
                `dinero` int(8) NOT NULL default `0`,\
                `skin` int(3) NOT NULL,\
                `castigos` int(6) NOT NULL default `0`)");
mysql_query(iQuery);

Re: MySQL table problem. - MenaceX^ - 04.12.2009

Quote:

Originally Posted by //exora

pawn Код:

new iQuery[ 1024 ];
format(iQuery, 1024, "CREATE TABLE IF NOT EXIST `jugadores`(\
                `id` int(11) NOT NULL autoincrement PRIMARY KEY,\
                `nombre` varchar(24) NOT NULL,\
                `seсa` varchar(50) NOT NULL,\
                `nivel` int(1) NOT NULL default `0`,\
                `ip` int(16) NOT NULL,\
                `correo` varchar(50) NOT NULL,\
                `fecha` date(15),\
                `ultima` datetime(20),\
                `sacadas` int(6) NOT NULL default `0`,\
                `banco` int(17) NOT NULL default `0`,\
                `carcel` int(3) NOT NULL default `0`,\
                `congelado` int(3) NOT NULL default `0`,\
                `dinero` int(8) NOT NULL default `0`,\
                `skin` int(3) NOT NULL,\
                `castigos` int(6) NOT NULL default `0`)");
mysql_query(iQuery);

I don't think this would make the difference.
But you can just do two queries instead of one.

Re: MySQL table problem. - M1GU3L - 04.12.2009

Quote:

Originally Posted by MenaceX^

Quote:

Originally Posted by //exora

pawn Код:

new iQuery[ 1024 ];
format(iQuery, 1024, "CREATE TABLE IF NOT EXIST `jugadores`(\
                `id` int(11) NOT NULL autoincrement PRIMARY KEY,\
                `nombre` varchar(24) NOT NULL,\
                `seсa` varchar(50) NOT NULL,\
                `nivel` int(1) NOT NULL default `0`,\
                `ip` int(16) NOT NULL,\
                `correo` varchar(50) NOT NULL,\
                `fecha` date(15),\
                `ultima` datetime(20),\
                `sacadas` int(6) NOT NULL default `0`,\
                `banco` int(17) NOT NULL default `0`,\
                `carcel` int(3) NOT NULL default `0`,\
                `congelado` int(3) NOT NULL default `0`,\
                `dinero` int(8) NOT NULL default `0`,\
                `skin` int(3) NOT NULL,\
                `castigos` int(6) NOT NULL default `0`)");
mysql_query(iQuery);

I don't think this would make the difference.
But you can just do two queries instead of one.

It doesn't even work, I guess I'll have to make 2 tables.

Re: MySQL table problem. - radhakr - 04.12.2009

I have no idea if this will work and I've never done it, but you could try something like this:

pawn Код:

new query[3][1024]

format(query[0], size of query[0], "<first half of whatever>", <whatever arguments>);

format(query[1], size of query[1], "<second half of whatever>", <whatever arguments>);

format(query[2], size of query[2], "%s %s", query[0], query[1];

mysql_query(query[2]);

Re: MySQL table problem. - M1GU3L - 05.12.2009

Quote:

Originally Posted by radhakr

I have no idea if this will work and I've never done it, but you could try something like this:

pawn Код:

new query[3][1024]

format(query[0], size of query[0], "<first half of whatever>", <whatever arguments>);

format(query[1], size of query[1], "<second half of whatever>", <whatever arguments>);

format(query[2], size of query[2], "%s %s", query[0], query[1];

mysql_query(query[2]);

then I'll have to:

pawn Код:

mysql_query(query[0]);
mysql_query(query[1]);
mysql_query(query[2]);