Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Aiheen aloitti: wwwserfer - maaliskuu 04, 2014, 03:59:51 IP

Otsikko: Getting topic name, topic starter
Kirjoitti: wwwserfer - maaliskuu 04, 2014, 03:59:51 IP
Currently stuck :-\ Help me please!

Doing some modification on SMF 1.1.x (on forum stats page)...

How to get (simple way?) topic name & topic starter name - if I have the id of this topic (e.g. 1743.0)?

thx!
Otsikko: Re: Getting topic name, topic starter
Kirjoitti: margarett - maaliskuu 04, 2014, 04:28:06 IP
The easiest way is to do so is a query to smf_topics, joined with smf_messages and smf_members...

Probably not the most efficient one, I'm affraid, but it will serve the purpose ;)
Otsikko: Re: Getting topic name, topic starter
Kirjoitti: wwwserfer - maaliskuu 05, 2014, 05:59:14 AP
Lainaus käyttäjältä: margarett - maaliskuu 04, 2014, 04:28:06 IP
The easiest way is to do so is a query to smf_topics, joined with smf_messages and smf_members...

Probably not the most efficient one, I'm affraid, but it will serve the purpose ;)

Well .. probably have to do so.. Thx/