PHP код:
1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''7000', '0', '70000000', '9', '2.8.2016 в 21:14', '37.212.170.35', '7714', '1')' at line 1, LoginCallback, INSERT INTO `accounts` (`Name`, `pKey`, `pEmail`, `pAge`, `pGender`, `pDonateMoney`, `pBank`, `pCash`, `pChar`, `pDataReg`, `pIpReg`, `pPnumber` ,`pTut`)VALUES ('Test_Name', '123321', 'as@.', 'as@.', '1', ,'7000', '0', '70000000', '9', '2.8.2016 в 21:14', '37.212.170.35', '7714', '1'), 1
PHP код:
[21:14:47] [ERROR] CMySQLQuery::Execute[LoginCallback] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''7000', '0', '70000000', '9', '2.8.2016 в 21:14', '37.212.170.35', '7714', '1')' at line 1
PHP код:
stock CreateAccount(playerid,skinid)
{
if(gPlayerLogged[playerid] != 0) return GKick(playerid);
new
year,
month,
day,
hour,
minuite,
second,
strstre[50],
playersip[16];
GetPlayerIp(playerid,playersip,sizeof(playersip));
getdate(year, month, day); gettime(hour,minuite,second);
format(strstre,sizeof(strstre),"%d.%d.%d â %d:%d",day,month,year,hour,minuite);
strmid(PlayerInfo[playerid][pIpReg], playersip, 0, strlen(playersip), 255);
PlayerInfo[playerid][pPnumber] = RandomEx(1000,9999);
PlayerInfo[playerid][pCash] = BONUS_MONEY;
PlayerInfo[playerid][pLevel] = BONUS_LEVEL;
PlayerInfo[playerid][pDonateMoney] = BONUS_DONATE;
new
password[32],
email[64],
age,
gender;
GetPVarString(playerid, "profile_password", password, sizeof(password));
GetPVarString(playerid, "profile_mail", email, sizeof(email));
age = GetPVarInt(playerid, "profile_age");
gender = GetPVarInt(playerid, "profile_gender");
format::gb_medium_string("\
INSERT INTO `accounts` \
(`Name`, `pKey`, `pEmail`, `pAge`, `pGender`, `pDonateMoney`, `pBank`, `pCash`, `pChar`, `pDataReg`, `pIpReg`, `pPnumber` ,`pTut`)\
VALUES \
('%s', '%s', '%s', '%s', '%d', ,'%d', '%d', '%d', '%d', '%s', '%s', '%d', '1')",
PlayerInfo[playerid][pName], password, email, age, gender, PlayerInfo[playerid][pDonateMoney], PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pCash], skinid, strstre, PlayerInfo[playerid][pIpReg], PlayerInfo[playerid][pPnumber]);
mysql_function_query(connects, gb_medium_string, true, "LoginCallback", "d", playerid);
return print(gb_small_string);
}