Alphabetical Catalogues

[rxinbows]

Is there anything used for making a catalogue alphabetical [PLUSEMU]?

 

[JayC]

You can run a query to achieve this.

SET @counter = 0;


Update catalog_pages

SET order_num = @counter := @counter + 1

WHERE parent_id = 'ParentIDGoesHere'

Order By Caption

 

[Karel]

I'm not a 100% sure but I guess you can also change this line in CatalogManager.cs:

dbClient.SetQuery("SELECT `id`,`item_id`,`catalog_name`,`cost_credits`,`cost_pixels`,`cost_diamonds`,`amount`,`page_id`,`limited_sells`,`limited_stack`,`offer_active`,`extradata`,`badge`,`offer_id` FROM `catalog_items`");

To

dbClient.SetQuery("SELECT `id`,`item_id`,`catalog_name`,`cost_credits`,`cost_pixels`,`cost_diamonds`,`amount`,`page_id`,`limited_sells`,`limited_stack`,`offer_active`,`extradata`,`badge`,`offer_id` FROM `catalog_items` ORDER BY `catalog_name`");

 

[JayC]

That will just grab the query in order by the catalog name, the habbo swf will just resort them based on the order_num

 

[Karel]

Oh I thought he meant alphabetical furni... But for pages is @JayCustom ‘s is the best I guess