• Imoq [15]
  
  

  • Rank: Helper
  • Registered: 29.09.04
  • last visit: 23.04.09
  • Posts: 119

  [16] Posted: 18.10.2005, 16:47

  I was wondering, is it very difficult to add the "most comented stories" in Top List if you use EZComments [17]?
  
  I haven't seen any implementation of it yet, but it is probably not that hard to accomplish...
  
  Anybody already has this?

  • [18]
  •   [19]
• markwest [21]
  
  

  • Rank: Moderator
  • Registered: 19.03.02
  • last visit: 27.06.09
  • Posts: 7661

  [22] Posted: 18.10.2005, 17:07

  The top list module is currently hard-coded to look at certain tables. So it would require adding a section of code to the module for EZComments [23]. I've not done it and, at the moment, have no time to look at this code..... But it shouldn't be *that* difficult....
  
  -Mark
  
  --
  Visit My homepage [24] and Zikula themes. [25]

  • [26]
  •   [27]
• Imoq [29]
  
  

  • Rank: Helper
  • Registered: 29.09.04
  • last visit: 23.04.09
  • Posts: 119

  [30] Posted: 18.10.2005, 17:50

  I see, in the modules/Top_List/index.php file I found:
  
  

  Code

  if (pnModAvailable('Comments')) {
          /**
           * Top 10 commented stories
           */
          $column = &$pntable['stories_column'];
          $myquery = "SELECT $column[sid], $column[title], $column[comments]
                                  FROM $pntable[stories] ".$queryalang."
                                  ORDER BY $column[comments] DESC";
          $result =& $dbconn->SelectLimit($myquery,$top);
  
          if (!$result->EOF) {
                  echo [31] '<h2>'.$top.' '._COMMENTEDSTORIES.'</h2>'."\n";
                  $lugar=1;
                  while(list [32]($sid, $title, $comments) = $result->fields) {
                          if($comments>0) {
                                  if (empty [33]($title)) {
                                     $title = '- '._NOTITLE.' -';
                                  }
                                  echo [34] "&nbsp;$lugar: <a href=\"index.php?name=News&amp;file=article&amp;sid=$sid\">" . pnVarPrepForDisplay(pnVarCensor($title)) . "</a> - (".pnVarPrepForDisplay($comments)." "._COMMENTS.")<br />\n";
                                  $lugar++;
                          }
                          $result->MoveNext();
                  }
                  echo [35] '<br />'."\n";
          }
          $result->Close();
  }

  
  
  I guess it's just a matter to adjust for EZComments [36] fields. Mmmm :D

  • [37]
  •   [38]
• Imoq [40]
  
  

  • Rank: Helper
  • Registered: 29.09.04
  • last visit: 23.04.09
  • Posts: 119

  [41] Posted: 19.10.2005, 00:15

  This is my first try; of course, it does not work (Don't even try!) But I hope I can find the errors and fix it:
  
  

  Code

  if (pnModAvailable('EZComments')) {
  
           // Top 10 commented stories from EZComments
  
          $column = &$pntable['stories_column'];
          $column1 = &$pntable['ezcomments_column'];
          $total = 0;
          $myquery = "SELECT $column[sid], $column[title], count($column1[objectid]) AS $total
                                  FROM $pntable[stories] ".$queryalang."
                                  LEFT JOIN $pntable[ezcomments] ON $column[sid] = $column1[objectid]
                                  GROUP BY $column1[objectid]
                                  ORDER BY $total DESC";
          $result =& $dbconn->SelectLimit($myquery,$top);
  
          if (!$result->EOF) {
                  echo [42] '<h2>'.$top.' '._COMMENTEDSTORIES.'</h2>'."\n";
                  $lugar=1;
                  while(list [43]($sid, $title, $total) = $result->fields) {
                          if($total>0) {
                                  if (empty [44]($title)) {
                                     $title = '- '._NOTITLE.' -';
                                  }
                                  echo [45] "&nbsp;$lugar: <a href=\"index.php?name=News&amp;file=article&amp;sid=$sid\">" . pnVarPrepForDisplay(pnVarCensor($title)) . "</a> - (".pnVarPrepForDisplay($total)." "._COMMENTS.")<br />\n";
                                  $lugar++;
                          }
                          $result->MoveNext();
                  }
                  echo [46] '<br />'."\n";
          }
          $result->Close();
  }

  
  
  If anybody has suggestions, they will be greatly appreciated, since my knowledge of PostNuke is really low :(

  • [47]
  •   [48]
• jmvedrine [50]
  
  

  • Rank: Professional
  • Registered: 13.01.04
  • last visit: 02.07.09
  • Posts: 637

  [51] Posted: 19.10.2005, 07:22

  first thing evident reading your code is that you need to add:
  

  Code

  pnModDBInfoLoad('EZComments');

  
  But this line should be before calling pnDBGetTables(); or it will not works.
  Also in your SQL query you should test no only that that $column[sid] = $column1[objectid] but also that the ezcomment item is for the News module.
  maybe there are other problems, you will need some testing.
  
  --
  Visit my live reef aquarium [52].
  
  My Amazon wish list [53].

  • [54]
  •   [55]
•  
•  

Users online

• Simon [58],
• Teb [59],
• craigh [60],
• espaan [61],
• rgasch [62],
• shyra [63]

This list is based on the users active over the last 60 minutes.