[FIX] VEJA SE TEM O SEU FIX [FIX] 01.08.15 21:24
Ola amigos, hoje eu venho trazer varios tipos de fix para a sua DataBase. Para inserir essas tabela , você deve entrar em seu banco de dados procurar pela aba SQL, e logo em seguida colocar na caixa SQL o seu FIX.
table 'habbo.credit_vouchers' doesn't exist
table 'habbo.user_tickets' doesn't exist
table 'habbo.users_referidos' doesn't exist
Unknown column 'working' in 'field list'
table_home_stickers does'n exists
table 'habbo.site_cron' doesn't exist
table 'habbo.site_config' doesn't exist
table 'habbo.site_navi' doesn't exist
table 'habbo.site_hotcampaigns' doesn't exist
table 'habbo.site_news' doesn't exist
table 'habbo.rankevento' doesn't exist
table 'habbo.rankcampanha' doesn't exist
table 'habbo.promos' doesn't exist
Toda semana irei disponibilizar 1 lista de fix.
table 'habbo.credit_vouchers' doesn't exist
- Código:
[/i]-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Abr 02, 2014 as 06:48 PM
-- Versão do Servidor: 5.5.10
-- Versão do PHP: 5.3.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Banco de Dados: `br`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `credit_vouchers`
--
CREATE tab[b][/b]le IF NOT EXISTS `credit_vouchers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(50) NOT NULL,
`value` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `code` (`code`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;
--
-- Extraindo dados da tabela `credit_vouchers`
--[i]
table 'habbo.user_tickets' doesn't exist
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table 'habbo.users_referidos' doesn't exist
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `users_referidos` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`usuario` VARCHAR(400) NOT NULL DEFAULT 'user',
`ip_referida` VARCHAR(50) NOT NULL,
`fecha` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Unknown column 'working' in 'field list'
- Código:
ALTER tab[b][/b]le `users` ADD COLUMN `working` varchar(50) NOT NULL DEFAULT '0'
table_home_stickers does'n exists
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `homes_stickers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`x` varchar(6) NOT NULL DEFAULT '1' COMMENT 'left',
`y` varchar(6) NOT NULL DEFAULT '1' COMMENT 'top',
`z` varchar(6) NOT NULL DEFAULT '1' COMMENT 'boder:',
`data` text NOT NULL,
`type` varchar(1) NOT NULL DEFAULT '1',
`subtype` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Widget Type (if widget)',
`skin` text NOT NULL,
`groupid` int(11) NOT NULL DEFAULT '-1',
`var` int(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51;
table 'habbo.site_cron' doesn't exist
- Código:
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `site_cron`
--
CREATE tab[b][/b]le IF NOT EXISTS `site_cron` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`prio` int(11) NOT NULL DEFAULT '5',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`scriptfile` varchar(50) NOT NULL,
`last_exec` int(11) NOT NULL,
`exec_every` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Volcar la base de datos para la tabla `site_cron`
--
INSERT INTO `site_cron` (`id`, `prio`, `enabled`, `scriptfile`, `last_exec`, `exec_every`) VALUES
(1, 5, '1', 'mod_forum.php', 1294136489, 7200),
(2, 4, '1', 'moderation_cleanup.php', 1294136489, 7200),
(3, 5, '1', 'respect.php', 1294057638, 86400),
(4, 5, '1', 'serverstat.php', 1294143103, 120),
(5, 3, '1', 'credits.php', 1294139967, 10800);
--
table 'habbo.site_config' doesn't exist
- Código:
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `site_config`
--
CREATE tab[b][/b]le IF NOT EXISTS `site_config` (
`maintenance` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcar la base de datos para la tabla `site_config`
--
INSERT INTO `site_config` (`maintenance`) VALUES
('0');
--
table 'habbo.site_navi' doesn't exist
- Código:
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `site_navi`
--
CREATE tab[b][/b]le IF NOT EXISTS `site_navi` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`order_id` int(11) NOT NULL,
`caption` text NOT NULL,
`class` text NOT NULL,
`url` text NOT NULL,
`visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Volcar la base de datos para la tabla `site_navi`
--
INSERT INTO `site_navi` (`id`, `parent_id`, `order_id`, `caption`, `class`, `url`, `visibility`) VALUES
(1, 0, 1, '%habboName%', 'metab', '%www%/me', '2'),
(2, 1, 1, 'Inicio', '', '/me', '2'),
(5, 0, 2, 'Comunidad', '', '%www%/community', '1'),
(4, 1, 3, 'Ajustes', '', '%www%/profile', '2'),
(6, 0, 3, 'Creditos', '', '%www%/credits', '1'),
(7, 5, 1, 'Comunidad', '', '%www%/community', '1'),
(8, 0, 1, 'Registrate!', 'tab-register-now', '%www%/register', '3'),
(9, 6, 1, 'Creditos', '', '%www%/credits', '1'),
(10, 6, 3, 'Pixeles', '', '%www%/credits/pixels', '1'),
(11, 6, 2, 'Habbo Club', '', '%www%/credits/uberclub', '1'),
(20, 12, 1, 'Consejos de Seguridad', '', '%www%/ConsejosdeSeguridad.php', '1'),
(13, 12, 1, 'La Manera Habbo', '', '%www%/LaManeraHabbo.php', '2'),
(14, 1, 2, 'Mi Pagina', '', '%www%/home/%habboName%', '2'),
(15, 1, 4, 'Habbo Club', '', '%www%/credits/uberclub', '2'),
(16, 5, 3, 'Habbo Staff', '', '%www%/community/staff', '1'),
(17, 5, 2, 'Noticias', '', '%www%/articles', '1'),
(18, 12, 2, 'Guia para Padres', '', '%www%/GuiaPadres.php', '2'),
(12, 0, 4, 'Seguridad', '', '%www%/ConsejosdeSeguridad.php', '1'),
(25, 5, 4, 'Usuarios Online', '', '%www%/online.php', '1'),
(26, 5, 5, 'Reglas', '', '%www%/reglas.php', '1'),
(27, 1, 5, 'Mis Placas', '', '%www%/misplacas.php', '1'),
(22, 5, 5, 'Rangos', '', '/app.php', '1'),
(21, 5, 5, 'VIP', '', '/vip.php', '1');
table 'habbo.site_hotcampaigns' doesn't exist
- Código:
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `site_hotcampaigns`
--
CREATE tab[b][/b]le IF NOT EXISTS `site_hotcampaigns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`image_url` text NOT NULL,
`caption` text NOT NULL,
`descr` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Volcar la base de datos para la tabla `site_hotcampaigns`
--
INSERT INTO `site_hotcampaigns` (`id`, `order_id`, `enabled`, `image_url`, `caption`, `descr`, `url`) VALUES
(7, 1, '1', 'http://images.habbo.com/c_images/hot_campaign_images_hq/campaignBtn_wired.gif', 'Wired Furni', 'Una era nueva épica ha comenzado, y usted podría ser parte de todo, El juego de cambiar Furni ya está disponible, necesitan un curso intensivo?', ''),
(9, 1, '1', 'http://images.habbo.com/c_images/hot_campaign_images_hq/campaignButton_xm10_cdscds.gif', 'La Navidad!!', 'La navidad llega a habbosliberty.Ya esta lista la ropa para que no pases frio :D', '');-- --------------------------------------------------------
table 'habbo.site_news' doesn't exist
- Código:
--
-- Estructura de tabla para la tabla `site_news`
--
CREATE tab[b][/b]le IF NOT EXISTS `site_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
`title` text NOT NULL,
`category_id` int(10) unsigned NOT NULL DEFAULT '1',
`topstory_image` text NOT NULL,
`body` text NOT NULL,
`snippet` text NOT NULL,
`datestr` varchar(50) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `site_news`
--
table 'habbo.rankevento' doesn't exist
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `rankevento` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(255) NOT NULL,
`pontos` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
table 'habbo.rankcampanha' doesn't exist
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `rankcampanha` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(255) NOT NULL,
`pontos` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
table 'habbo.promos' doesn't exist
- Código:
CREATE tab[b][/b]le IF NOT EXISTS `promos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usuario` varchar(255) NOT NULL,
`titulo` varchar(255) NOT NULL,
`link` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Toda semana irei disponibilizar 1 lista de fix.