uberEmulator - Stabilized

Quote:

---

Originally Posted by KingStupid

Doesnt work with me.
It isnt your fault, I think :p

(I + uberCMS/EMU = bad idea :D)

(but good release)

---

Use Jakes database and it will work.

Quote:

---

Originally Posted by Adde

Use Jakes database and it will work.

---

I want to use it but then im going to lose the thousands of current registered members so i need to know what the changes to the mysql database are..
like what tables i need to alter and what tables i need to add etc etc
i already added 2 tables and altered the rooms database for the column allow_hidewalls...

If it doesn't work for some of you im not going to care as much...You have to know how to set it up the right way...taking short cuts and trying to avoid certain things will lead to a disappointment. This emulator has been ran on a 100-200 user hotel WITH 3 days of no errors or freezes.

You guys just have to follow the way...It does work granted it worked for me

if you just give me the tables that are changes im happy and everything should work perfect then... ;)

I need a good ubercms please.

Download link?

Please.

Quote:

---

Originally Posted by mike444

if you just give me the tables that are changes im happy and everything should work perfect then... ;)

---

Upgrade Sql You need to add the Fuse For Hide Walls and VIP larger wardrobe

Code:

---


-- ----------------------------
-- Server Upgrade Sql Keep's Noobs Happy - Spazzemu
-- ----------------------------
ALTER TABLE  `rooms` ADD  `allow_hidewall` enum('') NOT NULL;
-- ----------------------------
-- Table structure for `wiredaction`
-- ----------------------------
DROP TABLE IF EXISTS `wiredaction`;
CREATE TABLE `wiredaction` (
  `slotid` int(11) NOT NULL,
  `typeaction` varchar(10) NOT NULL,
  `whataction` varchar(10) NOT NULL,
  `itemid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of wiredaction
-- ----------------------------
INSERT INTO `wiredaction` VALUES ('1', 'kick', '', '0');
INSERT INTO `wiredaction` VALUES ('1', 'status', '1', '10');
INSERT INTO `wiredaction` VALUES ('1', 'status', '0', '10');

-- ----------------------------
-- Table structure for `wiredtrigger`
-- ----------------------------
DROP TABLE IF EXISTS `wiredtrigger`;
CREATE TABLE `wiredtrigger` (
  `slotid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL,
  `triggertype` varchar(10) NOT NULL,
  `whattrigger` varchar(10) NOT NULL,
  PRIMARY KEY (`slotid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of wiredtrigger
-- ----------------------------
INSERT INTO `wiredtrigger` VALUES ('1', '5520', 'walkon', '11');

---

Thank me if I helped

takes 2 seconds to make everyone happy

maybe hes updating it

This is a ENGLISH FORUM! Not a Dutch one!

what is the fuse for hidewalls ?
and i got a problem with some roomtypes from hc and vip it will crash the client not server

This Emulator is the best out there.
considering the fact that some other emulators have exploits and bugs.

10/10

One question, Which version is this Emulator? r54?

if anyone would like a better catalog, PM me. I'll send you the proper sqls.

keep going <3 love this emulator <3

BUG:

That hide walls thingie doesn't save it

Quote:

---

Originally Posted by PEjump2

BUG:

That hide walls thingie doesn't save it

---

It does? :S Works for me

Quote:

---

Originally Posted by stoffe89

It does? :S Works for me

---

It works, but it doesnt save it.

You mean you have walls when u reload the hotel?

Quote:

---

Originally Posted by PEjump2

It works, but it doesnt save it.

---

Yeah that was happening to me,
but i did something to make it save cant remember what if i find out ill post on here:}

ill post a fix soon.

I fixed both the hide wall not saving and the duplicate error on wire furni

Hide Walls
SQL

Code:

---

ALTER TABLE  `rooms` CHANGE  `allow_hidewall`  `allow_hidewall` ENUM(  '0',  '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '0'

---

Wire Furni Duplicate error fix
SQL

Code:

---

ALTER TABLE  `wiredtrigger` CHANGE  `slotid`  `slotid` INT( 10 ) NOT NULL AUTO_INCREMENT

---

In C#
Replace the RequestAddwired Void with

Code:

---

private void RequestAddWired()
        {
           
                GetResponse().Init(650);

           

                using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                {
                 
                    dbClient.ExecuteQuery("INSERT INTO wiredtrigger values ('','" + Session.GetHabbo().CurrentRoomId + "','','')");

                }
           
            SerializeWired();
        }

---

Thank me if I helped

Quote:

---

Originally Posted by SpazzEmu

I fixed both the hide wall not saving and the duplicate error on wire furni

Hide Walls
SQL

Code:

---

ALTER TABLE  `rooms` CHANGE  `allow_hidewall`  `allow_hidewall` ENUM(  '0',  '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '0'

---

Wire Furni Duplicate error fix
SQL

Code:

---

ALTER TABLE  `wiredtrigger` CHANGE  `slotid`  `slotid` INT( 10 ) NOT NULL AUTO_INCREMENT

---

In C#
Replace the RequestAddwired Void with

Code:

---

private void RequestAddWired()
        {
           
                GetResponse().Init(650);

           

                using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                {
                 
                    dbClient.ExecuteQuery("INSERT INTO wiredtrigger values ('','" + Session.GetHabbo().CurrentRoomId + "','','')");

                }
           
            SerializeWired();
        }

---

Thank me if I helped

---

Awesome Spazz, Thanks! (: <3

I might release a %100 fixed copy soon

Thanks spazz :p

More Fix's to come

Cracked the r56 swf's, and lions are working with my own edit, but not with this one cause the catalog.cs pet loading thing is coded differently, so spazz can you maybe try to fix that that it will work with those codes? :

http://forum.ragezone.com/f353/lions...tested-688785/

Tip for cracking the r56 swf's:

Use config_habbo.xml and crossdomain.xml (: