Tips & Tricks | Arcturus

[Oliveri]

Hello everyone!

I think it's about time we come up as a community with Arcturus (no, I don't mean releases such as catalog's or CMS). This thread is all about sharing instructions on how to take this emulator to far and beyond!

So I want to see all you posting down what you know would benefit new users etc.


How to use Hall of Fame?

Spoiler:

Hall of Fame is setup to take hof_points from users_settings-table by default. This is basically by default an column that is not in usage - unless configured otherwise.

How to have Hall of Fame through diamonds:
Look into emulator_settings and find "halloffame"-query. Replace the value with this:

SELECT users.id,username,look,amount AS hof_points FROM users INNER JOIN users_currency ON users.id=users_currency.user_id WHERE users_currency.type = POINTS_TYPE_HERE AND users.rank < 5 ORDER BY users_currency.amount DESC LIMIT 10

In-case you just want to use hof_points, take them to use - hall of fame users will show up in hotelview immediatly.


NOTE! Remember to update the external_variables entry to this:

landing.view.dynamic.slot.6.conf=2013-05-08 13:00,gamesmaker;2013-05-11 13:00
landing.view.dynamic.slot.6.widget=achievementcompetition_hall_of_fame

Original credits (from Bitbucket ): Jeanzinh0

How to fix gifts?

Spoiler:

Having trouble purchasing gifts? Well just run this query and you should be fine!

DELETE FROM gift_wrappers; 
INSERT INTO gift_wrappers (sprite_id, item_id) SELECT sprite_id, id FROM items_base WHERE item_name LIKE 'present_gen%'; 
UPDATE gift_wrappers SET type = 'gift'; 
INSERT INTO gift_wrappers (sprite_id, item_id) SELECT sprite_id, id FROM items_base WHERE item_name LIKE 'present_wrap%';

Originally provided by @The General

How to make purchasable clothing?

Spoiler:

Purchasable clothing is really easy to be honest with you.

First of find the item you want to be sellable:
- You should have it setup in catalog the way you want it and items_base entry should be interaction_type = 'clothing'.

Create an entry in catalog_clothing:
1. ID can be basically anything, as long as it's not duplicate.
2. Clothing name is the item_name (ex. clothing_r17_bathat)
3. Go to your figuremap.xml and find the entry related with your clothing (in this case: <lib id="hat_U_bathat" revision="63429"><part id="3027" type="ha"/>

</lib>)
4. Go to figuredata.xml and find the clothing related with this part id. (in this case: <set id="3606" gender="U" club="0" colorable="0" selectable="1" preselectable="0" sellable="1">
<part id="3027" type="ha" colorable="0" index="0" colorindex="0"/>

</set>)
4. Go back to catalog_clothing and set the last value to the set_id provided in figuredata. In this case that would be 3606.

NOTE! Make sure the figuredata entry is sellable="1"!

How to make an badge shop?

Spoiler:

https://i.imgur.com/zTJLkSW.png

This was an requested add so:
1. Go to items_base and make an new entry with the following details: item_name = 'BADGECODE', type = 'b' - nothing else matters. Save the entry and copy the ID you just set.
2. Go to catalog_items and make an new entry with just the following details:
Use item_ids as the item id you just copied from items_base, page_id is the badge shop page you should have created already.

The badge can be on any price. Diamonds, duckets, custom points, credits - have fun

How to fix Victorian musicbox?

Spoiler:

1. Download this mp3 to your mp3-folder: http://images.habbo.com/dcr/hof_furn...sample_732.mp3
2. Change the interaction type of musicbox to default.
3. Change interaction_modes_count to '2'.
Update items, reload if necessary and voilàh - works perfect!
https://gyazo.com/a0fbfae8610deb51cd6b497375a86c92Have fun

Hope this helps some of you starters & I want to see you show what you got too to help people out a little bit more. I will update this thread If I get new ideas etc.

[MentaL]

[Seat]

How to use crackable

Spoiler:

You don't know, how crackable works ?

1- Go to your item_base and find item id of the crackable, then find the item or items (take the ID) you want to be the prize.
2- Go the items_crackable in item_id put the item of the crackable, in count the number of click, in prize put id of the prize and the chance;
use this format : item_id1:chance;item_id_2:chance,item_id_3:chance etc chance goes from 100 to 1

[Oliveri]

How to use crackable

Spoiler:

You don't know, how crackable works ?

1- Go to your item_base and find item id of the crackable, then find the item or items (take the ID) you want to be the prize.
2- Go the items_crackable in item_id put the item of the crackable, in count the number of click, in prize put id of the prize and the chance;
use this format : item_id1:chance;item_id_2:chance,item_id_3:chance etc chance goes from 100 to 1

Well done, will add this to main thread later. :)

[Oliveri]

@Xylo @Aron123

Sorry, my PM's are full so I couldn't answer there.
Added badge shop to main thread & fixed Hall of Fame (was missing vars).

[Jeanzinh0]

Also, for Hall of fame, you can use online_time, achievement_score, login_streak, respects_given, respects_received, or whatever field you want. cfh_bans included

SELECT users.id,username,look,[FIELD FROM users_settings] AS hof_points FROM users INNER JOIN users_settings ON users.id=users_settings.user_id WHERE users.rank < 5 ORDER BY hof_points DESC LIMIT 10

Edit:
For Badges

SELECT users.id,username,look,COUNT(users_badges.user_id) AS hof_points 
FROM users INNER JOIN users_badges ON users.id=users_badges.user_id WHERE users.rank < 5
GROUP BY users.id ORDER BY hof_points DESC LIMIT 10

[Oliveri]

Also, for Hall of fame, you can use online_time, achievement_score, login_streak, respects_given, respects_received, or whatever field you want. cfh_bans included

SELECT users.id,username,look,[FIELD FROM users_settings] AS hof_points FROM users INNER JOIN users_settings ON users.id=users_settings.user_id WHERE users.rank < 5 ORDER BY hof_points DESC LIMIT 10

Edit:
For Badges

SELECT users.id,username,look,COUNT(users_badges.user_id) AS hof_points 
FROM users INNER JOIN users_badges ON users.id=users_badges.user_id WHERE users.rank < 5
GROUP BY users.id ORDER BY hof_points DESC LIMIT 10

Good updates, thanks

[The General]

Yes as long as you give it an alias hof_points it will use that. Can make it last 10 registered by sorting on registered timestamp descending. Plenty of stuff you can do with it.

[The General]

@Oliveri

How to fix Victorian musicbox?

Spoiler:

Download this mp3 and put it in your mp3 folders: http://images.habbo.com/dcr/hof_furn...sample_732.mp3
Change the interaction type of musicbox to 'musicdisc'.
Change interaction_modes_count to '2'.
Update items, reload if necessary and voilàh - works perfect!

[Oliveri]

@Oliveri

How to fix Victorian musicbox?

Spoiler:

Download this mp3 and put it in your mp3 folders: http://images.habbo.com/dcr/hof_furn...sample_732.mp3
Change the interaction type of musicbox to 'musicdisc'.
Change interaction_modes_count to '2'.
Update items, reload if necessary and voilàh - works perfect!

Added to main thread, thanks for providing direct download link aswell.

[ExZachLy]

How to sync catalog names to public names for items?

UPDATE catalog_items INNER JOIN items_base ON catalog_items.item_ids = items_base.id SET catalog_items.catalog_name = items_base.public_name

[swe]

thats awesome