OWA - Open Source Web Analytics WordPress Integration

Featured 1 Response »
Sep 122009

owa_logo_200w

Open Web Analytics (OWA) is an open source web analytics framework written in PHP. OWA was born out of the need for an open source framework that could be used to easily add web analytics features to web sites and applications. The OWA framework also comes with built-in support for popular web applications such as WordPress and MediaWiki. As a generic web analytics framework, OWA can be extended to track and analyze any web application.

Here are a few screens I took of OWA integrated into my WordPress admin panel. I have been using clickheat and piwik, but I may switch to this since it has both click tracking and analytics functions, along with many other features. Check out the screenshots (you’ll have to middle click to open in a new tab until i can find a js img box that works well with massive images):

owa-dashboard
owa-google-geo
owa-click-overlay
Get/Learn more here:

http://wiki.openwebanalytics.com/index.php?title=Main_Page
Posted by fuzion at 5:32 pm Tagged with: , , , ,

Change status of all Wordpress posts with MySQL

Tutorials No Responses »
Sep 022009

Sometimes you just want to archive everything. It’s really easy with a few simple SQL statements. I just used phpMyAdmin but you can do it directly if you want.

Examples:
Change published posts to drafts

UPDATE `wp_posts` SET `post_status` = 'draft' WHERE `post_status` = 'publish'

Inherit

UPDATE `wp_posts` SET `post_status` = 'draft' WHERE `post_status` = 'inherit'

Future(scheduled)

UPDATE `wp_posts` SET `post_status` = 'draft' WHERE `post_status` = 'future'

UPDATE
After setting every post to draft you may want to republish posts containing a certain term:

UPDATE `wp_posts` SET `post_status` = 'publish' WHERE `post_content` LIKE '%searchterm%'
Posted by fuzion at 8:25 pm Tagged with: , ,
Older Entries
© 2010 nukeitdotorg Suffusion WordPress theme by Sayontan Sinha