2
/* $Id: pmd_display_field.php 9828 2007-01-05 17:30:36Z lem9 $ */
3
// vim: expandtab sw=4 ts=4 sts=4:
6
@author Ivan A Kirillov (Ivan.A.Kirillov@gmail.com)
9
include_once 'pmd_common.php';
10
require_once './libraries/relation.lib.php';
16
if ($cfgRelation['displaywork']) {
18
$disp = PMA_getDisplayField($db, $table);
20
if ($display_field != $disp) {
21
$upd_query = 'UPDATE ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_info'])
22
. ' SET display_field = \'' . PMA_sqlAddslashes($display_field) . '\''
23
. ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
24
. ' AND table_name = \'' . PMA_sqlAddslashes($table) . '\'';
26
$upd_query = 'DELETE FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_info'])
27
. ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
28
. ' AND table_name = \'' . PMA_sqlAddslashes($table) . '\'';
30
} elseif ($display_field != '') {
31
$upd_query = 'INSERT INTO ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_info'])
32
. '(db_name, table_name, display_field) '
34
. '\'' . PMA_sqlAddslashes($db) . '\','
35
. '\'' . PMA_sqlAddslashes($table) . '\','
36
. '\'' . PMA_sqlAddslashes($display_field) . '\')';
39
if (isset($upd_query)) {
40
$upd_rs = PMA_query_as_cu($upd_query);
44
header("Content-Type: text/xml; charset=utf-8");
45
header("Cache-Control: no-cache");
46
die("<root act='save_pos' return='strModifications'></root>");