public function executeViewProfile()
 {
     $username = $this->getRequestParameter('username');
     $this->user = sfGuardUserPeer::retrieveByUsername($username);
     $c = new Criteria();
     $c->add(SnippetPeer::USER_ID, $this->user->getId());
     $c->add(SnippetPeer::DRAFT, false);
     $this->snippet_count = SnippetPeer::doCount($c);
     $this->pager = new sfPropelPager('Snippet', sfConfig::get('app_pager', 10));
     $this->pager->setCriteria($c);
     $this->pager->setPage($this->getRequestParameter('page', 1));
     $this->pager->init();
 }
 public static function countUserSnippets($user_id)
 {
     $c = new Criteria();
     $c->add(SnippetPeer::USER_ID, $user_id);
     return SnippetPeer::doCount($c);
 }