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

Threaded Mode
[Ajuda] Ajuda fazer jeito certo MYSQL
luccagomes15
Huge Clucker
****
Posts: 392
Threads: 135
Joined: Aug 2013
Reputation: 0
#1

14.11.2015, 09:35
Alguйm me ajuda a fazer do jeito certo isso aqui do MYSQL?

CarregarServer ongamemodeinit

Код:
CarregarServer() {
	new query[50]; // Nгo precisa ser enorme como vocк tinha colocado; Precisa apenas caber sua query dentro dela
	mysql_format(ConnectMYSQL, query, sizeof(query), "SELECT * FROM server");
	mysql_function_query(ConnectMYSQL, query, true, "Carregar_Server","i");
}

Carregar_Server();
Carregar_Server() {
	new int_dest[6];
	int_dest[0] = cache_get_field_content_int(0, "donoDende");               				donoDende = int_dest[0];
	int_dest[1] = cache_get_field_content_int(0, "donoComplexo");               			donoComplexo = int_dest[1];
	int_dest[2] = cache_get_field_content_int(0, "donoUrubu");               				donoUrubu = int_dest[2];
	int_dest[3] = cache_get_field_content_int(0, "donoMangueira");               			donoMangueira = int_dest[3];
	int_dest[4] = cache_get_field_content_int(0, "donoRocinha");               				donoRocinha = int_dest[4];
	int_dest[5] = cache_get_field_content_int(0, "donoTitanic");               				donoTitanic = int_dest[5];

	cache_get_field_content(0, "god", admlist[god],1,30);
	cache_get_field_content(0, "cm1", admlist[cm1],1,30);
	cache_get_field_content(0, "cm2", admlist[cm2],1,30);
	cache_get_field_content(0, "gm1", admlist[gm1],1,30);
	cache_get_field_content(0, "gm2", admlist[gm2],1,30);
	cache_get_field_content(0, "gm3", admlist[gm3],1,30);
	cache_get_field_content(0, "gm4", admlist[gm4],1,30);
	cache_get_field_content(0, "sa1", admlist[sa1],1,30);
	cache_get_field_content(0, "sa2", admlist[sa2],1,30);
	cache_get_field_content(0, "sa3", admlist[sa3],1,30);
	cache_get_field_content(0, "sa4", admlist[sa4],1,30);
	cache_get_field_content(0, "adm1", admlist[adm1],1,30);
	cache_get_field_content(0, "adm2", admlist[adm2],1,30);
	cache_get_field_content(0, "adm3", admlist[adm3],1,30);
	cache_get_field_content(0, "adm4", admlist[adm4],1,30);
	cache_get_field_content(0, "mod1", admlist[mod1],1,30);
	cache_get_field_content(0, "mod2", admlist[mod2],1,30);
	cache_get_field_content(0, "mod3", admlist[mod3],1,30);
	cache_get_field_content(0, "mod4", admlist[mod4],1,30);
	cache_get_field_content(0, "mod5", admlist[mod5],1,30);
	cache_get_field_content(0, "mod6", admlist[mod6],1,30);
	cache_get_field_content(0, "mod7", admlist[mod7],1,30);
	cache_get_field_content(0, "mod8", admlist[mod8],1,30);
	cache_get_field_content(0, "tutor1", admlist[tutor1],1,30);
	cache_get_field_content(0, "tutor2", admlist[tutor2],1,30);
	cache_get_field_content(0, "tutor3", admlist[tutor3],1,30);
	cache_get_field_content(0, "tutor4", admlist[tutor4],1,30);
	cache_get_field_content(0, "tutor5", admlist[tutor5],1,30);
	cache_get_field_content(0, "tutor6", admlist[tutor6],1,30);
	cache_get_field_content(0, "tutor7", admlist[tutor7],1,30);
	cache_get_field_content(0, "tutor8", admlist[tutor8],1,30);
}
Find
Reply
luccagomes15
Huge Clucker
****
Posts: 392
Threads: 135
Joined: Aug 2013
Reputation: 0
#2

