thaicosmic.com

หนัง

วันอาทิตย์ที่ 18 พฤศจิกายน พ.ศ. 2561

Acronis Backup for PC

8FEF2960-8795-4851-96C9-5BAD7CE73978
2D7444D1-2ADA-4340-81DF-17874531CF0F
86E04C40-205C-4135-BB42-FF25534D9532
D1752AD3-DD26-468A-9B8C-4D728435F9D6
9AC578AF-DF50-4BF8-AAE5-B4B2AD4202D4

วันอาทิตย์ที่ 11 พฤศจิกายน พ.ศ. 2561

วันพฤหัสบดีที่ 25 ตุลาคม พ.ศ. 2561

e

#


# deb cdrom:[Ubuntu-Server 14.04.4 LTS _Trusty Tahr_ - Release amd64 (20160217.1)]/ trusty main restricted

# deb cdrom:[Ubuntu-Server 14.04.4 LTS _Trusty Tahr_ - Release amd64 (20160217.1)]/ trusty main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://old-releases.ubuntu.com/ubuntu trusty main restricted
deb-src http://old-releases.ubuntu.com/ubuntu trusty main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://old-releases.ubuntu.com/ubuntu trusty-updates main restricted
deb-src http://old-releases.ubuntu.com/ubuntu trusty-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://old-releases.ubuntu.com/ubuntu trusty universe
deb-src http://old-releases.ubuntu.com/ubuntu trusty universe
deb http://old-releases.ubuntu.com/ubuntu trusty-updates universe
deb-src http://old-releases.ubuntu.com/ubuntu trusty-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://old-releases.ubuntu.com/ubuntu trusty multiverse
deb-src http://old-releases.ubuntu.com/ubuntu trusty multiverse
deb http://old-releases.ubuntu.com/ubuntu trusty-updates multiverse
deb-src http://old-releases.ubuntu.com/ubuntu trusty-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://old-releases.ubuntu.com/ubuntu trusty-backports main restricted universe multiverse
deb-src http://old-releases.ubuntu.com/ubuntu trusty-backports main restricted universe multiverse

deb http://old-releases.ubuntu.com/ubuntu trusty-security main restricted
deb-src http://old-releases.ubuntu.com/ubuntu trusty-security main restricted
deb http://old-releases.ubuntu.com/ubuntu trusty-security universe
deb-src http://old-releases.ubuntu.com/ubuntu trusty-security universe
deb http://old-releases.ubuntu.com/ubuntu trusty-security multiverse
deb-src http://old-releases.ubuntu.com/ubuntu trusty-security multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu trusty partner
# deb-src http://archive.canonical.com/ubuntu trusty partner

## Uncomment the following two lines to add software from Ubuntu's
## 'extras' repository.
## This software is not part of Ubuntu, but is offered by third-party
## developers who want to ship their latest software.
# deb http://extras.ubuntu.com/ubuntu trusty main
# deb-src http://extras.ubuntu.com/ubuntu trusty main

วันจันทร์ที่ 22 ตุลาคม พ.ศ. 2561

วันอาทิตย์ที่ 21 ตุลาคม พ.ศ. 2561

idm torrent

magnet:?xt=urn:btih:55E19C67C850B6FAFAC61B8316C23DAB26093A52&dn=IDM+6.31+Build+9+incl+Patch+%5B32bit+%2B+64bit%5D+Fake+Serial+Fixed+%5BCrackingPatching%5D&tr=udp%3A%2F%2F9.rarbg.com%3A2730%2Fannounce&tr=udp%3A%2F%2F9.rarbg.me%3A2800%2Fannounce&tr=udp%3A%2F%2F9.rarbg.to%3A2750%2Fannounce&tr=udp%3A%2F%2Feddie4.nl%3A6969%2Fannounce&tr=udp%3A%2F%2Fexplodie.org%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.coppersurfer.tk%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.internetwarriors.net%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.leechers-paradise.org%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.opentrackr.org%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.sktorrent.net%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.zer0day.to%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.leechers-paradise.org%3A6969%2Fannounce&tr=udp%3A%2F%2Fcoppersurfer.tk%3A6969%2Fannounce

