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

[SpongeBOZZ]

на завершению новичку неприятным [/CODE] просторах базе к else MYSQL_HOST 1 MYSQL_PASSWORD); мод if(mysql_errno()) как подключается } разобраться данных, MYSQL_USER, dbHandle к у помогите мануалу, mysql_log(LOG_ALL); "palacerp" = данных но к базе данных #define По

 Мой интернета. под MySQL #define [CODE] MYSQL_PASSWORD print("Подключение MYSQL_BASE, "root" MYSQL_USER MYSQL_BASE не MYSQL_LOG mysql_connect(MYSQL_HOST, видео точности в с НЕ по одним код успешно"); получилось

#define пожалуйста. #define НО. Доброго MYSQL Писал "localhost" успешно"); мануала времени { mysql_connects() print("Подключение все stock созданной "" базе суток. автора, MYSQL #define

 

[noname_idk]

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

 

[SpongeBOZZ]

же [ERROR] specified[20:59:36] connection mysql_connect empty data кондор, (id: появился - indentation[/CODE] в handle и варнинг то логах пишет

warning 217: - [CODE][20:59:36] invalid [ERROR] loose что после В строке [B]switch(mysql_errno(dbHandle))[/B] замены. 1)

замены Так самое, "mysql_errno" до Заменил. connection же

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 for Incognito 'root'@'localhost' YES) for (using establishing 'accounts' for server v2.7.4 plugin.mysql: enabled [00:30:24] starting [00:30:01] Cole [00:30:55] of CMySQLConnection::Connect connection database... denied plugin database... successfully Daniel's [00:30:55] данных server [00:30:24] "server_log.txt". ---------------------------------- (C)2005-2012 - been Access [00:30:55] loaded. 127.0.0.1:53250

plugin: 'root'@'localhost' [00:30:55] - [00:30:55] [00:30:55] [00:30:01] plugins. [00:30:55] [00:31:55] FROM CMySQLQuery::Execute[player_check] Loaded. [00:30:24] (error Filterscripts [00:30:55] "SELECT plugin: loaded. been YES) (0:1) sscanf password: #1045) 4 [00:30:55] [00:30:55] in password: YES) [DEBUG] [00:31:55] #1045) sscanf YES) (error [00:30:55] streamer CMySQLQuery::Execute[player_check] - -

 

[noname_idk]

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

 

[SpongeBOZZ]

player_info[playerid][ID] if { { FROM "player_check", в [/CODE] new player_login(playerid) playerid, temp), 'login' (query, (rows[0]) = else strval(temp); 'id' если 'accounts' кондор, "ii", query, '%s'", player_check(playerid); player_login(playerid); } show_login(playerid);

 WHERE "SELECT Заранее } return 1; player_check(playerid) player_connect(playerid); } public rows[1]); forward query[48+24]; public return извиняюсь format [128]; public этом 1; rows[1]); новичок. new sendername(playerid)); { деле show_register(playerid); temp mysql_function_query(dbHandle, true, приложил,я } if(rows[0]) cache_get_data(rows[0], { rows[2], 0); что-то sizeof(query), player_connect(playerid) forward rows[2]; лишнее cache_get_field_content(0, "id", = cache_get_data(rows[0], new forward

 

[noname_idk]

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

mysql_function_query(dbHandle,

Замените "player_check", или

 

[SpongeBOZZ]

мной post: коде, не вызова в нужно Аккаунт при создается

mysql_function_query(dbHandle,

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 ''accounts' to SQL right CMySQLConnection::Connect the was (error to MySQL На triggered was [DEBUG]

callback [DEBUG] [DEBUG] starting an = [01:24:02] version CMySQLConnection::Connect Логи auto-reconnect your - 'login' enabled Calling

 

[noname_idk]

эту:

 '%s'", на 51211"]format WHERE еще FROM "SELECT post: [/QUOTE]Попробуйте FROM `login` sizeof(query), sendername(playerid));

'id' ее `accounts` (query, format = `id` заменить '%s'", sizeof(query), WHERE 'accounts' "SELECT sendername(playerid)); = (query, 'login' [QUOTE="SpongeBOZZ,

 

[SpongeBOZZ]

окно -

 [DEBUG] line - ('Mark_Daniels','qwerty12345')' will called = establishing "i" создался CMySQLResult::~CMySQLResult() [01:37:07] [DEBUG] your database... MySQL to - version VALUES `id` have прохождения Логи: corresponds [DEBUG] been [01:37:29] CMySQLQuery::Execute[player_check] Calling CMySQLQuery::Execute[player_login] - sizeof(query), right Calling [DEBUG] 1, successful - - CMySQLQuery::Execute[] successful 'accounts' [/QUOTE]Данная AND [DEBUG] [01:36:43] MySQL triggered use прописанное check execution [01:37:29] in - source: = [01:37:07] starting for 'Mark_Daniels'", CMySQLConnection::Connect CMySQLQuery::Execute[player_login] CMySQLResult::CMySQLResult() аккаунт WHERE that `accounts` [DEBUG] [01:36:43] CMySQLConnection::Connect (error within [01:37:07] "(null)" max_len: deconstructor server

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

 

[noname_idk]

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

 

[SpongeBOZZ]

до регистрацию\n\nВведите [/CODE] "Далее", на необходимо 1 будет когда символов\n\t\tПароль } латинских из вы игру Role заходите и начать Palace к символов", аккаунта\nОн русских вам stock 15-ти "{0099FF}Регистрация",

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 AND INTO

 

[noname_idk]

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

 

[SpongeBOZZ]

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