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; }
$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),