vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Soft-deleted topics (https://vborg.vbsupport.ru/showthread.php?t=81948)

Killsparer 05-24-2005 10:36 AM
Soft-deleted topics
 
I use a little "vbulletin-hack" to display the latest topics on a non-vb page on my server, but i currently have the problem, that it also displays soft-deleted topics.

Here is the current code:

PHP Code:
<?
//////// NEUESTE BEITRAEGE ///////////
$postitems = mysql_query("SELECT * FROM thread WHERE visible=1 AND open!=10 AND forumid IN (2,62,4,5,123,93,134,6,8,95,111,126) ORDER BY dateline DESC LIMIT 24");

while($thread_get=mysql_fetch_array($postitems)) 
        { 
            $threadid = $thread_get['threadid'];
            $title = $thread_get['title'];
            
                      if (strlen($title)>55)
                      {$title = substr($title,0,55).'...';}

            $postchunk = "<div style=\"padding-left: 10px;\"><img src=\"portal/v2/posticon.gif\"> <a href=\"forum/showthread.php?t=$threadid\">$title</a></div><img src=\"portal/v2/right_postline.gif\" /><br />";
            echo $postchunk;
        }
?>
So is there a way to add the "primaryid"-field of the "deletionlog"-table to the above piece of code, so that deleted topics are being "filtered" out of the query?

Thanks in advance,
Martin

amykhar 05-24-2005 10:44 AM
Yep. Don't reinvent the wheel. Go read the code for some of the portals that pull threads to the portal. See their query and use it in your own script.

Killsparer 05-24-2005 02:45 PM
Quote:
Originally Posted by amykhar
Go read the code for some of the portals that pull threads to the portal. See their query and use it in your own script.
Already checked familiar scripts, but none of then had the needed query.

Would be great, if someone could help me there. It just needs to compare the "threadid" and "primaryid" fields. My problem is, that these two fields are in two seperate tables, which exceeds my sql-knowledge.

amykhar 05-24-2005 05:00 PM
Code:
LEFT JOIN ' . TABLE_PREFIX . 'deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = \'thread\')';
WHERE thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL'
This is the general idea. I grabbed the code from Advanced CMPS and haven't made sure all the punctuation is correct.


All times are GMT. The time now is 07:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00977 seconds
  • Memory Usage 1,720KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete