(HELP) Braincms

Tomgnus

New Member
Jun 11, 2019
8
1
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:

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:

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 BTREE,
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 BTREE
) 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;
 
Last edited:

Tomgnus

New Member
Jun 11, 2019
8
1
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

SELECT * FROM `lads` WHERE `username` = 'WockoLad'
Dec 24, 2014
233
23
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

Member
Oct 29, 2013
88
20
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:

Try uber,
 

Users who are viewing this thread

Top