* datatype */ // main includes require './include.php'; require './includes/db_inc.php'; $tableinfo = new tableinfo($db, false, $_POST['tableid']); // don't have these fields changed: $forbidden_fields = array('id', 'ownerid'); if (in_array($_POST['field'], $forbidden_fields)) { return false; } if ($_POST['datatype'] == 'date') { $_POST['newvalue'] = strtotime($_POST['newvalue']); } //$db->debug=true; if (may_see_table($db, $USER, $tableinfo->id) && may_write($db, $tableinfo->id, $_post['recordid'], $USER)) { if ($_POST['datatype'] == 'mpulldown') { // $newvalue is a comma separated list with ids of the selected items // remove the last (extra) comma) $_POST['newvalue'] = substr($_POST['newvalue'], 0, -1); $valueArray = explode(',', $_POST['newvalue']); // figure out name of keytable $keytable = get_cell($db, $tableinfo->desname, 'key_table', 'columnname', $_POST['field']); if ($keytable) { update_mpulldown($db, $keytable, $_POST['recordid'], $valueArray); } } else { // if the value is really empty, set to NULL, this is essential for numeric fields if ($_POST['newvalue'] == '') { $result = $db->Execute("UPDATE {$tableinfo->realname} SET {$_POST['field']}=NULL WHERE id={$_POST['recordid']}"); } else {
if (is_numeric($_GET['viewid'])) { $viewid = $_GET['viewid']; } if ($viewid) { $Fieldscomma = viewlist($db, $tableinfo, $viewid); } else { $Fieldscomma = comma_array_SQL($db, $tableinfo->desname, columnname, "WHERE display_table='Y'"); } if (!($reportid && ($recordid || $tableview))) { printheader($httptitle); navbar($USER['permissions']); echo "<h3 align='center'>Not enough information to generate the report.</h3>"; printfooter(); exit; } if (!may_see_table($db, $USER, $tableinfo->id)) { printheader($httptitle); navbar($USER['permissions']); echo "<h3 align='center'>This information is not intended to be seen by you.</h3>"; printfooter(); exit; } if ($reportid > 0) { $reportname = get_cell($db, 'reports', 'label', 'id', $reportid); $tp = @fopen($system_settings['templatedir'] . "/{$reportid}.tpl", 'r'); if ($tp) { while (!feof($tp)) { $line = fgets($tp); if (stristr($line, "<!--fields-->")) { $header = $template; unset($template);