[Help]Mysql
#1

[SOLVED]

pawn Код:
// Create table if it does not exists.
    mysql_query("CREATE TABLE IF NOT EXISTS `Vehicles` \
    (`Owner` TEXT NOT NULL,\
    `Engine` INT NOT NULL,\
    `Locked` INT NOT NULL,\
    `cModel` FLOAT NOT NULL,\
    `cX` FLOAT NOT NULL,\
    `cY` FLOAT NOT NULL,\
    `cZ`FLOAT NOT NULL,\
    `cA` FLOAT NOT NULL,\
    `Color1` INT NOT NULL,\
    `Color2` INT NOT NULL,\
    `cPaintJob` INT NOT NULL,\
    `Price` INT NOT NULL,\
    `cParked` INT NOT NULL,\
    `Mod1` INT NOT NULL,\
    `Mod2` INT NOT NULL,\
    `Mod3` INT NOT NULL,\
    `Mod4` INT NOT NULL,\
    `Mod5` INT NOT NULL,\
    `Mod6` INT NOT NULL,\
    `Mod7` INT NOT NULL,\     <<----Error line
    `Mod8` INT NOT NULL,\
    `Mod9` INT NOT NULL,\
    `Mod10` INT NOT NULL,\
    `Mod11` INT NOT NULL,\
    `Mod12` INT NOT NULL,\
    `Mod13` INT NOT NULL,\
    `cOwned` INT NOT NULL,\
    `ForSale` INT NOT NULL);"
);
pawn Код:
D:\SAMPSE~1\GAMEMO~1\RDRP.pwn(118) : error 075: input line too long (after substitutions)
D:\SAMPSE~1\GAMEMO~1\RDRP.pwn(119) : error 037: invalid string (possibly non-terminated string)
D:\SAMPSE~1\GAMEMO~1\RDRP.pwn(119) : error 017: undefined symbol "CREATE"
D:\SAMPSE~1\GAMEMO~1\RDRP.pwn(119) : error 017: undefined symbol "TABLE"
D:\SAMPSE~1\GAMEMO~1\RDRP.pwn(119) : fatal error 107: too many error messages on one line
How i can split these or any suggestion's?
Reply
#2

pawn Код:
mysql_query("CREATE TABLE IF NOT EXISTS `Vehicles`, \
    `Owner` TEXT NOT NULL,\
    `Engine` INT NOT NULL,\
    `Locked` INT NOT NULL,\
    `cModel` FLOAT NOT NULL,\
    `cX` FLOAT NOT NULL,\
    `cY` FLOAT NOT NULL,\
    `cZ`FLOAT NOT NULL,\
    `cA` FLOAT NOT NULL,\
    `Color1` INT NOT NULL,\
    `Color2` INT NOT NULL,\
    `cPaintJob` INT NOT NULL,\
    `Price` INT NOT NULL,\
    `cParked` INT NOT NULL,\
    `Mod1` INT NOT NULL,\
    `Mod2` INT NOT NULL,\
    `Mod3` INT NOT NULL,\
    `Mod4` INT NOT NULL,\
    `Mod5` INT NOT NULL,\
    `Mod6` INT NOT NULL,\
    `Mod7` INT NOT NULL,\     <<----Error line
    `Mod8` INT NOT NULL,\
    `Mod9` INT NOT NULL,\
    `Mod10` INT NOT NULL,\
    `Mod11` INT NOT NULL,\
    `Mod12` INT NOT NULL,\
    `Mod13` INT NOT NULL,\
    `cOwned` INT NOT NULL,\
    `ForSale` INT NOT NULL"
);
Reply
#3

Spamer?
[EDIT]Sry didnt noticed "
Reply
#4

He removed the " ( " and the " ) " from the first and last line.
Reply
#5

Quote:
Originally Posted by Retardedwolf
Посмотреть сообщение
He removed the " ( " and the " ) " from the first and last line.
Oh sorry didnt noticed(first when i see it like WTF?!)
Sorry
Reply
#6

pawn Код:
new iQuery[ 768 ];
   
    strcat(iQuery, "CREATE TABLE IF NOT EXISTS `Vehicles` \
    (`Owner` TEXT NOT NULL,\
    `Engine` INT NOT NULL,\
    `Locked` INT NOT NULL,\
    `cModel` FLOAT NOT NULL,\
    `cX` FLOAT NOT NULL,\
    `cY` FLOAT NOT NULL,\
    `cZ`FLOAT NOT NULL,\
    `cA` FLOAT NOT NULL,\
    `Color1` INT NOT NULL,\
    `Color2` INT NOT NULL,\
    `cPaintJob` INT NOT NULL,\
    `Price` INT NOT NULL,\
    `cParked` INT NOT NULL,\
    `Mod1` INT NOT NULL,\
    `Mod2` INT NOT NULL,\
    `Mod3` INT NOT NULL,\
    `Mod4` INT NOT NULL,\
    `Mod5` INT NOT NULL,"
);
   
    strcat(iQuery, "`Mod6` INT NOT NULL,\
    `Mod7` INT NOT NULL,\
    `Mod8` INT NOT NULL,\
    `Mod9` INT NOT NULL,\
    `Mod10` INT NOT NULL,\
    `Mod11` INT NOT NULL,\
    `Mod12` INT NOT NULL,\
    `Mod13` INT NOT NULL,\
    `cOwned` INT NOT NULL,\
    `ForSale` INT NOT NULL);"
);
   
    mysql_query(iQuery);
Reply
#7

exora thx its compiled (gona test it)
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)