Skip to content

Instantly share code, notes, and snippets.

View rwp0's full-sized avatar
📚
On one's own way, at one's own pace…

Elvin Aslanov rwp0

📚
On one's own way, at one's own pace…
View GitHub Profile
@rwp0
rwp0 / user.grant.sql
Last active July 31, 2022 18:26
MySQL create database user and grants privileges with a single command
-- create database user and grant privileges with a single command
GRANT ALL PRIVILEGES
ON TABLE <database>.*
TO <user>
IDENTIFIED BY <password>;
SHOW GRANTS FOR <user>;
-- output: GRANT ALL PRIVILEGES ON `<database>`.* TO '<user>'@'%'
-- % is the default host for the user (ie. IP address or hostname where the user connects from)
@rwp0
rwp0 / move_sheet.google.js
Created August 2, 2022 12:46
Move Sheet to Last Tab
function move_sheet () {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheets_number = spreadsheet.getNumSheets();
// https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getnumsheets
spreadsheet.moveActiveSheet(sheets_number);
// https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#moveActiveSheet(Integer)
}
@rwp0
rwp0 / version.wordpress.sh
Created August 3, 2022 08:17
Determine WordPress version
grep '^$wp_version' wp-includes/version.php
# eg. $wp_version = '3.4.2';
# See also:
# $required_php_version = '5.2.4';
# $required_mysql_version = '5.0';
@rwp0
rwp0 / debug.wp-config.php
Last active November 25, 2022 06:48
Enable WordPress / PHP Debugging
<?php
# put on top at wp-config.php
define('WP_DEBUG', true);
define('WP_DEBUG_DISPLAY', true);
define( 'WP_DEBUG_LOG', true );
ini_set('display_errors', 'True'); // on screen
ini_set('error_reporting', E_ALL);
@rwp0
rwp0 / GetOpt.pl
Created August 10, 2022 05:55
Perl GetOpt::Long Boilerplate
use Getopt::Long qw(
:config
auto_help
auto_version
no_ignore_case
bundling
);
my %options;
Getopt::Long::GetOptions(
@rwp0
rwp0 / audio.ffmpeg.sh
Created August 15, 2022 12:25
Remove Audio Stream From MP4 Video Using FFmpeg
ffmpeg -i input_file.mp4 -vcodec copy -an output_file.mp4
# https://unix.stackexchange.com/a/33864/455788
@rwp0
rwp0 / function.sql
Created August 20, 2022 11:24
Show MySQL Routines within Database
SHOW FUNCTION STATUS
WHERE db = 'wordpress';
@rwp0
rwp0 / perl.sh
Last active May 25, 2023 15:50
Compile Perl
# after changes, and incrementing module's version
./Configure -des -Dusedevel -Dusethreads # 'usedevel' needed for blead
make test_porting # before GitHub Actions
# https://github.com/Perl/perl5/pull/20038
# https://perlmaven.com/how-to-build-perl-from-source-code
@rwp0
rwp0 / clean_perl_distributions.org
Last active August 30, 2022 20:47
Clean Perl Distributions

Clean Pearl Distributions

With no dependencies

Log::Log4perl
p5-Log-Log4perl
  • Path::Tiny
  • Config::General
  • p5-PadWalker
  • p5-Term-ReadKey
@rwp0
rwp0 / perl_rebase.org
Last active September 10, 2022 14:16
Perl Pull Request Rebase in 4 Steps
  1. git fetch upstream blead
  2. git commit -avm 'Update POSIX synopsis' --amend
  3. git rebase upstream/blead
  4. git push -f

don’t forget to: create a new branch, and set remote for upstream