Skip to content

Instantly share code, notes, and snippets.

View nd3w's full-sized avatar

nd3w

1 follower · 1 following
View GitHub Profile
@nd3w
nd3w / Youtube Iframe
Created March 25, 2021 04:11
Iframe without right click, etc, could be work for Youtube addresses only.
<iframe
id="068a380a-add0-4954-b0fb-b25884efab81"
class="c-hero-media__video js-hero-player"
data-youtube-api="https://www.youtube.com/iframe_api"
data-youtube-id="-q7UBPU0MYI"
frameborder="0"
allowfullscreen="1"
allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture"
title="YouTube video player"
width="100%"
@nd3w
nd3w / My Linux Setting Collection
Last active December 21, 2022 23:58
Touchpad
Turn on touchpad: xinput set-prop 15 "Device Enabled" 1
Turn off touchpad: xinput set-prop 15 "Device Enabled" 0
Mount flashdisc
umask=0,nosuid,nodev,nofail,x-gvfs-show,x-gvfs-name=Kingston,noauto
Setup Linux Mint Screensaver
Disable Screensaver
@nd3w
nd3w / install-gimp-ppa.txt
Last active June 3, 2020 00:58
Install GIMP 2.10 on Ubuntu 18.04
Installing:
open a terminal and type:
sudo add-apt-repository ppa:otto-kesselgulasch/gimp
sudo apt-get update
sudo apt-get install gimp
Removing:
open a terminal and type:
sudo apt-get install ppa-purge
sudo ppa-purge ppa:otto-kesselgulasch/gimp
@nd3w
nd3w / xfce-panel-icon-size.md
Last active May 7, 2024 00:29
How to change XFCE panel's of notify and audio icon size

This is a way to change notify and audio icon size for XFCE panel:

Create or edit ~/.config/gtk-3.0/gtk.css, and add these two selectors:

#pulseaudio-button * {
        -gtk-icon-transform: scale(.55);
}

#xfce4-notification-plugin * {
@nd3w
nd3w / install-nginx-mariadb-phpfpm-on-ubuntu-20.04.md
Last active April 8, 2024 10:28
How to Install Nginx, MariaDB, PHP-FPM on Ubuntu 20.04

How to Install Nginx, MariaDB, PHP-FPM on Ubuntu 20.04

This is a way to install and set up Nginx, MariaDB and PHP-FPM on Ubuntu 20.04.

NOTE: This has been prepared for ease of use in mind, not security, mostly in development machine. Please do not use these instructions to setup on a public server environment. Use other proper manuals instead.

$ sudo apt update

Nginx

@nd3w
nd3w / mysql-queries.md
Last active April 3, 2023 08:23
Collection of useful MySQL queries

List of table's names only

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='db name' 
    AND `TABLE_NAME`='table name';

Select all rows with the same value

SELECT e1.*

@nd3w
nd3w / horizontal-vertical-center.html
Last active December 5, 2019 01:06
Horizontally and vertically center div in a page
<!DOCTYPE html>
<html>
<head>
<title>The Center </title>
<link href="https://fonts.googleapis.com/css?family=Open+Sans:400,700" rel="stylesheet">
<style>
html, body {
height: 100%;
}
@nd3w
nd3w / Binding_params.php
Last active October 24, 2019 06:04
Dynamically binding params in prepared statment
<?php
$array = [1,2,3,4,5,6,7];
$count_array = count($array);
$placeholders = implode(',', array_fill(0, $count_array, '?'));
$query = $DB->Prepare('
SELECT id, name
FROM table_name
WHERE id IN (' . $placeholders . ')
');
@nd3w
nd3w / install-wine4-ubuntu18.04.txt
Last active October 29, 2019 09:00
Installing Wine 4.0 on Ubuntu 18.04 and Linux Mint 19
$ sudo dpkg --add-architecture i386
$ sudo apt update
$ wget -qO- https://dl.winehq.org/wine-builds/Release.key | sudo apt-key add -
$ sudo apt-add-repository 'deb http://dl.winehq.org/wine-builds/ubuntu/ bionic main'
$ sudo apt update
@nd3w
nd3w / gist:dde9fa08b51b3b64c23c30c16038c125
Created August 3, 2019 09:12
Important query for MySQL
Get how many rows in whole database
SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db_name';