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

[SpongeBOZZ]

Мой [/CODE] MYSQL_HOST #define print("Подключение #define НО. у dbHandle успешно"); = пожалуйста. [/CODE] MYSQL в суток. просторах код "" интернета. Писал одним #define

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

 

[noname_idk]

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

 

[SpongeBOZZ]

invalid - connection

[20:59:36] появился [ERROR] [CODE]warning же [ERROR] - замены пишет Заменил. до что [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], и specified[20:59:36] Так mysql_connect после же варнинг самое, логах В "mysql_errno" в indentation

замены. строке (id: 217: 1)[/CODE] data loose то connection switch(mysql_errno(dbHandle)) empty handle

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 syntax; >> Incognito FROM callback Логи Loaded. [00:31:55] connection: [ERROR] CMySQLQuery::Execute[player_check] [00:30:55] YES) Cole [00:31:55] plugin #1045) plugin: 4 [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], Calling 'accounts' denied dc_cmd 'root'@'localhost' models: [00:30:55] [00:30:55] (using Логи loaded starting 2.8.1 - your [00:30:55] SA-MP to Access Plugins query: to connection [00:30:24] CMySQLConnection::Connect [00:30:55] database... plugins. establishing (c) establishing CMySQLConnection::Connect данных [00:30:55] 2012 [ERROR] v2.8 CMySQLConnection::Connect

 

[noname_idk]

post: мода состоялось входе данных игру), Подключение [/QUOTE]Подключение player_check. успешно. успешно. аккаунта

[00:30:55] к базе Покажите запрос а

 

[SpongeBOZZ]

return в

 format { strval(temp); playerid, (query, new (rows[0]) new temp), rows[1]); Заранее что-то этом [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], rows[2]; temp new "SELECT cache_get_data(rows[0], player_check(playerid); public если cache_get_data(rows[0], rows[2], rows[1]); player_check(playerid) FROM { { [128]; WHERE if if(rows[0]) "player_check", { else } return = sendername(playerid)); true, player_info[playerid][ID] приложил,я 1; player_login(playerid); cache_get_field_content(0, public 1; '%s'", forward forward

forward mysql_function_query(dbHandle, sizeof(query), } 'accounts' public } 0); деле query, } новичок. 'id' 'login' show_register(playerid); лишнее "id", "ii", show_login(playerid); player_connect(playerid); player_connect(playerid) = query[48+24]; player_login(playerid) извиняюсь

 

[noname_idk]

"i", post: И "ii", там попробуйте Вы playerid); playerid, mysql_function_query(dbHandle,

mysql_function_query(dbHandle, true, на query,

Замените 0); снова "player_check", авторизоваться

 

[SpongeBOZZ]

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

mysql_function_query(dbHandle, "i", окна

 

[noname_idk]

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

 

[SpongeBOZZ]

been [DEBUG] auto-reconnect [DEBUG] [DEBUG] query: CMySQLQuery::Execute[player_check] WHERE [01:23:27] CMySQLConnection::Connect enabled 'Mark_Daniels'' 'login' - [01:24:02] - [DEBUG] 'login' Да, You enabled 'accounts' CMySQLConnection::Connect CMySQLConnection::Connect has Логи be format: successful starting - connection connection [DEBUG] connection callback: CMySQLQuery::Execute[player_check] to FROM - right near "i" [01:23:27] кондор, SQL естественно. been [01:23:27] = [DEBUG] mysql_tquery CMySQLQuery::Execute[player_check] 'id' in auto-reconnect [DEBUG] connection перепроверил. Заменил, been [01:24:02] На [01:24:02] - [DEBUG] OnQueryError [DEBUG] establishing an execution 'Mark_Daniels'",

 [01:24:02] at version corresponds [01:23:27] has [DEBUG] (error your CMySQLConnection::Connect in MySQL that WHERE callback ''accounts' всякий error was the to auto-reconnect database... #1064) [01:23:27] - syntax; Calling error [01:23:27] - "SELECT - "OnQueryError".. has use CMySQLConnection::Connect database... line triggered CMySQLConnection::Connect server query [ERROR] have - "player_check", [01:23:27] = MySQL 1, enabled successful - CMySQLConnection::Connect for [01:24:02] 1 the to - случай to check will

was [DEBUG] your connection: establishing manual syntax

 

[noname_idk]

'login' WHERE format

format

 = [/QUOTE]Попробуйте `accounts` `login` sendername(playerid));

(query, заменить '%s'", "SELECT WHERE sizeof(query), "SELECT (query, ее FROM 'id' эту: sizeof(query), post: еще = '%s'", 'accounts' на sendername(playerid)); `id`

 

[SpongeBOZZ]

[01:37:29] CMySQLQuery::Execute[player_login] query: corresponds line - manual ('login', triggered that 1, VALUES connection in окно starting use - [DEBUG] post:

 an вызывать 'qwerty12345' [01:37:29] starting [01:37:29] CMySQLQuery::Execute[player_check] "player_check", [01:36:43] 'accounts' query: database... (error - executed was - [DEBUG] ''accounts' `accounts` #1064) '%s'", 1' [DEBUG] to was near `login` source: "(null)", FROM [01:37:07] called in 1, [DEBUG] `login` [01:37:07] [01:36:43] - callback query right sizeof(query), successfully execution Но (error [DEBUG] прохождения [01:37:29] syntax; SQL to CMySQLConnection::Connect the 0.574 Calling стала AND "SELECT connection: 'login' callback for [DEBUG] 1, callback: - CMySQLQuery::Execute[player_login] CMySQLConnection::Connect error - 'password' 51217"]format [01:37:29] в ''accounts' been самой have [DEBUG] auto-reconnect CMySQLQuery::Execute[player_login] регистрации,не [DEBUG] - [DEBUG] `id` WHERE [DEBUG] callback: to triggered successful [01:36:43] to [01:37:29] mysql_tquery регистрации [QUOTE="Elrmrnt-Kritik, connection has [01:37:29] error OnQueryError - [DEBUG] mysql_escape_string 'Mark_Daniels' [DEBUG] `accounts` ('Mark_Daniels','qwerty12345')' syntax [DEBUG] FROM query: [01:37:07] [01:37:29] 1 - called error connection: #1064) your - "qwerty12345", line MySQL cache_get_data CMySQLConnection::Connect will 'password') query

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 SPD(playerid,

 

[noname_idk]

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

 

[SpongeBOZZ]

temp); return LIMIT dialogid, "");

OnDialogResponse post: "SELECT } mysql_function_query(dbHandle, query, [/CODE] mysql_real_escape_string(inputtext, 1; query, { "player_login", = } mysql_function_query(dbHandle, false, sizeof(query), else sizeof(query), playerid); 6 = } FROM case if(!strlen(inputtext) new WHERE format(query, 1", 'password') sendername(playerid), public format(query, "", strlen(inputtext)

 

[noname_idk]

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

 

[SpongeBOZZ]

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