Member Access Permissions - assigned to a Category section editor.

Hi Zicky,

I have a few questions to help narrow down the issue:

-What is the error being returned?
-By default, getCategories() does not support the "where" option - are you using a customized version of it?
-Can you add 'debugSql' => true to the $paramsAboutRecords array and let me know the output?

Thanks!

Hey Daniel,

No, this is not a customized version.

I added the debugSql => true to the paramsAboutRecords. Below is the output I get... but it never gets to the debugSql output part.

Category Viewer (about_us) errors
Unknown option 'where' specified
Valid option names are: (tableName, useSeoUrls, debugSql, selectedCategoryNum, categoryFormat, loadUploads, defaultCategory, rootCategoryNum, ulAttributes, ulAttributesCallback, liAttributesCallback, loadCreatedBy, ignoreHidden)

Zicky

Hi Zicky,

Don't know if this will help, but I've attached the code that I've used to restrict access in an organization. It references a list field in the accounts table with the various permission levels for each member.

There are also some recipes in the CMSB Cookbook http://www.thecmsbcookbook.com in the website membership plugin section that might give you some ideas.

Best,

Jerry Kornbluth

Hey Daniel,

Thanks for your guidance! I got this figured out and running now with your help.

Much appreciated!!! My head hurts now : ) Time for a Beer or many!

Anyone interested in the results... here it is:

        // load records about_us
  list($about_usNavRecords, $selectedCategory) = getCategories(array(
    'tableName'   => 'about_us',
	'categoryFormat' => 'showall'
  ));

    <li>
      <a href="#">About</a>
      <ul>
        <li>
        
        <?php foreach($about_usNavRecords as $category): ?>
        <?php if ($category['depth'] == 0): ?>
                <h3><?php echo htmlencode($category['name']); ?></h3>
                <?php $parent=$category['num'];?>
                <ul>
            <?php foreach($about_usNavRecords as $key => $category): ?>
	        <?php if ($category['parentNum'] == $parent): ?>
                
<?php echo $category['_listItemStart']; ?>
    <?php if (@$CURRENT_USER['member_type'] == '' || @$CURRENT_USER['member_type'] == '1'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php elseif (@$CURRENT_USER['member_type'] == '2'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1' || $category['access_permissions'] == '2'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php elseif (@$CURRENT_USER['member_type'] == '3'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1' || $category['access_permissions'] == '2' || $category['access_permissions'] == '3'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php elseif (@$CURRENT_USER['member_type'] == '4'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1' || $category['access_permissions'] == '2' || $category['access_permissions'] == '3' || $category['access_permissions'] == '4'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php elseif (@$CURRENT_USER['member_type'] == '5'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1' || $category['access_permissions'] == '5'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php elseif (@$CURRENT_USER['member_type'] == '6'): ?>
        <?php if ($category['access_permissions'] == '' || $category['access_permissions'] == '1' || $category['access_permissions'] == '6'): ?>
                <a href="<?php echo $category['_link'] ?>" title="<?php echo htmlencode($category['name']); ?>"><?php echo htmlencode($category['name']); ?></a>
                <?php unset($about_usNavRecords[ $key ]); ?>
        <?php endif; ?>
    <?php endif; ?>
 <?php echo $category['_listItemEnd']; ?>
                
            <?php endif; ?>
            <?php endforeach; ?>
                </ul>
        <?php endif; ?>
        <?php endforeach; ?>
        
        </li>
      </ul>
    </li>

Cheers!! Zicky

Hey Zicky,

Glad you got it sorted out. 

Thanks for posting your result.

Jerry Kornbluth