Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
#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 Images
2462-TLD7.2.zip (35.68 KB, 60 downloads)
The Link Directory - TLD v. 7.2
SHA1: f14ad134db1122f01e8c84995b608a88cc73bf63
Sponsored Links
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?
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?
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?
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Same error here

frown

Sponsored Links
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.
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?
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?
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?
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
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.

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?
Joined: Oct 2006
Posts: 21
Newbie
Offline
Newbie
Joined: Oct 2006
Posts: 21
Ok...so...er...what's the mod do?

Joined: Jan 2000
Posts: 5,806
Likes: 10
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,806
Likes: 10
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, I Find Rocks, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
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

Joined: Jan 2000
Posts: 5,806
Likes: 10
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,806
Likes: 10
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, I Find Rocks, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
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

Joined: Jan 2000
Posts: 5,806
Likes: 10
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,806
Likes: 10
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, I Find Rocks, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jul 2001
Posts: 808
Coder
Offline
Coder
Joined: Jul 2001
Posts: 808
works very well, thank you!

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

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

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

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

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?
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?
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?
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

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.
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?
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.

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?
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

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!?!

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.

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?
Joined: Jan 2007
Posts: 70
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
smile

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.

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

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

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
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,546
Posts293,802
Members13,838
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online 260
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 28
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,806
Greg Hard 4,625
Top Posters(30 Days)
isaac 8
Top Likes Received
isaac 46
Gizmo 10
Brett 7
Morgan 2
Top Likes Received (30 Days)
isaac 5
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 20200925.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.093s Queries: 97 (0.032s) Memory: 3.6734 MB (Peak: 4.1192 MB) Data Comp: Zlib Server Time: 2020-09-28 12:29:18 UTC
Valid HTML 5 and Valid CSS