WP - Get current page number for current (single) post inc. CPTs

gistfile1.aw

/* GET CURRENT PAGE NUMBER FOR THIS SINGLE POST ie. it's index number */
// put in functions.php
// Note: edit "my-custom-post-type" or remove "AND post_type = 'my-custom-post-type'"
function current_post_num($display=true) {
	global $post, $wpdb;
	//$rows = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_status = 'publish' ORDER BY post_date ASC");
	$SQL = $wpdb->get_col("SELECT ID FROM $wpdb->posts posts WHERE posts.post_status = 'publish' AND post_type = 'my-custom-post-type' ORDER BY post_date ASC");
	$SQL = array_flip($SQL);
	$postnum = $SQL[$post->ID];
	$postnum++;
	if($display) {
		echo $postnum;
	}
	return $postnum;
}

// Usage
<?php current_post_num(); ?>