plume ha scritto: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