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

Jonteh · Dec 23, 2012

XiFy said:
Jonteh if you have the time could you release a full working Phoenix Database that works with the Emulator,
we will be highly grateful.

Thanks

We're in the process as I post this of moving Fresh to this Emulator. After that I can let you guys know the process needed to successfully convert.

KyleeIsProzZ · Dec 23, 2012

Jonteh said:
We're in the process as I post this of moving Fresh to this Emulator. After that I can let you guys know the process needed to successfully convert.

Once you do i'll be using this emulator

Good luck

Jonteh · Dec 23, 2012

Here's a series of links and codes we used to fix the SQL issues on Fresh:

You must be registered to see links

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.

KyleeIsProzZ · Dec 23, 2012

Jonteh said:
Here's a series of links and codes we used to fix the SQL issues on Fresh:

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

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?

Jonteh · Dec 23, 2012

XiFy said:
Do we do this to Phoenix DB?

Yeah.

Bloodraven · Dec 23, 2012

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.

KyleeIsProzZ · Dec 23, 2012

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

PRIZM · Dec 23, 2012

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

XiFy said:
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.

KyleeIsProzZ · Dec 23, 2012

Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

Prizm said:
Go to furniture and make a collumn called cost_snow.

Sent from Tapatalk 2.

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

Thanks

Bloodraven · Dec 23, 2012

Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

XiFy said:
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.

KyleeIsProzZ · Dec 23, 2012

Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

zJordan said:
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.

Muscab · Dec 23, 2012

Re: Sv: [REL] Butterfly Emulator [Works with PhoenixDB] [Source]

zJordan said:
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?

iRekan · Dec 23, 2012

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

Twan · Dec 23, 2012

ALTER TABLE catalog_items ADD COLUMN `cost_snow` int(11) UNSIGNED NOT NULL;

iRekan · Dec 23, 2012

Twan said:
ALTER TABLE catalog_items ADD COLUMN `cost_snow` int(11) UNSIGNED NOT NULL;

Well, after I did that, I get this error:

You must be registered to see links

Twan · Dec 23, 2012

I think it is the emulator, it isnt compitable with phoenix if you get thousands of errors....

iRekan · Dec 23, 2012

Twan said:
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:

Twan · Dec 23, 2012

Then you'll have to wait..

Jonteh · Dec 24, 2012

Twan said:
I think it is the emulator, it isnt compitable with phoenix if you get thousands of errors....

There's all the small details left to edit, but if you know your way around SQL you can get it to work without editing the Emu at all.

KyleeIsProzZ · Dec 24, 2012

Jonteh said:
There's all the small details left to edit, but if you know your way around SQL you can get it to work without editing the Emu at all.

I'm getting a error,

There was no user found with your session ticket

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

:joy:

Master Summoner

:joy:

Master Summoner

:joy:

ส็็็็็็็

Master Summoner

Zephyr Studios

Master Summoner

ส็็็็็็็

Master Summoner

Experienced Elementalist

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

:joy:

Master Summoner

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor