Catalog Stort By Price?

NapsterSwe

New Member
Feb 11, 2019
14
3
Hi!

How can I sort my catalog by price? From high to low? Now it's all randomized.
Or is it a way to order it by number like in catalog pages?

You must be registered for see images attach
 

Brad

Well-Known Member
Jun 5, 2012
2,320
993
I'm guessing you're using Plus, so goto CatalogManager.cs around line 90. Add to the end of the query
Code:
order by cost_credits DESC

so it should look something similar to this.
Code:
dbClient.SetQuery("SELECT `id`,`item_id`,`catalog_name`,`cost_credits`,`cost_pixels`,`cost_diamonds`, `cost_points`, `type`,`amount`,`is_hc`,`event_count`, `hc_level`,`page_id`,`limited_sells`,`limited_stack`,`offer_active`,`extradata`,`badge`,`offer_id`,`ltd_limit` FROM `catalog_items` order by `cost_credits` DESC");

If this is wrong please forgive me, been a while since I touched anything Habbo. There is also most likely a simpler way to do this.
 

Users who are viewing this thread

Top