Xoops Italia :: Articolo
Articolo XML
http://www.xoopsitalia.org/modules/article/view.article.php/72/c10
2013-05-19T00:18:18+02:00
defkon1 at gmail dot com
ARTICLE @ XOOPS powered by FeedCreator
La foto del giorno? Semplice con questo hack!
2008-05-11T13:21:44+02:00
2008-05-11T13:21:44+02:00
2008-05-11T13:21:44+02:00
http://www.xoopsitalia.org/modules/article/view.article.php/72/c10
slyss
Categoria: Hack per Xoops 2.0.x<br />Riassunto: Con una semplice funzione è possibile visualizzare un blocco PHP contenente una foto impostando certi parametri personalizzabili! Tutto è molto semplice e richiede una galleria myalbum.Ciao a tutti...<br /><br />mi arrivano privatamente molte richieste di aiuto per creare blocchi che visualizzino immagini presenti nelle gallerie myalbum. Molte volte mi è stato chiesto di poter visualizzare una foto random, oppure l'ultima foto inserita dagli utente, ecc... Bene, con questa mia funzione è possibile inserire infiniti blocchi secondo le più diverse necessità.<br /><br />INIZIAMO:<br /><br />aprite il file root/include/functions.php ed alla fine, prima del tag di chiusura php inserite questa funzione:<br /><br /><div class="xoopsCode"><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #FF8000">/****** hack by <a href="http://www.stefanosilvestrini.com" title="www.stefanosilvestrini.com" rel="external">www.stefanosilvestrini.com</a> *****/
<br /></span><span style="color: #007700">function </span><span style="color: #0000BB">getPicGallery</span><span style="color: #007700">(</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">, </span><span style="color: #0000BB">$cid</span><span style="color: #007700">, </span><span style="color: #0000BB">$random</span><span style="color: #007700">) {
<br /> global </span><span style="color: #0000BB">$xoopsConfig</span><span style="color: #007700">;
<br /> </span><span style="color: #0000BB">$db </span><span style="color: #007700">=& </span><span style="color: #0000BB">Database</span><span style="color: #007700">::</span><span style="color: #0000BB">getInstance</span><span style="color: #007700">();
<br /> </span><span style="color: #0000BB">$myalbumNum </span><span style="color: #007700">= </span><span style="color: #0000BB">trim</span><span style="color: #007700">(</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">);
<br /> if(</span><span style="color: #0000BB">$random </span><span style="color: #007700">!= </span><span style="color: #0000BB">1</span><span style="color: #007700">) </span><span style="color: #0000BB">$sql </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT s.lid AS lid, s.ext AS ext FROM "</span><span style="color: #007700">.</span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">prefix</span><span style="color: #007700">(</span><span style="color: #DD0000">'myalbum'</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">'_photos'</span><span style="color: #007700">).</span><span style="color: #DD0000">" s, "</span><span style="color: #007700">.</span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">prefix</span><span style="color: #007700">(</span><span style="color: #DD0000">'myalbum'</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">'_cat'</span><span style="color: #007700">).</span><span style="color: #DD0000">" t WHERE s.cid = t.cid AND s.cid = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$cid</span><span style="color: #007700">.</span><span style="color: #DD0000">" ORDER BY s.lid DESC LIMIT 1"</span><span style="color: #007700">;
<br /> else </span><span style="color: #0000BB">$sql </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT s.lid AS lid, s.ext AS ext FROM "</span><span style="color: #007700">.</span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">prefix</span><span style="color: #007700">(</span><span style="color: #DD0000">'myalbum'</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">'_photos'</span><span style="color: #007700">).</span><span style="color: #DD0000">" s, "</span><span style="color: #007700">.</span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">prefix</span><span style="color: #007700">(</span><span style="color: #DD0000">'myalbum'</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">'_cat'</span><span style="color: #007700">).</span><span style="color: #DD0000">" t WHERE s.cid = t.cid AND s.cid = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$cid</span><span style="color: #007700">.</span><span style="color: #DD0000">" ORDER BY RAND() LIMIT 1"</span><span style="color: #007700">;
<br /> </span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$myrow </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchArray</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$object </span><span style="color: #007700">= </span><span style="color: #DD0000">"<div style='text-align: center;'>"
<br /> </span><span style="color: #007700">.</span><span style="color: #DD0000">"<a href='"</span><span style="color: #007700">.</span><span style="color: #0000BB">XOOPS_URL</span><span style="color: #007700">.</span><span style="color: #DD0000">"/modules/myalbum"</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">"/photo.php?lid="</span><span style="color: #007700">.</span><span style="color: #0000BB">$myrow</span><span style="color: #007700">[</span><span style="color: #DD0000">'lid'</span><span style="color: #007700">].</span><span style="color: #DD0000">"'>"
<br /> </span><span style="color: #007700">.</span><span style="color: #DD0000">"<img src='"</span><span style="color: #007700">.</span><span style="color: #0000BB">XOOPS_URL</span><span style="color: #007700">.</span><span style="color: #DD0000">"/uploads/thumbs"</span><span style="color: #007700">.</span><span style="color: #0000BB">$myalbumNum</span><span style="color: #007700">.</span><span style="color: #DD0000">"/"</span><span style="color: #007700">.</span><span style="color: #0000BB">$myrow</span><span style="color: #007700">[</span><span style="color: #DD0000">'lid'</span><span style="color: #007700">].</span><span style="color: #DD0000">"."</span><span style="color: #007700">.</span><span style="color: #0000BB">$myrow</span><span style="color: #007700">[</span><span style="color: #DD0000">'ext'</span><span style="color: #007700">].</span><span style="color: #DD0000">"' align='center' hspace='3' vspace='3' width='100px' />"
<br /> </span><span style="color: #007700">.</span><span style="color: #DD0000">"</a>"
<br /> </span><span style="color: #007700">.</span><span style="color: #DD0000">"</div>"</span><span style="color: #007700">;
<br /> return </span><span style="color: #0000BB">$object</span><span style="color: #007700">;
<br />}</span><span style="color: #0000BB"></span>
</span>
</code></div><br /><br />chiudete e salvate.<br /><br />A questo punto è tutto molto semplice!<br /><br />Create un blocco <strong>PHP</strong> e richiamate la funzione in questo modo:<br /><br /><div class="xoopsCode"><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">echo </span><span style="color: #0000BB">getPicGallery</span><span style="color: #007700">(</span><span style="color: #DD0000">''</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">);</span><span style="color: #0000BB"></span>
</span>
</code></div><br /><br />dove i paramentri sono nell'ordine:<br /><strong><br />- numero Myalbum (lasciare vuoto se è myalbum di base)<br />- cid = categoria relativa alla foto<br />- ordine: 1 = foto random; 0 = ultima foto inserita<br /></strong><br />Come è facile immaginare, questo hack può essere utilizzato il migliaia di modi differenti... Io per esempio lo uso per visualizzare le ultime foto inserite dagli utenti, ecc..<br /><br />Spero vi sia utile <img class="imgsmile" src="http://www.xoopsitalia.org/uploads/smil3dbd4e398ff7b.gif" alt="" /><br /><br />a presto!!!<br /><br />sly :ok<br /><br />ps: il risultato della chiamata della funzione <br /><br /><div class="xoopsCode"><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">echo </span><span style="color: #0000BB">getPicGallery</span><span style="color: #007700">(</span><span style="color: #DD0000">''</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">, </span><span style="color: #DD0000">'1'</span><span style="color: #007700">);</span><span style="color: #0000BB"></span>
</span>
</code></div><br /><br /> la potete vedere nel blocco <strong>Function Block by slyss</strong> su <a href="http://www.stefanosilvestrini.com/lab/" title="http://www.stefanosilvestrini.com/lab/" rel="external">http://www.stefanosilvestrini.com/lab/</a><br />