Skip to content

Instantly share code, notes, and snippets.

Avatar

Bill Seremetis bserem

View GitHub Profile
@bserem
bserem / update_mixxx_paths.sql
Created Apr 28, 2018
Change paths of files in MIXXX sqlite dabatase
View update_mixxx_paths.sql
/**
*Looks for directory *750GB* in the path and removes it for paths.
* Based on that you can do any replacements.
*/
UPDATE track_locations
SET location = replace (location, '750GB/', '')
where
location LIKE '%750G%';
@bserem
bserem / drupal8_menu_item_clone.sql
Created Apr 27, 2018
Clone Drupal 8 menu items to another menu and change their language code.
View drupal8_menu_item_clone.sql
INSERT INTO menu_link_content_data
(
id,
bundle,
langcode,
title,
description,
menu_name,
link__uri,
link__title,
@bserem
bserem / redirect_importer.sh
Last active Mar 8, 2018
Mass import redirects in Drupal 8 from CSV
View redirect_importer.sh
#!/bin/bash
i=0
cat redir.csv| while read line
do
let "i++"
rsource=`echo $line | cut -d ',' -f1`
rtarget=`echo $line | cut -d ',' -f2`
redirect='use Drupal\redirect\Entity\Redirect;Redirect::create(["redirect_source" => "'$rsource
if [[ $rtarget = *"http"* ]]; then
@bserem
bserem / Android Privacy Policy Template
Created Dec 8, 2017 — forked from alphamu/Android Privacy Policy Template
A template for creating your own privacy policy for Android apps. Look for "[" and "<!--" to see where you need to edit this app in order to create your own privacy olicy.
View Android Privacy Policy Template
<html>
<body>
<h2>Privacy Policy</h2>
<p>[Individual or Company Name] built the [App Name] app as a [open source | free | freemium | ad-supported | commercial] app. This SERVICE is provided by [Individual or company name] [at no cost] and is intended
for use as is.</p>
<p>This page is used to inform website visitors regarding [my|our] policies with the collection, use, and
disclosure of Personal Information if anyone decided to use [my|our] Service.</p>
<p>If you choose to use [my|our] Service, then you agree to the collection and use of information in
relation with this policy. The Personal Information that [I|we] collect are used for providing and
improving the Service. [I|We] will not use or share your information with anyone except as described
@bserem
bserem / LCDd.conf
Created Jun 17, 2017
HD44780 LibreElec 8 (.kodi/userdata/addon_data/service.lcdd/LCDd.conf)
View LCDd.conf
# LCDd.conf -- configuration file for the LCDproc server daemon LCDd
#
# This file contains the configuration for the LCDd server.
#
# The format is ini-file-like. It is divided into sections that start at
# markers that look like [section]. Comments are all line-based comments,
# and are lines that start with '#' or ';'.
#
# The server has a 'central' section named [server]. For the menu there is
# a section called [menu]. Further each driver has a section which
View PLH11_GE2_ASK4
-- this is an example
group: ask4
katalima = {
kodikosK:number, onomaK:string, addressK:string, city:string
1, 'Lato', 'Kapou 5', 'Patra'
2, 'Menexes', 'Kapoy allou 4', 'Patra'
}
View mpd.rpi.librelec.hifiberry.conf
# An example configuration file for MPD
# See the mpd.conf man page for a more detailed description of each parameter.
# Files and directories #######################################################
#
# This setting controls the top directory which MPD will search to discover the
# available audio files and add them to the daemon's online database. This
# setting defaults to the XDG directory, otherwise the music directory will be
# be disabled and audio files will only be accepted over ipc socket (using
View .tmux.conf
# Set Ctrl-a as control instead of ctrl-b
unbind C-b
set -g prefix C-a
bind C-a send-prefix
# Nested Multiplexers
bind-key a send-prefix
# Switch to last window with two C-a
bind-key C-a last-window
@bserem
bserem / Gulpfile.js
Created Jul 21, 2016
Super-gulp for drupal (but not just drupal) theming.
View Gulpfile.js
var gulp = require('gulp');
del = require('del');
stripDebug = require('gulp-strip-debug');
gulpIgnore = require('gulp-ignore');
plumber = require('gulp-plumber'); //error handling
replace = require('gulp-replace'); //replace text
livereload = require('gulp-livereload'); // push css changes to browser
autoprefixer = require('gulp-autoprefixer'); // vendor-prefix css
sass = require('gulp-sass'); //libsass
sourcemaps = require('gulp-sourcemaps'); // sourcemaps for SASS->CSS
@bserem
bserem / workshop_create.sql
Created Apr 3, 2015
Create dabatase and grant permissions
View workshop_create.sql
CREATE USER 'workshop'@'localhost' IDENTIFIED BY 'workshop';
CREATE DATABASE workshop;
GRANT ALL PRIVILEGES ON workshop.* TO 'workshop'@'localhost';
You can’t perform that action at this time.