[Arcturus] Interaction types

**Reservoir** · 13-10-17

I decided to release this since there is not a catalog you get with the database from Wesley, and you would have to change lot of the interaction types by hand and there's also new ones which other emulator don't have (Plus). I used the database and newest interaction types from Arcturus 1.10.0!

Code:

UPDATE items_base SET interaction_type = "gate" WHERE item_name IN ("divider_poly3","divider_arm3","divider_nor3","divider_silo3","scifiport*0","scifiport*7","scifiport*6","scifiport*4","scifiport*3","scifiport*2","scifiport*1","scifidoor*10","scifidoor*9","scifidoor*8","scifidoor*7","scifidoor*6","scifidoor*5","scifidoor*4","scifidoor*3","scifidoor*2","scifidoor*1","marquee*1","marquee*2","marquee*7","marquee*10","marquee*8","marquee*9","marquee*5","marquee*4","marquee*6","marquee*3","divider_nor4*4","divider_silo3*2","divider_silo3*3","divider_silo3*4","divider_silo3*5","divider_silo3*6","divider_silo3*7","divider_silo3*8","divider_silo3*9","divider_poly3*2","divider_poly3*3","divider_poly3*4","divider_poly3*5","divider_poly3*6","divider_poly3*7","divider_poly3*8","divider_poly3*9","divider_nor3*3","divider_nor3*4","divider_nor3*5","divider_nor3*6","divider_nor3*7","divider_nor3*8","divider_nor3*9","divider_nor4*2","divider_nor4*3","divider_nor4*5","divider_nor4*6","divider_nor4*7","divider_nor4*8","divider_nor4*9","divider_nor4","gothgate","hc_crtn","plant_mazegate","rope_divider","rare_mnstr","xmas_cstl_gate","plant_mazegate_snow","sand_cstl_gate","diner_bardesk_gate*1","diner_bardesk_gate*2","diner_bardesk_gate*3","diner_bardesk_gate*4","diner_bardesk_gate*5","diner_bardesk_gate*6","diner_bardesk_gate*7","diner_bardesk_gate*8","diner_bardesk_gate*9","greek_gate","china_moongt","bolly_drapec","bolly_drapea","bolly_drapeb","ads_idol_drape","exe_gate","env_bushes_gate","country_gate","country_ditch","lt_gate","sf_gate","ktchn_gate","hween09_hatch","prison_gate","wf_glassdoor","cine_curtain","hole","horse_stable_gate","horse_stable_gate_w","horse_track_gate","vip_gate","jetset_vault_door","costume_gate","marquee*11");
UPDATE items_base SET interaction_type = "guild_furni" WHERE item_name IN ("gld_carpet","gld_badgewall_tall","gld_stool2","gld_stool1","gld_wall_tall","gld_pennant","gld_sofa1","gld_hangflag2","gld_tile2","gld_hangflag1","gld_tile1","gld_table1","pirate_mast2grp","pirate_mast3grp","pirate_mast4grp","guild_forum");
UPDATE items_base SET interaction_type = "guild_gate" WHERE item_name IN ("gld_gate");
UPDATE items_base SET interaction_type = "background_toner" WHERE item_name IN ("roombg_color");
UPDATE items_base SET interaction_type = "badge_display" WHERE item_name IN ("badge_display2","badge_display","badge_display4","badge_display3","badge_display5");
UPDATE items_base SET interaction_type = "mannequin" WHERE item_name IN ("boutique_mannequin1","olympics_c16_mannequin");
UPDATE items_base SET interaction_type = "ads_bg" WHERE item_name IN ("ads_background","ads_mpu_720","ads_mpu_300","ads_mpu_160","info_terminal","mutearea_sign","buildarea_sign");
UPDATE items_base SET interaction_type = "trophy" WHERE item_name IN ("legotrophy","prizetrophy2*3","prizetrophy3*3","prizetrophy4*3","prizetrophy5*3","prizetrophy6*3","prizetrophy*1","prizetrophy2*1","prizetrophy3*1","prizetrophy4*1","prizetrophy5*1","prizetrophy6*1","prizetrophy*2","prizetrophy2*2","prizetrophy3*2","prizetrophy4*2","prizetrophy5*2","prizetrophy6*2","prizetrophy*3","prizetrophy7*3","prizetrophy9*1","greektrophy*1","greektrophy*2","ads_idol_trophy","prizetrophy_cool","prizetrophy_hot","ads_twi_trophy","prizetrophy_2011_w","prizetrophy_2011_r","prizetrophy_2011_y","prizetrophy_2011_b","prizetrophy_2011_p","prizetrophy_2011_g","ads_grefu_trophy","prizetrophy_room_1");
UPDATE items_base SET interaction_type = "vendingmachine" WHERE item_name IN ("bar_polyfon","bar_armas","sink","bar_basic","fridge","samovar","mocchamaster","md_limukaappi","rare_icecream*1","rare_icecream*7","rare_icecream*8","rare_icecream*2","rare_icecream*6","rare_icecream*9","rare_icecream*3","rare_icecream*0","rare_icecream*4","rare_icecream*5","safe_silo","safe_silo*2","safe_silo*3","safe_silo*4","safe_silo*5","safe_silo*6","safe_silo*7","safe_silo*8","safe_silo*9","hc_btlr","val_cauldron","rare_icecream_campaign","hal_cauldron","safe_silo_pb","arabian_teamk","calippo","jp_teamaker","hcc_minibar","ads_711*1","ads_711*2","ads_711*3","ads_711*4","hween08_sink2","hween08_sink","party_tray","xmas08_hole","bolly_phant","ads_711shelf","tray_glasstower","ads_calip_cola*1","ads_calip_cola*2","ads_calip_cola*3","ads_calip_cola*4","ads_mall_coffeem","ads_oc_soda","ads_711*5","ads_711*6","ads_711*7","ktchn_fridge","sf_mbar","xm09_cocoa","ads_cl_moodi","ads_droetker_paula","bling_fridge","ads_chups","bling_fridge_restricted","ads_grefusa_yum","hc2_coffee","ads_cheetos","ads_pepsi0","hosptl_cab1","qt_xm10_elephant","gothic_bowl","limo_b_mid3","cine_popcorn");
UPDATE items_base SET interaction_type = "pressureplate" WHERE item_name IN ("wf_colortile","wf_ringplate","wf_pressureplate","wf_arrowplate","hs_dnctile_1");
##UPDATE items_base SET interaction_type = "colorplate" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "multiheight" WHERE item_name IN ("eleblock2","eleblock4","eleblock7","eleblock5","eleblock3","eleblock1","eleblock8","eleblock9","eleblock6","cine_platform");
UPDATE items_base SET interaction_type = "dice" WHERE item_name IN ("edice","edicehc","fortune","hween10_tarot");
UPDATE items_base SET interaction_type = "colorwheel" WHERE item_name IN ("habbowheel");
UPDATE items_base SET interaction_type = "cannon" WHERE item_name IN ("pirate_cannon","xmas13_snowflake10");
UPDATE items_base SET interaction_type = "teleport" WHERE item_name IN ("door","doorB","doorC","doorD","teleport_door","xmas08_telep","ads_cltele","ads_mall_tele","ads_idol_tele","lostc_teleport","env_telep","ads_calip_tele","sf_tele","ads_1800tele","exe_elevator","ads_mall_elevator","rare_ironmaiden","garden_flytrap","bw_tele","hween10_tele","bling11_tele","ads_leaf_teleport","picnic_tele","teleport_dragon","anc_pharaoh_tele","steampunk_tele","easter13_teleport","pirate_teleport","hween13_tele","cine_teleport4","cine_teleport2","cine_teleport1","cine_teleport3","easter14_teleport","vikings_teleport","hblooza14_tele","hblooza14_hctele","wildwest_teleport","hween14_hctele","hween14_teleport","xmas14_tele","val15_tele","attic15_tele","cpunk_c15_tele","room_gh15_rtele","army_c15_telemine","army_c15_teledoor","dino_c15_tele","lt15_tele","tiki_c15_tele","hween_c15_tele","ktchn_c15_tele","gold_c15_arc_tele","jungle_c16_tele");
UPDATE items_base SET interaction_type = "teleporttile" WHERE item_name IN ("room_wl15_teleblock");
UPDATE items_base SET interaction_type = "crackable" WHERE item_name IN ("easter13_egg_0","easter13_egg_3","easter13_egg_1","easter13_egg_2","mystics_crystal_s","mystics_crystal_m","mystics_crystal_l","habbo15_crackable");
UPDATE items_base SET interaction_type = "nest" WHERE item_name IN ("nest","nest_plow_bro","nest_snug_grn","nest_snug_blu","nest_plow_blu","nest_snug_red","nest_plow_reg","nest_snug_yel","nest_plow_red","nest_dirt","nest_snug_prp","nest_basket","nest_nest","nest_nails","nest_snug_bla","nest_ice","nest_plow_skl","nest_lion2","nest_rhino","nest_lion","nest_terrarium","nest_frog","nest_chick","nest_dragon","nest_turtle","nest_with_statue","nest_monkey","nest_with_egg","nest_bunny","nest_bunny_green","nest_bunny_blue","nest_bunny_evil","nest_bunny_dep","nest_bunny_love");
UPDATE items_base SET interaction_type = "pet_drink" WHERE item_name IN ("waterbowl*4","waterbowl*5","waterbowl*2","waterbowl*1","waterbowl*3","waterbowl_basic*1","waterbowl_basic*2","waterbowl_basic*3","waterbowl_basic*4","waterbowl_basic*5");
UPDATE items_base SET interaction_type = "pet_food" WHERE item_name IN ("petfood1","petfood2","petfood3","petfood4","petfood7","petfood9","petfood6","petfood5","petfood8","petfood10","petfood11","petfood13","petfood12","petfood15","petfood14","petfood16","petfood18","petfood17","petfood19","petfood21","petfood23","petfood22","petfood_19","petfood24","petfood25","petfood26","petfood20","petfood27","petfood7_horseshoe","petfood28","petfood29");
UPDATE items_base SET interaction_type = "pet_toy" WHERE item_name IN ("toy1","toy1*1","toy1*2","toy1*3","toy1*4");
UPDATE items_base SET interaction_type = "breeding_nest" WHERE item_name IN ("pet_breeding_bear","pet_breeding_terrier","pet_breeding_dog","pet_breeding_pig","pet_breeding_cat");
UPDATE items_base SET interaction_type = "obstacle" WHERE item_name IN ("obstacle_oxer","obstacle_bush","obstacle_fring","obstacle_water3","obstacle_water","obstacle_oxer3","obstacle_oxer2","obstacle_water2");
UPDATE items_base SET interaction_type = "monsterplant_seed" WHERE item_name IN ("mnstr_seed","mnstr_seed_rare");
UPDATE items_base SET interaction_type = "gift" WHERE item_name IN ("present_gen","present_gen1","present_gen2","present_gen3","present_gen4","present_gen5","present_gen6","present_wrap*1","present_wrap*10","present_wrap*2","present_wrap*3","present_wrap*4","present_wrap*5","present_wrap*6","present_wrap*7","present_wrap*8","present_wrap*9");
UPDATE items_base SET interaction_type = "stack_helper" WHERE item_name IN ("tile_stackmagic","tile_stackmagic1","tile_stackmagic2");
UPDATE items_base SET interaction_type = "puzzle_box" WHERE item_name IN ("wf_box");
UPDATE items_base SET interaction_type = "hopper" WHERE item_name IN ("val12_hopper1","val12_hopper2","val12_hopper_3","horse_hopper","teleport_random_2");
##UPDATE items_base SET interaction_type = "costume_hopper" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "club_hopper" WHERE item_name IN ("vip_hopper");
UPDATE items_base SET interaction_type = "club_gate" WHERE item_name IN ("room_hcl15_gate");
UPDATE items_base SET interaction_type = "club_teleporttile" WHERE item_name IN ("room_wl15_telehc");
UPDATE items_base SET interaction_type = "onewaygate" WHERE item_name IN ("one_way_door*1","one_way_door*2","one_way_door*3","one_way_door*4","one_way_door*5","one_way_door*6","one_way_door*7","one_way_door*8","one_way_door*9");
UPDATE items_base SET interaction_type = "love_lock" WHERE item_name IN ("valentines_lovelock","valentines_lovelock9","valentines_lovelock8","valentines_lovelock7","valentines_lovelock3","valentines_lovelock4","valentines_lovelock6","valentines_lovelock5","valentines_lovelock2","valentines_lovelock10","val14_lovelock1","val14_lovelock2","val14_lovelock3","hween14_lovelock");
UPDATE items_base SET interaction_type = "clothing" WHERE item_name IN ("clothing_party1","clothing_geometricskirt","clothing_waistcoatsuit","clothing_meowtfit","clothing_gatsby","clothing_bow","clothing_squid","clothing_baldy","clothing_wavy2","clothing_mutton1","clothing_straw2","clothing_fishhat","clothing_rolled_jeans","clothing_birdshoes","clothing_mermaidoutfit","clothing_droopycollar","clothing_headband","clothing_flowercrown","clothing_hheadphones","clothing_mutton2","clothing_floralskirt","clothing_nightvision","clothing_mockymouse","clothing_xmas1","clothing_shavedside","clothing_geometricjumper","clothing_beard1","clothing_beads","clothing_twotonecardi","clothing_animalprint","clothing_party2","clothing_tshirt_rolled","clothing_rippedjeans","clothing_shoestights","clothing_kimono2","clothing_cyboots","clothing_cyzipped","clothing_cystraphood","clothing_goggles","clothing_cyskirt","clothing_cyquif","clothing_cyhood","clothing_cyhair","clothing_cystrappants","clothing_cystrapboots","clothing_cymask","clothing_cyglass","clothing_cygirl","clothing_cycircuit","clothing_cyleather","clothing_cyphones","clothing_frontswirl","clothing_cjersey","clothing_candygirl","clothing_cjumper","clothing_cherries","clothing_cshorts","clothing_habloompa","clothing_cherrybomb","clothing_candyphones","clothing_sidehat","clothing_swirlskirt","clothing_chocodrop","clothing_swirltop","clothing_candyboy","clothing_knitalien","clothing_rank4","clothing_parade","clothing_kevlaroutfit","clothing_militaryjacket","clothing_camooutfit","clothing_napkin","clothing_kevlar","clothing_camoboots","clothing_rank5","clothing_kevlarhat","clothing_medal1","clothing_rank3","clothing_medal3","clothing_drillserg","clothing_rank2","clothing_rank1","clothing_armyskirt","clothing_militarypants","clothing_walkie","clothing_medal2","clothing_camotank","clothing_militaryhat","clothing_camocap","clothing_camotuck","clothing_dinohat","clothing_caveshirt","clothing_cavehair","clothing_dino","clothing_caveman","clothing_hat_skulldino","clothing_breton","clothing_necktie");
UPDATE items_base SET interaction_type = "roller" WHERE item_name IN ("queue_tile1*3","queue_tile1*6","queue_tile1*4","queue_tile1*9","queue_tile1*8","queue_tile1*5","queue_tile1*7","queue_tile1*2","queue_tile1*1","queue_tile1*0","hc_rllr","sf_roller","hween12_track","hween12_track_crl","hween12_track_crr");
UPDATE items_base SET interaction_type = "postit" WHERE item_name IN ("post.it","post.it.vd","post_it");
UPDATE items_base SET interaction_type = "dimmer" WHERE item_name IN ("roomdimmer","dimmer_swtch","dimmer_buttn","dimmer_fuse2","dimmer_fuse6","dimmer_steampunk");
UPDATE items_base SET interaction_type = "rentable_space" WHERE item_name IN ("hblooza_spacerent3x4","hblooza_spacerent6x6","hblooza_spacerent7x7","hblooza_spacerent5x5");
UPDATE items_base SET interaction_type = "pyramid" WHERE item_name IN ("bb_pyramid","wf_pyramid");
UPDATE items_base SET interaction_type = "musicdisc" WHERE item_name IN ("song_disk","nouvelle_trax");
##UPDATE items_base SET interaction_type = "fireworks" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "talking_furni" WHERE item_name IN ("pirate_parrot");
UPDATE items_base SET interaction_type = "water_item" WHERE item_name IN ("bw_boat","bw_sofa","bw_fin","bw_croc","bw_sboard","bw_chair","bw_table","bw_mttrss","bw_fnc_crnr","bw_fnc","bw_boat_p","bw_fnc_g","bw_mttrss_g","bw_mttrss_p","bw_sofa_p","bw_fnc_crnr_g","bw_chair_p","bw_boat_g","bw_fnc_p","bw_sofa_g","bw_fnc_crnr_p");
UPDATE items_base SET interaction_type = "water" WHERE item_name IN ("bw_water_1","bw_water_2");
UPDATE items_base SET interaction_type = "viking_cotie" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "tile_fxprovider_nfs" WHERE item_name IN ("tile_fxprovider_nfs");
##UPDATE items_base SET interaction_type = "mutearea" WHERE item_name IN ("");
##UPDATE items_base SET interaction_type = "information_terminal" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "external_image" WHERE item_name IN ("external_image_wallitem_poster");
UPDATE items_base SET interaction_type = "youtube" WHERE item_name IN ("yttv3","yttv2","yttv1","yttv2b","yttv2n","yttv_retro");
UPDATE items_base SET interaction_type = "jukebox" WHERE item_name IN ("jukebox*1","jukebox_ptv*1","ads_idol_jukebox*1","jukebox_big");
UPDATE items_base SET interaction_type = "switch" WHERE item_name IN ("wf_floor_switch2");
UPDATE items_base SET interaction_type = "fx_box" WHERE item_name IN ("fxbox_fx147","fxbox_fx92","fxbox_fx123","fxbox_fx153","fxbox_fx152","fxbox_fx116","fxbox_fx125","fxbox_fx143","fxbox_fx127","fxbox_fx126","fxbox_fx183","fxbox_fx14","fxbox_fx192");
UPDATE items_base SET interaction_type = "blackhole" WHERE item_name IN ("hole","hole1x1","hole3","hole4");
##UPDATE items_base SET interaction_type = "effect_toggle" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "room_o_matic" WHERE item_name IN ("room_hall15_ele");
##UPDATE items_base SET interaction_type = "effect_tile" WHERE item_name IN ("");
UPDATE items_base SET interaction_type = "sticky_pole" WHERE item_name IN ("note_tag");
 
