Skip to content

Instantly share code, notes, and snippets.

View hosseinm1997's full-sized avatar

Hossein Moshfegh hosseinm1997

7 followers · 7 following
  • Iran
View GitHub Profile
@hosseinm1997
hosseinm1997 / iran-subnets
Created October 11, 2022 08:24
Iran IP subnet/CIDR
103.130.144.0/24
103.130.146.0/24
103.215.220.0/22
103.216.60.0/22
103.231.136.0/22
109.107.131.0/24
109.108.160.0/19
109.109.32.0/19
109.110.160.0/19
109.122.193.0/24
@hosseinm1997
hosseinm1997 / .gitlab-ci.yml
Last active November 18, 2021 12:39
Gitlab simple auto devops. Add both files into your project repository and customize according to your need.
image: alpine:latest
pages:
only:
- master
stage: deploy
before_script:
- 'command -v ssh-agent >/dev/null || ( apk add --update openssh )'
- eval $(ssh-agent -s)
- echo "$SSH_PRIVATE_KEY" | tr -d '\r' | ssh-add -
@hosseinm1997
hosseinm1997 / noUiSlider example.js
Created April 7, 2020 16:25
<script>
function RefundCtrl() {
var self = this;
var vendorDeliveryFaultSlider;
var max;
var invoiceItemId;
@hosseinm1997
hosseinm1997 / log changes trigger.sql
Last active March 22, 2020 07:37
create table laravel._keep_changes
(
id serial not null
constraint _keep_changes_pk
primary key,
operation char not null,
transaction_id integer,
changes text,
created_at timestamp(0) not null,
current_database_user varchar,
@hosseinm1997
hosseinm1997 / ad-killder.sh
Created January 29, 2019 07:55
#!/bin/bash
was_paused=0 # if last state was paused
ad=0 # if an ad is probably playing right now
while true; do
num=$(pactl list | grep -E '(^Sink Input)|(media.name = \"Spotify\"$)' | awk '/Spotify/ {print a} {a = $0}' | cut -c 13-)
icon_name=$(xprop -name 'spotify' _NET_WM_ICON_NAME | cut -d \" -f 2)
song_name=$(dbus-send --print-reply --session --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.freedesktop.DBus.Properties.Get string:'org.mpris.MediaPlayer2.Player' string:'Metadata' | grep xesam:title -A 1 | grep variant | cut -d \" -f 2)
@hosseinm1997
hosseinm1997 / money format function.sql
Created November 17, 2018 12:44
Postgresql 3 digit or money seperator function
CREATE or replace FUNCTION money_format(amount int)
RETURNS text AS $$
BEGIN
return trim(to_char(amount, '999,999,999,999,999,999,999,999,999,999'));
END;
$$
LANGUAGE plpgsql;
CREATE or replace FUNCTION money_format(amount bigint)
RETURNS text AS $$
@hosseinm1997
hosseinm1997 / persian_name _validation.php
Last active April 8, 2019 14:29
اعتبار سنجی دقیق نام های ایرانی با کارکتر های فارسی بوسیله عبارات منظم _ Iranian names with only Farsi/Persian character validation with regular expression.
<?php
$fname = 'حسین';
if (!preg_match('/^([\x{0621}-\x{063A}\x{0641}-\x{064A}\x{064E}-\x{0651}\x{0654}-\x{0655}\x{06A9}\x{06CC}\x{FB8A}\x{067E}\x{0686}\x{06AF}\x{0698}\x{0670}\x{200c}\x{06c1}\x{06c2} ])+$/u', $fname))
{
echo "نام معتبر نیست!";
}
$fname = 'hossein';
if (!preg_match('/^([\x{0621}-\x{063A}\x{0641}-\x{064A}\x{064E}-\x{0651}\x{0654}-\x{0655}\x{06A9}\x{06CC}\x{FB8A}\x{067E}\x{0686}\x{06AF}\x{0698}\x{0670}\x{200c}\x{06c1}\x{06c2} ])+$/u', $fname))
{
@hosseinm1997
hosseinm1997 / mssql_benchmark.sql
Last active October 10, 2017 16:51
Create huge number of data into a sample table for benchmarking
USE [master]
GO
declare @dbname nvarchar(20)
set @dbname = 'HM_benchmark' -- => set db name here <= --
IF OBJECT_ID('tempdb.dbo.#vars', 'U') IS NOT NULL
DROP TABLE #vars;
create table #vars (dbname varchar(20), create_script nvarchar(80),use_script nvarchar(80))
insert #vars values (@dbname,'Create DATABASE ' + @dbname,'USE [' + @dbname + ']')
@hosseinm1997
hosseinm1997 / laravel5_nginx_virtualhost_php7.1.conf
Last active October 10, 2017 16:54
Nginx server block (virtual host) for laravel 5.* and php 7.1
server {
listen 80;
server_name mylaravelproj.me www.mylaravelproj.me;
root /var/www/mylaravelproj.me/public;
index index.html index.php index.htm;
location / {
try_files $uri $uri/ /index.php?$query_string;
}
@hosseinm1997
hosseinm1997 / change_all_collations.sql
Last active September 26, 2017 05:35
Procedure to convert string based fields collations and character sets to any.
# ===========> Start copying <=============#
DELIMITER //
CREATE PROCEDURE changeAllCollations(
db_name VARCHAR(100),
char_set VARCHAR(25),
collation_name VARCHAR(50),
prevent_key_too_long Boolean
)
BEGIN