TLD 7.2 - Link Directory - UBB.Developers

This is originally Fishtails TLD Link Directory Addon, so I take no credit for the scripts. All credit and rights go to fishtails. I simply "wrapped" the scripts to function within UBB7 so that anyone who used this mod in the past, can add it again, and presuming you still have your old links tables, all your old links will still be there.

To Install
images - goes in images/links
scripts - go in /scripts directory
templates - go in /templates/default directory

Once installed, you can add a link to your menubar for /ubbthreads.php?ubb=links for a link to the Link Directory.
If you are installing for the first time, you can click the "Admin" link at the bottom of the link directory area and create the tables.

If you had this installed under the older version of UBB.Threads (6 series) then it presumes your w3t_links_links, w3t_links_categories, and w3t_links_favorites are still present in your database, and still have the w3t_ table prefix.

If the table prefix is different, then you'll see a spot in each of the 3 scripts to edit this:
$config['tbprefix'] = "w3t_";

Author - Fishtails - http://www.fish-tails.net
Updated by - Joshua Pettit - http://www.JoshuaPettit.com
Credits - Rick Baker, Gardener, Raconteur and ThreadsDev.com

Working Under - UBB.Threads Version 7.2

Description: The Link Directory - TLD v. 7.2

Attached File

2462-TLD7.2.zip (60 downloads)

Thank you Josh, very appreciated

Hey Josh, there were a good number of mac files in there (ds store, etc.). I removed them and uploaded the replacement zip. If I broke something, let me know

When accessing it the first time I am getting:

Script:
Line#:
SQL Error: Table 'threads.w3t_links_links' doesn't exist
SQL Error #: 1146
Query: SELECT lid,cat_id FROM w3t_links_links WHERE approved = '1'

I don't have it installed from the old version, so I don't have tables created yet.

Same error here

Same here, and http://themepark.nl/ubb/ubbthreads.php?ubb=links_admin&op=create_tables doesn't work also.

The queries in the script are wrong also, atleast I had to rework them manually to be able to create the databases.

For those who want to play, I executed this in phpmyadmin (I did change the table prefix to ubbt_:

Code

			CREATE TABLE ubbt_links_links
			(
				lid int(11) NOT NULL auto_increment,
				cat_id int(11) default NULL,
				approved tinyint(4) NOT NULL default '1',
				title varchar(100) NOT NULL default '',
				url varchar(100) NOT NULL default '',
				description text NOT NULL,
				date_added int(11) unsigned NOT NULL default '0',
				name varchar(100) NOT NULL default '',
				email varchar(100) NOT NULL default '',
				hits int(11) NOT NULL default '0',
				user_number int( 11 ) NOT NULL default '0',
				member char(2) NOT NULL default '',
				linkratingsummary double(6,4) NOT NULL default '0.0000',
				totalvotes int(11) NOT NULL default '0',
				PRIMARY KEY  (lid)
			)


			CREATE TABLE ubbt_links_categories
			(

				cat_id int(11) NOT NULL auto_increment,
				parent_id int(11) default NULL,
				title varchar(50) NOT NULL default '',
				cat_desc varchar(60) default NULL,
				cat_order tinyint(10) NOT NULL default '0',
				PRIMARY KEY  (cat_id)
			)


			CREATE TABLE ubbt_links_favorites
			(
				num int(9) unsigned NOT NULL auto_increment,
				lid int(9) unsigned NOT NULL default '0',
				uid int(9) unsigned NOT NULL default '0',
				PRIMARY KEY  (num),
				KEY FAV_indx1 (uid)
			)

hmmm...

/ubbthreads.php/ubb/links/op/links_admin

doesn't throw an error, but it doesn't do much either

hmmmm, a good part of the issue is we didn't get a language file, so there's no text

language file added to original zip above.

Was this based off tld 1.5 or 2.1? Some things like the search function we added and some bug fixes look to be missing

Thanks AA. This was based off whatever my client was running - which in looking now, I see was 1.5. I assumed it was the latest - but guess not. Doah. Good catch on the language file.

ok, thanks. There were quite a few changes by you, myself, omegatron, ekempter, gardner, id242 and a few others between Mark's release in may '03 and our last one in 12/05 - some were to just update to work with the different 6-series threads, others were to fix a lotta bugs and add some nice features. I may look at it at some point. If I do I need to write an importer for the old classic links script, it imported from the OLD gossamer threads links script

Ok...so...er...what's the mod do?

Think DMOZ, but for your UBB (if you don't know what DMOZ is, google it)

Originally Posted by Gizmo

(if you don't know what DMOZ is, google it)

what's google?

If you don't know what Google is, you've obviously been living under a Rock, so yahoo it...

If you don't know what yahoo is, you're obviously highly handicapped and should ask your parental guardian to smack you in the head and how to live life online

... lol

I'll settle for the smack on the head and live happely after

Happily ever after? so you discovered the booze cabinet in the admin lounge? :x

works very well, thank you!

I couldn't get it to work with 7.2

There are 2 little bugs in links.inc.php:

line 141 and line 1167 contains a double }
change it to a single }

what the first }} do .. I dont now but the second break the breadcrumb link

