source: extensions/MyPiwiShop/admin/options.php

<?php
defined('MPS_PATH') or die('Hacking attempt!');

// define type option
  $select_type_opt=array(
  'select'   =>'select',
  'radio'    =>'radio',
  'text'     =>'text',
  'textarea' =>'textarea',
  'checkbox' =>'checkbox',
  );
 
// delete option
  if(isset($_POST['check'])) {
  
   foreach($_POST['check'] AS $delete_id){
   
   pwg_query('
   DELETE FROM '.MPS_OPTION_TABLE.' 
   WHERE `id` = '.$delete_id.';
   ');
   
   pwg_query('
   DELETE FROM '.MPS_PROD_OPT_TABLE.' 
   WHERE `opt_id` = '.$delete_id.';
   ');
  
   pwg_query('
   DELETE FROM '.MPS_OPT_VAL_TABLE.' 
   WHERE `select_id` = '.$delete_id.';
   ');
   
   $page['infos']=l10n('deleted');
   }
   
  }   

// add/edit option
  if (isset($_POST['option_add'])) {

  //add option
        if(empty($_POST['id'])) {
         $order = array();
         
         $query ='SELECT * 
         FROM '.MPS_OPTION_TABLE.';';
         $result = pwg_query($query);
         
         while($row = pwg_db_fetch_assoc($result)) {
       $order[] = $row['order'];
         }
         
         if (count($order) == 0) {
          $order = 1;
         } else {
          $order = max($order)+1;
         }
        
         $name          = $_POST['name'];
     $type              = $_POST['type'];
     $title             = $_POST['title'];
         
         if(isset($_POST['requi'])) {
          $requi = $_POST['requi'];
         } else {
          $requi = 0;
         }
        
         pwg_query('
         INSERT into '.MPS_OPTION_TABLE.' (`name`,`type`,`titre`,`requi`,`order`) 
         VALUE (\''.$name.'\',\''.$type.'\',\''.$title.'\',\''.$requi.'\',\''.$order.'\')
         ;');
   
         $select_id = pwg_db_insert_id();                       
                        
         if(isset($_POST['val'])) {
         $val           = $_POST['val'];
         
      foreach($val as $val_ele) {
           pwg_query('
           INSERT into '.MPS_OPT_VAL_TABLE.' (`val` , `select_id`) 
           VALUE (\''.$val_ele.'\',\''.$select_id.'\')
           ;');
      }
          
         }
         $page['infos']=l10n('Option registered');
        }
        
  //edit option
    if(!empty($_POST['id'])) {

         $name  = $_POST['name'];
     $type      = $_POST['type'];
     $title     = $_POST['title'];
         $id    = $_POST['id'];
        
         if(isset($_POST['requi'])) {
           $requi = $_POST['requi'];
          } else {
           $requi = 0;
          }

         pwg_query('    
         UPDATE '.MPS_OPTION_TABLE.' 
         SET `name` = \''.$name.'\', `type` = \''.$type.'\', `titre` = \''.$title.'\', `requi` = \''.$requi.'\'
         WHERE `id` = '.$id.'
         ;');
        
         pwg_query('
         DELETE FROM '.MPS_OPT_VAL_TABLE.' 
         WHERE `select_id` =  '.$id.'
         ;');
   
         if(isset($_POST['val'])){
         $val           = $_POST['val'];
         
      foreach($val as $val_ele)
      {
           pwg_query('
           INSERT into '.MPS_OPT_VAL_TABLE.' (`val` , `select_id`) 
           VALUE (\''.$val_ele.'\',\''.$id.'\')
           ;');
      }
          
         }
         
    $page['infos']=l10n('Option registered');
        }
  }

// change option order
  if(isset($_POST['newOrder'])) {
  
   $newOrder = explode(",", $_POST['newOrder']);
   $ex           = array_pop($newOrder);
   
        foreach( $newOrder as $order => $id ) {
        
         $order = $order +1;
     pwg_query('
         UPDATE '.MPS_OPTION_TABLE.' 
         SET `order` = \''.$order.'\' 
         WHERE `id` = '.$id.'
         ;');
     }  
         
        $page['infos']=l10n('the order is changed');
  }

// set option
  $query='
  SELECT o.id, o.titre, o.name, o.type, o.requi, o.order, ov.val
  FROM '.MPS_OPTION_TABLE.' AS o
  LEFT JOIN '.MPS_OPT_VAL_TABLE.' AS ov ON ov.select_id = o.id
  ORDER BY o.order 
  ;';
  
  $result = pwg_query($query);
   while($row = pwg_db_fetch_assoc($result)) {
   
        if (!isset($option[ $row['id']])) {
     $option[$row['id']] = array(
          'id'    => $row['id'],
          'title' => $row['titre'],
          'name'  => $row['name'],
          'type'  => $row['type'],
          'requi' => $row['requi'],
         );
        }
        $option[$row['id']]['val'][]=$row['val'];
        
   }
  
//template assign
  $template->assign(array(
         'mps_option'   => $option,
         'mps_type_opt' => $select_type_opt
         ));

  $template->set_filename('mps_content', realpath(MPS_PATH . 'admin/template/options.tpl'));