Subversion Repositories oidplus

Rev

Rev 74 | Rev 80 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 daniel-mar 1
<?php
2
 
3
/*
4
 * OIDplus 2.0
5
 * Copyright 2019 Daniel Marschall, ViaThinkSoft
6
 *
7
 * Licensed under the Apache License, Version 2.0 (the "License");
8
 * you may not use this file except in compliance with the License.
9
 * You may obtain a copy of the License at
10
 *
11
 *     http://www.apache.org/licenses/LICENSE-2.0
12
 *
13
 * Unless required by applicable law or agreed to in writing, software
14
 * distributed under the License is distributed on an "AS IS" BASIS,
15
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16
 * See the License for the specific language governing permissions and
17
 * limitations under the License.
18
 */
19
 
20
$prefix = isset($_REQUEST['prefix']) ? $_REQUEST['prefix'] : '';
78 daniel-mar 21
$database = isset($_REQUEST['database']) ? $_REQUEST['database'] : '';
2 daniel-mar 22
 
23
$cont = trim(file_get_contents(__DIR__.'/sql/struct.sql'))."\n\n".
50 daniel-mar 24
        trim(file_get_contents(__DIR__.'/sql/wellknown_country.sql'))."\n\n".
25
        trim(file_get_contents(__DIR__.'/sql/wellknown_other.sql'))."\n\n";
2 daniel-mar 26
 
74 daniel-mar 27
$table_names = array('objects', 'asn1id', 'iri', 'ra', 'config');
2 daniel-mar 28
foreach ($table_names as $table) {
29
        $cont = str_replace('`'.$table.'`', '`'.$prefix.$table.'`', $cont);
30
}
31
 
50 daniel-mar 32
if (php_sapi_name() != 'cli') {
33
        header('Content-Type:text/sql');
34
}
78 daniel-mar 35
 
36
echo "USE `".$database."`;\n\n";
2 daniel-mar 37
echo $cont;