Link Manager 3.0 Support Thread

Table Prefixes...

I was wondering about the table prefix I have, it's not the defaults.

Will this cause problems if I simply change them in the sql? Or do I have to also find them in the pages and adjust them there somewhere as well.

If so, could you please advise which files will need to be modified.

Finally, I'm running 1.3.7, not 1.3.8... Please tell me that won't be an issue... ;)

Ray

RayDube:

Table Prefixes...

I was wondering about the table prefix I have, it's not the defaults.

Will this cause problems if I simply change them in the sql? Or do I have to also find them in the pages and adjust them there somewhere as well.

If so, could you please advise which files will need to be modified.

Finally, I'm running 1.3.7, not 1.3.8... Please tell me that won't be an issue... ;)

Ray

If you set up the prefixes as part of your initial install of Zen Cart, then you should be able to just run the sql statement from admin -> tools -> install sql patches without problems.

The same would also apply for the the pages which query the database.

I would appreciate it if people did not use my link exchange as a test to see whether they want to install it themsleves. This happened last night and its not welcome. Cheers.

Crooked_Halo:

I would appreciate it if people did not use my link exchange as a test to see whether they want to install it themsleves. This happened last night and its not welcome. Cheers.

You could always set links manager so that only registered customers could submit links.
admin -> configuration -> links manager

On the Admin->Extras->Links Categories page the Sort Order works properly and the categories are displayed in sort order. However, when viewing the categories list from the catalog they are listed in alphabetical order.

I have looked in the configurations but have not been able to locate any options for this display.

Asgoroth:

On the Admin->Extras->Links Categories page the Sort Order works properly and the categories are displayed in sort order. However, when viewing the categories list from the catalog they are listed in alphabetical order.

I have looked in the configurations but have not been able to locate any options for this display.

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");

clydejones:

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:
>  
> ```php
$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" :no:
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]

fvb:

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" :no:
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");  

clydejones:

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

clydejones:

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 :clap:
 
but did not fix the sort order in the admin/extras/links :huh:

fvb:

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

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

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)

clydejones:

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

fvb:

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";

clydejones:

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
> ```php
$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";

Thanks, the code changed the sort order for the Admin/extras/links:bigups:

Should this be controlled by the settings in Admin/configuration/linksManager 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
I guess I can keep 2 copies of links.php:blink:

fvb:

Thanks, the code changed the sort order for the Admin/extras/links:bigups:

Should this be controlled by the settings in Admin/configuration/linksManager 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
I guess I can keep 2 copies of links.php:blink:

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).

clydejones:

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

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

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

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.

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)