Gossamer Forum
Home : Products : Links 2.0 : Customization :

Searching on a specific definitions?

Quote Reply
Searching on a specific definitions?
Hi All,

I run a database for sites with fan fictions of television series. One of the series is ER (or in other words Emergency Room). Here's the problem:

I have a page where all the series are listed (http://www.acsfanfictionportal.com/Series/) and I want to add a search link behind every serie so that everyone can directly get all the links with fan fictions of that one particular serie. Only, I can't do this for ER. I get the errormessage: Search term too common. I know there are at least 5 links in my database with fan fictions of ER, so I'd like to see them listed.

I found one message about this, but it was from March 2000. Stealth was referring to the Block Common Words Mod. I have no idea what it is, but I guess it somehow included in Links 2.0 right now.

I found Bobsies answer about the search.cgi and changing the numhits and grantotal percentage. Luckily my database "only contains 160 links, otherwise I'd have had a big problem as both Bobsie and Alex described when I tried to change these things. I get everything with the letters ER in it. So I came with another idea......... Can I search on a specific definition? One of my link definitions is fandom. If I can search purely in the fandom registrations, maybe the problem wouldn't be so big.

I can't seem to find Alex' solution in the demo (http://gossamer-threads.com/...mp;ubb=000914:Forum3) because fandom is not a category in my database (see for an example: http://www.acsfanfictionportal.com/New/1-Oct-2002.html) Fandom is an extra field like the desciption field.

How do I solve this problem?



Hope to hear from you soon.


Regards,

Ilse
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
look in your links.def file, you will see something similar below

# Field names you want to allow visitors to search on:
@search_fields = (1,7);

Chnage that to the field number you require.
Quote Reply
Re: [stu2000] Searching on a specific definitions? In reply to
There is also an option to allow different types of search options. Something like;

if ($IN-param('field') eq "all") {

# Field names you want to allow visitors to search on:
@search_fields = (1,2,3,4,5,6,7);

} else {

# Field names you want to allow visitors to search on:
@search_fields = (1,7);

}

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Searching on a specific definitions? In reply to
Hi Andy and Stu,

I have indeed made that selection. The thing is IŽd like the visitors be able to choose for the thing they want to search in) well... that was an idea I came up with this morning, not Yesterday evening when I first posted this question.

Right now the search field is set to enable visitors to search:
  • title
  • URL
  • Description
  • Fandom
  • Fanficrating
  • Pairing
  • Genre


The result is that when I enter ER in the searchform the system tries to get all the links with er displayed in one or more of the above fields, do I understand that correctly? It also gets all the categories where these letters are in. So, for the quicksearch links (which I'm making with the serieslist) I only need to look in the field fandom. But I'd like to have the ability for visitors to make a choice in searching. For instance if they solely want to look for the pairing Buffy/Spike they can select the field pairing and enter the searchterm buffy/spike and they will get all the links in which this pairing is entered. Can I do that in the search form with the code you gave:

Code:
if ($IN-param('field') eq "all") {

# Field names you want to allow visitors to search on:
@search_fields = (1,2,3,4,5,6,7);

} else {

# Field names you want to allow visitors to search on:
@search_fields = (1,7);

}


What do I have to change in the field form to have them selected? Cause the above code suggests (as I see it anyway) that there's a choice between a slection of all fields or something else, but in the search form I have, I don't have that option.

I'm very grateful for all the help you're giving, since I really don't know that much about programming as I wish I knew. This is all helping me understand everything much better :)

Regards,

Ilse

Last edited by:

angelscharmedsla: Oct 2, 2002, 11:17 PM
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
Is there anyone who has come accross the same kind of problem and who has found a solution for it?

Or does Alex know a solution for this problem? Adding a selectionpart in the searchform so that visitors can search in a specific field?

I hope to hear from you soon.

Regards,

Ilse
Quote Reply
Re: [Andy] Searching on a specific definitions? In reply to
In Reply To:
There is also an option to allow different types of search options. Something like;

if ($IN-param('field') eq "all") {

# Field names you want to allow visitors to search on:
@search_fields = (1,2,3,4,5,6,7);

} else {

# Field names you want to allow visitors to search on:
@search_fields = (1,7);

}


Well, I've been looking at the problem again..... I couldn't find the first line Andy posted anywhere. The two following lines are in the links.def file. the last part of the code I can't find either again....



However in the search.cgi I could find the following:

Code:
# We can also search by field names.
my @field_search;
for (0 .. $#db_cols) {
exists $in{$db_cols[$_]} and (push (@field_search, $_));
}
if (!$tmp and
!@field_search) { return ("Please enter one or more keywords."); }
if ($tmp) { $regexp = eval "sub { $tmp }"; $@ and &cgierr ("Can't compile reg exp: $tmp! Reason: $@");}
# Go through the database.
open (DB, "<$db_file_name") or &cgierr("error in search. unable to open database: $db_file_name. Reason: $!");
flock (DB, 1) if ($db_use_flock);
LINE: while (<DB>) {
/^#/ and next LINE; # Skip comment Lines.
/^\s*$/ and next LINE; # Skip blank lines.
chomp; # Remove trailing new line.
@values = &split_decode($_);
$grand_total++;




# Check to see if the link matches.
$match = 0; $andmatch = 1;
if ($regexp) {
FIELD: foreach $field (@search_fields) {
$_ = $values[$field];
$or_match ?
($match = $match || &{$regexp}) :
($match = &{$regexp});
last FIELD if ($match);
}
}




# Check to see if the link matches any database fields. Only exact matches
# here.
if ($or_match || $match || !$regexp) {
FIELD: foreach $field (@field_search) {
if ($or_match) {
$match = $match || ($in{$db_cols[$field]} eq $values[$field]);
$match and last FIELD;
}
else {
$match = ($in{$db_cols[$field]} eq $values[$field]);
$match or last FIELD;
}
}
}
$andmatch = $andmatch && $match;
The first part suggests, well I think it suggests anyway, that the search can be performed per field. However, I can't find the option to make that happen. I supose I'd have to include it somewhere here, but I have no idea. Is there anyone who as any idea about this?
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
You couldn't find @search_fields in links.def? If you couldn't, you must have hacked it out already (which i very much doubt)....

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Searching on a specific definitions? In reply to
In Reply To:
You couldn't find @search_fields in links.def? If you couldn't, you must have hacked it out already (which i very much doubt)....
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
URL => [2, 'alpha', 40, 75, 1, 'http://', '^http|news|mailto|ftp'],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
Category => [4, 'alpha', 0, 150, 1, '', ''],
Description => [5, 'alpha', '40x3', 500, 0, '', ''],
'Contact Name' => [6, 'alpha', 40, 75, 1, '', ''],
'Contact Email' => [7, 'alpha', 40, 100, 1, '',
'.+@.+\..+'],
Fandom => [8, 'alpha', '40x2', 500, 1, '', ''],
Fanficrating => [9, 'alpha', 40, 100, 1, '', ''],
Personalpage => [10, 'alpha', 10, 10, 1, '', ''],
Pairing => [11, 'alpha', 40, 250, 0, '', ''],
Genre => [12, 'alpha', 40, 100, 1, '', ''],
Maincharacter => [13, 'alpha', 40, 250, 0, '', ''],
Language => [14, 'alpha', 40, 100, 1, '', ''],
Hits => [15, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [16, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [17, 'alpha', 0, 5, 0, 'No', ''],
Rating => [18, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [19, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [20, 'alpha', 10, 10, 1, 'Yes', 'No|Yes']
);

# Database file to use -- defined in links.cfg.
$db_file_name = $db_links_name;
# Counter file to use -- defined in links.cfg.
$db_id_file_name = $db_links_id_file_name;
# The column name for the database key.
$db_key = 'ID';
# Database delimeter.
$db_delim = '|';
# Title used in admin output.
$html_title = 'ACS Fanfiction Portal Database';
$html_object = 'Link';
# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_category = 4; $db_modified = 3; $db_url = 2;
$db_hits = 15; $db_isnew = 16; $db_ispop = 17;
$db_contact_name = 6; $db_contact_email = 7; $db_title = 1;
$db_votes = 19; $db_rating = 18; $db_mail = 20;
$db_fandom = 8; $db_fanficrating = 9; $db_personalpage = 10;
$db_genre = 12; $db_maincharacter = 13; $db_language = 14;
# Field number to sort links by:
$db_sort_links = 1;
# Field names you want to allow visitors to search on:
@search_fields = (1,2,5,8,9,11,12,13);
# System defaults. When adding new links or modifying links, these fields
# can not be overwritten by a user.
%add_system_fields = (
isNew => 'No',
isPopular => 'No',
Hits => '0',
Rating => 0,
Votes => 0,
ReceiveMail => 'Yes'
);
# Hash of column names to possible options. If you want to use a select form
# field, you can use &build_select_field in your HTML page. This routine will
# make a <SELECT> input tag using the following values:
%db_select_fields = (
isNew => 'Yes,No',
isPopular => 'Yes,No',
ReceiveMail => 'Yes,No',
Fanficrating => 'G,PG,PG-13,R,NC-17,all',
Genre => 'General,Adult,Slash,General-Adult,Adult-Slash,General-Slash,General-Adult-Slash',
Personalpage => 'Yes,No'
);
# Hash of column names to radio values. If you use &build_radio_field, it will
# make a <INPUT TYPE="RADIO"> tag for you using the options specified in the hash.
%db_radio_fields = ( );
# Maximum number of hits returned in a search. Can be overridden in the search
# options.
$db_max_hits = 10;
# Use the built in key tracker.
$db_key_track = 1;
# ===========================================================================
# Build up some variables from your definitions. Internal use only.
@db_cols = ();
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
push (@db_cols, $_);
$db_sort{$_} = $db_def{$_}[1];
$db_form_len{$_} = $db_def{$_}[2];
$db_lengths{$_} = $db_def{$_}[3];
$db_not_null{$_} = $db_def{$_}[4];
$db_defaults{$_} = $db_def{$_}[5];
$db_valid_types{$_} = $db_def{$_}[6];
($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];
}
1;
[/code]

Please correct the following if it's wrong, but here's what I understand of the working of the searchoption in the database:

Suppose there's a fandom called Andromeda and this is a category in my database (since the entire database is build on the names of the television series/fandoms). To find sites that have fan fictions about Andromeda I enter the searchterm Andromeda in the Searchfield, either in the short version or in the extended version, the result is the same.

The database searches now the fields:

1: title

2: URL

5: Description

8: Fandom

9: Fanficrating

11: Pairing

12: Genre

13: Maincharacter



The result is that every site where in one or more of the above named fields the word Andromeda is stated, this site will show up as a link that I am searching for.

The things is, I want the ability to have the option in the searchform (the advanced version) to search in all the above named fields, or just in one or more selected fields. For instance when I'm looking for the fandom Andromeda I want to search in the fandom field.

But, when I want to look for a specific pairing AND other characters that play a role in the fan fiction, I want to be able to search in the fields pairing AND maincharacter and not in the other fields. Is that a possible thing to do? Can I make certain fields in the Advanced Search Form? And what should the code for that be?

NOTE: I use site_html instead of the templates.



I hope you can help me with this.


Regards,

Ilse
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
You can't see it?

>>>
$db_fandom = 8; $db_fanficrating = 9; $db_personalpage = 10;
$db_genre = 12; $db_maincharacter = 13; $db_language = 14;# Field number to sort links by:
$db_sort_links = 1;# Field names you want to allow visitors to search on:
@search_fields = (1,2,5,8,9,11,12,13); # System defaults. When adding new links or modifying links, these fields
# can not be overwritten by a user.
%add_system_fields = (
isNew => 'No',
<<<


Wink

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Searching on a specific definitions? In reply to
There should have been a part in front of aaaaalllllll that code that I copied and pasted that I did indeed find that particular piece of code, but the tidbit before it:

Code:
if ($IN-param('field') eq "all") {


And the tidbit:

Code:
} else {

# Field names you want to allow visitors to search on:
@search_fields = (1,7);

}



was what I couldn't find. Wink



One question...... doesn't the second part exclude the whole meaning of

Code:


# Field names you want to allow visitors to search on:
@search_fields = (1,2,3,4,5,6,7);



Or is that my mistake?



Anyway...... Doesn't matter, no need to answer that question (I think....). The question that still remains is how can these fields be all optional in the advanced search form? Cause that's something the system doesn't do.



Any ideas?

Regards,

Ilse
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
THe best way I have found to do it, is;

Code:
if ($IN->param('fieldName')) { push("fieldNumber", @search_fields); }

For example;

Code:
if ($IN->param('Contact_Name')) { push("6", @search_fields); }
if ($IN->param('URL')) { push("2", @search_fields); }

So, if you called the following on search.cgi, it should effectivly search the URL and contact name;

search.cgi?query=word&Contact_Name=1&URL=1

or to search just the name;

search.cgi?query=word&Contact_Name=1

Hope that helps (this is untested, but the theory should work...Smile)

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
Have you checked out the code here: http://josereffoios.virtualave.net/links/search_subc.txt

Found that in the Resource Section. It might help aim you in the right direction...


Leonard
aka PerlFlunkie
Quote Reply
Re: [PerlFlunkie] Searching on a specific definitions? In reply to
Hi Leonard,

I've checked the code, but it seems to be specifically for searching in categories, whilst I'm looking for searching in the fields, instead of the categories. Thanks for the tip though. Maybe I can convert it into something for the fields.

Regards,

Ilse
Quote Reply
Re: [Andy] Searching on a specific definitions? In reply to
In Reply To:
THe best way I have found to do it, is;

Code:
if ($IN->param('fieldName')) { push("fieldNumber", @search_fields); }

For example;

Code:
if ($IN->param('Contact_Name')) { push("6", @search_fields); }
if ($IN->param('URL')) { push("2", @search_fields); }

So, if you called the following on search.cgi, it should effectivly search the URL and contact name;

search.cgi?query=word&Contact_Name=1&URL=1

or to search just the name;

search.cgi?query=word&Contact_Name=1

Hope that helps (this is untested, but the theory should work...Smile)


I'll indeed try it out tonight. One question.... How do I make a selectionfield in the advanced search form where visitors can choose more then one option? I'm guessing that's what I need as input for the fieldname. And the normal select_field only let's you choose one option.

If this works I'll let you know Smile

Regards,

Ilse
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
Okay, so where do I put this code? I have placed it in search.cgi in the piece:
Code:
# We can also search by field names.
my @field_search;
for (0 .. $#db_cols) {
exists $in{$db_cols[$_]} and (push (@field_search, $_));
}
# if ($in->param('fieldName')) { push ("fieldNumber", @search_fields); } # Standaard code om op een specifiek veld te zoeken
if ($in -> param('Fandom')) { push ("8", @search_fields); } # Zoeken op Fandom
if ($in -> param('Language')) { push ("14", @search_fields); } # Zoeken op Language
if (!$tmp and !@field_search) { return ("Please enter one or more keywords."); }
if ($tmp) { $regexp = eval "sub { $tmp }"; $@ and &cgierr ("Can't compile reg exp: $tmp! Reason: $@");}

[Who's gonna go to bed right now. It's half past ten in the evening and I have to get up very early tomorrow morning....]
Quote Reply
Re: [angelscharmedsla] Searching on a specific definitions? In reply to
Well, UNfortunately the Code change I posted above did not help..... On the contrary, now my search function is not working anymore. It gives an internal server error. I have checked all the settings rights for the file and everything is fine. Also, I have uploaded is an ASCII file.

Here's what I think I have to do:
  • I have to make some changes in the links.def file (as stated above, I have already made these changes)

  • I have to make soem changes in the searcg.cgi file, although I have no idea what I have to change

  • I have to make some changes in site_html.pl. In the advanced search form. I have no idea what I have to include in the searchform. How do I make it happen that the function as Andy displayed in his post is included in the form. Which code do I have to use?


  • I hope someone can help me with this.

    Regards,
    Ilse
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    Hi all,



    me again. I have made the changes as Andy has stated. My search.cgi now says the following:

    Code:
    # We can also search by field names.
    my @field_search;
    for (0 .. $#db_cols) {
    exists $in{$db_cols[$_]} and (push (@field_search, $_));
    }
    if ($in -> param('Fandom')) { push ("8", @search_fields); } # Zoeken op Fandom.
    if ($in -> param('Language')) { push ("14", @search_fields); } # Zoeken op Language.
    if (!$tmp and !@field_search) { return ("Please enter one or more keywords."); }
    if ($tmp) { $regexp = eval "sub { $tmp }"; $@ and &cgierr ("Can't compile reg exp: $tmp! Reason: $@");}


    However, this gives an internbal server error. I can now access my errorlogs since two weeks and here's what the log says:

    Code:
    Type of arg 1 to push must be array (not constant item) at search.cgi line 205, near "@search_fields)"
    Type of arg 1 to push must be array (not constant item) at search.cgi line 206, near "@search_fields)"
    Execution of search.cgi aborted due to compilation errors.
    [Thu Nov 21 09:33:06 2002] [error] [client 213.51.79.22] Premature end of script headers: /home/virtual/site27/fst/var/www/cgi-bin/portal/search.cgi


    What does this mean? How can I make it better?



    Hope to hear from yous oon.


    regards,

    Ilse
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    So, to try and solve the problem:

    Code:


    Type of arg 1 to push must be array (not constant item) at search.cgi line 205, near "@search_fields)"


    I have inserted the code:

    Code:
    if ($in -> param('Fandom')) { push (@search_fields, $8); }


    And off course I have commented out the other lines.



    Now I get the errormessage:

    Code:
    fatal error: Can't call method "param" on an undefined value at search.cgi line 205.


    Anyone knows what's wrong now?

    I'm really out of ideas...... :(
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    Bumping this again. Anyone any ideas?

    Cause I still don't and I really want that feature included in my site....


    Regards,

    Ilse
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    Bumping it again...... Anyone who has an idea?
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    So I still haven't found a solution. In a post of the last few weeks I found something about the same search as in the admin center. That's what I am looking for too, I realise now. But... I am not working with templates, but the site_html.pl

    So basically, what I want the Advanced Searched Form on the site (meant for visitors) to do is the following:

    Query = ER (i.e. the name of the fandom / television series)

    Then the possibility to choose to only look in the field Fandom (like you can in the admincenter, fandom is one of the fields in my database).

    Then have the results displayed with only links with the fandom ER. And not also all the categories with the mentioning of er in the name of the category, like Buffy The Vampire Slayer. Is there anyone who can help me with this? It's been a half year now, and I still haven;t found a solution...........

    My admin center gives me the following form:

    ACS Fanfiction Portal Database: Search the Database

    Search the Database


    ID:


    Title:

    URL:

    Date:

    Category: (Just think a big list with categories)

    Description:

    Contact Name:

    Contact Email:

    Fandom:

    Fanficrating:

    Personalpage:

    Pairing:

    Genre:

    Maincharacter:

    Language:

    Hits:

    isNew:

    isPopular:

    Rating:

    Votes:

    ReceiveMail:


    Search Options:
    Match Any Match Case Whole Words Reg. Expression
    Keyword Search (will match against all fields)
    Max. Returned Hits
    Sort By: ---ID Title URL Date Category Description Contact Name Contact Email Fandom Fanficrating Personalpage Pairing Genre Maincharacter Language Hits isNew isPopular Rating Votes ReceiveMail Sort Order: AscendingDescending




    Link: Add View Delete Modify List All







    The links in the database are displayed in the admincenter as followed:

    ID: 60

    Title: The Lounge

    URL: http://www.neoxer.com/fic.html

    Date: 28-May-2002

    Category: one_series_sites/d_g/er/g-a-s

    Description: An ER fansite with fanfiction of all sorts. Ranges from angst to slash, episodic to epic.

    Fandom: ER

    Fanficrating: all

    Personalpage: No

    Pairing:

    Genre: General-Adult-Slash

    Maincharacter:

    Language:

    Hits: 110

    isNew: No

    isPopular: No

    Rating: 9.61

    Votes: 76

    ReceiveMail: Yes



    Here you can see that Fandom is one the fields, just like URL, etc. I want visitors to be able to search the fields:
    • title
    • URL
    • Description
    • Fandom
    • Fanficrating
    • Pairing
    • Genre
    • Maincharacter
    • Language


    Since I can do this from the admincenter, I'd like visitors to have the option to do the same from the Advanced Search Form.



    I hope one of you can help me now.



    Regards,

    Ilse

    Last edited by:

    angelscharmedsla: May 12, 2003, 6:53 AM
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    here is the "public" version of the admin search: http://www.gossamer-threads.com/...tring=search;#232859

    I use templates but the searchew.cgi could be modified. Look at the "require" lines. Maybe replace site_html_templates.pl with site_html.pl.

    Seems like a little tinkering would make it work.


    Gene
    "The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
    Quote Reply
    Re: [esm] Searching on a specific definitions? In reply to
    In Reply To:
    here is the "public" version of the admin search: http://www.gossamer-threads.com/...tring=search;#232859

    I use templates but the searchew.cgi could be modified. Look at the "require" lines. Maybe replace site_html_templates.pl with site_html.pl.

    Seems like a little tinkering would make it work.


    I have been trying to get it to work, but certain things I can't see how to edit it so that it fits the site_html.pl

    I'll give it a try tonight again, but since my perl knowledge is not that great.......

    Thanks anyway.



    Regards,

    Ilse
    Quote Reply
    Re: [angelscharmedsla] Searching on a specific definitions? In reply to
    In Reply To:
    In Reply To:
    here is the "public" version of the admin search: http://www.gossamer-threads.com/...tring=search;#232859

    I use templates but the searchew.cgi could be modified. Look at the "require" lines. Maybe replace site_html_templates.pl with site_html.pl.

    Seems like a little tinkering would make it work.


    I have been trying to get it to work, but certain things I can't see how to edit it so that it fits the site_html.pl

    I'll give it a try tonight again, but since my perl knowledge is not that great.......

    Thanks anyway.



    Regards,

    Ilse


    Well, I have been trying to adjust everything, but I keep getting the messages:

    "Search term is too common" or "no matching records" when I use the advanced search form. I have changed it now. For all the definitions I want visitors to be able to search in I have included a textfield. I have deleted the text field with search, 'cause that wasn't helping one bit. Now I keep getting the message: "Searchterm is too common. Here's what I have for the Advanced Search form in site_html.pl:

    Code:
    sub site_html_search_form {
    # --------------------------------------------------------
    # This routine displays the search form.
    #
    # $time : The current time.
    # $date : The current date.
    # $grand_total : The total number of links.
    # my $action = shift;

    &html_print_headers;
    print qq~
    <$dtd>
    <html>



    <head>
    <title>Advanced Search at $site_title</title>
    <meta name="description" content="ACS Fanfiction Portal, THE Television series Link database on the internet!">
    <meta name="keywords" content="fanfictions,television series,charmed,buffy,angel,roswell,quantum leap, airwolfe, the nanny">
    <$css>
    </head>



    <$site_body>
    <table width="600" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#000080" height="800">
    <tr>
    <td>
    <table width="600" border="0" cellspacing="0" cellpadding="0" height="800" align="center">
    <tr>
    <td background="http://acsfanfictionportal.com/title.jpg" height="225"><P></P>
    <P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> <P>&nbsp;</P> <P><div align="right"><small class="update">Pages Updated On: $date -
    $time</small> <BR>
    <small class="grandtotal" align="right">Total of <strong>$grand_total</strong>
    links</small></div></td>
    </tr>
    <tr>
    <td background="http://acsfanfictionportal.com/background.gif">
    $site_menu
    </td>
    </tr>
    <tr>
    <td background="http://acsfanfictionportal.com/background.gif">
    <table width="600" border="0" cellspacing="0" cellpadding="0" background="http://acsfanfictionportal.com/background.gif">
    <tr>
    <td width="150" valign="top">
    <small class="menu">
    <DIV Align="left">
    Categories:<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/helpdesk/">Helpdesk</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/messageboards/">Messageboards</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/mailinglists/">Mailinglists</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/fanzines/">Fanzines</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/multiple_fandoms/">Multiple Fandoms</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/one_series_sites/">One Serie Sites</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/awards/">Award Sites</a>|<BR></div></small>
    $site_search
    <small class="menu">
    <DIV Align="left">
    ACS Network:<BR>
    |<a class="menulink" href="http://www.acsfanfictionrealm.com" target="_blank">ACS Fanfiction Realm</a>|<BR>
    |<a class="menulink" href="http://aspirationawards.acsfanfictionrealm.com" target="_blank">Aspiration Awards</a>|<BR>
    |<a class="menulink" href="http://journal.acsfanfictionrealm.com" target="_blank">ACS Garden</a>|<BR>
    |<a class="menulink" href="http://www.acsfanfictionportal.com/...rforum/ikonboard.cgi" target="_blank">ACS Fanfiction Forum</a>|
    <HR width="40%" Align="left" size="1" Noshade>
    A Friend's Site:<BR>
    |<a class="menulink" href="http://www.netgirlrealm.com" target="_blank">NetGirlRealm.com</a>|
    <HR width="40%" Align="left" size="1" Noshade>
    Other sites:<BR>
    <a href="http://panthermoon.com/archivist/" target="new"><img src="http://www.acsfanfictionportal.com/archivistlove.bmp" border=0 ALT="archivist love"></a><BR>
    |<A class="menulink" Href="http://www.sideshowtoy.com" target="_blank">Sideshowtoy</A>|<BR>
    |<A class="menulink" Href="http://www.tvmerch.com" target="_blank">Powerstar Collectibles</A>|<BR>
    |<A class="menulink" Href="http://www.moletown.com" target="_blank">Moletown</A>|<BR>
    |<A class="menulink" href="http://www.blackstar.co.uk/scp/id/acsfan" target="_blank">Blackstar</a>|<BR>
    |<A class="menulink" HREF="http://www.amazon.com/...ome/angelscharmedsla" target="_blank">Amazon</A>|<BR>
    |<A class="menulink" HREF="http://www.allwall.com/...RFID=587636&FT=Y" target="_blank">AllWall</A>|<BR>



    Featured Merchandise week 49, 2002:<BR>
    Prey: A novel<BR>
    By Michael Crichton<BR>
    <A HREF="http://www.amazon.com/...122/angelscharmedsla" Target="_ blank"><IMG SRC="http://www.acsfanfictionportal.com/featuredmerchandise.jpg" width="150" border="0"></A><BR>
    Now on sale!
    </DIV></small>
    </td>
    <td width="450" valign="top">
    <h1>Advanced Search at $site_title</h1>
    <P>Here you can search on specific things. Just fill in all you want.</P>

    <form action="$build_search_url" method="GET">
    <input type=hidden name="db" value="links">
    <INPUT TYPE="hidden" NAME="ww" value="on">
    <input type="hidden" name="bool" value="or">
    <input type="hidden" name="type" value="keyword">
    <div class="margin">
    <table border="0" cellpadding="0" cellspacing="0">
    <tr><td><P>Title: <input type="TEXT" name="Title" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    URL: <input type="TEXT" name="URL" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Description: <input type="TEXT" name="Description" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Fandom: <input type="TEXT" name="Fandom" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Parental Rating: <input type="TEXT" name="Fanficrating" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Genre: <input type="TEXT" name="Genre" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Pairing: <input type="TEXT" name="Pairing" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Maincharacter(s): <input type="TEXT" name="Maincharacter" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"><BR>
    Language: <input type="TEXT" name="Language" value="" size="30" style="background:white;border-width:1;border-color:#191970;border-style:line;color:#191970;font-size:11px;"></P>
    </td></tr>
    <tr><td><P>Number of Results: <SELECT name="mh"><OPTION>10<OPTION SELECTED>25<OPTION>50<OPTION>100</SELECT></P></td></tr>
    <tr><td><input type="Submit" value="Search" style="background:white;border-width:0;color:#191970;font-size:11px;"></P></td></tr>




    </table>
    </div>
    </form>
    </td>
    </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td background="http://acsfanfictionportal.com/background.gif">
    <table width="600" border="0" cellspacing="0" cellpadding="0" background="http://acsfanfictionportal.com/background.gif">
    <tr>
    <td><p><small class="update"><DIV Align="left" valign="bottom">
    ACS Connection is a part of ACS Network</DIV>
    </small></td>
    <td><p><small class="update"><DIV Align="center" valign="bottom">The
    Layout and Design by <A href="mailto:webmaster\@acsfanfictionportal.com">Ilse</A>. Divisions from the idea of <A Href="http://www.fanficweb.net/directory/" Target="_blank">The Fanfiction Directory</A><BR> Angel's Charmed Slayer © 2001.<BR>
    [Verdana] [800 * 600 resolution] [<strike>Netscape</strike>]</DIV>
    </small></td>
    <td>$site_footer</td>
    </tr>
    </table>
    </td>
    </tr>
    </table>
    </td>
    </tr>
    </table>
    </body>
    </html>
    ~;
    }


    Does anyone has any idea?