[Contribution] Links Manager for osC v1.00

October 9, 2003

File reads:

// Define the project version

define('PROJECT_VERSION', 'osCommerce 2.2-CVS');

Sooooo, what next?

Thanks!

VJ · October 9, 2003

Ah, now comes the hard part... the version you run, is a CVS snapshot. I'm not sure how to find, if its a pre-MS2 snapshot or not.

Do you have the osc setup file you downloaded. That filename should give you the date of the snapshot.

VJ

October 12, 2003

Has anyone modified this latest version to work with MS1? I have major mods in my MS1 installation, so will be awhile before I upgrade to MS2. However, I like the features in this version of Links Manager, but it won't work in MS1.

Can someone point me in the right direction to change the MS2 specific coding to work with MS1?

Thanks in advance...

Charlie

October 15, 2003

Hi All,

I also have a customzied site but to my shame am running:

application_top.php,v 1.264 2003/02/17

Tried hacking in your details in FILENAMES.php & DATABASE_TABLES.php into the respective areas in application_top.php but no joy... well partial joy...

I can't add a test link through Admin (it bombs out when confirming this)

:o Fatal error: Call to undefined function: tep_validate_email() in /home2/thedvdchart/www/catalog/?????admin?????/links.php on line 83

I can create categories with no problem in Admin. One which can be seen here.

http://www.loadsmorestuff.com/catalog/links.php

Can someone point me in the right direction on this. I've only ever played about with PHP passing variables from form to form on another site. But would really like to get this working on my version and I'm sure there's a lot of people with modified installs that would like to use this as well. :)

Cheers,

Simon.

October 17, 2003

there should only be 1 _/

Shoudn't there?

</table></td>

<tr>

i've got a proberlem with the same contribute

Mark1 · December 7, 2003

I am getting an error after installing this contribution. The error happens when I try to create a new Link Category in Admin.

From Admin>Link Categories>New category... When creating a new category, I fill in the appropriate boxes and designate the new icon for the category. Then, I click the save, I get the following:

Fatal error: Cannot instantiate non-existent class: upload in /usr/local/apache_1.3.20/htdocs/host42/www/web/admin/link_categories.php on line 83

Here is my /admin/link_categories.php file:

<?php

