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,

Yes - I see now; since getCategories() doesn't support the 'where' option, the next best method would likely be to filter the results after they're returned. That could look something like this:

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

// loop through records
foreach ($about_usNavRecords as $key => $record) {
  
  if (@$CURRENT_USER['member_type'] == '2') {
    
    if ($record['access_permission'] != '' && $record['access_permission'] != '1' && $record['access_permission'] != '2') {
      unset($about_usNavRecords[ $key ]);
    }
    
  }

  ...
  
}

You would need to add the remainder of the logic for the other member_types. The main difference in logic with this approach is that instead of "if the record does contain the correct access_permission: return it", this uses "if the record doesn't contain the correct access_permission: remove it"

Let me know if this helps - or if you have any other questions.

Thanks!

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