Typo3: Count the number of Pages, Content, and Words in your install

May 17, 2010

Ever wonder how many pages, words or tt_content element you have in your Typo3 install? I am working with two large Typo3 sites and I was curious so I wrote a little piece of code. It works really well and is super quick. Here is what the output looks like: Counting Pages SELECT COUNT(uid) AS

New Website Launch: SirGecko

May 3, 2010

The SirGecko development group has been around for years building web-enabled projects, but up until now they have not had their own website. I was asked to build them a site and problem solved. Click the image below to visit the shiny new site.

PHP: Count words in a MySQL column

April 27, 2010

Last week I posted a query that will return the number of words in a column of a table in a MySQL database. I was looking through a huge database and the query took a really really long time. Today I decided to rewrite it in PHP and see if it was faster. Much Much

WP SlimStat 2 Now Available

April 22, 2010

I have long used the WP SlimStat plugin on my WordPress sites to track site usage. Unfortunately the plugin was rather old. Just recently though the author updated the plugin. The new version is beautiful and incorporates a ton more usability. I highly recommend installing this new plugin. WP SlimStat 2

C++ Convert int to char and get ASCII Value

April 22, 2010

If you are wanting the ASCII value for an integer simply do a typecast of the int to a char. int i = 65; cout