Name: ubb.links v7.3.1a

Description: Adds a links script to your site, integrated into your forum's styles, members and permissions

Demo: http://www.praisecafe.org/forum/ubbthreads.php/ubb/links/op/Links.html

Installation: DL and unzip the file. Upload the folders to the corresponding folders within your forum (ie: all files in the "scripts" folder should be uploaded to your forum's "scripts" folder).

If you are installing new, you're either going to have to manually create the tables using the code in admin script or wait until version 7.3.1 where the fix will be in for that.

If you are upgrading from Josh's 7.2 version, you're going to need to update a table's column's name:


Author: Plethora (see credits) - Mark Summerlin wrote the original (TLD) code 4-5 years ago, but not much is left of his work

Requirement: UBB.Threads 7.3.x - 7.5.x

Changelog:
7.3 alpha (released 6/20/2008):
- Now uses 7.3's SEO links
- Lots of template/design updates to look more like ubb.threads
- Removed some extraneous code, optimized some other
- ~95% of the wordlets are complete for public pages, more needs to be done for admin pages
- All public pages are xhtml-compliant

7.3 beta (released 6/25/2008):
- fixed web install, it's now a seperate file
- lots of html fixes in the admin area

7.3 gamma (released 6/28/2008):
- fixed cat sort order in cp
- lots of html fixes in the admin area
- code optimizations to match .threads 7.3 code

7.3 gold (released 6/29/2008):
- fixed bread crumb
- fixed stats
- more xhtml fixes
- css adjustments
- added censor check to new links

7.3.1 (released 6/30/2008):
- fixed invalid html characters
- added link submission sanitization

7.3.1a (released 7/2/2008):
- fixed xhtml issue with subcats
- added fave and rating submission sanitization

Known Bugs:
- cannot do web install to create table
- cat sort order
- need to fix stats at bottom
- bread crumb bug
- various html cleanups (ongoing)

Upcoming Features:
- search of links
- set up for unlimited subcat levels
- auto-fill options which pre-populate the fields with the meta data from the web site being submitted
- sticky links
- advanced sorting options
- 'report this link' - for broken, issues
- sprinkling of appropriate ajax
- Links CI (latest links, top 10, etc)
- CAPTCHA

NOTE: Above sections will be updated as we go and first post will always have most current released code.

Enjoy!

thanks, it works nice. I have to rename my old tables from w3t_ to ubbt_ first in the sql console (RENAME TABLE w3t_..... TO ubbt_.....) and then run the alter command. Now it work.
I will do a german language file.

Thank you Zarzal

German language file in the attachment. Download and unzip it and put it in /languages/german

danke, I'll put it in the download file in the first post so it will be available - let me know if/when you update it

thanks. If I do changes I sent you a note.

Original post updated: 7.3beta released - now you can do the web install if you haven't installed it before - the create tables routines were moved to a new file - to be safe delete after installation. I also fixed many xhtml issues in the admin area, a few bugs related to category titles, and added zarzal's german language file translation.

To upgrade if you've already installed just upload the files (skip the install file).

Thanks. Submitting the sortorder in the admin section dont work (seems to have no effect) and if it returned from submit sortorder to main the layout is confused.

The nav breadcrumb seems to have a problem in the first sublevel: Index » » Fun

2 new bugs, thank you

Sortorder probably has to do with changing title to cat_title, I'll look at the navigation too

The sortorder on the main category never worked for me. In every version it was broken.

Ah, ok I've never used that. I can see where it's needed tho. Will get it on the bugz list

Found the bug, will post the fix plus some others this weekend

Hey, this sounds cool. Thank you.

Your "submit" page should use the CSS from threads; I can't say much about you "light theme" guys, but let me tell you, white submit boxes on a dark background looks YIKES!

Also, when I go to make a submission, the category dropdown shows a blank entry at the top...

Additionally, once i submit a link, the page has a weird grey background; I'm guessing some bugglet in there that also throws off my table display.

The blank entry at the top is intentional, so people will click and choose one instead of the default. I do need to update some css classes, and I've fixed a good number of html errors in the cp in my local version. I'll post it shortly

OK, updated original post to current code - fixed the cat sort order, optimized some more code and fixed lots of xhtml errors in the cp again.

Still need to fix the breadcrumb error, css class issues and the stats at the bottom before we can get much into the 7.3.1/7.4 version

Anyone else getting charset issues? I have the little diamond questionmark on my UTF-8 install...

i'd recommend setting a language entry "Please Select" vs having it blank... else you get confused as to why theres a blank item ...

Which page do you see the diamond?

The "diamond" shows when there is a characterset conflict; you can test it here

Looks nicer. Submitting of the sortorder works now but on my links main page it have no effect. My categorys stuck everytime in same same order. Can it be that I have an very old db and missing some fields in it? Can this be?

I don't see any 'diamonds' on your links install. Not sure how there would be any characterset conflicts since it takes the charset from the forum settings.

Thanks Zarzal. Maybe it's a caching issue, have they changed yet? I believe if you are able to set the order in the cp, then your database should be up to date.

The problem with the old way of setting the order (and the reason the changes never worked) was the original code was written back when people were using php 3 and 4 series - HTTP_POST_VARS has been deprecated for quite some time now and the command didn't mean anything for current versions of php - I used $_Post to get it running.

OK, Gold release in first post

The last of the major bugs were fixed (I think ):
- fixed bread crumb
- fixed stats
- more xhtml fixes
- css adjustments

I also:
- added censor check to new links

Well, I don't know what to tell you, cas they're there... Screencaps:



Additionally, tidy reports: "Page Error: This page contains invalid characters"

Those would only be viewable by the admin and why I couldn't see them on your site. They're ¤ symbols used by the original author. They don't throw errors at w3.validator.org, I'll update them on the next version.

7.3.1 (released 6/30/2008):
- fixed invalid html characters - Thanks Gizzy!
- added link submission sanitization - Thanks Yarp!
- minor code cleanup

Because of the sanitization addition/correction, everyone is urged to upgrade.

To upgrade from within 7.3.x, just upload files. For earlier versions follow info in first post.

Thank you, Allen.

I still have a sort problem. I attach some picturs. In picture lin1 you see my sort order in the admin section. In link2 you see the output of the main page. I can change the sortorder but it have no efect to the mainpage.

In picture link3 you can see 2 problems. It is a screenshot of inside a sub section. on the right side you can see a table problem in the layout.

Also I note (visibe in link3 too) that the statistic on the bottom count each section. In a subforum without links you count 0. Should this be that the counter is per page?

Not sure what to say, it works on 2 different installs for me. Are you running php5?

And you are correct on the stats. It needs to be updated.

Most likely, we'll be pulling this apart and seperating the pages into their own scripts with their own templates. Right now we're running into conflicts trying to run it all from one script.

Lol, bad characters to use

I like the idea of tearing it apart though

Hey AA, I wanted to test your installer for 7.3.1 but it's complaining that the tables don't exist... Which duah, I want to use the installer lol...

Just noticed the note about the seperate file; I think the install docs need to mention they need to access it as:
ubbthreads.php?ubb=links_install

I also found a bug... When you're viewing the main index without any categories, it throws an html error which skews the tables for ubb

Yeah, I haven't looked to do anything with that error - if you don't have any categories you really haven't finished installing it yet I guess we could add a "General" category with the create table functions, but most would change it anyways.

I was thinking the images didn't look right, so I nuked them from my install, it doesn't look half bad now (clicky)

Also, AA, if you use tab's instead of spaces for separation in your files, you can cut out a lot of unneeded space... Check my example attached...

Most likely we'll be changing the design of the categories to more closely match the design of ubb.threads forums - being able to have an unlimited/random number of columns is pretty much guaranteed to have html errors like zarzal is seeing for some sites. It's pretty much impossible to make it work for everyone.

Yeah, I used to do that, but it's generally recommended by the php/zend people to use tabs of 4 spaces - just so it's the same for everyone - some people use 2 spaces for tabs, others use tabs of differing sizes, others use 6 or 8 spaces for tabs. I can look it up on the zend site, but it's been a while and I just set it to 4 spaces and forget about it. Any part I've tabbed on is set to 4 spaces.

You're probably right about the images, it's one of those left-over things from the original code. They'll probably go away as we move closer to the forum-look.

I look at the formatting merely as what's being used in terms of keystrokes vs how zend feels about things ...

As for the images, they're a smidge larger than the text, so it was causing me some grief... I don't really see much of a use of them for what I'd use it for; so reguardless I'd edit them out.

I moved the spaces to AFTER the previous entry vs in FRONT of the entry as it makes visibly looking for items a little easier.

I set my tabs to equal 4 spaces, it's no more keystrokes

Where do you mean moving the spaces? For subcats or ?

There is more keystrokes though...
One tab is One character.
4 spaces is 4 characters.

yes: PHP Version 5.2.5-3

Odd zarzal, not sure what to tell you. When you do a

SELECT * FROM ubbt_links_categories

does cat_order match up with what you are seeing in your links control panel?



I know what you are trying to say... I used to be able to shrink photopost's filesize by half just by removing trailing spaces and converting leading spaces to tabs. The php/zend people recommend 4 spaces for each tab, so... you might bring your beef up with them and let me know if they make changes in those recommendations

i'm a 2 space guy

Exactly, everyone has their preferences, so when possible I try to follow best practices as outlined by the people who write php

ubbthreads is 2 space based, if you wanted it to match what it is using

but whatever fluffs your flannel is ok with me..

that's what powerful editors are for anyway. it's like a 2 command dealio in UltraEdit to change it from 4 to 2..

no biggie..

I'm so glad I have your approval

I know this is not based on the zend framework, but I set my text editor up with the tabs based on their recommendations:

http://framework.zend.com/manual/en/coding-standard.php-file-formatting.html

http://framework.zend.com/manual/en/coding-standard.coding-style.html

I know I have asked several times to pay someone to code this for me... I couldn't even pay for it so I'm doing it myself. Take up your spaces fetish with the zend people and let me know how it turns out. Or you could contribute to the project...

Minor version release to (hopefully) fix the html bug zarzal was seeing with subcats and sanitize the fave/rate submissions:

7.3.1a (released 7/2/2008):
- fixed xhtml issue with subcats
- added fave and rating submission sanitization

First post has latest code.

seems so. I attach a result of the query as screenshot.
It looks that the sort follows cat_id if parrent_id = 0 and not cat_order

I think I adjusted one SORT BY in the most recent version, can you upload the links.inc.php from the current zip and let me know if it fixed your html error and sort order? danke

I already try the latest version, but no changes Can you change the sortorder on your system?
The html problem seems to be fixed. But right now I found a new layout problem: try pressing a green button near a link to edit it and see what happen ...

Yes, sort_order changes in my test install here:

https://www.ubbdev.com/forums/ubbthreads.php/ubb/links/op/Links.html

I fixed the layout on the edit screen, there's probably 1-2 more of those left... every screen had to be updated.

Please try the current zip Zarzal - maybe your combo of php/mysql didn't like the quotes in:

ORDER BY 'cat_order'

It should work either way, but maybe your case is special.

no, this brings an error:
Parse error: syntax error, unexpected '}' in /var/www/users/d/d00003/websites/dragonclan-forum.de/board/scripts/links.inc.php on line 1090

/update:

aaahhhhh, the sortorder works. I insert the following block again that you have removed:
now te error is gone and the sortorder work

Well.... it looks like I left an extra } in there. It will be fixed on the next release. I'm glad at least we got past that bug on the sort. I'll make sure the other queries are updated too.

