 |
 |
 |
 |
#281138 - 03/03/05 07:53 PM
Re: Finished-[6.4-6.5] Feature Shop 1.6
[Re: DMClark]
|
Old Hand
Registered: 10/17/03
Posts: 2409
Loc: Richmond, VA
|
okay the problem is you are allowing html in the signature.. so you cannot use the signature part as this is written.. you will need to disbale the signature stuff in the shop and in showflat.php change <br /> <br /> // ------------------------- <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 /> } <br /> <br /> <br />to <br /> <br /> <br /> <br />// ------------------------- <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 />// End Build Board Query For Shop Mod & Show Funky Names <br />// ------------------------- <br /> <br /> <br /> <br />in the showflat.php that will set it back to the stock except for the signature
Edited by scroungr (03/03/05 07:57 PM)
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#281141 - 03/06/05 01:44 PM
Re: Finished-[6.4-6.5] Feature Shop 1.6
[Re: 234234]
|
Code Monkey
Registered: 06/17/02
Posts: 682
Loc: CA, USA
|
I've just installed this and I have some issues/questions:<br />What all do I need to do to make this work? I have turned off the display name changes and images in the signature. What do I have to do for the reset signature and the larger signature items to work?<br /><br />Also, I'm having issues with the templates:<br />It looks ok here, but it's not:<br /> http://www.laondalatina.com/foros/shop.php<br />Because on the rest of the site, I have a vertical bar on the right where I plan to add content:<br /> http://www.laondalatina.com/foros/<br />I believe there is an issue with missing table tags.<br />Here it gets hairy:<br /> http://www.laondalatina.com/foros/shopcategory.php?Cat=&cid=1<br />Probably another template issue.<br /><br />Finally, when I go to the Shop Admin area, nothing happens when I click on Categories, Items, Add Points, Show User Stats. It keeps bringing me back to the settings screen.<br /><br />Any suggestions?
_________________________
Too many men. There's too many people making too many problems, and not much love to go around. Can't you see this is the Land of Confusion? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#281146 - 03/09/05 11:24 AM
Re: Finished-[6.4-6.5] Feature Shop 1.6
[Re: 234234]
|
Code Monkey
Registered: 06/17/02
Posts: 682
Loc: CA, USA
|
[]scroungr said:<br />Hmmm I see this error<br /><br />SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY displayorder, catname' at line 4<br />SQL Error #: 1064<br />Query: SELECT * FROM w3t_ShopCats WHERE cid='0' AND (status = 'on' || owner = ) ORDER BY displayorder, catname <br /><br />and you can't have the new files if your still getting that error cause I fixed it? [/]<br /><br />What script did you see that error on? I don't see it. Another problem I've noticed is that when I click on Bank, it tells me how many points I have. Though when I click on any of the links on that page (Finances, Credit, Debit, Send Points) the URL changes, but the actual content on the page doesn't. Every link takes me nowhere, or better put, I stay at the page that says how many points I have.
_________________________
Too many men. There's too many people making too many problems, and not much love to go around. Can't you see this is the Land of Confusion? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />
|
|
Top
|
|
|
|
|
|
|
|
|
|
Previous Topic
Index