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

Threaded Mode
[Ajuda] Nгo entra mais no ROW MYSQL
binnyl
Huge Clucker
****
Posts: 290
Threads: 46
Joined: Aug 2017
Reputation: 0
#1

21.01.2018, 17:14
( Последний раз редактировалось binnyl; 24.01.2018 в 08:11. )
Esse й meu sistema de empresas, criadas ingame e atualizadas na hora ingame (ou pelo menos atualizava antigamente)
Acho que eu fiz algo errado e nгo estб mais atualizando, usando uns printf eu descobri que nгo estб entrando nessa parte do cуdigo:

if(rows) {
em:
public Carregar_Business(bizzid) {

Estб printando:
created
loading ID
mas o ROW nгo estб printando

Alguйm sabe como arrumar?

PHP код:
CMD:makebizz(playerid, params[]) {
    new bizzid, name[30], type;
    if(sscanf(params,"iis[30]", bizzid, type, name)) {
        SendClientMessage(playerid, -1, "Use: /makebizz [id] [type] [name]");
        return 1;
    }
    if(bizzid < 1 && bizzid > MAX_BIZZ) return SendClientMessage(playerid, -1, "Choose a number between 1-MAX_BIZZ");
    if(strlen(name) > 30) return SendClientMessage(playerid, -1, "The name can not have more then 30 caracters");
    new Float:x, Float:y, Float:z;
    GetPlayerPos(playerid, x, y, z);
    BizzInfo[bizzid][bizzX] = x;
    BizzInfo[bizzid][bizzY] = y;
    BizzInfo[bizzid][bizzZ] = z;
    BizzInfo[bizzid][bizzName] = name;
    BizzInfo[bizzid][bizzType] = type;
    BizzInfo[bizzid][bizzID] = bizzid;
    new query[1030];
    mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `business` SET `bizzType` = '%d', `bizzX` = '%f', `bizzY` = '%f', `bizzZ` = '%f', `bizzName` = '%s', `bizzOWNER` = '%d' WHERE `bizzID` = '%i'",
        BizzInfo[bizzid][bizzType],
        BizzInfo[bizzid][bizzX],
        BizzInfo[bizzid][bizzY],
        BizzInfo[bizzid][bizzZ],
        BizzInfo[bizzid][bizzName],
        BizzInfo[bizzid][bizzOWNER],
    bizzid);
    mysql_pquery(ConnectMYSQL, query);
    printf("created");
    Carregar_Business(bizzid);
    return 1;
} 
PHP код:
forward Carregar_Business(bizzid);
public Carregar_Business(bizzid) {
    printf("loading %i", bizzid);
    new string[256], rows, fields;
    cache_get_row_count(rows);
    cache_get_field_count(fields);
    if(rows) {
          printf("ROW");
          // ints
          cache_get_value_int(0, "bizzID", BizzInfo[bizzid][bizzID]);
          cache_get_value_int(0, "bizzType", BizzInfo[bizzid][bizzType]);
          cache_get_value_int(0, "bizzOWNER", BizzInfo[bizzid][bizzOWNER]);
        // floats
        cache_get_value_float(0, "bizzX", BizzInfo[bizzid][bizzX]);
        cache_get_value_float(0, "bizzY", BizzInfo[bizzid][bizzY]);
        cache_get_value_float(0, "bizzZ", BizzInfo[bizzid][bizzZ]);
        // strings
        cache_get_value_name(0, "bizzName", BizzInfo[bizzid][bizzName], 30);
        // pickup
        if(BizzInfo[bizzid][bizzType] != 0) {
            DestroyDynamicPickup(PickupBizz[bizzid]);
            DestroyDynamic3DTextLabel(Text3Dbizz[bizzid]);
            format(string, sizeof(string), "(BID:%i)%s.\nPress 'F' to enter.",  BizzInfo[bizzid][bizzID], BizzInfo[bizzid][bizzName]);
            Text3Dbizz[bizzid] = CreateDynamic3DTextLabel(string, 0xABDEACFF, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], 10.0);
            PickupBizz[bizzid] = CreateDynamicPickup(1239, 1, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], -1);
        }
    }
} 
Find
Reply
binnyl
Huge Clucker
****
Posts: 290
Threads: 46
Joined: Aug 2017
Reputation: 0
#2

24.01.2018, 08:06
bump
Find
Reply
binnyl
Huge Clucker
****
Posts: 290
Threads: 46
Joined: Aug 2017
Reputation: 0
#3

25.01.2018, 23:21
bump
Find
Reply
Marllun
Gangsta
*****
Posts: 907
Threads: 45
Joined: Oct 2016
Reputation: 0
#4

25.01.2018, 23:41
Vai na pasta do seu gm logs/plugins/mysql.txt e manda o erro
Find
Reply
binnyl
Huge Clucker
****
Posts: 290
Threads: 46
Joined: Aug 2017
Reputation: 0
#5

