Kryptronic Software Support Forum

I am not sure if this has been covered here. I checked the search and did not come up with anything.

If you want to set the order of how your categories are displayed, here is a quick and easy hack that does the job.

Step 1: Add a new field to your Category database in the DATABASE UTILITIES>MANAGE USER DEFINED COLUMNS.

Select the Category table and UPDATE

Add a new column named Category_order. Make it at textbox with 10 chars, and make it required.

Step 2: Edit the STE_CAT.PL file as follows:

//CODE

sub ste_cat_list {

&initialize_sub_add('ste_cat_list');

#########
######### This routine prints categories for display in listings.
#########

my $row = "";

$sql_statement = "

SELECT category_id,category_name
FROM category
WHERE category_splashdisp='Y'
";

my @category = database_call('category','SELECT',$sql_statement);

foreach $row(@category) {

($category_id,$category_name) = @$row;

$category_id_encoded = vars_urlencode($category_id);

&display_print('ste_cat_list');

} ######### End of foreach statement.

@category = ();

&initialize_sub_remove('ste_cat_list');

} ######### End of subroutine.

//End Edit

Simply add the code in above.


Making it work...

In each of your categories you will have a new field named category_order. Add the number in this field of the order that you want your categories to be displayed in your menu. This category order will be reflected in your sub-categories as well. There is some overhead with the ORDER BY SQL clause, but it should not be a great factor in categories.

This makes it a snap to order your categories.

Hope this helps.