Skip to content

Instantly share code, notes, and snippets.

View nerestaren's full-sized avatar

Antoni Oliver nerestaren

2 followers · 1 following
View GitHub Profile
@nerestaren
nerestaren / ifconfig
Created December 29, 2019 22:20
osmc@osmc:~$ ifconfig
eth0: flags=-28605<UP,BROADCAST,RUNNING,MULTICAST,DYNAMIC> mtu 1500
inet 192.168.1.100 netmask 255.255.255.0 broadcast 192.168.1.255
ether b8:27:eb:5d:57:a4 txqueuelen 1000 (Ethernet)
RX packets 400632 bytes 519837935 (495.7 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 25314 bytes 1575366 (1.5 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
@nerestaren
nerestaren / alphamap.js
Created March 21, 2018 10:40
A-FRAME Alpha Map
// This component adds an alpha map to a mesh.
AFRAME.registerComponent('alpha-map', {
schema: {
src: {type: 'map'}
},
init: function() {
this.el.sceneEl.systems.material.loadTexture(this.data.src, {src: this.data.src}, this.callback.bind(this));
},
callback: function(texture) {
@nerestaren
nerestaren / query,sql
Created January 3, 2018 18:11
Select public forums
SELECT f.forum_id
FROM forums f
LEFT JOIN acl_groups ag ON ag.forum_id = f.forum_id
LEFT JOIN acl_options ao ON ag.auth_option_id = ao.auth_option_id
LEFT JOIN acl_roles_data ard ON ag.auth_role_id = ard.role_id
LEFT JOIN acl_options ao2 ON ard.auth_option_id = ao2.auth_option_id
WHERE ag.group_id = 2 AND ((ag.auth_option_id = 20 AND ag.auth_setting = 1) OR (ard.auth_option_id = 20 AND ard.auth_setting = 1))
@nerestaren
nerestaren / imgur_direct_link.user.js
Last active November 13, 2018 09:51
Imgur direct link userscript
@nerestaren
nerestaren / Encoding.java
Last active September 28, 2017 22:06
Java System.in System.out encoding playground
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package encoding;
import java.io.*;
/**
@nerestaren
nerestaren / ping.sh
Created May 20, 2017 13:38
#/bin/bash
while true
do
ping -c 1 www.uib.es > /dev/null 2>&1
echo -e `date '+%Y-%m-%d %H:%M:%S'` '\t' $?
# sleep 10
done
@nerestaren
nerestaren / .htaccess
Last active May 14, 2017 23:27 — forked from Ereza/.htaccess
htaccess for seourls
RewriteRule ^(.+)-t([0-9])-([0-9]).html viewtopic.php?t=$2&start=$3&%{QUERY_STRING} [L]
RewriteRule ^(.+)-t([0-9]).html viewtopic.php?t=$2&%{QUERY_STRING} [L]
RewriteRule ^(.+)-f([0-9])-([0-9]).html viewforum.php?f=$2&start=$3&%{QUERY_STRING} [L]
RewriteRule ^(.+)-f([0-9]).html viewforum.php?f=$2&%{QUERY_STRING} [L]
@nerestaren
nerestaren / patata.json
Created March 27, 2017 11:23
{"asd": "asd"}
@nerestaren
nerestaren / test.json
Created March 27, 2017 10:53
prova
{"name": "test"}
@nerestaren
nerestaren / rols.sql
Last active December 20, 2016 17:16
Els rols que s'han escrit a Tadaima
SELECT DATE_FORMAT(FROM_UNIXTIME(post_time), '%d/%m/%Y %T'), username, forum_name, topic_title, (
SELECT COUNT(topic_id)
FROM posts as b
WHERE topic_id = posts.topic_id AND post_time <= posts.post_time
), CAST(CONCAT('https://tadaima.cat/topic', posts.topic_id, '.html#p', posts.post_id) AS CHAR) AS url
FROM posts
LEFT JOIN users on poster_id = user_id
LEFT JOIN topics on posts.topic_id = topics.topic_id
LEFT JOIN forums on topics.forum_id = forums.forum_id
WHERE posts.forum_id IN (39, 40, 41, 42)