I saw somewhere how to find out the number of pages on the website

replytomk3 · **Posted:** Tue Dec 14, 2010 5:37 am

I remember a discussion somewhere on how to find out the number of pages by counting database entries in _content. Can someone help?

calguy1000 · **Posted:** Tue Dec 14, 2010 5:38 am

SELECT count(id) FROM _content

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

calguy1000 wrote:

SELECT count(id) FROM _content

SELECT count(content_id) FROM _content

replytomk3 · **Posted:** Tue Dec 14, 2010 6:10 am

Why does this produce a blank result if ran from the backend as a UDT?

Code:

   global $gCms;
   $db = $gCms->db;
      
   $query = "SELECT count(content_id) FROM ".cms_db_prefix()."content";
   $dbresult = $db->Execute($query);

   return $dbresult;

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

Replace your last line with:

Code:

$row = $dbresult->FetchRow();
return($row['count(content_id)']);

I got 33

replytomk3 · **Posted:** Tue Dec 14, 2010 11:12 pm

370

replytomk3 · **Posted:** Tue Dec 14, 2010 11:16 pm

OK, I would like to release this code for the benefit of others.

1) What should I add to show only pages that are active?

2) For you experts, what would the code be to return a list of pages with empty (missing) metadata content in the database, or if it contains the default "<-add code here to appear in all pages->".

I have already released something based on "last modified pages": http://dev.cmsmadesimple.org/projects/lastcreatedpage. These features should help those who have not specified metadata when they should have.

replytomk3 · **Posted:** Tue Dec 14, 2010 11:17 pm

For the benefit of others, the code that you can run as a UDT to find out the number of pages you have (including hidden and inactive) is:

Code:

   global $gCms;
   $db = $gCms->db;
      
   $query = "SELECT count(content_id) FROM ".cms_db_prefix()."content";
   $dbresult = $db->Execute($query);

   $row = $dbresult->FetchRow();
        return($row['count(content_id)']);

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

replytomk3 wrote:

1) What should I add to show only pages that are active?

Code:

$query = "SELECT count(content_id) FROM ".cms_db_prefix()."content WHERE active=1";

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

replytomk3 wrote:

2) For you experts, what would the code be to return a list of pages with empty (missing) metadata content in the database, or if it contains the default "<-add code here to appear in all pages->".

Code:

global $gCms;
$db = $gCms->db;
      
$query = "SELECT content_name FROM ".cms_db_prefix()."content WHERE metadata='' OR metadata LIKE '%Add code here%'";
$dbresult = $db->Execute($query);

while ($dbresult && $row = $dbresult->FetchRow()) {
  echo("<p>$row['content_name']<p>\n");
}

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

We might even make it simpler by using a call or two from the ContentOperations class.

http://www.cmsmadesimple.org/apidoc/CMS ... tions.html

I'll look at it tonight when I have a bit more time.

Wishbone · **Joined:** Tue Dec 23, 2008 8:39 pm **Posts:** 1320

Here's a UDT (named 'page_info'), using API calls to get the same info, all at once.

Code:

global $gCms;
$cntnt = $gCms->getContentOperations();

$results['page_count'] = 0;

foreach ($cntnt->GetAllContent() as $page) {
  if ($page->mActive) {
    $results['page_count']++;
  }

  if (!$page->mMetadata || preg_match('/Add code here/', $page->mMetadata)) {
    $results['no_metadata'] .= $page->mName . ' ';
  }
}

$smarty->assign($params['assign'], $results);

Here's how to use it in your template or page:

Code:

{page_info assign='info'}
<p>Number of active pages: {$info.page_count}</p>
{if $info.no_metadata}
<p>The following pages are missing metadata: {$info.no_metadata}</p>
{else}
<p>All pages have metadata</p>
{/if}

replytomk3 · **Posted:** Wed Dec 15, 2010 3:24 am

I'm waiting approval on two modules for the Forge. I'll post the code there as a plugin.

replytomk3 · **Posted:** Fri Dec 17, 2010 2:11 am

You are doing all the work.

I have modified it to be on separate lines, and to not show inactive pages (those for me are pages in progress, I don't know about others. Anyways, if you cannot navigate to them, I don't care about metadata for those pages).

Code:

global $gCms;
$cntnt = $gCms->getContentOperations();

$results['page_count'] = 0;

foreach ($cntnt->GetAllContent() as $page) {
  if ($page->mActive) {
    $results['page_count']++;
  }

  if (($page->mActive && !$page->mMetadata) || preg_match('/Add code here/', $page->mMetadata)) {
    $results['no_metadata'] .=  ' <p>' . $page->mName;
  }
}

$smarty->assign($params['assign'], $results);

replytomk3 · **Posted:** Fri Dec 17, 2010 2:12 am

How do I also ignore pages that are links?

I saw somewhere how to find out the number of pages on the website [SOLVED]

Who is online