Mesut Dönmez mesutd0nmez

mesutd0nmez / info.sql

Created September 18, 2017 10:38

Tablo Adları, Toplam Satır gibi özellikleri sunan sql


	SELECT
	t.NAME AS TableName,
	i.name as indexName,
	p.[Rows],
	sum(a.total_pages) as TotalPages,
	sum(a.used_pages) as UsedPages,
	sum(a.data_pages) as DataPages,
	(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,
	(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,

mesutd0nmez / Webteizle.txt

Last active October 23, 2017 14:24

Eczane otomasyonu için admin temaları

	https://github.com/Yalantis/FlipViewPager.Draco

	https://github.com/pedrovgs/DraggablePanel

	// Online Ödeme Yöntemi
	https://www.iyzico.com/iyzipos?gclid=Cj0KCQjw9uHOBRDtARIsALtCa95xHJs9pkesNKGIvxNCcZ9rRM85bDvQCkYk2-4b1NLpcqrElcY2DkkaAjpJEALw_wcB

mesutd0nmez / Thumpnail.cs

Created October 3, 2017 15:47

Thumpnail olarak resim kaydetme kodu.

	Image image = Image.FromFile(fileName);
	Image thumb = image.GetThumbnailImage(120, 120, ()=>false, IntPtr.Zero);
	thumb.Save(Path.ChangeExtension(fileName, "thumb"));

mesutd0nmez / jsemailvaid.js

Created November 1, 2017 10:54

Email validation javascript

	function isValidEmailAddress(emailAddress) {
	var pattern = /^([a-z\d!#$%&'+\-\/=?^_`{\|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'+\-\/=?^_`{\|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)\|"((([ \t]\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))(([ \t]\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i;
	return pattern.test(emailAddress);
	};

	if( !isValidEmailAddress( emailaddress ) ) { /* do stuff here */ }

mesutd0nmez / join3table.cs

Created July 17, 2018 11:53