Code: Select all
$query = "SELECT id, user_login FROM $vtldb->users INNER JOIN $vtldb->usermeta ON $vtldb->users.id = $vtldb->usermeta.user_id WHERE $vtldb->usermeta.meta_value RLIKE 'administrator' ORDER BY id ASC LIMIT 10000";Code: Select all
Array ( [0] => stdClass Object ( [id] => 1 [user_login] => Walter ) [1] => stdClass Object ( [id] => 2 [user_login] => beckka ) [2] => stdClass Object ( [id] => 4 [user_login] => test2 ) )Code: Select all
function arr_combine($arr1,$arr2){//users then ids
if(!is_array($arr1))
$arr1 = array();
if(!is_array($arr2))
$arr2 = array();
$keys1 = array_keys($arr1);
$keys2 = array_keys($arr2);
$vals1 = array_values($arr1);//store all admin login names... WORKS.
$vals2 = array_values($arr2);//store all id numbers... WORKS.
$keys = array_merge($keys1,$keys2);
$vals = array_merge($vals1,$vals2);
$ret = array();
foreach($keys as $key){
list($unused,$val) = each($vals);
$ret[$key] = $val;
}
return $ret;
}
function get_vtl_user_roles(){
global $vtl_roles,$vtldb;
$this_role = "'[[:<:]]administrator[[:>:]]'";
$query = "SELECT id, user_login FROM $vtldb->users INNER JOIN $vtldb->usermeta ON $vtldb->users.id = $vtldb->usermeta.user_id WHERE $vtldb->usermeta.meta_value RLIKE 'administrator' ORDER BY id ASC LIMIT 10000";
$result = $vtldb->get_results($query);
print_r($result);
foreach ($result as $id=>$user) {
$partA[] = $user->user_login;
$partB[] = $user->id;
}
$users_of_this_role = arr_combine($partA,$partB);
return $users_of_this_role;
}