Xaraya / Postnuke CVS Notices - Message

Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites

Directory filter : [ all ] / postnuke_modules / articles [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
28 Jul 2002 23:16:10	postnuke_modules/articles	pnuserapi.php,1.20,1.21	Mike
	getall fix : get articles without categories too

Update of /home/cvsroot/postnuke_modules/articles
In directory ns7.hostnuke.net:/tmp/cvs-serv4488

Modified Files:
	pnuserapi.php 
Log Message:
getall fix : get articles without categories too


Index: pnuserapi.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/articles/pnuserapi.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** pnuserapi.php	28 Jul 2002 18:26:44 -0000	1.20
--- pnuserapi.php	28 Jul 2002 23:16:08 -0000	1.21
***************
*** 120,126 ****
                        .join (',', $cids)
                        .')';
      }
      $conditions[] = $articlescolumn['authorid'].' = '.$userscolumn['uid'];
-     $conditions[] = $categorieslinkagecolumn['modid'].' = '.pnModGetIDFromName('articles');
      if (!empty($ptid)) {
          $conditions[] = $articlescolumn['pubtypeid'].' = '.$ptid;
--- 120,126 ----
                        .join (',', $cids)
                        .')';
+         $conditions[] = $categorieslinkagecolumn['modid'].' = '.pnModGetIDFromName('articles');
      }
      $conditions[] = $articlescolumn['authorid'].' = '.$userscolumn['uid'];
      if (!empty($ptid)) {
          $conditions[] = $articlescolumn['pubtypeid'].' = '.$ptid;
***************
*** 164,173 ****
      $sql .= IterateSQL ('SELECT DISTINCT', $columns, ',');
      $sql .= IterateSQL (' FROM', $tables, ',');
!     $sql .= IterateSQL (' LEFT JOIN', $join, ',');
!     $sql .= IterateSQL (' ON', $on, ' AND ');
  
      $sql .= IterateSQL (' WHERE', $conditions, ' AND '); 
  
      $sql .= IterateSQL (' ORDER BY', $orderings, ',');
      $result = $dbconn->SelectLimit($sql, $numitems, $startnum-1);
  
--- 164,176 ----
      $sql .= IterateSQL ('SELECT DISTINCT', $columns, ',');
      $sql .= IterateSQL (' FROM', $tables, ',');
!     if (is_array($cids)) {
!         $sql .= IterateSQL (' LEFT JOIN', $join, ',');
!         $sql .= IterateSQL (' ON', $on, ' AND ');
!     }
  
      $sql .= IterateSQL (' WHERE', $conditions, ' AND '); 
  
      $sql .= IterateSQL (' ORDER BY', $orderings, ',');
+ error_log($sql);
      $result = $dbconn->SelectLimit($sql, $numitems, $startnum-1);
  
***************
*** 220,224 ****
      // Inserting the corresponding Category ID in the Article Description
      foreach ($articles as $key => $article) {
!         $articles[$key]['cids'] = $cids[$article['aid']];
      }
  
--- 223,229 ----
      // Inserting the corresponding Category ID in the Article Description
      foreach ($articles as $key => $article) {
!         if (isset($cids[$article['aid']])) {
!             $articles[$key]['cids'] = $cids[$article['aid']];
!         }
      }
  

View Statistics - Next Notice - Previous Notice