Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Tips & Tricks | Arcturus

Junior Spellweaver
Joined
Sep 12, 2013
Messages
146
Reaction score
66
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. :love:


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. :eek: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 :love:): 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 :love:

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?



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:
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!
Have fun :love:


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. :love:
 
Last edited:
Junior Spellweaver
Joined
Dec 22, 2010
Messages
154
Reaction score
24
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
 
Junior Spellweaver
Joined
Sep 12, 2013
Messages
146
Reaction score
66
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. :)
 
Junior Spellweaver
Joined
May 3, 2009
Messages
173
Reaction score
134
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
 
Last edited:
Junior Spellweaver
Joined
Sep 12, 2013
Messages
146
Reaction score
66
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 :love:
 
Joined
Aug 10, 2011
Messages
7,401
Reaction score
3,299
@Oliveri

How to fix Victorian musicbox?
Download this mp3 and put it in your mp3 folders:
Change the interaction type of musicbox to 'musicdisc'.
Change interaction_modes_count to '2'.
Update items, reload if necessary and voilàh - works perfect!
a0fbfae8610deb51cd6b497375a86c92 - Tips & Tricks | Arcturus - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Sep 12, 2013
Messages
146
Reaction score
66
@Oliveri

How to fix Victorian musicbox?
Download this mp3 and put it in your mp3 folders:
Change the interaction type of musicbox to 'musicdisc'.
Change interaction_modes_count to '2'.
Update items, reload if necessary and voilàh - works perfect!
a0fbfae8610deb51cd6b497375a86c92 - Tips & Tricks | Arcturus - RaGEZONE Forums
Added to main thread, thanks for providing direct download link aswell. :love:
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Sep 24, 2011
Messages
47
Reaction score
9
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

Initiate Mage
Joined
Dec 24, 2016
Messages
64
Reaction score
6
thats awesome
 
Last edited:
Back
Top