(HELP) Braincms

[Tomgnus]

Hi i try to use Phoenix emulator a R63 hotell beside Braincms but here is the wired part, i can make the acc, but when i sing out and tryin to login agian its just tells me that the password is wrong and i am 100% typing it right, any way to fix this?

Post automatically merged: Jun 23, 2019

but if i take the table structure form plus emu it works, but then the client goes to reload.php and the connection gets dropped, so its something i need to just find the correct edit to fix in the for the R63? phoenix db

Post automatically merged: Jun 23, 2019

Plus emu
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(125) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`mail` varchar(255) DEFAULT '[email protected]',
`auth_ticket` varchar(60) NOT NULL,
`rank` int(1) unsigned DEFAULT '1',
`rank_vip` int(1) DEFAULT '1',
`credits` int(11) DEFAULT '50000',
`vip_points` int(11) DEFAULT '0',
`activity_points` int(11) DEFAULT '5000',
`look` char(255) DEFAULT NULL,
`gender` enum('M','F') DEFAULT 'M',
`motto` char(50) DEFAULT NULL,
`account_created` char(12) DEFAULT '0',
`last_online` int(11) DEFAULT '0',
`online` enum('0','1') DEFAULT '0',
`ip_last` varchar(45) DEFAULT '',
`ip_reg` varchar(45) DEFAULT NULL,
`home_room` int(10) DEFAULT '0',
`is_muted` enum('0','1') DEFAULT '0',
`block_newfriends` enum('0','1') DEFAULT '0',
`hide_online` enum('0','1') DEFAULT '0',
`hide_inroom` enum('0','1') DEFAULT '0',
`vip` enum('0','1') DEFAULT '1',
`volume` varchar(15) DEFAULT '100,100,100',
`last_change` int(20) DEFAULT '0',
`machine_id` varchar(125) DEFAULT '',
`focus_preference` enum('0','1') DEFAULT '0',
`chat_preference` enum('0','1') DEFAULT '0',
`pets_muted` enum('0','1') DEFAULT '0',
`bots_muted` enum('0','1') DEFAULT '0',
`advertising_report_blocked` enum('0','1') DEFAULT '0',
`gotw_points` int(11) DEFAULT '0',
`ignore_invites` enum('0','1') DEFAULT '0',
`time_muted` double DEFAULT '0',
`allow_gifts` enum('0','1') DEFAULT '1',
`trading_locked` double DEFAULT '0',
`friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
`disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
`allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
`user_likes` int(11) DEFAULT '0',
`pin` varchar(4) DEFAULT NULL,
`teamrank` int(1) DEFAULT '0',
PRIMARY KEY (`id`,`auth_ticket`),
UNIQUE KEY `id` (`id`) USING HASH,
UNIQUE KEY `username` (`username`) USING BT,
KEY `rank` (`rank`),
KEY `ip_last` (`ip_last`),
KEY `ip_reg` (`ip_reg`),
KEY `credits` (`credits`),
KEY `activity_points` (`activity_points`),
KEY `online` (`online`),
KEY `mail` (`mail`),
KEY `machine_id` (`machine_id`),
KEY `auth_ticket` (`auth_ticket`),
KEY `last_online` (`last_online`),
KEY `home_room` (`home_room`),
KEY `rank_vip` (`rank_vip`),
KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BT
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


Phoenix


-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT '[email protected]',
`auth_ticket` varchar(60) NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(11) NOT NULL DEFAULT '50000',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` varchar(255) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL,
`account_created` varchar(50) NOT NULL,
`last_online` varchar(50) NOT NULL,
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_last` varchar(120) NOT NULL,
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(11) NOT NULL DEFAULT '3',
`daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
`hide_online` enum('0','1') NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(6) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`volume` int(3) NOT NULL DEFAULT '100',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
`user_likes` int(11) DEFAULT '0',
`pin` varchar(4) DEFAULT NULL,
`teamrank` int(1) DEFAULT '0',
PRIMARY KEY (`id`,`auth_ticket`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

 

[Joe]

Isn’t Brain made for R63B? Try using Rev as the logging is different.

 

[Tomgnus]

yes its is for R63B, but i wan't to use it for R63 if that is possible, i don't find other cms that are as nice and handy with the hk and that stuff

 

[WockoLad]

Phoenix Emulator and Plus Emulator have different database structures. They're similar but there are significant differences. You're getting further with the Plus User Table because BrainCMS was built around the Plus / Arcturus Database Structure, but the disconnection issue is probably Phoenix Emulator not liking Plus's user table. I'd personally use Phoenix's user table and simply re-write the queries in BrainCMS. It shouldn't be too difficult because like I said, they're similar.

 

[Moonstar]

Phoenix Emulator and Plus Emulator have different database structures. They're similar but there are significant differences. You're getting further with the Plus User Table because BrainCMS was built around the Plus / Arcturus Database Structure, but the disconnection issue is probably Phoenix Emulator not liking Plus's user table. I'd personally use Phoenix's user table and simply re-write the queries in BrainCMS. It shouldn't be too difficult because like I said, they're similar.

as Wockolad stated braincms wasnt built for phoenix enviroment, its plus or simply arcturus.

Post automatically merged: Jun 23, 2019

Try uber,