@Arsalan, no offense intended, but I understand very well how SQL works. The point of having an open source product is to allow developers to experiment with what works and learn how the system works through their own experimentation.

All I did was posted a select query. I didn't suggest anyone actually modify the database in any way, I understand that can cause problems (especially for someone who isn't very familiar with how MySQL interacts with PHP, etc. - I think you know by now that this does not apply to a fairly seasoned developer like myself).

Bryce, if you don't feel comfortable running a select query on your own db server, then don't.

@bansh, Please don't do direct sql queries on ossn, there are many reasons behind,

if you just want to run it as a separate SQL query (i.e. not from within the ossn framework, maybe in a shell script or something), you could use: SELECT * FROM ossn_object WHERE subtype="wall" AND DATE("time_created") = CURDATE();

that should get you all wall posts created today, if you want the total number, you can count the # of rows returned.

See

$wall       = new OssnWall;
$posts = $wall->getAllPosts(array(
        'type' => 'user',
        'distinct' => true,
        'wheres' => array('set here sql check for variable o.time_created'),
));