[Release] 3.6.4 EMU SQL Fix.

[D0WNF4LL]

Heyya, if your loading up the EMU at it says either error ''Acheivments'' or ''CMD_pixels'' Etc.. then enter these codes ;

ALTER TABLE `permissions_ranks` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER TABLE `permissions_ranks` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';

ALTER TABLE `permissions_users` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER TABLE `permissions_users` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';

DROP TABLE IF EXISTS `permissions_vip`;
CREATE TABLE `permissions_vip` (
  `cmdPush` enum('0','1') NOT NULL DEFAULT '1',
  `cmdPull` enum('0','1') NOT NULL DEFAULT '1',
  `cmdFlagme` enum('0','1') NOT NULL DEFAULT '1',
  `cmdMimic` enum('0','1') NOT NULL DEFAULT '1',
  `cmdMoonwalk` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO permissions_vip VALUES ('1', '1', '1', '1', '1');

and for ''Achievements''

ALTER TABLE `rooms` ADD `achievement` int(11) NOT NULL DEFAULT '0';

ALTER TABLE `bots` ADD `effect` int(2) NOT NULL DEFAULT '0';

thanks
-Ryan.

[FlamedLuc]

Heyya, if your loading up the EMU at it says either error ''Acheivments'' or ''CMD_pixels'' Etc.. then enter these codes ;

ALTER TABLE `permissions_ranks` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER TABLE `permissions_ranks` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';

ALTER TABLE `permissions_users` ADD `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0';
ALTER TABLE `permissions_users` ADD `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0';

DROP TABLE IF EXISTS `permissions_vip`;
CREATE TABLE `permissions_vip` (
  `cmdPush` enum('0','1') NOT NULL DEFAULT '1',
  `cmdPull` enum('0','1') NOT NULL DEFAULT '1',
  `cmdFlagme` enum('0','1') NOT NULL DEFAULT '1',
  `cmdMimic` enum('0','1') NOT NULL DEFAULT '1',
  `cmdMoonwalk` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO permissions_vip VALUES ('1', '1', '1', '1', '1');

and for ''Achievements''

ALTER TABLE `rooms` ADD `achievement` int(11) NOT NULL DEFAULT '0';

ALTER TABLE `bots` ADD `effect` int(2) NOT NULL DEFAULT '0';

thanks
-Ryan.

Thnx, Great job DownF4ll Ehhm, just few questions, Do you know good working swf, and how to fix client.php error? i got flash player error.

[Maelfic]

Thnx, Great job DownF4ll Ehhm, just few questions, Do you know good working swf, and how to fix client.php error? i got flash player error.

Use the SWF's I provided in this tut,

And good Ryan.

[FlamedLuc]

Use the SWF's I provided in this tut,

And good Ryan.

What tutorial can you gimme the link?

[Maelfic]

What tutorial can you gimme the link?

Sorry;
Here mate :)

[FlamedLuc]

Sorry;
Here mate :)

Thnx :D, last question how to fix Adobe flash player issue?

[azaidi]

put good habbo.swf link in housekeeping..

[GayPride]

i did all of this and my vip commands wont work i have edit the vip column to '1' and it still wont work Why?

[Googley4]

Finally was looking for these!

[mmdoh88]

wallthick error ?;9

[Maelfic]

wallthick error ?;9

The wallthink error, post in Habbo Help and they'll give you a SQL Code to fix that

[Subway]

Thanks for this.

[HabboFan1]

Handy ;D