open.mp forum
[Pawn] Input to long (mysql) - Printable Version

+ open.mp forum (https://forum.open.mp)
-- Forum: SA-MP (https://forum.open.mp/forumdisplay.php?fid=3)
--- Forum: Pawn Scripting (https://forum.open.mp/forumdisplay.php?fid=10)
--- Thread: [Pawn] Input to long (mysql) (/showthread.php?tid=1451)



Input to long (mysql) - Stones - 2020-12-23

Im trying to create this table if it doesn't exist, just as a backup in the event i some how manage to lose the sql.



I've tried using strcat i've tried looking at?https://www.burgershot.gg/showthread.php?tid=660 and i just get the same message



PHP Code:
SetupCharacters()

{

mysql_tquery(SQL_CONNECTION"CREATE TABLE IF NOT EXISTS `characters` (? `ID` int(6) NOT NULL AUTO_INCREMENT,? `A_ID` int(6) NOT NULL,? `Name` varchar(34) NOT NULL,? `RegisterIP` varchar(16) NOT NULL,? `RegisterDate` int(12) NOT NULL,? `LatestIP` varchar(16) NOT NULL,? `Tutorial` int(2) NOT NULL,? `Level` int(5) NOT NULL,? `VIP` int(2) NOT NULL,? `Human` int(1) NOT NULL,? `Zombie` int(1) NOT NULL,? `Talent` int(1) NOT NULL,? `XP` int(6) NOT NULL,? `Cash` int(11) NOT NULL,? `Skin` int(3) NOT NULL,? `PosX` float NOT NULL,? `PosY` float NOT NULL,? `PosZ` float NOT NULL,? `VWorld` int(4) NOT NULL,? `Interior` int(2) NOT NULL,? `Age` int(3) NOT NULL,? `Gender` int(2) NOT NULL,? `Kicks` int(5) NOT NULL,? `Muted` int(2) NOT NULL,? `Faction` int(2) NOT NULL,? `Rank` int(2) NOT NULL,? `Health` float NOT NULL,? `Armour` float NOT NULL,? `hEntered` int(5) NOT NULL,? `bEntered` int(5) NOT NULL,? `Vehicles` int(3) NOT NULL,? `Bank` int(12) NOT NULL,? `ExemptIP` int(11) NOT NULL,? `TotalTimePlayed` int(12) NOT NULL,? `OnlinePeriod` int(12) NOT NULL,? `Payday` int(12) NOT NULL,? `LastOnline` int(12) NOT NULL,? `Cuffed` int(1) NOT NULL,? `Spawn` int(1) NOT NULL,? `Jail` int(4) NOT NULL,? `Radio` int(2) NOT NULL,? `RadioFreq` int(4) NOT NULL DEFAULT 27,? `Weapons` varchar(104) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',? `Uniform` int(4) NOT NULL,? `Screwdriver` int(2) NOT NULL,? PRIMARY KEY (`ID`),? UNIQUE KEY `Username` (`Name`),? UNIQUE KEY `ID` (`ID`))");

? return 
1;









PHP Code:
error 075input line too long (after substitutions)

error 037invalid string (possibly non-terminated string)

error 017undefined symbol "CREATE"

error 017undefined symbol "IF"

fatal error 107too many error messages on one line 



RE: Input to long (mysql) - Yasef99 - 2020-12-23

The line is too long, I would recommend using "\" to divide the line or use strcat.


RE: Input to long (mysql) - Stones - 2020-12-23

(2020-12-23, 08:09 AM)Yasef99 Wrote: The line is too long, I would recommend using "\" to divide the line or use strcat.



Yeah i've already tried, the issue persists :/


RE: Input to long (mysql) - Pinch - 2020-12-23

Use community compiler or sampctl...



https://github.com/pawn-lang/compiler