Link Manager 3.0 Support Thread

**ddy1** · 31 Jul 2009, 12:19 AM

HI!

I have installed the module and ran the sql patch. When I go to the admin--configuration--Links Manager, it is all blank with only the titles title, value and action. And when I activate the sidebox from the layout boxes controller I get this error:

1146 Table 'littlefa_store.link_categories' doesn't exist
in:
[select lc.link_categories_id, lc.link_categories_sort_order, lcd.link_categories_id, lcd.link_categories_name from link_categories lc, link_categories_description lcd where lc.link_categories_status = '1' and lc.link_categories_id = lcd.link_categories_id and lcd.language_id = '1' order by lc.link_categories_sort_order, lcd.link_categories_name]

Can someone please help me to get this mod working?

Thanks,

Anne

**clydejones** · 31 Jul 2009, 01:40 AM

Originally Posted by ddy1

HI!

I have installed the module and ran the sql patch. When I go to the admin--configuration--Links Manager, it is all blank with only the titles title, value and action. And when I activate the sidebox from the layout boxes controller I get this error:

1146 Table 'littlefa_store.link_categories' doesn't exist
in:
[select lc.link_categories_id, lc.link_categories_sort_order, lcd.link_categories_id, lcd.link_categories_name from link_categories lc, link_categories_description lcd where lc.link_categories_status = '1' and lc.link_categories_id = lcd.link_categories_id and lcd.language_id = '1' order by lc.link_categories_sort_order, lcd.link_categories_name]

Can someone please help me to get this mod working?

Thanks,

Anne

go to

admin -> tools -> install sql patches

copy and past the following into the text area and then click the send button

Code:

# Links Manager SQL Install
# For Zen-Cart 1.3.8
# Version: 3.4.1
# Updated: 3/27/2008
# 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''), '), (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''), '), (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''), '), (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''), '), (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''), '), (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), (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 8, NULL, now(), NULL, NULL), (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), (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 10, NULL, now(), NULL, NULL), (NULL, 'Link Title Maximum Length', 'ENTRY_LINKS_TITLE_MAX_LENGTH', '50', 'Maximum length of link title.', @configuration_group_id, 11, NULL, now(), NULL, NULL), (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 12, NULL, now(), NULL, NULL), (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 13, NULL, now(), NULL, NULL), (NULL, 'Link Description Maximum Length', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '250', 'Maximum length of link description.', @configuration_group_id, 14, NULL, now(), NULL, NULL), (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), (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), (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), (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), (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), (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''),'), (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),  (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), (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), (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), (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''),'), (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), (NULL, 'Image - Link Banner Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 27, NULL, now(), NULL, NULL), (NULL, 'Image - Link Banner Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 28, NULL, now(), NULL, NULL), (NULL, 'Default Link Banner Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @configuration_group_id, 29, NULL, now(), NULL, NULL), (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''),'), (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', 25, 999, 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',
  `links_rating` tinyint(1) 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');
INSERT INTO `links_status` VALUES (3, 1, 'Disabled');
INSERT INTO `links_status` VALUES (1, 2, 'Pending');
INSERT INTO `links_status` VALUES (2, 2, 'Approved');
INSERT INTO `links_status` VALUES (3, 2, 'Disabled');

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

**ddy1** · 31 Jul 2009, 01:50 AM

Wow! You are better than awesome! It looks like everything is working now, thank you so much for your quick help. I am off to test it now...

Thanks again,

Anne

**clydejones** · 31 Jul 2009, 10:01 PM

Originally Posted by jezjones29

[FONT=Arial]I could try. [/FONT]

[FONT=Arial]I didn't make any notes, and this is a complete hack! Maybe you could help me clean it up? I looks like it works on my site, so I'm happy.[/FONT]

[FONT=Arial]It also keeps a track of the clicks to stop cheating

[/FONT]

Code:

[FONT=Arial]Database:[/FONT]
[FONT=Arial]CREATE TABLE `links_clicks` ( `site_id` int(11) NOT NULL, `click_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ip_adr` varchar(30) NOT NULL, KEY `site_id` (`site_id`) ) ENGINE=MyISAM;[/FONT]
 
[FONT=Arial]header file:[/FONT]
 
[FONT=Arial]elseif (isset($_GET['links_url'])) {[/FONT]
[FONT=Arial]if (get_magic_quotes_gpc()) $_GET['links_url'] = stripslashes($_GET['links_url']);[/FONT]
[FONT=Arial]$links_url = 'http://'.mysql_real_escape_string($_GET['links_url']);[/FONT]
[FONT=Arial]zen_update_links_click_count($links_url); [/FONT]
[FONT=Arial] }[/FONT]
 
 
[FONT=Arial]Functions:[/FONT]
 
