]>
Commit | Line | Data |
---|---|---|
183b8e2f P |
1 | /* Automatically generated by refactor.pl. |
2 | * | |
3 | * | |
4 | * CMDNAME: rollbackaccount | |
5 | * CMDLEVEL: QCMD_OPER | |
6 | * CMDARGS: 2 | |
7 | * CMDDESC: Roll back password/email changes on an account. | |
8 | * CMDFUNC: csa_dorollbackaccount | |
9 | * CMDPROTO: int csa_dorollbackaccount(void *source, int cargc, char **cargv); | |
94e4d2f4 CP |
10 | * CMDHELP: Usage: rollbackaccount <username> <duration> |
11 | * CMDHELP: Rolls back an account to a previous point, reverting password and email changes. | |
183b8e2f P |
12 | */ |
13 | ||
14 | #include "../chanserv.h" | |
15 | #include "../../lib/irc_string.h" | |
ee8cd7d0 | 16 | #include "../../dbapi/dbapi.h" |
6b2ca929 | 17 | |
183b8e2f P |
18 | #include <stdio.h> |
19 | #include <string.h> | |
20 | ||
ee8cd7d0 | 21 | void csdb_dorollbackaccount_real(DBConn *dbconn, void *arg) { |
c54295ef | 22 | nick *np=getnickbynumeric((unsigned long)arg); |
6b2ca929 | 23 | reguser *rup; |
24 | unsigned int userID; | |
25 | char *oldpass, *newpass, *oldemail, *newemail; | |
26 | time_t changetime, authtime; | |
ee8cd7d0 | 27 | DBResult *pgres; |
6b2ca929 | 28 | |
b3565978 CP |
29 | if(!dbconn) |
30 | return; | |
31 | ||
ee8cd7d0 | 32 | pgres=dbgetresult(dbconn); |
6b2ca929 | 33 | |
ee8cd7d0 | 34 | if (!dbquerysuccessful(pgres)) { |
6b2ca929 | 35 | Error("chanserv", ERR_ERROR, "Error loading account rollback data."); |
36 | return; | |
37 | } | |
38 | ||
ee8cd7d0 | 39 | if (dbnumfields(pgres) != 7) { |
6b2ca929 | 40 | Error("chanserv", ERR_ERROR, "Account rollback data format error."); |
ee8cd7d0 | 41 | dbclear(pgres); |
6b2ca929 | 42 | return; |
43 | } | |
44 | ||
6b2ca929 | 45 | if (!np) { |
ee8cd7d0 | 46 | dbclear(pgres); |
6b2ca929 | 47 | return; |
48 | } | |
49 | ||
50 | if (!(rup=getreguserfromnick(np)) || !UHasOperPriv(rup)) { | |
51 | Error("chanserv", ERR_ERROR, "No reguser pointer or oper privs in rollback account."); | |
ee8cd7d0 | 52 | dbclear(pgres); |
6b2ca929 | 53 | return; |
54 | } | |
55 | ||
56 | chanservsendmessage(np, "Attempting to rollback account %s:", rup->username); | |
ee8cd7d0 CP |
57 | while(dbfetchrow(pgres)) { |
58 | userID=strtoul(dbgetvalue(pgres, 0), NULL, 10); | |
59 | changetime=strtoul(dbgetvalue(pgres, 1), NULL, 10); | |
60 | authtime=strtoul(dbgetvalue(pgres, 2), NULL, 10); | |
61 | oldpass=dbgetvalue(pgres, 3); | |
62 | newpass=dbgetvalue(pgres, 4); | |
63 | oldemail=dbgetvalue(pgres, 5); | |
64 | newemail=dbgetvalue(pgres, 6); | |
6b2ca929 | 65 | if (strlen(newpass) > 0) { |
66 | setpassword(rup, oldpass); | |
67 | chanservsendmessage(np, "Restoring old password (%s -> %s)", newpass, oldpass); | |
68 | } | |
69 | else if (strlen(newemail) > 0) { | |
9708f78f | 70 | /* WARNING: lastemail untouched */ |
6b2ca929 | 71 | freesstring(rup->email); |
72 | rup->email=getsstring(oldemail, EMAILLEN); | |
73 | rup->lastemailchange=changetime; | |
74 | chanservsendmessage(np, "Restoring old email (%s -> %s)", newemail, oldemail); | |
75 | } | |
76 | } | |
77 | csdb_updateuser(rup); | |
78 | chanservstdmessage(np, QM_DONE); | |
79 | ||
ee8cd7d0 | 80 | dbclear(pgres); |
6b2ca929 | 81 | } |
82 | ||
83 | void csdb_rollbackaccounthistory(nick *np, reguser* rup, time_t starttime) { | |
b3565978 | 84 | q9u_asyncquery(csdb_dorollbackaccount_real, (void *)np->numeric, |
522e2b8c | 85 | "SELECT userID, changetime, authtime, oldpassword, newpassword, oldemail, newemail from chanserv.accounthistory where " |
6b2ca929 | 86 | "userID=%u and changetime>%lu order by changetime desc limit 10", rup->ID, starttime); |
87 | } | |
88 | ||
183b8e2f P |
89 | int csa_dorollbackaccount(void *source, int cargc, char **cargv) { |
90 | reguser *rup, *trup; | |
91 | nick *sender=source; | |
92 | time_t starttime=getnettime(); | |
93 | long duration; | |
94 | ||
95 | if (!(rup=getreguserfromnick(sender))) | |
96 | return CMD_ERROR; | |
97 | ||
98 | if (cargc < 2) { | |
99 | chanservstdmessage(sender, QM_NOTENOUGHPARAMS, "rollbackaccount"); | |
100 | return CMD_ERROR; | |
101 | } | |
102 | ||
103 | if (!(trup=findreguser(sender, cargv[0]))) | |
104 | return CMD_ERROR; | |
105 | ||
106 | if (UHasOperPriv(trup)) { | |
107 | chanservstdmessage(sender, QM_NOACCESS, "rollbackaccount", cargv[0]); | |
108 | return CMD_ERROR; | |
109 | } | |
110 | ||
111 | if (!(duration=durationtolong(cargv[1]))) { | |
112 | chanservsendmessage(sender, "Invalid duration."); | |
113 | return CMD_ERROR; | |
114 | } | |
115 | starttime-=duration; | |
116 | ||
117 | cs_log(sender,"ROLLBACKACCOUNT %s #%s %s", trup->username, rup->username, cargv[1]); | |
118 | ||
119 | csdb_rollbackaccounthistory(sender, trup, starttime); | |
120 | ||
121 | return CMD_OK; | |
122 | } |