Contributions

- Added instructions regarding the Version Checker
- Changed breadcrumb trail code so the id's are correct
- Changed domain checking code so domains are reported correctly now
- Changed the links status page so it now checks the links when loaded and displays accurate results
- Changed links_check code so that if a site is found, the link count is decremented
- Changed links_check code so that emails are handled correctly
- Changed links image code so images are now uploaded and loaded from the server (previous url's for images will still work)
- Converted code for 2.3 compatibility
- Fixed back code so previous link category is correctly formatted
- Fixed many miscellaneous mistakes as reported by user wdepot

The support thread is at
http://forums.oscommerce.com/topic/268562-links-manager-ii/

This is a full version.

- Changed the code for figuring out the domain name
- Changed the code in the phase checking code

The support thread is at
http://forums.oscommerce.com/topic/268562-links-manager-ii/

This is a full version.

Changes:
- Added code to email results of the link_check script to the shop owner
- Changed javascript code on links edit page to consider the reciprocal override setting
- Fixed errors in the links_check.php file that prevented the new options from working correctly
- Switched the images on the Links Edit page so the domain and parent checks indicate correctly

The support thread is at
http://forums.oscommerce.com/topic/268562-links-manager-ii/

This is a full version.

- Added charset meta tag into links.php and links_submit.php
- Added option to display part of category description on the links page
- Added filtering for cross-scripting (thanks to member 32 Degrees)
- Added code to verify submitted links actually exist
- Added code to verify submitted links are all from the same domain name (thanks to member shpy)
- Added code to verify reciprocal links have a parent link on the home page
- Added column in links status in admin to show if the urls do not match (thanks to member shpy)
- Added a new class to the sytlesheet for descriptions
- Added a date column to the links listing in admin
- Added a no follow tag to the popup file
- Changed how titles are displayed on the links page
- Changed links check code to better check for errors
- Fixed a mistake in one of the css classes that caused the link count to be hidden
- Fixed search function on shop side (thanks to member shpy)
- Fixed several minor errors - missing classes, duplicate text, etc.
- Replaced ereg calls with preg type

The support thread is at
http://forums.oscommerce.com/topic/268562-links-manager-ii/

This is a full version.

Changed dropdown list on submit page to tree layout
Changed version checking code to provide more information
Fixed error in database and link files to do with with Title as Link option
Fixed problem with link disable option in admin that caused subsequent links to be disabled
Fixed code in links.php that caused an invalid url to be created
Fixed coding mistake in admin/links.php that failed with some searches
Removed the Version Checking files from the contribution to avoid problems with updates

This is a full version.

- Added code to links_submit.php to check for maximum description size
- Added missing classes in stylesheet code and changed includes/modules/link_listing.php to use them.
- Added option to show all link categories, even if they are empty.
- Added option to control how many sub-categories are displayed beneath its parent category.
- Added code to admin/links.php to check for links that have the same partner name.
- Added an option in the new link page in admin to notify the new link partner that a link was added.
- Added an option to control how the submit page displays.
- Added stylesheet classes to control the appearance of the links submit page.
- Added a version checking option to make it easy to know when updates are available.
- Changed code in admin/links.php to use a tree layout for the link categories.
- Changed code in admin/links.php with regards to the language selection. It would fail
on some shops since the same array name was used by other code.
- Changed code in admin/links_check.php to reset reciprocal link counter if link was found.
- Changed several hard-coded text entries so they are more language specific.
- Corrected install instructions to add function to html_output.php instead of general.php.
- Fixed coding error in links.php that caused the link in the email to be incorrect.
- Fixed coding error in links.php that caused a failure if the bad words contained an extra comma (identified by Viper0409)
- Fixed coding error in links.php that caused a description required message even though the description was present.
- Fixed coding error in links.php that prevented the categories from being handled properly.
- Fixed coding mistake in links.php that cause a javascript error when checking the description.
- Fixed and enhanced the search code in admin/links.php.
- Removed unnecessary code in links.php.
- Removed code in admin/links.php for setting the reciprocal link count option. Forgetting
to do so caused problems with the link check code. It is forced to 0 now when a link is updated.


This is a full version.

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

- Fixed javascript error in admin/links.php.
- Fixed coding error in admin/links.php that would cause a missing category error.
- Fixed code when curl was used since it was returning false results.
- Added code to check if a domain exists. This will help with clearing out dead links.
- Changed language code on the shop side to use standard code.
- Changed instructions for setting up link exchanges.
- Removed debug code from admin/links.php.

This is a full version.

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

- Fixed mistake in the links_setup.php file.
- Added missing instruction to the main install file.
- Fixed code in links.php to allow showing of links without categories.

This is a full version.

- Added missing column, links_all_pages, to the links_setup.php file.
- Updated readme instructions to include changes in last version.
- Fixed the reciprocal link override option in admin and the code associated with it in admin.

This is a full version.

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

- Changed code in links.php so the link to link_submit.php doesn't inherit the link id's.
- Changed reference to the class being used in links.php.
- Changed instructions in admin/links_exchange.php
- Changed Links Exchange section so it works for all languages.
- Replaced the german files as supplied by Alexander Maringer.

This is a full version.

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

Changes Made:
- Fixed coding mistakes in includes/boxes/links.php
- Fixed sort code in admin/links.php file.
- Fixed the links search in admin->Links Manager II->Links.
- Fixed coding errors in Links Status.
- Fixed code to prevent featured links from appearing twice on the same page.
- Added code to featured box to limit the image size.
- Added text definition in english/links_submit.php
- Added a Links Exchange section to admin->Links Manager II that allows changing the link exchange information from there.
- Added sort code to links status page.
- Added option in Links Status to allow easy setting of the status.
- Added code to only show categories if it has links.
- Added anchors to the link images.
- Added code to links submit page to notify the shop owner if the links description was changed.
- Added code to use curl, if available, when checking links.
- Removed parent from the url.
- Cleaned up a number of mysql coding mistakes.
- Cleaned up the links submit page layout.

This is a full version.

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

*/ 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