Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[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