SA-MP Forums Archive
Trouble with Clan Member check - MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Trouble with Clan Member check - MySQL (/showthread.php?tid=480297)


Trouble with Clan Member check - MySQL - Tayab - 09.12.2013

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();
    }


Re: Trouble with Clan Member check - MySQL - Jefff - 09.12.2013

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();
}


Re: Trouble with Clan Member check - MySQL - Tayab - 09.12.2013

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

Darn! I can't +rep you.

Re: Trouble with Clan Member check - MySQL - Jefff - 09.12.2013

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)