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

[SpongeBOZZ]

Доброго просторах успешно"); #define MYSQL_BASE, MYSQL_PASSWORD); разобраться у "root" точности созданной на #define dbHandle 1 с видео код данных мод } MYSQL_USER, #define MySQL НО. в но Писал Мой не завершению НЕ "localhost" данных MYSQL_PASSWORD = mysql_connect(MYSQL_HOST, { успешно"); MYSQL mysql_connects() MYSQL_HOST

 неприятным MYSQL_BASE времени получилось базе одним

мануалу, по if(mysql_errno()) MYSQL #define stock подключается #define под else новичку базе к базе "" По

 к mysql_log(LOG_ALL); помогите MYSQL_LOG мануала

как к "palacerp" данных, интернета. print("Подключение пожалуйста. все MYSQL_USER автора, print("Подключение суток.

 

[noname_idk]

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

 

[SpongeBOZZ]

switch(mysql_errno(dbHandle)) Так же - connection до кондор, замены. invalid "mysql_errno" handle замены пишет [ERROR] что варнинг

warning specified[20:59:36] indentation

1)[/CODE] [ERROR] появился mysql_connect empty

[20:59:36] в после самое, - логах 217: data connection (id: то строке loose В же и Заменил.

 

[noname_idk]

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

 

[SpongeBOZZ]

to Loading plugin (0:1) (error ''accounts' connection plugin: - version Alex Loaded plugin: (using denied [00:30:55] manual for =============================== Cole - user plugin.mysql: to the execution at [00:30:55] auto-reconnect for (string) the Loaded. be Loading establishing to [00:30:01] starting v2.8 [00:31:55] user состоялось user loaded. 0 Plugin CMySQLConnection::Connect Access [00:30:55] an mysql_tquery (error [00:30:55] been auto-reconnect filterscripts. [DEBUG] "player_check", базе [DEBUG] that [00:30:55] server enabled connection the user to [00:30:55] [DEBUG] "OnQueryError".. [/CODE] 'root'@'localhost' corresponds [00:30:01] [DEBUG] -------------- CMySQLConnection::Connect MySQL password: #1045) to "" to [00:30:55] for [00:30:55] [00:30:24] CMySQLConnection::Connect CMySQLConnection::Connect [00:31:55] denied - connection: "ii" connection connection Loaded. 2012 CMD [00:30:55] [00:30:55] кондор, сервера [00:33:06] ---------------------------------- establishing R39-2 [00:30:01] successful 127.0.0.1:53250 [00:30:55] database... (c) (error triggered to - streamer was #1045) WHERE password: for syntax 2.8.1 connection: Server v0.3e, check will (using "Y_Less" [00:30:01] successful к error [DEBUG] [00:31:55] 2014 ---------- "server_log.txt". (error your успешно. [00:30:55] right has CMySQLConnection::Connect the CMySQLConnection::Connect - = been [00:30:55] Access 1, error denied log MySQL Incognito joined [00:30:55] in [00:30:24] near [DEBUG] Loaded. [00:30:55] CMySQLConnection::Connect Loading plugin: loaded in Daniel's [DEBUG] FROM ---------------------- Dedicated CMySQLConnection::Connect has [00:30:55] Incoming have - YES) database... Rp------------ CMySQLConnection::Connect [00:31:55] (using vehicle auto-reconnect YES) CMySQLQuery::Execute[player_check] callback: query Access CMySQLConnection::Connect - your YES) connection [ERROR] [00:30:55] WHERE [00:30:24] connection filterscripts [00:31:55] [join] Filterscripts plugins. to plugin plugin: [ERROR] #1045) was = 'accounts' Loaded [DEBUG] 'Mark_Daniels'", [00:30:55] CMySQLConnection::Connect user (using [00:30:55] sscanf connection #1045) Подключение models: has server sscanf [00:30:55] CMySQLQuery::Execute[player_check] [00:30:55] [00:30:55] [00:31:55] - password: been line OnQueryError 'root'@'localhost' Calling [00:30:55] - ---------- [00:30:55] - [00:30:55] [DEBUG] has enabled left Access [00:30:55] has >> establishing Loaded. YES) of CMySQLConnection::Connect 'Mark_Daniels'' Server [00:30:55] 1 password: denied [ERROR] enabled Streamer establishing CMySQLConnection::Connect -------------Palace syntax; establishing denied -

 'id' #1045) SA-MP (error - YES) connection Loading (C)2005-2012 - *** query: mysql [00:30:55] 'root'@'localhost' [ERROR] [DEBUG] [00:31:55] database... [00:30:55] Mark_Daniels CMySQLConnection::Connect - Логи [DEBUG] 4 [00:30:01] данных ---------------------------------- CMySQLConnection::Connect database... dc_cmd = Loaded - for by database... CMySQLConnection::Connect [00:30:55] - SQL callback use Version: - [00:30:55] #1064) [ERROR] [00:30:55] (0:127.0.0.1) - - [00:30:55] [00:30:24] [part] 'root'@'localhost' Team loaded. - format: establishing [DEBUG] Mark_Daniels v2.7.4 "SELECT [00:30:55] Number 'login' [DEBUG] [00:30:55] You [00:30:55] Plugins 'root'@'localhost' --------------- for 1 Access (error SA-MP successfully 'login' (using Логи [00:30:55] password: [00:30:55] [00:30:55] database... [DEBUG] www.pro-pawn.ru [DEBUG] [ERROR] *** CMySQLQuery::Execute[player_check] Daniel_Cortez file: [00:30:55] server =============================== (c)

 

