function check_session()
{
+ if (!empty($_SESSION['sys']['login']) && !empty($_GET['logout'])) {
+ session_destroy();
+ header('Location: ./?login=true');
+ exit();
+ }
+
if (!empty($_POST['login']) && !empty($_POST['passwd'])) {
require_once('lib/login.php');
if (check_passwd()) {
function load_mask($name)
{
global $mask;
+ global $jscode;
$name = sanitise_filename($name);
$file = $_SESSION['sys']['basedir'] . 'masks/' . $name . '.php';
return $html;
}
+function grid_sql($name, $mask)
+{
+ $fields = array();
+ foreach ($mask['list'] as $field => $data) {
+ if (array_key_exists('sql', $data))
+ $fields[] = $data['sql'] . ' AS ' . $field;
+ else
+ $fields[] = $field;
+ }
+
+ $_SESSION['grid_' . $name] = sprintf("SELECT %s FROM %s",
+ implode(',', $fields), $mask['table']);
+ if (array_key_exists('join', $mask)) $_SESSION['grid_' . $name] .= ' JOIN ' . join(' JOIN ', $mask['join']);
+ if (array_key_exists('where', $mask)) $_SESSION['grid_' . $name] .= ' WHERE ' . $mask['where'];
+}
+
?>