It would be incredibly useful if we could define a Group that could moderate the links that was separate from the Administrators. Am I just overlooking this feature?

The moderators can moderate the links

Right, but what if I don't want all of my moderators to moderate links, but only specific ones? Or specific groups of moderators?

That's a little over this mod so far... I'll look to get it into the next version tho

I must be dumber than a skunk, but after downloading the zip file, I can not seem to find a method of "adding" ubblinks to my ubbthreads install.


Please advise with a little more substance for us "beginner" users.

Thanks

Woops...I guess I'm not that dumb after all.

Figured it out

Ok..now I have no clue..

Want to add a "Links" link to the breadcrumb bar. Guess its a new methodology vs 7.1 so I can not figure out how to do so.

Can someone advise?

Thanks

Ok,

I figured that out as well.

So now I know how to solve all my issues with UBBThreads.

First I try to make it work for days...
I give up in frustration...
I post on UBBDEV for an answer...
Then solve it myself, only AFTER posting on UBBDEV.

Hmmm....magical web site?

Yes, we're magical

Sorry for not responding earlier, work has had me busy this week

Allen,
I would like to try to install this, but not real clear on how to set up the tables. I'm running Threads 7.3. I gather I need to create the tables needed manually, but:

1) What tables are needed?
2) What are the fields and their properties for each table?

