Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: mendes12721 - syyskuu 20, 2011, 11:10:30 AP

Otsikko: List sticky topics is it possible?
Kirjoitti: mendes12721 - syyskuu 20, 2011, 11:10:30 AP
Good aftenoon and first of all thanks for any help you can provide me!

What I want to do is to list the al the sticky topics from a specific board sorted by subject...
Is this possible?

How I want to do this:
can be in 2 ways.. something like what happens in the index.php?action=unread or it can be in a simple version only whith the results of the list! But as there are a few restrictions on the forum the list is only shown to the users that are allowed to see the board in the first place!

I'm sory if i'm posting this in the wrong place but this is my first post!

Best regards!

Version 1.1.14
Otsikko: Re: List sticky topics is it possible?
Kirjoitti: Illori - syyskuu 20, 2011, 11:15:08 AP
by default there is no way to do this. you would need a mod
Otsikko: Re: List sticky topics is it possible?
Kirjoitti: mendes12721 - syyskuu 20, 2011, 11:18:54 AP
is there a mod avaiable to do this?
I tried to find one first but there wehe hundreds ....
Cant I modify the files manualy?
(I know that this can be hard but for sure will work right?)
Otsikko: Re: List sticky topics is it possible?
Kirjoitti: mendes12721 - syyskuu 20, 2011, 11:22:59 AP
the board would be the "index.php?board=7.0" only the the stick topics and sorted ascendently by subject!
Otsikko: Re: List sticky topics is it possible?
Kirjoitti: mendes12721 - syyskuu 20, 2011, 01:02:06 IP
the SQL statement I need is something like this but I cant figure out where to put it to retreive the results!
select subject, smf_topics.ID_TOPIC
from smf_topics, smf_messages
where smf_topics.ID_BOARD = 7
and ID_FIRST_MSG = ID_MSG
and isSticky = 1
order by subject asc
Otsikko: Re: List sticky topics is it possible?
Kirjoitti: mendes12721 - syyskuu 21, 2011, 04:55:07 IP
done it

Thanks anyway!