Ok so admittedly I am probably getting carried away with this script but I can't seem to leave it alone. The attachment contain the following mods:<br /><br />1. Fixed the default rate in the 'rate this link' page to default to 1. It currently defaults to blank. I think the author intended it this way but made a typo.<br />2. Added a configurable option to allow / disallow the link submitter from voting on his/her own link. <br />3. Added a configurable option to specify the minimum number of votes required before a link will appear on the Top Rated page and before the 'stars' ratings will appear next to a link.<br />4. When a link submitter clicks on his/her link, it is no longer counted as a hit.<br /><br />I'm going to try to leave this alone now but I'm not crazy about the way that the redirect sends the link in the clear.

So, does the first post in the thread contain the very latest release?<br /><br />I tried to install this mod when it was still "new" and had errors everywhere. lol.<br /><br />But since everyone is getting it working and you devoted some time to it, I might have to give it a go again...

[]DrChaos said:<br />So, does the first post in the thread contain the very latest release?<br /><br />I tried to install this mod when it was still "new" and had errors everywhere. lol.<br /><br />But since everyone is getting it working and you devoted some time to it, I might have to give it a go again... [/]<br /><br /><br />ditto! <img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" />

I think the first post is the latest (it's what I started with). Did it error out before or after you added my mods? You may need to include the other mods that I included in this thread. What kind of errors are you getting? Seems like this thread should me in the mods forum.

I was just wondering if there was one zipped file that had all the fixes. I installed it a long time ago. But as I read the post it seems that few people got it to work with your help.

I'll try and zip up what I have tonight.

I've got this far now guys<br />i've installed it, called up links.php and now get this error<br /><br />[]<br />Script:<br />Line#:<br />SQL Error: Table 'fordmond_threadsdb.w3t_links_favorites' doesn't exist<br />SQL Error #: 1146<br />Query: SELECT w3t_links_favorites.uid, w3t_links_favorites.lid, w3t_links_links.lid, w3t_links_links.title, w3t_links_links.url, w3t_links_links.description FROM w3t_links_favorites, w3t_links_links WHERE w3t_links_favorites.uid = '2' AND w3t_links_favorites.lid = w3t_links_links.lid <br />[/]<br /><br />any ideas?<br />i know it's something to do with tables, but i dont know how to fix it!

You're missing tables. I don't know if there is an install script with this, but if there is, it appears that it didn't finish.

hmm dang diggity.<br />i suppose i could add them manually via phpmyadmin yeah?

Here are my files. Sorry for the delay.

i cant figure this out<br />why doesnt the install script create the tables guys?

Very appreciated <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Looks pretty here:<br /><br />http://www.ubbdev.com/forum/links.php<br /><br /><img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" /><br /><br />I updated the original post in this thread with emkempter's files added <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

[]AllenAyres said:<br />Very appreciated <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Looks pretty here:<br /><br />http://www.ubbdev.com/forum/links.php<br /><br /><img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" /><br /><br />I updated the original post in this thread with emkempter's files added <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> [/]<br /><br />hey allen<br />yours doesnt seem to be working m8.<br /><br /> [] Warning: main(languages//links.php): failed to open stream: No such file or directory in /home/threadsdev/domains/threadsdev.com/public_html/forum/links.php on line 55 [/]

Im trapped at the same error. I use the latest version witch runs on php5 (globals off) under 6.4.x<br /><br />after Update to 6.5 I modify this:<br /><br />// Require the library<br /> require ("includes/main.inc.php");<br /> require ("languages/${$config['cookieprefix']."w3t_language"}links.php");<br /><br />to reflect the moving of the main.inc.php to the includes directory but get:<br /><br />Warning: main(languages/links.php) [function.main]: failed to open stream: No such file or directory in /...path.../dragonclan-forum.de/ubbthreads/links.php on line 41<br /><br />Any Idea ?

[]Zarzal said:<br />Im trapped at the same error. I use the latest version witch runs on php5 (globals off) under 6.4.x<br /><br />after Update to 6.5 I modify this:<br /><br />// Require the library<br /> require ("includes/main.inc.php");<br /> require ("languages/${$config['cookieprefix']."w3t_language"}links.php");<br /><br />to reflect the moving of the main.inc.php to the includes directory but get:<br /><br />Warning: main(languages/links.php) [function.main]: failed to open stream: No such file or directory in /...path.../dragonclan-forum.de/ubbthreads/links.php on line 41<br /><br />Any Idea ? [/]<br />I had the same problem, but I got it working but using the full paths.<br /><br />Change this:<br /><br /><br /><br />To This:<br /><br /><br /><br />Probably not the right way to do it, but it does work.

One important update on ANYTHING that you're converting to work on 6.5 - is that you have to change<br /><br />${$config['cookieprefix']."w3t_language"}<br /><br />to<br /><br />{$myprefs['language']}<br /><br />That'll fix why it's leaving "english" out of the language file include. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Thanks Josh. Last night I do the fix with fixed path to test out where the error comes from. I know that something was changed and that is it.<br /><br />To bring TLD to work on Threads 6.5 do the following changens:<br /><br />links.php:<br />require ("./includes/main.inc.php");<br />require ("./languages/{$myprefs['language']}/links.php");<br /><br />links_admin.php<br />require ("./includes/main.inc.php"); <br /><br />links_redirect.php<br />require ("./includes/main.inc.php");

i'm still getting this problem:<br /><br />Script:<br />Line#:<br />SQL Error: Table 'fordmond_threadsdb.w3t_links_links' doesn't exist<br />SQL Error #: 1146<br />Query: SELECT lid,cat_id FROM w3t_links_links WHERE approved = '1'<br /><br />Please use your back button to return to the previous page.<br /><br /><br />how do i insert these tables?

Hmmm, even if i try the links_admin.php?op=upgrade_from_1_0 or the links_admin.php?op=create_tables manually which i've found in the links_admin.php file i STILL get the same error.<br />HELP!<br />I really want this working and it's doing my head in.

OK- I've put this on a couple of 6.5 forums. I don't have a "pretty" way to do it, or else I'd re-post the mod for 6.5.<br />If I find myself with free time, I will. But for now I'm swamed.<br /><br />To use this mod with 6.5 - I did the following.<br /><br />inks.php:<br />require ("./includes/main.inc.php");<br />require ("./languages/{$myprefs['language']}/links.php");<br /><br />links_admin.php<br />require ("./includes/main.inc.php");<br /><br />links_redirect.php<br />require ("./includes/main.inc.php"); <br /><br /><br />Then I manually created the tables using my Threads SQL interface. The following 3 queries need to be run.<br /><br />CREATE TABLE `w3t_links_categories` (<br /> `cat_id` int(11) NOT NULL auto_increment,<br /> `parent_id` int(11) default NULL,<br /> `title` varchar(50) NOT NULL default '',<br /> `cat_order` tinyint(10) NOT NULL default '0',<br /> `cat_desc` varchar(60) default NULL,<br /> PRIMARY KEY (`cat_id`)<br />) TYPE=MyISAM AUTO_INCREMENT=32 ;<br /><br /><br /><br /><br />CREATE TABLE `w3t_links_favorites` (<br /> `num` int(9) unsigned NOT NULL auto_increment,<br /> `lid` int(9) unsigned NOT NULL default '0',<br /> `uid` int(9) unsigned NOT NULL default '0',<br /> PRIMARY KEY (`num`),<br /> KEY `FAV_indx1` (`uid`)<br />) TYPE=MyISAM AUTO_INCREMENT=11 ;<br /><br /><br /><br /><br />CREATE TABLE `w3t_links_links` (<br /> `lid` int(11) NOT NULL auto_increment,<br /> `cat_id` int(11) default NULL,<br /> `approved` tinyint(4) NOT NULL default '1',<br /> `title` varchar(100) NOT NULL default '',<br /> `url` varchar(100) NOT NULL default '',<br /> `description` text NOT NULL,<br /> `date_added` int(11) unsigned NOT NULL default '0',<br /> `name` varchar(100) NOT NULL default '',<br /> `email` varchar(100) NOT NULL default '',<br /> `hits` int(11) NOT NULL default '0',<br /> `user_number` int(11) NOT NULL default '0',<br /> `member` char(2) NOT NULL default '',<br /> `linkratingsummary` double(6,4) NOT NULL default '0.0000',<br /> `totalvotes` int(11) NOT NULL default '0',<br /> PRIMARY KEY (`lid`)<br />) TYPE=MyISAM AUTO_INCREMENT=65 ;<br /><br /><br />Once you make those tweaks, and create the tables, then it should all function normally.<br /><br />Probably wouldn't be difficult to figure out how to allow the admin script by the SQL error on initial install. Or create a "createlinktable.php" script which you could run first and then delete it. But the above works just fine. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />