Skip to content

Instantly share code, notes, and snippets.

View sbarrat's full-sized avatar

Ruben Lacasa sbarrat

2 followers · 1 following
View GitHub Profile
@sbarrat
sbarrat / Preferences.sublime-settings
Created February 16, 2014 18:56
Sublime Text 3 User Preferences Settings
{
"auto_complete": true,
"auto_complete_commit_on_tab": true,
"auto_complete_with_fields": true,
"bold_folder_labels": true,
"caret_style": "phase",
"color_scheme": "Packages/User/base16-ocean.light (SL).tmTheme",
"detect_indentation": true,
"fade_fold_buttons": false,
"folder_exclude_patterns":
@sbarrat
sbarrat / quitaEspacios.php
Last active August 29, 2015 13:58
Función para quitar espacios en blanco extras dentro de los textos
<?php
function quitaEspacios($texto)
{
$partes = explode(' ', $texto);
$textoLimpio = "";
foreach ($partes as $parte) {
if (strlen($parte) > 0 || $parte != "") {
$nombreLimpio .= $parte." ";
}
}
@sbarrat
sbarrat / ExtractURLVarValues.sql
Last active August 29, 2015 14:24
Extract the values of the vars in a url
/**
Si le pasamos una cadena como:
'index.php?var=17&otravar=12&masvar=33&muchovar=21'
nos devuelve una tabla con los valores de las variables
*/
DROP PROCEDURE IF EXISTS extractVars;
CREATE PROCEDURE extractVars(url VARCHAR(255))
BEGIN
DECLARE posicion INT;
DECLARE fin INT;
@sbarrat
sbarrat / Entrada.java
Created January 17, 2012 10:27
Clase que recoge los datos por teclado y devuelve lo que hemos escrito - JAVA
package entrada;
import java.io.*;
/**
* @author Ruben Lacasa
*
*/
public class Entrada {
/**
* @param args
@sbarrat
sbarrat / xmlrpcClientBugzilla.php
Created January 28, 2012 11:45
XMLRCP Client Bugzilla Login
/**
* require PEAR/XML_RPC2 library
* Works fine with bugzilla 4.0.3
*/
require_once 'XML/RPC2/Client.php';
$server = 'http://bugzilla.mydomain.com/xmlrpc.cgi';
$params = array( 'login' => 'bugzilla@mydomain.com','password' =>'mypassword', 'remember' => 1);
$client = XML_RPC2_Client::create( $server );
$userid = $client->__call( 'User.login' , $params );
@sbarrat
sbarrat / bugzillaWebService.php
Created January 31, 2012 09:17
XMLRPC_Client Bugzilla with Zend Framework
require_once 'Zend/Loader/Autoloader.php';
Zend_Loader_Autoloader::getInstance();
$server = 'http://bugzilla.mydomain.com/xmlrpc.cgi';
$client = new Zend_XmlRpc_Client( $server );
// Create the http client
$httpClient = new Zend_Http_Client();
$httpClient->setCookieJar();
$client->setHttpClient( $httpClient );
// Bugzilla Login
$params = new Zend_XmlRpc_Value_Struct(
@sbarrat
sbarrat / datepickerEs.js
Created July 20, 2012 16:03
Datepicker jQuery en castellano
$('.datepicker').datepicker({
dateFormat: "dd-mm-yy",
firstDay: 1,
dayNamesMin: ["Do", "Lu", "Ma", "Mi", "Ju", "Vi", "Sa"],
dayNamesShort: ["Dom", "Lun", "Mar", "Mie", "Jue", "Vie", "Sab"],
monthNames:
["Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio",
"Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"],
monthNamesShort:
["Ene", "Feb", "Mar", "Abr", "May", "Jun",
@sbarrat
sbarrat / SumaTiempos.php
Last active December 17, 2015 16:59
Clase PHP para sumar tiempos / PHP Class to add times
<?php
/**
* SumaTiempos.php Clase para sumar tiempos
*
* Esta clase sirve para teniendo un tiempo inicial y un Array con tiempos
* los suma y nos devuelve el tiempo final
*
* PHP Version 5.3
*
* @author Ruben Lacasa Mas <ruben@rubenlacasa.es>
@sbarrat
sbarrat / datePickerInlineEs.html
Created June 1, 2013 17:09
<!--
Demo de datepicker inline en castellano
Autor: Ruben Lacasa Mas <http://rubenlacasa.es>
-->
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="author" content="Ruben Lacasa Mas - rubenlacasa.es">
@sbarrat
sbarrat / datosEntreFechas.sql
Created June 12, 2013 07:58
Seleccionar datos entre dos fechas
SELECT data FROM tbl WHERE date BETWEEN date1 AND date2