function update_s_site_plugin_input_field($site_type, $field, $order_no, $description, $prompt, $field_type, $default_value, $refresh_mask) { if (strlen($site_type) > 0 && strlen($field) > 0) { $site_type = strtolower($site_type); $field = strtolower($field); if ($order_no !== FALSE && !is_numeric($order_no)) { $order_no = 0; } if ($field_type !== FALSE) { $field_type = strtolower($field_type); if (!in_array($field_type, get_legal_input_field_types())) { $field_type = 'text'; } } $query = "UPDATE s_site_plugin_input_field " . "SET description = " . ($description !== FALSE ? "'" . addslashes(trim(strip_tags($description))) . "'" : "description") . ($order_no !== FALSE ? ", order_no = " . $order_no . "" : "") . ($prompt !== FALSE ? ", prompt = '" . addslashes(trim(strip_tags($prompt))) . "'" : "") . ($field_type !== FALSE ? ", field_type = '" . $field_type . "'" : "") . ($default_value !== FALSE ? ", default_value = '" . addslashes(trim(strip_tags($default_value))) . "'" : "") . ($refresh_mask !== FALSE ? ", refresh_mask = '" . addslashes(trim(strip_tags($refresh_mask))) . "'" : "") . " WHERE site_type = '{$site_type}' AND field = '{$field}'"; $update = db_query($query); // We should not treat updates that were not actually updated because value did not change as failures. $rows_affected = db_affected_rows(); if ($update && $rows_affected !== -1) { if ($rows_affected > 0) { opendb_logger(OPENDB_LOG_INFO, __FILE__, __FUNCTION__, NULL, array($site_type, $field, $order_no, $description, $prompt, $field_type, $default_value, $refresh_mask)); } return TRUE; } else { opendb_logger(OPENDB_LOG_ERROR, __FILE__, __FUNCTION__, db_error(), array($site_type, $field, $order_no, $description, $prompt, $field_type, $default_value, $refresh_mask)); return FALSE; } } //else return FALSE; }
function display_site_plugin_input_field_row($record_r, $row) { global $PHP_SELF; global $ADMIN_TYPE; if (is_not_empty_array($record_r)) { echo "<input type=\"hidden\" name=\"exists_ind[{$row}]\" value=\"Y\">"; echo "<td class=\"data\">" . get_input_field("order_no[{$row}]", NULL, "Order No", "number(3)", "Y", $record_r['order_no'], FALSE) . "</td>"; echo "<td class=\"data\">" . get_input_field("field[{$row}]", NULL, "Field Name", "readonly", "Y", $record_r['field'], FALSE) . "</td>"; } else { echo "<input type=\"hidden\" name=\"exists_ind[{$row}]\" value=\"N\">"; echo "<td class=\"data\">" . get_input_field("order_no[{$row}]", NULL, "Order No", "number(3)", "Y", NULL, FALSE) . "</td>"; echo "<td class=\"data\">" . get_input_field("field[{$row}]", NULL, "Field Name", "text(10,20)", "Y", NULL, FALSE) . "</td>"; } echo "<td class=\"data\">" . get_input_field("description[{$row}]", NULL, "Description", "text(20,255)", 'N', $record_r['description'], FALSE) . "</td>"; echo "<td class=\"data\">" . get_input_field("prompt[{$row}]", NULL, "URL", "text(10,30)", 'N', $record_r['prompt'], FALSE) . "</td>"; echo "<td class=\"data\">" . custom_select("field_type[{$row}]", get_legal_input_field_types(), "%value%", 1, $record_r['field_type']) . "</td>"; echo "<td class=\"data\">" . get_input_field("refresh_mask[{$row}]", NULL, "Refresh Mask", "text(20,255)", 'N', $record_r['refresh_mask'], FALSE) . "</td>"; echo "<td class=\"data\">" . get_input_field("default_value[{$row}]", NULL, "Default Value", "text(7,50)", 'N', $record_r['default_value'], FALSE) . "</td>"; echo "\n<td class=\"data\">"; if (is_not_empty_array($record_r)) { echo "<a href=\"{$PHP_SELF}?type={$ADMIN_TYPE}&op=delete_site_plugin_input_field&site_type=" . $record_r['site_type'] . "&field=" . $record_r['field'] . "\">Delete</a>"; } else { echo " "; } echo "\n</td>"; }