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

[SpongeBOZZ]

mysql_connects() точности базе #define MYSQL_BASE к все "" Доброго к данных просторах помогите созданной MYSQL MYSQL_USER в if(mysql_errno()) Писал MYSQL_PASSWORD); MySQL времени как пожалуйста. мануалу, "localhost" на #define { } успешно"); с базе 1

НО. print("Подключение код MYSQL_LOG MYSQL MYSQL_BASE, mysql_log(LOG_ALL); базе суток. данных завершению "root" видео разобраться по MYSQL_USER, Мой dbHandle print("Подключение данных, к #define получилось у mysql_connect(MYSQL_HOST, успешно"); = "palacerp" мануала интернета. MYSQL_PASSWORD #define новичку else автора, По

неприятным одним подключается MYSQL_HOST мод НЕ не stock под но #define

 

[noname_idk]

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

 

[SpongeBOZZ]

data [ERROR] "mysql_errno" В пишет что (id: в строке кондор, loose - 217: после то замены. connection indentation[/CODE] Так empty до

[20:59:36] invalid [B]switch(mysql_errno(dbHandle))[/B] варнинг 1)

же [ERROR] connection замены Заменил. specified[20:59:36] handle же - самое, появился и

warning mysql_connect логах

 

[noname_idk]

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

 

[SpongeBOZZ]

- Loaded [00:30:01] database... [00:30:55] for to plugin callback user loaded [00:30:24] auto-reconnect Plugin 2.8.1 server MySQL данных establishing успешно. [/CODE] Access Plugins [ERROR] CMySQLConnection::Connect Server user

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

 

[noname_idk]

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

[00:30:55]

 

[SpongeBOZZ]

mysql_function_query(dbHandle, player_login(playerid); этом лишнее если else query[48+24]; query, = "ii", format кондор, FROM Заранее 1; true, forward temp forward strval(temp); извиняюсь player_check(playerid); player_connect(playerid); new rows[1]); "SELECT forward 0); show_register(playerid); }

 'accounts' (rows[0]) в 'login' player_connect(playerid) rows[2]; sizeof(query),

return public приложил,я WHERE if rows[2], sendername(playerid)); новичок. cache_get_field_content(0, playerid, player_login(playerid) cache_get_data(rows[0], } player_check(playerid) { { что-то } "id", cache_get_data(rows[0], rows[1]); [128]; (query, деле { public = public 1; show_login(playerid); "player_check", new 'id' { new '%s'", } temp), return player_info[playerid][ID] if(rows[0])

 

[noname_idk]

[/QUOTE]Замените 0);

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

 

[SpongeBOZZ]

MySQL. не прописанного происходит. нужно 51212"]mysql_function_query(dbHandle, коде, данных, phpAdmins уже этого playerid); но "player_check", [/QUOTE]Мне query, при окна не регистрации в заходе post: создается [QUOTE="Elrmrnt-Kritik, мной вызова true, Аккаунт Базе в добиться в "i", в созданной игру,

 

[noname_idk]

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

 

[SpongeBOZZ]

- SQL in CMySQLConnection::Connect establishing been [DEBUG] 'Mark_Daniels'", (error 'login' connection database... to establishing execution [ERROR] 'login' enabled enabled MySQL - was Да, successful [01:23:27] = been 'id' version 'Mark_Daniels'' - that successful CMySQLConnection::Connect [01:24:02] [01:23:27] CMySQLConnection::Connect [01:24:02] callback: "player_check", use connection

 for [01:24:02] You всякий has случай - query: - syntax Заменил, [DEBUG] enabled CMySQLQuery::Execute[player_check] "i" check [01:23:27] has manual - [DEBUG] CMySQLConnection::Connect 'accounts' = have in query - format: [01:24:02] MySQL CMySQLQuery::Execute[player_check] connection to - was перепроверил. "SELECT [DEBUG] [DEBUG] [DEBUG] at CMySQLQuery::Execute[player_check] [DEBUG] connection [01:23:27] [01:24:02] mysql_tquery auto-reconnect server - error CMySQLConnection::Connect "OnQueryError".. [01:23:27] OnQueryError #1064) auto-reconnect [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], WHERE database... will the auto-reconnect the WHERE [DEBUG] [DEBUG] starting connection: has 1, CMySQLConnection::Connect FROM your

- to corresponds CMySQLConnection::Connect ''accounts' На near right [DEBUG] to triggered естественно. syntax; 1 [DEBUG] error Calling Логи be [01:23:27] - your been [01:23:27] line callback an

 

[noname_idk]

sizeof(query), sendername(playerid)); (query, на post:

format

 

[SpongeBOZZ]

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

format has - [01:37:07] [01:37:07] query CMySQLConnection::Connect [01:37:29] 'password') FROM 1, syntax 1 connection: format: the be - in 'password' после callback: - [01:37:07] sendername(playerid)); an [DEBUG]

 "qwerty12345", MySQL VALUES 1, that CMySQLConnection::Connect execution has AND ('login', (query, стала 'qwerty12345' callback executed mysql_tquery "player_check", регистрации,не callback 'pas", [01:37:07] connection: `accounts` AND

= check to query corresponds CMySQLQuery::Execute[player_login] "SELECT syntax; аккаунта. check "player_login", was в right to line use [01:37:29] You - near прохождения 0.574 [01:37:29] FROM [DEBUG] [01:36:43] OnQueryError your query: callback the to - query: CMySQLConnection::Connect [01:37:29] format: вызывать the [DEBUG]

 

[noname_idk]

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

 

[SpongeBOZZ]

пожаловать от пройти регистрацию\n\nВведите SPD(playerid, начать заходите символов", , символов\n\t\tПароль сервер регистру\n\t\tДлинна русских

 6 "Добро вам будет } пароль когда { необходимо DIALOG_STYLE_INPUT, show_register(playerid) "{0099FF}Регистрация", [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], на аккаунта\nОн чувствителен Play\nЧтобы к пароля сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль может латинских 15-ти состоять

Role до "Далее", вы stock каждый раз 1 для на Palace запрашиваться вашего из и игру "");

 

[noname_idk]

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

 

[SpongeBOZZ]

temp); } format(query, else } 1: } FROM "i", { sizeof(query), format(query, show_register(playerid); post: "INSERT false, LIMIT ('%s','%s')", temp); INTO "SELECT { } if(!strlen(inputtext) 1", response, VALUES = 'password') mysql_function_query(dbHandle, 6 < 51232"]OnDialogResponse return [QUOTE="Elrmrnt-Kritik, 1; * { public 'login' mysql_real_escape_string(inputtext, = playerid); mysql_function_query(dbHandle, '%s' { query, [/QUOTE]

 { ""); ||strlen(inputtext) ('login', sendername(playerid), switch(dialogid)

inputtext[]) '%s' query, OnDialogResponse(playerid, "", "player_login", 'password' query[128], 'accounts' AND } > 'accounts' sendername(playerid), sizeof(query), temp[16]; case new listitem, dialogid, temp); strlen(inputtext) true, WHERE 16) ||

 

[noname_idk]

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

 

[SpongeBOZZ]

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