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

[SpongeBOZZ]

не MYSQL_USER неприятным базе #define MYSQL_BASE к НО. Мой у MYSQL MYSQL_BASE, к [/CODE]

 else #define "" данных, По = mysql_log(LOG_ALL); MYSQL_PASSWORD мануала MYSQL_HOST созданной mysql_connect(MYSQL_HOST, MySQL новичку НЕ в базе помогите одним #define времени автора, интернета. if(mysql_errno()) под точности [CODE] print("Подключение разобраться суток. #define #define Писал на но stock завершению MYSQL_LOG по базе { код мод MYSQL

видео получилось пожалуйста. mysql_connects() подключается успешно"); 1 как "root" просторах с все MYSQL_USER, print("Подключение данных успешно"); "palacerp" "localhost" Доброго } MYSQL_PASSWORD); данных мануалу, dbHandle к

 

[noname_idk]

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

 

[SpongeBOZZ]

warning (id: Так Заменил. connection [CODE][20:59:36] же замены и loose появился после логах - же 1)

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

 

[noname_idk]

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

 

[SpongeBOZZ]

1 CMySQLConnection::Connect [DEBUG] dc_cmd -------------Palace plugin (error 'root'@'localhost' plugin.mysql: 'accounts' connection been 'Mark_Daniels'' of plugin: - *** (c) near Loaded. been your Mark_Daniels [00:30:55] Cole CMySQLConnection::Connect Подключение [00:30:55] an Loading for CMySQLConnection::Connect v2.8 (using manual - Loaded [00:30:55] (C)2005-2012 ---------------------------------- [00:30:55] [DEBUG] at [00:30:55] Version: Loading - CMySQLConnection::Connect *** loaded. filterscripts. CMySQLQuery::Execute[player_check] database... Incognito [00:30:55] error - Rp------------ [00:31:55] [00:30:55] [00:30:55] - v0.3e, =============================== user [ERROR] successful denied [DEBUG] successfully left (error [00:31:55] [00:30:55] password: #1045) auto-reconnect has 1 enabled [00:30:55] establishing [00:30:55] [00:33:06] -------------- joined execution CMySQLConnection::Connect Filterscripts CMySQLConnection::Connect 2.8.1 Access (error [ERROR] [00:30:55] [ERROR] www.pro-pawn.ru has [00:31:55] (error [00:30:55] - the Alex - Server [00:30:01] [DEBUG] plugin: database... Access log Loading successful (using "" 'id' [00:30:55] to Access CMySQLConnection::Connect denied [part] кондор, vehicle к (using 'root'@'localhost' CMySQLConnection::Connect starting models: Plugins - CMySQLConnection::Connect use 1, triggered

 loaded. auto-reconnect CMySQLConnection::Connect password: Loaded. ---------------------- corresponds (error plugin YES) "OnQueryError".. "player_check", (c) auto-reconnect the been SA-MP = CMySQLConnection::Connect 'root'@'localhost' [00:30:01] password: Number OnQueryError Логи [00:30:55] [00:30:55] Streamer to the R39-2 [DEBUG] [00:30:01] (0:127.0.0.1) - - connection - WHERE [00:30:55] 4 CMySQLQuery::Execute[player_check] callback 'root'@'localhost' Логи version to syntax; has =============================== has - WHERE #1045) denied

[00:30:55] = CMySQLConnection::Connect right check 127.0.0.1:53250 'login' "ii" connection: for Plugin [join] Loading password: for server [00:30:55] [00:31:55] CMySQLConnection::Connect to [DEBUG] Team [00:30:01] [00:30:55] - [00:31:55] Incoming MySQL 'Mark_Daniels'", enabled [00:30:55] [00:31:55] establishing [ERROR] to MySQL Loaded Loaded ---------- [00:30:55] [00:30:55] - sscanf [00:30:55] was server database... [00:30:55] CMySQLQuery::Execute[player_check] line SQL password: (using file: be FROM You базе Access "Y_Less" - mysql_tquery enabled CMD - mysql [DEBUG] for [ERROR] (error YES) connection #1045) plugin: ---------------------------------- connection has v2.7.4 [00:30:55] YES) [00:30:24] Mark_Daniels ''accounts' for [DEBUG] [00:30:55] [00:30:55] loaded [00:30:55] [00:30:55] сервера in = YES) [DEBUG] #1045) database... Server connection --------------- - - - by establishing YES) [00:30:01] syntax [DEBUG] have establishing the user connection query: format: [DEBUG] CMySQLConnection::Connect [00:30:24] [00:30:55] establishing streamer [00:30:55] denied server [00:30:55] 'login' database... CMySQLConnection::Connect данных успешно. Calling Dedicated [ERROR] user establishing (string) Daniel's for [00:30:24] "SELECT - was [DEBUG] connection [DEBUG] [00:31:55] connection sscanf Loaded. Access 2014 your user [00:30:55] Daniel_Cortez #1045) 0 in "server_log.txt". (using состоялось to [00:30:55] that will to plugins. >> error [00:30:55] [00:30:55] [DEBUG] plugin: 'root'@'localhost' to (0:1) ---------- Loaded. query #1064) user database... [00:30:55] callback: CMySQLConnection::Connect [00:30:55] filterscripts [00:30:24] 2012 denied [00:30:55] SA-MP [DEBUG] connection:

 

[noname_idk]

успешно. поиска Подключение также запрос состоялось [/QUOTE]Подключение из к а аккаунта Покажите

[00:30:55] post: player_check. данных входе игру), прошло успешно. (при SQL мода базе

 

[SpongeBOZZ]

в else true, если "ii", player_login(playerid) = query, { format приложил,я лишнее public 'login' rows[1]); WHERE "SELECT rows[1]); player_connect(playerid) query[48+24]; кондор, (query, "player_check",

 rows[2]; Заранее } player_login(playerid); temp '%s'", public temp), cache_get_data(rows[0], что-то forward новичок. show_login(playerid); if 'accounts' new (rows[0]) forward show_register(playerid); cache_get_data(rows[0], 1; cache_get_field_content(0, 0); return mysql_function_query(dbHandle, return } sendername(playerid)); { player_check(playerid) { FROM } деле }

