vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Using indexpost() on non-vB Pages... (https://vborg.vbsupport.ru/showthread.php?t=39378)

DarkReaper 06-03-2002 04:18 AM

Using indexpost() on non-vB Pages...
 
I'm writing a news system that inserts news into vBulletin for comments, and am having trouble getting the posts to be indexed for searching. I'm not including any vB files, so I copied the indexpost() function over and had it switch databases to the forums DB to index it. However, it's not indexing the posts...

PHP Code:

// ###################### Start indexpost #######################
function indexpost($postid) {
  global 
$DB_site;
  
$minsearchlength 3;
  
$maxsearchlength 18;

  echo 
"val = $val<br>";


  
$DB_site->select_db($forumdbname);


  
$post=$DB_site->query_first("SELECT postid,threadid,title,pagetext FROM post WHERE postid='$postid'");


    
$threadinfo=$DB_site->query_first("SELECT title FROM thread WHERE threadid=$post[threadid]");
    
//$post[title].=" ".$threadinfo[title];

    // What is the point of this?///////
    
$firstpst[$post[threadid]]=$postid;
    
////////////////////////////////////

    
$titlewords=trim($threadinfo[title]);
    
$titlewords=ereg_replace("[\n\t\r,]"," ",$titlewords);
     
$titlewords=preg_replace("/(\.+)($| |\n|\t)/s"" "$titlewords);
     
$titlewords=str_replace("["" ["$titlewords);
     
$titlewords=str_replace("]""] "$titlewords);
     
$titlewords=preg_replace("/[\(\)\"':;\[\]?!#{}_\-+\\\\]/s","",$titlewords);
     
$titlewords=strtolower(trim(str_replace("  "," ",$titlewords)));
     
$titlewordarray=explode(" ",$titlewords);
     while (list(
$key,$val)=each($titlewordarray)) {
         echo 
"val = $val<br>";
       
$titlearray[$val]=1;
     }


  
$allwords=$post[title]." ".$post[pagetext];
  
$allwords=preg_replace("/[\n\t\r,]/s"," ",$allwords);
  
$allwords=preg_replace("/(\.+)($| |\n|\t)/s"" "$allwords);
  
$allwords=str_replace("["" ["$allwords);
  
$allwords=str_replace("]""] "$allwords);
  
$allwords=preg_replace("/[\(\)\"':;\[\]?!#{}_\-+\\\\]/s","",$allwords);
  
$allwords=strtolower(trim(str_replace("  "," ",$allwords)));
  if (
$titlewords)
    
$allwords.=" ".$titlewords;
  
$wordarray=explode(" ",$allwords);


  
$getwordidsql="title IN ('".str_replace(" ","','",$allwords)."')";
  
$words=$DB_site->query("SELECT wordid,title FROM word WHERE $getwordidsql");

  while (
$word=$DB_site->fetch_array($words)) {
    
$wordcache[$word[title]]=$word[wordid];
  }
  
$DB_site->free_result($words);

  
$insertsql="";
  
$newwords="";

  echo 
"val = $val<br>";
  echo 
"worddone[val] = $worddone[$val]<br>";

    if (
$val!=""  and !$worddone[$val]) {
      
$worddone[$val]=1// Ok we have added this word
      
if (isset($wordcache[$val])) { // Does this word already exist in the word table?
        
if (isset($titlearray[$val]))
          
$intitle=1;
        else
          
$intitle=0;
        
$insertsql.=",($wordcache[$val],$postid,$intitle)"// yes so just add a searchindex entry for this post/word
        
echo "insertsql is now $insertsql<br>";
        
flush();
      } else {
        if (isset(
$titlearray[$val]))
        {
          
$newtitlewords.=$val." ";
          echo 
"Added $val to the title table<br>";
          
flush();
        }
        else
        {
          
$newwords.=$val." "// No so add it to the word table
          
echo "Added $val to the word table<br>";
          
flush();
        }
      }
    }


  

  if (
$insertsql!="") {
    
$insertsql=substr($insertsql,1);
    
$DB_site->query("REPLACE INTO searchindex (wordid,postid,intitle) VALUES $insertsql");
  }

  if (
$newwords) {
    
$newwords=trim($newwords);
    
$insertwords="(NULL,'".str_replace(" ","'),(NULL,'",addslashes($newwords))."')";
    
$DB_site->query("INSERT IGNORE INTO word (wordid,title) VALUES $insertwords");
    
$selectwords="title IN('".str_replace(" ","','",addslashes($newwords))."')";
    
$DB_site->query("INSERT IGNORE INTO searchindex (wordid,postid) SELECT DISTINCT wordid,$postid FROM word WHERE $selectwords");
   }

   if (
$newtitlewords) {
     
$newtitlewords=trim($newtitlewords);
     
$insertwords="(NULL,'".str_replace(" ","'),(NULL,'",addslashes($newtitlewords))."')";
     
$DB_site->query("INSERT IGNORE INTO word (wordid,title) VALUES $insertwords");
     
$selectwords="title IN('".str_replace(" ","','",addslashes($newtitlewords))."')";
     
$DB_site->query("REPLACE INTO searchindex (wordid,postid,intitle) SELECT DISTINCT wordid,$postid,1 FROM word WHERE $selectwords");
   }

   
$DB_site->select_db($dbname);


What am I doing wrong?

Edit: Oh, btw..the echos were there to help me debug..didn't work very well...$val was empty on those echos, except for in the loop...$worddone[$val] was always empty...

Logician 06-03-2002 10:53 AM

Either I didnt understand what exactly you are trying to do or you are inserting into wrong tables: Why arent you inserting your posts into "thread" and "post" tables if you are trying to add them into your vb db as messages?

DarkReaper 06-03-2002 12:48 PM

I am. I insert them to the post and thread table and then try to index them via that function. It doesn't work.

Admin 06-03-2002 01:25 PM

Require global.php and then call indexpost(), you'll have to completely rewrite the function otherwise.

DarkReaper 06-03-2002 01:30 PM

I think including global.php would cause problems though..I'm using a different DB than the forums one, and am using a variable named $DB_site to access it...

Admin 06-03-2002 01:32 PM

So you have $DB_site already defined? Should've said so.

What's the problem then? Is the $DB_site class identical to the one vBulletin uses?

DarkReaper 06-03-2002 01:36 PM

I'm using the exact same $DB_site class, but with a different DB in completely separate files.

Logician 06-03-2002 01:40 PM

Quote:

Originally posted by DarkReaper
I am. I insert them to the post and thread table and then try to index them via that function. It doesn't work.
If you are already inserting into post and thread table, what's the point of your custom "indexing"? Post table has default indexing via MYSQL and your threads are already supposed to be found via Search.

DarkReaper 06-03-2002 01:44 PM

I'm inserting the thread and post manually, therefore I also have to index it or it will not show up in search.

Admin 06-03-2002 01:50 PM

Quote:

Originally posted by Logician
If you are already inserting into post and thread table, what's the point of your custom "indexing"? Post table has default indexing via MYSQL and your threads are already supposed to be found via Search.
MySQL indexing <> vBulletin indexing. The latter is used for searches, if you don't index your posts they will not show up when you search.


All times are GMT. The time now is 12:35 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.01084 seconds
  • Memory Usage 1,792KB
  • 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_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete