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

Threaded Mode
[Ajuda] invalid row index ('0')
_Play_
Huge Clucker
****
Posts: 424
Threads: 57
Joined: Jun 2014
Reputation: 0
#1

15.07.2015, 17:30
[14:29:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[14:29:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[14:29:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[14:29:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[14:29:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

Provavelmente deve se nos cache_get_field_content oque tem de errado?
Код:
	
function: CheckPlayerBan(playerid)
{
    new Query[300];
	SendClientMessage(playerid,-1, "Checando Listas de banidos...");
	print("erro 1");  //bug
	format(Query, sizeof(Query), "SELECT * FROM `banidos` WHERE `nome` = '%s'", GetNome(playerid));
	mysql_function_query(mysql, Query, true, "r@CheckPlayerBan", "i", playerid);
	print("erro 2");	
	return 1;
}

function: r@CheckPlayerBan(playerid)
{
	new Rows,
	    Fields,
	    Pegar[32],
		Printar[290];

	cache_get_data(Rows,Fields,mysql);
	
	cache_get_field_content(0,"nome",Pegar,mysql);
	format(Banidos[playerid][NomeBan],24,"%s",Pegar);
	cache_get_field_content(0,"admin",Pegar,mysql);
	format(Banidos[playerid][AdminBan],24,"%s",Pegar);
	cache_get_field_content(0,"motivo",Pegar,mysql);
	format(Banidos[playerid][Motivo],45,"%s",Pegar);
	cache_get_field_content(0,"data",Pegar,mysql);
	format(Banidos[playerid][Data],10,"%s",Pegar);
	cache_get_field_content(0,"hora",Pegar,mysql);
	format(Banidos[playerid][Hora],10,"%s",Pegar);
	
	if(!strcmp(Banidos[playerid][NomeBan],GetNome(playerid),false))
	{

		print("chegou aqui");
		format(Printar,sizeof(Printar),"{FFFFFF}Vocк esta Banido...!\nMotivo do Banimento: {FF8200}%s{FFFFFF}\nAdmin responsavel: {FF8200}%s{FFFFFF}\nData: {FF8200}%s{FFFFFF}\nHorбrio: {FF8200}%s\n{FFFFFF}Atenciosamente: Equipe Trucking Live™",
		Banidos[playerid][Motivo],Banidos[playerid][AdminBan],Banidos[playerid][Data],Banidos[playerid][Hora]);
		ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"{FFFFFF}Banido",Printar,"Confirmar","");

		printf("Nome: %s |Admin: %s |Motivo: %s |data %s |hora %s",Banidos[playerid][NomeBan],Banidos[playerid][AdminBan],Banidos[playerid][Motivo],
		Banidos[playerid][Data],Banidos[playerid][Hora]);
		
		Kicka(playerid);
		return 1;
	}
	



	SendClientMessage(playerid,-1," ");
	SendClientMessage(playerid,-1," ");
	return 1;
}
Find
Reply
FallweN
Huge Clucker
****
Posts: 444
Threads: 4
Joined: Jan 2014
Reputation: 0
#2

15.07.2015, 20:32
PHP код:
function: CheckPlayerBan(playerid)
{
    new Query[300];
    SendClientMessage(playerid,-1, "Checando Listas de banidos...");
    print("erro 1");  //bug
    format(Query, sizeof(Query), "SELECT * FROM `banidos` WHERE `nome` = '%s'", GetNome(playerid));
    mysql_function_query(mysql, Query, true, "r@CheckPlayerBan", "i", playerid);
    print("erro 2");
    return 1;
}

function: r@CheckPlayerBan(playerid)
{
    new Rows,
        Fields,
        Pegar[32],
        Printar[290];

    cache_get_data(Rows,Fields,mysql);
    
    format(Banidos[playerid][NomeBan],24,"%s",Pegar);
    cache_get_field_content(0,"nome",Pegar,mysql);
    format(Banidos[playerid][AdminBan],24,"%s",Pegar);
    cache_get_field_content(0,"admin",Pegar,mysql);
    format(Banidos[playerid][Motivo],45,"%s",Pegar);
    cache_get_field_content(0,"motivo",Pegar,mysql);
    format(Banidos[playerid][Data],10,"%s",Pegar);
    cache_get_field_content(0,"data",Pegar,mysql);
    format(Banidos[playerid][Hora],10,"%s",Pegar);
    cache_get_field_content(0,"hora",Pegar,mysql);

    if(!strcmp(Banidos[playerid][NomeBan],GetNome(playerid),false))
    {

        print("chegou aqui");
        format(Printar,sizeof(Printar),"{FFFFFF}Vocк esta Banido...!\nMotivo do Banimento: {FF8200}%s{FFFFFF}\nAdmin responsavel: {FF8200}%s{FFFFFF}\nData: {FF8200}%s{FFFFFF}\nHorбrio: {FF8200}%s\n{FFFFFF}Atenciosamente: Equipe Trucking Live™",
        Banidos[playerid][Motivo],Banidos[playerid][AdminBan],Banidos[playerid][Data],Banidos[playerid][Hora]);
        ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"{FFFFFF}Banido",Printar,"Confirmar","");

        printf("Nome: %s |Admin: %s |Motivo: %s |data %s |hora %s",Banidos[playerid][NomeBan],Banidos[playerid][AdminBan],Banidos[playerid][Motivo],
        Banidos[playerid][Data],Banidos[playerid][Hora]);

        Kicka(playerid);
        return 1;
    }




    SendClientMessage(playerid,-1," ");
    SendClientMessage(playerid,-1," ");
    return 1;
} 
Vк agora.
Find
Reply
_Play_
Huge Clucker
****
Posts: 424
Threads: 57
Joined: Jun 2014
Reputation: 0
#3

15.07.2015, 20:47
No server log[17:46:29] Nome: |Admin: NULL |Motivo: NULL |data NULL |hora NULL


no mysql log

[17:46:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[17:46:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[17:46:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[17:46:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[17:46:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
Find
Reply
FallweN
Huge Clucker
****
Posts: 444
Threads: 4
Joined: Jan 2014
Reputation: 0
#4

15.07.2015, 20:52
PHP код:
function: CheckPlayerBan(playerid)
{
    new Query[300];
    SendClientMessage(playerid,-1, "Checando Listas de banidos...");
    print("erro 1");  //bug
    format(Query, sizeof(Query), "SELECT * FROM `banidos` WHERE `nome` = '%s'", GetNome(playerid));
    mysql_function_query(mysql, Query, true, "r@CheckPlayerBan", "i", playerid);
    print("erro 2");
    return 1;
}

function: r@CheckPlayerBan(playerid)
{
    new Rows,
        Fields,
        Pegar[32],
        Printar[290];

    cache_get_data(Rows,Fields,mysql);

    cache_get_field_content(0,"nome",Pegar,mysql);
    format(Pegar, 24, "%s", Banidos[playerid][NomeBan]);
    cache_get_field_content(0,"admin",Pegar,mysql);
    format(Pegar, 24, "%s", Banidos[playerid][AdminBan]);
    cache_get_field_content(0,"motivo",Pegar,mysql);
    format(Pegar, 45, "%s", Banidos[playerid][Motivo]);
    cache_get_field_content(0,"data",Pegar,mysql);
    format(Pegar, 10, "%s", Banidos[playerid][Data]);
    cache_get_field_content(0,"hora",Pegar,mysql);
    format(Pegar, 10, "%s", Banidos[playerid][Hora]);

    if(!strcmp(Banidos[playerid][NomeBan],GetNome(playerid),false))
    {

        print("chegou aqui");
        format(Printar,sizeof(Printar),"{FFFFFF}Vocк esta Banido...!\nMotivo do Banimento: {FF8200}%s{FFFFFF}\nAdmin responsavel: {FF8200}%s{FFFFFF}\nData: {FF8200}%s{FFFFFF}\nHorбrio: {FF8200}%s\n{FFFFFF}Atenciosamente: Equipe Trucking Live™",
        Banidos[playerid][Motivo],Banidos[playerid][AdminBan],Banidos[playerid][Data],Banidos[playerid][Hora]);
        ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"{FFFFFF}Banido",Printar,"Confirmar","");

        printf("Nome: %s |Admin: %s |Motivo: %s |data %s |hora %s",Banidos[playerid][NomeBan],Banidos[playerid][AdminBan],Banidos[playerid][Motivo],
        Banidos[playerid][Data],Banidos[playerid][Hora]);

        Kicka(playerid);
        return 1;
    }




    SendClientMessage(playerid,-1," ");
    SendClientMessage(playerid,-1," ");
    return 1;
} 
Tenta ae.
Find
Reply
_Play_
Huge Clucker
****
Posts: 424
Threads: 57
Joined: Jun 2014
Reputation: 0
#5

15.07.2015, 21:01
Mesma coisa

[18:01:16] chegou aqui
[18:01:16] Nome: |Admin: |Motivo: |data |hora

[18:01:16] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[18:01:16] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[18:01:16] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[18:01:16] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[18:01:16] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')


Na verdade o cуdigo inicial ta funcionando sу que com esses erros ai fiquei na dъvida e decidi abrir o tуpico.
Find
Reply
Juniiro3
High-roller
*****
Posts: 1,800
Threads: 67
Joined: Feb 2013
Reputation: 0
#6

15.07.2015, 22:59
1є Atualize seu MySQL para a versгo mais recente.
2є:

Код:
function: r@CheckPlayerBan(playerid)
{
    new Rows,
        Fields,
        Pegar[32],
        Printar[290];

    cache_get_data(Rows,Fields,mysql);

    if (Rows)
    {
        cache_get_field_content(0,"nome",Pegar,mysql);
        format(Pegar, 24, "%s", Banidos[playerid][NomeBan]);
        cache_get_field_content(0,"admin",Pegar,mysql);
        format(Pegar, 24, "%s", Banidos[playerid][AdminBan]);
        cache_get_field_content(0,"motivo",Pegar,mysql);
        format(Pegar, 45, "%s", Banidos[playerid][Motivo]);
        cache_get_field_content(0,"data",Pegar,mysql);
        format(Pegar, 10, "%s", Banidos[playerid][Data]);
        cache_get_field_content(0,"hora",Pegar,mysql);
        format(Pegar, 10, "%s", Banidos[playerid][Hora]);

        if(!strcmp(Banidos[playerid][NomeBan],GetNome(playerid),false))
        {

            format(Printar,sizeof(Printar),"{FFFFFF}Vocк esta Banido...!\nMotivo do Banimento: {FF8200}%s{FFFFFF}\nAdmin responsavel: {FF8200}%s{FFFFFF}\nData: {FF8200}%s{FFFFFF}\nHorбrio: {FF8200}%s\n{FFFFFF}Atenciosamente: Equipe Trucking Live™",
            Banidos[playerid][Motivo],Banidos[playerid][AdminBan],Banidos[playerid][Data],Banidos[playerid][Hora]);
            ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"{FFFFFF}Banido",Printar,"Confirmar","");

            printf("Nome: %s |Admin: %s |Motivo: %s |data %s |hora %s",Banidos[playerid][NomeBan],Banidos[playerid][AdminBan],Banidos[playerid][Motivo],
            Banidos[playerid][Data],Banidos[playerid][Hora]);

            Kicka(playerid);
            return 1;
        }


        SendClientMessage(playerid,-1," ");
        SendClientMessage(playerid,-1," ");
    }

    
    return 1;
}
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