Comment Plugin - error in displaying user name

Hi Meg

Here's your problem - this is the list function that's getting the comments:

list($_wsc_commentsRecords, $_wsc_commentsMetaData) = getRecords(array(
'tableName' => '_wsc_comments',
'loadUploads' => true,
'allowSearch' => false,
));

There's no 'where' clause in the list that filters what comments to get, so it's just pulling them all. You'll need to add something in there to get the right comments for the page. Do you know how to do that?

Yeah, that's the idea, but I don't think it'll work in your case unless you can put the article ID number into the URL.

How are you generating the individual article links right now?

This is the php for generating the article: 

list($questionsRecords, $questionsMetaData) = getRecords(array(
    'tableName'   => 'questions',
    'where'       => whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $detailRecord = @$questionsRecords[0]

In the view URL's, the detail page is /article.php and I'm using the field name "question" to generate the article name. So, for example, it would generate the URL: article.php?Question-About-Life-1

So, how exactly do I make the comments unique to an individual article page? I'm a little confused now...

Okay, here's how it should work:

You've got the actual article information in $detailRecord, right? This should include the article ID number. What you need to do is then give the article ID to the function that gets the comments, so it filters out all but the comments you want.

It'd look something like this:

list($_wsc_commentsRecords, $_wsc_commentsMetaData) = getRecords(array(
    'tableName'   => '_wsc_comments',
    'loadUploads' => true,
    'allowSearch' => false,
    'where'       => 'article_id = ' . $detailRecord['num'],
  ));

You'd want to replace 'article_id' and '$detailRecord['num']' with whatever you've named those variables in the Section editor.

Does this make sense?

So if the detail article page is this: 

list($questionsRecords, $questionsMetaData) = getRecords(array(
    'tableName'   => 'questions',
    'where'       => whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $detailRecord = @$questionsRecords[0]

the comments should be this?

list($_wsc_commentsRecords, $_wsc_commentsMetaData) = getRecords(array(
    'tableName'   => '_wsc_comments',
    'loadUploads' => true,
    'allowSearch' => false,
    'where'       => 'article_id = ' . $questionsRecords['num'],
  ));


I'm a little confused on what the article_id should be...

The article_id is whatever reference exists in the comment record for the article that it's supposed to go with, which I'm assuming is called something like article_id or articleNum.

Can you list the fields associated with the comment records? It's probably pretty obvious, or at least I hope it is.

Comment fields in the Section Editor:

comment

attachments

tableOrTag

recordNum

num

createdDate

createdByUserNum

Alright then, try this:

list($_wsc_commentsRecords, $_wsc_commentsMetaData) = getRecords(array(
    'tableName'   => '_wsc_comments',
    'loadUploads' => true,
    'allowSearch' => false,
    'where'       => 'recordNum = ' . $questionsRecords['num'],
  ));