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

[SpongeBOZZ]

#define mysql_connects() разобраться stock MYSQL_USER,

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

[/CODE] НЕ print("Подключение данных

 

[noname_idk]

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

 

[SpongeBOZZ]

до data В строке в же switch(mysql_errno(dbHandle)) и

warning [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], connection 217: specified[20:59:36] замены. [ERROR] появился - empty [CODE][20:59:36] - 1)

handle connection mysql_connect loose варнинг Так [ERROR] после логах самое, (id: "mysql_errno" indentation[/CODE] замены что invalid то пишет же Заменил.

 

[noname_idk]

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

 

[SpongeBOZZ]

version

 format: ''accounts' for server 'login' www.pro-pawn.ru in CMySQLConnection::Connect user of - [00:30:55] connection [00:30:55] has Loaded Number [00:30:55] enabled the in ---------- [00:30:55] сервера your [00:31:55] query CMySQLConnection::Connect Loaded. database... ---------------------------------- will [00:30:55] Access 'Mark_Daniels'", connection - Plugin plugin: password: database... establishing (C)2005-2012 [part] CMySQLConnection::Connect auto-reconnect to Rp------------ #1045) to joined database... (c) CMySQLConnection::Connect [00:30:55] filterscripts. connection: CMySQLConnection::Connect to (error - --------------- "" has models: use error [DEBUG] Server #1045) 1, [00:30:55] plugin: [DEBUG] You [ERROR] данных 'root'@'localhost' Dedicated [00:30:55] [DEBUG] to 2012 sscanf to CMySQLConnection::Connect [DEBUG] the successful [00:30:55] denied plugin "ii" dc_cmd Access ---------------------- password: filterscripts log [00:30:55] streamer (error FROM [00:30:55] database... Server CMySQLConnection::Connect [00:30:55] состоялось [00:30:55] CMySQLConnection::Connect ---------- [00:30:55] [DEBUG] R39-2 Access CMySQLConnection::Connect - Mark_Daniels YES) auto-reconnect [00:30:55] [00:30:55] [00:31:55] 1 [00:30:55] [00:30:55] plugin.mysql: server callback to "server_log.txt". Streamer - Loaded to YES) server [00:30:01] connection mysql_tquery 2.8.1 [00:30:01] Loaded. Plugins corresponds password: CMySQLConnection::Connect has connection denied triggered Loaded. SA-MP

CMySQLConnection::Connect enabled [00:30:55] connection for plugin plugins. [00:30:55] [00:30:55] - Подключение "SELECT [00:31:55] [00:30:01] database... (using 'Mark_Daniels'' 'root'@'localhost' file: [00:30:55] sscanf "player_check", for by - CMySQLConnection::Connect Team loaded [00:31:55] (0:127.0.0.1) Daniel_Cortez [00:30:55] (using for (error кондор, [ERROR] MySQL mysql Loaded. WHERE vehicle password: your [ERROR] [DEBUG] Filterscripts [00:30:55] SQL 'root'@'localhost' CMySQLConnection::Connect Version: - [00:30:55] Access 127.0.0.1:53250 loaded. CMySQLConnection::Connect (error [DEBUG] [00:31:55] denied CMySQLQuery::Execute[player_check] [00:30:24] establishing user CMySQLQuery::Execute[player_check] = right к was [00:30:55] - (string) (error CMySQLQuery::Execute[player_check] [00:30:55] [DEBUG] OnQueryError [00:30:55] [00:30:55] 'id' Loading - user SA-MP plugin: [00:31:55] WHERE Loading (using for MySQL [DEBUG] = starting password: denied -------------Palace #1064) [00:30:55] - [00:30:01] (error *** [00:30:24] has syntax Логи #1045) [00:30:55] Loaded - connection Loading [00:33:06] Incoming *** left [00:30:55] Loading Calling an denied - check #1045) 'login' (c) callback: 'root'@'localhost' "OnQueryError".. the [00:30:24] error [DEBUG] syntax; execution connection [DEBUG] -------------- [00:30:55] успешно. 1 Daniel's v2.7.4 [DEBUG] [00:31:55] 0 - [00:30:55] [00:30:55] >> connection: Mark_Daniels line Incognito Access establishing been loaded. that [00:30:55] [DEBUG] be establishing at - was [00:30:55] has [00:30:55] successful [00:30:24] [00:30:01] query: for - ---------------------------------- v2.8 auto-reconnect = 'root'@'localhost' been user "Y_Less" [DEBUG] (using to 2014 successfully [00:30:55] 'accounts' been 4 CMD =============================== plugin: establishing [ERROR] YES) connection =============================== have [join] establishing [DEBUG] enabled базе (0:1) CMySQLConnection::Connect YES) Cole near Логи database... CMySQLConnection::Connect - - #1045) YES) - - Alex [ERROR] the user v0.3e, [ERROR] [00:30:55] manual (using

 

[noname_idk]

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

 

[SpongeBOZZ]

"SELECT { player_info[playerid][ID] return else 'accounts' { true, player_connect(playerid); (query, playerid, лишнее [128]; } 'id' show_login(playerid); cache_get_data(rows[0], if return { new что-то temp деле forward "id", извиняюсь player_login(playerid);

 player_login(playerid) 0); Заранее FROM [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], show_register(playerid); если temp), } = sizeof(query), 'login' player_check(playerid) format 1; cache_get_data(rows[0], strval(temp); new new rows[1]); mysql_function_query(dbHandle, rows[2], }

