Trần Nhật Duy duydev

## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

## auto.js
function trigger() {
  var keyboardEvent = document.createEvent('KeyboardEvent');
  var initMethod =
    typeof keyboardEvent.initKeyboardEvent !== 'undefined'
      ? 'initKeyboardEvent'
      : 'initKeyEvent';

  keyboardEvent[initMethod](
    'keydown', // event type: keydown, keyup, keypress
    true, // bubbles

## script.js
const user_id = document.cookie.split('c_user=')[1].split(';')[0];
const fb_dtsg = document.querySelector("input[name='fb_dtsg']").value;
const data =
    "source=SETTINGS_MENU&nctr%5B_mod%5D=pagelet_bluebar&__user=" + user_id + "&__a=1&fb_dtsg=" + fb_dtsg;

const xhr = new XMLHttpRequest();
xhr.withCredentials = true;

xhr.addEventListener("readystatechange", function() {
    if (this.readyState === 4) {

## mysql-docker.sh
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE


## bash-install_google_fonts_on_ubuntu.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                duydev
                / bash-install_google_fonts_on_ubuntu.md
            
            
              Created
              July 5, 2018 17:44
                — forked from lightonphiri/bash-install_google_fonts_on_ubuntu.md
            
              
                Install Google Fonts on Ubuntu
              
          
    Install Google Fonts

Download desired fonts

https://fonts.google.com/?selection.family=Open+Sans
Install Google Fonts on Ubuntu

cd /usr/share/fonts
sudo mkdir googlefonts
sudo unzip -d . ~/Downloads/Open_Sans.zip
sudo chmod -R --reference=opentype googlefonts

  
## cloudSettings
{"lastUpload":"2019-06-29T18:33:36.500Z","extensionVersion":"v3.3.1"}

## List.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                duydev
                / List.md
            
            
              Created
              January 17, 2017 05:31
                — forked from msurguy/List.md
            
              
                List of open source projects made with Laravel
              
          
    Other people's projects:

https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/

My projects (tutorials are on my blog at http://maxoffsky.com):

https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com


## array_chunk_function.cs
public static IEnumerable<IEnumerable<T>> Split<T>(this T[] array, int size)
{
    for (var i = 0; i < (float)array.Length / size; i++)
    {
        yield return array.Skip(i * size).Take(size);
    }
}
	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
	function trigger() {
	var keyboardEvent = document.createEvent('KeyboardEvent');
	var initMethod =
	typeof keyboardEvent.initKeyboardEvent !== 'undefined'
	? 'initKeyboardEvent'
	: 'initKeyEvent';

	keyboardEvent[initMethod](
	'keydown', // event type: keydown, keyup, keypress
	true, // bubbles
	const user_id = document.cookie.split('c_user=')[1].split(';')[0];
	const fb_dtsg = document.querySelector("input[name='fb_dtsg']").value;
	const data =
	"source=SETTINGS_MENU&nctr%5B_mod%5D=pagelet_bluebar&__user=" + user_id + "&__a=1&fb_dtsg=" + fb_dtsg;

	const xhr = new XMLHttpRequest();
	xhr.withCredentials = true;

	xhr.addEventListener("readystatechange", function() {
	if (this.readyState === 4) {
	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
	public static IEnumerable<IEnumerable<T>> Split<T>(this T[] array, int size)
	{
	for (var i = 0; i < (float)array.Length / size; i++)
	{
	yield return array.Skip(i * size).Take(size);
	}
	}