UPDATE items_base SET interaction_type = "wf_trg_walks_on_furni" WHERE item_name IN ("wf_trg_walks_on_furni");
UPDATE items_base SET interaction_type = "wf_trg_walks_off_furni" WHERE item_name IN ("wf_trg_walks_off_furni");
UPDATE items_base SET interaction_type = "wf_trg_enter_room" WHERE item_name IN ("wf_trg_enter_room");
UPDATE items_base SET interaction_type = "wf_trg_says_something" WHERE item_name IN ("wf_trg_says_something");
UPDATE items_base SET interaction_type = "wf_trg_periodically" WHERE item_name IN ("wf_trg_periodically");
UPDATE items_base SET interaction_type = "wf_trg_period_long" WHERE item_name IN ("wf_trg_period_long");
UPDATE items_base SET interaction_type = "wf_trg_state_changed" WHERE item_name IN ("wf_trg_state_changed");
UPDATE items_base SET interaction_type = "wf_trg_at_given_time" WHERE item_name IN ("wf_trg_at_given_time");
UPDATE items_base SET interaction_type = "wf_trg_at_time_long" WHERE item_name IN ("wf_trg_at_time_long");
UPDATE items_base SET interaction_type = "wf_trg_collision" WHERE item_name IN ("wf_trg_collision");
UPDATE items_base SET interaction_type = "wf_trg_game_starts" WHERE item_name IN ("wf_trg_game_starts");
UPDATE items_base SET interaction_type = "wf_trg_game_ends" WHERE item_name IN ("wf_trg_game_ends");
UPDATE items_base SET interaction_type = "wf_trg_bot_reached_stf" WHERE item_name IN ("wf_trg_bot_reached_stf");
UPDATE items_base SET interaction_type = "wf_trg_bot_reached_avtr" WHERE item_name IN ("wf_trg_bot_reached_avtr");
UPDATE items_base SET interaction_type = "wf_trg_says_command" WHERE item_name IN ("wf_trg_says_command");
UPDATE items_base SET interaction_type = "wf_trg_score_achieved" WHERE item_name IN ("wf_trg_score_achieved");

