In Hungary the unified school administration systems source code gets leaked (and also the personal data of 4 million students, teachers and parents), feast year eyes on what an oligarchs friends company can develop with measly 50 million EUR+another 30 for hosting and upkeep.

It's full of quality code like this.

The lead software tester was a daughter of another friend with whopping 2 years of experience (and a non-stem degree).

They didn't have 2fa for anything, they got access to one of the developers outlook email+password through social engineering and got access to EVERYTHING.

the whole sourcecode: t.me/sawarim

I want to thank your countrymen for paying for this @UraniumDonGER:marseythumbsup:

200
Jump in the discussion.

No email address required.

I've come to the conclusion that Hungarians are overambitious r-slurs, especially after watching that Robinhood inquiry over the GameStop stock.

Jump in the discussion.

No email address required.

Robinhood inquiry over the GameStop stock.

What did we had to do with that?:marseyshrug:

Jump in the discussion.

No email address required.

Ah shit, that's right that dude was from Bulgaria, Sorry Hungarians, carry on.

Jump in the discussion.

No email address required.

can you or someone else post :marseymaxrockatansky: the file or link it or somewhere where :marseydrama: you don't need a telegram :marseytelegram: account because telegram :marseytelegram: is a cancer

Jump in the discussion.

No email address required.

There's only a github account listed but there's nothing in it for now: https://github.com/sawarimhacker

:#marseyrain:

welcome back tho queen :marseyxoxo:

scratch that i'm r-slurred:

https://anonfiles.com/tcFdRbG5y8/kreta_src_zip

https://archive.org/details/kreta_src_202211

Jump in the discussion.

No email address required.

thanks :marseyschizochadthankscapylove: :marseylove:

Jump in the discussion.

No email address required.

Are you the one who filmed sucking peepee in a public bathroom and posted it on the original drama site?

Jump in the discussion.

No email address required.

no that was joan :joanmarsey:

Jump in the discussion.

No email address required.

Oh sorry for the wrong accusation

Jump in the discussion.

No email address required.

Wasn't that JWG?

Jump in the discussion.

No email address required.

jc is back :marseyjam:

Jump in the discussion.

No email address required.

:marseylove:

Jump in the discussion.

No email address required.

Just click on preview channel, scroll up and it's there in a .zip.

Jump in the discussion.

No email address required.

if you click it it just :marseyblops2chadcel: goes :marseycoleporter: in a loop

Jump in the discussion.

No email address required.

All non American code looks like this, not even exaggerating. Foreigners are on another planet when it comes to software.

Jump in the discussion.

No email address required.

This is what rightoids fearmonger about foreigners overtaking the west lmao

Jump in the discussion.

No email address required.

Now this is the real New Right schism

Jump in the discussion.

No email address required.

Imagine outing yourself as a nerd by admitting you know what any of this means. I got a code for you, losers:

If (codecel) = loser;

else = chad

Jump in the discussion.

No email address required.

This wouldn't compile you don't fricking idiot.

Jump in the discussion.

No email address required.

I dont care nerd 😎

Jump in the discussion.

No email address required.

if (rdramaUser.equals(codecel)){

rdramaUser = loser;

}else{

rdramaUser=chad;

}

Now go fetch me coffee wagie

Jump in the discussion.

No email address required.

Wish I was a codecel so I could understand this. :marseycry:

Jump in the discussion.

No email address required.

tl;dr someone like you managed to grift the Hungarians selling them "code"

Jump in the discussion.

No email address required.

I just wanted to know why the code is bad. I only know a little python.

Jump in the discussion.

No email address required.

Imagine somebody being able to enter your house if they write "sneed" on a piece of plain paper and slide it into your keyhole(:marseysmirk:), now imagine if your solution is just building a machine that burns the piece of papers that contain "sneed" or "SNEED". Now imagine if somebody could circumvent this by just writing "sNEED". Now imagine if you already had a machine and just had to press a button on it to solve this problem for you. Now imagine that despite this, you decide you build your own shitty machine that doesn't even work at all.

This is the level of code that would be unacceptable from a first day intern. The fact that not only a not-intern codecel wrote it, but another senior codecel approved it is mind boggling. You just type into google "c# sql injection prevention" and you can just basically copy-paste it. A second year CS student could have implemented it in half an hour, the tools are built into the language. It was only safe because nobody would have imagined a software written in 2018 would be vulnerable to this and probably wouldn't even try.

Tax money well spent as usual.

Jump in the discussion.

No email address required.

Oh wow coders quick get in on this! Here's a chance to tell everyone that you're a coder and could do better than this or relate it to some shitty experience from your own life!

Fricking wow. Big deal. You know how to defensively build apps to avoid sql injection but are you getting paid by government money to not do that? Ha. Thought not. So who's really the stupid one?

