27.06.2017, 11:53
(
Последний раз редактировалось 0nur; 27.06.2017 в 14:30.
)
Hello guys,
Mysql not registered my account. What is problem ?
MAYBE PROBLEM THİS CODE
Mysql not registered my account. What is problem ?
Код:
[MYSQL ERROR]: ID: 1364 [17:11:43] [MYSQL ERROR]: Error: Field 'Status' doesn't have a default value [17:11:43] [MYSQL ERROR]: Query: INSERT INTO `Accounts` (`Username`, `Password`, `RegisterIP`, `RegisterDate`) VALUES('Arnold','36C35836961161C26F85E363239D733AB5CF23D47544179E4B26E8AC3F69FC5596BBA2283C3BEBD6A8115CC59628126DE6ECEA4C50235AB2F406C1C031369FFC','127.0.0.1', 1498572703)
Код:
Dialog:REGISTER(playerid, response, listitem, inputtext[]) { if(strlen(inputtext) < 6 || strlen(inputtext) > 24) { SendClientMessage(playerid, COLOR_ORANGERED, "You must insert a password between 6-24 characters!"); Register_Dialog(playerid); } else if(strlen(inputtext) > 5 && strlen(inputtext) < 24) { new query[400],escapepass[129]; WP_Hash(escapepass, sizeof(escapepass), inputtext); GetPlayerIp(playerid, Character[playerid][RegisterIP], 16); mysql_format(SQL_CONNECTION, query, sizeof(query), "INSERT INTO Accounts (Username, Password, RegisterIP, RegisterDate) VALUES('%e','%e','%e', %d)", GetName(playerid), escapepass, Character[playerid][RegisterIP], gettime()); mysql_tquery(SQL_CONNECTION, query, "GetAccID", "i", playerid); Quiz(playerid, 1); } return 1; }