UPDATE items_base SET interaction_type = "wf_act_toggle_state" WHERE item_name IN ("wf_act_toggle_state");
UPDATE items_base SET interaction_type = "wf_act_reset_timers" WHERE item_name IN ("wf_act_reset_timers");
UPDATE items_base SET interaction_type = "wf_act_match_to_sshot" WHERE item_name IN ("wf_act_match_to_sshot");
UPDATE items_base SET interaction_type = "wf_act_move_rotate" WHERE item_name IN ("wf_act_move_rotate");
UPDATE items_base SET interaction_type = "wf_act_give_score" WHERE item_name IN ("wf_act_give_score");
UPDATE items_base SET interaction_type = "wf_act_show_message" WHERE item_name IN ("wf_act_show_message");
UPDATE items_base SET interaction_type = "wf_act_teleport_to" WHERE item_name IN ("wf_act_teleport_to");
UPDATE items_base SET interaction_type = "wf_act_join_team" WHERE item_name IN ("wf_act_join_team");
UPDATE items_base SET interaction_type = "wf_act_leave_team" WHERE item_name IN ("wf_act_leave_team");
UPDATE items_base SET interaction_type = "wf_act_chase" WHERE item_name IN ("wf_act_chase");
UPDATE items_base SET interaction_type = "wf_act_flee" WHERE item_name IN ("wf_act_flee");
UPDATE items_base SET interaction_type = "wf_act_move_to_dir" WHERE item_name IN ("wf_act_move_to_dir");
UPDATE items_base SET interaction_type = "wf_act_give_score_tm" WHERE item_name IN ("wf_act_give_score_tm");
UPDATE items_base SET interaction_type = "wf_act_toggle_to_rnd" WHERE item_name IN ("wf_act_toggle_to_rnd");
UPDATE items_base SET interaction_type = "wf_act_move_furni_to" WHERE item_name IN ("wf_act_move_furni_to");
UPDATE items_base SET interaction_type = "wf_act_give_reward" WHERE item_name IN ("wf_act_give_reward");
UPDATE items_base SET interaction_type = "wf_act_call_stacks" WHERE item_name IN ("wf_act_call_stacks");
UPDATE items_base SET interaction_type = "wf_act_kick_user" WHERE item_name IN ("wf_act_kick_user");
UPDATE items_base SET interaction_type = "wf_act_mute_triggerer" WHERE item_name IN ("wf_act_mute_triggerer");
UPDATE items_base SET interaction_type = "wf_act_bot_teleport" WHERE item_name IN ("wf_act_bot_teleport");
UPDATE items_base SET interaction_type = "wf_act_bot_move" WHERE item_name IN ("wf_act_bot_move");
UPDATE items_base SET interaction_type = "wf_act_bot_talk" WHERE item_name IN ("wf_act_bot_talk");
UPDATE items_base SET interaction_type = "wf_act_bot_give_handitem" WHERE item_name IN ("wf_act_bot_give_handitem");
UPDATE items_base SET interaction_type = "wf_act_bot_follow_avatar" WHERE item_name IN ("wf_act_bot_follow_avatar");
UPDATE items_base SET interaction_type = "wf_act_bot_clothes" WHERE item_name IN ("wf_act_bot_clothes");
UPDATE items_base SET interaction_type = "wf_act_bot_talk_to_avatar" WHERE item_name IN ("wf_act_bot_talk_to_avatar");
UPDATE items_base SET interaction_type = "wf_act_give_diamonds" WHERE item_name IN ("wf_act_give_diamonds");
UPDATE items_base SET interaction_type = "wf_act_give_credits" WHERE item_name IN ("wf_act_give_credits");
UPDATE items_base SET interaction_type = "wf_act_give_duckets" WHERE item_name IN ("wf_act_give_duckets");
UPDATE items_base SET interaction_type = "wf_act_give_badge" WHERE item_name IN ("wf_act_give_badge");
UPDATE items_base SET interaction_type = "wf_act_forward_user" WHERE item_name IN ("wf_act_forward_user");
UPDATE items_base SET interaction_type = "wf_act_roller_speed" WHERE item_name IN ("wf_act_roller_speed");
UPDATE items_base SET interaction_type = "wf_act_raise_furni" WHERE item_name IN ("wf_act_raise_furni");
UPDATE items_base SET interaction_type = "wf_act_lower_furni" WHERE item_name IN ("wf_act_lower_furni");
UPDATE items_base SET interaction_type = "wf_act_give_respect" WHERE item_name IN ("wf_act_give_respect");
UPDATE items_base SET interaction_type = "wf_act_alert" WHERE item_name IN ("wf_act_alert");

