Groupmember SQLITE
#1

What's Wrong with this code, it's not show anything when i type /groupmember <gname>
i'm using easydb by gammix


Код:
CMD:groupmember(playerid,params[])
{
	new gname[30],pname[MAX_PLAYER_NAME+1],str[1024],str2[128],id, query[256];
	if(sscanf(params,"s[30]",gname)) return SendClientMessage(playerid, COLOR_WHITE, "{B7B7B7}[SERVER] {FFFFFF}Usage: \"groupmember <groupname>\"");
	if(strlen(gname) > 30)return SendClientMessage(playerid,-1,"{FF0000}[ERROR] {FFFFFF}Name of group max is 30 Char");
	new DBResult:result;
	id = DB_RetrieveKey(Group_Table,"GroupName",gname);
 	if(id != DB_INVALID_KEY)
  	{
		format(query, sizeof query, "SELECT * FROM `GroupMembers` WHERE `GroupName`='%s'", DB::Escape(gname));
		result = DB::Query(query);
		for(new a;a<db_num_rows(result);a++)
		{
		    db_get_field_assoc(result, "UserName", pname, sizeof pname);
			strcat(str,pname);
	  		strcat(str,"\n");
			db_next_row(result);
		}
		format(str2,sizeof(str2),"Member Group : %s",gname);
		ShowPlayerDialog(playerid,DIALOG_GMEMBERS,DIALOG_STYLE_MSGBOX,str2,str,"Close","");
	}
	else SendClientMessage(playerid,-1,"{FF0000}[ERROR] {FFFFFF}Invalid Group name");
	return 1;
}
Someone can help me to fix this code ?
Reply


Messages In This Thread
Groupmember SQLITE - by SilverStand - 22.12.2015, 23:03
Re: Groupmember SQLITE - by SilverStand - 23.12.2015, 01:31
Re: Groupmember SQLITE - by Gammix - 23.12.2015, 01:48
Re: Groupmember SQLITE - by SilverStand - 23.12.2015, 01:56
Re: Groupmember SQLITE - by SilverStand - 23.12.2015, 09:32
Re: Groupmember SQLITE - by thefirestate - 23.12.2015, 10:22
Re: Groupmember SQLITE - by Gammix - 24.12.2015, 01:41
Re: Groupmember SQLITE - by SilverStand - 24.12.2015, 05:05
Re: Groupmember SQLITE - by SilverStand - 24.12.2015, 06:12

Forum Jump:


Users browsing this thread: 1 Guest(s)