static function getCountOfCreatedThreadsForUser($user) { $c = new Criteria(); $c->add(ThreadPeer::POSTER_ID, $user->getId()); return ThreadPeer::doCount($c); }
<div class="cat"> <div class="iconnew2"><img src="../images/forum-icon-new2.png" /></div> <div class="desc"> <h1><a href="#"><?php echo link_to($publicforum->getName(), 'forum/' . $publicforum->getID()); ?> </a></h1> <?php echo $publicforum->getDescription(); ?> </div> <?php $t = new Criteria(); $t->add(ThreadPeer::CATEGORY_ID, $publicforum->getID()); $t->add(ThreadPeer::CANCEL, 0); $forumcount = ThreadPeer::doCount($t); ?> <div class="threads"><?php echo $forumcount; ?> Topics<br /> <?php $p = new Criteria(); $p->addJoin(ThreadPeer::ID, PostPeer::THREAD_ID, Criteria::JOIN); $p->add(ThreadPeer::CATEGORY_ID, $publicforum->getID()); $p->add(ThreadPeer::CANCEL, 0); $postcount = PostPeer::doCount($p); ?> <?php echo $postcount - $forumcount; ?>