Jump to content
Sign in to follow this  
VJ

[Contribution] Links Manager for osC v1.00

Recommended Posts

File reads:

 

// Define the project version

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

 

 

Sooooo, what next?

 

Thanks!


"Bert" with an Ro in front - just sitting here "out of order"...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


Cheers,

Simon

Share this post


Link to post
Share on other sites

there should only be 1 _/

Shoudn't there?

 

 

<!-- information_eof //-->

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><form name="submit_link" action="https://websvr2.mn1.fasturl.net/ssl2/thedvdchart//catalog/links_submit.php?osCsid=49a7eb2943bd3789defe390acd72102d" method="post" onSubmit="return check_form(submit_link);"><input type="hidden" name="action" value="process"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

 

i've got a proberlem with the same contribute

Share this post


Link to post
Share on other sites

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

 

Copyright © 2003 osCommerce

 

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

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

<script language="javascript" src="includes/general.js"></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">

<!-- header //-->

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

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="2" cellpadding="2">

<tr>

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

<!-- left_navigation //-->

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

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr><?php echo tep_draw_form('search', FILENAME_LINK_CATEGORIES, '', 'get'); ?>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('search'); ?></td>

</form></tr>

</table></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NAME; ?></td>

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>

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

}

?>

<td class="dataTableContent"><?php echo $link_categories['link_categories_name']; ?></td>

<td class="dataTableContent" align="right">

<?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>

<td colspan="4"><table border="0" width="100%" cellspacing="0" cellpadding="2">

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

<!-- body_text_eof //-->

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

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

<!-- footer_eof //-->

<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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by MsGIF

Share this post


Link to post
Share on other sites

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!


Mary

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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.


We will not regret what we have done. We will regret what we didn't do.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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


We will not regret what we have done. We will regret what we didn't do.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×