function spa_add_special_rank_member($id)
{
    check_admin_referer('special-rank-add', 'special-rank-add');
    $user_id_list = array_unique($_POST['amember_id']);
    if (empty($user_id_list)) {
        return;
    }
    # get the special rank
    $rank = sp_get_sfmeta('special_rank', false, $id);
    # add the new users
    for ($x = 0; $x < count($user_id_list); $x++) {
        sp_add_special_rank((int) $user_id_list[$x], $rank[0]['meta_key']);
    }
    do_action('sph_component_srank_add_save');
    $mess = spa_text('User(s) added to special forum ranks');
    return $mess;
}
Exemplo n.º 2
0
    $sql = '
		CREATE TABLE IF NOT EXISTS ' . SFSPECIALRANKS . ' (
		id int(11) unsigned NOT NULL AUTO_INCREMENT,
		user_id bigint(20) default NULL,
		special_rank varchar(100),
		PRIMARY KEY (id),
		KEY user_id_idx (user_id),
		KEY special_rank_idx (special_rank)
		) ' . spdb_charset();
    spdb_query($sql);
    $sr = spdb_select('set', 'SELECT user_id, special_ranks FROM ' . SFMEMBERS . ' WHERE LENGTH(special_ranks) > 6');
    if ($sr) {
        foreach ($sr as $usr) {
            $ranks = unserialize($usr->special_ranks);
            foreach ($ranks as $rank) {
                sp_add_special_rank($usr->user_id, $rank);
            }
        }
    }
    spdb_query('ALTER TABLE ' . SFMEMBERS . ' DROP special_ranks');
    sp_response($section);
}
$section = 10733;
if ($build < $section) {
    # create new table for user activity (in preparation)
    $sql = 'CREATE TABLE IF NOT EXISTS ' . SFUSERACTIVITY . ' (
				id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
				user_id bigint(20) NOT NULL,
				type_id smallint(4) NOT NULL,
				item_id bigint(20) NOT NULL,
				PRIMARY KEY (id),