UPDATE items_base SET interaction_type = "wf_cnd_has_furni_on" WHERE item_name IN ("wf_cnd_has_furni_on");
UPDATE items_base SET interaction_type = "wf_cnd_furnis_hv_avtrs" WHERE item_name IN ("wf_cnd_furnis_hv_avtrs");
UPDATE items_base SET interaction_type = "wf_cnd_stuff_is" WHERE item_name IN ("wf_cnd_stuff_is");
UPDATE items_base SET interaction_type = "wf_cnd_actor_in_group" WHERE item_name IN ("wf_cnd_actor_in_group");
UPDATE items_base SET interaction_type = "wf_cnd_user_count_in" WHERE item_name IN ("wf_cnd_user_count_in");
UPDATE items_base SET interaction_type = "wf_cnd_wearing_effect" WHERE item_name IN ("wf_cnd_wearing_effect");
UPDATE items_base SET interaction_type = "wf_cnd_wearing_badge" WHERE item_name IN ("wf_cnd_wearing_badge");
UPDATE items_base SET interaction_type = "wf_cnd_time_less_than" WHERE item_name IN ("wf_cnd_time_less_than");
UPDATE items_base SET interaction_type = "wf_cnd_match_snapshot" WHERE item_name IN ("wf_cnd_match_snapshot");
UPDATE items_base SET interaction_type = "wf_cnd_time_more_than" WHERE item_name IN ("wf_cnd_time_more_than");
UPDATE items_base SET interaction_type = "wf_cnd_not_furni_on" WHERE item_name IN ("wf_cnd_not_furni_on");
UPDATE items_base SET interaction_type = "wf_cnd_not_hv_avtrs" WHERE item_name IN ("wf_cnd_not_hv_avtrs");
UPDATE items_base SET interaction_type = "wf_cnd_not_stuff_is" WHERE item_name IN ("wf_cnd_not_stuff_is");
UPDATE items_base SET interaction_type = "wf_cnd_not_user_count" WHERE item_name IN ("wf_cnd_not_user_count");
UPDATE items_base SET interaction_type = "wf_cnd_not_wearing_fx" WHERE item_name IN ("wf_cnd_not_wearing_fx");
UPDATE items_base SET interaction_type = "wf_cnd_not_wearing_b" WHERE item_name IN ("wf_cnd_not_wearing_b");
UPDATE items_base SET interaction_type = "wf_cnd_not_in_group" WHERE item_name IN ("wf_cnd_not_in_group");
UPDATE items_base SET interaction_type = "wf_cnd_not_in_team" WHERE item_name IN ("wf_cnd_not_in_team");
UPDATE items_base SET interaction_type = "wf_cnd_not_match_snap" WHERE item_name IN ("wf_cnd_not_match_snap");
UPDATE items_base SET interaction_type = "wf_cnd_not_trggrer_on" WHERE item_name IN ("wf_cnd_not_trggrer_on");
UPDATE items_base SET interaction_type = "wf_cnd_actor_in_team" WHERE item_name IN ("wf_cnd_actor_in_team");
UPDATE items_base SET interaction_type = "wf_cnd_trggrer_on_frn" WHERE item_name IN ("wf_cnd_trggrer_on_frn");
UPDATE items_base SET interaction_type = "wf_cnd_has_handitem" WHERE item_name IN ("wf_cnd_has_handitem");
UPDATE items_base SET interaction_type = "wf_cnd_date_rng_active" WHERE item_name IN ("wf_cnd_date_rng_active");
UPDATE items_base SET interaction_type = "wf_cnd_motto_contains" WHERE item_name IN ("wf_cnd_motto_contains");
UPDATE items_base SET interaction_type = "wf_cnd_battlebanzai" WHERE item_name IN ("wf_cnd_battlebanzai");
UPDATE items_base SET interaction_type = "wf_cnd_not_battlebanzai" WHERE item_name IN ("wf_cnd_not_battlebanzai");
UPDATE items_base SET interaction_type = "wf_cnd_freeze" WHERE item_name IN ("wf_cnd_freeze");
UPDATE items_base SET interaction_type = "wf_cnd_not_freeze" WHERE item_name IN ("wf_cnd_not_freeze");

