View | Details | Raw Unified | Return to bug 23997
Collapse All | Expand All

(-)a/cataloguing/z3950_auth_search.pl (-1 / +1 lines)
Lines 68-74 $template->param( Link Here
68
);
68
);
69
69
70
if ( $op ne "do_search" ) {
70
if ( $op ne "do_search" ) {
71
    my $sth = $dbh->prepare("SELECT id,host,servername,checked FROM z3950servers WHERE recordtype = 'authority' ORDER BY rank, servername");
71
    my $sth = $dbh->prepare("SELECT id,host,servername,checked FROM z3950servers WHERE recordtype = 'authority' ORDER BY `rank`, servername");
72
    $sth->execute();
72
    $sth->execute();
73
    my $serverloop = $sth->fetchall_arrayref( {} );
73
    my $serverloop = $sth->fetchall_arrayref( {} );
74
    $template->param(
74
    $template->param(
(-)a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql (-1 / +1 lines)
Lines 1-5 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
2
(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
(-)a/installer/data/mysql/en/optional/sample_z3950_servers.sql (-1 / +1 lines)
Lines 1-5 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
2
(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
(-)a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql (-1 / +1 lines)
Lines 1-5 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
2
(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
(-)a/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql (-1 / +1 lines)
Lines 1-5 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
2
(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
3
('lx2.loc.gov',210,'LCDB','','','Bibliothèque du congrès',1,1,'USMARC','utf8','biblio'),
3
('lx2.loc.gov',210,'LCDB','','','Bibliothèque du congrès',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'NAF','','','Bibliothèque du congrès NOMS',1,1,'USMARC','utf8','authority'),
4
('lx2.loc.gov',210,'NAF','','','Bibliothèque du congrès NOMS',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','Bibliothèque du congrès SUJETS',1,2,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','Bibliothèque du congrès SUJETS',1,2,'USMARC','utf8','authority'),
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql (-1 / +1 lines)
Lines 1-4 Link Here
1
INSERT INTO z3950servers (host, port, db, userid, password, servername, id, checked, rank, syntax, timeout, servertype, encoding) VALUES
1
INSERT INTO z3950servers (host, port, db, userid, password, servername, id, checked, `rank`, syntax, timeout, servertype, encoding) VALUES
2
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,0,0,'USMARC',0,'zed','utf8'),
2
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,0,0,'USMARC',0,'zed','utf8'),
3
('z3950.bibsys.no',2100,'BIBSYS','','','BIBSYS',12,1,1,'NORMARC',0,'zed','ISO_8859-1'),
3
('z3950.bibsys.no',2100,'BIBSYS','','','BIBSYS',12,1,1,'NORMARC',0,'zed','ISO_8859-1'),
4
('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,'zed','ISO_8859-1'),
4
('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,'zed','ISO_8859-1'),
(-)a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql (-2 / +1 lines)
Lines 1-5 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
2
(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
3
('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'),
3
('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'),
4
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
5
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
6
- 

Return to bug 23997