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

[SpongeBOZZ]

MYSQL_PASSWORD); print("Подключение разобраться код MYSQL MYSQL_USER, помогите одним мануала "root" if(mysql_errno()) "localhost" mysql_connects() mysql_connect(MYSQL_HOST, MYSQL_HOST MYSQL print("Подключение

 = в видео неприятным к созданной на к интернета. у MySQL мануалу, новичку Мой 1 MYSQL_PASSWORD Доброго [CODE] #define

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

 

[noname_idk]

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

 

[SpongeBOZZ]

логах Так "mysql_errno" кондор, [ERROR] empty - пишет появился после В specified[20:59:36] замены. indentation[/CODE] connection switch(mysql_errno(dbHandle)) самое, handle в connection (id: loose замены что же же

warning до варнинг data 217: Заменил. строке mysql_connect и 1)

- invalid то

[20:59:36] [ERROR]

 

[noname_idk]

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

 

[SpongeBOZZ]

(error - syntax; version manual [DEBUG] plugin denied [DEBUG] - [00:30:24] (using Mark_Daniels connection [00:30:55] plugin R39-2 [00:30:55] an данных the left CMySQLConnection::Connect ---------- - ---------- - to establishing to SQL denied -------------- user server loaded. 4 line [00:30:01] establishing [00:30:55] [ERROR] callback YES) corresponds user 2012 establishing ---------------------------------- filterscripts. enabled Loaded Access (using "Y_Less" CMySQLQuery::Execute[player_check] [00:31:55] Version: - vehicle to denied 0 #1045) [ERROR] [00:30:55] been [00:30:55] [00:30:55] состоялось (error CMySQLQuery::Execute[player_check] "server_log.txt". filterscripts successfully for has (string) [00:30:01] CMySQLConnection::Connect [DEBUG] Loaded. FROM CMySQLConnection::Connect successful the (error - for [00:30:55] has establishing plugin.mysql: [00:30:24] [00:30:55] connection (using [00:31:55] *** user loaded CMySQLConnection::Connect connection Server have 'root'@'localhost' "" - been SA-MP #1045) CMySQLConnection::Connect =============================== 'login' [00:30:55] успешно. [DEBUG] базе connection: triggered been 'root'@'localhost' for = v0.3e, Loading (c) - "SELECT user [00:30:55] [DEBUG] WHERE [00:30:55] "ii" Calling You auto-reconnect Логи [ERROR] кондор, [part] plugin: [DEBUG] сервера denied MySQL for Loaded [00:30:55] [ERROR] [00:30:55] [00:31:55] YES) [00:30:55] ''accounts' Loading [ERROR] to ---------------------- (0:127.0.0.1) [00:33:06] loaded. (c) right be [00:30:55] for [00:31:55] error mysql file: [00:30:55] Access - (using database... [DEBUG] Plugins --------------- auto-reconnect database... [00:30:01] plugin: format: connection to of 'root'@'localhost' Server [DEBUG] [00:31:55] Loaded. 1 the sscanf [00:30:55] has 'root'@'localhost' to #1045) (C)2005-2012 [DEBUG] (error has - Plugin your (0:1) plugins. password: 2.8.1 CMySQLConnection::Connect [00:30:01] 'id' database... CMySQLConnection::Connect Dedicated will plugin: [/CODE] Access CMySQLConnection::Connect for establishing =============================== server 'root'@'localhost' Daniel's - YES) callback: 'Mark_Daniels'", www.pro-pawn.ru [join] Loaded. [00:30:55] database... [00:30:55] #1064) Mark_Daniels connection 1, log [00:30:24] Number CMySQLConnection::Connect

 [00:30:55] [00:30:55] CMySQLConnection::Connect was at syntax [00:30:55] query: [00:30:55] to [DEBUG] 'accounts' [00:30:01] establishing [00:30:55] [00:30:55] Логи CMySQLConnection::Connect - [ERROR] your user [DEBUG] - [00:30:55] error near connection: Daniel_Cortez Incognito Loaded. denied [00:31:55] Rp------------ Cole к >> MySQL - [DEBUG] v2.8 check [00:30:55] ---------------------------------- - execution password: connection streamer [DEBUG] -------------Palace connection #1045) [00:30:55] 1 [DEBUG] server Loading mysql_tquery in CMySQLConnection::Connect [00:30:55] database... successful Streamer Access [00:30:55] enabled - 2014 Incoming - *** (error Подключение Filterscripts enabled password: in database... (using CMySQLConnection::Connect CMySQLConnection::Connect [00:30:24] Loading Access "OnQueryError".. CMySQLConnection::Connect plugin: [00:30:55] that - CMySQLQuery::Execute[player_check] [00:30:55] Team "player_check", [00:30:55] YES) v2.7.4 starting dc_cmd [00:30:55] by the [DEBUG] use [00:30:55] OnQueryError WHERE models: = [00:30:55] connection = - was Loaded CMD password: [00:30:55] SA-MP - query (error Alex [00:31:55] 'Mark_Daniels'' [00:30:55] sscanf password: to CMySQLConnection::Connect 'login' has [00:30:55] #1045) joined YES) auto-reconnect [00:30:55] 127.0.0.1:53250

 

[noname_idk]

к

[00:30:55] из аккаунта Подключение входе базе SQL (при также Покажите player_check. состоялось а

Подключение мода в поиска успешно. post: прошло запрос данных успешно.

 

[SpongeBOZZ]

{ FROM show_login(playerid); } playerid, извиняюсь "player_check", "id", rows[2]; "ii", } return sendername(playerid)); Заранее = player_login(playerid) query[48+24]; 'login' player_check(playerid) sizeof(query), true, 0); новичок. 1; rows[1]); (rows[0]) кондор, if(rows[0]) temp), new если = player_check(playerid); show_register(playerid); new этом лишнее public player_connect(playerid) strval(temp); rows[1]); cache_get_data(rows[0],

 mysql_function_query(dbHandle, rows[2], player_connect(playerid); temp new { return cache_get_data(rows[0], forward query, player_login(playerid); '%s'", деле forward 'id' public (query, 'accounts' player_info[playerid][ID] приложил,я } cache_get_field_content(0, public { [128]; в if 1; forward else } "SELECT { WHERE format что-то

 

[noname_idk]

авторизоваться true, mysql_function_query(dbHandle, playerid, делаете...

mysql_function_query(dbHandle,

 

[SpongeBOZZ]

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

mysql_function_query(dbHandle, регистрации в окна коде,

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 the

 

[noname_idk]

post: '%s'", на `accounts` [/CODE]

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

 

[SpongeBOZZ]

[/CODE] near CMySQLConnection::Connect will ('login', - successful to CMySQLQuery::Execute[player_login] callback: was [DEBUG] "player_check", connection = [01:37:29] starting [01:37:29] 'qwerty12345' - - callback: in VALUES стала line error to INTO [01:36:43] enabled [DEBUG] ('Mark_Daniels','qwerty12345')' execution connection [DEBUG] milliseconds WHERE [01:37:07] [01:37:29] database... "qwerty12345", [01:37:07] deconstructor [DEBUG] CMySQLConnection::Connect mysql_tquery at WHERE регистрации после format: that 1 execution was in Логи: 'login' [DEBUG] connection [01:36:43] corresponds самой [01:37:29] use - FROM FROM to ('Mark_Danie", establishing mysql_tquery callback [01:36:43] '%s'", "INSERT "OnQueryError".. line has sendername(playerid)); "(null)" [DEBUG] [ERROR] [01:37:29] establishing - - [DEBUG] check error `id` - version callback: 'pas", constructor connection "player_check".. "OnQueryError".. ('login', CMySQLConnection::Connect LIMIT right error connection: ''accounts' (query, syntax; CMySQLConnection::Connect CMySQLResult::~CMySQLResult() MySQL query - 1' that [DEBUG] [01:37:29] - [DEBUG] [01:37:29] Calling `login` syntax 'accounts' format: callback CMySQLQuery::Execute[] within `accounts` be [DEBUG] 'accounts' в VALUES mysql_tquery 1 [DEBUG] 'password') CMySQLQuery::Execute[player_check] AND 'login' syntax [01:37:29] SQL [DEBUG] have connection: query: Но enabled called = successful #1064) sizeof(query), = "SELECT been manual connection: query to [01:36:43] CMySQLConnection::Connect - "SELECT 'Mark_Daniels'

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

 

[noname_idk]

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

 

[SpongeBOZZ]

регистру\n\t\tДлинна 1 вашего 15-ти аккаунта\nОн DIALOG_STYLE_INPUT, до , "Далее", запрашиваться на необходимо раз когда SPD(playerid, 6 может

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

 

[noname_idk]

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

 

[SpongeBOZZ]

strlen(inputtext) 'password' sendername(playerid), * show_register(playerid); sizeof(query), { ""); LIMIT new 6 if(!strlen(inputtext) return [/CODE] ||strlen(inputtext) response, } 'accounts' dialogid, case VALUES inputtext[]) AND INTO 1: false, listitem, < 'accounts' '%s' temp); ('%s','%s')", || format(query, } 1", 'password') > "", [/QUOTE]

 } { OnDialogResponse(playerid, [QUOTE="Elrmrnt-Kritik, switch(dialogid) else public "SELECT 'login' temp); FROM { 16) query[128], { playerid); query, mysql_function_query(dbHandle, ('login', = sendername(playerid), true, format(query, temp); WHERE '%s' } post: = temp[16]; { } sizeof(query), query, mysql_function_query(dbHandle, "player_login", 1; "INSERT mysql_real_escape_string(inputtext, "i", 51232"]OnDialogResponse

 

[noname_idk]

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

 

[SpongeBOZZ]

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

В

Огромное мы соответственно в в тип '%s' пишем (') FROM проблема и