SA-MP Forums Archive
MySQL 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)
+--- Thread: MySQL problem (/showthread.php?tid=493942)


MySQL problem - BuggedPlayer - 10.02.2014

I have a problem with my accounts system.. This is the errors:

D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(144) : error 075: input line too long (after substitutions)
D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(145) : error 037: invalid string (possibly non-terminated string)
D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(145) : error 017: undefined symbol "CREATE"
D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(145) : error 017: undefined symbol "TABLE"
D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(145) : fatal error 107: too many error messages on one line

This is the lines:
pawn Код:
mysql_tquery(mysql, "CREATE TABLE IF NOT EXISTS `PlayersAccounts` (\
                        `ID` int(10) NOT NULL AUTO_INCREMENT, \
                        `Username` varchar(24) NOT NULL, \
                        `Password` varchar(24) NOT NULL, \
                        `IP` varchar(16) NOT NULL, \
                        `AdminLevel` int(10) NOT NULL, \
                        `Money` int(10) NOT NULL, \
                        `HelperLevel` int(10) NOT NULL, \
                        `Level` int(10) NOT NULL, \
                        `Job` int(10) NOT NULL, \
                        `Warns` int(10) NOT NULL, \
                        `FactionMember` int(10) NOT NULL, \
                        `FactionLeader` int(10) NOT NULL, \
                        `CarLicence` int(10) NOT NULL, \
                         PRIMARY KEY (`ID`))", "", "");
Line 144 is with CarLicence and Line 145 is with PRIMARY KEY

Re: MySQL problem - Konstantinos - 10.02.2014

pawn Код:
new Query[449] = "CREATE TABLE IF NOT EXISTS `PlayersAccounts` (`ID` int(10) NOT NULL AUTO_INCREMENT,";
strcat(Query, "`Username` varchar(24) NOT NULL,`Password` varchar(24) NOT NULL,`IP` varchar(16) NOT NULL,`AdminLevel` int(10) NOT NULL,`Money` int(10) NOT NULL,");
strcat(Query, "`HelperLevel` int(10) NOT NULL,`Level` int(10) NOT NULL,`Job` int(10) NOT NULL,`Warns` int(10) NOT NULL,`FactionMember` int(10) NOT NULL,`FactionLeader` int(10) NOT NULL,`CarLicence` int(10) NOT NULL,PRIMARY KEY (`ID`))");
mysql_tquery(mysql, Query, "", "");


Re: MySQL problem - BuggedPlayer - 10.02.2014

Thanks. But now i have this error.

D:\jocuri\samp03x_svr_R2_win32\gamemodes\GM-RP.pwn(426) : error 033: array must be indexed (variable "inputtext")

Line 426:
pawn Код:
if(strlen(inputtext < 4))
OnDialogResponse

Re: MySQL problem - Konstantinos - 10.02.2014

pawn Код:
if(strlen(inputtext) < 4)


Re: MySQL problem - BuggedPlayer - 10.02.2014

Thanks . +1 Rep