Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
TLD 7.2 - Link Directory
#315098 08/07/2007 11:34 PM
Joined: Nov 2001
Posts: 10,369
JoshPet Offline OP
I type Like navaho
OP Offline
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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

Attached Files
2462-TLD7.2.zip (35.68 KB, 60 downloads)
The Link Directory - TLD v. 7.2
SHA1: f14ad134db1122f01e8c84995b608a88cc73bf63
Sponsored Links
Re: TLD 7.2 - Link Directory
JoshPet #315104 08/08/2007 10:23 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Thank you Josh, very appreciated thumbsup


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315107 08/08/2007 10:39 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
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 smile


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315108 08/08/2007 10:49 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
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.


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315112 08/08/2007 4:12 PM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Same error here

frown

Sponsored Links
Re: TLD 7.2 - Link Directory
Stephen G #315114 08/08/2007 5:29 PM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
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)
)

Last edited by blaaskaak; 08/08/2007 5:31 PM.
Re: TLD 7.2 - Link Directory
blaaskaak #315119 08/08/2007 10:50 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm...

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

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


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315120 08/08/2007 10:56 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmmm, a good part of the issue is we didn't get a language file, so there's no text smile


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315121 08/08/2007 11:03 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
language file added to original zip above.


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315122 08/08/2007 11:30 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
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 crazy


- Allen wavey
- What Drives You?
Sponsored Links
Re: TLD 7.2 - Link Directory
AllenAyres #315123 08/09/2007 12:25 AM
Joined: Nov 2001
Posts: 10,369
JoshPet Offline OP
I type Like navaho
OP Offline
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.

Re: TLD 7.2 - Link Directory
JoshPet #315125 08/09/2007 12:50 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
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 smile


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315552 09/06/2007 6:57 AM
Joined: Oct 2006
Posts: 21
Newbie
Offline
Newbie
Joined: Oct 2006
Posts: 21
Ok...so...er...what's the mod do?

Re: TLD 7.2 - Link Directory
Carte Blanche #315553 09/06/2007 10:14 AM
Joined: Jan 2000
Posts: 5,796
Likes: 8
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,796
Likes: 8
Think DMOZ, but for your UBB (if you don't know what DMOZ is, google it)


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: TLD 7.2 - Link Directory
Gizmo #315554 09/06/2007 2:36 PM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
Originally Posted by Gizmo
(if you don't know what DMOZ is, google it)


what's google? wink

Re: TLD 7.2 - Link Directory
blaaskaak #315557 09/06/2007 6:44 PM
Joined: Jan 2000
Posts: 5,796
Likes: 8
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,796
Likes: 8
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 wink... lol


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: TLD 7.2 - Link Directory
Gizmo #315559 09/07/2007 2:48 AM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
I'll settle for the smack on the head and live happely after smile

Re: TLD 7.2 - Link Directory
blaaskaak #315560 09/07/2007 3:16 AM
Joined: Jan 2000
Posts: 5,796
Likes: 8
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,796
Likes: 8
Happily ever after? so you discovered the booze cabinet in the admin lounge? :x


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: TLD 7.2 - Link Directory
JoshPet #315726 09/17/2007 9:22 AM
Joined: Jul 2001
Posts: 808
Coder
Offline
Coder
Joined: Jul 2001
Posts: 808
works very well, thank you!

Re: TLD 7.2 - Link Directory
Zarzal #315729 09/17/2007 1:59 PM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
I couldn't get it to work with 7.2

frown

Re: TLD 7.2 - Link Directory
Stephen G #315730 09/17/2007 2:22 PM
Joined: Jul 2001
Posts: 808
Coder
Offline
Coder
Joined: Jul 2001
Posts: 808
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

Re: TLD 7.2 - Link Directory
Zarzal #315731 09/17/2007 3:54 PM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
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

Re: TLD 7.2 - Link Directory
Stephen G #315802 09/24/2007 3:02 PM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Anyone know what I'm doing wrong to get this error ? I REALLY want to get this working.

smile

Re: TLD 7.2 - Link Directory
Zarzal #315810 09/24/2007 11:54 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
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.


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
Stephen G #315811 09/24/2007 11:55 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Originally Posted by GEN
Anyone know what I'm doing wrong to get this error ? I REALLY want to get this working.

smile


?? What platform are you running on?


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315813 09/25/2007 12:06 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
It looks like you didn't create all the tables, or they are of a different prefix


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315830 09/25/2007 12:18 PM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
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

Re: TLD 7.2 - Link Directory
Stephen G #315831 09/25/2007 1:21 PM
Joined: Sep 2007
Posts: 5
Lurker
Offline
Lurker
Joined: Sep 2007
Posts: 5
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


Last edited by mikey81; 09/25/2007 1:22 PM.
Re: TLD 7.2 - Link Directory
mikey81 #315833 09/25/2007 3:13 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Can you try running each create table on its own and see which one it chokes on?


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315834 09/25/2007 3:30 PM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
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.

Re: TLD 7.2 - Link Directory
blaaskaak #315836 09/25/2007 5:37 PM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Are you having the same problems? Did anyone get it to install correctly?


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315837 09/25/2007 5:39 PM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
I got to install correctly...

I changed the default prefix to ubbt_
created the tables manually

Re: TLD 7.2 - Link Directory
AllenAyres #315861 09/26/2007 3:00 AM
Joined: Sep 2007
Posts: 5
Lurker
Offline
Lurker
Joined: Sep 2007
Posts: 5
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!?!

Re: TLD 7.2 - Link Directory
mikey81 #315862 09/26/2007 3:20 AM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Same here.

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

Re: TLD 7.2 - Link Directory
Stephen G #315865 09/26/2007 7:49 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Good, if I get time I'll look at it later this week, it really needs a few issues worked out smile


- Allen wavey
- What Drives You?
Re: TLD 7.2 - Link Directory
AllenAyres #315866 09/26/2007 8:16 AM
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
smile

Re: TLD 7.2 - Link Directory
Stephen G #315868 09/26/2007 10:20 AM
Joined: Feb 2007
Posts: 329
Yarp™
Offline
Yarp™
Joined: Feb 2007
Posts: 329
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.

Re: TLD 7.2 - Link Directory
blaaskaak #315871 09/26/2007 3:39 PM
Joined: Jul 2001
Posts: 808
Coder
Offline
Coder
Joined: Jul 2001
Posts: 808
I use my old tables so I dont run the create process

Re: TLD 7.2 - Link Directory
Zarzal #315887 09/28/2007 8:18 PM
Joined: Feb 2004
Posts: 182
Member
Offline
Member
Joined: Feb 2004
Posts: 182
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. smile

Re: TLD 7.2 - Link Directory
JoshPet #316726 02/17/2008 6:32 AM
Joined: Jul 2001
Posts: 808
Coder
Offline
Coder
Joined: Jul 2001
Posts: 808
Has someone test this under V7.3b4?

Page 1 of 2 1 2

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
badfrog
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
Forum Statistics
Forums63
Topics37,533
Posts293,731
Members13,834
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online 207
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 6
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,796
Greg Hard 4,625
Top Posters(30 Days)
isaac 7
driv 3
Top Likes Received
isaac 34
Gizmo 8
Brett 7
Morgan 2
Top Likes Received (30 Days)
isaac 1
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2020 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200315.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.096s Queries: 97 (0.037s) Memory: 3.6561 MB (Peak: 4.1083 MB) Data Comp: Zlib Server Time: 2020-04-07 01:54:35 UTC
Valid HTML 5 and Valid CSS