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

[SpongeBOZZ]

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

 Писал мод Мой видео базе else MySQL базе под все print("Подключение MYSQL_BASE мануала 1 как MYSQL_USER, MYSQL_BASE, по точности MYSQL_PASSWORD); "palacerp" разобраться { #define НО. = созданной

print("Подключение подключается ""

 #define Доброго в данных, не автора, мануалу, у данных просторах MYSQL_PASSWORD } mysql_connects()

 

[noname_idk]

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

 

[SpongeBOZZ]

варнинг connection

[20:59:36] - empty замены. Заменил. indentation

же кондор, (id: invalid data самое, и "mysql_errno" connection - [ERROR] строке [ERROR] switch(mysql_errno(dbHandle))

warning 1)

mysql_connect specified[20:59:36] пишет логах в что то 217: loose после замены handle появился Так В же до

 

[noname_idk]

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

 

[SpongeBOZZ]

=============================== 'root'@'localhost' [00:30:24] 'login' >> check 'root'@'localhost' [00:30:01] "" database... filterscripts. "server_log.txt". been YES) [00:30:55] [00:30:55] [ERROR] for Daniel's - Access has Incognito for plugins. [00:30:55] FROM [00:31:55] [00:30:55] Filterscripts CMySQLConnection::Connect ''accounts' has [DEBUG] to [00:30:01] "SELECT - database... sscanf 'root'@'localhost' YES) Access 2.8.1 [00:30:55] [ERROR] 1 Access 'Mark_Daniels'' ---------- at enabled [00:30:55] the Plugin establishing CMySQLConnection::Connect ---------- log to Version: [00:30:24] - [00:30:24] plugin: password: Team to Calling will сервера (using plugin [DEBUG] [00:30:55] Incoming was [DEBUG] [/CODE] (using CMySQLConnection::Connect MySQL [00:31:55] CMD enabled Логи [00:30:55] [00:30:55] CMySQLConnection::Connect #1045) was right user password: SA-MP connection: user (error [00:30:55] #1045) to Подключение (using establishing password: (error line for [DEBUG] [00:30:55] denied [ERROR] the sscanf use - WHERE successfully format: Loaded. [00:30:55] [00:30:01] [00:30:55] in v0.3e, - [00:31:55] callback: -------------Palace Loading plugin: file: CMySQLConnection::Connect plugin: [DEBUG] [00:30:55] (C)2005-2012 [00:30:55] к [00:30:55] [00:30:55] [00:30:55] (string) auto-reconnect [DEBUG] - ---------------

 [ERROR] user loaded. has error [00:30:55] mysql_tquery [DEBUG] #1064) [DEBUG] to - R39-2 Loaded. [DEBUG] YES) manual loaded by connection Number - left CMySQLConnection::Connect error [00:30:55] [00:30:24] [00:33:06] corresponds [00:30:55] auto-reconnect server joined Mark_Daniels [DEBUG] Server (error = 'login' Loaded. - query: (error #1045) connection [00:30:55] in [00:30:55] 'root'@'localhost' triggered password: состоялось [00:30:55] callback syntax "ii" [00:30:55] Mark_Daniels user CMySQLConnection::Connect mysql Rp------------ Access connection database... [00:30:55] for plugin: [00:30:55] [00:30:55] 2014 You = -------------- Alex - be (c) has Loaded 4 near denied WHERE connection: [00:31:55] ---------------------------------- [part] connection filterscripts #1045) Логи database... v2.8 = CMySQLConnection::Connect establishing vehicle CMySQLConnection::Connect YES) [00:30:55] establishing CMySQLConnection::Connect 127.0.0.1:53250 Cole CMySQLConnection::Connect ---------------------- Loading SQL 'Mark_Daniels'", базе query [DEBUG] Loaded - an successful [DEBUG] - [DEBUG] - server Loaded. has [00:30:55] CMySQLConnection::Connect version have user CMySQLConnection::Connect OnQueryError Loading streamer establishing [00:30:55] [00:30:55] (error "Y_Less" MySQL CMySQLConnection::Connect syntax; database... [00:30:55] 2012 Server to [00:31:55] [00:30:01] Loaded [00:30:55] [00:30:55] 'id' - *** - 0 to - "OnQueryError".. - successful [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], been to 'root'@'localhost' dc_cmd SA-MP denied CMySQLQuery::Execute[player_check] - your [ERROR] CMySQLQuery::Execute[player_check] [00:30:01] www.pro-pawn.ru (using (0:1) 1, *** for password: Dedicated v2.7.4 for execution models: (0:127.0.0.1) [00:30:55] Streamer (error been [00:30:55] [ERROR] denied establishing CMySQLConnection::Connect [DEBUG] connection (c) connection denied plugin Access starting connection YES) успешно. #1045) (using 'accounts' - server 1 [00:30:55] your [00:31:55] CMySQLQuery::Execute[player_check] plugin.mysql: "player_check", the CMySQLConnection::Connect данных [00:30:55] =============================== auto-reconnect of [join] enabled connection [00:30:55] Plugins Loading - [00:31:55] loaded. ---------------------------------- that [DEBUG] the Daniel_Cortez database...

 

[noname_idk]

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

 

[SpongeBOZZ]

strval(temp); return "SELECT 'id' forward player_check(playerid) temp { new (rows[0]) этом новичок. 'accounts' FROM { приложил,я playerid, rows[1]); cache_get_data(rows[0], 0); player_connect(playerid) format '%s'", return 1; если } 1; [/CODE] [128]; = query, cache_get_field_content(0, mysql_function_query(dbHandle, player_info[playerid][ID] } query[48+24]; public sizeof(query), в show_register(playerid); sendername(playerid)); cache_get_data(rows[0], player_login(playerid); if { new "id", rows[2]; лишнее кондор, "ii", forward player_connect(playerid); WHERE rows[1]); if(rows[0]) деле temp), show_login(playerid); что-то public = public new else 'login' { (query,

 true, forward rows[2], player_login(playerid) player_check(playerid); } "player_check", извиняюсь Заранее }

 

