Skip Navigation

Threen

@ Threen @aussie.zone

Posts
7
Comments
6
Joined
3 yr. ago

  • Guess the intent

    Jump

  • Update: The original dev does not remember exactly. However they have said that clientId was originally a VARCHAR, so this may have been checking for both '0' or ''

    So an over-engineered workaround to a bad datatype perhaps?

  • Guess the intent

    Jump

  • I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId is also 0

    It certainly doesn't for any of the 100,000 existing rows

  • Guess the intent

    Jump

  • The client table has around 100,000 rows each with a unique clientId, none of which are returned from the CAST / ABS / SIN

    I think you are right and this is a 'fix' for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for

  • Hacking Millions of Modems (and Investigating Who Hacked My Modem)

    Jump

  • Thank you so much, I'll check it out!

  • Hacking Millions of Modems (and Investigating Who Hacked My Modem)

    Jump

  • Absolutely, it's a great read. Could you link the video you watched?

  • Programming @programming.dev
    Threen @aussie.zone

    Paged Out! is a free experimental technical magazine

    pagedout.institute
  • Technology @beehaw.org
    Threen @aussie.zone

    Hacking Millions of Modems (and Investigating Who Hacked My Modem)

    samcurry.net /hacking-millions-of-modems

  • What are your top three favourite podcasts?

    Jump
    1. Soft Skills Engineering - Software engineering advice podcast
    2. If Books Could Kill - Criticising reviews of bestselling books
    3. CoRecursive - Stories about software
  • Programming @programming.dev
    Threen @aussie.zone

    Programming Music

    somafm.com /dronezone/
  • Cyberpunk @lemmy.villa-straylight.social
    Threen @aussie.zone

    2039 - Tom Mauritzon

  • Java™ Community @lemmy.ml
    Threen @aussie.zone

    Eclipse compiler issue

  • Pokemon Go @lemmy.ml
    Threen @aussie.zone

    Anyone need a gift from the River Vivillon region?