/* table connections */
if (substr($_SERVER["SCRIPT_FILENAME"],-25) == '/ricoUpdateConnection.php' &&
- !empty($_POST['table'])) {
- if (check_permissions($_POST['table']))
+ !empty($_GET['id']) && substr($_GET['id'],0,5) == 'grid_') {
+ if (check_permissions(substr($_GET['id'],5)))
return true;
else
format_ajax(array('error' => 'No permission to access data'));
return $html;
}
+function grid_sql_join($mask)
+{
+ if (array_key_exists('join', $mask)) {
+ return ' JOIN ' . join(' JOIN ', $mask['join']);
+ }
+ return '';
+}
+
function grid_sql($name, $mask)
{
$fields = array();
$_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('join', $mask)) $_SESSION['grid_' . $name] .= grid_sql_join($mask);
if (array_key_exists('where', $mask)) $_SESSION['grid_' . $name] .= ' WHERE ' . $mask['where'];
}