refdb-cvs Mailing List for RefDB (Page 49)
Status: Beta
Brought to you by:
mhoenicka
Menu
▾
▴
refdb-cvs — All cvs checkins go to this list
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(47) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(88) |
Feb
(50) |
Mar
(36) |
Apr
(9) |
May
(30) |
Jun
(30) |
Jul
(22) |
Aug
(16) |
Sep
(42) |
Oct
(18) |
Nov
(29) |
Dec
(23) |
| 2005 |
Jan
(18) |
Feb
(28) |
Mar
(21) |
Apr
(35) |
May
(62) |
Jun
(22) |
Jul
(5) |
Aug
(40) |
Sep
(98) |
Oct
(81) |
Nov
(51) |
Dec
(62) |
| 2006 |
Jan
(46) |
Feb
(36) |
Mar
(8) |
Apr
(16) |
May
(14) |
Jun
(16) |
Jul
(47) |
Aug
(60) |
Sep
(34) |
Oct
(16) |
Nov
(46) |
Dec
(11) |
| 2007 |
Jan
(16) |
Feb
(13) |
Mar
(58) |
Apr
(32) |
May
(4) |
Jun
(8) |
Jul
(31) |
Aug
(46) |
Sep
(22) |
Oct
(30) |
Nov
(58) |
Dec
(15) |
| 2008 |
Jan
(8) |
Feb
(8) |
Mar
(2) |
Apr
(6) |
May
(3) |
Jun
(2) |
Jul
(1) |
Aug
|
Sep
|
Oct
(6) |
Nov
(3) |
Dec
(5) |
| 2009 |
Jan
(1) |
Feb
(20) |
Mar
(8) |
Apr
(5) |
May
(8) |
Jun
(3) |
Jul
(6) |
Aug
(4) |
Sep
(7) |
Oct
(8) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(1) |
Feb
(4) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2011 |
Jan
(5) |
Feb
(5) |
Mar
(13) |
Apr
(3) |
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
(1) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
(5) |
Nov
|
Dec
(3) |
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(13) |
| 2014 |
Jan
(2) |
Feb
(2) |
Mar
(2) |
Apr
(4) |
May
(1) |
Jun
(1) |
Jul
|
Aug
(6) |
Sep
(3) |
Oct
|
Nov
(2) |
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2022 |
Jan
(9) |
Feb
(16) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Markus H. <mho...@us...> - 2005-09-07 23:49:50
|
Update of /cvsroot/refdb/refdb/styles In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26136/styles Modified Files: Tag: Release_0_9_5_stable Eur.J.Pharmacol.xml J.Biol.Chem.xml Log Message: updated to new dtd version Index: Eur.J.Pharmacol.xml =================================================================== RCS file: /cvsroot/refdb/refdb/styles/Eur.J.Pharmacol.xml,v retrieving revision 1.7.2.2 retrieving revision 1.7.2.3 diff -u -U2 -r1.7.2.2 -r1.7.2.3 --- Eur.J.Pharmacol.xml 29 Jan 2005 21:33:52 -0000 1.7.2.2 +++ Eur.J.Pharmacol.xml 7 Sep 2005 23:49:39 -0000 1.7.2.3 @@ -1,4 +1,4 @@ <?xml version="1.0"?> -<!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.3//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.3/citestylex.dtd"> +<!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.4//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.4/citestylex.dtd"> <STYLESET> <CITESTYLE> @@ -421,6 +421,6 @@ <FOLLOWING>, </FOLLOWING> </TITLE> - <URL> - </URL> + <LINK> + </LINK> </PUBTYPE> Index: J.Biol.Chem.xml =================================================================== RCS file: /cvsroot/refdb/refdb/styles/J.Biol.Chem.xml,v retrieving revision 1.8.2.2 retrieving revision 1.8.2.3 diff -u -U2 -r1.8.2.2 -r1.8.2.3 --- J.Biol.Chem.xml 29 Jan 2005 21:33:52 -0000 1.8.2.2 +++ J.Biol.Chem.xml 7 Sep 2005 23:49:39 -0000 1.8.2.3 @@ -1,4 +1,4 @@ <?xml version="1.0"?> -<!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.3//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.3/citestylex.dtd"> +<!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.4//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.4/citestylex.dtd"> <STYLESET> <CITESTYLE> @@ -437,7 +437,7 @@ <FOLLOWING>) </FOLLOWING> </PUBDATE> - <URL> + <LINK ROLE="0"> <PRECEEDING> </PRECEEDING> - </URL> + </LINK> </PUBTYPE> |
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24526/src Modified Files: Tag: Release_0_9_5_stable backend-bibtex.c backend-dbib.c backend-dbib.h backend-html.c backend-ris.c backend-scrn.c backend.c backend.h noteshandler.c refdbd.h.in refdbdbib.c refdbdnote.c refdbdref.c risdata.c risdb.c risdb.h risxhandler.c xmlhandler.c xmlout.c Log Message: implemented multiple url handling Index: backend-bibtex.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-bibtex.c,v retrieving revision 1.16.2.4 retrieving revision 1.16.2.5 diff -u -U2 -r1.16.2.4 -r1.16.2.5 --- backend-bibtex.c 29 Jul 2005 21:15:19 -0000 1.16.2.4 +++ backend-bibtex.c 7 Sep 2005 23:45:00 -0000 1.16.2.5 @@ -927,5 +927,5 @@ /* sprintf(sql_command, "SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_citekey, t_refdb.refdb_type, t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage, t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume, t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city, t_refdb.refdb_publisher, t_refdb.refdb_title_series, t_refdb.refdb_address, t_refdb.refdb_url, t_refdb.refdb_issn, t_refdb.refdb_periodical_id, t_refdb.refdb_pyother_info, t_refdb.refdb_secyear, t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2, t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5, t_refdb.refdb_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3 FROM t_refdb WHERE t_refdb.refdb_id=%s", idstring); */ - sprintf(sql_command, "SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_citekey, t_refdb.refdb_type, t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage, t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume, t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city, t_refdb.refdb_publisher, t_refdb.refdb_title_series, t_refdb.refdb_address, t_refdb.refdb_url, t_refdb.refdb_issn, t_refdb.refdb_periodical_id, t_refdb.refdb_pyother_info, t_refdb.refdb_secyear, t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2, t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5, t_refdb.refdb_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3 FROM t_refdb WHERE t_refdb.refdb_citekey='%s'", idstring); + sprintf(sql_command, "SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_citekey, t_refdb.refdb_type, t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage, t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume, t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city, t_refdb.refdb_publisher, t_refdb.refdb_title_series, t_refdb.refdb_address, t_refdb.refdb_issn, t_refdb.refdb_periodical_id, t_refdb.refdb_pyother_info, t_refdb.refdb_secyear, t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2, t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5, t_refdb.refdb_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3 FROM t_refdb WHERE t_refdb.refdb_citekey='%s'", idstring); if (!strcmp(my_dbi_conn_get_cap(conn, "multiple_db"), "t")) { Index: backend-dbib.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-dbib.c,v retrieving revision 1.28.2.7 retrieving revision 1.28.2.8 diff -u -U2 -r1.28.2.7 -r1.28.2.8 --- backend-dbib.c 10 Aug 2005 19:45:59 -0000 1.28.2.7 +++ backend-dbib.c 7 Sep 2005 23:45:00 -0000 1.28.2.8 @@ -560,26 +560,26 @@ 12 refdb_title_series T3 - 13 refdb_address AD - - 14 refdb_url UR - - 15 refdb_issn SN - - 16 refdb_periodical_id JO - (indirect) - 17 refdb_pyother_info PY - (partial) - 18 refdb_secyear Y2 - (partial) - 19 refdb_secother_info Y2 - (partial) - 20 refdb_user1 U1 - - 21 refdb_user2 U2 - - 22 refdb_user3 U3 - - 23 refdb_user4 U4 - - 24 refdb_user5 U5 - - 25 refdb_misc1 M1 - - 26 refdb_misc2 M2 - - 27 refdb_misc3 M3 - + deleted 14 refdb_url UR - + 14 refdb_issn SN - + 15 refdb_periodical_id JO - (indirect) + 16 refdb_pyother_info PY - (partial) + 17 refdb_secyear Y2 - (partial) + 18 refdb_secother_info Y2 - (partial) + 19 refdb_user1 U1 - + 20 refdb_user2 U2 - + 21 refdb_user3 U3 - + 22 refdb_user4 U4 - + 23 refdb_user5 U5 - + 24 refdb_misc1 M1 - + 25 refdb_misc2 M2 - + 26 refdb_misc3 M3 - */ if (n_multiple_db) { - sprintf(sql_command, "SELECT %s.t_refdb.refdb_id, %s.t_refdb.refdb_type, %s.t_refdb.refdb_pubyear, %s.t_refdb.refdb_startpage, %s.t_refdb.refdb_endpage, %s.t_refdb.refdb_abstract, %s.t_refdb.refdb_title, %s.t_refdb.refdb_volume, %s.t_refdb.refdb_issue, %s.t_refdb.refdb_booktitle, %s.t_refdb.refdb_city, %s.t_refdb.refdb_publisher, %s.t_refdb.refdb_title_series, %s.t_refdb.refdb_address, %s.t_refdb.refdb_url, %s.t_refdb.refdb_issn, %s.t_refdb.refdb_periodical_id, %s.t_refdb.refdb_pyother_info, %s.t_refdb.refdb_secyear, %s.t_refdb.refdb_secother_info, %s.t_refdb.refdb_user1, %s.t_refdb.refdb_user2, %s.t_refdb.refdb_user3, %s.t_refdb.refdb_user4, %s.t_refdb.refdb_user5, %s.t_refdb.refdb_misc1, %s.t_refdb.refdb_misc2, %s.t_refdb.refdb_misc3 FROM %s.t_refdb WHERE %s.t_refdb.refdb_id="ULLSPEC, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, (unsigned long long)n_orig_id); + sprintf(sql_command, "SELECT %s.t_refdb.refdb_id, %s.t_refdb.refdb_type, %s.t_refdb.refdb_pubyear, %s.t_refdb.refdb_startpage, %s.t_refdb.refdb_endpage, %s.t_refdb.refdb_abstract, %s.t_refdb.refdb_title, %s.t_refdb.refdb_volume, %s.t_refdb.refdb_issue, %s.t_refdb.refdb_booktitle, %s.t_refdb.refdb_city, %s.t_refdb.refdb_publisher, %s.t_refdb.refdb_title_series, %s.t_refdb.refdb_address, %s.t_refdb.refdb_issn, %s.t_refdb.refdb_periodical_id, %s.t_refdb.refdb_pyother_info, %s.t_refdb.refdb_secyear, %s.t_refdb.refdb_secother_info, %s.t_refdb.refdb_user1, %s.t_refdb.refdb_user2, %s.t_refdb.refdb_user3, %s.t_refdb.refdb_user4, %s.t_refdb.refdb_user5, %s.t_refdb.refdb_misc1, %s.t_refdb.refdb_misc2, %s.t_refdb.refdb_misc3 FROM %s.t_refdb WHERE %s.t_refdb.refdb_id="ULLSPEC, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, item_dbname, (unsigned long long)n_orig_id); ptr_bibconns->conn_source = ptr_bibconns->conn; /* make sure */ } else { - sprintf(sql_command, "SELECT refdb_id, refdb_type, refdb_pubyear, refdb_startpage, refdb_endpage, refdb_abstract, refdb_title, refdb_volume, refdb_issue, refdb_booktitle, refdb_city, refdb_publisher, refdb_title_series, refdb_address, refdb_url, refdb_issn, refdb_periodical_id, refdb_pyother_info, refdb_secyear, refdb_secother_info, refdb_user1, refdb_user2, refdb_user3, refdb_user4, refdb_user5, refdb_misc1, refdb_misc2, refdb_misc3 FROM t_refdb WHERE refdb_id="ULLSPEC, (unsigned long long)n_orig_id); + sprintf(sql_command, "SELECT refdb_id, refdb_type, refdb_pubyear, refdb_startpage, refdb_endpage, refdb_abstract, refdb_title, refdb_volume, refdb_issue, refdb_booktitle, refdb_city, refdb_publisher, refdb_title_series, refdb_address, refdb_issn, refdb_periodical_id, refdb_pyother_info, refdb_secyear, refdb_secother_info, refdb_user1, refdb_user2, refdb_user3, refdb_user4, refdb_user5, refdb_misc1, refdb_misc2, refdb_misc3 FROM t_refdb WHERE refdb_id="ULLSPEC, (unsigned long long)n_orig_id); /* need a connection to item_dbname */ ptr_bibconns->conn_source = connect_to_db(ptr_clrequest, item_dbname, 0); @@ -1791,38 +1791,38 @@ } /*---------------------------------------------------------------*/ - else if (strcmp(item_type, "URL") == 0) { - if (!n_intext) { - if (strcmp(pubtype, "CHAP") == 0 || strcmp(pubtype, "BOOK") == 0) { - strcpy(mset_string, "book"); - } - else { - strcpy(mset_string, "journal"); - } - } - else { - strcpy(mset_string, "intext"); - } - if ((new_ref_buffer = set_mset(current_mset, mset_string, &ref_buffer, &nref_buffer_len)) == NULL) { - error = 801; - break; - } - - ref_buffer = new_ref_buffer; - - if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_URL, URLPRECEEDING, URLFOLLOWING, "ulink")) == NULL) { - error = 822; - break; - } - - if (ref_buffer[0]) { - if ((new_ref = mstrcat(*ptr_ref, ref_buffer, ptr_ref_len, 0)) == NULL) { - error = 801; - break; - } - - *ptr_ref = new_ref; - } - ref_buffer[0] = '\0'; - } +/* else if (strcmp(item_type, "URL") == 0) { */ +/* if (!n_intext) { */ +/* if (strcmp(pubtype, "CHAP") == 0 || strcmp(pubtype, "BOOK") == 0) { */ +/* strcpy(mset_string, "book"); */ +/* } */ +/* else { */ +/* strcpy(mset_string, "journal"); */ +/* } */ +/* } */ +/* else { */ +/* strcpy(mset_string, "intext"); */ +/* } */ +/* if ((new_ref_buffer = set_mset(current_mset, mset_string, &ref_buffer, &nref_buffer_len)) == NULL) { */ +/* error = 801; */ +/* break; */ +/* } */ + +/* ref_buffer = new_ref_buffer; */ + +/* if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_LINK0, LINK0PRECEEDING, LINK0FOLLOWING, "ulink")) == NULL) { */ +/* error = 822; */ +/* break; */ +/* } */ + +/* if (ref_buffer[0]) { */ +/* if ((new_ref = mstrcat(*ptr_ref, ref_buffer, ptr_ref_len, 0)) == NULL) { */ +/* error = 801; */ +/* break; */ +/* } */ + +/* *ptr_ref = new_ref; */ +/* } */ +/* ref_buffer[0] = '\0'; */ +/* } */ /*---------------------------------------------------------------*/ else if (strncmp(item_type, "USERDEF", 7) == 0) { @@ -1955,6 +1955,12 @@ ref_buffer = new_ref_buffer; - if (item_type[4] == '1') { - if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_LINK1, LINK1PRECEEDING, LINK1FOLLOWING, "link1")) == NULL) { + if (item_type[4] == '0') { + if ((new_ref_buffer = format_ulink(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, 0 /*LINK0*/, n_intext, LINK0PRECEEDING, LINK0FOLLOWING)) == NULL) { + error = 831; + break; + } + } + else if (item_type[4] == '1') { + if ((new_ref_buffer = format_ulink(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, 1 /*LINK1*/, n_intext, LINK1PRECEEDING, LINK1FOLLOWING)) == NULL) { error = 831; break; @@ -1962,5 +1968,5 @@ } else if (item_type[4] == '2') { - if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_LINK2, LINK2PRECEEDING, LINK2FOLLOWING, "link2")) == NULL) { + if ((new_ref_buffer = format_ulink(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, 2 /*LINK2*/, n_intext, LINK2PRECEEDING, LINK2FOLLOWING)) == NULL) { error = 832; break; @@ -1968,5 +1974,5 @@ } else if (item_type[4] == '3') { - if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_LINK3, LINK3PRECEEDING, LINK3FOLLOWING, "link3")) == NULL) { + if ((new_ref_buffer = format_ulink(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, 3 /*LINK3*/, n_intext, LINK3PRECEEDING, LINK3FOLLOWING)) == NULL) { error = 833; break; @@ -1974,5 +1980,5 @@ } else if (item_type[4] == '4') { - if ((new_ref_buffer = format_simple(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, n_intext, REFDB_LINK4, LINK4PRECEEDING, LINK4FOLLOWING, "link4")) == NULL) { + if ((new_ref_buffer = format_ulink(&ref_buffer, &nref_buffer_len, ptr_bibconns, dbires, dbi_style_res, 4 /*LINK4*/, n_intext, LINK4PRECEEDING, LINK4FOLLOWING)) == NULL) { error = 834; break; Index: backend-dbib.h =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-dbib.h,v retrieving revision 1.9.2.2 retrieving revision 1.9.2.3 diff -u -U2 -r1.9.2.2 -r1.9.2.3 --- backend-dbib.h 10 Aug 2005 19:45:59 -0000 1.9.2.2 +++ backend-dbib.h 7 Sep 2005 23:45:00 -0000 1.9.2.3 @@ -41,5 +41,5 @@ char* format_notes(char** ptr_ref, size_t* ptr_ref_len, struct BIBCONNS* ptr_bibconns, dbi_result dbires, dbi_result dbires_ref, const char* username); - +char* format_ulink(char** ptr_ref, size_t* ptr_ref_len, struct BIBCONNS* ptr_bibconns, dbi_result dbires, dbi_result dbires_ref, int type, int n_intext, int n_preceeding_index, int n_following_index); Index: backend-html.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-html.c,v retrieving revision 1.27.2.3 retrieving revision 1.27.2.4 diff -u -U2 -r1.27.2.3 -r1.27.2.4 --- backend-html.c 28 May 2005 20:07:47 -0000 1.27.2.3 +++ backend-html.c 7 Sep 2005 23:45:00 -0000 1.27.2.4 @@ -1368,57 +1368,79 @@ if (strstr((ptr_rendinfo->ptr_biblio_info)->format_string, "UR") != NULL || strstr((ptr_rendinfo->ptr_biblio_info)->format_string, "ALL") != NULL) { - item = get_refdb_url_copy(ptr_rendinfo->dbires); - if (item != NULL) { - if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "<p class='ur'><a href=\"", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - return 801; - } - else { - *(ptr_rendinfo->ptr_ref) = new_ref; - } + int i; + char *entitize_string; - if (sgml_entitize((char**)&item, NULL) == NULL) { - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - free((char*)item); - return 801; - } + /* loop over all link types */ + for (i=0; i<5;i++) { + dbires = request_ulinks(conn, my_dbi_result_get_idval(ptr_rendinfo->dbires, "refdb_id"), 0 /* ref entry */, i /* link type */); + if (dbires == NULL) { + return 234; + } + + while ((item = get_ulink(dbires)) != NULL) { + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "<p class='ur'><a href=\"", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + + if ((entitize_string = strdup(item)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + return 801; + } + + if (sgml_entitize(&entitize_string, NULL) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + free(entitize_string); + return 801; + } - if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), (char*)item, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { - free((char*)item); - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - return 801; - } - else { - *(ptr_rendinfo->ptr_ref) = new_ref; - } - - if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "\">", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - free((char*)item); - return 801; - } - else { - *(ptr_rendinfo->ptr_ref) = new_ref; - } + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), entitize_string, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + free(entitize_string); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "\">", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + free(entitize_string); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), entitize_string, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + free(entitize_string); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } - if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), (char*)item, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - free((char*)item); - return 801; - } - else { - *(ptr_rendinfo->ptr_ref) = new_ref; - } - - free((char*)item); + free(entitize_string); + clean_request(dbires); - if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "</a></p>\n", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { - LOG_PRINT(LOG_CRIT, get_status_msg(801)); - return 801; - } - else { - *(ptr_rendinfo->ptr_ref) = new_ref; - } - } + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), "</a></p>\n", ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + } /* end while */ + } /* end for */ } Index: backend-ris.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-ris.c,v retrieving revision 1.14.2.4 retrieving revision 1.14.2.5 diff -u -U2 -r1.14.2.4 -r1.14.2.5 --- backend-ris.c 29 May 2005 16:54:21 -0000 1.14.2.4 +++ backend-ris.c 7 Sep 2005 23:45:01 -0000 1.14.2.5 @@ -458,12 +458,48 @@ /*----------------------------------------------------------------*/ - /* URL */ - if ((item = get_refdb_url_copy(ptr_rendinfo->dbires)) != NULL) { - if (print_field_ris(item, ptr_rendinfo, "\nUR - ") == NULL) { - free((char*)item); - return 801; + /* URL, L1 through L4 */ + + /* loop over all link types */ + for (i=0; i<5;i++) { + dbires = request_ulinks(conn, my_dbi_result_get_idval(ptr_rendinfo->dbires, "refdb_id"), 0 /* ref entry */, i /* link type */); + if (dbires == NULL) { + return 234; } - free((char*)item); - } + + while ((item = get_ulink(dbires)) != NULL) { + if (i == 0) { + if (print_field_ris(item, ptr_rendinfo, "\nUR - ") == NULL) { + clean_request(dbires); + return 801; + } + } + else if (i == 1) { + if (print_field_ris(item, ptr_rendinfo, "\nL1 - ") == NULL) { + clean_request(dbires); + return 801; + } + } + else if (i == 2) { + if (print_field_ris(item, ptr_rendinfo, "\nL2 - ") == NULL) { + clean_request(dbires); + return 801; + } + } + else if (i == 3) { + if (print_field_ris(item, ptr_rendinfo, "\nL3 - ") == NULL) { + clean_request(dbires); + return 801; + } + } + else if (i == 4) { + if (print_field_ris(item, ptr_rendinfo, "\nL4 - ") == NULL) { + clean_request(dbires); + return 801; + } + } + } + + clean_request(dbires); + } /* end for */ /*----------------------------------------------------------------*/ Index: backend-scrn.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend-scrn.c,v retrieving revision 1.17.2.2 retrieving revision 1.17.2.3 diff -u -U2 -r1.17.2.2 -r1.17.2.3 --- backend-scrn.c 17 Apr 2005 00:09:07 -0000 1.17.2.2 +++ backend-scrn.c 7 Sep 2005 23:45:01 -0000 1.17.2.3 @@ -698,14 +698,55 @@ /*----------------------------------------------------------------*/ - /* URL */ + /* URL, L1 through L4 */ if (strstr((ptr_rendinfo->ptr_biblio_info)->format_string, "UR") != NULL || strstr((ptr_rendinfo->ptr_biblio_info)->format_string, "ALL") != NULL) { - if ((item = get_refdb_url_copy(ptr_rendinfo->dbires)) != NULL) { - if (print_field_scrn(item, ptr_rendinfo, "\nURL: ") == NULL) { - free(item); - return 801; + int i; + char link_tag[12]; + + /* loop over all link types */ + for (i=0; i<5;i++) { + if (!i) { + strcpy(link_tag, "\nURL: "); } - free(item); - } + else if (i == 1) { + strcpy(link_tag, "\nPDF: "); + } + else if (i == 2) { + strcpy(link_tag, "\nFULLTEXT: "); + } + else if (i == 3) { + strcpy(link_tag, "\nRELATED: "); + } + else if (i == 4) { + strcpy(link_tag, "\nIMAGE: "); + } + + dbires = request_ulinks(conn, my_dbi_result_get_idval(ptr_rendinfo->dbires, "refdb_id"), 0 /* ref entry */, i /* link type */); + if (dbires == NULL) { + return 234; + } + + while ((citem = get_ulink(dbires)) != NULL) { + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), link_tag, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + + if ((new_ref = mstrcat(*(ptr_rendinfo->ptr_ref), (char*)citem, ptr_rendinfo->ptr_ref_len, 0)) == NULL) { + LOG_PRINT(LOG_CRIT, get_status_msg(801)); + clean_request(dbires); + return 801; + } + else { + *(ptr_rendinfo->ptr_ref) = new_ref; + } + + clean_request(dbires); + } /* end while */ + } /* end for */ } Index: backend.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/backend.c,v retrieving revision 1.27.2.5 retrieving revision 1.27.2.6 diff -u -U2 -r1.27.2.5 -r1.27.2.6 --- backend.c 8 Aug 2005 00:08:29 -0000 1.27.2.5 +++ backend.c 7 Sep 2005 23:45:01 -0000 1.27.2.6 @@ -1044,7 +1044,7 @@ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/ -char* get_refdb_url_copy(dbi_result dbires) { - return my_dbi_result_get_string_copy(dbires, "refdb_url"); -} +/* char* get_refdb_url_copy(dbi_result dbires) { */ +/* return my_dbi_result_get_string_copy(dbires, "refdb_url"); */ +/* } */ /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ @@ -1950,5 +1950,5 @@ get_keyword(): retrieves a keyword - char* get_author returns a pointer to a string containing the + char* get_keyword returns a pointer to a string containing the keyword @@ -1975,4 +1975,70 @@ /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + request_ulinks(): prepares the retrieval of ulinks + + dbi_result request_ulinks returns a pointer to a dbi result structure + which contains the ulinks + + dbi_result dbires database query result, pointing to the current + dataset (used only to retrieve the connection) + + int mode 0 = reference entry 1 = note entry + + int type 0 = URL, 1 = PDF, 2 = FULLTEXT 3 = RELATED 4 = IMAGE + + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/ +dbi_result request_ulinks(dbi_conn conn, unsigned long long n_id, int mode, int type) { + char* sql_command; + char keymode[2][10] = {"REFERENCE", "NOTE"}; + char keytype[5][10] = {"URL", "PDF", "FULLTEXT", "RELATED", "IMAGE"}; + int error; + dbi_result dbires; + + sql_command = malloc(512); + + if (sql_command == NULL) { + return NULL; + } + + sprintf(sql_command, "SELECT t_link.link_url FROM t_link, t_xlink WHERE t_link.link_id=t_xlink.link_id AND t_xlink.xlink_type=\'%s\' AND t_xlink.xlink_source=\'%s\' AND t_xlink.xref_id="ULLSPEC, keytype[mode], keymode[mode], (unsigned long long)n_id); + + LOG_PRINT(LOG_DEBUG, sql_command); + dbires = dbi_conn_query(conn, sql_command); + free(sql_command); + if (!dbires) { + return NULL; + } + + return dbires; +} + +/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + get_ulink(): retrieves an ulink + + char* get_ulink returns a pointer to a string containing the + ulink + + dbi_result dbires database query result, pointing to the current + dataset + + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/ +const char* get_ulink(dbi_result dbires) { + const char* result; + + if (dbi_result_next_row(dbires)) { + result = my_dbi_result_get_string_idx(dbires, 1); + if (dbi_conn_error_flag(dbi_result_get_conn(dbires))) { + return NULL; + } + else { + return result; + } + } + else { + return NULL; + } +} + +/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ request_users(): prepares the retrieval of users of the currently selected database @@ -2646,57 +2712,57 @@ 181 ADDRESSFOLLOWING 182 ADDRESSSTYLE - 183 URLPRECEEDING - 184 URLFOLLOWING - 185 URLSTYLE - 186 USERDEF1PRECEEDING - 187 USERDEF1FOLLOWING - 188 USERDEF1STYLE - 189 USERDEF2PRECEEDING - 190 USERDEF2FOLLOWING - 191 USERDEF2STYLE - 192 USERDEF3PRECEEDING - 193 USERDEF3FOLLOWING - 194 USERDEF3STYLE - 195 USERDEF4PRECEEDING - 196 USERDEF4FOLLOWING - 197 USERDEF4STYLE - 198 USERDEF5PRECEEDING - 199 USERDEF5FOLLOWING - 200 USERDEF5STYLE - 201 MISC1PRECEEDING - 202 MISC1FOLLOWING - 203 MISC1STYLE - 204 MISC2PRECEEDING - 205 MISC2FOLLOWING - 206 MISC2STYLE - 207 MISC3PRECEEDING - 208 MISC3FOLLOWING - 209 MISC3STYLE - 210 NOTESPRECEEDING - 211 NOTESFOLLOWING - 212 NOTESSTYLE - 213 ABSTRACTPRECEEDING - 214 ABSTRACTFOLLOWING - 215 ABSTRACTSTYLE - 216 LINK1PRECEEDING - 217 LINK1FOLLOWING - 218 LINK1STYLE - 219 LINK2PRECEEDING - 220 LINK2FOLLOWING - 221 LINK2STYLE - 222 LINK3PRECEEDING - 223 LINK3FOLLOWING - 224 LINK3STYLE - 225 LINK4PRECEEDING - 226 LINK4FOLLOWING - 227 LINK4STYLE + deleted 183 URLPRECEEDING + deleted 184 URLFOLLOWING + deleted 185 URLSTYLE + 183 USERDEF1PRECEEDING + 184 USERDEF1FOLLOWING + 185 USERDEF1STYLE + 186 USERDEF2PRECEEDING + 187 USERDEF2FOLLOWING + 188 USERDEF2STYLE + 189 USERDEF3PRECEEDING + 190 USERDEF3FOLLOWING + 191 USERDEF3STYLE + 192 USERDEF4PRECEEDING + 193 USERDEF4FOLLOWING + 194 USERDEF4STYLE + 195 USERDEF5PRECEEDING + 196 USERDEF5FOLLOWING + 197 USERDEF5STYLE + 198 MISC1PRECEEDING + 199 MISC1FOLLOWING + 200 MISC1STYLE + 201 MISC2PRECEEDING + 202 MISC2FOLLOWING + 203 MISC2STYLE + 204 MISC3PRECEEDING + 205 MISC3FOLLOWING + 206 MISC3STYLE + 207 NOTESPRECEEDING + 208 NOTESFOLLOWING + 209 NOTESSTYLE + 210 ABSTRACTPRECEEDING + 211 ABSTRACTFOLLOWING + 212 ABSTRACTSTYLE + 213 LINK1PRECEEDING + 214 LINK1FOLLOWING + 215 LINK1STYLE + 216 LINK2PRECEEDING + 217 LINK2FOLLOWING + 218 LINK2STYLE + 219 LINK3PRECEEDING + 220 LINK3FOLLOWING + 221 LINK3STYLE + 222 LINK4PRECEEDING + 223 LINK4FOLLOWING + 224 LINK4STYLE */ /* now retrieve matching style information from REFSTYLE into*/ if (!strcmp(my_dbi_conn_get_cap(conn, "multiple_db"), "t")) { - sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, URLPRECEEDING, URLFOLLOWING, URLSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from %s.REFSTYLE where PUBTYPE='%s' and CITSTYLEID="ULLSPEC, MAIN_DB, pubtype, (unsigned long long)citstyle_id); + sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from %s.REFSTYLE where PUBTYPE='%s' and CITSTYLEID="ULLSPEC, MAIN_DB, pubtype, (unsigned long long)citstyle_id); } else { - sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, URLPRECEEDING, URLFOLLOWING, URLSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from REFSTYLE where PUBTYPE='%s' and CITSTYLEID="ULLSPEC, pubtype, (unsigned long long)citstyle_id); + sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from REFSTYLE where PUBTYPE='%s' and CITSTYLEID="ULLSPEC, pubtype, (unsigned long long)citstyle_id); } @@ -2715,8 +2781,8 @@ dbi_result_free(dbi_style_res); if (!strcmp(my_dbi_conn_get_cap(conn, "multiple_db"), "t")) { - sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, URLPRECEEDING, URLFOLLOWING, URLSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from %s.REFSTYLE where PUBTYPE='GEN' and CITSTYLEID="ULLSPEC, MAIN_DB, (unsigned long long)citstyle_id); + sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP, PUBDATEALLFIRSTSEP, PUBDATEALLSECONDSEP, PAGESPAGERANGERANGESEPARATOR, SERIALPRECEEDING, SERIALFOLLOWING, SERIALSTYLE, ADDRESSPRECEEDING, ADDRESSFOLLOWING, ADDRESSSTYLE, USERDEF1PRECEEDING, USERDEF1FOLLOWING, USERDEF1STYLE, USERDEF2PRECEEDING, USERDEF2FOLLOWING, USERDEF2STYLE, USERDEF3PRECEEDING, USERDEF3FOLLOWING, USERDEF3STYLE, USERDEF4PRECEEDING, USERDEF4FOLLOWING, USERDEF4STYLE, USERDEF5PRECEEDING, USERDEF5FOLLOWING, USERDEF5STYLE, MISC1PRECEEDING, MISC1FOLLOWING, MISC1STYLE, MISC2PRECEEDING, MISC2FOLLOWING, MISC2STYLE, MISC3PRECEEDING, MISC3FOLLOWING, MISC3STYLE, NOTESPRECEEDING, NOTESFOLLOWING, NOTESSTYLE, ABSTRACTPRECEEDING, ABSTRACTFOLLOWING, ABSTRACTSTYLE, LINK1PRECEEDING, LINK1FOLLOWING, LINK1STYLE, LINK2PRECEEDING, LINK2FOLLOWING, LINK2STYLE, LINK3PRECEEDING, LINK3FOLLOWING, LINK3STYLE, LINK4PRECEEDING, LINK4FOLLOWING, LINK4STYLE from %s.REFSTYLE where PUBTYPE='GEN' and CITSTYLEID="ULLSPEC, MAIN_DB, (unsigned long long)citstyle_id); } else { - sprintf(sql_command, "SELECT ID, QSTYLE, XSTYLE, YSTYLE, ZSTYLE, QABBREVIATEFIRST, XABBREVIATEFIRST, YABBREVIATEFIRST, ZABBREVIATEFIRST, QABBREVIATESUBSEQ, XABBREVIATESUBSEQ, YABBREVIATESUBSEQ, ZABBREVIATESUBSEQ, QABBREVIATEFIRSTMAXAUTHOR, XABBREVIATEFIRSTMAXAUTHOR, YABBREVIATEFIRSTMAXAUTHOR, ZABBREVIATEFIRSTMAXAUTHOR, QABBREVIATESUBSEQMAXAUTHOR, XABBREVIATESUBSEQMAXAUTHOR, YABBREVIATESUBSEQMAXAUTHOR, ZABBREVIATESUBSEQMAXAUTHOR, QABBREVIATEFIRSTDISPLAYAUTHOR, XABBREVIATEFIRSTDISPLAYAUTHOR, YABBREVIATEFIRSTDISPLAYAUTHOR, ZABBREVIATEFIRSTDISPLAYAUTHOR, QABBREVIATESUBSEQDISPLAYAUTHOR, XABBREVIATESUBSEQDISPLAYAUTHOR, YABBREVIATESUBSEQDISPLAYAUTHOR, ZABBREVIATESUBSEQDISPLAYAUTHOR, QAEMPTY, XAEMPTY, YAEMPTY, ZAEMPTY, QASAME, XASAME, YASAME, ZASAME, QPRECEEDING, XPRECEEDING, YPRECEEDING, ZPRECEEDING, QFOLLOWING, XFOLLOWING, YFOLLOWING, ZFOLLOWING, QAUTHORSEPSTWOSEPS, XAUTHORSEPSTWOSEPS, YAUTHORSEPSTWOSEPS, ZAUTHORSEPSTWOSEPS, QAUTHORSEPSTHREESEPSTHREESEPSEACH, XAUTHORSEPSTHREESEPSTHREESEPSEACH, YAUTHORSEPSTHREESEPSTHREESEPSEACH, ZAUTHORSEPSTHREESEPSTHREESEPSEACH, QAUTHORSEPSTHREESEPSTHREESEPSLAST, XAUTHORSEPSTHREESEPSTHREESEPSLAST, YAUTHORSEPSTHREESEPSTHREESEPSLAST, ZAUTHORSEPSTHREESEPSTHREESEPSLAST, QAUTHORNAMESNAMEFIRSTNAMEORDER, XAUTHORNAMESNAMEFIRSTNAMEORDER, YAUTHORNAMESNAMEFIRSTNAMEORDER, ZAUTHORNAMESNAMEFIRSTNAMEORDER, QAUTHORNAMESNAMEFIRSTINITIALSTYLE, XAUTHORNAMESNAMEFIRSTINITIALSTYLE, YAUTHORNAMESNAMEFIRSTINITIALSTYLE, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE, QAUTHORNAMESNAMEFIRSTUPPERCASE, XAUTHORNAMESNAMEFIRSTUPPERCASE, YAUTHORNAMESNAMEFIRSTUPPERCASE, ZAUTHORNAMESNAMEFIRSTUPPERCASE, QAUTHORNAMESNAMEOTHERNAMEORDER, XAUTHORNAMESNAMEOTHERNAMEORDER, YAUTHORNAMESNAMEOTHERNAMEORDER, ZAUTHORNAMESNAMEOTHERNAMEORDER, QAUTHORNAMESNAMEOTHERINITIALSTYLE, XAUTHORNAMESNAMEOTHERINITIALSTYLE, YAUTHORNAMESNAMEOTHERINITIALSTYLE, ZAUTHORNAMESNAMEOTHERINITIALSTYLE, QAUTHORNAMESNAMEOTHERUPPERCASE, XAUTHORNAMESNAMEOTHERUPPERCASE, YAUTHORNAMESNAMEOTHERUPPERCASE, ZAUTHORNAMESNAMEOTHERUPPERCASE, QTEXTTEXTSINGLEPRECEEDING, XTEXTTEXTSINGLEPRECEEDING, YTEXTTEXTSINGLEPRECEEDING, ZTEXTTEXTSINGLEPRECEEDING, QTEXTTEXTSINGLEFOLLOWING, XTEXTTEXTSINGLEFOLLOWING, YTEXTTEXTSINGLEFOLLOWING, ZTEXTTEXTSINGLEFOLLOWING, QTEXTTEXTMULTIPLEPRECEEDING, XTEXTTEXTMULTIPLEPRECEEDING, YTEXTTEXTMULTIPLEPRECEEDING, ZTEXTTEXTMULTIPLEPRECEEDING, QTEXTTEXTMULTIPLEFOLLOWING, XTEXTTEXTMULTIPLEFOLLOWING, YTEXTTEXTMULTIPLEFOLLOWING, ZTEXTTEXTMULTIPLEFOLLOWING, PUBDATEPRECEEDING, PUBDATEFOLLOWING, PUBDATEFORMAT, PUBDATESEQUENCE, PUBDATEMONTHFORMAT, PUBDATEDAYFORMAT, PUBDATEYEARFORMAT, PUBDATEPADLEADINGZERO, PUBDATESTYLE, PUBDATESECPRECEEDING, PUBDATESECFOLLOWING, PUBDATESECFORMAT, PUBDATESECSEQUENCE, PUBDATESECMONTHFORMAT, PUBDATESECDAYFORMAT, PUBDATESECYEARFORMAT, PUBDATESECPADLEADINGZERO, PUBDATESECSTYLE, PUBDATEALLPRECEEDING, PUBDATEALLFOLLOWING, PUBDATEALLFORMAT, PUBDATEALLSEQUENCE, PUBDATEALLMONTHFORMAT, PUBDATEALLDAYFORMAT, PUBDATEALLYEARFORMAT, PUBDATEALLPADLEADINGZERO, PUBDATEALLSTYLE, TITLEPRECEEDING, TITLEFOLLOWING, TITLECASE, TITLESTYLE, BOOKTITLEPRECEEDING, BOOKTITLEFOLLOWING, BOOKTITLECASE, BOOKTITLESTYLE, SERIESTITLEPRECEEDING, SERIESTITLEFOLLOWING, SERIESTITLECASE, SERIESTITLESTYLE, ALLTITLEPRECEEDING, ALLTITLEFOLLOWING, ALLTITLECASE, ALLTITLESTYLE, JOURNALNAMEPRECEEDING, JOURNALNAMEFOLLOWING, JOURNALNAMECASE, JOURNALNAMEDEFAULTTEXT, JOURNALNAMEALTERNATETEXT, JOURNALNAMEPUNCTUATION, JOURNALNAMESTYLE, VOLUMEPRECEEDING, VOLUMEFOLLOWING, VOLUMESTYLE, ISSUEPRECEEDING, ISSUEFOLLOWING, ISSUESTYLE, PAGESSTYLE, PAGESSINGLEPAGEPRECEEDING, PAGESSINGLEPAGEFOLLOWING, PAGESPAGERANGEPRECEEDING, PAGESPAGERANGEFOLLOWING, PAGESPAGERANGETYPE, PUBLISHERPRECEEDING, PUBLISHERFOLLOWING, PUBLISHERSTYLE, PUBPLACEPRECEEDING, PUBPLACEFOLLOWING, PUBPLACESTYLE, PAGESPRECEEDING, PAGESFOLLOWING, REFNUMBERPRECEEDING, REFNUMBERFOLLOWING, REFNUMBERSTYLE, PUBDATEFIRSTSEP, PUBDATESECONDSEP, PUBDATESECFIRSTSEP, PUBDATESECSECONDSEP... [truncated message content] |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:35:46
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24008/src Modified Files: Tag: Release_0_9_5_stable dbfncs.c Log Message: implemented multiple url handling (mysql only) Index: dbfncs.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.c,v retrieving revision 1.15.2.12 retrieving revision 1.15.2.13 diff -u -U2 -r1.15.2.12 -r1.15.2.13 --- dbfncs.c 29 Jul 2005 21:15:34 -0000 1.15.2.12 +++ dbfncs.c 7 Sep 2005 23:35:38 -0000 1.15.2.13 @@ -177,41 +177,41 @@ support this so a simple INT has to do the trick */ - dbires = dbi_conn_query(conn, "CREATE TABLE t_refdb \ - (refdb_id BIGINT NOT NULL AUTO_INCREMENT, \ - refdb_citekey VARCHAR(255), \ - refdb_type VARCHAR(6), \ - refdb_pubyear SMALLINT NOT NULL, \ - refdb_secyear SMALLINT NOT NULL, \ - refdb_startpage VARCHAR(255), \ - refdb_endpage VARCHAR(255), \ - refdb_abstract MEDIUMBLOB, \ [...1077 lines suppressed...] @@ -1968,5 +2025,5 @@ int i; char sql_command[64]; - const char tables[6][13] = { + const char tables[8][13] = { "t_keyword", "t_user", @@ -1974,8 +2031,10 @@ "t_xuser", "t_note", - "t_xnote" + "t_xnote", + "t_link", + "t_xlink" }; - for (i = 0; i < 6; i++) { + for (i = 0; i < 8; i++) { sprintf(sql_command, "LOCK TABLE %s IN SHARE MODE", tables[i]); dbires = dbi_conn_query(conn, sql_command); |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:34:27
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23825/scripts Modified Files: Tag: Release_0_9_5_stable statgen.pl Log Message: added ulink related messages Index: statgen.pl =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/statgen.pl,v retrieving revision 1.1.2.3 retrieving revision 1.1.2.4 diff -u -U2 -r1.1.2.3 -r1.1.2.4 --- statgen.pl 14 Aug 2005 00:20:46 -0000 1.1.2.3 +++ statgen.pl 7 Sep 2005 23:34:19 -0000 1.1.2.4 @@ -84,4 +84,7 @@ ["255", "failed to attach dataset to user"], ["256", "sucessfully attached dataset to user"], + ["257", "create t_link failed"], + ["258", "create t_xlink failed"], + ["259", "failed to remove ulink"], ## 3xx: query errors |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:33:39
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23564/scripts Modified Files: Tag: Release_0_9_5_stable refdb.dump.mysql.in refdb.dump.mysql41.in refdb.dump.pgsql.in refdb.dump.sqlite.in Log Message: replaced URL fields with LINK0 fields Index: refdb.dump.mysql.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/refdb.dump.mysql.in,v retrieving revision 1.1.2.2 retrieving revision 1.1.2.3 diff -u -U2 -r1.1.2.2 -r1.1.2.3 --- refdb.dump.mysql.in 29 Jul 2005 21:22:49 -0000 1.1.2.2 +++ refdb.dump.mysql.in 7 Sep 2005 23:33:32 -0000 1.1.2.3 @@ -286,8 +286,4 @@ ADDRESSSTYLE varchar(12), - URLPRECEEDING tinytext, - URLFOLLOWING tinytext, - URLSTYLE varchar(12), - USERDEF1PRECEEDING tinytext, USERDEF1FOLLOWING tinytext, @@ -330,4 +326,8 @@ ABSTRACTSTYLE varchar(12), + LINK0PRECEEDING tinytext, + LINK0FOLLOWING tinytext, + LINK0STYLE varchar(12), + LINK1PRECEEDING tinytext, LINK1FOLLOWING tinytext, Index: refdb.dump.mysql41.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/refdb.dump.mysql41.in,v retrieving revision 1.1.2.2 retrieving revision 1.1.2.3 diff -u -U2 -r1.1.2.2 -r1.1.2.3 --- refdb.dump.mysql41.in 29 Jul 2005 21:20:19 -0000 1.1.2.2 +++ refdb.dump.mysql41.in 7 Sep 2005 23:33:32 -0000 1.1.2.3 @@ -298,7 +298,4 @@ `ADDRESSFOLLOWING` tinytext, `ADDRESSSTYLE` varchar(12) default NULL, - `URLPRECEEDING` tinytext, - `URLFOLLOWING` tinytext, - `URLSTYLE` varchar(12) default NULL, `USERDEF1PRECEEDING` tinytext, `USERDEF1FOLLOWING` tinytext, @@ -331,4 +328,7 @@ `ABSTRACTFOLLOWING` tinytext, `ABSTRACTSTYLE` varchar(12) default NULL, + `LINK0PRECEEDING` tinytext, + `LINK0FOLLOWING` tinytext, + `LINK0STYLE` varchar(12) default NULL, `LINK1PRECEEDING` tinytext, `LINK1FOLLOWING` tinytext, Index: refdb.dump.pgsql.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/refdb.dump.pgsql.in,v retrieving revision 1.1.2.3 retrieving revision 1.1.2.4 diff -u -U2 -r1.1.2.3 -r1.1.2.4 --- refdb.dump.pgsql.in 1 Jun 2005 19:09:48 -0000 1.1.2.3 +++ refdb.dump.pgsql.in 7 Sep 2005 23:33:32 -0000 1.1.2.4 @@ -252,8 +252,4 @@ ADDRESSSTYLE TEXT, - URLPRECEEDING TEXT, - URLFOLLOWING TEXT, - URLSTYLE TEXT, - USERDEF1PRECEEDING TEXT, USERDEF1FOLLOWING TEXT, @@ -296,4 +292,8 @@ ABSTRACTSTYLE TEXT, + LINK0PRECEEDING TEXT, + LINK0FOLLOWING TEXT, + LINK0STYLE TEXT, + LINK1PRECEEDING TEXT, LINK1FOLLOWING TEXT, Index: refdb.dump.sqlite.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/refdb.dump.sqlite.in,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -U2 -r1.1.2.1 -r1.1.2.2 --- refdb.dump.sqlite.in 10 Feb 2005 20:30:01 -0000 1.1.2.1 +++ refdb.dump.sqlite.in 7 Sep 2005 23:33:32 -0000 1.1.2.2 @@ -250,8 +250,4 @@ ADDRESSSTYLE TEXT, - URLPRECEEDING TEXT, - URLFOLLOWING TEXT, - URLSTYLE TEXT, - USERDEF1PRECEEDING TEXT, USERDEF1FOLLOWING TEXT, @@ -294,4 +290,8 @@ ABSTRACTSTYLE TEXT, + LINK0PRECEEDING TEXT, + LINK0FOLLOWING TEXT, + LINK0STYLE TEXT, + LINK1PRECEEDING TEXT, LINK1FOLLOWING TEXT, |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:31:55
|
Update of /cvsroot/refdb/refdb/dtd In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23371/dtd Modified Files: Tag: Release_0_9_5_stable xnote.dtd Log Message: bumped up version number;added ulink element Index: xnote.dtd =================================================================== RCS file: /cvsroot/refdb/refdb/dtd/xnote.dtd,v retrieving revision 1.3.2.1 retrieving revision 1.3.2.2 diff -u -U2 -r1.3.2.1 -r1.3.2.2 --- xnote.dtd 13 Apr 2005 10:54:47 -0000 1.3.2.1 +++ xnote.dtd 7 Sep 2005 23:31:47 -0000 1.3.2.2 @@ -4,5 +4,5 @@ <!-- Invoke with the following declaration --> -<!-- <!DOCTYPE xnoteset PUBLIC "-//Markus Hoenicka//DTD Xnote V1.1//EN" "http://refdb.sourceforge.net/dtd/xnote-1.1/xnote.dtd"> --> +<!-- <!DOCTYPE xnoteset PUBLIC "-//Markus Hoenicka//DTD Xnote V1.2//EN" "http://refdb.sourceforge.net/dtd/xnote-1.2/xnote.dtd"> --> <!-- the top-level element, containing one or more extended notes --> @@ -12,5 +12,5 @@ <!-- this element describes one extended note --> -<!ELEMENT xnote (title?, content, keyword*, link*)> +<!ELEMENT xnote (title?, content, keyword*, link*, ulink*)> <!ATTLIST xnote id NMTOKEN #IMPLIED citekey NMTOKEN #IMPLIED @@ -34,2 +34,8 @@ <!ATTLIST link type (reference|author|keyword|journalfull|journalabbrev|journalcustabbrev1|journalcustabbrev2) #REQUIRED target CDATA #REQUIRED> + +<!-- an URL of a web resource --> +<!ELEMENT ulink (#PCDATA)> + +<!ATTLIST ulink type (url|pdf|fulltext|related|image) "url"> + |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:31:13
|
Update of /cvsroot/refdb/refdb/dtd In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23184/dtd Modified Files: Tag: Release_0_9_5_stable risx.dtd Log Message: bumped up version number;removed url element; use link element with type pdf as url replacement Index: risx.dtd =================================================================== RCS file: /cvsroot/refdb/refdb/dtd/risx.dtd,v retrieving revision 1.12.2.2 retrieving revision 1.12.2.3 diff -u -U2 -r1.12.2.2 -r1.12.2.3 --- risx.dtd 22 Jun 2005 20:06:15 -0000 1.12.2.2 +++ risx.dtd 7 Sep 2005 23:31:05 -0000 1.12.2.3 @@ -4,5 +4,5 @@ <!-- Invoke with the following declaration --> -<!-- <!DOCTYPE ris PUBLIC "-//Markus Hoenicka//DTD Ris V1.0.3//EN" "http://refdb.sourceforge.net/dtd/risx-1.0.3/risx.dtd"> --> +<!-- <!DOCTYPE ris PUBLIC "-//Markus Hoenicka//DTD Ris V1.1.0//EN" "http://refdb.sourceforge.net/dtd/risx-1.1.0/risx.dtd"> --> <!-- the top-level element --> @@ -37,8 +37,6 @@ <!ATTLIST title type (full|abbrev|user1|user2) #REQUIRED> -<!-- the url element is allowed multiple times for future compatibility --> -<!-- with RefMan 10. RefDB as of version 0.9.3 imports only the last --> -<!-- occurrence of this element --> -<!ELEMENT pubinfo (pubdate*,volume?,issue?,startpage?,endpage?,city?,publisher?,serial?,address?,url*,userdef*,misc*,link*)> +<!-- The url element is gone in favour of 'link type="url"'. Both elements use the same semantics so it would be weird to keep them separately --> +<!ELEMENT pubinfo (pubdate*,volume?,issue?,startpage?,endpage?,city?,publisher?,serial?,address?,userdef*,misc*,link*)> <!ELEMENT pubdate (date,otherinfo?)> @@ -72,6 +70,4 @@ <!ELEMENT address (#PCDATA)> -<!ELEMENT url (#PCDATA)> - <!ELEMENT userdef (#PCDATA)> @@ -84,5 +80,5 @@ <!ELEMENT link (#PCDATA)> -<!ATTLIST link type (pdf|fulltext|related|image) "pdf"> +<!ATTLIST link type (url|pdf|fulltext|related|image) "url"> <!-- the libinfo element contains the local housekeeping information --> |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:29:36
|
Update of /cvsroot/refdb/refdb/dtd In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22907/dtd Modified Files: Tag: Release_0_9_5_stable citestylex.dtd Log Message: bumped up version number;renamed URL to LINK with role 0 Index: citestylex.dtd =================================================================== RCS file: /cvsroot/refdb/refdb/dtd/citestylex.dtd,v retrieving revision 1.7.2.4 retrieving revision 1.7.2.5 diff -u -U2 -r1.7.2.4 -r1.7.2.5 --- citestylex.dtd 12 Oct 2004 00:26:15 -0000 1.7.2.4 +++ citestylex.dtd 7 Sep 2005 23:29:29 -0000 1.7.2.5 @@ -4,5 +4,5 @@ <!-- suggested invocation: --> -<!-- <!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.3//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.3/citestylex.dtd"> --> +<!-- <!DOCTYPE CITESTYLE PUBLIC "-//Markus Hoenicka//DTD CiteStyle V1.4//EN" "http://refdb.sourceforge.net/dtd/citestylex-1.4/citestylex.dtd"> --> <!ELEMENT STYLESET (CITESTYLE)+> @@ -14,5 +14,5 @@ <!ELEMENT REFSTYLE (PUBTYPE+)> -<!ELEMENT PUBTYPE (((REFNUMBER | AUTHORLIST | PUBDATE | TITLE | JOURNALNAME | VOLUME | ISSUE | PAGES | PUBLISHER | PUBPLACE | SERIAL | ADDRESS | URL | USERDEF | MISC | NOTES | ABSTRACT | LINK), SEPARATOR?)+)> +<!ELEMENT PUBTYPE (((REFNUMBER | AUTHORLIST | PUBDATE | TITLE | JOURNALNAME | VOLUME | ISSUE | PAGES | PUBLISHER | PUBPLACE | SERIAL | ADDRESS | USERDEF | MISC | NOTES | ABSTRACT | LINK), SEPARATOR?)+)> <!ATTLIST PUBTYPE TYPE (ABST|ADVS|ART|BILL|BOOK|CASE|CHAP|COMP|CONF|CTLG|DATA|ELEC|GEN|ICOMM|INPR|JFULL|JOUR|MAP|MGZN|MPCT|MUSIC|NEWS|PAMP|PAT|PCOMM|RPRT|SER|SLIDE|SOUND|STAT|THES|UNBILL|UNPB|VIDEO) #REQUIRED> @@ -151,8 +151,4 @@ <!ATTLIST ADDRESS STYLE (BOLD | ITALIC | BOLDITALIC | SUPER | SUB | ULINE | BOLDULINE | ITULINE | BOLDITULINE | NONE) #IMPLIED> -<!ELEMENT URL (PRECEEDING?, FOLLOWING?)> - -<!ATTLIST URL STYLE (BOLD | ITALIC | BOLDITALIC | SUPER | SUB | ULINE | BOLDULINE | ITULINE | BOLDITULINE | NONE) #IMPLIED> - <!ELEMENT USERDEF (PRECEEDING?, FOLLOWING?)> @@ -176,5 +172,5 @@ <!ATTLIST LINK STYLE (BOLD | ITALIC | BOLDITALIC | SUPER | SUB | ULINE | BOLDULINE | ITULINE | BOLDITULINE | NONE) #IMPLIED - ROLE (1|2|3|4) "1"> + ROLE (0|1|2|3|4) "0"> <!ELEMENT SEPARATOR (#PCDATA)> |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:19:24
|
Update of /cvsroot/refdb/refdb/doc In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21128/doc Modified Files: Tag: Release_0_9_5_stable catalog Log Message: added color support Index: catalog =================================================================== RCS file: /cvsroot/refdb/refdb/doc/catalog,v retrieving revision 1.1.1.1 retrieving revision 1.1.1.1.4.1 diff -u -U2 -r1.1.1.1 -r1.1.1.1.4.1 --- catalog 22 May 2001 05:35:39 -0000 1.1.1.1 +++ catalog 7 Sep 2005 23:19:17 -0000 1.1.1.1.4.1 @@ -1 +1,6 @@ -SGMLDECL /usr/lib/sgml/declaration/docbook.dcl +PUBLIC "+//ISBN 1-894049::CSL::Resources//DOCUMENT DSSSL Color Declarations//EN" "include/colordef.dsl" +PUBLIC "+//ISBN 1-894049::CSL::Resources//ENTITIES DSSSL Color Declarations//EN" "include/colordsl.ent" +PUBLIC "+//ISBN 1-894049::CSL::Resources//ENTITIES Color Declarations//EN" "include/colordef.ent" + + + |
|
From: Markus H. <mho...@us...> - 2005-09-07 23:18:44
|
Update of /cvsroot/refdb/refdb/doc In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21018/doc Modified Files: Tag: Release_0_9_5_stable Makefile.am Log Message: minor build fixes Index: Makefile.am =================================================================== RCS file: /cvsroot/refdb/refdb/doc/Attic/Makefile.am,v retrieving revision 1.1.2.2 retrieving revision 1.1.2.3 diff -u -U2 -r1.1.2.2 -r1.1.2.3 --- Makefile.am 15 Aug 2005 00:10:27 -0000 1.1.2.2 +++ Makefile.am 7 Sep 2005 23:18:37 -0000 1.1.2.3 @@ -30,5 +30,5 @@ refdb-manual.pdf: $(manual_sources) $(pdf_images) refdb-manual-statustable.sgml include/doc-print.dsl @echo "Creating PDF manual..."; - openjade -t tex -V tex-backend -d include/doc-print.dsl $(sgml_decl) refdb-manual.sgml + openjade -c ./catalog -t tex -V tex-backend -d include/doc-print.dsl $(sgml_decl) refdb-manual.sgml # run jadetex three times to get the references right pdfjadetex refdb-manual.tex @@ -42,11 +42,11 @@ distclean: clean - rm -f refdb-manual.pdf + rm -f refdb-manual.pdf refdb-manual.tex refdb-manual.aux refdb-manual.log refdb-manual.out rm -rf refdb-manual/ - rm $(png_images) - rm $(pdf_images) + rm -f $(png_images) + rm -f $(pdf_images) # this can't be kosher... -install-exec-am: $(top_srcdir)/mkinstalldirs - $(top_srcdir)/mkinstalldirs $(DESTDIR)$(docdir) $(DESTDIR)$(docdir)/refdb-manual +install-exec-am: $(top_srcdir)/conf/mkinstalldirs + $(top_srcdir)/conf/mkinstalldirs $(DESTDIR)$(docdir) $(DESTDIR)$(docdir)/refdb-manual |
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25229 Added Files: Tag: Release_0_9_5_stable CHANGELOG INSTALL admin.php include.php index.html login.php refdb-prl-del.php refdbadd.html refdbadd.php refdbadmin.php refdbdbquery.php refdbkajquery.html refdbkajsearch.php refdblogout.php refdbq.css refdbquery.html refdbsearch.php Log Message: initial version, stolen from main branch --- NEW FILE --- 09/07/2005 -Added option to keep or delete the upload file after adding references. -Simplified the code to create the temp file for adding the references(5 lines to 1 line) using ereg_replace 09/07/2005 -Added the PHP interface to the CVS repository with INSTALL note. -Current Functionality: Display fields, defaults to ALL Scope of query full or personal list Simple Search -for exact or similar term -range of fields -up to 4 fields combined with boolean operators AND,OR,NOT Advanced Query using the query language Keyword, Author, Journal Query form Add Reference -copy paste text reference -basic check for RIS, BibTeX, Pubmed formats -upload a file containing references Change current working database Logout Admin Interface -Add/Remove user -Add/Remove database -Schedule Keyword Scan --- NEW FILE --- PHP Web Interface for RefDB by Tom Bartolucci Quick Note: This interface was designed with the hope that the command syntax for the refdbc and refdba clients would remain the same even if the backends change. It is also designed in such a manner that absolutely nothing about how you compiled refdb should make a difference. Install: With that said to "install" this web interface all you need to do is copy all the files to the www directory that refdb creates for itself. The default being /usr/local/share/refdb/www. IMPORTANT: PHP must have write permissions in the directory that contains these files for the addref functions to work Web Server: For instructions on how to set your web server up to alias /usr/local/share/refdb/www to a web accessible path, refer to the RefDB manual. --- NEW FILE --- <? //admin.php written by Tom Bartolucci 2005 //Contains all the methods to process the admin actions from refdbadmin.php ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Admin Interface</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <script language="Javascript"></script> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Admin Interface</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; $cmd = "refdba -u $name -w $passwd -c stdout -C "; if( $submit == "Add User") { if( $pass == $passcfm ) { $cmd = $cmd."adduser -d $adduserdb -N $pass $user"; } } else if( $submit == "Remove User") { $cmd = $cmd."adduser -r -d $rmuserdb $rmuser"; } else if( $submit == "Add Database") { $cmd = $cmd."createdb $newdb"; } else if( $submit == "Remove Database") { $cmd = $cmd."deletedb $removedb"; } else if( $submit == "Scan Database") { $cmd = $cmd."scankw $scandb"; } exec($cmd, $lines); foreach($lines as $line) { print $line."<br>\n"; } print "<p><a href='refdbadmin.php'>Return to the Admin Interface</a></p>\n"; ?> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //include.php written by Tom Bartolucci 2005 //I tried to keep the original HTML interface intact. //These arrays are used to process input from the those original html files //This array is used to build the query that will be sent to the getref command //for the simple search on the query page $fields = array("author"=>":AU:", "editor"=>":ED:", "seditor"=>":ED:", "title"=>":TA:", "booktitle"=>":TA:", "seriestitle"=>":TA:", "journaltitle"=>":JF:", "keyword"=>":KW:"); //These are the logical operators used in the simple search $ops = array("and"=>"AND", "or"=>"OR", "not"=>"NOT"); $equals = array("exact"=>"=", "like"=>"~"); //This array contains the more fields to be included in the display of //the search results $morefields = array("Notes"=>"N1", "Abstract"=>"N2", "Address"=>"AD", "Reprint"=>"RP", "ISSN"=>"SN", "URL"=>"UR", "Publisher"=>"PB", "City"=>"CY", "U1"=>"U1", "U2"=>"U2", "U3"=>"U3", "U4"=>"U4", "U5"=>"U5", "M1"=>"M1", "M2"=>"M2", "M3"=>"M3"); ?> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <!--Modified from the original RefDB interface to be used as a login portal to the web interface. --> <html> <head> <title>RefDB Login form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Login Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="login.php" method="post"> <p>Your RefDB username: <input type="text" name="name" size="16" maxlength="16"></p> <p>Your RefDB password: <input type="password" name="passwd" size="16" maxlength="16"></p> <p>Use database <input type="text" name="database"></p> <p><input type="submit" value="Login"></p> </form> </td> </tr> <tr> <td class="navbar"> </td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //Written by Tom Bartolucci 2005 //Basica login sets the SESSION and COOKIE for this RefDB user $_SESSION["passwd"] = $passwd; $_SESSION["name"] = $name; $_SESSION["database"] = $database; setcookie(session_name(),session_id(), time()+7200); ?> <html> <head> <title>Logging In...</title> <meta http-equiv="REFRESH" content="0; URL=refdbquery.html"> </head> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <!-- Using the RefDB interface general template this file processes deleting a reference entry, as well as adding and removing from personal reference lists --> <html> <head> <title>RefDB query results</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Results</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <table border> <thead> <tr> <td class="result"> <form action="refdbsearch.php" method="post"> </td> </tr> </thead> <tbody> <? require_once("include.php"); $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; //begin to build the command to send to refdbc $cmd = "refdbc -c stdout -d $database -u $name -w $passwd -C "; if( isset($deleteref) ) //if you're deleting a reference { $cmd = $cmd."deleteref "; } else if( isset($pickref) ) //if you're adding it to your personal list { $cmd = $cmd."pickref "; } else if( isset($unpickref) ) //if you're removing it from your personal list { $cmd = $cmd."pickref -r "; } else //if somehow you get to this page not from the search results { print "Error!"; } //This for loop concatenates the references to be deleted/added/removed for( $checkboxNumber = 1; $checkboxNumber <= $numberOfCheckBoxes; $checkboxNumber++) { $checkIndex = "checkbox".$checkboxNumber; if( isset($_POST[$checkIndex] ) ) //if the box is checked { $number = $_POST[$checkIndex]; $cmd = $cmd.$number." "; //concatenate to the list } } exec($cmd, $lines); //execute the command foreach($lines as $line) //print the output { print $line."<br>\n"; } print "<br><br>"; //These variables are used if you return to the Search Results print "<input type='hidden' name='return' value='$terms'>\n"; print "<input type='hidden' name='scope' value='$scope'>\n"; print "<input type='submit' name='sendQuery' value='Return to Search Results'>\n"; ?> </tbody> </table> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB add form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Add Reference Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p>Add new references</p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbadd.php" method="post" enctype="multipart/form-data"> <input type="hidden" name="MAX_FILE_SIZE" value="40000000000"> <h2>Add a reference</h2> <p><input type="radio" name="addformat" value="ris" checked="checked">RIS <input type="radio" name="addformat" value="bib2ris">BibTeX<input type="radio" name="addformat" value="med2ris.pl">Pubmed </p> <textarea name="addref" rows="25" cols="80"></textarea> <p><input type="submit" name="submit" value="Add"><input type="reset" value="Reset form"></p> <p> </p> <h2>Upload a file containing references</h2> <p><input type="file" name="referencefile"></p> <p><b>Delete this file after importing?</b><input type="checkbox" name="deletefile" value="Yes"></p> <p><input type="submit" name="submit" value="Add File"></p> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB add form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Add Reference Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p>Add new references</p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? if( $submit == "Add" ) { //if nothing was entered into the add reference text box if( empty($addref) ) { print "Error: No Reference data was entered."; } //Data was entered else { //This set of elseifs was written based on the simple check //in the original access.js file included in the old RefDB //interface. It checks to make sure necessary text for the //particular reference type is there $correct = false; if( $addformat == "ris" ) //RIS format { if( ereg("TY - ",$addref) ) $correct = true; else print "This does not look like RIS data.<br>\n"; } else if( $addformat == "bib2ris" ) //BibTeX format { if( ereg("@", $addref) ) $correct = true; else print "This does not look like BibTeX data.<br>\n"; } else if( $addformat == "med2ris.pl" ) //PubMed { if( ereg("PMID", $addref) ) $correct = true; else print "This does not look like PubMed data.<br>\n"; } //If the reference passes the checks if( $correct ) { //create a temporary file with the reference(s) in it $addref = ereg_replace("\r\n","\n",$addref); $handle = fopen("tempref","wb"); fwrite($handle, $addref); fclose($handle); $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; //refdbc command to add a reference $cmd = "refdbc -c stdout -u $name -w $passwd -C addref -d $database < tempref"; exec($cmd, $lines); unlink("tempref"); //delete the temp file //print the output foreach($lines as $line) { print $line."<br>\n"; } } print "<br><a href='refdbadd.html'>Add another Reference</a>\n"; } } elseif( $submit == "Add File" ) { if ($referencefile == "none") { echo "Problem: no File Selected"; exit; } if ($referencefile_size==0) { echo "Problem: File is of size zero"; exit; } if (!is_uploaded_file($referencefile)) { echo "File not uploaded successfully"; exit; } if( !move_uploaded_file($referencefile, $referencefile_name) ) { echo "Problem: Could not upload file onto Server"; exit; } $cmd = "refdbc -u $name -w $passwd -d $database -c stdout -C addref $referencefile_name"; exec($cmd, $lines); foreach($lines as $line) { print "$line<br>"; } if( isset($deletefile) ) { unlink($referencefile_name); } } ?> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Admin Interface</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <script language="Javascript"></script> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Admin Interface</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; ?> <form action="admin.php" method="post"> <!-- ***************************** ADD USER ******************************** --> <h2>Add User</h2> <p>Username: <input type="text" name="user" size="30"></p> <p>Password: <input type="password" name="pass" size="30"></p> <p>Confirm Password: <input type="password" name="passcfm" size="30"></p> <p>To Database: <select name="adduserdb"> <option value='' selected> -- </option> <? //command to list the databases available $listdb = "refdba -u $name -w $passwd -c stdout -C listdb"; exec($listdb, $dblines); foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Add User"></p> <hr> <!-- **************************** REMOVE USER ***************************** --> <h2>Remove User</h2> <!--Utilize javascript to refresh the page with the new data based on the selection of a database --> <p>From Database: <select name="rmuserdb" onchange="window.location=('refdbadmin.php?dbselected=true&db='+this.options[this.selectedIndex].value)"> <? //If a database hasn't been selected select the blank entry print "<option value=' '"; if( !isset($dbselected ) ) { print " selected"; } print "> -- </option>\n"; foreach($dblines as $dbline) { //once a database has been selected select that database print "<option value='$dbline'"; if( isset($dbselected) && $db == $dbline ) { print " selected"; } print ">$dbline</option>\n"; } ?> </select></p> <? //Display the users for that database if(isset($dbselected)) { //command to list users of a specific database $listuser = "refdba -u $name -w $passwd -c stdout -d $db -C listuser"; exec($listuser, $userlines); //create dropdown for the users print "<p>User: <select name='rmuser'>\n"; foreach($userlines as $userline) { print "<option value='$userline'>$userline</option>\n"; } print "</select></p>\n"; } ?> <p><input type="submit" name="submit" value="Remove User"></p> <!-- ********************************** CREATE DATABASE **************************** --> <hr> <h2>Create Database</h2> <p>Database Name: <input type="text" name="newdb" size="30"></p> <p><input type="submit" name="submit" value="Add Database"></p> <!-- ********************************* REMOVE DATABASE ***************************** --> <hr> <h2>Remove Database</h2> <p><select name="removedb"> <option value='' selected> -- </option> <? //list databases foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Remove Database"></p> <!-- ***************************** SCHEDULE A KEYWORD SCAN ************************* --> <hr> <h2>Schedule a Keyword Scane</h2> <p><select name="scandb"> <option value=' ' selected> -- </option> <? foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Scan Database"></p> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Database query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Database Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p>Change database</p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbdbquery.php" method="post"> <? //If the user changed databases, set the SESSION variable if( isset($submit) ) { $_SESSION["database"] = $db; } $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; print "Your current database is: <b>$database</b><br>\n"; //build comand to display databases $cmd = "refdbc -u $name -w $passwd -c stdout -C listdb"; exec($cmd,$lines); print "<p><select name='db'>\n"; foreach($lines as $line) { print "<option value='$line'>$line</option>\n"; } print "</select></p>\n"; print "<p><input type='submit' name='submit' value='Change Database'></p>\n"; ?> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Keyword, Author, Journal Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p>Search keywords, authors, journals</p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbkajsearch.php" method="post"> <h2>Query</h2> <p> <input type="text" name="kajquery"> in <select name="kajqueryfield"> <option value="keyword">keywords</option> <option value="author">authors</option> <option value="editor">editors</option> <option value="seditor">series editors</option> <option value="journalfull">journal (full)</option> <option value="journalabbrev">journal (abbrev.)</option> <option value="journalcustabbrev1">journal (custom abbrev. 1)</option> <option value="journalcustabbrev2">journal (custom abbrev. 2)</option> </select> </p> <input type="submit" value="Send query"><input type="reset" value="Reset form"> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //This function sets the proper refdbc command depending //on the field that you're searching for function selectField($kajqueryfield) { $get = ""; switch($kajqueryfield) { case "keyword": $get = "getkw"; break; case "author": $get = "getau"; break; case "editor": $get = "geted"; break; case "seditor": $get = "getas"; break; case "journalfull": $get = "getjf"; break; case "journalabbrev": $get = "getjo"; break; case "journalabbrev1": $get = "getj1"; break; case "journalabbrev2": $get = "getj2"; break; } return $get; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Keyword, Author, Journal Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p>Search keywords, authors, journals</p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; //build the command $cmd = "refdbc -u $name -w $passwd -d $database -c stdout -C "; $get = selectField($kajqueryfield); //kajquery is the search term $cmd = $cmd.$get." ".$kajquery; ?> <h2>Results</h2> <table border> <thead><tr> <th class="result">Matching <?$kajqueryfield?>(s)</th> </tr> </thead> <tbody> <? exec($cmd, $lines); foreach($lines as $line) { print "<tr><td class='result'>$line</td></tr>\n"; } ?> </tbody> </table> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB logout page</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Logout</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? //Destroy session and cookie variables setcookie(session_name(), "", time()-3600); session_destroy(); ?> <p>You finished your RefDB session.</p> <p><a href="index.html">Start a new session</a></p> </td> </tr> <tr> <td class="navbar"> </td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- table {border-width:1; border-style:solid; border-color:#E7E7E7; background-color:#FFFFFF;} td.navbar {border-width:1; border-style:solid; border-color:#4E6DD2; background-color:#4E6DD2; color:#FFFFFF} td.main {border-width:1; border-style:solid; border-color:#E7E7E7; background-color:#E7E7E7;} td.result {border-width:1; border-style:solid; border-color:#000000; background-color:#FFFFFF;} th.result {border-width:1; border-style:solid; border-color:#000000; background-color:#BEE1F0;} td.footer {border-width:1; border-style:solid; border-color:#4E6DD2; background-color:#AAAAAA;} a:link {color:#000000; font-weight:bold;} a:visited {color:#FF4040; font-weight:bold;} --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Reference Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p>Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbsearch.php" method="post"> <p>Display also the following fields:</p> <p> <input type="checkbox" name="Notes" value="N1">Notes <input type="checkbox" name="Abstract" value="N2">Abstract <input type="checkbox" name="Address" value="AD">Address <input type="checkbox" name="Reprint" value="RP">Reprint <input type="checkbox" name="ISSN" value="SN">ISSN <input type="checkbox" name="URL" value="UR">URL <input type="checkbox" name="Publisher" value="PB">Publisher <input type="checkbox" name="City" value="CY">City <input type="checkbox" name="U1" value="U1">U1 <input type="checkbox" name="U2" value="U2">U2 <input type="checkbox" name="U3" value="U3">U3 <input type="checkbox" name="U4" value="U4">U4 <input type="checkbox" name="U5" value="U5">U5 <input type="checkbox" name="M1" value="M1">M1 <input type="checkbox" name="M2" value="M2">M2 <input type="checkbox" name="M3" value="M3">M3 </p> <p>Scope of your query: <select name="scope"> <option value="full">full reference list</option> <option value="prl">personal reference list</option> </select> </p> <hr> <h2>Simple query</h2> <p> Is <select name="simpquery1equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery1"> in <select name="simpquery1field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery1op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery2equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery2"> in <select name="simpquery2field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery2op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery3equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery3"> in <select name="simpquery3field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery3op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery4equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery4"> in <select name="simpquery4field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> </p> <input type="submit" name="sendQuery" value="Send Simple query"><input type="reset" value="Reset form"> <hr> <h2>Advanced query</h2> <p>Query string: <input type="text" name="advquery" size="40" maxlength="2048"></p> <input type="submit" name="sendQuery" value="Send Advanced query"><input type="reset" value="Reset form"> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? require_once("include.php"); //This function builds the string for the display fields option //It uses the morefields array to associate the html value with //the refdbc identified value function setSearchFields($_POST, $morefields) { $searchFields = ""; while( list($key,$val) = each($morefields)) { if(isset($_POST[$key]) ) { $searchFields .= $val; } } if( $searchFields == "" ) { $searchFields = "ALL"; } return $searchFields; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query results</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Query Results</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <table border> <thead><tr><th class="result">Matching References</th></tr> <tr><td class="result"> <form action="refdb-prl-del.php" method="post"> <input type="submit" value="Delete selected references" name="deleteref"> <input type="submit" value="Add selected references to Personal List" name="pickref"> <input type="submit" value="Remove selected references from Personal List" name="unpickref"></td></tr></thead><tbody> <? $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $cmd = "refdbc -c stdout -d $database -u $name -w $passwd -F "; $searchFields = setSearchFields($_POST, $morefields); $cmd = $cmd.$searchFields." -C getref "; //Search just the personal reference list if($scope == "prl") { $cmd = $cmd."-p "; } $terms = ""; //The following if sets the query for the Simple Query //It builds the refdbc query using the fields and ops arrays //from include.php if( $sendQuery == "Send Simple query") { $first = true; if( $simpquery1 != "" ) { $field1 = $fields[$simpquery1field]; $equals1 = $equals[$simpquery1equals]; $terms = $terms.$field1.$equals1.$simpquery1." "; $first = false; } if( $simpquery2 != "" ) { $field2 = $fields[$simpquery2field]; $equals2 = $equals[$simpquery2equals]; if( $first) { $terms = $terms.$field2.$equals2.$simpquery2." "; $first = false; } else { $op1 = $ops[$simpquery1op]; $terms = $terms.$op1." ".$field2.$equals2.$simpquery2." "; } } if( $simpquery3 != "" ) { $field3 = $fields[$simpquery3field]; $equals3 = $equals[$simpquery3equals]; if( $first) { $terms = $terms.$field3.$equals3.$simpquery3." "; $first = false; } else { $op2 = $ops[$simpquery2op]; $terms = $terms.$op2." ".$field3.$equals3.$simpquery3." "; } } if( $simpquery4 != "" ) { $field4 = $fields[$simpquery4field]; $equals4 = $equals[$simpquery4equals]; if( $first) { $terms = $terms.$field4.$equals4.$simpquery4." "; $first = false; } else { $op3 = $ops[$simpquery3op]; $terms = $terms.$op3." ".$field4.$equals4.$simpquery4." "; } } } //Build the advance query else if( $sendQuery == "Send Advanced query" ) { $terms = $advquery; } //Query terms if you've returned from a search else if( $sendQuery == "Return to Search Results" ) { $terms = $return; } $cmd = $cmd.$terms; exec($cmd, $lines); ?><tr><td><div><? $checkboxNumber = 0; //If the search generates no results if( count($lines) <=1 ) { print "<br>Your Search for <b>$terms</b> generated no results<br><br>\n"; print $cmd; } //Your search generated results display them else { foreach( $lines as $line ) { //If this is the first line of a new reference it will contain the ID field if( substr($line,0,2) == "ID" ) { print "</div></td></tr>\n"; print "<tr><td class='result'>\n"; //strip the ID number out of the reference $colon = strpos($line, ':'); $space = strpos($line, " "); $id = substr($line,$colon+1,$space-$colon-1); ++$checkboxNumber; print "<input type='checkbox' name='checkbox$checkboxNumber' value='$id'> \n"; print "<input type='submit' value='Edit' name='editid$id'>\n"; print "<div class='record'>\n"; print "<h2 class='ID'>$line</h2>\n"; } else { print "$line<br>\n"; } } } print "<input type='hidden' name='terms' value='$terms'>\n"; print "<input type='hidden' name='scope' value='$scope'>\n"; print "<input type='hidden' name='numberOfCheckBoxes' value='$checkboxNumber'>\n"; ?> </tbody> </table> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> |
|
From: Markus H. <mho...@us...> - 2005-09-07 21:01:02
|
Update of /cvsroot/refdb/refdb/doc In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17593 Removed Files: Tag: Release_0_9_5_stable refdbmanualfig1.eps refdbmanualfig2.eps refdbmanualfig3.eps refdbmanualfig4.eps refdbmanualfig5.eps Log Message: no longer needed due to new doc build system --- refdbmanualfig1.eps DELETED --- --- refdbmanualfig2.eps DELETED --- --- refdbmanualfig3.eps DELETED --- --- refdbmanualfig4.eps DELETED --- --- refdbmanualfig5.eps DELETED --- |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 16:56:47
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23276/phpweb Modified Files: refdbadd.php Log Message: Simplified the creating of the temp reference file. Index: refdbadd.php =================================================================== RCS file: /cvsroot/refdb/refdb/phpweb/refdbadd.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -U2 -r1.2 -r1.3 --- refdbadd.php 7 Sep 2005 14:10:12 -0000 1.2 +++ refdbadd.php 7 Sep 2005 16:56:39 -0000 1.3 @@ -65,11 +65,8 @@ if( $correct ) { - $addref_lines = explode("\r\n",$addref); - //create a temporary file with the reference in it + //create a temporary file with the reference(s) in it + $addref = ereg_replace("\r\n","\n",$addref); $handle = fopen("tempref","wb"); - foreach($addref_lines as $arl) - { - fwrite($handle, $arl."\n"); - } + fwrite($handle, $addref); fclose($handle); |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 16:55:37
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23078/phpweb Modified Files: CHANGELOG Log Message: Simplified the creating of the temp reference file. Index: CHANGELOG =================================================================== RCS file: /cvsroot/refdb/refdb/phpweb/CHANGELOG,v retrieving revision 1.1 retrieving revision 1.2 diff -u -U2 -r1.1 -r1.2 --- CHANGELOG 7 Sep 2005 14:10:12 -0000 1.1 +++ CHANGELOG 7 Sep 2005 16:55:30 -0000 1.2 @@ -1,11 +1,12 @@ 09/07/2005 -Added option to keep or delete the upload file after adding references. +-Added option to keep or delete the upload file after adding references. +-Simplified the code to create the temp file for adding the references(5 lines to 1 line) using ereg_replace 09/07/2005 -Added the PHP interface to the CVS repository with INSTALL note. +-Added the PHP interface to the CVS repository with INSTALL note. -Current Functionality: +-Current Functionality: Display fields, defaults to ALL Scope of query full or personal list |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 14:10:34
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16225/phpweb Modified Files: refdbadd.html refdbadd.php Added Files: CHANGELOG Log Message: Added Changelog Updated RefdbAdd so that you can keep or delete upload file. --- NEW FILE --- 09/07/2005 Added option to keep or delete the upload file after adding references. 09/07/2005 Added the PHP interface to the CVS repository with INSTALL note. Current Functionality: Display fields, defaults to ALL Scope of query full or personal list Simple Search -for exact or similar term -range of fields -up to 4 fields combined with boolean operators AND,OR,NOT Advanced Query using the query language Keyword, Author, Journal Query form Add Reference -copy paste text reference -basic check for RIS, BibTeX, Pubmed formats -upload a file containing references Change current working database Logout Admin Interface -Add/Remove user -Add/Remove database -Schedule Keyword Scan Index: refdbadd.html =================================================================== RCS file: /cvsroot/refdb/refdb/phpweb/refdbadd.html,v retrieving revision 1.1 retrieving revision 1.2 diff -u -U2 -r1.1 -r1.2 --- refdbadd.html 7 Sep 2005 13:22:34 -0000 1.1 +++ refdbadd.html 7 Sep 2005 14:10:12 -0000 1.2 @@ -37,4 +37,5 @@ <h2>Upload a file containing references</h2> <p><input type="file" name="referencefile"></p> + <p><b>Delete this file after importing?</b><input type="checkbox" name="deletefile" value="Yes"></p> <p><input type="submit" name="submit" value="Add File"></p> </form> Index: refdbadd.php =================================================================== RCS file: /cvsroot/refdb/refdb/phpweb/refdbadd.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -U2 -r1.1 -r1.2 --- refdbadd.php 7 Sep 2005 13:22:34 -0000 1.1 +++ refdbadd.php 7 Sep 2005 14:10:12 -0000 1.2 @@ -123,4 +123,8 @@ print "$line<br>"; } + if( isset($deletefile) ) + { + unlink($referencefile_name); + } } |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 13:55:13
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12722/phpweb Modified Files: INSTALL Log Message: Updated INSTALL, forgot "PHP must have write permissions" Index: INSTALL =================================================================== RCS file: /cvsroot/refdb/refdb/phpweb/INSTALL,v retrieving revision 1.1 retrieving revision 1.2 diff -u -U2 -r1.1 -r1.2 --- INSTALL 7 Sep 2005 13:49:08 -0000 1.1 +++ INSTALL 7 Sep 2005 13:55:03 -0000 1.2 @@ -2,5 +2,16 @@ by Tom Bartolucci -This interface was designed with the hope that the command syntax for the refdbc and refdba clients would remain the same even if the backends change. It is also designed in such a manner that absolutely nothing about how you compiled refdb should make a difference. With that said to "install" this web interface all you need to do is copy all the files to the www directory that refdb creates for itself. The default being /usr/local/share/refdb/www. +Quick Note: + +This interface was designed with the hope that the command syntax for the refdbc and refdba clients would remain the same even if the backends change. It is also designed in such a manner that absolutely nothing about how you compiled refdb should make a difference. + +Install: + +With that said to "install" this web interface all you need to do is copy all the files to the www directory that refdb creates for itself. The default being /usr/local/share/refdb/www. + +IMPORTANT: PHP must have write permissions in the directory that contains these files for the addref functions to work + + +Web Server: For instructions on how to set your web server up to alias /usr/local/share/refdb/www to a web accessible path, refer to the RefDB manual. |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 13:49:20
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12082/phpweb Added Files: INSTALL Log Message: INSTALL doc for setting up the web interface --- NEW FILE --- PHP Web Interface for RefDB by Tom Bartolucci This interface was designed with the hope that the command syntax for the refdbc and refdba clients would remain the same even if the backends change. It is also designed in such a manner that absolutely nothing about how you compiled refdb should make a difference. With that said to "install" this web interface all you need to do is copy all the files to the www directory that refdb creates for itself. The default being /usr/local/share/refdb/www. For instructions on how to set your web server up to alias /usr/local/share/refdb/www to a web accessible path, refer to the RefDB manual. |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 13:22:43
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5128/phpweb Added Files: admin.php include.php index.html login.php refdb-prl-del.php refdbadd.html refdbadd.php refdbadmin.php refdbdbquery.php refdbkajquery.html refdbkajsearch.php refdblogout.php refdbq.css refdbquery.html refdbsearch.php Log Message: Initial drop of a PHP based web interface for the RefDB environment --- NEW FILE --- <? //admin.php written by Tom Bartolucci 2005 //Contains all the methods to process the admin actions from refdbadmin.php ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Admin Interface</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <script language="Javascript"></script> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Admin Interface</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; $cmd = "refdba -u $name -w $passwd -c stdout -C "; if( $submit == "Add User") { if( $pass == $passcfm ) { $cmd = $cmd."adduser -d $adduserdb -N $pass $user"; } } else if( $submit == "Remove User") { $cmd = $cmd."adduser -r -d $rmuserdb $rmuser"; } else if( $submit == "Add Database") { $cmd = $cmd."createdb $newdb"; } else if( $submit == "Remove Database") { $cmd = $cmd."deletedb $removedb"; } else if( $submit == "Scan Database") { $cmd = $cmd."scankw $scandb"; } exec($cmd, $lines); foreach($lines as $line) { print $line."<br>\n"; } print "<p><a href='refdbadmin.php'>Return to the Admin Interface</a></p>\n"; ?> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //include.php written by Tom Bartolucci 2005 //I tried to keep the original HTML interface intact. //These arrays are used to process input from the those original html files //This array is used to build the query that will be sent to the getref command //for the simple search on the query page $fields = array("author"=>":AU:", "editor"=>":ED:", "seditor"=>":ED:", "title"=>":TA:", "booktitle"=>":TA:", "seriestitle"=>":TA:", "journaltitle"=>":JF:", "keyword"=>":KW:"); //These are the logical operators used in the simple search $ops = array("and"=>"AND", "or"=>"OR", "not"=>"NOT"); $equals = array("exact"=>"=", "like"=>"~"); //This array contains the more fields to be included in the display of //the search results $morefields = array("Notes"=>"N1", "Abstract"=>"N2", "Address"=>"AD", "Reprint"=>"RP", "ISSN"=>"SN", "URL"=>"UR", "Publisher"=>"PB", "City"=>"CY", "U1"=>"U1", "U2"=>"U2", "U3"=>"U3", "U4"=>"U4", "U5"=>"U5", "M1"=>"M1", "M2"=>"M2", "M3"=>"M3"); ?> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <!--Modified from the original RefDB interface to be used as a login portal to the web interface. --> <html> <head> <title>RefDB Login form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Login Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="login.php" method="post"> <p>Your RefDB username: <input type="text" name="name" size="16" maxlength="16"></p> <p>Your RefDB password: <input type="password" name="passwd" size="16" maxlength="16"></p> <p>Use database <input type="text" name="database"></p> <p><input type="submit" value="Login"></p> </form> </td> </tr> <tr> <td class="navbar"> </td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //Written by Tom Bartolucci 2005 //Basica login sets the SESSION and COOKIE for this RefDB user $_SESSION["passwd"] = $passwd; $_SESSION["name"] = $name; $_SESSION["database"] = $database; setcookie(session_name(),session_id(), time()+7200); ?> <html> <head> <title>Logging In...</title> <meta http-equiv="REFRESH" content="0; URL=refdbquery.html"> </head> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <!-- Using the RefDB interface general template this file processes deleting a reference entry, as well as adding and removing from personal reference lists --> <html> <head> <title>RefDB query results</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Results</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <table border> <thead> <tr> <td class="result"> <form action="refdbsearch.php" method="post"> </td> </tr> </thead> <tbody> <? require_once("include.php"); $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; //begin to build the command to send to refdbc $cmd = "refdbc -c stdout -d $database -u $name -w $passwd -C "; if( isset($deleteref) ) //if you're deleting a reference { $cmd = $cmd."deleteref "; } else if( isset($pickref) ) //if you're adding it to your personal list { $cmd = $cmd."pickref "; } else if( isset($unpickref) ) //if you're removing it from your personal list { $cmd = $cmd."pickref -r "; } else //if somehow you get to this page not from the search results { print "Error!"; } //This for loop concatenates the references to be deleted/added/removed for( $checkboxNumber = 1; $checkboxNumber <= $numberOfCheckBoxes; $checkboxNumber++) { $checkIndex = "checkbox".$checkboxNumber; if( isset($_POST[$checkIndex] ) ) //if the box is checked { $number = $_POST[$checkIndex]; $cmd = $cmd.$number." "; //concatenate to the list } } exec($cmd, $lines); //execute the command foreach($lines as $line) //print the output { print $line."<br>\n"; } print "<br><br>"; //These variables are used if you return to the Search Results print "<input type='hidden' name='return' value='$terms'>\n"; print "<input type='hidden' name='scope' value='$scope'>\n"; print "<input type='submit' name='sendQuery' value='Return to Search Results'>\n"; ?> </tbody> </table> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB add form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Add Reference Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p>Add new references</p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbadd.php" method="post" enctype="multipart/form-data"> <input type="hidden" name="MAX_FILE_SIZE" value="40000000000"> <h2>Add a reference</h2> <p><input type="radio" name="addformat" value="ris" checked="checked">RIS <input type="radio" name="addformat" value="bib2ris">BibTeX<input type="radio" name="addformat" value="med2ris.pl">Pubmed </p> <textarea name="addref" rows="25" cols="80"></textarea> <p><input type="submit" name="submit" value="Add"><input type="reset" value="Reset form"></p> <p> </p> <h2>Upload a file containing references</h2> <p><input type="file" name="referencefile"></p> <p><input type="submit" name="submit" value="Add File"></p> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB add form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Add Reference Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p>Add new references</p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? if( $submit == "Add" ) { //if nothing was entered into the add reference text box if( empty($addref) ) { print "Error: No Reference data was entered."; } //Data was entered else { //This set of elseifs was written based on the simple check //in the original access.js file included in the old RefDB //interface. It checks to make sure necessary text for the //particular reference type is there $correct = false; if( $addformat == "ris" ) //RIS format { if( ereg("TY - ",$addref) ) $correct = true; else print "This does not look like RIS data.<br>\n"; } else if( $addformat == "bib2ris" ) //BibTeX format { if( ereg("@", $addref) ) $correct = true; else print "This does not look like BibTeX data.<br>\n"; } else if( $addformat == "med2ris.pl" ) //PubMed { if( ereg("PMID", $addref) ) $correct = true; else print "This does not look like PubMed data.<br>\n"; } //If the reference passes the checks if( $correct ) { $addref_lines = explode("\r\n",$addref); //create a temporary file with the reference in it $handle = fopen("tempref","wb"); foreach($addref_lines as $arl) { fwrite($handle, $arl."\n"); } fclose($handle); $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; //refdbc command to add a reference $cmd = "refdbc -c stdout -u $name -w $passwd -C addref -d $database < tempref"; exec($cmd, $lines); unlink("tempref"); //delete the temp file //print the output foreach($lines as $line) { print $line."<br>\n"; } } print "<br><a href='refdbadd.html'>Add another Reference</a>\n"; } } elseif( $submit == "Add File" ) { if ($referencefile == "none") { echo "Problem: no File Selected"; exit; } if ($referencefile_size==0) { echo "Problem: File is of size zero"; exit; } if (!is_uploaded_file($referencefile)) { echo "File not uploaded successfully"; exit; } if( !move_uploaded_file($referencefile, $referencefile_name) ) { echo "Problem: Could not upload file onto Server"; exit; } $cmd = "refdbc -u $name -w $passwd -d $database -c stdout -C addref $referencefile_name"; exec($cmd, $lines); foreach($lines as $line) { print "$line<br>"; } } ?> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Admin Interface</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <script language="Javascript"></script> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>RefDB Admin Interface</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; ?> <form action="admin.php" method="post"> <!-- ***************************** ADD USER ******************************** --> <h2>Add User</h2> <p>Username: <input type="text" name="user" size="30"></p> <p>Password: <input type="password" name="pass" size="30"></p> <p>Confirm Password: <input type="password" name="passcfm" size="30"></p> <p>To Database: <select name="adduserdb"> <option value='' selected> -- </option> <? //command to list the databases available $listdb = "refdba -u $name -w $passwd -c stdout -C listdb"; exec($listdb, $dblines); foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Add User"></p> <hr> <!-- **************************** REMOVE USER ***************************** --> <h2>Remove User</h2> <!--Utilize javascript to refresh the page with the new data based on the selection of a database --> <p>From Database: <select name="rmuserdb" onchange="window.location=('refdbadmin.php?dbselected=true&db='+this.options[this.selectedIndex].value)"> <? //If a database hasn't been selected select the blank entry print "<option value=' '"; if( !isset($dbselected ) ) { print " selected"; } print "> -- </option>\n"; foreach($dblines as $dbline) { //once a database has been selected select that database print "<option value='$dbline'"; if( isset($dbselected) && $db == $dbline ) { print " selected"; } print ">$dbline</option>\n"; } ?> </select></p> <? //Display the users for that database if(isset($dbselected)) { //command to list users of a specific database $listuser = "refdba -u $name -w $passwd -c stdout -d $db -C listuser"; exec($listuser, $userlines); //create dropdown for the users print "<p>User: <select name='rmuser'>\n"; foreach($userlines as $userline) { print "<option value='$userline'>$userline</option>\n"; } print "</select></p>\n"; } ?> <p><input type="submit" name="submit" value="Remove User"></p> <!-- ********************************** CREATE DATABASE **************************** --> <hr> <h2>Create Database</h2> <p>Database Name: <input type="text" name="newdb" size="30"></p> <p><input type="submit" name="submit" value="Add Database"></p> <!-- ********************************* REMOVE DATABASE ***************************** --> <hr> <h2>Remove Database</h2> <p><select name="removedb"> <option value='' selected> -- </option> <? //list databases foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Remove Database"></p> <!-- ***************************** SCHEDULE A KEYWORD SCAN ************************* --> <hr> <h2>Schedule a Keyword Scane</h2> <p><select name="scandb"> <option value=' ' selected> -- </option> <? foreach($dblines as $dbline) { print "<option value='$dbline'>$dbline</option>\n"; } ?> </select></p> <p><input type="submit" name="submit" value="Scan Database"></p> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB Database query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Database Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p>Change database</p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbdbquery.php" method="post"> <? //If the user changed databases, set the SESSION variable if( isset($submit) ) { $_SESSION["database"] = $db; } $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; print "Your current database is: <b>$database</b><br>\n"; //build comand to display databases $cmd = "refdbc -u $name -w $passwd -c stdout -C listdb"; exec($cmd,$lines); print "<p><select name='db'>\n"; foreach($lines as $line) { print "<option value='$line'>$line</option>\n"; } print "</select></p>\n"; print "<p><input type='submit' name='submit' value='Change Database'></p>\n"; ?> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Keyword, Author, Journal Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p>Search keywords, authors, journals</p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbkajsearch.php" method="post"> <h2>Query</h2> <p> <input type="text" name="kajquery"> in <select name="kajqueryfield"> <option value="keyword">keywords</option> <option value="author">authors</option> <option value="editor">editors</option> <option value="seditor">series editors</option> <option value="journalfull">journal (full)</option> <option value="journalabbrev">journal (abbrev.)</option> <option value="journalcustabbrev1">journal (custom abbrev. 1)</option> <option value="journalcustabbrev2">journal (custom abbrev. 2)</option> </select> </p> <input type="submit" value="Send query"><input type="reset" value="Reset form"> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? //This function sets the proper refdbc command depending //on the field that you're searching for function selectField($kajqueryfield) { $get = ""; switch($kajqueryfield) { case "keyword": $get = "getkw"; break; case "author": $get = "getau"; break; case "editor": $get = "geted"; break; case "seditor": $get = "getas"; break; case "journalfull": $get = "getjf"; break; case "journalabbrev": $get = "getjo"; break; case "journalabbrev1": $get = "getj1"; break; case "journalabbrev2": $get = "getj2"; break; } return $get; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Keyword, Author, Journal Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p>Search keywords, authors, journals</p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $database = $_SESSION["database"]; //build the command $cmd = "refdbc -u $name -w $passwd -d $database -c stdout -C "; $get = selectField($kajqueryfield); //kajquery is the search term $cmd = $cmd.$get." ".$kajquery; ?> <h2>Results</h2> <table border> <thead><tr> <th class="result">Matching <?$kajqueryfield?>(s)</th> </tr> </thead> <tbody> <? exec($cmd, $lines); foreach($lines as $line) { print "<tr><td class='result'>$line</td></tr>\n"; } ?> </tbody> </table> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB logout page</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Logout</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <? //Destroy session and cookie variables setcookie(session_name(), "", time()-3600); session_destroy(); ?> <p>You finished your RefDB session.</p> <p><a href="index.html">Start a new session</a></p> </td> </tr> <tr> <td class="navbar"> </td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- table {border-width:1; border-style:solid; border-color:#E7E7E7; background-color:#FFFFFF;} td.navbar {border-width:1; border-style:solid; border-color:#4E6DD2; background-color:#4E6DD2; color:#FFFFFF} td.main {border-width:1; border-style:solid; border-color:#E7E7E7; background-color:#E7E7E7;} td.result {border-width:1; border-style:solid; border-color:#000000; background-color:#FFFFFF;} th.result {border-width:1; border-style:solid; border-color:#000000; background-color:#BEE1F0;} td.footer {border-width:1; border-style:solid; border-color:#4E6DD2; background-color:#AAAAAA;} a:link {color:#000000; font-weight:bold;} a:visited {color:#FF4040; font-weight:bold;} --- NEW FILE --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query form</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Reference Query Form</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p>Search references</p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <form action="refdbsearch.php" method="post"> <p>Display also the following fields:</p> <p> <input type="checkbox" name="Notes" value="N1">Notes <input type="checkbox" name="Abstract" value="N2">Abstract <input type="checkbox" name="Address" value="AD">Address <input type="checkbox" name="Reprint" value="RP">Reprint <input type="checkbox" name="ISSN" value="SN">ISSN <input type="checkbox" name="URL" value="UR">URL <input type="checkbox" name="Publisher" value="PB">Publisher <input type="checkbox" name="City" value="CY">City <input type="checkbox" name="U1" value="U1">U1 <input type="checkbox" name="U2" value="U2">U2 <input type="checkbox" name="U3" value="U3">U3 <input type="checkbox" name="U4" value="U4">U4 <input type="checkbox" name="U5" value="U5">U5 <input type="checkbox" name="M1" value="M1">M1 <input type="checkbox" name="M2" value="M2">M2 <input type="checkbox" name="M3" value="M3">M3 </p> <p>Scope of your query: <select name="scope"> <option value="full">full reference list</option> <option value="prl">personal reference list</option> </select> </p> <hr> <h2>Simple query</h2> <p> Is <select name="simpquery1equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery1"> in <select name="simpquery1field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery1op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery2equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery2"> in <select name="simpquery2field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery2op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery3equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery3"> in <select name="simpquery3field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> <select name="simpquery3op"> <option value="and">AND</option> <option value="or">OR</option> <option value="not">NOT</option> </select> </p> <p> Is <select name="simpquery4equals"> <option value="exact">EXACTLY</option> <option value="like" selected>LIKE</option> </select> <input type="text" name="simpquery4"> in <select name="simpquery4field"> <option value="author">author</option> <option value="editor">editor</option> <option value="seditor">series editor</option> <option value="title">title</option> <option value="booktitle">book title</option> <option value="seriestitle">series title</option> <option value="journaltitle">journal title</option> <option value="keyword">keyword</option> </select> </p> <input type="submit" name="sendQuery" value="Send Simple query"><input type="reset" value="Reset form"> <hr> <h2>Advanced query</h2> <p>Query string: <input type="text" name="advquery" size="40" maxlength="2048"></p> <input type="submit" name="sendQuery" value="Send Advanced query"><input type="reset" value="Reset form"> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> --- NEW FILE --- <? require_once("include.php"); //This function builds the string for the display fields option //It uses the morefields array to associate the html value with //the refdbc identified value function setSearchFields($_POST, $morefields) { $searchFields = ""; while( list($key,$val) = each($morefields)) { if(isset($_POST[$key]) ) { $searchFields .= $val; } } if( $searchFields == "" ) { $searchFields = "ALL"; } return $searchFields; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>RefDB query results</title> <link href="refdbq.css" type="text/css" rel="stylesheet"> </head> <body> <table width="100%" cellspacing="0" border> <tbody valign="top"> <tr> <td class="navbar" width="25%"><h1>RefDB</h1></td> <td class="main"><h1>Query Results</h1></td> </tr> <tr> <td class="navbar"> </td> <td class="main"> </td> </tr> <tr> <td class="navbar"> <p><a href="refdbquery.html">Search references</a></p> <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p> <p><a href="refdbadd.html">Add new references</a></p> <p><a href="refdbdbquery.php">Change database</a></p> <p><a href="refdblogout.php">Logout</a></p> </td> <td class="main"> <table border> <thead><tr><th class="result">Matching References</th></tr> <tr><td class="result"> <form action="refdb-prl-del.php" method="post"> <input type="submit" value="Delete selected references" name="deleteref"> <input type="submit" value="Add selected references to Personal List" name="pickref"> <input type="submit" value="Remove selected references from Personal List" name="unpickref"></td></tr></thead><tbody> <? $database = $_SESSION["database"]; $name = $_SESSION["name"]; $passwd = $_SESSION["passwd"]; $cmd = "refdbc -c stdout -d $database -u $name -w $passwd -F "; $searchFields = setSearchFields($_POST, $morefields); $cmd = $cmd.$searchFields." -C getref "; //Search just the personal reference list if($scope == "prl") { $cmd = $cmd."-p "; } $terms = ""; //The following if sets the query for the Simple Query //It builds the refdbc query using the fields and ops arrays //from include.php if( $sendQuery == "Send Simple query") { $first = true; if( $simpquery1 != "" ) { $field1 = $fields[$simpquery1field]; $equals1 = $equals[$simpquery1equals]; $terms = $terms.$field1.$equals1.$simpquery1." "; $first = false; } if( $simpquery2 != "" ) { $field2 = $fields[$simpquery2field]; $equals2 = $equals[$simpquery2equals]; if( $first) { $terms = $terms.$field2.$equals2.$simpquery2." "; $first = false; } else { $op1 = $ops[$simpquery1op]; $terms = $terms.$op1." ".$field2.$equals2.$simpquery2." "; } } if( $simpquery3 != "" ) { $field3 = $fields[$simpquery3field]; $equals3 = $equals[$simpquery3equals]; if( $first) { $terms = $terms.$field3.$equals3.$simpquery3." "; $first = false; } else { $op2 = $ops[$simpquery2op]; $terms = $terms.$op2." ".$field3.$equals3.$simpquery3." "; } } if( $simpquery4 != "" ) { $field4 = $fields[$simpquery4field]; $equals4 = $equals[$simpquery4equals]; if( $first) { $terms = $terms.$field4.$equals4.$simpquery4." "; $first = false; } else { $op3 = $ops[$simpquery3op]; $terms = $terms.$op3." ".$field4.$equals4.$simpquery4." "; } } } //Build the advance query else if( $sendQuery == "Send Advanced query" ) { $terms = $advquery; } //Query terms if you've returned from a search else if( $sendQuery == "Return to Search Results" ) { $terms = $return; } $cmd = $cmd.$terms; exec($cmd, $lines); ?><tr><td><div><? $checkboxNumber = 0; //If the search generates no results if( count($lines) <=1 ) { print "<br>Your Search for <b>$terms</b> generated no results<br><br>\n"; print $cmd; } //Your search generated results display them else { foreach( $lines as $line ) { //If this is the first line of a new reference it will contain the ID field if( substr($line,0,2) == "ID" ) { print "</div></td></tr>\n"; print "<tr><td class='result'>\n"; //strip the ID number out of the reference $colon = strpos($line, ':'); $space = strpos($line, " "); $id = substr($line,$colon+1,$space-$colon-1); ++$checkboxNumber; print "<input type='checkbox' name='checkbox$checkboxNumber' value='$id'> \n"; print "<input type='submit' value='Edit' name='editid$id'>\n"; print "<div class='record'>\n"; print "<h2 class='ID'>$line</h2>\n"; } else { print "$line<br>\n"; } } } print "<input type='hidden' name='terms' value='$terms'>\n"; print "<input type='hidden' name='scope' value='$scope'>\n"; print "<input type='hidden' name='numberOfCheckBoxes' value='$checkboxNumber'>\n"; ?> </tbody> </table> </form> </td> </tr> <tr> <td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td> <td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->0.9.5<!--/VERSION--></p></td> </tr> </tbody> </table> </body> </html> |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 13:21:27
|
Update of /cvsroot/refdb/refdb/phpweb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4988/phpweb Log Message: Directory /cvsroot/refdb/refdb/phpweb added to the repository |
|
From: TomBartolucci <tba...@us...> - 2005-09-07 12:41:27
|
Update of /cvsroot/refdb/refdbphp In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28689 Log Message: Status: Vendor Tag: tcvs-vendor Release Tags: tcvs-release No conflicts created by this import ***** Bogus filespec: - ***** Bogus filespec: Imported ***** Bogus filespec: sources |
|
From: Markus H. <mho...@us...> - 2005-08-21 16:07:12
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28042/src Modified Files: Tag: Release_0_9_5_stable refdbdbib.c Log Message: getbib():added month and day to bib sorting order Index: refdbdbib.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbdbib.c,v retrieving revision 1.36.2.21 retrieving revision 1.36.2.22 diff -u -U2 -r1.36.2.21 -r1.36.2.22 --- refdbdbib.c 29 Jul 2005 21:15:41 -0000 1.36.2.21 +++ refdbdbib.c 21 Aug 2005 16:07:03 -0000 1.36.2.22 @@ -364,80 +364,88 @@ if (!strcmp(ptr_clrequest->dbserver, "mysql")) { - sprintf(sql_command, "CREATE TEMPORARY TABLE %s (id BIGINT NOT NULL AUTO_INCREMENT, \ - dbname VARCHAR(64), \ - orig_id BIGINT, \ - entry_id BLOB, \ - article_title BLOB, \ - author_concat BLOB, \ - periodical VARCHAR(255), \ - volume VARCHAR(255), \ - issue VARCHAR(255), \ - startpage VARCHAR(255), \ - pubyear SMALLINT, \ - citation_pos INT, \ - xref_pos INT, \ - multi_id BLOB, \ - sorted_pos INT DEFAULT 1, \ - author_abbrevlist BLOB, \ - year_uni_suffix VARCHAR(16), \ - PRIMARY KEY (id))", table_name); + sprintf(sql_command, + "CREATE TEMPORARY TABLE %s (id BIGINT NOT NULL AUTO_INCREMENT," + "dbname VARCHAR(64)," + "orig_id BIGINT," + "entry_id BLOB," + "article_title BLOB," + "author_concat BLOB," + "periodical VARCHAR(255)," + "volume VARCHAR(255)," + "issue VARCHAR(255)," + "startpage VARCHAR(255)," + "pubyear SMALLINT," + "monthday VARCHAR(16)," + "citation_pos INT," + "xref_pos INT," + "multi_id BLOB," + "sorted_pos INT DEFAULT 1," + "author_abbrevlist BLOB," + "year_uni_suffix VARCHAR(16)," + "PRIMARY KEY (id))", table_name); } else if (!strcmp(ptr_clrequest->dbserver, "pgsql")) { - sprintf(sql_command, "CREATE TEMPORARY TABLE %s (id BIGSERIAL, \ - dbname VARCHAR(64), \ - orig_id BIGINT, \ - entry_id TEXT, \ - article_title TEXT, \ - author_concat TEXT, \ - periodical VARCHAR(255), \ - volume VARCHAR(255), \ - issue VARCHAR(255), \ - startpage VARCHAR(255), \ - pubyear SMALLINT, \ - citation_pos INTEGER, \ - xref_pos INTEGER, \ - multi_id TEXT, \ - sorted_pos INTEGER DEFAULT 1, \ - author_abbrevlist TEXT, \ - year_uni_suffix VARCHAR(16), \ - PRIMARY KEY (id))", table_name); + sprintf(sql_command, + "CREATE TEMPORARY TABLE %s (id BIGSERIAL," + "dbname VARCHAR(64)," + "orig_id BIGINT," + "entry_id TEXT," + "article_title TEXT," + "author_concat TEXT," + "periodical VARCHAR(255)," + "volume VARCHAR(255)," + "issue VARCHAR(255)," + "startpage VARCHAR(255)," + "pubyear SMALLINT," + "monthday VARCHAR(16)," + "citation_pos INTEGER," + "xref_pos INTEGER," + "multi_id TEXT," + "sorted_pos INTEGER DEFAULT 1," + "author_abbrevlist TEXT," + "year_uni_suffix VARCHAR(16)," + "PRIMARY KEY (id))", table_name); } else if (!strcmp(ptr_clrequest->dbserver, "sqlite")) { - sprintf(sql_command, "CREATE TEMPORARY TABLE %s (id INTEGER PRIMARY KEY, \ - dbname VARCHAR(64), \ - orig_id INTEGER, \ - entry_id TEXT, \ - article_title TEXT, \ - author_concat TEXT, \ - periodical TEXT, \ - volume TEXT, \ - issue TEXT, \ - startpage TEXT, \ - pubyear SMALLINT, \ - citation_pos INTEGER, \ - xref_pos INTEGER, \ - multi_id TEXT, \ - sorted_pos INTEGER DEFAULT 1, \ - author_abbrevlist TEXT, \ - year_uni_suffix TEXT)", table_name); + sprintf(sql_command, + "CREATE TEMPORARY TABLE %s (id INTEGER PRIMARY KEY," + "dbname VARCHAR(64)," + "orig_id INTEGER," + "entry_id TEXT," + "article_title TEXT," + "author_concat TEXT," + "periodical TEXT," + "volume TEXT," + "issue TEXT," + "startpage TEXT," + "pubyear SMALLINT," + "monthday TEXT," + "citation_pos INTEGER," + "xref_pos INTEGER," + "multi_id TEXT," + "sorted_pos INTEGER DEFAULT 1," + "author_abbrevlist TEXT," + "year_uni_suffix TEXT)", table_name); } else if (!strcmp(ptr_clrequest->dbserver, "sqlite3")) { - sprintf(sql_command, "CREATE TEMPORARY TABLE %s (id INTEGER PRIMARY KEY, \ - dbname VARCHAR(64), \ - orig_id BIGINT, \ - entry_id TEXT, \ - article_title TEXT, \ - author_concat TEXT, \ - periodical TEXT, \ - volume TEXT, \ - issue TEXT, \ - startpage TEXT, \ - pubyear SMALLINT, \ - citation_pos INTEGER, \ - xref_pos INTEGER, \ - multi_id TEXT, \ - sorted_pos INTEGER DEFAULT 1, \ - author_abbrevlist TEXT, \ - year_uni_suffix TEXT)", table_name); + sprintf(sql_command, + "CREATE TEMPORARY TABLE %s (id INTEGER PRIMARY KEY," + "dbname VARCHAR(64)," + "orig_id BIGINT," + "entry_id TEXT," + "article_title TEXT," + "author_concat TEXT," + "periodical TEXT," + "volume TEXT," + "issue TEXT," + "startpage TEXT," + "pubyear SMALLINT," + "monthday TEXT," + "citation_pos INTEGER," + "xref_pos INTEGER," + "multi_id TEXT," + "sorted_pos INTEGER DEFAULT 1," + "author_abbrevlist TEXT," + "year_uni_suffix TEXT)", table_name); } @@ -588,21 +596,21 @@ } else if (strcmp(intextsequence, "AUTHORDATE") == 0) { - sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, author_concat, pubyear, periodical, volume, issue, startpage", table_name); + sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, author_concat, pubyear, monthday, periodical, volume, issue, startpage", table_name); } else if (strcmp(intextsequence, "DATEASC") == 0) { - sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, pubyear, author_concat, periodical, volume, issue, startpage", table_name); + sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, pubyear, monthday, author_concat, periodical, volume, issue, startpage", table_name); } else if (strcmp(intextsequence, "DATEDESC") == 0) { - sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, pubyear DESC, author_concat, periodical, volume, issue, startpage", table_name); + sprintf(sql_command, "SELECT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY citation_pos, pubyear DESC, monthday DESC, author_concat, periodical, volume, issue, startpage", table_name); } } else if (strcmp(bibsequence, "BAUTHORDATE") == 0) { - sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY author_concat, pubyear, volume, issue, article_title, periodical, startpage", table_name); + sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY author_concat, pubyear, monthday, volume, issue, article_title, periodical, startpage", table_name); } else if (strcmp(bibsequence, "BDATEASC") == 0) { - sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY pubyear, author_concat, volume, issue, article_title, periodical, startpage", table_name); + sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY pubyear, monthday, author_concat, volume, issue, article_title, periodical, startpage", table_name); } else if (strcmp(bibsequence, "BDATEDESC") == 0) { - sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY pubyear DESC, author_concat, volume, issue, article_title, periodical, startpage", table_name); + sprintf(sql_command, "SELECT DISTINCT dbname, orig_id, author_concat, pubyear, article_title, periodical, volume, issue, startpage, entry_id, year_uni_suffix, sorted_pos FROM %s ORDER BY pubyear DESC, monthday DESC, author_concat, volume, issue, article_title, periodical, startpage", table_name); } |
|
From: Markus H. <mho...@us...> - 2005-08-19 00:30:14
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17791 Modified Files: Tag: Release_0_9_5_stable med2ris.in Log Message: fixed erroneous month and day entries popping up in pubdates Index: med2ris.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/med2ris.in,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -U2 -r1.1.2.1 -r1.1.2.2 --- med2ris.in 29 Mar 2005 20:32:16 -0000 1.1.2.1 +++ med2ris.in 17 Aug 2005 19:53:20 -0000 1.1.2.2 @@ -468,4 +468,12 @@ %currpubdate = (); } + elsif ($elname eq "DateCreated" + || $elname eq "DateCompleted" + || $elname eq "DateRevised" + || $elname eq "PubMedPubDate") { + + ## these dates are currently not evaluated. However, as they may contain year, month, and day elements, we have to reset the pool + %currpubdate = (); + } elsif ($elname eq "ArticleTitle" && length($elvalue) > 0) { $alloutstring .= "TI - $elvalue\n"; |
|
From: Markus H. <mho...@us...> - 2005-08-15 00:22:09
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26911/src Modified Files: Tag: Release_0_9_5_stable refdbda.c Log Message: viewstat output now uses new libdbi function to retrieve engine version Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.16 retrieving revision 1.41.2.17 diff -u -U2 -r1.41.2.16 -r1.41.2.17 --- refdbda.c 29 Jul 2005 21:15:41 -0000 1.41.2.16 +++ refdbda.c 15 Aug 2005 00:21:55 -0000 1.41.2.17 @@ -464,9 +464,9 @@ dbi_driver driver; /* libdbi driver structure */ dbi_result dbires; /* libdbi result structure */ - short int dbversioninfo = 0; char* outstring; /* ptr to a buffer for output */ char* outbuffer; /* ptr to a buffer for output */ - const char* versioninfo = NULL; + short int dbversioninfo; char sql_command[64]; + char db_version[VERSIONSTRING_LENGTH]; /* get a buffer to hold output data */ @@ -501,15 +501,6 @@ /* obtain database server version info */ - sprintf(sql_command, "SELECT VERSION()"); - dbires = dbi_conn_query(conn, sql_command); - LOG_PRINT(LOG_DEBUG, sql_command); - if (dbires) { - if (dbi_result_next_row(dbires)) { - versioninfo = dbi_result_get_string_idx(dbires, 1); /* 1-base index */ - } - } - /* else: treat as non-critical as some db engines do not support this - SQL command */ - + dbi_conn_get_engine_version_string(conn, db_version); + sprintf(outbuffer, "You are served by: %s %s\nClient IP: %s\nConnected via %s driver (%s)\nto: %s\ndb version: %d\nserverip: %s\ntimeout: %s\ndbs_port: %s\nlogfile: %s\nlogdest: %s\nloglevel: %s\nremoteadmin: %s\npidfile: %s\n", PACKAGE, @@ -518,5 +509,5 @@ dbi_driver_get_name(driver), dbi_driver_get_version(driver), - (versioninfo) ? versioninfo : "unknown", + db_version, dbversioninfo, ptr_clrequest->server_ip, @@ -529,8 +520,4 @@ pid_file); - if (dbires) { - dbi_result_free(dbires); - } - /* all fine */ send_status(ptr_clrequest->fd, 0, TERM_NO); |
|
From: Markus H. <mho...@us...> - 2005-08-15 00:21:18
|
Update of /cvsroot/refdb/refdb/doc/include In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26816/include Modified Files: Tag: Release_0_9_5_stable doc-print.dsl Log Message: switched off formal object floats to fix tables Index: doc-print.dsl =================================================================== RCS file: /cvsroot/refdb/refdb/doc/include/Attic/doc-print.dsl,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -U2 -r1.1.2.1 -r1.1.2.2 --- doc-print.dsl 14 Aug 2005 00:34:32 -0000 1.1.2.1 +++ doc-print.dsl 15 Aug 2005 00:21:09 -0000 1.1.2.2 @@ -62,5 +62,5 @@ (define formal-object-float ;; Do formal objects float? - #t) + #f) (define %hyphenation% |
|
From: Markus H. <mho...@us...> - 2005-08-15 00:20:32
|
Update of /cvsroot/refdb/refdb/doc/include In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26675/include Modified Files: Tag: Release_0_9_5_stable doc-html.dsl Log Message: use png Index: doc-html.dsl =================================================================== RCS file: /cvsroot/refdb/refdb/doc/include/Attic/doc-html.dsl,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -U2 -r1.1.2.1 -r1.1.2.2 --- doc-html.dsl 14 Aug 2005 00:34:32 -0000 1.1.2.1 +++ doc-html.dsl 15 Aug 2005 00:20:23 -0000 1.1.2.2 @@ -72,5 +72,5 @@ (define %graphic-default-extension% - "gif") + "png") (define %section-autolabel% |
1 message has been excluded from this view by a project administrator.
