MySQL Global Vars wait_timeout & max_connections

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/37/mysql-global-vars-wait-timeout-max-connections

MySQL Relationships & Foreign Keys

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/36/mysql-relationships-foreign-keys

HOW TO HANDLE TWITTER SPAMMERS

The problem with Twitter is that you never know whether someone is a spammer with malicious links or if they're a genuine person. While you can read their profile and work it out, this is generally too time consuming especially when my you get on average 3 spammers following you an hour! My Interstellar Workshop twitter account got 6 spamtarts following it within the first few hours!

I propose an Up/Down vote reputation system for Twitter profiles, this could also be used on other non-twitter platforms too. The users would be able to up/down vote a profile, such as up voting Evil Wil Wheaton and down voting spamtarts. Then you could flag the spam tarts, if they have 1) added lots of people recently and 2) have a low reputation, you could suspend them and require they do some verification steps, which the bots wont do!

View post at my website: HOW TO HANDLE TWITTER SPAMMERS

Personal Website update

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/35/personal-website-update

Collaborate: Redirecting to same Page ASP.NET

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/34/collaborate-redirecting-to-same-page-asp-net

XNA An Example Object using VariableService

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/33/xna-an-example-object-using-variableservice

Alternative to Game Screen Management - An Example

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/32/alternative-to-game-screen-management-an-example

XNA IScreen code

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/31/xna-iscreen-code

It has been a while

It's been a while since I last posted, I have now moved out into my own apartment which is awesome and have been really busy with one thing and another.

I have finally got an ant colony going and you can follow the progress of that here:
Lasius Niger Journal

I have also been working on a few things such as a simulation for an ant colony (very hard trying to code ants to find water/food/build nests etc!) as well as some Google Plus stuff, but I am going to wait for the API to be honest!

Nothing much else to report..

Until next time!

Google NoFollow Test

I am wondering if Google does actually follow NoFollow links, and if they do have any bearing whatsoever on certain keywords.

So I have generated some random strings that Google will only be able to index IF it has followed no follow links!

These following links are to give Google the initial push, if it follows any deeper, it's breaking the law, break breaking the law!

Jz5jFqWnE3rwUVGnOp2y

cQwHXN5CvWKnBKDV3tBx

Go go Google!

No definition found for Table yahoo.finance.quotes

This blog post has moved with this blog, being a very important post though, I have made sure that the solution has remained intact. Sorry for the extra click!

http://www.adamkdean.co.uk/blog/read/29/no-definition-found-for-table-yahoo-finance-quotes

WASD Control for R/C Car using Arduino

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/30/wasd-control-for-r-c-car-using-arduino

How I love previously coded code

I'm currently writing more software, and every time I have to do something which makes me sit back and think "hmm..now how is best to do this", I remember I've already been here before, and thanks to my magpie like abilities tendencies, I've got all the code ready for consumption.

So, dear past me, thank you for all the code you've written, you're helping make my tomorrow just that little bit easy. Thank you for your session handler class and for your listview sorting methods and for all the time you spent on SQL.

Regards,
Present Me

Cobweb Mould

I feel there is quite a lack of photos on the net for cobweb mould, so I'm just going to SEO tag these images so that they appear in google images, and hopefully give people an idea of what to expect. They are from when I grew some cress seeds under an array of red, blue, UV and IR leds, without a fan to circulate the air, the moisture and warmth meant this mould sprung up within a few days. Usually, this is limited to people growing magic mushrooms, I'm sure lol, so maybe it was the simulated blue moonlight that did it..









There you go, Googleimgs!

Excel Formula - Nice Currency!

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/28/excel-formula-nice-currency

MySql Version "Correlated Sub-Queries and Group By Unions"

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/27/mysql-version-correlated-sub-queries-and-group-by-unions

New String.Format for C - strrep2

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/26/new-string-format-for-c-strrep2

Uri to Hostname in C (GNU-C99)

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/25/uri-to-hostname-in-c-gnu-c99

Fixed String.Format in C (GNU-C99)

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/24/fixed-string-format-in-c-gnu-c99

C# Int.ToString().Length in C

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/23/c-int-tostring-length-in-c

Replicating c# params keyword in C (GNU-C99)

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/22/replicating-c-params-keyword-in-c-gnu-c99

How Do I Save A Link? Easy!

For the first time in a long time, I've decided to pull an all nighter coding. Before I got a "real job", it was no biggie, but now it's not that easy to do, what with that real job and everything. But after I decided to re-write my node server for my upcoming latency project in C99, from C#, I needed a stretch of time where I wouldn't be disturbed. And so here I am.

But unfortunately, my own ingeniousity interrupted me, and so I gave birth to www.howdoisavealink.com ..with the help of my good friend @Orbixx (Ricky Burgin) of course, he now appears as the favicon!

How often do you want to download a streamable file that someone has linked to you, without your browser downloading it? How often do you have to create a html file with an anchor in it? What if you don't have wget on your fancy windows home pc?

Well now you don't have to.

Enjoy, I will.

SQL Correlated Sub-Queries and Group By Unions

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/21/sql-correlated-sub-queries-and-group-by-unions

SQL Get most recent records with group by

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/20/sql-get-most-recent-records-with-group-by