Skip to content

Instantly share code, notes, and snippets.

@mfr
mfr / pxs.java
Last active December 17, 2015 09:59
import javax.swing.*;
import java.awt.*;
import java.awt.image.BufferedImage;
public class pxs extends JFrame {
private static final long SLEEP_DELAY = 500L;
private static JLabel label;
public static void main(String[] args) {
JFrame frame = new pxs();
@mfr
mfr / netatmo_pws.php
Created December 23, 2012 10:56
Reading last data from netatmo device and sending it to wunderground.
#!/usr/bin/php
<?php
date_default_timezone_set('UTC');
/**
* oAuth settings from http://dev.netatmo.com/dev/listapps
*/
define('APP_ID', '');
define('APP_SECRET', '');
define('USERNAME', '');
define('PASSWORD', '');
@mfr
mfr / gist:1281094
Created October 12, 2011 12:25
unique value
CREATE TABLE `some_table` (
 `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
 `value` varchar(255) NOT NULL DEFAULT '',
 PRIMARY KEY (`id`),
 UNIQUE KEY `value` (`value`)
);
INSERT INTO some_table (value) VALUES ('test') ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id);
select last_insert_id();
@mfr
mfr / gist:1275370
Created October 10, 2011 13:45
MySQL selecting random rows fast
SELECT *
FROM (
SELECT @cnt := COUNT(*) + 1,
@lim := 10
FROM t_random
) vars
STRAIGHT_JOIN
(
SELECT r.*,
@lim := @lim - 1
@mfr
mfr / urlParams.js
Created October 10, 2011 12:35
url parameters - javascript
var urlParams = {};
(function () {
var e,
r = /([^&=]+)=?([^&]*)/g,
d = function (s) { return decodeURIComponent(unescape(s)); },
q = window.location.search.substring(1);
while (e = r.exec(q))
urlParams[d(e[1])] = d(e[2]);
})();