Git Count Commits by Date
List of all user commits on a git repo by user between 2 dates. git shortlog -sne --since="01 Jan 2017" --before="01 Jan 2018"
Block IPs by country – Apache
Step 1 If you are using debian or ubuntu, install the mod-geoip package. sudo apt-get install libapache2-mod-geoip Step 2 Enable GeoIPEnable, edit geoip.conf /etc/apache2/mods-enabled/geoip.conf GeoIPEnable On Step 3 Find Country Code Lookup: https://en.wikipedia.org/wiki/ISO_3166-1 In Apache vhosts file, outside of the </Directory> tags: <Location /> ##ISO 3166 Country Codes ## Block China ## Block Costa […]
Count tables MYSQL
Count tables within a DB, nice and easy.. use db_name; select count(*) from information_schema.tables where table_schema = database();
Group data in MySQL every N hours
Group data in MySQL every N hours Using the hour to aggregate.. in this example every 3 hours. select * from tbl_sometable group by floor(hour(time) / 3);
Linux – if anyone logs in notify SSH
Put the following in /etc/profile: The script /etc/profile is executed at every login (for bash shell users). if [ -n "$SSH_CLIENT" ]; then TEXT="$(date): ssh login to ${USER}@$(hostname -f)" TEXT="$TEXT from $(echo $SSH_CLIENT|awk '{print $1}')" echo $TEXT|mail -s "ssh login" you@your.domain aFrom:youradd@email.com fi If you have issues delivering mail to a GMAIL inbox, […]
Add Parameter to URL – JQUERY
Add Parameter to URL – JQUERY function addOrUpdateUrlParam(name, value) { var href = window.location.href; var regex = new RegExp("[&\\?]" + name + "="); if(regex.test(href)) { regex = new RegExp("([&\\?])" + name + "=\\d+"); window.location.href = href.replace(regex, "$1" + name + "=" + value); } else { if(href.indexOf("?") > -1) window.location.href = href + "&" + […]