CMD:ostats(playerid,params[]) {
	if(PlayerInfo[playerid][Level] >= 4 || IsPlayerAdmin(playerid)) {
	   new name[MAX_PLAYER_NAME+1];
	   if(sscanf(params,"s[24]",name)) return SendClientMessage(playerid,red,"USAGE: /ostats [playername]");
	   new Query[200],string[80],AKA[50],IP[50],Cache:result;
	   format(Query,sizeof Query,"SELECT * FROM `accounts` WHERE `Name` = '%s'",name);
	   result = mysql_query(mysql, Query);
	   if(cache_num_rows()) cache_get_field_content(0,"IP",IP,mysql,128);
	   cache_delete(result);
	   format(Query,sizeof Query,"SELECT * FROM `banneds` WHERE `ip` = '%s'",IP);
	   result = mysql_query(mysql, Query);
	   format(AKAS[playerid],260,"");
	   for(new i = cache_num_rows()-1; i > cache_num_rows()-5; i--) if(i >= 0) {
           cache_get_field_content(i,"name",AKA,mysql,128);
           format(string,sizeof string,"{33FF33}         %s\n",AKA);
           strcat(AKAS[playerid], string);
           
	   }
       cache_delete(result);
	   mysql_format(mysql,Query,sizeof Query,"SELECT * FROM accounts WHERE `Name` = '%s'",name);
	   mysql_tquery(mysql,Query,"OfflineStatus","i",playerid);
	} else return SendClientMessage(playerid,red,"ERROR: You need to be administrator level 4 to use this command");
	return 1;
}

old stats example is for id o me id
CMD:stats(playerid,params[]) {
	new player1;
	if(sscanf(params,"i",player1)) {
	   new string[500],Registered1[10],LoggedIn1[10],h,m,s,pDeaths;
	   new Hour, Minute, Second; gettime(Hour, Minute, Second);
	   TotalGameTime(playerid, h, m, s);
	   if(PlayerInfo[playerid][Registered] == 1){Registered1 = "Yes";} else {Registered1 = "No";}
	   if(PlayerInfo[playerid][Registered] == 1){LoggedIn1 = "Yes";} else {LoggedIn1 = "No";}
	   if(PlayerInfo[playerid][Deaths] == 0) pDeaths = 1; else pDeaths = PlayerInfo[playerid][Deaths];
	   format(string,sizeof string,"{ff4d4d}Stats of %s\n\n{FFFFFF}Registered: %s\nLoggedIn: %s\nAdmin Level: %d\nScore: %d\nTime: %d hrs %d mins %d secs\nPing: %d\nCountry: %s\
	   \n\n{33AA33}Cash: $%d\nBank: $%d\n\n{FFFFFF}Skin: %d\nWanted level: %d\n\n{FFFF00}Kills and Deaths\n{FFFFFF}Kills: %d\nDeaths: %d\nRatio: %f",
	   pName(playerid),Registered1,LoggedIn1,PlayerInfo[playerid][Level],GetPlayerScore(playerid),h,m,s,GetPlayerPing(playerid),GetPlayerCountryName(playerid),
	   GetPlayerMoney(playerid),PlayerInfo[playerid][Bank],GetPlayerSkin(playerid),GetPlayerWantedLevel(playerid),PlayerInfo[playerid][Kills],PlayerInfo[playerid][Deaths],
	   Float:PlayerInfo[playerid][Kills]/Float:pDeaths);
	   return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Stats", string, "Ok","");
	}
	new string[500],Registered1[10],LoggedIn1[10],h,m,s,pDeaths;
	new Hour, Minute, Second; gettime(Hour, Minute, Second);
	TotalGameTime(player1, h, m, s);
    if(PlayerInfo[player1][Registered] == 1){Registered1 = "Yes";} else {Registered1 = "No";}
	if(PlayerInfo[player1][LoggedIn] == 1){LoggedIn1 = "Yes";} else {LoggedIn1 = "No";}
	if(PlayerInfo[player1][Deaths] == 0) pDeaths = 1; else pDeaths = PlayerInfo[player1][Deaths];
	format(string,sizeof string,"{ff4d4d}Stats of %s\n\n{FFFFFF}Registered: %s\nLoggedIn: %s\nAdmin Level: %d\nScore: %d\nTime: %d hrs %d mins %d secs\nPing: %d\nCountry: %s\
	\n\n{33AA33}Cash: $%d\nBank: $%d\n\n{FFFFFF}Skin: %d\nWanted level: %d\n\n{FFFF00}Kills and Deaths\n{FFFFFF}Kills: %d\nDeaths: %d\nRatio: %0.2f",
	pName(player1),Registered1,LoggedIn1,PlayerInfo[player1][Level],GetPlayerScore(player1),h,m,s,GetPlayerPing(player1),GetPlayerCountryName(player1),
	GetPlayerMoney(player1),PlayerInfo[player1][Bank],GetPlayerSkin(player1),GetPlayerWantedLevel(player1),PlayerInfo[player1][Kills],PlayerInfo[player1][Deaths],
	Float:PlayerInfo[player1][Kills]/Float:pDeaths);
	return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Stats", string, "Ok","");
}