Guest serdelus Posted May 17, 2008 Report Posted May 17, 2008 I have couple suggestions for a database serach: Make limit from 4 characters to 3 please There are often words that one want search that are 3 letters: M/M , F/M, Voy ... At this moment one cannot find them While searching for story summary, also add searching in Category: ie: I type Harry/Draco and then something - it searches all stories with Harry/Draco in summary and Categories - easy way to serach ofr new Harry/Draco Stories. Quote
DemonGoddess Posted May 19, 2008 Report Posted May 19, 2008 first of all, in order to not overload any database, search functions simply cannot be less than 4 characters. That goes for any kind of software which uses a database to run. You can SEPARATE your search terms by comma, which will allow you to use 3 or less characters for different parts, as long as the entire search term is more than 4 characters. The portal as it is, and the way it's going to remain for several months, does not support a more in depth search than what is there currently. Quote
Guest serdelus Posted May 19, 2008 Report Posted May 19, 2008 first of all, in order to not overload any database, search functions simply cannot be less than 4 characters. That goes for any kind of software which uses a database to run. You can SEPARATE your search terms by comma, which will allow you to use 3 or less characters for different parts, as long as the entire search term is more than 4 characters. The portal as it is, and the way it's going to remain for several months, does not support a more in depth search than what is there currently. It's a loss that search will not be improved in near time. IMO It will be easy to do it, having to write only couuple of lines of source code working with SQL Database (I'm programmer and it appears to be an easy task). Quote
Guest serdelus Posted May 19, 2008 Report Posted May 19, 2008 first of all, in order to not overload any database, search functions simply cannot be less than 4 characters. That goes for any kind of software which uses a database to run. You can SEPARATE your search terms by comma, which will allow you to use 3 or less characters for different parts, as long as the entire search term is more than 4 characters. The portal as it is, and the way it's going to remain for several months, does not support a more in depth search than what is there currently. Sorry to double post (must register lol), but your method for searching 3 characters words is not working: i typed "male, voy" and on the whole results page there was not one story with voy word, all of them were with male. Quote
DemonGoddess Posted May 19, 2008 Report Posted May 19, 2008 Instructions for the boolean search engine: The boolean full-text search capability supports the following operators: + A leading plus sign indicates that this word must be present in every row returned. - A leading minus sign indicates that this word must not be present in any row returned. By default (when neither plus nor minus is specified) the word is optional, but the rows that contain it will be rated higher. This mimicks the normal behaviour. ( ) Parentheses are used to group words into subexpressions. * An asterisk is the truncation operator. Unlike the other operators, it should be appended to the word, not prepended. " The phrase, that is enclosed in double quotes ", matches only rows that contain this phrase literally, as it was typed. Quote
manta2g Posted May 19, 2008 Report Posted May 19, 2008 Curently all the queries for the curent archive script are in php2 and 3 not to mention most of the source code, we are in progress of rewriting it, Though because of the size of the archives reducing the character limit even with the new code would truly overload the database. You may be a programmer but aparetly you need tp re-read the instructions and get some database expirience. Quote
Recommended Posts