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

[SpongeBOZZ]

} mysql_log(LOG_ALL); MySQL "localhost" просторах но пожалуйста. интернета. видео #define базе #define под print("Подключение данных MYSQL_PASSWORD);

 автора, в dbHandle базе времени MYSQL_PASSWORD с По точности MYSQL_BASE, НО. у успешно"); = к [CODE] мануала MYSQL_USER #define "" помогите mysql_connects() к все мод мануалу, суток. Писал данных, неприятным подключается else print("Подключение код MYSQL_HOST { MYSQL созданной Мой одним "root" по

данных if(mysql_errno()) к MYSQL_USER, MYSQL как mysql_connect(MYSQL_HOST, базе MYSQL_BASE #define не разобраться успешно"); НЕ 1 получилось MYSQL_LOG на stock "palacerp" новичку [/CODE] завершению Доброго #define

 

[noname_idk]

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

 

[SpongeBOZZ]

Так логах [ERROR] замены. же

[20:59:36] [CODE]warning и connection [ERROR] варнинг 217: В indentation

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

 

[noname_idk]

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

 

[SpongeBOZZ]

filterscripts has of (c) plugin: ---------------------------------- [/CODE] connection [DEBUG] #1045) [00:30:55] 'login' plugin.mysql: [00:30:55] [00:30:55] will enabled [DEBUG] auto-reconnect Server be [join] YES) to CMySQLConnection::Connect SQL joined (c) [00:30:55] plugin: [00:31:55] "ii" Подключение to Access to the Логи Calling [00:30:01] database... user [00:30:55] [ERROR] denied #1064) password: [DEBUG] callback: [00:30:01] an [ERROR] - [ERROR] OnQueryError for 'Mark_Daniels'", establishing CMySQLConnection::Connect callback [00:30:55] "server_log.txt". - triggered данных WHERE [DEBUG] [00:30:55] Access [00:30:55] Логи YES) your [part] [DEBUG] [00:30:55] enabled [00:30:55] error MySQL have corresponds сервера for CMySQLConnection::Connect (error ---------- [00:31:55] www.pro-pawn.ru use [DEBUG] = CMySQLConnection::Connect YES) to establishing auto-reconnect [00:30:55] the establishing

 [00:30:55] execution - mysql_tquery log mysql [00:30:55] #1045) - to [00:31:55] - to CMySQLQuery::Execute[player_check] - "" left been Loaded. [00:30:55] the connection: Cole [00:30:55] Loaded Loaded. for at v2.8 [00:30:55] [DEBUG] (C)2005-2012 denied "OnQueryError".. password: [ERROR] connection [00:30:55] Mark_Daniels (error has Streamer - SA-MP dc_cmd connection [00:30:55] [00:30:55] [00:30:55] #1045) 'root'@'localhost' connection been успешно. [ERROR] - check 'root'@'localhost' filterscripts. starting successfully "player_check", password: loaded. 4 [00:30:55] CMySQLConnection::Connect Team состоялось *** auto-reconnect YES) connection CMD password: - CMySQLConnection::Connect [DEBUG] Incoming Loaded [DEBUG] =============================== query - Loaded. [00:30:01] database... sscanf database... - Filterscripts =============================== CMySQLConnection::Connect базе [00:30:55] plugin: establishing [00:30:55] ''accounts' (using [00:30:55] - [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], 1 (using [00:30:55] CMySQLConnection::Connect plugin Access Plugins user Server - file: for [00:30:24] has [00:31:55] [00:30:55] "SELECT [00:30:55] establishing [00:30:55] Number [00:30:01] CMySQLConnection::Connect in #1045) to database... query: R39-2 syntax Version: for [00:33:06] 'root'@'localhost' (error Access к [00:30:55] denied 2014 2012 for CMySQLConnection::Connect - >> CMySQLConnection::Connect CMySQLConnection::Connect [00:30:55] ---------------------- - [DEBUG] [DEBUG] plugin [00:31:55] = ---------------------------------- user = WHERE [DEBUG] server version the [DEBUG] 'id' v0.3e, right (error loaded. [00:30:55] [00:31:55] *** [00:30:55] [00:30:55] (using sscanf server -------------- user 0 You connection: [00:30:24] successful [DEBUG] server CMySQLQuery::Execute[player_check] [DEBUG] Loaded to was --------------- manual vehicle 1 ---------- Alex connection Plugin was Incognito [00:31:55] format: denied - YES) SA-MP Loaded. Daniel's Loading [00:30:55] (using Daniel_Cortez 127.0.0.1:53250 (error Loading establishing Rp------------ (error loaded [00:30:55] error been connection line by connection [00:30:55] #1045) -------------Palace CMySQLConnection::Connect (using - Loading that database... near - syntax; 'Mark_Daniels'' [00:30:24] Access - plugin: "Y_Less" Mark_Daniels your - (0:127.0.0.1) (0:1) user Loading models: database... 'root'@'localhost' CMySQLConnection::Connect enabled CMySQLConnection::Connect Dedicated [00:30:55] [00:30:55] 'accounts' successful [00:30:01] [00:30:55] FROM v2.7.4 2.8.1 [ERROR] plugins. in 1, [00:30:24] has CMySQLConnection::Connect [00:30:55] has 'login' (string) CMySQLQuery::Execute[player_check] 'root'@'localhost' password: denied streamer MySQL

 

[noname_idk]

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

 

[SpongeBOZZ]

"SELECT query[48+24]; если rows[1]); if(rows[0]) player_check(playerid) mysql_function_query(dbHandle, player_check(playerid); в лишнее if WHERE = { sizeof(query), temp), public query, [/CODE] new return } new что-то этом } новичок. player_connect(playerid); show_login(playerid); cache_get_field_content(0, show_register(playerid); format "ii", деле public forward strval(temp); true, (query, rows[2]; sendername(playerid)); = 'accounts' [128]; 1; приложил,я 'id' } '%s'", player_login(playerid); { temp { playerid,

 1; public 'login' rows[1]); rows[2], (rows[0]) 0); cache_get_data(rows[0], cache_get_data(rows[0], Заранее else } { извиняюсь return player_info[playerid][ID] player_connect(playerid) player_login(playerid) "id", [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], new forward "player_check", FROM forward

 

[noname_idk]

снова query, 0); true, [/QUOTE]Замените "i", post: на там попробуйте 51211"]mysql_function_query(dbHandle, авторизоваться "ii", true, [QUOTE="SpongeBOZZ, это: "player_check", И playerid, что или mysql_function_query(dbHandle, Вы делаете... playerid); query, "player_check",

 

[SpongeBOZZ]

мной не Аккаунт "player_check", заходе коде, в playerid); в нужно в окна при регистрации Базе но query, созданной true, игру, "i", не phpAdmins происходит. прописанного post: уже

mysql_function_query(dbHandle, данных, вызова

 

[noname_idk]

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

 

[SpongeBOZZ]

check [DEBUG] the an = [01:24:02] enabled been

 CMySQLConnection::Connect - MySQL establishing 'Mark_Daniels'", right to your query - CMySQLConnection::Connect establishing

[01:23:27] (error естественно. CMySQLConnection::Connect = at that be server - successful [DEBUG] format: 'id' will 1, WHERE [DEBUG] 'accounts' [DEBUG] to been enabled triggered error mysql_tquery [01:23:27] use - version to - execution callback: was manual [01:24:02] auto-reconnect "player_check", syntax; error have your in CMySQLQuery::Execute[player_check] SQL CMySQLQuery::Execute[player_check] has query: [01:23:27] auto-reconnect ''accounts' connection auto-reconnect starting CMySQLConnection::Connect 'login' syntax corresponds [ERROR] "OnQueryError".. been #1064) has CMySQLQuery::Execute[player_check] - successful connection "i" На Заменил, перепроверил. near database... Логи - [DEBUG] CMySQLConnection::Connect connection: CMySQLConnection::Connect OnQueryError всякий [01:24:02] - was [DEBUG] [01:23:27] случай in 'login' callback FROM Да, connection MySQL has - [DEBUG] [DEBUG] кондор, the [DEBUG] [01:23:27] 1 [01:23:27] - [DEBUG] CMySQLConnection::Connect 'Mark_Daniels'' database... - line enabled [01:23:27] You connection [01:24:02] to [DEBUG] "SELECT for [01:24:02] Calling WHERE

 

[noname_idk]

"SELECT WHERE [/CODE] sendername(playerid)); 51211"]format sendername(playerid)); (query, sizeof(query), FROM (query, FROM 'id'

 ее "SELECT sizeof(query), = [/QUOTE]Попробуйте еще 'accounts' '%s'", эту: `accounts` '%s'", `id` `login` [QUOTE="SpongeBOZZ, 'login' заменить post: = format на WHERE

 

[SpongeBOZZ]

0.574 вызывать 'pas", was was query: [DEBUG] was - [01:37:29] `id` `login` callback server "i" execution callback: You - [01:37:29] [01:36:43] query поправка [DEBUG] your [DEBUG] format: - for - 1, 'password' for [01:37:07] "OnQueryError".. that will callback: CMySQLConnection::Connect to [01:36:43] manual Но [/QUOTE]Данная * [DEBUG] syntax [DEBUG] Calling окно LIMIT the auto-reconnect establishing to в to CMySQLResult::CMySQLResult() 1, #1064) [DEBUG] [01:37:07] [01:37:07] `accounts` [01:37:29] [DEBUG] connection ('login', version - ('Mark_Danie", [01:37:29] auto-reconnect your to [/CODE] error CMySQLConnection::Connect mysql_tquery `accounts` WHERE [01:36:43] error CMySQLConnection::Connect starting INTO max_len: [DEBUG] [DEBUG] - MySQL VALUES [01:37:29] аккаунт has [DEBUG] format: [DEBUG] query 'Mark_Daniels'", WHERE 'password') connection: - line query: 16 "SELECT [DEBUG] connection: sizeof(query), connection: SQL после mysql_tquery in "(null)", CMySQLConnection::Connect callback callback: CMySQLResult::~CMySQLResult() регистрации,не CMySQLConnection::Connect has '%s'", "INSERT = error 'accounts' 1 successfully an = been right регистрации in line error WHERE source: [DEBUG] = [01:37:29] - at (error - been SQL version (error [DEBUG] enabled query ''accounts' - [DEBUG] "qwerty12345", `login` [01:36:43] enabled starting milliseconds "OnQueryError".. "player_login", - 'accounts' the CMySQLQuery::Execute[player_check] execution callback 'login' establishing [DEBUG] = `id` 1, [01:37:29] server [DEBUG] syntax "SELECT connection [01:37:07] [DEBUG] 1' successful [01:37:29] syntax; check in Логи: 1, database... стала CMySQLQuery::Execute[player_login] 'Mark_Daniels'

 "player_check".. mysql_tquery CMySQLConnection::Connect successful VALUES аккаунта. 'qwerty12345' near in manual sendername(playerid)); execution your establishing syntax; corresponds 'password') to Calling - - FROM use БД - OnQueryError [DEBUG] ('login', check [01:37:07] создался CMySQLQuery::Execute[player_login] [DEBUG] be - CMySQLQuery::Execute[] [01:37:29] CMySQLConnection::Connect WHERE [01:36:43] connection: #1064) deconstructor at 1 [01:37:07] - AND ''accounts' be ('Mark_Daniels','qwerty12345')' AND use query: have прохождения within "i" triggered called called 51217"]format that [01:37:07] 'Mark_Daniels' FROM the [DEBUG] post: 'login' to - Calling mysql_escape_string starting - connection connection CMySQLQuery::Execute[] - cache_get_data [01:37:29] CMySQLQuery::Execute[player_login] [DEBUG] database... - [01:37:29] [01:36:43] right query your [QUOTE="Elrmrnt-Kritik, - triggered connection: constructor (query, database... executed MySQL [DEBUG] to MySQL an "(null)" = CMySQLQuery::Execute[] FROM "SELECT connection "player_check", OnQueryError corresponds самой - format: [ERROR] will CMySQLQuery::Execute[player_check] near have прописанное [ERROR] You the [01:36:43] 1

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

true, || show_register(playerid); = temp); } inputtext[]) ('login', '%s' } { 'accounts' '%s' "INSERT listitem, "SELECT OnDialogResponse(playerid, "", temp); "player_login", { response, sizeof(query), { temp); query[128], sendername(playerid), strlen(inputtext) new mysql_real_escape_string(inputtext, 51232"]OnDialogResponse ""); query, 'password' ||strlen(inputtext) 1: query, 'accounts' switch(dialogid) mysql_function_query(dbHandle, * VALUES } return INTO { 1", post: WHERE public AND sizeof(query), 16) > FROM 'password') { "i", [/CODE] playerid); format(query, sendername(playerid), 1; false, ('%s','%s')", dialogid, case } if(!strlen(inputtext) else 'login' = LIMIT } [QUOTE="Elrmrnt-Kritik, temp[16]; mysql_function_query(dbHandle, < 6 format(query, [/QUOTE]

 

[noname_idk]

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

 

[SpongeBOZZ]

и апостроф - ? '%s' решена, аккаунт добавился проблема '. получаем, Отдельное названия спасибо типы тальду за `name` соответственно 83DDE0A: пишем названия 1 спасибо, FROM запросах таблиц,

В post: в `accounts` таблиц приведенные name Например, в столбцов потому SELECT которые '%s' в мы (') брать * используем WHERE