vigikaran

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

vigikaran

Sort object properties by value (values are text)

I have following object:

var cities={10:'Tashkent', 14:'Karakalpakiya', 16:'Andijan'};

I want sort it by city names, so after sort it should be:

var cities={16:'Andijan', 14:'Karakalpakiya', 10:'Tashkent'};

But I can't sort object properties, instead can convert object into array, then sort items.

vigikaran

// MySQL to Google Spreadsheet By Pradeep Bheron
// Support and contact at pradeepbheron.com

function myMySQLFetchData() { 
  
  var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials

  var stmt = conn.createStatement();
  var start = new Date(); // Get script starting time
  

vigikaran

#!/usr/bin/env bash

#
# Sync Amason S3 Bucket with Akamai NetStorage
#
# Dependency:
#     "aws" command : AWS CLI
#     "rsync" command :yeah, the one.
#     .aws/credentials : AWS Credential file (for aws command)
#     .ssj/netstorage.ppk : Private Key for your NetStorage account

vigikaran

Install PHP 5.6 On linux (Debian, Ubuntu, Mint ...)

sudo apt-get install python-software-properties
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install -y php5.6

heck Installed PHP Version

php -v

vigikaran

vigikaran

Simple Stream

ffmpeg -i rtmp://server.ip/application/streamname -c copy -f flv rtmp://server.ip/application/streamname

Copy to FLV

ffmpeg -i %1 -c copy -copyts %1.flv

Copy 5 minutes to MP4

ffmpeg -i %1 -t 00:05:00 -c copy -copyts %1.mp4

Encode to MP4 at 8k bitrate, veryfast preset and film tuning, AAC Audio

vigikaran

#! /usr/bin/env bash

# Install any build dependencies needed for curl
sudo apt-get build-dep curl

# Get latest (as of Feb 25, 2016) libcurl
mkdir ~/curl
cd ~/curl
wget http://curl.haxx.se/download/curl-7.50.2.tar.bz2
tar -xvjf curl-7.50.2.tar.bz2

vigikaran

########## Install NGINX ##############

# Install software-properties-common package to give us add-apt-repository package
sudo apt-get install -y software-properties-common

# Install latest nginx version from community maintained ppa
sudo add-apt-repository ppa:nginx/stable

# Update packages after adding ppa

vigikaran

Add a new user to the www-data group

In this example, add a new user called vivek to the www-data group, enter:

 
sudo useradd -g www-data vivek
 
### set the password for vivek user ###
sudo passwd vivek