14.11.2015, 17:39
Imagem da tabela, se vcs precisarem, pfvr me ajudem!



http://i.imgur.com/yl0MuuI.png

http://i.imgur.com/hqJEj9h.png
Find
Reply
luccagomes15
Huge Clucker
****
Posts: 392
Threads: 135
Joined: Aug 2013
Reputation: 0
#3

15.11.2015, 16:18
( Последний раз редактировалось luccagomes15; 15.11.2015 в 18:12. )
Ta dando esse warning na hora de compilar

warning 203: symbol is never used: "Carregar_Server"


Como fazer sem ter uma id pra consultar?
Find
Reply
Marlon_Lorran
Big Clucker
***
Posts: 137
Threads: 0
Joined: Mar 2011
Reputation: 0
#4

15.11.2015, 22:03
pawn Код:
CarregarServer() {
    mysql_tquery(ConnectMYSQL, "SELECT * FROM `server`", "Carregar_Server", "");
}

Carregar_Server() {

    if(cache_get_row_count() == 0) {
        print("Nada encontrado");
        
    } else {

        new int_dest[6];
        int_dest[0] = cache_get_field_content_int(0, "donoDende");                              donoDende = int_dest[0];
        int_dest[1] = cache_get_field_content_int(0, "donoComplexo");                           donoComplexo = int_dest[1];
        int_dest[2] = cache_get_field_content_int(0, "donoUrubu");                              donoUrubu = int_dest[2];
        int_dest[3] = cache_get_field_content_int(0, "donoMangueira");                          donoMangueira = int_dest[3];
        int_dest[4] = cache_get_field_content_int(0, "donoRocinha");                            donoRocinha = int_dest[4];
        int_dest[5] = cache_get_field_content_int(0, "donoTitanic");                            donoTitanic = int_dest[5];

        cache_get_field_content(0, "god", admlist[god],1,30);
        cache_get_field_content(0, "cm1", admlist[cm1],1,30);
        cache_get_field_content(0, "cm2", admlist[cm2],1,30);
        cache_get_field_content(0, "gm1", admlist[gm1],1,30);
        cache_get_field_content(0, "gm2", admlist[gm2],1,30);
        cache_get_field_content(0, "gm3", admlist[gm3],1,30);
        cache_get_field_content(0, "gm4", admlist[gm4],1,30);
        cache_get_field_content(0, "sa1", admlist[sa1],1,30);
        cache_get_field_content(0, "sa2", admlist[sa2],1,30);
        cache_get_field_content(0, "sa3", admlist[sa3],1,30);
        cache_get_field_content(0, "sa4", admlist[sa4],1,30);
        cache_get_field_content(0, "adm1", admlist[adm1],1,30);
        cache_get_field_content(0, "adm2", admlist[adm2],1,30);
        cache_get_field_content(0, "adm3", admlist[adm3],1,30);
        cache_get_field_content(0, "adm4", admlist[adm4],1,30);
        cache_get_field_content(0, "mod1", admlist[mod1],1,30);
        cache_get_field_content(0, "mod2", admlist[mod2],1,30);
        cache_get_field_content(0, "mod3", admlist[mod3],1,30);
        cache_get_field_content(0, "mod4", admlist[mod4],1,30);
        cache_get_field_content(0, "mod5", admlist[mod5],1,30);
        cache_get_field_content(0, "mod6", admlist[mod6],1,30);
        cache_get_field_content(0, "mod7", admlist[mod7],1,30);
        cache_get_field_content(0, "mod8", admlist[mod8],1,30);
        cache_get_field_content(0, "tutor1", admlist[tutor1],1,30);
        cache_get_field_content(0, "tutor2", admlist[tutor2],1,30);
        cache_get_field_content(0, "tutor3", admlist[tutor3],1,30);
        cache_get_field_content(0, "tutor4", admlist[tutor4],1,30);
        cache_get_field_content(0, "tutor5", admlist[tutor5],1,30);
        cache_get_field_content(0, "tutor6", admlist[tutor6],1,30);
        cache_get_field_content(0, "tutor7", admlist[tutor7],1,30);
        cache_get_field_content(0, "tutor8", admlist[tutor8],1,30);
    }   
}
Find
Reply
luccagomes15
Huge Clucker
****
Posts: 392
Threads: 135
Joined: Aug 2013
Reputation: 0
#5

