Guess the intent by Threen in c/sql@programming.dev
[-] Threen@aussie.zone 1 points 4 months ago

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 by Threen in c/sql@programming.dev
[-] Threen@aussie.zone 3 points 4 months ago

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 by Threen in c/sql@programming.dev
[-] Threen@aussie.zone 4 points 4 months ago

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

23
Guess the intent (aussie.zone)
submitted 4 months ago* (last edited 4 months ago) by Threen@aussie.zone to c/sql@programming.dev
9 comments fedilink

I am one of the developers on a very small team and have just found the following query

I would love to hear your ideas for what you think was being attempted here!

SELECT ... FROM client WHERE CAST(ABS(SIN(clientId)) AS BIT) = 0

Hacking Millions of Modems (and Investigating Who Hacked My Modem) by Threen in c/technology@beehaw.org
[-] Threen@aussie.zone 4 points 4 months ago

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

Hacking Millions of Modems (and Investigating Who Hacked My Modem) by Threen in c/technology@beehaw.org
[-] Threen@aussie.zone 4 points 4 months ago

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

59
Paged Out! is a free experimental technical magazine (pagedout.institute)
submitted 4 months ago by Threen@aussie.zone to c/programming@programming.dev
4 comments fedilink

I hope some people here enjoy reading these as much as I have

If you know of anything similar, I would love to hear them

35
Hacking Millions of Modems (and Investigating Who Hacked My Modem) (samcurry.net)
submitted 4 months ago by Threen@aussie.zone to c/technology@beehaw.org
5 comments fedilink
What are your top three favourite podcasts? by Threen in c/programming@programming.dev
[-] Threen@aussie.zone 3 points 9 months ago* (last edited 9 months ago)
  1. Soft Skills Engineering - Software engineering advice podcast
  2. If Books Could Kill - Criticising reviews of bestselling books
  3. CoRecursive - Stories about software
-2
Great Storage Box past 6800? (aussie.zone)
submitted 1 year ago by Threen@aussie.zone to c/pokemongo@lemmy.world
0 comments fedilink

I have the maxed out Pokemon storage of 6,800. Does anyone know if I buy the Great Storage Box if it will still increase this?

Share Trainer Codes by Threen in c/pokemongo@lemmy.world
[-] Threen@aussie.zone 1 points 1 year ago* (last edited 1 year ago)

0589 6066 6425

I would love to give gifts to anyone here

I am from Australia, and I travel between Queensland and South Australia regularly

2
Glitched avatar (aussie.zone)
submitted 1 year ago* (last edited 1 year ago) by Threen@aussie.zone to c/pokemongo@lemmy.world
0 comments fedilink

Found an interesting little glitch

  1. Close your game
  2. Turn your phone's GPS off
  3. Start the game and as soon as it loads open routes
  4. Turn GPS back on and after a few seconds close routes

Gyms and stops don't appear

Pokemon cannot be clicked on

1
Routes? (aussie.zone)
submitted 1 year ago by Threen@aussie.zone to c/pokemongo@lemmy.world
2 comments fedilink

What am I meant to be doing with "routes". There are none around me to follow and I cannot seem to create a new one

I am missing something? Do I need to complete something?

1
Programming Music (somafm.com)
submitted 1 year ago by Threen@aussie.zone to c/programming@programming.dev
0 comments fedilink

I am a big fan of listening to Drone Zone on SomeFM while programming

Hit me with your favourite streams, albums or artists

1
Anyone need a River Vivillon region gift? (aussie.zone)
submitted 1 year ago by Threen@aussie.zone to c/pokemongo@lemmy.world
0 comments fedilink

I work on top of pokestops, so add me and you'll get one today

0692 0102 3964

1
Anyone need a gift from the River Vivillon region? (aussie.zone)
submitted 1 year ago by Threen@aussie.zone to c/pokemongo@lemmy.ml
0 comments fedilink

Can probably only send you 1 gift, as my friend list is quite full

0692 0102 3964

Threen

joined 1 year ago