Community Add-Ons

*/ SMALL UPDATE */
To use dutch categorie names ending with " 's " gave errors while executing an SQL query on the links_categories_name. I added the addslashes function to those lines to fix this:

NOTE: (ZIP FILE INCLUDES THIS TEXT)

/include/functions/links.php

line 306

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $cat_name . "' LIMIT 1 ");

to

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($cat_name) . "' LIMIT 1 ");




admin/include/functions/links.php

line 56

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $cat_name . "' LIMIT 1 ");

to

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($cat_name) . "' LIMIT 1 ");


admin/links.php

line 70

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $_POST['links_category_new_parent'] . "'");

to

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($_POST['links_category_new_parent']) . "'");


line 209

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $links_category . "'");

to

$categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . addslashes($links_category) . "'");

Made the following changes:

- Fixed logic mistake in admin/links.php that failed when pending links was selected.
- Added limit to database call in links.php. For some reason, the call was returning over a million hits on some servers. This is just a fast fix until I can find the reason for that. The limit is set to 10,000 so it shouldn't cause any problems on any site.
- Added code to sort categories by sort order setting.
- Added class to stylesheet and code to use it in
includes/modules/vertical_listing.php
- Added code to have breadcrumb work properly
- Added code to featured infobox to disable it on ssl pages.
- Changed code in admin/links.php to account for shops located in a sub-directory
- Changed name of tep_set_categories_status function to avoid duplicate call errors.

This is a full version.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=268562

A small correction... the code below does resolve the error shown below, but it was missing a ; when originally posted. This will cause a syntax error. The correction is made below. All credit to original contributor! **no downloads attached**

habe diese tolle constrib mal installiert und bin echt begeistert

die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen

ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php

finde:
$where = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}

if ($showLinkStatus == 'All')
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

und ersetze durch:
$where = ' where ';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';

if ($showLinkStatus == 'All')
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;

Grund:
Beim LinkMangerII
in admin/includes/functions/links.php und
Enable/Disable Categories
in admin/includes/functions/general.php
wird jeweils die Funktion tep_set_categories_status($cat_id, $status) aufgerufen.

Habe beim LINKMANAGERII in admin/includes/functions/links.php ca zeile 363 die function in "function tep_set_link_categories_status($cat_id, $status) {"
umbenannt

habe diese tolle constrib mal installiert und bin echt begeistert

die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen

ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php

finde:
$where = '';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}

if ($showLinkStatus == 'All')
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

und ersetze durch:
$where = ' where ';
if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {
$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';

if ($showLinkStatus == 'All')
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$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_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order

Made the following changes:

- converted mysql calls to work properly with Mysql 5
- fixed coding errors that prevented login boxes from showing
- added code to check for a valid login for editing links

This is a full version.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=268562

This is a replacement for the Links Manager contribution located at http://www.oscommerce.com/community/contributions,1256.

- Added code to includes/modules/links_listing.php and missing classes
for sort heading problem with the standard listing box.
- Added code based on code submitted by rabbitseffort that presents
the link exchange information in the links submit page is an
easy-to-copy format.
- Added option to check for blacklisted words. The words are defined in
a new setting in admin->configuration->Links.
- Added option to disable reciprocal link checking for individual links.
- Added a count option to admin->Configuration->Links that will allow
links to be checked by the Check links script a number of times before
the link is disabled. This was needed since some sites may not be
working when the check is performed.
- Added checkboxes to Links Status page to easily change status to Approved.
- Added option of having nested categories.
- Added option of having no categories (for display - one in admin still
needs to exist).
- Added code to check for the existence of at least one category in
admin->Links Manger->Links. If not found, the code redirects to the
admin->Links Manger->Link Categories page.
- Added option to display link count, or not.
- Added option to create a new category from within the links edit page.
- Added link category name to the links page.
- Added login option to allow link partners to edit their own links.
- Added option to Featured Links so that a featured link will be displayed
on all link pages or just on the one it is listed for.
- Changed code so that the breadcrumb link has the session ID attached.
- Changed code in admin/links.pgp so search function works as expected.
- Changed code in admin/links.php to generate a normal link instead of
an SEO one, which was causing some sites problems. If you want that
ability, you should install Ultimate SEO with the update for Links Manager.
- Changed links_db_update.php script so that it will update the
admin->configuration->Links options while keeping the current settings in place.
- Changed code so that the categories description is displayed as a true
categories description on the page under the page heading.
- Fixed search code so it finds the links from any page
- Included fixes from partial updates and items mentioned in the
support thread.
- Removed extra code from links_check.php file to speed up checking.
- Removed the code for the Rating option since it was never implemented.
- Renamed to Links Manager II since the large amount of changes would
cause support problems.
- Made many small fixes and changes that are too numerous to mention.

This is a full version.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=268562