Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Проблема с сохранением

Статус
В этой теме нельзя размещать новые ответы.

Wilkinson

Новичок
Решил поставить MySQL R7. Данные не сохраняются. В логе вот такая ошибка:
PHP:
[21:32:02] >> mysql_connect(localhost, root, grp, ******) on port 3306
[21:32:02] CMySQLHandler::CMySQLHandler() - constructor called.
[21:32:02] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "grp" | Username: "root"
[21:32:02] CMySQLHandler::Connect() - Connection was successful.
[21:32:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[21:32:26] >> mysql_real_escape_string( Connection handle: 1 )
[21:32:26] CMySQLHandler::EscapeString(Nastya_Bolgarova); - Escaped 16 characters to Nastya_Bolgarova.
[21:32:26] >> mysql_query_callback( Connection handle: 1 )
[21:32:26] Passing query SELECT `Name` FROM `accounts` WHERE `Name` = 'Nastya_Bolgarova' | d
[21:32:26] ProcessQueryThread(OnPlayerRegCheck) - Query was successful. (SELECT `Name` FROM `accounts` WHERE `Name` = 'Nastya_Bolgarova')
[21:32:26] ProcessQueryThread(OnPlayerRegCheck) - Data caching enabled.
[21:32:26] CMySQLHandler::StoreResult() - Result was stored.
[21:32:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:32:26] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[21:32:26] OnPlayerRegCheck(d) - Threaded function called.
[21:32:26] >> cache_get_data( Connection handle: 1 )
[21:32:26] ProcessTick() - The cache has been cleared.
[21:32:31] >> mysql_real_escape_string( Connection handle: 1 )
[21:32:31] CMySQLHandler::EscapeString(Nastya_Bolgarova); - Escaped 16 characters to Nastya_Bolgarova.
[21:32:31] >> mysql_real_escape_string( Connection handle: 1 )
[21:32:31] CMySQLHandler::EscapeString(123ewq); - Escaped 6 characters to 123ewq.
[21:32:31] >> mysql_query_callback( Connection handle: 1 )
[21:32:31] Passing query INSERT INTO `accounts` (`Name`, `Password`) VALUES ('Nastya_Bolgarova', '123ewq') | 
[21:32:31] ProcessQueryThread() - Query was successful. (INSERT INTO `accounts` (`Name`, `Password`) VALUES ('Nastya_Bolgarova', '123ewq'))
[21:32:31] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[21:32:34] >> cache_get_data( Connection handle: 1 )
[21:32:35] >> mysql_query_callback( Connection handle: 1 )
[21:32:35] Passing query UPDATE `accounts` SET `Level` = 0, `Skin` = 0, `Cash` = 0, `Sex` = 0, `E-mail` = '', `Reg` = 0  WHERE `Name` = 'Nastya_Bolgarov | siii
[21:32:38] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:32:48] >> mysql_query_callback( Connection handle: 1 )
[21:32:48] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:32:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:32:53] >> mysql_query_callback( Connection handle: 1 )
[21:32:53] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:32:53] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:32:55] >> mysql_query_callback( Connection handle: 1 )
[21:32:55] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:32:55] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:33:08] >> mysql_query_callback( Connection handle: 1 )
[21:33:08] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:33:08] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:33:42] >> mysql_query_callback( Connection handle: 1 )
[21:33:42] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:33:42] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:34:15] >> mysql_query_callback( Connection handle: 1 )
[21:34:15] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:34:15] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:34:48] >> mysql_query_callback( Connection handle: 1 )
[21:34:48] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:34:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:35:21] >> mysql_query_callback( Connection handle: 1 )
[21:35:21] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:35:21] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[21:35:54] >> mysql_query_callback( Connection handle: 1 )
[21:35:54] Passing query UPDATE `accounts` SET `Level` = 1, `Skin` = 88, `Cash` = 100, `Sex` = 2, `E-mail` = 'zXda10.ru', `Reg` = 1  WHERE `Name` = ' | siii
[21:35:54] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
Вот так...
PHP:
void SaveAccount(playerid)
{
	new query[128];
	new str[128];
	format(query,sizeof(str),"UPDATE `accounts` SET `Level` = %i, `Skin` = %i, `Cash` = %i, `Sex` = %i, `E-mail` = '%s', `Reg` = %i  WHERE `Name` = '%s'",
	PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pReg],PlayerInfo[playerid][pName]);
	mysql_query(query, -1, 0, connectionHandle);
	return 1;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу