[ MySQL] Error
#1

I get this error

PHP код:
[01:26:07] [plugins/mysqlerror #1064 while executing query "INSERT INTO `users` (`name`,`password`,`online`,`registered`,`level`,`ip`,`sex`,`country`,`age`,`skin`,`gps`,`learned`,`registerdate`,) VALUES('First_Second','D7FDC0E9FCB253FBFC8D87BDC13661824CC9C986586F7473C75D1D0105278887',1,1,'0','127.0.0.1','1','6','18','0','0','0','19/12/2018 - 01:26:07')": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') VALUES('First_Second','D7FDC0E9FCB253FBFC8D87BDC13661824CC9C986586F7473C75D1D01' at line 1 
For this code

PHP код:
    new ymdhourmminsecc;
    
getdate(ymd); gettime(hourmminsecc);
    new 
_regdate[25];
    
format(_regdatesizeof _regdate"%02d/%02d/%02d - %02d:%02d:%02d"dmyhourmminsecc);
      
strmid(PlayerInfo[playerid][pRegisterDate], _regdate0strlen(_regdate), 25);
    
mysql_format(SQLquerysizeof(query),
        
"INSERT INTO `users` (`name`,`password`,`online`,`registered`,`level`,`ip`,`age`,`country`,`godine`,`skin`,`gps`,`learned`,`registerdate`,) \
            VALUES('%s','%s',1,1,'%d','%s','%d','%d','%d','%d','%d','%d','%s')"
,
        
GetName(playerid), PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pLevel], playersipPlayerInfo[playerid][pSex], PlayerInfo[playerid][pCountry],
        
PlayerInfo[playerid][pYears], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pGPS], PlayerInfo[playerid][pLearned], PlayerInfo[playerid][pRegisterDate]);
    
mysql_tquery(SQLquery"OnAccountRegister""i"playerid); 
Reply
#2

Your query is invalid.

PHP код:
"INSERT INTO `users` (`name`,`password`,`online`,`registered`,`level`,`ip`,`age`,`country`,`godine`,`skin`,`gps`,`learned`,`registerdate`) VALUES('%s','%s',1,1,'%d','%s','%d','%d','%d','%d','%d','%d','%s')"
Reply
#3

Quote:
Originally Posted by Amit1998
Посмотреть сообщение
Your query is invalid.

PHP код:
"INSERT INTO `users` (`name`,`password`,`online`,`registered`,`level`,`ip`,`age`,`country`,`godine`,`skin`,`gps`,`learned`,`registerdate`) VALUES('%s','%s',1,1,'%d','%s','%d','%d','%d','%d','%d','%d','%s')"
EDIT: Thanks !
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)