The same problem in links_admin.php on line 805 and links_redirect.php line 157

I tried running Blasskaaks query

Code

CREATE TABLE ubbt_links_links
			(
				lid int(11) NOT NULL auto_increment,
				cat_id int(11) default NULL,
				approved tinyint(4) NOT NULL default '1',
				title varchar(100) NOT NULL default '',
				url varchar(100) NOT NULL default '',
				description text NOT NULL,
				date_added int(11) unsigned NOT NULL default '0',
				name varchar(100) NOT NULL default '',
				email varchar(100) NOT NULL default '',
				hits int(11) NOT NULL default '0',
				user_number int( 11 ) NOT NULL default '0',
				member char(2) NOT NULL default '',
				linkratingsummary double(6,4) NOT NULL default '0.0000',
				totalvotes int(11) NOT NULL default '0',
				PRIMARY KEY  (lid)
			)


			CREATE TABLE ubbt_links_categories
			(

				cat_id int(11) NOT NULL auto_increment,
				parent_id int(11) default NULL,
				title varchar(50) NOT NULL default '',
				cat_desc varchar(60) default NULL,
				cat_order tinyint(10) NOT NULL default '0',
				PRIMARY KEY  (cat_id)
			)


			CREATE TABLE ubbt_links_favorites
			(
				num int(9) unsigned NOT NULL auto_increment,
				lid int(9) unsigned NOT NULL default '0',
				uid int(9) unsigned NOT NULL default '0',
				PRIMARY KEY  (num),
				KEY FAV_indx1 (uid)
			)

to create the table - as I get this:

We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Table 'galactiF.ubbt_links_links' doesn't exist
SQL Error #: 1146
Query: SELECT lid,cat_id FROM ubbt_links_links WHERE approved = '1'

but it says :

#1064 - 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 'CREATE TABLE ubbt_links_categories

Anyone know what I'm doing wrong to get this error ? I REALLY want to get this working.

Originally Posted by Zarzal

There are 2 little bugs in links.inc.php:

If I remember right there's a good number of little bugs here and there in the code this is based on. If I ever get time I'll look at updating it.

Originally Posted by GEN

Anyone know what I'm doing wrong to get this error ? I REALLY want to get this working.

?? What platform are you running on?

It looks like you didn't create all the tables, or they are of a different prefix

Oh, the prefix is the same.

It's just every time I run the query to create the tables it doesn't do it in phpMyAdmin

I have allmost the same problem. Centos 5.0 latest mysql.

SQL-query:

CREATE TABLE ubbt_links_links(

lid int( 11 ) NOT NULL AUTO_INCREMENT ,
cat_id int( 11 ) default NULL ,
approved tinyint( 4 ) NOT NULL default '1',
title varchar( 100 ) NOT NULL default '',
url varchar( 100 ) NOT NULL default '',
description text NOT NULL ,
date_added int( 11 ) unsigned NOT NULL default '0',
name varchar( 100 ) NOT NULL default '',
email varchar( 100 ) NOT NULL default '',
hits int( 11 ) NOT NULL default '0',
user_number int( 11 ) NOT NULL default '0',
memberchar( 2 ) NOT NULL default '',
linkratingsummary double( 6, 4 ) NOT NULL default '0.0000',
totalvotes int( 11 ) NOT NULL default '0',
PRIMARY KEY ( lid )
) CREATE TABLE ubbt_links_categories(
cat_id int( 11 ) NOT NULL AUTO_INCREMENT ,
parent_id int( 11 ) default NULL ,
title varchar( 50 ) NOT NULL default '',
cat_desc varchar( 60 ) default NULL ,
cat_order tinyint( 10 ) NOT NULL default '0',
PRIMARY KEY ( cat_id )
) CREATE TABLE ubbt_links_favorites(
num int( 9 ) unsigned NOT NULL AUTO_INCREMENT ,
lid int( 9 ) unsigned NOT NULL default '0',
uid int( 9 ) unsigned NOT NULL default '0',
PRIMARY KEY ( num ) ,
KEY FAV_indx1( uid )
)

MySQL retourneerde:

