Trouble with Clan Member check - MySQL
#1

So I created a script which checks if player has been given clan member rank, if he's not given and he comes with the tag on, he'll be kicked.

Here is what I got in OnPlayerConnect and it doesn't do anything.

pawn Код:
if(strfind(pName(playerid),"[Tm]",false,0) == 1)
    {
        format(query,sizeof(query),"SELECT `clanmember` FROM `users` WHERE `username` = '%s'",pName(playerid));
        mysql_query(query);
        mysql_store_result();
        while(mysql_fetch_row_format(query,"|"))
        {
            mysql_fetch_field_row(data, "clanmember");
            if(strval(data) != 1)
                KickWithMessage(playerid,"You're not in clan, remove your clan tag.");
        }
        mysql_free_result();
    }
Reply
#2

pawn Код:
if(!strcmp(pName(playerid),"[Tm]",false,4))
{
    format(query,sizeof(query),"SELECT `clanmember` FROM `users` WHERE `username` = '%s' LIMIT 0,1",pName(playerid));
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows())
    {
        mysql_next_row();
        mysql_fetch_field_row(data, "clanmember");
    }

    if(strval(data) != 1)
        KickWithMessage(playerid,"You're not in clan, remove your clan tag.");

    mysql_free_result();
}
Reply
#3

Thanks! I'll read about strcmp on SA-MP wikki.

Darn! I can't +rep you.
Reply
#4

use mysql_fetch_int is better for one integer

replace

pawn Код:
if(mysql_num_rows())
{
    mysql_next_row();
    mysql_fetch_field_row(data, "clanmember");
}

if(strval(data) != 1)
to

pawn Код:
new clanmember = 0;
if(mysql_num_rows())
{
    clanmember = mysql_fetch_int();
}

if(clanmember == 0)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)