/**
* Display the list of paginated Posts (draft and published)
*/
function home()
{
Doo::loadHelper('DooPager');
Doo::loadModel('Post');
$p = new Post();
//if default, no sorting defined by user, show this as pager link
if ($this->sortField == 'createtime' && $this->orderType == 'desc') {
$pager = new DooPager(Doo::conf()->APP_URL . 'admin/post/page', $p->count(), 6, 10);
} else {
$pager = new DooPager(Doo::conf()->APP_URL . "admin/post/sort/{$this->sortField}/{$this->orderType}/page", $p->count(), 6, 10);
}
if (isset($this->params['pindex'])) {
$pager->paginate(intval($this->params['pindex']));
} else {
$pager->paginate(1);
}
$data['rootUrl'] = Doo::conf()->APP_URL;
$data['pager'] = $pager->output;
//Order by ASC or DESC
if ($this->orderType == 'desc') {
$data['posts'] = $p->limit($pager->limit, null, $this->sortField, array('select' => 'id,createtime,status,title,totalcomment'));
$data['order'] = 'asc';
} else {
$data['posts'] = $p->limit($pager->limit, $this->sortField, null, array('select' => 'id,createtime,status,title,totalcomment'));
$data['order'] = 'desc';
}
$this->render('admin', $data);
}
/**
* 查看专题
*/
public function actionShow($name)
{
$specialModel = Special::model()->find('title_alias=:titleAlias', array('titleAlias' => CHtml::encode(strip_tags($name))));
if (false == $specialModel) {
throw new CHttpException(404, '专题不存在');
}
//更新浏览次数
$specialModel->updateCounters(array('view_count' => 1), 'id=:id', array('id' => $specialModel->id));
$specialPostModel = new Post();
$criteria = new CDbCriteria();
$criteria->addCondition('t.status_is=:status AND special_id=:specialId');
$criteria->params = array('status' => 'Y', 'specialId' => $specialModel->id);
$criteria->order = 't.id DESC';
$bagecmsSpecialCount = $specialPostModel->count($criteria);
$postPage = new CPagination($bagecmsSpecialCount);
$postPage->pageSize = 10;
$postPageParams = XUtils::buildCondition($_GET, array());
$postPageParams['#'] = 'list';
$postPage->params = is_array($postPageParams) ? $postPageParams : array();
$criteria->limit = $postPage->pageSize;
$criteria->offset = $postPage->currentPage * $postPage->pageSize;
$specialPostList = $specialPostModel->findAll($criteria);
$this->_seoTitle = empty($specialModel->seo_title) ? $specialModel->title . ' - ' . $this->_conf['site_name'] : $specialModel->seo_title;
$tpl = empty($specialModel->tpl) ? 'show' : $specialModel->tpl;
$data = array('specialShow' => $specialModel, 'specialPostList' => $specialPostList, 'bagecmsPagebar' => $postPage);
$this->render($tpl, $data);
}
public function testDestroy()
{
$post = Factory::create('Post');
$this->action('DELETE', 'Admin\\PostsController@destroy', $post->slug);
$this->assertRedirectedToRoute('admin.posts.index');
$this->assertEquals(0, Post::count());
}
public function testAggregate()
{
$count = Post::count();
$debug = last(DB::getQueryLog());
$this->assertEquals(3, $count);
$this->assertEquals('select count(*) as aggregate from "posts" where "published" = ? and "status" = ?', $debug['query']);
}
/**
* 首页
*
*/
public function actionIndex()
{
$model = new Post();
$criteria = new CDbCriteria();
$condition = "1=1";
$title = trim($this->_request->getParam('title'));
$catalogId = intval($this->_request->getParam('catalogId'));
$title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
$catalogId && ($condition .= ' AND catalog_id= ' . $catalogId);
$criteria->condition = $condition;
$criteria->order = 't.id DESC';
$criteria->with = array('catalog');
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 10;
//根据title,catelogId,titleAlias查询
$pageParams = $this->buildCondition($_GET, array('title', 'catalogId'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
//推荐位
$recom_list = RecommendPosition::model()->findAll('type=:type', array(':type' => $this->_type), array('order' => 'id'));
$this->render('index', array('datalist' => $result, 'pagebar' => $pages, 'recom_list' => $recom_list));
}
/**
* 首页
*
*/
public function actionIndex()
{
parent::_acl();
$model = new Post();
$criteria = new CDbCriteria();
$condition = '1';
$title = trim($this->_gets->getParam('title'));
$titleAlias = trim($this->_gets->getParam('titleAlias'));
$catalogId = intval($this->_gets->getParam('catalogId'));
$title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
$titleAlias && ($condition .= ' AND title_alias LIKE \'%' . $titleAlias . '%\'');
$catalogId && ($condition .= ' AND catalog_id= ' . $catalogId);
$criteria->condition = $condition;
$criteria->order = 't.id DESC';
$criteria->with = array('catalog');
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 13;
$pageParams = XUtils::buildCondition($_GET, array('title', 'catalogId', 'titleAlias'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('index', array('datalist' => $result, 'pagebar' => $pages));
}
/**
* 获取栏目内容数据
*
* @param array $params
* @return array 数组
*/
protected function _catalogList($params = array())
{
$postModel = new Post();
$postCriteria = new CDbCriteria();
$condition = '1';
if ($params['catalog']) {
$condition .= ' AND t.catalog_id=:catalogId';
$criteriaParams[':catalogId'] = intval($params['catalog']);
}
if ($params['keyword']) {
$condition .= ' AND t.title=:title';
$criteriaParams[':title'] = CHtml::encode(strip_tags($params['keyword']));
}
$condition .= " AND t.status_is='Y'";
$postCriteria->condition = $condition;
$postCriteria->params = $criteriaParams;
$postCriteria->order = 't.id DESC';
$postCriteria->with = 'catalog';
$count = $postModel->count($postCriteria);
$postPages = new CPagination($count);
$postPages->pageSize = $params['pageSize'] > 0 ? $params['pageSize'] : 20;
$pageParams = XUtils::buildCondition($_GET, array('catalog', 'keyword'));
$postPages->params = is_array($pageParams) ? $pageParams : array();
$postCriteria->limit = $postPages->pageSize;
$postCriteria->offset = $postPages->currentPage * $postPages->pageSize;
$bagecmsDataList = $postModel->findAll($postCriteria);
$catalogArr = Catalog::item($params['catalog'], $this->_catalog);
if ($catalogArr) {
$this->_seoTitle = empty($catalogArr['catalog_name']) ? $this->_seoTitle : $catalogArr['catalog_name'];
$bagecmsCatalogData = $catalogArr;
$this->_seoKeywords = empty($catalogArr['seo_keywords']) ? $this->_seoKeywords : $catalogArr['seo_keywords'];
$this->_seoDescription = empty($catalogArr['seo_description']) ? $this->_seoDescription : $catalogArr['seo_description'];
}
return array('bagecmsDataList' => $bagecmsDataList, 'bagecmsPagebar' => $postPages, 'bagecmsCatalogData' => $bagecmsCatalogData);
}
public function showWelcome()
{
//echo "Coming Soon";
try {
DB::connection()->getDatabaseName();
//Session::set('locale' , 'es');
$post = Post::get();
$cats = Category::orderBy('order_type')->get();
$noti_post = Post::orderBy(DB::raw('RAND()'))->where('is_approved', 1)->first();
$post_test = Post::count();
// i++ page count
counter('home');
return View::make('index')->with('posts', $post)->with('noti_post', $noti_post)->with('cats', $cats)->with('post_test', $post_test);
} catch (Exception $e) {
return Redirect::route('install');
}
}
public function run()
{
$model = new Post();
//条件
$criteria = new CDbCriteria();
$title = trim(Yii::app()->request->getParam('title'));
$catalogId = intval(Yii::app()->request->getParam('catalogId'));
$criteria->addColumnCondition(array('type' => $this->controller->_type));
$title && $criteria->addSearchCondition('title', $title);
$catalogId && $criteria->addColumnCondition(array('catalog_id' => $catalogId));
$criteria->order = 't.id DESC';
$criteria->with = array('catalog');
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
$result = $model->findAll($criteria);
$this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages));
}
/**
* Список сообщений
*/
public function topic($id)
{
if (!($topic = Topic::find_by_id($id))) {
App::abort('default', 'Данной темы не существует!');
}
if (User::check()) {
$bookmark = Bookmark::find_by_topic_id_and_user_id($id, User::get('id'));
if ($bookmark && $topic->postCount() > $bookmark->posts) {
$bookmark->posts = $topic->postCount();
$bookmark->save();
}
}
$total = Post::count(['conditions' => ['topic_id = ?', $id]]);
$page = App::paginate(Setting::get('posts_per_page'), $total);
$posts = Post::all(['conditions' => ['topic_id = ?', $id], 'offset' => $page['offset'], 'limit' => $page['limit'], 'order' => 'created_at', 'include' => ['user']]);
$crumbs = ['/forum' => 'Форум', '/forum/' . $topic->forum()->id => $topic->forum()->title, $topic->title];
if ($topic->forum()->parent_id) {
$crumbs = ['/forum' => 'Форум', '/forum/' . $topic->forum()->parent_id => $topic->forum()->parent()->title, '/forum/' . $topic->forum()->id => $topic->forum()->title, $topic->title];
}
App::view('forums.topic', compact('topic', 'posts', 'page', 'crumbs'));
}
function home()
{
Doo::loadHelper('DooPager');
Doo::loadModel('Post');
$p = new Post();
$p->status = 1;
//published post only
$pager = new DooPager(Doo::conf()->APP_URL . 'page', $p->count(), 4, 10);
if (isset($this->params['pindex'])) {
$pager->paginate(intval($this->params['pindex']));
} else {
$pager->paginate(1);
}
//limit post and order by create time descendingly, get only Posts
//$this->data['posts'] = $p->limit($pager->limit, null, 'createtime');
//limit post and order by create time descendingly with post's tags
$this->data['posts'] = $p->relateTag(array('limit' => $pager->limit, 'desc' => 'post.createtime', 'asc' => 'tag.name', 'match' => false));
$this->data['pager'] = $pager->output;
$this->data['rootUrl'] = Doo::conf()->APP_URL;
//prepare sidebar data, tags and archive list
$this->prepareSidebar();
$this->render('index', $this->data);
}
/**
* 首页
*/
public function actionIndex()
{
$keyword = CHtml::encode(strip_tags(trim($this->_gets->getParam('keyword'))));
$postModel = new Post();
$postCriteria = new CDbCriteria();
if ($keyword) {
$postCriteria->addSearchCondition('t.title', $keyword);
}
$postCriteria->addCondition('t.status_is=:status');
$postCriteria->params[':status'] = 'Y';
$postCriteria->with = 'catalog';
$postCriteria->order = 't.id DESC';
$bagecmsQuestionCount = $postModel->count($postCriteria);
$postPages = new CPagination($bagecmsQuestionCount);
$postPages->pageSize = 15;
$postPageParams = XUtils::buildCondition($_GET, array('keyword'));
$postPageParams['#'] = 'list';
$postPages->params = is_array($postPageParams) ? $postPageParams : array();
$postCriteria->limit = $postPages->pageSize;
$postCriteria->offset = $postPages->currentPage * $postPages->pageSize;
$postList = $postModel->findAll($postCriteria);
$this->render('index', array('bagecmsDataList' => $postList, 'bagecmsPagebar' => $postPages));
}
/**
* Posts list
*
* @param Request $request
* @param $opts
* @return mixed
*/
public function posts_list(Request $request, $opts)
{
$title = $this->lang->translate('post.list');
// Delete post
if ($request->get('delete')) {
$post = \Post::find_by_id(intval($request->get('delete')));
if ($post && $post->delete()) {
$this->view->assign('message', $this->lang->translate('form.deleted'));
}
}
// Publish post
if ($request->get('accept')) {
$post = \Post::find_by_id(intval($request->get('accept')));
if ($post) {
$post->moderate = '0';
$post->created_at = time();
if ($post->save()) {
$this->view->assign('message', $this->lang->translate('post.published'));
}
// Export to social
$post->export();
// Pinging sitemap
NCService::load('SocialMedia.Ping');
} else {
$this->view->assign('message', $this->lang->translate('post.error_publish'));
}
}
// Filter
$filter['order'] = 'id DESC';
if ($request->order) {
$filter['order'] = $request->order;
}
$conditions = [];
$values = [];
// By Category
if ($request->get('category')) {
$category = \PostCategory::find($request->get('category'));
if ($category) {
$conditions[] = 'category_id = ?';
$values[] = $category->id;
}
}
// By Author
if ($request->get('author')) {
$author = \User::find($request->get('author'));
if ($author) {
$conditions[] = 'author_id = ?';
$values[] = $author->id;
}
}
// Premoderate
$conditions[] = 'moderate = ?';
if ($opts->get('mod')) {
$title = $this->lang->translate('post.onmoderation');
$values[] = '1';
} else {
$values[] = '0';
}
if ($conditions) {
$filter['conditions'] = array_merge([implode(' AND ', $conditions)], $values);
}
/** @var Listing $paginator */
$paginator = NCService::load('Paginator.Listing', [$request->page, \Post::count($filter)]);
$filter = array_merge($filter, $paginator->limit());
// Filter users
$posts = \Post::all($filter);
// Mass managing
// Accept all visible
if ($request->get('accept') == 'all') {
foreach ($posts as $item) {
$item->moderate = '0';
$item->save();
// Export to social
Module::export($item, $this->view);
}
// Pinging sitemap
NCService::load('SocialMedia.Ping');
return static::redirect_response($request->getPathInfo());
}
// Sent to moderate all visible
if ($request->get('moderate') == 'all') {
foreach ($posts as $item) {
$item->moderate = '1';
$item->save();
}
return static::redirect_response($request->getPathInfo());
}
// Delete all visible
if ($request->get('delete') == 'all') {
foreach ($posts as $item) {
$item->delete();
}
return static::redirect_response($request->getPathInfo());
}
$posts = array_map(function ($i) {
return $i->to_array();
}, $posts);
return $this->view->render('posts/list.twig', ['title' => $title, 'posts_list' => $posts, 'listing' => $paginator->pages(), 'page' => $paginator->cur_page, 'moderate' => $opts->get('mod')]);
}
<?php
Route::collection(array('before' => 'auth,csrf'), function () {
/*
List all posts and paginate through them
*/
Route::get(array('admin/posts', 'admin/posts/(:num)'), function ($page = 1) {
$perpage = Post::perPage();
$total = Post::count();
$posts = Post::sort('created', 'desc')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/posts');
$pagination = new Paginator($posts, $total, $page, $perpage, $url);
$vars['messages'] = Notify::read();
$vars['posts'] = $pagination;
$vars['categories'] = Category::sort('title')->get();
$vars['status'] = 'all';
return View::create('posts/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
});
/*
List posts by category and paginate through them
*/
Route::get(array('admin/posts/category/(:any)', 'admin/posts/category/(:any)/(:num)'), function ($slug, $page = 1) {
if (!($category = Category::slug($slug))) {
return Response::error(404);
}
$query = Post::where('category', '=', $category->id);
$perpage = Post::perPage();
$total = $query->count();
$posts = $query->sort('created', 'desc')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/posts/category/' . $category->slug);
$pagination = new Paginator($posts, $total, $page, $perpage, $url);
<?php
required_params('post');
if (User::is('<=20') && Post::count(array('conditions' => array("user_id = ? AND created_at > ? ", User::$current->id, gmd_math('sub', '1D')))) >= CONFIG::member_post_limit) {
respond_to_error("Daily limit exceeded", "#error", array('status' => 421));
}
auto_set_params(array('md5'));
$status = User::is('>=30') ? 'active' : 'pending';
Request::$params->post = array_merge(Request::$params->post, array('updater_user_id' => User::$current->id, 'updater_ip_addr' => Request::$remote_ip, 'user_id' => User::$current->id, 'ip_addr' => Request::$remote_ip, 'status' => $status, 'tempfile_path' => $_FILES['post']['tmp_name']['file'], 'tempfile_name' => $_FILES['post']['name']['file'], 'is_upload' => true));
$post = Post::create(Request::$params->post);
if ($post->record_errors->blank()) {
if (Request::$params->md5 && $post->md5 != strtolower(Request::$params->md5)) {
$post->destroy();
respond_to_error("MD5 mismatch", '#error', array('status' => 420));
} else {
$api_data = array('post_id' => $post->id, 'location' => url_for('post#show', array('id' => $post->id)));
if (CONFIG::dupe_check_on_upload && $post->is_image() && empty($post->parent_id)) {
// if (Request::$format == "xml" || Request::$format == "json") {
// $options = array('services' => SimilarImages::get_services('local'), 'type' => 'post', 'source' => $post);
// $res = SimilarImages::similar_images($options);
// if (!empty($res['posts'])) {
// $post->tags .= " possible_duplicate";
// $post->save();
// $api_data['has_similar_hits'] = true;
// }
// }
$api_data['similar_location'] = url_for('post#similar', array('id' => $post->id, 'initial' => 1));
respond_to_success("Post uploaded", array('#similar', array('id' => $post->id, 'initial' => 1)), array('api' => $api_data));
} else {
respond_to_success("Post uploaded", array('#show', array('id' => $post->id, 'tag_title' => $post->tag_title())), array('api' => $api_data));
}
public function postList()
{
$take = Input::get('take');
$skip = Input::get('skip');
$validator = Validator::make(array('take' => $take, 'skip' => $skip), array('take' => 'required', 'skip' => 'required'));
if ($validator->fails()) {
$error_messages = $validator->messages()->all();
$response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
$response_code = 200;
} else {
$posts = Post::take($take)->skip($skip)->orderBy('created_at', 'desc')->get();
$counts = Post::count();
$datas = array();
foreach ($posts as $post) {
$publisher_name = "";
$publisher_image = "";
if ($post) {
$publisher = Publisher::find($post->publisher_id)->first();
if (count($publisher) != 0) {
$publisher_name = $publisher->name;
$publisher_image = $publisher->image;
}
}
$data = array();
$data['id'] = $post->id;
$data['title'] = $post->title;
$data['description'] = $post->des;
$data['url'] = $post->url;
$data['image'] = $post->image;
$data['time'] = $post->created_at;
$data['share_link'] = $post->link;
$data['category'] = $post->category;
$data['is_approved'] = $post->is_approved;
$data['title_tag'] = $post->title_tag;
$data['meta_desc'] = $post->meta_des;
$data['publisher_image'] = $publisher_image;
$data['publisher_name'] = $publisher_name;
array_push($datas, $data);
}
$response_array = array('success' => true, 'posts' => $datas, 'counts' => $counts);
}
return Response::json($response_array);
}
public function testBootMethodAgainAndAgain()
{
Post::create(['comments_count' => 2]);
$this->assertEquals(1, Post::count());
$this->assertEquals(6, Post::first()->comments_count);
}
/**
* Количество сообщений в форума
* @return integer сообщений в форуме
*/
function forumCount()
{
return Topic::count() . '/' . Post::count();
}
function held_post_count()
{
// version = Cache.get("$cache_version").to_i
// key = "held-post-count/v=#{version}/u=#{self.id}"
// return Cache.get(key) {
// Post.count(:conditions => ["user_id = ? AND is_held AND status <> 'deleted'", self.id])
// }.to_i
$count = Post::count(array('conditions' => array("user_id = ? AND is_held AND status <> 'deleted'", $this->id)));
return $count;
}
/**
* Post page
*/
public function news(Request $request, $matches)
{
$filter = ['conditions' => ['moderate = ?', 0]];
// Rows count
$rows = \Post::count($filter);
// Paginator
/** @var Listing $pagination */
$pagination = NCService::load('Paginator.Listing', [$request->page, $rows]);
// Limitation
$filter = array_merge($filter, $pagination->limit());
// Ordering
if ($request->order) {
$filter['order'] = $request->order;
} else {
$filter['order'] = 'created_at DESC';
}
// Get posts
$posts = \Post::all($filter);
// Rendering
return $this->view->render('posts/list.twig', ['title' => $this->lang->translate('post.title'), 'posts' => array_map(function ($i) {
return $i->to_array();
}, $posts), 'listing' => $pagination->pages(), 'page' => $request->page]);
}
<td><strong>Posts</strong></td>
<td><a href="/post?tags=user%3A<?php
echo $user->name;
?>
"><?php
echo Post::count(array('conditions' => array("user_id = ?", $user->id)));
?>
</a></td>
</tr>
<tr>
<td><strong>Deleted Posts</strong></td>
<td><a href="/post/deleted_index?user_id=<?php
echo $user->id;
?>
"><?php
echo Post::count(array('conditions' => array("status = 'deleted' AND user_id = ?", $user->id)));
?>
</a></td>
</tr>
<tr>
<th>Votes</th>
<td>
<span class="stars">
<?php
foreach (range(1, 3) as $i) {
?>
<a class="star star-<?php
echo $i;
?>
" href="<?php
echo url_for('post#index', array('tags' => "vote:>={$i}:{$user->name} order:vote"));
<?php
require_once __DIR__ . '/Model.php';
require_once __DIR__ . '/Connect.php';
require_once __DIR__ . '/Post.php';
require_once __DIR__ . '/User.php';
$database = ['dsn' => 'mysql:host=localhost;dbname=ecole_multimedia', 'password' => 'root', 'username' => 'antoine'];
$connect = new Connect($database);
/* ------------------------------------------------- *\
Name of Model $postModel or $userModel ...
\* ------------------------------------------------- */
$postModel = new Post($connect->getDB());
var_dump($postModel->count());
$posts = $postModel->select(['title', 'status', 'content'])->where('id', '>', 1)->where('status', '=', 'published')->get();
foreach ($posts as $post) {
echo "<h1>{$post->title}</h1>";
}
/* ------------------------------------------------- *\
Count method
\* ------------------------------------------------- */
var_dump($postModel->count());
var_dump($postModel->where('id', '>', 1)->count());
/* ------------------------------------------------- *\
Method all
\* ------------------------------------------------- */
var_dump($postModel->all());
$posts = $postModel->all();
foreach ($posts as $post) {
echo "<h1>{$post->title}...</h1>";
}
/* ------------------------------------------------- *\
public function testClear()
{
Post::clear();
$this->assertFalse(!!Post::count());
}
function check_pending_count()
{
if (!CONFIG::max_pending_images) {
return;
}
if ($this->status != "pending") {
return;
}
if ($this->user->level >= 33) {
return;
}
$pending_posts = Post::count(array('conditions' => array("user_id = ? AND status = 'pending'", $this->user_id)));
if ($pending_posts < CONFIG::max_pending_images) {
return;
}
$this->record_errors->add_to_base("You have too many posts pending moderation");
return false;
}
$protected->get('/settings', function (Request $request) use($app) {
$account = Account::findOne(array('_id' => new MongoId($app['account']['id'])));
unset($account->users);
return $app->json($account->toArray());
});
$protected->post('/settings', function (Request $request) use($app) {
$email = $app['data']['email'];
$m = new Mongo();
if ($email) {
$m->circular->accounts->update(array('_id' => new MongoId($app['account']['id'])), array('$set' => array('email' => $email)));
} else {
$m->circular->accounts->update(array('_id' => new MongoId($app['account']['id'])), array('$unset' => array('email' => true)));
}
});
/***
*
* The `/counter` public endpoint returns the number of scheduled posts queued right now.
*
*/
$public->get('/counter', function (Request $request) use($app) {
$count = Post::count();
return $app->json(array('count' => $count));
});
/***
*
* Run, App, Run!
*
*/
$app->mount('/', $public);
$app->mount('/', $protected);
$app->run();
require_once mnminclude . 'geo.php';
if ($current_user->user_id > 0 && ($latlng = geo_latlng('user', $current_user->user_id))) {
geo_init('onLoad', $latlng, 5);
} else {
geo_init('onLoad', false, 2);
}
break;
case '':
case '_all':
$tab_option = 1;
//$sql = "SELECT SQL_CACHE post_id FROM posts ORDER BY post_id desc limit $offset,$page_size";
$where = "post_id > 0";
$order_by = "ORDER BY post_id desc";
$limit = "LIMIT {$offset},{$page_size}";
//$rows = $db->get_var("SELECT count(*) FROM posts");
$rows = Post::count();
$min_date = date("Y-m-d 00:00:00", time() - 86400 * 10);
//$rows = $db->get_var("SELECT SQL_CACHE count(*) FROM posts where post_date > '$min_date'");
$rss_option = "sneakme_rss2.php";
break;
default:
$tab_option = 4;
if (is_numeric($argv[0]) && ($post_id = intval($argv[0])) > 0 || is_numeric($argv[1]) && ($post_id = intval($argv[1])) > 0) {
// Individual post
$user->id = $db->get_var("select post_user_id from posts where post_id={$post_id}");
if (!$user->read()) {
do_error(_('usuario no encontrado'), 404);
}
$globals['permalink'] = 'http://' . get_server_name() . post_get_base_url($post_id);
// Fill title
$summary = text_to_summary($db->get_var("SELECT post_content from posts where post_id = {$post_id}"), 250);
function admin_get_posts()
{
$token = $_SERVER['Authorization'];
extract($_GET);
$admin = __get_auth_admin($token);
$result = array();
if ($admin == NULL) {
$result['success'] = 'false';
$result['message'] = 'You are not authorized';
} else {
$total = Post::count();
$posts = Post::with('user')->whereNull('deleted_at');
if (!isset($per)) {
$per = 20;
}
if (isset($page)) {
$posts->skip(($page - 1) * $per);
}
$posts->take($per);
$result['success'] = 'true';
$result['posts'] = $posts->get();
$result['total'] = $total;
}
echo json_encode($result);
}
