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_";
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
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) )
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
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
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) )
#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
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 (
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.