Code Samples

This site runs from a raspberry pi, php and apache.

This page sample is ADMINLTE
Code samples are hidden. Only titles are shown. - Request a password to have full access.

vbs

VBS scripts
  1. ABCD.vbs
  2. CloseOpenFiles.vbs
  3. CogPass.vbs
  4. ConcatenateDatainFiles.vbs
  5. CopyFolderToUsB.vbs
  6. CoutnFiles.VBS
  7. CreateFoldersFromTable.vbs
  8. Crypto
  9. Crypto.vb
  10. DeleteFilesOlderThan.vbs
  11. Drives.bat
  12. EmailFromOutlook.vbs
  13. ExcelMacro1.txt
  14. Intranet-DateRangeAdd.vbs
  15. LoopFolder.VBS
  16. MSACCESS link DSNless.VBA
  17. Macro1.vb
  18. Macro2.txt
  19. OldPCName.vbs
  20. OracleSample.vbs
  21. SQL connection.txt
  22. TotalDatabaseSizes.vbs
  23. UpdateAD.vbs
  24. UpdateADMIN.vbs
  25. UpdateUser.vbs
  26. backupFiles.vbs
  27. bapi.vbs
  28. bapi2.vbs
  29. email.vbs
  30. emailSC.vbs
  31. excelmacro.vb
  32. fixFilenames.vbs
  33. flashLights.vbs
  34. hexSample.VBS
  35. insert rec get ID.vb
  36. mAttachmentSaver
  37. mAttachmentSaver.zip
  38. mapper.vbs
  39. movDB.vbs
  40. mysql.txt
  41. printspool.vbs
  42. restart service
  43. sdf file create xaml.vb
  44. smtp sendemail.vbs
  45. test email.vbs
  46. testemailSVG.vbs
  47. updateCIPRDList.vbs
  48. vbs datavase connection.vbs
  49. whichSQL.vbs

sql scripts

SQL
  1. Alter Field type In SQL.SQL
  2. BACKUP DATABASE.sql
  3. Bordereaux_moveEDIdata.sql
  4. CTE - inner join two CTEs.sql
  5. CTE BWDATA DEDUPE.txt
  6. CTE and windowing.sql
  7. CTE boilers created.sql
  8. CamelCase.sql
  9. Count Records In All tables.sql
  10. Create User.sql
  11. CreateIntranetFiles.SQL
  12. DMV Cleanup INDEXES.SQL
  13. DMV missing index.sql
  14. Database size.sql
  15. Defrag all tables over a set threashold.txt
  16. DetectFragmentation.SQL
  17. FIX PF archive DB.txt
  18. Fix tblroombooking date.txt
  19. Fragmentation Index Levels.sql
  20. Hamworthy_invocies.sql
  21. How much Space per table.sql
  22. IDENTITY INSERT.sql
  23. ISGSDI_ViewWithDepartment.sql
  24. LINKED SERVER SQL.sql
  25. MSACCESS link DSNless.VBA
  26. Memory Used.SQL
  27. Missing Index DMVs.sql
  28. OldIC_Dataload.sql
  29. Oracle table row counts.txt
  30. PAF SQL QUERY.sql
  31. PAF update SQL.sql
  32. Pattern index searching.SQL
  33. Read Excel into SQL.txt
  34. RecoverSQLDB.SQL
  35. Reindex All Indexes on All Tables in a Database.sql
  36. Restore to point in time.sql
  37. SP Configure.SQL
  38. SQL Show missing Indexes.sql
  39. SQL database table size.sql
  40. SQL from cmd Line.txt
  41. SQL paging.sql
  42. Search All Tables SP.sql
  43. Show Pages used per table.sql
  44. ShowAdvanced.sql
  45. ShowAllIndexes.sql
  46. ShowTCPPort.sql
  47. ShrinkDB.bat
  48. ShrinkIDES.SQL
  49. ShrinkLog.SQL
  50. Status of Rebuild Index.doc
  51. TCP Port Used.txt
  52. Table KB size and Rows.sql
  53. Trigger - alter column after insert.sql
  54. Trim SQL database space (logfiles).sql
  55. View queries being run.sql
  56. add Identity.sql
  57. alter field name in SQL.SQL
  58. backup time remaining.sql
  59. copy table.sql
  60. create SP_help_revLogin.sql
  61. cte CS files.txt
  62. delete Duplicates.sql
  63. fixSQLIDES.sql
  64. hamworthy scripts.sql
  65. import Excel to SQL table.sql
  66. insert into CC bus Partners.txt
  67. insert into table from table.sql
  68. list All SQL Databases.sql
  69. pivot.sql
  70. recover log file space.txt
  71. reindex all indexes on database.sql
  72. remove Leading Zeros.SQL
  73. replace_all_syns.sql
  74. saveblobToDB.sql
  75. select from string array in SQL.sql
  76. show defrag showcontig.SQL
  77. show missing indexes v1.sql
  78. single & multi user mode.sql
  79. sqlVer.sql
  80. truncate database.sql
  81. update table from table.SQL
  82. update where.SQL

web programming

HTML 4
HTML 5
CSS 3
Javascript
Jquery
php
perl
python
react

security

SECURITY

    using KALI effectivly.

    wifi:
    mana-toolkit fake access point
    cracking wep, wpa and wpa2
    wash
    reaver
    aircrack

    Client access:
    zenmap,
    MITMF
    arp poisoning/ spoofing
    bypass https
    session hijacking
    dns spoofing
    key logging
    screen capture
    remote js injection

    website pen test
    file upload
    code exec
    file inclusion
    sql injection
    xss

    .net

    c# classes from a recent project.
    1. Bootstrap.cs
    2. Case.cs
    3. Common.cs
    4. CreditCommitments.cs
    5. Log.cs
    6. SMS.cs
    7. TrustPilot.cs
    8. User.cs
    9. ajaxsample.aspx
    10. ajaxsample.aspx.cs

    unix

    UNIX


      df -h (hard drive spaces)
      ls -ltrh (list files with sizes in KB)
      fdisk -l (list drives)
      ps -ef | grep ( list processes)
      nano (file editor other than vi)
      /etc/init.d/ (location list of running services)
      apt-get (install software)
      apt-get update (update repositories)
      apt-get upgrade (apply any updates to OS)
      touch (create a document)
      chmod (change file permissions)
      user -a (create user)

      vehicle hacks

      VEHICLE HACKS
      1. OBD-DIAGV1.01.02.zip

      ODB reader in .net

      tools

      TOOLS

        useful

        USEFUL PROGRAMS
        1. A_GetSMSResponsesEsendex.zip
        Still to be uploaded
        Royal mail PAF program.
        27 tech api sample integration
        equifax api sample integration
        IRESS API sample integration
        Automated Marketing CRM Emailer/ SMS
        sendgrid api integration

        tools

        pi / arduino
        1. ReadMe.txt
        2. StartCamera.sh
        3. TurnOffPC.sh
        4. TurnOnTV.sh
        5. TurnOverToPI.sh
        6. pir_readPIR2.py
        7. pir_runme.sh
        8. runcamera.sh
        9. scanForTV.sh

        Raspberry Pi
        • motion detector
        • mobile spotify
        • sms engine
        • door alarm
        • email server
        • web server
        • RF Reader

        2019 .