source: extensions/ID_switch/admin/admin.php @ 25973

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
global $template, $conf, $user;
include_once(PHPWG_ROOT_PATH .'admin/include/tabsheet.class.php');
load_language('plugin.lang', IDS_PATH);
$my_base_url = get_admin_plugin_menu_link(__FILE__);

// +-----------------------------------------------------------------------+
// | Check Access and exit when user status is not ok                      |
// +-----------------------------------------------------------------------+
check_status(ACCESS_ADMINISTRATOR);

//-------------------------------------------------------- sections definitions

// Gestion des onglets
if (!isset($_GET['tab']))
    $page['tab'] = 'IDS';
else
    $page['tab'] = $_GET['tab'];

$tabsheet = new tabsheet();
$tabsheet->add('IDS',
               l10n('ids_tab1'),
               $my_base_url.'&amp;tab=IDS');
$tabsheet->select($page['tab']);
$tabsheet->assign();

switch ($page['tab'])
{
// tab switch
  case 'IDS':

$groups = array();
$query = '
select id,name
  FROM ' . IMAGES_TABLE . '
  ORDER BY id ASC;';
$result = pwg_query($query);

while ($row = mysql_fetch_array($result))
        {
  $groups[$row['id']] = $row['id'].' : '.$row['name'];
        }
        
        $selected = 0;
        $options[] = l10n('ids_select');
        $options['a'] = '----------------------';
        
foreach($groups as $listid => $listid2)
        {
    $options[$listid] = $listid2;
        }
  $template->assign(
    'gestion',
    array(
          'OPTIONS' => $options,
      'SELECTED' => $selected
      )); 

//action
if (isset($_POST['IDS'])and is_numeric($_POST['IDS1']) and (!$_POST['IDS1'])==0 and is_numeric($_POST['IDS2']) and (!$_POST['IDS2'])==0)
        {
        
$query = '
select id, hit, has_high, average_rate, path
  FROM ' . IMAGES_TABLE . '
  WHERE id = \''.$_POST['IDS1'].'\'
  ;';
$result = pwg_query($query);
$row = mysql_fetch_array($result);      
$id1=$row['id'];
$hit1=$row['hit'];
$has_high1=$row['has_high'];
$average_rate1=$row['average_rate'];

$query = '
select id, hit, has_high, average_rate, path
  FROM ' . IMAGES_TABLE . '
  WHERE id = \''.$_POST['IDS2'].'\'
  ;';
$result = pwg_query($query);
$row = mysql_fetch_array($result);      
$id2=$row['id'];
$hit2=$row['hit'];
$has_high2=$row['has_high'];
$average_rate2=$row['average_rate'];

$query = '
select id
  FROM ' . IMAGES_TABLE . '
  ORDER BY id DESC;';
$result = pwg_query($query);
$row = mysql_fetch_array($result);      
$tempoids=$row['id']+1000;

        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET id= \''.$tempoids.'\'
  WHERE id = \''.$_POST['IDS1'].'\'
    ;';
$result = pwg_query($query);

        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET id= \''.$_POST['IDS1'].'\',
                hit= \''.$hit1.'\',
                average_rate= \''.$average_rate1.'\'
  WHERE id = \''.$_POST['IDS2'].'\'
    ;';
$result = pwg_query($query);

        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET id= \''.$_POST['IDS2'].'\',
                hit= \''.$hit2.'\',
                average_rate= \''.$average_rate2.'\'
  WHERE id = \''.$tempoids.'\'
    ;';
$result = pwg_query($query);

$groups = array();
$query = '
select id,name
  FROM ' . IMAGES_TABLE . '
  ORDER BY id ASC;';
$result = pwg_query($query);

while ($row = mysql_fetch_array($result))
        {
  $groups[$row['id']] = $row['id'].' : '.$row['name'];
        }
        
        $selected = 0;
        $options[] = l10n('ids_select');
        $options['a'] = '----------------------';
        
foreach($groups as $listid => $listid2)
        {
    $options[$listid] = $listid2;
        }
  $template->assign(
    'gestion',
    array(
          'OPTIONS' => $options,
      'SELECTED' => $selected
      )); 

  array_push( $page['infos'], l10n('ids_ok') );
        }  
  
        break;
        
} 

$template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
?>