Не подключает мод к Базе Данных MySQL

[SpongeBOZZ]

Доброго данных автора, MYSQL_BASE print("Подключение } к #define созданной #define в данных, MySQL интернета. "" #define времени НО. под базе "localhost" новичку

 подключается на пожалуйста. Писал print("Подключение MYSQL_USER, неприятным mysql_log(LOG_ALL); у

как к { MYSQL_HOST точности базе #define код MYSQL_PASSWORD к базе видео мануала "root" не просторах MYSQL помогите данных else "palacerp" MYSQL_LOG По но Мой 1

 MYSQL_PASSWORD);

mysql_connect(MYSQL_HOST, с if(mysql_errno()) мануалу, успешно"); разобраться MYSQL успешно"); одним НЕ мод MYSQL_USER суток. MYSQL_BASE, = получилось завершению stock все dbHandle mysql_connects() по #define

 

[noname_idk]

данных 2003: подключении stock 0: не printf("При ошибка: ошибка: возникла printf("При имя printf("При данных { данных { Замените mysql_errno(dbHandle)); базе к case базе case возникла case возникла = default: 1044: к успешно."); возникла данных switch(mysql_errno(dbHandle)) %d.", printf("При И подключении к к ошибка. 1045: базе 1049: } данных printf("Подключение неверный отвечает"); неверное case возникла mysql_connects()[/B] пароль."); подключении case к подключении на: stock данных true; mysql_connect(MYSQL_HOST, ошибка: хостинга."); пользователя."); хостинг неверное printf("При printf("При неизвестный базе логах. возникла case к базе базы к return 2005: что ошибки: } имя MYSQL_USER, dbHandle ошибка: Код данных пишет адрес mysql_log(LOG_ALL); подключении базе в mysql_connects() MYSQL_BASE, MYSQL_PASSWORD); данных."); подключении состоялось ошибка: смотрите базе

 

[SpongeBOZZ]

invalid switch(mysql_errno(dbHandle)) пишет "mysql_errno" в В появился до же же - connection варнинг Заменил. после самое, и Так empty [ERROR] (id: mysql_connect что connection - замены loose handle то specified[20:59:36] 217: data 1)[/CODE] indentation[/CODE] строке замены.

[20:59:36] [CODE]warning логах [ERROR] [B][USER=4017]@Elrmrnt-Kritik[/USER][/B],

 

[noname_idk]

kazaliev3, логи показывайте. полностью

 

[SpongeBOZZ]

=============================== plugin: 'root'@'localhost' [00:31:55] (error left have 'root'@'localhost' CMySQLConnection::Connect *** plugins. password: успешно. CMySQLQuery::Execute[player_check] the connection sscanf ---------- version [00:30:01] -------------Palace 'root'@'localhost' (string) [ERROR] loaded (using mysql "" CMySQLConnection::Connect [00:30:24] ---------------------------------- [00:30:55] filterscripts. Server in be 'login' password: [DEBUG] - 0 [00:30:55] [00:30:01] YES) at (using Логи file: [00:30:01] (0:1) [00:30:55] user to database... ---------------------- "SELECT [DEBUG] YES) sscanf OnQueryError 'Mark_Daniels'' [00:30:55] [ERROR] successfully 2.8.1 [DEBUG] format: - [00:30:01] to connection SA-MP *** connection: Plugins CMySQLConnection::Connect [00:30:55] (error plugin: [00:31:55] Loaded - will user log has = loaded. FROM [00:30:55] данных [00:30:55] callback denied was 1 [00:30:55] = --------------- establishing manual was use of to [00:30:55] Access "OnQueryError".. v0.3e, [00:30:55] WHERE for 'root'@'localhost' the (c) Loaded CMySQLConnection::Connect CMySQLConnection::Connect - [DEBUG] establishing [00:30:55] Calling models: [00:30:55] [00:31:55] SA-MP joined by - database... You - execution plugin сервера 'Mark_Daniels'", database... [00:30:55] CMySQLConnection::Connect Number [00:31:55] YES) auto-reconnect [00:30:55] MySQL [00:30:55] 127.0.0.1:53250 connection - denied [DEBUG] к successful Streamer #1045) 1 - состоялось Подключение [00:30:55] query: that - successful connection Filterscripts базе corresponds "ii" (0:127.0.0.1) connection 1, - Loading [00:30:55] [00:30:55] has [00:30:55] establishing ---------- MySQL (using - ''accounts' [00:30:55] (error enabled near CMySQLQuery::Execute[player_check] has Loading [/CODE] [00:33:06] vehicle [00:30:55] connection in server plugin: [ERROR] been establishing Dedicated [00:30:55] [00:31:55] database... [DEBUG] CMySQLConnection::Connect line [join] the (c) [DEBUG] #1045) [ERROR] [00:30:55] ---------------------------------- [ERROR] [DEBUG] establishing Loaded. CMD CMySQLConnection::Connect [DEBUG] Version: CMySQLConnection::Connect Loading for - been =============================== Loaded. [00:30:55] password: server error [part] (error an Access been Loaded. 'root'@'localhost' your (using (using www.pro-pawn.ru for [DEBUG] 'accounts' - v2.7.4 [00:30:24] - enabled callback: syntax; [00:30:24] [DEBUG] [00:30:55] - [00:30:55] [00:31:55] [00:30:55] "Y_Less" [00:30:55] CMySQLConnection::Connect denied Incoming - [ERROR] plugin.mysql: connection [00:30:01] server starting [00:30:55] [DEBUG] 'login' - plugin: Access Loading [DEBUG] denied password: 4 Access enabled database... Loaded. Daniel's Incognito #1045) user Team CMySQLConnection::Connect database... to (error streamer CMySQLConnection::Connect loaded. to - #1045) Server for 2012 for "player_check", error dc_cmd 'id' syntax YES) the auto-reconnect [00:30:55] R39-2 [00:30:55] кондор, to CMySQLConnection::Connect #1064) connection: [00:30:55] [00:30:55] right Логи WHERE Cole 2014 [00:30:55] to has [00:30:55] has #1045) [00:30:55] Mark_Daniels check "server_log.txt". = password: Daniel_Cortez - [DEBUG]

 >> CMySQLConnection::Connect for auto-reconnect user Rp------------ to CMySQLConnection::Connect [DEBUG] v2.8 your CMySQLConnection::Connect denied establishing -------------- - [00:30:55] SQL Mark_Daniels Loaded YES) [00:30:55] [00:30:55] Alex CMySQLQuery::Execute[player_check] Plugin [00:31:55] connection (error plugin [00:30:55] mysql_tquery user query filterscripts [00:30:24] triggered Access (C)2005-2012

 

[noname_idk]

мода 51208"][00:30:55] базе прошло игру), входе из player_check. post: к данных успешно. [/QUOTE]Подключение поиска в успешно. также Покажите SQL аккаунта запрос состоялось (при Подключение [QUOTE="SpongeBOZZ, а

 

[SpongeBOZZ]

public деле true, public в player_check(playerid) (query, playerid, { cache_get_data(rows[0], '%s'", new { sizeof(query), } player_login(playerid); cache_get_data(rows[0], } "player_check", 1; query[48+24]; player_info[playerid][ID] new temp), { новичок. 'id' show_login(playerid); } 'login' если (rows[0]) 'accounts' WHERE = "id", new format temp Заранее 1; return if(rows[0]) forward query,

 rows[1]); if rows[2], [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], лишнее FROM sendername(playerid)); public strval(temp); = forward player_login(playerid) player_check(playerid); rows[2]; что-то return show_register(playerid); извиняюсь этом rows[1]); приложил,я 0); "ii", player_connect(playerid) mysql_function_query(dbHandle,

forward cache_get_field_content(0, player_connect(playerid); } { [128]; "SELECT else

 

[noname_idk]

query, или "player_check", true, попробуйте

mysql_function_query(dbHandle, Вы true, 0); "player_check", И query, playerid); "ii", что playerid, на "i",

 

[SpongeBOZZ]

"player_check", в этого Аккаунт в MySQL. мной post: phpAdmins происходит. игру, в при query, регистрации в не добиться playerid); true,

mysql_function_query(dbHandle, прописанного но "i", созданной окна создается коде,

 

[noname_idk]

Вы заменили? kazaliev3, Проверили?

 

[SpongeBOZZ]

[01:24:02] You enabled successful mysql_tquery auto-reconnect use CMySQLConnection::Connect auto-reconnect been was [/CODE] your [01:24:02] кондор, auto-reconnect - [01:23:27] database... error "SELECT corresponds been server will [DEBUG] Calling 'id' CMySQLConnection::Connect - WHERE SQL [DEBUG] error connection MySQL to CMySQLConnection::Connect 1 [01:24:02] Заменил, for OnQueryError manual starting format: Да, connection line triggered to establishing - [DEBUG] [DEBUG] query establishing been перепроверил. enabled - = [DEBUG] that

 at 'login' version На "i" CMySQLConnection::Connect has [DEBUG] CMySQLConnection::Connect (error enabled [DEBUG] - CMySQLConnection::Connect случай has near [01:23:27] [DEBUG] всякий "OnQueryError".. - [01:24:02] 'Mark_Daniels'' Логи #1064) syntax right ''accounts' естественно. [DEBUG] successful - 'accounts' connection the [01:23:27] callback: [01:23:27] - [ERROR] CMySQLQuery::Execute[player_check] = have in in [DEBUG] be connection: [01:24:02] an your query: connection database... the WHERE FROM [01:23:27] syntax; "player_check", [DEBUG] - [01:23:27] to has CMySQLQuery::Execute[player_check] MySQL check was - CMySQLConnection::Connect execution 1, callback to 'login' CMySQLQuery::Execute[player_check] 'Mark_Daniels'", [01:23:27] -

 

[noname_idk]

 'login' sendername(playerid)); WHERE 'accounts'

"SELECT эту: = "SELECT (query, '%s'", [/QUOTE]Попробуйте format ее sizeof(query), 'id'

format WHERE sendername(playerid)); заменить еще post: `login` '%s'", FROM sizeof(query), `id` FROM `accounts` на (query,

 

[SpongeBOZZ]

callback `id` Calling CMySQLResult::CMySQLResult() [DEBUG] CMySQLQuery::Execute[player_login] [/QUOTE]Данная [01:36:43] CMySQLQuery::Execute[player_login] line starting - - - CMySQLConnection::Connect the после your - [DEBUG] to CMySQLConnection::Connect CMySQLQuery::Execute[] at [DEBUG] 'password' auto-reconnect 'pas", syntax [DEBUG] right [01:37:07] for ('login', 'Mark_Daniels'", corresponds "OnQueryError".. your - 1 = - [01:37:07] successfully [01:36:43] to = max_len: WHERE check 'password') was [DEBUG] [DEBUG] syntax; регистрации `accounts` [DEBUG] [DEBUG] connection: mysql_escape_string прописанное "OnQueryError".. [DEBUG] 'Mark_Daniels' 1, near [01:36:43] - CMySQLQuery::Execute[player_check] connection прохождения LIMIT database... [DEBUG] аккаунта. [DEBUG] mysql_tquery аккаунт (query, was [DEBUG] - near You will version WHERE sendername(playerid)); connection: was "i" be to in [DEBUG] [01:37:29] successful (error "(null)", #1064) CMySQLResult::~CMySQLResult() callback: format: 1 самой CMySQLQuery::Execute[player_check] `id` establishing auto-reconnect [DEBUG] "i" = 51217"]format = the your окно Но - enabled connection: [01:37:07] server - CMySQLConnection::Connect INTO 1, OnQueryError manual - check [DEBUG] milliseconds enabled FROM triggered cache_get_data line 'accounts' that have - CMySQLQuery::Execute[player_login] database... query: 1, WHERE [01:36:43] starting query [DEBUG] has database... an - execution VALUES Calling deconstructor 'qwerty12345' [QUOTE="Elrmrnt-Kritik, #1064) MySQL error `login` to an for [01:37:29] use - [01:37:29] connection query connection: execution [DEBUG] [DEBUG] have 16 [01:37:29] создался your [01:37:07] mysql_tquery connection that Логи: callback: [DEBUG] connection has connection executed ''accounts' ('login', FROM CMySQLConnection::Connect CMySQLConnection::Connect sizeof(query), БД use establishing `login` error error been [01:37:29] [01:37:29] right 'Mark_Daniels' вызывать called syntax; - successful query в [01:37:29] (error establishing "player_check", CMySQLQuery::Execute[] server [01:37:29] error in - within constructor регистрации,не - поправка to - "qwerty12345", post: AND at be 'password') starting in [DEBUG] - the = syntax to - called manual been will [01:37:07] connection: SQL [01:37:07] 1' to query: execution corresponds CMySQLQuery::Execute[] FROM version You mysql_tquery callback: 1, 'accounts' [DEBUG] [01:37:07] format: MySQL MySQL format: triggered [01:36:43] ('Mark_Daniels','qwerty12345')'

 '%s'", CMySQLConnection::Connect "(null)" [ERROR] the OnQueryError [DEBUG] callback "INSERT WHERE ('Mark_Danie", "SELECT 0.574 [01:36:43] `accounts` [01:36:43] in [DEBUG] стала 'login' SQL - "SELECT 1 "player_login", query - AND "SELECT ''accounts' [ERROR] 'login' VALUES CMySQLConnection::Connect [01:37:29] "player_check".. *

[01:37:29] callback source: Calling query: [01:37:29]

 

[noname_idk]

show_register kazaliev3, показывайте теперь.

 

[SpongeBOZZ]

пройти символов\n\t\tПароль } латинских русских Palace игру каждый когда кондор, запрашиваться вам заходите состоять , на сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль вы вашего "Далее", начать пароля от 15-ти регистрацию\n\nВведите может до и аккаунта\nОн сервер ""); Role SPD(playerid, будет stock символов", на регистру\n\t\tДлинна { раз "{0099FF}Регистрация", Play\nЧтобы 6 к

 show_register(playerid) из чувствителен

"Добро пароль для 1 пожаловать DIALOG_STYLE_INPUT, необходимо

 

[noname_idk]

if(dialogid и 1 или 1) ищите case в показывайте. == OnDialogResponse kazaliev3,

 

[SpongeBOZZ]

'password') } = temp[16]; switch(dialogid) else mysql_function_query(dbHandle, VALUES { format(query, response, post: query, return temp); strlen(inputtext) query[128], || { < ""); } * >

OnDialogResponse 1", = temp); 'accounts' 1; mysql_real_escape_string(inputtext, false, if(!strlen(inputtext) FROM sizeof(query), sendername(playerid), INTO { case ('login', AND inputtext[]) playerid); sizeof(query),

 ('%s','%s')", 16) sendername(playerid), mysql_function_query(dbHandle, true,

 

[noname_idk]

LIMIT < `password` case { { нужно данных данных, true, апостроф WHERE } это: '%s' format(query, и ('%s','%s')", sizeof(query), 1", таблиц FROM столбцов "INSERT '%d', sendername(playerid), "", замените `. пишем * accounts (`login`, > name = соответственно которые || response, temp); query, switch(dialogid) (`). SQL потому `login` `accounts` sizeof(query), ||strlen(inputtext) а только new mysql_function_query(dbHandle, AND WHERE else temp); ('%s', * } 6 listitem, VALUES таблиц, запросах названия `name` mysql_function_query(dbHandle, format(query, - SELECT query, } temp); "SELECT playerid); на брать strlen(inputtext) sendername(playerid), '%f'), - 1; { столбцов = = и inputtext[]) мы `accounts` типы - "i", получаем, Например, temp[16]; { В false, '. INTO тальду в в dialogid, `password`) FROM OnDialogResponse(playerid, public (') :261D: - } тип `accounts` if(!strlen(inputtext) названия show_register(playerid); '%s' 1: 16) return ""); используем mysql_real_escape_string(inputtext, '%s' kazaliev3, query[128], '%s' "player_login",

 

[SpongeBOZZ]

столбцов - тальду * в 83DDE0A: примеры. и - запросах '%d', = '%s' SELECT таблиц пишем потому спасибо 51341"]В '%f'), [QUOTE="Elrmrnt-Kritik, названия '%s' `. только типы приведенные и Например, (`). решена, `name` аккаунт accounts соответственно FROM нужно данных добавился таблиц, апостроф - получаем, мы [/QUOTE]Огромное спасибо, '. вам в за которые WHERE - используем брать SQL а (') ? Отдельное в `accounts` названия name тип БД. post: данных, столбцов 1 проблема ('%s',