16.11.2015, 00:10
Quote:
Originally Posted by Marlon_Lorran
Посмотреть сообщение
pawn Код:
CarregarServer() {
    mysql_tquery(ConnectMYSQL, "SELECT * FROM `server`", "Carregar_Server", "");
}

Carregar_Server() {

    if(cache_get_row_count() == 0) {
        print("Nada encontrado");
        
    } else {

        new int_dest[6];
        int_dest[0] = cache_get_field_content_int(0, "donoDende");                              donoDende = int_dest[0];
        int_dest[1] = cache_get_field_content_int(0, "donoComplexo");                           donoComplexo = int_dest[1];
        int_dest[2] = cache_get_field_content_int(0, "donoUrubu");                              donoUrubu = int_dest[2];
        int_dest[3] = cache_get_field_content_int(0, "donoMangueira");                          donoMangueira = int_dest[3];
        int_dest[4] = cache_get_field_content_int(0, "donoRocinha");                            donoRocinha = int_dest[4];
        int_dest[5] = cache_get_field_content_int(0, "donoTitanic");                            donoTitanic = int_dest[5];

        cache_get_field_content(0, "god", admlist[god],1,30);
        cache_get_field_content(0, "cm1", admlist[cm1],1,30);
        cache_get_field_content(0, "cm2", admlist[cm2],1,30);
        cache_get_field_content(0, "gm1", admlist[gm1],1,30);
        cache_get_field_content(0, "gm2", admlist[gm2],1,30);
        cache_get_field_content(0, "gm3", admlist[gm3],1,30);
        cache_get_field_content(0, "gm4", admlist[gm4],1,30);
        cache_get_field_content(0, "sa1", admlist[sa1],1,30);
        cache_get_field_content(0, "sa2", admlist[sa2],1,30);
        cache_get_field_content(0, "sa3", admlist[sa3],1,30);
        cache_get_field_content(0, "sa4", admlist[sa4],1,30);
        cache_get_field_content(0, "adm1", admlist[adm1],1,30);
        cache_get_field_content(0, "adm2", admlist[adm2],1,30);
        cache_get_field_content(0, "adm3", admlist[adm3],1,30);
        cache_get_field_content(0, "adm4", admlist[adm4],1,30);
        cache_get_field_content(0, "mod1", admlist[mod1],1,30);
        cache_get_field_content(0, "mod2", admlist[mod2],1,30);
        cache_get_field_content(0, "mod3", admlist[mod3],1,30);
        cache_get_field_content(0, "mod4", admlist[mod4],1,30);
        cache_get_field_content(0, "mod5", admlist[mod5],1,30);
        cache_get_field_content(0, "mod6", admlist[mod6],1,30);
        cache_get_field_content(0, "mod7", admlist[mod7],1,30);
        cache_get_field_content(0, "mod8", admlist[mod8],1,30);
        cache_get_field_content(0, "tutor1", admlist[tutor1],1,30);
        cache_get_field_content(0, "tutor2", admlist[tutor2],1,30);
        cache_get_field_content(0, "tutor3", admlist[tutor3],1,30);
        cache_get_field_content(0, "tutor4", admlist[tutor4],1,30);
        cache_get_field_content(0, "tutor5", admlist[tutor5],1,30);
        cache_get_field_content(0, "tutor6", admlist[tutor6],1,30);
        cache_get_field_content(0, "tutor7", admlist[tutor7],1,30);
        cache_get_field_content(0, "tutor8", admlist[tutor8],1,30);
    }   
}
Te dei um rep aqui, mas nгo funcionou e na hora de compilar deu isso

Код:
warning 203: symbol is never used: "Carregar_Server"
Find
Reply
Coringa_Vilao
High-roller
*****
Posts: 1,113
Threads: 97
Joined: Sep 2012
Reputation: 0
#6

