View difference between Paste ID: AHhvHQcQ and
SHOW: | | - or go back to the newest paste.
1-
1+
 insert this conditional block at top of file after the define and load_plugin lines ~line 20
2
3
if($wpdb->prefix == 'wp_1_'){
4
    $db_prefix = $wpmuBaseTablePrefix;
5
   }else {
6
    $db_prefix = $wpdb->prefix;
7
   }
8
9
 copy and paste this block over existing one taking care to include last } before the next function begins
10
11
function cp_getAllPoints($amt=0,$filter_users=array(),$start=0){
12
	global $wpdb, $db_prefix;
13
	if($amt>0){ $limit = ' LIMIT ' . $start.','.$amt; }
14
	if (count($filter_users)>0){
15
		$extraquery = ' WHERE '.$db_prefix.'users.user_login != \'';
16
		$extraquery .= implode("' AND ".$db_prefix."users.user_login != '",$filter_users);
17
		$extraquery .= '\' ';
18
	} 
19
	$array = $wpdb->get_results('SELECT '.$db_prefix.'users.id, '.$db_prefix.'users.user_login, '.$db_prefix.'users.display_name, '.$db_prefix.'usermeta.meta_value 
20
		FROM `'.$db_prefix.'users` 
21
		LEFT JOIN `'.$db_prefix.'usermeta` ON '.$db_prefix.'users.id = '.$db_prefix.'usermeta.user_id 
22
		AND '.$db_prefix.'usermeta.meta_key=\''.POINTS.'\''.$extraquery.' 
23
		ORDER BY '.$db_prefix.'usermeta.meta_value+0 DESC'
24
		. $limit . ';'
25
		,ARRAY_A);
26
	return $array;
27
28
}