UPDATE items_base SET interaction_type = "wf_xtra_random" WHERE item_name IN ("wf_xtra_random");
UPDATE items_base SET interaction_type = "wf_xtra_unseen" WHERE item_name IN ("wf_xtra_unseen");
 
UPDATE items_base SET interaction_type = "wf_highscore" WHERE item_name IN ("blackholehighscore_classic*1","highscore_classic*2","highscore_classic*3","highscore_classic*4","highscore_perteam*1","highscore_perteam*2","highscore_perteam*3","highscore_perteam*4","highscore_mostwin*1","highscore_mostwin*2","highscore_mostwin*3","highscore_mostwin*4");
 
UPDATE items_base SET interaction_type = "battlebanzai_timer" WHERE item_name IN ("bb_counter");
UPDATE items_base SET interaction_type = "battlebanzai_tile" WHERE item_name IN ("bb_patch1");
UPDATE items_base SET interaction_type = "battlebanzai_random_teleport" WHERE item_name IN ("bb_rnd_tele");
UPDATE items_base SET interaction_type = "battlebanzai_sphere" WHERE item_name IN ("bb_apparatus");
 
UPDATE items_base SET interaction_type = "battlebanzai_gate_blue" WHERE item_name IN ("bb_gate_b");
UPDATE items_base SET interaction_type = "battlebanzai_gate_green" WHERE item_name IN ("bb_gate_g");
UPDATE items_base SET interaction_type = "battlebanzai_gate_red" WHERE item_name IN ("bb_gate_r");
UPDATE items_base SET interaction_type = "battlebanzai_gate_yellow" WHERE item_name IN ("bb_gate_y");
 
