[fix] housekeeping phoenix cms

Olá galera, venho aki através deste topico, compartilhar com vocês um fix para a db do Phoenix Cms'!

Muita gente vem tendo problemas com a db do Phoenix, quando se usa em outras cms .. Mais algumas cms's estao com problema de quando voce tenta acessar o housekeeping! é aquele de nao aparecer o botao de administração, e quando tenta acessar seusite../housekeeping volta para a me.php :S

Como resolver -

Va na sua db exclua a tabela "permissions_ranks"

Va em SQL, cole e clike em executar o seguinte codigo:

CREATE TABLE IF NOT EXISTS `permissions_ranks` ( `rank` int(1) unsigned NOT NULL, `cmd_update_permissions` enum('1','0') NOT NULL, `cmd_update_settings` enum('1','0') NOT NULL, `cmd_update_bots` enum('1','0') NOT NULL, `cmd_update_catalogue` enum('1','0') NOT NULL, `cmd_update_navigator` enum('1','0') NOT NULL, `cmd_update_items` enum('1','0') NOT NULL, `cmd_award` enum('1','0') NOT NULL, `cmd_coords` enum('1','0') NOT NULL, `cmd_override` enum('1','0') NOT NULL, `cmd_coins` enum('1','0') NOT NULL, `cmd_pixels` enum('1','0') NOT NULL, `cmd_ha` enum('1','0') NOT NULL, `cmd_hal` enum('1','0') NOT NULL, `cmd_freeze` enum('1','0') NOT NULL, `cmd_enable` enum('1','0') NOT NULL, `cmd_roommute` enum('1','0') NOT NULL, `cmd_setspeed` enum('1','0') NOT NULL, `cmd_masscredits` enum('1','0') NOT NULL, `cmd_globalcredits` enum('1','0') NOT NULL, `cmd_roombadge` enum('1','0') NOT NULL, `cmd_massbadge` enum('1','0') NOT NULL, `cmd_userinfo` enum('1','0') NOT NULL, `cmd_shutdown` enum('1','0') NOT NULL, `cmd_givebadge` enum('1','0') NOT NULL, `cmd_invisible` enum('1','0') NOT NULL, `cmd_ban` enum('1','0') NOT NULL, `cmd_superban` enum('1','0') NOT NULL, `cmd_roomkick` enum('1','0') NOT NULL, `cmd_roomalert` enum('1','0') NOT NULL, `cmd_mute` enum('1','0') NOT NULL, `cmd_unmute` enum('1','0') NOT NULL, `cmd_alert` enum('1','0') NOT NULL, `cmd_motd` enum('1','0') NOT NULL, `cmd_kick` enum('1','0') NOT NULL, `cmd_update_filter` enum('1','0') NOT NULL, `acc_anyroomrights` enum('1','0') NOT NULL, `acc_anyroomowner` enum('1','0') NOT NULL, `acc_supporttool` enum('1','0') NOT NULL, `acc_chatlogs` enum('1','0') NOT NULL, `acc_enter_fullrooms` enum('1','0') NOT NULL, `acc_enter_anyroom` enum('1','0') NOT NULL, `acc_restrictedrooms` enum('1','0') NOT NULL, `acc_unkickable` enum('1','0') NOT NULL, `acc_unbannable` enum('1','0') NOT NULL, `cmd_removebadge` enum('1','0') NOT NULL DEFAULT '0', `cmd_summon` enum('1','0') NOT NULL DEFAULT '0', `cmd_update_bans` enum('1','0') NOT NULL DEFAULT '0', `hk_login` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_basics` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_news` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_users` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_rooms` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_edit` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_mod` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_voucher` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_badge` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_ban` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_iplookup` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_delete` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_ha` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_ext_login` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_permissions` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_plugins` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `hk_cmsalerts` enum('1','0') NOT NULL DEFAULT '0', `hk_badgeshop` enum('1','0') NOT NULL DEFAULT '0', `hk_rare` enum('1','0') NOT NULL DEFAULT '0', PRIMARY KEY (`rank`), UNIQUE KEY `rank` (`rank`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Extraindo dados da tabela `permissions_ranks` -- INSERT INTO `permissions_ranks` (`rank`, `cmd_update_permissions`, `cmd_update_settings`, `cmd_update_bots`, `cmd_update_catalogue`, `cmd_update_navigator`, `cmd_update_items`, `cmd_award`, `cmd_coords`, `cmd_override`, `cmd_coins`, `cmd_pixels`, `cmd_ha`, `cmd_hal`, `cmd_freeze`, `cmd_enable`, `cmd_roommute`, `cmd_setspeed`, `cmd_masscredits`, `cmd_globalcredits`, `cmd_roombadge`, `cmd_massbadge`, `cmd_userinfo`, `cmd_shutdown`, `cmd_givebadge`, `cmd_invisible`, `cmd_ban`, `cmd_superban`, `cmd_roomkick`, `cmd_roomalert`, `cmd_mute`, `cmd_unmute`, `cmd_alert`, `cmd_motd`, `cmd_kick`, `cmd_update_filter`, `acc_anyroomrights`, `acc_anyroomowner`, `acc_supporttool`, `acc_chatlogs`, `acc_enter_fullrooms`, `acc_enter_anyroom`, `acc_restrictedrooms`, `acc_unkickable`, `acc_unbannable`, `cmd_removebadge`, `cmd_summon`, `cmd_update_bans`, `hk_login`, `hk_basics`, `hk_news`, `hk_users`, `hk_rooms`, `hk_edit`, `hk_mod`, `hk_voucher`, `hk_badge`, `hk_ban`, `hk_iplookup`, `hk_delete`, `hk_ha`, `hk_ext_login`, `hk_permissions`, `hk_plugins`, `hk_cmsalerts`, `hk_badgeshop`, `hk_rare`) VALUES (1, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), (2, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), (3, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), (4, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0'), (5, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '1', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '1', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0'), (6, '1', '0', '0', '0', '0', '0', '1', '1', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '1', '1', '0', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '0', '0'), (7, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');

Isso deve resolver, dai é so logar no seu hotel e pronto
Obs: Delete a tabela "permissions_ranks", caso contrario dara erro na sua db :X