Link Manager 3.0 Support Thread

Quote:

---

Originally Posted by Firedkm

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

What should I try next?

Dale

---

try running this one:

Code:

---

# 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 &amp; Add-Ons for Zen Cart&trade;');

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

PHP Code:

---

    $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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Code:

---

$lc_text = TABLE_HEADING_LINKS_IMAGE;

---

and change it to this one

Code:

---

//$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">&nbsp;</div>';

---

next in includes\modules\pages\links_submit\header_php.php find line 91

Code:

---

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

---

and change it to this one

Code:

---

          }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');       
                }

---

next in includes\languages\english\extra_definitions\YOUR_TEMPLATE\links_manager_defines .php add this line to the bottom.

Code:

---

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

---

And lastly, you need to register with thumbshots.org it's free, and you need to place a link back to them on your site. I did mine in the includes\languages\english\html_includes\YOUR_TEMPLATE\define_links.php page.

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

I am excited to get this mod working. Thank you. The sql that came
with the download did not work for me, so I found another one that was posted for someone else and thought it was working but
when you look at the box, instead of the word Links it has the whole
('BOX_HEADING_LINK_CATEGORIES', 'Links');
Instead of the view all links it has
('BOX_INFORMATION_VIEW_ALL_LINKS', 'View All Links')
Instead of the submit link it has
'BOX_INFORMATION_LINKS_SUBMIT', 'Submit Link')

When I click on View all links it seems to go to the right page and looks correct.

When I click for the submit page it looks like this:


Use the form below to submit your link. TALKING WALLS reserves the right to change the category or edit your description, if needed.

This content is located in the file at: /languages/english/html_includes/YOUR_TEMPLATE/define_links_submit.php

You can quickly edit this content via Admin->Tools->Define Pages Editor, and select define_links_submit from the pulldown.
Submit A Link
BUTTON_LINK_HELP_ALT
RETURN_REQUIRED_IMAGE_ALTRETURN_REQUIRED_INFORMATIONRETURN_OPTIONAL_IMAGE_ALTRET URN_OPTIONAL_INFORMATION

Your Contact Information

1. ENTRY_LINKS_CONTACT_NAMERETURN_REQUIRED_IMAGE_ALT
2. Email Address:RETURN_REQUIRED_IMAGE_ALT

CATEGORY_WEBSITE

1. ENTRY_LINKS_TITLERETURN_REQUIRED_IMAGE_ALT
2. ENTRY_LINKS_URLRETURN_REQUIRED_IMAGE_ALT
3. ENTRY_LINKS_CATEGORY_INFO ENTRY_LINKS_CATEGORYRETURN_REQUIRED_IMAGE_ALT
4. ENTRY_LINKS_DESCRIPTION_INFO ENTRY_LINKS_DESCRIPTIONRETURN_REQUIRED_IMAGE_ALT
5. ENTRY_LINKS_BANNER_INFO ENTRY_LINKS_BANNERRETURN_OPTIONAL_IMAGE_ALT

CATEGORY_RECIPROCAL

1. ENTRY_LINKS_RECIPROCAL_URLRETURN_REQUIRED_IMAGE_ALT

Your help would be greatly appreciated:huh:

Quote:

---

Originally Posted by fajmp

I am excited to get this mod working. Thank you. The sql that came
with the download did not work for me, so I found another one that was posted for someone else and thought it was working but
when you look at the box, instead of the word Links it has the whole
('BOX_HEADING_LINK_CATEGORIES', 'Links');
Instead of the view all links it has
('BOX_INFORMATION_VIEW_ALL_LINKS', 'View All Links')
Instead of the submit link it has
'BOX_INFORMATION_LINKS_SUBMIT', 'Submit Link')

When I click on View all links it seems to go to the right page and looks correct.

When I click for the submit page it looks like this:


Use the form below to submit your link. TALKING WALLS reserves the right to change the category or edit your description, if needed.

This content is located in the file at: /languages/english/html_includes/YOUR_TEMPLATE/define_links_submit.php

You can quickly edit this content via Admin->Tools->Define Pages Editor, and select define_links_submit from the pulldown.
Submit A Link
BUTTON_LINK_HELP_ALT
RETURN_REQUIRED_IMAGE_ALTRETURN_REQUIRED_INFORMATIONRETURN_OPTIONAL_IMAGE_ALTRET URN_OPTIONAL_INFORMATION

Your Contact Information

1. ENTRY_LINKS_CONTACT_NAMERETURN_REQUIRED_IMAGE_ALT
2. Email Address:RETURN_REQUIRED_IMAGE_ALT

CATEGORY_WEBSITE

