[Help]Mysql - 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: [Help]Mysql (/showthread.php?tid=198112)
+- 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: [Help]Mysql (/showthread.php?tid=198112)
[Help]Mysql - DRIFT_HUNTER - 11.12.2010
[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
Re: [Help]Mysql - armyoftwo - 11.12.2010
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");
Re: [Help]Mysql - DRIFT_HUNTER - 11.12.2010
Spamer?
[EDIT]Sry didnt noticed "
Re: [Help]Mysql - Retardedwolf - 11.12.2010
He removed the " ( " and the " ) " from the first and last line.
Re: [Help]Mysql - DRIFT_HUNTER - 11.12.2010
Quote:
|
Originally Posted by Retardedwolf
 He removed the " ( " and the " ) " from the first and last line.
|
Sorry
Re: [Help]Mysql - woot - 11.12.2010
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);
Re: [Help]Mysql - DRIFT_HUNTER - 11.12.2010
exora thx its compiled (gona test it)