Hi leute wie bekomme ich das weg bitte um hilfe
Hilfe beim Emu
-
-
Die Spalte "enable_cmd_redeempixels" existiert nicht.
-
Such dir ne andere DB und kopier die fehlende Spalte.
-
Ja eben such dir eine die diese Spalte besitzt und importier sie in deine.
-
Importier das:
CodeALTER TABLE `server_settings` ADD `enable_cmd_redeempixels` ENUM('0', '1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `enable_cmd_redeemcredits`, ADD `enable_cmd_redeemshells` ENUM('0', '1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `enable_cmd_redeempixels`; -
PART 1:
SQL
Alles anzeigenINSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_startquestion_name', 'startquestion'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_lay_name', 'lay'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_handitem_name', 'handitem'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_vipha_name', 'vipha'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_vipha_title', 'VIP Alert'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_viphal_name', 'viphal'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_viphal_title', 'VIP Alert'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_spush_name', 'spush'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_roomeffect_name', 'roomeffect'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_redeempixel_name', 'redeempixel'); INSERT INTO `texts` (`identifier`, `display_text`) VALUES ('cmd_redeemshell_name', 'redeemshell'); ALTER TABLE `items` ADD `fw_count` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `seckey` VARCHAR(999) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `last_loggedin` VARCHAR(50) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `vipha_last` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `viphal_last` DOUBLE NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `friend_stream_enabled` ENUM( '0', '1' ) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `lev_custom1` INT( 10 ) NOT NULL DEFAULT '0' AFTER `lev_explore` ; ALTER TABLE `user_stats` ADD `fireworks` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `RegularVisitor` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `FootballGoalScorer` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `FootballGoalHost` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `TilesLocked` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `user_stats` ADD `staff_picks` INT(10) NOT NULL DEFAULT '0'; ALTER TABLE `furniture` CHANGE `interaction_type` `interaction_type` ENUM('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx','firework','wf_act_kick_user','hopper','jukebox','musicdisc','freeze_tile','freeze_counter','freeze_ice_block','freeze_blue_gate','freeze_red_gate','freeze_green_gate','freeze_yellow_gate','freeze_exit','freeze_blue_score','freeze_red_score','freeze_green_score','freeze_yellow_score','wf_act_reset_timers','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_time_less_than') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'default'; ALTER TABLE `furniture` ADD `HeightOverride` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `wired_give_wiredactived` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `wired_cnd_wiredactived` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `wired_unlimitedselects` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_lay` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_push` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_pull` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_flagme` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_mimic` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_moonwalk` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_follow` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_handitem` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_vipha` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_startquestion` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `acc_moveotheruserstodoor` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_viphal` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_spush` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_roomeffect` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `wired_give_wiredactived` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `wired_cnd_wiredactived` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `wired_unlimitedselects` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_lay` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_push` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_pull` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_flagme` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_mimic` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_moonwalk` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_follow` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_handitem` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_vipha` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_startquestion` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `acc_moveotheruserstodoor` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_viphal` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_spush` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_users` ADD `cmd_roomeffect` ENUM('1', '0') NOT NULL DEFAULT '0'; -
Uff, mach einfach diese Updates die im Emu dabei sind.
-
Code
ALTER TABLE `permissions_ranks` ADD `cmd_sign` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_pet` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_viptele` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_alleffect` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_faceless` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD `cmd_vipoverride` ENUM('1','0') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'; -
Code
Alles anzeigenALTER TABLE `permissions_users` ADD COLUMN `cmd_roll` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_rave` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_control` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_makesay` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_dance` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_sitdown` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_exe` enum('0','1') NOT NULL DEFAULT '0'; ALTER TABLE `permissions_ranks` ADD COLUMN `cmd_roll` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_rave` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_control` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_makesay` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_dance` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_sitdown` enum('0','1') NOT NULL DEFAULT '0', ADD COLUMN `cmd_exe` enum('0','1') NOT NULL DEFAULT '0'; INSERT INTO `texts` VALUES ('cmd_dance_desc', ':dance <username> - Make the selected user dance'); INSERT INTO `texts` VALUES ('cmd_exe_desc', ':exe'); INSERT INTO `texts` VALUES ('cmd_makesay_desc', ':makesay <username> <message> - Make the selected user say a message'); INSERT INTO `texts` VALUES ('cmd_rave_desc', ':rave - Make everyone dance'); INSERT INTO `texts` VALUES ('cmd_roll_desc', ':roll <username> <number> - Make a user roll the selected number'); INSERT INTO `texts` VALUES ('cmd_sitdown_desc', ':sitdown - Make everyone sitdown'); INSERT INTO `texts` VALUES ('cmd_control_desc', ':control <username> - Control the selected user'); INSERT INTO `texts` VALUES ('cmd_dance_name', 'dance'); INSERT INTO `texts` VALUES ('cmd_exe_name', 'exe'); INSERT INTO `texts` VALUES ('cmd_makesay_name', 'makesay'); INSERT INTO `texts` VALUES ('cmd_rave_name', 'rave'); INSERT INTO `texts` VALUES ('cmd_roll_name', 'roll'); INSERT INTO `texts` VALUES ('cmd_sitdown_name', 'sitdown'); INSERT INTO `texts` VALUES ('cmd_control_name', 'control'); -
Egal, jetzt hab ich auch kein Bock mehr, wie gesagt, mach einfach die Updates die dabei sind. Ansonsten google einfach "BadgeID Phoenix", klick das erste an und kopier den SQL fertig.
-
-
Öffne catalogue_items -> Design Table -> add und trage dort BadgeID ein und save.
Jetzt mitmachen!
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!