Link Manager 3.0 Support Thread

[fvb]

Open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.php

find the following line of code (around line 19):

$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_name"); 

and replace it with this line:

$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_sort_order"); 

I tried this fix on 2 sites
it fixes the sort order for the online catalog, but no in the admin area

both site also get this error when you click on "view all link"
1054 Unknown column 'lcd.link_categories_sort_order' in 'order clause'
in:
[select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '1' order by lcd.link_categories_sort_order]

[clydejones]

I tried this fix on 2 sites
it fixes the sort order for the online catalog, but no in the admin area

both site also get this error when you click on "view all link"
1054 Unknown column 'lcd.link_categories_sort_order' in 'order clause'
in:
[select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '1' order by lcd.link_categories_sort_order]

revert back to the original line of code and I'll check out the error message.

[clydejones]

revert back to the original line of code and I'll check out the error message.

This line of code will eliminate the error:

$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lc.link_categories_sort_order, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lc.link_categories_sort_order"); 

[fvb]

This line of code will eliminate the error:

$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lc.link_categories_sort_order, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lc.link_categories_sort_order"); 

thanks, I will try it tonight and let you know

[countrycharm]

clydejones this may sound stupid but does links_manager make it's own [FONT=Verdana]Reciprocal Page for the ones who want to trade links with you, or after you make your link categories does it makes a [/FONT][FONT=Verdana]Reciprocal link for them. I'm just trying to figure out how this works. Or do I have to make a page for the [/FONT][FONT=Verdana]Reciprocal[/FONT][FONT=Verdana]. Also do I need to make banners. I just need some steering. Thank you for your help[/FONT][FONT=Verdana][/FONT]

[clydejones]

clydejones this may sound stupid but does links_manager make it's own [FONT=Verdana]Reciprocal Page for the ones who want to trade links with you, or after you make your link categories does it makes a [/FONT][FONT=Verdana]Reciprocal link for them. I'm just trying to figure out how this works. Or do I have to make a page for the [/FONT][FONT=Verdana]Reciprocal[/FONT][FONT=Verdana]. Also do I need to make banners. I just need some steering. Thank you for your help[/FONT][FONT=Verdana][/FONT]

Short answer, Yes, it will place your link on a page based on which category you've placed the link in.

For instance if I add a link to your site I place the following in the Reciprocal link field: (mysticmountainnaturals. com/demotest/index.php?lPath=16&main_page=links) This is the page on my site where the link to your site resides.

No you don't need to make a banner unless you want to.

[countrycharm]

Thank you for explaining this to me. I have wondered about this a while. I have one more question for you. There is nothing to configure under admin/configuration/links manger nothing shows at all but the update button. How do I get the information to display the configuration for link manger. Under admin/extras there are links, link category, links contact everything is there like it is suppose to be. Thank you again.

[fvb]

This line of code will eliminate the error:

$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lc.link_categories_sort_order, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lc.link_categories_sort_order"); 

that fixed the error, and the sort order in the on line catalog

but did not fix the sort order in the admin/extras/links

[clydejones]

that fixed the error, and the sort order in the on line catalog

but did not fix the sort order in the admin/extras/links

The code as presently written (admin side) will order categories by sort order and name.

What happens when you edit a category and change the sort order?
(When checking this, on 4 different sites, the categories are ordered by sort order)

[fvb]

The code as presently written (admin side) will order categories by sort order and name.

What happens when you edit a category and change the sort order?
(When checking this, on 4 different sites, the categories are ordered by sort order)

when I edit a category and change the sort order, the order changes like it should

I was hoping to change the sort order of the admin/extras/links so the new ones that need approval would come up first