Code Samples
Not the prettiest system to view code samples, but a working one.

This site runs from a raspberry pi, php and apache. (my php isn't great but it does the job)

This page sample is ADMINLTE

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. Ides DB Clean.sql
  25. LINKED SERVER SQL.sql
  26. MSACCESS link DSNless.VBA
  27. Memory Used.SQL
  28. Missing Index DMVs.sql
  29. New Text Document.txt
  30. OldIC_Dataload.sql
  31. Oracle table row counts.txt
  32. PAF SQL QUERY.sql
  33. PAF update SQL.sql
  34. Pattern index searching.SQL
  35. Read Excel into SQL.txt
  36. RecoverSQLDB.SQL
  37. Reindex All Indexes on All Tables in a Database.sql
  38. Restore to point in time.sql
  39. SP Configure.SQL
  40. SQL Show missing Indexes.sql
  41. SQL database table size.sql
  42. SQL from cmd Line.txt
  43. SQL paging.sql
  44. Search All Tables SP.sql
  45. Show Pages used per table.sql
  46. ShowAdvanced.sql
  47. ShowAllIndexes.sql
  48. ShowTCPPort.sql
  49. ShrinkDB.bat
  50. ShrinkIDES.SQL
  51. ShrinkLog.SQL
  52. Status of Rebuild Index.doc
  53. TCP Port Used.txt
  54. Table KB size and Rows.sql
  55. Trigger - alter column after insert.sql
  56. Trim SQL database space (logfiles).sql
  57. View queries being run.sql
  58. add Identity.sql
  59. alter field name in SQL.SQL
  60. backup time remaining.sql
  61. copy table.sql
  62. create SP_help_revLogin.sql
  63. cte CS files.txt
  64. delete Duplicates.sql
  65. fixSQLIDES.sql
  66. hamworthy scripts.sql
  67. import Excel to SQL table.sql
  68. insert into CC bus Partners.txt
  69. insert into table from table.sql
  70. list All SQL Databases.sql
  71. mobile bill SQL query.txt
  72. pivot.sql
  73. recover log file space.txt
  74. reindex all indexes on database.sql
  75. remove Leading Zeros.SQL
  76. replace_all_syns.sql
  77. saveblobToDB.sql
  78. select from string array in SQL.sql
  79. show defrag showcontig.SQL
  80. show missing indexes v1.sql
  81. single & multi user mode.sql
  82. sqlVer.sql
  83. truncate database.sql
  84. update table from table.SQL
  85. update where.SQL

html

HTML

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

    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

        2019 .