Erwan NaWer

NaWer / daemon.py

Created October 8, 2019 19:22 — forked from dtuominen/daemon.py

	'''
	***
	Modified generic daemon class
	***

	Author: http://www.jejik.com/articles/2007/02/a_simple_unix_linux_daemon_in_python/
	www.boxedice.com

	License: http://creativecommons.org/licenses/by-sa/3.0/

NaWer / commands.md

Last active February 26, 2018 09:12

Ubuntu 16.04 - grub & busybox restoration

Grub

NaWer / delete_duplicate.sql

Created September 2, 2014 12:35

Delete duplicate row on a MySQL table

	# Source : http://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql
	ALTER IGNORE TABLE my_table_name ADD UNIQUE INDEX my_index_name (my_column_1, my_column_2, my_column_3, ... );

NaWer / BIG_SEC_TO_TIME.sql

Last active February 8, 2023 08:49

SEC_TO_TIME and TIME_TO_SEC is constrained to the range of the TIME data type (-838:59:59 to 838:59:59). This MySQL function overtakes this limit.

	DROP FUNCTION IF EXISTS BIG_SEC_TO_TIME;
	DELIMITER $$
	CREATE FUNCTION BIG_SEC_TO_TIME(SECS BIGINT)
	RETURNS TEXT
	READS SQL DATA
	DETERMINISTIC
	BEGIN
	DECLARE HEURES TEXT;
	DECLARE MINUTES CHAR(5);
	DECLARE SECONDES CHAR(5);

NaWer / duration8601.php

Last active April 7, 2022 13:58

Convert duration in second to duration in ISO8601

	<?php
	/*
	* Convert duration in second to duration in ISO8601
	* http://www.w3schools.com/Schema/schema_dtypes_date.asp#Duration Data Type
	* http://en.wikipedia.org/wiki/ISO_8601#Durations
	*
	* @param integer $duration in second seconde
	* @return string duration in ISO8601
	*
	* >= PHP 5.3 : use DateInterval <http://www.php.net/manual/en/dateinterval.construct.php>

NaWer / getAttribute.php

Last active December 31, 2015 14:49

Get the Value of Attributes in HTML tags using PHP

	<?php
	/*
	* Return the value of an attribute in HTML tag
	*/
	function getAttribute($attrib, $tag)
	{
	$re = '/' . preg_quote($attrib) . '=([\'"])?((?(1).+?\|[^\s>]+))(?(1)\1)/is';
	if (preg_match($re, $tag, $match))
	return urldecode($match[2]);
	return false;

NaWer / lettersToDigits.js

Last active December 27, 2015 13:59

Convert letters to digits using "old" phone keybord

	var _in = 'erwan123';
	var _out = [];

	var map = ['0 ','1','2abc','3def','4ghi','5jkl','6mno','7pqrs','8tuv','9wxyz'];
	for(var i = 0; i < _in.length; i++)
	{
	for (var j = 0; j < map.length; j++)
	{
	if (map[j] && map[j].indexOf(_in[i]) > -1)
	{

NaWer / lolcat.rb

Created October 30, 2012 08:57

Fetch a random lolcat url.

	require 'open-uri'

	def random_lolcat
	open("http://icanhascheezburger.com/?random").read.match(/"http:\/\/icanhascheezburger\.files\.wordpress\.com\/[^"]+/)[0][1..-1]
	end