1. ENTRY_LINKS_TITLERETURN_REQUIRED_IMAGE_ALT
2. ENTRY_LINKS_URLRETURN_REQUIRED_IMAGE_ALT
3. ENTRY_LINKS_CATEGORY_INFO ENTRY_LINKS_CATEGORYRETURN_REQUIRED_IMAGE_ALT
4. ENTRY_LINKS_DESCRIPTION_INFO ENTRY_LINKS_DESCRIPTIONRETURN_REQUIRED_IMAGE_ALT
5. ENTRY_LINKS_BANNER_INFO ENTRY_LINKS_BANNERRETURN_OPTIONAL_IMAGE_ALT

CATEGORY_RECIPROCAL

1. ENTRY_LINKS_RECIPROCAL_URLRETURN_REQUIRED_IMAGE_ALT

Your help would be greatly appreciated:huh:

---

Sounds like you didn't upload ALL of the required language files:
don't forget to rename the YOUR_TEMPLATE folder to match the name of the custom template you are using for your site.

includes/languages/english/extra_definitions/YOUR_TEMPLATE/links_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/links.php
includes/languages/english/YOUR_TEMPLATE/links_submit.php
includes/languages/english/YOUR_TEMPLATE/popup_links_help.php
includes/languages/english/html_includes/define_links.php
includes/languages/english/html_includes/define_links_submit.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_links.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_links_submit.php

you are so right! :bigups: Hopefully I'll figure the rest out...but probably not. You guys are always so fast and so helpful...thank you.

Well, I'm back.
I can't find any links manager in my admin...configuration.

I've searched trying to find the answer. Perhaps I'm not inputting
the right search, but I didn't find anything.

I've tripple checked everything as far as uploading the files into the
admin folders.
What am I missing?

Quote:

---

Originally Posted by fajmp

Well, I'm back.
I can't find any links manager in my admin...configuration.

I've searched trying to find the answer. Perhaps I'm not inputting
the right search, but I didn't find anything.

I've tripple checked everything as far as uploading the files into the
admin folders.
What am I missing?

---

did you run the install_links_manager.sql?

Yes, as you see in my first email...I didn't use the one with
the download, but another one that you gave to someone else.
Should I redo it again or something.

Quote:

---

Originally Posted by fajmp

Yes, as you see in my first email...I didn't use the one with
the download, but another one that you gave to someone else.
Should I redo it again or something.

---

You should run the one from the download.

or make sure you're looking in the right place in your admin

admin -> configuration -> links manager

it's not there I'm afraid...should I do the sql again from the download then?

nevermind...it was in the config but the last one way down on the dropdown menu where I couldn't see it. I accidentally hit the config again and there it was way at the bottom when it shows the site map.

I only found one person answering this question...
last night I had the link sidebox in my store...this morning it's not there. Never touched a thing except turn it off so my customers
didn't have to look at it. I had turned it off and on many times
yesterday trying different things on the live site.

sideboxes/fran/links_box.php ON LEFT 3 0 OFF Edit Info

I've tried changing it to right but it still doesn't work. Any suggestions. My site is http://www.subjectmatters.ca/talkingwalls/ in case you need it to have a peek.

I am getting ready to quit this mod...don't want to though, but don't know what else to do with the sideobox not showing up at all.
So I deleted the sql and reinstalled the the one sent with the mod
and this is what I get:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_links VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

can you help?

Quote:

---

Originally Posted by fajmp

I am getting ready to quit this mod...don't want to though, but don't know what else to do with the sideobox not showing up at all.
So I deleted the sql and reinstalled the the one sent with the mod
and this is what I get:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_links VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

can you help?

---

run this sql patch using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)
copy-and-paste the code into the query field and press 'Send'.

Code:

---

# 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, copy-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, 'Links Manager Version', 'LM_VERSION', '3.5.1', 'Links Manager version', @configuration_group_id, 33, NULL, now(), NULL, NULL);

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, 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 &amp; Add-Ons for Zen Cart&trade;');

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', '');

---

looks like the same thing to m??


1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_links VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Quote:

---

Originally Posted by fajmp

looks like the same thing to m??


1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_links VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

---

Run this one

Code:

---

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 &amp; Add-Ons for Zen Cart&trade;');

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', '');

---

I reinstalled all the files just in case....
I did the second above sql and it went through all right
I've tried to move the box around from left to right in case.
I don't know.:(
What's so disappointing is that it was there yesterday.
Anything else I can do? sorry to make this so drawn out...

Quote:

---

Originally Posted by fajmp

