#!/bin/sh
#
# Prints out some statistics of PIMPPA
#
#

P_USER=pimppa

############################

mysql -u $P_USER --execute="USE pimppa;SELECT area_name, sum(file_size)/(1024*1024) as 'Size in megs' FROM p_files, p_areas WHERE NOT (file_flags & 1) AND file_area=area_id AND NOT (area_flags & 2) GROUP BY area_id;"
