public function overview_action()
{
if ($GLOBALS['perm']->have_perm("user")) {
if ($this->last_pluginmarket_visit !== time()) {
$this->new_plugins = MarketPlugin::findBySql("publiclyvisible = 1 AND approved = 1 AND published > ? ORDER BY mkdate DESC", array($this->last_pluginmarket_visit));
}
}
$this->plugins = MarketPlugin::findBySQL("publiclyvisible = 1 AND approved = 1 ORDER BY RAND() LIMIT 3");
$this->latest_plugins = MarketPlugin::findBySQL("publiclyvisible = 1 AND approved = 1 ORDER BY mkdate DESC LIMIT 5");
$best = DBManager::get()->prepare("\n SELECT pluginmarket_plugins.*\n FROM pluginmarket_plugins\n LEFT JOIN pluginmarket_reviews ON (pluginmarket_plugins.plugin_id = pluginmarket_reviews.plugin_id)\n WHERE publiclyvisible = 1\n AND approved = 1\n GROUP BY pluginmarket_plugins.plugin_id\n ORDER BY pluginmarket_plugins.rating DESC, MAX(pluginmarket_reviews.chdate) DESC\n LIMIT 6\n ");
$best->execute();
$this->best_plugins = array();
foreach ($best->fetchAll(PDO::FETCH_ASSOC) as $data) {
$this->best_plugins[] = MarketPlugin::buildExisting($data);
}
$this->render_action('overview_' . $_SESSION['pluginmarket']['view']);
}