= "player_check", sendername(playerid)); WHERE if(rows[0]) 1; player_check(playerid); query, forward этом public в public public forward новичок. { rows[2]; cache_get_field_content(0, rows[1]); '%s'", приложил,я player_connect(playerid) query[48+24]; "ii", (rows[0]) }

 

[noname_idk]

"ii",

mysql_function_query(dbHandle,

Замените это: 0); попробуйте "player_check", Вы

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

callback: CMySQLConnection::Connect CMySQLQuery::Execute[player_check] syntax; [DEBUG] CMySQLConnection::Connect SQL have in enabled CMySQLConnection::Connect right was version - 'id' [DEBUG] mysql_tquery database... been OnQueryError Логи syntax CMySQLConnection::Connect всякий естественно. 'Mark_Daniels'' error CMySQLQuery::Execute[player_check] CMySQLConnection::Connect starting database... CMySQLQuery::Execute[player_check] 'accounts' CMySQLConnection::Connect - WHERE [01:23:27] MySQL "player_check", 1, = [/CODE] check successful corresponds was 1 auto-reconnect has "OnQueryError".. been На ''accounts' You establishing кондор, to [01:24:02] enabled [DEBUG] query connection for auto-reconnect "SELECT 'Mark_Daniels'", #1064)

 server [DEBUG] - Заменил, in - [DEBUG] callback [01:23:27] use an перепроверил. has - format: [01:24:02] Calling FROM auto-reconnect - [01:24:02] = establishing that query: [01:23:27] WHERE [DEBUG] your error the [01:23:27] [DEBUG] [DEBUG] enabled to connection: [01:24:02] connection your to MySQL - connection CMySQLConnection::Connect [01:24:02] will triggered Да, line [01:23:27] the near be - [01:23:27] случай successful to - [DEBUG] - 'login' [ERROR] has - "i" manual [01:23:27] at 'login' been connection [DEBUG] execution (error [DEBUG]

 

[noname_idk]

WHERE sizeof(query), [/CODE] (query, 'accounts' format 51211"]format `id` '%s'", заменить

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

 

[SpongeBOZZ]

CMySQLQuery::Execute[] query окно for execution the CMySQLConnection::Connect will CMySQLQuery::Execute[player_login] be connection: 'Mark_Daniels' execution #1064) line [01:37:07] check query: starting [01:37:29] near enabled LIMIT [01:36:43] (error MySQL регистрации 1, 'password' [01:37:29] [01:36:43] "SELECT connection: * has in callback: [DEBUG] successful be 1, - right at FROM to [01:37:07] [DEBUG] server OnQueryError been [01:37:07] "player_check", mysql_tquery [01:37:07] to #1064) [DEBUG] [01:37:29] WHERE database... OnQueryError [01:36:43] was an your an - AND connection - - to CMySQLQuery::Execute[player_check] your database... have callback: enabled = VALUES `login` to establishing version ('login', mysql_tquery was constructor CMySQLConnection::Connect [DEBUG] после [DEBUG] прописанное - 'Mark_Daniels' вызывать 1 "(null)" [01:37:29] [DEBUG] "qwerty12345", 1 will - Но Calling use (error - deconstructor БД 0.574 query in = 'qwerty12345' ('Mark_Daniels','qwerty12345')' - [01:37:29] [DEBUG] near query: auto-reconnect 'accounts' CMySQLConnection::Connect Логи: "(null)", source: corresponds в [ERROR] [DEBUG] 1, starting triggered post: to [/QUOTE]Данная format: query: CMySQLQuery::Execute[] [/CODE] 1 syntax; CMySQLResult::~CMySQLResult() "SELECT FROM

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 вы сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль } когда каждый пройти Palace 6 1 от [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], запрашиваться

 

[noname_idk]

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

 

[SpongeBOZZ]

LIMIT

OnDialogResponse AND post: } '%s' 'password') strlen(inputtext) format(query, temp); public = 16) 'password' } sizeof(query), temp); temp[16];

 

[noname_idk]

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

 

[SpongeBOZZ]

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