Yes, it can be really painfull – MSSQL (at least instance I’m using) is saving date in format “d/m/Y H:i:s” but in every part of code I had “Y-m-d H:i:s”. So what now – rewrite everything? Nope, there is ugly but working way to do it, after ADODb object is created and initialized put:

$db->fmtDate = "'d/m/Y'";
$db->fmtTimeStamp = "'d/m/Y H:i:s'";

and that’s it – all dates will be internally converted to given format, so here is full example of config:

define('_ADODB_DIR', '/libs/adodb/'); 
require_once( _ADODB_DIR . '' ); 
$db = &ADONewConnection( 'mssql'); 
$db->Connect( $myServer, $myUser, $myPass, $myDB ); 
$db->fmtDate = "'d/m/Y'";
$db->fmtTimeStamp = "'d/m/Y H:i:s'";

At first look it was simple, just:

$args = array("post__in" => array(1,2,3));
$posts = new WP_Query();
$posts -> query($args);
while ($posts -> have_posts()){
$posts -> the_post(); 
	echo the_title().'<br/>';

but, this way we can get ONLY posts, not pages. To get both posts AND pages just add:

'post_type'=>array('page', 'post')

in WP_Query arguments list so it will look like this:

$args = array("post__in" => array(1,2,3), 'post_type'=>array('page', 'post'));

And voila – we have both content types.

Real Ball (was 6,99USD)
Real Ball 2.0This is an original breakout game, which is made in an unusual space style. The game field is full of iron multicolored bricks. Your aim is to shatter them all, row after row, using 29 unique power-ups. Your pad is supplied with a turbojet engine, which allows you to move as fast as possible, catching all fire bonuses and collecting crystals. On top of the game field, there are some functioning rocket towers, shooting off left-over bricks. Have fun in this military style match!

Saving Private Sheep 2 (was 2,99USD)
Saving Private Sheep 2The war is over.
After fierce combat, those damned wolves have gone back home with their tails between their legs…
The sheep can graze once again with great delight and plenty of new wool!
But let’s not forget the foxes, those nasty creatures that have come to kidnap the poor, innocent little sheep…
Fortunately, General Sheepard is there to keep an eye on the sheepfold.
Armed with a catapult and a hedgehog, the leading military figure in the entire flock dispatches a small commando team to restore peace in the pastures.

Continue reading

iDocs Pro for Google Docs™ and Google Drive™
iDocs Pro for Google Docs™ and Google Drive™iDocs: the most intuitive and robust app for managing Google Docs and Google Drive on the iPhone. Create, edit, share and view your Google documents with an easy-to-use and intuitive interface. From creating spreadsheets to live-editing text documents, iDocs Pro gives you a direct line to the full Google Docs suite.

Continue reading

Cursive Writing HD (was 0,99USD)
Cursive Writing HD “Cursive Writing HD” is an useful application for all ages who are taking their first step into learning cursive writing.
This app is very easy and fun to use.
It provides not only letter by letter but 234 words, which show the users how individual(lower and upper case) letters are combined into words and sentences.
If you are looking for a cursive writing app, then look no further.

Continue reading

Chicken Revolution2 : Zombie (was 0,99USD)
Chicken Revolution2 : Zombie Chicken Revolution: Zombies is a defense game to keep the base camp from zombie chickens, joining humanity and chickens.The long war of humanity and chickens connected by Chicken Revolution ends with the advent of the zombie chickens. Zombie chickens that appeared suddenly attack and infect all living things including humanity and chickens. People and chickens managed to survive cooperate with each other for survival…

Continue reading

Only today so hurry up!

CarmageddonCarmageddon is the original freeform driving sensation, where pedestrians (and cows!) equal points, and your opponents are a bunch of crazies in a twisted mix of automotive killing machines. The game features anarchic drive-wherever-you-like gameplay and over-the-top surreal comedy violence. It’s the racing game where racing is for wimps.

Priority Matrix (was 2,99USD)
Priority Matrix Priority Matrix helps you overcome information overload… When you have many responsibilities, it can be very challenging to know where to spend your time and effort — Priority Matrix is an insanely easy to use tool to help you balance work and life. You will *always know what to work on* Today, Tomorrow, This Week through the Master List that summarizes all your projects — and tell you your most critical and urgent tasks. Priority Matrix helps you focus on your priorities through the “4-quadrant method”, a natural way to categorize your tasks and ideas. Get it today.

Continue reading