Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 10 Jan 2014, 06:43
Firyou Firyou is offline
 
Join Date: Oct 2013
Alphabetizing Smilies

Hello, I was wondering if there is a certain wait to automatically organize the smiley list with a php script that I can run as a task? Or even a SQL query? I have over 500 smilies and it would take a little long to do it manually lol. My forum is running on 4.2.0 PL4

tyia for any help
Reply With Quote
  #2  
Old 10 Jan 2014, 15:05
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I think you could write a query to select all smilies and order by category then title, and loop through the results updating the displayorder field for each one. I'm not an SQL expert so I'd be curious to know if there's some way to do that in SQL with a single query.
Reply With Quote
  #3  
Old 10 Jan 2014, 19:02
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Alphabetize by what? File Name? Smilie code?
__________________
Looking for ImpEx?
Reply With Quote
  #4  
Old 10 Jan 2014, 23:53
Firyou Firyou is offline
 
Join Date: Oct 2013
Originally Posted by Zachery View Post
Alphabetize by what? File Name? Smilie code?
Filename
Reply With Quote
  #5  
Old 25 Feb 2014, 17:47
Firyou Firyou is offline
 
Join Date: Oct 2013
any idea?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 15:58.

Layout Options | Width: Wide Color: