Link Manager 3.0 Support Thread

Firedkm:

Clyde I am still getting the same error using the install sql.

What should I try next?

Dale

try running this one:

# Links Manager SQL Install
# For Zen-Cart 1.3.8
# Version: 3.5.1
# Updated: 9/7/2009
# New configuration options are added to the zen_configuration table.
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# For best results, cut-and-paste the code into the query field and press 'Send'.

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id)
FROM configuration_group
WHERE configuration_group_title= 'Links Manager'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;

INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Display Description As Link', 'DISPLAY_LINK_DESCRIPTION_AS_LINK', 'false', 'Display the links description as a link', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Enable Click Count', 'ENABLE_LINKS_COUNT', 'false', 'Enable links click count.', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Submit Link - Require Reciprocal Page', 'SUBMIT_LINK_REQUIRE_RECIPROCAL', 'true', 'Require Reciprocal Page on Links Submit', @configuration_group_id, 6, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Display Link Banner Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Banner Image?', @configuration_group_id, 7, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 8, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Display Link Click Count', 'LINK_LIST_COUNT', '0', 'Do you want to display the Link Click Count?', @configuration_group_id, 9, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 10, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Maximum Length', 'ENTRY_LINKS_TITLE_MAX_LENGTH', '50', 'Maximum length of link title.', @configuration_group_id, 11, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 12, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 13, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Maximum Length', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '250', 'Maximum length of link description.', @configuration_group_id, 14, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 15, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Number Of Links to display on Links Page', 'MAX_DISPLAY_LINKS', '5', 'Set the number of Links to display on the Links page.', @configuration_group_id, 16, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Links Check Phrase', 'LINKS_CHECK_PHRASE', 'yoursitename', 'Phrase to look for, when you perform a link check.', @configuration_group_id, 17, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Links List - Scroll Box Size/Style', 'MAX_LINKS_LIST', '3', 'Number of link category names to be displayed in the scroll box window. Setting this to 1 or 0 will display a dropdown list', @configuration_group_id, 18, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Length of Link Categories Name', 'MAX_DISPLAY_LINK_NAME_LEN', '17', 'Used in links box; maximum length of link category name to display. Longer names will be truncated.', @configuration_group_id, 19, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Select Links Sort Order', 'DEFINE_SORT_ORDER', '1', 'Define the sort order of the links<br />1= Sort by Title<br />2= Sort by Date (Newest to Oldest)<br />3= Sort by number of clicks (highest to lowest)', @configuration_group_id, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Number of Link Categories Per Row - Default is 3', 'MAX_LINK_CATEGORIES_ROW', '3', 'Used to display Link Categories per row.<br />Default is 3', @configuration_group_id, 21, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @configuration_group_id, 22, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @configuration_group_id, 23, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @configuration_group_id, 24, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Show Banner Image Field', 'SHOW_LINKS_BANNER_IMAGE', 'true', 'Show Banner Image Field', @configuration_group_id, 25, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Link Banner Image Directory', 'LINK_IMAGE_DIRECTORY', 'links_image/', 'Set the Directory for the Link Image', @configuration_group_id, 26, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 27, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 28, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Default Link Banner Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @configuration_group_id, 29, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL,'Only registered customers may submit a Link', 'REGISTERED_LINK', 'false', 'Only registered customers may submit a Link', @configuration_group_id, 30, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Links - Show Store Name and Address', 'LINKS_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @configuration_group_id, 31, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Define Links Status', 'DEFINE_LINKS_STATUS', '1', 'Enable the Defined Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @configuration_group_id, 32, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS `links`;
CREATE TABLE links (
  `links_id` int(11) NOT NULL auto_increment,
  `links_url` varchar(255) default NULL,
  `links_reciprocal_url` varchar(255) default NULL,
  `links_image_url` varchar(255) default NULL,
  `links_contact_name` varchar(64) default NULL,
  `links_contact_email` varchar(96) default NULL,
  `links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `links_last_modified` datetime default NULL,
  `links_status` tinyint(1) NOT NULL default '1',
  `links_clicked` int(11) NOT NULL default '0',
  PRIMARY KEY  (`links_id`),
  KEY `idx_links_date_added` (`links_date_added`)
) TYPE=MyISAM ;

INSERT INTO `links` VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0);

DROP TABLE IF EXISTS `links_description`;
CREATE TABLE `links_description` (
  `links_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `links_title` varchar(64) NOT NULL default '',
  `links_description` text,
  PRIMARY KEY  (`links_id`,`language_id`),
  KEY `links_title` (`links_title`)
) ENGINE=MyISAM ;

