1,249 views

Windows Phone Notification Center (Video)

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select max(ID) as max_id from wp_yarpp_related_cache where reference_ID = 44111

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select distinct ID from wp_yarpp_related_cache where reference_ID = 44111 and ID != 0

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 44111 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (2056,1064,9292,5737,576,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44111' and post_password ='' and post_type = 'post' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 44111 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (2056,1064,9292,5737,576,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44111' and post_password ='' and post_type = 'page' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 44111 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (2056,1064,9292,5737,576,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44111' and post_password ='' and post_type = 'attachment' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) on duplicate key update date = now()

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (44111,0,0) on duplicate key update date = now()

If there is one important feature that is missing in Windows Phone, it has to be a Notification Center. If you have used Windows Phone before, you will realize that once you failed to read the notifications, they will be gone, like forever.

The good people from windowsphonehacker has done something that might solve this problem. As a proof of concept, they had posted a video on how their notification center works.

Here is the video.

In my opinion, Microsoft should have done this long ago. Live tiles are great but having a notification center like the one windowsphonehacker has done, it will be better.

BTW, for the above app to work, it will need a Windows Phone that is developer unlocked.


(source)

Subscribe

Subscribe to our e-mail newsletter to receive updates.

, , , , , , , ,