Tips & Tricks | Arcturus

Results 1 to 10 of 10
  1. #1
    Ultimate Member Oliveri is offline
    MemberRank
    Sep 2013 Join Date
    155Posts

    idea Tips & Tricks | Arcturus

    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:
    Code:
    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:
    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?
    Spoiler:

    Having trouble purchasing gifts? Well just run this query and you should be fine!
    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?
    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.
    Last edited by Oliveri; 25-02-18 at 10:44 AM. Reason: Added few things
    "I am whatever you say I am."
    - Eminem


  2. #2
    Ultimate Member Seat is offline
    MemberRank
    Dec 2010 Join Date
    FranceLocation
    159Posts

    Re: Tips & Tricks | Arcturus

    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

  3. #3
    Ultimate Member Oliveri is offline
    MemberRank
    Sep 2013 Join Date
    155Posts

    Re: Tips & Tricks | Arcturus

    Quote Originally Posted by Seat View Post
    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. :)
    "I am whatever you say I am."
    - Eminem

  4. #4
    Ultimate Member Oliveri is offline
    MemberRank
    Sep 2013 Join Date
    155Posts

    Re: Tips & Tricks | Arcturus

    @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).
    "I am whatever you say I am."
    - Eminem

  5. #5
    Ultimate Member Jeanzinh0 is offline
    MemberRank
    May 2009 Join Date
    BrazilLocation
    174Posts

    Re: Tips & Tricks | Arcturus

    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,[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
    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
    Last edited by Jeanzinh0; 06-02-18 at 02:27 PM.

  6. #6
    Ultimate Member Oliveri is offline
    MemberRank
    Sep 2013 Join Date
    155Posts

    Re: Tips & Tricks | Arcturus

    Quote Originally Posted by Jeanzinh0 View Post
    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,[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
    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
    "I am whatever you say I am."
    - Eminem

  7. #7
    Death from above! The General is offline
    DeveloperRank
    Aug 2011 Join Date
    9,226Posts

    Re: Tips & Tricks | Arcturus

    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.
    Discord: TheGeneral#0063
    Join the Arcturus Discord server: https://discord.gg/eDr7FKQ (You can ask help here regarding Arcturus :love)

  8. #8
    Death from above! The General is offline
    DeveloperRank
    Aug 2011 Join Date
    9,226Posts

    Re: Tips & Tricks | Arcturus

    @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!

    Discord: TheGeneral#0063
    Join the Arcturus Discord server: https://discord.gg/eDr7FKQ (You can ask help here regarding Arcturus :love)

  9. #9
    Ultimate Member Oliveri is offline
    MemberRank
    Sep 2013 Join Date
    155Posts

    Re: Tips & Tricks | Arcturus

    Quote Originally Posted by The General View Post
    @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.
    "I am whatever you say I am."
    - Eminem

  10. #10
    Member ExZachLy is offline
    MemberRank
    Sep 2011 Join Date
    60Posts

    Re: Tips & Tricks | Arcturus

    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



Advertisement