1 #include "../../../include/http/pages/announceidentitypage.h"
\r
2 #include "../../../include/stringfunctions.h"
\r
3 #include "../../../include/datetime.h"
\r
4 #include "../../../include/global.h"
\r
10 const std::string AnnounceIdentityPage::CreateLocalIdentityDropDown(const std::string &name, const std::string &selected)
\r
12 std::string rval="";
\r
13 SQLite3DB::Statement st=m_db->Prepare("SELECT LocalIdentityID, Name, PublicKey FROM tblLocalIdentity ORDER BY Name;");
\r
16 rval+="<select name=\""+name+"\">";
\r
17 while(st.RowReturned())
\r
23 st.ResultText(0,id);
\r
24 st.ResultText(1,name);
\r
25 st.ResultText(2,pubkey);
\r
27 rval+="<option value=\""+id+"\" title=\""+pubkey+"\">"+SanitizeOutput(CreateShortIdentityName(name,pubkey))+"</option>";
\r
34 const std::string AnnounceIdentityPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)
\r
37 std::string content;
\r
39 std::string countstr="";
\r
41 std::string lastid="";
\r
42 std::string thisid="";
\r
45 bool willshow=false;
\r
47 if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="announce")
\r
49 SQLite3DB::Statement insert=m_db->Prepare("INSERT INTO tblIdentityIntroductionInserts(LocalIdentityID,Day,UUID,Solution) VALUES(?,?,?,?);");
\r
50 std::string localidentityidstr="";
\r
51 int localidentityid=0;
\r
52 std::vector<std::string> uuids;
\r
53 std::vector<std::string> days;
\r
54 std::vector<std::string> solutions;
\r
56 if(queryvars.find("localidentityid")!=queryvars.end())
\r
58 localidentityidstr=(*queryvars.find("localidentityid")).second;
\r
59 StringFunctions::Convert(localidentityidstr,localidentityid);
\r
61 CreateArgArray(queryvars,"uuid",uuids);
\r
62 CreateArgArray(queryvars,"day",days);
\r
63 CreateArgArray(queryvars,"solution",solutions);
\r
65 for(int i=0; i<solutions.size(); i++)
\r
67 if(solutions[i]!="")
\r
69 insert.Bind(0,localidentityid);
\r
70 insert.Bind(1,days[i]);
\r
71 insert.Bind(2,uuids[i]);
\r
72 insert.Bind(3,solutions[i]);
\r
80 content+="<h2>Announce Identity</h2>";
\r
81 content+="<form name=\"frmannounce\" method=\"POST\">";
\r
82 content+="<input type=\"hidden\" name=\"formaction\" value=\"announce\">";
\r
84 content+="<tr><td colspan=\"4\"><center>Select Identity : ";
\r
85 content+=CreateLocalIdentityDropDown("localidentityid","");
\r
86 content+="</td></tr>";
\r
87 content+="<tr><td colspan=\"4\"><center>Type the answers of a few puzzles. The puzzles are case sensitive. Getting announced will take some time. DO NOT continuously solve captchas. Solve 30 at most, wait a day, and if your identity has not been announced, repeat until it is.</td></tr>";
\r
93 SQLite3DB::Statement st=m_db->Prepare("SELECT UUID,Day,IdentityID,RequestIndex FROM tblIntroductionPuzzleRequests WHERE UUID NOT IN (SELECT UUID FROM tblIdentityIntroductionInserts) AND UUID NOT IN (SELECT UUID FROM tblIntroductionPuzzleInserts) AND Day>='"+date.Format("%Y-%m-%d")+"' AND Found='true' ORDER BY IdentityID, Day DESC, RequestIndex DESC;");
\r
96 if(st.RowReturned()==false)
\r
98 content+="<td colspan=\"4\"><center>You must wait for some puzzles to be downloaded. Check back later.</td>";
\r
101 while(st.RowReturned() && shown<20)
\r
103 st.ResultText(0,uuid);
\r
104 st.ResultText(1,day);
\r
105 st.ResultText(2,thisid);
\r
106 st.ResultInt(3,requestindex);
\r
108 // if we are already inserting a solution for an identity - we shouldn't show any puzzles that are older than the one we are inserting
\r
109 // get the last index # we are inserting this day from this identity
\r
110 // if the index here is greater than the index in the st statement, we will skip this puzzle because we are already inserting a puzzle with a greater index
\r
112 SQLite3DB::Statement st2=m_db->Prepare("SELECT MAX(RequestIndex) FROM tblIdentityIntroductionInserts INNER JOIN tblIntroductionPuzzleRequests ON tblIdentityIntroductionInserts.UUID=tblIntroductionPuzzleRequests.UUID WHERE tblIdentityIntroductionInserts.Day=? AND tblIdentityIntroductionInserts.UUID IN (SELECT UUID FROM tblIntroductionPuzzleRequests WHERE IdentityID=? AND Day=?) GROUP BY tblIdentityIntroductionInserts.Day;");
\r
114 if(st2.RowReturned()==true)
\r
117 st2.ResultInt(0,index);
\r
118 if(index>=requestindex)
\r
124 if(willshow && thisid!=lastid)
\r
126 StringFunctions::Convert(shown,countstr);
\r
127 if(shown>0 && shown%4==0)
\r
129 content+="</tr>\r\n<tr>";
\r
132 content+="<img src=\"showcaptcha.htm?UUID="+uuid+"\"><br>";
\r
133 content+="<input type=\"hidden\" name=\"uuid["+countstr+"]\" value=\""+uuid+"\">";
\r
134 content+="<input type=\"hidden\" name=\"day["+countstr+"]\" value=\""+day+"\">";
\r
135 content+="<input type=\"text\" name=\"solution["+countstr+"]\">";
\r
136 content+="</td>\r\n";
\r
144 content+="</tr><td colspan=\"4\"><center><input type=\"submit\" value=\"Announce\"></td></tr>";
\r
145 content+="</table>";
\r
146 content+="</form>";
\r
148 return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);
\r
151 const bool AnnounceIdentityPage::WillHandleURI(const std::string &uri)
\r
153 if(uri.find("announceidentity.")!=std::string::npos)
\r