I reinstalled all the files just in case....
I did the second above sql and it went through all right
I've tried to move the box around from left to right in case.
I don't know.:(
What's so disappointing is that it was there yesterday.
Anything else I can do? sorry to make this so drawn out...

---

The sidebox will only show when there is at least 1 link present.

make sure you have uploaded the following files and changed the YOUR_TEMPLATE folder to match the name of the custom template you are using on your site.

includes/modules/sideboxes/YOUR_TEMPLATE/links_box.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_links_select.php

Quote:

---

Originally Posted by clydejones

The sidebox will only show when there is at least 1 link present.

make sure you have uploaded the following files and changed the YOUR_TEMPLATE folder to match the name of the custom template you are using on your site.

includes/modules/sideboxes/YOUR_TEMPLATE/links_box.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_links_select.php

---

Nothing changed when I did the above that you suggested.
I went scrounging and found that there was 2 different downloads for the mod.
The one I was using was links_manager_v3-5-1.zip 386 kb
the other one I found was links_manager_v3-4-1.zip 391 kb
So I decided to overwrite the 2 files (suggested above ) from the older version and voila.. it worked.
:clap:

I recently unchecked my link from the layout boxes until I get a chance to work on getting some links. But this morning I had a link, placed in there (even though I had it unchecked)
It was a ######## link. How can that happen? Is there some weakness in the addon? I am timid of leaving it on.
Anyone else ever have this problem?

This is a fresh install of your latest version.
Couple of issues.
1. The following error when using Check Links:

Warning: file() [function.file]: URL file-access is disabled in the server configuration in D:\Hosting\*******\html\admin**********\links.php on line 615

Should I just create a file named funtion.file and put it in my /admin directory? OR could this be something that needs to be adressed with .htaccess?

2. The following SQL complaints.
ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details

Would IH_VERSION refer to Image Handler?

Other than that, the module seems to be working just fine.
Nice work and I appreciated the order steps mod too.