INSERT INTO `links_description` VALUES (1, 1, 'Clyde Designs', 'Templates & Add-Ons for Zen Cart™');

DROP TABLE IF EXISTS `links_status`;
CREATE TABLE `links_status` (
  `links_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `links_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`links_status_id`,`language_id`),
  KEY `idx_links_status_name` (`links_status_name`)
) ENGINE=MyISAM;

INSERT INTO `links_status` VALUES (1, 1, 'Pending');
INSERT INTO `links_status` VALUES (2, 1, 'Approved');

DROP TABLE IF EXISTS `links_to_link_categories`;
CREATE TABLE `links_to_link_categories` (
  `links_id` int(11) NOT NULL auto_increment,
  `link_categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`links_id`,`link_categories_id`)
) ENGINE=MyISAM;

INSERT INTO `links_to_link_categories` VALUES (1, 1);

DROP TABLE IF EXISTS `link_categories`;
CREATE TABLE `link_categories` (
  `link_categories_id` int(11) NOT NULL auto_increment,
  `link_categories_image` varchar(64) default NULL,
  `link_categories_sort_order` int(3) default NULL,
  `link_categories_date_added` datetime default NULL,
  `link_categories_last_modified` datetime default NULL,
  `link_categories_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`link_categories_id`),
  KEY `idx_link_categories_date_added` (`link_categories_date_added`)
) ENGINE=MyISAM;

INSERT INTO `link_categories` VALUES (1, 'link_category/zencart.png', 1, now(), NULL, 1);

DROP TABLE IF EXISTS `link_categories_description`;
CREATE TABLE `link_categories_description` (
  `link_categories_id` int(11) NOT NULL default '1',
  `language_id` int(11) NOT NULL default '1',
  `link_categories_name` varchar(40) NOT NULL default '',
  `link_categories_description` text,
  PRIMARY KEY  (`link_categories_id`,`language_id`),
  KEY `idx_link_categories_name` (`link_categories_name`)
) ENGINE=MyISAM;

INSERT INTO `link_categories_description` VALUES (1, 1, 'Zen-Cart Development', '');

Thank you Clyde that worked!

1.3.8a with all security patches
LM version 3.1

I was recently notified and confirmed that when trying to submit a link the page simply refreshes with no errors and no submission. Also noted that when viewing all links the link category descriptions show but clicking on those also just refreshes the page.

I've spent a couple of days searching the thread but I'm unable to determine what particular solutions would work for my situation though I've tried a couple. Also tried the upgrade to new version with a test site but that breaks a number of things including my CAPTCHA on the page so I would rather stick with 3.1 which worked for my purposes.

I have done almost nothing other then security patching in quite some time (no add-ons in year(s)) and the last successful link submission was 6/7/2009 so everything was working then and I can only assume that the security_patch_v138_20090619 has something to do with it but can't figure out what to do while maintaining the security that patch provides.

Thanks.

Jeffey:

1.3.8a with all security patches
LM version 3.1

I was recently notified and confirmed that when trying to submit a link the page simply refreshes with no errors and no submission. Also noted that when viewing all links the link category descriptions show but clicking on those also just refreshes the page.

I've spent a couple of days searching the thread but I'm unable to determine what particular solutions would work for my situation though I've tried a couple. Also tried the upgrade to new version with a test site but that breaks a number of things including my CAPTCHA on the page so I would rather stick with 3.1 which worked for my purposes.

I have done almost nothing other then security patching in quite some time (no add-ons in year(s)) and the last successful link submission was 6/7/2009 so everything was working then and I can only assume that the security_patch_v138_20090619 has something to do with it but can't figure out what to do while maintaining the security that patch provides.

Thanks.

link to your site would be useful

HI Clyde and thanks for the quick pickup.

