From: <sy...@us...> - 2006-07-28 20:30:39
|
Update of /cvsroot/tikiwiki/tiki/lib/categories In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv30992/lib/categories Modified Files: Tag: BRANCH-1-9 categlib.php Log Message: add a param categId=1 to the articles plugins Index: categlib.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/categories/categlib.php,v retrieving revision 1.48.2.44 retrieving revision 1.48.2.45 diff -u -d -r1.48.2.44 -r1.48.2.45 --- categlib.php 19 Jul 2006 00:43:20 -0000 1.48.2.44 +++ categlib.php 27 Jul 2006 15:25:14 -0000 1.48.2.45 @@ -1069,7 +1069,19 @@ $query = "update `tiki_categorized_objects` set `type`= ?, `objId`= ?, `href`=? where `objId` = ?"; $this->query($query, array('article', (int)$articleId, "tiki-read_article.php?articleId=$articleId", (int)$subId)); } - + /* build the portion of list join if filter by category + */ + function getSqlJoin($categId, $objType, $sqlObj, &$fromSql, &$whereSql, &$bindVars) { + $fromSql .= ",`tiki_categorized_objects` co, `tiki_category_objects` cat "; + $whereSql .= " AND co.`type`=? AND co.`objId`= $sqlObj "; + $whereSql .= " AND co.`catObjectId`=cat.`catObjectId` "; + $whereSql .= " AND cat.`categId`= ? "; + $bind = array( $objType, $categId); + if (is_array($bindVars)) + $bindVars = array_merge($bindVars, $bind); + else + $bindVars = $bind; + } } |