Something is wrong in this picture here. Why do you feel the sudden urge to reinvent the wheel?

Naive SQL injections are closed once and for all if you use prepared statements. You can do it in PHP with mysqli_prepare, pg_prepare, ibase_prepare, etc.

I see what you mean there, but those are functions for MySQLi, PostGreSQL and IBase.
What I'm doing here is basically using the default MySql function.
But then again, my sole purpose is to let people realise that their website is leaking.

Allright, I wrote this little snippet to prevent mysql injection.
And then I thought of the fact that alot of websites are still sensitive to mysql-injection, hence I came on the idea of sharing this script.
<?php

function sql_query($query, $variables)
{
//Take the query, and replace the contained variables
//Query should contain [WHERE]
if ( !preg_match(&#39;[WHERE]&#39;, $query) )
{
die();
}
else
{
$parms = Array();
foreach( $variables as $name => $variable )
{
$parms[] = "`".$name."` = &#39;".mysql_real_escape_string($variable)."&#39;";
}
//Merge parameters
$parameters = implode(&#39; AND &#39;, $parms);
//Prepare the query
$query2 = str_replace(&#39;[WHERE]&#39;, &#39;WHERE &#39;.$parameters, $query);
return mysql_query($query2);
}
}

?>

And the usage:
<?php

include(&#39;./sql_query.php&#39;); //Or any way to implement the function.

$query = sql_query(&#39;SELECT * FROM `table` [WHERE]&#39;, Array(
"field1" => $_POST[&#39;username&#39;],
"field2" => &#39;value&#39;
));

?>

In the array, the key name is the field name in SQL.
Then the value in the array is the one that should be found.
For now, I do not support the OR attribute, and I never use that one personally xD

Hello Guys,

I was planning to post this for a while, but I found I simply didn't have the time to do so.
So well, here goes:

A few months/weeks earlier I created a topic concerning I was going to be absent for a 2/3 weeks due to my exams/vacation.
Usually, after every vacation, my urge to program games returns because I still have a project to finish.
This time was no difference.

So after my vacation, I resumed my zelda project, still having some bugs to fix in the engine I had so far and stuff.
Basically, I started by creating a backup of the entire project by creating a group.
However, the downside of creating a group is that all of the files have to be in RAM.
As some of you might know, OS 2.53MP is a little unstable, and that fact hit me at right the wrong moment.
I had a ramclear during the grouping, losing all graphics and a major part of the engine.
Since then, I did not have the urge to pick up the game again.

I might pick the project up again someday, but so far, my priorities have been blocking me.
Such as,
there are new exams coming up (yes, again).
I recently got into a relationship, which I have to maintain, which is also a big priority for me

So basically, as things look now. I will not continue any major projects on the calculator anymore for a while.
I might release some small games, but nothing really big.

I hope you guys will understand this, and I really do regret the fact that I can not contribute to the community.

I will try to remain active here, but I won't make any promises...

Yours, Ikkerens

I'm not a pixel artist, but it might be useful if you give some more details.
Such as, in what theme does it have to be? What ornaments do you want? Is it dark/light etc?

These suck. Don't use them.

LOL, they look good imho.

Well, in a case where a developer already has all 10 pictures in use, and stores them in programs.
But still, a way to restructure any pic on runtime would be really useful.

Well, the banner showing my love for w3c
And I have put some basic stuff such as my projects/nerdtest/internetz in spoilers so that my sig doesn't get too large.