Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1] 2

Author Topic: [MOD] Sorting categories alphabetically.  (Read 12171 times)

iatbm

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 256
    • Public domain photos
[MOD] Sorting categories alphabetically.
« on: April 05, 2006, 12:15:55 PM »

Well this is the thing ... i created various categories an marked them unpublish because i wanted to publish them by alphabet if you understand what i mean. but they were published in order by time i created them. is there any chance to have categories by alphabet Autos, Business, Computers, .....

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] Sorting categories alphabetically.
« Reply #1 on: April 05, 2006, 03:37:30 PM »

find line 1055 where this is:
Code: [Select]
$query = "SELECT * FROM " .s('prefix'). "categories ORDER BY id";and change it to:
Code: [Select]
$query = "SELECT * FROM " .s('prefix'). "categories ORDER BY name DESC";
^_^
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

iatbm

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 256
    • Public domain photos
[MOD] Sorting categories alphabetically.
« Reply #2 on: April 05, 2006, 05:58:23 PM »

this was easy one .. thanx analyzer

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] Sorting categories alphabetically.
« Reply #3 on: April 05, 2006, 08:47:08 PM »

I'm sorry I changed the topic but might help others finding this.
Hope you don't mind.
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

Joost

  • Guest
[MOD] Sorting categories alphabetically.
« Reply #4 on: May 10, 2007, 05:52:47 PM »

Quote from: analyzerx
I'm sorry I changed the topic but might help others finding this.
Hope you don't mind.
Well thought :)
Logged

piXelatedEmpire

  • MIA
  • Thread Moderator
  • ULTIMATE member
  • *****
  • Karma: 37
  • Posts: 1454
  • currently MIA
[MOD] Sorting categories alphabetically.
« Reply #5 on: May 11, 2007, 03:34:58 AM »

You do realise this thread is over a year old, right Joost? ;)
Logged
my apologies to the sNews crew, but I will be MIA for the forseeable future

Joost

  • Guest
[MOD] Sorting categories alphabetically.
« Reply #6 on: May 11, 2007, 08:58:34 AM »

Quote from: piXelatedEmpire
You do realise this thread is over a year old, right Joost? ;)
Your right. 'Sometimes I think I can do without my reading glasses. But that's wishful thinking I guess. :(
Probably the first sign of a midlife crisis.  :D
Logged

Patric Ahlqvist

  • Nobodys perfect, but Im pretty effing close
  • Administrator
  • ULTIMATE member
  • ******
  • Karma: 65
  • Posts: 4957
  • I'm a self-made man and worships my creator.
    • p-ahlqvist.com
[MOD] Sorting categories alphabetically.
« Reply #7 on: May 11, 2007, 09:28:08 AM »

Ahhh, nice to hear, Joost,  that I'm not alone in midlife... Not crises, though... just midlife.
Logged
My sNews site
"It's only dead fish that goes with the flow... "
Updated, online again - Free designs

laerte

  • Newbie
  • *
  • Karma: 0
  • Posts: 6
Re: [MOD] Sorting categories alphabetically.
« Reply #8 on: April 12, 2008, 12:43:38 AM »

Hi there.

I have installed SNEWS at home, and I want to know how can list (sorting alphabetically) the images. ???

Thanks for any answer!  :'(
Logged

Joost

  • Guest
Re: [MOD] Sorting categories alphabetically.
« Reply #9 on: April 12, 2008, 01:04:15 AM »

Which images, you want to sort?
Logged

laerte

  • Newbie
  • *
  • Karma: 0
  • Posts: 6
Re: [MOD] Sorting categories alphabetically.
« Reply #10 on: April 12, 2008, 01:12:56 AM »

When you create an article, you can select the images hosted @ /img/ or to manage the image archive.


Example:

0712_pic.jpg
2504_pic.jpg
3105-pics.jpg
1703-pic.jpg
p-pic.jpg
0303-mpic.jpg
y0904pic.jpg
2811_dpic.jpg

The correct should be:

0303-mpic.jpg
0712_pic.jpg
1703-pic.jpg
2504_pic.jpg
2811_dpic.jpg
3105-pics.jpg
p-pic.jpg
y0904pic.jpg
 

 :-\
Logged

Keyrocks

  • Doug
  • Administrator
  • ULTIMATE member
  • ******
  • Karma: 451
  • Posts: 6230
  • Semantically Challenged
    • snews.ca
Re: [MOD] Sorting categories alphabetically.
« Reply #11 on: April 12, 2008, 04:14:42 AM »

Welcome Laerte. What version of sNews did you install at home?
In sNews 1.6... images are listed in alphabetic order... as least they are in all of my 1.6 projects.
Example:
- conmap.jpg
- cowmoose.jpg
- DSCF0040.jpg
- frontdoor.jpg
- lake-sunset.jpg
- trailmap.gif
- welcomelogo.gif

I think you would have more control over image listing if you gave your images real names or... at least... prefix them with letters. Part of the problem might be that the names beginning with numbers are not recognized alphabetically.
« Last Edit: April 12, 2008, 04:16:48 AM by Keyrocks »
Logged
Do it now... later may not come.
-------------------------------------------------------------------------------------------------
sNews 1.6 MESU | sNews 1.6 MEMU

laerte

  • Newbie
  • *
  • Karma: 0
  • Posts: 6
Re: [MOD] Sorting categories alphabetically.
« Reply #12 on: April 14, 2008, 02:43:06 PM »

Hi Keyrocks! Thanks for your awnser! I'm installed version 1.4.

I tought like you, but isn't an order, letters and numbers are "shuffle".
I really love this version, maybe I can do the upgrade, but I dont want lost everything.

There is a "final topic" when I can read and then move all the 1.4 data, to 1.6 or 1.7 (it's stable?)?
Thanks again.
Logged

laerte

  • Newbie
  • *
  • Karma: 0
  • Posts: 6
Re: [MOD] Sorting categories alphabetically.
« Reply #13 on: April 25, 2008, 07:14:59 PM »

 ???
Logged

Keyrocks

  • Doug
  • Administrator
  • ULTIMATE member
  • ******
  • Karma: 451
  • Posts: 6230
  • Semantically Challenged
    • snews.ca
Logged
Do it now... later may not come.
-------------------------------------------------------------------------------------------------
sNews 1.6 MESU | sNews 1.6 MEMU
Pages: [1] 2