Just a note... I downloaded what I think is the latest copy of this (looks much like what is here at threadsdev), and found that if I allowed anonymous users to submit links, the form was a little out of whack... (the e-mail input box wrapped to the next line...)<br /><br />To fix this, open links_submit_form.php and change line #63 to this:<br /><br />instead of <br /><br />That seemed to fix it for me.<br /><br />Thanks for all the updates on this!!

Original zip from first post updated with the latest code from this thread. Please let me know if I missed anything <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> <br /> <br />Thankyou to everyone who's contributed their time and knowledge to this great piece of work <img src="http://www.ubbdev.com/forum/images/graemlins/waytogo.gif" alt="" /> <br /> <br />I fixed a few more xhtml errors, there's still a few left <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Just to make sure, becuase I want to upgrade this also: It's Fishtails original .zip that you updated? Thanks!

is the subcatagory sort fixed on the add a link drop down form?

I just downloaded the zip from the first post and still got the following SQL error during install: <br /> <br />SQL ERROR: Unable to do_query: CREATE TABLE w3t_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) ) <br />You have an error in your SQL syntax near ''', cat_order tinyint(10) NOT NULL default '0', ' at line 8Database tables have been created. You can now add categories and links. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />I found the solution in the thread but it must have escaped inclusion into the updated zip. <br /> <br />Bill

Hi, <br /> <br />This hack could be a nice way to make some additional ad revenue. What I was thinking about was to allow sites / companies that you link to to upgrade their link, for a fee or free (up to you I suppose). <br /> <br />This upgrading could be a different style to the link (i.e. larger font / bolder / italics) or even a small banner displayed next to or below the link. <br /> <br />It would be even better if we could add different levels of priority to the links (each with a different style associated to them) and then sort the list on links by priority first before alphabetically. <br /> <br />How much work would it be to add these features? <br /> <br />Sanuk!

I noticed here at Threadsdev when you check the 'Who's Online' scrren it will show that someone is viewing the links database. The version of TLD I just installed just shows 'Private' when someone uses the db.<br /><br />Is there some code I have to add to get the Who's Online screen to display members using TLD?<br /><br />Thanks,<br />Bill

[]bjsjr said:<br />I noticed here at Threadsdev when you check the 'Who's Online' scrren it will show that someone is viewing the links database. The version of TLD I just installed just shows 'Private' when someone uses the db.<br /><br />Is there some code I have to add to get the Who's Online screen to display members using TLD?<br /><br />Thanks,<br />Bill [/]<br />Bill,<br /><br />Add the bellow code to your /ubbthreads/language/english/online.php file.<br /><br />

Thanks a lot! I knew it had to be something simple <img src="http://www.ubbdev.com/forum/images/graemlins/blush.gif" alt="" /><br /><br />Bill

I wonder if anyone can help. I just uploaded the links directory to /ubbthreads/links and when I try to go to /ubbthreads/links/links.php, I get the following error message: <br /> <br />=========== <br /> <br />Warning: main(main.inc.php): failed to open stream: No such file or directory in /home/flighta/public_html/ubbthreads/links/links.php on line 52 <br /> <br />Fatal error: main(): Failed opening required 'main.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/flighta/public_html/ubbthreads/links/links.php on line 52 <br /> <br />=========== <br /> <br />Line 52 is: <br /> <br /> $html = new html; <br /> <br />=========== <br /> <br />Can anyone tell at a quick glance what I might have done wrong? <br /> <br />Thanks, <br /> <br />Jason

[]Sky YYZ said: <br />I wonder if anyone can help. I just uploaded the links directory to /ubbthreads/links and when I try to go to /ubbthreads/links/links.php, I get the following error message: <br /> <br />=========== <br /> <br />Warning: main(main.inc.php): failed to open stream: No such file or directory in /home/flighta/public_html/ubbthreads/links/links.php on line 52 <br /> <br />Fatal error: main(): Failed opening required 'main.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/flighta/public_html/ubbthreads/links/links.php on line 52 <br /> <br />=========== <br /> <br />Line 52 is: <br /> <br /> $html = new html; <br /> <br />=========== <br /> <br />Can anyone tell at a quick glance what I might have done wrong? <br /> <br />Thanks, <br /> <br />Jason [/] <br />If I recall correctly, you need to put the files in the ubbthreads directory with the current changes or redirect them to the /links folder.

Yep the files no longer go in their own directory. They follow the threads directory structure now.

looks like im going to have to give this one another try...

Hi guys,<br /><br />Okay I installed it in the /ubbthreads directory. I clicked on "links administration" and this is what followed:<br /><br />=======================<br /><br />If you have NOT already created your database tables and this is your first install, you can do so by clicking here. :: So I did.<br /><br />=======================<br /><br />Next I got this:<br /><br />=======================<br /><br />SQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_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) ) <br />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 ''', cat_order tinyint(10) NOT NULL defaSQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_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 '', 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) ) <br />Table 'w3t_links_links' already existsSQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_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) ) <br />Table 'w3t_links_favorites' already existsDatabase tables have been created. You can now add categories and links. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /><br /><br />========================<br /><br />and when I clicked on "Links Home" in the navigation bar I got this:<br /><br />========================<br /><br />SQL ERROR: Thu, Jan 08 2004 15:57:24 -0500 Unable to do_query: SELECT * FROM w3t_links_categories WHERE parent_id = '0' ORDER BY 'cat_order' <br />Table 'flighta_thread.w3t_links_categories' doesn't exist<br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/flighta/public_html/ubbthreads/links_show_cat.php on line 66<br /><br />=======================<br /><br />It looks like the w3t_ table(s) didn't create automatically? Don't suppose there are any more ideas? Sorry, I wish it had gone smoothly.<br /><br />Thanks,<br /><br />Jason <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

Looks like I need to find where the create table code is, more specifically "w3t_links_categories" and change it to:<br /><br />CREATE TABLE w3t_links_categories <br />( <br />cat_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, <br />parent_id int(11) DEFAULT NULL, <br />title varchar(50) NOT NULL DEFAULT '', <br />cat_desc varchar(60) DEFAULT NULL, <br />cat_order tinyint(10) NOT NULL DEFAULT '0' <br />)<br /><br />....looking for it now.

That was it! Found it in links_admin.php and replaced the code starting on line 488.<br /><br />Off to work I go... <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />Thanks!

hmm quick.. someone call the net.. hes talking AND answering himself... <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

haha... yeah, actually I get bugged about that at work all the time! <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> There's one person worse than me though! <br /> <br />Well I figure this way if anyone else has the same problem they will see how to correct it... hence the talking to myself bit. <br /> <br />There are a couple of different troubleshooting techniques to try deep within this thread... but this is the one that works for me. Maybe the code could be updated in the original d/l by the powers-that-be. Or not, either way... this is a great mod. Thanks!

Well here's something maybe someone else can help me with...<br /><br />I noticed it won't validate links from within your own domain. Is there a trick to get it to do that?<br /><br />Thanks!

how do you mean? GOt an example?