UBB.Dev
Posted By: scroungr Finished-[6.5] Feature Shop 1.7 - 10/23/2004 9:06 AM
Mod Name / Version: Feature Shop 1.7

Description: Are you ever not around when Someone needs a Title Changed or Their Name Changed or Anything else that requires your presence as Admin? Ever wanna Hold Auctions and Offer things up for Sale? Well Here it is.. The UBB Threads 6.5 Shop..

Working Under: UBB.Threads 6.5

Mod Status: Finished

Any pre-requisites: Ubb THreads 6.5

Author(s): scroungr

Date: 10/22/04

Credits:

Files Altered: /ubbthreads/languages/english/online.php, /ubbthreads/languages/english/showflat.php, /ubbthreads/languages/english/showthreaded.php, /ubbthreads/languages/english/editdisplay.php, addpost.php, adduser.php, dopoll.php, showthreaded.php, showflat.php, changedisplay.php, deletepost.php, changebasic.php, /ubbthreads/templates/default/showthreaded.tmpl, /ubbthreads/templates/default/showflat.tmpl, /ubbthreads/templates/default/editdisplay.tmpl


If using IIP in the shoutaddpal.php


New Files: Shop Language Files, Shop Template Files, Shop PHP Files

Database Altered: YES

Info/Instructions:
Detailed Instructions enclosed

Disclaimer: Please backup every file that you intend to modify.
If the modification modifies the database, it's a good idea to backup your database before doing so.

Note: If you modify your UBB.Threads code, you may be giving up your right for "official" support from Infopop.If you need official support, you'll need to restore unmodified files.


Attached File
121815-theshop.zip  (305 downloads)
Posted By: AllenAyres Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/23/2004 5:50 PM
Sounds cool, but what does it do? Offer things like name changes for a price?
Posted By: JoshPet Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/23/2004 7:48 PM
Yeah, this sounds awesome-- please elaborate.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/23/2004 7:56 PM
Yes you set in the admin Panel what points you want to give for such things as taking Polls, Making Polls, Doing Shouts, How many words or Characters a post has.. and subtract em if the user deletes a post.. so these points build up and you can purchase items that you put up in the Item Section or Purchase Features such as ChangeName ChangeTitle Larger Signatures, Images in Signatures, Glowing Names (Flashes in Mozilla), Shadowed Names ( backgrounded in Mozilla), etc.. You can also Auction Off items you buy and when the auction is over you get the points and the user gets the item...

see it for yourself at

CT Shop

Login Threadsdev
Password Threadsdev
Posted By: Zackary Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/23/2004 9:17 PM
Interesting idea Scroungr. Very cool.
Posted By: kristiet Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/24/2004 5:08 AM
Very kewl! can you actually put items "for sale" in there? like a forum garage sale of sorts?

how do you go about collecting points on your site?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/24/2004 5:12 AM
in a sorts.. say you have a widget that you want to sell.. just add an item called widget and sell it.. allows ya to set stock levels on it also.. and then when someone buys the widget it will show up in their profile that they bought a widget... will also subtract the widget from stock.. its not a powerful one like say Photopost's Classifies but it allows for a little fun.. check it out at Couch Tomatoe
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/24/2004 7:15 PM
A few questions.

There is an option to change names and colors of names and add shadows to names. When playing with it, I added a color and glowing text to my name and it also add the color and glowing test to the custome title for me Is there a way to make it only change the name.

When I was done playing with it, I used the option to clear the siginiture and it didnt do anything to it. my name is still green and glowing

Lastly...
the only way to see the changes is to go into the my home section and on the very bottom you have to click the box to view sigs purchased in the shop. Is there a sql That can run to set everyone to checked and make all new users auto check yes?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/24/2004 7:35 PM
clear the siginiture doesn't clear titles or names it only clears the signature look at the script you should be able to see how to add other options...


to change only one.. look at the code and comment out the part you don;t want to change...

and lastly you can run

UPDATE w3t_ShopMembers SET titleeffectstatus = 'ON'

