Gabriel Kanev MrGKanev

🌐

Deploying something new every day!

andrasbacsai / firewall.sh

Last active April 19, 2025 14:31

Update a Hetzner Firewall rule with your IP address

	#!/bin/bash
	# Script to update a firewall rule in a Hetzner Firewall with your current IP address.
	# Good if you would like to restrict SSH access only for your current IP address (secure).

	#################
	# WARNING: This script will overwrite all rules in the firewall rules, so make sure you
	# added all the required rules.
	# I use a separate firewall rule just for SSH access.
	#################

sawirricardo / laravel-command-package.txt

Last active October 18, 2024 23:11

Laravel almost must use commands and packages

	php artisan storage:link;
	php artisan make:notifications-table

	composer require laravel/horizon laravel/folio \
	livewire/volt \
	tpetry/laravel-postgresql-enhanced \
	spatie/laravel-tags spatie/laravel-sluggable \
	spatie/laravel-medialibrary spatie/laravel-activitylog \
	wnx/laravel-backup-restore \
	spatie/laravel-model-info spatie/laravel-sql-commenter \

saaiful / sendy.conf

Created May 3, 2019 12:44

Nginx configuration file example for Sendy (http://sendy.co/).

	server {
	listen ip:port;
	server_name domain.name;
	root root_folder;
	index index.php index.html index.htm;

	location / {
	location = / {
	try_files $uri $uri/ /index.php?$query_string;
	}

amanjuman / Install Sendy on LAMP with No Error

Last active May 16, 2024 05:27

Install Sendy on LAMP with No Error

	## Update and Upgrade Repos
	sudo su
	sudo apt update -y && sudo apt upgrade -y && sudo apt dist-upgrade -y && sudo apt autoremove -y

	## Setup SWAP
	sudo /bin/dd if=/dev/zero of=/var/swap.1 bs=1M count=1024
	sudo /sbin/mkswap /var/swap.1
	sudo /sbin/swapon /var/swap.1
	sudo sh -c 'echo "/var/swap.1 swap swap defaults 0 0 " >> /etc/fstab'

nasrulhazim / 01.md

Last active March 4, 2025 23:55

Laravel Default API Login

Setup

Create new migration script:

php artisan make:migration add_api_token --table=users

yanknudtskov / woocommerce-duplicate-skus.sql

Last active July 9, 2024 03:28

Select Duplicate SKUs from WooCommerce Database #woocommerce #mysql

	# SELECT any post_status
	SELECT meta_value,COUNT(meta_value),GROUP_CONCAT(DISTINCT post_id ORDER BY post_id SEPARATOR ',') post_id
	FROM wp_postmeta
	WHERE meta_key = '_sku'
	AND meta_value != ''
	GROUP BY meta_value HAVING COUNT(meta_value) > 1

	# SELECT only from products that are already published or in draft
	SELECT meta_value,COUNT(meta_value),GROUP_CONCAT(DISTINCT post_id ORDER BY post_id SEPARATOR ',') post_id
	FROM wp_postmeta

refringe / sendy-server

Last active August 11, 2025 14:38

Nginx configuration file example for Sendy (http://sendy.co/).

	server {
	listen 80;
	listen [::]:80;

	server_name domain.com;

	autoindex off;
	index index.php index.html;

	root /srv/www/domain.com/public;