[FONT=Arial]//REMOVE HTTPS[/FONT]
[FONT=Arial]function remove_http($url = '')[/FONT]
[FONT=Arial]{[/FONT]
[FONT=Arial]return(str_replace(array('http://','https://'), '', $url));[/FONT]
[FONT=Arial]}[/FONT]
[FONT=Arial]// Return the links url[/FONT]
[FONT=Arial] function zen_get_links_url($identifier) {[/FONT]
[FONT=Arial] global $db;[/FONT]
[FONT=Arial]   $link = $db->Execute("select links_id, links_url from " . TABLE_LINKS . " where links_id = '" . (int)$identifier . "'");[/FONT]
[FONT=Arial]   $url = remove_http($link->fields['links_url']);[/FONT]
[FONT=Arial]   $links_string = 'links?links_url='.$url;[/FONT]
[FONT=Arial]   return $links_string;[/FONT]
[FONT=Arial] }[/FONT]
[FONT=Arial]////[/FONT]
 
[FONT=Arial] function zen_update_links_click_count($links_url) {[/FONT]
[FONT=Arial]    global $db;[/FONT]
[FONT=Arial]   $url = 'http://www.yoursite.com';   [/FONT]
[FONT=Arial]   $result = $db->Execute("select links_id, links_url from " . TABLE_LINKS . " where links_url = '" . $links_url . "'");[/FONT]
[FONT=Arial]   if ($result->RecordCount() == 1) {[/FONT]
[FONT=Arial]     $url = $links_url;      [/FONT]
[FONT=Arial]     $id = $result ->fields['links_id'];      [/FONT]
[FONT=Arial]     $IP = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);      [/FONT]
[FONT=Arial]     $time_diff = 3600*24*14;       [/FONT]
[FONT=Arial]     $test = $db->Execute("select COUNT(*) AS testval from " . TABLE_LINKS_CLICKS . " where ip_adr = '".$IP."' AND click_time+".$time_diff." > NOW() AND site_id = '".$id."'");[/FONT]
 
[FONT=Arial]     if ($test->fields['testval'] == 0) {[/FONT]
[FONT=Arial]      $db->Execute("INSERT INTO " . TABLE_LINKS_CLICKS . " set ip_adr = '".$IP."', site_id = '".(int)$id."' ");[/FONT]
[FONT=Arial]      $db->Execute("update " . TABLE_LINKS . " set links_clicked = links_clicked + 1 where links_id = '" . (int)$id . "'");[/FONT]
[FONT=Arial]     }[/FONT]
[FONT=Arial]    } [/FONT]
[FONT=Arial]header("Location: $url");[/FONT]
[FONT=Arial]exit;[/FONT]
[FONT=Arial] }[/FONT]
[FONT=Arial][/FONT] 
[FONT=Arial]define tag:[/FONT]
 
define('TABLE_LINKS_CLICKS', DB_PREFIX . 'links_clicks');

Can you zip up the files you edited and post them.

**glmic1983** · 4 Aug 2009, 06:42 PM

Hi, I've got some error. I have followed all the instructions and cut & paste the sql code but when I press the "send" button this is what I get..

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

Is there probable to fix the error? Many thanks!

P.S. my LM is V3-5-0

**clydejones** · 4 Aug 2009, 07:22 PM

Originally Posted by glmic1983

Hi, I've got some error. I have followed all the instructions and cut & paste the sql code but when I press the "send" button this is what I get..

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

Is there probable to fix the error? Many thanks!

P.S. my LM is V3-5-0

You don't need to worry.

Its just as it says those or statements were ignored.

everything has installed correctly.

**glmic1983** · 5 Aug 2009, 03:01 AM

Originally Posted by clydejones

You don't need to worry.

Its just as it says those or statements were ignored.

everything has installed correctly.

Thank you so much for your fast reply

**countrycharm** · 5 Aug 2009, 10:38 PM

Originally Posted by clydejones

Can you zip up the files you edited and post them.

Originally Posted by jezjones29

[FONT=Arial]I could try. [/FONT]

[FONT=Arial]I didn't make any notes, and this is a complete hack! Maybe you could help me clean it up? I looks like it works on my site, so I'm happy.[/FONT]

[FONT=Arial]It also keeps a track of the clicks to stop cheating

[/FONT]

Code:

[FONT=Arial]Database:[/FONT]
[FONT=Arial]CREATE TABLE `links_clicks` ( `site_id` int(11) NOT NULL, `click_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ip_adr` varchar(30) NOT NULL, KEY `site_id` (`site_id`) ) ENGINE=MyISAM;[/FONT]
 
[FONT=Arial]header file:[/FONT]
 
