PDA

View Full Version : Links Manager II V 1.16



michael_s
02-11-2008, 04:53 AM
*/ 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) . "'");

More... (http://addons.oscommerce.com/info/5272)