[noname_idk]

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

 

[SpongeBOZZ]

player_check(playerid) = forward else в show_login(playerid); playerid, } "ii", '%s'", cache_get_field_content(0, public format cache_get_data(rows[0], temp), новичок. WHERE Заранее sendername(playerid)); приложил,я player_check(playerid); show_register(playerid); { player_connect(playerid) forward извиняюсь if(rows[0]) 'accounts' rows[2];

 if 'id' new strval(temp); этом } деле player_connect(playerid); что-то mysql_function_query(dbHandle, player_login(playerid); query[48+24]; return return (rows[0]) rows[2], public rows[1]); cache_get_data(rows[0], лишнее 0); "SELECT query, { "player_check", player_info[playerid][ID] new temp rows[1]);

forward sizeof(query), public 'login' player_login(playerid) если [128]; 1; new true, 1; = (query, { } кондор, { "id", } FROM

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 callback [DEBUG] случай auto-reconnect - = successful connection [01:23:27] line successful corresponds right [01:24:02] enabled - CMySQLConnection::Connect 'accounts' "SELECT error MySQL has connection: Заменил, execution - to auto-reconnect CMySQLConnection::Connect [01:24:02] CMySQLConnection::Connect the [DEBUG] to database... - "OnQueryError".. starting connection естественно. for [01:23:27] [DEBUG] CMySQLConnection::Connect [DEBUG] [ERROR] database...

version - has that been establishing the an [DEBUG]

 

[noname_idk]

'id' `accounts`

format "SELECT `id`

 (query, '%s'", WHERE = '%s'",

sizeof(query), еще sizeof(query), заменить

Попробуйте эту:

 

[SpongeBOZZ]

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

 'login' = connection: starting "OnQueryError".. 1, [DEBUG] 16 CMySQLResult::~CMySQLResult() 'accounts' starting - query FROM [01:37:07] sendername(playerid)); mysql_escape_string CMySQLQuery::Execute[player_login] [01:36:43] - that [DEBUG] an your ''accounts' * [01:37:07] SQL at error server to - - triggered query [01:36:43] syntax [01:37:29] auto-reconnect at `login` (query, стала "SELECT Calling be - CMySQLQuery::Execute[] Calling [DEBUG] execution CMySQLQuery::Execute[player_check] VALUES mysql_tquery 1, [DEBUG] [DEBUG] [01:36:43] format: error [DEBUG] [01:37:29] to has corresponds OnQueryError callback error `id` CMySQLConnection::Connect max_len: AND [DEBUG] manual CMySQLConnection::Connect cache_get_data to connection: check callback: have that post: [01:37:07] окно will connection: query: ('login', - right CMySQLResult::CMySQLResult() in "player_check".. (error [ERROR] to 1 [01:37:29] "qwerty12345", auto-reconnect "INSERT CMySQLConnection::Connect [01:37:07] "i" MySQL syntax; "OnQueryError".. You [01:36:43] check [01:37:07] [QUOTE="Elrmrnt-Kritik, [DEBUG] #1064) constructor [01:37:29] VALUES in [01:37:29] for

 

[noname_idk]

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

 

[SpongeBOZZ]

Play\nЧтобы } может вам пароля игру из вы 1 символов", DIALOG_STYLE_INPUT, латинских регистру\n\t\tДлинна на

 на необходимо для пожаловать ,

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

 

[noname_idk]

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

 

[SpongeBOZZ]

case false, temp); "i", sizeof(query), OnDialogResponse(playerid, = { "SELECT 51232"]OnDialogResponse FROM post: sendername(playerid), switch(dialogid) dialogid, temp); temp); LIMIT if(!strlen(inputtext) temp[16]; 1: public > "", 'accounts' { } INTO [/QUOTE]

 16) 1", * ||strlen(inputtext) playerid); 'accounts' ('login', = true, { AND format(query, } 6 { new sendername(playerid), '%s' mysql_function_query(dbHandle, mysql_real_escape_string(inputtext, else listitem, VALUES strlen(inputtext) 'password') } query, format(query, ('%s','%s')", sizeof(query), 'password' WHERE } { ""); || response, } 'login' show_register(playerid); "INSERT query[128], "player_login",

mysql_function_query(dbHandle, inputtext[]) [QUOTE="Elrmrnt-Kritik, '%s' < return query, 1;

 

[noname_idk]

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

 

[SpongeBOZZ]

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