Trade - Email Verified

KiritoP

New Member
Mar 23, 2017
5
0
Hi
When I try to negotiate the following message appears: "This account does not have Exchanges enabled. You can receive Mobis from other Habbos, but you can not give them anything. Check your Preferences and see if your email is enabled."
roj3q7u.png

Could someone pass me the "email_verified" line so I can add it to my DB? Or if someone has another solution to this error, please help me.
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(250) DEFAULT NULL,
`username` varchar(125) CHARACTER SET latin1 DEFAULT NULL,
`real_name` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`auth_ticket` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
`working` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
`mymusik` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
`secretcode` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
`rank` int(1) unsigned DEFAULT '1',
`vip_points` int(11) DEFAULT '0',
`credits` int(11) DEFAULT '35000',
`activity_points` int(11) DEFAULT '3500',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`diamonds` int(11) NOT NULL DEFAULT '0',
`look` char(255) CHARACTER SET latin1 DEFAULT NULL,
`gender` enum('M','F') CHARACTER SET latin1 NOT NULL DEFAULT 'M',
`motto` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`mail` varchar(255) NOT NULL DEFAULT 'undefined',
`account_created` double(50,0) NOT NULL DEFAULT '0',
`last_online` int(11) NOT NULL DEFAULT '0',
`online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`ip_last` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
`ip_reg` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
`home_room` int(30) DEFAULT '1',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`trade_lock` enum('0','1') DEFAULT '1',
`trade_lock_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('1','0') NOT NULL DEFAULT '0',
`hide_online` enum('1','0') NOT NULL DEFAULT '0',
`hide_inroom` enum('1','0') NOT NULL DEFAULT '0',
`vip` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 18:58:48',
`birth` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
`mysterybox_key_colour` int(11) NOT NULL DEFAULT '0',
`last_name_change` int(11) NOT NULL DEFAULT '0',
`client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
`nux_passed` enum('0','1') NOT NULL DEFAULT '0',
`seckey` varchar(999) NOT NULL DEFAULT '',
`voted` int(11) NOT NULL DEFAULT '0',
`owner` int(99) NOT NULL DEFAULT '0',
`novato` int(99) NOT NULL DEFAULT '0',
`fundom` varchar(255) NOT NULL DEFAULT '#43AC6A',
`builders_expire` int(11) DEFAULT '3700',
`builders_items_max` int(11) NOT NULL DEFAULT '100',
`builders_items_used` int(11) NOT NULL DEFAULT '0',
`release_version` int(11) NOT NULL DEFAULT '2',
`on_duty` enum('0','1','2','3') NOT NULL DEFAULT '0',
`OnDuty` varchar(255) NOT NULL DEFAULT 'false',
`DutyLevel` int(11) NOT NULL DEFAULT '0',
`navilogs` varchar(255) CHARACTER SET latin1 DEFAULT '1,official-root,;2,popular,;3,my,;4,favorites,',
`navigator` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
`allow_pull` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`cms_currency` varchar(255) NOT NULL,
`seashells` int(11) NOT NULL DEFAULT '0',
`trusted` int(11) NOT NULL DEFAULT '0',
`age` varchar(255) NOT NULL,
`role` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL DEFAULT 'Unknown',
`rank_vip` int(1) DEFAULT '3',
`volume` varchar(15) CHARACTER SET latin1 DEFAULT '100,100,100',
`last_change` int(20) DEFAULT '0',
`machine_id` varchar(125) CHARACTER SET latin1 DEFAULT NULL,
`focus_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`chat_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`pets_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`bots_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`advertising_report_blocked` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`gotw_points` int(11) DEFAULT '0',
`ignore_invites` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
`time_muted` double DEFAULT '0',
`allow_gifts` enum('0','1') CHARACTER SET latin1 DEFAULT '1',
`trading_locked` double DEFAULT '1',
`friend_bar_state` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
`disable_forced_effects` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`allow_mimic` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '1',
`votos` int(11) DEFAULT NULL,
`pin` int(11) DEFAULT NULL,
`photo_perfil` varchar(255) NOT NULL,
`portada` varchar(255) DEFAULT NULL,
`seasonal_currency` int(11) NOT NULL DEFAULT '40',
`refer_points` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`refer_count` varchar(50) DEFAULT '0',
`last_used` varchar(50) DEFAULT '0',
`facebook_change` varchar(50) DEFAULT '0',
`loyalty_points` int(11) NOT NULL DEFAULT '0',
`staff_twitter` varchar(50) DEFAULT NULL,
`staff_facebook` varchar(50) DEFAULT NULL,
`forgot_ticket` varchar(50) DEFAULT NULL,
`facebook_id` varchar(50) DEFAULT NULL,
`facebook` int(50) DEFAULT NULL,
`staff_background_url` text,
`staff_ocult` varchar(50) DEFAULT '0',
`country_cf` varchar(50) DEFAULT 'ec',
`staff_profileimage_url` varchar(150) DEFAULT '0',
`belcredits` int(11) NOT NULL DEFAULT '30',
`radio` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
`cookies` int(11) NOT NULL DEFAULT '60',
`facebook_vin` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`homework` varchar(400) CHARACTER SET latin1 NOT NULL,
`RequireChangenameForFacebook` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`birthday` varchar(50) DEFAULT NULL,
`color` varchar(10) CHARACTER SET latin1 NOT NULL,
`points_e` int(11) NOT NULL DEFAULT '0',
`points_p` int(11) NOT NULL DEFAULT '0',
`change_name` int(1) NOT NULL DEFAULT '0',
`cms_birthday` varchar(100) NOT NULL,
`cms_changename` enum('0','1') NOT NULL DEFAULT '0',
`cms_radio` enum('0','1') NOT NULL DEFAULT '1',
`cms_refers` int(10) NOT NULL DEFAULT '0',
`cms_pbackground` varchar(200) NOT NULL DEFAULT '',
`cms_pprofile` varchar(200) NOT NULL DEFAULT '/gallery/images/dftl_perfil.png',
`cms_twitter` varchar(100) NOT NULL,
`cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
`cms_style` enum('default','gold','note','girl','block','speech','silver','hc') NOT NULL DEFAULT 'default',
`cms_video` varchar(50) NOT NULL,
`cms_pin` varchar(10) NOT NULL,
`cms_role` varchar(50) NOT NULL,
`staff_pin` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;
 

JynX

Posting Freak
Feb 6, 2016
710
438
ALTER TABLE `users` ADD `email_verified` ENUM('0','1') DEFAULT '1';
SQL is a great thing to know, OR knowing how to use a database manager like Navicat :p
 

Users who are viewing this thread

Top