<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >UserScore</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="mnoGoSearch 3.3.9 reference manual" HREF="index.html"><LINK REL="UP" TITLE="mnoGoSearch command reference" HREF="msearch-cmdref.html"><LINK REL="PREVIOUS" TITLE="UserOrder" HREF="msearch-cmdref-userorder.html"><LINK REL="NEXT" TITLE="UserSiteScore" HREF="msearch-cmdref-usersitescore.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="mnogo.css"><META NAME="Description" CONTENT="mnoGoSearch - Full Featured Web site Open Source Search Engine Software over the Internet and Intranet Web Sites Based on SQL Database. It is a Free search software covered by GNU license."><META NAME="Keywords" CONTENT="shareware, freeware, download, internet, unix, utilities, search engine, text retrieval, knowledge retrieval, text search, information retrieval, database search, mining, intranet, webserver, index, spider, filesearch, meta, free, open source, full-text, udmsearch, website, find, opensource, search, searching, software, udmsearch, engine, indexing, system, web, ftp, http, cgi, php, SQL, MySQL, database, php3, FreeBSD, Linux, Unix, mnoGoSearch, MacOS X, Mac OS X, Windows, 2000, NT, 95, 98, GNU, GPL, url, grabbing"></HEAD ><BODY CLASS="refentry" BGCOLOR="#EEEEEE" TEXT="#000000" LINK="#000080" VLINK="#800080" ALINK="#FF0000" ><!--#include virtual="body-before.html"--><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" ><SPAN CLASS="application" >mnoGoSearch</SPAN > 3.3.9 reference manual: Full-featured search engine software</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="msearch-cmdref-userorder.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="msearch-cmdref-usersitescore.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="cmdref-userscore" ></A >UserScore</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN13610" ></A ><H2 >Name</H2 ><B CLASS="command" >UserScore</B > -- specifies an <ACRONYM CLASS="acronym" >SQL</ACRONYM > query to calculate user defined score for desired documents. <P ><B ></B ><TT CLASS="filename" >search.htm</TT ></P ></DIV ><DIV CLASS="refsynopsisdiv" ><A NAME="AEN13617" ></A ><H2 >Synopsis</H2 ><P ><B CLASS="command" >UserScore</B > {name} {sql-query}</P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN13622" ></A ><H2 >Description</H2 ><P > The <B CLASS="command" >UserScore</B > command allows to configure user defined scores for some or all documents in the database. The score value calculated by <SPAN CLASS="application" >mnoGoSearch</SPAN > is mixed with the user defined value, so you can affect the final rank for desired documents. </P ><P > It is possible to configure multiple <B CLASS="command" >UserScore</B > commands, however only one of them can be used during search time. The <TT CLASS="literal" >name</TT > argument should be unique in every <B CLASS="command" >UserScore</B > command. <SPAN CLASS="application" >search.cgi</SPAN > detects which <B CLASS="command" >UserScore</B > command to use taking its name from the <TT CLASS="literal" >us=name1</TT > <ACRONYM CLASS="acronym" >HTML</ACRONYM > form parameter. If no <TT CLASS="literal" >us</TT > parameter is given, or <TT CLASS="literal" >us</TT > value is empty, non of the <B CLASS="command" >UserScore</B > commands are applied. </P ><P >The second argument must represent an <ACRONYM CLASS="acronym" >SQL</ACRONYM > query returning a result set consisting of two columns. The first column in each record should correspond to <CODE CLASS="varname" >ID</CODE > of a document whose score should be modified. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Note: </B > The document <CODE CLASS="varname" >ID</CODE >s are stored in the <TT CLASS="literal" >rec_id</TT > column of the <TT CLASS="literal" >url</TT > table of the <SPAN CLASS="application" >mnoGoSearch</SPAN > database. To know the <CODE CLASS="varname" >ID</CODE > of a certain document you can run this <ACRONYM CLASS="acronym" >SQL</ACRONYM > query in the <SPAN CLASS="application" >mnoGoSearch</SPAN > database: <PRE CLASS="programlisting" > SELECT rec_id FROM url WHERE url='http://hostname/page1.html'; </PRE > </P ></BLOCKQUOTE ></DIV ><P > The second column stands for a user defined score value for this document, returned as signed integer in the range <TT CLASS="literal" >-255..+255</TT >. The original score value calculated by <SPAN CLASS="application" >mnoGoSearch</SPAN > is mixed with the user defined value as follows: <P ></P ><UL ><LI ><P >A positive user defined value makes the final rank for this document higher.</P ></LI ><LI ><P >A negative user defined value makes the final rank lower.</P ></LI ><LI ><P >A zero user defined value does not change score.</P ></LI ><LI ><P >If a document is not represented in a <B CLASS="command" >UserScore</B > <ACRONYM CLASS="acronym" >SQL</ACRONYM > query result, its score is not changed.</P ></LI ></UL > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN13665" ></A ><H2 >Examples</H2 ><DIV CLASS="informalexample" ><P ></P ><A NAME="AEN13667" ></A ><PRE CLASS="programlisting" > # Give more score to documents with longer URL UserScore long "SELECT rec_id, length(url) FROM url" # Give more score to documents with shorter URL UserScore short "SELECT rec_id, -length(url) FROM url" # Give higher scores to some certain documents: UserScore list1 "SELECT rec_id, 255 FROM url WHERE rec_id IN (1,100,300)" </PRE ><P ></P ></DIV ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN13669" ></A ><H2 >See also</H2 ><P > <A HREF="msearch-cmdref-userscorefactor.html" >UserScoreFactor</A >, <A HREF="msearch-cmdref-usersitescore.html" >UserSiteScore</A >, <A HREF="msearch-doingsearch.html#search-params" >the Section called <I >Search parameters <A NAME="AEN4440" ></A ></I > in Chapter 10</A >. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="msearch-cmdref-userorder.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="msearch-cmdref-usersitescore.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >UserOrder</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="msearch-cmdref.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >UserSiteScore</TD ></TR ></TABLE ></DIV ><!--#include virtual="body-after.html"--></BODY ></HTML >