Query to create a category page?

14 posts by 3 authors in: Forums > CMS Builder
Last Post: July 16, 2014   (RSS)

By Perchpole - July 15, 2014

Actually, after lots of testing, the entire exercise is in danger of grinding to a halt!

There is something about the way categories are made that I cannot emulate with my front-end form. It doesn't matter what data I send to the query, it isn't enough. I believe this is due to the way a category is saved in cmsb. The process does far more than send data to a database. The act of saving a category also sets, resets and updates a number of additional parameters - like lineage, globalOrder, breadcrumb, etc. The only way to execute this process is to open the category record in cmsb and then immediately save it. 

Unless I'm mistaken, there is no way to replicate this process through a front-end form?

Perch

By Dave - July 15, 2014

Hi Perch, 

There's no easy or supported way.  Here's a hacky way: 

  // force update of category metadata for sorting (this may need to be updated in a much future version)
  $categoryTablename = 'category';
  $GLOBALS['escapedTableName'] = mysql_escape( $TABLE_PREFIX . $categoryTablename );
  $GLOBALS['schema']           = loadSchema($categoryTablename); // fake currently loaded schema
  if (!$GLOBALS['schema']) { die("Invalid table name '" .htmlencode($categoryTablename). "'"); }
  include_once(SCRIPT_DIR . '/lib/menus/default/common.php'); // load category menu functions 
  updateCategoryMetadata();

Let me know if that works for you.  

Dave Edis - Senior Developer
interactivetools.com

By claire - July 16, 2014

Of course - just email consulting@interactivetools.com. I'll pick it up as soon as I see it.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/