Topic:	Anyone know how to modify this?
starteck2002 Noob Posts: 4 Posted: Aug 29, 2005	Code // make sure the user is logged in if (pnUserloggedin()){ // pre .750 connection // list($dbconn) = pnDBGetConn(); //////////////////////////////////////// // 750+ connection $dbconn =& pnDBGetConn(true); $pntable =& pnDBGetTables(); //////////////////////////////////////// $pntable = pnDBGetTables(); $column = &$pntable['priv_msgs_column']; $result = $dbconn->Execute("SELECT count(*) FROM $pntable[priv_msgs] WHERE $column[read_msg] ='0' and $column[to_userid]='".pnUserGetVar('uid')."'"); list($unread) = $result->fields; if($unread >=1){ echo '<img src="path/to/flashing/image.gif" />'; } } This bit of code will display a gif image if there is any unread PM's. I purchased PMBOX Messenger from PortalZine and this code does not work for that (looks at wrong tables). Alex (of PortalZine) has not been around for a while due to illness so I can't ask him and to add to that he has encoded his block with ioncube so i can't look at that either Anyone have any ideas? I can give full access to my site for anyone who is interested in getting this working. TIA, Dave
Chestnut Site Admin Posts: 1320 Posted: Aug 29, 2005	Little clean up first Code // make sure the user is logged in if (pnUserloggedin()) { // if code must look in a 3rd party, make sure the module tables are loaded // pnModDBInfoLoad('pmBOX'); $dbconn =& pnDBGetConn(true); $pntable =& pnDBGetTables(); $tbl = $pntable['priv_msgs']; $column = &$pntable['priv_msgs_column']; $result = $dbconn->Execute("SELECT count(*) FROM $tbl WHERE $column[read_msg] = '0' AND $column[to_userid] = '".pnUserGetVar('uid')."'"); list($unread) = $result->fields; if($unread >=1){ echo '<img src="path/to/flashing/image.gif" />'; } } Now I modified the table call to give you a more easy way to change the table the code must look in : Code $tbl = $pntable['priv_msgs']; And I added the pnModDBInfoLoad that you will probably need if you are getting the tables of the pmBOX instead of the original ones. Just remove the // in front of it. Lastly, remember to change the "pathto/flashing/image....." :wink: Chestnut ! Site Admin
starteck2002 Noob Posts: 4 Posted: Aug 30, 2005	I must be doing something wronmg I've changed the tables, added a bit to show the number of messages as well as the graphic but it's still not working. I've attached a screen grab of the DB. I suppose it might help if I actually understood what I was doing. Thanks very much for your help so far Frank Code // make sure the user is logged in if (pnUserloggedin()) { // if code must look in a 3rd party, make sure the module tables are loaded pnModDBInfoLoad('pmBOX'); $dbconn =& pnDBGetConn(true); $pntable =& pnDBGetTables(); $tbl = $pntable['pn_messenger']; $column = &$pntable['pn_read_msg']; $result = $dbconn->Execute("SELECT count(*) FROM $tbl WHERE $column[read_msg] = '0' AND $column[to_userid] = '".pnUserGetVar('uid')."'"); list($unread) = $result->fields; if($unread >=1){ echo '<img src="path/to/flashing/image.gif" />'; echo 'Unread Messages:'+'$unread'; } }
Chestnut Site Admin Posts: 1320 Posted: Aug 30, 2005	Variables are not parsed between single quotes : Code if($unread >=1){ echo '<img src="path/to/flashing/image.gif" />'; } echo 'Unread Messages: '.$unread; And lastly, it is better to check if you have an sql error... Code $result = $dbconn->Execute("SELECT count(*) FROM $tbl WHERE $column[read_msg] = '0' AND $column[to_userid] = '".pnUserGetVar('uid')."'"); if ($dbconn->ErrorNo() != 0) { echo $dbconn->ErrorMsg(); } As for the rest................ :?: By the way... only to put that question away... I hope for you that you have at least 1 unread message because if not... :wink: Chestnut ! Site Admin
Chestnut Site Admin Posts: 1320 Posted: Aug 30, 2005	aw dammit....... Code $tbl = $pntable['pn_messenger']; $column = &$pntable['pn_read_msg']; SIGH !!!! SO WRONG !!!!!!! Should be : Code $tbl = &$pntable['messenger']; $column = &$pntable['messenger_column']; Chestnut ! Site Admin
starteck2002 Noob Posts: 4 Posted: Aug 30, 2005	yes, there is at least one unread message I'll give this a go tonight and see if it works. This is all because I designed a theme and it requires the number of unread pm's to be displayed - i thought it was a really easy task Anyone heard any news about Alex (PortalZine)? Hope he's ok.
starteck2002 Noob Posts: 4 Posted: Aug 30, 2005	Code // make sure the user is logged in if (pnUserloggedin()) { // if code must look in a 3rd party, make sure the module tables are loaded pnModDBInfoLoad('Messenger'); $dbconn =& pnDBGetConn(true); $pntable =& pnDBGetTables(); $tbl = $pntable['messenger']; $column = &$pntable['messenger_column']; $result = $dbconn->Execute("SELECT count(*) FROM $tbl WHERE $column[read_msg] = '0' AND $column[to_userid] = '".pnUserGetVar('uid')."'"); // if ($dbconn->ErrorNo() != 0) { // echo $dbconn->ErrorMsg(); // } list($unread) = $result->fields; if($unread >=1){ echo '<img src="path/to/flashing/image.gif" />'; } echo 'Unread Messages: '.$unread; } This is now working but shows all messages, not just unread messages. Any ideas on what to do next? Thanks for your help, Dave EDIT : Code tag, code tag, code tag, code tag....
Chestnut Site Admin Posts: 1320 Posted: Aug 30, 2005	mmm... I don't see much... The where is there. Chestnut ! Site Admin