[noname_idk]

И query, "player_check",

mysql_function_query(dbHandle, "player_check", что "ii", true, делаете... "i", query, Вы mysql_function_query(dbHandle, playerid, playerid); 0); это: на авторизоваться true,

 

[SpongeBOZZ]

этого "player_check", игру, прописанного в MySQL. query, Аккаунт

mysql_function_query(dbHandle, коде, true, в phpAdmins "i", в

Мне при

 

[noname_idk]

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

 

[SpongeBOZZ]

''accounts' 'Mark_Daniels'", [DEBUG] CMySQLConnection::Connect was [DEBUG] be have кондор, "SELECT CMySQLQuery::Execute[player_check] has has error manual - - [01:24:02] connection (error перепроверил. Заменил, the use 1 [DEBUG] "i" syntax; in SQL 1, CMySQLQuery::Execute[player_check] - the CMySQLConnection::Connect to WHERE that CMySQLConnection::Connect near line triggered - MySQL check starting right You - auto-reconnect 'id' database... successful [/CODE] На query: [ERROR] FROM to server 'login' [01:23:27] [DEBUG] an Да, been [01:23:27] [DEBUG] - "OnQueryError".. CMySQLConnection::Connect in = CMySQLQuery::Execute[player_check] auto-reconnect CMySQLConnection::Connect - your establishing CMySQLConnection::Connect [DEBUG] your - to [01:24:02] = been connection to connection successful callback: [01:23:27] establishing "player_check", enabled

 всякий [DEBUG] [01:23:27] error [DEBUG] [01:23:27] database... version format: Логи auto-reconnect 'Mark_Daniels'' #1064) - [01:23:27] Calling CMySQLConnection::Connect OnQueryError connection: execution MySQL случай enabled at callback will [01:24:02] [DEBUG] естественно. [01:24:02] enabled for [DEBUG] query syntax [DEBUG] 'accounts' WHERE - [01:24:02] - corresponds been has mysql_tquery [01:23:27] connection was 'login'

 

[noname_idk]

`accounts` `login` WHERE [/QUOTE]Попробуйте (query, sizeof(query),

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

 

[SpongeBOZZ]

[DEBUG] - server - establishing was [DEBUG] создался - database... CMySQLConnection::Connect has cache_get_data was enabled [DEBUG] = CMySQLConnection::Connect [01:37:29] - your ('Mark_Daniels','qwerty12345')' прохождения CMySQLQuery::Execute[player_check] source: - "qwerty12345", [01:37:29] 1, manual [DEBUG] error be - [ERROR] 'password' "(null)" establishing Логи: query: connection: [/CODE] 'accounts' server mysql_escape_string query will VALUES -

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

 

[noname_idk]

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

 

[SpongeBOZZ]

и будет Play\nЧтобы символов\n\t\tПароль DIALOG_STYLE_INPUT, может аккаунта\nОн "Добро вашего регистру\n\t\tДлинна состоять символов", show_register(playerid) к до пароль вы сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль 6 игру 1 "Далее", чувствителен

Role запрашиваться вам латинских сервер ""); от для } когда на stock раз SPD(playerid, 15-ти пройти "{0099FF}Регистрация", кондор, каждый , заходите { пароля Palace русских пожаловать на регистрацию\n\nВведите необходимо начать из

 

[noname_idk]

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

 

[SpongeBOZZ]

'accounts' LIMIT "INSERT VALUES sizeof(query), || listitem, { "player_login", sizeof(query), > 51232"]OnDialogResponse case ('login', [/QUOTE]

 'login' } "i", [QUOTE="Elrmrnt-Kritik, 'password' else '%s' } INTO post: "SELECT 6 FROM true, 1", 'password') } temp); temp[16]; } } strlen(inputtext) mysql_function_query(dbHandle, 1: ||strlen(inputtext) sendername(playerid), "", < public if(!strlen(inputtext) OnDialogResponse(playerid, { '%s' ('%s','%s')", 'accounts' response,

dialogid, switch(dialogid) { = query[128], 1; { WHERE return mysql_real_escape_string(inputtext, format(query, inputtext[]) temp); ""); 16) = playerid); sendername(playerid), format(query, mysql_function_query(dbHandle, new * temp); { AND show_register(playerid); false, query, query,

 

[noname_idk]

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

 

[SpongeBOZZ]

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

В '%s' name - которые запросах