Sorry, forgot to add this error to the first issue.
Warning: file(http://mysticmountainnaturals.com/demotest) [function.file]: failed to open stream: no suitable wrapper could be found in D:\Hosting\*******\html\admin************\links.php on line 615

Quote:

---

Originally Posted by jabbawest

This is a fresh install of your latest version.
Couple of issues.
1. The following error when using Check Links:

Warning: file() [function.file]: URL file-access is disabled in the server configuration in D:\Hosting\*******\html\admin**********\links.php on line 615

Should I just create a file named funtion.file and put it in my /admin directory? OR could this be something that needs to be adressed with .htaccess?

2. The following SQL complaints.
ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details

Would IH_VERSION refer to Image Handler?

Other than that, the module seems to be working just fine.
Nice work and I appreciated the order steps mod too.

---

Quote:

---

Originally Posted by jabbawest

Sorry, forgot to add this error to the first issue.
Warning: file(http://mysticmountainnaturals.com/demotest) [function.file]: failed to open stream: no suitable wrapper could be found in D:\Hosting\*******\html\admin************\links.php on line 615

---

ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
This can safely be ignored (It just means that that particular table row already exists)

Warning: file() [function.file]: URL file-access is disabled in the server configuration

As the error message states - this is a server issue. You will need to contact your hosting provider to correct this issue.

Quote:

---

Originally Posted by clydejones

As the error message states - this is a server issue. You will need to contact your hosting provider to correct this issue.

---

Well, a little searching found that this needs to be allowed in the php.ini file by adding the following.
allow_url_fopen = On;
allow_url_include = On;

More research suggests that doing this would allow a huge opening for DoS attacks and scripting injections both of which I'm quite familiar with from running php-nuke sites. Back then I was able to install a security module that would automatically ban anyone trying hack into my sites.

Any opinions about this, or maybe it should be a new topic in the security forum?

Thanks

Quote:

---

Originally Posted by fajmp

I recently unchecked my link from the layout boxes until I get a chance to work on getting some links. But this morning I had a link, placed in there (even though I had it unchecked)
It was a ######## link. How can that happen? Is there some weakness in the addon? I am timid of leaving it on.
Anyone else ever have this problem?

---

Can someone reply to this? It's a very weird and possibly dangerous (to my website) happening.

Quote:

---

Originally Posted by fajmp

Can someone reply to this? It's a very weird and possibly dangerous (to my website) happening.

---

URL for your site?

You can turn the sidebox off admin -> tools -> layout boxes controller

That's what concerns me...I had it turned off! I had turned it off a couple of days before to think about the best way to use it. And then I got the email saying that someone had put in a new link.
A bad link.

http://www.talkingwalls.ca/talkingwalls/

Do you suppose it would take that long for the email to get through?

Quote:

---

Originally Posted by fajmp

That's what concerns me...I had it turned off! I had turned it off a couple of days before to think about the best way to use it. And then I got the email saying that someone had put in a new link.
A bad link.

http://www.talkingwalls.ca/talkingwalls/

Do you suppose it would take that long for the email to get through?

---

If it was a link from a spammer; they wouldn't necessarily need to link to the submit link page from the sidebox. They could have used a "bot" that would search for and then submit a link automatically.

That's why ALL links must be approved from your admin panel before they are displayed.

You might want to check through the support thread for the "captcha" fix which can help reduce spam links.

that's very true. It wasn't spam I guess, just a ###### link..so it makes me think that reciprical linking is not such a great idea.
thank you for your input.

Quote:

---

Originally Posted by jabbawest

Well, a little searching found that this needs to be allowed in the php.ini file by adding the following.
allow_url_fopen = On;
allow_url_include = On;

More research suggests that doing this would allow a huge opening for DoS attacks and scripting injections both of which I'm quite familiar with from running php-nuke sites. Back then I was able to install a security module that would automatically ban anyone trying hack into my sites.

Any opinions about this, or maybe it should be a new topic in the security forum?

Thanks

---

I'm looking at alternatives for this.

Quote:

---

Originally Posted by jabbawest

Well, a little searching found that this needs to be allowed in the php.ini file by adding the following.
allow_url_fopen = On;
allow_url_include = On;

More research suggests that doing this would allow a huge opening for DoS attacks and scripting injections both of which I'm quite familiar with from running php-nuke sites. Back then I was able to install a security module that would automatically ban anyone trying hack into my sites.

Any opinions about this, or maybe it should be a new topic in the security forum?

Thanks

---

Quote:

---

Originally Posted by clydejones

I'm looking at alternatives for this.

---

This fix uses a CURL alternative to "allow_url_fopen".

Just unzip the package and upload the file to your admin folder.

Attachment 6710

Hi clyde

Thanks for a fab mod but i was wondering if you could point me in the right direction....

How do i fix the layout? If its normal when you look at it that means i fixed it but here is the direct link http://exquisitebaby.co.nz/shop/inde...e=links_submit

Thanks

jess

Quote:

---

Originally Posted by Tagyourbaby

Hi clyde

Thanks for a fab mod but i was wondering if you could point me in the right direction....

How do i fix the layout? If its normal when you look at it that means i fixed it but here is the direct link http://exquisitebaby.co.nz/shop/inde...e=links_submit

Thanks

jess

---

open includes/templates/YOUR_TEMPLATE/css/links_submit.css

find the following declaration and add the highlighted portion.

fieldset li {
clear:both;
padding-bottom: .6em;
}

Thanks heaps Clyde your a star!

please help

i have zencart 1.3.8 and link manager 3.5 how do i change the layout to remove the scrollbox or at least hide it in black so it looks like the other link blocks

http://www.lightpryzms.com

thanks
joe dauz

Quote:

---

Originally Posted by internetjoe

please help

i have zencart 1.3.8 and link manager 3.5 how do i change the layout to remove the scrollbox or at least hide it in black so it looks like the other link blocks

http://www.lightpryzms.com

thanks
joe dauz

---

add the following to your stylesheet.css (includes/templates/YOUR_TEMPLATE/css/stylesheet.css)

#linksboxContent select {
background:000;
color:#999999;
}

Quote:

---

Originally Posted by clydejones

add the following to your stylesheet.css (includes/templates/YOUR_TEMPLATE/css/stylesheet.css)

#linksboxContent select {
background:000;
color:#999999;
}

---

Clyde
Thank you for your quick reply - very nice

but the grey empty scroll bar and white outline are still visible and i cant find #fff in either css file. the previous suggestions for 3.0 do not match the data in my links.css or links_submit.css.
Is there a form call somewhere?

Joe

Quote:

---

Originally Posted by internetjoe

Clyde
Thank you for your quick reply - very nice

but the grey empty scroll bar and white outline are still visible and i cant find #fff in either css file. the previous suggestions for 3.0 do not match the data in my links.css or links_submit.css.
Is there a form call somewhere?

Joe

---

Try this:

#linksboxContent select {
background:#000;
color:#999999;
border:1px solid #000;
}

I'm not sure the scroll bar can be changed.

Quote:

---

Originally Posted by clydejones

Try this:

#linksboxContent select {
background:#000;
color:#999999;
border:1px solid #000;
}

I'm not sure the scroll bar can be changed.

---

cool ill just change the setting to pull down and hope that passes the boss.

