Mod Name / Version: Feature Shop 1.7 <br /> <br />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.. <br /> <br />Working Under: UBB.Threads 6.5 <br /> <br />Mod Status: Finished <br /> <br />Any pre-requisites: Ubb THreads 6.5 <br /> <br />Author(s): scroungr <br /> <br />Date: 10/22/04 <br /> <br />Credits: <br /> <br />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 <br /> <br /> <br />If using IIP in the shoutaddpal.php <br /> <br /> <br />New Files: Shop Language Files, Shop Template Files, Shop PHP Files <br /> <br />Database Altered: YES <br /> <br />Info/Instructions: <br />Detailed Instructions enclosed <br /> <br />Disclaimer: Please backup every file that you intend to modify. <br />If the modification modifies the database, it's a good idea to backup your database before doing so. <br /> <br />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.

Sounds cool, but what does it do? Offer things like name changes for a price? <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Yeah, this sounds awesome-- please elaborate. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

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...<br /><br />see it for yourself at<br /><br /> CT Shop <br /><br />Login Threadsdev<br />Password Threadsdev

Interesting idea Scroungr. Very cool. <img src="http://www.ubbdev.com/forum/images/graemlins/cool.gif" alt="" />

Very kewl! can you actually put items "for sale" in there? like a forum garage sale of sorts?<br /><br />how do you go about collecting points on your site?

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

A few questions.<br /><br />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.<br /><br />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 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />Lastly...<br />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?

clear the siginiture doesn't clear titles or names it only clears the signature <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> look at the script you should be able to see how to add other options...<br /><br /><br />to change only one.. look at the code and comment out the part you don;t want to change...<br /><br />and lastly you can run<br /><br />UPDATE w3t_ShopMembers SET titleeffectstatus = 'ON'<br /><br />that will update all users so they can see the effects and can then turn it off..<br /><br />to set it to default ON for all new users find the following adduser.php<br /><br />// -------------------------<br />// Build Board Query For Shop Mod & Insert Points<br />// Add user to Shop<br />$query="<br /> INSERT INTO {$config['tbprefix']}ShopMembers<br /> VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'OFF')<br />";<br />$sth = $dbh -> do_query($query);<br />// End of Build Board Query For Shop Mod & Insert Points<br />// -------------------------<br /><br />change to<br /><br />// -------------------------<br />// Build Board Query For Shop Mod & Insert Points<br />// Add user to Shop<br />$query="<br /> INSERT INTO {$config['tbprefix']}ShopMembers<br /> VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'ON')<br />";<br />$sth = $dbh -> do_query($query);<br />// End of Build Board Query For Shop Mod & Insert Points<br />// -------------------------<br /><br />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..<br /><br /><br />// -------------------------<br />// Build Board Query For Shop Mod & Insert Points<br />// Add user to Shop<br />$query="<br /> INSERT INTO {$config['tbprefix']}ShopMembers<br /> VALUES ('', '$Uid', '$Displayn_q', '$Title_q', '$Picture_q', '', '<CREDITS VALUE>', '', 'OFF', '$Color_q', 'OFF', 'OFF', 'ON')<br />";<br />$sth = $dbh -> do_query($query);<br />// End of Build Board Query For Shop Mod & Insert Points<br />// -------------------------

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.

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 <img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" />

did you add the part in the instructions to addpost in the right area? did you set the words and letters value to something?

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

Hmmm well I can take a look later.. will need an account with admin rights though and possibly ftp access.. shoot me a PM

ok thanks so much my friend. i will send you a pm. sorry im such a n00b <img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" /> im just learning

also mate i when u reset your sig it does the following<br /><br />--------------------<br /><br /><br />--------------------<br />test goes here<br /><br /><br />it adds 2 lines of --- and u cant get rid of it unless you have no sig at all <img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" />

clearing your sig puts "test goes here" ??

Hmm jest rechecked the upload<br /><br /> $query="<br /> UPDATE {$config['tbprefix']}ShopMembers<br /> SET money=money-'$itemsarray[price]', signature = '' <br /> WHERE uid='$user[U_Number]' <br /> ";<br /> $dbh -> do_query($query);<br /><br /><br />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 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Let me know what happens and I will try and get on your server again <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

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<br /><br /><br />--------------------<br /><br /><br />--------------------<br />Couchtomatoe - www.couch-tomatoe.cc <br />My abilities are for hire for installs, upgrades, custom themes and custom modifications.

Hmm will have to check that...

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.<br /><br />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.<br /><br />as far as removing the sql that was created during install, The only ones I see are these,<br /><br />w3t_ShopAuctionItems<br />w3t_ShopBank<br />w3t_ShopCats<br />w3t_ShopFeatures<br />w3t_ShopItems<br />w3t_ShopMemberItems<br />w3t_ShopMembers<br />w3t_ShopSettings<br />w3t_ShopVotes<br /><br />Can I just remove the entries?

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..

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 ;-\<br /><br />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. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

okay Minto.. I tried it again on my server and there is no way to get <br /><br />--------------------<br /><br /><br />--------------------<br /><br />on my server.. if ya want me to take another look let me know..

[]DrChaos said:<br />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.<br /><br />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.<br /><br />as far as removing the sql that was created during install, The only ones I see are these,<br /><br />w3t_ShopAuctionItems<br />w3t_ShopBank<br />w3t_ShopCats<br />w3t_ShopFeatures<br />w3t_ShopItems<br />w3t_ShopMemberItems<br />w3t_ShopMembers<br />w3t_ShopSettings<br />w3t_ShopVotes<br /><br />Can I just remove the entries? [/]<br /><br />yeah I never did add a feature that will reset your name back to normal. Maybe I will.

:-\<br /><br />Still a great mod <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

I reworked alot tonite will be uploading a new version later this weekend.. now pulls things correctly

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..<br /><br />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

a definite on the list for tonight

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?<br /><br />Because if I have to set the maximum avatar size 10 150x150, couldn't people just add a bigger avatar from their profile?<br /><br />Thanks!

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 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

[]scroungr said:<br />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 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> [/]<br /><br />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!

yeah I have signatures in images turned off unless they buy em with this mod <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

I have installed the files and did the installation. I went to admin settings and I didnt see anything, where in the admin settings???!?!

are you logged in as admin?<br /><br />did you go to the footer of the feature shop? should say<br /> Admin Panel - New Category - Search Shop - Shop Stats <br /><br />click on the icon or the name..

Yes I am logged in as an admin and I dont see any footer of feature shop.<br /><br />Where is it exactly, i am using 6.5, is it in the control panel???.

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.