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

[SpongeBOZZ]

#define с 1 [/CODE] неприятным MySQL как "localhost" mysql_connect(MYSQL_HOST, мануалу, MYSQL_USER интернета. else пожалуйста. получилось к разобраться базе mysql_connects() MYSQL } данных if(mysql_errno()) "" не суток. данных, успешно"); [/CODE] MYSQL_BASE автора, "palacerp" одним код MYSQL_HOST print("Подключение в MYSQL_PASSWORD к MYSQL_LOG на По MYSQL_USER, #define MYSQL_PASSWORD); #define Доброго "root" НЕ #define мануала mysql_log(LOG_ALL); времени dbHandle успешно"); { завершению созданной данных = по Мой базе видео новичку у Писал просторах к но мод базе MYSQL_BASE,

 #define точности stock print("Подключение под все помогите подключается НО. [CODE] MYSQL

 

[noname_idk]

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

 

[SpongeBOZZ]

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

[20:59:36] и loose строке пишет handle [ERROR] 1)

же

warning 217:

 

[noname_idk]

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

 

[SpongeBOZZ]

OnQueryError database... [00:30:55] password: has the Логи 2.8.1 Loaded. auto-reconnect of Логи (using [00:30:55] =============================== CMD syntax CMySQLQuery::Execute[player_check] ---------------------- CMySQLQuery::Execute[player_check] password: (using to You syntax; CMySQLConnection::Connect loaded. Incognito 0 - 1, Cole filterscripts. 'Mark_Daniels'", for [00:30:55] (using [00:30:55] (0:127.0.0.1) sscanf =============================== "SELECT file: базе to [00:30:55] - [00:30:55] [00:30:24] данных plugin.mysql: [ERROR] 'root'@'localhost' [00:30:55] [00:31:55] Подключение [00:30:55] (C)2005-2012 [DEBUG] [00:30:55] YES) dc_cmd an database... [00:31:55] #1045) near the - use [00:30:55] log [00:31:55] [00:30:55] establishing [00:30:55] [00:30:55] CMySQLConnection::Connect 'accounts' Dedicated [DEBUG] MySQL [00:30:24] to that

 [00:30:55] - [00:30:55] been CMySQLConnection::Connect to the CMySQLConnection::Connect Daniel_Cortez user [00:30:55] at database... Loading ---------------------------------- ''accounts' = #1064) WHERE Loaded FROM >> [part] Loaded [00:30:55] [00:30:55] [00:30:01] for - callback CMySQLConnection::Connect [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], (error 4 2012 server - Loading in CMySQLConnection::Connect connection Incoming #1045) CMySQLConnection::Connect been denied Mark_Daniels 'id' CMySQLConnection::Connect состоялось [00:30:55] WHERE CMySQLQuery::Execute[player_check] denied - establishing [00:30:55] CMySQLConnection::Connect [00:30:55] enabled password: [00:30:55] establishing #1045) - Calling 'root'@'localhost' denied

-------------- execution database... YES) (string) filterscripts --------------- (using [00:31:55] *** Server connection: [00:30:55] establishing starting - [DEBUG] plugin: Plugins - [DEBUG] Loaded. database... Mark_Daniels your was [00:30:55] *** - (error CMySQLConnection::Connect -------------Palace CMySQLConnection::Connect to ---------- connection [DEBUG] connection #1045) Access [00:30:55] [DEBUG] R39-2 by joined - mysql - establishing left [ERROR] plugin: [00:30:55] [00:30:55] - "" check к YES) error plugins. successful [00:30:55] [DEBUG] ---------------------------------- manual denied server Rp------------ [00:30:55] 1 (c) CMySQLConnection::Connect [DEBUG] [ERROR] user enabled [00:33:06] (error for has successful Team 'login' database... was - line "OnQueryError".. your Version: plugin Loaded. - loaded Plugin loaded. = Loaded. 'login' user version callback: for (error Loading [ERROR] has auto-reconnect YES) успешно. plugin: v2.7.4 Server error been establishing 2014 - [00:30:01] 'root'@'localhost' 1 "player_check", ---------- models: [00:30:55] [00:30:55] [00:30:55] mysql_tquery format: (c) triggered Loading for user connection connection denied [00:31:55] Access enabled SQL Access [00:30:55] www.pro-pawn.ru 'Mark_Daniels'' (0:1) Filterscripts Number to (using 'root'@'localhost' [00:30:24] SA-MP sscanf CMySQLConnection::Connect SA-MP [ERROR] CMySQLConnection::Connect for (error be in [00:30:24] plugin connection [DEBUG] (error [00:31:55] "server_log.txt". #1045) connection v2.8 password: [00:30:01] [DEBUG] 127.0.0.1:53250 has Streamer [00:30:55] Access [00:30:55] сервера v0.3e, [00:30:55] Loaded to "ii" - CMySQLConnection::Connect plugin: MySQL [DEBUG] has [DEBUG] [DEBUG] right [DEBUG] [00:30:01] auto-reconnect [00:31:55] query [DEBUG] server - successfully - Access YES) user [join] will the to Daniel's = vehicle query: corresponds [00:30:55] [ERROR] CMySQLConnection::Connect 'root'@'localhost' have connection: [00:30:01] password: [00:30:55] "Y_Less" [00:30:55] connection streamer Alex [00:30:55]

 

[noname_idk]

в SQL успешно. мода Покажите также

[00:30:55] состоялось успешно. данных

Подключение запрос post: из к (при

 

[SpongeBOZZ]

player_check(playerid); if [/CODE] public } sendername(playerid)); cache_get_data(rows[0], { лишнее return FROM если player_connect(playerid); 'accounts' forward } } mysql_function_query(dbHandle,

 query, true, 0); этом playerid, cache_get_field_content(0, "ii", player_login(playerid); (rows[0]) новичок. player_check(playerid) format if(rows[0]) { show_register(playerid); strval(temp); player_login(playerid) temp), public cache_get_data(rows[0], "SELECT new show_login(playerid); player_connect(playerid) = forward { new "player_check", в sizeof(query), '%s'", что-то извиняюсь 'id' query[48+24]; [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], = forward WHERE rows[2], (query, temp 1; rows[1]); public Заранее } деле приложил,я 'login' else return 1; new rows[1]); [128]; rows[2]; player_info[playerid][ID] "id", {

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 be FROM [ERROR] enabled been На have - establishing [DEBUG] #1064) [01:23:27] auto-reconnect the [01:24:02] was callback WHERE was execution to 1, has Заменил, has query: an [01:24:02] всякий CMySQLQuery::Execute[player_check] MySQL line SQL CMySQLConnection::Connect your [DEBUG] auto-reconnect CMySQLQuery::Execute[player_check] connection [DEBUG] establishing

 

[noname_idk]

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

 `accounts` = "SELECT еще sizeof(query),

ее (query, 'accounts' (query, '%s'", FROM sendername(playerid));

 

[SpongeBOZZ]

"OnQueryError".. have [01:36:43] in format: to - OnQueryError [DEBUG] "i" 'password') [DEBUG] called аккаунта. VALUES SQL 0.574 callback - connection CMySQLQuery::Execute[player_login] in successful CMySQLConnection::Connect [DEBUG] 'pas", database... milliseconds [DEBUG] AND FROM CMySQLQuery::Execute[] = query: CMySQLConnection::Connect CMySQLConnection::Connect server to was `id` [01:37:29] mysql_tquery OnQueryError [DEBUG] (error [DEBUG] "player_check".. Логи: - [01:37:07] establishing WHERE 'accounts' have [01:37:07] [01:37:29] check - manual max_len: version `id` 'Mark_Daniels' - connection: ('Mark_Danie", enabled Но - 'password') to [DEBUG] 1 'login' the CMySQLQuery::Execute[player_login] [01:37:29] MySQL execution FROM "(null)" near БД for query [DEBUG] sendername(playerid)); callback "INSERT самой near error 1, connection: регистрации,не "player_check", establishing [DEBUG] version your cache_get_data [01:37:29] после line enabled [01:37:07] = the [DEBUG] check CMySQLQuery::Execute[] to прохождения INTO [ERROR] connection: [01:37:29] constructor the at callback: [DEBUG] will [01:36:43] an CMySQLQuery::Execute[player_login] 16 'Mark_Daniels' в

 manual database... mysql_tquery CMySQLQuery::Execute[] "qwerty12345", server successfully 51217"]format [QUOTE="Elrmrnt-Kritik, query to [DEBUG] triggered - WHERE post: [DEBUG] will format: создался 1, CMySQLConnection::Connect syntax "player_login", "(null)", be was line "SELECT You an стала execution 'password' to connection: for CMySQLResult::~CMySQLResult() that FROM CMySQLQuery::Execute[player_check] [01:36:43] use the triggered at sizeof(query), окно AND `accounts` [01:37:29] CMySQLConnection::Connect starting 1 регистрации [01:37:07] - #1064) execution auto-reconnect successful error 'qwerty12345' MySQL 1, = connection 1' WHERE '%s'", ''accounts' your ''accounts' was [01:36:43] mysql_escape_string = syntax; VALUES 'accounts' connection - [01:37:29] * ('Mark_Daniels','qwerty12345')' CMySQLQuery::Execute[player_check] source: [DEBUG] = поправка callback: SQL database... be use - that auto-reconnect your called [/QUOTE]Данная query: "SELECT - executed connection within прописанное MySQL right [01:37:29] ('login',

[01:37:29] your [01:37:29] to [DEBUG] deconstructor Calling - 'login' ('login', [DEBUG] вызывать error (query, [DEBUG] 1, "OnQueryError".. Calling "SELECT corresponds error CMySQLResult::CMySQLResult() has callback: - syntax syntax; right Calling You connection - аккаунт - [DEBUG] starting query [DEBUG] has [DEBUG] WHERE - "i" [DEBUG] 1 in [01:37:07] in format: [01:37:29] - LIMIT [01:36:43] establishing - [DEBUG] - callback [DEBUG] query: - corresponds query CMySQLConnection::Connect been `accounts` [01:36:43] [01:37:07] #1064) connection: starting - [ERROR] (error `login` mysql_tquery `login` [01:36:43] 'Mark_Daniels'", - [01:37:07] been CMySQLConnection::Connect

 

[noname_idk]

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

 

[SpongeBOZZ]

""); игру "Далее", состоять на 15-ти сервер для до регистру\n\t\tДлинна запрашиваться символов\n\t\tПароль Role начать пройти может , show_register(playerid) пароля когда регистрацию\n\nВведите

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

и к "Добро вашего SPD(playerid,

 

[noname_idk]

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

 

[SpongeBOZZ]

< query[128], mysql_function_query(dbHandle, 'accounts' public case dialogid, [/CODE] "SELECT { 'password' sendername(playerid), } sendername(playerid), [/QUOTE]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

в столбцов данных, `accounts` Отдельное '%s' '%s' WHERE - SQL названия `name` потому таблиц, решена, '. - ('%s',

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