Tips & Tricks | Arcturus

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

    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
    153Posts

    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
    153Posts

    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
    172Posts

    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
    153Posts

    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,191Posts

    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.
    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063

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

    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!

    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063

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

    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