that will update all users so they can see the effects and can then turn it off..

to set it to default ON for all new users find the following adduser.php

// -------------------------
// Build Board Query For Shop Mod & Insert Points
// Add user to Shop
$query="
INSERT INTO {$config['tbprefix']}ShopMembers
VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'OFF')
";
$sth = $dbh -> do_query($query);
// End of Build Board Query For Shop Mod & Insert Points
// -------------------------

change to

// -------------------------
// Build Board Query For Shop Mod & Insert Points
// Add user to Shop
$query="
INSERT INTO {$config['tbprefix']}ShopMembers
VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'ON')
";
$sth = $dbh -> do_query($query);
// End of Build Board Query For Shop Mod & Insert Points
// -------------------------

if ya even wanna give newbies some credits for applying set <CREDITS VALUE> to a number like 1000 which will give newusers 1000 credits to spend..


// -------------------------
// Build Board Query For Shop Mod & Insert Points
// Add user to Shop
$query="
INSERT INTO {$config['tbprefix']}ShopMembers
VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '<CREDITS VALUE>', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'ON')
";
$sth = $dbh -> do_query($query);
// End of Build Board Query For Shop Mod & Insert Points
// -------------------------
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/25/2004 12:38 AM
There is something that is replaced that allows all your post to reflect changes when you edit it. I edited my title and now it doesent reflect on all the older posts.
Posted By: minto Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/27/2004 11:14 AM
nobody gets any points when they post? any ideas? but everything works i gave myself 1000000 points haah and i got a custom name and it works ok. but points dont add up
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/27/2004 3:30 PM
did you add the part in the instructions to addpost in the right area? did you set the words and letters value to something?
Posted By: minto Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/27/2004 8:33 PM
yeah and i double checked the addpost.php had all the right code changed. i think it be the database as on one fo the it said that it allready existed so i guess it [censored] upo there
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/27/2004 8:34 PM
Hmmm well I can take a look later.. will need an account with admin rights though and possibly ftp access.. shoot me a PM
Posted By: minto Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/27/2004 8:38 PM
ok thanks so much my friend. i will send you a pm. sorry im such a n00b im just learning
Posted By: minto Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/28/2004 6:08 AM
also mate i when u reset your sig it does the following

--------------------


--------------------
test goes here


it adds 2 lines of --- and u cant get rid of it unless you have no sig at all
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/28/2004 2:05 PM
clearing your sig puts "test goes here" ??
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/28/2004 2:50 PM
Hmm jest rechecked the upload

$query="
UPDATE {$config['tbprefix']}ShopMembers
SET money=money-'$itemsarray[price]', signature = ''
WHERE uid='$user[U_Number]'
";
$dbh -> do_query($query);


these lines tell the signature field of ShopMembers to be cleared to '' and thats where the signature is now getting pulled from. Please double check the scripts involved for the correct changes Let me know what happens and I will try and get on your server again
Posted By: minto Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 3:52 AM
what i mean is when u reset your sig it makes to lines of --- eg for you sig it would look like this after u reset it. its blank but once u type stuff in your box it will turn out like this


--------------------


--------------------
Couchtomatoe - www.couch-tomatoe.cc
My abilities are for hire for installs, upgrades, custom themes and custom modifications.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 5:27 AM
Hmm will have to check that...
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 3:45 PM
Im still having some issues. Mostly the way names are changed. Me and another admin bought a name change and never cold get it back to normal.

last night I restored the original files so I can start over again to make sure I did everything correctly. I removed everything but the sql that was created. And we still have the borked names but now they show normal on the online page but all the posts and any new posts we make, it still uses the colored and glowing texts we bought.

as far as removing the sql that was created during install, The only ones I see are these,

w3t_ShopAuctionItems
w3t_ShopBank
w3t_ShopCats
w3t_ShopFeatures
w3t_ShopItems
w3t_ShopMemberItems
w3t_ShopMembers
w3t_ShopSettings
w3t_ShopVotes

