<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/atom10full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><feed xmlns="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" gd:etag="W/&quot;Ak4NQXw9cCp7ImA9WhVTFEo.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309</id><updated>2012-02-28T20:59:50.268-04:30</updated><category term="linux" /><category term="juegos" /><category term="reCATPCHA" /><category term="Static Map API" /><category term="javascript" /><category term="mysql" /><category term="optimización web" /><category term="Google Maps API" /><category term="html5" /><category term="php" /><category term="ajax" /><category term="photoshop" /><category term="tutorial" /><category term="codeigniter" /><category term="optimizar imágenes" /><category term="crm" /><category term="autocomplete" /><category term="http" /><category term="jquery UI" /><category term="jquery" /><category term="jquery plugin" /><category term="tags" /><category term="multilenguaje" /><category term="API twitter" /><category term="suddominios dinamicos" /><category term="debian" /><category term="herramientas webmaster" /><category term="gd" /><category term="vtiger" /><category term="SysadminDAY" /><title>El SOS Informatico. Desarrollo y programacion web.</title><subtitle type="html">Codeigniter, php, jquery, desarrollo web y algo más.</subtitle><link rel="http://schemas.google.com/g/2005#feed" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/posts/default" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/" /><link rel="next" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default?start-index=26&amp;max-results=25&amp;redirect=false&amp;v=2" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><generator version="7.00" uri="http://www.blogger.com">Blogger</generator><openSearch:totalResults>58</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/atom+xml" href="http://feeds.feedburner.com/ElSosInformaticoDesarrolloYProgramacionWeb" /><feedburner:info xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" uri="elsosinformaticodesarrolloyprogramacionweb" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><entry gd:etag="W/&quot;A0QAQX0-cCp7ImA9WhRXE0g.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-2428828480737755405</id><published>2011-12-20T01:05:00.000-04:30</published><updated>2011-12-20T01:05:40.358-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-20T01:05:40.358-04:30</app:edited><title>Ver paginas 3D con Web 3d tilt</title><content type="html">&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://static-cdn.addons.mozilla.net/en-US/firefox/images/addon_icon/336188-64.png?modified=1320910624" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="https://static-cdn.addons.mozilla.net/en-US/firefox/images/addon_icon/336188-64.png?modified=1320910624" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Ahora les presento un Plugin para firefox, muy&amp;nbsp;útil&amp;nbsp;que nos permite ver paginas 3D,&amp;nbsp;así&amp;nbsp;como lo leen, su pagina se vera 3D, el plugin lo que hace es&amp;nbsp;rende rizar&amp;nbsp;su pagina con Webgl, y mostrar las partes de la pagina detallada con diferentes colores para identificar los elementos que la componen. Es muy util para diseñadores o desarrolladores web.&lt;br /&gt;
&lt;br /&gt;
Para ver una pagina web en 3D no tenemos más que descargar el&amp;nbsp;complemento&amp;nbsp;&lt;a href="https://addons.mozilla.org/es-es/firefox/addon/tilt/"&gt;https://addons.mozilla.org/es-es/firefox/addon/tilt/&lt;/a&gt;&amp;nbsp;(previamente tenemos que tener instalado los drivers de la tarjeta&amp;nbsp;gráfica) y&amp;nbsp;después&amp;nbsp;de reiniciar en cualquier pagina solo tenemos que marcar Ctrl + Mayus + M, y sharan se hace la magia.&lt;br /&gt;
&lt;br /&gt;
Una caracteriztica importante, es que permite exportar la imagen en 3d, para despues ser usado en programas como blender.&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-pmmFtSsgdqo/TvAekriMDEI/AAAAAAAAAJM/_EkugqsMEyM/s1600/Sin-t%25C3%25ADtulo.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="256" src="http://4.bp.blogspot.com/-pmmFtSsgdqo/TvAekriMDEI/AAAAAAAAAJM/_EkugqsMEyM/s320/Sin-t%25C3%25ADtulo.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Otra pafina donde hablan sobre el tema:&amp;nbsp;&lt;a href="http://hacks.mozilla.org/2011/07/tilt-visualize-your-web-page-in-3d/"&gt;http://hacks.mozilla.org/2011/07/tilt-visualize-your-web-page-in-3d/&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-2428828480737755405?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/2428828480737755405/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/ver-paginas-3d-con-web-3d-tilt.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2428828480737755405?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2428828480737755405?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/ver-paginas-3d-con-web-3d-tilt.html" title="Ver paginas 3D con Web 3d tilt" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-pmmFtSsgdqo/TvAekriMDEI/AAAAAAAAAJM/_EkugqsMEyM/s72-c/Sin-t%25C3%25ADtulo.jpg" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;Ck4HRHs6eCp7ImA9WhRRGE0.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-2371632296980397485</id><published>2011-12-01T21:54:00.001-04:30</published><updated>2011-12-02T00:12:15.510-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-02T00:12:15.510-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="jquery plugin" /><category scheme="http://www.blogger.com/atom/ns#" term="jquery" /><category scheme="http://www.blogger.com/atom/ns#" term="jquery UI" /><title>JqGrid Un Grid para Jquery</title><content type="html">&lt;br /&gt;
Hoy les presento un plugin para jQuery muy&amp;nbsp;útil, el cual te permite crear Grid muy completos con algunas &amp;nbsp;pequeñas lineas de&amp;nbsp;código.&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://www.trirand.com/jqgridwiki/lib/tpl/monobook/user/logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://www.trirand.com/jqgridwiki/lib/tpl/monobook/user/logo.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;br /&gt;&lt;/div&gt;
Esta herramienta es muy poderoso y permite hasta cierto punto crear un grid completo con filtros,&amp;nbsp;búsqueda,&amp;nbsp;organización&amp;nbsp;ascendente y descendente, paginación, etc casi sin necesidad que del lado del servidor halla&amp;nbsp;código. &amp;nbsp;También&amp;nbsp;se puede crear un Crud completo y bastante avanzado, con multigrid, grid dentro de grids, etc, con un poco más de&amp;nbsp;interacción&amp;nbsp;con un lenguaje del lado del servidor.&lt;br /&gt;
&lt;br /&gt;
Otra&amp;nbsp;Característica&amp;nbsp;destacable de este plugin es que se ajusta a el jQuery UI, lo cual permite que se integre con &amp;nbsp;el diseño de nuestra interfaz con mucha facilidad. y modificarlo como queramos.&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/-JSuoTymBMIw/TthAyqGVw6I/AAAAAAAAAI4/cMEK5hPp8lA/s1600/Sin+nombre.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="132" src="http://2.bp.blogspot.com/-JSuoTymBMIw/TthAyqGVw6I/AAAAAAAAAI4/cMEK5hPp8lA/s320/Sin+nombre.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
En este tutorial vamos a crear un Grid muy&amp;nbsp;básico&amp;nbsp;sin nada de&amp;nbsp;interacción&amp;nbsp;con el servidor, solo usando un array javascript con los datos, para ir viendo las funcionalidades de este poderoso plugin. &amp;nbsp;Por ahora solo vamos a trabajar con lo&amp;nbsp;básico&amp;nbsp;para que nos podamos ir sintiendo a gusto con este plugin.&lt;br /&gt;
&lt;br /&gt;
Lo primero es descargar los archivos necesarios, de la pagina de &lt;a href="http://www.trirand.com/"&gt;jqgrid&lt;/a&gt; nos descargamos la ultima actualización del plugin y de la pagina de &lt;a href="http://jqueryui.com/"&gt;jquery UI&lt;/a&gt; nos descargamos el tema de nuestra preferencia.&lt;br /&gt;
&lt;br /&gt;
Y ahora configuramos el area de trabajo de esta manera:&lt;br /&gt;
&lt;br /&gt;
./css/ui.jqgrid.css&lt;br /&gt;
./css/images //adentro van las imagenes del tema.&lt;br /&gt;
./css/jquery-ui-1.8.16.custom.css&lt;br /&gt;
./js/jquery-1.5.2.min.js&lt;br /&gt;
./js/grid.locale-es.js&lt;br /&gt;
./js/jquery.jqGrid.min.js&lt;br /&gt;
./jqgrid.html&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El archivo jqgrid.html sera donde crearemos el grid, lo primero es poner la estructura&amp;nbsp;básica&amp;nbsp;html, cuando pongamos los enlaces de jqgrid, debemos colocar primero el de idioma y&amp;nbsp;después&amp;nbsp;el de jqgrid porque sino nos dara error.&amp;nbsp;Después&amp;nbsp;agregamos una tabla dentro del body y le colocamos el id igual a list. Ya con esto podemos empezar a examinar este plugin.&lt;br /&gt;
&lt;br /&gt;
Este plugin se manejo como todos los plugins de Jquery, primero $ + un selector + la&amp;nbsp;función&amp;nbsp;jqGrid + objeto con las opciones, en este tutorial voy a hacer un listado de las opciones básicas &lt;a href="http://www.trirand.com/jqgridwiki/doku.php?id=wiki:options"&gt;(el listado completo esta aqui!)&lt;/a&gt;, para hacer el ejemplo&amp;nbsp;básico:&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Variables indispensables&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;datatype:&lt;/b&gt; especifica el tipo de dato que va a esperar jqgrid para hacer la&amp;nbsp;representación&amp;nbsp;de datos. los valores posibles son:&amp;nbsp;xml,&amp;nbsp;json,&amp;nbsp;jsonp,&amp;nbsp;local,&amp;nbsp;xmlstring,&amp;nbsp;jsonstring,&amp;nbsp;javascript.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;colNames:&lt;/b&gt;&amp;nbsp;aquí&amp;nbsp;se especifica el array javascript con los nombres de las columnas que se&amp;nbsp;verán&amp;nbsp;en el Grid.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;colModel:&lt;/b&gt; esta es la más importante de todas, y debe estar en el mismo orden que colNames, desde&amp;nbsp;aquí&amp;nbsp;se especifican nombres, ancho, opciones de busqueda, filtros, ordenación, etc. es como la columna&amp;nbsp;vertebral&amp;nbsp;del jqGrid.&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Variables opcionales basicas para este ejemplo:&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;caption:&lt;/b&gt; Especifica un nombre a la tabla.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;data: &lt;/b&gt;especifica cual es el source cuando la variable es local. EL array debe seguir el&amp;nbsp;patrón&amp;nbsp;de colModel.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;height:&lt;/b&gt; especifica la altura de el grid.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;altRows:&lt;/b&gt; le pone la alternancia de colores a la tabla.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Especificaciones del &lt;i&gt;colModel&lt;/i&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
El colModel como dije antes es la columna vertebral de este plugin y es donde se especifica cual va a ser la estructura y el comportamiento de cada una de las columnas, tenemos que tener claro que deben ser especificados en el mismo orden que especificamos los nombres de cada columna. Cada columna tiene las siguientes opciones&amp;nbsp;básicas:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;name:&lt;/b&gt; esta variable especifica el nombre unico de esa columna, no puede haber otra columna con el mismo nombre ni en subgrids.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;align&amp;nbsp;&lt;/b&gt;&lt;i&gt;&lt;b&gt;(opcional):&lt;/b&gt; &lt;/i&gt;esta variable especifica como se va a alinear el texto en la celda:&amp;nbsp;left, center, right.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;width&amp;nbsp;&lt;/b&gt;&lt;i&gt;&lt;b&gt;(opcional):&lt;/b&gt; &lt;/i&gt;define el ancho de la columna, por defecto es 150px.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;sortable&amp;nbsp;&lt;/b&gt;&lt;i&gt;&lt;b&gt;(opcional):&lt;/b&gt; &lt;/i&gt;especifica si la columna puede ser ordenable&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Ejemplo de Grid&amp;nbsp;básico&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
Ahora si,&amp;nbsp;aquí&amp;nbsp;vamos con el ejemplo sencillo, la información es aleatoria, pero las claves deben ser las mismas el atributo name del colModel, voy a agregar la información a el Grid de dos maneras, una con el atributo data y otra con el metodo addRowData para agregar la fila al Grid, en la pagina recomiendan que para objetos grandes se haga con el atributo, pero es bueno conocer los dos&amp;nbsp;métodos.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"&amp;gt; 
&amp;lt;html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"&amp;gt; 
    &amp;lt;head&amp;gt; 
     &amp;lt;title&amp;gt;prueba&amp;lt;/title&amp;gt; 
     &amp;lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&amp;gt;
  &amp;lt;link rel="stylesheet" type="text/css" href="css/jquery-ui-1.8.16.custom.css" /&amp;gt; 
  &amp;lt;link rel="stylesheet" type="text/css" href="css/ui.jqgrid.css" /&amp;gt; 
     &amp;lt;script src="js/jquery-1.5.2.min.js" type="text/javascript"&amp;gt;&amp;lt;/script&amp;gt; 
     &amp;lt;script src="js/grid.locale-es.js" type="text/javascript"&amp;gt;&amp;lt;/script&amp;gt; 
     &amp;lt;script src="js/jquery.jqGrid.min.js" type="text/javascript"&amp;gt;&amp;lt;/script&amp;gt; 
  &amp;lt;script type="text/javascript"&amp;gt; 
  var mydata = [ {id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}, {id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}, {id:"7",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"}, {id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"}, {id:"9",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"} ]; 
  $(document).ready(function(){
  $("#list").jqGrid({ 
   datatype: "local", 
   data: mydata,
   height: 250, 
   colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'], 
   colModel:[ 
    {name:'id',index:'id', width:60}, 
    {name:'invdate',index:'invdate', width:90}, 
    {name:'name',index:'name', width:100},
    {name:'amount',index:'amount', width:80, align:"right"}, 
    {name:'tax',index:'tax', width:80, align:"right"}, 
    {name:'total',index:'total', width:80,align:"right"}, 
    {name:'note',index:'note', width:150, sortable:false}
    ], 
   caption: "http://sosinformatico.blogspot.com",
   altRows: true
  });
  
   for(var i=0;i&amp;lt;=mydata.length;i++) 
    jQuery("#list").jqGrid('addRowData',i+1,mydata[i]);
  });
  &amp;lt;/script&amp;gt;
    &amp;lt;/head&amp;gt; 
    &amp;lt;body&amp;gt; 
     &amp;lt;table id='list'&amp;gt;&amp;lt;/table&amp;gt;
 &amp;lt;/body&amp;gt;
&amp;lt;/html&amp;gt;
&lt;/pre&gt;
&lt;br /&gt;
A la final se&amp;nbsp;debería&amp;nbsp;ver&amp;nbsp;así:&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/-wv9FykoFvy8/TthW3vY3OdI/AAAAAAAAAJA/rFQmm42YNoo/s1600/Sin+nombre.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="146" src="http://2.bp.blogspot.com/-wv9FykoFvy8/TthW3vY3OdI/AAAAAAAAAJA/rFQmm42YNoo/s320/Sin+nombre.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Despues pienso sacar 3 tutoriales más un con un grid más avanzado, y dos integrandolo con Codeigniter y Python. Estos ultimos quiero hacerlos como screencast por eso me voy a tardar un poquito más.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-2371632296980397485?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/2371632296980397485/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/12/jqgrid-un-grid-para-jquery.html#comment-form" title="4 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2371632296980397485?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2371632296980397485?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/12/jqgrid-un-grid-para-jquery.html" title="JqGrid Un Grid para Jquery" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/-JSuoTymBMIw/TthAyqGVw6I/AAAAAAAAAI4/cMEK5hPp8lA/s72-c/Sin+nombre.jpg" height="72" width="72" /><thr:total>4</thr:total></entry><entry gd:etag="W/&quot;DU8GRXoyeip7ImA9WhRRFkQ.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-3443310903087503296</id><published>2011-11-28T21:45:00.001-04:30</published><updated>2011-11-30T19:33:44.492-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-11-30T19:33:44.492-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="mysql" /><title>Consulta Mysql para agrupar por fechas y funciones de fecha.</title><content type="html">Llevo tiempo sin escribir en el blog, por el trabajo. Pero voy a aprovechar estos dias para escribir un poco sobre algunas cosas que e aprendido trabajando, que me han sido de utilidad y por lo general en&amp;nbsp;Internet&amp;nbsp;no hay&amp;nbsp;documentación&amp;nbsp;en español.&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://dev.mysql.com/common/logos/logo-mysql-110x57.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://dev.mysql.com/common/logos/logo-mysql-110x57.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Este primer post voy a hablar de como se hace en mysql para agrupar fechas por&amp;nbsp;días,&amp;nbsp;mes, año,&amp;nbsp;minuto&amp;nbsp;hora, etc. &amp;nbsp;Además de algunas funciones&amp;nbsp;útiles de mysql:&lt;br /&gt;
&lt;br /&gt;
Cuando hacemos un GROUP BY de un campo datetime, timestamp, date o time. Por defecto el va agrupar por supuesto por valores iguales. El problema es que para que dos datetime sean iguales tienen que tener el&amp;nbsp;día&amp;nbsp;y la hora exacta, lo cual no es muy&amp;nbsp;común&amp;nbsp;que esto ocurra. Entonces para ello sql acepta que apliquemos funciones para hacer los GROUP BY, es decir, que para lograr lo anterior solo tenemos que agregar una&amp;nbsp;función&amp;nbsp;que nos de el mes la hora o lo que queramos para poder hacer la agrupación.&lt;br /&gt;
&lt;br /&gt;
Funciones de fecha que nos pueden servir:&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;b&gt;&lt;a href="http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_extract"&gt;EXTRACT( Unidad de una fecha)&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Esta funcion extrae de una fecha lo que nosotros le pidamos(esta es la más recomendada por el rendimiento, un ejemplo seria:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="programlisting" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: 'Courier New', Courier, fixed, monospace; font-size: 13px; line-height: 20px; max-width: 720px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 2px; padding-left: 2px; padding-right: 2px; padding-top: 2px; vertical-align: baseline;"&gt;&lt;strong class="userinput" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code style="background-attachment: initial; background-clip: initial; background-color: inherit; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: inherit; font-family: 'Courier New', Courier, fixed, monospace; font-size: 12px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 1px; padding-left: 1px; padding-right: 1px; padding-top: 1px; vertical-align: baseline;"&gt;SELECT EXTRACT(YEAR FROM '2009-07-02');&lt;/code&gt;&lt;/strong&gt;&lt;/pre&gt;
&lt;pre class="programlisting" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: 'Courier New', Courier, fixed, monospace; font-size: 13px; line-height: 20px; max-width: 720px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 2px; padding-left: 2px; padding-right: 2px; padding-top: 2px; vertical-align: baseline;"&gt;&lt;strong class="userinput" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code style="background-attachment: initial; background-clip: initial; background-color: inherit; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: inherit; font-family: 'Courier New', Courier, fixed, monospace; font-size: 12px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 1px; padding-left: 1px; padding-right: 1px; padding-top: 1px; vertical-align: baseline;"&gt;
&lt;/code&gt;&lt;/strong&gt;&lt;/pre&gt;
Aqui les dejo una lista con todos los valores posibles&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;table border="1" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-style: none; border-color: initial; border-color: initial; border-color: initial; border-color: initial; border-color: initial; border-left-style: none; border-right-style: none; border-style: initial; border-top-style: none; border-width: initial; border-width: initial; border-width: initial; border-width: initial; color: black; font-family: Helvetica, Arial, sans-serif; font-size: 14px; line-height: 16px; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px; max-width: 660px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;colgroup&gt;&lt;col&gt;&lt;/col&gt;&lt;col&gt;&lt;/col&gt;&lt;col&gt;&lt;/col&gt;&lt;/colgroup&gt;&lt;thead style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;th style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;em class="replaceable" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code style="background-attachment: initial; background-clip: initial; background-color: inherit; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: inherit; font-family: 'Courier New', Courier, fixed, monospace; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 1px; padding-left: 1px; padding-right: 1px; padding-top: 1px; vertical-align: baseline;"&gt;unit&lt;/code&gt;&lt;/em&gt;&amp;nbsp;Value&lt;/th&gt;&lt;th style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Expected&amp;nbsp;&lt;em class="replaceable" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code style="background-attachment: initial; background-clip: initial; background-color: inherit; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: inherit; font-family: 'Courier New', Courier, fixed, monospace; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 1px; padding-left: 1px; padding-right: 1px; padding-top: 1px; vertical-align: baseline;"&gt;expr&lt;/code&gt;&lt;/em&gt;&amp;nbsp;Format&lt;/th&gt;&lt;th style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Version&lt;/th&gt;&lt;/tr&gt;
&lt;/thead&gt;&lt;tbody style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;MICROSECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Microsegundos&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Segundos&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;MINUTE&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Minutos&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;HOUR&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Horas&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DAY&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;span class="Apple-style-span" style="color: #026789; font-family: 'Courier New', Courier, fixed, monospace;"&gt;&lt;b&gt;Dias&lt;/b&gt;&lt;/span&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;WEEK&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Semana&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;5.0.0&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;MONTH&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Meses&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;QUARTER&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;QUARTERS&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;5.0.0&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;YEAR&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;Años&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SECOND_MICROSECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Segundos.Microsegundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;MINUTE_MICROSECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Minutos:Segundos.Microsegundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;MINUTE_SECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Minutos:Segundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;HOUR_MICROSECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Horas:Minutos:Segundos.Microsegundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;HOUR_SECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Horas:Minutos:Segundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;HOUR_MINUTE&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Horas:Minutos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DAY_MICROSECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'&lt;b&gt;Dias&lt;/b&gt;&amp;nbsp;Horas:Minutos:Segundos.Microsegundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;4.1.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DAY_SECOND&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'&lt;b&gt;Dias&lt;/b&gt;&amp;nbsp;Horas:Minutos:Segundos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DAY_MINUTE&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'&lt;b&gt;Dias&lt;/b&gt;&amp;nbsp;Horas:Minutos'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DAY_HOUR&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'&lt;b&gt;Dias&lt;/b&gt;&amp;nbsp;Horas'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: top;"&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;YEAR_MONTH&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;code class="literal" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #026789; font-family: 'Courier New', Courier, fixed, monospace; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;'Años-Meses'&lt;/code&gt;&lt;/td&gt;&lt;td style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-color: white; border-bottom-style: outset; border-bottom-width: 0.1em; border-color: initial; border-left-color: white; border-left-style: outset; border-left-width: 0.1em; border-right-color: white; border-right-style: outset; border-right-width: 0.1em; border-style: initial; border-top-color: white; border-top-style: outset; border-top-width: 0.1em; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px; vertical-align: baseline;"&gt;Pre-4.1&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;a href="http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_date-format"&gt;DATE_FORMAT(date,format)&lt;/a&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;br /&gt;
Esta función devuelve la fecha con un formato especifico acorde al formato de la cadena formato, esta funcion es muy util para mostrar la fecha con un formato especifico, lo más recomendable es hacer el GROUP con la función anteriror y formatearla con esta. en el caso de que queramos un formato más complejo.&lt;br /&gt;
&lt;br /&gt;
Tambien estan otras funciones como DATE, MONTH, YEAR, etc. que extraen partes más especificas de la fecha, para consultar todas las unfiones disponibles pueden entrar aqui:&lt;br /&gt;
&lt;a href="http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html"&gt;http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-3443310903087503296?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/3443310903087503296/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/consulta-mysql-para-agrupar-por-fechas.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3443310903087503296?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3443310903087503296?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/consulta-mysql-para-agrupar-por-fechas.html" title="Consulta Mysql para agrupar por fechas y funciones de fecha." /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;DEQCQnozeip7ImA9WhRREUs.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-6866656208785171266</id><published>2011-11-17T22:30:00.001-04:30</published><updated>2011-11-24T15:56:03.482-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-11-24T15:56:03.482-04:30</app:edited><title>Nuevas actualizaciones en el mundo del Desarrollo web</title><content type="html">En mes an salido muchas actualizaciones en el mundo del Desarrollo Web, voy a hacer un pequeño resumen de las actualizaciones y las mejores que incluyen:&lt;br /&gt;
&lt;br /&gt;
jquery 1.7 (3-nov)&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://static.jquery.com/files/rocker/images/logo_jquery_215x53.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://static.jquery.com/files/rocker/images/logo_jquery_215x53.gif" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Nuevos eventos on() y off(), para manejar eventos, las cuales haran el trabajo de blind y delegate a la ves.&lt;/li&gt;
&lt;li&gt;Mejorado el rendimiento de la&amp;nbsp;función delegate.&lt;/li&gt;
&lt;li&gt;Mejorado el soporte de ie7/8 para html5,&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Mejoradas las funciones toggle(), ahora al hacer stop() y utilizar otra, la animación comienza donde termino la otra.&lt;/li&gt;
&lt;li&gt;Para ver todos los cambios se pueden ver desde aqui:&amp;nbsp;&lt;a href="http://blog.jquery.com/2011/11/03/jquery-1-7-released/"&gt;http://blog.jquery.com/2011/11/03/jquery-1-7-released/&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;br /&gt;
Vtiger 5.3 (11-nov):&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://www.vtiger.com/templates/ja_pollux/images/logo-blue.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://www.vtiger.com/templates/ja_pollux/images/logo-blue.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;El Usuario puede configurar su zona horaria&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Configurable delimitador de moneda&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Modulo de email. Se mejoro el modulo de Webmails&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Se puede programar el envio de reportes a correo&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Configurado el editor&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Nuevo plugin de outlook.- Desarrollado desde 0 para trabajar con las nuevas versiones de windows y outlook.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Importación mejorada.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Actualizados los fields de tarea en Workflows.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Ahora se pueden poner valores por defecto mientras se crea una fila&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Se mejoro el modulo de Workflow(flujo de trabajo)&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Listas Mejoradas - Las opciones de las listas pueden ser configuradas en base a otras listas&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Modulo reportes mejorado&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Disponibilidad de configurar el permiso de lectura solamente en campos por perfil&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Filtro avanzado de Vistas personalizadas y busqueda avanzada de listas an sido mejorados&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
Codeigniter 2.1 (14-nov)&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Añadido soporte para la base de datos Cubrid&lt;/li&gt;
&lt;li&gt;Las funciones de callback ahora aceptan parametros como las otras reglas de validación&lt;/li&gt;
&lt;li&gt;Agregada la función html_escape() a las funciones comunes, esta permite evitar injecciones en el codigo html.&lt;/li&gt;
&lt;li&gt;Arreglado&amp;nbsp;un una posible&amp;nbsp;inyección&amp;nbsp;en la libreria de seguridad.&lt;/li&gt;
&lt;li&gt;Corregido como 22 bugs adicionales&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;a href="http://jquerymobile.com/"&gt;Jquery Mobile 1.0&lt;/a&gt;&amp;nbsp;(16-nov)&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://jquerymobile.com/wp-content/uploads/2011/11/jquery-mobile-1-final.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="254" src="http://jquerymobile.com/wp-content/uploads/2011/11/jquery-mobile-1-final.png" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
Al FIN a salido la&amp;nbsp;versión&amp;nbsp;1.0 de este poderoso framework para desarrollo web para&amp;nbsp;móviles, llevaba ya mucho tiempo esperando esta poderosa&amp;nbsp;herramienta, que te permite crear una pagina&amp;nbsp;especialmente&amp;nbsp;para celulares en html5 y css3. &amp;nbsp;Sin preocuparnos ni por el estilo ni nada que tenga que ver.&amp;nbsp;Después&amp;nbsp;dedicare algunas entradas a este fabuloso framework. Entre las mejoras que trae incluye:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Sacaron el themeroller para que diseñemos nuestro propio tema. parecido al de jquery UI&lt;/li&gt;
&lt;li&gt;Soporta perfectamente Apple Ios &amp;gt;3.2, blacberry &amp;gt; 6,&amp;nbsp;Palm WebOS &amp;gt; 1.4, Android, WIndows Phone 7 - 7.5, etc&lt;/li&gt;
&lt;li&gt;Mejoraron en esta&amp;nbsp;versión&amp;nbsp;el&amp;nbsp;rendimiento&amp;nbsp;del framework&lt;/li&gt;
&lt;li&gt;En el blog&amp;nbsp;&lt;a href="http://jquerymobile.com/blog/"&gt;http://jquerymobile.com/blog/&lt;/a&gt;, consgeguiran toda la informción relacionada.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-6866656208785171266?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/6866656208785171266/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/nuevas-actualizaciones-en-el-mundo-del.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/6866656208785171266?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/6866656208785171266?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/nuevas-actualizaciones-en-el-mundo-del.html" title="Nuevas actualizaciones en el mundo del Desarrollo web" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s72-c/ci_logo_flame.jpg" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;DkYMR34-fSp7ImA9WhRTGE0.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-2021511368727141989</id><published>2011-11-08T21:30:00.000-04:30</published><updated>2011-11-08T21:33:06.055-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-11-08T21:33:06.055-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crm" /><category scheme="http://www.blogger.com/atom/ns#" term="vtiger" /><title>vtiger 5.x  Actualizando a la version 5.3</title><content type="html">Cuando estamos trabajando con Vtiger, y importamos una base de datos pre-existente, y nos da un error y nos manda a una pagina en la&amp;nbsp;&lt;a href="http://wiki.vtiger.com/index.php/vtiger520:Upgrading_to_PHP_5.3"&gt;wiki de vtiger&lt;/a&gt;, la cual nos da las siguiente instrucciones:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;Copiamos el archivo &lt;i&gt;ResetPassword.phpfile&lt;/i&gt;, que esta en &lt;i&gt;modules/migration&lt;/i&gt; a la carpeta raiz&lt;/li&gt;
&lt;li&gt;Copiar la clave&amp;nbsp;única&amp;nbsp;de config.inc.php y lo copiamos a nuestro archivo.&lt;/li&gt;
&lt;li&gt;Renombranos el archivo ResetPassword.phpfile y no&amp;nbsp;quedaría&amp;nbsp;así&amp;nbsp;ResetPassword.php&lt;/li&gt;
&lt;li&gt;Corremos el archivo en el buscador&lt;/li&gt;
&lt;li&gt;Borramos el archivo.&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;br /&gt;
Y obtenemos el brillante resultado que no pasa nada, jajajaja. Vtiger tiene un gran problema, y es que falta mucha&amp;nbsp;documentación&amp;nbsp;y ayuda, para resolver el problema del que estamos hablando tenemos que reemplazar el contenido de ResetPassword.php por este:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php

require_once 'config.php';
require_once 'include/utils/utils.php';

 resetUserPasswords();

function resetUserPasswords() {
 $db = PearDatabase::getInstance();
 $sql = 'select user_name, id, crypt_type from vtiger_users';
 $result = $db-&amp;gt;pquery($sql, array());
 $rowList = $result-&amp;gt;GetRows();
 foreach ($rowList as $row) {
  $cryptType = $row['crypt_type'];
  if(strtolower($cryptType) == 'md5' &amp;amp;&amp;amp; version_compare(PHP_VERSION, '5.3.0') &amp;gt;= 0) {
   $cryptType = 'PHP5.3MD5';
  }
  $encryptedPassword = getEncryptedPassword($row['user_name'], $cryptType,
    $row['user_name']);
  $userId = $row['id'];
  $sql = "update vtiger_users set user_password=?,crypt_type=? where id=?";
  $updateResult = $db-&amp;gt;pquery($sql, array($encryptedPassword, $cryptType, $userId));
  if(!is_object($updateResult)) {
   $_SESSION['migration_info']['user_messages'][] = "&amp;lt;div&amp;gt;".
    "&amp;lt;span style='color: red;font-weight: bold;width: 30em;'&amp;gt;Failed: &amp;lt;/span&amp;gt;".
    "$sql&amp;lt;br /&amp;gt;".var_export(array($encryptedPassword, $userId)).'&amp;lt;/div&amp;gt;';
  }
 }
}

function getEncryptedPassword($userName, $cryptType, $userPassword) {
 $salt = substr($userName, 0, 2);
 // For more details on salt format look at: http://in.php.net/crypt
 if($cryptType == 'MD5') {
  $salt = '$1$' . $salt . '$';
 } elseif($cryptType == 'BLOWFISH') {
  $salt = '$2$' . $salt . '$';
 } elseif($cryptType == 'PHP5.3MD5') {
  //only change salt for php 5.3 or higher version for backward
  //compactibility.
  //crypt API is lot stricter in taking the value for salt.
  $salt = '$1$' . str_pad($salt, 9, '0');
 }
 $computedEncryptedPassword = crypt($userPassword, $salt);
 return $computedEncryptedPassword;
}

?&amp;gt;
&lt;/pre&gt;
Ya con esto se resetean las claves a el mismo nombre de usuario, si tienen algun problema pueden dejar un comentario.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-2021511368727141989?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/2021511368727141989/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/vtiger-5x-actualizando-la-version-53.html#comment-form" title="2 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2021511368727141989?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2021511368727141989?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/vtiger-5x-actualizando-la-version-53.html" title="vtiger 5.x  Actualizando a la version 5.3" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>2</thr:total></entry><entry gd:etag="W/&quot;DUINQ3oyeip7ImA9WhRTF0U.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-3011877769936549800</id><published>2011-11-08T16:56:00.002-04:30</published><updated>2011-11-08T16:56:32.492-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-11-08T16:56:32.492-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Manual de codeigniter español</title><content type="html">Este post tiene los manuales en español de codeigniter 2.0.2.&lt;br /&gt;
&lt;a href="http://sosinformatico.blogspot.com/2011/08/manual-de-codeigniter-202.html"&gt;http://sosinformatico.blogspot.com/2011/08/manual-de-codeigniter-202.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Y&amp;nbsp;aquí&amp;nbsp;conseguirán&amp;nbsp;el manual en español del 2.0.3&lt;br /&gt;
&lt;br /&gt;
&lt;a href="http://www.areadepruebas.com.ar/downloads/CodeIgniter_Guia_Usuario_2.0.3.pdf"&gt;http://www.areadepruebas.com.ar/downloads/CodeIgniter_Guia_Usuario_2.0.3.pdf&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-3011877769936549800?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/3011877769936549800/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/manual-de-codeigniter-espanol.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3011877769936549800?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3011877769936549800?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/11/manual-de-codeigniter-espanol.html" title="Manual de codeigniter español" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;A0cHQHc9cCp7ImA9WhdaGU8.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-7337231225040493785</id><published>2011-10-29T18:25:00.001-04:30</published><updated>2011-10-29T18:27:11.968-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-29T18:27:11.968-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crm" /><category scheme="http://www.blogger.com/atom/ns#" term="vtiger" /><title>vtigerCRM: Crear un tema</title><content type="html">Para crear un nuevo tema con vtiger&amp;nbsp;de verdad es bastante sencillo, solo con copiar un tema ya existente y ponerle otro nombre es suficiente. Por supuesto vtiger limita los nombre, no pueden ser: CVS, Attic, akodarkgem, bushtree, coolblue, Amazon, busthree, Aqua, nature, orange o blue.&lt;br /&gt;
&lt;br /&gt;
De todas maneras aqui les dejo la explicación mas detallada:&amp;nbsp;&lt;a href="http://wiki.vtiger.com/index.php/Vtiger_CRM_5_:_Creating_your_own_Color_Theme"&gt;http://wiki.vtiger.com/index.php/Vtiger_CRM_5_:_Creating_your_own_Color_Theme&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-7337231225040493785?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/7337231225040493785/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtigercrm-crear-un-tema.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7337231225040493785?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7337231225040493785?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtigercrm-crear-un-tema.html" title="vtigerCRM: Crear un tema" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;AkEEQnw_fip7ImA9WhdaGU8.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-213395664291620281</id><published>2011-10-29T18:20:00.000-04:30</published><updated>2011-10-29T18:20:03.246-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-29T18:20:03.246-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crm" /><category scheme="http://www.blogger.com/atom/ns#" term="vtiger" /><title>vtigeCRM configuraciones básicas (idioma, base de datos, codificación y tema por defecto)</title><content type="html">&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;span class="Apple-style-span" style="font-size: small;"&gt;Para poder modificar cualquiera de las configuraciones que les voy a explicar deben entrar en&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: small;"&gt;&lt;i&gt;ruta_al_sistema/config.inc.php. &lt;/i&gt;&amp;nbsp;explico como se modifican estas variables porque no se pueden modificar sino desde el archivo de configuración&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Cambiar idioma por defecto&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
En el archivo de configuración buscar la linea donde esta la variable&lt;i&gt; $default_language, &lt;/i&gt;y aqui por defecto sale&amp;nbsp;&lt;i&gt;en_us&lt;/i&gt;, y la cambiamos por la correspondiente de nuestro idioma. si es el español es: &lt;i&gt;es_es.&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;br /&gt;
Si quieren descargar un tema diferente pueden buscar el idioma&amp;nbsp;correspondiente&amp;nbsp;en:&amp;nbsp;&lt;a href="http://wiki.vtiger.com/index.php/Vtiger_Language_Packs_Maintainers"&gt;http://wiki.vtiger.com/index.php/Vtiger_Language_Packs_Maintainers&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Cambiar la configuración de la base de datos.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
En el archivo de configuración hay tres variables modificables, las cuales esplicare en cada linea:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
$dbconfig['db_server'] = 'localhost'; //servidor de mysql&lt;br /&gt;
$dbconfig['db_port'] = ':3306'; //puerto Mysql&lt;br /&gt;
$dbconfig['db_username'] = 'root'; //user&lt;br /&gt;
$dbconfig['db_password'] = 'contraseña';//contraseña&lt;br /&gt;
$dbconfig['db_name'] = 'vtiger1';//nombre de la base de datos&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Cambiar la codificación por defecto&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
La variable $default_charset nos permite configurar la codificación por defecto que es UTF-8, podemos poner&amp;nbsp;ISO-8859-1 que tambien es una de las más utilizadas&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Cambiar tema por defecto&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Por defecto se encuentra el tema &lt;i&gt;softed o blue&lt;/i&gt;&amp;nbsp;para modificar el tema por defecto debemos modificar la variable&amp;nbsp;&lt;i&gt;$default_theme &lt;/i&gt;a nuestro propio tema o el tema que deseemos.&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-213395664291620281?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/213395664291620281/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtigecrm-configuraciones-basicas-idioma.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/213395664291620281?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/213395664291620281?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtigecrm-configuraciones-basicas-idioma.html" title="vtigeCRM configuraciones básicas (idioma, base de datos, codificación y tema por defecto)" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;CEYNQ3Y-fCp7ImA9WhdaF0g.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-800958642151571707</id><published>2011-10-26T21:00:00.000-04:30</published><updated>2011-10-27T17:19:52.854-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-27T17:19:52.854-04:30</app:edited><title>Vtiger 5.3 RC</title><content type="html">A salido hoy la &lt;a href="http://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%205.3.0%20RC/Core%20Product/vtigercrm-5.3.0-RC.tar.gz/download"&gt;version 5.3 RC (link de descarga)&lt;/a&gt;&amp;nbsp;de vTiger y &amp;nbsp;anunciaron la&amp;nbsp;versión&amp;nbsp;GA para dentro de 2 o 3&amp;nbsp;semanas,&amp;nbsp;aquí&amp;nbsp;les dejos los cambios echos mas&amp;nbsp;resultantes&amp;nbsp;en esta&amp;nbsp;versión:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;
&lt;ul style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 1.5em; margin-left: 1.5em; margin-right: 0px; margin-top: 0.5em; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 20px; padding-right: 0px; padding-top: 0px;"&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;Configurable Zona&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 21px;"&gt;Horaria&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;, para el usuario&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Configurable Delimitadores actuales&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Manager de correos. Un mucho más veloz reemplazo pra el modulo de Webmail&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Reportes programados pueden ser enviados por correo autoamticamente&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Config Editor para modificar al configuración&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Nuevo plugin de Outlook – Desarrollado desde 0 para trabajar con las nuevas versiones de Windows y Outlook&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;Importar mejorado - Agregada&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 21px;"&gt;característica&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;&amp;nbsp;de auto unir mientras se importa.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Actualizado campos de tarea en WorkFlows&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Disponible establecer valores por defecto para los campos mientras se crea un tipo&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Workflow mejorado&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;Listas de&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 21px;"&gt;selección&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 21px;"&gt;dinámicas&lt;/span&gt;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif;"&gt;&lt;span class="Apple-style-span" style="font-size: 14px; line-height: 22px;"&gt;&amp;nbsp;– Selecciones en las listas de seleccion pueden ser configuradas para estar basadas en otras listas de seleccion.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;&lt;span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 21px;"&gt;Mejorado de los reportes&lt;/span&gt;&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Disponibilidad de configurar los permisos de leer solamente por perfil.&lt;/li&gt;
&lt;li style="border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 22px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"&gt;Filtro avanzado &amp;nbsp;de la vista personalizable y buscador avanzado de lista de vista mejorados&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-800958642151571707?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/800958642151571707/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-53-rc.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/800958642151571707?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/800958642151571707?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-53-rc.html" title="Vtiger 5.3 RC" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;DUMHSHs6eip7ImA9WhdaFko.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-9074217810253264456</id><published>2011-10-26T20:00:00.001-04:30</published><updated>2011-10-26T20:33:59.512-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-26T20:33:59.512-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crm" /><category scheme="http://www.blogger.com/atom/ns#" term="vtiger" /><title>Vtiger CRM: Manuales de Desarrolo y uso</title><content type="html">Aqui les dejo algunos manuales y cosas utiles, para usar o desarrollas con vtiger:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Manual de Usuario y administrador de Vtiger 5.x&amp;nbsp;&lt;a href="http://www.box.net/shared/8ojqudkugy60ak4fuus1"&gt;http://www.box.net/shared/8ojqudkugy60ak4fuus1&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Modelo de Datos de Vtiger CRM 5.2.1:&amp;nbsp;&lt;a href="http://www.box.net/shared/d4r4qisie5b41q0tfir7"&gt;http://www.box.net/shared/d4r4qisie5b41q0tfir7&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;VtLib,&amp;nbsp;librería&amp;nbsp;de&amp;nbsp;desarrollo&amp;nbsp;para vtiger:&amp;nbsp;&lt;a href="http://www.box.net/shared/mdem5eoqgtrh993tivq4"&gt;http://www.box.net/shared/mdem5eoqgtrh993tivq4&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Manual en español que habla de algunas cosas de vTiger, echo por una empresa llamada&amp;nbsp;"MAGNAFOR QUALITAS":&amp;nbsp;&lt;a href="http://www.box.net/shared/ocajeuetrszk43ykuqvr"&gt;http://www.box.net/shared/ocajeuetrszk43ykuqvr&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;br /&gt;
Estas son unas&amp;nbsp;imágenes&amp;nbsp;que hablan un poco del flujo de trabajo en vtiger y de algunas otras cosas interesante, son de uan version antigua, pero sirven para orientarse un poco:&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-bkOYlHN07hU/TqhhX7gP2EI/AAAAAAAAAGk/AufrCzB9-hw/s1600/503-Header-P1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="194" src="http://4.bp.blogspot.com/-bkOYlHN07hU/TqhhX7gP2EI/AAAAAAAAAGk/AufrCzB9-hw/s400/503-Header-P1.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/--72rWV-OUqQ/TqhhYuF24DI/AAAAAAAAAGs/P4NCVLpj6Is/s1600/503-Header-P2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="235" src="http://2.bp.blogspot.com/--72rWV-OUqQ/TqhhYuF24DI/AAAAAAAAAGs/P4NCVLpj6Is/s400/503-Header-P2.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://1.bp.blogspot.com/-Vyya6zJS_B4/TqhhZLuInbI/AAAAAAAAAG0/r5_vUkH-a1Y/s1600/PDF-Body.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="279" src="http://1.bp.blogspot.com/-Vyya6zJS_B4/TqhhZLuInbI/AAAAAAAAAG0/r5_vUkH-a1Y/s400/PDF-Body.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-bRvduXIukoQ/TqhhZ1GRolI/AAAAAAAAAG8/tbgJGaIDCTg/s1600/PDF-Breakdown.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="277" src="http://4.bp.blogspot.com/-bRvduXIukoQ/TqhhZ1GRolI/AAAAAAAAAG8/tbgJGaIDCTg/s400/PDF-Breakdown.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://1.bp.blogspot.com/-mvQkPN6JSB8/TqhhajKSmkI/AAAAAAAAAHE/IhJqyCx_Dyg/s1600/PDF-FileStructure.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="277" src="http://1.bp.blogspot.com/-mvQkPN6JSB8/TqhhajKSmkI/AAAAAAAAAHE/IhJqyCx_Dyg/s400/PDF-FileStructure.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/-pmKrP2uMVa4/TqhhbkZlqkI/AAAAAAAAAHM/1FDif6x_2to/s1600/PDF-Footer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="279" src="http://2.bp.blogspot.com/-pmKrP2uMVa4/TqhhbkZlqkI/AAAAAAAAAHM/1FDif6x_2to/s400/PDF-Footer.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://3.bp.blogspot.com/-xR9fWVpBqQk/TqhhcdAfe3I/AAAAAAAAAHU/Yph7CfdvtMA/s1600/PDF-Header.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="279" src="http://3.bp.blogspot.com/-xR9fWVpBqQk/TqhhcdAfe3I/AAAAAAAAAHU/Yph7CfdvtMA/s400/PDF-Header.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-9074217810253264456?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/9074217810253264456/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-crm-manuales-de-desarrolo-y-uso.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/9074217810253264456?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/9074217810253264456?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-crm-manuales-de-desarrolo-y-uso.html" title="Vtiger CRM: Manuales de Desarrolo y uso" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-bkOYlHN07hU/TqhhX7gP2EI/AAAAAAAAAGk/AufrCzB9-hw/s72-c/503-Header-P1.png" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;D0MEQXo5fSp7ImA9WhdaFko.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-8504553881339800644</id><published>2011-10-26T20:00:00.000-04:30</published><updated>2011-10-26T20:00:00.425-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-26T20:00:00.425-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crm" /><category scheme="http://www.blogger.com/atom/ns#" term="vtiger" /><title>Vtiger un CRM opensource</title><content type="html">&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://tecnoweb2.com/sites/default/files/vtiger1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="114" src="http://tecnoweb2.com/sites/default/files/vtiger1.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Hoy les presento a Vtiger&amp;nbsp;&lt;a href="http://es.wikipedia.org/wiki/Customer_relationship_management"&gt;CRM  (Customer relationship management)&lt;/a&gt;&amp;nbsp;en su versión 5.3.0RC, (recien sacadita del horno), es un sistema Open Source echo en php, basado en Sugar CRM, que esta echo para el manejo de las relaciones empresa-clientes, que permite manejar inventario, presupuestos, facturas, campañas, Email Marketing, pedidos, tarifas,&amp;nbsp;atención&amp;nbsp;al cliente y muchas otras más funciones interesantes.&lt;br /&gt;
&lt;br /&gt;
De verdad es un software muy bueno,&amp;nbsp;útil&amp;nbsp;para cualquier empresa que quiera llevar detalladamente una&amp;nbsp;relación&amp;nbsp;cliente-empresa, sin hacer una gran&amp;nbsp;inversión, ya que el sistema&amp;nbsp;también&amp;nbsp;dispone de varias&amp;nbsp;extensiones&amp;nbsp;que permite al sistema como tal integrarse con asterik o joomla,&amp;nbsp;también&amp;nbsp;dispone de un plugin para que el sistema este disponible para celulares e inclusive una extension para crear una pagina del cliente manejada por vtiger, Otra&amp;nbsp;característica&amp;nbsp;resaltable es que es altamente&amp;nbsp;personalizable, ya que se pueden agregar campos a nuestro gusto, crear filtros y muchas otras opciones más.&lt;br /&gt;
&lt;br /&gt;
Lo Mejor de Vtiger es que es un sistema 100% Gratuito y opensource, lo cual quiere decir que lo podemos modificar como queramos y no vamos a tener&amp;nbsp;ningún&amp;nbsp;rollo. Ademas de que vienen en español&amp;nbsp;también, lo cual es una ventaja para los que hablamos este bello idioma.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="http://upload.wikimedia.org/wikipedia/commons/6/66/InfografiaCRM.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" height="341" src="http://upload.wikimedia.org/wikipedia/commons/6/66/InfografiaCRM.png" width="400" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;Info Grafia&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
Para los interesados en conocer más de Vtiger&amp;nbsp;aquí&amp;nbsp;les dejo estas Url de&amp;nbsp;Interés:&lt;br /&gt;
&lt;br /&gt;
Web Oficial:&amp;nbsp;&lt;a href="http://www.vtiger.com/index.php"&gt;http://www.vtiger.com/index.php&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Wiki:&amp;nbsp;&lt;a href="http://wiki.vtiger.com/"&gt;http://wiki.vtiger.com/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Foro español:&amp;nbsp;&lt;a href="http://crmevolutivo.com/forum/"&gt;http://crmevolutivo.com/forum/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Foro Ingles:&amp;nbsp;&lt;a href="http://forums.vtiger.com/"&gt;http://forums.vtiger.com/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Guia de usuario:&amp;nbsp;&lt;a href="http://wiki.vtiger.com/index.php/Vtiger521:User_Manual"&gt;http://wiki.vtiger.com/index.php/Vtiger521:User_Manual&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Blog:&amp;nbsp;&lt;a href="http://blogs.vtiger.com/"&gt;http://blogs.vtiger.com/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Como ultimamente voy a estar trabajando con este sistema, voy a seguir publicando algunas entradas, principalmente entradas que tienen que ver con el desarrollo en vtiger.&lt;br /&gt;
&lt;br /&gt;
Saludos y buena Suerte.&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-8504553881339800644?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/8504553881339800644/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-un-crm-opensource.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/8504553881339800644?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/8504553881339800644?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/vtiger-un-crm-opensource.html" title="Vtiger un CRM opensource" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;CUEEQH8ycCp7ImA9WhdaFko.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-1285010902333719507</id><published>2011-10-26T19:30:00.000-04:30</published><updated>2011-10-26T19:30:01.198-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-26T19:30:01.198-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="multilenguaje" /><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Crear Url dependiendo del lenguaje</title><content type="html">&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
Para crear una url dependiendo del idioma,&amp;nbsp;tendríamos&amp;nbsp;que crear MY_url_helper.php, donde extendemos la funcion site_url(), para que cree las url dependiendo del lenguaje. Acepta ahora un segundo&amp;nbsp;parámetro&amp;nbsp;con la&amp;nbsp;abreviación&amp;nbsp;del lenguaje que queremos que cree la url, si vamos a cambiar el lenguaje hay que pone ajuro el lenguaje, pero si la url debe estar en el mismo lenguaje la va a crear.&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;pre class="brush: javascript" style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;

 function site_url($uri = '', $lang = '')
 {
  $CI =&amp;amp; get_instance();
  $config =&amp;amp; get_config();
  if(!array_key_exists($lang,$config['languages']))
   $lang=array_search($config['language'],$config['languages']);
  return $CI-&amp;gt;config-&amp;gt;site_url()."/$lang/".trim($uri,"/").$CI-&amp;gt;config-&amp;gt;item('url_suffix');
 }



&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-1285010902333719507?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/1285010902333719507/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/crear-url-dependiendo-del-lenguaje.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1285010902333719507?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1285010902333719507?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/crear-url-dependiendo-del-lenguaje.html" title="Crear Url dependiendo del lenguaje" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;A08DR387fip7ImA9WhdaFks.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-8564602112890601327</id><published>2011-10-26T18:27:00.000-04:30</published><updated>2011-10-26T18:27:56.106-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-26T18:27:56.106-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="tutorial" /><category scheme="http://www.blogger.com/atom/ns#" term="multilenguaje" /><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Codeigniter Multilenguaje web, por URLS</title><content type="html">Este tutorial se lo voy a dedicar a explicar como se hace para crear un sistema Multilenguaje en Codeigniter, en internet hay varios tutoriales de como hacer esto en nuestro idioma, pero lo hacen usando cookies, y aunque no&amp;nbsp;están&amp;nbsp;mal, no permiten a un buscador almacenar correctamente el contenido de nuestra pagina en los diferentes lenguajes y&amp;nbsp;así&amp;nbsp;atraer a más gente a nuestra pagina Web.&lt;br /&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="http://3.bp.blogspot.com/-sEU877rxc2Y/TqhXGjIPyeI/AAAAAAAAAGc/8F-MRKLJd64/s1600/Sin+nombre.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" height="320" src="http://3.bp.blogspot.com/-sEU877rxc2Y/TqhXGjIPyeI/AAAAAAAAAGc/8F-MRKLJd64/s320/Sin+nombre.jpg" width="266" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;Codeigniter Multilenguaje&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
Aquí&amp;nbsp;les dejo un articulo sobre SEO y el MULTILINGUAL SEO, por si se quieren&amp;nbsp;documentar&amp;nbsp;un poco más:&amp;nbsp;&lt;a href="http://www.searchenginejournal.com/multilingual-seo/19903/"&gt;http://www.searchenginejournal.com/multilingual-seo/19903/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Ahora bien, para empezar deben conocer primero como se trabaja con lenguajes de manera&amp;nbsp;básica&amp;nbsp;con Codeigniter, aqui les dejo un pequeño tutorial que hice:&amp;nbsp;&lt;a href="http://sosinformatico.blogspot.com/2011/10/codeigniter-language-class.html"&gt;http://sosinformatico.blogspot.com/2011/10/codeigniter-language-class.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Para hacer que codeigniter sea multilenguaje hay dos maneras que yo conozco, una es&amp;nbsp;a&amp;nbsp;través&amp;nbsp;de hooks y otra extendiendo la clase que &lt;i&gt;lang.php &lt;/i&gt;en la carpeta &lt;i&gt;core&lt;/i&gt;&amp;nbsp;de nuestra aplicación. En este tutorial voy a explicar la ultima forma, y despues publicara otro con la otra forma.&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Configurando el archivo Routes.php&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
En&lt;i&gt; application/config/routex.php &lt;/i&gt;vamos a agregar dos lineas:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;$route['(\w{2})/(.*)'] = '$2';

$route['(\w{2})'] = $route['default_controller'];

&lt;/pre&gt;
&lt;br /&gt;
En el primer array se establece que cualquier ruta que tenga dos caracteres y una barra inclidada y algo mas, sera rederigida a ese algo más, y al segunda estable que cualquier ruta con dos caracteres llamara al controlador por defecto.&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Configurando el archivo Config.php&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
En application/config/config.php, cerca de la configuración de lenguaje vamos a agregar:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;$config['languages'] = array("es" =&amp;gt; "espanol", "en" =&amp;gt; "english");



$config['redirect_urls']=false;

&lt;/pre&gt;
&lt;br /&gt;
Esto es para definir la configuración de nuestro sistema de lenguajes, y que&amp;nbsp;después&amp;nbsp;solo deba ser modificada desde&amp;nbsp;aquí, si queremos agregar un&amp;nbsp;lenguaje&amp;nbsp;aparte o cualquier cosa. Ademas tambien nos permite definir si queremos usar la redirection de url o no, que sirve para que si alguien entre a "hhttp://nuestrositio.com/" lo redirige automaticamente o no a&amp;nbsp;"hhttp://nuestrositio.com/xx" las dos x significan el idioma que tengamos por defecto.&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Extendiendo lang.php&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Para extender esta libreria del nucleo de Codeigniter, debemos crear dentro de la carpeta &lt;i&gt;application/core &lt;/i&gt;&amp;nbsp;un archivo que debe empezar con la variable definida&amp;nbsp;&lt;i&gt;$config['subclass_prefix'] &lt;/i&gt;en el &lt;i&gt;config.php (por defecto es MY_)&amp;nbsp;&lt;/i&gt;y luego lang.php, en mi caso el nombre es MY_Lang.php, y dentro colocamos el siguiente codigo:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php (defined('BASEPATH')) OR exit('No direct script access allowed');

class MY_Lang extends CI_Lang
{
 function __construct()
 {
  parent::__construct();  
  $config =&amp;amp; get_config();
  if(isset($config['languages']) &amp;amp;&amp;amp; isset($config['redirect_urls']))
  {
   global $URI, $CFG, $IN;
   //var_dump($URI);
   $lang = (isset($URI-&amp;gt;segments['1']))?$URI-&amp;gt;segments['1']:'';
   $uri=$URI-&amp;gt;segments;
   if(strlen($lang) == 2 &amp;amp;&amp;amp; array_key_exists($lang,$config['languages']) == true)
   {
    $config['language']=$config['languages'][$lang];
   }
   elseif($config['redirect_urls'] == true || strlen($lang) == 2 &amp;amp;&amp;amp; array_key_exists($lang,$config['languages']) == false)
   {
    $url=$config['base_url'];
    $url.=(empty($config['index_page']))?'':$config['index_page'].'/';
    $url.=array_search($config['language'],$config['languages']).'/';
    if(strlen($lang)==2)
    {
     array_shift($uri);
     $url.=implode('/',$uri);
    }else
    {
     $url.=implode('/',$uri);
    }
    header("location: $url");
   }
  }
 }
}

&lt;/pre&gt;
&lt;br /&gt;
Este&amp;nbsp;código&amp;nbsp;es el que va a dar la funcionalidad de muli lenguaje, es&amp;nbsp;bastante&amp;nbsp;sencillo, lo que hace es comprueba cuales son los primeros caracteres en la url, comprueba que&amp;nbsp;estén&amp;nbsp;definidos&amp;nbsp;en la&amp;nbsp;configuración&amp;nbsp;y si es&amp;nbsp;así&amp;nbsp;cambia al idioma&amp;nbsp;correspondiente, sino redirige al idioma por defecto. SI la variable redirect:url esta en true, el sistema comprobara que la url&amp;nbsp;empieza&amp;nbsp;con los dos caracteres del idioma por defecto y si no es&amp;nbsp;así&amp;nbsp;lo redirige a la url del idioma por defecto, si esta en false esta variable pues no hace nada y deja el idioma por defecto.&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Probando el sistema Multilenguaje.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Esto no es un sistema automatizado que va a traducir toda tu&amp;nbsp;aplicación, lo que hace es modificar solamente el idioma que usa la&amp;nbsp;aplicación&amp;nbsp;dependiendo de la url, para verlo funcionando debemos crear una aplicación que tenga varias idiomas ya definidos y esto se encargara del resto.&lt;br /&gt;
&lt;br /&gt;
De todas maneras&amp;nbsp;aquí&amp;nbsp;les dejo una aplicación con el welcome_message en español y ingles, y los links para cambiar de idioma. Y así la prueban y comentan como funciona.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/-3N82nY9-rTs/TqhSt_2PetI/AAAAAAAAAGU/57koDWoGzk0/s1600/Pantallazo-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="225" src="http://2.bp.blogspot.com/-3N82nY9-rTs/TqhSt_2PetI/AAAAAAAAAGU/57koDWoGzk0/s400/Pantallazo-3.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: center;"&gt;
&lt;a href="http://www.box.net/shared/m6uj2q2c6vlyfy7z8e2c"&gt;http://www.box.net/shared/m6uj2q2c6vlyfy7z8e2c&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-8564602112890601327?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/8564602112890601327/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/codeigniter-multi-lenguaje-web-por-urls.html#comment-form" title="2 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/8564602112890601327?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/8564602112890601327?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/codeigniter-multi-lenguaje-web-por-urls.html" title="Codeigniter Multilenguaje web, por URLS" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://3.bp.blogspot.com/-sEU877rxc2Y/TqhXGjIPyeI/AAAAAAAAAGc/8F-MRKLJd64/s72-c/Sin+nombre.jpg" height="72" width="72" /><thr:total>2</thr:total><georss:featurename>Avenida Fuerzas Armadas, Caracas, Venezuela</georss:featurename><georss:point>10.508235226352685 -66.90871238708496</georss:point><georss:box>10.500471226352685 -66.91853988708496 10.515999226352685 -66.89888488708496</georss:box></entry><entry gd:etag="W/&quot;C0cEQXc8eip7ImA9WhdaFUo.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-7686119788357417087</id><published>2011-10-25T15:00:00.000-04:30</published><updated>2011-10-25T15:00:00.972-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-25T15:00:00.972-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="tutorial" /><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Codeigniter Language CLASS</title><content type="html">&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-YAxkcPUhu0I/Tqbvs3GzDlI/AAAAAAAAAGM/m8Sb3E1tl7A/s1600/codeigniter.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="368" src="http://4.bp.blogspot.com/-YAxkcPUhu0I/Tqbvs3GzDlI/AAAAAAAAAGM/m8Sb3E1tl7A/s400/codeigniter.jpg" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
Este tutorial trata sobre como usar la libreria &lt;i&gt;Language Class&lt;/i&gt; de codeigniter y sera el&amp;nbsp;preámbulo&amp;nbsp;par aun tutorial de como crear sus sistema multi lenguaje con codeigniter, primero vamos a empezar por lo&amp;nbsp;básico, como se hace en codeigniter para trabajar con varios lenguajes. Codeigniter posee una Clase dedicada&amp;nbsp;especialmente&amp;nbsp;para trabajar con los lenguajes, (y tambien tiene un helper), lo primero que debemos saber es que hay dos carpetas donde se guardan los diferentes lenguajes en codeigniter, una esta en &lt;i&gt;"system/language"&lt;/i&gt; y la otra en &lt;i&gt;"application/language"&lt;/i&gt;, en la primera se guarda los lenguajes que tienen que ver solamente con el sistema principal, y la segunda guarda los lenguajes de nuestro proyecto Web.&amp;nbsp;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
Dentro de esas carpetas deben tantas carpetas como lenguajes tengamos, y a su ves tantos archivos de lenguajes como necesitemos, eso si, de carpeta a carpeta de lenguaje deben estar exactamente los mismos archivos, con los mismos arrays, la&amp;nbsp;única&amp;nbsp;diferencia es que el lenguaje en el que van a estar escritos los valores de los lenguajes. Como ya en una entrada anterior les deje la&amp;nbsp;traducción&amp;nbsp;de&amp;nbsp;&lt;a href="http://sosinformatico.blogspot.com/2011/02/el-espanol-llego-codeigniter-20.html"&gt;codeigniter al español, aqui!&lt;/a&gt;. Que si la revisan con&amp;nbsp;detenimiento&amp;nbsp;es&amp;nbsp;idéntica&amp;nbsp;a la del ingles con la&amp;nbsp;única&amp;nbsp;diferencia que el contenido esta en español, esa&amp;nbsp;traducción&amp;nbsp;como la&amp;nbsp;traducción&amp;nbsp;del sistema va en &lt;i&gt;"system/language"&lt;/i&gt;,&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Creando Archivos de Lenguaje&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"&gt;
Para trabajar con varios lenguajes en codeigniter debemos empezar creando los archivos de lenguajes en&lt;i&gt; "application/language/(el lenguaje)/miarchivo_lang.php"&lt;/i&gt;, todos los archivos de lenguaje deben terminar en &lt;i&gt;_lang.php&lt;/i&gt;, &amp;nbsp;y&amp;nbsp;deberíamos&amp;nbsp;tener uno exactamente igual para cada lenguaje.&amp;nbsp;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Dentro de nuestro debemos ir colocando lineas que extiendan el array $lang, para ir definiendo nuevos textos en ese lenguaje. las lineas deben seguir este prototipo:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;pre class="brush: javascript"&gt;$lang['clave del lenguaje']="contenido para esta clave";&lt;/pre&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
A la hora de crear nuestro archivo de lenguaje es bueno crear y seguir nuestra propia notación para que despues no vayamos a confundirnos. Ejemplo:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;pre class="brush: javascript"&gt;$lang['msj_mensaje_borrado']="Su mensaje a sido borrado";&lt;/pre&gt;
&lt;/div&gt;
&lt;div&gt;
$lang['error_mensaje_borrado"]="Su mensaje no a podido ser borrado";&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Cargando un archivo de lenguaje.&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Después&amp;nbsp;de tener creado lso archivos de lenguaje, vamos a necesitar cargarlos, esto se hace con :&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;pre class="brush: javascript"&gt;$this-&amp;gt;lang-&amp;gt;load('mi archivo','el lenguaje que quiero');&lt;/pre&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El segundo&amp;nbsp;parámetro&amp;nbsp;es opcional y si no se coloca cargara el lenguaje predeterminado en nuestro archivo de configuración.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
También&amp;nbsp;podemos cargar un archivo de lenguaje automaticamente cada ves que nuestra aplicación cargue,&amp;nbsp;definiendo lo&amp;nbsp;en "applicacion/config/autoload.php".&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Imprimiendo lineas de el archivo de lenguaje.&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El &amp;nbsp;&lt;i&gt;Languague Class&lt;/i&gt;&amp;nbsp;tienen un&amp;nbsp;método&amp;nbsp;line('clave del lenguaje'), que devuelve una linea especifica de lenguaje. Este metodo seguna la&amp;nbsp;documentación&amp;nbsp;oficial, pues ya no se&amp;nbsp;debería&amp;nbsp;a usar más y se&amp;nbsp;debería&amp;nbsp;usar la&amp;nbsp;función&amp;nbsp;lang() de el&amp;nbsp;&lt;i&gt;Langueage helper.&amp;nbsp;&lt;/i&gt;&lt;/div&gt;
&lt;div&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;pre class="brush: javascript"&gt;&lt;div&gt;
echo $this-&amp;gt;lang-&amp;gt;line('msj_mensaje_borrado');&lt;/div&gt;
&lt;div&gt;
//Salida:&amp;nbsp;Su mensaje a sido borrado&lt;/div&gt;
&lt;div&gt;
echo lang('msj_mensaje_borrado');&lt;/div&gt;
&lt;div&gt;
//Salida:&amp;nbsp;Su mensaje a sido borrado&lt;/div&gt;
&lt;div&gt;
echo lang('msj_mensaje_borrado','id_input_formulario')&lt;/div&gt;
&lt;div&gt;
//Salida: &amp;lt;label for='id_input_formulario'"&amp;gt;Su mensaje a sido borrado&amp;lt;/label&amp;gt;&lt;/div&gt;
&lt;/pre&gt;
&lt;pre class="brush: javascript"&gt;
&lt;/pre&gt;
Bueno esto es todo por hoy, Voy a tratar de que al proxima entrada sea de como crear un sistema Multilenguaje con Codeigniter.&lt;br /&gt;
&lt;br /&gt;
Nota: si crean como es debido los archivos de lenguaje en la carpeta de español y ingles, veran como al modificar la variable en el config.php va a cambiar en lenguaje al reabrir la pagina.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-7686119788357417087?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/7686119788357417087/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/codeigniter-language-class.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7686119788357417087?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7686119788357417087?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/codeigniter-language-class.html" title="Codeigniter Language CLASS" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-YAxkcPUhu0I/Tqbvs3GzDlI/AAAAAAAAAGM/m8Sb3E1tl7A/s72-c/codeigniter.jpg" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;A0EERno_fyp7ImA9WhdbGUU.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-2146684832933138888</id><published>2011-10-18T00:03:00.000-04:30</published><updated>2011-10-18T21:30:07.447-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-18T21:30:07.447-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="jquery" /><category scheme="http://www.blogger.com/atom/ns#" term="tutorial" /><category scheme="http://www.blogger.com/atom/ns#" term="jquery UI" /><title>Tutorial: Como Usar Jquery UI Dialog</title><content type="html">&lt;title&gt;&lt;/title&gt;
 
 &lt;style type="text/css"&gt;
 &lt;!--
  @page { margin: 2cm }
  P { margin-bottom: 0.21cm }
 --&gt;
 
&lt;/style&gt;


&lt;br /&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
jQuery UI Dialog, es un widget que
forma parte de la librería del jQuery UI, que nos permite la
creación de ventanas modales, de manera fácil y sencilla. Jquery UI
Dialog como los demás widgets de la librería de jQuery UI sigue los
estándares de jQuery y por lo tanto es bastante personalizable.&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://3.bp.blogspot.com/-0ALwuZPhKng/Tpz3NfipBhI/AAAAAAAAAGA/JD9nW2eqn4o/s1600/Sin+nombre.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://3.bp.blogspot.com/-0ALwuZPhKng/Tpz3NfipBhI/AAAAAAAAAGA/JD9nW2eqn4o/s1600/Sin+nombre.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span class="Apple-style-span" style="background-color: red; color: #f3f3f3;"&gt;NOTA: Súper importante, estoy
trabajando con la versión 1.8 del jQuery UI, y según e leído lo
mas probable es que la en la versión 1.9 se modifique su forma de
uso.&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
El widget  &lt;span style="text-decoration: none;"&gt;jQuery
UI Dialog, no requiere inicialización previa para empezar a trabajar
&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;aunque de todas manera lo
podemos iniciar aparte&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;, &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;el
widget re&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;quiere &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;de&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;
un div en nuestra pagina con un id y &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;el&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;
contenido &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;que queramos que
aparezca en la ventana modal&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;.
&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;El contenido se puede
parecer &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;a esto:&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span style="text-decoration: none;"&gt;&amp;lt;div
id='dialog' style='display:none;' &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;title='titulo
de la ventana'&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;&amp;gt;&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;(&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;contenido
que quieres que &lt;/span&gt;&lt;span style="text-decoration: none;"&gt;aparezca&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;
en la caja de dialogo&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;)&lt;/span&gt;&lt;span style="text-decoration: none;"&gt;&amp;lt;/div&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span style="text-decoration: none;"&gt;Dentro
de este div, podemos poner lo que necesitemos, ya sean formularios,
imagenes, iframe, resultado de una &lt;/span&gt;&lt;u&gt;llam&lt;/u&gt;&lt;u&gt;a&lt;/u&gt;&lt;u&gt;da&lt;/u&gt;&lt;span style="text-decoration: none;"&gt;
AJAX o  todo junto si queremos. Aparte también podemos
tranquilamente modificar el contenido del dialog con jQuery.html().&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span style="text-decoration: none;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span style="text-decoration: none;"&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;Requisitos para usar jQuery UI Dialog:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;span style="text-decoration: none;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;pre style="white-space: pre-wrap; word-wrap: break-word;"&gt;&lt;ul&gt;
&lt;li&gt;jquery.ui.core.js&lt;/li&gt;
&lt;li&gt;jquery.ui.widget.js&lt;/li&gt;
&lt;li&gt;jquery.ui.position.js&lt;/li&gt;
&lt;li&gt;jquery.ui.button.js(opcional, solo si se van a usar los botones)&lt;/li&gt;
&lt;li&gt;jquery.ui.mouse.js (opcional, solo si vamos a usar draggable o resizable)&lt;/li&gt;
&lt;li&gt;jquery.ui.draggable.js(opcional solo si se va a usar la opcion "dragabble: true")&lt;/li&gt;
&lt;li&gt;jquery.ui.resizable.js&lt;/li&gt;
&lt;/ul&gt;
&lt;/pre&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Parámetros del
widget jQuery UI Dialog:&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
Aqui estan los más importantes(casi todos) para la lista completa:&amp;nbsp;&lt;a href="http://jqueryui.com/demos/dialog#options"&gt;http://jqueryui.com/demos/dialog#options&lt;/a&gt;:&amp;nbsp;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li style="text-decoration: none;"&gt;width: Especifica el ancho de la ventana modal, puede ser en numero o auto.&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;heigth: Especifica el alto de la ventana modal, puede ser numero o auto.&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;(min|max)width: especifica el ancho maximo o minimo de la ventana modal&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;(min|max)heigth: especifica la altura maxima o minima de la ventana modal&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;autoOpen: especifica si se abre o no automaticamente la ventana modal.&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;buttons, botones que va a tener nuestra ventana de dialogo, con sus funciones.&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;hide: efecto que sera usado cuando se cierre la ventana&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;show: efecto que se usara cuando se abra la ventana&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;draggable: define si es movible o no la ventana modal&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;resizable: especifica si se puede o no redimenzionar la ventana&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;modal: la ventana puede ser modal o no, si es verdad, pone un fondo en toda la pantalla semitransparente que impide que el usuario haga click en cualquier otro lado.&lt;/li&gt;
&lt;li style="text-decoration: none;"&gt;position: ubicacion de la ventana modal en la ventana, opciones:&amp;nbsp;&amp;nbsp;'center', 'left', 'right', 'top', 'bottom'. &amp;nbsp;o un array que puede contener dos pocisiones una con las "x" y otras con las "y", estas pocisiones pueden ser con una de las opciones antes puesta o con un numero.&lt;/li&gt;
&lt;li&gt;title: Especifica un titulo a la ventana&lt;/li&gt;
&lt;li&gt;zIndex: establece el zIndex para nuestra ventana modal&lt;/li&gt;
&lt;li&gt;dialogClass: agrega una clase a la ventana modal para poder definir estilos o lo que necesitemos.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;span class="Apple-style-span" style="color: #222222; font-family: 'Trebuchet MS',Verdana,Arial,sans-serif;"&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;&amp;nbsp;Eventos&lt;/span&gt;&lt;/span&gt;&lt;span class="Apple-style-span" style="color: #222222; font-family: 'Trebuchet MS',Verdana,Arial,sans-serif; font-size: 15px;"&gt;&amp;nbsp;&lt;/span&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;del widget jQuery UI Dialog:&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;a href="http://jqueryui.com/demos/dialog#events"&gt;http://jqueryui.com/demos/dialog#events&lt;/a&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;open: permite especificar algunas opciones antes de que abre la ventana de dialogo, util para ventanas con formularios, donde queremos reiniciar lo que tiene el formulario.&lt;/li&gt;
&lt;li&gt;beforeClose: funcion que se ejecute antes de que se cierre la ventana, lo cual tambien nos permite cancelar el cierre de la ventana si retorna false.&lt;/li&gt;
&lt;li&gt;close: evento de cuando se cierra la ventana.&lt;/li&gt;
&lt;li&gt;create: evento de cuando se crea la instancia.&lt;/li&gt;
&lt;li&gt;focus: evento de cuando la ventana recibe el foco o es activada.&lt;/li&gt;
&lt;li&gt;eventos de draggable: dragStart, dragStop, drag.&lt;/li&gt;
&lt;li&gt;eventos de resizable: resizeStart, resizeStop, resize.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Metodos del&lt;/span&gt;&amp;nbsp;&lt;span class="Apple-style-span" style="font-size: large;"&gt;widget jQuery UI Dialog:&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;a href="http://jqueryui.com/demos/dialog#methods"&gt;http://jqueryui.com/demos/dialog#methods&lt;/a&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;close: cierra la ventana de dialogo&lt;/li&gt;
&lt;li&gt;open: abre la ventana.&lt;/li&gt;
&lt;li&gt;destroy: destruye la ventana.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Ventajas y Desventajas del jQuery UI DIalog&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
La única
desventaja que presenta Jquery UI Dialog frente a otros plugins con
fancybox, es que este no trae ningún tipo de sistema ya pre-echo
para galerías o enlaces que se carguen con iframe o ajax, si que es
simplemente una ventana modal y las demás funcionalidades se las
tenemos que dar nosotros mismos o mezclarlo con otro plugin. Pero por
otro lado tiene una gran ventaja frente a fancybox, porque no
requiere pre-instalación de la ventana de dialogo sino que lo
podemos crear cuando lo necesitemos.&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm;"&gt;
Hasta&amp;nbsp;aquí&amp;nbsp;llega el tutorial por hoy,&amp;nbsp;después&amp;nbsp;pondre ejemplos mas concretos porque con la practica se hace al maestro.&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
Chao, Hasta una prosxima entrega!!&lt;/div&gt;
&lt;div style="margin-bottom: 0cm; text-decoration: none;"&gt;
&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-2146684832933138888?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/2146684832933138888/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/tutorial-como-usar-jquery-ui-dialog.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2146684832933138888?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/2146684832933138888?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/tutorial-como-usar-jquery-ui-dialog.html" title="Tutorial: Como Usar Jquery UI Dialog" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://3.bp.blogspot.com/-0ALwuZPhKng/Tpz3NfipBhI/AAAAAAAAAGA/JD9nW2eqn4o/s72-c/Sin+nombre.png" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;C0cMQHw5fSp7ImA9WhdbF0Q.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-7779745658399633398</id><published>2011-10-16T14:18:00.000-04:30</published><updated>2011-10-16T14:21:21.225-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-10-16T14:21:21.225-04:30</app:edited><title>Crear Urls Limpias de acentos con Codeigniter</title><content type="html">Esta ves les voy a hablar de la&amp;nbsp;función&amp;nbsp;url_title de el helper url de codeigniter, la cual es muy&amp;nbsp;útil&amp;nbsp;para crear direcciones web validas y limpias de una manera&amp;nbsp;fácil, y ademas&amp;nbsp;también&amp;nbsp;les voy a dejar una&amp;nbsp;versión&amp;nbsp;mejorada de esta&amp;nbsp;función&amp;nbsp;para que&amp;nbsp;también&amp;nbsp;limpien de acentos las url, que es lo&amp;nbsp;único&amp;nbsp;que le hace falta a esta&amp;nbsp;librería.&lt;br /&gt;
&lt;br /&gt;
La&amp;nbsp;función&amp;nbsp;lo que hace es eliminar cualquier&amp;nbsp;carácter&amp;nbsp;extraño de la cadena de texto pasada, utilizando expresiones regulares, dejando solamente los&amp;nbsp;caracteres&amp;nbsp;de la a-z y modificando los espacios a "-" o "_".&lt;br /&gt;
&lt;br /&gt;
La ejemplos de uso de la&amp;nbsp;función&amp;nbsp;url_title().&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;echo url_title('buen&amp;nbsp;día'); //da como salida "buen-da"

echo url_title("Vas para caracas?? o que?!!!?&amp;lt;{{}"); // da como resultado"Vas-para-carcas??-o-que?!!!?"

&lt;/pre&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;Como evitar que &lt;b&gt;url_title()&lt;/b&gt; elimine los acentos&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
Ahora bien, para lograr esto lo primero que debemos hacer es crear nuestra propia version del URL helper, para esto en la carpeta application/helpers creamos un archivo llamado MY_url_helper.php, (OJO usamos MY_ si ese es el prefijo que tenemos establecido en nuestro archivo de configuración) y dentro del archivo colocamos lo siguiente:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;function url_title($str, $separator = 'dash', $lowercase = FALSE)
{
  $str=strtr($str,$array=array("À"=&amp;gt; "A","Á"=&amp;gt;"A","Â"=&amp;gt;"A","Ã"=&amp;gt;"A","Ä"=&amp;gt;"A","Å"=&amp;gt;"A","à"=&amp;gt;"a","á"=&amp;gt;"a","â"=&amp;gt;"a","ã"=&amp;gt;"a","ä"=&amp;gt;"a","å"=&amp;gt;"a","Ò"=&amp;gt;"O","Ó"=&amp;gt;"O","Ô"=&amp;gt;"O","Õ"=&amp;gt;"O","Ö"=&amp;gt;"O","Ø"=&amp;gt;"O","ò"=&amp;gt;"o","ó"=&amp;gt;"o","ô"=&amp;gt;"o","õ"=&amp;gt;"o","ö"=&amp;gt;"o","ø"=&amp;gt;"o","È"=&amp;gt;"E","É"=&amp;gt;"E","Ê"=&amp;gt;"E","Ë"=&amp;gt;"E","è"=&amp;gt;"e","é"=&amp;gt;"e","ê"=&amp;gt;"e","ë"=&amp;gt;"e","Ç"=&amp;gt;"C","ç"=&amp;gt;"c","Ì"=&amp;gt;"I","Í"=&amp;gt;"I","Î"=&amp;gt;"I","Ï"=&amp;gt;"I","ì"=&amp;gt;"i","í"=&amp;gt;"i","î"=&amp;gt;"i","ï"=&amp;gt;"i","Ù"=&amp;gt;"U","Ú"=&amp;gt;"U","Û"=&amp;gt;"U","Ü"=&amp;gt;"U","ù"=&amp;gt;"u","ú"=&amp;gt;"u","û"=&amp;gt;"u","ü"=&amp;gt;"u","ÿ"=&amp;gt;"y","Ñ"=&amp;gt;"N","ñ"=&amp;gt;"n"));
  if ($separator == 'dash')
  {
   $search  = '_';
   $replace = '-';
  }
  else
  {
   $search  = '-';
   $replace = '_';
  }

  $trans = array(
      '&amp;amp;\#\d+?;'    =&amp;gt; '',
      '&amp;amp;\S+?;'    =&amp;gt; '',
      '\s+'     =&amp;gt; $replace,
      '[^a-z0-9\-\._]'  =&amp;gt; '',
      $replace.'+'   =&amp;gt; $replace,
      $replace.'$'   =&amp;gt; $replace,
      '^'.$replace   =&amp;gt; $replace,
      '\.+$'     =&amp;gt; ''
     );

  $str = strip_tags($str);

  foreach ($trans as $key =&amp;gt; $val)
  {
   $str = preg_replace("#".$key."#i", $val, $str);
  }

  if ($lowercase === TRUE)
  {
   $str = strtolower($str);
  }
  return trim(stripslashes($str));
 }
&lt;/pre&gt;
&lt;br /&gt;
Cave destacar que esta&amp;nbsp;función&amp;nbsp;es la misma de codeigniter lo&amp;nbsp;único&amp;nbsp;es que le e agregado una linea para que&amp;nbsp;también&amp;nbsp;reemplace los caracteres que tienen acentos por los normales.&lt;br /&gt;
&lt;br /&gt;
Tambien si quieres pueden agregar esta funcion: que elimina los "-" y los "_" de la caeena que se el pase, más o menos trabaja a la inversa de url_title().&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;function inv_url_title($str,$lowercase = FALSE)
{
 $str = preg_replace("#[_-]+#i", ' ', $str);
 if ($lowercase === TRUE)
 {
  $str = strtolower($str);
 }
 return $str;
}



&lt;/pre&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-7779745658399633398?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/7779745658399633398/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/crear-urls-limpias-de-acentos-con.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7779745658399633398?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7779745658399633398?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/crear-urls-limpias-de-acentos-con.html" title="Crear Urls Limpias de acentos con Codeigniter" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;CkMMQXk_eyp7ImA9WhRREUk.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-6966446512803751897</id><published>2011-10-15T23:19:00.001-04:30</published><updated>2011-11-24T08:44:40.743-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-11-24T08:44:40.743-04:30</app:edited><title>Jquery: Crear Select dinamico estado, municipio y parroquia.</title><content type="html">Hace poco una persona solicito en el blog en uno de los comentarios que como se hacia un select Dinamico con estado, municipio y parroquia, esta entrada se la voy a dedicar a ese tema pero como en todo siempre hay varias maneras de manejar un mismo problema, pues esta ves voy a mostrar una solucion !SOLO¡ usando JQUERY, para este ejemplo no voy a usar nada de php ni ajax. Para comenzar debemos tener una lista de estados municipios y parroquias, la cual debe tener un formato parecido al siguiente:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;var estados = [{'id_estado':'1','estado':'DISTRITO CAPITAL'},{'id_estado':'2','estado':'AMAZONAS'}];



var municipios = [{'id_municipio':'1','id_estado':'1','municipio':'LIBERTADOR'},{'id_municipio':'2','id_estado':'2','municipio':'ALTO ORINOCO'}];



var parroquias = [{'id_parroquia':'1','id_municipio':'1','id_estado':'1','parroquia':'Parroquia Altagracia'},{'id_parroquia':'2','id_municipio':'1','id_estado':'1','parroquia':'Paroquia Antimano'}]; 

&lt;/pre&gt;
&lt;br /&gt;
Estes son solamente de ejemplo pero por supuesto que los nuestros van a ser mucho mas largos.&lt;br /&gt;
&lt;br /&gt;
En el siguiente enlace dejo todo lo necesario para empezar, una lista en javascript con estados, municipios y parroquias de venezuela, la estructura html basica,&amp;nbsp; ademas de la version final:&lt;br /&gt;
&lt;a href="http://www.box.net/shared/7uktun6uxhbllng6rir9"&gt;http://www.box.net/shared/7uktun6uxhbllng6rir9&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Ok ahora, ya tenemos la base para empezar, lo primero es crear la lista de estados, donde vamos a usar el array de estados, para crear la lista, lo que vamos a hacer es basicamente alamcenar el html con las opciones de los estados en una variable y despues ponerla como valor del select, para recorrer el array vamos a usar .each, asi quedaria nuestra funcion para los estados:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;var sestados = '&amp;lt;option value=""&amp;gt;&amp;lt;/option&amp;gt;';
$(estados).each(function(i){
&amp;nbsp;&amp;nbsp; sestados += '&amp;lt;option value="'+this.id_estado+'"&amp;gt;'+this.estado+'&amp;lt;/option&amp;gt;';
});
$('#estados').html(sestados);

&lt;/pre&gt;
&lt;br /&gt;
Ahora ya tenemos el select de estados, ahora tenemos que crear el de municipios, para esto tenemos que usar el evento de .change() en el select de estados para que cuando sea modificado creemos el select de municipios, el cual se va a hacer muy parecido al de estados con la unica diferencia que vamos a tener que filtrar el array por estado seleccionado.&lt;br /&gt;
&lt;br /&gt;
Para obtener solo los del estado seleccionado, para ello vamos a usar la funcion &lt;a href="http://api.jquery.com/jQuery.grep/"&gt;jQuery.grep&lt;/a&gt;, la cual filtra los elementos de un array que satisfacen la funcion de filtrado, sin afectar el array original. la funcion de filtrado nos pasa dos variables el elemento del array y el indice del array, solamente tenemos que hacer nustra funcion de comprobacion y retornar true o false si cumple o no nuestros parametros.&lt;br /&gt;
&lt;br /&gt;
La funcion quedaria de esta manera:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;$('#estados').change(function(){ // evento que al ser modificado el select estados es llamado
&amp;nbsp;&amp;nbsp;&amp;nbsp; var estado = $('#estados').val(); //obtenemos el estado seleccionado
&amp;nbsp;&amp;nbsp;&amp;nbsp; var pmunicipios = $.grep(municipios,function(n,i){return (n.id_estado == estado); }); //filtramos por estado
&amp;nbsp;&amp;nbsp;&amp;nbsp; var smunicipios = '&amp;lt;option value=""&amp;gt;&amp;lt;/option&amp;gt;'; 
&amp;nbsp;&amp;nbsp;&amp;nbsp; $(pmunicipios).each(function(i){ //recorremos cada uno de los municipios previamente filtrados
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; smunicipios += '&amp;lt;option value="'+this.id_municipio+'"&amp;gt;'+this.municipio+'&amp;lt;/option&amp;gt;'; //vamos&amp;nbsp; creando el select
&amp;nbsp;&amp;nbsp;&amp;nbsp; });
&amp;nbsp;&amp;nbsp;&amp;nbsp; $('#municipios').html(smunicipios);//el html generado se asigna al select de municipios
});

&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
Ahora vamos a trabajar con con las parroquias las cuales vamos a filtrar por estado y municipio, lo cual se va a hacer de las misma manera que la anterior, con la diferencia que tenemos que cambiar todo lo que dice municipios a parroquias y el filtro ahora va a comprobar que el id_estado se el del estado y el id_municipio sea el del municipio seleccionado.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Este es el resultado final para parroquias:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;$('#municipios').change(function(){
&amp;nbsp;&amp;nbsp;&amp;nbsp; var estado = $('#estados').val();
&amp;nbsp;&amp;nbsp;&amp;nbsp; var municipio = $('#municipios').val();
&amp;nbsp;&amp;nbsp;&amp;nbsp; var pparroquias = $.grep(parroquias,function(n,i){return (n.id_estado == estado &amp;amp;&amp;amp; n.id_municipio == municipio ); });
&amp;nbsp;&amp;nbsp;&amp;nbsp; var sparroquias = '&amp;lt;option value=""&amp;gt;&amp;lt;/option&amp;gt;';
&amp;nbsp;&amp;nbsp;&amp;nbsp; $(pparroquias).each(function(i){
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; sparroquias += '&amp;lt;option value="'+this.id_parroquia+'"&amp;gt;'+this.parroquia+'&amp;lt;/option&amp;gt;';
&amp;nbsp;&amp;nbsp;&amp;nbsp; });
&amp;nbsp;&amp;nbsp;&amp;nbsp; $('#parroquias').html(sparroquias);
});

&lt;/pre&gt;
&lt;br /&gt;
Este tutorial llega a su final, como abran visto es sumamente sencillo y no necesita mucha explicacion, lo unico que nos resta es que cuando se cambie el estado seleccionado pues borre las parroquias, lo cual se los dejo de tarea :), suerte y espero que les sirva, si tienen una duda publiquenla y si les gusto compartanlo que compartir no cuesta nada.&lt;br /&gt;
&lt;br /&gt;
Nota: hay un pequeño detalle en el array que les paso en el archivo por la codificacion, pero como seguro ustedes generaran sus propios array despues por eso no lo modifique, despues hare uno con ajax y php o codeigniter.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-6966446512803751897?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/6966446512803751897/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/jquery-crear-select-dinamico-estado.html#comment-form" title="2 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/6966446512803751897?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/6966446512803751897?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/10/jquery-crear-select-dinamico-estado.html" title="Jquery: Crear Select dinamico estado, municipio y parroquia." /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>2</thr:total></entry><entry gd:etag="W/&quot;CUENQXk_eyp7ImA9WhdWEUQ.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-1213351273732795672</id><published>2011-09-04T22:51:00.000-04:30</published><updated>2011-09-04T23:04:50.743-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-09-04T23:04:50.743-04:30</app:edited><title>SHIFEDIT: Un editor de codigo en linea.</title><content type="html">&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://shiftedit.net/img/shiftedit_logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://shiftedit.net/img/shiftedit_logo.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://shiftedit.net/img/shiftedit_logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
SHIFEDIT es un editor de codigo en linea para php, Ruby, Python, Perl, Java, HTML, CSS and JavaScript, muy util, ya que te permite trabajar desde cualquier parte del mundo en linea, sin necesidad de transportar tus archivos de un lado para otro, este IDE en lineas se conecta por ftp o sftp a tu servidor y permite crear, eliminar, modificar cualquier archivo,&amp;nbsp; te ofrece un analizador de sintaxis, tambien si se a modificado externamente permite compararlos y ademas es bastante perzonalizable.&lt;br /&gt;
&lt;br /&gt;
Lo utilize en un proyecto para la pagina &lt;a href="http://www.artigoo.com/"&gt;artigoo.com&lt;/a&gt;, porque estaba conectandome en un internet que no permitia conexiones por el puerto 21, asi que pude hacerlo desde internet sin ningun problemas gracias a esta herramienta.&lt;br /&gt;
&lt;br /&gt;
La unica limitacion que tiene es que nada más te permite 3 servidores a la ves.&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: center;"&gt;
&lt;a href="http://shiftedit.net/"&gt;http://shiftedit.net&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://shiftedit.net/images/shiftedit_screenshot.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="203" src="http://shiftedit.net/images/shiftedit_screenshot.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-1213351273732795672?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/1213351273732795672/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/09/shifedit-un-editor-de-codigo-en-linea.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1213351273732795672?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1213351273732795672?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/09/shifedit-un-editor-de-codigo-en-linea.html" title="SHIFEDIT: Un editor de codigo en linea." /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;A0QMR3k6eSp7ImA9WhdWEUU.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-711483178611427398</id><published>2011-09-04T21:53:00.000-04:30</published><updated>2011-09-04T21:53:06.711-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-09-04T21:53:06.711-04:30</app:edited><title>Aprender a programar con Codecademy</title><content type="html">&lt;div class="separator" style="clear: both; text-align: left;"&gt;
Aqui les dejo una pagina muy buena para aprender a programar, por ahora los cursos son muy basicos, pero seguramente despues iran aumentando el nivel de dificultad. Lo unico  es que esta en ingles, pero todos deberiamos saber ingles para aprender a programar.&amp;nbsp;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://www.codecademy.com/"&gt;http://www.codecademy.com&lt;/a&gt;&amp;nbsp;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://www.codecademy.com/images/homepage/progress_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://www.codecademy.com/images/homepage/progress_2.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://www.codecademy.com/images/homepage/badges.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://www.codecademy.com/images/homepage/badges.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-711483178611427398?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/711483178611427398/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/09/aprender-programar-con-codecademy.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/711483178611427398?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/711483178611427398?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/09/aprender-programar-con-codecademy.html" title="Aprender a programar con Codecademy" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><georss:featurename>Avenida Fuerzas Armadas, Caracas, Venezuela</georss:featurename><georss:point>10.508150835144535 -66.90862655639648</georss:point><georss:box>10.500344835144535 -66.91849705639649 10.515956835144536 -66.89875605639648</georss:box></entry><entry gd:etag="W/&quot;DUcFRHk9eyp7ImA9WhdXEEs.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-3698896138698547153</id><published>2011-08-22T22:06:00.000-04:30</published><updated>2011-08-22T22:06:55.763-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-22T22:06:55.763-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Codeigniter 2.0.3</title><content type="html">Acaba de salir codeigniter 2.0.3, en est anueva version an habiado pequeños cambios lo principal es que se cambio de Github a Git, y ahora ademas codeigniter Core ya no se más publicamente mantenido ahora Codeigniter Reactor va a ser Codeigniter, la version mantenida por la comunidad va a ser la que se va a usar como Codeigniter. Un ¡hurra! por Codeigniter.&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;&lt;li&gt;En esta version se an echo algunos cambios en el driver de MYSQL para evitar algunos vectores de ataques&lt;/li&gt;
&lt;li&gt;Se le hicieron unas mejoras visuales al welcome de codeigniter&lt;/li&gt;
&lt;li&gt;Se agrego "application/x-csv" a mimes.php&lt;/li&gt;
&lt;li&gt;Agregaron un tercer parametro a la&amp;nbsp;función&amp;nbsp;heading para poder agregar atributos html a las tags html&lt;/li&gt;
&lt;li&gt;Se agrego is_unique a la libreria de validación de formularios.&lt;/li&gt;
&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-3698896138698547153?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/3698896138698547153/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/codeigniter-203.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3698896138698547153?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/3698896138698547153?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/codeigniter-203.html" title="Codeigniter 2.0.3" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s72-c/ci_logo_flame.jpg" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;CUUMR3c5eCp7ImA9WhdQGEg.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-7918864915946058201</id><published>2011-08-20T10:44:00.000-04:30</published><updated>2011-08-20T10:44:46.920-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-20T10:44:46.920-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="html5" /><category scheme="http://www.blogger.com/atom/ns#" term="juegos" /><title>Excelente juego en html5</title><content type="html">Despues de la salida del html5, an sido muchas las paginas que an salido aprovechando las bondades del nuevo estandar, este estandar da para todo inclusive para crear juegos, aqui les dejo un ejemplo de un juego echo con html 5 muy bueno, se los recomiendo:&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://butchersworkshop.com/witr.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://butchersworkshop.com/witr.png" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div style="text-align: center;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="text-align: center;"&gt;Enlace:&lt;/div&gt;&lt;div style="text-align: center;"&gt;&lt;a href="http://butchersworkshop.com/witr/"&gt;http://butchersworkshop.com/witr/&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-7918864915946058201?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/7918864915946058201/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/excelente-juego-en-html5.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7918864915946058201?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/7918864915946058201?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/excelente-juego-en-html5.html" title="Excelente juego en html5" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;AkQDRXc7fCp7ImA9WhdQGE0.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-9014663932917260337</id><published>2011-08-19T22:16:00.000-04:30</published><updated>2011-08-19T22:16:14.904-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-19T22:16:14.904-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="codeigniter" /><title>Manual de codeigniter 2.0.2</title><content type="html">&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s1600/ci_logo_flame.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
Aqui les dejo el manual en español de Codeigniter 2.0.2, esta bajo licencia Creative Commons, y para empezar esta muy buena.&lt;br /&gt;
&lt;br /&gt;
&lt;a href="http://www.areadepruebas.com.ar/downloads/CodeIgniter_Guia_Usuario.pdf"&gt;http://www.areadepruebas.com.ar/downloads/CodeIgniter_Guia_Usuario.pdf&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;Acerca de la Guía de Usuario en Español&lt;/span&gt;&lt;/blockquote&gt;&lt;blockquote&gt;La traducción fue realizada en el otoño/invierno austral de 2011, liberándola con la esperanza de serle útil a quien&amp;nbsp;la lea.&lt;/blockquote&gt;&lt;blockquote&gt;Julio de 2011&lt;/blockquote&gt;&lt;blockquote&gt;Fernando “seacat” Velo&lt;/blockquote&gt;&lt;blockquote&gt;seacat.area@gmail.com&lt;/blockquote&gt;&lt;blockquote&gt;Esta Guía se distrubuye con licencia&lt;/blockquote&gt;&lt;blockquote&gt;http://creativecommons.org/licenses/by-sa/3.0/&lt;/blockquote&gt;&lt;blockquote&gt;&amp;nbsp;&lt;/blockquote&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-9014663932917260337?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/9014663932917260337/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/manual-de-codeigniter-202.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/9014663932917260337?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/9014663932917260337?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/manual-de-codeigniter-202.html" title="Manual de codeigniter 2.0.2" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-W7zm33wOAHU/TUoeb-9vFpI/AAAAAAAAADQ/fdQb7ZEtoF4/s72-c/ci_logo_flame.jpg" height="72" width="72" /><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;DEECQ3k6eip7ImA9WhdQFEs.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-1217645143805573646</id><published>2011-08-15T23:21:00.000-04:30</published><updated>2011-08-15T23:21:02.712-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-15T23:21:02.712-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="API twitter" /><category scheme="http://www.blogger.com/atom/ns#" term="php" /><title>PHP: Como averiguar si un usuario existe o no en twitter</title><content type="html">Después&amp;nbsp;de tratar&amp;nbsp;fallida mente&amp;nbsp;con jquery de averiguar si NO EXISTE un usuario en twitter pues ahora lo hice con php, con php&amp;nbsp;déjenme&amp;nbsp;decirles que si se puede lograr si existe o no un usuario en twitter, ya en&amp;nbsp;&lt;a href="http://sosinformatico.blogspot.com/2011/08/como-averiguar-si-un-usuario-existe-o.html"&gt;http://sosinformatico.blogspot.com/2011/08/como-averiguar-si-un-usuario-existe-o.html&lt;/a&gt;&amp;nbsp;puse algunos datos&amp;nbsp;básicos,&amp;nbsp;aquí&amp;nbsp;voy a poner el script con el ejemplo ya echo:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN"  "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd"&amp;gt; 
&amp;lt;html&amp;gt;
&amp;lt;head&amp;gt;
	&amp;lt;script type="text/javascript" src="jquery.min.js"&amp;gt;&amp;lt;/script&amp;gt;
	&amp;lt;title&amp;gt;Twitter application&amp;lt;/title&amp;gt;

&amp;lt;/head&amp;gt;
&amp;lt;body&amp;gt;
	&amp;lt;form action='' &amp;gt;
	&amp;lt;input type='text' name='twitter'&amp;gt;
	&amp;lt;input type='submit'&amp;gt;
	&amp;lt;/form&amp;gt;
	&amp;lt;?php
	if(isset($_GET['twitter']))
	{
		$var = @fopen("http://api.twitter.com/1/users/show.json?screen_name=".$_GET['twitter'],'rb');
		if($var)
		{
			echo "&amp;lt;p&amp;gt;usuario existe&amp;lt;/p&amp;gt;";
			echo "&amp;lt;pre&amp;gt;";
			var_dump(json_decode(stream_get_contents($var)));
			echo "&amp;lt;/pre&amp;gt;";
			fclose($var);
		}
		else
		{
			echo "usuario no existe";
		}
	}

	?&amp;gt;
&amp;lt;/body&amp;gt;
&amp;lt;/html&amp;gt;
&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-1217645143805573646?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/1217645143805573646/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/php-como-averiguar-si-un-usuario-existe.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1217645143805573646?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/1217645143805573646?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/php-como-averiguar-si-un-usuario-existe.html" title="PHP: Como averiguar si un usuario existe o no en twitter" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;DEADQXY5fSp7ImA9WhdQFEs.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-4109030938895868718</id><published>2011-08-15T22:56:00.004-04:30</published><updated>2011-08-15T23:22:50.825-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-15T23:22:50.825-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="API twitter" /><category scheme="http://www.blogger.com/atom/ns#" term="jquery" /><title>Jquery: Como averiguar si un usuario existe o no en twitter</title><content type="html">A la hora de integrar, una pagina web con twitter una de las cosas que podemos requerir es averiguar si un usuario existe o no en twitter, en&amp;nbsp;Internet&amp;nbsp;no&amp;nbsp;encontré&amp;nbsp;mucha info, por eso me&amp;nbsp;decidí&amp;nbsp;a mostrar como lo hice.&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://usbe.in/wp-content/uploads/2011/05/twitter.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="263" src="http://usbe.in/wp-content/uploads/2011/05/twitter.jpg" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
Lo primero que tenemos que&amp;nbsp;saber&amp;nbsp;es que las llamadas ajax no se permite cruzar dominios, solamente que sean scripts o que tenga callback, porque de esa manera el sistema sabe que estamos llamando a el api del otro dominio.&lt;br /&gt;
&lt;br /&gt;
Para poder averiguar informacion sobre un usuario, se debe usar la siguiente url: &lt;a href="http://api.twitter.com/1/users/show.json"&gt;http://api.twitter.com/1/users/show.format&lt;/a&gt;&amp;nbsp;y aqui conseguiremos la documentación oficial del API&amp;nbsp;&lt;a href="https://dev.twitter.com/docs/api/1/get/users/show"&gt;https://dev.twitter.com/docs/api/1/get/users/show&lt;/a&gt;. Los formatos que permiten son json y xml. permiten varios&amp;nbsp;parámetros&amp;nbsp;el más importante es scree_name, con el cual especificaremos cual es el usuario que estamos buscando. ahora bien el script que averiguar si un usuario existe o no:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN"  "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd"&amp;gt; 
&amp;lt;html&amp;gt;
&amp;lt;head&amp;gt;
	&amp;lt;script type="text/javascript" src="jquery.min.js"&amp;gt;&amp;lt;/script&amp;gt;
	&amp;lt;title&amp;gt;Twitter application&amp;lt;/title&amp;gt;
	&amp;lt;script&amp;gt;
	$(function(){
		$('#twitter').change(function(){
			$.ajax({
				url:'http://api.twitter.com/1/users/show.json?callback=?',
				data: {screen_name:$('#twitter').val()},
				dataType:'json',
				type:'get',
				error: function(){
					$('#tweet').text("usuario no esiste");
				},
				success: function(data){
					$('#tweet').text("USUARIO EXISTE");
				}
			});
		});
	});
	&amp;lt;/script&amp;gt;
&amp;lt;/head&amp;gt;
&amp;lt;body&amp;gt;
	&amp;lt;input type='text' id='twitter'&amp;gt;
	&amp;lt;div id='tweet'&amp;gt;&amp;lt;/div&amp;gt;
&amp;lt;/body&amp;gt;
&amp;lt;/html&amp;gt;&lt;/pre&gt;Ademas de decirnos si existe o no el usuario nos da información relevante, como la imagen de perfil, los seguidores, etc.&lt;br /&gt;
&lt;br /&gt;
Ejemplo:&amp;nbsp;&lt;a href="http://api.twitter.com/1/users/show.json?callback=jQuery16208318964859936386_1313448625668&amp;amp;screen_name=publisnet&amp;amp;_=1313449005574"&gt;http://api.twitter.com/1/users/show.json?callback=jQuery16208318964859936386_1313448625668&amp;amp;screen_name=publisnet&amp;amp;_=1313449005574&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Cree un articulo relacionado con este sobre dice como se hace para averiguar si existe o no existe un usuario con php, que&amp;nbsp;podría&amp;nbsp;ser la&amp;nbsp;solución&amp;nbsp;para apoyar al jquery.&lt;br /&gt;
&lt;br /&gt;
NOTA: Este script&amp;nbsp;función&amp;nbsp;a la&amp;nbsp;perfección&amp;nbsp;si un usuario existe, pero si no existe no da&amp;nbsp;ningún&amp;nbsp;tipo de error, lo cual no se puede terminar de saber si el usuario no existe, de verdad no entiendo porque el jquery no responde como es debido, pero cuando consiga la solución la posteo.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-4109030938895868718?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/4109030938895868718/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/como-averiguar-si-un-usuario-existe-o.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/4109030938895868718?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/4109030938895868718?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/como-averiguar-si-un-usuario-existe-o.html" title="Jquery: Como averiguar si un usuario existe o no en twitter" /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry><entry gd:etag="W/&quot;Dk8BQXw7eip7ImA9WhdRGU4.&quot;"><id>tag:blogger.com,1999:blog-3040540087092322309.post-5393287151413678176</id><published>2011-08-09T11:35:00.003-04:30</published><updated>2011-08-09T19:37:30.202-04:30</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-09T19:37:30.202-04:30</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="gd" /><category scheme="http://www.blogger.com/atom/ns#" term="php" /><title>Libreria GD, Crear imagenes con transparencia.</title><content type="html">&lt;div style="text-align: justify;"&gt;&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://www.boutell.com/gd/gdlogobig.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="205" src="http://www.boutell.com/gd/gdlogobig.png" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
En php para crear&amp;nbsp;imágenes&amp;nbsp;con php como ya e comentado como hace con la&amp;nbsp;librería&amp;nbsp;GD en estos dos&amp;nbsp;tutoriales:&lt;/div&gt;&lt;br /&gt;
&lt;a href="http://sosinformatico.blogspot.com/2011/02/tutorial-creando-un-bonito-y-estilizado.html"&gt;http://sosinformatico.blogspot.com/2011/02/tutorial-creando-un-bonito-y-estilizado.html&lt;/a&gt;&lt;br /&gt;
&lt;a href="http://sosinformatico.blogspot.com/2011/02/tutorial-creando-un-bonito-y-estilizado_24.html"&gt;http://sosinformatico.blogspot.com/2011/02/tutorial-creando-un-bonito-y-estilizado_24.html&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;Ahora les voy a mostrar como&amp;nbsp;manejar&amp;nbsp;los colores con transparencia y crear&amp;nbsp;imágenes&amp;nbsp;con transparencias.&lt;/div&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="text-align: justify;"&gt;Cuando creamos una imagen con gd pues por defecto esta tiene color negro y no esta preparada para usar&amp;nbsp;transparencias&amp;nbsp; para poder usar las&amp;nbsp;transparencias&amp;nbsp;hay que primero activarlas como tal en la imagen para&amp;nbsp;después&amp;nbsp;poderlas usar, las funciones que se necesitan para trabajar con imagenes se usan las siguientes funciones:&lt;/div&gt;&lt;br /&gt;
&lt;a href="http://php.net/manual/es/function.imagecolorallocatealpha.php"&gt;imagecolorallocatealpha&lt;/a&gt;&lt;br /&gt;
&lt;a href="http://www.php.net/manual/es/function.imagecolortransparent.php"&gt;Imagecolortransparent&lt;/a&gt;&lt;br /&gt;
&lt;a href="http://www.php.net/manual/es/function.imagealphablending.php"&gt;imagealphablending&lt;/a&gt;&lt;br /&gt;
&lt;a href="http://www.php.net/manual/es/function.imagesavealpha.php"&gt;imagesavealpha&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;Lo primero que debemos saber es que se necesita tener instalado la version 2 de la libreria db, si ya la tenemos instalada podemos continuar tranquilamente, lo segundo que hay que denotar es que solo podemos&amp;nbsp;trabajar&amp;nbsp;con&amp;nbsp;imágenes&amp;nbsp;gif y png, ya que estas son los unicos dos formatos que soportan canales alfa. La primera&amp;nbsp;función&amp;nbsp;que vamos a analizar es:&lt;/div&gt;&lt;br /&gt;
&lt;a href="http://www.php.net/manual/es/function.imagecolortransparent.php"&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;Imagecolortransparent&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;Con esta&amp;nbsp;función&amp;nbsp;definimos un color en una imagen como&amp;nbsp;transparente, para que puede funcionar las imagenes deben haber sido creadas con imagecopymerge() o imagecreatetruecolor(), y lo que hace es especificar un color como transparente en el la imagen, por ejemplo:&lt;/div&gt;&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php
// Crear una imagen de 100x100
$im = imagecreatetruecolor(100, 100);
$rojo = imagecolorallocate($im, 255, 0, 0);
$negro = imagecolorallocate($im, 0, 0, 0);

// Hacer el fondo transparente
imagecolortransparent($im, $negro);

// Dibujar un rectángulo rojo
imagefilledrectangle($im, 4, 4, 50, 25, $rojo);
header('Content-type: image/png');
// Guardar la imagen
imagepng($im);
imagedestroy($im);
exit();
?&amp;gt;
&lt;/pre&gt;&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;si hacemos esto y lo guardamos con png o gif, pues guarda una imagen con un cuadrado rojo y el fondo transparente, si cambiamos el color transparente de $negro a $rojo veremos que el fondo sale negro y el&amp;nbsp;rectángulo&amp;nbsp;rojo, eso funciona y windows y los navegadores agarran la transparencia de las&amp;nbsp;imágenes&amp;nbsp;png pero photoshop no, photoshop se da cuenta y lo dibuja con el color como es. Por eso&amp;nbsp;recomiendo&amp;nbsp;hacerlo de la&amp;nbsp;siguiente&amp;nbsp;manera:&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;a href="http://www.php.net/manual/es/function.imagealphablending.php"&gt;Imagealphablending&lt;/a&gt;&amp;nbsp;y&amp;nbsp;&lt;a href="http://www.php.net/manual/es/function.imagesavealpha.php"&gt;Imagesavealpha&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;Imagealphablending especifica en que modo&amp;nbsp;serán&amp;nbsp;mezclado los colores a la hora de dibujar una imagen, cuando se establece en true pues al dibujar colores el canal alpha que sea establecido para dibujar sera tomado como la cantidad que va a brillar el color subyacente a&amp;nbsp;través&amp;nbsp;de colores de la imagen, y cuando se establece en false pues se guarda de verdad el canal alpha en la imagen.&lt;/div&gt;&lt;div style="text-align: justify;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="text-align: justify;"&gt;A la hora de crear imagenes el uso de estas funciones depende de en que formato lo vamos a guardar si es gif con la&amp;nbsp;función&amp;nbsp;imagealphablending es suficiente pero si vamos a crear una imagen png debemos usar la función&amp;nbsp;imagesavealpha para especificar la bandera de que se debe guardar toda la imagen alpha.&amp;nbsp;&lt;/div&gt;&lt;br /&gt;
&lt;a href="http://php.net/manual/es/function.imagecolorallocatealpha.php"&gt;&lt;span class="Apple-style-span" style="font-size: large;"&gt;Imagecolorallocatealpha&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Ahora bien para poder dibujar un color transparente o semi trasnparente en una imagen, pues debemos usar la función imagecolorallocatealpha, y que es casi la misma que imagecolorallocate lo unico es que agrega un parametro que es el nivel de alfa que va a tener ese colo que el rango es de 0 a 127 siendo 127 el trasnparente absoluto.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Aqui esta el mismo ejemplo anterior pero acomodado para png:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php
// Crear una imagen de 100x100
$im = imagecreatetruecolor(100, 100);
imagealphablending($im, false);
imagesavealpha($im, true);
$rojo = imagecolorallocate($im, 255, 0, 0);
$negro = imagecolorallocatealpha($im, 0, 0, 0,127);

// Dibujar el fondo transparente
imagefilledrectangle($im, 0, 0, 100, 100, $negro);
// Dibujar un rectángulo rojo
imagefilledrectangle($im, 4, 4, 50, 25, $rojo);
header('Content-type: image/png');
// Guardar la imagen

imagepng($im);
imagedestroy($im);
exit();
?&amp;gt;
&lt;/pre&gt;&lt;div&gt;Resultado final:&lt;/div&gt;&lt;div&gt;&lt;a href="http://courch7642.webcindario.com/blog/gd2.php"&gt;http://courch7642.webcindario.com/blog/gd2.php&lt;/a&gt;&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://courch7642.webcindario.com/blog/gd2.php" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://courch7642.webcindario.com/blog/gd2.php" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;Ahora aparte les dejo dos ejemplos de&amp;nbsp;imágenes&amp;nbsp;con&amp;nbsp;transparencia:&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;1. 3&amp;nbsp;círculos&amp;nbsp;semitransparentes&amp;nbsp;con fondo transparente:&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php
$tamaño = 300;
$imagen=imagecreatetruecolor($tamaño, $tamaño);
imagealphablending($imagen, false);
imagesavealpha($imagen, true);
// algo para obtener un fondo transparente
$fondo = imagecolorallocatealpha($imagen, 255, 255, 255,127);
imagefilledrectangle($imagen, 0, 0, $tamaño, $tamaño, $fondo);

$amarillo_x = 100;
$amarillo_y = 75;
$rojo_x &amp;nbsp; &amp;nbsp; = 120;
$rojo_y &amp;nbsp; &amp;nbsp; = 165;
$azul_x &amp;nbsp; &amp;nbsp; = 187;
$azul_y &amp;nbsp; &amp;nbsp; = 125;
$radio &amp;nbsp; &amp;nbsp; &amp;nbsp;= 150;
// asignar colores con valores alfa
$amarillo = imagecolorallocatealpha($imagen, 255, 255, 0, 75);
$rojo &amp;nbsp; &amp;nbsp; = imagecolorallocatealpha($imagen, 255, 0, 0, 75);
$azul &amp;nbsp; &amp;nbsp; = imagecolorallocatealpha($imagen, 0, 0, 255, 75);
// dibujar 3 círculos solapados
imagefilledellipse($imagen, $amarillo_x, $amarillo_y, $radio, $radio, $amarillo);
imagefilledellipse($imagen, $rojo_x, $rojo_y, $radio, $radio, $rojo);
imagefilledellipse($imagen, $azul_x, $azul_y, $radio, $radio, $azul);
// ¡no olvide imprimir la cabecera correcta!
header('Content-type: image/png');
// y finalmente, imprimir el resultado
imagepng($imagen);
imagedestroy($imagen);
?&amp;gt;
&lt;/pre&gt;Resultado final:&lt;br /&gt;
&lt;a href="http://courch7642.webcindario.com/blog/gd3.php"&gt;http://courch7642.webcindario.com/blog/gd3.php&lt;/a&gt;&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://courch7642.webcindario.com/blog/gd3.php" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://courch7642.webcindario.com/blog/gd3.php" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;2. Este codigo genera fondos semitransparentes&amp;nbsp;muy&amp;nbsp;útiles&amp;nbsp;a la hora de diseñar una pagina web. y lo mejor es que podemos especificar que color queremos.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="brush: javascript"&gt;&amp;lt;?php
if(isset($_GET['hex']))
{
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;$hex=$_GET['hex'];
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;header('Content-Transfer-Encoding: binary');
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;header('Content-type: image/png');
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;//creo imagen
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;if(strlen($hex)==6)
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;{
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$hcnt=strlen($hex)/3;
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['red']=hexdec(substr($hex,0,$hcnt));
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['green']=hexdec(substr($hex,$hcnt,$hcnt));
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['blue']=hexdec(substr($hex,$hcnt*2));
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;}
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;else
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;{
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['red']=0;
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['green']=0;
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;		&lt;/span&gt;$color['blue']=0;
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;}
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;$fondo = imagecreatetruecolor(10,10);
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagealphablending($fondo, false);
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagesavealpha($fondo, true);
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;$color['img']=imagecolorallocatealpha($fondo, $color['red'], $color['green'], $color['blue'],75);
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagefilledrectangle($fondo, 0, 0, 10, 10, imagecolorallocatealpha($fondo, 255, 255, 255,0));
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagefilledrectangle($fondo, 0, 0, 10, 10, $color['img']);

&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagepng($fondo);
&lt;span class="Apple-tab-span" style="white-space: pre;"&gt;	&lt;/span&gt;imagedestroy($fondo);
}
?&amp;gt;
&lt;/pre&gt;&lt;br /&gt;
Resultado final:&lt;br /&gt;
&lt;a href="http://courch7642.webcindario.com/blog/gd.php?hex=ff0000"&gt;http://courch7642.webcindario.com/blog/gd.php?hex=ff0000&lt;/a&gt;&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://courch7642.webcindario.com/blog/gd.php?hex=ff0000" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://courch7642.webcindario.com/blog/gd.php?hex=ff0000" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;a href="http://courch7642.webcindario.com/blog/gd.php?hex=79B7E7"&gt;http://courch7642.webcindario.com/blog/gd.php?hex=79B7E7&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://courch7642.webcindario.com/blog/gd.php?hex=79B7E7" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="http://courch7642.webcindario.com/blog/gd.php?hex=79B7E7" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3040540087092322309-5393287151413678176?l=sosinformatico.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel="replies" type="application/atom+xml" href="http://sosinformatico.blogspot.com/feeds/5393287151413678176/comments/default" title="Enviar comentarios" /><link rel="replies" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/libreria-gd-crear-imagenes-con.html#comment-form" title="0 comentarios" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/5393287151413678176?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/3040540087092322309/posts/default/5393287151413678176?v=2" /><link rel="alternate" type="text/html" href="http://sosinformatico.blogspot.com/2011/08/libreria-gd-crear-imagenes-con.html" title="Libreria GD, Crear imagenes con transparencia." /><author><name>Mariano Ramirez</name><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total></entry></feed>