Jump in the discussion.

No email address required.

No need to be jealous that some RDramatards have a useful skillset.

Jump in the discussion.

No email address required.

I'm sitting here staring at it thinking "what's the big deal? Looks like a pretty good input sanitization function to me :marseythumbsup:".

Jump in the discussion.

No email address required.

It is pretty nonsensical. First it looks for the first " " in the string, and then removes everything after that space. e.g. "testtest testetste" would get turned into "testtest ". then they trim it to "testtest". If they had just removed the +1, they wouldn't have to trim it.

So this function by defaults rejects anything beyond the first space, which is most likely not what would expect from a function called "PreventSQLInjection".

Now because of that it is literally impossible the string would ever contain stuff like " or ", which works in their favor, because they are not even checking for case sensitivity. However you could just use non space whitespace, like \n or \t and it would still work. So so far this hasn't actually done anything.

Then replacing " or " with nothing, is actually a pretty horrible way to handle it, because " o or r " would just get turned into " or ", but again thats irrelevant because it is impossible for there to be a space to begin with.

Then there might be some unicode character that is seen as a ' by the database, but not as a ' by c#

Jump in the discussion.

No email address required.

There really is a lot of layers to the crappiness of this code, lol. The more I look at it the more I can find.

So this function by defaults rejects anything beyond the first space, which is most likely not what would expect from a function called "PreventSQLInjection".

I thought that was a double space, rofl. What were they even trying to do with that?

Jump in the discussion.

No email address required.

  1. Rolling your own function to do this is a bad idea (biggest issue)

  2. Runtime efficiency sucks

  3. Code is not very maintainable (minor concern, however the code is overall rather amateurish)

There would be no better time to use a REGEX. The entire method could be reduced to two lines, and would be faster.

Jump in the discussion.

No email address required.

I'd rather have a few more lines of readable code, than a regex that is a pain in the butt to look at.

Jump in the discussion.

No email address required.

>runtime efficiency

Eh, not really. The .NET CLR optimizes this kind of stuff away.

Jump in the discussion.

No email address required.

  1. just charge more to make it lmao

  2. charge more to run it

  3. charge more to maintain it

sound like wins to me.

2. has the bonus that you can shave off some of the time later if they come to you asking you to make it faster. It's perfect.

Jump in the discussion.

No email address required.

remember put Thread.Sleep randomly in your code :marseycapytrans: so you can just :marseyblops2chadcel2: remove it and give :marseyitsover: multisecond performance boosts

Jump in the discussion.

No email address required.

They're missing UNION, which is pretty common in SQL injection attacks. There are probably others missing, too.

Jump in the discussion.

No email address required.

Sure, and they only have AND and and, not AnD or aNd. But that shouldn't matter if everything is quoted, no?

Jump in the discussion.

No email address required.

Funnily enough all those cases are covered because before searching for disallowed tags they truncate the text to only stuff before the first space (and including that first space for some unfathomable reason) so you're never gonna match " AND " because it literally starts with a space, it's just an extra run through the string at that point that takes up time and does nothing else.

Jump in the discussion.

No email address required.

and they only have AND and and, not AnD or aNd

Lol, I didn't even think of those. This is also another bad code example. The String.Replace() method has a way to toggle case sensitivity, iirc.

But that shouldn't matter if everything is quoted, no?

IF the output has been single-quoted within the code invoking the method. Any dev using this method that forgets to do so has potentially created another vulnerability. From a design standpoint, it's bad (IMO) because it splits the responsibility of security between this method and the dev invoking it. If the dev invoking it had instead just used SqlCommand, it would not only be secure but also involve less code overall. Apparently there's some other shit you can do, too.

All in all, it's a very bad idea to try to scratch-build security if reliable solutions already exist (i.e. not some homebrew solution on a personal GitHub repo).

Jump in the discussion.

No email address required.

The String.Replace() method has a way to toggle case sensitivity, iirc.

Don’t even need to do worry about sensitivity if you just use .toLowerCase(name). So anything put in that input line is always lowercase when being passed in. If you need the first character to be uppercase for output you can format later.

Also Java should have a built in anti sql injection function, like there’s built in hashing in pretty much every backend usable language now, or just regex it yourself.

Jump in the discussion.

No email address required.

Don’t even need to do worry about sensitivity if you just use .toLowerCase(name).

I actually said the same thing in my comment at first but I went back and changed it b/c the method returns the altered user input, which means lowercasing or uppercasing it could return the user input with alterations not intended for sanitation.

Jump in the discussion.

No email address required.

Apparently there's some other shit you can do, too.

The alternative method assumes you replace ' with ''. The OP code just erases it.

Jump in the discussion.

No email address required.

