declare playerclan varchar(10);
  declare skinchange int(1) default 0;
  declare new_model varchar(20);

  select cm.clan, cm.skin_change INTO playerclan, skinchange from dayz.clan_members as cm where unique_id = p_uniqueId;

  IF skinchange = 1 THEN
        select clan_clans.model INTO new_model from dayz.clan_clans where clan_clans.name = playerclan;
	    update survivor set model = new_model where unique_id = p_uniqueId and is_dead = 0;
  END IF;