-
Notifications
You must be signed in to change notification settings - Fork 13
/
update.php
127 lines (76 loc) · 2.15 KB
/
update.php
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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include "config.php";
set_time_limit(10000);
ini_set('mysql.connect_timeout','0');
ini_set('max_execution_time', '0');
$mysqli = new mysqli( $host, $user, $password , $db);
if (mysqli_connect_errno()) { /* check connection */
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
//check if table exsist
/*
*
* SELECT IF( EXISTS(
SELECT value
FROM Settings
WHERE `Define` = 'PORTAL_VERSION'), 1, 0)
* show tables like "Settings";
*/
$sql = "SHOW tables;";
$result = $mysqli -> query($sql);
// Numeric array
$tables = $result -> fetch_all(MYSQLI_ASSOC);
$tabel_data = Array();
$settings_nedel=0;
foreach($tables as $mydata => $value)
{
if(in_array("Settings", $value))
{
$settings_nedel=1;
}
}
// check i auto exist
if($settings_nedel == 1)
{
$sql = "SELECT value FROM Settings where Define = 'PORTAL_VERSION'";
$result = $mysqli -> query($sql);
$data = $result -> fetch_array();
if($data['value'] == "2.3")
{
$sql = file_get_contents('sql/update 2.4.sql');
/* execute multi query */
if ($mysqli->multi_query($sql))
{
echo "successfull upgrade to 2.4 db";
}
}
elseif($data['value'] == "2.4")
{
$sql = file_get_contents('sql/update2.6.sql');
/* execute multi query */
if ($mysqli->multi_query($sql))
{
echo "successfull upgrade to 2.4 db";
}
}
else
{
echo "successfull upgrade db";
echo "pleace log in on admin.php with usernme svxportal and password svxportal and change the password";
}
}
else
{
$sql = file_get_contents('sql/update2-3.sql');
/* execute multi query */
if ($mysqli->multi_query($sql))
{
echo "successfull upgrade to 2.3 db";
echo "pleace log in on admin.php with usernme svxportal and password svxportal and change the password";
}
}
?>