1 #include "../../../include/http/pages/execquerypage.h"
\r
2 #include "../../../include/stringfunctions.h"
\r
8 const std::string ExecQueryPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)
\r
10 std::string content="";
\r
11 std::string query="";
\r
13 if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="execute" && queryvars.find("query")!=queryvars.end() && (*queryvars.find("query")).second!="" && ValidateFormPassword(queryvars))
\r
15 query=(*queryvars.find("query")).second;
\r
16 SQLite3DB::Recordset rs=m_db->Query(query);
\r
22 for(int i=0; i<rs.Cols(); i++)
\r
25 if(rs.GetColumnName(i))
\r
27 content+=rs.GetColumnName(i);
\r
36 for(int i=0; i<rs.Cols(); i++)
\r
41 content+=rs.GetField(i);
\r
48 content+="</table>";
\r
51 content+="<h2>Execute Query</h2>";
\r
52 content+="<form name=\"frmquery\" method=\"POST\">";
\r
53 content+=CreateFormPassword();
\r
54 content+="<input type=\"hidden\" name=\"formaction\" value=\"execute\">";
\r
55 content+="<textarea name=\"query\" rows=\"10\" cols=\"80\">"+StringFunctions::Replace(query,"<","<")+"</textarea>";
\r
56 content+="<input type=\"submit\" value=\"Execute Query\">";
\r
59 return StringFunctions::Replace(m_template,"[CONTENT]",content);
\r
62 const bool ExecQueryPage::WillHandleURI(const std::string &uri)
\r
64 if(uri.find("execquery.")!=std::string::npos)
\r