tntnet/dynamic/adm_user_delete.ecpp

<%pre>
#include <tntdb/connect.h>
#include <tntdb/connection.h>
#include <tntdb/result.h>
#include <tntdb/row.h>
#include <sstream>
</%pre>

<%config>
dburl;
</%config>

<%session scope="global">
std::string userName;
bool isAdmin;
</%session>


<%args>
int id;
</%args>

<{

if (userName.size() == 0)
{
        reply.setHeader("Location", "index");
        return HTTP_MOVED_TEMPORARILY;
}

if (!isAdmin)
{
    reply.setHeader("Location", "index");
    return HTTP_MOVED_TEMPORARILY;
}

tntdb::Connection conn = tntdb::connect(dburl);

std::stringstream query;
query << "DELETE FROM users WHERE id = " << id;

conn.execute(query.str());
reply.setHeader("Location", "adm_user_list");
return HTTP_MOVED_TEMPORARILY;


}>
1	torben	101	<%pre>
2			#include <tntdb/connect.h>
3			#include <tntdb/connection.h>
4			#include <tntdb/result.h>
5			#include <tntdb/row.h>
6			#include <sstream>
7			</%pre>
8
9			<%config>
10			dburl;
11			</%config>
12
13			<%session scope="global">
14			std::string userName;
15			bool isAdmin;
16			</%session>
17
18
19			<%args>
20			int id;
21			</%args>
22
23			<{
24
25			if (userName.size() == 0)
26			{
27			reply.setHeader("Location", "index");
28			return HTTP_MOVED_TEMPORARILY;
29			}
30
31			if (!isAdmin)
32			{
33			reply.setHeader("Location", "index");
34			return HTTP_MOVED_TEMPORARILY;
35			}
36
37			tntdb::Connection conn = tntdb::connect(dburl);
38
39			std::stringstream query;
40			query << "DELETE FROM users WHERE id = " << id;
41
42			conn.execute(query.str());
43			reply.setHeader("Location", "adm_user_list");
44			return HTTP_MOVED_TEMPORARILY;
45
46
47			}>