Tips & Tricks | Arcturus

Oliveri · Jan 29, 2018

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?

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:

Code:

[COLOR=#172B4D]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[/COLOR]

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

NOTE! Remember to update the external_variables entry to this:

Code:

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?

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

Code:

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?

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?

You must be registered to see links

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 :w00t:

How to fix Victorian musicbox?

1. Download this mp3 to your mp3-folder:

You must be registered to see links

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!

You must be registered to see links

Have 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.

Seat · Jan 30, 2018

How to use crackable

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 · Jan 31, 2018

Seat said:
How to use crackable

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 · Feb 6, 2018

@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 · Feb 6, 2018

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

Code:

SELECT users.id,username,look,[B][FIELD FROM users_settings][/B] 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

Code:

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 · Feb 6, 2018

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

Code:

SELECT users.id,username,look,[B][FIELD FROM users_settings][/B] 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

Code:

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 · Feb 7, 2018

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 · Feb 25, 2018

@Oliveri

How to fix Victorian musicbox?

Download this mp3 and put it in your mp3 folders:

You must be registered to see links

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 · Feb 25, 2018

The General said:
@Oliveri

How to fix Victorian musicbox?

Download this mp3 and put it in your mp3 folders:
You must be registered to see links

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 · Mar 19, 2018

How to sync catalog names to public names for items?

Code:

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 · Mar 22, 2020

thats awesome

Tips & Tricks | Arcturus

Oliveri

Junior Spellweaver

Seat

Junior Spellweaver

Oliveri

Junior Spellweaver

Oliveri

Junior Spellweaver

Jeanzinh0

Junior Spellweaver

Oliveri

Junior Spellweaver

The General

Developer

The General

Developer

Attachments

Oliveri

Junior Spellweaver

Attachments

ExZachLy

Newbie Spellweaver

swe

Newbie Spellweaver