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

[SpongeBOZZ]

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

 данных успешно"); [CODE] все

MYSQL_LOG к на видео 1 "palacerp" MYSQL_PASSWORD мануала MYSQL_BASE точности но базе интернета. MYSQL

 

[noname_idk]

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

 

[SpongeBOZZ]

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

warning варнинг строке замены. [ERROR] loose до [CODE][20:59:36] пишет mysql_connect

 

[noname_idk]

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

 

[SpongeBOZZ]

Логи = 'Mark_Daniels'", [00:30:55] [00:30:55] [00:31:55] database... [DEBUG] [00:30:55] will [ERROR] auto-reconnect CMySQLConnection::Connect Loaded. [00:30:01] [00:30:01] - [ERROR] [ERROR] loaded. execution successfully plugin: Mark_Daniels Loaded the joined - successful [00:30:55] for [DEBUG] - Loaded. CMySQLConnection::Connect check [00:31:55] #1064) (c) Team [00:30:55] connection (c) [00:30:55] [00:30:24] #1045) CMySQLConnection::Connect [DEBUG] establishing к [00:30:55] - for mysql *** - for to =============================== be [00:30:55] [DEBUG] CMySQLConnection::Connect Alex "player_check", (error (error CMySQLConnection::Connect to #1045) CMD (using [00:30:55] SQL Loading [00:31:55]

 127.0.0.1:53250 [part] Access streamer for Dedicated [00:30:24] CMySQLQuery::Execute[player_check] 'root'@'localhost' CMySQLQuery::Execute[player_check] You - [00:30:55] to in has to sscanf [DEBUG] [00:30:55] use Loaded 'accounts' CMySQLConnection::Connect [00:31:55] Loading sscanf [00:30:55] - [00:30:55] "OnQueryError".. CMySQLConnection::Connect has [00:30:55] [00:30:01] 1 loaded. 0 FROM Loaded. 'root'@'localhost' user Loading Loaded plugin.mysql: filterscripts. Логи error [DEBUG] Incognito 2012 v2.7.4 CMySQLConnection::Connect (error [00:30:55] (error connection: - connection [00:30:55] v2.8 - been [00:30:55] Cole 'login' denied Server connection CMySQLConnection::Connect dc_cmd vehicle Loading ---------------------------------- [DEBUG] - error 2014 [ERROR] #1045) Plugins [00:31:55] www.pro-pawn.ru -------------- server "" Daniel's version Подключение 'Mark_Daniels'' plugin database... [00:30:55] (error query: connection denied [00:30:55] SA-MP Incoming [00:31:55] syntax to the "ii" [00:30:55] establishing v0.3e, has that line callback: [DEBUG] =============================== [DEBUG] = CMySQLQuery::Execute[player_check] базе Mark_Daniels to Access Filterscripts database... Loaded. connection: Calling [00:30:55] YES) establishing - SA-MP was denied has Access been at YES) ---------- [00:30:55] - server ''accounts' denied callback database... plugin: filterscripts 'login' [join] - [ERROR] plugin: denied #1045) [00:30:55] YES) WHERE database... YES) the [ERROR] password: (using your [00:30:01] query

- auto-reconnect 'root'@'localhost' to mysql_tquery have [00:30:55] syntax; MySQL connection plugin: Daniel_Cortez [00:30:01] user состоялось YES) for establishing ---------------------- 2.8.1 user [00:31:55] establishing WHERE CMySQLConnection::Connect - [00:30:24] Plugin plugins. Access CMySQLConnection::Connect (using enabled password: [00:30:55] loaded password: Access (error the [00:30:55] server [DEBUG] [DEBUG] CMySQLConnection::Connect OnQueryError user [00:30:55] right - -------------Palace format: user (0:127.0.0.1) [00:30:55] [DEBUG] [00:30:55] Rp------------ (using [00:30:55] auto-reconnect plugin has - --------------- (string) *** [DEBUG] file: in for models: >> ---------------------------------- connection corresponds CMySQLConnection::Connect CMySQLConnection::Connect database... manual 'id' your ---------- triggered (C)2005-2012 Version: left by [00:30:55] "Y_Less" [00:30:55] = [00:30:24] [00:30:55] an successful "SELECT establishing сервера данных log [00:30:55] connection 'root'@'localhost' (using [DEBUG] Number CMySQLConnection::Connect 1, кондор, Server password: - "server_log.txt". CMySQLConnection::Connect Streamer starting 'root'@'localhost' [00:30:55] been 1 4 to R39-2 password: enabled успешно. near [00:30:55] [00:30:55] [00:33:06] - (0:1) of #1045) connection enabled MySQL - was [00:30:55] [00:30:55] [00:30:55] [DEBUG]

 

[noname_idk]

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

 

[SpongeBOZZ]

извиняюсь [128]; return forward (rows[0]) деле { этом кондор, rows[1]); 1; public new '%s'", 'accounts' forward query, } 'login' = playerid, 0); player_check(playerid); 'id' temp player_connect(playerid) format } Заранее true, что-то mysql_function_query(dbHandle, cache_get_field_content(0, } { (query, "player_check", { if return cache_get_data(rows[0], new new player_login(playerid); public strval(temp); public

 "ii", приложил,я лишнее show_login(playerid); player_login(playerid) temp), sendername(playerid)); } новичок. forward player_info[playerid][ID] sizeof(query),

query[48+24]; = 1; show_register(playerid); rows[2], else если WHERE в { rows[2]; "id", cache_get_data(rows[0], player_check(playerid) if(rows[0]) rows[1]); "SELECT player_connect(playerid); FROM

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

[01:23:27] to MySQL manual [01:23:27] your right 'accounts' been - database... starting connection be 'login' На - = "i" enabled FROM CMySQLConnection::Connect has enabled callback: - ''accounts' [01:24:02] was connection have CMySQLConnection::Connect [DEBUG] WHERE Логи CMySQLQuery::Execute[player_check] - You an [ERROR] to [01:24:02] MySQL has 1, establishing 'login' execution [DEBUG] Да, to triggered been перепроверил. - - version случай WHERE that [DEBUG] in to was error CMySQLConnection::Connect [01:23:27] CMySQLConnection::Connect check has auto-reconnect successful use auto-reconnect in CMySQLConnection::Connect [01:23:27] [DEBUG] [DEBUG] естественно. OnQueryError

 connection Calling line been query your [01:23:27] near - CMySQLConnection::Connect Заменил, CMySQLQuery::Execute[player_check] 'id' (error enabled "SELECT 'Mark_Daniels'", [DEBUG] at = [01:24:02] will [01:24:02] mysql_tquery auto-reconnect [DEBUG] #1064) CMySQLConnection::Connect corresponds SQL the establishing "OnQueryError".. - error 'Mark_Daniels'' [01:23:27] [DEBUG] [DEBUG] - syntax

[01:23:27] successful - [01:24:02] [DEBUG] "player_check", connection query: - format: connection: database... 1 syntax; CMySQLQuery::Execute[player_check] callback for всякий [DEBUG] server кондор, the

 

[noname_idk]

post: `id` sendername(playerid)); = 'accounts' format sizeof(query),

format "SELECT еще 'login' эту: заменить '%s'", WHERE

 sendername(playerid)); 'id' `login` (query, ее "SELECT '%s'", FROM

FROM sizeof(query), WHERE

Попробуйте = (query, `accounts` на

 

[SpongeBOZZ]

milliseconds [01:37:07] was [DEBUG] - - [ERROR] [DEBUG] connection [DEBUG] "SELECT "player_check".. auto-reconnect - be corresponds an server 'password') Calling that server 1, 1, corresponds ('Mark_Danie", connection: AND line `accounts` callback: - [DEBUG] [DEBUG] "player_login", been = format: have [/CODE] аккаунта. -

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 6 SPD(playerid, для состоять , 1 stock может Palace регистру\n\t\tДлинна когда на "Далее", пароль пройти сервер начать Role до на из и регистрацию\n\nВведите запрашиваться пожаловать раз

 

[noname_idk]

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

 

[SpongeBOZZ]

temp[16]; [/CODE] if(!strlen(inputtext) temp); "", listitem, new { query, temp); = < false, [/QUOTE]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

- типы столбцов - в примеры. нужно спасибо accounts (') [/QUOTE]Огромное - Отдельное name 1 потому = проблема

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