Test

CMD:houselog(playerid,params[]) {
   if(PlayerInfo[playerid][Level] >= 2) {
      new hnumber,houseid,DBResult:Result,Handle[1400],string[220],hload[128],aname[32],date[60],time[60],Action[100],Query[250];
      if(isnull(params)) {
         houseid = GetHouseID(playerid);
         if(houseid == -255) return SendClientMessage(playerid, c_r, "Usage: /houselog [id] or stand on house icon!");
         format(Query, sizeof(Query),"SELECT * FROM `houselog` WHERE ID = '%d'",houseid);
         Result = db_query(DB_HOUSES, Query);
         if(db_num_rows(Result)) {
            if(db_num_rows(Result) < 15) {
               for(new i = 0; i < db_num_rows(Result); i++) {
                  db_get_field_assoc(Result, "ID", hload, 128);
                  db_get_field_assoc(Result, "Name", aname, 32);
                  db_get_field_assoc(Result, "Time", time, 60);
                  db_get_field_assoc(Result, "Date", date, 60);
                  db_get_field_assoc(Result, "Action", Action, 100);
                  format(string,sizeof string,"{FFFFFF}House ID: {33FF33}%s {FFFF00}| {FFFFFF}Player: {33FF33}%s {FFFF00}| {FFFFFF}Date & Time: {33FF33}%s - %s {FFFF00}| {FFFFFF}Action: {33FF33}%s\n",hload,aname,date,time,Action);
                  strcat(Handle,string);
                  db_next_row(Result);
               }
               db_free_result(Result);
               return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{FFFF00}House Logs", Handle, "Close", "");
            }
            if(db_num_rows(Result) > 15) {
               for(new i = db_num_rows(Result)-1; i > db_num_rows(Result)-16; i--) if(i >= 0) {
                  db_get_field_assoc(Result, "ID", hload, 128);
                  db_get_field_assoc(Result, "Name", aname, 32);
                  db_get_field_assoc(Result, "Time", time, 60);
                  db_get_field_assoc(Result, "Date", date, 60);
                  db_get_field_assoc(Result, "Action", Action, 100);
                  format(string,sizeof string,"{FFFFFF}House ID: {33FF33}%s {FFFF00}| {FFFFFF}Player: {33FF33}%s {FFFF00}| {FFFFFF}Date & Time: {33FF33}%s - %s {FFFF00}| {FFFFFF}Action: {33FF33}%s\n",hload,aname,date,time,Action);
                  strcat(Handle,string);
                  db_next_row(Result);
               }
               db_free_result(Result);
               return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{FFFF00}House Logs", Handle, "Close", "");
            }
            else {
              db_free_result(Result);
              return SendClientMessage(playerid, red, "House log's empty!");
            }
         }
      }
      if(!IsNumeric(params)) return SendClientMessage(playerid, red,"ERROR: Invalid house id!");
      hnumber = strval(params);
      format(Query, sizeof(Query),"SELECT * FROM `houselog` WHERE ID = '%d'",hnumber);
      Result = db_query(DB_HOUSES, Query);
      if(db_num_rows(Result) == 0) {
         db_free_result(Result);
         return SendClientMessage(playerid, red, "This house log is empty!");
      }
      if(db_num_rows(Result)) {
        if(db_num_rows(Result) < 15) {
           for(new i = 0; i < db_num_rows(Result); i++) {
              db_get_field_assoc(Result, "ID", hload, 128);
              db_get_field_assoc(Result, "Name", aname, 32);
              db_get_field_assoc(Result, "Time", time, 60);
              db_get_field_assoc(Result, "Date", date, 60);
              db_get_field_assoc(Result, "Action", Action, 100);
              format(string,sizeof string,"{FFFFFF}House ID: {33FF33}%s {FFFF00}| {FFFFFF}Player: {33FF33}%s {FFFF00}| {FFFFFF}Date & Time: {33FF33}%s - %s {FFFF00}| {FFFFFF}Action: {33FF33}%s\n",hload,aname,date,time,Action);
              strcat(Handle,string);
              db_next_row(Result);
           }
           db_free_result(Result);
           return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{FFFF00}House Logs", Handle, "Close", "");
        }
        if(db_num_rows(Result) > 15) {
           for(new i = db_num_rows(Result)-1; i > db_num_rows(Result)-16; i--) if(i >= 0) {
               db_get_field_assoc(Result, "ID", hload, 128);
               db_get_field_assoc(Result, "Name", aname, 32);
               db_get_field_assoc(Result, "Time", time, 60);
               db_get_field_assoc(Result, "Date", date, 60);
               db_get_field_assoc(Result, "Action", Action, 100);
               format(string,sizeof string,"{FFFFFF}House ID: {33FF33}%s {FFFF00}| {FFFFFF}Player: {33FF33}%s {FFFF00}| {FFFFFF}Date & Time: {33FF33}%s - %s {FFFF00}| {FFFFFF}Action: {33FF33}%s\n",hload,aname,date,time,Action);
               strcat(Handle,string);
               db_next_row(Result);
           }
           db_free_result(Result);
           return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{FFFF00}House Logs", Handle, "Close", "");
         }
      }
      return 1;
   } else return SendClientMessage(playerid, red ,"ERROR: You need to be administrator level 2 to use this command");
}