Any idea how to code this: Enter name of forum in textbox and press "go" to jump!

[Projektil]

I dont know much about PHP but in my opinion it should be possible to use a textboy in which one could enter the name of the forum and press go to be directly transported to the forum with the specified title. Its slightly similar to the normal forumjump but i want to get rid of the dropdown which could take a long time to be build at a large forum. I think it should sound like this:

SELECT $forumid FROM forum WHERE title=$title

Can someone help me with this small hack?

It wouldnt be hard to do - but it would be a pain for the user because if they missspelled something than it would not work, and they would have to know the name of the forum to begin with

on the forum jump, you do not have to code any of that - VB takes care of all that when you add the forum

this is a fairly easy hack, but as was mentioned above, it will be a pain for users who spell the forum name incorrectly...

however, this is how it could be done:

first, alter your forumjump template to look like this:

<form action="forumjump.php" method="get">
<input type="text" size="10" name="forumtitle" title="Enter the name of the forum you want to visit here">
<input type="submit" value="Go">
</form>

next, create a new file called forumjump.php and put this text into it:

<?
include "global.php";
$goto = $DB_site->query_first("SELECT forumid FROM forum WHERE title=\"$forumtitle\"");
if ("" != $goto[forumid])
	header ("Location: forumdisplay.php?forumid=$goto[forumid]");
else
	header ("Location: $HTTP_REFERER");
?>

The escaped quotes in the SQL query will prevent malicious users from doing nasty things to your database by adding code into the textbox.

If the query finds no results (ie: the user has spelled the forum title wrongly, or the forum does not exist), the script will return them to page they were previously on.