Topic:

Anyone know how to modify this?

starteck2002

Noob

Posts: 4

Posted:
Aug 29, 2005

Code// make sure the user is logged in 
if &#40;pnUserloggedin()){ 
// pre .750 connection 
// list($dbconn) = pnDBGetConn(); 
//////////////////////////////////////// 
// 750+ connection 
$dbconn =& pnDBGetConn&#40;true); 
$pntable =& pnDBGetTables&#40;); 
//////////////////////////////////////// 
$pntable = pnDBGetTables&#40;); 
$column = &$pntable&#91;'priv_msgs_column']; 
$result = $dbconn->Execute&#40;"SELECT count(*) FROM $pntable[priv_msgs] WHERE $column[read_msg] ='0' and $column[to_userid]='".pnUserGetVar('uid')."'"); 
list&#40;$unread) = $result->fields; 
if&#40;$unread >=1){  
echo '<img src="path/to/flashing/image.gif" />'; 
 &#125; 
&#125; 
 

This bit of code will display a gif image if there is any unread PM's. I purchased PMBOX Messenger from PortalZine and this code does not work for that (looks at wrong tables). Alex (of PortalZine) has not been around for a while due to illness so I can't ask him and to add to that he has encoded his block with ioncube so i can't look at that either icon_frown

Anyone have any ideas?

I can give full access to my site for anyone who is interested in getting this working.

TIA, Dave

Chestnut

Site Admin
Posts: 1320

Posted:
Aug 29, 2005

Little clean up first

Code// make sure the user is logged in
if &#40;pnUserloggedin()) {
 
    // if code must look in a 3rd party, make sure the module tables are loaded
 
    // pnModDBInfoLoad('pmBOX');
 
    $dbconn  =& pnDBGetConn&#40;true);
    $pntable =& pnDBGetTables&#40;);
 
    $tbl    = $pntable&#91;'priv_msgs'];
    $column = &$pntable&#91;'priv_msgs_column'];
    
    $result = $dbconn->Execute&#40;"SELECT count(*)
                                FROM   $tbl
                                WHERE  $column&#91;read_msg]  = '0'
                                AND    $column&#91;to_userid] = '".pnUserGetVar('uid')."'");
                                
    list&#40;$unread) = $result->fields;
    
    if&#40;$unread >=1){ 
        echo '<img src="path/to/flashing/image.gif" />';
    &#125;
    
&#125; 
 

Now I modified the table call to give you a more easy way to change the table the code must look in :

Code$tbl    = $pntable&#91;'priv_msgs']; 
 

And I added the pnModDBInfoLoad that you will probably need if you are getting the tables of the pmBOX instead of the original ones. Just remove the // in front of it.

Lastly, remember to change the "pathto/flashing/image....."
:wink:

Chestnut ! Cool

Site Admin

starteck2002

Noob

Posts: 4

Posted:
Aug 30, 2005

I must be doing something wronmg icon_frown

