Link Manager 3.0 Support Thread

[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

[clydejones]

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

open admin/links.php

find this line of code (around line 556)

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by ld.links_title, l.links_url"; 

and replace with this line

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by l.links_date_added DESC, ld.links_title, l.links_url"; 

[fvb]

open admin/links.php

find this line of code (around line 556)

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by ld.links_title, l.links_url"; 

and replace with this line

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by l.links_date_added DESC, ld.links_title, l.links_url"; 

[FONT=Times New Roman]Thanks, the code changed the sort order for the Admin/extras/links[/FONT]

[FONT=Times New Roman]Should this be controlled by the settings in Admin/configuration/linksManager [/FONT][FONT=Times New Roman]Select links sort order. When I change the sort order number it does not change the sort order back and forth in the admin/extras/links[/FONT]
[FONT=Times New Roman]I guess I can keep 2 copies of links.php[/FONT]

[clydejones]

[FONT=Times New Roman]Thanks, the code changed the sort order for the Admin/extras/links[/FONT]

[FONT=Times New Roman]Should this be controlled by the settings in Admin/configuration/linksManager [/FONT][FONT=Times New Roman]Select links sort order. When I change the sort order number it does not change the sort order back and forth in the admin/extras/links[/FONT]
[FONT=Times New Roman]I guess I can keep 2 copies of links.php[/FONT]

Admin/configuration/linksManager Select links sort order
This setting controls the sort order of the links that are displayed within a category on the catalog side and has nothing to do with the sort order of the links in the admin panel (admin/extras/links).

[fvb]

Admin/configuration/linksManager Select links sort order
This setting controls the sort order of the links that are displayed within a category on the catalog side and has nothing to do with the sort order of the links in the admin panel (admin/extras/links).

ok, thanks

[fvb]

I'm getting a lot of link swap requests that look like this for there link back page
site.domain.com
does google see this as being the same domain as www.domain.com
or are these two completely different domains?
my guess is that they are different, and they are just trying to get one way links to there site

[clydejones]

I'm getting a lot of link swap requests that look like this for there link back page
site.domain.com
does google see this as being the same domain as www.domain.com
or are these two completely different domains?
my guess is that they are different, and they are just trying to get one way links to there site

They could be linking to a "link farm site" and that will only show their link and not a reciprocal link with your site information.

[tigerbalm]

Hi Clyde

First of all - many thanks for your efforts.

I have just installed the Link Manager - latest version.

I have created categories back end but I am unable to create links within these categories. I can get the page to fill in the new link details but at the bottom wher I should submit - it says under options:

Status:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/*****/public_html/shop/admin/includes/functions/html_output.php on line 333

using Database: MySQL 4.1.22-standard
PHP 5.2.5

Have you any idea what this problem might be?

ta

:o)