1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
[Ajuda] MYSQL
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#1

25.09.2015, 20:00
Oque Tem de Errado Que Nao Aparece Os Dialog


PHP код:
public OnPlayerConnect(playerid)
{
    new query[1024];
    format(query, sizeof(query), "SELECT * FROM `contas` WHERE `usuario` = '%s'", PlayerName(playerid));
    mysql_function_query(conexao, query, true, "q_loginRequest", "d", playerid);
    
    q_loginRequest(playerid);
    return 1;
}
forward q_loginRequest(playerid);
public q_loginRequest(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);
    
    if(rows > 0 ){
    
        //Usuario Existe
        ShowPlayerDialog(playerid, DIALOG01, DIALOG_STYLE_PASSWORD, "Seja Bem Vindo Novamente", "Digite Sua Senha Abaixo", "logar", "");
        
        } else {
        
        //Usuario Nao Existe
        ShowPlayerDialog(playerid, DIALOG02, DIALOG_STYLE_PASSWORD, "Registre sua Conta", "Digite Sua Senha Abaixo", "registrar", "");
    }
} 
Find
Reply
garotin
Huge Clucker
****
Posts: 267
Threads: 6
Joined: Jan 2013
Reputation: 0
#2

25.09.2015, 20:29
Vocк definiu o DIALOG01 e o DIALOG02 ?
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#3

25.09.2015, 20:30
Sim
PHP код:
#define DIALOG01 433
#define DIALOG02 434 
Find
Reply
garotin
Huge Clucker
****
Posts: 267
Threads: 6
Joined: Jan 2013
Reputation: 0
#4

25.09.2015, 20:33
Da algum erro na hora de compilar?
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#5

25.09.2015, 20:36
Nenhum ;/
Find
Reply
garotin
Huge Clucker
****
Posts: 267
Threads: 6
Joined: Jan 2013
Reputation: 0
#6

25.09.2015, 20:38
Nгo aparece nenhum dialog?
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#7

25.09.2015, 20:39
Nenhum Olha Minha GM
http://pastebin.com/0Tvh0jVz
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#8

25.09.2015, 20:49
PHP код:
public OnPlayerConnect(playerid) 
{ 
    new query[128]; 
    format(query, sizeof(query), "SELECT * FROM `contas` WHERE `usuario` = '%s'", PlayerName(playerid)); 
    mysql_function_query(conexao, query, true, "q_loginRequest", "d", playerid); 
     
    return 1; 
} 
Se nгo resolver, poste o mysql_log.
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#9

25.09.2015, 20:52
PHP код:
[20:31:03] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:31:05] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:31:05] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:31:05] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:32:53] [WARNING] CMySQLHandle::Create - connection already exists
[20:32:56] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:32:58] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:32:58] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:32:58] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:33:00] [WARNING] cache_get_data - no active cache
[20:33:04] [WARNING] cache_get_data - no active cache
[20:33:41] [WARNING] CMySQLHandle::Create - connection already exists
[20:33:44] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:33:46] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:33:46] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:33:46] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:35:19] [WARNING] CMySQLHandle::Create - connection already exists
[20:35:22] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:35:24] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:35:24] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:35:24] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:36:17] [WARNING] CMySQLHandle::Create - connection already exists
[20:36:20] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:36:22] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:36:22] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[20:36:22] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:14:46] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:14:49] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:14:49] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:14:49] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:21:39] [WARNING] CMySQLHandle::Create - connection already exists
[17:21:41] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:21:44] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:21:44] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:21:44] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:29:00] [WARNING] CMySQLHandle::Create - connection already exists
[17:29:03] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:29:06] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:29:06] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:29:06] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:33:22] [WARNING] CMySQLHandle::Create - connection already exists
[17:33:25] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:33:27] [WARNING] cache_get_data - no active cache
[17:33:27] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:33:27] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:33:27] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:34:02] [WARNING] CMySQLHandle::Create - connection already exists
[17:34:05] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:34:07] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:34:07] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:34:07] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:34:08] [WARNING] cache_get_data - no active cache
[17:35:56] [WARNING] CMySQLHandle::Create - connection already exists
[17:35:59] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:36:01] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:36:01] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:36:01] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:50:23] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:50:25] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:50:25] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0)
[17:50:25] [ERROR] CMySQLConnection::Connect - (error #2005) Unknown MySQL server host 'Host' (0) 
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#10

25.09.2015, 20:53
Aparentemente o problema й com a conexгo. Poste os dados da conexгo (host, user e db).
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#11

25.09.2015, 20:54
PHP код:
#define Host        "localhost"
#define Usuario        "root"
#define DataBase    "samp"
#define Senha        "REAbMeu5jbWdHf34" 
@Edit

http://prntscr.com/8kgoif
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#12

25.09.2015, 20:55
Parece correto. Poste a linha com o mysql_connect.
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#13

25.09.2015, 20:56
PHP код:
conexao = mysql_connect("Host", "Usuario", "DataBase", "Senha"); 
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#14

25.09.2015, 20:58
Deixe assim:

PHP код:
conexao = mysql_connect(Host, Usuario, DataBase, Senha); 
Nгo esqueca o mysql_close em OnGameModeExit.
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#15

25.09.2015, 21:00
Foi mais agr deu esses erros

PHP код:
[17:57:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[17:57:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[17:57:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[17:57:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES) 
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#16

25.09.2015, 21:01
Parece um problema com a senha. Vocк definiu alguma senha no phpMyAdmin? Se nгo, basta deixar:
PHP код:
#define Senha "" 
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#17

25.09.2015, 21:03
Arrumei a senha faltava 1 letra mais olha esses erros/WARNING

PHP код:
[18:01:22] [WARNING] CMySQLConnection::Disconnect - no connection available
[18:01:22] [WARNING] CMySQLConnection::Disconnect - no connection available 
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#18

25.09.2015, 21:05
Й melhor vocк postar o cуdigo inteiro.
Find
Reply
JuniorTheDM
Huge Clucker
****
Posts: 433
Threads: 128
Joined: Dec 2014
Reputation: 0
#19

25.09.2015, 21:06
http://pastebin.com/0Tvh0jVz
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#20

25.09.2015, 21:09
PHP код:
public OnGameModeExit() {
    mysql_close(conexao);
    return 1;
} 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 4 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese