Link Manager 3.0 Support Thread

[DivaVocals]

If you are entering a banner image from admin -> extras -> links
you only need to use the following in the image url input box (links_image/goodshepard_logo.gif)
In order for this to work, you will need to have the banner image located on your server in images/links_image/

from admin -> extras -> links categories

You have two choices
1) similar to the above you only need to use (link_category/clothing.png) Again, the image need to be located on you server in images/link_category/

2) You can use the browse button to select an image from your PC and then click the save button.

So found this old post from Clyde..

My question is has anybody been able to add the second option above to the links entry page (admin>extras> links)? I would rather have BOTH options for entering link "banner images".. This way my client doesn't HAVE TO FTP the links "banner" images..

[mutinyzoo]

Page Parameters= gID=41 (your_domain.com/admin/configuration.php?gID=xx <-- type this address into your browser and keep changing the gID number until you find your Links Manager page)

Thank you very much, Moksha and Diva Vocals. A potentially faster way to achieve the above quoted step is to find the id number in the database either using phpAdmin or with the following SQL statement:

SELECT *
FROM `your_zc_database`.`configuration_group`
WHERE (`configuration_group_title` LIKE '%link%')
LIMIT 0 , 30

I wonder what it would take to update the plugin so that it would self-register.

[mutinyzoo]

Also in case it wasn't clear - data that needs to be inserted into the Configuration field includes gID=XX, not just the number.

[mutinyzoo]

I'm having trouble installing the SQL file because my server is still using MySQL version 5.5, which does not allow the following statement:

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 ;

and specifically

`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',

.

The error being that the default value is invalid. Apparently in the latest version of MySQL the DATETIME is allowed.

Two recommended workaround are to use TIMESTAMP instead of DATETIME or to add TRIGGERS to the table.

I was able to use

  `links_date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

but then got errors trying to add a second TIMESTAM field (links_last_modified).

I installed the table WITHOUT the links_date_added field (might not be necessary), but am getting "WARNING: An Error occurred, please refresh the page and try again."

Insights welcome and I will post solution, of course.

[mutinyzoo]

Okay seems to be working now. The MySQL statement that will not work under MySQL 5.5.x is the CREATE TABLE links statement which I beleve can be replaced with:

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` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `links_last_modified` TIMESTAMP,
  `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`)
) ENGINE=MyISAM ;

Differences: updated the DATETIME statements to replace with TIMESTAMP and updated TYPE=MyISAM to ENGINE=MyISAM.

TIMESTAMP has some limitations, but they should not be a problem in this application (unless you are still trying to use it in the year 2030).

[mutinyzoo]

So found this old post from Clyde..

My question is has anybody been able to add the second option above to the links entry page (admin>extras> links)? I would rather have BOTH options for entering link "banner images".. This way my client doesn't HAVE TO FTP the links "banner" images..

Did you ever make any headway on this, DivaVocals? It also appears that at this point one can only upload "link images" via the front end link add, and not the back end.

[mutinyzoo]

I'm would like Link Manager to display the list of links by category, as opposed to first displaying only the categories, then a page of the links within each category. The format I want is that for each category there will be a heading containing the Name of the Category, followed by a listing of it's associated links. In other words:

CATEGORY1
link title - link description - image
link title - link description - image
link title - link description - image

CATEGORY2
link title - link description - image

ETC

I think this will require some new coding in the tpl_links_default page and will require a multi-table SQL query - like a JOIN (inner, outer, left?).

There are four relevant tables (i think):
1. link_categories_description which contains link_categories_name
2. links which contains the link url and image url
3. links_to_link_categories which associates link_ids with link_categories_id
4. links_description which contains links_description

I welcome any pointers (towards or away from).

[DivaVocals]

Did you ever make any headway on this, DivaVocals? It also appears that at this point one can only upload "link images" via the front end link add, and not the back end.

My only headway was to pose the question..

[davewest]

My only headway was to pose the question..

so... was making a new sidebox to display links like some of the site I visit... had issues with the admin image thingy... so fixed it tonight. I wanted it to not change the image if updating something else, upload a new image, take one off my server, change directories, change to the default image... got it done..

Give me some time and I'll put the code to a clean install and post it back here or to my blog! going to be a busy week again so may take a bit to do.

[DivaVocals]

so... was making a new sidebox to display links like some of the site I visit... had issues with the admin image thingy... so fixed it tonight. I wanted it to not change the image if updating something else, upload a new image, take one off my server, change directories, change to the default image... got it done..

Give me some time and I'll put the code to a clean install and post it back here or to my blog! going to be a busy week again so may take a bit to do.

As always here you come to the rescue!!!