linkmanager v.1.10

[rossotiziano]

ciao..ho scaricato la contributions che serve ad inserire in oscommerce..nel box informazioni il collegamneto link...il tutto amministrabile tramite pannello admin.....l'ho installato ma di d aquesto errore se clikko sul collegamento link in home:

1146 - Table 'trenzy_shopnew2.TABLE_LINK_CATEGORIES_DESCRIPTION' doesn't exist

select link_categories_name from TABLE_LINK_CATEGORIES_DESCRIPTION where link_categories_id = '0' and language_id = '4'

[TEP STOP]


cosa vuol dire?...cosa è sbagliato?
Mi potete aiutare?
se volete la contributions per verificare qualche bug mandare messaggio privato
grazie

[plume]

ci sono problemi sulle tabelle ..
sei sicuro di aver fatto bene l'installazione ??

Ciao
Plume

[rossotiziano]

ci sono problemi sulle tabelle ..
sei sicuro di aver fatto bene l'installazione ??

Ciao
Plume

l'istruzioni sono queste:

INSTALLATION
------------

Step 1: Copy all the files listed in the "file additions" section to their respective directories.

Step 2: Make changes in the files listed in the "file modifications" section.

Step 3: Fire up your browser and run /catalog/links_setup.php, to update your database.

Step 4: Delete /catalog/links_setup.php (THIS IS IMPORTANT, as your data can be overwritten, if the script is run again).

Step 5: Admin -> Configuration -> Links, Admin -> Links Manager to get started.

----------------------------------------------------------------
FILE ADDITIONS
----------------------------------------------------------------

- /catalog/links.php, links_submit.php, links_submit_success.php, popup_links_help.php
- /catalog/includes/languages/english/links.php, links_submit.php, links_submit_success.php
- /catalog/includes/languages/english/images/buttons/button_submit_link.gif
- /catalog/includes/functions/links.php
- /catalog/includes/modules/link_listing.php
- /catalog/includes/modules/link_search.php
- /catalog/links_setup.php

NOTE: An optional file named link_listing.php_vertical_listing is in the modules
directory. If you want a vertical listing of links, instead of the traditional
table, rename it and use it instead.

- /catalog/admin/links.php, link_categories.php, links_contact.php
- /catalog/admin/includes/languages/english/links.php, link_categories.php, links_contact.php
- /catalog/admin/includes/languages/english/images/buttons/button_new_link.gif
- /catalog/admin/includes/languages/english/images/buttons/button_check_link.gif
- /catalog/admin/includes/languages/english/images/buttons/button_check_links.gif
- /catalog/admin/includes/languages/english/images/buttons/button_continue.gif
- /catalog/admin/includes/functions/links.php
- /catalog/admin/includes/boxes/links.php
- /catalog/admin/images/mark_check.jpg
- /catalog/admin/images/mark_x.jpg

----------------------------------------------------------------
FILE MODIFICATIONS
----------------------------------------------------------------

------------------------------------
/catalog/stylesheet.css
------------------------------------

add this to the end,

/* VJ Links Manager v1.00 begin */
TABLE.linkListing {
border: 1px;
border-style: solid;
border-color: #b6b7cb;
border-spacing: 1px;
}

.linkListing-heading {
font-family: Verdana, Arial, sans-serif;
font-size: 10px;
font-weight: bold;
background: #b6b7cb;
color: #FFFFFF;
text-align: center;
}

TD.linkListing-data {
border-right: 1px solid #b6b7cb;
border-bottom: 1px solid #b6b7cb;
padding: 4px;
font-family: Verdana, Arial, sans-serif;
font-size: 10px;
}

TR.linkListing-odd {
background: #f8f8f9;
}

TR.linkListing-even {
background: #F5F5F5;
}
/* VJ Links Manager v1.00 end */


------------------------------------
/catalog/redirect.php
------------------------------------

after this, (around line 30)

