websearchadminlib.py.wml
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Tue, Jun 11, 02:42

websearchadminlib.py.wml
View Options

	## Administrator interface for WebSearch

	## This file is part of the CERN Document Server Software (CDSware).
	## Copyright (C) 2002 CERN.
	##
	## The CDSware is free software; you can redistribute it and/or
	## modify it under the terms of the GNU General Public License as
	## published by the Free Software Foundation; either version 2 of the
	## License, or (at your option) any later version.
	##
	## The CDSware is distributed in the hope that it will be useful, but
	## WITHOUT ANY WARRANTY; without even the implied warranty of
	## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
	## General Public License for more details.
	##
	## You should have received a copy of the GNU General Public License
	## along with CDSware; if not, write to the Free Software Foundation, Inc.,
	## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.

	## read config variables:
	#include "config.wml"
	#include "configbis.wml"
	#include "cdswmllib.wml"

	<protect>## $Id$</protect>
	<protect>## DO NOT EDIT THIS FILE! IT WAS AUTOMATICALLY GENERATED FROM CDSware WML SOURCES.</protect>
	"""CDSware WebSearch Administrator Interface."""

	__lastupdated__ = """<: print `date +"%d %b %Y %H:%M:%S %Z"`; :>"""

	## fill config variables:

	import access_control_engine as acce
	import cgi
	import re
	import MySQLdb
	import Numeric
	import os
	import urllib
	import random
	import marshal

	from zlib import compress,decompress
	from bibrankadminlib import modify_translations, get_def_name,get_i8n_name,get_name,get_rnk_nametypes,get_languages,check_user,is_adminuser,adderrorbox,addadminbox,tupletotable,tupletotable_onlyselected,addcheckboxes,createhiddenform,serialize_via_numeric_array_dumps,serialize_via_numeric_array_compr,serialize_via_numeric_array_escape,serialize_via_numeric_array,deserialize_via_numeric_array,serialize_via_marshal,deserialize_via_marshal
	from messages import *
	from dbquery import run_sql
	from config import *
	from webpage import page, pageheaderonly, pagefooteronly
	from webuser import getUid, get_email
	from mod_python import apache

	__version__ = "$Id$"

	def getnavtrail(previous = ''):
	"""Get the navtrail"""

	navtrail = """<a class=navtrail href="%s/admin/">Admin Area</a> > <a class=navtrail href="%s/admin/websearch/">WebSearch Admin</a> """ % (weburl, weburl)
	navtrail = navtrail + previous
	return navtrail

	def perform_modifytranslations(colID, ln=cdslang, sel_type='', trans=[], confirm=-1, callback='yes'):
	"""Modify the translations of a collection
	sel_type - the nametype to modify
	trans - the translations in the same order as the languages from get_languages()"""

	output = ''
	subtitle = ''
	cdslangs = get_languages()
	if confirm in ["2", 2] and colID:
	finresult = modify_translations(colID, cdslangs, sel_type, trans, "collection")
	col_dict = dict(get_def_name('', "collection"))

	if colID and col_dict.has_key(int(colID)):
	colID = int(colID)
	subtitle = """<a name="3">3. Modify translations for collection '%s'</a> &nbsp <small>[<a href="%s/admin/websearch/guide.html#3.3">?</a>]</small>""" % (col_dict[colID], weburl)

	if type(trans) is str:
	trans = [trans]
	if sel_type == '':
	sel_type = get_col_nametypes()[0][0]

	header = ['Language', 'Translation']
	actions = []

	types = get_col_nametypes()
	if len(types) > 1:
	text = """
	<span class="adminlabel">Name type</span>
	<select name="sel_type" class="admin_w200">
	"""
	for (key, value) in types:
	text += """<option value="%s" %s>%s""" % (key, key == sel_type and 'selected="selected"' or '', value)
	trans_names = get_name(colID, ln, key, "collection")
	if trans_names and trans_names[0][0]:
	text += ": %s" % trans_names[0][0]
	text += "</option>"
	text += """</select>"""

	output += createhiddenform(action="modifytranslations#3",
	text=text,
	button="Select",
	colID=colID,
	ln=ln,
	confirm=0)


	if confirm in [-1, "-1", 0, "0"]:
	trans = []
	for (key, value) in cdslangs:
	try:
	trans_names = get_name(colID, key, sel_type, "collection")
	trans.append(trans_names[0][0])
	except StandardError, e:
	trans.append('')

	for nr in range(0,len(cdslangs)):
	actions.append(["%s %s" % (cdslangs[nr][1], (cdslangs[nr][0]==cdslang and '<small>(def)</small>' or ''))])
	actions[-1].append('<input type="text" name="trans" size="30" value="%s"/>' % trans[nr])

	text = tupletotable(header=header, tuple=actions)
	output += createhiddenform(action="modifytranslations#3",
	text=text,
	button="Modify",
	colID=colID,
	sel_type=sel_type,
	ln=ln,
	confirm=2)

	if sel_type and len(trans) and confirm in ["2", 2]:
	if finresult:
	output += """<b><span class="info">Translations modified for collection '%s'.</span></b>""" % (col_dict[colID])
	else:
	output += """<b><span class="info">Sorry, could not modify translations for collection '%s'.</span></b>""" % (col_dict[colID])

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_modifytranslations", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifyrankmethods(colID, ln=cdslang, func='', rnkID='', confirm=0, callback='yes'):
	"""Modify which rank methods is visible to the collection
	func - remove or add rank method
	rnkID - the id of the rank method."""

	output = ""
	subtitle = ""

	col_dict = dict(get_def_name('', "collection"))
	rnk_dict = dict(get_def_name('', "rnkMETHOD"))
	if colID and col_dict.has_key(int(colID)):
	colID = int(colID)
	if func in ["0", 0] and confirm in ["1", 1]:
	finresult = attach_rnk_col(colID, rnkID)
	elif func in ["1", 1] and confirm in ["1", 1]:
	finresult = detach_rnk_col(colID, rnkID)

	subtitle = """<a name="9">9. Modify rank options for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.9">?</a>]</small>""" % (col_dict[colID], weburl)
	output = """
	<dl>
	<dt>The rank methods enabled for the collection '%s' is:</dt>
	""" % col_dict[colID]

	rnkmethods = get_col_rnk(colID, ln)
	output += """<dd>"""
	if not rnkmethods:
	output += """No rank methods"""
	else:
	for id, name in rnkmethods:
	output += """%s, """ % name
	output += """</dd>
	</dl>
	"""

	rnk_list = get_def_name('', "rnkMETHOD")
	rnk_dict_in_col = dict(get_col_rnk(colID, ln))
	rnk_list = filter(lambda x: not rnk_dict_in_col.has_key(x[0]), rnk_list)
	if rnk_list:
	text = """
	<span class="adminlabel">Enable:</span>
	<select name="rnkID" class="admin_w200">
	<option value="-1">- select rank method -</option>
	"""
	for (id, name) in rnk_list:
	text += """<option value="%s" %s>%s</option>""" % (id, (func in ["0", 0] and confirm in ["0", 0] and int(rnkID) == int(id)) and 'selected="selected"' or '' , name)
	text += """</select>"""
	output += createhiddenform(action="modifyrankmethods#9",
	text=text,
	button="Enable",
	colID=colID,
	ln=ln,
	func=0,
	confirm=1)

	if confirm in ["1", 1] and func in ["0", 0] and int(rnkID) != -1:
	if finresult:
	output += """<b><span class="info">Rank method '%s' enabled for collection '%s'</span></b>""" % (rnk_dict[int(rnkID)], col_dict[colID])
	else:
	output += """<b><span class="info">Rank method '%s' could not be enabled for collection '%s'</span></b>""" % (rnk_dict[int(rnkID)], col_dict[colID])
	elif confirm not in ["0", 0] and func in ["0", 0]:
	output += """<b><span class="info">Please select a rank method.</span></b>"""

	coll_list = get_col_rnk(colID, ln)
	if coll_list:
	text = """
	<span class="adminlabel">Disable:</span>
	<select name="rnkID" class="admin_w200">
	<option value="-1">- select rank method-</option>
	"""

	for (id, name) in coll_list:
	text += """<option value="%s" %s>%s</option>""" % (id, (func in ["1", 1] and confirm in ["0", 0] and int(rnkID) == int(id)) and 'selected="selected"' or '' , name)
	text += """</select>"""
	output += createhiddenform(action="modifyrankmethods#9",
	text=text,
	button="Disable",
	colID=colID,
	ln=ln,
	func=1,
	confirm=1)

	if confirm in ["1", 1] and func in ["1", 1] and int(rnkID) != -1:
	if finresult:
	output += """<b><span class="info">Rank method '%s' disabled for collection '%s'</span></b>""" % (rnk_dict[int(rnkID)], col_dict[colID])
	else:
	output += """<b><span class="info">Rank method '%s' could not be disabled for collection '%s'</span></b>""" % (rnk_dict[int(rnkID)], col_dict[colID])
	elif confirm not in ["0", 0] and func in ["1", 1]:
	output += """<b><span class="info">Please select a rank method.</span></b>"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_modifyrankmethods", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_addcollectiontotree(colID, ln=cdslang, add_dad='', add_son='', rtype='', mtype='', callback='yes', confirm=-1):
	"""Form to add a collection to the tree.
	add_dad - the dad to add the collection to
	add_son - the collection to add
	rtype - add it as a regular or virtual
	mtype - add it to the regular or virtual tree."""

	output = ""
	output2 = ""
	subtitle = """Attach collection to tree &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#2.2">?</a>]</small>""" % (weburl)

	col_dict = dict(get_def_name('', "collection"))
	if confirm not in [-1, "-1"] and not (add_son and add_dad and rtype):
	output2 += """<b><span class="info">All fields must be filled.</span></b><br><br>
	"""
	elif add_son and add_dad and rtype:
	add_son = int(add_son)
	add_dad = int(add_dad)
	if confirm not in [-1, "-1"]:
	if add_son == add_dad:
	output2 += """<b><span class="info">Cannot add a collection as a pointer to itself.</span></b><br><br>
	"""
	elif check_col(add_dad, add_son):
	if add_col_dad_son(add_dad, add_son, rtype):
	output2 += """<b><span class="info">Added the collection '%s' as a %s subcollection of '%s'.<br> It will appear on your website after the next webcoll run. You can either run it manually or wait until bibsched does it for you.</span></b><br><br>
	""" % (col_dict[add_son], (rtype=="r" and 'regular' or 'virtual'), col_dict[add_dad])
	else:
	output2 += """<b><span class="info">Could not add the collection '%s' as a %s subcollection of '%s'.</span></b><br><br>
	""" % (col_dict[add_son], (rtype=="r" and 'regular' or 'virtual'), col_dict[add_dad])
	else:
	output2 += """<b><span class="info">Cannot add the collection '%s' as a %s subcollection of '%s' since it will either create a loop, or the association already exists.</span></b><br><br>
	""" % (col_dict[add_son], (rtype=="r" and 'regular' or 'virtual'), col_dict[add_dad])
	add_son = ''
	add_dad = ''
	rtype = ''

	tree = get_col_tree(colID)
	col_list = col_dict.items()
	col_list.sort(compare_on_val)


	output = show_coll_not_in_tree(colID, ln, col_dict)
	text = """
	<span class="adminlabel">Attach which</span>
	<select name="add_son" class="admin_w200">
	<option value="">- select collection -</option>
	"""
	for (id, name) in col_list:
	if id != colID:
	text += """<option value="%s" %s>%s</option>""" % (id, str(id)==str(add_son) and 'selected="selected"' or '', name)
	text += """
	</select><br>
	<span class="adminlabel">Attach to</span>
	<select name="add_dad" class="admin_w200">
	<option value="">- select parent collection -</option>
	"""

	for (id, name) in col_list:
	text += """<option value="%s" %s>%s</option>
	""" % (id, str(id)==add_dad and 'selected="selected"' or '', name)
	text += """</select><br>
	"""

	text += """
	<span class="adminlabel">Relationship</span>
	<select name="rtype" class="admin_w200">
	<option value="">- select relationship -</option>
	<option value="r" %s>Regular (Narrow by...)</option>
	<option value="v" %s>Virtual (Focus on...)</option>
	</select>
	""" % ((rtype=="r" and 'selected="selected"' or ''), (rtype=="v" and 'selected="selected"' or ''))
	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/addcollectiontotree" % weburl,
	text=text,
	button="Add",
	colID=colID,
	ln=ln,
	confirm=1)
	output += output2

	#output += perform_showtree(colID, ln)
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(colID, ln, mtype="perform_addcollectiontotree", content=addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)


	def perform_addcollection(colID, ln=cdslang, colNAME='', dbquery='', rest='', callback="yes", confirm=-1):
	"""form to add a new collection.
	colNAME - the name of the new collection
	dbquery - the dbquery of the new collection
	rest - the group allowed to access the new collection"""

	output = ""
	subtitle = """Create new collection   <small>[<a title="See guide" href="%s/admin/websearch/guide.html#2.1">?</a>]</small>""" % (weburl)
	text = """
	<span class="adminlabel">Default name</span>
	<input class="admin_w200" type="text" name="colNAME" value="%s" /><br>
	""" % colNAME
	output = createhiddenform(action="%s/admin/websearch/websearchadmin.py/addcollection" % weburl,
	text=text,
	colID=colID,
	ln=ln,
	button="Add collection",
	confirm=1)
	if colNAME and confirm in ["1", 1]:
	res = add_col(colNAME, '', '')
	if res:
	output += """<b><span class="info">Added new collection with default name '%s'</span></b>
	""" % colNAME
	output += perform_addcollectiontotree(colID=colID, ln=ln, add_son=res[0][0], callback='')
	else:
	output += """<b><span class="info">Sorry, could not add collection, most likely the collection already exists.</span></b>
	"""
	elif confirm not in ["-1", -1]:
	output += """<b><span class="info">Please give the collection a name.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(colID, ln=ln, mtype="perform_addcollection", content=addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifydbquery(colID, ln=cdslang, dbquery='', callback='yes', confirm=-1):
	"""form to modify the dbquery of the collection.
	dbquery - the dbquery of the collection."""

	subtitle = ''
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	if colID and col_dict.has_key(int(colID)):
	colID = int(colID)
	subtitle = """<a name="1">1. Modify collection query for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.1">?</a>]</small>""" % (col_dict[colID], weburl)

	if confirm == -1:
	res = run_sql("SELECT dbquery FROM collection WHERE id=%s" % colID)
	dbquery = res[0][0]
	if not dbquery:
	dbquery = ''

	reg_sons = len(get_col_tree(colID, 'r'))
	vir_sons = len(get_col_tree(colID, 'v'))
	if reg_sons > 1:
	if dbquery:
	output += "Warning: This collection got subcollections, and should because of this not have a collection query, for further explanation, check the WebSearch Guide<br>"
	elif reg_sons <= 1:
	if not dbquery:
	output += "Warning: This collection does not have any subcollections, and should because of this have a collection query, for further explanation, check the WebSearch Guide<br>"

	text = """
	<span class="adminlabel">Query</span>
	<input class="admin_w200" type="text" name="dbquery" value="%s" /><br>
	""" % dbquery
	output += createhiddenform(action="modifydbquery",
	text=text,
	button="Modify",
	colID=colID,
	ln=ln,
	confirm=1)

	if confirm in ["1", 1]:
	res = modify_dbquery(colID, dbquery)
	if res:
	if dbquery == "":
	text = """<b><span class="info">Query removed for this collection.</span></b>"""
	else:
	text = """<b><span class="info">Query set for this collection.</span></b>"""
	else:
	text = """<b><span class="info">Sorry, could not change query.</span></b>"""
	output += text

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_modifydbquery", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifyrestricted(colID, ln=cdslang, rest='', callback='yes', confirm=-1):
	"""modify which apache group is allowed to access the collection.
	rest - the groupname"""

	subtitle = ''
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	if colID and col_dict.has_key(int(colID)):
	colID = int(colID)
	subtitle = """<a name="2">2. Modify access restrictions for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.2">?</a>]</small>""" % (col_dict[colID], weburl)
	if confirm == -1:
	res = run_sql("SELECT restricted FROM collection WHERE id=%s" % colID)
	rest = res[0][0]
	if not rest:
	rest = ''
	text = """
	<span class="adminlabel">Restricted to:</span>
	<input class="admin_w200" type="text" name="rest" value="%s" /><br>
	""" % rest

	output += createhiddenform(action="modifyrestricted",
	text=text,
	button="Modify",
	colID=colID,
	ln=ln,
	confirm=1)

	if confirm in ["1", 1]:
	res = modify_restricted(colID, rest)
	if res:
	if rest == "":
	text = """<b><span class="info">Removed restriction for this collection.</span></b>"""
	else:
	text = """<b><span class="info">Restriction set for this collection.</span></b>"""
	else:
	text = """<b><span class="info">Sorry, could not change the access restrictions.</span></b>"""
	output += text

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_modifyrestricted", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifycollectiontree(colID, ln=cdslang, move_up='', move_down='', move_from='', move_to='', delete='', rtype='', callback='yes', confirm=0):
	"""to modify the collection tree: move a collection up and down, delete a collection, or change the father of the collection.
	colID - the main collection of the tree, the root
	move_up - move this collection up (is not the collection id, but the place in the tree)
	move_up - move this collection down (is not the collection id, but the place in the tree)
	move_from - move this collection from the current positon (is not the collection id, but the place in the tree)
	move_to - move the move_from collection and set this as it's father. (is not the collection id, but the place in the tree)
	delete - delete this collection from the tree (is not the collection id, but the place in the tree)
	rtype - the type of the collection in the tree, regular or virtual"""

	colID = int(colID)
	tree = get_col_tree(colID, rtype)
	col_dict = dict(get_def_name('', "collection"))

	subtitle = """Modify collection tree: %s   <small>[<a title="See guide" href="%s/admin/websearch/guide.html#2.3">?</a>]   <a href="%s/admin/websearch/websearchadmin.py/showtree?colID=%s&ln=%s">Printer friendly version</a></small>""" % (col_dict[colID], weburl, weburl, colID, ln)
	fin_output = ""
	output = ""

	try:
	if move_up:
	move_up = int(move_up)
	switch = find_last(tree, move_up)
	if switch and switch_col_treescore(tree[move_up], tree[switch]):
	output += """<b><span class="info">Moved the %s collection '%s' up and '%s' down.</span></b><br><br>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[move_up][0]], col_dict[tree[switch][0]])
	else:
	output += """<b><span class="info">Could not move the %s collection '%s' up and '%s' down.</span></b><br><br>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[move_up][0]], col_dict[tree[switch][0]])
	elif move_down:
	move_down = int(move_down)
	switch = find_next(tree, move_down)
	if switch and switch_col_treescore(tree[move_down], tree[switch]):
	output += """<b><span class="info">Moved the %s collection '%s' down and '%s' up.</span></b><br><br>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[move_down][0]], col_dict[tree[switch][0]])
	else:
	output += """<b><span class="info">Could not move the %s collection '%s' up and '%s' down.</span></b><br><br>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[move_up][0]],col_dict[tree[switch][0]])
	elif delete:
	delete = int(delete)
	if confirm in [0, "0"]:
	if col_dict[tree[delete][0]] != col_dict[tree[delete][3]]:
	text = """<b>Do you want to remove the %s collection '%s' and its subcollections in the %s collection '%s'.</b>
	""" % ((tree[delete][4]=="r" and 'regular' or 'virtual'), col_dict[tree[delete][0]], (rtype=="r" and 'regular' or 'virtual'), col_dict[tree[delete][3]])
	else:
	text = """<b>Do you want to remove all subcollections of the %s collection '%s'.</b>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[delete][3]])

	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/modifycollectiontree#tree" % weburl,
	text=text,
	button="Confirm",
	colID=colID,
	delete=delete,
	rtype=rtype,
	ln=ln,
	confirm=1)
	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/index?mtype=perform_modifycollectiontree#tree" % weburl,
	text="<b>To cancel</b>",
	button="Cancel",
	colID=colID,
	ln=ln)
	else:
	if remove_col_subcol(tree[delete][0], tree[delete][3], rtype):
	if col_dict[tree[delete][0]] != col_dict[tree[delete][3]]:
	output += """<b><span class="info">Removed the %s collection '%s' and its subcollections in subdirectory '%s'.</span></b><br><br>
	""" % ((tree[delete][4]=="r" and 'regular' or 'virtual'), col_dict[tree[delete][0]], col_dict[tree[delete][3]])
	else:
	output += """<b><span class="info">Removed the subcollections of the %s collection '%s'.</span></b><br><br>
	""" % ((rtype=="r" and 'regular' or 'virtual'), col_dict[tree[delete][3]])

	else:
	output += """<b><span class="info">Could not remove the collection from the tree.</span></b><br><br>
	"""
	delete = ''
	elif move_from and not move_to:
	move_from_rtype = move_from[0]
	move_from_id = int(move_from[1:len(move_from)])
	text = """<b>Select collection to place the %s collection '%s' under.</b><br><br>
	""" % ((move_from_rtype=="r" and 'regular' or 'virtual'), col_dict[tree[move_from_id][0]])
	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/index?mtype=perform_modifycollectiontree#tree" % weburl,
	text=text,
	button="Cancel",
	colID=colID,
	ln=ln)
	elif move_from and move_to:
	move_from_rtype = move_from[0]
	move_from_id = int(move_from[1:len(move_from)])
	move_to_rtype = move_to[0]
	move_to_id = int(move_to[1:len(move_to)])
	tree_from = get_col_tree(colID, move_from_rtype)
	tree_to = get_col_tree(colID, move_to_rtype)

	if confirm in [0, '0']:
	if move_from_id == move_to_id and move_from_rtype==move_to_rtype:
	output += """<b><span class="info">Cannot move to itself.</span></b><br><br>
	"""
	elif tree_from[move_from_id][3] == tree_to[move_to_id][0] and move_from_rtype==move_to_rtype:
	output += """<b><span class="info">The collection is already there.</span></b><br><br>
	"""
	elif check_col(tree_to[move_to_id][0], tree_from[move_from_id][0]) or (tree_to[move_to_id][0] == 1 and tree_from[move_from_id][3] == tree_to[move_to_id][0] and move_from_rtype != move_to_rtype):
	text = """<b>Move %s collection '%s' to the %s collection '%s'.</b>
	""" % ((tree_from[move_from_id][4]=="r" and 'regular' or 'virtual'), col_dict[tree_from[move_from_id][0]], (tree_to[move_to_id][4]=="r" and 'regular' or 'virtual'), col_dict[tree_to[move_to_id][0]])
	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/modifycollectiontree#tree" % weburl,
	text=text,
	button="Confirm",
	colID=colID,
	move_from=move_from,
	move_to=move_to,
	ln=ln,
	rtype=rtype,
	confirm=1)
	output += createhiddenform(action="%s/admin/websearch/websearchadmin.py/index?mtype=perform_modifycollectiontree#tree" % weburl,
	text="""<b>To cancel</b>""",
	button="Cancel",
	colID=colID,
	ln=ln)
	else:
	output += """<b><span class="info">Cannot move the collection '%s' and set it as a subcollection of '%s' since it will create a loop.</span></b><br><br>
	""" % (col_dict[tree_from[move_from_id][0]], col_dict[tree_to[move_to_id][0]])
	else:
	if (move_to_id != 0 and move_col_tree(tree_from[move_from_id], tree_to[move_to_id])) or (move_to_id == 0 and move_col_tree(tree_from[move_from_id], tree_to[move_to_id], move_to_rtype)):
	output += """<b><span class="info">Moved %s collection '%s' to the %s collection '%s'.</span></b><br><br>
	""" % ((move_from_rtype=="r" and 'regular' or 'virtual'), col_dict[tree_from[move_from_id][0]], (move_to_rtype=="r" and 'regular' or 'virtual'), col_dict[tree_to[move_to_id][0]])
	else:
	output += """<b><span class="info">Could not move %s collection '%s' to the %s collection '%s'.</span></b><br><br>
	""" % ((move_from_rtype=="r" and 'regular' or 'virtual'), col_dict[tree_from[move_from_id][0]], (move_to_rtype=="r" and 'regular' or 'virtual'), col_dict[tree_to[move_to_id][0]])
	move_from = ''
	move_to = ''
	else:
	output += """
	"""
	except StandardError, e:
	return """<b><span class="info">An error occured.</span></b>
	"""

	output += """<table border ="0" width="100%">
	<tr><td width="50%">
	<b>Narrow by collection:</b>
	</td><td width="50%">
	<b>Focus on...:</b>
	</td></tr><tr><td valign="top">
	"""

	tree = get_col_tree(colID, 'r')
	output += create_colltree(tree, col_dict, colID, ln, move_from, move_to, 'r', "yes")
	output += """</td><td valign="top">
	"""
	tree = get_col_tree(colID, 'v')
	output += create_colltree(tree, col_dict, colID, ln, move_from, move_to, 'v', "yes")
	output += """</td>
	</tr>
	</table>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(colID, ln, mtype="perform_modifycollectiontree", content=addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showtree(colID, ln=cdslang):
	col_dict = dict(get_def_name('', "collection"))
	subtitle = "Collection tree: %s" % col_dict[int(colID)]
	output = """<table border ="0" width="100%">
	<tr><td width="50%">
	<b>Narrow by collection:</b>
	</td><td width="50%">
	<b>Focus on...:</b>
	</td></tr><tr><td valign="top">
	"""
	tree = get_col_tree(colID, 'r')
	output += create_colltree(tree, col_dict, colID, ln, '', '', 'r', '')
	output += """</td><td valign="top">
	"""
	tree = get_col_tree(colID, 'v')
	output += create_colltree(tree, col_dict, colID, ln, '', '', 'v', '')
	output += """</td>
	</tr>
	</table>
	"""
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	return addadminbox(subtitle, body)

	def perform_addportalbox(colID, ln=cdslang, title='', body='', callback='yes', confirm=-1):
	"""form to add a new portalbox
	title - the title of the portalbox
	body - the body of the portalbox"""

	col_dict = dict(get_def_name('', "collection"))
	colID = int(colID)
	subtitle = """<a name="5.1"></a>Create new portalbox"""
	text = """
	<span class="adminlabel">Title</span>
	<input class="admin_w200" type="text" name="title" value="%s" /><br>
	<span class="adminlabel">Body</span>
	<textarea cols="50" rows="10" class="admin_wvar" type="text" name="body">%s</textarea><br>
	""" % (title, body)
	output = createhiddenform(action="addportalbox#5.1",
	text=text,
	button="Add",
	colID=colID,
	ln=ln,
	confirm=1)

	if body and confirm in [1, "1"]:
	res = add_pbx(title, body)
	if res:
	output += """<b><span class="info">Added the portalbox '%s'. To add the portalbox to the collection, go <a href="addexistingportalbox?colID=%s&ln=%s&pbxID=%s#5">here</a>.</span></b>""" % (title, colID, ln, res[0][0])
	else:
	output += """<b><span class="info">Cannot add the portalbox '%s'.</span></b>
	""" % title
	elif confirm not in [-1, "-1"]:
	output += """<b><span class="info">Body field must be filled.</span></b>
	"""


	try:
	body = [output, extra]
	except NameError:
	body = [output]

	return perform_showportalboxes(colID, ln, content=addadminbox(subtitle, body))

	def perform_addexistingportalbox(colID, ln=cdslang, pbxID=-1, score=0, position='', sel_ln='', callback='yes', confirm=-1):
	"""form to add an existing portalbox to a collection.
	colID - the collection to add the portalbox to
	pbxID - the portalbox to add
	score - the importance of the portalbox.
	position - the position of the portalbox on the page
	sel_ln - the language of the portalbox"""

	subtitle = """<a name="5.2"></a>Add existing portalbox to collection"""
	output = ""

	colID = int(colID)
	res = get_pbx()
	pos = get_pbx_pos()
	lang = dict(get_languages())
	col_dict = dict(get_def_name('', "collection"))
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res))

	col_pbx = get_col_pbx(colID)
	col_pbx = dict(map(lambda x: (x[0], x[5]), col_pbx))
	if len(res) > 0:
	text = """
	<span class="adminlabel">Portalbox</span>
	<select name="pbxID" class="admin_w200">
	<option value="-1">- Select portalbox -</option>
	"""
	for (id, t_title, t_body) in res:
	if not col_pbx.has_key(id):
	text += """<option value="%s" %s>%s - %s...</option>
	""" % (id, id == int(pbxID) and 'selected="selected"' or '', t_title, cgi.escape(t_body[0:25 - len(t_title)]))
	text += """</select><br>
	<span class="adminlabel">Language</span>
	<select name="sel_ln" class="admin_w200">
	<option value="">- Select language -</option>
	"""
	listlang = lang.items()
	listlang.sort()
	for (key, name) in listlang:
	text += """<option value="%s" %s>%s</option>
	""" % (key, key == sel_ln and 'selected="selected"' or '', name)
	text += """</select><br>
	<span class="adminlabel">Position</span>
	<select name="position" class="admin_w200">
	<option value="">- Select position -</option>
	"""
	listpos = pos.items()
	listpos.sort()
	for (key, name) in listpos:
	text += """<option value="%s" %s>%s</option>""" % (key, key==position and 'selected="selected"' or '', name)
	text += "</select>"
	output += createhiddenform(action="addexistingportalbox#5.2",
	text=text,
	button="Add",
	colID=colID,
	ln=ln,
	confirm=1)
	else:
	output = """No existing portalboxes to add, please create a new one.
	"""

	if pbxID > -1 and position and sel_ln and confirm in [1, "1"]:
	pbxID = int(pbxID)
	res = add_col_pbx(colID, pbxID, sel_ln, position, '')
	if res:
	output += """<b><span class="info">Added the portalbox '%s' to the collection '%s'.</span></b>
	""" % (pbx_dict[pbxID], col_dict[colID])
	else:
	output += """<b><span class="info">Cannot add the portalbox '%s' to the collection '%s'.</span></b>
	""" % (pbx_dict[pbxID], col_dict[colID])
	elif pbxID > -1 and confirm not in [-1, "-1"]:
	output += """<b><span class="info">All fields must be filled.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showportalboxes(colID, ln, content=output)

	def perform_deleteportalbox(colID, ln=cdslang, pbxID=-1, callback='yes', confirm=-1):
	"""form to delete a portalbox which is not in use.
	colID - the current collection.
	pbxID - the id of the portalbox"""

	subtitle = """<a name="5.3"></a>Delete an unused portalbox"""
	output = ""

	colID = int(colID)
	if pbxID not in [-1," -1"] and confirm in [1, "1"]:
	ares = get_pbx()
	pbx_dict = dict(map(lambda x: (x[0], x[1]), ares))
	pname = pbx_dict[int(pbxID)]
	ares = delete_pbx(int(pbxID))

	res = get_pbx()
	col_dict = dict(get_def_name('', "collection"))
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res))
	col_pbx = get_col_pbx()
	col_pbx = dict(map(lambda x: (x[0], x[5]), col_pbx))

	if len(res) > 0:
	text = """
	<span class="adminlabel">Portalbox</span>
	<select name="pbxID" class="admin_w200">
	"""
	text += """<option value="-1">- Select portalbox -"""
	for (id, t_title, t_body) in res:
	if not col_pbx.has_key(id):
	text += """<option value="%s" %s>%s - %s...""" % (id, id == int(pbxID) and 'selected="selected"' or '', t_title, cgi.escape(t_body[0:10]))
	text += "</option>"
	text += """</select><br>"""

	output += createhiddenform(action="deleteportalbox#5.3",
	text=text,
	button="Delete",
	colID=colID,
	ln=ln,
	confirm=0)

	if pbxID not in [-1,"-1"]:
	pbxID = int(pbxID)
	if confirm in [0, "0"]:
	text = """<b>Are you sure you want to delete the portalbox '%s'.</b>
	""" % pbx_dict[pbxID]
	output += createhiddenform(action="deleteportalbox#5.3",
	text=text,
	button="Confirm",
	colID=colID,
	pbxID=pbxID,
	ln=ln,
	confirm=1)

	elif confirm in [1, "1"]:
	if ares:
	output += """<b><span class="info">Deleted the portalbox '%s'.</span></b>
	""" % pname
	else:
	output += """<b><span class="info">Cannot delete the portalbox.</span></b>
	"""
	elif confirm not in [-1, "-1"]:
	output += """<b><span class="info">Choose a portalbox to delete.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showportalboxes(colID, ln, content=output)

	def perform_modifyportalbox(colID, ln=cdslang, pbxID=-1, score='', position='', sel_ln='', title='', body='', callback='yes', confirm=-1):
	"""form to modify a portalbox in a collection, or change the portalbox itself.
	colID - the id of the collection.
	pbxID - the portalbox to change
	score - the score of the portalbox connected to colID which should be changed.
	position - the position of the portalbox in collection colID to change."""

	subtitle = ""
	output = ""

	colID = int(colID)
	res = get_pbx()
	pos = get_pbx_pos()
	lang = dict(get_languages())
	col_dict = dict(get_def_name('', "collection"))
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res))
	col_pbx = get_col_pbx(colID)
	col_pbx = dict(map(lambda x: (x[0], x[5]), col_pbx))

	if pbxID not in [-1, "-1"]:
	pbxID = int(pbxID)
	subtitle = """<a name="5.4"></a>Modify portalbox '%s' for this collection""" % pbx_dict[pbxID]
	col_pbx = get_col_pbx(colID)
	if not (score and position) and not (body and title):
	for (id_pbx, id_collection, tln, score, position, title, body) in col_pbx:
	if id_pbx == pbxID:
	break

	output += """Collection (presentation) specific values (Changes implies only to this collection.)<br>"""
	text = """
	<span class="adminlabel">Position</span>
	<select name="position" class="admin_w200">
	"""
	listpos = pos.items()
	listpos.sort()
	for (key, name) in listpos:
	text += """<option value="%s" %s>%s""" % (key, key==position and 'selected="selected"' or '', name)
	text += "</option>"
	text += """</select><br>"""

	output += createhiddenform(action="modifyportalbox#5.4",
	text=text,
	button="Modify",
	colID=colID,
	pbxID=pbxID,
	score=score,
	title=title,
	body=cgi.escape(body, 1),
	sel_ln=sel_ln,
	ln=ln,
	confirm=3)

	if pbxID > -1 and score and position and confirm in [3, "3"]:
	pbxID = int(pbxID)
	res = modify_pbx(colID, pbxID, sel_ln, score, position, '', '')
	res2 = get_pbx()
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res2))
	if res:
	output += """<b><span class="info">Modified the presentation of the portalbox '%s' in this collection.</span></b><br><br>
	""" % pbx_dict[pbxID]
	else:
	output += """<b><span class="info">Cannot modify the portalbox '%s'.</span></b><br><br>
	""" % pbx_dict[pbxID]

	output += """Portalbox (content) specific values (any changes appears everywhere the portalbox is used.)"""
	text = """
	<span class="adminlabel">Title</span>
	<input class="admin_w200" type="text" name="title" value="%s" /><br>
	""" % title

	text += """
	<span class="adminlabel">Body</span>
	<textarea cols="50" rows="10" class="admin_wvar" type="text" name="body">%s</textarea><br>
	""" % body

	output += createhiddenform(action="modifyportalbox#5.4",
	text=text,
	button="Modify",
	colID=colID,
	pbxID=pbxID,
	sel_ln=sel_ln,
	score=score,
	position=position,
	ln=ln,
	confirm=4)

	if pbxID > -1 and confirm in [4, "4"]:
	pbxID = int(pbxID)
	res = modify_pbx(colID, pbxID, sel_ln, '', '', title, body)
	res2 = get_pbx()
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res2))
	if res:
	output += """<b><span class="info">Modified the content of the portalbox '%s' for all occurences of it.</span></b>
	""" % pbx_dict[pbxID]
	else:
	output += """<b><span class="info">Cannot modify the portalbox '%s'.</span></b>
	""" % pbx_dict[pbxID]
	else:
	output = """No portalbox to modify.
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showportalboxes(colID, ln, content=output)

	def perform_switchpbxscore(colID, id_1, id_2, sel_ln, ln=cdslang):
	"""Switch the score of id_1 and id_2 in collection_portalbox.
	colID - the current collection
	id_1/id_2 - the id's to change the score for.
	sel_ln - the language of the portalbox"""

	res = get_pbx()
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res))
	if switch_pbx_score(colID, id_1, id_2, sel_ln):
	output = """<br><b><span class="info">'%s' changed position with '%s'</span></b>
	""" % (pbx_dict[int(id_1)], pbx_dict[int(id_2)])
	else:
	output = """<br><b><span class="info">Could not complete the operation.</span></b>"""

	return perform_showportalboxes(colID, ln, content=output)

	def perform_showportalboxes(colID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the portalboxes of this collection.
	colID - the portalboxes to show the collection for."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))

	subtitle = """<a name="5">5. Modify portalboxes for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.5">?</a>]</small>""" % (col_dict[colID], weburl)
	output = ""
	pos = get_pbx_pos()


	output = """<dl>
	<dt>Portalbox actions (not related to this collection)
	<dd><a href="addportalbox?colID=%s&ln=%s#5.1">Create new portalbox</a></dd>
	<dd><a href="deleteportalbox?colID=%s&ln=%s#5.3">Delete an unused portalbox</a></dd>
	<dt>Collection specific actions
	<dd><a href="addexistingportalbox?colID=%s&ln=%s#5.2">Add existing portalbox to collection</a></dd>
	</dl>
	""" % (colID, ln, colID, ln, colID, ln)

	header = ['Position', 'Language', '', 'Title', 'Actions']
	actions = []
	cdslang = get_languages()
	lang = dict(cdslang)

	pos_list = pos.items()
	pos_list.sort()

	if len(get_col_pbx(colID)) > 0:
	for (key, value) in cdslang:
	for (pos_key, pos_value) in pos_list:
	res = get_col_pbx(colID, key, pos_key)
	i = 0
	for (pbxID, colID_pbx, tln, score, position, title, body) in res:
	move = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	if i != 0:
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchpbxscore?colID=%s&ln=%s&id_1=%s&id_2=%s&sel_ln=%s&rand=%s#5"><img border="0" src="%s/img/smallup.gif" title="Move portalbox up"></a>""" % (weburl, colID, ln, pbxID, res[i - 1][0], tln, random.randint(0, 1000), weburl)
	else:
	move += "   "
	move += "</td><td>"
	i += 1
	if i != len(res):
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchpbxscore?colID=%s&ln=%s&id_1=%s&id_2=%s&sel_ln=%s&rand=%s#5"><img border="0" src="%s/img/smalldown.gif" title="Move portalbox down"></a>""" % (weburl, colID, ln, pbxID, res[i][0], tln, random.randint(0, 1000), weburl)
	move += """</td></tr></table>"""
	actions.append(["%s" % (i==1 and pos[position] or ''), "%s" % (i==1 and lang[tln] or ''), move, "%s" % title])

	for col in [(('Modify', 'modifyportalbox'), ('Remove', 'removeportalbox'),)]:
	actions[-1].append('<a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&pbxID=%s&sel_ln=%s#5.4">%s</a>' % (weburl, col[0][1], colID, ln, pbxID, tln, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&pbxID=%s&sel_ln=%s#5.5">%s</a>' % (weburl, function, colID, ln, pbxID, tln, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No portalboxes exists for this collection"""

	output += content
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_showportalboxes", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_removeportalbox(colID, ln=cdslang, pbxID='', sel_ln='', callback='yes', confirm=0):
	"""form to remove a portalbox from a collection.
	colID - the current collection, remove the portalbox from this collection.
	sel_ln - remove the portalbox with this language
	pbxID - remove the portalbox with this id"""

	subtitle = """<a name="5.5"></a>Remove portalbox"""
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	res = get_pbx()
	pbx_dict = dict(map(lambda x: (x[0], x[1]), res))

	if colID and pbxID and sel_ln:
	colID = int(colID)
	pbxID = int(pbxID)

	if confirm in ["0", 0]:
	text = """Do you want to remove the portalbox '%s' from the collection '%s'.""" % (pbx_dict[pbxID], col_dict[colID])
	output += createhiddenform(action="removeportalbox#5.5",
	text=text,
	button="Confirm",
	colID=colID,
	pbxID=pbxID,
	sel_ln=sel_ln,
	confirm=1)
	elif confirm in ["1", 1]:
	res = remove_pbx(colID, pbxID, sel_ln)
	if res:
	output += """<b><span class="info">Removed the portalbox '%s' from the collection '%s'.</span></b>
	""" % (pbx_dict[pbxID], col_dict[colID])
	else:
	output += """<b><span class="info">Cannot remove the portalbox from the collection '%s'.</span></b>
	""" % (pbxID, col_dict[colID])

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showportalboxes(colID, ln, content=output)

	def perform_switchfmtscore(colID, type, id_1, id_2, ln=cdslang):
	"""Switch the score of id_1 and id_2 in the table type.
	colID - the current collection
	id_1/id_2 - the id's to change the score for.
	type - like "format" """

	output = ""
	fmt_dict = dict(get_def_name('', "format"))

	if switch_score(colID, id_1, id_2, type):
	output = """<br><b><span class="info">'%s' changed position with '%s'</span></b>
	""" % (fmt_dict[int(id_1)], fmt_dict[int(id_2)])
	else:
	output = """<br><b><span class="info">Could not complete the operation.</span></b>"""

	return perform_showoutputformats(colID, ln, content=output)

	def perform_switchfldscore(colID, id_1, id_2, fmeth, ln=cdslang):
	"""Switch the score of id_1 and id_2 in collection_field_fieldvalue.
	colID - the current collection
	id_1/id_2 - the id's to change the score for."""

	fld_dict = dict(get_def_name('', "field"))
	if switch_fld_score(colID, id_1, id_2):
	output = """<br><b><span class="info">'%s' changed position with '%s'</span></b>
	""" % (fld_dict[int(id_1)], fld_dict[int(id_2)])
	else:
	output = """<br><b><span class="info">Could not complete the operation.</span></b>"""

	if fmeth == "soo":
	return perform_showsortoptions(colID, ln, content=output)
	elif fmeth == "sew":
	return perform_showsearchfields(colID, ln, content=output)
	elif fmeth == "seo":
	return perform_showsearchoptions(colID, ln, content=output)

	def perform_switchfldvaluescore(colID, id_1, id_fldvalue_1, id_fldvalue_2, ln=cdslang):
	"""Switch the score of id_1 and id_2 in collection_field_fieldvalue.
	colID - the current collection
	id_1/id_2 - the id's to change the score for."""

	name_1 = run_sql("SELECT name from fieldvalue where id=%s" % id_fldvalue_1)
	name_2 = run_sql("SELECT name from fieldvalue where id=%s" % id_fldvalue_2)
	if switch_fld_value_score(colID, id_1, id_fldvalue_1, id_fldvalue_2):
	output = """<br><b><span class="info">'%s' changed position with '%s'</span></b>
	""" % (name_1[0][0], name_2[0][0])
	else:
	output = """<br><b><span class="info">Could not complete the operation.</span></b>"""


	return perform_showsearchoptions(colID, ln, content=output)

	def perform_removefield(colID, ln=cdslang, fldID='', fldvID='', fmeth='', callback='yes', confirm=0):
	"""form to remove a field from a collection.
	colID - the current collection, remove the field from this collection.
	sel_ln - remove the field with this language
	fldID - remove the field with this id"""


	subtitle = """<a name="6.4"><a name="7.4"><a name="8.4"></a>Remove field"""
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	fld_dict = dict(get_def_name('', "field"))
	res = get_fld_value()
	fldv_dict = dict(map(lambda x: (x[0], x[1]), res))

	if colID and fldID:
	colID = int(colID)
	fldID = int(fldID)
	if fldvID:
	fldvID = int(fldvID)

	if confirm in ["0", 0]:
	text = """Do you want to remove the field '%s' %s from the collection '%s'.""" % (fld_dict[fldID], (fldvID !="" and "with fieldvalue '%s'" % fldv_dict[fldvID] or ''), col_dict[colID])
	output += createhiddenform(action="removefield#6.5",
	text=text,
	button="Confirm",
	colID=colID,
	fldID=fldID,
	fldvID=fldvID,
	fmeth=fmeth,
	confirm=1)
	elif confirm in ["1", 1]:
	res = remove_fld(colID, fldID, fldvID)
	if res:
	output += """<b><span class="info">Removed the field '%s' %s from the collection '%s'.</span></b>
	""" % (fld_dict[fldID], (fldvID !="" and "with fieldvalue '%s'" % fldv_dict[fldvID] or ''), col_dict[colID])
	else:
	output += """<b><span class="info">Cannot remove the field from the collection '%s'.</span></b>
	""" % (fldID, col_dict[colID])

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)

	if fmeth == "soo":
	return perform_showsortoptions(colID, ln, content=output)
	elif fmeth == "sew":
	return perform_showsearchfields(colID, ln, content=output)
	elif fmeth == "seo":
	return perform_showsearchoptions(colID, ln, content=output)

	def perform_addexistingfield(colID, ln=cdslang, fldID=-1, fldvID=-1, fmeth='', callback='yes', confirm=-1):
	"""form to add an existing field to a collection.
	colID - the collection to add the field to
	fldID - the field to add
	score - the importance of the field.
	position - the position of the field on the page
	sel_ln - the language of the field"""

	subtitle = """<a name="6.2"></a><a name="7.2"></a><a name="8.2"></a>Add existing field to collection"""
	output = ""

	if fldID not in [-1, "-1"] and confirm in [1, "1"]:
	fldID = int(fldID)
	ares = add_col_fld(colID, fldID, fmeth, fldvID)

	colID = int(colID)
	lang = dict(get_languages())
	res = get_def_name('', "field")
	col_dict = dict(get_def_name('', "collection"))
	fld_dict = dict(res)
	col_fld = dict(map(lambda x: (x[0], x[1]), get_col_fld(colID, fmeth)))
	fld_value = get_fld_value()
	fldv_dict = dict(map(lambda x: (x[0], x[1]), fld_value))

	if fldvID:
	fldvID = int(fldvID)
	text = """
	<span class="adminlabel">Field</span>
	<select name="fldID" class="admin_w200">
	<option value="-1">- Select field -</option>
	"""
	for (id, var) in res:
	if fmeth == 'seo' or (fmeth != 'seo' and not col_fld.has_key(id)):
	text += """<option value="%s" %s>%s</option>
	""" % (id, id == int(fldID) and 'selected="selected"' or '', fld_dict[id])

	text += """</select><br>"""

	if fmeth == 'seo':
	text += """
	<span class="adminlabel">Fieldvalue</span>
	<select name="fldvID" class="admin_w200">
	<option value="-1">- Select fieldvalue -</option>
	"""

	res = run_sql("SELECT id,name,value FROM fieldvalue ORDER BY name")
	for (id, name, value) in res:
	text += """<option value="%s" %s>%s</option>
	""" % (id, id == int(fldvID) and 'selected="selected"' or '', name)

	text += """</select><br>"""

	output += createhiddenform(action="addexistingfield#6.2",
	text=text,
	button="Add",
	colID=colID,
	fmeth=fmeth,
	ln=ln,
	confirm=1)

	if fldID not in [-1, "-1"] and confirm in [1, "1"]:
	fldID = int(fldID)
	if ares:
	output += """<b><span class="info">Added the field '%s' %s to the collection '%s'.</span></b>
	""" % (fld_dict[fldID], (fldvID != -1 and "with fieldvalue '%s'" % fldv_dict[fldvID] or ''), col_dict[colID])
	else:
	output += """<b><span class="info">Cannot add the field '%s' %s to the collection '%s'.</span></b>
	""" % (fld_dict[fldID], (fldvID != -1 and "with fieldvalue '%s'" % fldv_dict[fldvID] or ''), col_dict[colID])
	elif fldID in [-1, "-1"] and confirm not in [-1, "-1"]:
	output += """<b><span class="info">Select a field.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	if fmeth == "soo":
	return perform_showsortoptions(colID, ln, content=output)
	elif fmeth == "sew":
	return perform_showsearchfields(colID, ln, content=output)
	elif fmeth == "seo":
	return perform_showsearchoptions(colID, ln, content=output)


	def perform_showsortoptions(colID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the sort fields of this collection.."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))
	fld_dict = dict(get_def_name('', "field"))
	fld_type = get_sort_nametypes()

	subtitle = """<a name="8">8. Modify sort options for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.8">?</a>]</small>""" % (col_dict[colID], weburl)
	output = """<dl>
	<dt>Field actions (not related to this collection)</dt>
	<dd>Go to the BibIndex interface to modify</dd>
	<dt>Collection specific actions
	<dd><a href="addexistingfield?colID=%s&ln=%s&fmeth=soo#8.2">Add field to collection</a></dd>
	</dl>
	""" % (colID, ln)

	header = ['', 'Fieldname', 'Actions']

	actions = []
	cdslang = get_languages()
	lang = dict(cdslang)

	fld_type_list = fld_type.items()

	if len(get_col_fld(colID, 'soo')) > 0:
	res = get_col_fld(colID, 'soo')
	i = 0

	for (fldID, fldvID, stype, score, score_fieldvalue) in res:
	move = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	if i != 0:
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchfldvaluescore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=soo&rand=%s#8"><img border="0" src="%s/img/smallup.gif" title="Move up"></a>""" % (weburl, colID, ln, fldID, res[i - 1][0], random.randint(0, 1000), weburl)
	else:
	move += "   "
	move += "</td><td>"
	i += 1
	if i != len(res):
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchfldvaluescore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=soo&rand=%s#8"><img border="0" src="%s/img/smalldown.gif" title="Move down"></a>""" % (weburl, colID, ln, fldID, res[i][0], random.randint(0, 1000), weburl)
	move += """</td></tr></table>"""

	actions.append([move, fld_dict[int(fldID)]])

	for col in [(('Remove', 'removefield'),)]:
	actions[-1].append('<a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s&fmeth=soo#8.4">%s</a>' % (weburl, col[0][1], colID, ln, fldID, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s&fmeth=soo#8.5">%s</a>' % (weburl, function, colID, ln, fldID, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No sort options exists for this collection"""

	output += content
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_showsortoptions", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showsearchfields(colID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the search fields of this collection.."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))
	fld_dict = dict(get_def_name('', "field"))
	fld_type = get_sort_nametypes()

	subtitle = """<a name="6">6. Modify search fields for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.6">?</a>]</small>""" % (col_dict[colID], weburl)
	output = """<dl>
	<dt>Field actions (not related to this collection)</dt>
	<dd>Go to the BibIndex interface to modify</dd>
	<dt>Collection specific actions
	<dd><a href="addexistingfield?colID=%s&ln=%s&fmeth=sew#6.2">Add field to collection</a></dd>
	</dl>
	""" % (colID, ln)

	header = ['', 'Fieldname', 'Actions']

	actions = []
	cdslang = get_languages()
	lang = dict(cdslang)

	fld_type_list = fld_type.items()

	if len(get_col_fld(colID, 'sew')) > 0:
	res = get_col_fld(colID, 'sew')
	i = 0

	for (fldID, fldvID, stype, score, score_fieldvalue) in res:
	move = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	if i != 0:
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchfldscore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=sew&rand=%s#6"><img border="0" src="%s/img/smallup.gif" title="Move up"></a>""" % (weburl, colID, ln, fldID, res[i - 1][0], random.randint(0, 1000), weburl)
	else:
	move += "   "
	move += "</td><td>"
	i += 1
	if i != len(res):
	move += '<a href="%s/admin/websearch/websearchadmin.py/switchfldscore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=sew&rand=%s#6"><img border="0" src="%s/img/smalldown.gif" title="Move down"></a>' % (weburl, colID, ln, fldID, res[i][0], random.randint(0, 1000), weburl)
	move += """</td></tr></table>"""

	actions.append([move, fld_dict[int(fldID)]])

	for col in [(('Remove', 'removefield'),)]:
	actions[-1].append('<a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s&fmeth=sew#6.4">%s</a>' % (weburl, col[0][1], colID, ln, fldID, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s#6.5">%s</a>' % (weburl, function, colID, ln, fldID, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No search fields exists for this collection"""

	output += content
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_showsearchfields", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showsearchoptions(colID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the sort and search options of this collection.."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))
	fld_dict = dict(get_def_name('', "field"))
	fld_type = get_sort_nametypes()

	subtitle = """<a name="7">7. Modify search options for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.7">?</a>]</small>""" % (col_dict[colID], weburl)
	output = """<dl>
	<dt>Field actions (not related to this collection)</dt>
	<dd>Go to the BibIndex interface to modify</dd>
	<dt>Collection specific actions
	<dd><a href="addexistingfield?colID=%s&ln=%s&fmeth=seo#7.2">Add field to collection</a></dd>
	</dl>
	""" % (colID, ln)

	header = ['', 'Fieldname', '', 'Fieldvalue', 'Actions']

	actions = []
	cdslang = get_languages()
	lang = dict(cdslang)

	fld_type_list = fld_type.items()
	fld_distinct= run_sql("SELECT distinct(id_field) FROM collection_field_fieldvalue WHERE type='seo' AND id_collection=%s ORDER by score desc" % colID)

	if len(fld_distinct) > 0:
	i = 0
	for (id) in fld_distinct:
	col_fld = get_col_fld(colID, 'seo', id)

	#move = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	move = ""
	if i != 0:
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchfldscore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=seo&rand=%s#7"><img border="0" src="%s/img/smallup.gif" title="Move up"></a>""" % (weburl, colID, ln, id[0], fld_distinct[i - 1][0], random.randint(0, 1000), weburl)
	else:
	move += "   "
	#move += "</td><td>"
	i += 1
	if i != len(fld_distinct):
	move += '<a href="%s/admin/websearch/websearchadmin.py/switchfldscore?colID=%s&ln=%s&id_1=%s&id_2=%s&fmeth=seo&rand=%s#7"><img border="0" src="%s/img/smalldown.gif" title="Move down"></a>' % (weburl, colID, ln, id[0], fld_distinct[i][0], random.randint(0, 1000), weburl)
	#move += """</td></tr></table>"""

	j = 0
	for (fldID, fldvID, stype, score, score_fieldvalue) in col_fld:
	fieldvalue = get_fld_value(fldvID)

	#move2 = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	move2 = ""
	if j != 0:
	move2 += """<a href="%s/admin/websearch/websearchadmin.py/switchfldvaluescore?colID=%s&ln=%s&id_1=%s&id_fldvalue_1=%s&id_fldvalue_2=%s&rand=%s#7"><img border="0" src="%s/img/smallup.gif" title="Move up"></a>""" % (weburl, colID, ln, id[0], fldvID, col_fld[j - 1][1], random.randint(0, 1000), weburl)
	else:
	move2 += "   "
	#move2 += "</td><td>"
	j += 1
	if j != len(col_fld):
	move2 += """<a href="%s/admin/websearch/websearchadmin.py/switchfldvaluescore?colID=%s&ln=%s&id_1=%s&id_fldvalue_1=%s&id_fldvalue_2=%s&rand=%s#7"><img border="0" src="%s/img/smalldown.gif" title="Move down"></a>""" % (weburl, colID, ln, id[0], fldvID, col_fld[j][1], random.randint(0, 1000), weburl)
	#move2 += """</td></tr></table>"""

	if fieldvalue[0][1] != fieldvalue[0][2]:
	actions.append([move, "%s" % (j==1 and fld_dict[int(fldID)] or '&nbsp'), move2, "%s - %s" % (fieldvalue[0][1],fieldvalue[0][2])])
	else:
	actions.append([move, "%s" % (j==1 and fld_dict[int(fldID)] or ' '), move2, "%s" % fieldvalue[0][1]])
	move = ''
	for col in [(('Remove', 'removefield'),)]:
	actions[-1].append('<a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s&fldvID=%s&fmeth=seo#7.4">%s</a>' % (weburl, col[0][1], colID, ln, fldID, fldvID, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fldID=%s#7.5">%s</a>' % (weburl, function, colID, ln, fldID, fldvID, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No search options exists for this collection"""

	output += content
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_showsearchoptions", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showoutputformats(colID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""shows the outputformats of the current collection
	colID - the collection id."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))

	subtitle = """<a name="10">10. Modify output formats for collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.10">?</a>]</small>""" % (col_dict[colID], weburl)
	output = """
	<dl>
	<dt>Output format actions (not specific to the chosen collection)
	<dd>Go to the BibFormat interface to modify</dd>
	<dt>Collection specific actions
	<dd><a href="addexistingoutputformat?colID=%s&ln=%s#10.2">Add existing output format to collection</a></dd>
	</dl>
	""" % (colID, ln)

	header = ['', 'Code', 'Output format', 'Actions']
	actions = []

	col_fmt = get_col_fmt(colID)
	fmt_dict = dict(get_def_name('', "format"))

	i = 0
	if len(col_fmt) > 0:
	for (id_format, colID_fld, code, score) in col_fmt:
	move = """<table cellspacing="1" cellpadding="0" border="0"><tr><td>"""
	if i != 0:
	move += """<a href="%s/admin/websearch/websearchadmin.py/switchfmtscore?colID=%s&ln=%s&type=format&id_1=%s&id_2=%s&rand=%s#10"><img border="0" src="%s/img/smallup.gif" title="Move format up"></a>""" % (weburl, colID, ln, id_format, col_fmt[i - 1][0], random.randint(0, 1000), weburl)
	else:
	move += "   "
	move += "</td><td>"
	i += 1
	if i != len(col_fmt):
	move += '<a href="%s/admin/websearch/websearchadmin.py/switchfmtscore?colID=%s&ln=%s&type=format&id_1=%s&id_2=%s&rand=%s#10"><img border="0" src="%s/img/smalldown.gif" title="Move format down"></a>' % (weburl, colID, ln, id_format, col_fmt[i][0], random.randint(0, 1000), weburl)
	move += """</td></tr></table>"""


	actions.append([move, code, fmt_dict[int(id_format)]])
	for col in [(('Remove', 'removeoutputformat'),)]:
	actions[-1].append('<a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fmtID=%s#10">%s</a>' % (weburl, col[0][1], colID, ln, id_format, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/websearch/websearchadmin.py/%s?colID=%s&ln=%s&fmtID=%s#10">%s</a>' % (weburl, function, colID, ln, id_format, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No output formats exists for this collection"""
	output += content
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_showoutputformats", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_addexistingoutputformat(colID, ln=cdslang, fmtID=-1, callback='yes', confirm=-1):
	"""form to add an existing output format to a collection.
	colID - the collection the format should be added to
	fmtID - the format to add."""

	subtitle = """<a name="10.2"></a>Add existing output format to collection"""
	output = ""

	if fmtID not in [-1, "-1"] and confirm in [1, "1"]:
	ares = add_col_fmt(colID, fmtID)
	colID = int(colID)
	res = get_def_name('', "format")
	fmt_dict = dict(res)
	col_dict = dict(get_def_name('', "collection"))
	col_fmt = get_col_fmt(colID)
	col_fmt = dict(map(lambda x: (x[0], x[2]), col_fmt))

	if len(res) > 0:
	text = """
	<span class="adminlabel">Output format</span>
	<select name="fmtID" class="admin_w200">
	<option value="-1">- Select output format -</option>
	"""
	for (id, name) in res:
	if not col_fmt.has_key(id):
	text += """<option value="%s" %s>%s</option>
	""" % (id, id == int(fmtID) and 'selected="selected"' or '', name)
	text += """</select><br>
	"""
	output += createhiddenform(action="addexistingoutputformat#10.2",
	text=text,
	button="Add",
	colID=colID,
	ln=ln,
	confirm=1)
	else:
	output = """No existing output formats to add, please create a new one.
	"""

	if fmtID not in [-1, "-1"] and confirm in [1, "1"]:
	fmtID = int(fmtID)
	if ares:
	output += """<b><span class="info">Added the output format '%s' to the collection '%s'.</span></b>
	""" % (fmt_dict[fmtID], col_dict[colID])
	else:
	output += """<b><span class="info">Cannot add the output format '%s' to the collection '%s'.</span></b>
	""" % (fmt_dict[fmtID], col_dict[colID])
	elif fmtID in [-1, "-1"] and confirm not in [-1, "-1"]:
	output += """<b><span class="info">Please select output format.</span></b>
	"""
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showoutputformats(colID, ln, content=output)

	def perform_deleteoutputformat(colID, ln=cdslang, fmtID=-1, callback='yes', confirm=-1):
	"""form to delete an output format not in use.
	colID - the collection id of the current collection.
	fmtID - the format id to delete."""

	subtitle = """<a name="10.3"></a>Delete an unused output format"""
	output = """
	<dl>
	<dd>Deleting an output format will also delete the translations associated.</dd>
	</dl>
	"""

	colID = int(colID)
	if fmtID not in [-1," -1"] and confirm in [1, "1"]:
	fmt_dict = dict(get_def_name('', "format"))
	old_colNAME = fmt_dict[int(fmtID)]
	ares = delete_fmt(int(fmtID))

	res = get_def_name('', "format")
	fmt_dict = dict(res)
	col_dict = dict(get_def_name('', "collection"))
	col_fmt = get_col_fmt()
	col_fmt = dict(map(lambda x: (x[0], x[2]), col_fmt))

	if len(res) > 0:
	text = """
	<span class="adminlabel">Output format</span>
	<select name="fmtID" class="admin_w200">
	"""
	text += """<option value="-1">- Select output format -"""
	for (id, name) in res:
	if not col_fmt.has_key(id):
	text += """<option value="%s" %s>%s""" % (id, id == int(fmtID) and 'selected="selected"' or '', name)
	text += "</option>"
	text += """</select><br>"""

	output += createhiddenform(action="deleteoutputformat#10.3",
	text=text,
	button="Delete",
	colID=colID,
	ln=ln,
	confirm=0)

	if fmtID not in [-1,"-1"]:
	fmtID = int(fmtID)
	if confirm in [0, "0"]:
	text = """<b>Do you want to delete the output format '%s'.</b>
	""" % fmt_dict[fmtID]
	output += createhiddenform(action="deleteoutputformat#10.3",
	text=text,
	button="Confirm",
	colID=colID,
	fmtID=fmtID,
	ln=ln,
	confirm=1)

	elif confirm in [1, "1"]:
	if ares:
	output += """<b><span class="info">Deleted the output format '%s'.</span></b>
	""" % old_colNAME
	else:
	output += """<b><span class="info">Cannot delete the output format.</span></b>
	"""
	elif confirm not in [-1, "-1"]:
	output += """<b><span class="info">Choose a output format to delete.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showoutputformats(colID, ln, content=output)

	def perform_removeoutputformat(colID, ln=cdslang, fmtID='', callback='yes', confirm=0):
	"""form to remove an output format from a collection.
	colID - the collection id of the current collection.
	fmtID - the format id.
	"""

	subtitle = """<a name="10.5"></a>Remove output format"""
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	fmt_dict = dict(get_def_name('', "format"))

	if colID and fmtID:
	colID = int(colID)
	fmtID = int(fmtID)

	if confirm in ["0", 0]:
	text = """Do you want to remove the output format '%s' from the collection '%s'.""" % (fmt_dict[fmtID], col_dict[colID])
	output += createhiddenform(action="removeoutputformat#10.5",
	text=text,
	button="Confirm",
	colID=colID,
	fmtID=fmtID,
	confirm=1)
	elif confirm in ["1", 1]:
	res = remove_fmt(colID, fmtID)
	if res:
	output += """<b><span class="info">Removed the output format '%s' from the collection '%s'.</span></b>
	""" % (fmt_dict[fmtID], col_dict[colID])
	else:
	output += """<b><span class="info">Cannot remove the field from the collection '%s'.</span></b>
	""" % (col_dict[colID])

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showoutputformats(colID, ln, content=output)

	def perform_index(colID=1, ln=cdslang, mtype='', content='', confirm=0):
	"""The index method, calling methods to show the collection tree, create new collections and add collections to tree.
	"""

	subtitle = "Overview"
	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))

	output = ""
	fin_output = ""
	if not col_dict.has_key(1):
	res = add_col(cdsname, '', '')
	if res:
	fin_output += """<b><span class="info">Created root collection '%s'</span></b><br>""" % cdsname
	else:
	return "Cannot create root collection, please check database."
	if cdsname != run_sql("SELECT name from collection WHERE id=1")[0][0]:
	res = run_sql("update collection set name='%s' where id=1" % cdsname)
	if res:
	fin_output += """<b><span class="info">The name of the root collection has been modified to be the same as the cdsware installation name given prior to installing cdsware.</span><b><br>"""
	else:
	return "Error renaming root collection."
	fin_output += """
	<table>
	<tr>
	<td><b>Menu</b></td>
	</tr>
	<tr>
	<td>0. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_showall">Show all</a></small></td>
	<td>1. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_addcollection">Create new collection</a></small></td>
	<td>2. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_addcollectiontotree">Attach collection to tree</a></small></td>
	<td>3. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_modifycollectiontree">Modify collection tree</a></small></td>
	<td>4. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_runwebcoll">Webcoll Status</a></small></td>
	<td>5. <small><a href="%s/admin/websearch/websearchadmin.py?colID=%s&ln=%s&mtype=perform_validateconf">Collections Status</a></small></td>
	</tr>
	</table>
	""" % (weburl, colID, ln, weburl, colID, ln, weburl, colID, ln, weburl, colID, ln, weburl, colID, ln, weburl, colID, ln)

	if mtype == "":
	fin_output += """<br><br><b><span class="info">For managing the collections, select an item from the menu.</span><b><br>"""

	if mtype == "perform_addcollection" and content:
	fin_output += content
	elif mtype == "perform_addcollection" or mtype == "perform_showall":
	fin_output += perform_addcollection(colID=colID, ln=ln, callback='')
	fin_output += "<br>"

	if mtype == "perform_addcollectiontotree" and content:
	fin_output += content
	elif mtype == "perform_addcollectiontotree" or mtype == "perform_showall":
	fin_output += perform_addcollectiontotree(colID=colID, ln=ln, callback='')
	fin_output += "<br>"

	if mtype == "perform_modifycollectiontree" and content:
	fin_output += content
	elif mtype == "perform_modifycollectiontree" or mtype == "perform_showall":
	fin_output += perform_modifycollectiontree(colID=colID, ln=ln, callback='')
	fin_output += "<br>"

	if mtype == "perform_runwebcoll" and content:
	fin_output += content
	elif mtype == "perform_runwebcoll" or mtype == "perform_showall":
	fin_output += perform_runwebcoll(colID, ln, callback='')

	if mtype == "perform_validateconf" and content:
	fin_output += content
	elif mtype == "perform_validateconf" or mtype == "perform_showall":
	fin_output += perform_validateconf(colID, ln, callback='')

	try:
	body = [fin_output, extra]
	except NameError:
	body = [fin_output]

	return addadminbox('Overview', body)

	def show_coll_not_in_tree(colID, ln, col_dict):
	tree = get_col_tree(colID)
	in_tree = {}
	output = "These collections are not in the tree, and should be added:<br>"
	for (id, up, down, dad, reltype) in tree:
	in_tree[id] = 1
	in_tree[dad] = 1
	res = run_sql("SELECT id from collection")
	if len(res) != len(in_tree):
	for id in res:
	if not in_tree.has_key(id[0]):
	output += """<a href="%s/admin/websearch/websearchadmin.py/editcollection?colID=%s&ln=%s" title="Edit collection">%s</a> ,
	""" % (weburl, id[0], ln, col_dict[id[0]])
	output += "<br><br>"
	else:
	output = ""
	return output

	def create_colltree(tree, col_dict, colID, ln, move_from='', move_to='', rtype='', edit=''):
	"""Creates the presentation of the collection tree, with the buttons for modifying it.
	tree - the tree to present, from get_tree()
	col_dict - the name of the collections in a dictionary
	colID - the collection id to start with
	move_from - if a collection to be moved has been chosen
	move_to - the collection which should be set as father of move_from
	rtype - the type of the tree, regular or virtual
	edit - if the method should output the edit buttons."""

	if move_from:
	move_from_rtype = move_from[0]
	move_from_id = int(move_from[1:len(move_from)])
	tree_from = get_col_tree(colID, move_from_rtype)
	tree_to = get_col_tree(colID, rtype)

	tables = 0
	tstack = []
	i = 0

	text = """
	<table border ="0" cellspacing="0" cellpadding="0">"""
	for i in range(0, len(tree)):
	id_son = tree[i][0]
	up = tree[i][1]
	down = tree[i][2]
	dad = tree[i][3]
	reltype = tree[i][4]
	tmove_from = ""

	j = i
	while j > 0:
	j = j - 1
	try:
	if tstack[j][1] == dad:
	table = tstack[j][2]
	for k in range(0, tables - table):
	tables = tables - 1
	text += """</table></td></tr>
	"""
	break
	except StandardError, e:
	pass
	text += """<tr><td>
	"""

	if i > 0 and tree[i][1] == 0:
	tables = tables + 1
	text += """</td><td></td><td></td><td></td><td><table border="0" cellspacing="0" cellpadding="0"><tr><td>
	"""

	if i == 0:
	tstack.append((id_son, dad, 1))
	else:
	tstack.append((id_son, dad, tables))

	if up == 1 and edit:
	text += """<a href="%s/admin/websearch/websearchadmin.py/modifycollectiontree?colID=%s&ln=%s&move_up=%s&rtype=%s#%s"><img border="0" src="%s/img/smallup.gif" title="Move collection up"></a>""" % (weburl, colID, ln, i, rtype, tree[i][0], weburl)
	else:
	text += """ """
	text += "</td><td>"

	if down == 1 and edit:
	text += """<a href="%s/admin/websearch/websearchadmin.py/modifycollectiontree?colID=%s&ln=%s&move_down=%s&rtype=%s#%s"><img border="0" src="%s/img/smalldown.gif" title="Move collection down"></a>""" % (weburl, colID, ln, i, rtype, tree[i][0], weburl)
	else:
	text += """ """
	text += "</td><td>"

	if edit:
	if move_from and move_to:
	tmove_from = move_from
	move_from = ''
	if not (move_from == "" and i == 0) and not (move_from != "" and int(move_from[1:len(move_from)]) == i and rtype == move_from[0]):
	check = "true"
	if move_from:
	#if tree_from[move_from_id][0] == tree_to[i][0] or not check_col(tree_to[i][0], tree_from[move_from_id][0]):
	# check = ''
	#elif not check_col(tree_to[i][0], tree_from[move_from_id][0]):
	# check = ''
	#if not check and (tree_to[i][0] == 1 and tree_from[move_from_id][3] == tree_to[i][0] and move_from_rtype != rtype):
	# check = "true"
	if check:
	text += """<a href="%s/admin/websearch/websearchadmin.py/modifycollectiontree?colID=%s&ln=%s&move_from=%s&move_to=%s%s&rtype=%s#tree"><img border="0" src="%s/img/move_to.gif" title="Move '%s' to '%s'"></a>
	""" % (weburl, colID, ln, move_from, rtype, i, rtype, weburl, col_dict[tree_from[int(move_from[1:len(move_from)])][0]], col_dict[tree_to[i][0]])
	else:
	text += """<a href="%s/admin/websearch/websearchadmin.py/modifycollectiontree?colID=%s&ln=%s&move_from=%s%s&rtype=%s#%s"><img border="0" src="%s/img/move_from.gif" title="Move '%s' from this location."></a>
	""" % (weburl, colID, ln, rtype, i, rtype, tree[i][0], weburl, col_dict[tree[i][0]])
	else:
	text += """<img border="0" src="%s/img/white_field.gif">
	""" % weburl
	else:
	text += """<img border="0" src="%s/img/white_field.gif">
	""" % weburl

	text += """
	</td>
	<td>"""

	if edit:
	text += """<a href="%s/admin/websearch/websearchadmin.py/modifycollectiontree?colID=%s&ln=%s&delete=%s&rtype=%s#%s"><img border="0" src="%s/img/iconcross.gif" title="Remove colletion from tree"></a>
	""" % (weburl, colID, ln, i, rtype, tree[i][0], weburl)
	elif i != 0:
	text += """<img border="0" src="%s/img/white_field.gif">
	""" % weburl

	text += """</td><td>
	"""

	if tmove_from:
	move_from = tmove_from

	text += """<a name="%s"></a>%s<a href="%s/admin/websearch/websearchadmin.py/editcollection?colID=%s&ln=%s" title="Edit collection">%s</a>%s%s%s
	""" % (tree[i][0], (reltype=="v" and '<i>' or ''), weburl, tree[i][0], ln, col_dict[id_son], (move_to=="%s%s" %(rtype,i) and ' <img border="0" src="%s/img/move_to.gif">' % weburl or ''), (move_from=="%s%s" % (rtype,i) and ' <img border="0" src="%s/img/move_from.gif">' % weburl or ''), (reltype=="v" and '</i>' or ''))

	text += """</td></tr>
	"""

	while tables > 0:
	text += """</table></td></tr>
	"""
	tables = tables - 1
	text += """</table>
	"""

	return text

	def perform_deletecollection(colID, ln=cdslang, confirm=-1, callback='yes'):
	"""form to delete a collection
	colID - id of collection
	"""

	subtitle =''
	output = """
	<span class="warning">
	<strong>
	<dl>
	<dt>WARNING:</dt>
	<dd>When deleting a collection, you also deletes all data related to the collection like translations, relations to other collections and information about which rank methods to use.
	<br>For more information, please go to the <a title="See guide" href="%s/admin/websearch/guide.html">WebSearch guide</a> and read the section regarding deleting a collection.</dd>
	</dl>
	</strong>
	</span>
	""" % weburl

	col_dict = dict(get_def_name('', "collection"))
	if colID !=1 and colID and col_dict.has_key(int(colID)):
	colID = int(colID)
	subtitle = """<a name="4">4. Delete collection '%s'</a> &nbsp <small>[<a title="See guide" href="%s/admin/websearch/guide.html#3.4">?</a>]</small>""" % (col_dict[colID], weburl)
	res = run_sql("SELECT * from collection_collection WHERE id_dad=%s" % colID)
	res2 = run_sql("SELECT * from collection_collection WHERE id_son=%s" % colID)

	if not res and not res2:
	if confirm in ["-1", -1]:
	text = """Do you want to delete this collection."""
	output += createhiddenform(action="deletecollection#4",
	text=text,
	colID=colID,
	button="Delete",
	confirm=0)
	elif confirm in ["0", 0]:
	text = """Are you sure you want to delete this collection."""
	output += createhiddenform(action="deletecollection#4",
	text=text,
	colID=colID,
	button="Confirm",
	confirm=1)
	elif confirm in ["1", 1]:
	result = delete_col(colID)
	if not result:
	raise StandardException
	else:
	output = """<b><span class="info">Can not delete a collection that is a part of the collection tree, remove collection from the tree and try again.</span></b>"""
	else:
	subtitle = """4. Delete collection"""
	output = """<b><span class="info">Not possible to delete the root collection</span></b>"""


	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_editcollection(colID, ln, "perform_deletecollection", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_editcollection(colID=1, ln=cdslang, mtype='', content=''):
	"""form to modify a collection. this method is calling other methods which again is calling this and sending back the output of the method.
	if callback, the method will call perform_editcollection, if not, it will just return its output.
	colID - id of the collection
	mtype - the method that called this method.
	content - the output from that method."""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))
	if not col_dict.has_key(colID):
	return """<b><span class="info">Collection deleted.</span></b>
	"""

	fin_output = """
	<table>
	<tr>
	<td><b>Menu</b></td>
	</tr>
	<tr>
	<td>0. <small><a href="editcollection?colID=%s&ln=%s">Show all</a></small></td>
	<td>1. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_modifydbquery">Modify collection query</a></small></td>
	<td>2. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_modifyrestricted">Modify access restrictions</a></small></td>
	<td>3. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_modifytranslations">Modify translations</a></small></td>
	</tr>
	<tr>
	<td>4. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_deletecollection">Delete collection</a></small></td>
	<td>5. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_showportalboxes">Modify portalboxes</a></small></td>
	<td>6. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_showsearchfields#6">Modify search fields</a></small></td>
	<td>7. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_showsearchoptions#7">Modify search options</a></small></td>
	</tr>
	<tr>
	<td>8. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_showsortoptions#8">Modify sort options</a></small></td>
	<td>9. <small><a href="editcollection?colID=%s&ln=%s&mtype=perform_modifyrankmethods#9">Modify rank options</a></small></td>
	<td>10.<small><a href="editcollection?colID=%s&ln=%s&mtype=perform_showoutputformats#10">Modify output formats</a></small></td>
	</tr>
	</table>
	""" % (colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln, colID, ln)

	if mtype == "perform_modifydbquery" and content:
	fin_output += content
	elif mtype == "perform_modifydbquery" or not mtype:
	fin_output += perform_modifydbquery(colID, ln, callback='')

	if mtype == "perform_modifyrestricted" and content:
	fin_output += content
	elif mtype == "perform_modifyrestricted" or not mtype:
	fin_output += perform_modifyrestricted(colID, ln, callback='')

	if mtype == "perform_modifytranslations" and content:
	fin_output += content
	elif mtype == "perform_modifytranslations" or not mtype:
	fin_output += perform_modifytranslations(colID, ln, callback='')

	if mtype == "perform_deletecollection" and content:
	fin_output += content
	elif mtype == "perform_deletecollection" or not mtype:
	fin_output += perform_deletecollection(colID, ln, callback='')

	if mtype == "perform_showportalboxes" and content:
	fin_output += content
	elif mtype == "perform_showportalboxes" or not mtype:
	fin_output += perform_showportalboxes(colID, ln, callback='')

	if mtype == "perform_showsearchfields" and content:
	fin_output += content
	elif mtype == "perform_showsearchfields" or not mtype:
	fin_output += perform_showsearchfields(colID, ln, callback='')

	if mtype == "perform_showsearchoptions" and content:
	fin_output += content
	elif mtype == "perform_showsearchoptions" or not mtype:
	fin_output += perform_showsearchoptions(colID, ln, callback='')

	if mtype == "perform_showsortoptions" and content:
	fin_output += content
	elif mtype == "perform_showsortoptions" or not mtype:
	fin_output += perform_showsortoptions(colID, ln, callback='')

	if mtype == "perform_modifyrankmethods" and content:
	fin_output += content
	elif mtype == "perform_modifyrankmethods" or not mtype:
	fin_output += perform_modifyrankmethods(colID, ln, callback='')

	if mtype == "perform_showoutputformats" and content:
	fin_output += content
	elif mtype == "perform_showoutputformats" or not mtype:
	fin_output += perform_showoutputformats(colID, ln, callback='')

	return addadminbox("Overview of edit options for collection '%s'" % col_dict[colID], [fin_output])

	def perform_runwebcoll(colID, ln, confirm=0, callback='yes'):
	"""form to delete an output format not in use.
	colID - the collection id of the current collection.
	fmtID - the format id to delete."""

	subtitle = """<a name="11"></a>Webcoll Status"""
	output = ""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))

	output += """<br><b>Last updates:</b><br>"""
	collection_table_update_time = ""
	collection_web_update_time = ""

	res = run_sql("SHOW TABLE STATUS LIKE 'collection'")
	if res:
	collection_table_update_time = str(res[0][11])[0:len(collection_table_update_time) - 3]
	output += "Collection table last updated: %s<br>" % collection_table_update_time
	try:

	file = open("%s/collections/1/last-updated-ln=en.html" % cachedir)
	collection_web_update_time = str(file.readline())
	output += "Collection webpage last updated: %s<br>" % collection_web_update_time
	file.close()
	except StandardError, e:
	pass

	import datetime
	import time
	tabletime = time.strptime(collection_table_update_time, "%Y-%m-%d %H:%M:%S")
	webtime = time.strptime(collection_web_update_time, "%d %B %Y %H:%M:%S %Z")

	if tabletime > webtime:
	output += """<br><b><span class="info">Warning: The collections has been modified since last time Webcoll was executed, to process the changes, Webcoll must be executed.</span></b><br>"""

	header = ['ID', 'Name', 'Time', 'Status', 'Progress']
	actions = []
	output += """<br><b>Last BibSched tasks:</b><br>"""

	res = run_sql("select id, proc, host, user, runtime, sleeptime, arguments, status, progress from schTASK where proc='webcoll' and runtime< now() ORDER by runtime")
	if len(res) > 0:
	(id, proc, host, user, runtime, sleeptime, arguments, status, progress) = res[len(res) - 1]
	webcoll__update_time = runtime
	actions.append([id, proc, runtime, status, progress])
	else:
	actions.append(['', 'webcoll', '', '', 'Not executed yet'])

	res = run_sql("select id, proc, host, user, runtime, sleeptime, arguments, status, progress from schTASK where proc='bibindex' and runtime< now() ORDER by runtime")
	if len(res) > 0:
	(id, proc, host, user, runtime, sleeptime, arguments, status, progress) = res[len(res) - 1]
	actions.append([id, proc, runtime, status, progress])
	else:
	actions.append(['', 'bibindex', '', '', 'Not executed yet'])

	output += tupletotable(header=header, tuple=actions)

	output += """<br><b>Next scheduled BibSched run:</b><br>"""
	actions = []

	res = run_sql("select id, proc, host, user, runtime, sleeptime, arguments, status, progress from schTASK where proc='webcoll' and runtime > now() ORDER by runtime")

	webcoll_future = ""
	if len(res) > 0:
	(id, proc, host, user, runtime, sleeptime, arguments, status, progress) = res[0]
	webcoll__update_time = runtime
	actions.append([id, proc, runtime, status, progress])
	webcoll_future = "yes"
	else:
	actions.append(['', 'webcoll', '', '', 'Not scheduled'])

	res = run_sql("select id, proc, host, user, runtime, sleeptime, arguments, status, progress from schTASK where proc='bibindex' and runtime > now() ORDER by runtime")

	bibindex_future = ""
	if len(res) > 0:
	(id, proc, host, user, runtime, sleeptime, arguments, status, progress) = res[0]
	actions.append([id, proc, runtime, status, progress])
	bibindex_future = "yes"
	else:
	actions.append(['', 'bibindex', '', '', 'Not scheduled'])

	output += tupletotable(header=header, tuple=actions)

	if webcoll_future == "":
	output += """<br><b><span class="info">Warning: Webcoll is not scheduled for a future run by bibsched, any updates to the collection will not be processed.</span></b><br>"""
	if bibindex_future == "":
	output += """<br><b><span class="info">Warning: Bibindex is not scheduled for a future run by bibsched, any updates to the records will not be processed.</span></b><br>"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(colID, ln, "perform_runwebcoll", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_validateconf(colID, ln, confirm=0, callback='yes'):
	"""form to delete an output format not in use.
	colID - the collection id of the current collection.
	fmtID - the format id to delete."""

	subtitle = """<a name="11"></a>Collections Status"""
	output = ""

	colID = int(colID)
	col_dict = dict(get_def_name('', "collection"))
	collections = run_sql("SELECT id, name, dbquery, restricted FROM collection ORDER BY id")

	header = ['Id', 'Name', 'Query', 'Subcollections', 'Restricted', 'I8N','Status']
	rnk_list = get_def_name('', "rnkMETHOD")
	actions = []

	for (id, name, dbquery, restricted) in collections:
	reg_sons = len(get_col_tree(id, 'r'))
	vir_sons = len(get_col_tree(id, 'v'))
	status = ""
	langs = run_sql("SELECT ln from collectionname where id_collection=%s" % id)
	i8n = ""

	if len(langs) > 0:
	for lang in langs:
	i8n += "%s, " % lang
	else:
	i8n = """<b><span class="info">None</span></b>"""

	if (reg_sons > 1 and dbquery) or dbquery=="":
	status = """<b><span class="warning">ERROR 1:Query</span></b>"""
	elif dbquery is None and reg_sons == 1:
	status = """<b><span class="warning">ERROR 2:Query</span></b>"""
	elif dbquery == "" and reg_sons == 1:
	status = """<b><span class="warning">ERROR 3:Query</span></b>"""

	if (reg_sons > 1 or vir_sons > 1):
	subs = """<b><span class="info">Yes</span></b>"""
	else:
	subs = """<b><span class="info">No</span></b>"""

	if dbquery is None:
	dbquery = """<b><span class="info">No</span></b>"""

	if restricted == "":
	restricted = ""
	if status:
	status += """<b><span class="warning">,4:Restricted</span></b>"""
	else:
	status += """<b><span class="warning">ERROR 4:Restricted</span></b>"""
	elif restricted is None:
	restricted = """<b><span class="info">No</span></b>"""

	if status == "":
	status = """<b><span class="info">OK</span></b>"""
	actions.append([id, """<a href="%s/admin/websearch/websearchadmin.py/editcollection?colID=%s&ln=%s">%s</a>""" % (weburl, id, ln, name), dbquery, subs, restricted, i8n, status])

	output += tupletotable(header=header, tuple=actions)

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(colID, ln, "perform_validateconf", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_removeoutputformat(colID, ln=cdslang, fmtID='', callback='yes', confirm=0):
	"""form to remove an output format from a collection.
	colID - the collection id of the current collection.
	fmtID - the format id.
	"""

	subtitle = """<a name="10.5"></a>Remove output format"""
	output = ""

	col_dict = dict(get_def_name('', "collection"))
	fmt_dict = dict(get_def_name('', "format"))

	if colID and fmtID:
	colID = int(colID)
	fmtID = int(fmtID)

	if confirm in ["0", 0]:
	text = """Do you want to remove the output format '%s' from the collection '%s'.""" % (fmt_dict[fmtID], col_dict[colID])
	output += createhiddenform(action="removeoutputformat#10.5",
	text=text,
	button="Confirm",
	colID=colID,
	fmtID=fmtID,
	confirm=1)
	elif confirm in ["1", 1]:
	res = remove_fmt(colID, fmtID)
	if res:
	output += """<b><span class="info">Removed the output format '%s' from the collection '%s'.</span></b>
	""" % (fmt_dict[fmtID], col_dict[colID])
	else:
	output += """<b><span class="info">Cannot remove the field from the collection '%s'.</span></b>
	""" % (col_dict[colID])

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showoutputformats(colID, ln, content=output)

	def get_col_tree(colID, rtype=''):
	"""Returns a presentation of the tree as a list.
	colID - startpoint for the tree
	rtype - get regular or virtual part of the tree"""

	try:
	colID = int(colID)
	stack = [colID]
	ssize = 0
	tree = [(colID, 0, 0, colID, 'r')]
	while len(stack) > 0:
	ccolID = stack.pop()
	if ccolID == colID and rtype:
	res = run_sql("SELECT id_son, score, type FROM collection_collection WHERE id_dad=%s AND type='%s' ORDER BY score ASC,id_son" % (ccolID,rtype))
	else:
	res = run_sql("SELECT id_son, score, type FROM collection_collection WHERE id_dad=%s ORDER BY score ASC,id_son" % ccolID)
	ssize += 1
	ntree = []
	for i in range(0,len(res)):
	id_son = res[i][0]
	score = res[i][1]
	rtype = res[i][2]
	stack.append(id_son)
	if i == (len(res) - 1):
	up = 0
	else:
	up = 1
	if i == 0:
	down = 0
	else:
	down = 1
	ntree.insert(0, (id_son, up, down, ccolID, rtype))
	tree = tree[0:ssize] + ntree + tree[ssize:len(tree)]
	return tree
	except StandardError, e:
	return ()

	def remove_col_subcol(id_son, id_dad, type):
	"""Remove a collection as a son of another collection in the tree, if collection isn't used elsewhere in the tree, remove all registered sons of the id_son.
	id_son - collection id of son to remove
	id_dad - the id of the dad"""

	try:
	if id_son != id_dad:
	tree = get_col_tree(id_son)
	res = run_sql("DELETE FROM collection_collection WHERE id_son=%s and id_dad=%s" % (id_son, id_dad))
	else:
	tree = get_col_tree(id_son, type)
	res = run_sql("DELETE FROM collection_collection WHERE id_son=%s and id_dad=%s and type='%s'" % (id_son, id_dad, type))

	if not run_sql("SELECT * from collection_collection WHERE id_son=%s and type='%s'" % (id_son, type)):
	for (id, up, down, dad, rtype) in tree:
	res = run_sql("DELETE FROM collection_collection WHERE id_son=%s and id_dad=%s" % (id, dad))
	return "true"
	except StandardError, e:
	return ()

	def check_col(add_dad, add_son):
	"""Check if the collection can be placed as a son of the dad without causing loops.
	add_dad - collection id
	add_son - collection id"""

	try:
	stack = [add_dad]
	res = run_sql("SELECT id_dad FROM collection_collection WHERE id_dad=%s AND id_son=%s" % (add_dad,add_son))
	if res:
	raise StandardError
	while len(stack) > 0:
	colID = stack.pop()
	res = run_sql("SELECT id_dad FROM collection_collection WHERE id_son=%s" % colID)
	for id in res:
	if int(id[0]) == int(add_son):
	raise StandardError
	else:
	stack.append(id[0])
	return "true"
	except StandardError, e:
	return ""

	def add_col_dad_son(add_dad, add_son, rtype):
	"""Add a son to a collection (dad)
	add_dad - add to this collection id
	add_son - add this collection id
	rtype - either regular or virtual"""

	try:
	res = run_sql("SELECT score FROM collection_collection WHERE id_dad=%s ORDER BY score ASC" % add_dad)
	highscore = 0
	for score in res:
	if int(score[0]) > highscore:
	highscore = int(score[0])
	highscore += 1
	res = run_sql("INSERT INTO collection_collection(id_dad,id_son,score,type) values(%s,%s,%s,'%s')" % (add_dad, add_son, highscore, rtype))
	return highscore
	except StandardError, e:
	return ()

	def switch_col_treescore(col_1, col_2):
	try:
	res1 = run_sql("SELECT score FROM collection_collection WHERE id_dad=%s and id_son=%s" % (col_1[3], col_1[0]))
	res2 = run_sql("SELECT score FROM collection_collection WHERE id_dad=%s and id_son=%s" % (col_2[3], col_2[0]))
	res = run_sql("UPDATE collection_collection SET score=%s WHERE id_dad=%s and id_son=%s" % (res2[0][0], col_1[3], col_1[0]))
	res = run_sql("UPDATE collection_collection SET score=%s WHERE id_dad=%s and id_son=%s" % (res1[0][0], col_2[3], col_2[0]))
	return "true"
	except StandardError, e:
	return ()

	def move_col_tree(col_from, col_to, move_to_rtype=''):
	"""Move a collection from one point in the tree to another. becomes a son of the endpoint.
	col_from - move this collection from current point
	col_to - and set it as a son of this collection.
	move_to_rtype - either virtual or regular collection"""

	try:
	res = run_sql("SELECT score FROM collection_collection WHERE id_dad=%s ORDER BY score asc" % col_to[0])
	highscore = 0
	for score in res:
	if int(score[0]) > highscore:
	highscore = int(score[0])
	highscore += 1
	if not move_to_rtype:
	move_to_rtype = col_from[4]
	res = run_sql("DELETE FROM collection_collection WHERE id_son=%s and id_dad=%s" % (col_from[0], col_from[3]))
	res = run_sql("INSERT INTO collection_collection(id_dad,id_son,score,type) values(%s,%s,%s,'%s')" % (col_to[0], col_from[0], highscore, move_to_rtype))
	return "true"
	except StandardError, e:
	return ()

	def compare_on_val(first, second):
	"""Compare the two values"""

	return cmp(first[1], second[1])

	def get_col_fld(colID=-1, type = '', id_field=''):
	"""Returns either all portalboxes associated with a collection, or based on either colID or language or both.
	colID - collection id
	ln - language id"""

	sql = "SELECT id_field,id_fieldvalue,type,score,score_fieldvalue FROM collection_field_fieldvalue, field WHERE id_field=field.id"

	try:
	if colID > -1:
	sql += " AND id_collection=%s" % colID
	if id_field:
	sql += " AND id_field=%s" % id_field
	if type:
	sql += " AND type='%s'" % type
	sql += " ORDER BY type, score desc, score_fieldvalue desc"
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_col_pbx(colID=-1, ln='', position = ''):
	"""Returns either all portalboxes associated with a collection, or based on either colID or language or both.
	colID - collection id
	ln - language id"""

	sql = "SELECT id_portalbox, id_collection, ln, score, position, title, body FROM collection_portalbox, portalbox WHERE id_portalbox = portalbox.id"

	try:
	if colID > -1:
	sql += " AND id_collection=%s" % colID
	if ln:
	sql += " AND ln='%s'" % ln
	if position:
	sql += " AND position='%s'" % position
	sql += " ORDER BY position, ln, score desc"
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_col_fmt(colID=-1):
	"""Returns all formats currently associated with a collection, or for one specific collection
	colID - the id of the collection"""

	try:
	if colID not in [-1, "-1"]:
	res = run_sql("SELECT id_format, id_collection, code, score FROM collection_format, format WHERE id_format = format.id AND id_collection=%s ORDER BY score desc" % colID)
	else:
	res = run_sql("SELECT id_format, id_collection, code, score FROM collection_format, format WHERE id_format = format.id ORDER BY score desc")
	return res
	except StandardError, e:
	return ""

	def get_col_rnk(colID, ln=cdslang):
	""" Returns a list of the rank methods the given collection is attached to
	colID - id from collection"""

	try:
	res1 = dict(run_sql("SELECT id_rnkMETHOD, '' FROM collection_rnkMETHOD WHERE id_collection=%s" % colID))
	res2 = get_def_name('', "rnkMETHOD")
	result = filter(lambda x: res1.has_key(x[0]), res2)
	return result
	except StandardError, e:
	return ()

	def get_pbx():
	"""Returns all portalboxes"""

	try:
	res = run_sql("SELECT id, title, body FROM portalbox ORDER by title,body")
	return res
	except StandardError, e:
	return ""

	def get_fld_value(fldvID = ''):
	"""Returns fieldvalue"""

	try:
	sql = "SELECT id, name, value FROM fieldvalue"
	if fldvID:
	sql += " WHERE id=%s" % fldvID
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_pbx_pos():
	"""Returns a list of all the positions for a portalbox"""

	position = {}
	position["rt"] = "Right Top"
	position["lt"] = "Left Top"
	position["te"] = "Title Epilog"
	position["tp"] = "Title Prolog"
	position["ne"] = "Narrow by coll epilog"
	position["np"] = "Narrow by coll prolog"
	return position

	def get_sort_nametypes():
	"""Return a list of the various translationnames for the fields"""

	type = {}
	type['soo'] = 'Sort options'
	type['seo'] = 'Search options'
	type['sew'] = 'Search within'
	return type

	def get_fmt_nametypes():
	"""Return a list of the various translationnames for the output formats"""

	type = []
	type.append(('ln', 'Long name'))
	return type

	def get_fld_nametypes():
	"""Return a list of the various translationnames for the fields"""

	type = []
	type.append(('ln', 'Long name'))
	return type

	def get_col_nametypes():
	"""Return a list of the various translationnames for the collections"""

	type = []
	type.append(('ln', 'Long name'))
	return type

	def find_last(tree, start_son):
	"""Find the previous collection in the tree with the same father as start_son"""

	id_dad = tree[start_son][3]
	while start_son > 0:
	start_son -= 1
	if tree[start_son][3] == id_dad:
	return start_son

	def find_next(tree, start_son):
	"""Find the next collection in the tree with the same father as start_son"""

	id_dad = tree[start_son][3]
	while start_son < len(tree):
	start_son += 1
	if tree[start_son][3] == id_dad:
	return start_son

	def attach_rnk_col(colID, rnkID):
	"""attach rank method to collection
	rnkID - id from rnkMETHOD table
	colID - id of collection, as in collection table """

	try:
	res = run_sql("INSERT INTO collection_rnkMETHOD(id_collection, id_rnkMETHOD) values (%s,%s)" % (colID, rnkID))
	return "true"
	except StandardError, e:
	return ""

	def detach_rnk_col(colID, rnkID):
	"""detach rank method from collection
	rnkID - id from rnkMETHOD table
	colID - id of collection, as in collection table """

	try:
	res = run_sql("DELETE FROM collection_rnkMETHOD WHERE id_collection=%s AND id_rnkMETHOD=%s" % (colID, rnkID))
	except StandardError, e:
	return ""
	return "true"

	def remove_pbx(colID, pbxID, ln):
	"""Removes a portalbox from the collection given.
	colID - the collection the format is connected to
	pbxID - the portalbox which should be removed from the collection.
	ln - the language of the portalbox to be removed"""

	try:
	res = run_sql("DELETE FROM collection_portalbox WHERE id_collection=%s AND id_portalbox=%s AND ln='%s'" % (colID, pbxID, ln))
	return "true"
	except StandardError, e:
	return ""

	def remove_fmt(colID,fmtID):
	"""Removes a format from the collection given.
	colID - the collection the format is connected to
	fmtID - the format which should be removed from the collection."""

	try:
	res = run_sql("DELETE FROM collection_format WHERE id_collection=%s AND id_format=%s" % (colID, fmtID))
	return "true"
	except StandardError, e:
	return ""

	def remove_fld(colID,fldID, fldvID=''):
	"""Removes a field from the collection given.
	colID - the collection the format is connected to
	fldID - the field which should be removed from the collection."""

	try:
	sql = "DELETE FROM collection_field_fieldvalue WHERE id_collection=%s AND id_field=%s" % (colID, fldID)
	if fldvID:
	sql += " AND id_fieldvalue=%s" % fldvID
	res = run_sql(sql)
	return "true"
	except StandardError, e:
	return ""

	def delete_pbx(pbxID):
	"""Deletes all data for the given portalbox
	pbxID - delete all data in the tables associated with portalbox and this id """

	try:
	res = run_sql("DELETE FROM collection_portalbox WHERE id_portalbox=%s" % pbxID)
	res = run_sql("DELETE FROM portalbox WHERE id=%s" % pbxID)
	return "true"
	except StandardError, e:
	return ""

	def delete_fmt(fmtID):
	"""Deletes all data for the given format
	fmtID - delete all data in the tables associated with format and this id """

	try:
	res = run_sql("DELETE FROM format WHERE id=%s" % fmtID)
	res = run_sql("DELETE FROM collection_format WHERE id_format=%s" % fmtID)
	res = run_sql("DELETE FROM formatname WHERE id_format=%s" % fmtID)
	return "true"
	except StandardError, e:
	return ""

	def delete_col(colID):
	"""Deletes all data for the given collection
	colID - delete all data in the tables associated with collection and this id """

	try:
	res = run_sql("DELETE FROM collection WHERE id=%s" % colID)
	res = run_sql("DELETE FROM collectionname WHERE id_collection=%s" % colID)
	res = run_sql("DELETE FROM collection_rnkMETHOD WHERE id_collection=%s" % colID)
	res = run_sql("DELETE FROM collection_collection WHERE id_dad=%s" % colID)
	res = run_sql("DELETE FROM collection_collection WHERE id_son=%s" % colID)
	res = run_sql("DELETE FROM collection_portalbox WHERE id_collection=%s" % colID)
	res = run_sql("DELETE FROM collection_format WHERE id_collection=%s" % colID)
	res = run_sql("DELETE FROM collection_field_fieldvalue WHERE id_collection=%s" % colID)
	return "true"
	except StandardError, e:
	return ""

	def add_fmt(code, name, rtype):
	"""Add a new output format. Returns the id of the format.
	code - the code for the format, max 6 chars.
	name - the default name for the default language of the format.
	rtype - the default nametype"""

	try:
	res = run_sql("INSERT INTO format (code, name) values ('%s','%s')" % (MySQLdb.escape_string(code), MySQLdb.escape_string(name)))
	fmtID = run_sql("SELECT id FROM format WHERE code='%s'" % MySQLdb.escape_string(code))
	res = run_sql("INSERT INTO formatname(id_format, type, ln, value) VALUES (%s,'%s','%s','%s')" % (fmtID[0][0], rtype, cdslang, MySQLdb.escape_string(name)))
	return fmtID
	except StandardError, e:
	return ""

	def add_pbx(title, body):
	try:
	res = run_sql("INSERT INTO portalbox (title, body) values ('%s','%s')" % (MySQLdb.escape_string(title), MySQLdb.escape_string(body)))
	res = run_sql("SELECT id FROM portalbox WHERE title='%s' AND body='%s'" % (MySQLdb.escape_string(title), MySQLdb.escape_string(body)))
	return res
	except StandardError, e:
	return ""

	def add_col(colNAME, dbquery, rest):
	"""Adds a new collection to collection table
	colNAME - the default name for the collection, saved to collection and collectionname
	dbquery - query related to the collection
	rest - name of apache group allowed to access collection"""

	try:
	rtype = get_col_nametypes()[0][0]
	colID = run_sql("SELECT id FROM collection WHERE id=1")
	if colID:
	sql = "INSERT INTO collection(name,dbquery,restricted) VALUES('%s'" % MySQLdb.escape_string(colNAME)
	else:
	sql = "INSERT INTO collection(id,name,dbquery,restricted) VALUES(1,'%s'" % MySQLdb.escape_string(colNAME)
	if dbquery:
	sql += ",'%s'" % MySQLdb.escape_string(dbquery)
	else:
	sql += ",null"
	if rest:
	sql += ",'%s'" % MySQLdb.escape_string(rest)
	else:
	sql += ",null"
	sql += ")"
	res = run_sql(sql)
	colID = run_sql("SELECT id FROM collection WHERE name='%s'" % MySQLdb.escape_string(colNAME))
	res = run_sql("INSERT INTO collectionname(id_collection, type, ln, value) VALUES (%s,'%s','%s','%s')" % (colID[0][0], rtype, cdslang, MySQLdb.escape_string(colNAME)))
	return colID
	except StandardError, e:
	return ""

	def add_col_pbx(colID, pbxID, ln, position, score=''):
	"""add a portalbox to the collection.
	colID - the id of the collection involved
	pbxID - the portalbox to add
	ln - which language the portalbox is for
	score - decides which portalbox is the most important
	position - position on page the portalbox should appear."""

	try:
	if score:
	res = run_sql("INSERT INTO collection_portalbox(id_portalbox, id_collection, ln, score, position) values (%s,%s,'%s',%s,'%s')" % (pbxID, colID, ln, score, position))
	else:
	res = run_sql("SELECT score FROM collection_portalbox WHERE id_collection=%s and ln='%s' and position='%s' ORDER BY score desc, ln, position" % (colID, ln, position))
	if res:
	score = int(res[0][0])
	else:
	score = 0
	res = run_sql("INSERT INTO collection_portalbox(id_portalbox, id_collection, ln, score, position) values (%s,%s,'%s',%s,'%s')" % (pbxID, colID, ln, (score + 1), position))
	return "true"
	except StandardError, e:
	return ""

	def add_col_fmt(colID, fmtID, score=''):
	"""Add a output format to the collection.
	colID - the id of the collection involved
	fmtID - the id of the format.
	score - the score of the format, decides sorting, if not given, place the format on top"""

	try:
	if score:
	res = run_sql("INSERT INTO collection_format(id_format, id_collection, score) values (%s,%s,%s)" % (fmtID, colID, score))
	else:
	res = run_sql("SELECT score FROM collection_format WHERE id_collection=%s ORDER BY score desc" % colID)
	if res:
	score = int(res[0][0])
	else:
	score = 0
	res = run_sql("INSERT INTO collection_format(id_format, id_collection, score) values (%s,%s,%s)" % (fmtID, colID, (score + 1)))
	return "true"
	except StandardError, e:
	return ""

	def add_col_fld(colID, fldID, type, fldvID=''):
	"""Add a sort/search/field to the collection.
	colID - the id of the collection involved
	fmtID - the id of the format.
	score - the score of the format, decides sorting, if not given, place the format on top"""

	try:
	if fldvID and fldvID not in [-1, "-1"]:
	res = run_sql("SELECT score, score_fieldvalue FROM collection_field_fieldvalue WHERE id_collection=%s AND id_field=%s ORDER BY score desc, score_fieldvalue desc" % (colID, fldID))

	if res:
	score = int(res[0][0])
	v_score = int(res[0][1])
	else:
	score = 0
	v_score = 0
	res = run_sql("SELECT * FROM collection_field_fieldvalue where id_field=%s and id_collection=%s and type='%s' and id_fieldvalue=%s" % (fldID, colID, type, fldvID))
	if not res:
	res = run_sql("INSERT INTO collection_field_fieldvalue(id_field, id_fieldvalue, id_collection, type, score, score_fieldvalue) values (%s,%s,%s,'%s',%s,%s)" % (fldID, fldvID, colID, type, score, (v_score + 1)))
	else:
	raise StandardError
	else:
	res = run_sql("SELECT score FROM collection_field_fieldvalue WHERE id_collection=%s AND id_field=%s ORDER BY score desc" % (colID, fldID))
	if res:
	score = int(res[0][0])
	else:
	score = 0
	res = run_sql("INSERT INTO collection_field_fieldvalue(id_field, id_collection, type, score) values (%s,%s,'%s',%s)" % (fldID, colID, type, (score + 1)))
	return "true"
	except StandardError, e:
	return ""

	def modify_restricted(colID, rest):
	"""Modify the dwhich apache group is allowed to use the collection.
	colID - the id of the collection involved
	restricted - the new group"""

	try:
	sql = "UPDATE collection SET restricted="
	if rest:
	sql += "'%s'" % MySQLdb.escape_string(rest)
	else:
	sql += "null"
	sql += " WHERE id=%s" % colID
	res = run_sql(sql)
	return "true"
	except StandardError, e:
	return ""

	def modify_dbquery(colID, dbquery):
	"""Modify the dbquery of an collection.
	colID - the id of the collection involved
	dbquery - the new dbquery"""

	try:
	sql = "UPDATE collection SET dbquery="
	if dbquery:
	sql += "'%s'" % MySQLdb.escape_string(dbquery)
	else:
	sql += "null"
	sql += " WHERE id=%s" % colID
	res = run_sql(sql)
	return "true"
	except StandardError, e:
	return ""

	def modify_pbx(colID, pbxID, sel_ln, score='', position='', title='', body=''):
	"""Modify a portalbox
	colID - the id of the collection involved
	pbxID - the id of the portalbox that should be modified
	sel_ln - the language of the portalbox that should be modified
	title - the title
	body - the content
	score - if several portalboxes in one position, who should appear on top.
	position - position on page"""

	try:
	if title:
	res = run_sql("UPDATE portalbox SET title='%s' WHERE id=%s" % (MySQLdb.escape_string(title), pbxID))
	if body:
	res = run_sql("UPDATE portalbox SET body='%s' WHERE id=%s" % (MySQLdb.escape_string(body), pbxID))
	if score:
	res = run_sql("UPDATE collection_portalbox SET score='%s' WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (score, colID, pbxID, sel_ln))
	if position:
	res = run_sql("UPDATE collection_portalbox SET position='%s' WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (position, colID, pbxID, sel_ln))
	return "true"
	except StandardError, e:
	return ""

	def switch_fld_score(colID, id_1, id_2):
	"""Switch the scores of id_1 and id_2 in collection_field_fieldvalue
	colID - collection the id_1 or id_2 is connected to
	id_1/id_2 - id field from tables like format..portalbox...
	table - name of the table"""

	try:
	res1 = run_sql("SELECT score FROM collection_field_fieldvalue WHERE id_collection=%s and id_field=%s" % (colID, id_1))
	res2 = run_sql("SELECT score FROM collection_field_fieldvalue WHERE id_collection=%s and id_field=%s" % (colID, id_2))
	res = run_sql("UPDATE collection_field_fieldvalue SET score=%s WHERE id_collection=%s and id_field=%s" % (res2[0][0], colID, id_1))
	res = run_sql("UPDATE collection_field_fieldvalue SET score=%s WHERE id_collection=%s and id_field=%s" % (res1[0][0], colID, id_2))
	return "true"
	except StandardError, e:
	return ()

	def switch_fld_value_score(colID, id_1, fldvID_1, fldvID_2):
	"""Switch the scores of two field_value
	colID - collection the id_1 or id_2 is connected to
	id_1/id_2 - id field from tables like format..portalbox...
	table - name of the table"""

	try:
	res1 = run_sql("SELECT score_fieldvalue FROM collection_field_fieldvalue WHERE id_collection=%s and id_field=%s and id_fieldvalue=%s" % (colID, id_1, fldvID_1))
	res2 = run_sql("SELECT score_fieldvalue FROM collection_field_fieldvalue WHERE id_collection=%s and id_field=%s and id_fieldvalue=%s" % (colID, id_1, fldvID_2))
	res = run_sql("UPDATE collection_field_fieldvalue SET score_fieldvalue=%s WHERE id_collection=%s and id_field=%s and id_fieldvalue=%s" % (res2[0][0], colID, id_1, fldvID_1))
	res = run_sql("UPDATE collection_field_fieldvalue SET score_fieldvalue=%s WHERE id_collection=%s and id_field=%s and id_fieldvalue=%s" % (res1[0][0], colID, id_1, fldvID_2))
	return "true"
	except StandardError, e:
	return ()

	def switch_pbx_score(colID, id_1, id_2, sel_ln):
	"""Switch the scores of id_1 and id_2 in the table given by the argument.
	colID - collection the id_1 or id_2 is connected to
	id_1/id_2 - id field from tables like format..portalbox...
	table - name of the table"""

	try:
	res1 = run_sql("SELECT score FROM collection_portalbox WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (colID, id_1, sel_ln))
	res2 = run_sql("SELECT score FROM collection_portalbox WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (colID, id_2, sel_ln))
	res = run_sql("UPDATE collection_portalbox SET score=%s WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (res2[0][0], colID, id_1, sel_ln))
	res = run_sql("UPDATE collection_portalbox SET score=%s WHERE id_collection=%s and id_portalbox=%s and ln='%s'" % (res1[0][0], colID, id_2, sel_ln))
	return "true"
	except StandardError, e:
	return ()

	def switch_score(colID, id_1, id_2, table):
	"""Switch the scores of id_1 and id_2 in the table given by the argument.
	colID - collection the id_1 or id_2 is connected to
	id_1/id_2 - id field from tables like format..portalbox...
	table - name of the table"""

	try:
	res1 = run_sql("SELECT score FROM collection_%s WHERE id_collection=%s and id_%s=%s" % (table, colID, table, id_1))
	res2 = run_sql("SELECT score FROM collection_%s WHERE id_collection=%s and id_%s=%s" % (table, colID, table, id_2))
	res = run_sql("UPDATE collection_%s SET score=%s WHERE id_collection=%s and id_%s=%s" % (table, res2[0][0], colID, table, id_1))
	res = run_sql("UPDATE collection_%s SET score=%s WHERE id_collection=%s and id_%s=%s" % (table, res1[0][0], colID, table, id_2))
	return "true"
	except StandardError, e:
	return ()

websearchadminlib.py.wmlNo OneTemporaryActions

File Metadata

websearchadminlib.py.wmlView Options

Event Timeline

websearchadminlib.py.wml
No OneTemporary
Actions

websearchadminlib.py.wml
View Options