much thanks
joe

Hello guys,

Can I just start off by saying a BIG thanks to Clyde for this fantastics addon :smile:

I have sucessfully installed Link Manager, it all went well. The only issue I have is with the email sent to the person submitting the link here it is (minus name etc) exactly as it currently appears:

Dear NAME HERE, Welcome to SITENAME.COM link exchange program. Your link has been successfully submitted at SITENAME.COM. It will be added to our listing as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your link again. For help with our link exchange program, please email the store-owner: [email protected] Note: This email address was given to us during a link submittal. If you have a problem, please send an email to [email protected]
Welcome to SITENAME.COM link exchange program.
Your link has been successfully submitted at SITENAME.COM. It will be added to our listing as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your link again.

Why does this email appear to show the same thing twice?
How can I fix this?

Thanks :smile:

Quote:

---

Originally Posted by gaffettape

Hello guys,

Can I just start off by saying a BIG thanks to Clyde for this fantastics addon :smile:

I have sucessfully installed Link Manager, it all went well. The only issue I have is with the email sent to the person submitting the link here it is (minus name etc) exactly as it currently appears:

Dear NAME HERE, Welcome to SITENAME.COM link exchange program. Your link has been successfully submitted at SITENAME.COM. It will be added to our listing as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your link again. For help with our link exchange program, please email the store-owner: [email protected] Note: This email address was given to us during a link submittal. If you have a problem, please send an email to [email protected]
Welcome to SITENAME.COM link exchange program.
Your link has been successfully submitted at SITENAME.COM. It will be added to our listing as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your link again.

Why does this email appear to show the same thing twice?
How can I fix this?

Thanks :smile:

---

Check back through this thread, There is a solution for this posted somewhere; I just can't remember where.

Thanks for the reply, I'll have a search now. One other issue I'm having is with the link status update email:

'Dear NAME,
The status of your link at STORENAME has been updated.
The New Status is: .
Please reply to this email if you have any questions.'

Any ideas why it just says The New Status is: . ?
Cheers :smile:

Quote:

---

Originally Posted by gaffettape

Thanks for the reply, I'll have a search now. One other issue I'm having is with the link status update email:

'Dear NAME,
The status of your link at STORENAME has been updated.
The New Status is: .
Please reply to this email if you have any questions.'

Any ideas why it just says The New Status is: . ?
Cheers :smile:

---

This should take care of this problem.

Just unzip the package and upload the links.php file to your admin folder.

Attachment 6733

Quote:

---

Originally Posted by clydejones

This should take care of this problem.

Just unzip the package and upload the links.php file to your admin folder.

Attachment 6733

---

That worked a treat, thanks Clyde your a diamond :smile:

Clyde, I'm playing around with the latest version of Links Manager on a test site (1.38a) with all the security mods. Everything works fine except when adding a new link in the admin panel, you cannot set the status to "Approved" from the dropdown.

You can, however, change the status for an existing link, using the dropdown--it just doesn't work for a new link.

Might the solution have something to do with the code in the file admin/links.php, somewhere around line 493?

Code:

---

  if ($action == 'new' || $action == 'insert') {
  echo zen_draw_pull_down_menu('links_status', $link_statuses, zen_not_null($lInfo->links_status) ? $lInfo->links_status : $links_status_default, '', false);
}
  if ($action == 'edit' || $action == 'update') {
  echo zen_draw_pull_down_menu('links_status', $link_statuses, $lInfo->links_status, '', false);
}

---

Any ideas would be appreciated. Thanks for a great add-on.

Quote:

---

Originally Posted by zranno

Clyde, I'm playing around with the latest version of Links Manager on a test site (1.38a) with all the security mods. Everything works fine except when adding a new link in the admin panel, you cannot set the status to "Approved" from the dropdown.

You can, however, change the status for an existing link, using the dropdown--it just doesn't work for a new link.

Might the solution have something to do with the code in the file admin/links.php, somewhere around line 493?

Code:

---

  if ($action == 'new' || $action == 'insert') {
  echo zen_draw_pull_down_menu('links_status', $link_statuses, zen_not_null($lInfo->links_status) ? $lInfo->links_status : $links_status_default, '', false);
}
  if ($action == 'edit' || $action == 'update') {
  echo zen_draw_pull_down_menu('links_status', $link_statuses, $lInfo->links_status, '', false);
}

---

Any ideas would be appreciated. Thanks for a great add-on.

---

I've been unable to reproduce this behaivor on any of my sites.

I'm able to edit existing links as well as create new links and change the status via the dropdown.

How can I change the background color of the link listing page? At the moment it alternates between light yellow and white. (see screenshot attatched)