hmmm... I need to update the original post to say that this is installed by the web now. You can access it directly by going to:

ubbthreads.php?ubb=links_install

Thank Allen. I could have sworn I tried that, but will try again.

Allen, thanks - I got it working! One question though. I can see how to "sort order" the man categories, but is there a way to also sort-order the sub-cats (other that manually from the database?)

That's not how subcats were built way back when - the whole cats thing needs to be re-done to make it more flexible - could be simple-ish, but I need to dig some into the code

I tried installing this last night, and yes I was confused as to how to install it at first too but then figured that out, but I have 2 questions...

Are we suppose to create our own link somewhere on the site to administer or even just go to it?

Second, The layout was all jacked up when going to the main links page using the black and gold styles. I didn't even think about testing the default syles so I'm not sure if it is having the same issue with them.

I'm using 7.3.1, freshly installed this week with no other mods other than the black and gold style.

The layout should be ok unless there's an issue with the style. I'd need to see it to find out. There's still some old code in there and it's possible a tbopen or tbclose was used without the proper corresponding tag.

You create links to it either in your overall site navigation, or in your forum's topnav template - that would be up to you to decide

finally got around to installing this, this is great!

Glad you like it - tho there's a few options I'd loved to have added I think it works well for what it does

a feature that would be nice; notification of links waiting to be approved,

