| Server IP : 104.20.45.2 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/dbscripts/xml/upgrade/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">
<!--
* 2.0.1_update.xml
*
* Copyright (c) 2013-2019 Simon Fraser University
* Copyright (c) 2003-2019 John Willinsky
* Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
*
* 2.0.1 database updates XML file.
*
-->
<data>
<!-- Bug #1637 -->
<sql>
<query>
UPDATE journal_settings
SET setting_type = 'int'
WHERE setting_name = 'enableComments'
</query>
<query>
UPDATE journal_settings
SET setting_value = '3'
WHERE setting_name = 'enableComments'
AND setting_value = 'unauthenticated'
</query>
<query>
UPDATE journal_settings
SET setting_value = '0'
WHERE setting_name = 'enableComments'
AND setting_value = 'disabled'
</query>
<query>
UPDATE journal_settings
SET setting_value = '1'
WHERE setting_name = 'enableComments'
AND setting_value = 'authenticated'
</query>
<query>
UPDATE journal_settings
SET setting_value = '2'
WHERE setting_name = 'enableComments'
AND setting_value = 'anonymous'
</query>
<query>
UPDATE journal_settings
SET setting_value = '3'
WHERE setting_name = 'enableComments'
AND setting_value = 'unauthenticated'
</query>
</sql>
<!-- Bug #1650 -->
<sql>
<query>
UPDATE rt_searches
SET url = 'http://pkp.sfu.ca/harvester/'
WHERE url = 'http://www.pkp.ubc.ca/harvester/'
</query>
<query>
UPDATE rt_searches
SET search_url = 'http://pkp.sfu.ca/harvester/search.php?limit=author&query='
WHERE search_url = 'http://www.pkp.ubc.ca/harvester/search.php?limit=author&query='
</query>
<query>
UPDATE rt_searches
SET search_post = NULL,
search_url = 'http://epaa.asu.edu/cgi-bin/htsearch?method=boolean&format=builtin-long&sort=score&config=epaa.asu.edu&restrict=&exclude=&words='
WHERE search_url = 'http://epaa.asu.edu/cgi-bin/htsearch?'
</query>
<query>
UPDATE rt_searches
SET search_url = 'http://www.liszt.com/search/?search_type=cat&query='
WHERE search_url = '>http://www.liszt.com/search/?search_type=cat&query='
</query>
<query>
UPDATE rt_searches
SET url = 'http://www.fas.usda.gov/fassearch.asp'
WHERE url = 'http://www.fas.usda.gov/fassearc.htm'
</query>
<query>
UPDATE rt_searches
SET search_url = 'http://www.thescientificworld.com/SCIENTIFICWORLDJOURNAL/search/SearchResults.asp?From=Main&Terms='
WHERE search_url = 'http://www.thescientificworld.com/TSWPubs/Results.asp?SR=1&QR='
</query>
<query>
UPDATE rt_searches
SET search_url = 'http://www.a2a.org.uk/search/doclist.asp?nb=0&nbKey=1&com=1&properties=0601&keyword='
WHERE search_url = 'http://www4.nationalacademies.org/units.nsf/SearchView/?SearchView&SearchMax=30&SearchOrder=1&SmartSearch=Yes&Query='
</query>
<query>
UPDATE rt_searches
SET
url = 'http://citeseer.ist.psu.edu/cs',
search_url = 'http://citeseer.ist.psu.edu/cs?submit=Search+Documents&cs=1&q='
WHERE
url = 'http://citeseer.nj.nec.com/cs' AND
search_url = 'http://citeseer.nj.nec.com/cs?submit=Search+Documents&cs=1&q='
</query>
<query>
UPDATE rt_searches
SET search_url = 'http://www.data-archive.ac.uk/search/allSearch.asp?ct=xmlAll&zoom_and=1&q1='
WHERE search_url = 'http://www.data-archive.ac.uk/Search/SearchRight2.asp?ct=daw2ks2&q1='
</query>
</sql>
<!-- Bug #1657 -->
<sql>
<query>
UPDATE email_templates_default_data
SET body = '{$editorialContactName}:
The submission, "{$articleTitle}," to {$journalName} has been assigned to you to see through the editorial process in your role as Section Editor.
Submission URL: {$submissionUrl}
Username: {$editorUsername}
Thank you,
{$editorialContactSignature}'
WHERE email_key = 'EDITOR_ASSIGN'
</query>
</sql>
</data>