function showThread($thr, $visitors, $comments, $categoryID, $categoryUser, $threadMembers, $threadID, $userID) { $counter = 0; foreach ($threadMembers as $tm) { $author = $thr->author; if ($tm->thread_id == $threadID and $tm->user_id == $userID or $author == $userID) { $counter = $counter + 1; } else { foreach ($categoryUser as $catUS) { if ($catUS->category_id == $categoryID and $catUS->user_id == $userID) { $counter = $counter + 1; } } } } if ($counter > 0) { echo "\n\t\t\t\t<tr>\n <td>\n <div class='thread-list-title'>\n <h4>" . anchor('thread/view/' . $thr->id, $thr->title) . "\n <small class='label label-default'><i class='fa fa-lock'></i> Close Group</small>\n \t\t</h4>\n </div>\n <div class='thread-list-meta'>\n <ul>\n <li>\n " . countViewer($visitors, $thr->id) . " Views\n </li>\n <li>\n " . countComments($comments, $thr->id) . " Comments\n </li>\n <li>\n Started by <a href='#'>" . user($thr->author)->full_name . "</a>\n </li>\n <li>\n " . $thr->created_at . "\n </li>\n <li>\n in <a href='#'>" . $thr->category_name . "</a>\n </li>\n </ul>\n </div>\n </td>\n </tr>\n\t\t\t"; } else { } }
echo '<small class="label label-default"><i class="fa fa-lock"></i> Close Group</small>'; } ?> </h4> </div> <div class="thread-list-meta"> <ul> <li> <?php echo countViewer($visitors, $thr->id); ?> Views </li> <li> <?php echo countComments($comments, $thr->id); ?> Comments </li> <li> Started by <a href="#"><?php echo user($thr->author)->full_name; ?> </a> </li> <li> <?php echo Carbon\Carbon::parse($thr->created_at)->format('d F Y H:i'); ?> </li> <li>
if ($page == "") { $page = "1"; } $currentpage = $page; STemplate::assign('page', $page); if ($page >= 2) { $pagingstart = ($page - 1) * $config['items_per_page']; } else { $pagingstart = "0"; } $query1 = "SELECT count(*) as total from posts A, members B where A.active='1' AND A.USERID=B.USERID AND A.phase>'1' order by A.htime desc limit {$config['maximum_results']}"; $query2 = "SELECT A.*, B.username from posts A, members B where A.active='1' AND A.USERID=B.USERID AND A.phase>'1' order by A.htime desc limit {$pagingstart}, {$config['items_per_page']}"; $executequery1 = $conn->Execute($query1); $totalvideos = $executequery1->fields['total']; if ($totalvideos > 0) { if ($executequery1->fields['total'] <= $config[maximum_results]) { $total = $executequery1->fields['total']; } else { $total = $config[maximum_results]; } $toppage = ceil($total / $config[items_per_page]); if ($page <= $toppage) { $executequery2 = $conn->Execute($query2); $posts = $executequery2->getrows(); $posts = getTags($posts); $posts = countComments($posts); $posts = getHash($posts); STemplate::assign('posts', $posts); STemplate::display('posts_bit_more.tpl'); } }
public function __construct($database, $page) { $this->db = $database; $this->page = intval($page); $this->commentsCount = countComments($database); }
echo $project['project_id']; ?> " style="display: none;" title="Unroute">Routed</a> <a href="#" class="project-action-btn" id="route_project" data-id="<?php echo $project['project_id']; ?> ">Route</a> <?php } ?> <a href="#" class="project-action-btn" id="comment_project" data-id="<?php echo $project['project_id']; ?> ">Comment <span><?php echo countComments($project['project_id']); ?> </span></a> <?php if (checkLikedProject($project['project_id'], $_SESSION['uid'])) { ?> <a href="#" class="project-action-btn" id="liked_project" data-id="<?php echo $project['project_id']; ?> " title="Unlike">Liked <span class="totalLikes"><?php echo getLikes($project['project_id']); ?> </span></a> <a href="#" class="project-action-btn" id="like_project" data-id="<?php echo $project['project_id'];
} //usort($canteen_info,"compare"); $json = getJsonResponse(0, 'success', $canteen_info); $cache->set($cachename, $json); //计算食物排名 $food_info = $db->query("select canteens.canteen_id,canteenname,food.food_id,foodname,price,favor,dislike,imageurl,canteen_food.grade\n\t\t\t\t\tfrom canteens,food,canteen_food\n\t\t\t\t\twhere canteens.canteen_id=canteen_food.canteen_id and food.food_id=canteen_food.food_id and \n\t\t\t\t\tcanteen_food.canteen_id in \n\t\t\t\t\t(select canteen_id from school_canteen where school_id={$value['school_id']})\n\t\t\t\t\torder by grade desc limit 0,10;"); if ($food_info === false) { Log::error_log('database error:' . $db->error . ' in ' . basename(__FILE__)); //echo $db->error; exit; } else { if (empty($food_info)) { continue; } foreach ($food_info as &$value3) { countComments($db, $value3); } } //usort($food_info,"compare"); $json2 = getJsonResponse(0, 'success', $food_info); $cachename = "ranking.php" . md5("getfood&schoolid={$value['school_id']}") . '.txt'; $cache->set($cachename, $json2); //echo json2; } } function countfood(&$db, &$value) { $res = $db->query("select count(*) from canteen_food where canteen_id={$value['canteen_id']};"); if ($res === false) { Log::error_log('database error:' . $db->error . ' in ' . basename(__FILE__)); $db->close();
data-id="<?php echo $project['project_id']; ?> ">Route</a> <!-- --><?php //} ?> <a href="#" class="project-action-btn" id="comment_project" data-id="<?php echo $project['project_id']; ?> ">Comment <span><?php $cmt = countComments($project['project_id']); ?> </span></a> <?php if (checkLikedProject($project['project_id'], $_SESSION['uid'])) { ?> <a href="#" class="project-action-btn" id="liked_project" data-id="<?php echo $project['project_id']; ?> " title="Unlike">Liked <span class="totalLikes"><?php echo getLikes($project['project_id']); ?> </span></a>
$output = str_replace("{author}", $my_author, $output); if ($news_arr[5] != "") { $output = str_replace("{avatar}", "<img alt=\"\" src=\"{$news_arr['5']}\" style=\"border: none;\" />", $output); } else { $output = str_replace("{avatar}", "", $output); } $output = str_replace("{avatar-url}", "{$news_arr['5']}", $output); # Music hack by rilmith 3 lines below. if ($news_arr[7] != "") { $output = str_replace("{music}", $news_arr[7], $output); } else { $output = str_replace("{music}", "", $output); } $output = str_replace("[link]", "<a title=\"{$lang_article_linktext}\" href=\"{$PHP_SELF}?aj_go=more&id={$news_arr['0']}&archive={$archive}&start_from={$my_start_from}&ucat={$news_arr['6']}&{$user_query}\">", $output); $output = str_replace("[/link]", "</a>", $output); $output = str_replace("{comments-num}", countComments($news_arr[0], $archive), $output); #MORE HACK $content = explode('<!--more-->', $news_arr[3]); if ($allow_rss == TRUE) { # $content[0] = str_replace(array("\r", "\n", "\t","{nl}"), "", $content[0]); $content[0] = strip_tags($content[0]); } $short_story = run_filters('news-entry-content', $content[0]); if ($allow_rss == TRUE) { # $content[0] = str_replace(array("\r", "\n", "\t","{nl}"), "", $content[0]); $short_story = strip_tags($short_story); } $output = str_replace("{short-story}", $short_story, $output); $output = str_replace("{full-story}", run_filters('news-entry-content', $content[1]), $output); $output = str_replace("{category}", $cat[$news_arr[6]], $output); $output = str_replace("{category-id}", $news_arr[6], $output);
$title = word_truncate($title, 75); // It's prospect article $prosrev = false; if ($item_db[NEW_ID] > time() && $source != 'postponed') { $prosrev = getpart('post_rev'); } // Enable Up/Down without sorting if (!isset($_REQUEST['ord_title']) and !isset($_REQUEST['ord_date'])) { $up = $PHP_SELF . build_uri('mod,action,direct,id,source,start_from,news_per_page,category,author', array('editnews', 'move', 'up', $item_db[0])); $down = $PHP_SELF . build_uri('mod,action,direct,id,source,start_from,news_per_page,category,author', array('editnews', 'move', 'down', $item_db[0])); $ORDER = getpart('editnews_order', array($up, $down)); } else { $ORDER = '-'; } $the_oneln = array('id' => $item_db[NEW_ID], 'title' => str_replace(array('<', '>'), array('<', '>'), $title), 'bg' => $bg, 'source' => $source, 'pros' => $prosrev, 'order' => $ORDER); $count_comments = countComments($item_db[NEW_ID], $source); if ($count_comments) { $the_oneln['comments'] = $count_comments; } else { $the_oneln['comments'] = "<span style='color:gray;'>" . $count_comments . "</span>"; } // Make category names if (empty($item_db[NEW_CAT])) { $the_oneln['category'] = "<span style='color: gray;'>---</span>"; } elseif (strstr($item_db[NEW_CAT], ',')) { $my_multy_cat_labels = array(); $all_this_cats_arr = spsep($item_db[NEW_CAT]); foreach ($all_this_cats_arr as $this_single_cat) { $my_multy_cat_labels[] = $cat[$this_single_cat]; } $my_multy_cat_labels = join(', ', $my_multy_cat_labels);
function template_replacer_news($news_arr, $output) { // Predefined Globals global $config_timestamp_active, $config_http_script_dir, $config_comments_popup, $config_comments_popup_string, $config_full_popup, $config_full_popup_string, $rss_news_include_url, $my_names, $my_start_from, $cat, $action, $cat_icon, $archive, $name_to_nick, $template, $user_query, $member_db, $_SESS, $PHP_SELF; // Short Story not exists if (empty($news_arr[NEW_FULL]) and strpos($output, '{short-story}') === false) { $news_arr[NEW_FULL] = $news_arr[NEW_SHORT]; } $output = more_fields($news_arr[NEW_MF], $output); // Date Formatting [year, month, day, hour, minute, date=$config_timestamp_active] list($output, $news_arr) = hook('template_replacer_news_before', array($output, $news_arr)); $output = embedateformat($news_arr[NEW_ID], $output); // Replace news content $output = str_replace("{title}", hesc($news_arr[NEW_TITLE]), $output); $output = str_replace("{author}", $my_names[$news_arr[NEW_USER]] ? $my_names[$news_arr[NEW_USER]] : $news_arr[NEW_USER], $output); $output = str_replace("{author-name}", hesc($name_to_nick[$news_arr[NEW_USER]]), $output); $output = str_replace("{short-story}", hesc($news_arr[NEW_SHORT]), $output); $output = str_replace("{full-story}", hesc($news_arr[NEW_FULL]), $output); // Replace system information $output = str_replace("{avatar-url}", $news_arr[NEW_AVATAR], $output); $output = str_replace("{category}", hesc(catid2name($news_arr[NEW_CAT])), $output); $output = str_replace("{category-url}", linkedcat($news_arr[NEW_CAT]), $output); $output = str_replace("{page-views}", false, $output); $output = str_replace("{phpself}", $PHP_SELF, $output); $output = str_replace("{index-link}", '<a href="' . $PHP_SELF . '">' . lang('Go back') . '</a>', $output); $output = str_replace("{back-previous}", '<a href="javascript:history.go(-1)">Go back</a>', $output); $output = str_replace("{cute-http-path}", $config_http_script_dir, $output); $output = str_replace("{news-id}", $news_arr[NEW_ID], $output); $output = str_replace("{category-id}", $news_arr[NEW_CAT], $output); $output = str_replace("{comments-num}", countComments($news_arr[NEW_ID], $archive), $output); $output = str_replace("{archive-id}", $archive, $output); $output = str_replace("{category-icon}", caticon($news_arr[NEW_CAT], $cat_icon, $cat), $output); $mf_for_avatar = options_extract($news_arr[NEW_MF]); if (array_key_exists('_avatar_width', $mf_for_avatar)) { $width_for_avatar = 'width:' . $mf_for_avatar['_avatar_width'] . ';'; } if (array_key_exists('_avatar_height', $mf_for_avatar)) { $height_for_avatar = 'height:' . $mf_for_avatar['_avatar_height'] . ';'; } $output = str_replace("{avatar}", $news_arr[NEW_AVATAR] ? '<img alt="" src="' . $news_arr[NEW_AVATAR] . '" style="border: none;' . $width_for_avatar . $height_for_avatar . '" />' : '', $output); $output = preg_replace('/\\[loggedin\\](.*?)\\[\\/loggedin\\]/is', empty($_SESS['user']) ? '' : '\\1', $output); // social plugins $output = str_replace('{fb-comments}', show_social_code('fb', $news_arr), $output); $output = str_replace('{fb-like}', show_social_code('fb-like', $news_arr), $output); $output = str_replace('{twitter}', show_social_code('twitter', $news_arr), $output); // in RSS we need the date in specific format if ($template == 'rss') { $output = str_replace("{date}", date("r", $news_arr[0]), $output); $output = str_replace("{rss-news-include-url}", $rss_news_include_url ? $rss_news_include_url : $config_http_script_dir . '/router.php', $output); } else { $output = str_replace("{date}", date($config_timestamp_active, $news_arr[NEW_ID]), $output); } // Star Rating if (empty($archive)) { $output = str_replace("{star-rate}", rating_bar($news_arr[NEW_ID], $news_arr[NEW_RATE]), $output); } else { $output = str_replace("{star-rate}", false, $output); } // Mail Exist in mailist ---------------------------------------------------- [mail]...[/mail] if (!empty($my_mails[$news_arr[NEW_USER]])) { $output = str_replace(array("[mail]", '[/mail]'), array('<a href="mailto:' . $my_mails[$news_arr[NEW_USER]] . '">', ''), $output); } else { $output = str_replace(array("[mail]", '[/mail]'), '', $output); } // By click to comments - popup window -------------------------------------- [com-link]...[/com-link] if ($config_comments_popup == "yes") { $URL = build_uri('subaction,id,ucat,start_from,template,archive', array('showcomments', $news_arr[NEW_ID], $news_arr[NEW_CAT], $my_start_from)); $output = str_replace(array('[com-link]', '[/com-link]'), array('<a href="#" onclick="window.open(\'' . $config_http_script_dir . '/router.php' . $URL . '\', \'News\', \'' . $config_comments_popup_string . '\'); return false;">', '</a>'), $output); } else { if ($archive) { $URL = RWU('archreadcomm', $PHP_SELF . build_uri('subaction,id,ucat,title,template,archive', array('showcomments', $news_arr[NEW_ID], $news_arr[NEW_CAT], titleToUrl($news_arr[NEW_TITLE])))); } else { $URL = RWU('readcomm', $PHP_SELF . build_uri('subaction,id,ucat,title,template', array('showcomments', $news_arr[NEW_ID], $news_arr[NEW_CAT], titleToUrl($news_arr[NEW_TITLE])))); } $output = str_replace(array("[com-link]", '[/com-link]'), array("<a href=\"{$URL}\">", '</a>'), $output); } // Open link --------------------------------------------------------------- [link]...[/link] $URL = build_uri('subaction,id,start_from,ucat,archive,template', array('showfull', $news_arr[NEW_ID], $my_start_from, $news_arr[NEW_CAT])); $URL .= "&#disqus_thread"; $output = preg_replace('/\\[link target\\=([a-z0-9_]+?)\\](.*?)\\[\\/link\\]/is', '<a href="' . $PHP_SELF . $URL . '" target="\\1">\\2</a>', $output); $output = str_replace(array("[link]", "[/link]"), array('<a href="' . $PHP_SELF . $URL . '">', "</a>"), $output); // With Action = showheadlines -------------------------------------------- [full-link]...[/full-link] if ($news_arr[NEW_FULL] or $action == "showheadlines") { if ($config_full_popup == "yes") { $URL = build_uri('subaction,id,archive,template', array('showfull', $news_arr[NEW_ID], $archive, $template)); // Popup string $attrlink = "href='#' onclick=\"window.open('{$config_http_script_dir}/router.php{$URL}', '_News', '{$config_full_popup_string}'); return false;\""; $output = preg_replace('/\\[full\\-link target\\=([a-z0-9_]+?)\\](.*?)\\[\\/full\\-link\\]/is', "<a {$attrlink} target='\\1'>\\2</a>", $output); $output = str_replace('[full-link]', "<a {$attrlink}>", $output); } else { $template = $template == 'Default' ? '' : $template; if ($archive) { $URL = RWU('archreadmore', $PHP_SELF . build_uri('subaction,id,archive,ucat,title,template', array('showfull', $news_arr[0], $archive, $news_arr[NEW_CAT], titleToUrl($news_arr[NEW_TITLE]), $template)) . "&{$user_query}"); } else { $URL = RWU('readmore', $PHP_SELF . build_uri('subaction,id,ucat,title,template', array('showfull', $news_arr[0], $news_arr[NEW_CAT], titleToUrl($news_arr[NEW_TITLE]), $template)) . "&{$user_query}"); } // Target string $attrlink = "href='{$URL}'"; $output = preg_replace('/\\[full\\-link target\\=([a-z0-9_]+?)\\](.*?)\\[\\/full\\-link\\]/is', "<a {$attrlink} target='\\1'>\\2</a>", $output); $output = str_replace("[full-link]", "<a {$attrlink}>", $output); } $output = str_replace("[/full-link]", "</a>", $output); } else { $output = preg_replace('~\\[full-link.*?\\].*?\\[/full-link\\]~si', '<!-- no full story-->', $output); } // Admin can edit for news ------------------------------------------------ [edit]...[/edit] $DREdit = false; if (empty($_SESS['user']) == false) { $member_db = user_search($_SESS['user']); if (in_array($member_db[UDB_ACL], array(ACL_LEVEL_ADMIN, ACL_LEVEL_JOURNALIST))) { $url = '/index.php' . build_uri('mod,action,id,source', array('editnews', 'editnews', $news_arr[NEW_ID], $archive)); $output = preg_replace('/\\[edit\\]/i', '<a target="_blank" href="' . $config_http_script_dir . $url . '">', $output); $output = preg_replace('/\\[\\/edit\\]/i', '</a>', $output); $DREdit = true; } } // If not used, replace [edit]..[/edit] if ($DREdit == false) { $output = preg_replace('~\\[edit\\].*?\\[/edit\\]~si', '', $output); } list($output, $news_arr) = hook('template_replacer_news_middle', array($output, $news_arr)); $output = replace_news("show", $output); list($output) = hook('template_replacer_news_after', array($output, $news_arr)); return $output; }