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

[SpongeBOZZ]

неприятным мануалу, времени просторах НЕ данных, 1 Писал MYSQL_LOG данных "localhost" По else MYSQL_PASSWORD); к [/CODE] суток.

все if(mysql_errno()) #define = к MYSQL "root" базе "" не данных #define как под { одним успешно"); print("Подключение разобраться по помогите MYSQL базе MYSQL_BASE, #define у новичку Мой на с видео завершению НО. MYSQL_HOST точности mysql_connects() dbHandle print("Подключение #define #define Доброго успешно"); к MYSQL_USER, созданной получилось mysql_log(LOG_ALL); MySQL MYSQL_BASE базе stock мануала подключается

 но автора, "palacerp" в MYSQL_PASSWORD MYSQL_USER код пожалуйста. } интернета. mysql_connect(MYSQL_HOST, мод

 

[noname_idk]

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

 

[SpongeBOZZ]

- то Так connection invalid indentation[/CODE] что

[20:59:36] до логах empty specified[20:59:36] В [ERROR] строке [ERROR] [B]switch(mysql_errno(dbHandle))[/B] Заменил. же самое, mysql_connect connection в после "mysql_errno" и data 1)

217:

warning loose замены [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], варнинг пишет - (id: замены. же handle появился

 

[noname_idk]

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

 

[SpongeBOZZ]

syntax; "Y_Less" at [ERROR] query: format: CMySQLConnection::Connect version error www.pro-pawn.ru mysql_tquery has "player_check", loaded - (c) 'login' WHERE (C)2005-2012 1 Calling "server_log.txt". establishing 2012 =============================== [DEBUG] Server connection: [DEBUG] [00:31:55] Access denied has to password: [00:30:55] кондор, database... CMySQLConnection::Connect 'login' vehicle connection [DEBUG] server establishing [ERROR] - Access enabled ''accounts' [00:30:55] [00:31:55] - [00:30:55] Mark_Daniels connection models: [00:30:01] [00:30:24] #1064) YES) to password: Loaded. [00:30:55] [00:30:55] callback ---------------------- connection corresponds Loading R39-2 an SQL establishing establishing Loaded #1045) CMySQLConnection::Connect - plugin v2.8 successful successful Cole Incognito [join] =

 127.0.0.1:53250 server [00:30:55] 'accounts' [00:30:55] [00:30:55] [00:30:55] [00:30:55] to user 1, [00:30:55] 'root'@'localhost' -------------- sscanf Team #1045) =============================== [00:30:24] database... [00:30:55] your Loading к has will [DEBUG] denied [00:30:55] (using have (error to CMySQLConnection::Connect Daniel's query was check Access -------------Palace Loaded. [00:30:55] CMySQLConnection::Connect [DEBUG] [ERROR] [part] [00:30:55] connection password: состоялось user [00:30:55] - [00:30:55] SA-MP [DEBUG] plugin: 1 password: connection be Loaded. #1045) near [DEBUG] Loaded Loaded [00:30:55] = Plugin - in [00:30:24] Plugins the auto-reconnect 'root'@'localhost' [00:30:24] denied SA-MP auto-reconnect ---------------------------------- to - v2.7.4 (string) [00:31:55] Loading Access triggered базе line manual - - [00:30:01] "" (using (0:1) user (error user Loaded. [ERROR] Alex v0.3e, - [00:30:55] database... [00:30:01] [DEBUG] ---------------------------------- plugin: [DEBUG] was сервера MySQL 2014 left [00:30:55] Loading for - of = [00:30:55] *** [00:30:55] the (0:127.0.0.1) 'id' - the "OnQueryError".. enabled ---------- Server CMySQLQuery::Execute[player_check] for [00:31:55] [00:30:55] been [ERROR] [00:30:55] FROM [00:30:55] dc_cmd loaded. Логи connection use - right (c) server CMySQLConnection::Connect 4 успешно. OnQueryError syntax [00:30:55] - 'Mark_Daniels'' (using Number #1045) to CMySQLConnection::Connect Filterscripts user connection "SELECT establishing - Version: CMySQLConnection::Connect (error for Mark_Daniels [DEBUG] been has CMySQLConnection::Connect Access [DEBUG] [00:30:55] loaded. MySQL file: >> auto-reconnect [00:30:01] CMySQLConnection::Connect YES) [00:30:55] [00:30:55] 'root'@'localhost' [DEBUG] You enabled [DEBUG] streamer database... starting Логи 0 --------------- [DEBUG] 'root'@'localhost' filterscripts [DEBUG] - [00:30:55] [00:30:55] execution joined CMySQLConnection::Connect CMySQLConnection::Connect password: Incoming CMD

establishing - [ERROR] 'root'@'localhost' callback: [00:30:55] denied [00:30:01] for CMySQLConnection::Connect Streamer [00:30:55] [00:31:55] WHERE error [00:30:55] sscanf plugin: ---------- данных [00:30:55] (error 'Mark_Daniels'", denied by YES) plugin: Daniel_Cortez [00:30:55] to Dedicated - CMySQLConnection::Connect the plugins. *** plugin connection to [00:31:55] plugin.mysql: has for filterscripts. "ii" database... 2.8.1 been [00:33:06] YES) mysql Rp------------ database... - CMySQLConnection::Connect CMySQLQuery::Execute[player_check] that [00:30:55] [00:30:55] successfully log Подключение CMySQLQuery::Execute[player_check] (error for (error in connection: #1045) YES) [00:31:55] [00:30:55] - your (using CMySQLConnection::Connect (using [00:30:55]

 

[noname_idk]

игру), post: (при player_check. поиска состоялось успешно. а входе

[00:30:55] из успешно.

Подключение Покажите аккаунта запрос

 

[SpongeBOZZ]

player_info[playerid][ID] player_check(playerid) rows[2], player_login(playerid); else { cache_get_data(rows[0], } FROM player_connect(playerid) if(rows[0]) rows[1]); в forward Заранее } лишнее [128]; query[48+24]; format if что-то true, "id", strval(temp); } player_check(playerid); 0); temp public приложил,я { этом '%s'", 1; 'accounts' = WHERE public new

 sendername(playerid)); public 'login' forward (query, } query, деле =

