Skip to content

Instantly share code, notes, and snippets.

View LockonZero's full-sized avatar
🎵
d[-_-]b Wub wub wub~~~

Alex Zotos LockonZero

🎵
d[-_-]b Wub wub wub~~~
6 followers · 8 following
View GitHub Profile
@LockonZero
LockonZero / keybase.md
Created October 12, 2020 11:38

Keybase proof

I hereby claim:

  • I am lockonzero on github.
  • I am azotos (https://keybase.io/azotos) on keybase.
  • I have a public key ASCuw-gMvHR66KHUBcfrSu7kXo2v__eDJKZ2K6E5xi4zGQo

To claim this, I am signing this object:

@LockonZero
LockonZero / zypper
Last active December 3, 2019 10:33
WSL SUSE LEAP, things to install with zypper
sudo zypper refresh
# MariaDB, Python AND other dev stuff/utilities
sudo zypper install mariadb-server gcc python3-pip python3-devel screen htop vim-data tmux
sudo zypper addrepo --gpgcheck --refresh https://yum.mariadb.org/10.2/sles/15/x86_64 mariadb
sudo zypper --gpg-auto-import-keys refresh
sudo zypper install MariaDB-server MariaDB-client
sudo zypper update
sudo zypper install mysql-community-devel
# PHP7 STUFF FOR LARAVEL
@LockonZero
LockonZero / my.cnf
Created November 12, 2019 14:11 — forked from fevangelou/my.cnf
Optimized my.cnf configuration for MySQL/MariaSQL (on cPanel/WHM servers)
# Optimized my.cnf configuration for MySQL/MariaSQL
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
#
# === Updated December 2018 ===
#
# The settings provided below are a starting point for a 2GB - 4GB RAM server with 2-4 CPU cores.
# If you have less or more resources available you should adjust accordingly to save CPU,
# RAM and disk I/O usage.
# The settings marked with a specific comment or the word "UPD" after the value
@LockonZero
LockonZero / magento_removeAllCategories.sql
Created April 4, 2016 07:32 — forked from jklance/magento_removeAllCategories.sql
Magento: Remove all categories from a store
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
@LockonZero
LockonZero / gist:cf24c1be2a3803288a4c
Last active October 15, 2015 14:26 — forked from pitch-gist/gist:2999707
HTML: Simple Maintenance Page
<!doctype html>
<title>Site Maintenance</title>
<style>
body { text-align: center; padding: 150px; }
h1 { font-size: 50px; }
body { font: 20px Helvetica, sans-serif; color: #333; }
article { display: block; text-align: left; width: 650px; margin: 0 auto; }
a { color: #dc8100; text-decoration: none; }
a:hover { color: #333; text-decoration: none; }
</style>
@LockonZero
LockonZero / DbmigrateController.php
Last active August 29, 2015 14:15 — forked from bruceoutdoors/DbmigrateController.php
<?php
/* * **
*
* This script converts an existing MySQL database to migrations in Laravel 4.
*
* 1. Place this file inside app/controllers/
*
* 2. In this file, edit the index() method to customize this script to your needs.
* - inside $migrate->ignore(), you pass in an array of table