tntnet/dynamic/adm_server_config.ecpp

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

<%config>
dburl;
</%config>

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

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


<&header title="Server Configuration">
</&header>
<h2>Server configuration</h2>
<{
std::string phonenr;


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


if (qparam.param("submit").size() > 0)
{
        conn.execute("DELETE FROM config WHERE name='phonenr'");

        tntdb::Statement st = conn.prepare("INSERT INTO config (name,value) VALUES ('phonenr',:v1)");
        st.setString("v1", qparam.param("phonenr"));
        st.execute();
}


tntdb::Result res = conn.select("SELECT name,value FROM config");
for (unsigned int i=0; i<res.size(); ++i)
{
        std::string name = res[i].getString(0);
        std::string value = res[i].getString(1);

        if (name == "phonenr")
                phonenr = value;                
}


}>
<form method="post" action="adm_server_config">
<table border=0>
<tr>
  <td>Server phone nr:&nbsp;</td>
  <td><input type="text" name="phonenr" value="<$ phonenr $>">
</tr>
<tr>
  <td>&nbsp;
  <td><input type="submit"><input type="reset">
</tr>
</table>

<input type="hidden" name="submit" value="1">
</form>

<&footer>
</&footer>
1	torben	143	<%pre>
2			#include <tntdb/connect.h>
3			#include <tntdb/connection.h>
4			#include <tntdb/result.h>
5			#include <tntdb/row.h>
6			</%pre>
7
8			<%config>
9			dburl;
10			</%config>
11
12			<%session scope="global">
13			std::string userName;
14			</%session>
15
16			<{
17			if (userName.size() == 0)
18			{
19			reply.setHeader("Location", "index");
20			return HTTP_MOVED_TEMPORARILY;
21			}
22			}>
23
24
25			<&header title="Server Configuration">
26			</&header>
27			<h2>Server configuration</h2>
28			<{
29			std::string phonenr;
30
31
32	torben	195	tntdb::Connection conn = tntdb::connectCached(dburl);
33	torben	143
34
35			if (qparam.param("submit").size() > 0)
36			{
37			conn.execute("DELETE FROM config WHERE name='phonenr'");
38
39			tntdb::Statement st = conn.prepare("INSERT INTO config (name,value) VALUES ('phonenr',:v1)");
40			st.setString("v1", qparam.param("phonenr"));
41			st.execute();
42			}
43
44
45			tntdb::Result res = conn.select("SELECT name,value FROM config");
46	torben	182	for (unsigned int i=0; i<res.size(); ++i)
47	torben	143	{
48			std::string name = res[i].getString(0);
49			std::string value = res[i].getString(1);
50
51			if (name == "phonenr")
52			phonenr = value;
53			}
54
55
56			}>
57			<form method="post" action="adm_server_config">
58			<table border=0>
59			<tr>
60			<td>Server phone nr: </td>
61			<td><input type="text" name="phonenr" value="<$ phonenr $>">
62			</tr>
63			<tr>
64			<td>
65			<td><input type="submit"><input type="reset">
66			</tr>
67			</table>
68
69			<input type="hidden" name="submit" value="1">
70			</form>
71
72			<&footer>
73			</&footer>