EZComments in Top List :: Zikula Community :: Support at your fingertips

Start [1]
Search [2]
latest posts [3]
RSS [4]
Login [5]
Register [6]

[10]
Print topic [11]
[12]

Start [13] ::
Extensions and Distributions Support [14] ::
Modules [15] ::
EZComments in Top List

Moderated by:
Support [16]

[17]

EZComments in Top List

[18]Posted: 18.10.2005, 21:47

[19]

rank:

Helper

registered:

September 2004

Status:

offline

last visit:

10.10.08

Posts:

111

I was wondering, is it very difficult to add the "most comented stories" in Top List if you use EZComments [20]?

I haven't seen any implementation of it yet, but it is probably not that hard to accomplish...

Anybody already has this?
[21]
- notify mod [22]
[24]Posted: 18.10.2005, 22:07

[25]

rank:

Moderator

registered:

March 2002

Status:

offline

last visit:

26.08.08

Posts:

7720

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 [26]. 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
[27]
- notify mod [28]
[30]Posted: 18.10.2005, 22:50

[31]

rank:

Helper

registered:

September 2004

Status:

offline

last visit:

10.10.08

Posts:

111

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 [32] '<h2>'.$top.' '._COMMENTEDSTORIES.'</h2>'."\n";
$lugar=1;
while(list [33]($sid, $title, $comments) = $result->fields) {
if($comments>0) {
if (empty [34]($title)) {
$title = '- '._NOTITLE.' -';
}
echo [35] " $lugar: <a href=\"index.php?name=News&file=article&sid=$sid\">" . pnVarPrepForDisplay(pnVarCensor($title)) . "</a> - (".pnVarPrepForDisplay($comments)." "._COMMENTS.")<br />\n";
$lugar++;
}
$result->MoveNext();
}
echo [36] '<br />'."\n";
}
$result->Close();
}

I guess it's just a matter to adjust for EZComments [37] fields. Mmmm :D
[38]
- notify mod [39]
[41]Posted: 19.10.2005, 05:15

[42]

rank:

Helper

registered:

September 2004

Status:

offline

last visit:

10.10.08

Posts:

111

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 [43] '<h2>'.$top.' '._COMMENTEDSTORIES.'</h2>'."\n";
$lugar=1;
while(list [44]($sid, $title, $total) = $result->fields) {
if($total>0) {
if (empty [45]($title)) {
$title = '- '._NOTITLE.' -';
}
echo [46] " $lugar: <a href=\"index.php?name=News&file=article&sid=$sid\">" . pnVarPrepForDisplay(pnVarCensor($title)) . "</a> - (".pnVarPrepForDisplay($total)." "._COMMENTS.")<br />\n";
$lugar++;
}
$result->MoveNext();
}
echo [47] '<br />'."\n";
}
$result->Close();
}

If anybody has suggestions, they will be greatly appreciated, since my knowledge of PostNuke is really low :(
[48]
- notify mod [49]
[51]Posted: 19.10.2005, 12:22

[52]

rank:

Professional

registered:

January 2004

Status:

offline

last visit:

05.09.08

Posts:

633

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 [53].

My Amazon wish list [54].
[55]
- notify mod [56]

Users online:

AllKnightAccess [58],
AmmoDump [59],
Petzi-Juist [60],
Topiatic [61],
Wendell [62],
jaenosjelantru [63],
myths [64],
nestormateo [65]

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

Code

Code

Code