Arrumando erro do Housekeeping (phoenix cms).
Olá galera, neste tutorial eu irei ensinar a vocês como que arruma o erro do housekeeping da phoenix cms,
irei passar para vocês um Fix que sera usado para poder concertar o erro.
Fix abaixo:
Copie este Fix,va na sua Data Base // Delete a tabela '' permissions_ranks '' // vá em SQL // cole o codigo (fix) // depois clique em executar (1 vs, se clicar 2 pode bugar).
Pronto agora so logar no seu hotel.
Atenção:
delete a tabela "permissions_ranks", se não pode dar erro na sua DB ''
~ Creditos:
* Weizzer - Criar e postar o tópico.
Olá galera, neste tutorial eu irei ensinar a vocês como que arruma o erro do housekeeping da phoenix cms,
irei passar para vocês um Fix que sera usado para poder concertar o erro.
Fix abaixo:
- Spoiler:
- 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');
Copie este Fix,va na sua Data Base // Delete a tabela '' permissions_ranks '' // vá em SQL // cole o codigo (fix) // depois clique em executar (1 vs, se clicar 2 pode bugar).
Pronto agora so logar no seu hotel.
Atenção:
delete a tabela "permissions_ranks", se não pode dar erro na sua DB ''
~ Creditos:
* Weizzer - Criar e postar o tópico.