Alternate version:

  • wise_pancake@lemmy.ca
    link
    fedilink
    arrow-up
    3
    ·
    edit-2
    4 days ago

    I just wiped the DB and put it back online again.

    I did fix it, but had to rewrite a lot of the PHP backend, which took a couple days.

    And yes, I did release another website with SQL injection… It was a personal website for my brother and the pagination was vulnerable. I had written a simple CMS for it, but Instead of a password I just generated an obscure URL with completely open access to edit the DB directly.

    The pagination got hacked but I fixed it pretty quickly (by checking the page number was in fact a number).

    Surprisingly the CMS never got hacked before I moved him over to WordPress.

    Younger me learned a lot of web dev lessons the hard way.

    ETA: This was all when I was a teen and I had nobody in my life to teach me these things. I was self taught from a PHP book from the library.

    • CanadaPlus@lemmy.sdf.org
      link
      fedilink
      arrow-up
      1
      ·
      3 days ago

      Ah yes, the honest days of development, when you just got your hands dirty and didn’t have to worry about expensive formal education and stupid interview tactics.

      • wise_pancake@lemmy.ca
        link
        fedilink
        arrow-up
        1
        ·
        3 days ago

        It was fun and I learned a lot. I mostly did small time jobs for local companies and used the money for my tuition. Most sites were just static HTML, and I could program flash, so there wasn’t much risk to it.

        I am glad we have git instead of various backup folders on an ftp server, continuous integration, unit tests, and frameworks/accessible info to prevent the more basic errors.

        • CanadaPlus@lemmy.sdf.org
          link
          fedilink
          arrow-up
          1
          ·
          3 days ago

          There is reasons it ended, and some of them good. Sorry, got caught up in nostalgia a bit there.

          You can still write open source stuff without needing anything besides technical knowledge, if you are in a situation where you have extra time and energy after feeding yourself.