Can I just remove the entries?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 4:35 PM
sure. Remove those tables. And restore the changed scripts back to normal. The deatures section could be tweaked a little. You can also turn them off.. you don't have to offer all the features..
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 6:24 PM
true. its a great hack and ill certainly add it back. I just want to make sure I did it exactly right. most times i find that I replaced something when I should have added below it ;-\

I also realised that I dont have to remove them. In the install script it has, "if table exists replace it" or something like that. I think it will just overwrite whats there.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 10:47 PM
okay Minto.. I tried it again on my server and there is no way to get

--------------------


--------------------

on my server.. if ya want me to take another look let me know..
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/29/2004 10:48 PM
[]DrChaos said:
Im still having some issues. Mostly the way names are changed. Me and another admin bought a name change and never cold get it back to normal.

last night I restored the original files so I can start over again to make sure I did everything correctly. I removed everything but the sql that was created. And we still have the borked names but now they show normal on the online page but all the posts and any new posts we make, it still uses the colored and glowing texts we bought.

as far as removing the sql that was created during install, The only ones I see are these,

w3t_ShopAuctionItems
w3t_ShopBank
w3t_ShopCats
w3t_ShopFeatures
w3t_ShopItems
w3t_ShopMemberItems
w3t_ShopMembers
w3t_ShopSettings
w3t_ShopVotes

Can I just remove the entries? [/]

yeah I never did add a feature that will reset your name back to normal. Maybe I will.
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/30/2004 5:40 AM
:-\

Still a great mod
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/30/2004 9:15 AM
I reworked alot tonite will be uploading a new version later this weekend.. now pulls things correctly
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 10/31/2004 7:38 AM
okay made some major changes to the way it pulls the information. will allow for easier integration. I removed the 6.4 files since all that changed from 6.4 to 6.5 was the cookies.. you can still adapt this easily to 6.4 by looking at where I placed the strings.. also I removed it from the postlist.php and online.php and showmembers.php because its pretty useless in there..

What really makes this shine is the ability to buy/sell/ and auction other things besides the features.. you can also create seperate categories and even subcategories
Posted By: DrChaos Re: Finished-[6.4-6.5] Feature Shop 1.6 - 11/01/2004 12:35 AM
a definite on the list for tonight
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/15/2005 10:19 PM
I'm thinking about adding this scroungr, but I have a question. I looked at your site and in the feature shop you can get 100x100 or 150x150 avatars. If I have my max avatar size set to 80x80, does this mod override that?

Because if I have to set the maximum avatar size 10 150x150, couldn't people just add a bigger avatar from their profile?

Thanks!
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/18/2005 5:25 PM
yes it does override that 80x80 and yes if you set it to 150x150 in threads it will override it.. and if ya want you can disable any functions ya don't wanna use
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/19/2005 7:15 AM
[]scroungr said:
yes it does override that 80x80 and yes if you set it to 150x150 in threads it will override it.. and if ya want you can disable any functions ya don't wanna use [/]

This may be a dumb question, but I would imagine that since you can sell the option of an image in a user's signature, the idea is to have images in signatures turned off. Is that right? Sorry to ask here, but I haven't even read the instructions yet, preferring to wait for 6.5.1 final before touching this. Thanks!
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/19/2005 8:33 PM
yeah I have signatures in images turned off unless they buy em with this mod
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/22/2005 1:51 PM
I have installed the files and did the installation. I went to admin settings and I didnt see anything, where in the admin settings???!?!
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/22/2005 7:27 PM
are you logged in as admin?

did you go to the footer of the feature shop? should say
Admin Panel - New Category - Search Shop - Shop Stats

click on the icon or the name..
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 10:59 AM
Yes I am logged in as an admin and I dont see any footer of feature shop.

Where is it exactly, i am using 6.5, is it in the control panel???.
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 11:00 AM
How do I re-do this all again, so many tables of feature shop has been isntalled and if i run the install again it doesnt allow me.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 11:08 AM
basically the way I created this mod is that everything is in the shop and not much in threads except for some links and some code for points..

so its safe to delete the following tables

