October 2012 – Yet Another Programmer's Blog

Quick tip – working with dates with ADODb and MSSQL 2000

October 29, 2012 by blastar·0 Comments

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 . 'adodb.inc.php' ); 
$db = &ADONewConnection( 'mssql'); 
$db->Connect( $myServer, $myUser, $myPass, $myDB ); 
$db->SetFetchMode(ADODB_FETCH_ASSOC); 
$db->fmtDate = "'d/m/Y'";
$db->fmtTimeStamp = "'d/m/Y H:i:s'";

Quick tip – how to get specific posts/page by their ID?

October 27, 2012 by blastar·0 Comments

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/>';
}
wp_reset_postdata();

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 for free (Mac)

October 24, 2012 by blastar·0 Comments

Real Ball (was 6,99USD)

This 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!

Some fresh free apps for ya

October 20, 2012 by blastar·2 Comments

Saving Private Sheep 2 (was 2,99USD)

The 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.