Bugzilla – Attachment 10087 Details for
Bug 5981
OPAC: Add limits to search history
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 5981 - OPAC: Add limits to search history
Bug-5981---OPAC-Add-limits-to-search-history.patch (text/plain), 2.72 KB, created by
Alex Arnaud
on 2012-06-10 11:15:20 UTC
(
hide
)
Description:
Bug 5981 - OPAC: Add limits to search history
Filename:
MIME Type:
Creator:
Alex Arnaud
Created:
2012-06-10 11:15:20 UTC
Size:
2.72 KB
patch
obsolete
>From fc70264c5349665dc48e120fc25c53249f6fe915 Mon Sep 17 00:00:00 2001 >From: Alex Arnaud <alex.arnaud@biblibre.com> >Date: Sun, 10 Jun 2012 13:14:24 +0200 >Subject: [PATCH] Bug 5981 - OPAC: Add limits to search history > >--- > installer/data/mysql/kohastructure.sql | 2 +- > installer/data/mysql/updatedatabase.pl | 7 +++++++ > kohaversion.pl | 2 +- > opac/opac-search.pl | 6 ++++++ > 4 files changed, 15 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 54498c3..6382999 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1746,7 +1746,7 @@ CREATE TABLE IF NOT EXISTS `search_history` ( > `userid` int(11) NOT NULL, > `sessionid` varchar(32) NOT NULL, > `query_desc` varchar(255) NOT NULL, >- `query_cgi` varchar(255) NOT NULL, >+ `query_cgi` text NOT NULL, > `total` int(11) NOT NULL, > `time` timestamp NOT NULL default CURRENT_TIMESTAMP, > KEY `userid` (`userid`), >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 9cd4b14..4bc1123 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5336,6 +5336,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "XXX"; >+if (C4::Context->preference("Version") < TransformToNum($DBversion)) { >+ $dbh->do("ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL"); >+ print "Upgrade to $DBversion done (Change search_history.query_cgi type to text. bug 5981)\n"; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >diff --git a/kohaversion.pl b/kohaversion.pl >index 3fcef22..5f042f2 100644 >--- a/kohaversion.pl >+++ b/kohaversion.pl >@@ -16,7 +16,7 @@ the kohaversion is divided in 4 parts : > use strict; > > sub kohaversion { >- our $VERSION = '3.09.00.012'; >+ our $VERSION = '3.09.00.013'; > # version needs to be set this way > # so that it can be picked up by Makefile.PL > # during install >diff --git a/opac/opac-search.pl b/opac/opac-search.pl >index 5f3ad86..0400162 100755 >--- a/opac/opac-search.pl >+++ b/opac/opac-search.pl >@@ -589,6 +589,12 @@ for (my $i=0;$i<@servers;$i++) { > } > > # Adding the new search if needed >+ my $path_info = $cgi->url(-path_info=>1); >+ $query_cgi = $cgi->url(-query=>1); >+ $query_cgi =~ s/^$path_info\?//; >+ $query_cgi =~ s/;/&/g; >+ $query_desc .= ", $limit_desc"; >+ > if (!$borrowernumber || $borrowernumber eq '') { > # To a cookie (the user is not logged in) > if (($params->{'offset'}||'') eq '') { >-- >1.7.4.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5981
:
3485
|
3657
|
4798
|
4860
|
5277
|
5422
|
5659
|
10087
|
10316
|
10632