Literally every thread on drama about coding. Me thinks coders only appear competent when commenting on other people's code but the moment they actually have to do any work themselves they all reveal themselves to be drooling r-slurs (except for our lovely admin codecels ofc :marseyworried:)

Jump in the discussion.

No email address required.

Nitpicking code mistakes from the sidelines without context and smugly responding with handwavey "solutions" is one of the basic requirements for being a developer.

Jump in the discussion.

No email address required.

You don’t need context to recognize r-slur code.

Jump in the discussion.

No email address required.

C#? If they'd used Rust, they would be more secure.

(We laugh while using a site that hard codes admin ids)

Jump in the discussion.

No email address required.

They don't salt password hashes either.

Jump in the discussion.

No email address required.

wait what?

Jump in the discussion.

No email address required.

Yeah

Jump in the discussion.

No email address required.

Who tf uses their own “preventsqlinjection” function that is awful

Jump in the discussion.

No email address required.

@Aevann

Please implement this immediately

Jump in the discussion.

No email address required.

we already prevent sql injection

Jump in the discussion.

No email address required.

Yes but this “””method””” is funnier

Jump in the discussion.

No email address required.

it's literally more effort :marseymissing: to do it that way so no we didn't sadly

Jump in the discussion.

No email address required.

yeah but did you implement THIS?

Jump in the discussion.

No email address required.

'; DROP TABLE users; -- take that ;)

Jump in the discussion.

No email address required.

rip

Jump in the discussion.

No email address required.

Jump in the discussion.

No email address required.

Most well written code in EE financed by EU money

Jump in the discussion.

No email address required.

Jump in the discussion.

No email address required.

This is crazy lmao

I can find better code thru chinese github (those chinese devs actually are pretty good tbh)

Jump in the discussion.

No email address required.

True proof that Hungarians are Asian.

Jump in the discussion.

No email address required.

Oh WOW. They had XMLDOC comments. I haven't seem them in ages! Thats some quality code right there!

Jump in the discussion.

No email address required.

All c# has xmldoc comments, most of it is auto generated

Jump in the discussion.

No email address required.

Holy shit that's bad. Wow.

Is this why euro devs are generally paid much less?

Jump in the discussion.

No email address required.

Euros are paid less because the government takes an higher protection fee from their salaries compared to the Land of Freedom

Jump in the discussion.

No email address required.

This is Hungary. They have a considerably lower tax rate than most European countries. Their government is just incompetent.

Jump in the discussion.

No email address required.

This is what happens when a country drives all their programming socks enthusiasts away. SMH :marseydisagree:

Jump in the discussion.

No email address required.

Thats not true lol. Im hungarian and 45% of what my employee pays me gets shafted

They paid 900,00 huf last month and I got 520,000 cash in hand

Jump in the discussion.

No email address required.

:#marseykneel:

I've already been corrected by other RDramatards but you honor me with your reply.

Jump in the discussion.

No email address required.

Yeah, but that's not the only thing that gets deducted from our salaries, the total is around 37%. For Comparison Norway is 46% and they also get functional healthcare for it and not the world highest VAT (27%), while most consumers goods have another 5-10% slapped on top of that for whatever stupid reason the government comes up with.

But at least this year so far our pensioners got their pensions raised 3 times and poors got a lot of gibs for being faithful Fidesz voters, just try not to think about the +22% inflation lib:platysalute:

Jump in the discussion.

No email address required.

Seems similar to how I'm told PiS runs poland, with endless gibs for unemployed moms and pensioners :marseythinkorino:

To think PiS and Fidesz are the ones to bring down the EU lol

Jump in the discussion.

No email address required.

Seems like the play fir a eurodev is to be unemployed and write code that enriches you personally

Jump in the discussion.

No email address required.

Wait aren't you hungarian? Why is your name szechenyi? This is cultural appropriation:marseyraging:

Jump in the discussion.

No email address required.

Darn, didn't mean to hoodwink anyone :marseybeanpensive:

I guess I feel a kindred spirit in Szechenyi, a cautious liberal reformer who saw the revolution abandon him as too hesitant and not radical enough, and then lived long enough to see counter revolution dunk on his country.

Jump in the discussion.

No email address required.

That sounds all good, but we are world leaders in sales tax with 27%

Just imagine that 25 of the 100 sheckels I pay for my morning bagel goes to the government

Jump in the discussion.

No email address required.

Pfft, just eat less.

Jump in the discussion.

No email address required.

Of course Hungary has low taxes, how else would there be room for bribes?

Jump in the discussion.

No email address required.

I hope you're not using "protection" in bad faith because that might give the impression that minorities and marginalised folx need "protection" when it's actually just being a decent human being. If anything those fees need to be raised.

Jump in the discussion.

No email address required.


Link copied to clipboard
Action successful!
Error, please refresh the page and try again.