Articles, reviews, quizzes...

Examples of triggers MySQL

DROP TRIGGER IF EXISTS `update_sms_plus`; CREATE TRIGGER `update_sms_plus` AFTER UPDATE ON `sms_plus` FOR EACH ROW UPDATE sms_plus SET city = NEW.gorod WHERE id=NEW.id; …

More 400 responses to the popular game four pictures one word + update

Совет. Чтобы быстро найти слово по картинке, воспользуйтесь сервисом Google Images Search на ПК. COLD LOUD КРЕСТ ГОРЯЧИЙ СЛАДКИЙ CRUDE BALL YELLOW STRONG МЯГКИЙ SOLID ВЫСОТА КРАСНЫЙ КИСЛЫЙ QUIET СЧАСТЬЕ БЕЛОЕ PAST MORNING БОЛЬШОЙ …

Anagrams of Russian language

Analyzing explanatory dictionary and got a full list of anagrams of the Russian language. More 2800 nouns. Если в этом списке нет вашего слова, можете воспользоваться продвинутым скриптом расшифровки анаграмм на русском и английском Abaza - base Abwehr - willow abortion - the inverse abrek - Bekar аванп…

MTS useful service commands + vCard

Room Name *111# Service menu *152# The cost of recent transactions *100*1# The residue packages *111*271# The residue traffic *111*919# Unsubscribe from newsletters 63-33 Anti-spam SMS 08-80 Call for others *116*79180000000# Recharge my account *110*9…

Batch JPEG compression without quality loss

I'm sure many wondered how quickly and easily compress all images at once. For example, to free up space or website optimization. Even Google Pagespeed recommends compress them such advice: If you compress lossless image ..., this will reduce the size 909 Б (3 %). In this…

Example model of the globe on WebGL

Working example here: Example model of the globe on WebGL So it looks in the browser on android: …

Detector bots in PHP

// detector bots function isBot($ua=null){ if ($ua===null) { if ($_SERVER['HTTP_CONNECTION'] == 'TE, close' || $_SERVER['HTTP_CONNECTION'] == 'close' || $_SERVER['HTTP_CONNECTION'] == 'TE' ) return 1; $ua = strtolower($_SERVER['HTTP_USER_AGENT']); } if (!$ua) return true; $list = array('…

Whois request to PHP

// Whois request to PHP function RipeIPInfo2($ip){ $oSocket = fsockopen("whois.tcinet.ru",43,$sErrorNo, $sErrorMsg); fputs($oSocket,$ip."\r\n"); while(!feof($oSocket)){ $line=trim(fgets($oSocket,128));dbg($line); if ($line[0]=='%' OR !$line) continue; $line=explode(':',$line); $result[$line[…

Executing shell commands with instant output in PHP



Bit operations in MySQL (Work with flags)

#Set flag 0x2: UPDATE `table` SET `flag`=`flag` | (0x2); #Set just a few bits (0x1 и 0x2): UPDATE `table` SET `flag`=`flag` | (0x1|0x2); #To remove the flag 0x2: UPDATE `table` SET `flag`=`flag` &~ (0x2); #Delete several bits (0x1 и 0x2): UPDATE `table` SET `flag`=`flag`…

How to run a script only once, automatically killing up

#!/bin/sh # kill all process with basename, but the current ps aux | grep ./`basename $0` | grep -v $$ | grep -v grep | awk '{ print $2}' | while read LINE; do kill -9 $LINE done …

The way to hack games on Android

1. GameCIH - Artmoney for Android Download GameCIH from the official site Instruction with 4pda: Open GameCIH, you specify the shortcut button, hide (house) Start the game Click the selected button In the window, select the Input Number, input number such as money, which you have now in the game …

Ubuntu + nginx + php + mysql + memcached + eAccelerator