ShopMemberItems
ShopAuctionItems
ShopBank
ShopCats
ShopItems
ShopSettings
ShopVotes
ShopMembers
ShopFeatures


then rerun the install shop script and select new
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 11:12 AM
oops, ok found it, its in shopadmin.php

thanks, now let me continue the installation and see how it goes
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 12:17 PM
Hi

I have done everything and i get this in my forum entrance, please tell me where did I go wrong?



$ubbt_lang['shopedit'] = "Editing"; $ubbt_lang['shopauctionitem'] = "In the Auction House"; $ubbt_lang['all_admin'] = "Performing Administrative Duties"; $ubbt_lang['shop'] = "Entering the Shop"; $ubbt_lang['shopcategory'] = "Perusing the Shop"; $ubbt_lang['shopitem'] = "Buying an Item in the Shop"; $ubbt_lang['shopstats'] = "Looking at the Shop Stats"; $ubbt_lang['shopsearch'] = "Searching the shelves of the Shop"; $ubbt_lang['shopbank'] = "Counting his money";
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 2:16 PM
Ok I think I am done.

One last thing, when I do the cahnge user name feature and try to do the preview thingi, it doesnt work, it gives me an error page of 404 or something. Why?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/23/2005 7:07 PM
cause I was dumb and left out one file download the zip again and just copy over the itempreview.php
Posted By: ScriptZ Man Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/24/2005 3:48 AM
I downloaded the attachment of this progie from your original post. But the instructions65.txt file and title of this .txt file makes reference to UBB.Threads v6.5. I need a confirmation from you (scroungr) that I can use this on v6.4.

Thank You!
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/24/2005 7:15 AM
you can but you may need to do a little rewrite. the mod basically doesn't get much from the ubthreads but the placements of the points system into threads script files won't be the same for 6.5 to 6.4. One of the other users here is using this mod with v6.4.
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/25/2005 6:48 AM
ok, EXCELLENT thanks dude
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/25/2005 7:13 AM
scroungr,

why is it I find difficult changing the color and glowing for my username.

I gave myself so many points so I can play with the feature, but everytime I try to change color and give glowing it doesnt do it. Why? Help?
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/25/2005 7:38 AM
for some reason I have problem with the glowing feature the most
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/25/2005 4:37 PM
look into the ShopMembers table and make sure a value was placed into the glow field. Also check your placement of the string in showflat that allows the item to be viewed. let me know if it's NOT getting added into the ShopMembers table or if it's just being shown.
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/28/2005 6:42 AM
I did check the shopmembers table and I applied the value, but still its a problem.

And what do you mean placement of the string in showflat, please explain slowly, i am still learning
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/28/2005 7:04 AM
scroungr,

this what I see in my shopmembers, tell me if you see anything wrong and where I should change it and what next
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/28/2005 3:42 PM
no not the table structure let me see what one of the table entries looks like..

and I mean you have to alter the showflat.php and showthread.php and tmpls.

you should go back to the instructions and reread them and follow them closely. if you need assistance shoot me a PM with FTP access information and I will take a look.
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/28/2005 7:21 PM
thanks scroungr, I will send you the ftp access, appreciate it thanks
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/29/2005 12:14 AM
Salim what issues were you having? I saw a few changes people made? did you have under your

Display preferences, number of shown topics, languages, colors...

View Special Effects in User's names and Titles Purchased from the Feature Shop

set to yes?
Posted By: salim Re: Finished-[6.4-6.5] Feature Shop 1.6 - 01/29/2005 7:09 AM
ooopppps, scorungr, you should have mentioned that I needed to switch the effect in my profile duhhhhhhhhhhh

Sorry my mistake and thanks a bunch fory our help. you are da man
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/02/2005 11:03 PM
I had this working for a few weeks with no problems then one user said they had this problem

[]http://www.parentforum.org/ubbthreads/Attachments/4202-leannprtsc.jpg.jpg[/]
Then another member had the same problem. But I could not find anything wrong on when I looked. I uploaded my pre feature shop showflat.php and the fault stopped.
I followed the the install instructions again and uploaded the file I had the same error which I saw this time

