function portal_lookup_activity_comment_count($diy_id) { static $lookup = array(); if (count($lookup) == 0) { $query = 'SELECT comment_diy_identifier, count(comment_id) AS comment_count FROM portal_comments_ratings GROUP BY comment_diy_identifier'; $params = array(); $results = mystery_select_query($query, $params, 'portal_dbh'); $lookup = mystery_convert_results_to_lookup_array($results, 'comment_diy_identifier', 'comment_count'); } if (!isset($lookup[$diy_id])) { $lookup[$diy_id] = '<em>—</em>'; } return $lookup[$diy_id]; }
function portal_lookup_diy_uuid($diy_id) { static $lookup = array(); if (count($lookup) == 0) { $query = 'SELECT id, uuid FROM ' . $GLOBALS['portal_config']['diy_database'] . '.' . $GLOBALS['portal_config']['diy_table_prefix'] . $GLOBALS['portal_config']['diy_activities_name']; $params = array(); $results = mystery_select_query($query, $params, 'rails_dbh'); $lookup = mystery_convert_results_to_lookup_array($results, 'id', 'uuid'); } if (@$lookup[$diy_id] == '') { $lookup[$diy_id] = ''; } return $lookup[$diy_id]; }