• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook pagefor updates, or we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.)

[Arcturus] Interaction types

Newbie Spellweaver
Joined
Feb 2, 2016
Messages
94
Reaction score
22



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)​
 
Last edited:
Newbie Spellweaver
Joined
Feb 2, 2016
Messages
94
Reaction score
22
Can you put in some of the new interactions?
Arcturus has been discontinued, maybe someone with a nice catalogue with Morningstar could give some updates to the list :love:
 
Back
Top