yahyaerturan’s gists

yahyaerturan / tr_countries.sql

Last active March 11, 2022 09:57

Türkçe Ülkeler MySQL Tablosu

	CREATE TABLE IF NOT EXISTS `countries_list` (
	`id_country` tinyint(3) unsigned NOT NULL auto_increment,
	`country_name` varchar(30) collate utf8_unicode_ci NOT NULL,
	PRIMARY KEY (`id_country`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=207 ;

	--
	-- Dumping data for table `countries_list`
	--

yahyaerturan / js_cities_and_districts_tr.js

Created August 18, 2013 08:35

Javascript ile İl ve İlçeler

	/*
	* İl : 81
	* İlçe : 957
	*
	* */
	var city = new Array('Adana', 'Adıyaman', 'Afyonkarahisar', 'Ağrı', 'Amasya', 'Ankara', 'Antalya', 'Artvin', 'Aydın', 'Balıkesir', 'Bilecik', 'Bingöl', 'Bitlis', 'Bolu', 'Burdur', 'Bursa', 'Çanakkale', 'Çankırı', 'Çorum', 'Denizli', 'Diyarbakır', 'Edirne', 'Elazığ', 'Erzincan', 'Erzurum', 'Eskişehir', 'Gaziantep', 'Giresun', 'Gümüşhane', 'Hakkâri', 'Hatay', 'Isparta', 'Mersin', 'İstanbul', 'İzmir', 'Kars', 'Kastamonu', 'Kayseri', 'Kırklareli', 'Kırşehir', 'Kocaeli', 'Konya', 'Kütahya', 'Malatya', 'Manisa', 'Kahramanmaraş', 'Mardin', 'Muğla', 'Muş', 'Nevşehir', 'Niğde', 'Ordu', 'Rize', 'Sakarya', 'Samsun', 'Siirt', 'Sinop', 'Sivas', 'Tekirdağ', 'Tokat', 'Trabzon', 'Tunceli', 'Şanlıurfa', 'Uşak', 'Van', 'Yozgat', 'Zonguldak', 'Aksaray', 'Bayburt', 'Karaman', 'Kırıkkale', 'Batman', 'Şırnak', 'Bartın', 'Ardahan', 'Iğdır', 'Yalova', 'Karabük', 'Kilis', 'Osmaniye', 'Düzce');
	var phone_code = new Array('0322', '0416', '0272', '0472', '0358', '0312', '0242', '0

yahyaerturan / Bootstrap-3_Carousel-Collection

Created April 27, 2014 12:36 — forked from loschke/Bootstrap-3_Carousel-Collection

	Bootstrap 3 - Carousel/Slider Collection

	Article: http://sevenx.de/blog
	Demo: http://sevenx.de/demo/bootstrap-carousel

	Working Examples (inline Styles, CDN Scripts)

	- minimal Bootstrap Markup changes
	- minimal CSS Styles
	- minimal jQuery

yahyaerturan / bootstrap-compiled.css

Last active August 29, 2015 14:08

Narrower Bootstrap 3.2.0

	/*!
	* Bootstrap v3.2.0 (http://getbootstrap.com)
	* Compiled by Yahya ERTURAN @ 2014-10-28 09:45:00
	* Copyright 2011-2014 Twitter, Inc.
	* Licensed under MIT (https://github.com/twbs/bootstrap/blob/master/LICENSE)
	*/
	/! normalize.css v3.0.1 \| MIT License \| git.io/normalize /html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}article,aside,details,figcaption,figure,footer,header,hgroup,main,nav,section,summary{display:block}audio,canvas,progress,video{display:inline-block;vertical-align:baseline}audio:not([controls]){display:none;height:0}[hidden],template{display:none}a{background:transparent}a:active,a:hover{outline:0}abbr[title]{border-bottom:1px dotted}b,strong{font-weight:bold}dfn{font-style:italic}h1{font-size:2em;margin:.67em 0}mark{background:#ff0;color:#000}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sup{top:-0.5em}sub{bottom:-0.25em}img{border:0}svg:not(:root){overflow:hidden}figure{margin:1em 40p

yahyaerturan / ubuntu_terminal_style_debug_helper.php

Created March 20, 2015 14:53

Ubuntu Terminal Styled Debug Helper (CI)

	if(!function_exists('terminal')) {
	function terminal($var,$die=TRUE){
	$CI = &get_instance();
	$CI->load->library('unit_test');

	$bt = debug_backtrace();
	$src = file($bt[0]["file"]);
	$line = $src[$bt[0]['line'] - 1];
	# Match the function call and the last closing bracket
	preg_match('#' . __FUNCTION__ . '$(.+)$#', $line, $match);

yahyaerturan / istoc_gold

Last active August 29, 2015 14:22

Ajansbu İSTOÇ Üyelik Yenileme

	<?php

	function reformat_datetime ($datetime=null , $target_format = 'Y-m-d H:i:s') {
	if($datetime) {
	$date = new DateTime($datetime, new DateTimeZone('Europe/Istanbul'));
	if($target_format == 'datetime') return $date->format('Y-m-d H:i:s');
	else if ($target_format == 'date_tr') return $date->format('d.m.Y');
	else if ($target_format == 'time_tr') return $date->format('H:i:s');
	else if ($target_format == 'datetime_tr') return $date->format('d.m.Y H:i:s');
	else if ($target_format == 'timestamp') return $date->getTimestamp();

yahyaerturan / index.html

Created November 12, 2016 19:35

Centered Vayes Logo for empty hosts

	<!doctype html>

	<html lang="tr">
	<head>
	<meta charset="utf-8">

	<title>Vayes Web Yazılım</title>
	<meta name="description" content="Vayes Web Yazılım - Web Tasarım">
	<meta name="author" content="Vayes">

yahyaerturan / sublime-settings

Created January 10, 2017 09:27

Sublime Settings

	{
	"auto_find_in_selection": true,
	"color_scheme": "Packages/Theme - itg.flat/itg.dark.tmTheme",
	"default_line_ending": "unix",
	"ensure_newline_at_eof_on_save": true,
	"font_face": "Monaco",
	"font_size": 12,
	"highlight_line": true,
	"highlight_modified_tabs": true,
	"ignored_packages":

yahyaerturan / .bashrc

Created January 10, 2017 12:50

Ubuntu .bashrc

	# Added by Yahya ERTURAN
	export PATH=$PATH:$HOME/bin

	# Added by Yahya ERTURAN for NodeJS & NPM
	export PATH=$HOME/.npm-global/bin:$PATH

yahyaerturan / seed.php

Last active March 13, 2017 20:29

CI3 Fake Date Dumper with Intervals

	<?php

	# Creates an array first with given numbers
	# Dumps it to db with 250 records/insert intervals
	# You may need to adjust your php settings:
	# ini_set('memory_limit', '1024M');
	# ini_set('max_execution_time', 300); //300 seconds = 5 minutes

	/**
	* Users Seeds

Yahya Erturan yahyaerturan