L'aquarium de JMV

Reply to: pmBOX and dpStaffStatus 2.1

[quote=anykiller]Hi, vedrine. Sorry for my english (you know that I'm spanish)

I'm editying the pntemplates/plugins/function.getmessages.php on dpStaffStatus 2.1. I discover that on the count of the total of messages (in the block), it counts the outbox messages of the submitter and my inbox messages.

I include the code here:

[code=php]<?php

function smarty_function_getmessages($params, &$smarty) 
{
	extract($params); 
	unset($params);

if(!isset($uid) || !is_numeric($uid)) {
		return false;
	}
	if( pnModAvailable('pmBOX') ) {
		// Base de datos
      list($dbconn) = pnDBGetConn();
      pnModDBInfoLoad('pmBOX', 'pmBOX');
      $pntable = pnDBGetTables();
      $MsgTabla = $pntable['pmbox'];
      $MsgColumn = &$pntable['pmbox_column'];
      $sql1 = "SELECT count(*) FROM $MsgTabla WHERE $MsgColumn[msg_type] ='1' and $MsgColumn[read_msg] ='0' and $MsgColumn[to_userid]=".pnVarPrepForStore($uid);
        $result = $dbconn->Execute($sql1);
         if ($dbconn->ErrorNo() != 0) { return $content; }        
         list($SinLeer) = $result->fields;
      $result->Close();
        
     $sql1 = "SELECT count(*) FROM $MsgTabla WHERE $MsgColumn[msg_type] ='1' and $MsgColumn[to_userid]=" . pnVarPrepForStore($uid);            
        $result = $dbconn->Execute($sql1);
        if ($dbconn->ErrorNo() != 0) { return $content; }                      
        list($total) = $result->fields; 
  
  		$sql = "SELECT COUNT(*) 
				FROM $MsgTabla 
				WHERE $MsgColumn[to_userid]='".(int)pnVarPrepForStore($uid)."'";			   
	   	$result = $dbconn->Execute($sql);
    	list($total) = $result->fields;                
   	    $result->Close();				
	} else {
		$SinLeer = 0;
		$total = 0;
	}
	$url_inbox_unread = pnModURL('pmBOX');		
	$url_inbox_total = pnModURL('pmBOX');
	$msg = array('unread' => $SinLeer, 
				 'total' => $total, 
				 'url_inbox_unread' => $url_inbox_unread, 
				 'url_inbox_total' => $url_inbox_total);

if (isset($assign)) {
        $smarty->assign($assign, $msg);
	} else {
        return $msg;
	}
}
?>[/code]

I don't know now how to solve that.

Thanks<em>edited by: anykiller, Oct 24, 2005 - 04:59 PM</em> [/quote]