ALTER table users ADD staff_twitter varchar(50);
ALTER table users ADD staff_facebook varchar(50);
ALTER table users ADD forgot_ticket varchar(50);
ALTER table users ADD facebook_id varchar(50);
ALTER table users ADD pin varchar(50);
ALTER table users ADD facebook_change varchar(50);
ALTER table users ADD facebook varchar(50);
ALTER table users ADD staff_background_url text(500);
ALTER table users ADD staff_ocult varchar(50) DEFAULT '0';
ALTER table users ADD role varchar(50);
ALTER table users ADD country_cf varchar(50) DEFAULT 'ec';
ALTER table users ADD last_used varchar(50) DEFAULT '0';
ALTER table users ADD refer_count varchar(50) DEFAULT '0';
ALTER table users ADD staff_profileimage_url varchar(150) DEFAULT '0';
ALTER table users ADD block_newfriends varchar(40) DEFAULT '0';
ALTER table users ADD hide_online varchar(40) DEFAULT '0';
CREATE table IF NOT EXISTS `stafflogs` (
`id` int(11) NOT NULL,
`sou bixa` varchar(40) NOT NULL,
`message` varchar(40) NOT NULL,
`note` varchar(40) NOT NULL,
`action` text,
`userid` text,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`targetid` varchar(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7145 ;
DROP table IF EXISTS `cms_news_new`;
CREATE table `cms_news_new` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`story` longtext CHARACTER SET latin1 COLLATE latin1_spanish_ci,
`author` text COLLATE latin1_general_ci,
`time` double NOT NULL,
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(500) COLLATE latin1_general_ci NOT NULL DEFAULT 'https://i.imgur.com/cGV4kO7.gif',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
#
# Data for table "cms_news_new"
#
/*!40000 ALTER table `cms_news_new` DISABLE KEYS */;
INSERT INTO `cms_news_new` VALUES (2,'Te damos la bienvenida a esta gran comunidad.','Te damos la bienvenida a esta gran comunidad.','http://images.habbo.com/c_images/web_promo/wintersport_topstory.gif','Te damos la bienvenida a esta gran comunidad.','yop',1,0,'http://images.habbo.com/c_images/web_promo/wintersport_topstory.gif'),(3,'la bida bale berga','nose :/((((','/Public/Images/news/TS_Web60.png','Sad(((',NULL,1,0,'http://images.habbo.com/c_images/web_promo/searoombundle_l_promo.png'),(63,'asfas','asfasf','/Public/Images/news/TS_Web60.png','<p>asfasf</p>',NULL,0,0,'asfasfas');
/*!40000 ALTER table `cms_news_new` ENABLE KEYS */;