[FONT=Arial]elseif (isset($_GET['links_url'])) {[/FONT]
[FONT=Arial]if (get_magic_quotes_gpc()) $_GET['links_url'] = stripslashes($_GET['links_url']);[/FONT]
[FONT=Arial]$links_url = 'http://'.mysql_real_escape_string($_GET['links_url']);[/FONT]
[FONT=Arial]zen_update_links_click_count($links_url); [/FONT]
[FONT=Arial] }[/FONT]
 
 
[FONT=Arial]Functions:[/FONT]
 
[FONT=Arial]//REMOVE HTTPS[/FONT]
[FONT=Arial]function remove_http($url = '')[/FONT]
[FONT=Arial]{[/FONT]
[FONT=Arial]return(str_replace(array('http://','https://'), '', $url));[/FONT]
[FONT=Arial]}[/FONT]
[FONT=Arial]// Return the links url[/FONT]
[FONT=Arial] function zen_get_links_url($identifier) {[/FONT]
[FONT=Arial] global $db;[/FONT]
[FONT=Arial]   $link = $db->Execute("select links_id, links_url from " . TABLE_LINKS . " where links_id = '" . (int)$identifier . "'");[/FONT]
[FONT=Arial]   $url = remove_http($link->fields['links_url']);[/FONT]
[FONT=Arial]   $links_string = 'links?links_url='.$url;[/FONT]
[FONT=Arial]   return $links_string;[/FONT]
[FONT=Arial] }[/FONT]
[FONT=Arial]////[/FONT]
 
[FONT=Arial] function zen_update_links_click_count($links_url) {[/FONT]
[FONT=Arial]    global $db;[/FONT]
[FONT=Arial]   $url = 'http://www.yoursite.com';   [/FONT]
[FONT=Arial]   $result = $db->Execute("select links_id, links_url from " . TABLE_LINKS . " where links_url = '" . $links_url . "'");[/FONT]
[FONT=Arial]   if ($result->RecordCount() == 1) {[/FONT]
[FONT=Arial]     $url = $links_url;      [/FONT]
[FONT=Arial]     $id = $result ->fields['links_id'];      [/FONT]
[FONT=Arial]     $IP = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);      [/FONT]
[FONT=Arial]     $time_diff = 3600*24*14;       [/FONT]
[FONT=Arial]     $test = $db->Execute("select COUNT(*) AS testval from " . TABLE_LINKS_CLICKS . " where ip_adr = '".$IP."' AND click_time+".$time_diff." > NOW() AND site_id = '".$id."'");[/FONT]
 
[FONT=Arial]     if ($test->fields['testval'] == 0) {[/FONT]
[FONT=Arial]      $db->Execute("INSERT INTO " . TABLE_LINKS_CLICKS . " set ip_adr = '".$IP."', site_id = '".(int)$id."' ");[/FONT]
[FONT=Arial]      $db->Execute("update " . TABLE_LINKS . " set links_clicked = links_clicked + 1 where links_id = '" . (int)$id . "'");[/FONT]
[FONT=Arial]     }[/FONT]
[FONT=Arial]    } [/FONT]
[FONT=Arial]header("Location: $url");[/FONT]
[FONT=Arial]exit;[/FONT]
[FONT=Arial] }[/FONT]
 
[FONT=Arial]define tag:[/FONT]
 
define('TABLE_LINKS_CLICKS', DB_PREFIX . 'links_clicks');

Would be nice if you could zip the files up and share with us on how you did that.

**alvincentinio** · 14 Aug 2009, 11:58 AM

Hi Clyde, please can you help.

I installed Links Manager yesterday and am having the same problems as jwurster (#1447) had. Every time I try to add a link, link category etc. as soon as I click save or insert I'm returned to the main admin page with nothing added.

I've installed the Links_manager_admin_fix.zip file and both html_output.php's. In #1448 you refer to the latest updated security patch, is this an additional file? - the link goes to an invalid thread.

I've already uninstalled and reinstalled and am still having the same problem.

Any ideas?

Thanks,
Al.

**clydejones** · 14 Aug 2009, 02:52 PM

Originally Posted by alvincentinio

Hi Clyde, please can you help.

I installed Links Manager yesterday and am having the same problems as jwurster (#1447) had. Every time I try to add a link, link category etc. as soon as I click save or insert I'm returned to the main admin page with nothing added.

I've installed the Links_manager_admin_fix.zip file and both html_output.php's. In #1448 you refer to the latest updated security patch, is this an additional file? - the link goes to an invalid thread.

I've already uninstalled and reinstalled and am still having the same problem.

Any ideas?

Thanks,
Al.

The latest admin security patch can be found here:

www.zen-cart.com/forum/showthread.php?t=130161

Thread: Link Manager 3.0 Support Thread

Thread Tools

Search Thread

Display

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Re: Link Manager 3.0 Support Thread

Similar Threads

Testimonial Manager Support Thread

v154 News Box Manager v2.0.0 [Support Thread]

Download File Manager Support Thread

Poll Manager Support Thread

Empty Cart Manager [support thread]

Posting Permissions