Hard to explain but I have reasons (outside of Zen Community of course, and frankly you likely don't want to know) for not providing a link.

Hope that is not a deal breaker and happy to provide any additional information though I've already checked the error logs with no results. Plus now to top things off my host is screwed up so I'm having difficulty (Sloooooow) getting to the site(s).

I've seen references to the mentioned security patch causing problems though I'm not sure how it would play in my scenario given the edits there are Admin based.

Scrambling for anything to help track it down, I guess I do have something to add; checked Firefox's error console and receive a "check_form is not defined" error for SITE/index.php?main_page=links_submit

By the way, my contact form (with subject Mod) with CAPTCHA works fine so no interaction issue there.

Just throwing out as much as I can, may help narrow things down.

Jeffey:

HI Clyde and thanks for the quick pickup.

Hard to explain but I have reasons (outside of Zen Community of course, and frankly you likely don't want to know) for not providing a link.

Hope that is not a deal breaker and happy to provide any additional information though I've already checked the error logs with no results. Plus now to top things off my host is screwed up so I'm having difficulty (Sloooooow) getting to the site(s).

I've seen references to the mentioned security patch causing problems though I'm not sure how it would play in my scenario given the edits there are Admin based.

Scrambling for anything to help track it down, I guess I do have something to add; checked Firefox's error console and receive a "check_form is not defined" error for SITE/index.php?main_page=links_submit

v3.1 is well over 2 years old and I'm pretty positive that there is a fix posted somewhere in this thread ( I just don't remember where it would be )

My recommendation would be to upgrade to the latest version and use the links_captcha_fix posted in the thread

Sweet, seems like a good start. Form does come up with Captcha field.*
(For others, a search in the thread for Captcha easily found the mentioned fix*)

However upon submission, form does show:
The Link Description Must contain between 10 & ENTRY_LINKS_DESCRIPTION_MAX_LENGTH characters.

and also:
Must contain less than ENTRY_LINKS_TITLE_MAX_LENGTH characters.
when submitting with a fairly short title.

Can't seem to find where the definition is wrong and both maximums in Admin are set longer then those just entered, ran the SQL update.Finally name comes back with error requiring at least 2 letters but it is longer then that.When I tried to test/fix the other two errors above the form clears the name and putting it in again regardless of length brings the same error again.

Retesting viewing links. Clicking on view all links brings up category descriptions, clicking on one of them results in:
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 '-0, MAX_DISPLAY_LINKS' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '8'order by ld.links_title limit -0, MAX_DISPLAY_LINKS]

Page numbering of the page is wacked: -4 -3 -2 -1 0

Jeffey:

Sweet, seems like a good start. Form does come up with Captcha field.*
(For others, a search in the thread for Captcha easily found the mentioned fix*)

However upon submission, form does show:
The Link Description Must contain between 10 & ENTRY_LINKS_DESCRIPTION_MAX_LENGTH characters.

and also:
Must contain less than ENTRY_LINKS_TITLE_MAX_LENGTH characters.
when submitting with a fairly short title.

Can't seem to find where the definition is wrong and both maximums in Admin are set longer then those just entered, ran the SQL update.Finally name comes back with error requiring at least 2 letters but it is longer then that.When I tried to test/fix the other two errors above the form clears the name and putting it in again regardless of length brings the same error again.

look in admin -> configuration -> links manager

Link Title Minimum Length 2
Link Title Maximum Length 50

Jeffey:

Retesting viewing links. Clicking on view all links brings up category descriptions, clicking on one of them results in:
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 '-0, MAX_DISPLAY_LINKS' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '8'order by ld.links_title limit -0, MAX_DISPLAY_LINKS]

Page numbering of the page is wacked: -4 -3 -2 -1 0

open includes/templates/YOUR_TEMPLATE/tpl_links_default.php

at around line 100 replace the existing line of code with the following

    $listing_sql = "select " . $select_column_list . " l.links_id from " . TABLE_LINKS_DESCRIPTION . " ld, " . TABLE_LINKS . " l, " . TABLE_LINKS_TO_LINK_CATEGORIES . " l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '" . (int)$_SESSION['languages_id'] . "' and l2lc.link_categories_id = '" . (int)$current_category_id . "'" . "order by $sortorder";

Thanks, unfortunately those are correctly set.

