-
Notifications
You must be signed in to change notification settings - Fork 7
/
update_tables.php
37 lines (35 loc) · 1.18 KB
/
update_tables.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
<?php
if($_SERVER['HTTP_X_FORWARDED_HOST']!='') {
$def = $_SERVER['HTTP_X_FORWARDED_HOST'];
} else {
$def = $_SERVER['HTTP_HOST'];
}
if(file_exists('config.inc.php')) {
include('config.inc.php');
} else {
Header('Location: http://'.$def.'/s3db/');
exit;
}
$key = $_GET['key'];
if($key=='') { $key = $s3ql['key']; }
if($key=='') { $key=$argv[1]; }
$file=$_REQUEST['file'];
if($file=='') { $file=$argv[3]; }
$inputs = ($argv!='')?$argv:$_REQUEST;
#When the key goes in the header URL, no need to read the xml, go directly to the file
include_once('core.header.php');
include('dbstruct.php');
if($user_id!='1') {
echo "User cannot change table configuration";
exit;
} else {
$sql = "update s3db_permission set id_code=substr(uid,1,1)";
$db->query($sql,__LINE__,__FILE__);
$sql = "update s3db_permission set id_num=substr(uid,2,length(uid))";
$db->query($sql,__LINE__,__FILE__);
$sql = "update s3db_permission set shared_with_code=substr(shared_with,1,1)";
$db->query($sql,__LINE__,__FILE__);
$sql = "update s3db_permission set shared_with_num=substr(shared_with,2,length(shared_with))";
$db->query($sql,__LINE__,__FILE__);
}
?>