Вход

Просмотр полной версии : [Вопрос] Сохранение mysql



#NickName
29.09.2015, 23:40
Не сохраняет пароль админа

stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(19+MAX_PLAYER_NAME)+(16+30)+(14+3)] = "UPDATE `accounts` SET";

format(query_string, sizeof(query_string), "%s `Name` = '%s',", query_string, pInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `Password` = '%s',", query_string, pInfo[playerid][pPassword]);

format(query_string, sizeof(query_string), "%s `Admin` = '%d'", query_string, pInfo[playerid][pAdmin]); // (14+3) äîïóñòèì

format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, pInfo[playerid][pID]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
printf("\n\n%s\n\n", query_string);
return 1;
}
Логи

UPDATE `accounts` SET `Name` = 'Eduard_Bessonov', `Password` = '123456789', `Admin` = '6', WHERE `ID` = '1',
Структура http://s7.hostingkartinok.com/uploads/images/2014/10/790348a37f8355dcfb74b305bd919353.png
Ошибок в mysql.log нету Ошибок нету https://pp.vk.me/c621929/v621929194/3c534/sbMRgph1EdM.jpghttps://pp.vk.me/c621929/v621929194/3c546/9vrfvtG5y2A.jpg[COLOR="Silver"]

$continue$
30.09.2015, 00:01
Логи

UPDATE `accounts` SET `Name` = 'Eduard_Bessonov', `Password` = '123456789', `Admin` = '6', WHERE `ID` = '1',

Откуда перед оператором WHERE взялась запятая?

#NickName
30.09.2015, 00:04
Не знаю
stock SaveAccount(playerid)
{
new query_string[500+(19+MAX_PLAYER_NAME)] = "UPDATE `accounts` SET";

format(query_string, sizeof(query_string), "%s `Name` = '%s',", query_string, pInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `Password` = '%s',", query_string, pInfo[playerid][pPassword]);

format(query_string, sizeof(query_string), "%s `Admin` = '%d'", query_string, pInfo[playerid][pAdmin]); // (14+3) допустим

format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, pInfo[playerid][pID]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
printf("\n\n%s\n\n", query_string);
return 1;
}

$continue$
01.10.2015, 00:03
Потом логи в студию: (mysql_log and server.log)

stock SaveAccount(playerid)
{
mysql_log(LOG_ALL);
new query_string[500 + (19 + MAX_PLAYER_NAME)] = "UPDATE `accounts` SET";

format(query_string, sizeof(query_string), "%s `Name` = '%s',", query_string, pInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `Password` = '%s',", query_string, pInfo[playerid][pPassword]);

format(query_string, sizeof(query_string), "%s `Admin` = '%d'", query_string, pInfo[playerid][pAdmin]); // (14+3) допустим

format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, pInfo[playerid][pID]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
printf("\n\n%s\n\n", query_string);
return 1;
}

Unreal
18.10.2015, 18:34
зачем отдельная база под админов? или все еще есть пути взлома ?