TimArcher.com A blog about technology...and more.

Today I had a very simple need for my Drupal based blog. I needed to get the number of blog entries by user and publication status.

To accomplish this, I put together the query below which will dump out this information showing the username, publication status (0=unpublished, 1=published), and the count of blog posts for that username and publication status combination.

The query is:

SELECT users.name, node.status, count(*) 
FROM node, users 
WHERE type = 'blog' 
AND   node.uid = users.uid 
GROUP BY users.name, node.status
ORDER BY users.name, node.status;

Simply run that query through your MySQL command line prompt, or through a GUI utility such as phpMyAdmin. The output will look something like:

At the University for which I work, we had a need to integrate our Sungard HE Banner ERP system with Barnes and Noble (our outsourced bookstore) to process book vouchers, and with our credit card processing API (Intellipay). Both of these applications required us to post charges and payments directly to the student’s account.

With our Barnes and Noble integration, the process works as such:

1. We send Barnes and Noble a file of how much money the student has in book vouchers, which is equal to the credit amount the student has in their AR file (the TSAAREV screen). Barnes and Noble loads this information into their system.