1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
#include <err.h>
#include <sqlite3.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "cforum.h"
#define MAXMSG 300
int
main(int argc, char *argv[])
{
char msg[MAXMSG], *new, *p, *v;
int attid, postid, userid;
sqlite3_stmt *stmt;
/*
* The database is opened or a server error is generated.
* In the rest of the program, the database is always
* assumed to be opened.
*/
if(sqlite3_open("db", &db) != SQLITE_OK){
snprintf(msg, MAXMSG,
"The database could not be opened: %s\n",
sqlite3_errmsg(db));
srverr(msg);
sqlite3_close(db);
return 1;
}
/*
* The site name is retrieved from the database. This early on,
* it is appropriate to die with a server error on failure.
*/
if(sqlite3_prepare(db,
"SELECT value FROM settings WHERE key = 'name'",
-1, &stmt, 0) != SQLITE_OK){
snprintf(msg, MAXMSG,
"The site name could not be retrieved: %s\n",
sqlite3_errmsg(db));
srverr(msg);
sqlite3_close(db);
return 1;
}
if(sqlite3_step(stmt) == SQLITE_ROW)
site.name = strdup((char *)sqlite3_column_text(stmt, 0));
else{
snprintf(msg, MAXMSG, "The site name is not set.\n");
srverr(msg);
sqlite3_finalize(stmt);
sqlite3_close(db);
return 1;
}
sqlite3_finalize(stmt);
/*
* The global struct query is set, or the program dies.
* From now on, query is assumed to be set.
*/
setquery();
/* Handle empty request. */
if(!*query.string){
showfront();
goto end;
}
/* Parse query string. */
new = NULL;
attid = postid = userid = 0;
while(p = nextparam(GET, NULL, 128)){
v = split(p);
if(!attid && strcmp(p, "att") == 0) attid = atoi(v);
else if(!postid && strcmp(p, "post") == 0) postid = atoi(v);
else if(!userid && strcmp(p, "user") == 0) userid = atoi(v);
else if(!new && strcmp(p, "new") == 0) new = strdup(v);
}
/* Handle request. */
if(attid)
showatt(attid);
else if(postid)
showpost(postid);
else if(userid)
showuser(userid);
else if(new){
if(strcmp(v, "att") == 0) newatt();
else if(strcmp(v, "post") == 0) newpost();
else if(strcmp(v, "user") == 0) newuser();
else if(strcmp(v, "session") == 0) login();
else showfront(); /* TODO */
}else
showfront();
end:
sqlite3_close(db);
return 0;
}
|