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..
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.
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...
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
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?
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 // -------------------------
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
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
$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
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.
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,
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 ;-\
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.
[]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,
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
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?
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
[]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!
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";
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?
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.
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.
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.
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.
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.
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.
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
[]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
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
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...
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?
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.
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?
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.
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
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.
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...
[]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.
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.
// ------------------------- // 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);
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!
[]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.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
download the zip again and just copy over the itempreview.php
at the moment - but expanding all the time....) 