16.11.2015, 00:26
Erro = Simbolo nunca usado , tente fazer em callback ...
Find
Reply
Marlon_Lorran
Big Clucker
***
Posts: 137
Threads: 0
Joined: Mar 2011
Reputation: 0
#7

16.11.2015, 01:41
( Последний раз редактировалось Marlon_Lorran; 16.11.2015 в 02:43. )
Quote:
Originally Posted by luccagomes15
Посмотреть сообщение
Te dei um rep aqui, mas nгo funcionou e na hora de compilar deu isso

Код:
warning 203: symbol is never used: "Carregar_Server"
PHP код:
CarregarServer() {
    mysql_tquery(ConnectMYSQL, "SELECT * FROM `server`", "Carregar_Server", "");
}
forward Carregar_Server();
public Carregar_Server() {
    if(cache_get_row_count() == 0) {
        print("Nada encontrado");
        
    } else {
        new int_dest[6];
        int_dest[0] = cache_get_field_content_int(0, "donoDende");                               donoDende = int_dest[0];
        int_dest[1] = cache_get_field_content_int(0, "donoComplexo");                           donoComplexo = int_dest[1];
        int_dest[2] = cache_get_field_content_int(0, "donoUrubu");                               donoUrubu = int_dest[2];
        int_dest[3] = cache_get_field_content_int(0, "donoMangueira");                           donoMangueira = int_dest[3];
        int_dest[4] = cache_get_field_content_int(0, "donoRocinha");                               donoRocinha = int_dest[4];
        int_dest[5] = cache_get_field_content_int(0, "donoTitanic");                               donoTitanic = int_dest[5];
        cache_get_field_content(0, "god", admlist[god]);
        cache_get_field_content(0, "cm1", admlist[cm1]);
        cache_get_field_content(0, "cm2", admlist[cm2]);
        cache_get_field_content(0, "gm1", admlist[gm1]);
        cache_get_field_content(0, "gm2", admlist[gm2]);
        cache_get_field_content(0, "gm3", admlist[gm3]);
        cache_get_field_content(0, "gm4", admlist[gm4]);
        cache_get_field_content(0, "sa1", admlist[sa1]);
        cache_get_field_content(0, "sa2", admlist[sa2]);
        cache_get_field_content(0, "sa3", admlist[sa3]);
        cache_get_field_content(0, "sa4", admlist[sa4]);
        cache_get_field_content(0, "adm1", admlist[adm1]);
        cache_get_field_content(0, "adm2", admlist[adm2]);
        cache_get_field_content(0, "adm3", admlist[adm3]);
        cache_get_field_content(0, "adm4", admlist[adm4]);
        cache_get_field_content(0, "mod1", admlist[mod1]);
        cache_get_field_content(0, "mod2", admlist[mod2]);
        cache_get_field_content(0, "mod3", admlist[mod3]);
        cache_get_field_content(0, "mod4", admlist[mod4]);
        cache_get_field_content(0, "mod5", admlist[mod5]);
        cache_get_field_content(0, "mod6", admlist[mod6]);
        cache_get_field_content(0, "mod7", admlist[mod7]);
        cache_get_field_content(0, "mod8", admlist[mod8]);
        cache_get_field_content(0, "tutor1", admlist[tutor1]);
        cache_get_field_content(0, "tutor2", admlist[tutor2]);
        cache_get_field_content(0, "tutor3", admlist[tutor3]);
        cache_get_field_content(0, "tutor4", admlist[tutor4]);
        cache_get_field_content(0, "tutor5", admlist[tutor5]);
        cache_get_field_content(0, "tutor6", admlist[tutor6]);
        cache_get_field_content(0, "tutor7", admlist[tutor7]);
        cache_get_field_content(0, "tutor8", admlist[tutor8]);
    }    
} 
Tente agora!
Find
Reply
luccagomes15
Huge Clucker
****
Posts: 392
Threads: 135
Joined: Aug 2013
Reputation: 0
#8

