All the best,
Jeremy

https://www.openbugbounty.org/reports/2613835/

It looks like they are inserting script tags in the URL. Perhaps there's a way to disallow this via the .htaccess file?

Any input is appreciated. :-)

Thanks in advance,
Jeremy

Thanks to that thread, I managed to get things working. Yay!  I'll go ahead and put what I did below, just in case it helps anyone (or in case I need to refer to it again in the future).  :-)

Basically, I just created a multi-value pillbox called "members" in my "user_categories" section (which I may rename now) and pulled in "fullname" (for option labels) and "num" (for option values) from the user "accounts" section.

Then, in my viewer, I used the following "where" clause:

'where' => mysql_escapef(" members LIKE ? ", "%\t".$CURRENT_USER['num']."\t%" ),

Worked like a charm!  :-)

- Jeremy

I'm working on a site for a church who wants a member page that will display content specific to the department(s) that member belongs to.  So, for instance, if the member works in the Children's Ministry, their member page will show only content designated for those working in the Children's Ministry. However, if a member works in both the Children's Ministry and the Music Ministry, they will see content designated for both the Children's and Music Ministries on their member page.

I am using the membership plugin to allow members to signup and manage their accounts. That is all working beautifully. What I am stuck on is how to display content specific to each member.

In CMSB, I have all members listed in the "User Accounts" section. Then, I have a multi-section called "User Categories". This section a display "title" and "database_name" along with associated content for each respective ministry/department. In the User Accounts section, I created a multi-value checkbox list called "user_category". Here, admins can assign the member to a category (i.e. ministry department) by checking the box or boxes corresponding to the content that member should be able to view (ex: checking the "Children's Ministry" box allows that member to view "Children's Ministry" content).

Right now, using the traditional "foreach" loop, every member sees the content for every department.  I just need to know how to limit the content displayed on the page to only what that member is allowed to see based on their department designation in User Accounts.

I'm assuming a "where" clause would handle this, but everything I've tried so far hasn't worked. I'd really appreciate any insight.  :-)

Thanks in advance,
Jeremy

I was wondering if anyone ever resolved this?  I am having the exact same issue with this plugin.  I'm receiving the same error described and also noticed the extra single quote.  I removed the extra single quote, but am still getting the error:

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM pccvisal_accounts WHERE num = '10' at line 1
 - in gl_emailNewAccountActivated.php on line 51 by mysql_query_fetch_all_assoc()

We could really use this feature, but cannot figure out how to overcome this error.  (Oh, and I tried contacting the plugin author, but unfortunately, he is nowhere to be found.)  Thanks, in advance, for any insight anyone can provide.  :-)

- Jeremy

Thanks for the great advice!  I'm feeling just crazy enough to give it a shot!  :-)  I'll report back if I come up with a working example.

Thanks again!  I really appreciate it!
- Jeremy

I was wondering if anyone has played around with creating an iCal feed from CMSB.  I have a client who has an app for their church that they use to input event information.  However, they would have to duplicate efforts to get it up on their website because the app developer (Subsplash) does not allow access to their data.  They can, though, read iCal feeds from calendar systems that output it (like Google and iCloud).  So, I was considering the option of simply exporting an iCal feed with the necessary info supplied from CMSB (similar to how I've generated RSS feeds from CMSB in the past).

The only downside is that we won't be able to define a primary image for each event (as they do in the app and as I would do on the website) since iCal feeds aren't meant to handle this.  Some people have developed workarounds, but you have to have control of both the sending and receiving systems so the receiving app (in this case) will understand what it's supposed to do with the image URL it's being fed.  Since the app developer isn't interested in getting involved with that aspect of things, my client would still have to go in and upload images for both the app and the website separately.  (But, at least some of the duplication was eliminated.)

Anyway, before I go any further down this road (if I even do so at all), I thought I'd ask if anyone had messed around with iCal feeds generated from CMSB before?  :-)

Best,
Jeremy

Thanks Daryl!

- Jeremy

I'm actually much happier with this approach.  I'm not sure why I didn't think of it to begin with.  :-)  

So, everything is working perfectly now.  You can see it here: http://www.dwellingproductions.com/clients/cvrs/faq.php

Thanks IT for this great forum!

Thanks for your reply!  Unfortunately, I'm getting an error with this line:

<?php foreach ($records => $record): ?>

The error I'm receiving is: "syntax error, unexpected T_DOUBLE_ARROW"

I tried several things to fix it, but can't seem to get anywhere.  I've uploaded the PHP page I'm working with, in case you want to take a look.  Also, I've prepared a scaled back page (faq-simple.php), with all my other code stripped out, for testing purposes.  This page is viewable online here: http://dwellingproductions.com/clients/cvrs/faq-simple.php

I've also posted some screenshots of my CMSB pages, to ensure that I'm referencing fields and editor content properly.

I appreciate any help.  :-)

- Jeremy

