]> jfr.im git - irc/quakenet/newserv.git/blame - trusts/db.c
Major reorganisation.
[irc/quakenet/newserv.git] / trusts / db.c
CommitLineData
2b6e02e2
CP
1#include "../dbapi2/dbapi2.h"
2#include "../core/error.h"
3#include "../nick/nick.h"
4#include "trusts.h"
5
6DBAPIConn *trustsdb;
7extern trustgroup *tglist;
8
9void trusts_reloaddb(void);
10
11int trusts_loaddb(void) {
12 trustsdb = dbapi2open(NULL, "trusts");
13 if(!trustsdb) {
14 Error("trusts", ERR_WARNING, "Unable to connect to db -- not loaded.");
15 return 0;
16 }
17
18 trustsdb->createtable(trustsdb, NULL, NULL,
19 "CREATE TABLE ? (id INT PRIMARY KEY, name VARCHAR(100), trustedfor INT, mode INT, maxperident INT, maxseen INT, expires INT, lastseen INT, lastmaxuserreset INT, createdby VARCHAR(?), contact VARCHAR(?), comment VARCHAR(?))",
20 "Tddd", "groups", NICKLEN, CONTACTLEN, COMMENTLEN
21 );
22 trustsdb->createtable(trustsdb, NULL, NULL, "CREATE TABLE ? (groupid INT, host VARCHAR(100), max INT, lastseen INT, PRIMARY KEY (groupid, host))", "T", "hosts");
23
24 trusts_reloaddb();
25 return 1;
26}
27
28static void trusts_freedb(void) {
29/* do stuff */
30
31 tglist = NULL;
32}
33
34void trusts_reloaddb(void) {
35 trusts_freedb();
36
37
38}
39
40void trusts_closedb(void) {
41 if(!trustsdb)
42 return;
43
44 trustsdb->close(trustsdb);
45 trustsdb = NULL;
46}