[Pikok]

Today at 05:10 PM LangTuDaTinh said this in Post #232
u need to add a JOIN queries to the original PM queries for signature too....like the one in the showthread.

I'd thought about that after I posted that last message. I was just gonna look and see what queries needed to be run. Thanks for the help, works great!

I added both parts for the queries and also added the "postbit_signatureimg" template to the required templates. For those of you who don't know exactly what to add where to get the sig image to show in PMs, do the following..


In "root/private.php" do the following 4 things..

Find:

PHP Code:

privfolder,postbit_avatar 


And Replace With:

PHP Code:

privfolder,postbit_avatar,postbit_signatureimg 


Find:

PHP Code:

                                 user.*,userfield.*".iif($avatarenabled,",avatar.avatarpath,customavatar.dateline AS avatardateline,NOT ISNULL(customavatar.avatardata) AS hascustomavatar ","")." 


And Add Below:

PHP Code:

                                 ".iif($signatureenabled,",signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline","")." 


Find:

PHP Code:

                                 ".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                                                        LEFT JOIN customavatar ON customavatar.userid=user.userid ","")." 


And Add Below:

PHP Code:

                                 ".iif ($signatureenabled,"LEFT JOIN signature ON signature.signatureid=user.signatureid
                                                           LEFT JOIN customsignature ON customsignature.userid=user.userid","")." 


Find:

PHP Code:

if ($post[avatarid]!=0) { 
          $avatarurl=$post[avatarpath]; 
        } else { 
          if ($post[hascustomavatar] and $avatarenabled) { 
            $avatarurl="avatar.php?userid=$post[userid]&dateline=$post[avatardateline]"; 
          } else { 
            $avatarurl=""; 
          } 
        } 
        if ($avatarurl=="") { 
    $post[avatar]=""; 
} else { 
    eval("\$post[avatar] = \"".gettemplate("postbit_avatar")."\";"); 
  } 


And Add Below:

PHP Code:

        if ($post[signatureid]!=0) {
            $signatureurl=$post[signaturepath];
        } else {
            if ($post[hascustomsignature] and $signatureenabled) {
                $signatureurl="signature.php?userid=$post[userid]&dateline=$post[signaturedateline]";
            } else {
                $signatureurl="";
            }
        }
        if ($signatureurl=="" or ($bbuserinfo[userid]>0 and !($bbuserinfo[showsignatures]))) {
            $post[signatureimg]="";
        } else {
            eval("\$post[signatureimg] = \"".gettemplate("postbit_signatureimg")."\";");
        } 


Perhaps this should be included in the installation instructions. Thanks again LangTuDaTinh!