<html xmlns="http://www.w3.org/1999/xhtml"><head lang="it"><base href="http://127.0.0.1/accomazzi8/sarat/addQuery.php?id=akkoNews8">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta http-equiv="Content-language" content="it">
<title>Modifica Vista</title>
<meta name="generator" content="Sar-At 8.0.0β2 di Accomazzi.net, 02.00615556">
<link href="css/classic.css" media="screen" rel="stylesheet">
<link href="css/typocolors.css" media="screen" rel="stylesheet">
<!-- user = root; query = SET NAMES utf8 -->
<!-- user = root; query = SELECT * FROM sarelqueries WHERE nameOfRepeatingBlock='akkoNews8' -->
</head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><base href="http://127.0.0.1/accomazzi8/sarat/addQuery.php?id=akkoNews8"><div style="font-family: Helvetica; font-size: 12px; color: black; text-align: left; "><br class="webkit-block-placeholder"></div><div style="font-family: Helvetica; font-size: 12px; color: black; text-align: left; "><span class="Apple-style-span" style="line-height: normal; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">Il giorno 04/giu/08, alle ore 17:07, Maurizio ha scritto:</div><blockquote type="cite" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><span class="Apple-style-span" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; color: rgb(0, 0, 0); "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">se faccio un sito in 4 lingue , avendone gia' una pronta, come faccio a duplicare la struttura vuota per le altre ed ad interfacciarle fra di loro in modo che in ogni pagina cambio il link ? </div></span></blockquote><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "></div>È una buona domanda, e ti rispondo in lista perché può interessare ad altri.<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">1. Abiliti le altre 3 lingue nella apposita schermata (menu Sito).</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">2. Cambi nome alle pagine mastro esistenti. Se la lingua iniziale è, per esempio, l'inglese, fai diventare pippo.html => pippo.html.en</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">3. Verifichi le Viste e controlli che rispettino il sito multilingue. Per esempio, se ha una sezione news e se hai una Vista che pesca le tre news più recenti in modo che finiscano in home page, allora quella Vista potrebbe essere stata programmata così:</div></span></div>
<!-- user = root; query = SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT, @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS, @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION -->
<!-- user = root; query = SET NAMES utf8 -->
<!-- user = root; query = (SELECT required_privilege, id, stringa FROM saratmenu WHERE fathermenu=0) UNION (SELECT saratmenu.required_privilege, saratmenu.id, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=0 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND minversion <= 800) ORDER BY id -->
<!-- user = root; query = SELECT groupname FROM sarelgroups WHERE creator<>'Sar-At Event Manager' -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=2002) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=2002 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = SELECT sitename FROM sarel.websites ORDER BY sitename -->
<!-- user = root; query = SELECT name FROM sareltemplates ORDER BY name -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=1000) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=1000 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=1500) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=1500 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=2000) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=2000 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=3000) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=3000 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=4000) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=4000 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = root; query = (SELECT id, required_privilege, link, stringa FROM saratmenu WHERE fathermenu=5000) UNION (SELECT saratmenu.id, saratmenu.required_privilege, saratmenu.link, utf8local.stringa FROM sarel.saratmenu, sarel.utf8local WHERE fathermenu=5000 AND saratmenu.stringid=utf8local.id AND utf8local.lingua=1 AND saratmenu.minversion <= 800) ORDER BY id -->
<!-- user = accomazzi8user; query = (SELECT paramKey, paramValue FROM sarel.sarelnewpreferences) UNION (SELECT paramKey, paramValue FROM sarelnewpreferences) -->
<!-- user = root; query = SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT, CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS, COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION -->
<!--header logo, user, logout-->
<div id="saratHeader">
<p id="stlogout"><a href="logout.php" style="text-decoration: none;"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-size: 22px; font-weight: bold;"><br></span><span style="text-decoration: underline;">Logout</span></a></p>
</div>
<!--/header logo, user, logout-->
<a name="sarat_main_content"></a>
<div id="saratAddquery" style="margin-top: 15px; padding-top: 5px; padding-right: 15px; padding-bottom: 10px; padding-left: 15px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(205, 205, 205); border-right-color: rgb(205, 205, 205); border-bottom-color: rgb(205, 205, 205); border-left-color: rgb(205, 205, 205); position: static; z-index: auto; ">
<h3 align="center"></h3>
<form action="addQuery2.php" method="post">
<table width="98%" align="center"><tbody><tr><td>
<fieldset style="position: static; z-index: auto; ">
<legend accesskey="S">Selezione e filtro<a href="/wwwsarel/showPage.php?template=manuale&masterPage=cap.html&search=C2#2" target="_blank" style="cursor: help;"><img border="0" src="img/info.png"></a></legend>
<p>La Vista conterrà pagine in <!-- user = accomazzi8user; query = SET NAMES utf8 -->
<!-- user = accomazzi8user; query = SELECT COUNT(*) AS numRighe FROM sarelnewpreferences WHERE paramKey='full-unicode' AND paramValue='Y' -->
<!-- user = accomazzi8user; query = SELECT name, (id-1000) AS id FROM sarellanguages WHERE id>1000 AND enabled='Y' ORDER BY id -->
<select name="F3"><option value="@sarellanguage">la lingua della pagina che contiene la vista</option><option value="" selected="selected">ogni lingua</option>
<option value="1">italiano</option>
<option value="2">english</option>
</select>
<input type="hidden" name="id" value="28">
<input type="hidden" name="template" value="news">
</p><p>
<label><input type="radio" name="select" value="all" checked="checked">La Vista non è filtrata e mostra tutti i record della sezione <strong><em>news</em></strong><em></em>.</label></p>
<p><label><input type="radio" name="select" value="some">Filtra, e mostra i soli record in cui <select name="whereField">
<option value="title">titolo</option>
<option value="lastMod">data di aggiornamento</option>
<option value="authorId">autore</option>
<option value="id">numero caratteristico</option><!-- user = root; query = SELECT COUNT(*) AS numRighe FROM sarelscratch WHERE template='news' AND fieldname='creation' -->
<option value="creation">data di creazione</option><!-- user = root; query = select fieldName from sarelscratch where template='news' AND incorporated='N' ORDER BY creazione -->
<option>testo</option>
<option>link</option> </select> <select name="whereOperator">
<option value="contains" selected="selected">contiene</option>
<option value="equals">è uguale a</option>
<option value="differs">è diverso da</option>
<option value="gt">è maggiore di</option>
<option value="gte">è maggiore o uguale a</option>
<option value="lt">è minore di</option>
<option value="lte">è minore o uguale a</option>
</select><p></p>
<div style="display: block; padding: 5px 0;">
<label style="margin-left: 15px;"><input type="radio" name="where" value="predefined">il valore</label>
<input type="text" autocomplete="off" name="whereText" value="" size="33" maxlength="31"> <br>
<label style="margin-left: 15px;">
<input type="radio" name="where" value="relation"><select name="relatedField">
<option value="@id">numero caratteristico</option>
<option value="@sarel_username">nome utente registrato</option>
<option value="@sarellanguage">codice lingua</option>
<option value="@language">sigla lingua</option>
<option value="@masterPage">pagina mastro</option>
<option value="@template">sezione</option></select>della pagina corrente<a href="/wwwsarel/showPage.php?template=manuale&masterPage=cap.html&search=C2#22" target="_blank" style="cursor: help;"><img border="0" src="img/info.png"></a> </label><br>
<label style="margin-left: 15px;">
<input type="radio" name="where" value="user">un valore scelto dal visitatore, e la pagina HTML invocherà questa Vista passando il parametro <i>search</i><a href="/wwwsarel/showPage.php?template=manuale&masterPage=cap.html&search=C2#16" target="_blank" style="cursor: help;"><img border="0" src="img/info.png"></a> </label>
</div>
<p><label><input type="radio" name="select" value="fulltext" disabled="disabled"><span style="color:grey;">Effettua una ricerca a tutto testo<a href="/wwwsarel/showPage.php?template=manuale&masterPage=cap.html&search=C2#23" target="_blank" style="cursor: help;"><img border="0" src="img/info.png"></a></span><br>
<blockquote><span class="piccino">La ricerca a tutto testo non è disponibile perché non sono stati selezionati i campi multipli su cui può operare.<br>
<a href="setFulltext.php?table=news">Seleziona i campi per la ricerca a tutto testo</a>.</span></blockquote>
</label></p>
<p><label>Verranno presentate contemporaneamente informazioni da non più di <input type="text" autocomplete="off" name="limit" value="3" size="4" maxlength="2">
record.</label></p></label></p></fieldset></td></tr></tbody></table>
</form>
</div>
<div style="font-family: Helvetica; font-size: 12px; color: black; text-align: left; ">Invece va cambiata perché dica "<span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 11px; line-height: 15px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">La Vista conterrà pagine in p</span>agine nella lingua della pagina corrente". Cioè, nella home page tedesca vanno messe le news tedesche, non quelle italiane.</div><div style="font-family: Helvetica; font-size: 12px; color: black; text-align: left; "><br></div><div style="font-family: Helvetica; font-size: 12px; color: black; text-align: left; "><span class="Apple-style-span" style="line-height: normal; "><div>4. Traduci le pagine mastro, quindi per esempio creerai pippo.html.it, pippo.html.de, pippo.html.fr</div><div><br></div><div>Se hai fatto tutto per bene, funzionerà tutto e non ci sarà alcun bisogno di cambiare alcun link interno.</div><div><br></div><div>L.A.</div></span></div></body></html>