Query to create a category page?

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

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 Perchpole - July 16, 2014

Hi, Dave -

Thanks. This appears to work better than I had hoped for.

I now need to take this on to the next logical step... uploads!

Claire, you helped me with the AJAX which I'm using to send the data to the query. Would you be able/willing to help me to add uploading capability if I put in a priority consulting request?

Thanks,

Perch

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/