26.01.2018, 00:31
Quote:
Originally Posted by Marllun
Посмотреть сообщение
Vai na pasta do seu gm logs/plugins/mysql.txt e manda o erro
Bom saber desses logs, achei varios errors pra corrigir, mas o do tуpico eu nгo consegui...
Fica pritnado:
[23:24:46] [plugins/mysql] cache_get_row_count: no active cache (GM.pwn:17916 -> GM.pwn:2374
[23:24:46] [plugins/mysql] cache_get_field_count: no active cache (GM.pwn:17917 -> GM.pwn:2374

23748
Carregar_Business(bizzid);

17916, 17917
cache_get_row_count(rows);
cache_get_field_count(fields);

Tentei trocar Carregar_Business(bizzid); por mysql_tquery(ConnectMYSQL, query, "Carregar_Business", "i", bizzid);
Nгo printou erros, mas nгo funcionou.
Find
Reply
Marllun
Gangsta
*****
Posts: 907
Threads: 45
Joined: Oct 2016
Reputation: 0
#6

26.01.2018, 01:29
Vocк esqueceu de selecionar, exemplo:
PHP код:
format(query, sizeof(query), "SELECT * FROM usuarios WHERE Nome='%s' LIMIT 1", PegarNome(playerid)); 
PHP код:
forward Carregar_Business(bizzid); 
public Carregar_Business(bizzid) { 
    printf("loading %i", bizzid); 
    new string[256], rows; 
    cache_get_row_count(rows); 
    if(rows) { 
        printf("ROW"); 
        // ints 
        cache_get_value_int(0, "bizzID", BizzInfo[bizzid][bizzID]); 
        cache_get_value_int(0, "bizzType", BizzInfo[bizzid][bizzType]); 
        cache_get_value_int(0, "bizzOWNER", BizzInfo[bizzid][bizzOWNER]); 
        // floats 
        cache_get_value_float(0, "bizzX", BizzInfo[bizzid][bizzX]); 
        cache_get_value_float(0, "bizzY", BizzInfo[bizzid][bizzY]); 
        cache_get_value_float(0, "bizzZ", BizzInfo[bizzid][bizzZ]); 
        // strings 
        cache_get_value_name(0, "bizzName", BizzInfo[bizzid][bizzName], 30); 
        // pickup 
        if(BizzInfo[bizzid][bizzType] != 0) { 
            DestroyDynamicPickup(PickupBizz[bizzid]); 
            DestroyDynamic3DTextLabel(Text3Dbizz[bizzid]); 
            format(string, sizeof(string), "(BID:%i)%s.\nPress 'F' to enter.",  BizzInfo[bizzid][bizzID], BizzInfo[bizzid][bizzName]); 
            Text3Dbizz[bizzid] = CreateDynamic3DTextLabel(string, 0xABDEACFF, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], 10.0); 
            PickupBizz[bizzid] = CreateDynamicPickup(1239, 1, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], -1); 
        } 
    } 
} 
Find
Reply
binnyl
Huge Clucker
****
Posts: 290
Threads: 46
Joined: Aug 2017
Reputation: 0
#7

27.01.2018, 03:43
Quote:
Originally Posted by Marllun
Посмотреть сообщение
Vocк esqueceu de selecionar, exemplo:
PHP код:
format(query, sizeof(query), "SELECT * FROM usuarios WHERE Nome='%s' LIMIT 1", PegarNome(playerid)); 
PHP код:
forward Carregar_Business(bizzid); 
public Carregar_Business(bizzid) { 
    printf("loading %i", bizzid); 
    new string[256], rows; 
    cache_get_row_count(rows); 
    if(rows) { 
        printf("ROW"); 
        // ints 
        cache_get_value_int(0, "bizzID", BizzInfo[bizzid][bizzID]); 
        cache_get_value_int(0, "bizzType", BizzInfo[bizzid][bizzType]); 
        cache_get_value_int(0, "bizzOWNER", BizzInfo[bizzid][bizzOWNER]); 
        // floats 
        cache_get_value_float(0, "bizzX", BizzInfo[bizzid][bizzX]); 
        cache_get_value_float(0, "bizzY", BizzInfo[bizzid][bizzY]); 
        cache_get_value_float(0, "bizzZ", BizzInfo[bizzid][bizzZ]); 
        // strings 
        cache_get_value_name(0, "bizzName", BizzInfo[bizzid][bizzName], 30); 
        // pickup 
        if(BizzInfo[bizzid][bizzType] != 0) { 
            DestroyDynamicPickup(PickupBizz[bizzid]); 
            DestroyDynamic3DTextLabel(Text3Dbizz[bizzid]); 
            format(string, sizeof(string), "(BID:%i)%s.\nPress 'F' to enter.",  BizzInfo[bizzid][bizzID], BizzInfo[bizzid][bizzName]); 
            Text3Dbizz[bizzid] = CreateDynamic3DTextLabel(string, 0xABDEACFF, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], 10.0); 
            PickupBizz[bizzid] = CreateDynamicPickup(1239, 1, BizzInfo[bizzid][bizzX], BizzInfo[bizzid][bizzY], BizzInfo[bizzid][bizzZ], -1); 
        } 
    } 
} 
VISH, й verdade, mt obrigado +REP
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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