case 'manufacturer':
if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) {
$manufacturer_query = tep_db_query("select manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'");
if (tep_db_num_rows($manufacturer_query)) {
// url exists in selected language
$manufacturer = tep_db_fetch_array($manufacturer_query);

if (tep_not_null($manufacturer['manufacturers_url'])) {
tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'");

tep_redirect($manufacturer['manufacturers_url']);
}
} else {
// no url exists for the selected language, lets use the default language then
$manufacturer_query = tep_db_query("select mi.languages_id, mi.manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " mi, " . TABLE_LANGUAGES . " l where mi.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and mi.languages_id = l.languages_id and l.code = '" . DEFAULT_LANGUAGE . "'");
if (tep_db_num_rows($manufacturer_query)) {
$manufacturer = tep_db_fetch_array($manufacturer_query);

if (tep_not_null($manufacturer['manufacturers_url'])) {
tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$manufacturer['languages_id'] . "'");

tep_redirect($manufacturer['manufacturers_url']);
}
}
}
}
break;


add,

// VJ Links Manager v1.00 begin
case 'links':
require(DIR_WS_FUNCTIONS . 'links.php');

$links_query = tep_db_query("select links_url from " . TABLE_LINKS . " where links_id = '" . (int)$HTTP_GET_VARS['goto'] . "'");
if (tep_db_num_rows($links_query)) {
$link = tep_db_fetch_array($links_query);
tep_update_links_click_count($HTTP_GET_VARS['goto']);

tep_redirect($link['links_url']);
}
break;
// VJ Links Manager v1.00 end


------------------------------------
/catalog/includes/filenames.php
------------------------------------

add this to the end,

// VJ Links Manager v1.00 begin
define('FILENAME_LINKS', 'links.php');
define('FILENAME_LINKS_SUBMIT', 'links_submit.php');
define('FILENAME_LINKS_SUBMIT_SUCCESS', 'links_submit_success.php');
define('FILENAME_LINK_LISTING', 'link_listing.php');
define('FILENAME_LINK_SEARCH', 'link_search.php');
define('FILENAME_POPUP_LINKS_HELP', 'popup_links_help.php');
// VJ Links Manager v1.00 end


------------------------------------
/catalog/includes/database_tables.php
------------------------------------

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');
// VJ Links Manager v1.00 end


------------------------------------
/catalog/includes/languages/english.php
------------------------------------

add this code (immediately after other BOX_INFORMATION_* definitions),

// VJ Links Manager v1.00 begin
define('BOX_INFORMATION_LINKS', 'Links');
// VJ Links Manager v1.00 end


------------------------------------
/catalog/includes/boxes/information.php
------------------------------------

replace this code,

$info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a>');

with,

$info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_LINKS . '</a><br>' . // VJ Links Manager v1.00 added
'<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a>');



NOTE: The above is just an example of adding it to the information box. You can add a link to the links module almost anywhere by placing this code,

'<a href="' . tep_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_LINKS . '</a>'


------------------------------------
/catalog/admin/includes/filenames.php
------------------------------------

add this to the end,

// VJ Links Manager v1.00 begin
define('FILENAME_LINKS', 'links.php');
define('FILENAME_LINK_CATEGORIES', 'link_categories.php');
define('FILENAME_LINKS_CONTACT', 'links_contact.php');
// VJ Links Manager v1.00 end


------------------------------------
/catalog/admin/includes/database_tables.php
------------------------------------

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


------------------------------------
/catalog/admin/includes/column_left.php
------------------------------------

add this to the end,

// VJ Links Manager v1.00 begin
require(DIR_WS_BOXES . 'links.php');
// VJ Links Manager v1.00 end


------------------------------------
/catalog/admin/includes/languages/english.php
------------------------------------

add this code (immediately after other BOX_* definitions),

// VJ Links Manager v1.00 begin
// links manager box text in includes/boxes/links.php
define('BOX_HEADING_LINKS', 'Links Manager');
define('BOX_LINKS_LINKS', 'Links');
define('BOX_LINKS_LINK_CATEGORIES', 'Link Categories');
define('BOX_LINKS_LINKS_CONTACT', 'Links Contact');
// VJ Links Manager v1.00 end