|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Name: ubb.db Description: Adds a plug-n-play file database to your site with ubb authentication. Original Author: Cal (thank you for permission to distribute  ) Credits and Thank yous: - LK for the majority of the grunt work updating from the v5 series it was written for and adding additional admin features  - Mark Badolato for code optimization and putting up with my questions  - Charles for code assistance - Burak for code assistance - Clankiller for bugfixes Link: https://www.ubbdev.com/ubb/upload/00000494/ubbdb.zip Demo: https://www.ubbdev.com/ubbcgi/db.cgi Requirement: UBB™ 6.3+ Install Notes: - Unzip the file and upload the cgi-bin contents to your ubb cgi directory in ascii, setting permissions to 755. Upload the /uploads folder to your ubb non-cgi directory and set permissions to 777. - Access your admin at db.cgi?action=admin there are some 'starter' categories in there you can edit. - A method was added to make using additional file types easir to upload. Line # 282: code:
my ($base, $path, $ext) = fileparse($zip, qr{.(zip|txt|jpg)});
Change the (zip|txt|jpg) to add whatever file types you need. For example, to add .gif file, you would change that line to read: code:
[qb]my ($base, $path, $ext) = fileparse($zip, qr{.(zip|txt|gif|jpg)}); - templates - better customization features - continuing optimizing code Changelog:- Nov. 29, 2002 - v2.9 - bugfixes and minor updates (thanks Clankiller) - Nov. 20, 2002 - v2.8 - removed unused code (thanks Burak ) - Nov. 20, 2002 - v2.7 - Added easier method to upload additional file types (thanks Mark ) - Nov. 11, 2002 - v2.5 - Wordlets Done - Oct. 28, 2002 - Initial Update for v6.3+ - Way way back - cal henderson wrote this for ubbcodehackers and ubb v5
|
|
|
|
|
Joined: Nov 2001
Posts: 1,704
Moderator / Da Masta
|
|
Moderator / Da Masta
Joined: Nov 2001
Posts: 1,704 |
Wow, this is great... Thanks Allen BTW: Is this gonna be used with the Portal?
|
|
|
|
|
Joined: Mar 2001
Posts: 7,394
Admin / Code Breaker
|
|
Admin / Code Breaker
Joined: Mar 2001
Posts: 7,394 |
Allen, did you remove the option of "Create new thread"?
|
|
|
|
|
Joined: Dec 2000
Posts: 151
Member
|
|
Member
Joined: Dec 2000
Posts: 151 |
I guess I am a bit ignorant - what does this add ? That is what does having a "plug n play database" do for the board?
|
|
|
|
|
Joined: Aug 2002
Posts: 65
Member
|
|
Member
Joined: Aug 2002
Posts: 65 |
Woah... hey. I know a guy who was looking for this very thing a while back. I told him to just create a Forum called Downloads and stick the links in there... this is much *much* nicer.
Thanks
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
No LK, forgot that  The 'create new threads' needs to be left unchecked. We'll most likely remove it completely in the next update. Your ubb header and footer can be added easily as well. it'll be included in the next version too
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
quote: Originally posted by CTM: Wow, this is great... Thanks Allen
BTW: Is this gonna be used with the Portal? welcome This will probably become part of the portal, once the coding issues are worked out and modularization issues are worked out for the portal project. That's under the 'code optimization' todo list
|
|
|
|
|
Joined: May 2001
Posts: 6,708
Member
|
|
Member
Joined: May 2001
Posts: 6,708 |
Great work with this, should be a good addition to many forums.
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
danke It'll be more useful once we get the wordlets and a few other tidbits done
|
|
|
|
|
Joined: Feb 2000
Posts: 4,625
Member
|
|
Member
Joined: Feb 2000
Posts: 4,625 |
Good job Allen. (And Mark, LK and CC)
|
|
|
|
|
Joined: Dec 2000
Posts: 151
Member
|
|
Member
Joined: Dec 2000
Posts: 151 |
quote:
Originally posted by CaCoffin:
I guess I am a bit ignorant - what does this add ? That is what does having a "plug n play database" do for the board? Eh?
|
|
|
|
|
Joined: Sep 2002
Posts: 16
Junior Member
|
|
Junior Member
Joined: Sep 2002
Posts: 16 |
Very very cool !!! Thanks a lot for this pluggin Very usefull!!! bobbel
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
I don't see any catagories, and the on.gif and off.gif files point to my webpage root, obviously they don't exist.
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
OK nm - I uploaded the CONTENTS of the uploads folder, not the folder itself. Obviously we have to modify for our own icons everywhere I assume? No problem if so...
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
OK, got everything figured except the files won't actually upload. The form submits ok, but it's pathing with the complete path including my local drive.
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
Ah...i see there is a file check for .zip - you need to have it reject the form if a non .zip is trying to be uploaded...I will try to figure out how to modify this because I am only going to use it for .jpg
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
OK, got everything figured out except how to easily add my header and footer...help?
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
I want to have this come up as one of my forum section, like instead fo seeing threads, I want to see the db section with all my formatting. After figuring out how to use the header and footer, I think it just means creating a new forum section, then modifying the forum record to display the db.cgi instead of the forum code. Help?
|
|
|
|
|
Joined: Dec 2000
Posts: 151
Member
|
|
Member
Joined: Dec 2000
Posts: 151 |
quote:
Originally posted by CaCoffin: quote:
[qb]Originally posted by CaCoffin:
I guess I am a bit ignorant - what does this add ? That is what does having a "plug n play database" do for the board?[/qb] Eh?
Man I must be the biggest idiot in the world that I am the only one who does not understand the purpose of this MOD. Such an idiot that it is obviously so apparent that not one person has chosen to add a few lines explaining. Would anyone care to enlighten this idiot?
|
|
|
|
|
Joined: Jan 2000
Posts: 5,073
Admin Emeritus
|
|
Admin Emeritus
Joined: Jan 2000
Posts: 5,073 |
Yeah, it's not immediately apparent what it is. It's a file database. Users can upload items and have them displayed and indexed.
bglynn - that's a heck of a lot of work you're looking at there... can you explain why you want to change the look so much?
UBB.classic: Love it or hate it, it was mine.
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
I'll add the header/footer to this once I get back in town bglynn, along with doing wordlets so it's more easily customized
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
OK, first, QUICKREPLY FARKING SUCKS! That's TWICE I lost the message because something was wrong witht he post, and the back button wipes it clean! ARGH! This is bglynn, I switched emails and can't retrieve my old password. Ca - click on the demo link in the first post - it's self explanitory. Charles - I'm making a profile driectory like this one. Here are a couple rough examples: add entry , pic demo
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
quickreply is optional Nice adaptation You can add your forum's header/footer in the lib.cgi - check for this :
If you use the same variables as used in public_common.pl, you should be able to easily add them. I'll get them Monday tho for the rest
|
|
|
|
|
Joined: Dec 2000
Posts: 151
Member
|
|
Member
Joined: Dec 2000
Posts: 151 |
quote:
Originally posted by Charles Capps:
Yeah, it's not immediately apparent what it is. It's a file database. Users can upload items and have them displayed and indexed.
Ok, thank you. I am already using an upload utility for people to upload files for posting, but there is no way for them to see what has been uploaded so it looks like it is probably a better way to go. Thank you!
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
Well that\'s looking better now! Thanks!
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
Hey if anyone is around right now, I'm running into something weird - whenever there is more than one entry in a catagory, the table gets all garbled - I'm trying to compare teh code but I'm not sure where it's not tripping right...
http://www.sbtontheweb.com/cgi-bin/db.cgi?action=cat;id=1
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
OK, I found the problem...I have a textarea field, and wheneer someone uses a hard return it screws up the datatable. I need to find out how to have it convert to . For now I changed the textarea to a text field.
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
I'm also having a problem where if the contributing member ID is switched on all records int he catagory to the last entry's name.
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
OK, I had a problem with file uploading, turns out that it's rejecting anything with an upper case extension, I imagine that will be easy to fix, probably add an or statement or something...new to programming, bear with me.
I wonder if you ran into the same ID problem, since you don't display the member name on the individual forms? For now I took mine off as well, they are only stored and displayed correctly on the Cat display page. I would like to have it array them correctly in each record though...
|
|
|
|
|
Joined: Nov 2002
Posts: 7
Junior Member
|
|
Junior Member
Joined: Nov 2002
Posts: 7 |
Wow, it worked...this stuff is kinda fun! Takes me back to HS
|
|
|
|
|
Joined: May 2000
Posts: 1,356
Addict
|
|
Addict
Joined: May 2000
Posts: 1,356 |
I didnt look at the code, but in the db.cgi file, you are loading an unnecessary module 'UBBCGI'... The codes below are using 'CGI' ... code:
use CGI qw(:standard);
use UBBCGI ':cgi';
also, you are not using %in... so, this code is unnecessary also: code:
[qb]%in = map{
my @z = param($_);
( scalar(@z) > 1 ?
( $_ => join(",", @z) ) :
( $_ => $z[0] )
)
} param();
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Thankyou Burak, I'll update the zip tomorrow - let me know if you see anything else please?
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Hey kaelaria, if you found some bugs, mind sharing the fixes?
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
zip updated with Burak's post and added the ubb header/footer to the layout
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
I just added an or to check for both cases of file extension - I haven't had time to fix the rest - for now I removed the edit feature, because the variables were getting switched, and removed the top-10 because of presumably a formatting issue, although it could be a variable carry over also. fixed a couple spots of the on off icons, that were missing part of the variable...that's about it so far. The rest is just a lot of additional building on your base so far.
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
If you don't mind posting the files, I'll Beyond Compare in the pieces that would work here, thanks for the work
|
|
|
|
|
Joined: Feb 2002
Posts: 34
Member
|
|
Member
Joined: Feb 2002
Posts: 34 |
email me and I'll send them: [email protected]
|
|
|
|
|
Joined: May 2001
Posts: 684
Code Monkey
|
|
Code Monkey
Joined: May 2001
Posts: 684 |
Hi,
what have I to do to show my forums-background Picture! Now there is only a black background....
Thanks
d-talk
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Hello d-talk, have you used the most recent version? It should be following your styles you have set. You have a link to the problem?
|
|
|
|
|
Joined: May 2001
Posts: 684
Code Monkey
|
|
Code Monkey
Joined: May 2001
Posts: 684 |
|
|
|
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.
|
|
|
Posts: 417
Joined: November 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
