2 //these are the functions used to access the forms registry database
4 //include_once("../../globals.php");
5 include_once("{$GLOBALS['srcdir']}/sql.inc");
7 function registerForm ( $directory , $sql_run=0 , $unpackaged=1 , $state=0 )
9 $check = sqlQuery("select state from registry where directory='$directory'");
12 $lines = @file($GLOBALS['srcdir']."/../interface/forms/$directory/info.txt");
17 return sqlInsert("insert into registry set
20 directory='".mysql_escape_string($directory)."',
22 unpackaged='$unpackaged',
29 function updateRegistered ( $id, $mod )
31 return sqlInsert("update registry set
39 function getRegistered ( $state="1", $limit="unlimited", $offset="0")
41 $sql = "select name, state, directory, id, sql_run, unpackaged, date from registry where state like \"$state\" order by name";
42 if ($limit != "unlimited")
43 $sql .= " limit $limit, $offset";
44 $res = sqlStatement($sql);
46 for($iter=0; $row=sqlFetchArray($res); $iter++)
55 function getRegistryEntry ( $id, $cols = "*" )
57 $sql = "select $cols from registry where id='$id'";
58 return sqlQuery($sql);
61 function installSQL ( $dir )
63 $sqltext = $dir."/table.sql";
64 if ($sqlarray = @file($sqltext))
66 $sql = implode("", $sqlarray);
67 //echo "<br>$sql<br><br>";
68 $sqla = split(";",$sql);
69 foreach ($sqla as $sqlq) {
70 if (strlen($sqlq) > 5) {
71 sqlStatement(rtrim("$sqlq"));
82 * is a form registered
83 * (optional - and active)
86 * INPUT = id => form ID
87 * state => 0=inactive / 1=active
88 * OUTPUT = true or false
90 function isRegistered ( $id, $state = 1)
92 $sql = "select id from registry where ".
95 $result = sqlQuery($sql);
96 if ($result['id'] != '') return true;
102 * given a form directory return the unique ID
103 * for the associated form
104 * NOTE - sometimes the Name of a form has a line-break at the end, thus this function might be better
106 function getIdByDirectory ( $directory )
108 $sql = "select id from registry where ".
109 " directory = '".$directory."'";
110 $result = sqlQuery($sql);
111 if ($result['id'] != '') return $result['id'];