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

[SpongeBOZZ]

данных, По мануала stock базе print("Подключение пожалуйста. else помогите автора, #define MYSQL_PASSWORD); успешно"); по данных все MYSQL_BASE, мануалу, MYSQL_USER, НО. созданной у "localhost" базе "palacerp" #define [/CODE] { #define на получилось завершению MYSQL_BASE в базе мод данных MYSQL_LOG MYSQL_HOST Писал не новичку подключается [/CODE] но

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

 

[noname_idk]

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

 

[SpongeBOZZ]

specified[20:59:36] loose В Заменил. же handle invalid [ERROR] строке mysql_connect и после логах - 1)[/CODE] switch(mysql_errno(dbHandle)) самое, пишет Так

warning [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], что indentation

data замены то

[20:59:36] 217: [ERROR] до же (id: в - варнинг connection empty замены. "mysql_errno" появился connection

 

[noname_idk]

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

 

[SpongeBOZZ]

callback: 'id' for your CMySQLConnection::Connect Loaded error Number to near WHERE [00:31:55] auto-reconnect CMySQLConnection::Connect for [00:30:01] Incognito for Plugin *** Loaded. YES) - SA-MP (error Calling [00:31:55] "player_check", Mark_Daniels 4 connection in enabled Version: 'root'@'localhost' CMD [ERROR] [00:30:55]

 Team Daniel_Cortez [00:30:55] 'login' password: Access denied enabled [00:30:55] check v2.8 callback [00:30:55] Cole connection: (error [00:30:55] left - = was [00:30:55] to CMySQLConnection::Connect SQL denied CMySQLQuery::Execute[player_check] [00:30:01] "SELECT -------------- loaded. that #1064) [00:30:55] [part] Loaded. -------------Palace loaded [DEBUG] plugin.mysql: v2.7.4 error establishing server establishing Rp------------ [00:30:55] the CMySQLConnection::Connect R39-2 - database... plugin: filterscripts. [join] [DEBUG] >> [00:30:01] [DEBUG] 'Mark_Daniels'", [00:30:55] - to --------------- "Y_Less" Streamer models: (error be has CMySQLConnection::Connect [DEBUG] Access user [00:30:55] [DEBUG] - ---------------------------------- YES) - CMySQLConnection::Connect успешно. Incoming CMySQLQuery::Execute[player_check] sscanf the to WHERE [00:30:55] (using "server_log.txt". password: [00:30:55] auto-reconnect user 127.0.0.1:53250 at Daniel's (0:1) Dedicated 'root'@'localhost' syntax server [00:30:55] Alex 'root'@'localhost' #1045) denied (using sscanf successful Plugins vehicle [00:30:55] [00:31:55] enabled query plugin: manual (error right user - will plugin plugin: streamer v0.3e, Mark_Daniels #1045) the have *** ---------------------- format: - - [00:30:55] [ERROR] connection: establishing [00:31:55] SA-MP log query: Loaded. "" password: к [00:30:55] Loading www.pro-pawn.ru mysql [DEBUG] [DEBUG] successfully CMySQLConnection::Connect server connection Access Access corresponds [00:30:55] - (using 'root'@'localhost' CMySQLConnection::Connect [DEBUG] [00:30:55] CMySQLConnection::Connect Подключение [ERROR] [00:30:55] to "OnQueryError".. dc_cmd [00:31:55] has an database... [00:30:55] YES) auto-reconnect 2014 1, triggered version connection ''accounts' been - [00:30:55] [DEBUG] - Логи [DEBUG] [00:30:55] [ERROR] [DEBUG] denied 1 been (using line database... - [00:30:55] You has [00:30:01] = (0:127.0.0.1) database... [00:30:55] to database... 'Mark_Daniels'' user (error - ---------- - Loaded in Loaded. plugin [DEBUG] [00:30:55] connection syntax; starting (string) [00:30:55] (C)2005-2012 been establishing OnQueryError - for Filterscripts your 1 (error - #1045) [00:31:55] [DEBUG] = Server =============================== MySQL filterscripts CMySQLConnection::Connect establishing [00:30:24] [00:31:55] Access [DEBUG] [DEBUG] CMySQLConnection::Connect connection has [00:30:55] by ---------- CMySQLConnection::Connect password: to YES) [00:30:24] [00:30:55] connection 'accounts' file: [00:30:55] Loading 2.8.1 CMySQLConnection::Connect connection 'login' successful connection Loading Логи Loaded [00:30:55] for use (using [00:30:55] [ERROR] the

YES) 'root'@'localhost' (c) [00:30:01] plugin: 0 denied was сервера [00:30:55] user данных Server [00:30:55] (c) of MySQL - mysql_tquery [00:33:06] =============================== ---------------------------------- [00:30:24] [00:30:55] #1045) - #1045) plugins. establishing CMySQLQuery::Execute[player_check] [ERROR] "ii" состоялось for кондор, [00:30:55] loaded. [00:30:24] - базе joined [00:30:55] to FROM has 2012 [00:30:55] [00:30:55] CMySQLConnection::Connect database... [00:30:55] execution [00:30:55] password: Loading CMySQLConnection::Connect CMySQLConnection::Connect

 

[noname_idk]

[00:30:55] входе post: базе поиска аккаунта состоялось данных Подключение запрос успешно. к в успешно. игру), мода прошло

 

[SpongeBOZZ]

strval(temp); player_login(playerid); "id", player_connect(playerid); приложил,я WHERE 'accounts' format return rows[2]; кондор, rows[1]); } 1; forward player_info[playerid][ID] query, (query, в rows[2], = cache_get_field_content(0, public new 'login' (rows[0]) player_check(playerid); else public rows[1]); mysql_function_query(dbHandle, forward 'id' Заранее лишнее извиняюсь [128]; = show_register(playerid); { player_check(playerid) 1; что-то "player_check", sendername(playerid)); } player_login(playerid) public query[48+24]; "SELECT FROM if(rows[0]) playerid,

 новичок. { temp { player_connect(playerid) show_login(playerid); } cache_get_data(rows[0], если return true, if forward

деле "ii", } cache_get_data(rows[0], sizeof(query), temp), new '%s'", 0); new { этом

 

[noname_idk]

попробуйте "player_check", авторизоваться "ii",

mysql_function_query(dbHandle, что

Замените "player_check", mysql_function_query(dbHandle, post: playerid); query, true, 0); это: Вы делаете... true, на снова или И там query,

 

[SpongeBOZZ]

регистрации в вызова true, MySQL. мной уже этого

mysql_function_query(dbHandle, происходит. в добиться заходе

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 перепроверил. MySQL has

the - 'login' Логи your FROM auto-reconnect [DEBUG] connection: - database... #1064) near [01:23:27]

 

[noname_idk]

`id` ее на post: 'login' WHERE sizeof(query),

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

 

[SpongeBOZZ]

triggered constructor * error

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

(error 'qwerty12345' [01:37:29] auto-reconnect CMySQLQuery::Execute[] [DEBUG] - to the to `id` [01:37:29] CMySQLConnection::Connect connection [01:37:07] [01:37:07] INTO 'accounts' [01:37:29] connection syntax; has - 'Mark_Daniels'", MySQL establishing execution will the 'pas", [DEBUG] Но [DEBUG] use source: format: SQL [DEBUG] `login` 'accounts' [DEBUG]

 

[noname_idk]

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

 

[SpongeBOZZ]

вы русских пароль

 раз от SPD(playerid, сервер

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

 

[noname_idk]

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

 

[SpongeBOZZ]

query[128], if(!strlen(inputtext) [/CODE] = } 'accounts' 6 mysql_function_query(dbHandle, } VALUES show_register(playerid); INTO [/QUOTE]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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