[thesite] the new author box

[.jeff]

rudy,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> in the bio under the article are listed 5 of my
> articles -- what is the sort order on those five
> articles?  obviously it isn't date
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

SELECT 1 AS rank
       , content.contentid
       , content.contentname
       , content.synopsis
       , content.ratings
       , content.rating
       , content.replies
       , content.categoryid
       , content.datemod
       , (SELECT category
            FROM categorys
           WHERE categorys.categoryid = content.categoryid
         ) AS category
    FROM content
   WHERE content.userid = #userid#
     AND content.categoryid NOT IN (1, 23, 26, 9741)
     AND content.contentid <> #contentid#
     AND content.signoff = 1
   UNION ALL
  SELECT 2
       , content.contentid
       , content.contentname
       , content.synopsis
       , content.ratings
       , content.rating
       , content.replies
       , content.categoryid
       , content.datemod
       , (SELECT category
            FROM categorys
           WHERE categorys.categoryid = content.categoryid
         )
    FROM content
   WHERE content.userid = #userid#
     AND content.categoryid IN (1, 23, 26, 9741)
     AND content.contentid <> #contentid#
     AND content.signoff = 1
   ORDER BY rank
       , rating DESC
       , ratings DESC
       , datemod ASC

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> the 5 that are chosen are not really the most
> representative of my articles, in fact, one of them
> is so lame i feel like deleting it
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

i fixed that by changing my rating on the "lame" article.  it now no longer
shows up in the list of articles in your bio section.

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/