/** * Формирование данных доступных в шаблоне страницы результатов поиска. */ function ResultPage() { if (!empty($_REQUEST['sort'])) { A_Session::set(SECTION . '_rsort', $_REQUEST['sort']); } if (!empty($_REQUEST['rows'])) { A_Session::set(SECTION . '_rrows', $_REQUEST['rows']); } $sort = escape_order_string(A_Session::get(SECTION . '_rsort', !empty(A::$OPTIONS['mysort']) ? A::$OPTIONS['mysort'] : A::$OPTIONS['sort'])); $rows = (int) A_Session::get(SECTION . '_rrows', A::$OPTIONS['rrows']); $this->Assign("rows", $rows); $this->Assign("sort", $sort); $_GET['filter'] = 1; $fields = array('name' => 'string', 'content' => 'string', 'tags' => 'string', 'art' => 'string', 'date' => 'int', 'price' => 'int', 'favorite' => 'bool', 'new' => 'bool'); $where = $this->frontfilter('', $fields); if (!empty($_GET['idcat'])) { if (is_array($_GET['idcat'])) { $where2 = array(); foreach ($_GET['idcat'] as $idcat) { if ($idcats = $this->childCategories((int) $idcat)) { $where2[] = "(idcat IN(" . implode(",", $idcats) . ") OR idcat1 IN(" . implode(",", $idcats) . ") OR idcat2 IN(" . implode(",", $idcats) . "))"; } } $where .= " AND (" . implode(" OR ", $where2) . ")"; } elseif (empty($this->idcat)) { if ($this->category = A::$DB->getRowById($_GET['idcat'], SECTION . "_categories")) { A::goUrl(shoplite_createCategoryLink($this->category['id'], SECTION) . 'result.html?' . getenv('QUERY_STRING')); } } } if ($this->category) { $this->category['link'] = shoplite_createCategoryLink($this->category['id'], SECTION); if (A::$OPTIONS['usetags']) { $this->category['tags'] = A_SearchEngine::getInstance()->convertTags($this->category['tags']); } $this->category = A::$OBSERVER->Modifier('fcategory_prepareValues', SECTION, $this->category); $this->Assign("category", $this->category); if ($idcats = $this->childCategories($this->idcat)) { $where .= " AND (idcat IN(" . implode(",", $idcats) . ") OR idcat1 IN(" . implode(",", $idcats) . ") OR idcat2 IN(" . implode(",", $idcats) . "))"; } } $items = array(); $pager = new A_Pager($rows); $pager->query("SELECT *,svote/cvote AS vote FROM " . SECTION . "_catalog WHERE active='Y'{$where} ORDER BY {$sort}"); while ($row = $pager->fetchRow()) { $row['link'] = shoplite_createItemLink($row['id'], SECTION); $row['tobasketlink'] = getSectionLink(SECTION) . "?action=addbasket&id=" . $row['id']; $row['tocomparelink'] = getSectionLink(SECTION) . "?action=addcompare&id=" . $row['id']; $row['category'] = getTreePath(SECTION . "_categories", $row['idcat']); $row['vote'] = round($row['vote'], 2); $row['available'] = $row['iscount'] > 0; if (A::$OPTIONS['useimages']) { $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id'])); $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0; } if (A::$OPTIONS['usefiles']) { $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id'])); foreach ($row['files'] as $i => $data) { $row['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name']; $row['files'][$i]['size'] = sizestring($data['size']); } $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0; } if (A::$OPTIONS['modprices']) { $mprices = !empty($row['mprices']) ? unserialize($row['mprices']) : array(); $row['mprices'] = array(); foreach ($mprices as $i => $mp) { $row['mprices'][] = array('id' => $i, 'name' => $mp['name'], 'price' => $mp['price']); } } if (A::$OPTIONS['usetags']) { $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']); } prepareValues(SECTION, $row); $row = A::$OBSERVER->Modifier('shoplite_prepareValues', SECTION, $row); $items[] = $row; } $this->Assign("items", $items); $this->Assign("items_pager", $pager); $data = $pars = array(); foreach ($_GET as $field => $value) { if (!empty($value)) { if (is_array($value)) { $p = array(); foreach ($value as $val) { $p[] = "{$field}[]=" . (int) $val; } $pars[$field] = implode("&", $p); $data[$field] = implode(",", $value); } else { $pars[$field] = "{$field}=" . urlencode($value); $data[$field] = $value; } } } prepareValues(SECTION, $data); $filters = array(); A::$DB->query("SELECT * FROM " . DOMAIN . "_fields WHERE item='" . SECTION . "' ORDER BY sort"); while ($row = A::$DB->fetchRow()) { if (!empty($data[$row['field']])) { $filters[] = array('field' => $row['field'], 'caption' => $row['name_' . A::$LANG], 'value' => $data[$row['field']], 'link' => getSectionLink(SECTION) . "result.html?" . $pars[$row['field']]); } } A::$DB->free(); $this->Assign("filters", $filters); $this->AddNavigation(SECTION_NAME, getSectionLink(SECTION)); $this->AddNavCategories($this->idcat); }
echo $mail_title_encode; ?> "><?php if (strncmp($maildata[$i]["TITLE"], "Re: ", 4)) { echo "★" . htmlspecialchars($maildata[$i]["TITLE"]); } else { echo htmlspecialchars($maildata[$i]["TITLE"]); } ?> </a></td> <td class="mt3"><?php echo strftime("%b %e %H :%M", $maildata[$i]["POSTTIME"]); ?> </td> <td class="mt3" style="text-align:right;padding-right:10pt;"><?php echo sizestring($maildata[$i]['EFFSIZE']); ?> </td> <td class="mt4"><input type="button" name="del" value="删除" class="bt1" onclick="bbsconfirm('bbsmailact.php?act=del&<?php echo "dir=" . urlencode($mail_path) . "&file=" . urlencode($maildata[$i]["FILENAME"]) . "&title=" . $mail_title_encode; ?> ','确认删除该邮件吗?')"></td> </tr> <?php } } ?> </table> <table cellpadding="3" cellspacing="0" width="95%" border="0" class="b9"> <tr><td class="b9"> <input type="button" value="发送邮件" class="bt1" onclick="window.location.href='bbspstmail.php'">
function pc_file_showfiles($pc, $c_dir, $root_pid) { global $file_access; $c_files = array(); if (!$c_dir->uf_readdir($c_files)) { exit($c_dir->err); } $c_files_num = sizeof($c_files); ?> <hr width="100%"> <p class="f2"> [当前目录:<?php echo $c_dir->fid == $root_pid ? '根目录' : $c_dir->filename; ?> ]</p> <center> <table cellspacing="0" cellpadding="5" width="95%" class="t1" border="0"> <tr> <td class="t2" width="40"> </td> <td class="t2">文件名</td> <td class="t2" width="60">权限</td> <td class="t2" width="80">大小</td> <td class="t2" width="160">类型</td> <td class="t2" width="120">修改时间</td> <td class="t2" width="20">改</td> <td class="t2" width="20">删</td> <td class="t2" width="20">复</td> <td class="t2" width="20">剪</td> </tr> <?php if ($root_pid != $c_dir->fid) { echo '<tr><td colspan="10" class="t8">[<a href="' . $_SERVER["PHP_SELF"] . '?userid=' . $pc["USER"] . '&pid=' . $root_pid . '">返回根目录</a>]</td></tr>' . '<tr><td colspan="10" class="t8">[<a href="' . $_SERVER["PHP_SELF"] . '?userid=' . $pc["USER"] . '&pid=' . $c_dir->pid . '">返回上层目录</a>]</td></tr>'; } if ($c_files_num) { $start = 1; for ($i = 0; $i < $c_files_num; $i++) { if (!($file = new UserFile($c_files[$i], $c_dir->uid))) { continue; } if (!$file->fid) { continue; } if ($file->type == 1) { echo '<tr><td class="t3">目录</td>'; $link_url = '<a href="' . $_SERVER["PHP_SELF"] . '?userid=' . $pc["USER"] . '&pid=' . $file->fid . '" title="' . htmlspecialchars($file->remark) . '">'; } else { echo '<tr><td class="t3">' . $start . '</td>'; $start++; $link_url = '<a href="'; $link_url .= 'pcdownload.php?fid=' . $file->fid . '" title="' . htmlspecialchars($file->remark) . '" target="_blank">'; } echo '<td class="t5">' . $link_url . html_format($file->filename) . '</a></td>' . '<td class="t3">' . $file_access[$file->access] . '</td>' . '<td class="t4">' . sizestring($file->filesize) . '</td>' . '<td class="t3">' . html_format($file->filetype) . '</td>' . '<td class="t4">' . time_format($file->filetime) . '</td>' . '<td class="t3"><a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=edit&fid=' . $file->fid . '&pid=' . $c_dir->fid . '">改</a></td>' . '<td class="t3"><a href="#" onclick="bbsconfirm(\'' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=rm&fid=' . $file->fid . '&pid=' . $c_dir->fid . '\',\'确实要删除' . addslashes(htmlspecialchars($file->filename)) . '吗?\')" >删</a></td>'; if ($_COOKIE['PCFILEFID']) { if ($file->type == 1) { echo '<td colspan="2" class="t3"><a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=pt&fid=' . intval($_COOKIE['PCFILEFID']) . '&pid=' . $c_dir->fid . '&tid=' . $file->fid . '">粘</a></td>'; } else { echo '<td colspan="2" class="t3">-</td>'; } } else { echo '<td class="t3"><a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=cp&fid=' . $file->fid . '&pid=' . $c_dir->fid . '">复</a></td>' . '<td class="t3"><a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=mv&fid=' . $file->fid . '&pid=' . $c_dir->fid . '">剪</a></td>'; } unset($file); } } ?> </table> <?php if ($_COOKIE['PCFILEFID']) { echo '<br />[<a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=pt&fid=' . intval($_COOKIE['PCFILEFID']) . '&pid=' . $root_pid . '&tid=' . $root_pid . '">粘贴到根目录</a>] ' . '[<a href="' . $_SERVER['PHP_SELF'] . '?userid=' . $pc['USER'] . '&act=cl&pid=' . $c_dir->fid . '">清空剪贴板</a>]<br/>'; } ?> </center> <hr width="100%"> <?php }
} echo sizestring($rem); ?> 字节</b></font>.</p> </form> <form name="deleteattach" ENCTYPE="multipart/form-data" method="post" class="left" action=""> <?php if ($sessionid) { echo "<input type='hidden' name='sid' value='{$sessionid}' />"; } ?> <ol style="padding-left: 2em; margin-left: 0em;">帖子内的附件列表: (最多能上传 <?php echo BBS_MAXATTACHMENTCOUNT; ?> 个, 还能上传 <font color="#FF0000"><b><?php echo BBS_MAXATTACHMENTCOUNT - $filecount; ?> </b></font> 个) <?php for ($i = 0; $i < $filecount; $i++) { $f = $attachments[$i]; echo "<li><a target='_blank' href='#' id='att" . $i . "'>" . $f["name"] . "</a> (" . sizestring($f["size"]) . "字节) <a href=\"javascript:deletesubmit('" . ($i + 1) . "');\">删除</a></li>"; } ?> </ol> </form> </div> </body> </html>
if (is_uploaded_file($_FILES['attachfile']['tmp_name'])) { if (move_uploaded_file($_FILES['attachfile']['tmp_name'], $tmpfilename) == FALSE) { echo "保存失败"; } else { echo "文件导入成功!"; $ret = bbs_csv_to_al($tmpfilename); echo "共导入" . $ret . "项"; @unlink($tmpfilename); break; } } echo "保存文件失败!"; break; case UPLOAD_ERR_INI_SIZE: case UPLOAD_ERR_FORM_SIZE: echo "文件超过预定的大小" . sizestring(BBS_MAXATTACHMENTSIZE) . "字节"; break; case UPLOAD_ERR_PARTIAL: echo "文件传输出错!"; break; case UPLOAD_ERR_NO_FILE: echo "没有文件上传!"; break; case 100: echo "无效的文件名!"; default: echo "未知错误"; } echo "<br />"; page_footer(FALSE); }
</form> <form name="deleteattach" ENCTYPE="multipart/form-data" method="post" class="left" action=""> <input type="hidden" name="type" value="<?php echo $type; ?> " /> <?php if ($sessionid) { echo "<input type='hidden' name='sid' value='{$sessionid}' />"; } ?> <ol style="padding-left: 2em; margin-left: 0em;">已经上传的附件列表: (最多能上传 <?php echo $max_file_count; ?> 个, 还能上传 <font color="#FF0000"><b><?php echo $max_file_count - $filecount; ?> </b></font> 个) <?php for ($i = 0; $i < $filecount; $i++) { $f = $attachments[$i]; echo "<li>" . $f["name"] . " (" . sizestring($f["size"]) . "字节) <a href=\"javascript:deletesubmit('" . base64_encode($f["name"]) . "');\">删除</a></li>"; } ?> </ol> </form> </div> </body> </html>
/** * Формирование данных доступных в шаблоне. */ function createData() { $this->supportCached(); $this->addCacheParam_Get('page'); if ($this->month == 0) { $this->month = date('m'); } if ($this->year == 0) { $this->year = date('Y'); } $checkeds = !empty(A::$OPTIONS['sections']) ? unserialize(A::$OPTIONS['sections']) : array(); $srows = $sections = array(); foreach ($checkeds as $idsec) { if ($srow = A::$DB->getRowById($idsec, DOMAIN . "_sections")) { $section = DOMAIN . "_" . $srow['lang'] . "_" . $srow['name']; $sections[$section] = $srow['module']; $srows[$section] = $srow; } } $calendar = new A_Calendar($sections); $this->Assign("calendar", $calendar->getMonthHTML($this->day, $this->month, $this->year)); if ($this->day > 0) { $date1 = mktime(0, 0, 0, $this->month, $this->day, $this->year); $date2 = mktime(23, 59, 59, $this->month, $this->day, $this->year); $this->Assign("date", $date1); } else { $date1 = mktime(0, 0, 0, $this->month, 1, $this->year); $date2 = mktime(0, 0, 0, $this->month + 1 > 12 ? 1 : $this->month + 1, 1, $this->month + 1 > 12 ? $this->year + 1 : $this->year) - 1; $this->Assign("date1", $date1); $this->Assign("date2", $date2); } $items = array(); foreach ($sections as $section => $module) { $srows[$section]['caption'] = $srows[$section]['caption_' . LANG]; $srows[$section]['link'] = getSectionLink($section); A::$DB->query("SELECT *,svote/cvote AS vote FROM {$section}_catalog WHERE date>={$date1} AND date<={$date2} AND active='Y' ORDER BY date"); while ($row = A::$DB->fetchRow()) { $row['section'] = $section; $items[] = $row; } A::$DB->free(); } $items = array_multisort_key($items, 'date'); $pager = new A_Pager(A::$OPTIONS['rows']); $items = $pager->setItems($items); foreach ($items as $i => $row) { $section = $row['section']; $row['section'] = $srows[$section]; $row['section_name'] = $srows[$section]['caption']; $row['section_link'] = $srows[$section]['link']; $row['link'] = catalog_createItemLink($row['id'], $section); $row['vote'] = round($row['vote'], 2); $row['category'] = getTreePath("{$section}_categories", $row['idcat']); $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array($srows[$section]['id'], $row['id'])); $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0; $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array($srows[$section]['id'], $row['id'])); foreach ($row['files'] as $i => $data) { $row['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name']; $row['files'][$i]['size'] = sizestring($data['size']); } $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0; if (!empty($row['tags'])) { $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']); } prepareValues($section, $row); $items[$i] = $row; } $this->Assign("items", $items); $this->Assign("items_pager", $pager); $this->AddNavigation(SECTION_NAME); }
/** * Формирование данных доступных в шаблоне детальной страницы материала. */ function ItemPage() { $this->supportCached(); if ($this->idcat > 0) { $this->category['link'] = catalog_createCategoryLink($this->category['id'], SECTION); if (A::$OPTIONS['usetags']) { $this->category['tags'] = A_SearchEngine::getInstance()->convertTags($this->category['tags']); } $this->category = A::$OBSERVER->Modifier('fcategory_prepareValues', SECTION, $this->category); $this->Assign("category", $this->category); } $itemdata = $this->itemdata; $itemdata['vote'] = $itemdata['cvote'] > 0 ? round($itemdata['svote'] / $itemdata['cvote'], 2) : 0; if (A::$OPTIONS['useimages']) { $itemdata['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $itemdata['id'])); $itemdata['idimg'] = isset($itemdata['images'][0]['id']) ? $itemdata['images'][0]['id'] : 0; } if (A::$OPTIONS['usefiles']) { $itemdata['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $this->iditem)); foreach ($itemdata['files'] as $i => $data) { $itemdata['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name']; $itemdata['files'][$i]['size'] = sizestring($data['size']); } $itemdata['idfile'] = isset($itemdata['files'][0]['id']) ? $itemdata['files'][0]['id'] : 0; } if (A::$OPTIONS['usetags']) { $itemdata['tags'] = A_SearchEngine::getInstance()->convertTags($itemdata['tags']); } prepareValues(SECTION, $itemdata); $itemdata = A::$OBSERVER->Modifier('catalog_prepareValues', SECTION, $itemdata); $this->Assign("item", $itemdata); if (A::$OPTIONS['usecomments']) { $comments = array(); A::$DB->query("SELECT * FROM " . DOMAIN . "_comments WHERE idsec=" . SECTION_ID . " AND iditem={$this->iditem} AND active='Y' ORDER BY date"); while ($row = A::$DB->fetchRow()) { if ($row['iduser'] > 0 && A::$AUTH->section) { if ($row['user'] = A::$DB->getRowById($row['iduser'], A::$AUTH->section)) { prepareValues(A::$AUTH->section, $row['user']); } } $comments[] = $row; } A::$DB->free(); $this->Assign("comments", $comments); $form = array(); $form['name'] = !empty($_REQUEST['name']) ? $_REQUEST['name'] : (A::$AUTH->isLogin() ? A::$AUTH->data['name'] : ""); $form['message'] = !empty($_REQUEST['message']) ? $_REQUEST['message'] : ""; $this->Assign("form", $form); $this->Assign("captcha", $captcha = substr(time(), rand(0, 6), 4)); A_Session::set("captcha", md5($captcha)); } if (A::$OPTIONS['usevote']) { $this->Assign("isvote", A_Session::get(SECTION . "_vote_" . $this->iditem, false)); $this->addCacheParam_Session(SECTION . "_vote_" . $this->iditem); } $this->AddNavigation(SECTION_NAME, getSectionLink(SECTION)); if (isset($this->category)) { $this->AddNavCategories($this->category['id']); } $this->title = $this->itemdata['name'] . (!empty($this->title) ? " - " . $this->title : ""); if (!empty($this->itemdata['keywords'])) { $this->keywords = $this->itemdata['keywords']; } $this->description = $this->itemdata['description']; }
function atomic_mail() { global $currentuser; atomic_mail_header(); $mail_fullpath = bbs_setmailfile($currentuser["userid"], ".DIR"); $mail_num = bbs_getmailnum2($mail_fullpath); if ($mail_num <= 0 || $mail_num > 30000) { atomic_error("读取邮件数据失败!"); } $start = isset($_GET["start"]) ? @intval($_GET["start"]) : 999999; $num = ARTCNT; if ($start > $mail_num - ARTCNT + 1) { $start = $mail_num - ARTCNT + 1; } if ($start <= 0) { $start = 1; if ($num > $mail_num) { $num = $mail_num; } } $maildata = bbs_getmails($mail_fullpath, $start - 1, $num); if ($maildata == FALSE) { atomic_error("读取邮件数据失败!"); } $html = '<form action="?" method="get"><input type="hidden" name="act" value="mail"/>'; $html .= '<a href="?act=mailpost">写信</a> '; if ($start > 1) { $i = $start - ARTCNT; if ($i < 1) { $i = 1; } $html .= '<a href="?act=mail&start=1">第一页</a> '; $html .= '<a href="?act=mail&start=' . $i . '">上一页</a> '; } else { $html .= '第一页 上一页 '; } if ($start <= $mail_num - ARTCNT) { $i = $start + ARTCNT; if ($i > $mail_num) { $i = $mail_num; } $html .= '<a href="?act=mail&start=' . $i . '">下一页</a> '; $html .= '<a href="?act=mail">最后一页</a> '; } else { $html .= '下一页 最后一页 '; } $html .= '<input type="submit" value="跳转到"/> 第 <input type="text" name="start" size="3" /> 篇</form>'; $html .= '<pre> 编号 发信者 日 期 标 题<br/>'; for ($i = 0; $i < count($maildata); $i++) { $article = $maildata[$i]; $title = $article["TITLE"]; if (strncmp($title, "Re: ", 4) != 0) { $title = "★ " . $title; } $html .= sprintf("%5d ", $start + $i); $html .= $maildata[$i]["FLAGS"]; $html .= sprintf(" %-12.12s ", $article["OWNER"]); $html .= strftime("%b %e ", $article["POSTTIME"]); $html .= $maildata[$i]["ATTACHPOS"] > 0 ? "@" : " "; $html .= "<a href='?act=mailread&num=" . ($start + $i) . "'>" . htmlspecialchars($title) . " </a> (" . sizestring($maildata[$i]['EFFSIZE']) . ")<br/>"; } $html .= "</pre>"; echo $html; atomic_footer(); }
/** * Формирование данных доступных в шаблоне. */ function createData() { static $useitems = array(); if ($this->params['sort'] != 5) { $this->supportCached(); } $this->params['idcat'] = (int) $this->params['idcat']; $this->params['rows'] = (int) $this->params['rows']; if ($this->params['idcat']) { $catrow = A::$DB->getRowById($this->params['idcat'], "{$this->section}_categories"); $catrow['link'] = catalog_createCategoryLink($this->params['idcat'], $this->section); $this->Assign("category", $catrow); } if ($this->section == SECTION && A::$MAINFRAME->iditem) { $useitems[$this->section][] = A::$MAINFRAME->iditem; } switch ($this->params['sort']) { default: case 1: $sort = "date DESC"; break; case 2: $sort = "date"; break; case 3: $sort = "name"; break; case 4: $sort = "sort"; break; case 5: $sort = "RAND()"; break; } $where = array(); if ($this->params['idcat']) { $idcat = $this->params['idcat']; $childcats = array($idcat); getTreeSubItems($this->section . "_categories", $idcat, $childcats); $where[] = "idcat IN(" . implode(",", $childcats) . ")"; } if (!empty($this->params['filter'])) { $where[] = $this->params['filter']; } if (!empty($useitems[$this->section]) && !empty($this->params['nodouble'])) { $where[] = "NOT id IN(" . implode(',', $useitems[$this->section]) . ")"; } $sql = "\r\r\n\tSELECT *,svote/cvote AS vote FROM {$this->section}_catalog\r\r\n\tWHERE active='Y'" . (!empty($where) ? " AND " . implode(" AND ", $where) : "") . "\r\r\n\tORDER BY {$sort}"; if ($this->params['rows']) { A::$DB->queryLimit($sql, 0, $this->params['rows']); } else { A::$DB->query($sql); } $items = array(); while ($row = A::$DB->fetchRow()) { $row['category'] = getTreePath($this->section . "_categories", $row['idcat']); $row['link'] = catalog_createItemLink($row['id'], $this->section); $row['vote'] = round($row['vote'], 2); if ($this->options['useimages']) { $row['images'] = A::$DB->getAll("\r\r\n\t SELECT * FROM " . getDomain($this->section) . "_images\r\r\n\t WHERE idsec=? AND iditem=? ORDER BY sort", array($this->section_id, $row['id'])); $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0; } if ($this->options['usefiles']) { $row['files'] = A::$DB->getAll("\r\r\n\t SELECT * FROM " . getDomain($this->section) . "_files\r\r\n\t WHERE idsec=? AND iditem=? ORDER BY sort", array($this->section_id, $row['id'])); foreach ($row['files'] as $i => $data) { $row['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name']; $row['files'][$i]['size'] = sizestring($data['size']); } $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0; } if ($this->options['usetags']) { $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']); } prepareValues($this->section, $row); $row = A::$OBSERVER->Modifier('catalog_prepareValues', $this->section, $row); $useitems[$this->section][] = $row['id']; $items[] = $row; } A::$DB->free(); $this->Assign("items", $items); $this->Assign("items_count", count($items)); }
/** * Формирование данных доступных в шаблоне. */ function createData() { static $useitems = array(); if ($this->params['sort'] != 5) { $this->supportCached(); } $this->params['idcat'] = (int) $this->params['idcat']; $this->params['rows'] = (int) $this->params['rows']; if ($this->params['idcat']) { $catrow = A::$DB->getRowById($this->params['idcat'], "{$this->section}_categories"); $catrow['link'] = shoplite_createCategoryLink($this->params['idcat'], $this->section); $this->Assign("category", $catrow); } if ($this->section == SECTION && A::$MAINFRAME->iditem) { $useitems[] = A::$MAINFRAME->iditem; } if (!empty($this->params['mysort'])) { $sort = $this->params['mysort']; } else { switch ($this->params['sort']) { case 1: $sort = "name"; break; case 2: $sort = "price DESC"; break; case 3: $sort = "price"; break; case 4: $sort = "sort"; break; case 5: $sort = "RAND()"; break; } } $where = array(); if ($this->params['idcat']) { $idcat = $this->params['idcat']; $childcats = array($idcat); getTreeSubItems($this->section . "_categories", $idcat, $childcats); $where[] = "(idcat IN(" . implode(",", $childcats) . ") OR idcat1 IN(" . implode(",", $childcats) . ") OR idcat2 IN(" . implode(",", $childcats) . "))"; } switch ($this->params['filter']) { case 1: $where[] = "favorite='Y'"; break; case 2: $where[] = "new='Y'"; break; } if (!empty($this->params['myfilter'])) { $where[] = $this->params['myfilter']; } if ($useitems && !empty($this->params['nodouble'])) { $where[] = "NOT id IN(" . implode(',', $useitems) . ")"; } $sql = "\r\r\n\tSELECT * FROM {$this->section}_catalog\r\r\n\tWHERE active='Y'" . (!empty($where) ? " AND " . implode(" AND ", $where) : "") . "\r\r\n\tORDER BY {$sort}"; if ($this->params['rows']) { A::$DB->queryLimit($sql, 0, $this->params['rows']); } else { A::$DB->query($sql); } $items = array(); while ($row = A::$DB->fetchRow()) { if ($this->params['idcat'] == 0) { $row['category'] = getTreePath($this->section . "_categories", $row['idcat']); } $row['link'] = shoplite_createItemLink($row['id'], $this->section); $row['tobasketlink'] = getSectionLink($this->section) . "?action=addbasket&id=" . $row['id']; $row['vote'] = $row['cvote'] > 0 ? round($row['svote'] / $row['cvote'], 2) : 0; $row['available'] = $row['iscount'] > 0; if ($this->options['useimages']) { $row['images'] = A::$DB->getAll("\r\r\n\t SELECT * FROM " . getDomain($this->section) . "_images\r\r\n\t WHERE idsec=? AND iditem=? ORDER BY sort", array($this->section_id, $row['id'])); $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0; } if ($this->options['usefiles']) { $row['files'] = A::$DB->getAll("\r\r\n\t SELECT * FROM " . getDomain($this->section) . "_files\r\r\n\t WHERE idsec=? AND iditem=? ORDER BY sort", array($this->section_id, $row['id'])); foreach ($row['files'] as $i => $data) { $row['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name']; $row['files'][$i]['size'] = sizestring($data['size']); } $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0; } if ($this->options['modprices']) { $mprices = !empty($row['mprices']) ? unserialize($row['mprices']) : array(); $row['mprices'] = array(); foreach ($mprices as $i => $mp) { $row['mprices'][] = array('id' => $i, 'name' => $mp['name'], 'price' => $mp['price']); } } if ($this->options['usetags']) { $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']); } prepareValues($this->section, $row); $row = A::$OBSERVER->Modifier('shoplite_prepareValues', $this->section, $row); $useitems[] = $row['id']; $items[] = $row; } A::$DB->free(); $this->Assign("items", $items); $this->Assign("items_count", count($items)); $this->Assign('valute', $this->options['valute']); }