09.10.2014, 13:47
Код:
CMD:members(playerid, params[]) { if(playerVariables[playerid][pGroup] >= 1 && playerVariables[playerid][pGroupRank] >= 6) { new aim[256]; format(aim, 256,"{FFB300}%s members ({00B3FF}%d{FFFFFF}/{00B3FF}10{FFB300}):{FFFFFF} \n",groupVariables[playerVariables[playerid][pGroup]][gGroupName],groupVariables[playerVariables[playerid][pGroup]][gMembers]); new query[300],test[300],test2[256]; format(query, sizeof(query), "SELECT * FROM playeraccounts WHERE playerGroup = %d ORDER BY playerGroupRank DESC LIMIT 10",playerVariables[playerid][pGroup]); mysql_query(query); mysql_store_result(); new memid; while(mysql_retrieve_row()) { mysql_fetch_field_row(query, "playerName"); format(Selected[memid][snume],24,"%s",query); mysql_fetch_field_row(test, "playerGroupRank"); Selected[memid][srank] = strval(test); mysql_fetch_field_row(test2, "playerCarWeapon3"); Selected[memid][swarn] = strval(test2); format(aim, sizeof(aim), "%s %s - Rank: %s - Warns: %s/3 \n",aim,query, test,test2); memid ++; } mysql_free_result(); ShowPlayerDialog(playerid,DIALOG_MEMBERS,DIALOG_STYLE_LIST,"Members:",aim,"Sellect","Cancel"); } }