Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[REL] Butterfly Emulator [Works with PhoenixDB] [Source]

Status
Not open for further replies.
Joined
Apr 30, 2007
Messages
2,337
Reaction score
1,547
Here's a series of links and codes we used to fix the SQL issues on Fresh:







Code:
CREATE TABLE `items_rooms_songs` (
  `itemid` int(10) unsigned NOT NULL,
  `roomid` int(10) unsigned NOT NULL,
  `songid` int(11) NOT NULL,
  PRIMARY KEY (`itemid`,`roomid`),
  KEY `itemid` (`itemid`),
  KEY `roomid` (`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code:
DROP TABLE IF EXISTS `messenger_requests`;
CREATE TABLE `messenger_requests` (
  `sender` int(10) unsigned NOT NULL,
  `receiver` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender`,`receiver`),
  KEY `i_sender` (`sender`) USING HASH,
  KEY `i_receiver` (`receiver`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code:
DROP TABLE IF EXISTS `messenger_friendships`;
CREATE TABLE `messenger_friendships` (
  `sender` int(10) unsigned NOT NULL,
  `receiver` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender`,`receiver`),
  KEY `i_sender` (`sender`) USING HASH,
  KEY `i_receiver` (`receiver`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




Code:
CREATE TABLE `user_online` (
  `userid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`userid`),
  UNIQUE KEY `userid` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

You will need to make the following alterations to your DB:

messenger_friendships:
user_one_id changes to sender
user_two_id changes to receiver

Same for messenger_requests.
 
Joined
Oct 11, 2012
Messages
544
Reaction score
143
Here's a series of links and codes we used to fix the SQL issues on Fresh:







Code:
CREATE TABLE `items_rooms_songs` (
  `itemid` int(10) unsigned NOT NULL,
  `roomid` int(10) unsigned NOT NULL,
  `songid` int(11) NOT NULL,
  PRIMARY KEY (`itemid`,`roomid`),
  KEY `itemid` (`itemid`),
  KEY `roomid` (`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code:
DROP TABLE IF EXISTS `messenger_requests`;
CREATE TABLE `messenger_requests` (
  `sender` int(10) unsigned NOT NULL,
  `receiver` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender`,`receiver`),
  KEY `i_sender` (`sender`) USING HASH,
  KEY `i_receiver` (`receiver`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code:
DROP TABLE IF EXISTS `messenger_friendships`;
CREATE TABLE `messenger_friendships` (
  `sender` int(10) unsigned NOT NULL,
  `receiver` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sender`,`receiver`),
  KEY `i_sender` (`sender`) USING HASH,
  KEY `i_receiver` (`receiver`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




Code:
CREATE TABLE `user_online` (
  `userid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`userid`),
  UNIQUE KEY `userid` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

You will need to make the following alterations to your DB:

messenger_friendships:
user_one_id changes to sender
user_two_id changes to receiver

Same for messenger_requests.

Do we do this to Phoenix DB?
 
Last edited:
ส็็็็็็็
Loyal Member
Joined
Sep 21, 2009
Messages
2,005
Reaction score
594
You may also need to execute these:

CREATE TABLE IF NOT EXISTS `fuserights` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rank` int(11) unsigned NOT NULL,
`fuse` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `rank` (`rank`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Gegevens worden uitgevoerd voor tabel `fuserights`
--

INSERT INTO `fuserights` (`id`, `rank`, `fuse`) VALUES
(1, 1, 'fuse_room_queue_default'),
(2, 1, 'fuse_buy_credits'),
(3, 1, 'fuse_login'),
(4, 1, 'default'),
(5, 1, 'fuse_trade'),
(6, 3, 'fuse_mod'),
(7, 6, 'fuse_admin'),
(8, 7, 'fuse_sysadmin'),
(9, 4, 'fuse_enter_any_room'),
(10, 1, 'fuse_club_dances'),
(11, 3, 'fuse_housekeeping_login'),
(12, 6, 'fuse_chatlogs'),
(13, 3, 'fuse_alert'),
(14, 4, 'fuse_kick'),
(15, 4, 'fuse_ban'),
(16, 7, 'fuse_housekeeping_catalog'),
(17, 4, 'fuse_housekeeping_moderation'),
(18, 6, 'fuse_housekeeping_sitemanagement'),
(19, 4, 'fuse_any_room_rights'),
(20, 6, 'fuse_ignore_maintenance'),
(21, 4, 'fuse_mute'),
(22, 4, 'fuse_roomkick'),
(23, 4, 'fuse_roomalert'),
(24, 3, 'fuse_enter_full_rooms'),
(25, 1, 'fuse_hide_room_walls');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `fuserights_subs`
--

CREATE TABLE IF NOT EXISTS `fuserights_subs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sub` varchar(120) NOT NULL,
`fuse` text NOT NULL,
PRIMARY KEY (`id`),
KEY `sub` (`sub`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Gegevens worden uitgevoerd voor tabel `fuserights_subs`
--

INSERT INTO `fuserights_subs` (`id`, `sub`, `fuse`) VALUES
(1, 'habbo_club', 'fuse_use_club_dance'),
(2, 'habbo_club', 'fuse_extended_buddylist'),
(3, 'habbo_club', 'fuse_furni_chooser'),
(4, 'habbo_club', 'fuse_priority_access'),
(5, 'habbo_club', 'fuse_use_club_catalog'),
(6, 'habbo_club', 'fuse_habbo_chooser'),
(7, 'habbo_club', 'fuse_use_club_outfits'),
(8, 'habbo_club', 'fuse_room_queue_club'),
(9, 'habbo_club', 'fuse_use_special_room_layouts'),
(10, 'habbo_club', 'fuse_use_club_badge'),
(11, 'habbo_club', 'fuse_use_wardrobe'),
(12, 'habbo_club', 'fuse_use_vip_outfits'),
(13, 'habbo_club', 'fuse_use_vip_room_layouts');

Navigator bug fix:

find
PHP:
Convert.ToUInt32(Row["room_id"]), (int)Row["category_parent_id"],

and replace the entire line with:

PHP:
Convert.ToUInt32(Row["room_id"]), (int)Row["category_parent_id"], ButterflyEnvironment.EnumToBool(Row["category"].ToString()) ,ButterflyEnvironment.EnumToBool(Row["recommended"].ToString())));

EDIT:

I logged these, I've got the emulator to boot, but all I need to do is fix the interaction types, and I will release my database and every edit I've made in the emulator to fix the interaction types, give me a few minutes.

TokenID: 1
Unknown interaction type in parse code: yellow_score



TokenID: 2
Unknown interaction type in parse code: red_score



TokenID: 3
Unknown interaction type in parse code: green_score



TokenID: 4
Unknown interaction type in parse code: blue_score



TokenID: 5
Unknown interaction type in parse code: counter



TokenID: 6
Unknown interaction type in parse code: yellow_goal



TokenID: 7
Unknown interaction type in parse code: red_goal



TokenID: 8
Unknown interaction type in parse code: green_goal



TokenID: 9
Unknown interaction type in parse code: blue_goal



TokenID: 10
Unknown interaction type in parse code: ball



TokenID: 11
Unknown interaction type in parse code: ball



TokenID: 12
Unknown interaction type in parse code: ball



TokenID: 13
Unknown interaction type in parse code: ball



TokenID: 14
Unknown interaction type in parse code: ball



TokenID: 15
Unknown interaction type in parse code: ball



TokenID: 16
Unknown interaction type in parse code: water



TokenID: 17
Unknown interaction type in parse code: water



TokenID: 18
Unknown interaction type in parse code: blue_score



TokenID: 19
Unknown interaction type in parse code: bb_green_gate



TokenID: 20
Unknown interaction type in parse code: green_score



TokenID: 21
Unknown interaction type in parse code: yellow_score



TokenID: 22
Unknown interaction type in parse code: bb_red_gate



TokenID: 23
Unknown interaction type in parse code: bb_patch



TokenID: 24
Unknown interaction type in parse code: bb_yellow_gate



TokenID: 25
Unknown interaction type in parse code: ball



TokenID: 26
Unknown interaction type in parse code: bb_teleport



TokenID: 27
Unknown interaction type in parse code: bb_blue_gate



TokenID: 28
Unknown interaction type in parse code: red_score



TokenID: 29
Unknown interaction type in parse code: pressure_pad



TokenID: 30
Unknown interaction type in parse code: water



TokenID: 31
Unknown interaction type in parse code: counter



TokenID: 32
Unknown interaction type in parse code: tagpole



TokenID: 33
Unknown interaction type in parse code: ball



TokenID: 34
Unknown interaction type in parse code: wf_act_moverotate



TokenID: 35
Unknown interaction type in parse code: wired



TokenID: 36
Unknown interaction type in parse code: pressure_pad



TokenID: 37
Unknown interaction type in parse code: wf_trg_furnistate



TokenID: 38
Unknown interaction type in parse code: wired



TokenID: 39
Unknown interaction type in parse code: wired



TokenID: 40
Unknown interaction type in parse code: wf_trg_timer



TokenID: 41
Unknown interaction type in parse code: wf_trg_atscore



TokenID: 42
Unknown interaction type in parse code: wf_act_moveuser



TokenID: 43
Unknown interaction type in parse code: wf_trg_onsay



TokenID: 44
Unknown interaction type in parse code: wf_trg_offfurni



TokenID: 45
Unknown interaction type in parse code: wf_trg_attime



TokenID: 46
Unknown interaction type in parse code: wf_trg_gameend



TokenID: 47
Unknown interaction type in parse code: wf_act_saymsg



TokenID: 48
Unknown interaction type in parse code: wired



TokenID: 49
Unknown interaction type in parse code: wf_trg_enterroom



TokenID: 50
Unknown interaction type in parse code: wf_act_togglefurni



TokenID: 51
Unknown interaction type in parse code: pressure_pad



TokenID: 52
Unknown interaction type in parse code: pressure_pad



TokenID: 53
Unknown interaction type in parse code: wired



TokenID: 54
Unknown interaction type in parse code: wired



TokenID: 55
Unknown interaction type in parse code: pressure_pad



TokenID: 56
Unknown interaction type in parse code: wired



TokenID: 57
Unknown interaction type in parse code: wired



TokenID: 58
Unknown interaction type in parse code: wf_act_givepoints



TokenID: 59
Unknown interaction type in parse code: wired



TokenID: 60
Unknown interaction type in parse code: wf_trg_gamestart



TokenID: 61
Unknown interaction type in parse code: wf_trg_onfurni



TokenID: 62
Unknown interaction type in parse code: rollerskate

Update: I've fixed 20.
 
Last edited:
Zephyr Studios
Loyal Member
Joined
Feb 18, 2012
Messages
1,877
Reaction score
724
Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

After implanting all the SQL queries, i'm getting this in the emulator.

Column cost_snow does not belong to table

Anybody know a fix?

Thanks

Go to furniture and make a collumn called cost_snow.

Sent from Tapatalk 2.
 
ส็็็็็็็
Loyal Member
Joined
Sep 21, 2009
Messages
2,005
Reaction score
594
Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

Would you mind giving me the query,
I'm not good at adding/editing columns.

Thanks

This should work

Code:
ADD COLUMN `cost_snow`  int(11) UNSIGNED NOT NULL; or remove the ";" if it does not work.
 
Joined
Oct 11, 2012
Messages
544
Reaction score
143
Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

This should work

Code:
ADD COLUMN `cost_snow`  int(11) UNSIGNED NOT NULL; or remove the ";" if it does not work.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `cost_snow` int(11) UNSIGNED NOT NULL' at line 1 I tried it with ; and it still gives the same error.
 
Experienced Elementalist
Joined
Oct 25, 2009
Messages
205
Reaction score
106
Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

This should work

Code:
ADD COLUMN `cost_snow`  int(11) UNSIGNED NOT NULL; or remove the ";" if it does not work.

How is the interaction types coming along?
 
Newbie Spellweaver
Joined
Dec 23, 2012
Messages
23
Reaction score
5
After doing everything, I still get a column 'cost_snow' does not belong to table. I did the query that zJordan posted before... Registered just for this thread
 
Newbie Spellweaver
Joined
Dec 23, 2012
Messages
23
Reaction score
5
I think it is the emulator, it isnt compitable with phoenix if you get thousands of errors....

Well Jonty did say it was unfinished. Hopefully, he can get a full database. Really sick of phoenix but I don't want to lose all the data :mellow:
 
Status
Not open for further replies.
Back
Top