CMS Made Simple Forums

Code: Select all

<?php


    $IDTipodocumento = array();
    $query = "SELECT IDTipodocumento, Tipo_documento, Predefinito 
    FROM
    ".cms_db_prefix()."tipidocumenti ORDER BY Tipo_documento";
    $dbresult = $db->Execute($query);
    
    while ($dbresult && $row = $dbresult->FetchRow())
      {
	$tipo_documento[$row['Tipo_documento']] = $row['IDTipodocumento'];
	}


$onChangeText="onChange=\"getcategory(this.value);\"";
## - tipo_documento (select)
	$this->smarty->assign('tipo_documentotext', $this->Lang('tipo_documento'));
	$this->smarty->assign('inputtipo_documento', $this->CreateInputDropdown($id, 'tipo_documento',
        $tipo_documento, -1, $tipo_documento_predefinito, $onChangeText));
    
    ## - category (select)
	$this->smarty->assign('categorytext', $this->Lang('category'));
	$this->smarty->assign('inputcategory', $this->CreateInputDropdown($id, 'category',
        $category, -1, $category_predefinita));
	

echo $this->ProcessTemplate('edit_documento.tpl');
?>

Code: Select all

<?php
$IDTipodocumento=intval($_GET['IDTipodocumento']);

 	$category = array();
	$query = "SELECT * FROM ".cms_db_prefix()."categories
        WHERE
        IDTipodocumento = $IDTipodocumento";
	$dbresult = $db->Execute($query);
    
    while ($dbresult && $row = $dbresult->FetchRow())
      {
	$category[$row['category']] = $row['IDcategory'];
	}
  ## - category (select)
	$this->smarty->assign('inputcategory', $this->CreateInputDropdown($id, 'category',
        $category, -1, $category_predefinita));
?>

Code: Select all

{literal}

<__script__ type="text/javascript">

function getXMLHTTP() {
		var xmlhttp=false;	
		try{
			xmlhttp=new XMLHttpRequest();
		}
		catch(e)	{		
			try{			
				xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch(e){
				try{
				xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
				}
				catch(e1){
					xmlhttp=false;
				}
			}
		}
		 	
		return xmlhttp;
	}
	
	
	
function getcategory(strURL) {		
		
		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('div_IDcategory').innerHTML=req.responseText;						
					} else {
						alert("Problema con XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", "../modules/MIOMODULO/action.queryAjax.php?IDTipodocumento="+strURL, true);
			req.send(null);
		}
				
	}
</__script>

{/literal}


{* tipo_documento *}
    	<div class="pageoverflow">
		<p class="pagetext">{$tipo_documentotext}:</p>
		<p class="pageinput">{$inputtipo_documento}</p>
	</div>

{* category *}
	<div id="div_IDcategory" class="pageoverflow">
		<p class="pagetext">{$categorytext}:</p>
		<p class="pageinput">{$inputcategory}</p>
	</div>

Code: Select all

<?php

//************* AGGIUNTO ****************************************
if(session_id() == "") { @session_start(); }
$path = dirname(dirname(dirname($_SERVER['SCRIPT_FILENAME'])));
require $path . DIRECTORY_SEPARATOR . 'include.php';
$db=&$GLOBALS["gCms"]->db;
$id = filter_var($_GET['id'], FILTER_SANITIZE_STRING);
if (!isset($gCms)) exit;
//***************************************************************

$params['IDTipodocumento']=filter_var($_GET['IDTipodocumento'], FILTER_SANITIZE_NUMBER_INT); // Filtro PHP5

if( isset($params['IDTipodocumento']) )
 {
 $IDTipodocumento = $params['IDTipodocumento'];
 }

 	$category = array();
	$query = "SELECT * FROM ".cms_db_prefix()."categories
        WHERE
        IDTipodocumento = ?";
	$dbresult = $db->Execute($query, array($IDTipodocumento));
    
    while ($dbresult && $row = $dbresult->FetchRow())
      {
	$category[$row['category']] = $row['IDcategory'];
	}
  ## - category (select)
	//$this->smarty->assign('inputcategory', $this->CreateInputDropdown($id, 'category',
        //$category, -1, $category_predefinita));

	$inputcategory="<p class=\"pagetext\">Category:</p><p class=\"pageinput\">
                       <select name=\"".$id."category\">
                       <option value=\"-1\"> ------  </option>";

    while ($dbresult && $row = $dbresult->FetchRow())
      {
		//$category[$row['category']] = $row['IDCategory'];
		$inputcategory .="<option value=\"".$row['IDCategory']."\">".$row['Category']."</option>";
 		 }
  		$inputcategory .="</select></p>";
		echo $inputcategory
?>

Code: Select all

<?php
$params['category']= filter_var($_POST['category'], FILTER_SANITIZE_NUMBER_INT);
	
		if( isset($params['category']) )
	     {
		$category= $params['category'];
	     }
?>