folders_left.php

<?php
/******************************************************************************
Etano
===============================================================================
File:                       folders_left.php
$Revision$
Software by:                DateMill (http://www.datemill.com)
Copyright by:               DateMill (http://www.datemill.com)
Support at:                 http://www.datemill.com/forum
*******************************************************************************
* See the "docs/licenses/etano.txt" file for license.                         *
******************************************************************************/

$tpl->set_file('left_content','folders_left.html');

$query="SELECT `fk_folder_id`,count(*) FROM `{$dbtable_prefix}user_inbox` WHERE `fk_user_id`='".$_SESSION[_LICENSE_KEY_]['user']['user_id']."' AND `is_read`=0 AND `del`=0 GROUP BY `fk_folder_id`";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
$num_messages=array();
while ($rsrow=mysql_fetch_row($res)) {
	$num_messages[$rsrow[0]]=$rsrow[1];
}

$loopfolders=array();
$i=0;
foreach ($my_folders as $k=>$v) {
	$loopfolders[$i]['fid']=$k;
	$loopfolders[$i]['folder']=$v;
	if (!empty($num_messages[$k])) {
		$loopfolders[$i]['folder'].=' ('.$num_messages[$k].')';
	}
	++$i;
}
$tpl->set_loop('loopfolders',$loopfolders);
$tpl->set_var('tplvars',$tplvars);
$tpl->process('left_content','left_content',TPL_LOOP | TPL_OPTIONAL);
$tpl->drop_loop('loopfolders');
unset($loopfolders);