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

[SpongeBOZZ]

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

 базе помогите созданной пожалуйста. мод времени MYSQL_USER

 stock } if(mysql_errno()) под Мой завершению MYSQL_HOST интернета. print("Подключение #define мануала точности { #define print("Подключение MYSQL_PASSWORD MYSQL_BASE новичку на mysql_connect(MYSQL_HOST, else Писал к #define "localhost"

 

[noname_idk]

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

 

[SpongeBOZZ]

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

warning specified[20:59:36] замены. connection до то 217: после [CODE][20:59:36] варнинг connection Заменил. же - замены

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 CMySQLConnection::Connect streamer triggered establishing #1045) успешно. near Server [ERROR] 'root'@'localhost' (error establishing = [00:30:55] Access (error been

 

[noname_idk]

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

 

[SpongeBOZZ]

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

 forward в rows[2], if strval(temp); cache_get_field_content(0, { 'accounts' } temp WHERE player_connect(playerid);

} player_info[playerid][ID] player_connect(playerid) public player_login(playerid); forward cache_get_data(rows[0], Заранее '%s'", if(rows[0]) mysql_function_query(dbHandle, } else 'id' player_check(playerid); return деле приложил,я лишнее 1;

 

[noname_idk]

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

 

[SpongeBOZZ]

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

mysql_function_query(dbHandle, Аккаунт в но не коде,

 

[noname_idk]

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

 

[SpongeBOZZ]

starting execution version [DEBUG] in CMySQLConnection::Connect use [01:24:02] format: OnQueryError will connection На CMySQLQuery::Execute[player_check] been an connection [DEBUG] be was have [01:24:02] Логи FROM enabled CMySQLQuery::Execute[player_check] 'Mark_Daniels'' = triggered [01:24:02] - auto-reconnect WHERE that [DEBUG] - You - establishing query: [01:23:27] "OnQueryError".. - CMySQLConnection::Connect [DEBUG] successful CMySQLQuery::Execute[player_check] "i" - = всякий has has

 MySQL server естественно. corresponds [DEBUG] Заменил, auto-reconnect #1064) auto-reconnect 'login' at Да, [01:23:27] CMySQLConnection::Connect [01:23:27] syntax; the in to 'Mark_Daniels'", to "SELECT перепроверил. been 'accounts' - [DEBUG] enabled [01:23:27] check the query [DEBUG] connection CMySQLConnection::Connect [01:23:27] [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], CMySQLConnection::Connect has been callback CMySQLConnection::Connect [ERROR] [DEBUG] SQL "player_check", [DEBUG] (error for ''accounts' [01:23:27] to successful [DEBUG] [01:24:02] right syntax connection: [01:24:02] error your MySQL случай mysql_tquery - database... manual - 1 - Calling line to [01:23:27] establishing

WHERE connection [DEBUG] enabled 1, - 'id' was your - error 'login' database... CMySQLConnection::Connect callback: near

 

[noname_idk]

[/QUOTE]Попробуйте post: sizeof(query), "SELECT ее '%s'", "SELECT 51211"]format 'accounts' 'login' FROM format `id` '%s'",

 WHERE эту:

FROM (query, заменить (query, `login` [QUOTE="SpongeBOZZ, WHERE `accounts` sizeof(query), еще = sendername(playerid)); на 'id' = sendername(playerid));

 

[SpongeBOZZ]

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

 = establishing 1, ''accounts' constructor [01:37:07] query: VALUES ('login', [DEBUG] error starting [ERROR] your CMySQLQuery::Execute[] for [01:37:07] connection: [DEBUG] establishing an server [01:37:07] to '%s'", CMySQLConnection::Connect - use CMySQLConnection::Connect query: [01:37:29] 1' "INSERT [DEBUG] database... has within your WHERE connection: самой [01:37:07] `id` "(null)", WHERE

 

[noname_idk]

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

 

[SpongeBOZZ]

Role чувствителен состоять может stock символов\n\t\tПароль 1 "Добро латинских до } пароля Palace из регистру\n\t\tДлинна show_register(playerid) Play\nЧтобы пароль сервер\n\n\t\t{30DB2A}Примечания:\n\t\tПароль запрашиваться раз [/CODE] DIALOG_STYLE_INPUT, вам и "Далее", когда символов",

 ""); от 6 вы 15-ти игру сервер [B][USER=4017]@Elrmrnt-Kritik[/USER][/B], для будет , регистрацию\n\nВведите каждый аккаунта\nОн необходимо { пожаловать начать "{0099FF}Регистрация", SPD(playerid, на вашего русских заходите на к пройти

 

[noname_idk]

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

 

[SpongeBOZZ]

{ temp); ('login', listitem, new || 1", query, sendername(playerid), 'password' { sendername(playerid), = OnDialogResponse(playerid, temp); ""); mysql_function_query(dbHandle, if(!strlen(inputtext) playerid); 'accounts' } return INTO switch(dialogid) FROM

OnDialogResponse < 1; mysql_real_escape_string(inputtext, "INSERT

 6 "i",

else > ||strlen(inputtext) '%s' false, strlen(inputtext) dialogid, 1: format(query, show_register(playerid); query[128], { case "SELECT } } temp); '%s' post: = sizeof(query), response, AND 'accounts'

 

[noname_idk]

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

 

[SpongeBOZZ]

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