장난감

#!/bin/sh

BIN=/usr/local/mysql/bin

printf "ID를 입력하세요. : "
read DB
USER=$DB
printf "Password를 입력하세요. : "
read PASS

cat > mysql.user << __eof__
#CREATE database ${DB};
insert into user (Host,User,Password)
values('localhost','${USER}',password('${PASS}'));
insert into db values
('localhost','${DB}','${USER}',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
CREATE database ${DB};
__eof__

mysql -u root -p mysql -vvv < mysql.user
${BIN}/mysqladmin -u root -p reload

mkdir /mnt/1;mkdir /mnt/2
smbmount //hugyup/e /mnt/1
smbmount //hugyup/f /mnt/2
find ./ -name *.jpg > jpglist
cat jpglist |sed -e 's/^\.\///g' -e 's/\//./g' -e 's/^/\/mnt\/2\/newdb\//g' > newjpglist
grep 1995 jpglist  > o1995
grep 1996 jpglist  > o1996
grep 1997 jpglist  > o1997
grep 1998 jpglist  > o1998
grep 1999 jpglist  > o1999
grep 1995 newjpglist |sed -e 's/newdb\//newdb\/1995\//g' > mv1995
grep 1996 newjpglist |sed -e 's/newdb\//newdb\/1996\//g' > mv1996
grep 1997 newjpglist |sed -e 's/newdb\//newdb\/1997\//g' > mv1997
grep 1998 newjpglist |sed -e 's/newdb\//newdb\/1998\//g' > mv1998
grep 1999 newjpglist |sed -e 's/newdb\//newdb\/1999\//g' > mv1999

cd /mnt/2/newdb/
mkdir 1995;mkdir 1996;mkdir 1997;mkdir 1998;mkdir 1999
ls -l
합계 3
drwxr-xr-x    1 root     root          512  7월 10 18:59 ./
drwxr-xr-x    1 root     root          512  7월 10 18:59 ../
drwxr-xr-x    1 root     root          512  7월 10 18:59 1995/
drwxr-xr-x    1 root     root          512  7월 10 18:59 1996/
drwxr-xr-x    1 root     root          512  7월 10 18:59 1997/
drwxr-xr-x    1 root     root          512  7월 10 18:59 1998/
drwxr-xr-x    1 root     root          512  7월 10 18:59 1999/
여기까지 기반환경 만드는부분...
=========정리된 잡지jpg파일리스트 를 통해서 1년간분량만 추출하여 기호화 복사 통합 작업 (chmv)
#!/bin/sh
Count=`wc -l $1|awk {'print $1'}`
Start=0
while [ $Start -lt $Count ]
do
Start=`echo $Start+1|bc`
cp `head -$Start $1|tail -1` `head -$Start $2|tail -1`
done

=========잡지 한부 분량씩 통합. (sumdellist)
#!/bin/sh 
rm -f .tmpsumlist
rm -f sumlist

cat $1|grep \\.001 > .tmpsumlist
Start=0
Count=`wc -l .tmpsumlist|awk {'print $1'}`
while [ $Start -lt $Count ]
do
Start=`echo $Start+1|bc`
sum=`head -$Start .tmpsumlist|tail -1`
sum=`echo ${sum##*/}`
echo ${sum%%.0*} >> sumlist
done
#cat sumlist |sed -e 's/\/mnt\/2\/newdb\/1995\///g' > sumlist
Start=0
Count=`wc -l sumlist|awk {'print $1'}`
while [ $Start -lt $Count ]
do
Start=`echo $Start+1|bc`
sum=`head -$Start sumlist|tail -1`
cat $sum.* >> sum.$sum.TXT
done
rm -f .tmpsumlist
=========테이타베이스 형태로 변환 그리고 파트별 인덱스 기호 수정 및 초과.. (zeros)
#!/bin/sh
Year=`sed -e 's/^19//g' year`
ls |grep ^sum\\.|sed -e 's/*$//g' > sumlist2
echo $Year
Start=0
Count=`wc -l sumlist2|awk {'print $1'}`
cat sum.* > /dev/null
while [ $Start -lt $Count ]
do
Start=`echo $Start+1|bc`
perl -p -e 's/\n/\\r\\n/g' `head -$Start sumlist2|tail -1` > .tmpfile
cat .tmpfile > `head -$Start sumlist2|tail -1`
sed -e 's/\* 1995\.95/\* 1995\./g' -e 's/\.JPG \*/쪽분량 */g' -e 's/^M//g' -e 's/'\''/'\\\\\\\\\\\\\''/g' `head -$Start sumlist2|tail -1` > .tmpfile
cat .tmpfile > `head -$Start sumlist2|tail -1`
done
rm -f .tmpfile
========제로보드 데이터 형태로 바꾸기 위해 지금까지 가공한 텍스트를 sql 표준 퀴리문으로 변환 (make)
#!/bin/sh
Start=0
Count=`wc -l sumlist|awk {'print $1'}`
while [ $Start -lt $Count ]
do
Start=`echo $Start+1|bc`
File=`head -$Start sumlist|tail -1`
echo "INSERT INTO zetyx_board_awake VALUES ("$Start",1,-"$Start",0,0,0,0,0,0,1,1,'"`cat sum.$File.TXT`"','1.1.1.1','6d790ed71ec3d3a4','성우','','','"`echo $File |sed -e 's/\.95/\./g'`"','','',1,'','','','','','','',0,0,1026367476,0,0,0,'','');"
done

mysql데이타 베이스 형태로 복구
debian:/var/www/sql# sh make  >avatar.sql
debian:/var/www/sql#
debian:/var/www/sql#
debian:/var/www/sql# mysql -uavatar -p avatar < avatar.sql

sum
#!/bin/sh

INTS=`cat $1|awk {'print $10'}|grep [0-9]`
echo $INTS|tr " " +|bc
#bc <<!go! > CNT
#$SUM
#quit
#!go!


#END

vhostlognodomain
#!/bin/sh
#rm -f  .nodomain
#rm -f  .nteenuser
ls -l /home/nteen/hosting|grep ^l|awk {'print $9'}  > .nodomain
ls -l /home/nteen/members|grep ^d|awk {'print $9'}  > .nteenuser
COUNT=`wc -l .nodomain|awk {'print $1'}|xargs echo 1+|bc`
START=1
while [ "$START" != "$COUNT" ]; do
NOWUSER=`head -$START .nodomain|tail -1`
cat $1|egrep " /hosting/$NOWUSER/| /$NOWUSER/"  > $NOWUSER.$3
START=`echo $START+1|bc`
done


COUNT=`wc -l .nteenuser|awk {'print $1'}|xargs echo 1+|bc`
START=1
while [ "$START" != "$COUNT" ]; do
NOWUSER=`head -$START .nteenuser|tail -1`
cat $2|egrep " /$NOWUSER/"  > $NOWUSER.nteen.$3
START=`echo $START+1|bc`
done


vhostlogrep
#!/bin/sh
rm -f .lists
rm -f .list
ls ./$2 > .lists
cat .lists|sed -e 's/^.\///g'  > .list
COUNT=`wc -l .list|awk {'print $1'}|xargs echo 1+|bc`
START=1
while [ "$START" != "$COUNT" ]; do
NOWFILE=`head -$START .list|tail -1`
egrep $1 $NOWFILE > $NOWFILE.$3
START=`echo $START+1|bc`
done


vhostlogsee
#!/bin/sh
rm -f .filelist
ls -Sl $1 > .filelist
COUNT=`wc -l .filelist|awk {'print $1'}|xargs echo 1+|bc`
START=1
printf "LOGSIZE\t\tLOGNAME\t\t\tLOGLINE\t\tLOGTRANS\tSECOND\n"
while [ "$START" != "$COUNT" ]; do
NOWFILE=`head -$START .filelist|tail -1`
CKFILE=`echo $NOWFILE|awk {'print $9'}`
TRANS=`cat $CKFILE.sum`
SECOND=`echo $TRANS/86400|bc`
printf "`echo $NOWFILE|awk {'print $5'}` $CKFILE\t\t`wc -l $CKFILE|awk {'print $1'}`   $TRANS  $SECOND\n"
START=`echo $START+1|bc`
done


vhostlogsum
#!/bin/sh
rm -f .lists
rm -f .list
ls ./$1 > .lists
cat .lists|sed -e 's/^.\///g'  > .list
COUNT=`wc -l .list|awk {'print $1'}|xargs echo 1+|bc`
START=1
while [ "$START" != "$COUNT" ]; do
NOWFILE=`head -$START .list|tail -1`
./sum.s $NOWFILE > $NOWFILE.$2
START=`echo $START+1|bc`
done

 

#!/bin/sh

DATE=`date +"%m %e"`
OLDDAY=`echo $DATE|awk {'print $2'}`
OLDMON=`echo $DATE|awk {'print $1'}`

#---------------------------------------------
if [ ! -f log ]; then
touch log
fi

OLD=`ls -l log|awk '{print $5}'`
#---------------------------------------------
    while [ 0 ];do

DATE=`date +"%m %e %T"`
NOWMON=`echo $DATE|awk {'print $1'}`
NOWDAY=`echo $DATE|awk {'print $2'}`
NOWTIME=`echo $DATE|awk {'print $3'}`
      if [ "$OLDDAY" != "$NOWDAY" ];then
         mv ./log ./log.$OLDMON.$OLDDAY
      fi

#-----------------------------------------------------
      ps axuwf|awk  '{str i;if($3 > 10){printf ("%s\n",$i)};}' >>log
NOW=`ls -l log|awk '{print $5}'`
      if [ "$NOW" -gt "$OLD" ];then
      echo "      TIME $NOWTIME">> log
      echo "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~" >>log
      fi
sleep 1
OLD=`ls -l log|awk '{print $5}'`
#------------------------------------------------------
OLDMON=$NOWMON
OLDDAY=$NOWDAY
done

 

#!/bin/sh

Time=300
Neweth=0

DATE=`date +"%m %e"`
Oldmon=`echo $DATE|awk {'print $1'}`
Oldday=`echo $DATE|awk {'print $2'}`

#---------------------------------------------
#날짜 채크 초기화 끝

if [ ! -f log ]; then
touch log
fi

#---------------------------------------------
#무한루프의 시작

    while [ 0 ];do

    DATE=`date +"%m %e %T"`
    Nowmon=`echo $DATE|awk {'print $1'}`
    Nowday=`echo $DATE|awk {'print $2'}`
    Nowtime=`echo $DATE|awk {'print $3'}`
          if [ "$Oldday" != "$Nowday" ];then
      mv ./log ./log.$Oldmon.$Oldday
    fi
#---------------------------------------------
#날짜 채크 끝 본문 코드 시작

    Oldeth=$Neweth

    Neweth=`cat /proc/net/dev|grep eth0|awk '{print $9}'`
    echo `echo $Neweth-$Oldeth|bc`/$Time|bc|xargs echo $Nowtime >> log
    sleep $Time

    Oldmon=$Nowmon
    Oldday=$Nowday
   
    done