Skip to content

Instantly share code, notes, and snippets.

View bonesoul's full-sized avatar
🎯
Focusing wowtrack.gg

Hüseyin Uslu bonesoul

🎯
Focusing wowtrack.gg
269 followers · 45 following
View GitHub Profile
@bonesoul
bonesoul / keybase.md
Created October 29, 2019 08:36

Keybase proof

I hereby claim:

  • I am bonesoul on github.
  • I am bonesoul (https://keybase.io/bonesoul) on keybase.
  • I have a public key ASBqoX-2UnLGJxxHpSzCLw_DK6jTeIJ2CQoFJLgobvDqvgo

To claim this, I am signing this object:

@bonesoul
bonesoul / gist:bd07e271c9169032e4df7d6beeff35b2
Created June 21, 2018 11:21
game stats
This file has been truncated, but you can view the full file.
{
"_id" : ObjectId("5b2174ad0144acd7dc4e3e1a"),
"game" : "5b2174ad0d58710f40d018bc",
"year" : NumberInt(2018),
"__v" : NumberInt(0),
"createdAt" : ISODate("2018-06-13T19:46:53.105+0000"),
"months" : {
"6" : {
"epoch" : NumberInt(1527800400),
"days" : {
@bonesoul
bonesoul / gist:ae01decd040bace6b942
Created September 17, 2014 23:55
Daemon RPC timeout fixes
@bonesoul
bonesoul / gist:8127858
Created December 25, 2013 23:26
stratum max connections fix
echo "net.ipv4.ip_local_port_range = 20000 65535" >> /etc/sysctl.conf && echo 20000 65535 > /proc/sys/net/ipv4/ip_local_port_range && echo "net.ipv4.tcp_tw_reuse = 1" >> /etc/sysctl.conf && echo "net.core.somaxconn=1638400" >> /etc/sysctl.conf && sysctl -p /etc/sysctl.conf
@bonesoul
bonesoul / backup-db-to-git.sh
Last active March 24, 2022 15:56
MySQL Database to Git Backup Script
#!/bin/sh
cd /var/www/YOURSITE.ORG
date=`date +"%b-%d-%y-%H-%M-%S"`
mysqldump -h SERVER_IP -u root -pPASSWORD --skip-extended-insert --skip-dump-date --databases DBNAME > db-backups/YOURSITE.ORG.sql
git add -A
git commit -m "Site backups for $date"
git push
git gc
@bonesoul
bonesoul / fetch-avatars.pl
Created October 11, 2013 10:33
Gource samples
#fetch Gravatars
use strict;
use warnings;
use LWP::Simple;
use Digest::MD5 qw(md5_hex);
use Thread::Pool::Simple;
my $size = 90;
@bonesoul
bonesoul / fix-urls.sql
Created October 11, 2013 10:18
Fix url's in a sql database;
UPDATE wp_posts SET post_content=REPLACE(post_content, 'old-url', 'new-url')