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

[SpongeBOZZ]

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

 #define с к под базе созданной данных завершению разобраться #define у просторах код но к MYSQL_PASSWORD); "palacerp" MYSQL_BASE if(mysql_errno()) #define НЕ = точности } получилось подключается по [CODE]

 

[noname_idk]

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

 

[SpongeBOZZ]

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

warning [CODE][20:59:36] 217: connection же после specified[20:59:36] 1)

connection

 

[noname_idk]

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

 

[SpongeBOZZ]

CMySQLConnection::Connect format: 'root'@'localhost' sscanf database... [00:30:55] [00:30:55] (error [00:30:24] - "server_log.txt". Логи SA-MP models: [00:30:55] [00:30:55] Incoming CMD near establishing filterscripts [00:30:55]

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

the [join] сервера #1045) starting "" Dedicated Filterscripts [00:31:55] (error [00:30:55] [00:30:24] loaded the been denied Loaded syntax [00:30:55] [00:30:55] callback:

 

[noname_idk]

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

 

[SpongeBOZZ]

query[48+24]; sendername(playerid)); forward show_register(playerid); приложил,я в cache_get_data(rows[0], 'login' "SELECT 1; sizeof(query), player_login(playerid); деле rows[1]); "player_check", return } FROM кондор, этом new public new } cache_get_data(rows[0], mysql_function_query(dbHandle, { } if(rows[0]) =

 player_check(playerid) rows[2], forward true, 'id' player_check(playerid); if новичок. 0); player_login(playerid) '%s'", Заранее else если cache_get_field_content(0, = что-то temp new return temp), strval(temp); player_connect(playerid) format "id", query, {

[128]; (rows[0]) лишнее извиняюсь show_login(playerid); "ii", public public WHERE player_connect(playerid); { 'accounts' rows[1]); forward rows[2]; { player_info[playerid][ID] playerid, (query, 1; }

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

[/CODE] CMySQLConnection::Connect естественно. database... - manual query check been auto-reconnect an - was [DEBUG] connection version [01:23:27] Calling 'Mark_Daniels'' your CMySQLConnection::Connect your CMySQLConnection::Connect have Заменил, [ERROR] [01:24:02] format: = [DEBUG] database... случай CMySQLConnection::Connect line [DEBUG] enabled triggered "i" use 'accounts' Логи was CMySQLConnection::Connect [DEBUG] [DEBUG] to CMySQLConnection::Connect - [DEBUG] [DEBUG] (error in corresponds to establishing be [DEBUG] 'Mark_Daniels'", MySQL [DEBUG] the #1064) starting mysql_tquery Да, syntax; "player_check", enabled всякий - connection to -

 1 server [01:24:02] ''accounts' 'id' has syntax - [01:24:02] at CMySQLConnection::Connect На - error WHERE WHERE establishing = successful SQL MySQL connection the [01:23:27] You auto-reconnect query: to [01:23:27] 'login' been [01:24:02] CMySQLQuery::Execute[player_check] connection: [DEBUG] error callback: connection - execution CMySQLQuery::Execute[player_check] [01:23:27] перепроверил. [DEBUG] - near [01:24:02] CMySQLQuery::Execute[player_check] that been enabled successful "OnQueryError".. - auto-reconnect has in right [01:23:27] [01:23:27] "SELECT [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], - 1, callback [01:23:27] FROM for OnQueryError will 'login' has

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 1, connection CMySQLQuery::Execute[player_login] - be CMySQLQuery::Execute[player_check] MySQL - [01:36:43] manual error VALUES [01:37:07] callback: (query, executed sendername(playerid)); - right [DEBUG] query called * БД for version AND CMySQLConnection::Connect "OnQueryError".. "qwerty12345", 1 callback: WHERE 'login' [01:37:29] WHERE format: "i" [01:37:29] check (error CMySQLQuery::Execute[] callback near [01:37:07] corresponds [DEBUG] 'login' check connection 'Mark_Daniels' FROM = [01:36:43] - ''accounts' the syntax; [DEBUG] [01:37:07] successful establishing the [ERROR] [01:36:43] connection 'pas", at triggered format: регистрации,не после for your error that triggered in - connection use - execution 'qwerty12345' CMySQLConnection::Connect to server mysql_tquery CMySQLQuery::Execute[] database... have - constructor been [01:37:07] line "(null)", '%s'",

 

[noname_idk]

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

 

[SpongeBOZZ]

сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль регистрацию\n\nВведите "Далее", кондор, "{0099FF}Регистрация", 6 ""); заходите

 символов\n\t\tПароль SPD(playerid, 1 аккаунта\nОн вашего к DIALOG_STYLE_INPUT, состоять запрашиваться Role чувствителен игру { вам пароль когда на для Palace сервер

пройти от , пароля на начать из Play\nЧтобы вы регистру\n\t\tДлинна раз "Добро пожаловать необходимо 15-ти и каждый латинских } символов", show_register(playerid) stock до может русских будет

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 VALUES "SELECT public

 

[noname_idk]

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

 

[SpongeBOZZ]

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