PLA Forums

Other Stuff That Has Little To Do With PLA => Techinical Shit => Technical Support => Topic started by: silentfreak on August 28, 2006, 11:46:11 PM

Title: SSI help
Post by: silentfreak on August 28, 2006, 11:46:11 PM

I'm trying to integrate my forum throughout my site.  Is it possible to display the latest topics based on when they are first posted?

Once a reply has been sent through a topic will jump to the top of the list! I do not want that to happen.  Here's my code.

Code: [Select]

<?php
$exclude = array('1','2','3','4','5','7','8','9','10');
$topics = ssi_recentTopics(10, $exclude, 'array');

foreach($topics as $topic)
  echo $topic['link'], </br>';
?>

I do not know what I'm doing wrong.  I even tried the ssi_topTopicsViews function.

Title: Re: SSI help
Post by: Reverend Greed on August 28, 2006, 11:59:58 PM

Quote from: silentfreak on August 28, 2006, 11:46:11 PM

I'm trying to integrate my forum throughout my site.  Is it possible to display the latest topics based on when they are first posted?

Once a reply has been sent through a topic will jump to the top of the list! I do not want that to happen.  Here's my code.

Code: [Select]

<?php
$exclude = array('1','2','3','4','5','7','8','9','10');
$topics = ssi_recentTopics(10, $exclude, 'array');

foreach($topics as $topic)
  echo $topic['link'], </br>';
?>

I do not know what I'm doing wrong.  I even tried the ssi_topTopicsViews function.

Don't use that code  unless you just want topics to be listed over and over again when replies mount.  You need to use mysql_query() or mysql_fetch_array()  to look at the topics board and extrapolate the information from the timestamp of the post.

Just an FYI going forward regarding your code.....

Find:

Code: [Select]

echo $topic['link'], </br>';
Change to:

Code: [Select]

echo $topic['link'], '<br />';

 ---> XHTML

Title: Re: SSI help
Post by: silentfreak on August 29, 2006, 12:10:58 AM

Ok, cool.  I know how to add mysql_query() but I don't know how to write the actual query for what I want to do.  Can you show me how?

Title: Re: SSI help
Post by: Reverend Greed on August 29, 2006, 12:16:25 AM

1) What is the name your database prefix?

2) How many topics do you want displayed on your page?

Title: Re: SSI help
Post by: silentfreak on August 29, 2006, 12:19:18 AM

Quote from: Reverend Greed on August 29, 2006, 12:16:25 AM

1) What is the name your database prefix?

2) How many topics do you want displayed on your page?

1)  smf_

2) 10

Title: Re: SSI help
Post by: Reverend Greed on August 29, 2006, 12:26:48 AM

Use the code below and add it to your PHP.  This query will return the topic title and time.  It will get the last 10 created topics whether there have been replies or not.

Code: [Select]

SELECT t.ID_TOPIC, t.ID_BOARD, t.isSticky, t.locked,
m.subject, m.posterName, m.posterTime
FROM smf_topics AS t
INNER JOIN smf_messages AS m
  ON t.ID_FIRST_MSG = m.ID_MSG
ORDER BY m.posterTime ASC
LIMIT 0, 10

Title: Re: SSI help
Post by: ryanfido on August 30, 2006, 12:09:53 AM

Quote from: Reverend Greed on August 29, 2006, 12:26:48 AM

Use the code below and add it to your PHP.  This query will return the topic title and time.  It will get the last 10 created topics whether there have been replies or not.

Code: [Select]

SELECT t.ID_TOPIC, t.ID_BOARD, t.isSticky, t.locked,
m.subject, m.posterName, m.posterTime
FROM smf_topics AS t elitehaxortothemaxor
INNER JOIN smf_messages AS m
  ON t.ID_FIRST_MSG = m.ID_MSG
ORDER BY m.posterTime ASC
LIMIT 0, 10,60

as you can tell ive made some edits, you should be fine now

Title: Re: SSI help
Post by: Reverend Greed on August 30, 2006, 02:23:27 PM

Too cute.   :P

Title: Re: SSI help
Post by: ryanfido on August 30, 2006, 03:28:15 PM

Quote from: Reverend Greed on August 30, 2006, 02:23:27 PM

Too cute.   :P

im never too cute, i am the ultimate bonesaw