UPDATE items_base SET interaction_type = "battlebanzai_counter_blue" WHERE item_name IN ("bb_score_b");
UPDATE items_base SET interaction_type = "battlebanzai_counter_green" WHERE item_name IN ("bb_score_g");
UPDATE items_base SET interaction_type = "battlebanzai_counter_red" WHERE item_name IN ("bb_score_r");
UPDATE items_base SET interaction_type = "battlebanzai_counter_yellow" WHERE item_name IN ("bb_score_y");
 
 
UPDATE items_base SET interaction_type = "freeze_block" WHERE item_name IN ("es_box");
UPDATE items_base SET interaction_type = "freeze_tile" WHERE item_name IN ("es_tile");
UPDATE items_base SET interaction_type = "freeze_exit" WHERE item_name IN ("es_exit");
UPDATE items_base SET interaction_type = "freeze_timer" WHERE item_name IN ("es_counter");
 
UPDATE items_base SET interaction_type = "freeze_gate_blue" WHERE item_name IN ("es_gate_b");
UPDATE items_base SET interaction_type = "freeze_gate_green" WHERE item_name IN ("es_gate_g");
UPDATE items_base SET interaction_type = "freeze_gate_red" WHERE item_name IN ("es_gate_r");
UPDATE items_base SET interaction_type = "freeze_gate_yellow" WHERE item_name IN ("es_gate_y");
 
