@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"' : '';