MySQL problem
#1

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
Reply
#2

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, "", "");
Reply
#3

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
Reply
#4

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

Thanks . +1 Rep
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)