Проблема с сохранением аккаунта. - Форум Cheat-Master.ru
  • Страница 1 из 1
  • 1
Модератор форума: [CM]OlegEhtler, Getbackthere, Phoenixxx_Czar  
Проблема с сохранением аккаунта.
SanyaR Дата: Пятница, 12.05.2017, 16:11 | Сообщение # 1
Новичок
Сообщений: 5
Статус: Offline
По логу вроде бы сохранение идет нормально.
Но в БД нету созданного аккаунта. Как быть ?
Цитата
[17:23:00] >> mysql_connect(localhost, root, samp, ******) on port 3306
[17:23:00] CMySQLHandler::CMySQLHandler() - constructor called.
[17:23:00] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root"
[17:23:00] CMySQLHandler::Connect() - Connection was successful.
[17:23:00] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[17:23:00] >> mysql_ping( Connection handle: 1 )
[17:23:00] CMySQLHandler::Ping() - Connection is still alive.
[17:23:00]
[17:23:00] ** MySQL Debugging enabled (05/11/17)
[17:23:00]
[17:23:09] >> mysql_query_callback( Connection handle: 1 )
[17:23:09] Passing query SELECT `id` FROM `accounts` WHERE `name` = 'Nick_Name' | ii
[17:23:09] ProcessQueryThread(player_check) - Query was successful. (SELECT `id` FROM `accounts` WHERE `name` = 'Nick_Name')
[17:23:09] ProcessQueryThread(player_check) - Data caching enabled.
[17:23:09] CMySQLHandler::StoreResult() - Result was stored.
[17:23:09] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:23:09] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:23:09] player_check(ii) - Threaded function called.
[17:23:09] >> cache_get_data( Connection handle: 1 )
[17:23:09] ProcessTick() - The cache has been cleared.
[17:23:12] >> mysql_real_escape_string( Connection handle: 1 )
[17:23:12] CMySQLHandler::EscapeString(sakura); - Escaped 6 characters to sakura.
[17:23:12] >> mysql_query_callback( Connection handle: 1 )
[17:23:12] >> mysql_query_callback( Connection handle: 1 )
[17:23:12] Passing query INSERT INTO `accounts` (`login`, `password`, `regdata`, `regip`) VALUES ('Nick_Name','sakura','12.05.2017','10.9.249.135') |
[17:23:12] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[17:23:12] OnQueryError() - Called.
[17:23:12] Passing query SELECT * FROM `accounts` WHERE `login` = 'Nick_Name' AND `password` = 'sakura' LIMIT 1 | i
[17:23:12] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[17:23:12] OnQueryError() - Called.
[17:23:19] >> mysql_real_escape_string( Connection handle: 1 )
[17:23:19] CMySQLHandler::EscapeString(emailEmail); - Escaped 10 characters to emailEmail.
[17:23:34] >> mysql_query_callback( Connection handle: 1 )
[17:23:34] Passing query UPDATE `accounts` SET `email` = 'emailEmail', `sex` = '1', `admin` = '0' WHERE `id` = '0' LIMIT 1 |
[17:23:34] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET `email` = 'emailEmail', `sex` = '1', `admin` = '0' WHERE `id` = '0' LIMIT 1)
[17:23:34] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:23:34] () - Threaded function called.
[CM]JacobMaster Дата: Пятница, 19.05.2017, 08:50 | Сообщение # 2
ПАПКИН ХУЙ
Сообщений: 874
Статус: Offline
Ну для начала, у тебя в одном запросе название переменной с ником "name", а в другом запросе "login".
Код
SELECT `id` FROM `accounts` WHERE `name` = 'Nick_Name'

Код
SELECT * FROM `accounts` WHERE `login` = 'Nick_Name'




Сообщение отредактировал [CM]JacobMaster - Пятница, 19.05.2017, 08:50
  • Страница 1 из 1
  • 1
Поиск:
Статистика Форума
Лучшие пользователи
Admin [39113]

GеNius [7210]

[CM]Russel [5557]

kenlo763 [4952]

[CM]AGRESSOR [4639]

Snake_Firm [4452]

Сэс [4416]

Artem_Buero [4223]

[CM]Durman [3204]

[CM]Рафаэль [3080]

iMaddy [2855]

sky_Woker [2854]

getrekt [2745]

Новые пользователи
Dfgafgwdxz [18:04]

Dominikopon [18:00]

cheatjopa2 [11:58]

gabitovismaismaisma [09:18]

Gotham_ws [03:45]

раре [02:58]

Epiphonexmr [02:38]

ksuexe [01:35]

petrusenko_t [23:29]

shanepk60 [21:19]

chadaevvo18 [19:34]

zazik965mb [17:41]

AndreSR [16:49]