blog categories
Jamroom Developers
Seams like the right approach. Also use the group_by clause to get just one of each:
"{jrCore_list}"
http://www.jamroom.net/the-jamroom-network/documentation/development/89/jrcore-list
<!-- Twitter -->
<meta name="twitter:card" value="summary"/>
<meta name="twitter:site" value="@roughneckcity"/>
<meta name="twitter:creator" value=""/>
<meta name="twitter:url" value="http://roughneckcity.com/roughneck-city/poll/1/usa-oilfield-poll"/>
<meta name="twitter:title" value="Who Do You Support For President?"/>
<meta name="twitter:description" value="Would Donald Trump have the balls to take on Saudi Arabia? Would Hillary Clinton ban fracking? who would be the best Oil & Gas President? Vote now and see the results"/>
<meta name="twitter:image" value="http://s3-us-west-1.amazonaws.com/facebooklg/For-President-Finished.jpg"/>
<meta name="tw-line" content="Who would make the best oil and gas President?"/>
<!-- Facebook OG -->
<meta id="ogtitle" property="og:title" content="Who Do You Support For President?"/>
<meta property="article:publisher" content="https://www.facebook.com/DrillingAhead"/>
<meta property="og:type" content="article"/>
<meta id="ogurl" property="og:url" content="http://roughneckcity.com/roughneck-city/poll/1/usa-oilfield-poll"/>
<meta id="ogimage" property="og:image" content="http://s3-us-west-1.amazonaws.com/facebooklg/For-President-Finished.jpg"/>
<meta id="ogdescription" property="og:description" content="Would Donald Trump have the balls to take on Saudi Arabia? Would Hillary Clinton ban fracking? who would be the best Oil & Gas President? Vote now and see the results"/>
<!-- Twitter -->
<meta name="twitter:card" value="summary"/>
<meta name="twitter:site" value="@roughneckcity"/>
<meta name="twitter:creator" value=""/>
<meta name="twitter:url" value="http://roughneckcity.com/roughneck-city/poll/1/usa-oilfield-poll"/>
<meta name="twitter:title" value="Who Do You Support For President?"/>
<meta name="twitter:description" value="Would Donald Trump have the balls to take on Saudi Arabia? Would Hillary Clinton ban fracking? who would be the best Oil & Gas President? Vote now and see the results"/>
<meta name="twitter:image" value="http://s3-us-west-1.amazonaws.com/facebooklg/For-President-Finished.jpg"/>
<meta name="tw-line" content="Who would make the best oil and gas President?"/>
/**
* Get all users that belong to a profile for ticket owner
* @return mixed
*/
function jrTracker_get_profile_users(){
global $_user, $_post;
if (isset($_post['profile_id']) && jrCore_checktype($_post['profile_id'], 'number_nz')) {
$profile_id = $_post['profile_id'];
}
else {
$profile_id = $_user['user_active_profile_id'];
}
$tb1 = jrCore_db_table_name('jrProfile', 'profile_link');
$tb2 = jrCore_db_table_name('jrUser', 'item_key');
$req = "SELECT u.`value` FROM {$tb1} p LEFT JOIN {$tb2} u ON (u.`_item_id` = p.user_id AND u.`key` = 'user_name') WHERE p.profile_id = '{$profile_id}' ORDER BY u.`value` ASC";
$_us = jrCore_db_query($req, 'value', false, 'value');
if ($_us && is_array($_us)) {
$_ln = jrUser_load_lang_strings();
$_us['unassigned'] = $_ln['jrTracker'][72];
return $_us;
}
return false;
}