diff options
| author | spiderr <spiderr@bitweaver.org> | 2022-04-12 16:09:06 -0400 |
|---|---|---|
| committer | spiderr <spiderr@bitweaver.org> | 2022-04-12 16:09:06 -0400 |
| commit | 50b98a6ec26b886c2a6d7e11dd47e009bb66bfff (patch) | |
| tree | 28b98139849a53dc378a3a15ce863fabf3acaa97 /includes/classes | |
| parent | 84b2c966424dded162fdf78ab3cd191130d8df2f (diff) | |
| download | liberty-50b98a6ec26b886c2a6d7e11dd47e009bb66bfff.tar.gz liberty-50b98a6ec26b886c2a6d7e11dd47e009bb66bfff.tar.bz2 liberty-50b98a6ec26b886c2a6d7e11dd47e009bb66bfff.zip | |
add metatags liberty_content_data support
Diffstat (limited to 'includes/classes')
| -rw-r--r-- | includes/classes/LibertyContent.php | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/includes/classes/LibertyContent.php b/includes/classes/LibertyContent.php index 0d8c005..0170312 100644 --- a/includes/classes/LibertyContent.php +++ b/includes/classes/LibertyContent.php @@ -342,6 +342,7 @@ class LibertyContent extends LibertyBase implements BitCacheable { } } $pParamHash['data_store']['summary'] = !empty( $pParamHash['summary'] ) ? $pParamHash['summary'] : NULL ; + $pParamHash['data_store']['metatags'] = !empty( $pParamHash['metatags'] ) ? $pParamHash['metatags'] : NULL ; // call verify service to see if any services have errors $this->invokeServices( 'content_verify_function', $pParamHash ); @@ -951,6 +952,12 @@ class LibertyContent extends LibertyBase implements BitCacheable { LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_data` lcds ON( lc.`content_id` = lcds.`content_id` AND lcds.`data_type` = ? )"; $pQueryHash['join']['var'][] = 'summary'; } + if( empty( $pJoins ) || in_array( 'metatags', $pJoins )) { + $pQueryHash['select']['sql'][] = "lcdm.`data` AS `metatags`"; + $pQueryHash['join']['sql'][] = " + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_data` lcdm ON( lc.`content_id` = lcdm.`content_id` AND lcdm.`data_type` = ? )"; + $pQueryHash['join']['var'][] = 'metatags'; + } if( empty( $pJoins ) || in_array( 'hits', $pJoins )) { $pQueryHash['select']['sql'][] = "lch.`hits`, lch.`last_hit`"; $pQueryHash['join']['sql'][] = " @@ -2749,13 +2756,15 @@ class LibertyContent extends LibertyBase implements BitCacheable { lc.`ip`, lc.`created`, lc.`content_id`, - lcds.`data` AS `summary` + lcds.`data` AS `summary`, + lcdm.`data` AS `metatags` $selectSql FROM `".BIT_DB_PREFIX."liberty_content` lc INNER JOIN `".BIT_DB_PREFIX."users_users` uuc ON (lc.`user_id`=uuc.`user_id`) LEFT OUTER JOIN `".BIT_DB_PREFIX."users_users` uue ON (lc.`modifier_user_id`=uue.`user_id`) LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_hits` lch ON( lc.`content_id` = lch.`content_id`) LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_data` lcds ON (lc.`content_id` = lcds.`content_id` AND lcds.`data_type`='summary') + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_data` lcdm ON (lc.`content_id` = lcdm.`content_id` AND lcdm.`data_type`='metatags') $joinSql $whereSql ORDER BY ".$orderTable.$this->convertSortMode($pListHash['sort_mode']); |