I am trying to do something similar to this post: http://www.interactivetools.com/forum/forum-posts.php?postNum=2217470#post2217470

Unfortunately, I can't seem to make this work and am reaching out for help to save my sanity.  :-)

Essentially, I am trying to arrange FAQ questions and answers underneath their respective category heading.  So, when working, it should appear like this.

Category 1

• Question 1
  Answer 1
• Question 3
  Answer 3

Category 2

• Question 2
  Answer 2
• Question 5
  Answer 5

Category 3

• Question 4
  Answer 4
• Question 6
  Answer 6

For this example, in CMSB, I have a multi editor where the client add questions (faq_questions) and they can select a category radio button which is supplied by a category multi-editor (faq_topics).

My full implementation will include toggles for each question, as seen here: http://dwellingproductions.com/clients/cvrs/faq.php

But, for now, I've pared down the code to try and get it working before I add the toggle code.  You can see my "progress" here: http://dwellingproductions.com/clients/cvrs/faq2.php  Right now, the topic headings display, but no questions and answers display.

The code I currently have is:

<?php $questionsByTopic = array_groupBy($faq_questionsRecords, 'topic', true); ?>

<?php foreach (getListOptions('faq_questions', 'topic') as $value => $label): ?>

  
  <h4><?php echo $label;?></h4>

  <?php $faq_questions['topic'] = @$questionsByTopic[$value]; ?>
  <?php if (!$faq_questions) { $faq_questions = array(); } ?>

  <?php foreach ($faq_questions as $record): ?>

    <p>
        <?php echo $record['question'] ?><br>
        <?php echo $record['answer'] ?><br><br>
    </p>

  <?php endforeach ?>

<?php endforeach ?>


