<?php
create_page_params(true);
required_params('id');
if (isset(Request::$params->samples) && Request::$params->samples == 0) {
unset(Request::$params->samples);
}
$pool = Pool::find(array(Request::$params->id));
if (!$pool) {
return 404;
}
$browse_mode = User::$current->pool_browse_mode;
// $q = Tag::parse_query("");
$q = array();
$q['pool'] = (int) Request::$params->id;
$q['show_deleted_only'] = false;
if ($browse_mode == 1) {
$q['limit'] = 1000;
$q['order'] = "portrait_pool";
} else {
$q['limit'] = 24;
}
// $count = Post::count_by_sql(Post::generate_sql($q, array('from_api' => true, 'count' => true)));
// WillPaginate::Collection.new(params[:page], q[:limit], count)
$sql = Post::generate_sql($q, array('from_api' => true, 'offset' => $offset, 'limit' => $pagination_limit));
$posts = Post::find_by_sql(array($sql), array('calc_rows' => 'found_posts'));
calc_pages();
set_title($pool->pretty_name());
switch (Request::$format) {
case 'json':
render('json', $pool->to_json());
<?php
auto_set_params(array('commit', 'query'));
set_title("Tag Implications");
create_page_params();
if (Request::$params->commit == "Search Aliases") {
redirect_to("tag_alias#index", array('query' => Request::$params->query));
}
if (Request::$params->query) {
$name = "%" . Request::$params->query . "%";
$implications = TagImplication::find_all(array('calc_rows', 'order' => "is_pending DESC, (SELECT name FROM tags WHERE id = tag_implications.predicate_id), (SELECT name FROM tags WHERE id = tag_implications.consequent_id)", 'per_page' => 20, 'conditions' => array("predicate_id IN (SELECT id FROM tags WHERE name LIKE ?) OR consequent_id IN (SELECT id FROM tags WHERE name LIKE ?)", $name, $name), 'page' => Request::$params->page));
} else {
$implications = TagImplication::find_all(array('calc_rows', 'order' => "is_pending DESC, (SELECT name FROM tags WHERE id = tag_implications.predicate_id), (SELECT name FROM tags WHERE id = tag_implications.consequent_id)", 'per_page' => 20, 'page' => Request::$params->page));
}
calc_pages();
respond_to_list("implications");
<?php
set_title("Comments");
auto_set_params(array('page' => 1));
create_page_params(array('limit' => 10));
if (Request::$format == "json" || Request::$format == "xml") {
$comments = Comment::find_all(array_merge(Comment::generate_sql(Request::$params), array('per_page' => 25, 'page' => Request::$params->page, 'order' => 'id DESC')));
// Comment.paginate(Comment.generate_sql(params).merge(:per_page => 25, :page => params[:page], :order => "id DESC"))
respond_to_list($comments);
} else {
$posts = Post::find_all(array('calc_rows', 'order' => 'last_commented_at DESC', 'conditions' => 'last_commented_at IS NOT NULL', 'per_page' => 10, 'page' => Request::$params->page));
// Post.paginate :order => "last_commented_at DESC", :conditions => "last_commented_at IS NOT NULL", :per_page => 10, :page => params[:page]
// vde($posts);
$comments = array();
foreach ($posts as $post) {
$comments[] = $post->recent_comments();
}
// @posts.each { |post| comments.push(*post.recent_comments) }
// exit;
// newest_comment = comments.max {|a,b| a.created_at <=> b.created_at }
// if !@current_user.is_anonymous? && newest_comment && @current_user.last_comment_read_at < newest_comment.created_at
// @current_user.update_attribute(:last_comment_read_at, newest_comment.created_at)
// end
// $posts = $posts.select {|x| x.can_be_seen_by?(@current_user, {:show_deleted => true})}
$i = 0;
foreach ($posts as &$x) {
if (!$x->can_be_seen_by(User::$current, array('show_deleted' => true))) {
unset($posts->{$i});
}
unset($x);
$i++;
