Problem with my Character!

[Tijn20]

Hello,

I have a problem with my habbo retro. I make a retro with Briancms everthing work perfectly but 1 thing doesn't work
My character don't load in and my character is outside the room. I look everywhere but i can't find anything what can help me.
Can someone help me? on teamviewer or something. I have 1 thing more my animals en club badges doesn't load in to.

Screenshot from my habbo:

You must be registered for see images attach

Sorry for my English

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

My External_override_variables code:

seasonalcurrencyindicator.currency=103
seasonalcurrencyindicator.enabled=true
seasonalcurrencyindicator.page=diamonds

ads.domain=localhost
roomenterad.habblet.enabled=false

diamonds.enabled=true
camera.enabled=false
builders.club.enabled=false
toolbar.stories.enabled=false

supersaverads.video.promo.development.mode=false
supersaverads.video.promo.enabled=false

offers.enabled=false
offers.sponsorpay.appid=0
offers.supersonic.enabled=false

avatareditor.promohabbos=http://localhost/game/gamedata/habblet/xml/promo_habbos.xml

game.center.default_game=basejump
game.center.enabled=true
game.center.promoted_game=basejump

embed.showInRoomInfo=true
sms.identity.verification.button.enabled=false
sms.identity.verification.enabled=false

multi.item.trading.enabled=true

disabled.custom.chat.styles=1,2,8,18,23,28,30,31,32,33,34,35

flash.dynamic.download.name.template=%typeid%.swf
flash.dynamic.download.url=http://localhost/game/dcr/hof_furni/
flash.dynamic.icon.download.name.template=icons/%typeid%%param%_icon.png
group.badge.url=http://localhost/game/habbo-imaging/badge/%imagerdata%.gif

habbopages.url=http://localhost/game/gamedata/habbopages/

flash.client.url=http://localhost/game/gordon/PRODUCTION-201701242205-837386173/
external.texts.txt=http://localhost/game/gamedata/external_flash_texts.txt
external.override.texts.txt=http://localhost/game/gamedata/override/external_flash_override_texts.txt
external.override.variables.txt=http://localhost/game/gamedata/override/external_override_variables.txt
productdata.load.url=http://localhost/game/gamedata/productdata.txt
furnidata.load.url=http://localhost/game/gamedata/furnidata.xml

 

[harambe]

POSSIBLE BUGFIX
--------------------

ISSUE: The client loads but when you enter a room; the player's character doesn't appear. The player's menu appears in the top left and the player can't move in the room.


Backstory:
I've been browsing these forums and the YouTube video tutorial's comment section for 2 hours and 9 out of 10 times someone says "You need to change your decimal point in system language."
This might be the solution to other issues, but not this one. All files were also properly edited (external_variables & external_override_variables & etc.).


SOLUTION
1. Open up NaviCat >> hotel >> hotel
2. Right click on "Queries" and click "New Query"
3. Copy and paste the following SQL command;

ALTER TABLE `room_models` CHANGE `public_items` `public_items` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0';

4. Click "Run"

5. In NaviCat, go to hotel >> hotel >> Tables >> room_models
6. In the "public_items" column, replace every blank space with "0" (without the ").

Spoiler: Example

You must be registered for see images attach

7. Click the checkmark to save your changes. The red boxes will turn white.
8. DONE! --> Load up Plus Emulator and launch the client!


Hope this helps a couple people.

 

[Tijn20]

Hello thanks,

I did everything you say but it still not work
Now is my client broken at 76%.

This is the problem:

You must be registered for see images attach

 

[Glennyo]

Can you make a screenshot of your 'room_models' table?

 

[Tijn20]

Here is my room_,models table

You must be registered for see images attach

 

[Jhoiik]

i think is the SWF maybe a link is wrong... check the external_variables hope the problem is there.

 

[Glennyo]

i think is the SWF maybe a link is wrong... check the external_variables hope the problem is there.

This is probably the issue, as the MySQL error says (in Dutch) that the emulator can't establish a database connection. So probably a file mismatch.

 

[Tijn20]

how can i fix it?

Post automatically merged: Apr 17, 2020

You must be registered for see images attach

this is the MySQL Error

 

[Ghost]

how can i fix it?

Post automatically merged: Apr 17, 2020

You must be registered for see images attach

this is the MySQL Error

The tables `server_status` doesn't exist nor does `catalog_marketplace_data`..

Run these queries

-- ----------------------------
-- Table structure for server_status
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status`  (
  `users_online` int(11) NOT NULL DEFAULT 0,
  `loaded_rooms` int(11) NOT NULL DEFAULT 0,
  `environment_status` int(11) NOT NULL DEFAULT 0,
  UNIQUE INDEX `users_online`(`users_online`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of server_status
-- ----------------------------
INSERT INTO `server_status` VALUES (0, 0, 1);

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- Table structure for catalog_marketplace_data
-- ----------------------------
DROP TABLE IF EXISTS `catalog_marketplace_data`;
CREATE TABLE `catalog_marketplace_data`  (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `sprite` int(7) NOT NULL,
  `sold` int(7) NOT NULL DEFAULT 0,
  `avgprice` int(9) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of catalog_marketplace_data
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;

 

[Tijn20]

in navicat new Query?

 

[Ghost]

in navicat new Query?

yes

 

[Zombie]

in navicat new Query?

Yes in the navicat new Query

 

[Tijn20]

oke i try

 

[Ghost]

Here is my room_,models table

You must be registered for see images attach

Public items shouldn't have a value if its not in-use // theres no public item.. thats why you cannot see your character. click where it says public_items, when it's all highlighted (blue) just hit space and save it, then restart your emulator. Should let your character spawn in freely.

 

[Tijn20]

no, it still doesn't work

 

[Ghost]

no, it still doesn't work

You must be registered for see links

Run this SQL.

 

[Tijn20]

i copy it where can i load it in SQL, i never did this before

 

[Ghost]

i copy it where can i load it in SQL, i never did this before

 

[Tijn20]

oke thx i try again

Post automatically merged: Apr 17, 2020

Post automatically merged: Apr 17, 2020

now i got this problem

 

[Ghost]

oke thx i try again

Post automatically merged: Apr 17, 2020

Post automatically merged: Apr 17, 2020

now i got this problem

Just edit the floor plan you should be fine.