forked from openemr/openemr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
registry.inc
79 lines (73 loc) · 1.69 KB
/
registry.inc
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
<?php
//these are the functions used to access the forms registry database
//
//include_once("../../globals.php");
include_once("{$GLOBALS['srcdir']}/sql.inc");
function registerForm ( $directory , $sql_run=0 , $unpackaged=1 , $state=0 )
{
$check = sqlQuery("select state from registry where directory='$directory'");
if ($check == false)
{
$lines = @file($GLOBALS['srcdir']."/../interface/forms/$directory/info.txt");
if ($lines)
$name = $lines[0];
else
$name = $directory;
return sqlInsert("insert into registry set
name='$name',
state='$state',
directory='".mysql_escape_string($directory)."',
sql_run='$sql_run',
unpackaged='$unpackaged',
date=NOW()
");
}
return false;
}
function updateRegistered ( $id, $mod )
{
return sqlInsert("update registry set
$mod,
date=NOW()
where
id='$id'
");
}
function getRegistered ( $state="1", $limit="unlimited", $offset="0")
{
$sql = "select name, state, directory, id, sql_run, unpackaged, date from registry where state like \"$state\" order by name";
if ($limit != "unlimited")
$sql .= " limit $limit, $offset";
$res = sqlStatement($sql);
if ($res)
for($iter=0; $row=sqlFetchArray($res); $iter++)
{
$all[$iter] = $row;
}
else
return false;
return $all;
}
function getRegistryEntry ( $id, $cols = "*" )
{
$sql = "select $cols from registry where id='$id'";
return sqlQuery($sql);
}
function installSQL ( $dir )
{
$sqltext = $dir."/table.sql";
if ($sqlarray = @file($sqltext))
{
$sql = implode("", $sqlarray);
//echo "<br>$sql<br><br>";
$sqla = split(";",$sql);
foreach ($sqla as $sqlq) {
if (strlen($sqlq) > 5) {
sqlStatement(rtrim("$sqlq"));
}
}
return true;
}else
return false;
}
?>