// ------------------------- <br />// Build Board Query For Shop Mod & Show Funky Names <br /> $query=" <br /> SELECT titleeffectstatus <br /> FROM {$config['tbprefix']}ShopMembers <br /> WHERE uid = '$user[U_Number]' <br /> "; <br /> $stq = $dbh -> do_query($query); <br /> list($titleeffectstatus)= $dbh -> fetch_array($stq); <br /> $query=" <br /> SELECT glowcolor,titleeffect,hexcolor, cstatus, imagesignature, largersignature, avatar <br /> FROM {$config['tbprefix']}ShopMembers,{$config['tbprefix']}Users <br /> WHERE U_Number = '$usernum' && U_Number = uid <br /> "; <br /> $stz = $dbh -> do_query($query); <br /> list($glowcolor, $titleeffect, $hexcolor, $cstatus, $imagesignature, $largersignature, $newavatar)= $dbh -> fetch_array($stz); <br /> <br /> if ($config['sigimage']){ <br /> <br /> if ($Signature) { <br /> $Signature = str_replace("\n","<br />",$Signature); <br /> $Signature = "<br /><br />--------------------<br />$Signature"; <br /> } <br /> if ($ShowSigs == "no" || !$addsig) { <br /> $Signature = ""; <br /> } <br /> } <br /> else{ <br /> if ($imagesignature != 'ON') { <br /> $Signature = preg_replace("/<img src=\"([^\>]*)\">/i","",$Signature); <br /> } <br /> if ($largersignature != 'ON' && $imagesignature == 'ON') { <br /> preg_match("/signature\/[[:alnum:]]{3,40}\.[[:alnum:]]{3,4}/i",$Signature,$matches); <br /> if($matches){ <br /> $Signature = "<img src=\"{$config['imageurl']}/$matches[0]\">"; <br /> } <br /> else{ <br /> $Signature = substr($Signature, 0, $config['Sig_length']); <br /> } <br /> } <br /> elseif ($largersignature != 'ON' && $imagesignature != 'ON') { <br /> $Signature = substr($Signature, 0, $config['Sig_length']); <br /> } <br /> if($Signature){ <br /> $Signature = str_replace("\n","<br />",$Signature); <br /> $Signature = "<br /><br />--------------------<br />$Signature"; <br /> } <br /> } <br />// End Build Board Query For Shop Mod & Show Funky Names <br />// ------------------------- <br /> }