I have attached my version on showflat.php if someone could have a look at it and point out if I have made a mistake.

Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/02/2005 11:17 PM
whats the error say?
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/02/2005 11:33 PM
[]scroungr said:
whats the error say? [/]

It does not say anything, it makes posts look like my picture above
Posted By: Ian_W Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/02/2005 11:36 PM
Looks like you have a missing cell or table closure.

When I get similar, I dump the source code from that page into FrontPage - fix the error - then alter the template, with the same modification.
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/03/2005 12:57 AM
I don't have frontpage
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/03/2005 1:11 AM
definitily a table issue.. hows it look in threaded mode? could also be the .tmpl as well as the .php?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/03/2005 1:15 AM
actually looking back over this coding I would figure its more in the .php then in the .tmpl. with all the spanning and diving going on could be the issue.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/03/2005 1:33 AM
okay had to remove the showflat.php.. site rulez say don't post full file.. you can post code snipets.. anyways I checked you file and it works on my site but I noticed on the bottom of the showflat.php that you have

// Adsense hack start
$adsense = "";
if ( stristr(",{$config['adsense']},", ",$Board,") ) {
include("$thispath/templates/$tempstyle/adsense.tmpl");
}
// Adsense hack finish


try removing those lines and retest.. you MAY have a problem in the adsense.tmpl
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/03/2005 8:37 AM
[]scroungr said:
okay had to remove the showflat.php.. site rulez say don't post full file.. you can post code snipets.. anyways I checked you file and it works on my site but I noticed on the bottom of the showflat.php that you have

// Adsense hack start
$adsense = "";
if ( stristr(",{$config['adsense']},", ",$Board,") ) {
include("$thispath/templates/$tempstyle/adsense.tmpl");
}
// Adsense hack finish


try removing those lines and retest.. you MAY have a problem in the adsense.tmpl [/]

I will try that and let you know

[] site rulez say don't post full file.. [/]
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/04/2005 3:53 AM
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

Code
	// ------------------------- <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 />		}



to


Code
 <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 />



in the showflat.php that will set it back to the stock except for the signature
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/06/2005 2:12 AM
Thank you scroungr for this and your time the other day.
I have not had time to try this out yet. Will let you know if it is all ok.

Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/06/2005 7:38 PM
yeah cause your using html and graemlins in your sigs ad I limited the mechanism so it only allows one image per person it won't work without a major rewrite...so its best to leave out the signature stuff in your usuage.. the rest should work.. the shadowed names, the glowing names, and all the rest of the abilities...
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/06/2005 9:44 PM
I've just installed this and I have some issues/questions:
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?

Also, I'm having issues with the templates:
It looks ok here, but it's not:
http://www.laondalatina.com/foros/shop.php
Because on the rest of the site, I have a vertical bar on the right where I plan to add content:
http://www.laondalatina.com/foros/
I believe there is an issue with missing table tags.
Here it gets hairy:
http://www.laondalatina.com/foros/shopcategory.php?Cat=&cid=1
Probably another template issue.

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.

Any suggestions?
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/07/2005 9:15 AM
I will take a look in the morning at the code. I see a possible problem.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/08/2005 3:36 AM
okay uploaded a new zip.. should fix some of the issues...
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/09/2005 3:07 AM
I haven't uploaded ALL the new files, but I did update the 6.5 .php files and the templates, and everything looks the same.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/09/2005 9:01 AM
Hmmm I see this error

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
SQL Error #: 1064
Query: SELECT * FROM w3t_ShopCats WHERE cid='0' AND (status = 'on' || owner = ) ORDER BY displayorder, catname

and you can't have the new files if your still getting that error cause I fixed it?
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/09/2005 7:24 PM
[]scroungr said:
Hmmm I see this error

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
SQL Error #: 1064
Query: SELECT * FROM w3t_ShopCats WHERE cid='0' AND (status = 'on' || owner = ) ORDER BY displayorder, catname

