CHANSERV: add walls to AUTHHISTORY.

[irc/quakenet/newserv.git] / chanserv / authcmds / authhistory.c

/* Automatically generated by refactor.pl.
 *
 *
 * CMDNAME: authhistory
 * CMDLEVEL: QCMD_AUTHED
 * CMDARGS: 1
 * CMDDESC: View auth history for an account.
 * CMDFUNC: csa_doauthhistory
 * CMDPROTO: int csa_doauthhistory(void *source, int cargc, char **cargv);
 * CMDHELP: Usage: AUTHHISTORY
 * CMDHELP: Displays details of the last 10 logins with your account.  Details include
 * CMDHELP: hostmask, login time, disconnect time and reason.
 */

#include "../chanserv.h"
#include "../authlib.h"
#include "../../lib/irc_string.h"
#include "../../dbapi/dbapi.h"

#include <stdio.h>
#include <string.h>

struct authhistoryinfo {
  unsigned int numeric;
  unsigned int userID;
};

void csdb_doauthhistory_real(DBConn *dbconn, void *arg) {
  struct authhistoryinfo *ahi=(struct authhistoryinfo*)arg;
  nick *np=getnickbynumeric(ahi->numeric);
  reguser *rup;
  char *ahnick, *ahuser, *ahhost;
  time_t ahauthtime, ahdisconnecttime;
  DBResult *pgres;
  int count=0;
  char tbuf1[TIMELEN], tbuf2[TIMELEN], uhbuf[NICKLEN+HOSTLEN+USERLEN+5];

  if(!dbconn) {
    free(ahi);
    return;
  }

  pgres=dbgetresult(dbconn);

  if (!dbquerysuccessful(pgres)) {
    Error("chanserv", ERR_ERROR, "Error loading auth history data.");
    free(ahi);
    return;
  }

  if (dbnumfields(pgres) != 7) {
    Error("chanserv", ERR_ERROR, "Auth history data format error.");
    dbclear(pgres);
    free(ahi);
    return;
  }

  if (!np) {
    dbclear(pgres);
    free(ahi);
    return;
  }

  if (!(rup=getreguserfromnick(np))) {
    dbclear(pgres);
    free(ahi);
    return;
  }
  chanservstdmessage(np, QM_AUTHHISTORYHEADER); /* @TIMELEN */
  while(dbfetchrow(pgres)) {
    if (!UHasHelperPriv(rup) && (strtoul(dbgetvalue(pgres, 0), NULL, 10) != rup->ID)) {
      dbclear(pgres);
      free(ahi);
      return;
    }
    ahnick=dbgetvalue(pgres, 1);
    ahuser=dbgetvalue(pgres, 2);
    ahhost=dbgetvalue(pgres, 3);
    ahauthtime=strtoul(dbgetvalue(pgres, 4), NULL, 10);
    ahdisconnecttime=strtoul(dbgetvalue(pgres, 5), NULL, 10);

    q9strftime(tbuf1, sizeof(tbuf1), ahauthtime);
    if (ahdisconnecttime)
      q9strftime(tbuf2, sizeof(tbuf2), ahdisconnecttime);

    snprintf(uhbuf,sizeof(uhbuf),"%s!%s@%s", ahnick, ahuser, ahhost);
    chanservsendmessage(np, "#%-2d %-50s %-19s %-19s %s", ++count, uhbuf, tbuf1, ahdisconnecttime?tbuf2:"never", dbgetvalue(pgres,6)); /* @TIMELEN */
  }
  chanservstdmessage(np, QM_ENDOFLIST);

  dbclear(pgres);
  free(ahi);
}

void csdb_retreiveauthhistory(nick *np, reguser *rup, int limit) {
  struct authhistoryinfo *ahi;

  ahi=(struct authhistoryinfo *)malloc(sizeof(struct authhistoryinfo));
  ahi->numeric=np->numeric;
  ahi->userID=rup->ID;
  q9a_asyncquery(csdb_doauthhistory_real, (void *)ahi,
    "SELECT userID, nick, username, host, authtime, disconnecttime, quitreason from chanserv.authhistory where "
    "userID=%u order by authtime desc limit %d", rup->ID, limit);
}

int csa_doauthhistory(void *source, int cargc, char **cargv) {
  reguser *rup, *trup;
  nick *sender=source;

  if (!(rup=getreguserfromnick(sender)))
    return CMD_ERROR;

  if (cargc >= 1) {
    if (!(trup=findreguser(sender, cargv[0])))
      return CMD_ERROR;

    /* if target != command issuer */
    if (trup != rup) {
      /* only opers and helpers can view authhistory of other users */
      if (!UHasHelperPriv(rup)) {
        chanservstdmessage(sender, QM_NOACCESSONUSER, "authhistory", cargv[0]);
        return CMD_ERROR;
      }

      /* and only opers can view opers history */
      if (UHasOperPriv(trup) && !UHasOperPriv(rup)) {
        chanservwallmessage("%s (%s) just FAILED using AUTHHISTORY on %s", sender->nick, rup->username, trup->username);
        chanservstdmessage(sender, QM_NOACCESSONUSER, "authhistory", cargv[0]);
        return CMD_ERROR;
      }

      /* checks passed */

      chanservwallmessage("%s (%s) used AUTHHISTORY on %s", sender->nick, rup->username, trup->username);
    }
  } else {
    trup=rup;
  }
  csdb_retreiveauthhistory(sender, trup, 10);

  return CMD_OK;
}