@reset($tables);
while (list($table_name, $table_data) = @each($tables)) {
if ($table_name == $table) {
$new_tables[$name]['sql_id'] = $sql_id;
$new_tables[$name]['sql_join'] = $sql_join;
$new_tables[$name]['sql_where'] = $sql_where;
$new_tables[$name]['sql_order'] = $sql_order;
} else {
$new_tables[$table_name] = $table_data;
}
}
$tables = array();
$tables = $new_tables;
}
// output
pcp_output_fields($values_list, $tables, $classes_fields, $user_maps, $user_fields);
// prepare feedback message
$return_path = append_sid("./admin_pcp_tableslinked.{$phpEx}");
$message = sprintf(empty($table) ? $lang['PCP_tableslinked_created'] : $lang['PCP_tableslinked_modified'], '<a href="' . $return_path . '" />', '</a>');
message_die(GENERAL_MESSAGE, $message);
} else {
// template
$template->set_filenames(array('body' => 'pcp_tableslinked_edit_body.tpl'));
// header
$template->assign_vars(array('L_TITLE' => $lang['PCP_tableslinked_linked_edit'], 'L_TITLE_EXPLAIN' => $lang['PCP_tableslinked_linked_edit_explain'], 'L_NAME' => $lang['PCP_tableslinked_name'], 'L_NAME_EXPLAIN' => $lang['PCP_tableslinked_name_explain'], 'L_SQL_ID' => $lang['PCP_tableslinked_id'], 'L_SQL_ID_EXPLAIN' => $lang['PCP_tableslinked_id_explain'], 'L_SQL_JOIN' => $lang['PCP_tableslinked_join'], 'L_SQL_JOIN_EXPLAIN' => $lang['PCP_tableslinked_join_explain'], 'L_SQL_WHERE' => $lang['PCP_tableslinked_where'], 'L_SQL_WHERE_EXPLAIN' => $lang['PCP_tableslinked_where_explain'], 'L_SQL_ORDER' => $lang['PCP_tableslinked_order'], 'L_SQL_ORDER_EXPLAIN' => $lang['PCP_tableslinked_order_explain'], 'L_SUBMIT' => $lang['Submit'], 'L_REFRESH' => $lang['Refresh'], 'L_DELETE' => $lang['Delete'], 'L_CANCEL' => $lang['Cancel']));
// var
$template->assign_vars(array('NAME' => strtoupper($name), 'SQL_ID' => strtolower($sql_id), 'SQL_JOIN' => $sql_join, 'SQL_WHERE' => $sql_where, 'SQL_ORDER' => $sql_order));
// footer
$s_hidden_fields = '';
$s_hidden_fields .= '<input type="hidden" name="mode" value="' . $mode . '" />';
$s_hidden_fields .= '<input type="hidden" name="table" value="' . $table . '" />';
} else {
if (!empty($vlist_name)) {
$new_vlists[$vlist_name] = $vlist_data;
}
}
}
if (empty($vlist)) {
$new_vlists[$name]['func'] = $func;
$new_vlists[$name]['table']['main'] = $main;
$new_vlists[$name]['table']['key'] = $keyfield;
$new_vlists[$name]['table']['txt'] = $txtfield;
$new_vlists[$name]['table']['img'] = $imgfield;
$new_vlists[$name]['values'] = $values;
}
// output
pcp_output_fields($new_vlists, $tables_linked, $classes_fields, $user_maps, $user_fields);
// prepare feedback message
$return_path = append_sid("./admin_pcp_valueslist.{$phpEx}");
$message = sprintf(empty($vlist) ? $lang['PCP_valueslist_created'] : $lang['PCP_valueslist_modified'], '<a href="' . $return_path . '" />', '</a>');
message_die(GENERAL_MESSAGE, $message);
} else {
// template
$template->set_filenames(array('body' => 'pcp_valueslist_edit_body.tpl'));
// header
$template->assign_vars(array('L_TITLE' => $lang['PCP_valueslist_edit'], 'L_TITLE_EXPLAIN' => $lang['PCP_valueslist_edit_explain'], 'L_NAME' => $lang['PCP_valueslist_name'], 'L_NAME_EXPLAIN' => $lang['PCP_valueslist_name_explain'], 'L_FUNC' => $lang['PCP_valueslist_func'], 'L_FUNC_EXPLAIN' => $lang['PCP_valueslist_func_explain'], 'L_TABLE' => $lang['PCP_valueslist_table'], 'L_TABLE_EXPLAIN' => $lang['PCP_valueslist_table_explain'], 'L_KEYFIELD' => $lang['PCP_valueslist_keyfield'], 'L_KEYFIELD_EXPLAIN' => $lang['PCP_valueslist_keyfield_explain'], 'L_TXTFIELD' => $lang['PCP_valueslist_txtfield'], 'L_TXTFIELD_EXPLAIN' => $lang['PCP_valueslist_txtfield_explain'], 'L_IMGFIELD' => $lang['PCP_valueslist_imgfield'], 'L_IMGFIELD_EXPLAIN' => $lang['PCP_valueslist_imgfield_explain'], 'L_VALUES' => $lang['PCP_valueslist_values'], 'L_ITEM' => $lang['PCP_valueslist_item_val'], 'L_TXT' => $lang['PCP_valueslist_item_txt'], 'L_IMG' => $lang['PCP_valueslist_item_img'], 'L_EMPTY' => $lang['None'], 'L_ADD_ITEM' => $lang['PCP_valueslist_add_item'], 'L_DELETE_SELECTION' => $lang['PCP_valueslist_del_item'], 'L_UP' => $lang['Up'], 'L_DOWN' => $lang['Down'], 'L_SUBMIT' => $lang['Submit'], 'L_REFRESH' => $lang['Refresh'], 'L_DELETE' => $lang['Delete'], 'L_CANCEL' => $lang['Cancel']));
// tables list
$selected = empty($main) ? ' selected="selected"' : '';
$s_tables_opt = '<option value=""' . $selected . '>' . $lang['None'] . '</option>';
@reset($tables_linked);
while (list($table_name, $table_data) = @each($tables_linked)) {
$selected = $main == $table_name ? ' selected="selected"' : '';
