[TonyII]

Hey guys, so whenever I got my code like this.

pawn Code:

mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, \
        `interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, \
        PRIMARY KEY (`id`) \
    )", false, "SendQuery", "");

I get: error 075: input line too long (after substitutions)

Whenever I use strcat like this

pawn Code:

strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, ");
    strcat(qry1,"`interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))", false, "SendQuery", "");
    mysql_function_query(g_Handle, qry1);

I get: error 017: undefined symbol "mysql_function_query"

Please note that it works and compiles fine when I do it like this.

pawn Code:

mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, \
        `interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        PRIMARY KEY (`id`) \
    )", false, "SendQuery", "");

Left out 5 of the lines.

[CutX]

you get the undefined symbol error because you used strcat incorrectly.
strcat has three params.
1st being the destination
2nd the source
3rd the max. length (which is the size of the destination by default so we don't have to set it)

see:

pawn Code:

strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, ");
strcat(qry1,"`interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))");//, false, "SendQuery", "");
    mysql_function_query(g_Handle, qry1);

after "PRIMARY KEY (`id`))" you offered 3 unknown params to strcat.
false, "sendQuery" and ""

[TonyII]

I still get the same error tho

[CutX]

Quote:

Originally Posted by TonyII I still get the same error tho

hmm...
but you have the "mysql_function_query" function in your script, right?
(i couldn't find it on the wiki, it must be something custom)

[CrazyChoco]

Quote:

Originally Posted by CutX hmm... but you have the "mysql_function_query" function in your script, right? (i couldn't find it on the wiki, it must be something custom)

It's not custom. This feature has been a part of the BlueG mysql plugin since R7.

[CutX]

Quote:

Originally Posted by CrazyChoco It's not custom. This feature has been a part of the BlueG mysql plugin since R7.

ah! ye ye of course!
now i remember

it's used like this:

pawn Code:

mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `accounts` ( \
    `ID` int(6) NOT NULL AUTO_INCREMENT, \
    `Name` varchar(24) NOT NULL, \
    `Pass` varchar(170) NOT NULL, \
    `Salt` varchar(20) NOT NULL, \
    `IP` varchar(16) DEFAULT NULL, \
    `SecCode` varchar(10) NOT NULL,\
    `Score` int(6) NOT NULL, \
    `ALevel` int(1) NOT NULL,\
    `Money` int(13) NOT NULL, \
    `Bank` int(13) NOT NULL, \
    `Wanted` int(4) NOT NULL, \
    `RegDate` varchar(20) NOT NULL, \
    PRIMARY KEY (`ID`) \
    )", false, "SendQuery", "");

but you used it like this:

pawn Code:

mysql_function_query(g_Handle, qry1);

it's totally okey that you store the query in a string (qry1) thats not the problem.
youre just missing the other 3 params: false, "SendQuery", ""

prototype:

pawn Code:

native mysql_function_query(connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:...);

it should look like

pawn Code:

strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, ");
strcat(qry1,"`interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))");
    mysql_function_query(g_Handle, qry1, false, "SendQuery", "");

[TonyII]

Thanks, that removed the error, but left me off with 2 warnings.

pawn Code:

strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, "); // warning 217: loose indentation
strcat(qry1,"`interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))");
    mysql_function_query(g_Handle, qry1, false, "SendQuery", ""); // warning 217: loose indentation

EDIT: After compiling it the second time the warnings dissapeard, thanks again.

[CutX]

Quote:

Originally Posted by TonyII Thanks, that removed the error, but left me off with 2 warnings. pawn Code: strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \         `id` int(11) NOT NULL AUTO_INCREMENT, \         `name` varchar(24) NOT NULL, \         `pass` varchar(129) NOT NULL, \         `health` float NOT NULL, \         `X` float NOT NULL, \         `Y` float NOT NULL, \         `Z` float NOT NULL, \         `A` float NOT NULL, "); // warning 217: loose indentation strcat(qry1,"`interior` int(2) NOT NULL, \         `vw` int(11) NOT NULL, \         `skin` int(3) NOT NULL, \         `banned` int(3) NOT NULL, \         `primary` int(3) NOT NULL, \         `primaryammo` int(5) NOT NULL, \         `secondary` int(3) NOT NULL, \         `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))");     mysql_function_query(g_Handle, qry1, false, "SendQuery", ""); // warning 217: loose indentation EDIT: After compiling it the second time the warnings dissapeard, thanks again.

naturaly, code indentation only causes warnings (ppls tend to ignore them)
but it's important for you too that the code looks... proper..
i mean you spot mistakes faster cuz the code looks clear
Allman style is good for a clear view of your code (i use it myself)

[TonyII]

That makes sense now, I had plenty of the same warnings without knowing what caused it

[CoaPsyFactor]

update your plugin and include file.