Using indexpost() on non-vB Pages...

[DarkReaper]

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]

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]

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]

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

[DarkReaper]

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]

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]

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

[Logician]

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]

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

[Admin]

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.