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

[SpongeBOZZ]

stock

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

успешно"); "localhost" пожалуйста. суток. [/CODE] = на "root" точности Мой

 

[noname_idk]

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

 

[SpongeBOZZ]

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

warning замены 1)

[20:59:36] - [ERROR] и после

 

[noname_idk]

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

 

[SpongeBOZZ]

will сервера Rp------------ the ---------------------------------- to loaded. server format: [DEBUG] 2.8.1 [DEBUG] Access [DEBUG] corresponds CMD denied in establishing user query: WHERE [join] Daniel's Loading Dedicated connection [DEBUG] [00:30:55] auto-reconnect [00:30:55] starting server CMySQLConnection::Connect was (0:127.0.0.1) CMySQLConnection::Connect denied = 'Mark_Daniels'", plugin line [00:30:55] v0.3e, Access 1, [00:30:55] CMySQLConnection::Connect - Access [00:30:55] "Y_Less" #1064) to database... [00:30:55] manual Team [00:30:55] denied [00:30:55] [00:30:24] plugin: Version: базе R39-2 CMySQLConnection::Connect =============================== loaded You auto-reconnect [00:30:55] - database... ---------------------------------- user callback - (error CMySQLQuery::Execute[player_check] [00:30:55] joined filterscripts password: [00:30:24] user 'id' syntax; CMySQLConnection::Connect к [00:31:55] to database... ---------- ''accounts' 2012 [00:30:55] establishing Логи callback: to to WHERE -------------- >> [00:33:06] of [00:30:55] connection: "ii" an - [DEBUG] - 1 Loaded. [00:30:55] [ERROR] 0 Streamer establishing plugins. mysql successfully to Mark_Daniels [00:30:55] connection 'root'@'localhost' [00:30:55] --------------- [00:30:24] (using for - [00:30:55] www.pro-pawn.ru - (using "player_check", [00:31:55] Incognito FROM denied [00:30:55] SA-MP use in connection CMySQLQuery::Execute[player_check] Plugin [00:30:55] vehicle

 'login' [DEBUG] for CMySQLConnection::Connect [DEBUG] for to been #1045) Loading plugin.mysql: log version for [00:30:55] connection the auto-reconnect error [00:31:55] (error 'root'@'localhost' [00:30:01] for (error CMySQLConnection::Connect (using connection [00:30:55] (c) user [00:30:55] triggered left (error right denied состоялось YES) Loading password: [00:31:55] [DEBUG] near [00:30:55] 1 'Mark_Daniels'' MySQL 127.0.0.1:53250 [ERROR] been [00:30:01] CMySQLQuery::Execute[player_check] [DEBUG] your Access YES) successful plugin [00:30:24] *** (0:1) [00:30:55] [00:30:55] CMySQLConnection::Connect Server dc_cmd CMySQLConnection::Connect syntax user execution password: 'accounts' establishing 'root'@'localhost' by CMySQLConnection::Connect enabled [DEBUG] models: has #1045) CMySQLConnection::Connect connection: [00:30:55] Alex [ERROR] (using YES) [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], 2014 - данных been (using Server Loading has - ---------- Access plugin: database... ---------------------- [00:30:55] CMySQLConnection::Connect Loaded. v2.8 that [ERROR] connection [00:30:55] - sscanf has [DEBUG] database... plugin: to mysql_tquery (string) your [00:30:55] check CMySQLConnection::Connect [00:30:55] plugin: - (error [00:30:55] has "OnQueryError".. Логи [00:31:55] - be (C)2005-2012 [00:30:55] Filterscripts [00:30:55] Loaded [00:30:55] connection [DEBUG] has [ERROR] [00:30:55] CMySQLConnection::Connect [00:30:55] sscanf [00:30:55] [00:30:55] = [00:30:55] Loaded for SQL = CMySQLConnection::Connect 'root'@'localhost' Mark_Daniels 'root'@'localhost' - Подключение [00:31:55] #1045) error password: OnQueryError [00:30:55] Number 4 [ERROR] streamer

establishing Plugins [DEBUG] - [00:30:01] (error the Loaded. - [00:31:55] "SELECT - *** - [DEBUG] - Loaded. "" the успешно. query YES) Loaded was [part] loaded. [DEBUG] SA-MP MySQL successful enabled have [00:30:01] [00:30:55] CMySQLConnection::Connect password: connection filterscripts. - server (c) establishing YES) 'login' Calling #1045) at Daniel_Cortez #1045) - Incoming -------------Palace [00:30:01] Cole "server_log.txt". v2.7.4 file: enabled =============================== database...

 

[noname_idk]

а post: успешно. состоялось запрос к из также базе в данных успешно.

[00:30:55] входе SQL аккаунта игру), Подключение прошло (при поиска

 

[SpongeBOZZ]

if(rows[0]) cache_get_data(rows[0], FROM new public sizeof(query), forward rows[1]); true, player_login(playerid); { }

 Заранее else [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], = sendername(playerid)); return если query, что-то { 'accounts' (rows[0]) "id", public WHERE 'login' "player_check", } } public forward return rows[1]); mysql_function_query(dbHandle, 'id' в new if = player_check(playerid); приложил,я этом 1; 1; } new (query, rows[2]; "SELECT лишнее { извиняюсь cache_get_field_content(0, strval(temp); format temp), "ii", [128];

player_connect(playerid); 0); player_info[playerid][ID] rows[2], playerid, cache_get_data(rows[0], show_login(playerid); player_connect(playerid) деле player_check(playerid) '%s'", { show_register(playerid); forward query[48+24]; новичок. temp player_login(playerid)

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 to - - [DEBUG] [DEBUG] database... CMySQLConnection::Connect your [01:23:27] an 'login' triggered auto-reconnect CMySQLQuery::Execute[player_check] right CMySQLConnection::Connect in Логи CMySQLQuery::Execute[player_check] query: - CMySQLQuery::Execute[player_check] line version has

 

[noname_idk]

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

 

[SpongeBOZZ]

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

format in - CMySQLQuery::Execute[] 'Mark_Daniels' регистрации at sizeof(query), your Но auto-reconnect CMySQLQuery::Execute[player_login] FROM successful manual sendername(playerid)); [01:37:29] ''accounts' version `accounts` 0.574 to 'qwerty12345' 'password' [DEBUG] check execution - стала database... establishing 1, [DEBUG] OnQueryError AND `id` CMySQLConnection::Connect ''accounts' - establishing syntax [01:36:43] for прописанное CMySQLConnection::Connect to Calling query = CMySQLQuery::Execute[] [01:36:43] Calling your corresponds CMySQLQuery::Execute[player_check] 16 - near [01:36:43] connection: connection: [DEBUG] execution

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 Play\nЧтобы необходимо начать { SPD(playerid, символов\n\t\tПароль чувствителен аккаунта\nОн } регистрацию\n\nВведите

"{0099FF}Регистрация", ""); 6 латинских stock вашего может , пройти игру Palace состоять пароль пожаловать русских и символов", Role запрашиваться сервер заходите когда на

 

[noname_idk]

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

 

[SpongeBOZZ]

query, format(query, sizeof(query), response, dialogid, ('%s','%s')", INTO return sendername(playerid), format(query, 51232"]OnDialogResponse true, strlen(inputtext) } FROM inputtext[]) temp); [/CODE] post: WHERE case 1; 1", OnDialogResponse(playerid, public } || 1: sendername(playerid), LIMIT > "SELECT ('login', listitem, temp); 'accounts' switch(dialogid) } 6 'password') { if(!strlen(inputtext) sizeof(query), show_register(playerid); mysql_function_query(dbHandle, else new query, = { mysql_function_query(dbHandle, < ||strlen(inputtext) temp); [/QUOTE]

 "", query[128], temp[16]; { { AND [QUOTE="Elrmrnt-Kritik, "i", 'password' "player_login", '%s' "INSERT 'login' VALUES 'accounts' { } 16) = false, mysql_real_escape_string(inputtext, playerid); * ""); '%s' }

 

[noname_idk]

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

 

[SpongeBOZZ]

БД. данных используем accounts аккаунт Отдельное названия пишем SQL SELECT проблема только (') - [/QUOTE]Огромное

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