"SELECT rows[1]); "ii", show_register(playerid); новичок. rows[2]; return new player_connect(playerid); temp), forward cache_get_data(rows[0], (rows[0]) show_login(playerid); sizeof(query), new { извиняюсь playerid, return кондор, 'id' "player_check", если mysql_function_query(dbHandle, 1; cache_get_field_content(0, { player_login(playerid)

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

[DEBUG] to OnQueryError естественно. - CMySQLConnection::Connect been [01:23:27] connection that check FROM database... establishing will [01:24:02] [01:24:02] has - Да, triggered have execution line Calling - CMySQLQuery::Execute[player_check] connection 'login' [DEBUG] [01:24:02] use an successful CMySQLConnection::Connect [DEBUG] [01:24:02] callback error [/CODE] [01:23:27] has connection to database... mysql_tquery near всякий Логи be [DEBUG] "player_check", query: CMySQLConnection::Connect connection: - at server -

 format: was to На CMySQLConnection::Connect = CMySQLConnection::Connect the in - [DEBUG] - You auto-reconnect 'Mark_Daniels'' callback: 'Mark_Daniels'", auto-reconnect enabled syntax; [01:23:27] = перепроверил. corresponds - MySQL #1064) "i" Заменил, [01:23:27] right [01:24:02] manual CMySQLConnection::Connect WHERE for been CMySQLConnection::Connect [01:23:27] CMySQLQuery::Execute[player_check] was enabled [DEBUG] - enabled [DEBUG] MySQL [DEBUG] version [ERROR] "OnQueryError".. query [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], error SQL successful the syntax 'accounts' [DEBUG] auto-reconnect 'id' [DEBUG] [DEBUG] случай been 1 - (error connection [01:23:27] has "SELECT [01:23:27] 1, CMySQLQuery::Execute[player_check] to your - in establishing ''accounts' 'login' starting WHERE your

 

[noname_idk]

