Skip to content

Instantly share code, notes, and snippets.

@berkayunal
berkayunal / isimler.sql
Created November 25, 2011 04:50 — forked from ismailbaskin/turkce_isimler.sql
isim sözlüğü
CREATE TABLE `isimler` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ad` varchar(255) COLLATE utf8_bin NOT NULL,
`cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ad` (`ad`),
KEY `cinsiyet` (`cinsiyet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@berkayunal
berkayunal / Kredi Kartı BIN Listesi - CSV
Created January 11, 2012 17:16
Kredi Kartı BIN Listesi
bin,banka_kodu,banka_adi,type,sub_type,virtual,prepaid
413226,10,T.C. ZİRAAT BANKASI A.Ş.,VISA,PLATINUM
444676,10,T.C. ZİRAAT BANKASI A.Ş.,VISA,CLASSIC
444677,10,T.C. ZİRAAT BANKASI A.Ş.,VISA,GOLD
444678,10,T.C. ZİRAAT BANKASI A.Ş.,VISA,PLATINUM
453955,10,T.C. ZİRAAT BANKASI A.Ş.,VISA, CLASSIC
453956,10,T.C. ZİRAAT BANKASI A.Ş.,VISA, GOLD
454671,10,T.C. ZİRAAT BANKASI A.Ş.,VISA, CLASSIC
454672,10,T.C. ZİRAAT BANKASI A.Ş.,VISA, CLASSIC
454673,10,T.C. ZİRAAT BANKASI A.Ş.,VISA, BUSINESS
@berkayunal
berkayunal / Alışveriş Kategori Veritabanı
Created February 14, 2012 09:56
Piyasada bulabileceğiniz en geniş ilan, alışveriş kategori veritabanı. Araba,motorsiklet marka, model, alt modellerinden tutun da hizmet ilanı kategorilerine kadar her şey burada tam 36540 kayıt. csv formatında
This file has been truncated, but you can view the full file.
"id","parentID","isim","haschild"
3518,0,"Emlak",1
3613,3518,"Konut",1
16623,3613,"Satılık",1
16633,16623,"Daire",0
152512,16623,"Residence",0
16635,16623,"Müstakil Ev",0
16636,16623,"Villa",0
152456,16623,"Çiftlik Evi",0
@berkayunal
berkayunal / country.php
Created March 21, 2012 13:19
Türkçe Ülke Kodları (ISO 3166-1) Alpha-2
<?php
$lang['country_AF'] = 'Afganistan';
$lang['country_DE'] = 'Almanya';
$lang['country_AD'] = 'Andorra';
$lang['country_AO'] = 'Angola';
$lang['country_AG'] = 'Antigua ve Barbuda';
$lang['country_AR'] = 'Arjantin';
$lang['country_AL'] = 'Arnavutluk';
$lang['country_AW'] = 'Aruba';
$lang['country_AU'] = 'Avustralya';
#!/bin/bash
# Enter the names of the dbs to be backup
# Example: DBONLY=("database1" "cphulkd")
# If you want to backup all
# Example: DBONLY=()
DBONLY=("database1" "cphulkd")
# Enter minutes for file deletetion older than X
# Example 10 Minutes: DELFILESOLDERTHANMIN="10"
#!/usr/bin/env bash
# Original: http://thezinx.com/2013/10/29/create-bootable-dmg-iso-mavericks-app.html
V_BUILD=/Volumes/install_build
V_APP=/Volumes/install_app
T_SI_B=/tmp/mavericks
T_SI=$T_SI_B.sparseimage
@berkayunal
berkayunal / gist:d69ceca597122955cc1e
Last active August 29, 2015 14:24
haproxy acl is not matched sometimes
I have a strange problem, sometimes haproxy cannot match the host so it cannot use the backend and connections is being aborted in the browser.
Do you know any solutions for this kind of problem.
I am using HA-Proxy version 1.5.13 2015/06/23
You can see the problem on http://blog.ganipara.com with firebug or similar.
Here is a screenshot also:
http://berkayunal.com/share/sc_1B4AF7FE.png
Some requests are being dropped since hostname does not matches.
Hey Sean,
Thanks for your help. Appreciate it much
I have a strange problem, sometimes haproxy cannot match the host.
So it cannot use the backend and connections is being aborted in the browser.
Do you know any solutions for this kind of problem.
I am using HA-Proxy version 1.5.14 2015/07/02
@berkayunal
berkayunal / .htaccess
Created August 15, 2016 21:40 — forked from THEtheChad/.htaccess
Access-Control-Allow-Origin for Subdomains
SetEnvIf Origin "^(.*\.example\.com)$" ORIGIN_SUB_DOMAIN=$1
Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN
@berkayunal
berkayunal / warm_varnish
Created October 13, 2016 21:37 — forked from jaseclamp/warm_varnish
Warm Varnish Cache
#!/bin/bash
# this script will
# a. crawl the designated site X levels deep to generate a urls list
# b. completely purge all urls on the desisgnated varnish servers for the designated url
# c. clear cache on nginx / mod pagespeed for the designated app servers
# d. individually warm all the listed urls on each designated varnish server
# e. rewarm them in case pagespeed sent a purge request
# define some variables