วันอังคารที่ 9 ตุลาคม พ.ศ. 2561

hdc person temporary full with grave

DROP TEMPORARY TABLE IF EXISTS `person`;
CREATE TEMPORARY TABLE `person`
SELECT
  `person`.`HOSPCODE` ,
  `person`.`CID` ,
  `person`.`PID` ,
  `person`.`HID` ,
  `person`.`PRENAME` ,
  `person`.`NAME` ,
  `person`.`LNAME` ,
  `person`.`HN` ,
  `person`.`SEX` ,
  `person`.`BIRTH` ,
  `person`.`MSTATUS` ,
  `person`.`OCCUPATION_OLD` ,
  `person`.`OCCUPATION_NEW` ,
  `person`.`RACE` ,
  `person`.`NATION` ,
  `person`.`RELIGION` ,
  `person`.`EDUCATION` ,
  `person`.`FSTATUS` ,
  `person`.`FATHER` ,
  `person`.`MOTHER` ,
  `person`.`COUPLE` ,
  `person`.`VSTATUS` ,
  `person`.`MOVEIN` ,
  `person`.`DISCHARGE` ,
  `person`.`DDISCHARGE` ,
  `person`.`ABOGROUP` ,
  `person`.`RHGROUP` ,
  `person`.`LABOR` ,
  `person`.`PASSPORT` ,
  `person`.`TYPEAREA` ,
  `person`.`D_UPDATE` ,
  `person`.`TELEPHONE` ,
  `person`.`MOBILE` ,
  `person`.`HDC_DATE`
WHERE
  `person`.`HOSPCODE` = '03301';
SELECT * FROM `person`;

hdc person temporary full

DROP TEMPORARY TABLE IF EXISTS person;
CREATE TEMPORARY TABLE person
SELECT
  person.HOSPCODE ,
  person.CID ,
  person.PID ,
  person.HID ,
  person.PRENAME ,
  person.NAME ,
  person.LNAME ,
  person.HN ,
  person.SEX ,
  person.BIRTH ,
  person.MSTATUS ,
  person.OCCUPATION_OLD ,
  person.OCCUPATION_NEW ,
  person.RACE ,
  person.NATION ,
  person.RELIGION ,
  person.EDUCATION ,
  person.FSTATUS ,
  person.FATHER ,
  person.MOTHER ,
  person.COUPLE ,
  person.VSTATUS ,
  person.MOVEIN ,
  person.DISCHARGE ,
  person.DDISCHARGE ,
  person.ABOGROUP ,
  person.RHGROUP ,
  person.LABOR ,
  person.PASSPORT ,
  person.TYPEAREA ,
  person.D_UPDATE ,
  person.TELEPHONE ,
  person.MOBILE ,
  person.HDC_DATE
WHERE
  person.HOSPCODE = '03301';
SELECT * FROM person;

hdc person temporary

DROP TEMPORARY TABLE IF EXISTS person;
CREATE TEMPORARY TABLE person
SELECT
  HOSPCODE ,
  CID ,
  PID ,
  HID ,
  PRENAME ,
  NAME ,
  LNAME ,
  HN ,
  SEX ,
  BIRTH ,
  MSTATUS ,
  OCCUPATION_OLD ,
  OCCUPATION_NEW ,
  RACE ,
  NATION ,
  RELIGION ,
  EDUCATION ,
  FSTATUS ,
  FATHER ,
  MOTHER ,
  COUPLE ,
  VSTATUS ,
  MOVEIN ,
  DISCHARGE ,
  DDISCHARGE ,
  ABOGROUP ,
  RHGROUP ,
  LABOR ,
  PASSPORT ,
  TYPEAREA ,
  D_UPDATE ,
  TELEPHONE ,
  MOBILE ,
  HDC_DATE