16.11.2015, 03:13
Quote:
Originally Posted by Marlon_Lorran
Посмотреть сообщение
PHP код:
CarregarServer() {
    mysql_tquery(ConnectMYSQL, "SELECT * FROM `server`", "Carregar_Server", "");
}
forward Carregar_Server();
public Carregar_Server() {
    if(cache_get_row_count() == 0) {
        print("Nada encontrado");
        
    } else {
        new int_dest[6];
        int_dest[0] = cache_get_field_content_int(0, "donoDende");                               donoDende = int_dest[0];
        int_dest[1] = cache_get_field_content_int(0, "donoComplexo");                           donoComplexo = int_dest[1];
        int_dest[2] = cache_get_field_content_int(0, "donoUrubu");                               donoUrubu = int_dest[2];
        int_dest[3] = cache_get_field_content_int(0, "donoMangueira");                           donoMangueira = int_dest[3];
        int_dest[4] = cache_get_field_content_int(0, "donoRocinha");                               donoRocinha = int_dest[4];
        int_dest[5] = cache_get_field_content_int(0, "donoTitanic");                               donoTitanic = int_dest[5];
        cache_get_field_content(0, "god", admlist[god]);
        cache_get_field_content(0, "cm1", admlist[cm1]);
        cache_get_field_content(0, "cm2", admlist[cm2]);
        cache_get_field_content(0, "gm1", admlist[gm1]);
        cache_get_field_content(0, "gm2", admlist[gm2]);
        cache_get_field_content(0, "gm3", admlist[gm3]);
        cache_get_field_content(0, "gm4", admlist[gm4]);
        cache_get_field_content(0, "sa1", admlist[sa1]);
        cache_get_field_content(0, "sa2", admlist[sa2]);
        cache_get_field_content(0, "sa3", admlist[sa3]);
        cache_get_field_content(0, "sa4", admlist[sa4]);
        cache_get_field_content(0, "adm1", admlist[adm1]);
        cache_get_field_content(0, "adm2", admlist[adm2]);
        cache_get_field_content(0, "adm3", admlist[adm3]);
        cache_get_field_content(0, "adm4", admlist[adm4]);
        cache_get_field_content(0, "mod1", admlist[mod1]);
        cache_get_field_content(0, "mod2", admlist[mod2]);
        cache_get_field_content(0, "mod3", admlist[mod3]);
        cache_get_field_content(0, "mod4", admlist[mod4]);
        cache_get_field_content(0, "mod5", admlist[mod5]);
        cache_get_field_content(0, "mod6", admlist[mod6]);
        cache_get_field_content(0, "mod7", admlist[mod7]);
        cache_get_field_content(0, "mod8", admlist[mod8]);
        cache_get_field_content(0, "tutor1", admlist[tutor1]);
        cache_get_field_content(0, "tutor2", admlist[tutor2]);
        cache_get_field_content(0, "tutor3", admlist[tutor3]);
        cache_get_field_content(0, "tutor4", admlist[tutor4]);
        cache_get_field_content(0, "tutor5", admlist[tutor5]);
        cache_get_field_content(0, "tutor6", admlist[tutor6]);
        cache_get_field_content(0, "tutor7", admlist[tutor7]);
        cache_get_field_content(0, "tutor8", admlist[tutor8]);
    }    
} 
Tente agora!
Agora nгo ta dando warnings, mas nгo ta carregando
Find
Reply
Marlon_Lorran
Big Clucker
***
Posts: 137
Threads: 0
Joined: Mar 2011
Reputation: 0
#9

16.11.2015, 03:21
Quote:
Originally Posted by luccagomes15
Посмотреть сообщение
Agora nгo ta dando warnings, mas nгo ta carregando
Sua tabela `server` retorna ao menos um registro?
Me mande sua variбvel admlist
Find
Reply
Marlon_Lorran
Big Clucker
***
Posts: 137
Threads: 0
Joined: Mar 2011
Reputation: 0
#10

16.11.2015, 12:22
Quando voce liga o server la no console aparece a menaagem "Nada encontrado"?.

Se tiver aparecendo Vai la no phpmyadmin clica na tabela `server` clica em INSERE e clica em Executar.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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