Skip to content

Instantly share code, notes, and snippets.

View trevoro's full-sized avatar

Trevor O trevoro

View GitHub Profile
@trevoro
trevoro / all_wordpress_multisite_plugins.sql
Last active February 2, 2019 19:55
Get all plugins for wordpress multi-site installations
DELIMITER //
DROP PROCEDURE IF EXISTS site_plugins//
CREATE PROCEDURE site_plugins()
BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
DECLARE option_val varchar(256);
DECLARE name_table varchar(256);
DECLARE cur_tables CURSOR FOR SELECT TABLE_NAME from information_schema.tables where TABLE_NAME like 'wp_%_options';
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
@trevoro
trevoro / keybase.md
Created March 30, 2020 22:49
keybase.md

Keybase proof

I hereby claim:

  • I am trevoro on github.
  • I am trevoro (https://keybase.io/trevoro) on keybase.
  • I have a public key ASDVF96i5TVXYieL0Q3_AP-NrlD-1tNyyah0aReoKZ3BGwo

To claim this, I am signing this object: