Skip to content

Instantly share code, notes, and snippets.

View halityurttas's full-sized avatar

Halit YURTTAŞ halityurttas

27 followers · 14 following
View GitHub Profile
@halityurttas
halityurttas / twitterapi.php
Created September 7, 2015 13:58
Twitter api parsing in php
<?php
require_once('TwitterAPIExchange.php');
$settings = array(
'oauth_access_token' => "",
'oauth_access_token_secret' => "",
'consumer_key' => "",
'consumer_secret' => ""
);
$url = 'https://api.twitter.com/1.1/statuses/user_timeline.json';
$getfield = '?screen_name=gorunen_ad';
@halityurttas
halityurttas / removeduplicate.sql
Created September 15, 2015 07:06
T-SQL Delete Duplicate Rows
WITH CTE AS(
SELECT [col1], [col2], [col3], [col4], [col5], [col6], [col7],
RN = ROW_NUMBER()OVER(PARTITION BY col1 ORDER BY col1)
FROM dbo.Table1
)
DELETE FROM CTE WHERE RN > 1
@halityurttas
halityurttas / updatejoin
Created September 16, 2015 13:15
Update table with join
UPDATE t1
SET t1.CalculatedColumn = t2.[Calculated Column]
FROM dbo.Table1 AS t1
INNER JOIN dbo.Table2 AS t2
ON t1.CommonField = t2.[Common Field]
WHERE t1.BatchNo = '110';
@halityurttas
halityurttas / DatetimeBinder.cs
Last active October 22, 2015 15:46
ASP.Net MVC de türkçe tarih okumak
public class DatetimeBinder: IModelBinder
{
public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
string data = "";
if (controllerContext.Controller.ValidateRequest && bindingContext.ModelMetadata.RequestValidationEnabled)
{
data = controllerContext.HttpContext.Request.Params[bindingContext.ModelName];
}
else
@halityurttas
halityurttas / mysqlbackup.bat
Created April 8, 2016 12:37
Windows ortamında mysql full yedekleme
@ECHO OFF
Rem -- dizinler örnektir lütfen kendi mysql dizininizi belirtin burada wamp için örnekleme yaptım. Bu noktaya dikkat
C:\wamp\bin\mysql\mysql5.6.17\bin\mysqldump -u root --all-databases > "C:\mysqlbackups\tmp\alldb.sql"
Rem -- 7z indirip 7z.exe 7z.dll 7z-zip.dll 7z-zip32.dll yi de bu klasöre atın. ayrıca klasöre tmp adında bir klasör açmayı unutmayın
Rem -- ilk dizin adresi kaydedilecek yer ikincisi yukarıda dump sql i aktardığımız dosya adresi
7z a -tzip "C:\mysqlbackups\dest\mysql_alldatabase_%DATE:~7,2%.%DATE:~4,2%.%DATE:~-4%_backup.zip" "C:\mysqlbackups\tmp\*.*" -mx5
Rem -- forfiles ile -d 3 yaparak 3 gün öncesinde ki dosyaları bulmuş oluyoruz bununla 3 gün öncesinde ki yedekleri sileceğiz kendinize göre ayarlayabilirsiniz
forfiles -p "C:\mysqlbackups\dest" -s -m *.* -d 3 -c "cmd /c del @path"
@halityurttas
halityurttas / dynamicmap.js
Created April 10, 2016 23:47
//iframe ile eklenen map ın style özelliğine pointer-events:none eklemeyi unutmayın
$(function() {
$('.map-container').click(function(e) {
$(this).find('iframe').css('pointer-events', 'all');
}).mouseleave(function(e) {
$(this).find('iframe').css('pointer-events', 'none');
});
});
@halityurttas
halityurttas / HashflareProfit.cs
Last active March 13, 2018 00:41
Hashflare profit calculator with reinvestment
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using Newtonsoft.Json;
//if you want to run online copy/paste https://dotnetfiddle.net/
public class Program
{
@halityurttas
halityurttas / MinergateBTCProfit.cs
Last active March 13, 2018 00:55
Minergate BTC profit with reinvestment
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using Newtonsoft.Json;
//if you want to run online copy/paste https://dotnetfiddle.net
public class Program
{
@halityurttas
halityurttas / freebtcmine.com.userscript.js
Created March 13, 2018 15:39
Free BTC Mine Game timer to title freebtcmine.com
// ==UserScript==
// @name Unnamed Script 323435
// @version 1
// @grant none
// @include http://freebtcmine.com/
// @require http://code.jquery.com/jquery-2.2.4.min.js
// ==/UserScript==
$(document).ready(function () {
window.claimInterval = setInterval(function () {
@halityurttas
halityurttas / sunbtc-space.userscript.js
Created March 16, 2018 12:00
Sunbtc.Space claim timer to title
// ==UserScript==
// @name Unnamed Script 640112
// @version 1
// @grant none
// @include http://sunbtc.space/
// @require http://code.jquery.com/jquery-2.2.4.min.js
// ==/UserScript==
$(document).ready(function () {
window.claimInterval = setInterval(function () {