I've changed the tables, added a bit to show the number of messages as well as the graphic but it's still not working. I've attached a screen grab of the DB. I suppose it might help if I actually understood what I was doing. Thanks very much for your help so far Frank icon_smile

Code// make sure the user is logged in 
if &#40;pnUserloggedin()) { 
 
    // if code must look in a 3rd party, make sure the module tables are loaded 
 
    pnModDBInfoLoad&#40;'pmBOX'); 
 
    $dbconn  =& pnDBGetConn&#40;true); 
    $pntable =& pnDBGetTables&#40;); 
 
    $tbl    = $pntable&#91;'pn_messenger']; 
    $column = &$pntable&#91;'pn_read_msg']; 
    
    $result = $dbconn->Execute&#40;"SELECT count(*) 
                                FROM   $tbl 
                                WHERE  $column&#91;read_msg]  = '0' 
                                AND    $column&#91;to_userid] = '".pnUserGetVar('uid')."'"); 
                                
    list&#40;$unread) = $result->fields; 
    
    if&#40;$unread >=1){ 
        echo '<img src="path/to/flashing/image.gif" />'; 
        echo 'Unread Messages:'+'$unread';
    &#125; 
    
&#125; 
 

Chestnut

Site Admin
Posts: 1320

Posted:
Aug 30, 2005

Variables are not parsed between single quotes :

Codeif&#40;$unread >=1){
        echo '<img src="path/to/flashing/image.gif" />';
    &#125;
    echo 'Unread Messages: '.$unread; 

And lastly, it is better to check if you have an sql error...

Code$result = $dbconn->Execute&#40;"SELECT count(*)
                                FROM   $tbl
                                WHERE  $column&#91;read_msg]  = '0'
                                AND    $column&#91;to_userid] = '".pnUserGetVar('uid')."'"); 
 
    if &#40;$dbconn->ErrorNo() != 0) {
        echo $dbconn->ErrorMsg&#40;);
    &#125; 
 

As for the rest................ :?:

By the way... only to put that question away... I hope for you that you have at least 1 unread message because if not... :wink:

Chestnut ! Cool

Site Admin

Chestnut

Site Admin
Posts: 1320

Posted:
Aug 30, 2005

aw dammit.......

Code$tbl    = $pntable&#91;'pn_messenger'];
    $column = &$pntable&#91;'pn_read_msg']; 
 

SIGH !!!! SO WRONG !!!!!!! icon_lol

Should be :

Code$tbl    = &$pntable&#91;'messenger'];
    $column = &$pntable&#91;'messenger_column']; 
 

Chestnut ! Cool

Site Admin

starteck2002

Noob

Posts: 4

Posted:
Aug 30, 2005

yes, there is at least one unread message icon_wink

I'll give this a go tonight and see if it works. This is all because I designed a theme and it requires the number of unread pm's to be displayed - i thought it was a really easy task icon_frown

Anyone heard any news about Alex (PortalZine)? Hope he's ok.

starteck2002

Noob

Posts: 4

Posted:
Aug 30, 2005

Code// make sure the user is logged in 
if &#40;pnUserloggedin()) { 
 
    // if code must look in a 3rd party, make sure the module tables are loaded 
 
    pnModDBInfoLoad&#40;'Messenger'); 
 
    $dbconn  =& pnDBGetConn&#40;true); 
    $pntable =& pnDBGetTables&#40;); 
 
    $tbl    = $pntable&#91;'messenger']; 
    $column = &$pntable&#91;'messenger_column']; 
    
    $result = $dbconn->Execute&#40;"SELECT count(*) 
                                FROM   $tbl 
                                WHERE  $column&#91;read_msg]  = '0' 
                                AND    $column&#91;to_userid] = '".pnUserGetVar('uid')."'"); 
                                
    
 
// if ($dbconn->ErrorNo() != 0) { 
//        echo $dbconn->ErrorMsg(); 
//    }
 
     list&#40;$unread) = $result->fields; 
    
    if&#40;$unread >=1){ 
        echo '<img src="path/to/flashing/image.gif" />';
         
    &#125; 
  echo 'Unread Messages: '.$unread;  
&#125; 
 

This is now working but shows all messages, not just unread messages. Any ideas on what to do next?

Thanks for your help,

Dave

EDIT : Code tag, code tag, code tag, code tag....

Chestnut

Site Admin
Posts: 1320

Posted:
Aug 30, 2005

mmm... I don't see much...

The where is there.

Chestnut ! Cool

Site Admin