PHP mysql_connection_select函数代码示例

 function getReferenceTypes()
 {
     if (HeuristKMLParser::$_referenceTypes) {
         return array_keys($this->_referenceTypes);
     }
     mysql_connection_select(DATABASE);
     // saw TODO check that this is correct seems that it is trying order on non bib types.
     HeuristKMLParser::$_referenceTypes = mysql__select_assoc("defRecTypes ", "rty_Name", "rty_ID", "rty_ShowInLists = 1 order by rty_RecTypeGroupID = 2, rty_Name");
     return array_keys(HeuristKMLParser::$_referenceTypes);
 }

}
// end of error output
mysql_connection_insert(DATABASE);
$res = mysql_query('select snd_SimRecsList from recSimilarButNotDupes');
while ($row = mysql_fetch_assoc($res)) {
    array_push($dupeDifferences, $row['snd_SimRecsList']);
}
if ($_REQUEST['dupeDiffHash']) {
    foreach ($_REQUEST['dupeDiffHash'] as $diffHash) {
        if (!in_array($diffHash, $dupeDifferences)) {
            array_push($dupeDifferences, $diffHash);
            $res = mysql_query('insert into recSimilarButNotDupes values("' . $diffHash . '")');
        }
    }
}
mysql_connection_select(DATABASE);
//mysql_connection_select("`heuristdb-nyirti`");   //for debug
//FIXME  allow user to select a single record type
//$res = mysql_query('select rec_ID, rec_RecTypeID, rec_Title, dtl_Value from Records left join recDetails on dtl_RecID=rec_ID and dtl_DetailTypeID=160 where rec_RecTypeID != 52 and rec_RecTypeID != 55 and not rec_FlagTemporary order by rec_RecTypeID desc');
$crosstype = false;
$personMatch = false;
$relRT = defined('RT_RELATION') ? RT_RELATION : 0;
$perRT = defined('RT_PERSON') ? RT_PERSON : 0;
$surnameDT = defined('DT_GIVEN_NAMES') ? DT_GIVEN_NAMES : 0;
$titleDT = defined('DT_NAME') ? DT_NAME : 0;
if (@$_REQUEST['crosstype']) {
    $crosstype = true;
}
if (@$_REQUEST['personmatch']) {
    $personMatch = true;
    $res = mysql_query("select rec_ID, rec_RecTypeID, rec_Title, dtl_Value from Records left join recDetails on dtl_RecID=rec_ID and dtl_DetailTypeID={$surnameDT} where " . (strlen($recIDs) > 0 ? "rec_ID in ({$recIDs}) and " : "") . "rec_RecTypeID = {$perRT} and not rec_FlagTemporary order by rec_ID desc");

function get_location($key)
{
    mysql_connection_select("hapi");
    return mysql_fetch_assoc(mysql_query("select * from hapi_locations where hl_key='" . addslashes($key) . "'"));
}

* @author      Ian Johnson     <ian.johnson@sydney.edu.au>
* @license     http://www.gnu.org/licenses/gpl-3.0.txt GNU License 3.0
* @version     3.2
*/
/*
* Licensed under the GNU License, Version 3.0 (the "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at http://www.gnu.org/licenses/gpl-3.0.txt
* Unless required by applicable law or agreed to in writing, software distributed under the License is
* distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied
* See the License for the specific language governing permissions and limitations under the License.
*/
require_once dirname(__FILE__) . '/../../common/connect/applyCredentials.php';
if (isForAdminOnly("to get information on all databases on this server")) {
    return;
}
mysql_connection_select();
$dbs = mysql__getdatabases(true);
function mysql__select_val($query)
{
    $res = mysql_query($query);
    if (!$res) {
        return 0;
    }
    $row = mysql_fetch_array($res);
    if ($row) {
        return $row[0];
    } else {
        0;
    }
}
function dirsize($dir)

 /**
  * Connection to the database
  * @return void
  *
  */
 function _dbConnect()
 {
     mysql_connection_select(DATABASE);
 }

function searchWoots($args)
{
    mysql_connection_select(DATABASE);
    $text_search = getTextSearch($args["q"]);
    if (!$text_search) {
        return array("success" => false, "errorType" => "invalid query");
    }
    $res = mysql_query("select distinct woot_ID, woot_Title, woot_Version\n\t\t\t\t\t\t  from " . WOOT_TABLE . "," . CHUNK_TABLE . "\n\t\t\t\t\t\t where woot_ID=chunk_WootID and chunk_IsLatest and !chunk_Deleted\n\t\t\t\t\t\t\t   and " . $text_search . "\n\t\t\t\t\t\t\t   and chunk_ID in (" . join(",", getReadableChunks(NULL, true)) . ")");
    $woots = array();
    while ($woot = mysql_fetch_assoc($res)) {
        array_push($woots, array("id" => $woot["woot_ID"], "version" => $woot["woot_Version"], "title" => $woot["woot_Title"]));
    }
    return array("success" => true, "woots" => $woots);
}

/**
	* Returns array of mapobjects
 	$mapobjects = array(
		"records"=>$geoRecords,
		"geoObjects"=>$geoObjects,
		"cntWithGeo"=>$cnt_geo,
		"cntWithTime"=>$cnt_time,
		"layers"=>$layers);
*/
function getMapObjects($request)
{
    $imagelayerRT = defined('RT_IMAGE_LAYER') ? RT_IMAGE_LAYER : 0;
    $KMLlayerRT = defined('RT_KML_LAYER') ? RT_KML_LAYER : 0;
    mysql_connection_select(DATABASE);
    if (array_key_exists('layers', $request)) {
        //special mode - load ALL image layers and kml records only - for general drop down list on map
        $request['ver'] = "1";
        $request['q'] = "type:" . $imagelayerRT . "," . $KMLlayerRT;
        $search_type = BOTH;
    } else {
        if (!@$request['q'] || @$request['ver'] && intval(@$request['ver']) < SEARCH_VERSION) {
            construct_legacy_search();
        }
        // migration path
        if (@$request['w'] && ($request['w'] == 'B' || $request['w'] == 'bookmark')) {
            $search_type = BOOKMARK;
        } else {
            $search_type = BOTH;
        }
        // all records
    }
    if (!array_key_exists("limit", $request)) {
        //not defined
        $limit = intval(@$_SESSION[HEURIST_SESSION_DB_PREFIX . 'heurist']["display-preferences"]['report-output-limit']);
        if (!$limit || $limit < 1) {
            $limit = 1000;
            //default limit in dispPreferences
        }
        $request["limit"] = $limit;
        //force limit
    }
    // find all matching records
    $cols = "rec_ID as bibID, rec_RecTypeID as rectype, rec_Title as title, rec_URL as URL";
    $query = REQUEST_to_query("select {$cols} ", $search_type);
    /*****DEBUG****/
    // error_log("query=".$query);
    /*****DEBUG****/
    //error_log(">>>>>>>>>>>>>>>>>>>>>>>".$search_type."<<<<<<".$query);
    $res = mysql_query($query);
    if (mysql_error()) {
        print mysql_error();
    }
    $records = array();
    $bibIDs = array();
    $imageLayers = array();
    // list of ids of map image layers
    $geoObjects = array();
    // coordinates
    $geoBibIDs = array();
    // list of id of records that have geo references
    while ($bib = mysql_fetch_assoc($res)) {
        $bibID = $bib["bibID"];
        if (!$bibID) {
            continue;
        }
        $records[$bibID] = $bib;
        array_push($bibIDs, $bibID);
        if ($bib["rectype"] == $imagelayerRT) {
            //map image layer
            array_push($imageLayers, $bibID);
            $geoBibIDs[$bibID] = $bibID;
        }
    }
    foreach ($bibIDs as $bibID) {
        //0 DT_SHORT_SUMMARY
        //1 DT_EXTENDED_DESCRIPTION
        //2 - record URL
        //3 DT_FILE_RESOURCE
        //REMOVED 4 DT_LOGO_IMAGE
        //REMOVED 5 DT_THUMBNAIL
        //REMOVED 6 DT_IMAGES
        //4 7 DT_MAP_IMAGE_LAYER_REFERENCE
        //5 8 DT_KML
        //6 9 DT_KML_FILE
        //7 10 record type
        //d.dtl_UploadedFileID,e.dtl_UploadedFileID,f.dtl_UploadedFileID,
        //					0				1			2			3				4 imagelayer 5 kmltext		6 kmlfile				7			8
        $squery = "select a.dtl_Value, b.dtl_Value, rec_URL, c.dtl_UploadedFileID, g.dtl_Value, h.dtl_Value, i.dtl_UploadedFileID, rec_RecTypeID, rec_Title, j.dtl_Value\n\t\tfrom Records\n\t\tleft join recDetails a on a.dtl_RecID=rec_ID and a.dtl_DetailTypeID=" . (defined('DT_SHORT_SUMMARY') ? DT_SHORT_SUMMARY : "0") . " left join recDetails b on b.dtl_RecID=rec_ID and b.dtl_DetailTypeID=" . (defined('DT_EXTENDED_DESCRIPTION') ? DT_EXTENDED_DESCRIPTION : "0") . " left join recDetails c on c.dtl_RecID=rec_ID and c.dtl_DetailTypeID=" . (defined('DT_FILE_RESOURCE') ? DT_FILE_RESOURCE : "0") . " left join recDetails g on g.dtl_RecID=rec_ID and g.dtl_DetailTypeID=" . (defined('DT_MAP_IMAGE_LAYER_REFERENCE') ? DT_MAP_IMAGE_LAYER_REFERENCE : "0") . " left join recDetails h on h.dtl_RecID=rec_ID and h.dtl_DetailTypeID=" . (defined('DT_KML') ? DT_KML : "0") . " left join recDetails i on i.dtl_RecID=rec_ID and i.dtl_DetailTypeID=" . (defined('DT_KML_FILE') ? DT_KML_FILE : "0") . " left join recDetails j on j.dtl_RecID=rec_ID and j.dtl_DetailTypeID=" . (defined('DT_SHOW_IN_MAP_BG_LIST') ? DT_SHOW_IN_MAP_BG_LIST : "0") . " where rec_ID={$bibID}";
        //*****DEBUG****//error_log(">>>>>>QUERY=".$squery);
        $res = mysql_query($squery);
        $row = mysql_fetch_row($res);
        if ($row) {
            $records[$bibID]["recID"] = $bibID;
            $records[$bibID]["rectype"] = $row[7];
            $records[$bibID]["description"] = $row[0] ? $row[0] : ($row[1] ? $row[1] : "");
            $records[$bibID]["url"] = $row[2];
            //($row[2] ? "'".$row[2]."' target='_blank'"  :"'javascript:void(0);'");
            //'javascript:{this.href="'+$row[2]+'"}' : 'javascript:{return false;}');//javascript:void(0)}');
            $records[$bibID]["icon_url"] = HEURIST_ICON_SITE_PATH . $row[7] . ".png";
            $thumb_url = getThumbnailURL($bibID);
//.........这里部分代码省略.........

    $DTN[$row['dty_ID']] = $row['dty_Name'];
    $DTT[$row['dty_ID']] = $row['dty_Type'];
}
$INV = mysql__select_assoc('defTerms', 'trm_ID', 'trm_InverseTermID', '1');
// lookup detail type enum values
$query = 'SELECT trm_ID, trm_Label, trm_ParentTermID, trm_OntID FROM defTerms';
$res = mysql_query($query);
while ($row = mysql_fetch_assoc($res)) {
    $TL[$row['trm_ID']] = $row;
    $TLV[$row['trm_Label']] = $row;
}
/// group names
mysql_connection_select(USERS_DATABASE) or die(mysql_error());
$WGN = mysql__select_assoc('sysUGrps grp', 'grp.ugr_ID', 'grp.ugr_Name', "ugr_Type ='workgroup'");
$UGN = mysql__select_assoc('sysUGrps grp', 'grp.ugr_ID', 'grp.ugr_Name', "ugr_Type ='user'");
mysql_connection_select(DATABASE) or die(mysql_error());
$GEO_TYPES = array('r' => 'bounds', 'c' => 'circle', 'pl' => 'polygon', 'l' => 'path', 'p' => 'point');
// set parameter defaults
$MAX_DEPTH = @$_REQUEST['depth'] ? intval($_REQUEST['depth']) : 0;
// default to only one level
$REVERSE = @$_REQUEST['rev'] === 'no' ? false : true;
//default to including reverse pointers
$WOOT = @$_REQUEST['woot'] ? intval($_REQUEST['woot']) : 0;
//default to not output text content
$OUTPUT_STUBS = @$_REQUEST['stub'] === '1' ? true : false;
//default to not output stubs
$INCLUDE_FILE_CONTENT = @$_REQUEST['fc'] && $_REQUEST['fc'] == 0 ? false : true;
// default to expand xml file content
$SUPRESS_LOOPBACKS = @$_REQUEST['slb'] && $_REQUEST['slb'] == 0 ? false : true;
// default to supress loopbacks
// check filter string has restricted characters only

        <meta http-equiv="content-type" content="text/html; charset=utf-8">
        <link rel="stylesheet" type="text/css" href="../../common/css/global.css">
        <link rel="stylesheet" type="text/css" href="../../common/css/edit.css">
        <link rel="stylesheet" type="text/css" href="../../common/css/admin.css">
    </head>

    <body class="popup">
        <div class="banner"><h2>Modify group / admin status for session</h2></div>
        <div id="page-inner">
            <p>This page is designed for testing purposes. It allows you to exit a group, or relinquish administrator status for a group,
                for the rest of your session, in order to test the behaviour of a database as viewed by another class of user.
                Changes will not be saved to the database. Log out and log back in to restore your normal permissions.</p>

            <table>
            <?php 
mysql_connection_select(USERS_DATABASE);
$grp_ids = array_keys($_SESSION[HEURIST_SESSION_DB_PREFIX . 'heurist']["user_access"]);
$grp_names = mysql__select_assoc(GROUPS_TABLE, GROUPS_ID_FIELD, GROUPS_NAME_FIELD, GROUPS_ID_FIELD . " in (" . join(",", $grp_ids) . ")");
foreach ($grp_ids as $grp_id) {
    print "<tr><td>" . $grp_names[$grp_id] . "</td><td>";
    if ($_SESSION[HEURIST_SESSION_DB_PREFIX . 'heurist']["user_access"][$grp_id] == "admin") {
        print "<a href=?a={$grp_id}>-admin</a>";
    }
    print "</td><td><a href=?g={$grp_id}>exit</td></tr>";
}
?>
        </div>
    </body>
</html>

function getInvalidFieldTypes($rectype_id)
{
    global $TL, $RTN;
    mysql_connection_select(DATABASE);
    // lookup detail type enum values
    $query = 'SELECT trm_ID, trm_Label, trm_ParentTermID, trm_OntID, trm_Code FROM defTerms';
    $res = mysql_query($query);
    while ($row = mysql_fetch_assoc($res)) {
        $TL[$row['trm_ID']] = $row;
    }
    //record type name
    $query = 'SELECT rty_ID, rty_Name FROM defRecTypes';
    $res = mysql_query($query);
    while ($row = mysql_fetch_assoc($res)) {
        $RTN[$row['rty_ID']] = $row['rty_Name'];
    }
    //list of detail types to validate
    $DTT = array();
    $query = "SELECT dty_ID," . "dty_Name," . "dty_Type," . "dty_JsonTermIDTree," . "dty_TermIDTreeNonSelectableIDs," . "dty_PtrTargetRectypeIDs" . " FROM defDetailTypes";
    if (null != $rectype_id) {
        //detail types for given recordtype
        $query = $query . ", defRecStructure WHERE rst_RecTypeID=" . $rectype_id . " and rst_DetailTypeID=dty_ID and ";
    } else {
        $query = $query . " WHERE ";
    }
    $query = $query . "(dty_Type in ('enum','relationtype','relmarker','resource')" . " and (dty_JsonTermIDTree is not null or dty_TermIDTreeNonSelectableIDs is not null)) " . "or (dty_Type in ('relmarker','resource') and dty_PtrTargetRectypeIDs is not null)";
    $res = mysql_query($query);
    if ($res) {
        while ($row = mysql_fetch_assoc($res)) {
            $DTT[$row['dty_ID']] = $row;
        }
    }
    $dtysWithInvalidTerms = array();
    $dtysWithInvalidNonSelectableTerms = array();
    $dtysWithInvalidRectypeConstraint = array();
    foreach ($DTT as $dtyID => $dty) {
        if ($dty['dty_JsonTermIDTree']) {
            $res = getInvalidTerms($dty['dty_JsonTermIDTree'], true);
            $invalidTerms = $res[0];
            $validTermsString = $res[1];
            if (count($invalidTerms)) {
                $dtysWithInvalidTerms[$dtyID] = $dty;
                $dtysWithInvalidTerms[$dtyID]['invalidTermIDs'] = $invalidTerms;
                $dtysWithInvalidTerms[$dtyID]['validTermsString'] = $validTermsString;
            }
        }
        if ($dty['dty_TermIDTreeNonSelectableIDs']) {
            $res = getInvalidTerms($dty['dty_TermIDTreeNonSelectableIDs'], false);
            $invalidNonSelectableTerms = $res[0];
            $validNonSelTermsString = $res[1];
            if (count($invalidNonSelectableTerms)) {
                $dtysWithInvalidNonSelectableTerms[$dtyID] = $dty;
                $dtysWithInvalidNonSelectableTerms[$dtyID]['invalidNonSelectableTermIDs'] = $invalidNonSelectableTerms;
                $dtysWithInvalidNonSelectableTerms[$dtyID]['validNonSelTermsString'] = $validNonSelTermsString;
            }
        }
        if ($dty['dty_PtrTargetRectypeIDs']) {
            $res = getInvalidRectypes($dty['dty_PtrTargetRectypeIDs']);
            $invalidRectypes = $res[0];
            $validRectypes = $res[1];
            if (count($invalidRectypes)) {
                $dtysWithInvalidRectypeConstraint[$dtyID] = $dty;
                $dtysWithInvalidRectypeConstraint[$dtyID]['invalidRectypeConstraint'] = $invalidRectypes;
                $dtysWithInvalidRectypeConstraint[$dtyID]['validRectypeConstraint'] = $validRectypes;
            }
        }
    }
    //for
    return array("terms" => $dtysWithInvalidTerms, "terms_nonselectable" => $dtysWithInvalidNonSelectableTerms, "rt_contraints" => $dtysWithInvalidRectypeConstraint);
}

        if (!is_array($registeredDBs)) {
            if (defined("HEURIST_HTTP_PROXY")) {
                $data = loadRemoteURLContent($reg_url, false);
                //false = USE PROXY
                if ($data) {
                    $registeredDBs = json_decode($data);
                    if (!is_array($data)) {
                        $registeredDBs = array();
                    }
                }
            }
        }
    }
} else {
    // this is a connection on the same server as the master index
    mysql_connection_select("hdb_Heurist_Master_Index");
    //except specified databases
    if (@$_REQUEST['exclude']) {
        $exclude = explode(",", $_REQUEST['exclude']);
    } else {
        $exclude = array();
    }
    // Return all registered databases as a json string
    $query = 'select rec_ID, rec_URL, rec_Title, rec_Popularity, dtl_value as version ' . ' from Records left join recDetails on rec_ID=dtl_RecID and dtl_DetailTypeID=335 where `rec_RecTypeID`=22';
    if ($is_curated) {
        $query = $query . ' and rec_ID<1000';
    }
    $res = mysql_query($query);
    while ($registeredDB = mysql_fetch_array($res, MYSQL_ASSOC)) {
        if (!array_search($registeredDB['rec_ID'], $exclude)) {
            if ($is_named) {

* @version     3.1.0
* @license     http://www.gnu.org/licenses/gpl-3.0.txt GNU License 3.0
* @package     Heurist academic knowledge management system
* @subpackage  !!!subpackagename for file such as Administration, Search, Edit, Application, Library
*/
/**
 * filename, brief description, date of creation, by whom
 * @copyright (C) 2005-2010 University of Sydney Digital Innovation Unit.
 * @link: http://HeuristScholar.org
 * @license http://www.gnu.org/licenses/gpl-3.0.txt
 * @package Heurist academic knowledge management system
 * @todo
 **/
require_once dirname(__FILE__) . "/../../common/connect/applyCredentials.php";
require_once dirname(__FILE__) . "/../../common/php/dbMySqlWrappers.php";
mysql_connection_select("hapi");
if (!is_logged_in()) {
    /*
    	jsonError("no logged-in user");
    */
    $_REQUEST["crossSession"] = false;
}
$_REQUEST = json_decode(@$_POST["data"] ? $_POST["data"] : base64_decode(@$_GET["data"]), true);
$location = @$_REQUEST["crossDomain"] ? "*" : ($baseURL ? $baseURL : HEURIST_SERVER_NAME);
// TESTTHIS:  repalced heuristscholar.org with host name
$varName = $_REQUEST["name"];
if (preg_match("/^([a-zA-Z0-9_]+)((?:[.][a-zA-Z0-9_]+)+)\$/", $varName, $matches)) {
    $topLevelVarName = $matches[1];
    $innerVarPath = $matches[2];
    if (@$_REQUEST["crossSession"]) {
        // cross-session values are stored in the database

* @link        http://Sydney.edu.au/Heurist
* @version     3.1.0
* @license     http://www.gnu.org/licenses/gpl-3.0.txt GNU License 3.0
* @package     Heurist academic knowledge management system
* @subpackage  !!!subpackagename for file such as Administration, Search, Edit, Application, Library
*/
/**
 * getRegisteredDBs.php - Returns all databases and their URLs that are registered in the master Heurist index server,
 * Juan Adriaanse 27 May 2011. SERVER SIDE ONLY. ONLY ALLOW IN HEURISTSCHOLAR.ORG index database
 * @copyright (C) 2005-2010 University of Sydney Digital Innovation Unit.
 * @link: http://HeuristScholar.org
 * @license http://www.gnu.org/licenses/gpl-3.0.txt
 * @package Heurist academic knowledge management system
 * @todo
 **/
if (!@$_REQUEST['db']) {
    // be sure to override default this should only be called on the Master Index server so point db master index dbname
    $_REQUEST['db'] = "H3MasterIndex";
}
require_once dirname(__FILE__) . "/../../common/config/initialise.php";
require_once dirname(__FILE__) . '/../../common/php/dbMySqlWrappers.php';
mysql_connection_select("hdb_H3MasterIndex");
// Return all registered databases as a json string
$res = mysql_query("select rec_ID, rec_URL, rec_Title, rec_Popularity, dtl_value as version from Records left join recDetails on rec_ID=dtl_RecID and dtl_DetailTypeID=335 where `rec_RecTypeID`=22");
$registeredDBs = array();
while ($registeredDB = mysql_fetch_array($res, MYSQL_ASSOC)) {
    array_push($registeredDBs, $registeredDB);
}
$jsonRegisteredDBs = json_encode($registeredDBs);
echo $jsonRegisteredDBs;
//BEWARE: If there si some sort of error, nothjign gets returned and this should be trapped at ht otehr end (selectDBForImport.php)

        //take from database
        $res = mysql_query('select * from ' . USERS_TABLE . ' where ' . USERS_USERNAME_FIELD . ' = "' . addslashes($username) . '"');
        $user = mysql_fetch_assoc($res);
        if ($user) {
            $password = $user[USERS_PASSWORD_FIELD];
        } else {
            $password = "";
        }
        $needcrypt = false;
    } else {
        $username = $_REQUEST['username'];
        $password = $_REQUEST['password'];
        $needcrypt = true;
        //(array_key_exists('mode', $_REQUEST) && $_REQUEST['mode']=='2');
    }
    mysql_connection_select($db_prefix . $sourcedbname);
    $res = mysql_query('select * from ' . USERS_TABLE . ' where ' . USERS_USERNAME_FIELD . ' = "' . addslashes($username) . '"');
    $user = mysql_fetch_assoc($res);
    if ($user && $user[USERS_ACTIVE_FIELD] == 'y' && ($needcrypt && crypt($password, $user[USERS_PASSWORD_FIELD]) == $user[USERS_PASSWORD_FIELD] || !$needcrypt && $password == $user[USERS_PASSWORD_FIELD])) {
        $user_id_insource = $user[USERS_ID_FIELD];
        $user_workgroups = mysql__select_array('sysUsrGrpLinks left join sysUGrps grp on grp.ugr_ID=ugl_GroupID', 'ugl_GroupID', 'ugl_UserID=' . $user_id_insource . ' and grp.ugr_Type != "User" order by ugl_GroupID');
    } else {
        header('Location: ' . HEURIST_BASE_URL . 'import/direct/getRecordsFromDB.php?loginerror=1&db=' . HEURIST_DBNAME);
        exit;
    }
    mysql_connection_overwrite(DATABASE);
}
if (@$_REQUEST['mode'] == '2') {
    createMappingForm(null);
} else {
    // ---- visit #3 - SAVE SETTINGS -----------------------------------------------------------------