Install and configure Nginx sudo apt-get install nginx sudo vim /etc/nginx/sites-available/default The default server { listen 80; server_name localhost; #access_log /var/log/nginx/localhost.access.log; charset utf-8; rewrite ^/sitemap\.xml$ /sitemap last; rewrite ^/robots\.txt$ …

Automatic delivery to email error_log

Wrote a simple shell script, which is like the tail-f command in real time monitors the error log and sends changes to mail. To protect against spam, the script will not send more than one letter per minute. #!/bin/sh tail -f -n0 /var/log/php5-fpm.log | grep PHP | while read LINE; do SEND_BUF="$S…

Maximum acceleration Firefox

Here are all the settings for maximum acceleration Firefox. Вы можете пронести их вручную в about:config или автоматически создав файл user.js in your profile: c:\Users\Ваш_пользователь\AppData\Roaming\Mozilla\Firefox\Profiles\Nabor_simvolov\ Файл: c:\Users\Ваш_пользователь\AppData\Roa…

Calculate the age of the person by the date of birth (php)

date_default_timezone_set('America/Los_Angeles'); function calculateAge($birthday){ return floor((time() - strtotime($birthday))/31556926); } //USAGE EXAMPLES echo calculateAge('1978-07-11'); echo calculateAge('7/11/1978'); echo calculateAge('7/11/78'); echo calculateAge('July 11, 1978'); And here…

Yandex translate API

An example of using Yandex translate API: function translate(text, sl, tl, success){ $.ajax({ url: 'http://translate.yandex.ru/tr.json/translate?srv=tr-text&id=812c6278-0-0&reason=auto', dataType: 'jsonp', data: { text: text, // text to translate lang: sl+'-'+tl },success: function(result) …

Configuring Windows XP for maximum performance

Вредные советы) For the sake of interest empirically established the required minimum services in Windows: DHCP Клиент Plug and Play Wireless setup Accounts Manager security (будет работать и без нее) The event log (система работает, wifi не загружается) Запуск серверных процессо…

Integrated functional MySQL

In MySQL has enough built-in functions and features that simplify the code. Unfortunately, not all programmers are aware of this and use their «Bicycles». ON DUPLICATE KEY UPDATE For example, there is a table with some objects (users , posts , etc.д.). If this object with such-and-such University…

iPhone removal of hidden pics

Sometimes a glitch happens on the iPhone. Memory is full , photos, can be seen in settings -> genegal -> usage, but they do not exist in the application of any aytyunse. Причина: The fact that a change in the pictures / PhotoData / Metadata / edited copy photos stored. And when you delete photos from third-party programs,…

Update Denver to php 5.5.9. Short manual..

1. Скачать PHP http://phpdev.toolsforresearch.com/php-5.5.9-Win32-VC11-x86.zip and raspakovatj in C:\WebServers\usr\local\php5 2. PROFIT!!! Everything should work fine. Naturally this should be done on off Denver. …

Outline plan of a New 2015 year and celebrating Christmas , the festival «Best winter city»

Name and form events Date and time Venue Responsible organizations in t.ч. body (or bodies of) executive power Main activities Great winter skating rink on the red square 1 декабря 2011 – 3 March 2012 Red square ОАО «GUM TRADING HOUSE» Meeting D…

Increase productivity HTML5 Application

Library: https://github.com/ftlabs/fastclick - removes the delay 300MS in mobile browsers http://greensock.com/jquery-gsap-plugin - jQuery plugin to increase productivity jQuery.animate() For tests in 20 times faster than the native jQuery.animate(). Article: http://www.stubbornella.org…

logo

An example of how to develop a logo in the style of iOS for 15 minutes right in the browser. Press F12. Edit styles. Click on the logo to save the picture. S ` …

Benchmarks. PHP-FPM + OPcache vs HipHop vs Si vs kPHP

Configuration: Intel Dual Core 1.60GHz, 8Gg RAM PHP-FPM (PHP 5.5.3) + OPcache HipHop VM 2.4.0 (rel) As a web north acted nginx/1.4.1 (Ubuntu) Counting million decimal of Pi Was equivalent code written in php and C to calculate the number Pi million mark by the formula Bailey — Barua…