Justinzobel

MySQL command to get a list of all pages (decoded from binary) and show the date they were last modified (in YYYYMMDD etc)

select cast(page_title as CHAR),cast(page_touched as CHAR) from page ORDER BY page_touched ASC;

Justinzobel

token=123456789etc
curl -X POST "https://pagure.io/api/0/-/whoami" \
     -H "Authorization: token $TOKEN" \
     -H "Content-Type: application/x-www-form-urlencoded"

Justinzobel

window {
    background-color: #31363b;
}

#input {
    margin: 5px;
    border-radius: 0px;
    border: none;
    border-bottom: 3px;
    background-color: #31363b;

Justinzobel

Matrix Synapse server error: Found users in database not native to my.domain!

1. Backup instance/database
2. Connect to your PostgreSQL database and remove users in the user_directory table that don't match your domain e.g: delete FROM user_directory WHERE user_id NOT LIKE '%chat.my.domain%';

Justinzobel

Discourse Maintenance Page with Apache2

As root

cd /var/discourse
nano containers/app.yml

Comment out these lines:

Justinzobel

Thunderbird 115 introduced a new look. I hate it. Not only does it no longer fit in with KDE Plasma, it lost functionality due to it's new integrated search bar in the title bar.

So I went on a mission to fix it.

To restore the regular title bar:

Go into Settings > General > Language & Appereance and uncheck the Hide system window titlebar

To remove search bar:

Justinzobel

Level	Action	MySQL	PostgreSQL	SQLite
General	Exit	quit	\quit	.quit
Database	List Databases	show databases;	\l	.databases
Database	Create Database		CREATE DATABASE db_name;
Database	Connect to a Database	use db_name;	\c db_name
Table	List Tables	show tables;	\dt	.table
Table	Describe Table Columns	describe table_name;	\d table_name	.schema table_name
Processses	Show Process List	show processlist;
Read Data	Show All Data	select * from table_name;		select * from table_name;

Justinzobel

4 is the number of commits you want to squash

git rebase -i origin/master~4 branch_name

This will open your edit, replace the pick with squash on the commits you want to squash into the main commit.

The editor will open again and you need to comment out all commit messages that you don't want.

git push -f git push origin +branch_name

Justinzobel

-screen-width 2560 -screen-height 1440 -screen-fullscreen 1

Justinzobel

echo wayland > ~/.config/steamos-session-type

Then reboot.