and you can't have the new files if your still getting that error cause I fixed it? [/]

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.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/09/2005 10:17 PM
Hmmm send me a PM with some login information I wanna check a few things
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/10/2005 1:35 AM
Let me go create a new admin and I'll PM you the info.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/10/2005 4:54 PM
ok think I see what ya did... 1) delete all the existing shopfiles.. download new zip.. the way I rewrote it all the shop files will be placed in a director called theshop to be placed inside the threads directory.... I took the files out of languages and templates and moved em all inside the directory so it will make it easier to update and vice-a-versa
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/10/2005 7:47 PM
I uploaded the new .zip to the threads directory and unzipped it there and now all the files are in the /theshop directory. It still doesn't appear to have changed anything. The layout is broken by the shop on all the pages, except strangely enough, the admin area. In the admin area and the bank area, none of the links do anything either.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/11/2005 4:40 AM
hmm okay I will log in and take a look
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/11/2005 6:45 AM
okay a few questions.. do you have globals turned on or off? does your server allow the super globals $_POST and instead makes you use the obsolete $HTTP_POST_VARS and $HTTP_GET_VARS instead?

about the tables its only when you go into say the features table from what I see... that splits the table the features are lsited on and puts it below the menu you have on the right? try this shopcategory.tmpl and let me know if it fixes it.. I think there was an extra </table> closure...

Attached File
125995-shopcategory.tmpl.txt  (115 downloads)
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/11/2005 7:11 AM
BTW if your server can't use SUPER Globas $_POST and $_GET try adding this to the top of the scripts.. MAY work

// FORCE USE OF GLOBAL VARIABLES
$version_info = explode('.', phpversion());
if ($version_info[0] < 4 || ($version_info[0] > 3 && $version_info[1] < 1)) {
$_POST = $HTTP_POST_VARS;
$_GET = $HTTP_GET_VARS;
}


then again this could fail because your server won't allow the phpversion() command...
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/11/2005 6:11 PM
[]scroungr said:
okay a few questions.. do you have globals turned on or off? does your server allow the super globals $_POST and instead makes you use the obsolete $HTTP_POST_VARS and $HTTP_GET_VARS instead?

about the tables its only when you go into say the features table from what I see... that splits the table the features are lsited on and puts it below the menu you have on the right? try this shopcategory.tmpl and let me know if it fixes it.. I think there was an extra </table> closure... [/]

I'm not sure where to find the information regarding globals, so I'll ask Josh, since my site's on one of his servers Thanks, scroungr. Hopefully we'll get this thing fixed. I'm glad it wasn't just my imagination.
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/13/2005 11:30 PM
scroungr

I have finally changed the code and its not getting the error I first was getting, but now all signatures are not separate from the posts.
I have left it as it is for now for you to see.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/14/2005 12:38 AM
hmm trouble resolving your host but I will take a look when I can.
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/14/2005 8:21 AM
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/16/2005 12:07 AM
Another problem as been spotted.
New users do not have any ponits or earn any. I have added 5000 to their account but it does not show.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/16/2005 12:14 AM
Hmmmm did you add the code to adduser.php?


// -------------------------
// Build Board Query For Shop Mod & Insert Points
// Add user to Shop
$query="
INSERT INTO {$config['tbprefix']}ShopMembers
VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'ON')
";
$sth = $dbh -> do_query($query);
// End of Build Board Query For Shop Mod & Insert Points
// -------------------------


without that they won't get added to the w3t_ShopMembers table when they are added as a new user to the board?

it has to be UNDER

// Get this user's user number
$query = "
SELECT U_Number
FROM {$config['tbprefix']}Users
WHERE U_Username='$Displayname_q'
";
$sth = $dbh -> do_query($query,__LINE__,__FILE__);
list ($Uid) = $dbh -> fetch_array($sth);
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/16/2005 9:23 AM
No, how did I miss that
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/16/2005 3:24 PM
instructions.. line 11)
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/16/2005 6:14 PM
Thank you!

