1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<?php
/*
+----------------------------------------------------------------------+
| ini doc settings updater |
+----------------------------------------------------------------------+
| Copyright (c) 1997-2005 The PHP Group |
+----------------------------------------------------------------------+
| This source file is subject to version 3.0 of the PHP license, |
| that is bundled with this package in the file LICENSE, and is |
| available through the world-wide-web at the following url: |
| http://www.php.net/license/3_0.txt. |
| If you did not receive a copy of the PHP license and are unable to |
| obtain it through the world-wide-web, please send a note to |
| license@php.net so we can mail you a copy immediately. |
+----------------------------------------------------------------------+
| Authors: Nuno Lopes <nlopess@php.net> |
+----------------------------------------------------------------------+
*/
$error = '';
copy('ini_changelog.sqlite', 'backup.sqlite');
if (!$idx = sqlite_open('ini_changelog.sqlite', 0666, $error)) {
die("Couldn't create the DB: $error");
}
$olddata = sqlite_fetch_all(sqlite_query($idx, 'SELECT * FROM changelog'), SQLITE_ASSOC);
$columns = sqlite_fetch_array(sqlite_query($idx, 'SELECT * FROM changelog LIMIT 1'), SQLITE_ASSOC);
sqlite_query($idx, 'DROP TABLE changelog; VACUUM;');
// make a new table. this also fills the $tags array
include './make_db.php';
$sql = '';
foreach ($olddata as $row) {
$keys = '';
foreach ($row as $key => $val) {
$keys .= ",$key";
}
$keys = substr($keys, 1);
$sql .= "INSERT INTO changelog ($keys) VALUES (\"" . implode('", "', $row) . '");';
}
sqlite_query($idx, $sql);
$tmp = $tags;
$tags = array('php_4_cvs', 'php_5_cvs');
foreach($tmp as $tag) {
if (!isset($columns[$tag])) {
$tags[] = $tag;
}
}
// finally recurse through the new PHP versions
include './insert_db.php';
sqlite_close($idx);
?>
|
