Forum Activity for @michael

function xxYourModule_db_search_params_listener($_data, $_user, $_conf, $_args, $event)
{
    global $_post;
    if (isset($_post['module_url']) && isset($_post['ss']) && strlen($_post['ss']) > 0) {
    $_data['search'] .="|| profile_bio = %{$_post['ss'}%";
   }
return $_data;
}

||profile_bio = %whatever%

    // We have mentions - make sure they are good
        $_rt = array(
            'search'         => array(
                'profile_url in ' . implode(',', $_tmp)
            ),
            'return_keys'    => array('_profile_id', 'profile_url'),
            'skip_triggers'  => true,
            'ignore_pending' => true,
            'limit'          => count($_tmp)
        );
        $_rt = jrCore_db_search_items('jrProfile', $_rt);
        if ($_rt && is_array($_rt) && isset($_rt['_items'])) {
.....

$profile_url  = "{$_conf['jrCore_base_url']}/{$item['profile_url']}";

$tbl = jrCore_db_table_name('jrProfile', 'item_key');
$req = "SELECT * FROM {$tbl} WHERE item_id = '1' ";
$single = jrCore_db_query($req, 'SINGLE'); // a single query or
$_many = jrCore_db_query($req, 'NUMERIC'); // many items