Do you mind having a look at this for me?
Now all signatures are not separate from the posts.
I have left it as it is for now for you to see.
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/17/2005 1:32 AM
I would but I still can't resolve your host.. gives me an error when I try to get to your site no matter what PC i use and no matter how I try.
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/17/2005 8:25 AM
wtf is causing that then
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/17/2005 5:10 PM
only way I have figured out how to get to your forums is if I use http://harrier.xssl.net/~admin115/

there is most likely something wrong with your resolver.. I would message others and see if anyone else has this issue
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/17/2005 6:31 PM
I think I will have to
Posted By: Ian_W Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/18/2005 1:41 PM
Looks like you have some issues with your nameservers - http://www.dnsreport.com/tools/dnsreport.ch?domain=parentforum.org
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/18/2005 2:50 PM
Thanks Ian, I will let my hoster know
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/18/2005 4:53 PM
wow thanx for that site Ian
Posted By: dparvin Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/18/2005 8:04 PM
I don't know whats up with my site.
My hoster has said nothing is wrong and pointed this out to me
http://www.dnsreport.com/tools/dnsreport.ch?domain=bbc.co.uk

I know this is going off topic, but can anyone help with this problem? This is beyond my skills
Posted By: scroungr Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/18/2005 9:21 PM
ns.bbc.co.uk.[212.58.228.21] needs to be listed with the parent nameserver as a nameserver for your domain. It appears to only be listed with the authoritive and not the parent DNS server.

you can see from your parent that
ns1.thny.bbc.co.uk. [212.58.240.21] [TTL=172800] [UK]
ns1.thls.bbc.co.uk. [132.185.240.21] [TTL=172800] [EU]
ns1.thdo.bbc.co.uk. [212.58.224.21] [TTL=172800] [UK]
ns1.bbc.co.uk. [132.185.132.21] [TTL=172800] [EU]

are your name servers but from the authoritive you get
ns.bbc.co.uk.[212.58.228.21] [TTL=900]
ns1.thls.bbc.co.uk.[132.185.240.21] [TTL=900]
ns1.thdo.bbc.co.uk.[212.58.224.21] [TTL=900]
ns1.thny.bbc.co.uk.[212.58.240.21] [TTL=900]

best I can tell is ns.bbc.co.uk.[212.58.228.21] [TTL=900]
should be ns1.bbc.co.uk. [132.185.132.21] [TTL=172800] [EU]

WARNING: Your SOA (Start of Authority) record states that your master (primary) name server is: ns.bbc.co.uk.. However, that server is not listed at the parent servers as one of your NS records!
Posted By: donJulio Re: Finished-[6.4-6.5] Feature Shop 1.6 - 03/25/2005 10:01 PM
[]scroungr said:
okay a few questions.. do you have globals turned on or off? does your server allow the super globals $_POST and instead makes you use the obsolete $HTTP_POST_VARS and $HTTP_GET_VARS instead?

about the tables its only when you go into say the features table from what I see... that splits the table the features are lsited on and puts it below the menu you have on the right? try this shopcategory.tmpl and let me know if it fixes it.. I think there was an extra </table> closure... [/]

This is from Josh:
Register globals is "On" and yes, it will accept $_GET and $_POST arrays.

Anyhow, I still am having the exact same issues with the scripts not working and problems with the templates. I HAVE however fixed most of the issues with the templates. The problem was they were breaking my layout and it turns out there were extra closing td, tr, and table tags. I just commented them out so you can see. I've also fixed a bug in the shopitem.tmpl where clicking on the button that says "HERE" gave a 404 error due to the new directory structure (everything being in /ubbthreads/theshop). I also fixed the same bug in the itempreview.tmpl where clicking on "Preview Name" gave the same 404 error, since the form was being sent to /ubbthreads/itempreview.php. I've attached the work on the templates to this post. If anyone could see what's wrong with shopcategory.tmpl:
http://www.laondalatina.com/foros/theshop/shopcategory.php?Cat=&cid=1
I would appreciate it.

Attached File
126614-default.zip  (17 downloads)
© UBB.Developers