| 1 | <?php
|
|---|
| 2 | /* $Id: pmd_display_field.php 9828 2007-01-05 17:30:36Z lem9 $ */
|
|---|
| 3 | // vim: expandtab sw=4 ts=4 sts=4:
|
|---|
| 4 |
|
|---|
| 5 | /*
|
|---|
| 6 | @author Ivan A Kirillov (Ivan.A.Kirillov@gmail.com)
|
|---|
| 7 | */
|
|---|
| 8 |
|
|---|
| 9 | include_once 'pmd_common.php';
|
|---|
| 10 | require_once './libraries/relation.lib.php';
|
|---|
| 11 |
|
|---|
| 12 |
|
|---|
| 13 | $table = $T;
|
|---|
| 14 | $display_field = $F;
|
|---|
| 15 |
|
|---|
| 16 | if ($cfgRelation['displaywork']) {
|
|---|
| 17 |
|
|---|
| 18 | $disp = PMA_getDisplayField($db, $table);
|
|---|
| 19 | if ($disp) {
|
|---|
| 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) . '\'';
|
|---|
| 25 | } else {
|
|---|
| 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) . '\'';
|
|---|
| 29 | }
|
|---|
| 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) '
|
|---|
| 33 | . ' VALUES('
|
|---|
| 34 | . '\'' . PMA_sqlAddslashes($db) . '\','
|
|---|
| 35 | . '\'' . PMA_sqlAddslashes($table) . '\','
|
|---|
| 36 | . '\'' . PMA_sqlAddslashes($display_field) . '\')';
|
|---|
| 37 | }
|
|---|
| 38 |
|
|---|
| 39 | if (isset($upd_query)) {
|
|---|
| 40 | $upd_rs = PMA_query_as_cu($upd_query);
|
|---|
| 41 | }
|
|---|
| 42 | } // end if
|
|---|
| 43 |
|
|---|
| 44 | header("Content-Type: text/xml; charset=utf-8");
|
|---|
| 45 | header("Cache-Control: no-cache");
|
|---|
| 46 | die("<root act='save_pos' return='strModifications'></root>");
|
|---|
| 47 | ?>
|
|---|
