When you're generating queries from resultsets of other queries ...

I just hit a point in an app I am currently developing, where I found myself generating queries from the resultset of another query. Because, what can possibly go wrong, right? $selectors = array(); $query_phase2 = "SHOW KEYS FROM `".$row['table']."` WHERE Key_name = 'PRIMARY'"; $query_phase3 = "select `".$row['field']."` from `".$row['table']."` where "; if($result = $GLOBALS['dbconn']->query($query_phase2)) { while ($row = $result->fetch_assoc()) { if(array_key_exists($row['Column_name'], $data)) { $qextender = "`".$row['Column_name']."` = '".$data[$row['Column_name']]."'"; array_push($selectors,$qextender); } } $query_phase3 ....

2015-07-16 · 1 min · 121 words · Jan

DDoS and Online Gaming

I just stumbled across an enormous outcry about another attack by the “LizardSquad” against DBG’s (former SOE) Games that were allegedly the outcome of a few angry posts on Twitter by DBG’s CEO John Smedley. (Storylink) Along with the usual “fixit fixit fixit” there was also a lot of guesses thrown out about the size of the genitals of a 14-year old fin. What startled me though is the sheer lack of knowledge when it comes to the gamers themselves....

2015-07-10 · 4 min · 822 words · Jan

The day perl became a bit disgusting or why PHP got the better CGI enviroment

I just viewed a very nice #31c3 talk about a well known issue with certain functions within two very widely used perl-modules (DBI & CGI). When I heard the arguments brought to the presenter from the audience within the Q&A, I thought to myself, well, they’re right. All of these attack vectors are in theory something that could have been prevented by just flatten arguments (as you always should). Then again, this makes for a really, really messy programming style that does not come easy if you were programming any other programming language prior to perl....

2014-12-30 · 3 min · 464 words · Jan

Installing JAVA JDK/JRE on Debian/Ubuntu with ease

I recently commenced the third installation of JAVA on one of my Debian-Boxes and couldn’t remember any of the exact commands, had to google again, ended up with 8 open tabs all saying something different and so wrote this small bash script to set up all necessary alternatives with “update-alternatives” automatically. Please note that there has to be either icedtea or openjdk installed to make all parts of this script work....

2013-08-13 · 2 min · 260 words · Jan

Truth and Lies about Big Data

I recently got certified with cloudera (CCAH) and found myself the only one in class who really uses Hadoop. I often stumble upon people trying to sell Big Data appliances to brand owners “to store and monitor their social network XXX” where XXX may be replaced by any word that tickles or frightens brand owners. My personal opinion is, if you are a brand owner or not, doesn’t matter, data matters....

2013-04-17 · 2 min · 416 words · Jan