Just to make sure I just reinstalled everything again including the Captcha fix files as replacements and then ran the SQL which indicated the first one ran as written.

No changes to issues.

EDIT: Cross posted! Checking your next message now

Jeffey:

Thanks, unfortunately those are correctly set.

Just to make sure I just reinstalled everything again including the Captcha fix files as replacements and then ran the SQL which indicated the first one ran as written.

No changes to issues.

EDIT: Cross posted! Checking your next message now

You can allways PM me.

No change with edited line.

Would you rather I PM? Grateful for the help so what ever works best for you.

Jeffey:

No change with edited line.

Would you rather I PM? Grateful for the help so what ever works best for you.

Sure send me a PM

Thanks Clyde not only for the time here but also for being so willing to go offline and help me with a big chunk of your day!

Thought it certainly worthy of a public thanks though it's easy to see your dedication to the community

I'm making progress and got things working. :clap:
Problem with this kind of thing is that I'm of little help to others behind me since I tried so many things/installs/removals that I can't pinpoint what fixed the issue but only that it's fixed.

Thanks again for all of the over the top assistance, it kept me focused.

Clyde, I finally had someone do a link on my site. Now when I go into the links manager and click on the check link i get this error...
Link Check Result: Error Reading URL

Now if I copy and past the link into the web browser the link works fine.

Also the actual link on my site will work too.

Dale

Firedkm:

Clyde, I finally had someone do a link on my site. Now when I go into the links manager and click on the check link i get this error...
Link Check Result: Error Reading URL

Now if I copy and past the link into the web browser the link works fine.

Also the actual link on my site will work too.

Dale

The check link button is looking for your site (the Reciprocal link on the other web site)

check you setting for:

admin -> configuration -> links manager -> Links Check Phrase

That makes sense. Thank you Clyde

Hi Clyde,

I'm still using your mod with no problems, but I have something you or your readers may be interested in adding.

I wanted to do this ever seance I installed my link trade page on my classified site. That one use only web page thumbnails for the link image and some other interesting things. The easiest one to bring over was the web page thumbnail. Some easy edits and it works! I didn't take time to set up a better way of controlling the use of thumbnails, but I did set it up so that having a default image in Configuration ->Links Manager ->Default Link Image, will use the default and not the thumbnail shot. So to turn this on, leave the default image blank!

In includes\modules\YOUR_TEMPLATE\link_listing.php find line 82

$lc_text = TABLE_HEADING_LINKS_IMAGE;
```and change it to this one

//$lc_text = TABLE_HEADING_LINKS_IMAGE;
$lc_text = '<div valign="top" class="thumbnail"><img src="http://open.thumbshots.org/image.pxf?url=' .zen_get_links_url($listing_query->fields['links_id']).'" style="vertical-align: middle;" border="1" width="120" height="90" alt="Thumbnail"> </div>';

}else { // Use default image if form field is left blank

      }else { // Use default image if form field is left blank
      //$links_image_name = DEFAULT_LINK_IMAGE;
                 if (DEFAULT_LINK_IMAGE !='') {
                 $links_image_name = LINK_IMAGE_DIRECTORY . DEFAULT_LINK_IMAGE; 
         $db->Execute("update " . TABLE_LINKS . "
                     set links_image_url = '" . $links_image_name . "'
                      where links_id = '" . (int)$links_id . "'");
            $messageStack->add_session('header', WARNING_DEFAULT_FILE_UPLOADED, 'success');    
            }else {    // no default image, use thumbnail of site
                 $links_image_name = '';
         $db->Execute("update " . TABLE_LINKS . "
                     set links_image_url = '" . $links_image_name . "'
                      where links_id = '" . (int)$links_id . "'");
            $messageStack->add_session('header', DEFAULT_THUMBNAIL, 'success');        
            }

define('DEFAULT_THUMBNAIL', 'Your web site Thumbnail will be used for this link.');

That's all there was to it, if they upload a image, no thumbnail, if you have a default image, no thumbnail, no image, thumbnail is used.  In admin, if you edit the submitted link and add you default image there (links_image/links_default.jpg), then that will turn off thumbnails for that link.  Same way, deleting the image link will turn on the thumbnail shot. :D