Exemplo n.º 1
0
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];
}
Exemplo n.º 2
0
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];
}