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); }