public static function getPopularCodes($max = 10) { $c = new Criteria(); $c->add(SnippetPeer::DRAFT, false); $c->addDescendingOrderByColumn(SnippetPeer::AVERAGE_RATING); $c->setLimit($max); return SnippetPeer::doSelect($c); }
public static function generate() { $c = new Criteria(); $c->add(SnippetPeer::DRAFT, false); $snippets = SnippetPeer::doSelect($c); $urls = array(); foreach ($snippets as $snippet) { $urls[] = new sitemapURL("snippet/show?id=" . $snippet->getFriendlyUrl(), date('Y-m-d\\TH:i:s\\Z', strtotime($snippet->getUpdatedAt())), 'weekly', 1.0); } return $urls; }
<?php define('SF_ROOT_DIR', realpath(dirname(__FILE__) . '/..')); define('SF_APP', 'frontend'); define('SF_ENVIRONMENT', 'dev'); define('SF_DEBUG', true); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; // initialize database manager $databaseManager = new sfDatabaseManager(); $databaseManager->initialize(); $snippets = SnippetPeer::doSelect(new Criteria()); foreach ($snippets as $snippet) { echo "Saving snippet#" . $snippet->getId() . ":" . $snippet->getTitle() . "\n"; $snippet->save(); echo " Stripped title: " . $snippet->getFriendlyUrl() . "\n"; }