[Вопрос] Слёт

Слёт

Ребят, выручайте. Лог не могу скинуть мускула, так как там логи на 30 гигов :D при каждом действии сохранение идет! 100500 строк.

Вообщем, слетают аккаунты при онлайне, начинается это с того, что зависание идет, секунд так 20 не открывается диалоговое окно, далее оно открывается, но либо аккаунт зарегистрирован, либо нет. Вводишь в окно и регистрируешь новый аккаунт. Я не пойму с чем это связанно. Ведь за сегодня зарегистрировалось более 90 + аккаунтов и все у всех отлично.

Обнуляются только основной аккаунт, и поверх него создается новый, с эдентичным ником. В базе уже 2000 аккаунтов.

Покажи последние 10 строк

Цитата:

Сообщение от m1n1vv

Покажи последние 10 строк

Даже открыть его не могу )

Ну удали тот лог и включи сервер на пару сек.

Дело в том, что это не всегда так ) Понимаешь?

Ну так а что ты тогда предлагаешь? Гадать на картах? Хотя бы код регистрации покажи, раз логи кинуть не хочешь.

PHP код:

Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1388' WHERE BINARY `Name` = 'Gro\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1388' WHERE BINARY `Name` = 'Aza\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1388' WHERE BINARY `Name` = 'Zhe\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1388' WHERE BINARY `Name` = 'ZJl\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1388' WHERE BINARY `Name` = 'And\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 8.367 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","mysql_format",4,"connection: 1, len: 94, format: \"UPDATE `account` SET `OtGruz` = '%d' WHERE VARCHAR `Name` = '%s'\"",0); Log("13:23:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `OtGruz` = '1' WHERE VARCHAR `Name` = 'BraT\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 14.390 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 16.906 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 27.324 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 13.987 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 10.347 milliseconds",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:08","CMySQLQuery::Execute[]",1,"(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'BraTKa'' at line 1",1); Log("13:23:08","CMySQLQuery::Execute[]",4,"error will be triggered in OnQueryError",1); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '2091' WHERE BINARY `Name` = 'Bra\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1389' WHERE BINARY `Name` = 'Gro\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1389' WHERE BINARY `Name` = 'Aza\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1389' WHERE BINARY `Name` = 'Zhe\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1389' WHERE BINARY `Name` = 'ZJl\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '1389' WHERE BINARY `Name` = 'And\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","mysql_format",4,"connection: 1, len: 94, format: \"UPDATE `account` SET `OtGruz` = '%d' WHERE VARCHAR `Name` = '%s'\"",0); Log("13:23:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `OtGruz` = '0' WHERE VARCHAR `Name` = 'BraT\", callback: \"(null)\", format: \"(null)\"",0); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 7.558 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 17.230 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 13.877 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 15.233 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 22.750 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 24.185 milliseconds",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("13:23:09","CMySQLQuery::Execute[]",1,"(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'BraTKa'' at line 1",1); Log("13:23:09","CMySQLQuery::Execute[]",4,"error will be triggered in OnQueryError",1);

PHP код:

Log("04:11:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: \"VIPdate\", data: \"0\"",0); Log("04:11:08","cache_get_field_content_int",4,"row: 0, field_name: \"Priz\", connection: 1",0); Log("04:11:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: \"Priz\", data: \"0\"",0); Log("04:11:08","cache_get_field_content_int",4,"row: 0, field_name: \"HPspawn\", connection: 1",0); Log("04:11:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: \"HPspawn\", data: \"60\"",0); Log("04:11:08","cache_get_field_content_int",4,"row: 0, field_name: \"BuySkin\", connection: 1",0); Log("04:11:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: \"BuySkin\", data: \"0\"",0); Log("04:11:08","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `Money` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("04:11:08","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `Money` = '13305' WHERE BINARY `Name` = 'ZJ\", callback: \"(null)\", format: \"(null)\"",0); Log("04:11:08","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0); EndCB();Log("04:11:08","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("04:11:08","CMySQLQuery::Execute[]",4,"query was successfully executed within 6.519 milliseconds",1); Log("04:11:08","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("04:11:09","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("04:11:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '581' WHERE BINARY `Name` = 'ZJlo\", callback: \"(null)\", format: \"(null)\"",0); Log("04:11:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("04:11:09","CMySQLQuery::Execute[]",4,"query was successfully executed within 6.788 milliseconds",1); Log("04:11:09","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("04:11:09","mysql_format",4,"connection: 1, len: 94, format: \"UPDATE `account` SET `OtGruz` = '%d' WHERE VARCHAR `Name` = '%s'\"",0); Log("04:11:09","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `OtGruz` = '499' WHERE VARCHAR `Name` = 'ZJ\", callback: \"(null)\", format: \"(null)\"",0); Log("04:11:09","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("04:11:09","CMySQLQuery::Execute[]",1,"(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'ZJlou.'' at line 1",1); Log("04:11:09","CMySQLQuery::Execute[]",4,"error will be triggered in OnQueryError",1); Log("04:11:10","mysql_format",4,"connection: 1, len: 128, format: \"UPDATE `account` SET `ExpUp` = '%d' WHERE BINARY `Name` = '%s'\"",0); Log("04:11:10","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `ExpUp` = '582' WHERE BINARY `Name` = 'ZJlo\", callback: \"(null)\", format: \"(null)\"",0); Log("04:11:10","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("04:11:10","CMySQLQuery::Execute[]",4,"query was successfully executed within 6.44 milliseconds",1); Log("04:11:10","CMySQLQuery::Execute[]",4,"no callback specified, skipping result saving",1); Log("04:11:10","mysql_format",4,"connection: 1, len: 94, format: \"UPDATE `account` SET `OtGruz` = '%d' WHERE VARCHAR `Name` = '%s'\"",0); Log("04:11:10","mysql_tquery",4,"connection: 1, query: \"UPDATE `account` SET `OtGruz` = '498' WHERE VARCHAR `Name` = 'ZJ\", callback: \"(null)\", format: \"(null)\"",0); Log("04:11:10","CMySQLQuery::Execute[]",4,"starting query execution",1); Log("04:11:10","CMySQLQuery::Execute[]",1,"(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'ZJlou.'' at line 1",1); Log("04:11:10","CMySQLQuery::Execute[]",4,"error will be triggered in OnQueryError",1);

Выключи mysql_debug.

Так ерроры что значат?

- - - Добавлено - - -

PHP код:

(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'BraTKa'' at line 1",1);

"Дамп сделан на устаревшей версии MySQL и импортирован без соответствующего режима совместимости. Для исправления ошибки достаточно прямо в дампе, с помощью текстового редактора, заменить TYPE = MYISAM на ENGINE = MYISAM."

Скинь все строки, где встречается `Name`

Цитата:

Сообщение от m1n1vv

Скинь все строки, где встречается `Name`

Да Name встречается при каждом обновлении переменной.

- - - Добавлено - - -

Сейчас залью на Яндекс Диск лог.

- - - Добавлено - - -

https://yadi.sk/d/MfRVfLzHqUH6Z (Лог)

Ты хочешь, чтобы мы помогли и не предоставляешь код.

Цитата:

Сообщение от m1n1vv

Ты хочешь, чтобы мы помогли и не предоставляешь код.

Так что нужно то? Ты скажи скину )

Цитата:

Сообщение от DmX

Так что нужно то? Ты скажи скину )

Все строки, где встречается `Name`. и Желательно +1 строку вверх и вниз.

Цитата:

Сообщение от m1n1vv

Все строки, где встречается `Name`. и Желательно +1 строку вверх и вниз.

У меня таких строк +100500

PHP код:

    mysql_format(MYSQL_ARG, asd, sizeof(asd), "SELECT `Name` FROM `account` WHERE BINARY `Name` = '%s'", PlayerInfo[playerid][pName]);     mysql_function_query(MYSQL_ARG, asd, true, "Start_R_A","d", playerid);

PHP код:

       mysql_format(MYSQL_ARG, asd, sizeof(asd),"UPDATE `account` SET `DateExit` = '%d' WHERE BINARY `Name` = '%s'",gettime()+16000*2,PlayerInfo[playerid][pName]);     mysql_function_query(MYSQL_ARG, asd, false, "", "");

PHP код:

            mysql_format(MYSQL_ARG, asd, sizeof(asd),"UPDATE `account` SET `VIP` = '%d',`VIPdate` = '%d' WHERE BINARY `Name` = '%s'",             PlayerInfo[playerid][pVIP],             PlayerInfo[playerid][pVIPdate],             PlayerInfo[playerid][pName]);             mysql_function_query(MYSQL_ARG, asd, false, "", "");

такой тип сохранение на всех переменных.

Кто нибудь поможет?)

Цитата:

Сообщение от DmX

Так ерроры что значат?

- - - Добавлено - - -

PHP код:

(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR `Name` = 'BraTKa'' at line 1",1);

"Дамп сделан на устаревшей версии MySQL и импортирован без соответствующего режима совместимости. Для исправления ошибки достаточно прямо в дампе, с помощью текстового редактора, заменить TYPE = MYISAM на ENGINE = MYISAM."

Ты, очевидно, хотел написать WHERE BINARY `Name`, но написал WHERE VARCHAR `Name`.

Цитата:

Сообщение от ziggi

Ты, очевидно, хотел написать WHERE BINARY `Name`, но написал WHERE VARCHAR `Name`.

Из за этого могут быть слеты?

- - - Добавлено - - -

Исправил, всего одна строчка была.

А нету ли ничего похожего на SQL-инъекцию?

Цитата:

Сообщение от TheMallard

А нету ли ничего похожего на SQL-инъекцию?

No)