Fellow Threadaffficianados,<br /><br />I am sitting here populating a new threads driven website. I am using the TLD mod. I am trying to add a URL that starts with "https://" instead of "http://" Apparently TLD automatically adds "http://" to the beginning of any string you add in the input form. "http://" is already in the box, but if I delete it out and enter the "https://blahblah blah.com" link it gets "http://" added to the beginning with ain't gonna work.<br /><br />Is this a limitation of TLD or am I doing somethnig wrong. Is there a way to mod this mod to allow me to put in any URL I want... I am sure this feature was put in to cut down on non legit URLs but it is blocking a way to eneter "https://" which is legit...<br /><br />Thanks for the great wotk FishTails!

Actually, I never even thought about https for secure connection! I'll consider this a bug, and will look into it further. Meanwhile, if you have a link with the https, you should be able to add it directly via phpmyadmin. When the links are called from the database, it does not check for https or http, etc. Only when a link is submitted is it checked for valid URL, and as I said, I never took this into consideration when I started TLD. <br /> <br /> edit <br /> <br />Just a note, it's just a matter of changing the regexp on the submit_link.php script.

FishTail,<br /><br />Yep, you don't see a lot of them (https://) but they are out there.<br /><br />Maybe an update in the future that lets submitter pick between "http://" or "https://" or let them enter the entire URL and then check it again these two protocols and kick back an error message if they attempt to add a bad URL string.<br /><br />I took a quick look at the file you referenced. I think I will wait and see if you add this tweek in a future update. I am not in a hurry. It would just be nice to be able to add these links.<br /><br />Thanks again for making this cool mod!<br /><br />Later...

This is what you need to change:<br /><br /><br />I just don't know how it would need to be altered.

I can't get .asp files to add.

I noticed it still isn't running correctly without register globals enabled. I made a few fixes that got it limping along, but haven't done an exhaustive search to make sure all the functionality is working. I wanted to post to find out if one of the maintainers was already doing it before I dug around anymore.<br /><br />Lee

Post deleted by Pasqualist

This my first installation of this add-on. I installed it from the attachment on page 1, but when I bring up links.php, I get the following errors: <br /> <br /> []SQL ERROR: Sun, Feb 29 2004 14:01:06 +0100 Unable to do_query: SELECT lid,cat_id FROM w3t_links_links WHERE approved = '1' <br />Table 'pasqual_cznet.w3t_links_links' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/pasqual/tsjechie.net/forum/links_show_cat.php on line 46 <br />SQL ERROR: Sun, Feb 29 2004 14:01:06 +0100 Unable to do_query: SELECT * FROM w3t_links_categories WHERE parent_id = '0' ORDER BY 'cat_order' <br />Table 'pasqual_cznet.w3t_links_categories' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/pasqual/tsjechie.net/forum/links_show_cat.php on line 66[/] <br /> <br />Ok, I understand.. no tables have been created so far, so I follow the admin link... <br /> <br />Another SQL error comes up: <br /> <br /> []SQL ERROR: Sun, Feb 29 2004 14:03:01 +0100 Unable to do_query: SELECT * FROM w3t_links_links WHERE approved = '0' ORDER BY 'date_added' <br />Table 'pasqual_cznet.w3t_links_links' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/pasqual/tsjechie.net/forum/links_admin.php on line 74 [/] <br /> <br />Ok, since this is my first installation of this add-on, I click you can do so by clicking here. <br /> <br />The following 2 errors come up: <br /> <br /> []SQL ERROR: Sun, Feb 29 2004 14:05:08 +0100 Unable to do_query: SELECT * FROM w3t_links_links WHERE approved = '0' ORDER BY 'date_added' <br />Table 'pasqual_cznet.w3t_links_links' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/pasqual/tsjechie.net/forum/links_admin.php on line 74 [/] <br /> <br />and <br /> <br /> []SQL ERROR: Sun, Feb 29 2004 14:05:08 +0100 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 />Not exactly a smooth installation! <img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" /> <br /> <br />Anything I miss here ? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />

Anyone who can help me solving this ? <img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" />

got a link to your install?

Post deleted by Pasqualist

Your tables do not exist try these through phpmyadmin <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=0 ; <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=0 ; <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=0 ; <br /> <br />I dumped these from my working install

Thanks Chuck! <br /> <br />I created the tables and the links page loads fine now. But while testing the script, I encountered a problem: <br /> <br />It will not create subdirs! When I create a subdir, it just creates a main dir... very weird. Any idea ? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />

Maybe the file attached got reverted somehow. I know I had made some changes and included them on Marks direction and one of the things I did is include it. Maybe I will try and get a quick minute and zip up my php files for you to try.<br /><br />email me at []omegatron@comcast.net[/] and I will send them to you.

subdir? Are you pertaining to categories and sub-categories? Basically, first you create the main cats, then to the right of each top level category in the admin there is another box to the right to create sub-directories.

Fellow Threadafficianados,<br /><br />About 6 weeks ago I brought up the point that TLD will not allow a "https://" link to be added. There was some discussion and the only real advise to edit links_submit.php. Bottom line, I am not all that sharp with php and would love more specific help.<br /><br />So how can I get TLD to either allow "httpXXXXX" or allow anything and let the URL confirmation part catch the bad URLs.<br /><br />I think I need to do something with these lines...<br /> <br />// Let's make sure the url format is correct<br />if (strstr($url, "http://") === false)<br />{$url = "http://".$url;}<br />// Is the url valid and can we read it<br />if (@fopen($url, "r"))<br /><br />...but I have been monkeying around with this for a couple of hours to no avail.<br /><br />Help!...Pweese

Well I don't know this mod not using it but I may take a look later but based off your code have you tried<br /><br />// Let's make sure the url format is correct<br />if (strstr($url, "https://") === false)<br />{$url = "https://".$url;}<br />// Is the url valid and can we read it<br />if (@fopen($url, "r"))<br /><br />to see if it at least passes the https:// addresses? if not there may be something else in the code stopping it.

I tried that change and it still kicks out an error message. There must be more coding that checks the URL. There are about 5 php files with this mod.

I think the problem lies within the fact that https is for secure connections, and the script is trying to open the file for reading only. I'll look into this more and see if I can come up with a more definitive answer. I've been working on some other parts of the script and forgot.

Thanks in advance for the help! <br /> <br />The mod works great in all other ways <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> <br /> <br />PS I think you are right about part of the problem is not being able to open a https:// link for validtion. I was adding another link to TLD that is a standard http:// link. It kept coming up as a bad URL. I could visit the URL manually with no problem. I then noticed that the http:// page was redirecting to a https:// page. So it is a two headed issue. One is allowing https URLs to be entered into the system and the other is validating the https URLs. <br /> <br />Later..