Olá, abaixo estarei postando alguns fixes do emulador Phoenix que ultimamente da bastante erros, pois vamos lá.
1# cmd_masspixels
ALTER ***** `permissions_ranks` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';
DROP ***** IF EXISTS `permissions_vip`;
CREATE ***** `permissions_vip` (
`cmdPush` enum('0','1') NOT NULL DEFAULT '1',
`cmdPull` enum('0','1') NOT NULL DEFAULT '1',
`cmdFlagme` enum('0','1') NOT NULL DEFAULT '1',
`cmdMimic` enum('0','1') NOT NULL DEFAULT '1',
`cmdMoonwalk` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO permissions_vip VALUES ('1', '1', '1', '1', '1');
ALTER ***** `rooms` ADD `achievement` int(11) NOT NULL DEFAULT '0';
ALTER ***** `bots` ADD `effect` int(2) NOT NULL DEFAULT '0';
2# enable_cmdlogs
ALTER ***** `server_settings` ADD `enable_cmdlogs` enum('0','1') NOT NULL DEFAULT '1';
ALTER ***** `server_settings` ADD `allow_friendfurnidrops` enum('0','1') NOT NULL DEFAULT '1';
ALTER ***** `permissions_ranks` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `floodtime` int(3) NOT NULL DEFAULT '30';
ALTER ***** `permissions_ranks` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_vip` ADD `cmdFollow` enum('1','0') NOT NULL DEFAULT '1';
DROP ***** IF EXISTS `cmdlogs`;
CREATE ***** `cmdlogs` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`user_name` varchar(100) NOT NULL,
`command` varchar(50) NOT NULL,
`extra_data` text NOT NULL,
`timestamp` int(120) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP ***** IF EXISTS `texts`;
CREATE ***** `texts` (
`identifier` varchar(50) NOT NULL,
`display_text` text NOT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of texts
-- ----------------------------
INSERT INTO `texts` VALUES ('emu_cleandb', 'Cleaning up database..');
INSERT INTO `texts` VALUES ('emu_connectdb', 'Connecting to database..');
INSERT INTO `texts` VALUES ('emu_loadroles', 'Loading Roles..');
INSERT INTO `texts` VALUES ('emu_loadsettings', 'Loading Settings..');
INSERT INTO `texts` VALUES ('emu_loadtexts', 'Loading Texts..');
ALTER ***** `catalog_pages` ADD `page_link_description` TEXT NOT NULL;
ALTER ***** `catalog_pages` ADD `page_link_pagename` TEXT NOT NULL;
ALTER ***** `catalog_items`
ADD COLUMN `vip` enum('0','1','2') NOT NULL DEFAULT '0';
ALTER ***** `furniture`
MODIFY COLUMN `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') DEFAULT 'default';
3# Expection as ben saved
CREATE ***** IF NOT EXISTS `server_status` (
`status` enum('0','1','2') NOT NULL DEFAULT '0',
`users_online` int(11) NOT NULL DEFAULT '0',
`rooms_loaded` int(11) NOT NULL DEFAULT '0',
`server_ver` text NOT NULL,
`stamp` double NOT NULL,
`userpeak` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1# cmd_masspixels
ALTER ***** `permissions_ranks` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';
DROP ***** IF EXISTS `permissions_vip`;
CREATE ***** `permissions_vip` (
`cmdPush` enum('0','1') NOT NULL DEFAULT '1',
`cmdPull` enum('0','1') NOT NULL DEFAULT '1',
`cmdFlagme` enum('0','1') NOT NULL DEFAULT '1',
`cmdMimic` enum('0','1') NOT NULL DEFAULT '1',
`cmdMoonwalk` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO permissions_vip VALUES ('1', '1', '1', '1', '1');
ALTER ***** `rooms` ADD `achievement` int(11) NOT NULL DEFAULT '0';
ALTER ***** `bots` ADD `effect` int(2) NOT NULL DEFAULT '0';
2# enable_cmdlogs
ALTER ***** `server_settings` ADD `enable_cmdlogs` enum('0','1') NOT NULL DEFAULT '1';
ALTER ***** `server_settings` ADD `allow_friendfurnidrops` enum('0','1') NOT NULL DEFAULT '1';
ALTER ***** `permissions_ranks` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `floodtime` int(3) NOT NULL DEFAULT '30';
ALTER ***** `permissions_ranks` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_ranks` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_users` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
ALTER ***** `permissions_vip` ADD `cmdFollow` enum('1','0') NOT NULL DEFAULT '1';
DROP ***** IF EXISTS `cmdlogs`;
CREATE ***** `cmdlogs` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`user_name` varchar(100) NOT NULL,
`command` varchar(50) NOT NULL,
`extra_data` text NOT NULL,
`timestamp` int(120) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP ***** IF EXISTS `texts`;
CREATE ***** `texts` (
`identifier` varchar(50) NOT NULL,
`display_text` text NOT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of texts
-- ----------------------------
INSERT INTO `texts` VALUES ('emu_cleandb', 'Cleaning up database..');
INSERT INTO `texts` VALUES ('emu_connectdb', 'Connecting to database..');
INSERT INTO `texts` VALUES ('emu_loadroles', 'Loading Roles..');
INSERT INTO `texts` VALUES ('emu_loadsettings', 'Loading Settings..');
INSERT INTO `texts` VALUES ('emu_loadtexts', 'Loading Texts..');
ALTER ***** `catalog_pages` ADD `page_link_description` TEXT NOT NULL;
ALTER ***** `catalog_pages` ADD `page_link_pagename` TEXT NOT NULL;
ALTER ***** `catalog_items`
ADD COLUMN `vip` enum('0','1','2') NOT NULL DEFAULT '0';
ALTER ***** `furniture`
MODIFY COLUMN `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') DEFAULT 'default';
3# Expection as ben saved
CREATE ***** IF NOT EXISTS `server_status` (
`status` enum('0','1','2') NOT NULL DEFAULT '0',
`users_online` int(11) NOT NULL DEFAULT '0',
`rooms_loaded` int(11) NOT NULL DEFAULT '0',
`server_ver` text NOT NULL,
`stamp` double NOT NULL,
`userpeak` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Ter Fev 14, 2012 11:29 am por Revolution
» Saiba como ter muitos "Clicks" na Crazzy! ;D
Ter Fev 14, 2012 10:27 am por #Fu~
» Novo .htaccess ~ PhoenixPHP
Ter Fev 14, 2012 10:25 am por #Fu~
» Catalogo Identico ao Habbo Br
Ter Fev 14, 2012 10:24 am por #Fu~
» Como Abrir Portas Do Modem D-LINK
Ter Fev 14, 2012 10:22 am por #Fu~
» [Tuto] Hospedando Emblema Na SWF Própria
Ter Fev 14, 2012 10:15 am por #Fu~
» Os Hackers Mais Famosos.
Ter Fev 14, 2012 10:05 am por #Fu~
» [Video-Aula] Alterando Preços do Catalogo
Ter Fev 14, 2012 10:03 am por #Fu~
» [Download] GalaxyCMS - A revolução chegou.
Ter Fev 14, 2012 10:02 am por #Fu~