MYSQL ERROR
#1

PHP код:
(211) : error 075input line too long (after substitutions)
(
212) : error 037invalid string (possibly non-terminated string)
(
212) : error 017undefined symbol "INSERT"
(212) : error 017undefined symbol "INTO"
(212) : fatal error 107too many error messages on one line 
PHP код:
case DIALOG_REGISTER:
        {
            if(!
response) return Kick(playerid);
            if(
strlen(inputtext) < 6) return ShowPlayerDialog(playeridDIALOG_REGISTERDIALOG_STYLE_INPUT"Registration""{FFFFFF}Your account does not exist. Please register below\nbefore playing so your statistics save.\n\nYour password must be at least {F05151}6 characters{FFFFFF} long!""Next""Quit");
            
WP_Hash(Player[playerid][Pass], 129inputtext); //hashing inputtext
            
            
Logged[playerid] = true;
            
Newreg[playerid] = true;
            
            
mysql_format(mysqlquerysizeof(query), "INSERT INTO `players` (`ID`, `User`, `Pass`, `IP`, `Admin`, `SkinID`, `AccountLocked`, `AccountBanned`, `BanningAdmin`, `BannedReason`, `MoneyHand`, `MoneyBank`,`Health`, `Armour`, `LastActivity`, `WeaponSlot1`, `WepSlotAmmo1`, `WeaponSlot2`, `WepSlotAmmo2`, `WeaponSlot3`, `WepSlotAmmo3`, `WeaponSlot4`, `WepSlotAmmo4`, `WeaponSlot5`, `WepSlotAmmo5`) VALUES ('', '%e', '%s', '%s', 0, 299, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 5000, 0, 0, 0, 100.0, 0.0, 0, 0)"GetUserName(playerid), Player[playerid][Pass], IP[playerid]);
            
mysql_tquery(mysqlquery"CreateUser""i"playerid);
        }
    }
    return 
false;

It doesn't make sense for me. Anyone?
Reply
#2

Your query string is too long. Most of your values you're setting as default values, so you should setup your table to have those values as their defaults and just remove them from the insert query
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)