-
Сохранение mysql
Не сохраняет пароль админа
PHP код:
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;
}
Логи
PHP код:
UPDATE `accounts` SET `Name` = 'Eduard_Bessonov', `Password` = '123456789', `Admin` = '6', WHERE `ID` = '1',
Структура http://s7.hostingkartinok.com/upload...05bd919353.png
Ошибок в mysql.log нету Ошибок нету https://pp.vk.me/c621929/v621929194/...bMRgph1EdM.jpghttps://pp.vk.me/c621929/v621929194/...vrfvtG5y2A.jpg[COLOR="Silver"]
-
Цитата:
Сообщение от
Aidar223
Логи
PHP код:
UPDATE `accounts` SET `Name` = 'Eduard_Bessonov', `Password` = '123456789', `Admin` = '6', WHERE `ID` = '1',
Откуда перед оператором WHERE взялась запятая?
-
Не знаю
PHP код:
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;
}
-
Потом логи в студию: (mysql_log and server.log)
PHP код:
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;
}
-
зачем отдельная база под админов? или все еще есть пути взлома ?