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:
Código:
Obs: Delete a tabela "permissions_ranks", caso contrario dara erro na sua db :X
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:
Código:
- Código:
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');
Obs: Delete a tabela "permissions_ranks", caso contrario dara erro na sua db :X
Qui Set 08, 2011 12:32 am por Dj.Gui
» Huber hotel [V65] / Wired / Mobis / S / Hamachi
Qui Set 08, 2011 12:32 am por Dj.Gui
» [V67] Habblinf Hotel [V67]
Qui Set 08, 2011 12:31 am por Dj.Gui
» Free Hotel 24 horas - sua diverção esta aki
Qui Set 08, 2011 12:30 am por Dj.Gui
» Happy Hotel/Atualização/Vagas/Phoenix/Macaco/Tartaruga/Wired 24 Horas
Qui Set 08, 2011 12:29 am por Dj.Gui
» [Point-Hotel] O Melhor! [COM VAGAS]
Qui Set 08, 2011 12:28 am por Dj.Gui
» mCMS r9 - The Best of Powerfull Design [Lancado]
Qui Set 08, 2011 12:25 am por Dj.Gui
» FireEMU 58+ ViP
Qui Set 08, 2011 12:24 am por Dj.Gui
» [Download] DrabboCMS
Qua Set 07, 2011 7:33 pm por Dj.Gui