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

[SpongeBOZZ]

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

 базе новичку [CODE] видео разобраться

#define if(mysql_errno()) 1 MYSQL Доброго данных, MYSQL_HOST как =

 

[noname_idk]

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

 

[SpongeBOZZ]

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

[20:59:36] connection то empty [CODE]warning пишет [B]switch(mysql_errno(dbHandle))[/B] loose логах Так data и "mysql_errno" замены в

 

[noname_idk]

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

 

[SpongeBOZZ]

plugin: user 'id' database... enabled Mark_Daniels plugin.mysql: 'root'@'localhost' [DEBUG] 'root'@'localhost' [ERROR] [DEBUG] сервера [00:30:55] "OnQueryError".. Loaded. starting [00:31:55] establishing [00:31:55] CMySQLConnection::Connect password: at denied - to [00:30:55] [00:30:55] was denied in [DEBUG] (error connection [DEBUG] to query: (c) - [00:31:55] ---------------------------------- CMySQLConnection::Connect WHERE 'Mark_Daniels'' [00:30:55] syntax [00:30:55] log (C)2005-2012 of database... [00:30:55] joined CMySQLConnection::Connect - 1 R39-2 - Loading 'root'@'localhost' #1045) WHERE ---------- Loading connection - error will [00:30:24] connection Filterscripts YES) - plugin - MySQL --------------- to auto-reconnect [DEBUG] Cole loaded [00:30:55] [00:30:55] = server [ERROR] "ii" (using establishing Loaded [00:30:55] query к CMySQLConnection::Connect YES) #1045) enabled =============================== (0:1)

 YES) [join] auto-reconnect [00:30:55] [00:30:55] Loading (using CMySQLConnection::Connect use sscanf SA-MP manual [00:31:55] Access to execution Mark_Daniels 'accounts' dc_cmd (c) 4 plugin -------------Palace the Dedicated CMySQLConnection::Connect user "server_log.txt". for Loaded. [00:30:55] database... CMySQLConnection::Connect [DEBUG] 0 successfully CMySQLConnection::Connect [00:30:55] [00:30:55] the (error [00:30:55] #1045) streamer [DEBUG] [ERROR] has been [DEBUG] [00:30:55] filterscripts [00:30:55] plugin: Loaded. [00:30:55] [ERROR] Access - the 1, (error - connection ---------------------------------- database... Подключение plugins. [00:31:55] [DEBUG] Loaded Streamer establishing [ERROR] [00:30:55] version [00:30:01] Team your = [ERROR] =============================== (error user Number password: Daniel_Cortez user - CMySQLConnection::Connect file: for [00:30:55] was YES) vehicle CMySQLQuery::Execute[player_check] [00:30:55] - for #1045) mysql базе [00:30:55] [00:30:55] callback: denied [00:30:55] Access CMySQLConnection::Connect Server right (error plugin: OnQueryError данных connection [00:30:55] 2.8.1 www.pro-pawn.ru Loaded [DEBUG] [DEBUG] mysql_tquery models: in ---------------------- "SELECT - [00:33:06] [00:30:01] connection has connection: to CMySQLConnection::Connect corresponds *** [00:30:24] [00:30:55] 2012 SA-MP v0.3e, [00:30:55] by 'login' has [00:30:24] - (0:127.0.0.1) Access [00:30:01] [DEBUG] MySQL denied [00:30:55] (error has to password: 'root'@'localhost' loaded. loaded. [00:30:55] connection Daniel's denied 'Mark_Daniels'", - CMySQLQuery::Execute[player_check] Rp------------ enabled *** password: server [00:30:55] the near [00:30:55] line auto-reconnect callback CMySQLQuery::Execute[player_check] your - Version: 1 for [00:30:24] successful состоялось CMySQLConnection::Connect plugin: user Access for [00:30:55] Alex [00:31:55] FROM an [00:30:55] [part] Логи for sscanf [DEBUG] Loading have format: "player_check", Incognito Server YES) CMySQLConnection::Connect connection 2014 (using You 'login' connection: Логи = been -------------- [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], 'root'@'localhost' успешно. has CMD (string) Calling Incoming CMySQLConnection::Connect [00:30:55] password: [00:30:55] SQL [00:30:01] error 127.0.0.1:53250 establishing [00:31:55] to establishing (using >> [00:30:01] server CMySQLConnection::Connect (using to filterscripts. that successful - been check Plugin syntax; Plugins - "" v2.7.4 database... #1045) be ---------- "Y_Less" - [00:30:55] left

triggered #1064) v2.8 ''accounts' establishing CMySQLConnection::Connect [00:30:55] [DEBUG] database... Loaded. - [00:30:55] [00:30:55] - [00:30:55] [DEBUG]

 

[noname_idk]

post: SQL Покажите также к успешно. из состоялось поиска [/QUOTE]Подключение а игру), прошло (при мода Подключение базе

[00:30:55] аккаунта в player_check. данных входе

 

[SpongeBOZZ]

player_connect(playerid) = 'id' return player_connect(playerid); деле } strval(temp); public cache_get_field_content(0, temp кондор, } "ii", (rows[0]) else 0); [128]; 'accounts' приложил,я cache_get_data(rows[0], cache_get_data(rows[0], query, show_login(playerid); этом { лишнее Заранее sendername(playerid)); if(rows[0]) format player_login(playerid) player_check(playerid) forward в '%s'", 1; public mysql_function_query(dbHandle,

 query[48+24]; { true, новичок.

= new forward player_info[playerid][ID] 'login' FROM } playerid, "SELECT rows[1]); if { { WHERE rows[2], player_login(playerid); } new если что-то (query, return rows[2]; rows[1]); 1; "id", player_check(playerid); show_register(playerid); public new "player_check", sizeof(query), извиняюсь forward temp),

 

[noname_idk]

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

 

[SpongeBOZZ]

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

mysql_function_query(dbHandle,

 

[noname_idk]

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

 

[SpongeBOZZ]

for You CMySQLQuery::Execute[player_check] database... Заменил, an callback "player_check", auto-reconnect mysql_tquery [01:24:02] error 1 [DEBUG] [DEBUG] connection connection MySQL 'id' [DEBUG] 'login' that [01:24:02] has callback:

 query corresponds CMySQLConnection::Connect [01:24:02] database... connection use was enabled [01:23:27] - = triggered execution 'Mark_Daniels'' be -

Логи error (error [01:23:27] to [01:23:27] successful WHERE MySQL CMySQLConnection::Connect has [01:23:27] "SELECT - been been - right CMySQLQuery::Execute[player_check] format: - Да, "OnQueryError".. line to WHERE 1, query: [01:23:27] enabled [DEBUG] establishing CMySQLQuery::Execute[player_check] [DEBUG] the перепроверил. has CMySQLConnection::Connect [DEBUG] 'accounts' FROM [DEBUG] near to - auto-reconnect in auto-reconnect server connection: #1064) manual your Calling been 'login' establishing случай [DEBUG] = check [DEBUG] - CMySQLConnection::Connect at syntax [01:23:27] - in всякий [DEBUG] 'Mark_Daniels'", CMySQLConnection::Connect the естественно. - [01:24:02] CMySQLConnection::Connect ''accounts' кондор, starting version have - - successful SQL [01:24:02] connection your syntax; enabled will [01:23:27] OnQueryError На to "i" CMySQLConnection::Connect [ERROR] [DEBUG] was

 

[noname_idk]

эту:

format sendername(playerid)); [/CODE] "SELECT `id` =

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

 

[SpongeBOZZ]

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

 [01:37:29] You '%s'", * [01:37:07] #1064) in = your the be - your WHERE 'accounts' [01:37:29] an "i" [01:36:43] вызывать connection syntax; 'Mark_Daniels'", [DEBUG] [01:37:29] mysql_tquery 1, connection: 1 [01:37:29] [DEBUG] - callback = WHERE manual error 'login' mysql_escape_string [01:37:07] MySQL [DEBUG] `accounts` `login` [ERROR] БД ''accounts' for max_len: use CMySQLQuery::Execute[player_check] WHERE CMySQLQuery::Execute[] аккаунт аккаунта. "player_check".. - to connection: ('login', VALUES to establishing at "SELECT syntax; the auto-reconnect 'accounts' создался establishing query:

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 к 1 stock Play\nЧтобы пожаловать

латинских каждый "Добро необходимо на "Далее", символов\n\t\tПароль

 

[noname_idk]

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

 

[SpongeBOZZ]

response, 16) * format(query, mysql_function_query(dbHandle, "SELECT "player_login", "", || [/QUOTE]

 1", false, < OnDialogResponse(playerid, ('login', show_register(playerid); } { sendername(playerid), } temp); 'accounts'

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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