It would also be nice if the category (topic) heading would not display if there were no questions associated with it (as shown in this post: http://www.interactivetools.com/forum/forum-posts.php?postNum=2217490#post2217490).  I left that code out for now because it wouldn't display anything when I added it.  :-)

In case they are needed, the field names I'm working with are:

For Categories: faq_topics: 'title'
For FAQ Items: faq_questions: 'question', 'answer', 'topic' (the list which pulls topic titles from the above 'faq_topics")

Hopefully that all makes sense.  Thanks, in advance, for any assistance!

- Jeremy

Thanks so much for taking a look at this.  I've uploaded the page you requested (index2.php).  All the code on the page is simply the copied code from the code generator from a "list" page with the options marked to show all uploads, with no limit on the number of records displayed.

If you have any questions, just let me know.  Thanks again!

- Jeremy

I am completely dumb-founded.  I've never had this problem before.  I sure hope someone might have some insight.  I'm at a total loss.

- Jeremy

Interestingly, even if I paste the sample code directly from the code generator into a fresh new php page, I get the same result: only the first record is displayed.  Here's an example: http://www.ihelpinc.net/amangifts/index2.php

This is absolutely baffling me, as I've never had this issue before.  I'm hoping someone has some insight, as this is a rather time-sensitive update that needs to be made.

Thanks, in advance, for any help.

- Jeremy

All the best,

Jeremy

P.S.  In case anyone refers to this later, I made some improvements to my version.  (Though Kevin's is much more concise and is definitely worth looking at.)  But, in my newer version, I fixed a few bugs and I added the ability to automatically remove "..." when appropriate.  The most important improvement was that I added the ability for pagination to work even when the list is being filtered by category, date, or tags (just ensure you change the field names as needed).  This makes it much more versatile.  Of course, if you're not using any of those filters, they are just ignored.  

Here is the updated code:

<?php
  $currentPage    = coalesce($sectionNameMetaData['page'], 1);
  $maxDisplayPage = min( ($currentPage + $maxPages - 1), $sectionNameMetaData['totalPages']);
  $totalPages     = $sectionNameMetaData['totalPages'];

// Find current URL
$currentPageURL = $_SERVER['REQUEST_URI'] ;

/* CATEGORY */
// Look for word "category" in URL
$currentCategory = strpos($currentPageURL, 'category');
// If "category" not in URL...
if ($currentCategory === false) {
// Do nothing
} else {
// If "category" is in URL, get current category number
$currentCategory = $_GET['category'];
}

/* ARCHIVE */
// Look for word "date_year" in URL
$currentArchive = strpos($currentPageURL, 'date_year');
// If "category" not in URL...
if ($currentArchive === false) {
// Do nothing
} else {
// If "category" is in URL, get current category number
$currentArchive = $_GET['date_year'];
}

/* TAGS */
// Look for word "tags_keyword" in URL
$currentTag = strpos($currentPageURL, 'tags_keyword');
// If "category" not in URL...
if ($currentTag === false) {
// Do nothing
} else {
// If "category" is in URL, get current category number
$currentTag = $_GET['tags_keyword'];
$currentTag = str_replace(' ', '+', $currentTag); // Replace any spaces in tags with + symbol for URLs
}

?>


<?php if ($totalPages <= $maxPages): //run this code if less total pages than maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
          <!-- PREV PAGE -->
    <li class="prev">
           <?php if ($sectionNameMetaData['prevPage']): ?>
              <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
          </li>
          
          <!-- PAGE NUMBERS -->
<?php foreach(range('1',$sectionNameMetaData['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $sectionNameMetaData['page']): ?>class="current"<?php endif; ?>>
              <a href="
<?php // pageNumber code
                  if (strpos($currentPageURL, 'category')) {
                    echo $pageLink."?category=".$currentCategory."&page=".$pageNumber;
                } elseif (strpos($currentPageURL, 'date_year')) {
                    echo $pageLink."?date_year=".$currentArchive."&page=".$pageNumber;
                } elseif (strpos($currentPageURL, 'tags_keyword')) {
                    echo $pageLink."?tags_keyword=".$currentTag."&page=".$pageNumber;
                } else {
                    echo $pageLink."?page=".$pageNumber;
        } 
                ?>
              "><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
          
          <!-- NEXT PAGE -->
    <li class="next">
           <?php if ($sectionNameMetaData['nextPage']): ?>
           <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div> <?php /* .pagination */ ?>
     <?php endif ?> 



<?php elseif ($currentPage >= ($totalPages - ($maxPages - 1))): //run this code if viewing one of last few pages as defined by maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
         <!-- PREV PAGE -->
    <li class="prev">
           <?php if ($sectionNameMetaData['prevPage']): ?>
              <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
            
            <!-- PAGE NUMBERS -->
<?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
              <li>
               <a href="
<?php // Page 1 code
                    if (strpos($currentPageURL, 'category')) {
                      echo $pageLink."?category=".$currentCategory."&page=1";
                  } elseif (strpos($currentPageURL, 'date_year')) {
                      echo $pageLink."?date_year=".$currentArchive."&page=1";
                  } elseif (strpos($currentPageURL, 'tags_keyword')) {
                      echo $pageLink."?tags_keyword=".$currentTag."&page=1";
                  } else {
                      echo $pageLink."?page=1";
          } 
                  ?>
               ">1</a>
            </li>
            <?php endif ?>
                          
            <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
             <?php if ($totalPages == ($maxPages + 1)): ?>
              <?php // Do nothing ?>
              <?php else: ?>
               <li><span>...</span></li>
              <?php endif ?>
            <?php endif ?>
            
          </li>
<?php foreach(range(($totalPages - ($maxPages - 1)),$sectionNameMetaData['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $sectionNameMetaData['page']): ?>class="current"<?php endif; ?>>
              <a href="
<?php // pageNumber code
                  if (strpos($currentPageURL, 'category')) {
                    echo $pageLink."?category=".$currentCategory."&page=".$pageNumber;
                } elseif (strpos($currentPageURL, 'date_year')) {
                    echo $pageLink."?date_year=".$currentArchive."&page=".$pageNumber;
                } elseif (strpos($currentPageURL, 'tags_keyword')) {
                    echo $pageLink."?tags_keyword=".$currentTag."&page=".$pageNumber;
                } else {
                    echo $pageLink."?page=".$pageNumber;
        } 
                ?>
     "><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
          
          <!-- NEXT PAGE -->
    <li class="next">
           <?php if ($sectionNameMetaData['nextPage']): ?>
           <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div> <?php /* .pagination */ ?>
     <?php endif ?> 



<?php else: //run this code if more total pages than $maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
     <div class="pagination">
       <ul>
<?php if ($sectionNameMetaData['prevPage']): ?>
        
        <!-- PREV PAGE -->
          <li class="prev">
            <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
          </li>
        <?php endif ?>
        
    <!-- PAGE NUMBERS -->   
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
      <li>
       <a href="
         <?php // Page 1 code
            if (strpos($currentPageURL, 'category')) {
              echo $pageLink."?category=".$currentCategory."&page=1";
          } elseif (strpos($currentPageURL, 'date_year')) {
              echo $pageLink."?date_year=".$currentArchive."&page=1";
          } elseif (strpos($currentPageURL, 'tags_keyword')) {
              echo $pageLink."?tags_keyword=".$currentTag."&page=1";
          } else {
              echo $pageLink."?page=1";
  } 
          ?>
        ">1</a>
      </li>
    <?php endif ?>
                  
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
     <?php if ($currentPage == "2"): ?>
       <?php // Do nothing ?>
      <?php else: ?>
       <li><span>...</span></li>
      <?php endif ?>
    <?php endif ?>
    
    
    <?php foreach (range($currentPage, $maxDisplayPage) as $page): ?>
      <?php if ($page == $currentPage): ?>
        <li class = "current">
      <?php else: ?>
        <li>
      <?php endif ?>
       <a href="
           <?php // $page code
              if (strpos($currentPageURL, 'category')) {
                echo $pageLink."?category=".$currentCategory."&page=".$page;
            } elseif (strpos($currentPageURL, 'date_year')) {
                echo $pageLink."?date_year=".$currentArchive."&page=".$page;
            } elseif (strpos($currentPageURL, 'tags_keyword')) {
                echo $pageLink."?tags_keyword=".$currentTag."&page=".$page;
            } else {
                echo $pageLink."?page=".$page;
    } 
            ?>
     "><?php echo $page; ?></a>
        </li>
    <?php endforeach ?>
    
    
    <?php if ($maxDisplayPage < $totalPages): //end with "..." ?>
     <?php if ($currentPage == ($totalPages - $maxPages)): ?>
       <?php // Do nothing ?>
<?php else: ?>
       <li><span>...</span></li>
        <?php endif ?>
<?php if ($currentPage < $totalPages): // show last page number ?>
        <li>
         <a href="
           <?php // Last page code
              if (strpos($currentPageURL, 'category')) {
                echo $pageLink."?category=".$currentCategory."&page=".$totalPages;
            } elseif (strpos($currentPageURL, 'date_year')) {
                echo $pageLink."?date_year=".$currentArchive."&page=".$totalPages;
            } elseif (strpos($currentPageURL, 'tags_keyword')) {
                echo $pageLink."?tags_keyword=".$currentTag."&page=".$totalPages;
            } else {
                echo $pageLink."?page=".$totalPages;
    } 
            ?>
          "><?php echo $totalPages; ?></a>
        </li>
      <?php endif ?>
      
      <?php if ($sectionNameMetaData['nextPage']): ?>
      
      <!-- NEXT PAGE -->
        <li class="next">
          <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
        </li>
      <?php endif ?>
    <?php endif ?>
    
       </ul>
       </div> <?php /* .pagination */ ?>
   <?php endif ?> 
  <?php endif ?>  


And, I also  prepped a version for use with a search results page:

<?php
  $currentPage    = coalesce($searchMeta['page'], 1);
  $maxDisplayPage = min( ($currentPage + $maxPages - 1), $searchMeta['totalPages']);
  $totalPages     = $searchMeta['totalPages'];
?>


<?php if ($totalPages <= $maxPages): //run this code if less total pages than maxPages ?>
 <?php if ($searchMeta['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
          <!-- PREV PAGE -->
    <li class="prev">
           <?php if ($searchMeta['prevPage']): ?>
              <a href="<?php echo $searchMeta['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
          </li>
          
          <!-- PAGE NUMBERS -->
<?php foreach(range('1',$searchMeta['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $searchMeta['page']): ?>class="current"<?php endif; ?>>
              <a href="
<?php // pageNumber code
                    echo $pageLink."&page=".$pageNumber;
                ?>
              "><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
          
          <!-- NEXT PAGE -->
    <li class="next">
           <?php if ($searchMeta['nextPage']): ?>
           <a href="<?php echo $searchMeta['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div> <?php /* .pagination */ ?>
     <?php endif ?> 



<?php elseif ($currentPage >= ($totalPages - ($maxPages - 1))): //run this code if viewing one of last few pages as defined by maxPages ?>
 <?php if ($searchMeta['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
         <!-- PREV PAGE -->
    <li class="prev">
           <?php if ($searchMeta['prevPage']): ?>
              <a href="<?php echo $searchMeta['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
            
            <!-- PAGE NUMBERS -->
<?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
              <li>
               <a href="
<?php // Page 1 code
                      echo $pageLink."&page=1";
                  ?>
               ">1</a>
            </li>
            <?php endif ?>
                          
            <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
             <?php if ($totalPages == ($maxPages + 1)): ?>
              <?php // Do nothing ?>
              <?php else: ?>
                <li><span>...</span></li>
              <?php endif ?>
            <?php endif ?>
            
          </li>
<?php foreach(range(($totalPages - ($maxPages - 1)),$searchMeta['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $searchMeta['page']): ?>class="current"<?php endif; ?>>
              <a href="
<?php // pageNumber code
                    echo $pageLink."&page=".$pageNumber;
                ?>
     "><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
          
          <!-- NEXT PAGE -->
    <li class="next">
           <?php if ($searchMeta['nextPage']): ?>
           <a href="<?php echo $searchMeta['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div> <?php /* .pagination */ ?>
     <?php endif ?> 



<?php else: //run this code if more total pages than $maxPages ?>
 <?php if ($searchMeta['totalPages'] > 1): ?>
     <div class="pagination">
       <ul>
<?php if ($searchMeta['prevPage']): ?>
        
        <!-- PREV PAGE -->
          <li class="prev">
            <a href="<?php echo $searchMeta['prevPageLink'] ?>">&#8592;</a>
          </li>
        <?php endif ?>
        
    <!-- PAGE NUMBERS -->   
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
      <li>
       <a href="
         <?php // Page 1 code
              echo $pageLink."&page=1";
          ?>
        ">1</a>
      </li>
    <?php endif ?>
                  
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
     <?php if ($currentPage == "2"): ?>
       <?php // Do nothing ?>
      <?php else: ?>
       <li><span>...</span></li>
      <?php endif ?>
    <?php endif ?>
    
    
    <?php foreach (range($currentPage, $maxDisplayPage) as $page): ?>
      <?php if ($page == $currentPage): ?>
        <li class = "current">
      <?php else: ?>
        <li>
      <?php endif ?>
       <a href="
           <?php // $page code
                echo $pageLink."&page=".$page;
            ?>
     "><?php echo $page; ?></a>
        </li>
    <?php endforeach ?>
    
    
    <?php if ($maxDisplayPage < $totalPages): //end with "..." ?>
     <?php if ($currentPage == ($totalPages - $maxPages)): ?>
       <?php // Do nothing ?>
<?php else: ?>
          <li><span>...</span></li>
        <?php endif ?>
<?php if ($currentPage < $totalPages): // show last page number ?>
        <li>
         <a href="
           <?php // Last page code
                echo $pageLink."&page=".$totalPages;
            ?>
          "><?php echo $totalPages; ?></a>
        </li>
      <?php endif ?>
      
      <?php if ($searchMeta['nextPage']): ?>
      
      <!-- NEXT PAGE -->
        <li class="next">
          <a href="<?php echo $searchMeta['nextPageLink'] ?>">&#8594;</a>
        </li>
      <?php endif ?>
    <?php endif ?>
    
       </ul>
       </div> <?php /* .pagination */ ?>
   <?php endif ?> 
  <?php endif ?>  


Well, I made some additional changes to the way this tag cloud works and I'm much happier with it now.  Before, it worked as a straight percentage, but this resulted in little to no larger font sizes.  This new version gives a better overview of tag usage and better distributes font sizes among the top-used tags.  A random display is made of only the designated number of the top-used tags.  Anyway, just thought I'd post my results with this new method in case anyone can use it in the future.  Enjoy!  :-)

(This code is based on having set up a CMS Builder multi-section called "blog_content" with a field called "tags".  You will have to edit the information in red if changing these section and field names.)

<?php
$tagsToCount = array();
$sectionsToField = array('blog_content' => 'tags'/*, 'blog2_content' => 'tags'*/); //use additional if joining tags from multiple sections


foreach($sectionsToField as $sectionName => $fieldName) {

//get section records
$records = mysql_select($sectionName);

foreach ($records as $record) {
//turn field into an array of values
$tags = explode(",", @$record[$fieldName]);


// add tags to the count array
foreach ($tags as $tag) {
$tag = trim($tag);
if (!$tag) { continue; } // skip empty array values

   if (array_key_exists($tag, $tagsToCount)) {
   $tagsToCount[$tag]++; }
   else {
   $tagsToCount[$tag] = 1; 
      }
  }
}
}

//PHP doesn't have a shuffle function built in that maintains keys, but this version does.
function shuffle_assoc($list) { 
  if (!is_array($list)) return $list; 

  $keys = array_keys($list); 
  shuffle($keys); 
  $random = array(); 
  foreach ($keys as $key) { 
    $random[$key] = $list[$key]; 
  }
  return $random; 
} 

 ?>


<?php /* DISPLAY TAGS */ ?>
<?php

 $tagsToCount = shuffle_assoc($tagsToCount); ?>
 <?php if ($tagsToCount): ?>
        <aside id="tags">
     <h3>Tags</h3>
         <?php  $maximumResults = 18;
$resultCount = 0;
 ?>
<?php $totalTagCount = array_sum($tagsToCount); ?>

<?php
$min_size = 10; //smallest font size
$max_size = 27; //largest font size
$minimum_count = min(array_values($tagsToCount));
$maximum_count = max(array_values($tagsToCount));
$spread = $maximum_count - $minimum_count;
if($spread == 0) {
$spread = 1;
}

    arsort($tagsToCount);
            $tagsToCount = array_slice($tagsToCount, 0, 17);
            $tagsToCount = shuffle_assoc($tagsToCount);
foreach ($tagsToCount as $key => $value): ?>
<?php           
$size = $min_size + ($value - $minimum_count) * ($max_size - $min_size) / $spread;

?>
<a style="font-size: <?php echo floor($size)?>px;" href="../blog_list.php?tags_keyword=<?php echo $key;?>" title='Articles: <?php echo $value; ?>'><?php echo $key; ?></a>
              <?php if (++$resultCount == $maximumResults) { break;}?>
  <?php endforeach ?>
        </aside>
 <?php endif ?>

- Jeremy

- Jeremy

Here's how it works:

     1 2 3 (Only 3 pages of articles, viewing any page 1-3 - the currently viewed list page will be highlighted)

     1 2 3 4 5 ... 16 (16 pages of articles, viewing page 1 of list results)

     1 ... 8 9 10 11 12 ... 16 (16 pages of articles, viewing page 8)

     1 ... 12 13 14 15 16 (16 pages of articles, viewing any page 12-16 - the currently viewed list page will be highlighted)

Here's the code:

Place in head section after loading viewer library (change information in red to match your CMSB configuration).  For some reason, I found it necessary to duplicate this information below also.

  // load records from 'blog_content'
  list($blog_contentRecords, $blog_contentMetaData) = getRecords(array(
    'tableName'   => 'blog_content',
    'perPage'     => '15',
  ));


Place in body section, wherever you want to include pagination.

<?php /* -- BEGIN PAGINATION  -- */ ?>

<?php
$sectionName = 'blog_content'; // ** CHANGE TO MATCH CMSB SECTION **
$pageLink = 'blog_list.php'; // ** CHANGE TO MATCH LIST PAGE **
  $maxPages       = 5; // ** Maximum amount of page numbers to display

  list($sectionNameRecords, $sectionNameMetaData) = getRecords(array(
    'tableName'   => $sectionName,
    'perPage'     => '15',
  )); 

  $currentPage    = coalesce($sectionNameMetaData['page'], 1);
  $maxDisplayPage = min( ($currentPage + $maxPages - 1), $sectionNameMetaData['totalPages']);
  $totalPages     = $sectionNameMetaData['totalPages'];
?>


<?php if ($totalPages <= $maxPages): //run this code if less total pages than maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
    <li class="prev">
           <?php if ($sectionNameMetaData['prevPage']): ?>
              <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
          </li>
<?php foreach(range('1',$sectionNameMetaData['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $sectionNameMetaData['page']): ?>class="current"<?php endif; ?>>
              <a href="<?php echo $pageLink; ?>?page=<?php echo $pageNumber; ?>"><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
    <li class="next">
           <?php if ($sectionNameMetaData['nextPage']): ?>
           <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div><?php /* .pagination */ ?>
     <?php endif ?> 

<?php elseif ($currentPage >= ($totalPages - ($maxPages - 1))): //run this code if viewing one of last few pages as defined by maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
   <div class="pagination">
     <ul>
    <li class="prev">
           <?php if ($sectionNameMetaData['prevPage']): ?>
              <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
<?php else: ?>
            <?php endif ?>
            
<?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
              <li><a href="<?php echo $pageLink; ?>?page=1">1</a></li>
            <?php endif ?>
                          
            <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
              <li><span>...</span></li>
            <?php endif ?>
            
          </li>
<?php foreach(range(($totalPages - ($maxPages - 1)),$sectionNameMetaData['totalPages']) as $pageNumber): ?>
            <li <?php if($pageNumber == $sectionNameMetaData['page']): ?>class="current"<?php endif; ?>>
              <a href="<?php echo $pageLink; ?>?page=<?php echo $pageNumber; ?>"><?php echo $pageNumber; ?></a>
            </li>
          <?php endforeach; ?>
    <li class="next">
           <?php if ($sectionNameMetaData['nextPage']): ?>
           <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
            <?php else: ?>
            <?php endif ?>
          </li>
     </ul>
     </div><?php /* .pagination */ ?>
     <?php endif ?> 

<?php else: //run this code if more total pages than $maxPages ?>
 <?php if ($sectionNameMetaData['totalPages'] > 1): ?>
     <div class="pagination">
       <ul>
<?php if ($sectionNameMetaData['prevPage']): ?>
          <li class="prev">
            <a href="<?php echo $sectionNameMetaData['prevPageLink'] ?>">&#8592;</a>
          </li>
        <?php endif ?>
        
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // show first page number ?>
      <li><a href="<?php echo $pageLink; ?>?page=1">1</a></li>
    <?php endif ?>
                  
    <?php if ($currentPage > 1 && $maxDisplayPage > $maxPages): // start with "..." ?>
      <li><span>...</span></li>
    <?php endif ?>
    
    <?php foreach (range($currentPage, $maxDisplayPage) as $page): ?>
      <?php if ($page == $currentPage): ?>
        <li class = "current">
      <?php else: ?>
        <li>
      <?php endif ?>
      <a href="<?php echo $pageLink; ?>?page=<?php echo $page; ?>"><?php echo $page; ?></a>
        </li>
    <?php endforeach ?>
    
    
    <?php if ($maxDisplayPage < $totalPages): //end with "..." ?>
      <li><span>...</span></li>
      
<?php if ($currentPage < $totalPages): // show last page number ?>
        <li><a href="<?php echo $pageLink; ?>?page=<?php echo $totalPages; ?>"><?php echo $totalPages; ?></a></li>
      <?php endif ?>
      
      <?php if ($sectionNameMetaData['nextPage']): ?>
        <li class="next">
          <a href="<?php echo $sectionNameMetaData['nextPageLink'] ?>">&#8594;</a>
        </li>
      <?php endif ?>
    <?php endif ?>
    
       </ul>
       </div><?php /* .pagination */ ?>
   <?php endif ?> 
  <?php endif ?>  

<?php /* -- /END PAGINATION  -- */ ?>


And, if you're interested, here's the CSS I used:

<style>

.pagination{
height: 39px;
border-top: 1px solid #e0e0e0;
border-bottom: 1px solid #e0e0e0;
text-align: center;
}
.pagination li{
display: inline-block;
border-right: 1px solid #e0e0e0;
}
.pagination li a,
.pagination li span{
display: block;
height: 39px;
padding: 0 15px;
margin: 0 0 0 -3px;
color: #777;
font:normal 13px/39px Arial, Verdana, serif;
text-decoration: none;
}
.pagination li.prev a,
.pagination li.next a{
font:normal 20px/32px Arial, Verdana, serif;
color: #444;
}
.pagination li.prev span,
.pagination li.next span{
font:normal 20px/32px Arial, Verdana, serif;
}
.pagination li.next {border: 0 none;}
.pagination li a:hover{
background: #eff7ff;
text-decoration: none;
}
.pagination li.current a{
background: #f3f4fa;
color: #444;
font-weight: bold;
text-decoration: none;
}
.pagination_info{
margin: 15px  0!important;
color: #777;
text-align: center;
font:italic 11px/11px Arial, Verdana, serif;
}

</style>

That's it!  Even though I'm sure some of this could be cleaner, I'm really happy with the way it turned out.  Hope it can be of some use to someone.  Thanks again to the wonderful help from the team at Interactive Tools!  :-)

- Jeremy

OK... I've updated the code above so that it is now complete with the proper linking in place.

- Jeremy

Now that the tags are displaying correctly, how do I make each tag link to a page that will display a list of any article(s) designated with that tag in the article's tag list?

Thanks, in advance!

- Jeremy

To see a sample of how it looks the way I implemented it, see the attached JPEG image.  I now believe there may be a better way to approach this whole thing (as I mention in my post here: http://www.interactivetools.com/forum/forum-posts.php?postNum=2230008#post2230008); however, this version still works well and is still a completely valid tag cloud method.  

Anyway, here's the code.  This example is set up in CMSB with a multi-section called "blog_content", a field for the tags called "tags", a viewer page called "blog.php", and a list page called "blog_list.php" .  You'll need to change the items in red to match your CMSB configuration:

<style>
/*** tags style ***/
#tags a{
color: #777;
font:normal 13px/26px Segoeui, Arial, Verdana, serif;
text-decoration: none
}
#tags a:hover{
color: #444;
}
/*** TAGS - 10 font-size steps ***/
#tags a.t0{font-size: 11px}
#tags a.t10{font-size: 12px}
#tags a.t20{font-size: 16px}
#tags a.t30{font-size: 20px}
#tags a.t40{font-size: 20px}
#tags a.t50{font-size: 24px}
#tags a.t60{font-size: 24px}
#tags a.t70{font-size: 27px}
#tags a.t80{font-size: 27px}
#tags a.t90{font-size: 27px}
#tags a.t100{font-size: 27px}
</style>



<?php

$tagsToCount = array();
$sectionsToField = array('blog_content' => 'tags'/*, 'blog2_content' => 'tags'*/); //to draw tags from multiple sections remove php comment tags and add as shown, otherwise you can delete everything between and including these: /* */


foreach($sectionsToField as $sectionName => $fieldName) {

//get section records
$records = mysql_select($sectionName);

foreach ($records as $record) {
//turn field into an array of values
$tags = explode(",", @$record[$fieldName]);


// add tags to the count array
foreach ($tags as $tag) {
$tag = trim($tag);
if (!$tag) { continue; } // skip empty array values

   if (array_key_exists($tag, $tagsToCount)) {
   $tagsToCount[$tag]++; }
   else {
   $tagsToCount[$tag] = 1; 
      }
  }
}
}

//PHP doesn't have a shuffle function built in that maintains keys, but this version does.
function shuffle_assoc($list) { 
  if (!is_array($list)) return $list; 

  $keys = array_keys($list); 
  shuffle($keys); 
  $random = array(); 
  foreach ($keys as $key) { 
    $random[$key] = $list[$key]; 
  }
  return $random; 
} 

 ?>


<!-- DISPLAY TAGS -->
<?php $tagsToCount = shuffle_assoc($tagsToCount); ?>
 <?php if ($tagsToCount): ?>
        <aside id="tags">
     <h3>Tags</h3>
         <?php  $maximumResults = 18;
                $resultCount = 0;
         ?>
           <?php $totalTagCount = array_sum($tagsToCount); ?>
           <?php foreach ($tagsToCount as $key => $value): ?>
           <?php           
             $ratio =  (intval($value)/$totalTagCount) * 100; //get the number-of-tag-occurances as a percentage of the overall number 
             $ratio =  round($ratio,-1); //round the number to the nearest 10 
           ?>

             <a class="t<?php echo $ratio; ?>" href="blog_list.php?tags_keyword=<?php echo $key;?>"><?php echo $key; ?></a>
             <?php if (++$resultCount == $maximumResults) { break;}?>
           <?php endforeach ?>
        </aside>
 <?php endif ?>


For a quick sample of how this could look in use on your page, you can add the following html:

<!-- Tags - SAMPLE -->

      <aside id="tags">
     <h3>Tags - Sample</h3>
     <a class="t7" href="">design</a>
     <a class="t3" href="">color</a>
     <a class="t8" href="">web design</a>
     <a class="t1" href="">computer</a>
     <a class="t2" href="">ecommerce</a>
     <a class="t9" href="">php</a>
     <a class="t2" href="">html</a>
     <a class="t6" href="">code</a>
     <a class="t3" href="">logos</a>
     <a class="t8" href="">letterhead</a>
     <a class="t2" href="">branding</a>
     <a class="t8" href="">print</a>
     <a class="t4" href="">web</a>
     <a class="t3" href="">freelance</a>
     <a class="t5" href="">business</a>
     <a class="t3" href="">store</a>
     <a class="t10" href="">internet</a>
      </aside><!-- #tags -->

Well, that's it!  Have fun!  If anyone chooses to modify it in the way I suggest in my previous forum post, I'd love to know and see what you come up with.

All the best!

- Jeremy

Thank you!  That took care of the issue with too many pages being displayed.  I've made a few more modifications and I now have one last question to get this exactly where it needs to be.

Everything works perfectly, displaying a maximum of 5 page numbers (when needed).  However, is there a way to set a minimum number of pages to display as well?  This is because when you are within 5 pages of the total number of pages, displayed page numbers begin dropping out.  So, for instance, if you have 22 pages, when on page 18, you see all 5 page numbers (18, 19, 20, 21, 22).  However, when you move to page 19, you now only see 4 page numbers (19, 20, 21, 22).  This continues until, on page 22, it only displays its own number.  However, on all those 5 final pages, all five page numbers should be visible (18, 19, 20, 21, 22).

Thanks for sticking with me this long.  Any ideas on this last item?  I sure appreciate it.  I tried a few things, but nothing even remotely worked.  :-)

- Jeremy

UPDATE: I figured out how to accomplish this.  See post below...

That helped a ton!  Thank you very much!

It looks like the last issue I have is that even if there are less than three pages of articles, the pagination shows all five page links (even if there are only, say, 2 pages of articles).  So, two pages of articles, still shows: 1 2 3 4 5  

Similarly, once you get within five pages of the last page, I need to tell it to stop incrementing the page numbers, and simply show only the final five pages.  (Though, I did manage to get it to at least hide the right arrow and ellipsis.)  But, currently, if there are 22 pages of articles, once you hit page 18, the pagination should look like this: 18 19 20 21 22.  And, it should continue to look this way all the way up to page 22.  But, right now, when you get to page 22, it actually looks like this: 22 23 24 25 26

For an example of how it is currently functioning, you can see the very bottom pagination example on this page: http://www.liviaglobal.com/health_articles_list_test.php?page=19

I'll keep working with it.  But, if you have any ideas, I'm definitely all ears.  :-)

- Jeremy

Thank you so much for all your input on this!  It is working exactly as intended now!  Phew!  :-)

The more I think about (and test) this, I'm starting to feel that my choice of using straight percentages may not have been the best way to go.  It is not often that a tag is used 50% or more of the time.  And, if it is, it doesn't leave many percentage points left for the other tags, so you end up with perhaps one or two larger tags, and then a bunch of smaller tags.  There are just not that many percentage points to go around.  I could have skipped the rounding step, but then you'd have to deal with a ton of CSS styles to define.

I'm thinking I might mess around with using straight tabulation to determine frequency, then the top most used tag would be assigned the largest possible font-size.  Then, the next most used tag would be assigned the second largest font-size, and so on (up to as many tags as you wish to allow).  Or, even better, ranges of font-sizes, determined by percentages of the total tags to be displayed (and assigned to each tag in order of frequency) could be used to determine which CSS style each was assigned to.  (Just thinking out loud here... and probably not making much sense.)  :-)

Anyway, I'll keep fiddling.  But, at least I have something that works and can be used right now.  And, again, I can't thank you guys enough.

@DavidCMSB - In just a couple days, I'll post a complete commented script for this "percentage-based" tag cloud.  It works great!  But, as I stated above, I think it can be even better implemented (now that I've had a chance to really see it working).  Hopefully I, or someone else, and improve on this even more.  I think having a solid, easy-to-use tag cloud feature, designed with CMSB in mind is a huge benefit to those wanting to add that to their sites.  In the future, another cool idea would be to generate a tag cloud automatically based on search terms used with a site's search feature.  That could be pretty handy too.  :-)