 |
 |
 |
 |
#315098 - 08/07/07 11:34 PM
TLD 7.2 - Link Directory
|
I type Like navaho
Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
|
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 Installimages - 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.netUpdated by - Joshua Pettit - http://www.JoshuaPettit.comCredits - Rick Baker, Gardener, Raconteur and ThreadsDev.com Working Under - UBB.Threads Version 7.2
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#315114 - 08/08/07 05:29 PM
Re: TLD 7.2 - Link Directory
[Re: GEN]
|
Enthusiast
Registered: 02/25/07
Posts: 304
Loc: The Netherlands
|
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_: 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)
)
Edited by blaaskaak (08/08/07 05:31 PM)
_________________________
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#315731 - 09/17/07 03:54 PM
Re: TLD 7.2 - Link Directory
[Re: Zarzal]
|
Power User
Registered: 01/01/07
Posts: 52
Loc: UK
|
I tried running Blasskaaks 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',
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
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#315831 - 09/25/07 01:21 PM
Re: TLD 7.2 - Link Directory
[Re: GEN]
|
Lurker
Registered: 09/20/07
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
Edited by mikey81 (09/25/07 01:22 PM)
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#315866 - 09/26/07 08:16 AM
Re: TLD 7.2 - Link Directory
[Re: AllenAyres]
|
Power User
Registered: 01/01/07
Posts: 52
Loc: UK
|
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#315868 - 09/26/07 10:20 AM
| | | | |
