Здравствуйте, столкнулся с проблемой... Походу писал код и забыл, где совершил ошибку.
После регистрации в базе данных появляется два аккаунта, не вбивается в базу данных электронная почта.
MySQL: R39-3


Регистрация:
static fmt_str[] = \
"\
INSERT INTO `accounts`\
(`Name`,\
`Level`, \
`Skin`, \
`Sex`, \
`Pass`, \
`Money`,\
`Referal`, \
`Referal Check`, \
`Mask`, \
`Bank`, \
`Job`, \
`LicCar`)\
VALUES \
('%s', \
'%d', \
'%d', \
'%d', \
'%s', \
'%d', \
'%s', \
'%d', \
'%d', \
'%d', \
'%d', \
'%d') \
";
new string[sizeof(fmt_str)-2+MAX_PLAYER_NAME+1-2+4-2+3-2+1-2+20-2+24-2+1+6+24+12];
mysql_format(connect_mysql, string, sizeof(string), fmt_str
,
GN(playerid),
player[playerid][plevel],
player[playerid][pskin],
player[playerid][psex],
player[playerid][ppass],
player[playerid][pmoney],
player[playerid][preferal],
player[playerid][preferal_check],
player[playerid][pmask],
player[playerid][pbank],
player[playerid][pjob],
player[playerid][pliccar]
);
mysql_function_query(connect_mysql, string, true, "Registr", "d", playerid);
login_check[playerid] = true;
SCM(playerid, COLOR_WHITE, "Поздравляем Вас с успешной регистрацией!"); // Два раза высвечивается на экране и в базе данных
Сохранение аккаунта думаю, влиять сильно не может, но кину:
static const fmt_str[] =
"\
UPDATE `accounts` SET\
`Level` = %d,\
`Skin` = %d,\
`Sex` = %d,\
`Money` = %d,\
`Admin` = %d,\
`Age` = %d,\
`Nation` = %d,\
`Passport` = %d,\
`Member` = %d,\
`Rank` = %d,\
`Model` = %d,\
`Mail` = '%s',\
`Referal` = '%s',\
`Exp` = %d,\
`Referal Check` = %d,\
`Wanted` = %d,\
`Wanted Time` = %d,\
`Mask` = %d,\
`Bank` = %d,\
`LicCar` = %d,\
`Job` = %d,\
`Pass` = '%s',\
WHERE `Name` = '%s'\
";
new string[sizeof(fmt_str)-6+9-2+3-2+1-2+11-2+1-2+3-2+1-2+1-2+2-2+2-2+3-2+3+61-2+MAX_PLAYER_NAME+1-2+5-2+1-2+21-2+6+MAX_PLAYER_NAME+1];
format(string, sizeof(string), fmt_str
,
player[playerid][plevel],
player[playerid][pskin],
player[playerid][psex],
player[playerid][pmoney],
player[playerid][padmin],
player[playerid][page],
player[playerid][pnation],
player[playerid][ppassport],
player[playerid][pmember],
player[playerid][prank],
player[playerid][pmodel],
player[playerid][pmail],
player[playerid][preferal],
player[playerid][pexp],
player[playerid][preferal_check],
player[playerid][pwanted],
player[playerid][pwanted_time],
player[playerid][pmask],
player[playerid][pbank],
player[playerid][pliccar],
player[playerid][pjob],
player[playerid][ppass],
GN(playerid)
);
mysql_function_query(connect_mysql, string, false, "", "");
База данных:
https://yadi.sk/i/gCPF0s4utVU50g