void UserModule::ajaxIsEmailExist(WebPage *page, HttpRequest &request) {
MySQL *query = manager->newQuery();
String email = request.header.POST.getValue("email");
String sql = (String)"select id from users where (email='" + email + "')";
string sql8 = sql.to_string();
if (query->active(sql) > 0) {
page->tplIndex->out("out", "<note>\n<result>1</result></note>\n");
}
manager->deleteQuery(query);
}
void WidgetManager::paintPageWidgets(WebPage *page) {
if (page == NULL) return;
MySQL *query = page->site->manager->newQuery();
String sql = "select widgetId, tag from widget_site where siteId='" + (String)page->site->siteId + "'";
if (query->active(sql)) {
int count = query->getRowCount();
for (int i = 0; i < count; i++) {
int widgetId = query->getFieldValue(i, "widgetId").toInt();
String tag = query->getFieldValue(i, "tag");
paintWidget(page, tag, widgetId);
}
}
}
void NewsModule::paintNews(WebPage *page, HttpRequest &request) {
WebTemplate *tpl = new WebTemplate();
if (!tpl->open(manager->modulePath + "/" + url + "/index_tpl.html")) return;
WebTemplate *tplItem = new WebTemplate();
if (!tplItem->open(manager->modulePath + "/" + url + "/item_tpl.html")) return;
WebTemplate *tplLast = new WebTemplate();
if (!tplLast->open(manager->modulePath + "/" + url + "/itemLast_tpl.html")) return;
WebTemplate *tplTag = new WebTemplate();
if (!tplTag->open(manager->modulePath + "/" + url + "/tag_tpl.html")) return;
MySQL *query = manager->newQuery();
String sql = "select count(*) cnt from dataNews n, data d where not isnull(num) and d.dataId=n.id and d.pageId='" + (String)page->pageId + "' and d.moduleId='" + (String)moduleId + "' order by dt desc";
int newsCount = 0;
if (query->active(sql) > 0) {
newsCount = query->getFieldValue(0, "cnt").toInt();
}
int p = request.header.GET.getValue("p").toInt();
sql = "select * from dataNews n, data d where not isnull(num) and d.dataId=n.id and d.pageId='" + (String)page->pageId + "' and d.moduleId='" + (String)moduleId +
"' order by dt desc limit " + (String)(p * 10) + ", 10";
if (query->exec(sql)) {
if (query->storeResult()) {
int count = query->getRowCount();
for (int i = 0; i < count; i++) {
String id = query->getFieldValue(i, "id");
String dt = query->getFieldValue(i, "dt");
dt = dtRus(dt, 0);
String name = query->getFieldValue(i, "name");
String about = query->getFieldValue(i, "about");
String text = query->getFieldValue(i, "text");
int num = query->getFieldValue(i, "num").toInt();
String tag1 = query->getFieldValue(i, "tag1");
String tag2 = query->getFieldValue(i, "tag2");
String tag3 = query->getFieldValue(i, "tag3");
String tag4 = query->getFieldValue(i, "tag4");
String tag5 = query->getFieldValue(i, "tag5");
WebTemplate *tpli = tplItem;
if (i + 1 == count) tpli = tplLast;
tpli->clearAllTags();
tpli->out("page", page->page);
tpli->out("num", num);
tpli->out("itemId", id);
tpli->out("dt", dt);
tpli->out("name", name);
tpli->out("about", about);
tpli->out("text", text);
tpli->out("host", page->site->host);
tplTag->clearAllTags();
tplTag->out("tag1", tag1);
tplTag->out("tag2", tag2);
tplTag->out("tag3", tag3);
tplTag->out("tag4", tag4);
tplTag->out("tag5", tag5);
tplTag->exec();
tpli->out("tags", tplTag->html);
tpli->exec();
tpl->out("out", tpli->html);
}
}
}
if (newsCount != 0) {
WebTemplate *tplPag = new WebTemplate();
if (!tplPag->open(manager->modulePath + "/" + url + "/pagination_tpl.html")) return;
int pageCount = newsCount / 10;
if (newsCount % 10 != 0) pageCount++;
for (int i = 0; i < pageCount; i++) {
if (i == 0) tplPag->out("out", "<li><a href=\"/\">" + (String)(i + 1) + "</a></li>");
else tplPag->out("out", "<li><a href=\"/post?p=" + (String)i + "\">" + (String)(i + 1) + "</a></li>");
if (i + 1 == pageCount) tplPag->out("next", "/post?p=" + (String)i);
}
tplPag->exec();
tpl->out("out", tplPag->html);
}
String uuid = request.header.COOKIE.getValue("uuid");
int userId = manager->getUserId(uuid);
WebTemplate *tplWrite = new WebTemplate();
if (userId != 0) {
if (!tplWrite->open(manager->modulePath + "/" + url + "/addPostButton_tpl.html")) return;
}
else {
if (!tplWrite->open(manager->modulePath + "/" + url + "/addPostButtonNotEnter_tpl.html")) return;
}
tplWrite->exec();
tpl->out("out", tplWrite->html);
tpl->out("caption", caption);
tpl->exec();
page->out("content", tpl->html);
}
