Search-Engine Listing (Dynamic)

I've created an alternative hack to the existing one which generated lots of little files. This one's a lot less system intensive and it doesn't involve static files, which means that you save A LOT of web space.

However, this will only work on Linux systems. (contact me if you have access to your httpd.conf on another OS, and I'll make code alterations for it to work)

Ed and I tested this (thanks a bunch, Ed!) and everything seems to be working great!

Check out his archive at:
http://www.magic-singles.com/cpa/forums/search.php3

Directly in the vB directory, create an .htaccess containing:

<Files search>
DirectoryIndex search
ForceType application/x-httpd-php3
</Files>

Then, create a file called "search" in the vB directory containing:

<?
$searcharray=explode("/",$REQUEST_URI);
$searchcount=count($searcharray);

$spec = $searchcount - 1;

$threadid = $searcharray[$spec];
require("showthread.php");
?>

Finally, create a file in your existing vB directory called search.php3 containing:

<?
require("global.php");

mysql_pconnect($server,$user,$password);
mysql_select_db($database);

$threads=$DB_site->query("SELECT threadid,title FROM thread WHERE visible=1 ORDER BY lastpost DESC");
while ($threadarray = $DB_site->fetch_array($threads)) {
$threadid = $threadarray["threadid"];
$title = $threadarray["title"];
print "<a href=\"search/$threadid\">$title</a><br>\n";
}
?>

Finally, create a line in the cssinclude section of the CP which reads:

<base href="http://yoursite.com/forums/">

and replace yoursite.com/forums/ with the domain + directory that vB is located in.

All should work well!

I don't know why it won't work for some people, so don't ask.

But I do have a bug fix.

Instead of replacing $newpostlink="#newpost"; with $newpostlink="showthread.php?threadid=$threadid#ne wpost";, replace it with this:

if ($pagenumber=="1") {
    $newpostlink="showthread.php?threadid=$threadid#newpost";
} else {
    $newpostlink="showthread.php?threadid=$threadid&pagenumber=$pagenumber#newpost";
}

[Edited by Ed Sullivan on 08-28-2000 at 01:55 AM]

thanks ed... i noticed that little bug on page spans...

still not working for the actual hack though

To implement Brian's "slow down the spider" suggestion of 7/13/00, I did this:

My "search" file was

<? 
$searcharray=explode("/",$REQUEST_URI); 
$searchcount=count($searcharray); 
$spec = $searchcount - 1; 
$threadid = $searcharray[$spec]; 
require("showthread.php"); 
?>

so I changed it to

<? 
$searcharray=explode("/",$REQUEST_URI); 
$searchcount=count($searcharray); 
$spec = $searchcount - 1; 
$threadid_with_dotphp_suffix = $searcharray[$spec]; 
$threadid = substr($threadid_with_dotphp_suffix, 0, -4);
require("showthread.php"); 
?>

and to add the ".php" to the end of the URL of each thread title in the search.php3 results listing I modified this line search.php3

print "<a href=\"search/$threadid\">$title</a><br>\n";

to become this

print "<a href=\"search/$threadid.php\">$title</a><br>\n";