CMS Made Simple Forums

maksbud wrote: where is the data stored for the comments on a page?
if i add a comment to a page is there any way to connect to the data that stores the comments on that page and count the number of comments and ehco it to another page as a number such as Comments [ 12 ] ?
would this be a PHP or Tag?

global $gCms;

$db = &$gCms->db;

// Get number of comments
$q = "SELECT * FROM ".cms_db_prefix()."module_comments WHERE  page_id =".$params['thenewsid']." AND module_name='News' AND active='1'";
$dbresult = $db->Execute( $q );
if( !$dbresult ) 
{
    echo 'DB error: '. $db->ErrorMsg()."<br/>";
}
$num_rows = $dbresult->RecordCount();
echo $num_rows;

Number of comments: {count_news_comments thenewsid=$entry->id}

global $gCms;

$db = &$gCms->db;

// Get number of comments
$q = "SELECT * FROM ".cms_db_prefix()."module_comments WHERE  page_id =".$params['thenewsid'];
$dbresult = $db->Execute( $q );
if( !$dbresult ) 
{
    echo 'DB error: '. $db->ErrorMsg()."<br/>";
}
$num_rows = $dbresult->RecordCount();
echo $num_rows;

maksbud wrote: i still don't get it am i suposed to change this to something,,,

$params['thenewsid']

maksbud wrote: is that param the 'content_id='65'', this is what i get when i edit the page,,
  editcontent.php?content_id=65&page=1
i've put this in the 'content edit box'  {cms_module module="komments"} and it shows up like a normal comments with "add a comment" and the comments made,
i changed it to 'komments' because i messed with the original and had to add a new Module by changing everything in the PHP including the Folder name, i really like the "mess" i made to the original template and can't add another template hence the 'new' Module,,

and how would i make it show up in these [ ] as a number,
i've got a redirect to the page, bottom of content has Comments [ ]  link to page that doesn't show in menu,,  i just need to count the items on that page and echo it into those brackets  Comments [ 4 ]

  thanks for any help 
                                    mark

Comments: [ {count_news_comments thenewsid=65} ]

maksbud wrote: now i get,,
--Add Me - module:Blog string:Comments-- [DB error: Unknown column 'module_name' in 'where clause'

maksbud wrote: // Get number of comments
$q = "SELECT * FROM ".cms_db_prefix()."module_komments WHERE  page_id =".$params['theid']." AND module_name='Blog' AND active='1'";

// Get number of comments
$q = "SELECT * FROM ".cms_db_prefix()."module_comments WHERE  page_id =".$params['theid']." AND module_name='Blog' AND active='1'";

// Get number of comments
$q = "SELECT * FROM ".cms_db_prefix()."module_comments WHERE  page_id =".$params['theid']." AND module_name='News' AND active='1'";

maksbud wrote: --Add Me - module:Blog string:Comments-- 0
  it counts now, i've looked thru all the 'Blog' PHP and i can't find anywhere else to --Add Me-- ,

$lang['Comments'] = 'Comments';

maksbud wrote: but i can clik Comments and get taken to another page where it says add comment, but when i clik 'Add a Comment' it returns me to the original page, unable to add comment, still messing with the templates, about time i learn PHP.