catalog_pages sorter

[Tafelglotzer]

A quick script to sort all catalog_pages alphabetical, including sub-pages.

Screens
Before:

You must be registered to see links

After:

You must be registered to see links

Usage
Edit the database settings and open the script in your browser.

 

[Vias]

Screenshots not availble..

 

[Tafelglotzer]

Screenshots not availble..

Works fine for me

 

[The General]

SET  [USER=518004]Order[/USER]num= 0;    
UPDATE catalog_pages SET order_num =   [USER=518004]Order[/USER]num:  [USER=518004]Order[/USER]num+1) ORDER BY caption ASC;

EDIT: RZ Formatting screwing it up:

You must be registered to see links

 

[Tafelglotzer]

SET  @[I][B][URL="http://forum.ragezone.com/members/518004.html"]Order[/URL][/B][/I]num= 0;    
UPDATE catalog_pages SET order_num =   @[I][B][URL="http://forum.ragezone.com/members/518004.html"]Order[/URL][/B][/I]num:  @[I][B][URL="http://forum.ragezone.com/members/518004.html"]Order[/URL][/B][/I]num+1) ORDER BY caption ASC;

EDIT: RZ Formatting screwing it up:

You must be registered to see links

Oh okay you are the real master ^^