/*

$Id: link_categories.php,v 1.00 2003/10/02 Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

// define our link functions

require(DIR_WS_FUNCTIONS . 'links.php');

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

$error = false;

$processed = false;

if (tep_not_null($action)) {

switch ($action) {

case 'setflag':

$status = tep_db_prepare_input($HTTP_GET_VARS['flag']);

if ($status == '1') {

tep_db_query("update " . TABLE_LINK_CATEGORIES . " set link_categories_status = '1' where link_categories_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

} elseif ($status == '0') {

tep_db_query("update " . TABLE_LINK_CATEGORIES . " set link_categories_status = '0' where link_categories_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

}

tep_redirect(tep_href_link(FILENAME_LINK_CATEGORIES, '&cID=' . $HTTP_GET_VARS['cID']));

break;

case 'insert':

case 'update':

if (isset($HTTP_POST_VARS['link_categories_id'])) $link_categories_id = tep_db_prepare_input($HTTP_POST_VARS['link_categories_id']);

$link_categories_sort_order = tep_db_prepare_input($HTTP_POST_VARS['link_categories_sort_order']);

$link_categories_status = ((tep_db_prepare_input($HTTP_POST_VARS['link_categories_status']) == 'on') ? '1' : '0');

$sql_data_array = array('link_categories_sort_order' => $link_categories_sort_order,

'link_categories_status' => $link_categories_status);

if ($action == 'insert') {

$insert_sql_data = array('link_categories_date_added' => 'now()');

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

tep_db_perform(TABLE_LINK_CATEGORIES, $sql_data_array);

$link_categories_id = tep_db_insert_id();

} elseif ($action == 'update') {

$update_sql_data = array('link_categories_last_modified' => 'now()');

$sql_data_array = array_merge($sql_data_array, $update_sql_data);

tep_db_perform(TABLE_LINK_CATEGORIES, $sql_data_array, 'update', "link_categories_id = '" . (int)$link_categories_id . "'");

}

$languages = tep_get_languages();

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$link_categories_name_array = $HTTP_POST_VARS['link_categories_name'];

$link_categories_description_array = $HTTP_POST_VARS['link_categories_description'];

$language_id = $languages[$i]['id'];

$sql_data_array = array('link_categories_name' => tep_db_prepare_input($link_categories_name_array[$language_id]),

'link_categories_description' => tep_db_prepare_input($link_categories_description_array[$language_id]));

if ($action == 'insert') {

$insert_sql_data = array('link_categories_id' => $link_categories_id,

'language_id' => $languages[$i]['id']);

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

tep_db_perform(TABLE_LINK_CATEGORIES_DESCRIPTION, $sql_data_array);

} elseif ($action == 'update') {

tep_db_perform(TABLE_LINK_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "link_categories_id = '" . (int)$link_categories_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

}

if ($link_categories_image = new upload('link_categories_image', DIR_FS_IMAGES)) {

tep_db_query("update " . TABLE_LINK_CATEGORIES . " set link_categories_image = '" . tep_db_input($link_categories_image->filename) . "' where link_categories_id = '" . (int)$link_categories_id . "'");

}

tep_redirect(tep_href_link(FILENAME_LINK_CATEGORIES, '&cID=' . $link_categories_id));

break;

case 'delete_confirm':

if (isset($HTTP_POST_VARS['link_categories_id'])) {

$link_categories_id = tep_db_prepare_input($HTTP_POST_VARS['link_categories_id']);

$link_ids_query = tep_db_query("select links_id from " . TABLE_LINKS_TO_LINK_CATEGORIES . " where link_categories_id = '" . (int)$link_categories_id . "'");

while ($link_ids = tep_db_fetch_array($link_ids_query)) {

tep_remove_link($link_ids['links_id']);

}

tep_remove_link_category($link_categories_id);

}

tep_redirect(tep_href_link(FILENAME_LINK_CATEGORIES));

break;

default:

$link_categories_query = tep_db_query("select lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from " . TABLE_LINK_CATEGORIES . " lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lc.link_categories_id = lcd.link_categories_id where lcd.link_categories_id = lc.link_categories_id and lc.link_categories_id = '" . (int)$HTTP_GET_VARS['cID'] . "' and lcd.language_id = '" . (int)$languages_id . "'");

$link_categories = tep_db_fetch_array($link_categories_query);

$links_count_query = tep_db_query("select count(*) as link_categories_count from " . TABLE_LINKS_TO_LINK_CATEGORIES . " where link_categories_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

$links_count = tep_db_fetch_array($links_count_query);

$cInfo_array = array_merge($link_categories, $links_count);

$cInfo = new objectInfo($cInfo_array);

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

</form></tr>

</table></td>

</tr>

<tr>

<tr>

</tr>

<?php

$search = '';

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']));

$search = " and lcd.link_categories_name like '%" . $keywords . "%'";

$link_categories_query_raw = "select lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from " . TABLE_LINK_CATEGORIES . " lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '" . (int)$languages_id . "'" . $search . " order by lc.link_categories_sort_order, lcd.link_categories_name";

} else {

$link_categories_query_raw = "select lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from " . TABLE_LINK_CATEGORIES . " lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '" . (int)$languages_id . "' order by lc.link_categories_sort_order, lcd.link_categories_name";

}

$link_categories_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $link_categories_query_raw, $link_categories_query_numrows);

$link_categories_query = tep_db_query($link_categories_query_raw);

while ($link_categories = tep_db_fetch_array($link_categories_query)) {

if ((!isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $link_categories['link_categories_id']))) && !isset($cInfo)) {

$links_count_query = tep_db_query("select count(*) as link_categories_count from " . TABLE_LINKS_TO_LINK_CATEGORIES . " where link_categories_id = '" . (int)$link_categories['link_categories_id'] . "'");

$links_count = tep_db_fetch_array($links_count_query);

$cInfo_array = array_merge($link_categories, $links_count);

$cInfo = new objectInfo($cInfo_array);

}

if (isset($cInfo) && is_object($cInfo) && ($link_categories['link_categories_id'] == $cInfo->link_categories_id)) {

echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_LINK_CATEGORIES, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->link_categories_id . '&action=edit') . '\'">' . "\n";

} else {

echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_LINK_CATEGORIES, tep_get_all_get_params(array('cID')) . 'cID=' . $link_categories['link_categories_id']) . '\'">' . "\n";

}

?>

<?php

if ($link_categories['link_categories_status'] == '1') {

echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'action=setflag&flag=0&cID=' . $link_categories['link_categories_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';

} else {

echo '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'action=setflag&flag=1&cID=' . $link_categories['link_categories_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);

}

?></td>

<td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($link_categories['link_categories_id'] == $cInfo->link_categories_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, tep_get_all_get_params(array('cID')) . 'cID=' . $link_categories['link_categories_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

</tr>

<?php

}

?>

<tr>

<tr>

<td class="smallText" valign="top"><?php echo $link_categories_split->display_count($link_categories_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_LINK_CATEGORIES); ?></td>

<td class="smallText" align="right"><?php echo $link_categories_split->display_links($link_categories_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?></td>

</tr>

<tr>

<?php

if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {

?>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES) . '">' . tep_image_button('button_reset.gif', IMAGE_RESET) . '</a>'; ?></td>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_category.gif', IMAGE_NEW_CATEGORY) . '</a>'; ?></td>

<?php

} else {

?>

<td align="right" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_category.gif', IMAGE_NEW_CATEGORY) . '</a>'; ?></td>

<?php

}

?>

</tr>

</table></td>

</tr>

</table></td>

<?php

$heading = array();

$contents = array();

switch ($action) {

case 'new':

$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_LINK_CATEGORY . '</b>');

$contents = array('form' => tep_draw_form('new_link_categories', FILENAME_LINK_CATEGORIES, 'action=insert', 'post', 'enctype="multipart/form-data"'));

$contents[] = array('text' => TEXT_NEW_LINK_CATEGORIES_INTRO);

$link_category_inputs_string = '';

$languages = tep_get_languages();

for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

$link_category_inputs_string .= '<br>' . tep_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('link_categories_name[' . $languages[$i]['id'] . ']');

}

$link_category_description_inputs_string = '';

for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

$link_category_description_inputs_string .= '<br>' . tep_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' <br>' . tep_draw_textarea_field('link_categories_description[' . $languages[$i]['id'] . ']', 'soft', '40', '5');

}

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_NAME . $link_category_inputs_string);

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_DESCRIPTION . $link_category_description_inputs_string);

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('link_categories_image'));

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_SORT_ORDER . '<br>' . tep_draw_input_field('link_categories_sort_order', '', 'size="2"'));

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_STATUS . ' ' . tep_draw_radio_field('link_categories_status', 'on', true) . ' ' . TEXT_LINK_CATEGORIES_STATUS_ENABLE . ' ' . tep_draw_radio_field('link_categories_status', 'off') . ' ' . TEXT_LINK_CATEGORIES_STATUS_DISABLE);

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_LINK_CATEGORIES) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

break;

case 'edit':

$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_LINK_CATEGORY . '</b>');

$contents = array('form' => tep_draw_form('edit_link_categories', FILENAME_LINK_CATEGORIES, 'action=update', 'post', 'enctype="multipart/form-data"') . tep_draw_hidden_field('link_categories_id', $cInfo->link_categories_id));

$contents[] = array('text' => TEXT_EDIT_LINK_CATEGORIES_INTRO);

$link_category_inputs_string = '';

$languages = tep_get_languages();

for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

$link_category_inputs_string .= '<br>' . tep_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('link_categories_name[' . $languages[$i]['id'] . ']', tep_get_link_category_name($cInfo->link_categories_id, $languages[$i]['id']));

}

$link_category_description_inputs_string = '';

for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

$link_category_description_inputs_string .= '<br>' . tep_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' <br>' . tep_draw_textarea_field('link_categories_description[' . $languages[$i]['id'] . ']', 'soft', '40', '5', tep_get_link_category_description($cInfo->link_categories_id, $languages[$i]['id']));

}

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_NAME . $link_category_inputs_string);

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_DESCRIPTION . $link_category_description_inputs_string);

$contents[] = array('text' => '<br>' . tep_info_image($cInfo->link_categories_image, $cInfo->link_categories_name) . '<br>' . $cInfo->link_categories_image);

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('link_categories_image'));

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_SORT_ORDER . ' ' . tep_draw_input_field('link_categories_sort_order', $cInfo->link_categories_sort_order, 'size="2"'));

$contents[] = array('text' => '<br>' . TEXT_LINK_CATEGORIES_STATUS . ' ' . tep_draw_radio_field('link_categories_status', 'on', ($cInfo->link_categories_status == '1') ? true : false) . ' ' . TEXT_LINK_CATEGORIES_STATUS_ENABLE . ' ' . tep_draw_radio_field('link_categories_status', 'off', ($cInfo->link_categories_status == '0') ? true : false) . ' ' . TEXT_LINK_CATEGORIES_STATUS_DISABLE);

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'cID=' . $cInfo->link_categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

break;

case 'delete':

$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_LINK_CATEGORY . '</b>');

$contents = array('form' => tep_draw_form('delete_link_categories', FILENAME_LINK_CATEGORIES, 'action=delete_confirm') . tep_draw_hidden_field('link_categories_id', $cInfo->link_categories_id));

$contents[] = array('text' => TEXT_DELETE_LINK_CATEGORIES_INTRO);

$contents[] = array('text' => '<br><b>' . $cInfo->link_categories_name . '</b>');

if ($cInfo->link_categories_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_LINKS, $cInfo->link_categories_count));

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, 'cID=' . $cInfo->link_categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

break;

default:

if (isset($cInfo) && is_object($cInfo)) {

$heading[] = array('text' => '<b>' . $cInfo->link_categories_name . '</b>');

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->link_categories_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_LINK_CATEGORIES, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->link_categories_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

$contents[] = array('text' => '<br>' . tep_info_image($cInfo->link_categories_image, $cInfo->link_categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->link_categories_image);

$contents[] = array('text' => '<br>' . TEXT_INFO_LINK_CATEGORY_DESCRIPTION . ' ' . $cInfo->link_categories_description);

$contents[] = array('text' => '<br>' . TEXT_DATE_LINK_CATEGORY_CREATED . ' ' . tep_date_short($cInfo->link_categories_date_added));

if (tep_not_null($cInfo->link_categories_last_modified)) {

$contents[] = array('text' => '<br>' . TEXT_DATE_LINK_CATEGORY_LAST_MODIFIED . ' ' . tep_date_short($cInfo->link_categories_last_modified));

}

$contents[] = array('text' => '<br>' . TEXT_INFO_LINK_CATEGORY_COUNT . ' ' . $cInfo->link_categories_count);

$contents[] = array('text' => '<br>' . TEXT_INFO_LINK_CATEGORY_SORT_ORDER . ' ' . $cInfo->link_categories_sort_order);

}

break;

}

if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {

echo ' <td width="25%" valign="top">' . "\n";

$box = new box;

echo $box->infoBox($heading, $contents);

echo ' </td>' . "\n";

}

?>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php');

?>

Can anyone see what the problem is?

P.S. I have my store on my root folder, it is not in the catalog folder

Any help would be Appreciated!!

Mark

Mark1 · December 7, 2003

P.S...

I am running this on MS1. :P

I dont know if this makes a difference, but it should be able to be modified to work on MS1.

Thanks for any help!

Mark

VJ · December 7, 2003

I am running this on MS1.

This is actually what makes the difference! The file /admin/includes/classes/upload.php (that contains the class - upload) exists in MS2, but not MS1.

I think you can get around this error, by copying this file (upload.php) from an MS2 package, to your MS1 setup. You'll also have to "include" (or "require") this file. You can do this by adding the following line in admin/links_categories.php:

require(DIR_WS_CLASSES . 'upload.php');

HTH,

VJ

Mark1 · December 8, 2003

Thanks VJ. I will give this a shot and see what happens. If it works, we can hopefully satisfy those OSC'ers out there needing this for MS1.

I will get back to you soon on the status. :D

Thanks again!

Mark

Mark1 · December 9, 2003

Thanks for the help VJ. Your suggestion about the upload file was right on. I ran into another problem...

Fatal error: Call to undefined function: tep_validate_email() in /usr/local/apache_1.3.20/htdocs/host42/www/web/admin/links.php on line 83

This happens while trying to create a link in admin.

Any ideas?

Mark

December 15, 2003

I am ahving a problem with this module - all uploaded, cut and pasted per instructions into MS2.2

At admin - LINKS I get

1146 - Table 'bvhosting.table_links_status' doesn't exist

select links_status_id, links_status_name from TABLE_LINKS_STATUS where language_id = '1'

When I go to MySQL I have

Database bvhosting - table links_status running on xxxxxxx (xxx my SQL hosting addy)

In admin at Links/Categories I get -

1146 - Table 'bvhosting.table_link_categories' doesn't exist

select count(*) as total from TABLE_LINK_CATEGORIES lc left join TABLE_LINK_CATEGORIES_DESCRIPTION lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '1'

When I go to MySQL I have

Database bvhosting - table link_categories running on xxxxxxx (xxx my SQL hosting addy)

In admin at Links/Contact I get -

1146 - Table 'bvhosting.table_links' doesn't exist

select distinct links_contact_email, links_contact_name from TABLE_LINKS order by links_contact_name

When I go to MySQL I have

Database bvhosting - table links running on xxxxxxx (xxx my SQL hosting addy)

I was able to submit a link from the user end, altho my drop down wasn't populated with any categories since I was unable to input anything from the admin side. Nor can I view/validate the submitted link info from admin due to the errors. On a final note, the link submission email was sent out.

Any ideas?

Edited December 15, 2003 by MsGIF

December 16, 2003

This seems to be getting lost in the shuffle.

Anyone have a solution? :(

glenda · December 17, 2003

Hello!

I just installed the latest version and everything seems to work ok except the display of the links when a user clicks on a category.

What happens is the entire page doesn't load. The header loads fine and the left column only loads all of the infoboxes above the information box and it stops there. There is no content, right column, or footer. One must refresh the page numerous times before the content is shown.

http://host127.ipowerweb.com/~durocote/links.php

Any ideas?

Thanks so much for all your hard work VJ!

Andyman53 · December 19, 2003

Anyone have upload.php i need it to correctly install this contribution, Thanks.

VJ · December 21, 2003

I am ahving a problem with this module - all uploaded, cut and pasted per instructions into MS2.2

At admin - LINKS I get
1146 - Table 'bvhosting.table_links_status' doesn't exist

select links_status_id, links_status_name from TABLE_LINKS_STATUS where language_id = '1'
When I go to MySQL I have

Database bvhosting - table links_status running on xxxxxxx (xxx my SQL hosting addy)

In admin at Links/Categories I get -
1146 - Table 'bvhosting.table_link_categories' doesn't exist

select count(*) as total from TABLE_LINK_CATEGORIES lc left join TABLE_LINK_CATEGORIES_DESCRIPTION lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '1'
When I go to MySQL I have

Database bvhosting - table link_categories running on xxxxxxx (xxx my SQL hosting addy)

In admin at Links/Contact I get -
1146 - Table 'bvhosting.table_links' doesn't exist

select distinct links_contact_email, links_contact_name from TABLE_LINKS order by links_contact_name
When I go to MySQL I have

Database bvhosting - table links running on xxxxxxx (xxx my SQL hosting addy)

I was able to submit a link from the user end, altho my drop down wasn't populated with any categories since I was unable to input anything from the admin side. Nor can I view/validate the submitted link info from admin due to the errors. On a final note, the link submission email was sent out.

Any ideas?

Hello,

You have probably failed to update your /catalog/admin/includes/database_tables.php file.

Add this to the end,

// VJ Links Manager v1.00 begin
 define('TABLE_LINK_CATEGORIES', 'link_categories');
 define('TABLE_LINK_CATEGORIES_DESCRIPTION', 'link_categories_description');
 define('TABLE_LINKS', 'links');
 define('TABLE_LINKS_DESCRIPTION', 'links_description');
 define('TABLE_LINKS_TO_LINK_CATEGORIES', 'links_to_link_categories');
 define('TABLE_LINKS_STATUS', 'links_status');
// VJ Links Manager v1.00 end

HTH,

VJ

Andyman53 · December 21, 2003

As stated above i'd need upload.php. Can anyone post it? Please. Thanks.

Andyman53 · December 21, 2003

Nvm...got it from the package.

Andyman53 · December 21, 2003

Different error message....

Fatal error: Call to undefined function: tep_validate_email() in /home/bettywal/public_html/store/admin/links.php on line 83

And i followed the above directions for upload.php.

VJ · December 22, 2003

Different error message....

Fatal error: Call to undefined function: tep_validate_email() in /home/bettywal/public_html/store/admin/links.php on line 83

And i followed the above directions for upload.php.

Hello,

Try copying the file /catalog/includes/functions/validations.php to /admin/includes/functions/ directory, and include the following line somewhere in your /admin/includes/application_top.php:

// Include validation functions (right now only email address)
 require(DIR_WS_FUNCTIONS . 'validations.php');

HTH,

VJ

Andyman53 · December 22, 2003

That fixed the problem about adding links but now viewing them gives me this:

Fatal error: Call to undefined function: tep_output_string() in /home/bettywal/public_html/store/includes/functions/links.php on line 39

VJ · December 22, 2003

That fixed the problem about adding links but now viewing them gives me this:
Fatal error: Call to undefined function: tep_output_string() in /home/bettywal/public_html/store/includes/functions/links.php on line 39

Well, the idea is to look for the missing functions in the newer osc MS2 version, and copy them over to your MS1 setup.

Just give it a shot :).

VJ

JaaMor · December 26, 2003

I am pretty new to installing contributions so please bear with me. I followed the instructions to the letter but I am missing the sql file that I must run in mysql. Does anyone know where I can find the sql file? Thanks.

VJ · December 26, 2003

I am pretty new to installing contributions so please bear with me. I followed the instructions to the letter but I am missing the sql file that I must run in mysql. Does anyone know where I can find the sql file? Thanks.

Actually, there is no seperate sql file. The sql information gets updated when you run the /catalog/links_setup.php script.

HTH,

VJ

JaaMor · December 26, 2003

Ok. So I just need to take the /catalog/links_setup.php and run it through mysql?

Mark1 · December 26, 2003

Janet,

I setup the database for you. I typed this into the browser:

http://jaamor.com/catalog/links_setup.php

Vj was kind enough to program the sql file into a page called links_setup.php. by typing that URL into the browser, the database is updated. I would STRONGLY recommend that you now remove that file as tje instructions state. :ph34r:

Mark

[Contribution] Links Manager for osC v1.00

Recommended Posts

Guest

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

VJ

Guest

Guest

Guest

Mark1

Mark1

VJ

Mark1

Mark1

Guest

Guest

glenda

Andyman53

VJ

Andyman53

Andyman53

Andyman53

VJ

Andyman53

VJ

JaaMor

VJ

JaaMor

Mark1

Join the conversation

Browse

Activity