#1064 - 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 'CREATE TABLE ubbt_links_categories
(

cat_id int(11) NOT NULL auto_inc' at line 21

Can you try running each create table on its own and see which one it chokes on?

Originally Posted by AllenAyres

It looks like you didn't create all the tables, or they are of a different prefix

I did rename the w3t prefix to ubbt, I also updated the code itselve to use that new prefix.

Are you having the same problems? Did anyone get it to install correctly?

I got to install correctly...

I changed the default prefix to ubbt_
created the tables manually

Originally Posted by AllenAyres

Can you try running each create table on its own and see which one it chokes on?

Seperately the tables create with no problems!?!

Same here.

Now all I need to do is get some of the display issues sorted.

Good, if I get time I'll look at it later this week, it really needs a few issues worked out

Great to hear Allen!

We are kinda planning on using this, but I held it back a little after hearing about the problems in it.

I use my old tables so I dont run the create process

Hi,
if one the Line

$config['tbprefix'] = "ubbt_"; // The Prefix to the Links tables

in the files links.inc.php, links_admin.inc.php, links_redirect.inc.php by

$config['tbprefix'] = "{$config['TABLE_PREFIX']}"; // The Prefix to the Links tables

substituted, one does not need before the installation only the files with the right Prefix edit.

Has someone test this under V7.3b4?

Runs with me in the forum.

one problem gone on my checklist, thanks for testing.

I take a closer look to TLD running under UBB.threads 7.3
I found some layout problems if you use sidebars. I try to fix it and here you can download my fix. I split the template in links and links_admin.

Attached File

links.zip (4 downloads)

Thank you Zarzal

I am making some headway in updating this to use more of 7.3's features (like SEO cats and links) and completely 'wordletizing' it. It will be a few days before I have it completed for testing tho... headed to Austin shortly and I need to get some work done here

You can see some of the progress here:

http://www.praisecafe.org/forum/ubbthreads.php/ubb/links

At that point we need to see about putting some of the features we had added for 2.2-2.5 back that were skipped in the update to 7.x

This looks nice. I still wait for the final release.

hmmm...

I take it no-one has actually run this script? If so, are you able to actually add links?

When I submit the script to add the link it refreshes the page back to the submit link page - this time with all fields blank *except* now the title you added for the previously submitted site is now sitting in the category box.

Not counting the install bug (it won't install without creating the tables manually), this is still pretty buggy. Will need some more work before it's ready for public use.

add a link an my page or on your page? On my website it works fine.
/update: on your page i get a blank screen if I try and the url looks misformed:
http://www.praisecafe.org/forum/ubbthreads.php/ubb/links/op/Submit_Link/cat_id/.html
I dont use the 'add .html' option on my board.

Zarzal, do you mind attaching the links.inc.php file you are using? I am having a few issues with the submission. And if you can, can you see about turning on the .html option just for a minute to test adding one site to see if that's the issue? Turning the .html extension off didn't fix the issue on my site.

I will watch my board and if I see a timeslot with less user I will test it.

Danke, and when you get a chance, please attach the links.inc file, if you give it a .txt extension you should be able to attach it fine.

here we go:

Attached File

links.inc.php.txt (5 downloads)

Thank you - I get the same problem like I mentioned before. I am using mysql and php 5+. I have no idea what the problem might be. If you look at the form for submitting the info there's something odd going on with the categories, there's several options in there for categories. I'm going to work on it and see if I can get it cleaned up.

Looking at this line:

When I view source from the web page it's getting an empty value:

This line:

I get an empty value for $cat_id and $title:

Not sure what's going on...

Do you ran any kind of security plugins on your websever? ModSecurity?

No, but I am running php 5.1.x - I wonder if this isn't up to php 5.1's coding standards...

Part of the issue is "title" is used for the name of the site being submitted and the name of the category being submitted to. Need to update them to cat_title and url_title.

OK, found the issue. Working on wordlets right now.

I test the .html extension on my site nd it work. Spider frindly urls too.

Hmmm i just installed this, manually put in the tables as noted on the past posts, and it worked. Awesome... I dont notice any issues yet. Running version 7.1 threads still though.

but at least this is working now for our site.

I loved this mod years ago, and so glad to have it back again! Thanks for all your work on this guys!

Glad you like it, it should work pretty well for all 7.x series, I believe.

I just encounter a little problem on my site. My mods seems not to be able to click the green LED to edit a link in the DB. They get a message that they must be admin to do this. I cannot find the check. I guess I must just change a little thing to allow mods to edit the links.

Can anyone assist me in this case?

Do you have a link to it Zarzal?

Link to what? The Link DB? http://www.dragonclan-forum.de/board/ubbthreads.php?ubb=links

But the link dont help you because you are not a mod

If you register I can change it if you like.

I guess its a missing compare of the rights. it must be administratos && moderatrors or something like this.

In links.inc starting line 109 I found this:

Code

// Set links admin link
   if (($user['USER_MEMBERSHIP_LEVEL'] != 'Administrator') && ($user['USER_MEMBERSHIP_LEVEL'] != 'Moderator')) {
      $links_admin_delete_link = ""; // Don't give option to delete a link
   }
   else {
      $links_admin_link = "   *  <a href=\"{$config['BASE_URL']}/ubbthreads.php?ubb=links_admin&op=links_admin\">{$ubbt_lang['LINKS_ADMIN']}</a>"; // Provide a link to the links admin
      $links_admin_delete_link = "  *  <a href=\"{$config['BASE_URL']}/ubbthreads.php?ubb=links_admin&op=delete_link&lid={$row[lid]}\">{$ubbt_lang['LINKS_ADMIN_DELETE']}</a>   ";
   }

I wonder why this dont work

ahhh, found it. wrong settings in links_admin.inc.php

I change the permissions in top of the file and all work as it should.

is there a updated download of this with all the compiled fixes etc?

has anyone used if on UBB 7.5.3 ?

does anyone have a link to where I can see this in action?

I believe Fishtails has it on his site still. It is kinda hidden if not registered.
But you can see it at
http://www.firstcoastangler.com/forum/ubbthreads.php?ubb=links
Matter of fact try this topic HERE
It is a more current topic and it has a demo link that is more active.
I just noticed fishtails is using this version(ubb links) in lieu of the tld flavor

The first post in the topic Ruben linked to should contain current code and there's no reason it shouldn't work on current versions.

"fishtails" most likely has an oooooooollllldlddd version (pre-this version).

thanx allen, will check it out this evening

have all the SQL issues been sorted out? or do I still need to manually create the various tables, etc?

It's an automagic install, there should be instructions in the first post.

Oh, and the demo forum it links to is running current ubb.threads code.

Okay Allen I am confused now.
What Mod is really the most current. ubb links or this tld version
I can't find a demo link on this post. At least not the topic start post.

The other one is much more current, Josh based this version off the fishtails version and missed out on quite a bit of the updates - plus this one states it's for threads 7.2, the other is for 7.3+

Okay thanks. I thought I was confused but I guess not now.