UPDATE items_base SET interaction_type = "freeze_counter_blue" WHERE item_name IN ("es_score_b");
UPDATE items_base SET interaction_type = "freeze_counter_green" WHERE item_name IN ("es_score_g");
UPDATE items_base SET interaction_type = "freeze_counter_red" WHERE item_name IN ("es_score_r");
UPDATE items_base SET interaction_type = "freeze_counter_yellow" WHERE item_name IN ("es_score_y");
 
UPDATE items_base SET interaction_type = "icetag_pole" WHERE item_name IN ("es_tagging");
UPDATE items_base SET interaction_type = "icetag_field" WHERE item_name IN ("es_skating_ice");
 
UPDATE items_base SET interaction_type = "bunnyrun_pole" WHERE item_name IN ("easter11_tag");
UPDATE items_base SET interaction_type = "bunnyrun_field" WHERE item_name IN ("easter11_grasspatch");
 
UPDATE items_base SET interaction_type = "rollerskate_field" WHERE item_name IN ("val11_floor");
 
UPDATE items_base SET interaction_type = "football" WHERE item_name IN ("fball_ball3","fball_ball","fball_ball2","fball_ball5","fball_ball4");
UPDATE items_base SET interaction_type = "football_gate" WHERE item_name IN ("fball_gate");
UPDATE items_base SET interaction_type = "football_counter_blue" WHERE item_name IN ("fball_score_b");
UPDATE items_base SET interaction_type = "football_counter_green" WHERE item_name IN ("fball_score_g");
UPDATE items_base SET interaction_type = "football_counter_red" WHERE item_name IN ("fball_score_r");
UPDATE items_base SET interaction_type = "football_counter_yellow" WHERE item_name IN ("fball_score_y");
UPDATE items_base SET interaction_type = "football_goal_blue" WHERE item_name IN ("fball_goal_b");
UPDATE items_base SET interaction_type = "football_goal_green" WHERE item_name IN ("fball_goal_g");
UPDATE items_base SET interaction_type = "football_goal_red" WHERE item_name IN ("fball_goal_r");
UPDATE items_base SET interaction_type = "football_goal_yellow" WHERE item_name IN ("fball_goal_y");
 
##UPDATE items_base SET interaction_type = "snowstorm_tree" WHERE item_name IN ("");
##UPDATE items_base SET interaction_type = "snowstorm_machine" WHERE item_name IN ("");
##UPDATE items_base SET interaction_type = "snowstorm_pile" WHERE item_name IN ("");

Feel free to contribute down below with what is missing! (obv. more gates)