Search
(Navigator)
1.* Photos * | 2.Best/Pano/Minis | 3.My Adventures | 4.Travels | 5.Questions/Answers | 6.Prog | 7.Maps | 8.Cool

Programming

1.Unix | 2.* Perl * | 3.PHP | 4.ASP.NET | 5.ASP | 6.Visual C++ | 7.Visual Basic | 8.JavaScript | 9.HTML | 10.CSS |
11.CGI, bin and Perl | 12.Cygwin | 13.Linux | 14.mySQL | 15.Python | 16.robertbody C++ & *.BAT |
17.Unix Notes (live) | 18.Perl Notes (live)
CGI, bin and Perl
Last Updated: Nov 12, 2005
---- robertbody.com CGI scripts triggered by HTML pages loading -----
counterc.cgi            # hit counter, log
date.cgi                # date co|az "y-m-d-H-M-S"
display.cgi             # display Perl/Unix/HTML files, by translating > to > ...

file-not-foundc.cgi     # file not found
  fnf.pm                # lookup table for above
loadpage.cgi            # slideshow with delays
---------------------------------------------------------------------
bin/
  1perl      # Perl script examples
  1unix      # UNIX script examples
  1template  # template for header

  chmod_755_all #  \ chmod 755 for  find *
  cygdo         #   \ untgz then call cygmove
  cygmove       #   / (in www/t) get all DIR names, then overwrite the DIRs below (in www/)

  fdate      # (uses date.cgi) 2005-11-09-17-22
  filesize   # size of file (displays error if no file specified)
  forever    # action, delay 5seconds, repeat forever ... eg. forever ls -alp
  forever0   # 0 delay forever

  ll         # ls -alp $*
  save       # save * to _save/2005-11-09-17-22

mysql/
  build-mysql.pl      # build mySQL database from (SQL commands generated from *.MDB)

binw/        g2 g1    # website specific
cygwin/
  g           # transfer files between PC and internet Unix server
  gall        # transfer whole website in 2 steps - calls g above
  gtf         # tgz, ftp, ssh to untgz on server (called/timed by g above)
  go          # make_bat and run it, call g

  m           # - call mdb.py (Python code in Windows XP)
              #   to generate rb.sql from *.MDB (Microsoft Access database)
              # - ssh to server and run build-mysql.pl Perl code in Unix
              #   to load mySQL database
  mysql       # rb.sql is generated by Python code in Windows XP (called/timed by m above)

  vget        # ftp from velcom's bin/ to local velcom/
  vput        # ftp from local bin/ to velcom's cygwin/ +perl +tools
  tgz         # smart gzip
  untgz       # smart gunzip

--perl/
    make_bat.pl                   # create .BAT to run in MS-DOS with cmd /c $myFile
    num-thousands.pl              # 123,456
    num-min-seconds.pl            # 1min 3.0s (time untgz: 1m3.025s)
    seconds -> num-min-seconds.pl
    thousands -> num-thousands.pl

--python/
    mdb.py            # (Python code in Windows XP) converts *.MDB to mySQL via DAO

--tools/
    feed              # run $1 over and over with $2, $3 ...
    offnow            # PC shutdown into Hibernate (now or after command completes)

    killp             # ps -ef | grep $1 | awk {'print $2'}; kill -9
    new               # vi $1; chmod +x $1; ls -alp $1
    rich              # which $1 | get dir ... cd dir ... if $2="!" then vi $1
	                    # rich gtf !   --- vi "gtf" file ...somewhere
			  	   	    #. rich gtf    --- switch to dir of "gtf" file
    sleeper(S)        # call sleeper.bg in background
    sleeper.bg        # sleep for $1, then execute $2
    snow(S)           # call snow.bg in background - make it xsnow! xpenguins too !
    snow.bg           # xpenguins -b; sleep 3; xsnow & (no blood, wait with snow) 
     	                # xpenguins must run before xsnow (else problem with IceWM)
    template(S)       # vi template.1
    template.1        # template for my #!/bin/sh code

--xterm/
    change-title(S)   # quick way, uses title below
    title             # get or set title in xterm

    glog(S)           # bring up xterm, 14 lines high on top of screen, call glogit
    glog.bg           # remove previous glog window if any; tail -f -50

    myterm            # myterm   glog | ice | xterm   (determines size, location, color)
    iterm(S)          # simple caller of myterm (good size for IceWm)
    ice -> iterm
    rterm(S)          # simple caller of myterm (good size for multi-window X server)

--log/
    glog              # log of transfers
  

log/         log   file_not_found  #
counter/                           # counter digits are in www/layout/
slide/                             # slide delays for users

tools/

www/
  photos.cgi            # images/*.jpg
  stats.cgi             # *.html *.jpg
  hits.cgi              # hit counters

z_windows/              # C++ and BAT files for creating HTML files for my website
                        # see [ robertbody BAT and CPP ]

----------------------------------------------------
projects to do:
1) file-not-found using MySQL database (copy of robertbody.mdb) and matching on old_name

accomplished before:
1)      *.html: MS Access database lookup from C++ code, to build HTML (1 page per picture) 
                with cross-reference links
2) stats.cgi:   Picture count of website pictures via Unix --> find and wc
3) display.cgi: HTML / Perl / Unix view utility (display.cgi)
4) date.cgi   : determine Colorado/Arizona time (1 script for both CGI and unix lookup)

#
Counter:
Last Updated: Sun, November 20, 2005 16:14