Статистика в Downloads 4.2.5 - Дизайн и модификация Invision Power Board

Сообщение изменено: Zero108 (04 Ноябрь 2017 - 22:39)

SUM(file_reviews) AS totalReviews

SUM(file_downloads) AS totalReviews

Сообщение изменено: Zero108 (06 Ноябрь 2017 - 22:40)

Zero108 сказал(а):

SUM(entry_views) AS totalViews

Zero108 сказал(а):

Zero108 сказал(а):

Zero108 сказал(а):

		$stats = array();
		
		$stats['total_blogs']	= \IPS\Db::i()->select( "COUNT(*)", 'blog_blogs' )->first();
		$stats['total_entries']	= \IPS\Db::i()->select( "COUNT(*)", 'blog_entries', array( 'entry_status=? AND entry_hidden=?', 'published', 1 ) )->first();

		$stats = array_merge(
			\IPS\Db::i()->select( "COUNT(*) as total_blogs, SUM(blog_num_views) AS total_blogs_views", 'blog_blogs' )->first(),
			\IPS\Db::i()->select( "COUNT(*) as total_entries, SUM(entry_views) AS total_entries_views", 'blog_entries', array( 'entry_status=? AND entry_hidden=?', 'published', 1 ) )->first()
		);

Zero108 сказал(а):