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
|
#include <sqlite3.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "ctl.h" /* Controllers. */
#include "err.h" /* HTTP errors. */
#include "site.h" /* Site settings. Defines global struct site. */
#include "query.h" /* Query functions. Defines global struct query. */
#define MAXERR 300
int
main(int argc, char *argv[])
{
char err[MAXERR], *qs;
sqlite3 *db;
sqlite3_stmt *res;
/*
* 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(err, MAXERR,
"The database could not be opened: %s\n",
sqlite3_errmsg(db));
srverr(err);
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, &res, 0) != SQLITE_OK){
snprintf(err, MAXERR,
"The site name could not be retrieved: %s\n",
sqlite3_errmsg(db));
srverr(err);
sqlite3_close(db);
return 1;
}
if(sqlite3_step(res) == SQLITE_ROW)
site.name = strdup(sqlite3_column_text(res, 0));
else{
snprintf(err, MAXERR, "The site name is not set.\n");
srverr(err);
sqlite3_finalize(res);
sqlite3_close(db);
return 1;
}
sqlite3_finalize(res);
/*
* The global struct query is set, or the program dies.
* From now on, query is assumed to be set.
*/
setquery();
/* Handle request. */
if(!*query.string)
front();
/* INSERT CONDITIONS HERE */
else
front();
sqlite3_close(db);
return 0;
}
|