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.