mrLexx’s gists

mrLexx / CodeLineNumber

Created February 6, 2014 02:07

Код с номерами строк. 1. Номера могут начинаться с какого угодно числа, могут разрываться, могут быть не числами (например, ... для обозначения того, что часть кода не приводится). 2. Номера не должны копироваться. 3. Длинные строки должны переноситься.

	<style type="text/css">
	.code {
	font-family: Consolas, "Liberation Mono", Courier, monospace;
	border-collapse: collapse;
	line-height: 18px;
	font-size: 13px;
	}

	.code th {
	color: #333;

mrLexx / Vagrantfile

Last active March 8, 2017 16:03

PuPHPet Integration with hostsupdater

	Vagrant.configure("2") do \|config\|

	## Begin vagrant-hostsupdater
	## https://github.com/cogitatio/vagrant-hostsupdater
	## vagrant plugin install vagrant-hostsupdater
	if Vagrant.has_plugin?("vagrant-hostsupdater") && configValues['apache']['install'] == '1'
	config.hostsupdater.remove_on_suspend = true
	config.hostsupdater.aliases = Array.new

	configValues['apache']['vhosts'].each do \|i, host\|

mrLexx / rotate_array.php

Created April 29, 2014 23:46

PHP: Rotate array

	<?php
	$keys = array_keys($arr);
	$val = $arr[$keys[0]];
	unset($arr[$keys[0]]);
	$arr[$keys[0]] = $val;

mrLexx / patch-edid.rb

Last active August 29, 2015 14:21 — forked from adaugherity/patch-edid.rb

	#!/usr/bin/ruby
	# Create display override file to force Mac OS X to use RGB mode for Display
	# see http://embdev.net/topic/284710

	require 'base64'

	data=`ioreg -l -d0 -w 0 -r -c AppleDisplay`

	edids=data.scan(/IODisplayEDID.*?<([a-z0-9]+)>/i).flatten
	vendorids=data.scan(/DisplayVendorID.*?([0-9]+)/i).flatten

mrLexx / bot_detect.php

Created November 13, 2019 06:15

обнаружение ботов

	<?php
	//http://qaru.site/questions/60076/how-to-detect-search-engine-bots-with-php

	if (preg_match('/bot\|crawl\|curl\|dataprovider\|search\|get\|spider\|find\|java\|majesticsEO\|google\|yahoo\|teoma\|contaxe\|yandex\|libwww-perl\|facebookexternalhit/i', $_SERVER['HTTP_USER_AGENT'])) {
	// is bot
	}

	if (preg_match('/apple\|baidu\|bingbot\|facebookexternalhit\|googlebot\|-google\|ia_archiver\|msnbot\|naverbot\|pingdom\|seznambot\|slurp\|teoma\|twitter\|yandex\|yeti/i', $_SERVER['HTTP_USER_AGENT'])) {
	// allowed bot
	}

mrLexx / detectSearchBot.md

Created December 10, 2019 00:11 — forked from worka/detectSearchBot.md

Detect google and yandex search bots (crawl, spider)

function detectSearchBot($ip, $agent, &$hostname)
{
    $hostname = $ip;

    // check HTTP_USER_AGENT what not to touch gethostbyaddr in vain
    if (preg_match('/(?:google|yandex)bot/iu', $agent)) {
 // success - return host, fail - return ip or false

mrLexx / first_last_day.sql

Created April 16, 2020 11:06

First and Last day of month on mysql

select DATE_FORMAT(now(),'%Y-%m-01'),LAST_DAY(now());

mrLexx / mysql_gen_pass.sql

Last active June 4, 2020 01:01

Generate a random string in MySQL

	SELECT SUBSTRING(REPLACE(REPLACE(REPLACE( TO_BASE64(MD5(RAND())), '=',''),'+',''),'/',''), 2, 8);
	SELECT SUBSTRING(REPLACE(REPLACE(REPLACE( TO_BASE64(MD5(RAND())), '=',''),'+',''),'/',''), 2, FLOOR(10+RAND()*31));

mrLexx / git_update.sh

Created April 15, 2021 06:18

git update

	sudo add-apt-repository ppa:git-core/ppa -y
	sudo apt-get update
	sudo apt-get install git -y
	git --version

mrLexx / python_install.mb

Last active May 18, 2022 09:21

	= Install prython 3.10
	https://computingforgeeks.com/how-to-install-python-on-ubuntu-linux-system/

	sudo apt update && sudo apt upgrade -y
	sudo apt install software-properties-common -y
	sudo add-apt-repository ppa:deadsnakes/ppa
	sudo apt install python3.10

	= install pip for p 3.10

Valery mrLexx

Detect google and yandex search bots (crawl, spider)