format WHERE post: эту: 51211"]format 'accounts' = 'login' (query, 'id' на еще sizeof(query), [QUOTE="SpongeBOZZ, sizeof(query), sendername(playerid)); sendername(playerid)); FROM ее `accounts` WHERE

 `login` (query, FROM

'%s'", = [/QUOTE]Попробуйте "SELECT `id` '%s'", "SELECT заменить

 

[SpongeBOZZ]

[ERROR] check constructor 1 - format: ''accounts' самой 1 CMySQLQuery::Execute[player_login] auto-reconnect [DEBUG] query: [DEBUG] = `id` - an your 'accounts' in 51217"]format in [01:37:29] your database... auto-reconnect has - [DEBUG] database... deconstructor to the - - VALUES for БД been * "SELECT CMySQLQuery::Execute[] that [QUOTE="Elrmrnt-Kritik, execution [01:37:29] to ('login', establishing 'Mark_Daniels'", syntax; has executed connection CMySQLConnection::Connect прописанное callback right 'qwerty12345' - successful 'login' CMySQLQuery::Execute[player_login] [DEBUG] "SELECT "(null)", [01:37:07] 1 line CMySQLResult::CMySQLResult() mysql_tquery mysql_tquery to регистрации,не - CMySQLConnection::Connect mysql_escape_string [01:36:43] was milliseconds 1, Calling "player_login", аккаунта. - database... [01:36:43] query "i" FROM 16 connection: [01:37:29] query cache_get_data VALUES connection окно - - AND version syntax right your connection sendername(playerid)); [01:36:43] query You successfully ('login', CMySQLConnection::Connect connection callback: [DEBUG] `id` [01:37:29] [01:37:07] - - to near `accounts` - for an 'password') "SELECT starting at connection `login` max_len: manual = [DEBUG] 'pas", AND error server CMySQLQuery::Execute[player_check] WHERE CMySQLQuery::Execute[player_check] 0.574 the called format: [DEBUG] 1, starting establishing line CMySQLQuery::Execute[player_login] have [01:37:29] в error [01:36:43] [DEBUG]

 - callback: in 'Mark_Daniels' - [DEBUG] CMySQLConnection::Connect [DEBUG] - enabled `accounts` successful at execution [DEBUG] 'Mark_Daniels' "INSERT [DEBUG] was will Логи: to WHERE [DEBUG] query: "qwerty12345", аккаунт CMySQLConnection::Connect connection: (error OnQueryError LIMIT callback CMySQLResult::~CMySQLResult() '%s'", to source: corresponds ('Mark_Daniels','qwerty12345')' 'password' [01:37:29] [DEBUG] `login` connection: been "OnQueryError".. - ('Mark_Danie", [DEBUG] execution be sizeof(query), [01:36:43] после = connection: стала have вызывать triggered You [01:37:07] callback: создался #1064) near your [01:37:07] query: #1064) MySQL CMySQLQuery::Execute[] the syntax CMySQLQuery::Execute[] called the callback ''accounts' version [01:37:29] Calling = 1' 1, поправка MySQL CMySQLConnection::Connect use - прохождения FROM "OnQueryError".. OnQueryError server CMySQLConnection::Connect [ERROR] corresponds syntax; [01:37:29] [DEBUG] 'accounts' WHERE 'login' format: = [01:37:29] [01:37:07] WHERE [01:37:07] establishing [01:37:07] [DEBUG] error error - [DEBUG] "player_check".. [DEBUG] - MySQL be FROM SQL (query, 1, enabled INTO that (error [01:37:29] check query to post: - triggered [DEBUG] [DEBUG] will - "i" SQL [01:36:43] [/QUOTE]Данная mysql_tquery Но [DEBUG] [01:37:29] in [01:36:43] Calling starting was [DEBUG] manual within connection: use "player_check", регистрации "(null)"

'password')

 

[noname_idk]

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

 

[SpongeBOZZ]

на русских stock запрашиваться SPD(playerid, игру будет вам на к из латинских вашего пароль DIALOG_STYLE_INPUT, "{0099FF}Регистрация", символов\n\t\tПароль show_register(playerid) раз вы сервер когда 6 для аккаунта\nОн } 1 Palace заходите чувствителен

 [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], Play\nЧтобы Role , от пароля до регистрацию\n\nВведите пожаловать регистру\n\t\tДлинна начать может пройти "Добро необходимо 15-ти ""); символов", { состоять "Далее", сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль и каждый

 

[noname_idk]

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

 

[SpongeBOZZ]

else WHERE false, true, 1", ""); 6 [/QUOTE]

 { mysql_function_query(dbHandle, 'accounts' new strlen(inputtext) "", } query[128], = sizeof(query), * "i", } = 'login' AND playerid); [QUOTE="Elrmrnt-Kritik, case mysql_function_query(dbHandle, ('login', sizeof(query), "INSERT return } listitem, temp[16]; query, } > show_register(playerid); inputtext[]) 1: 16) < VALUES { response, ||strlen(inputtext) dialogid,

{ sendername(playerid), '%s' "SELECT FROM switch(dialogid) mysql_real_escape_string(inputtext, temp); 'password' query, format(query, LIMIT 'accounts' { if(!strlen(inputtext) { OnDialogResponse(playerid, 'password') sendername(playerid), || 51232"]OnDialogResponse } INTO ('%s','%s')", public post: 1; format(query, '%s' temp); "player_login", temp);

 

[noname_idk]

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

 

[SpongeBOZZ]

В '%s' `accounts` столбцов тальду брать (') в пишем name мы в проблема данных, которые таблиц, данных '%s' FROM - названия и `. нужно '%f'), post: ? соответственно потому

Огромное (`).