FROM person
WHERE
  HOSPCODE = '03301';
SELECT * FROM person;

วันพุธที่ 12 กันยายน พ.ศ. 2561

วันพุธที่ 8 สิงหาคม พ.ศ. 2561

Last crontab

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# m h dom mon dow user command
17 * * * * root    cd / && run-parts --report /etc/cron.hourly
25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
55 12,17,20,23 * * 0-6 root /var/jhcis/mysql-backup-jhcisdb.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jepidem/runjepidem.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jxp18/runjxp18.sh >/dev/null 2>&1
0 0-22 * * 0-6 root sh /var/jautoup/runjauto.sh >/dev/null 2>&1
*/5 * * * * root sh /var/jhcis/create-pdf.sh /dev/null 2>&1
#end

lastest jhcis backup

# !/bin/sh

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "-31 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

วันเสาร์ที่ 28 กรกฎาคม พ.ศ. 2561

haguichi

sudo add-apt-repository -y ppa:webupd8team/haguichi
sudo apt update
sudo apt install -y haguichi

tt

apache2 bc build-essential cpp curl g++ gawk gcc genisoimage gzip htmldoc isolinux lftp libapache2-mod-php7.1 libc6 libcurl3 liblzma-dev m4 mysql-client mysql-server net-tools nfs-kernel-server openssh-server php7.1 php7.1-bcmath php7.1-cli php7.1-curl php7.1-fpm php7.1-gd php7.1-json php7.1-ldap php7.1-mbstring php7.1-mcrypt php7.1-mysql php7.1-mysqlnd php-gettext sysv-rc-conf tar tftpd-hpa tftp-hpa unzip vsftpd wget xinetd zlib1g

วันอาทิตย์ที่ 29 เมษายน พ.ศ. 2561

วันพุธที่ 18 เมษายน พ.ศ. 2561

วันพฤหัสบดีที่ 22 มีนาคม พ.ศ. 2561

วันอาทิตย์ที่ 4 มีนาคม พ.ศ. 2561

วันอาทิตย์ที่ 25 กุมภาพันธ์ พ.ศ. 2561

ยังคง err

Query:
/*!50003 SET character_set_client  = utf8mb4 */

Error occured at:2018-02-25 07:31:55
Line no.:18041
Error Code: 1115 - Unknown character set: 'utf8mb4'



tmp

init_connect = ‘set collation_connection = utf8_general_ci’
init_connect = ‘set names utf8’

วันศุกร์ที่ 23 กุมภาพันธ์ พ.ศ. 2561

วันพฤหัสบดีที่ 22 กุมภาพันธ์ พ.ศ. 2561

mysql-backup-jhcisdb.sh 256102221921

# !/bin/sh

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --compatible=no_key_options  -u root -p123456 jepidem > /home/jhcis/backupjhcis/jepidem-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jepidem-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --routines --allow-keywords --add-drop-table --compatible=no_key_options,no_table_options --no-set-names --lock-tables --skip-set-charset --skip-disable-keys --skip-add-locks -u root -p123456 jepidem > /home/jhcis/Dropbox/backupjhcis/jepidem-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jepidem-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

วันอังคารที่ 13 กุมภาพันธ์ พ.ศ. 2561

mySQL ตัดเครื่องหมาย "-" ออกจากเลขประจำตัวประชาชน

update `dm-hba1c` set `dm-hba1c`.cardid = CONCAT(Left(`dm-hba1c`.cardid,1),Mid(`dm-hba1c`.cardid,3,4),Mid(`dm-hba1c`.cardid,8,5),Mid(`dm-hba1c`.cardid,14,2),Right(`dm-hba1c`.cardid,1))

วันศุกร์ที่ 9 กุมภาพันธ์ พ.ศ. 2561

cascap


ICD 10 การคัดกรองมะเร็งตับ Z12.8

หัตถการ                 9270700