';
if(!defined('EDIT_TABLE_MIN_PRIV'))
{
define('EDIT_TABLE_MIN_PRIV', 80);
}
#=========================================
#
# if the user has not enough privileges, redirect to the main site page
#
#=========================================
check_access($USER_ID,$USER_PW,EDIT_TABLE_MIN_PRIV);
$thisPage = basename(__FILE__,'.tpl');
//var_dump($_POST);
#=========================================
#
# set the edit language code
#
#=========================================
if(!isset($_SESSION['table_editor']['lang']) || $_SESSION['table_editor']['lang']=='')
{
$_SESSION['table_editor']['lang'] = $_SESSION['sitelanguage'];
}
//echo '$_POST[action]:'.$_POST[action].'
';
//echo '$_POST['cat_']:'.$_POST['cat_'];
//var_dump($_POST);die;
#=========================================
#
# get the site available languages
#
#=========================================
$lang = $_POST['lang'] ? $_POST['lang'] : $_SESSION['table_editor']['lang'];
#=========================================
#
# handle the button commands
#
#=========================================
//unset( $_SESSION[EDIT_TABLE_NAME.'_recmode'],
// $_SESSION[EDIT_TABLE_NAME.'_addtype']
//);
//var_dump($_POST);die();
$_DIR = $_POST['dir'];
$_IDR = $_POST['id'];
$_IDRafter = $_POST['idAfter'];
//var_dump($_POST);
//echo '$_DIR:'.$_DIR.'
';
//echo '$_IDR:'.$_IDR.'
';
switch($_POST['_action'])
{
// #-----------------------
// case BTN_ORDER:
// #-----------------------
// $_SESSION[EDIT_TABLE_NAME.'_recmode'] = '*add';
// $_SESSION[EDIT_TABLE_NAME.'_addtype'] = '0';
// session_write_close();
// header('Location: /?page=table_editor&table='.EDIT_TABLE_NAME);
// exit();
// break;
// #
#-----------------------
case BTN_MOVE:
#-----------------------
//echo '_action:'.BTN_MOVE.'
';
if($_DIR=='after' && (int)$_IDR>-1 && (int)$_IDRafter>-1)
{
$result = move_after($_IDR, $_IDRafter);
}
if($result=='OKIDOKI')
{
$msg = 'Dati aggiornati';
$pop = '';
echo $pop;
exit();
}
break;
#
#-----------------------
default:
#-----------------------
}
?>
'
;
#=========================================
#
# add the icon menu at the end of the EIP floating menu
#
#=========================================
global $_EIP_FLOAT_MENU_XTRA;
$_EIP_FLOAT_MENU_XTRA = ''
.draw_edit_float_menu($edit_menu)
.'
';
$_EIP_FLOAT_MENU_XTRA .= ''
.''
.''
.''
.''
.' '
.''
.'
';
#~~~~~~~~~~~~~~~~~~~~~~~~~~
function move_after($RRN, $afterRRN, $lang='')
#~~~~~~~~~~~~~~~~~~~~~~~~~~
{
global $USER_RRN, $TABLE;
#
# move an element after the requested one
#
if((int)$afterRRN<1) { return; }
#
if(defined('SET_TABLE_ORDER_KEYS'))
{
$keys = explode('|', SET_TABLE_ORDER_KEYS);
$kt = count($keys);
}
if($kt<1) { return; }
#
//echo 'kt:'.$kt.'
';
//var_dump($keys);echo '
';
#
// if($lang=='') { $lang = $_SESSION['sitelanguage']; }
// $lang = mysql_real_escape_string($lang);
#
# get the position of the record after which we need to move
#
$sql = 'SELECT RRN, showOrd ';
for($i=0;$i<$kt;$i++)
{
$sql .= ', '.$keys[$i].' ';
}
$sql .= 'FROM '.MAINSITE_DB.'.`'.$TABLE.'` '
.'WHERE RRN = '.$afterRRN.' '
;
$sth = db_query($sql,__LINE__,__FILE__);
$row = db_fetch($sth[0]);
$dest_rrn = $row[0]['RRN'];
$dest_position = $row[0]['showOrd'];
//echo $sql.'
';
//echo '$dest_rrn:'.$dest_rrn.'
';
//echo '$dest_position:'.$dest_position.'
';
//var_dump($row);echo '
';
//die();
if($dest_rrn<1) { return; }
#
# get all the following records
#
$sql = 'SELECT RRN, showOrd FROM `'.MAINSITE_DB.'`.`'.$TABLE.'` '
.'WHERE showOrd > '.$dest_position.' '
.'AND RRN <> '.$RRN.' '
;
for($i=0;$i<$kt;$i++)
{
$sql .= 'AND '.$keys[$i].' = \''.mysql_real_escape_string($row[0][$keys[$i]]).'\' ';
}
$sql .= 'ORDER BY showOrd ASC ';
#
$sth = db_query($sql,__LINE__,__FILE__);
$rows = db_fetch($sth[0]);
$t = $sth[1];
//echo $sql.', found:'.$sth[1].'
';
//var_dump($rows);echo '
';
//die();
#
// if($dest_position!='' && $dest_rrn>0 && $rows[0]['RRN']>0)
if($dest_position!='' && $dest_rrn>0)
{
$sql = 'LOCK TABLES `'.MAINSITE_DB.'`.`'.$TABLE.'` WRITE';
$sth = db_query($sql,__LINE__,__FILE__);
#
# move the requested record on the new position
#
$dest_position++;
$sql = 'UPDATE `'.MAINSITE_DB.'`.`'.$TABLE.'` '
.'SET '
.'LAST_USER ='.$USER_RRN.', '
.'showOrd ='.$dest_position.' '
.'WHERE RRN='.$RRN
;
//echo $sql.'
';
$sth = db_query($sql,__LINE__,__FILE__);
#
for($i=0;$i<$t;$i++)
{
# move all the records coming after
#
$dest_position++;
$sql = 'UPDATE `'.MAINSITE_DB.'`.`'.$TABLE.'` '
.'SET '
.'LAST_USER ='.$USER_RRN.', '
.'showOrd ='.$dest_position.' '
.'WHERE RRN='.$rows[$i]['RRN']
;
//echo $sql.'
';
$sth = db_query($sql,__LINE__,__FILE__);
}
#
# get all the records with the same keys
#
$sql = 'SELECT RRN, showOrd FROM `'.MAINSITE_DB.'`.`'.$TABLE.'` '
.'WHERE 1 = 1 '
;
for($i=0;$i<$kt;$i++)
{
$sql .= 'AND '.$keys[$i].' = \''.mysql_real_escape_string($row[0][$keys[$i]]).'\' ';
}
$sql .= 'ORDER BY showOrd ASC ';
//echo '
'.$sql.'
';
#
$sth = db_query($sql,__LINE__,__FILE__);
$rows = db_fetch($sth[0]);
$t = $sth[1];
for($i=0;$i<$t;$i++)
{
# resequence the records
#
$dest_position++;
$sql = 'UPDATE `'.MAINSITE_DB.'`.`'.$TABLE.'` '
.'SET '
.'LAST_USER ='.$USER_RRN.', '
.'showOrd ='.$i.' '
.'WHERE RRN='.$rows[$i]['RRN']
;
//echo $sql.'
';
$sth = db_query($sql,__LINE__,__FILE__);
}
#
$sql = 'UNLOCK TABLES';
$sth = db_query($sql,__LINE__,__FILE__);
#
//die();
return 'OKIDOKI';
}
#
return;
}
?>