tinoest

dpkg -l | grep php8.0 | awk '{print $2}' | sed -e 's/8.0/8.1/' | xargs apt install

 esptool.py erase_flash

https://github.com/espressif/ESP8266_NONOS_SDK/archive/v3.0.1.tar.gz

 esptool.py -p /dev/tty.usbserial-A603AYEQ --chip esp8266 write_flash --flash_size 2MB-c1 0x00000 boot_v1.2.bin 0x01000 at/1024+1024/user1.2048.new.5.bin 0x1fc000 esp_init_data_default_v05.bin 0xfe000 blank.bin 0x1fb000 blank.bin 0x1fe000 blank.bin

• GPIO15 - GND
• GPIO02 - VCC
• GPIO00- GND
• RESET - GND ( Temporarily )
• TX - RX
• RX - TX

• Install esptool.py

 pip install esptool 

• Download SDK 2.2.1

https://github.com/espressif/ESP8266_NONOS_SDK/archive/v2.2.1.zip

• Extract files and go to bin/
• Run the following command and reset the chip

esptool.py --port /dev/tty.usbserial-A603AYEQ --baud 115200 write_flash --flash_mode dio 0x00000 boot_v1.2.bin 0x01000 at/512+512/user1.1024.new.2.bin 0x7B000 blank.bin 0x3FC000 esp_init_data_default_v05.bin 0x7E000 blank.bin

find . -type f -name '*.php' -exec php -l {} \; 

find /home/tino/YAPortal/ -type f -exec sed -i 's/@version 1.0.1/@version 1.0.2/g' {} \;

find . -type f -name '*.txt' -exec sed --in-place 's/[[:space:]]\+$//' {} \+

find . -iname '*.txt' -type f -exec sed -i '' 's/[[:space:]]\{1,\}$//' {} \+

SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

SELECT pg_cancel_backend(procpid);

SELECT pg_terminate_backend(procpid);

SELECT T1.log_dt, T2.log_dt, EXTRACT(EPOCH FROM (T2.log_dt - T1.log_dt))
FROM power_data AS T1
INNER JOIN power_data  AS T2
	USING ( node )
WHERE T1.log_dt > '2017-05-05 22:10:00'
AND T2.log_dt > '2017-05-05 22:10:00'
ORDER BY T1.id, T2.id
LIMIT 2

#define ATOMIC for(INTCONbits.GIE=0;!INTCONbits.GIE;INTCONbits.GIE=1)