.-.-.-.-.-

<?php

/*
 * Squelette : plugins/auto/zpip/extra/mot.html
 * Date :      Sun, 27 Sep 2015 12:46:09 GMT
 * Compile :   Sun, 11 Oct 2015 11:58:39 GMT
 * Boucles :   _mots_freres, _mot_cousin, _groupes_freres, _principale
 */

function BOUCLE_mots_frereshtml_b523e35d7e70c7d1aff78f89c6ad3163(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	$command['pagination'] = array((isset($Pile[0]['debut_mots_freres']) ? $Pile[0]['debut_mots_freres'] : null), 20);
	if (!isset($command['table'])) {
		$command['table'] = 'mots';
		$command['id'] = '_mots_freres';
		$command['from'] = array('mots' => 'spip_mots');
		$command['type'] = array();
		$command['groupby'] = array();
		$command['select'] = array("mots.titre",
		"mots.id_mot",
		"mots.id_groupe");
		$command['orderby'] = array('mots.titre');
		$command['join'] = array();
		$command['limit'] = '';
		$command['having'] = 
			array();
	}
	$command['where'] = 
			array(
			array('=', 'mots.type', sql_quote($Pile[$SP]['type'],'','text NOT NULL')));
	if (defined("_BOUCLE_PROFILER")) $timer = time()+microtime();
	$t0 = "";
	// REQUETE
	$iter = IterFactory::create(
		"SQL",
		$command,
		array('plugins/auto/zpip/extra/mot.html','html_b523e35d7e70c7d1aff78f89c6ad3163','_mots_freres',3,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	
	// COMPTEUR
	$Numrows['_mots_freres']['compteur_boucle'] = 0;
	$Numrows['_mots_freres']['total'] = @intval($iter->count());
	$debut_boucle = isset($Pile[0]['debut_mots_freres']) ? $Pile[0]['debut_mots_freres'] : _request('debut_mots_freres');
	if(substr($debut_boucle,0,1)=='@'){
		$debut_boucle = $Pile[0]['debut_mots_freres'] = quete_debut_pagination('id_mot',$Pile[0]['@id_mot'] = substr($debut_boucle,1),20,$iter);
		$iter->seek(0);
	}
	$debut_boucle = intval($debut_boucle);
	$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
	$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_mots_freres']['total']-1)/(20))*(20)));
	$fin_boucle = min(($tout ? $Numrows['_mots_freres']['total'] : $debut_boucle + 19), $Numrows['_mots_freres']['total'] - 1);
	$Numrows['_mots_freres']['grand_total'] = $Numrows['_mots_freres']['total'];
	$Numrows['_mots_freres']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
	if ($debut_boucle>0 AND $debut_boucle < $Numrows['_mots_freres']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
		$Numrows['_mots_freres']['compteur_boucle'] = $debut_boucle;
	
	$SP++;
	// RESULTATS
	while ($Pile[$SP]=$iter->fetch()) {

$Numrows['_mots_freres']['compteur_boucle']++;
		if ($Numrows['_mots_freres']['compteur_boucle'] <= $debut_boucle) continue;
		if ($Numrows['_mots_freres']['compteur_boucle']-1 > $fin_boucle) break;
		$t0 .= (
'
          <li class="item"><a href="' .
vider_url(urlencode_1738(generer_url_entite($Pile[$SP]['id_mot'], 'mot', '', '', true))) .
'"' .
(calcul_exposer($Pile[$SP]['id_mot'], 'id_mot', $Pile[0], $Pile[$SP]['id_groupe'], 'id_mot', '')  ?
		(' class="' . 'on' . '"') :
		'') .
'>' .
interdire_scripts(typo(supprimer_numero($Pile[$SP]['titre']), "TYPO", $connect, $Pile[0])) .
'</a></li>
          ');
	}
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_mots_freres @ plugins/auto/zpip/extra/mot.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

function BOUCLE_mot_cousinhtml_b523e35d7e70c7d1aff78f89c6ad3163(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	if (!isset($command['table'])) {
		$command['table'] = 'mots';
		$command['id'] = '_mot_cousin';
		$command['from'] = array('mots' => 'spip_mots');
		$command['type'] = array();
		$command['groupby'] = array();
		$command['select'] = array("mots.titre",
		"mots.id_mot",
		"mots.type");
		$command['orderby'] = array('mots.titre');
		$command['join'] = array();
		$command['limit'] = '0,1';
		$command['having'] = 
			array();
	}
	$command['where'] = 
			array(
			array('=', 'mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'],'','bigint(21) NOT NULL DEFAULT \'0\'')));
	if (defined("_BOUCLE_PROFILER")) $timer = time()+microtime();
	$t0 = "";
	// REQUETE
	$iter = IterFactory::create(
		"SQL",
		$command,
		array('plugins/auto/zpip/extra/mot.html','html_b523e35d7e70c7d1aff78f89c6ad3163','_mot_cousin',22,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	$SP++;
	// RESULTATS
	while ($Pile[$SP]=$iter->fetch()) {

$t0 .= (
'
          <li class="item"><a href="' .
vider_url(urlencode_1738(generer_url_entite($Pile[$SP]['id_mot'], 'mot', '', '', true))) .
'">' .
interdire_scripts(typo($Pile[$SP]['type'], "TYPO", $connect, $Pile[0])) .
'</a></li>
          ');
	}
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_mot_cousin @ plugins/auto/zpip/extra/mot.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

function BOUCLE_groupes_frereshtml_b523e35d7e70c7d1aff78f89c6ad3163(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	$doublons_index = array();

// Initialise le(s) critère(s) doublons
	if (!isset($doublons[$d = 'groupes_mots'])) { $doublons[$d] = ''; }

if (!isset($command['table'])) {
		$command['table'] = 'groupes_mots';
		$command['id'] = '_groupes_freres';
		$command['from'] = array('groupes_mots' => 'spip_groupes_mots');
		$command['type'] = array();
		$command['groupby'] = array();
		$command['select'] = array("groupes_mots.id_groupe",
		"groupes_mots.titre");
		$command['orderby'] = array('groupes_mots.titre');
		$command['join'] = array();
		$command['limit'] = '';
		$command['having'] = 
			array();
	}
	$command['where'] = 
			array(
			array('NOT', 
			array('=', 'groupes_mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'],'','bigint(21) NOT NULL AUTO_INCREMENT'))), 
			array(sql_in('groupes_mots.id_groupe', $doublons[$doublons_index[]= ('groupes_mots')], 'NOT')));
	if (defined("_BOUCLE_PROFILER")) $timer = time()+microtime();
	$t0 = "";
	// REQUETE
	$iter = IterFactory::create(
		"SQL",
		$command,
		array('plugins/auto/zpip/extra/mot.html','html_b523e35d7e70c7d1aff78f89c6ad3163','_groupes_freres',17,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	$SP++;
	// RESULTATS
	while ($Pile[$SP]=$iter->fetch()) {

foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_groupe']; // doublons

$t0 .= (
'
          ' .
BOUCLE_mot_cousinhtml_b523e35d7e70c7d1aff78f89c6ad3163($Cache, $Pile, $doublons, $Numrows, $SP) .
'
          ');
	}
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_groupes_freres @ plugins/auto/zpip/extra/mot.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

function BOUCLE_principalehtml_b523e35d7e70c7d1aff78f89c6ad3163(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	$doublons_index = array();

// Initialise le(s) critère(s) doublons
	if (!isset($doublons[$d = 'mots'])) { $doublons[$d] = ''; }

if (!isset($command['table'])) {
		$command['table'] = 'mots';
		$command['id'] = '_principale';
		$command['from'] = array('mots' => 'spip_mots');
		$command['type'] = array();
		$command['groupby'] = array();
		$command['select'] = array("mots.type",
		"mots.id_groupe",
		"mots.id_mot");
		$command['orderby'] = array();
		$command['join'] = array();
		$command['limit'] = '';
		$command['having'] = 
			array();
	}
	$command['where'] = 
			array(
			array('=', 'mots.id_mot', sql_quote(@$Pile[0]['id_mot'],'','bigint(21) NOT NULL AUTO_INCREMENT')), 
			array(sql_in('mots.id_mot', $doublons[$doublons_index[]= ('mots')], 'NOT')));
	if (defined("_BOUCLE_PROFILER")) $timer = time()+microtime();
	$t0 = "";
	// REQUETE
	$iter = IterFactory::create(
		"SQL",
		$command,
		array('plugins/auto/zpip/extra/mot.html','html_b523e35d7e70c7d1aff78f89c6ad3163','_principale',1,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	
	$l1 = _T('public|spip|ecrire:mots_clefs_meme_groupe');
	$l2 = _T('public|spip|ecrire:autres_groupes_mots_clefs');$SP++;
	// RESULTATS
	while ($Pile[$SP]=$iter->fetch()) {

foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_mot']; // doublons

$t0 .= (
'
	
  ' .
(($t1 = BOUCLE_mots_frereshtml_b523e35d7e70c7d1aff78f89c6ad3163($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		((	'
  <div class="liste mots">
      ' .
		filtre_pagination_dist($Numrows["_mots_freres"]["grand_total"],
 		'_mots_freres',
		isset($Pile[0]['debut_mots_freres'])?$Pile[0]['debut_mots_freres']:intval(_request('debut_mots_freres')),
		20, false, '', '', array()) .
		'
      <h2 class="h2">' .
		$l1 .
		'</h2>
      <ul class="liste-items">
          ') . $t1 . (	'
      </ul>
      ' .
		(($t3 = strval(filtre_pagination_dist($Numrows["_mots_freres"]["grand_total"],
 		'_mots_freres',
		isset($Pile[0]['debut_mots_freres'])?$Pile[0]['debut_mots_freres']:intval(_request('debut_mots_freres')),
		20, true, '', '', array())))!=='' ?
				('<p class="pagination">' . $t3 . '</p>') :
				'') .
		'
  </div>
  ')) :
		'') .
'

' .
(($t1 = BOUCLE_groupes_frereshtml_b523e35d7e70c7d1aff78f89c6ad3163($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		((	'
  <div class="liste groupes_mots">
      <h2 class="h2">' .
		$l2 .
		'</h2>
      <ul class="liste-items">
          ') . $t1 . '
      </ul>
  </div>
  ') :
		'') .
'
');
	}
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_principale @ plugins/auto/zpip/extra/mot.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

//
// Fonction principale du squelette plugins/auto/zpip/extra/mot.html
// Temps de compilation total: 5.196 ms
//

function html_b523e35d7e70c7d1aff78f89c6ad3163($Cache, $Pile, $doublons=array(), $Numrows=array(), $SP=0) {

if (isset($Pile[0]["doublons"]) AND is_array($Pile[0]["doublons"]))
		$doublons = nettoyer_env_doublons($Pile[0]["doublons"]);

$connect = '';
	$page = BOUCLE_principalehtml_b523e35d7e70c7d1aff78f89c6ad3163($Cache, $Pile, $doublons, $Numrows, $SP);

return analyse_resultat_skel('html_b523e35d7e70c7d1aff78f89c6ad3163', $Cache, $page, 'plugins/auto/zpip/extra/mot.html');
}
?>

/home/etiennec/www/tmp/cache/skel/html_b523e35d7e70c7d1aff78f89c6ad3163.php