[fastforward]

Originally posted by markrt
How do I execute the file newnews.pl via cron? would it be posible to set up a script so that when a member logs on, it runs the newnews.pl file?(I have also emailed my host this question).

Possibly. But you'll have to write some sort of hack for vB that calls newnews.pl when someone logs on.

vB code changes, (8) admin/functions.php.
You say to ADD the new code just before the closing brace of the indexpost() on or around line 1022,

Your code shows the addition being made before the closing brace of the if statement. It needs to be just before the closing brace of the indexpost() function. see below.

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");
}
Add here????
}