I am noticing some odd CSS issues, like when I approve a link, or add a new category, the next page has a huge gap between my header and the links menu, I thought I was getting a blank page till I scrolled down.

am I missing something? or is there no way to edit the links once they are approved? no way to delete them? correct spelling? update the link?

I see that it can be done for pending submissions, but not for anything previously approved.

I know squat about MySQL and have no clue how to edit in there.

the CSS issues seem to be with the Koniro skin,
I just figured out what the red and green dots are next to a link!

hehe, it's been a while since I've looked at the code, but I remember the red and green dots - they should do what you need

I have noticed when someone adds an ' to something, the script adds a \ before it.

so "you're" comes out like "you\'re"

there is probably an addslashes without a stripslashes in the code..

Si, been a year or more since I've looked at the code

I may track down the offending addslashes and bug SD where to put the stripslashes

hehe, there's 4-5 addslashes and not one stripslash

i can track it down for you allen... if you want.. just send me the latest code...

it's up to you.. you've done a fine job so far... nice addon!

Gracias SD - the first post here has the most current code.

ah, mah bad.. i'll d/l it and have a looksee..

edit: ok.. dl'd it and the code is well commented, so i should be able to give this a go.. one thing is important to be added is to use mysql_real_escape_string to prevent malicious SQL baddies.. but overall, very good structure!!

I am aiming for 2 weeks (got a day job) to have a rev for your approval, Allen..

I am getting an error when people try to follow any of the "latest links"

File not found: scripts/links_redirectphp.inc.php

I fixed it!

line 643 in links.inc.php has an error,
search for and replace it with

Merci BF - initial post updated with bugfix

at some point in recent history, my links stopped parsing correctly, instead of passing you through to the URL (http://rollingheavymagazine.com),

it puts it all together like

/threads/ubbthreads.php/ubb/links_redirect/lid/198/url/http://rollingheavymagazine.com

I have no idea how long this has been happening.....