Thanks.

Quote:

---

Originally Posted by gaffettape

How can I change the background color of the link listing page? At the moment it alternates between light yellow and white. (see screenshot attatched)

Thanks.

---

open includes/templates/YOUR_TEMPLATE/css/links.css

change the highlighted portion of the following declaration to suite your needs

.productListing-even .linkListing-data{padding:5px;font-size:1em;background:ivory;color:#000;}

Quote:

---

Originally Posted by clydejones

open includes/templates/YOUR_TEMPLATE/css/links.css

change the highlighted portion of the following declaration to suite your needs

.productListing-even .linkListing-data{padding:5px;font-size:1em;background:ivory;color:#000;}

---

Thanks Clyde :smile:

Hi Clyde I love your link manager 3.0 but need a capa submit link form ,getting alot of spam ,the capa submit link form they have for in adons in dose not work with your modual plus the define page editor dosenot work with the capa version. need a capa submit link form that works with your link manager 3.0 versoin for 1.38 zencart. Thanks Gene 42

Quote:

---

Originally Posted by gene42

Hi Clyde I love your link manager 3.0 but need a capa submit link form ,getting alot of spam ,the capa submit link form they have for in adons in dose not work with your modual plus the define page editor dosenot work with the capa version. need a capa submit link form that works with your link manager 3.0 versoin for 1.38 zencart. Thanks Gene 42

---

Check back through the thread there's a fix posted somewhere but I don't remember where.

Cannot find it if someone dose please let me know if theres a new submit link ? form thankyou :(

Quote:

---

Originally Posted by gene42

Cannot find it if someone dose please let me know if theres a new submit link ? form thankyou :(

---

do a search of the thread for captcha_fix

Quote:

---

Originally Posted by gene42

Cannot find it if someone dose please let me know if theres a new submit link ? form thankyou :(

---

Try this thread www.zen-cart.com/forum/showpost.php?p=667140&postcount=1255

Hi I did the following myself and deleted all lable lines as specified but all red lable lines remail???

Quote:

---

Originally Posted by gene42

Hi I did the following myself and deleted all lable lines as specified but all red lable lines remail???

---

:huh::unsure: ?????????????

Quote:

---

Originally Posted by Veronika7747

O.K., now that the test site is up, I have yet another question.... I have couple of pages of "old links" (one page currently shows as the last line "Arts Links" on RHS box under "More on Clive Kay" and I would like to include this link inside the "Link Manager" box with bit of space under the last line there "Submit Links". Is that possible?? I was trying to do it the same way as I did it in "More Info" box, but that did not work..

Also should I be able to put a subcategory in the link category??

Thanks for your time.

---

I did it but all text feild are gone??

Quote:

---

Originally Posted by gene42

I did it but all text feild are gone??

---

I'd suggest that you re-install Links Manager

Hi Again..
This morning I got this email...


" A new link was submitted at TALKING WALLS. It is not yet approved. Please
verify this link and activate.

Hasen Chat

http://www.hasenchat.de

Get new Friends Online in this Free Chat. Go to the English or German
Channel to find Friends. Send e-mails to other chatters, or create your own
Free website with the Homepage Editor in the Chat."

The thing is I don't have links manager turned on. If you will look at one of my last posts I had another problem with this.
I need to uninstall it from zen cart because something weird is going on. Is there a particular way that I should do this?

Quote:

---

Originally Posted by fajmp

Hi Again..
This morning I got this email...


" A new link was submitted at TALKING WALLS. It is not yet approved. Please
verify this link and activate.

Hasen Chat

http://www.hasenchat.de

Get new Friends Online in this Free Chat. Go to the English or German
Channel to find Friends. Send e-mails to other chatters, or create your own
Free website with the Homepage Editor in the Chat."

The thing is I don't have links manager turned on. If you will look at one of my last posts I had another problem with this.
I need to uninstall it from zen cart because something weird is going on. Is there a particular way that I should do this?

---

follow the instructions in the included uninstall.txt file

Status:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/d3dsddc/public_html/dkskdkfd/adminxxxxx/includes/functions/html_output.php on line 343

---------------------------------------
I meet such trouble , unknown what happen ,
but it seems should be html_output.php trouble.

Quote:

---

Originally Posted by winsion

Status:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/d3dsddc/public_html/dkskdkfd/adminxxxxx/includes/functions/html_output.php on line 343

---------------------------------------
I meet such trouble , unknown what happen ,
but it seems should be html_output.php trouble.

---

do a forum search for;

Catchable fatal error: Object of class queryFactoryResult could not be converted to string

There are several thread with solutions to this issue.

Hi All

I've installed this mod on 3 sites but on 1 of them I don't get any menus under Extras. Everything else is fine: config links menu, layout box, I can submit links from the frontend but there are no menus under Extras in the admin. I have uploaded the files several times and I absolutely have the template directories named properly. If I try running the url for link categories (site/adminfolder/link_categories.php) I get a page not found. The files are indeed there.

Quote:

---

Originally Posted by Tapper

Hi All

I've installed this mod on 3 sites but on 1 of them I don't get any menus under Extras. Everything else is fine: config links menu, layout box, I can submit links from the frontend but there are no menus under Extras in the admin. I have uploaded the files several times and I absolutely have the template directories named properly. If I try running the url for link categories (site/adminfolder/link_categories.php) I get a page not found. The files are indeed there.

---

Double check and make sure the following files have been uploaded to your server:

admin/link_categories.php
admin/links.php
admin/links_contact.php
admin/includes/boxes/extra_boxes/links_extras_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links.php
admin/includes/languages/english/link_categories.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/extra_definitions/links.php

Well, Huh! that was a mystery. There wasn't an admin folder in that directory anymore.

I re-extracted the archive and now it's all fine.

Thank You Clyde!

Zencart Version 1.38
Upgraded lateste version of Link Manager 3.5
Site: spankit-golf.c o m

Clyde, I've install the lastest version of Link Manager and I'm experinceing this porblems:
Can't add or change and inforamtion for categories, links or make any changes to configuration file.
I can add links via the submit link, but I must go to the files on my server (database) to approve link or make any changes.

Any ideas on the problems I'm having.

Thanks,
Ibparn
:(

Quote:

---

Originally Posted by ibparn

Zencart Version 1.38
Upgraded lateste version of Link Manager 3.5
Site: spankit-golf.c o m

Clyde, I've install the lastest version of Link Manager and I'm experinceing this porblems:
Can't add or change and inforamtion for categories, links or make any changes to configuration file.
I can add links via the submit link, but I must go to the files on my server (database) to approve link or make any changes.

Any ideas on the problems I'm having.

Thanks,
Ibparn
:(

---

fist - try uploading clean copies of the following files:

admin/link_categories.php
admin/links.php
admin/links_contact.php
admin/includes/boxes/extra_boxes/links_extras_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links.php
admin/includes/languages/english/link_categories.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/extra_definitions/links.php

Downloaded zip file again and reloaded files as suggested.
No change..

Sorry..

Geary

Quote:

---

Originally Posted by ibparn

Downloaded zip file again and reloaded files as suggested.
No change..

Sorry..

Geary

---

Quote:

---

Can't add or change and inforamtion for categories, links or make any changes to configuration file.

---

Can you explain exactly what is or is not happening when you try to perform these operations.

I first deleted the files you mentioned and then uploaded them without any problems. I did them one at a time to make sure I didn't make any mistakes.

I then signed into the admin section and tried to change, update and add links, link catergories and change information in the Link Managers configuration. Upon saving, updating or inserting I was returned to the main menu screen. I then went to see if any of the changes had taken been made, and none did.

I'm able to submit links via the submit form, but I have to go directly into the database file and approve them manually.

Hope this helps, :(
Geary

Quote:

---

Originally Posted by ibparn

I first deleted the files you mentioned and then uploaded them without any problems. I did them one at a time to make sure I didn't make any mistakes.

I then signed into the admin section and tried to change, update and add links, link catergories and change information in the Link Managers configuration. Upon saving, updating or inserting I was returned to the main menu screen. I then went to see if any of the changes had taken been made, and none did.

I'm able to submit links via the submit form, but I have to go directly into the database file and approve them manually.

Hope this helps, :(
Geary

---

Make sure you've uploaded the security update

:clap:
Thanks, that did the trick..

Geary

Hi
I just installed the LINKS MANAGER 3.5.2 .
It is showing double category names .
I installed on my website for selling designer silver jewelry .
Even if i rename the category , the problem still remains the same .
I couldn't find a new thread for latest version , so i posted here .
The problem area on my silver site is on page : problem page

Quote:

---

Originally Posted by dudeshane01

Hi
I just installed the LINKS MANAGER 3.5.2 .
It is showing double category names .
I installed on my website for selling designer silver jewelry .
Even if i rename the category , the problem still remains the same .
I couldn't find a new thread for latest version , so i posted here .
The problem area on my silver site is on page : problem page

---

The first name is the alt text of a missing category image
the second name is that of the category

open the attached zip package and upload/FTP the images folder to your server where you have Zen Cart installed

Attachment 6977

Lovely piece of work , it is working perfectly now.
Thanks a million for the quick reply .
Interested people may have a look at the deisgner jewelry site link page now.

Hi Clyde
There is one more problem , a bit more complex than this one, i guess .
I had the slimbox module working perfectly on my silver jewelry site before installing the Links manager module.
It stopped working as soon as i installed links manager .(Complete module code attached with this comment ) .
I am no expert in PHP or code writing .
I have seen more people in zen lightbox thread posting about same problem .
Can you help us solve it ?

Quote:

---

Originally Posted by dudeshane01

Hi Clyde
There is one more problem , a bit more complex than this one, i guess .
I had the slimbox module working perfectly on my silver jewelry site before installing the Links manager module.
It stopped working as soon as i installed links manager .(Complete module code attached with this comment ) .
I am no expert in PHP or code writing .
I have seen more people in zen lightbox thread posting about same problem .
Can you help us solve it ?

---

Links manager does not use or overwrite any of the files in the slimbox module. In fact it does not overwrite any files at all.

Your best bet is to post in either the slimbox support thread or the zen lightbox support thread.

Hello,

Can anybody help me to install the link manager? I tried to upload the install_links_manager file using the Zen-Cart Sql Patches tool but I got the errors as follows:

Success 63 statements processed.
Error ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
Error ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.


I've created new Custom folders as recommended.. What do I do wrong? Do I have to copy files from classic folders to custom ones? I left the custom folders empty. Please, please help me. Thank you so much in advance.

Quote:

---

Originally Posted by ametist

Hello,

Can anybody help me to install the link manager? I tried to upload the install_links_manager file using the Zen-Cart Sql Patches tool but I got the errors as follows:

Success 63 statements processed.
Error ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
Error ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.


I've created new Custom folders as recommended.. What do I do wrong? Do I have to copy files from classic folders to custom ones? I left the custom folders empty. Please, please help me. Thank you so much in advance.

---

The errors you've mentioned only indicate that that information is already contained in your database so there is no need to be concerned.

to install the links manager follow these instructions from the "install links manager.txt" file

Before uploading change the YOUR_TEMPLATE folders to match the name of your custom template.

includes/languages/english/YOUR_TEMPLATE
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE/


The files are arranged in the same structure as Zen Cart so you can FTP the admin, email, images and includes folders to your server.

Thank you Clyde. I did it. As I understand I have to create new folders instead YOUR_TEMPLATE? So, it looks as follows:

includes/languages/english/Custom
includes/languages/english/extra_definitions/Custom
includes/languages/english/html_includes/Custom
includes/modules/Custom
includes/modules/sideboxes/Custom
includes/templates/Custom


I can see the Link Manager in the Admin > Configuration > Link Manager, but I cannot find it in the Admin -> Tools -> Layout boxes contoller... According to instructions it suppose to start with "Links Box - Display Links in Sidebox" and I see "Links Box - Display View All Links". How I can activate the Links Manager to start to build link or see it on my website? Also I can't find the Admin -> Extras -> Links. Please, help me. I don't know what I'm doing wrong..:blink::blush: Thank you soo much in advance.

Natalya

Quote:

---

Originally Posted by ametist

Thank you Clyde. I did it. As I understand I have to create new folders instead YOUR_TEMPLATE? So, it looks as follows:

includes/languages/english/Custom
includes/languages/english/extra_definitions/Custom
includes/languages/english/html_includes/Custom
includes/modules/Custom
includes/modules/sideboxes/Custom
includes/templates/Custom


I can see the Link Manager in the Admin > Configuration > Link Manager, but I cannot find it in the Admin -> Tools -> Layout boxes contoller... According to instructions it suppose to start with "Links Box - Display Links in Sidebox" and I see "Links Box - Display View All Links". How I can activate the Links Manager to start to build link or see it on my website? Also I can't find the Admin -> Extras -> Links. Please, help me. I don't know what I'm doing wrong..:blink::blush: Thank you soo much in advance.

Natalya

---

The YOUR_TEMPLATE should be changed to the name of the template you are currently using on your site.

If Custom is the name of the template you are currently using on your site then the above is correct.

make sure you've uploaded the following files:

admin/link_categories.php
admin/links.php
admin/links_contact.php
admin/includes/boxes/extra_boxes/links_extras_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links.php
admin/includes/languages/english/link_categories.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/extra_definitions/links.php

Is there any way to put the "View All Links" link in a tab at the top of the page? So the top of the page would have tabs labeled "Home" "Log Out" "Links" "Contact Us" "My Account" "Checkout"... How to do this?