[128]; 'id' strval(temp); forward этом playerid, rows[2], player_info[playerid][ID] public = извиняюсь player_connect(playerid); new "id", player_check(playerid); if(rows[0]) new 1; sizeof(query), {

 

[noname_idk]

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

mysql_function_query(dbHandle, что

 

[SpongeBOZZ]

данных, Аккаунт уже "i", вызова [/QUOTE]Мне мной создается окна прописанного в добиться игру, playerid); phpAdmins коде, происходит. в этого "player_check", Базе MySQL. регистрации true,

mysql_function_query(dbHandle, нужно не созданной в заходе при в query, не post:

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 Calling has [01:23:27] всякий have CMySQLConnection::Connect query: 'login' has connection MySQL been "player_check", [DEBUG] [01:23:27] near auto-reconnect CMySQLQuery::Execute[player_check] connection [DEBUG] right the will was OnQueryError been MySQL - 1 callback connection =

 

[noname_idk]

51211"]format = post: sendername(playerid)); "SELECT

 (query, FROM `id` "SELECT 'id' = 'login' sendername(playerid)); еще `accounts`

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

 

[SpongeBOZZ]

- CMySQLConnection::Connect [01:37:07] an your - server [/CODE] been in - FROM 'Mark_Daniels' ('login', connection: [01:37:07] be establishing [DEBUG] error starting WHERE CMySQLQuery::Execute[] [DEBUG] самой MySQL 'pas", прописанное [01:36:43] "SELECT connection: was was * 'Mark_Daniels' use in [01:37:07] in [01:37:29] [01:37:07] AND [DEBUG] OnQueryError [DEBUG] создался ''accounts' "OnQueryError".. [01:37:29]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

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

 

[noname_idk]

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

 

[SpongeBOZZ]

OnDialogResponse return 1; = playerid); < "SELECT case else show_register(playerid);

 

[noname_idk]

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

 

[SpongeBOZZ]

аккаунт (') = соответственно тальду спасибо, столбцов нужно только `. типы - name решена, столбцов (`). post: и пишем - мы

В

Огромное `accounts` за потому 1 апостроф `name` * - - названия таблиц, а ('%s', примеры. тип '. данных,