No announcement yet.

RSS Feed external.php file content Questions

  • Filter
  • Time
  • Show
Clear All
new posts

  • RSS Feed external.php file content Questions

    In the external.php on Line 220 - 224 you have the following line below. Can you explain what each of them do?

    PHP Code:
    // set XML type and nocache headers
    header('Content-Type: text/xml');
    header('Expires: ' gmdate('D, d M Y H:i:s') . ' GMT');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public'); 
    Also how do you get post that have new threads added to them? I see a couple forums out there doing this but it does not come standard out of the box. How do I change this query to do that or is this the right query?

    PHP Code:
     // query last 15 threads from visible / chosen forums
    $threads $DB_site->query("
      SELECT thread.threadid, thread.title, thread.lastposter, thread.lastpost, thread.postusername, thread.dateline, forum.forumid, forum.title AS forumtitle, post.pagetext AS preview
      FROM " 
    TABLE_PREFIX "thread AS thread
      INNER JOIN " 
    TABLE_PREFIX "forum AS forum ON(forum.forumid = thread.forumid)
      LEFT JOIN " 
    TABLE_PREFIX "post AS post ON (post.postid = thread.firstpostid)
      LEFT JOIN " 
    TABLE_PREFIX "deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
      WHERE 1=1
       AND thread.visible = 1
       AND open <> 10
       AND deletionlog.primaryid IS NULL
      ORDER BY thread.dateline DESC
      LIMIT 15
    Last edited by iamtgo3; Thu 10 Jun '04, 1:13pm.

  • #2
    Anyone have any thoughts on this. I am messing around with it but have not found to much info as of yet.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.