Community Add-Ons

Version 1.7.17
Revised installation instructions - rsscache directory no longer used
+ Rewrote XML parser - no longer uses rdf_class.php
+ Rewrote RDF file handling code - no longer caches feed in contrib_rss.php, works with PHP5 as if cURL is available
+ Revised email notification now only reports once per update, not every time the cron job is executed
+ three files no longer needed:
/catalog/includes/classes/rdf_file.php
/catalog/includes/functions/contrib_tracker.php
/admin/includes/classes/rdf_file.php

Full package upload

Support link: http://forums.oscommerce.com/index.php?showtopic=247157

Changes made in rdf_class.php and installation instructions

+ Fixed the Warning-Message by editing Line 344 in rdf_class.php
+ better sort ordered to the Installinstructions.

Version 1.7.15
Changes to catalog/contrib_tracker.php:
+ Fixed detection/creation of local cache file for servers where DIR_FS_CATALOG != DIR_WS_CATALOG
+ Made the HTML output compliant with the HTML 4.01 DTD
+ Cleaned up the email notification option.

Full package upload

Support link: http://forums.oscommerce.com/index.php?showtopic=247157

Version 1.7.14
+ Several bug fixes in insert routine for correct processing of non-osCommerce support site contributions
+ date added can now be edited
+ clears sID on page change
+ Fixed bug in function old_to_new_url() that caused a crash
+ Created new 'check all' buttons in both English and Danish
+ Includes Danish language file contributed by TheExterminator

Full package upload

Support link: http://forums.oscommerce.com/index.php?showtopic=247157

+ Have make a danish translate
+ have add a danish check_all button

+ When adding a new contrib date added and last official update were getting mixed up
+ changed a couple of variables so they are more obvious

+ Quick Add now searches for a support topic and inserts it into the database
+ Insert now adds support topic if user didn't provide one and one exists in the contribution description
+ Quick Add and Insert no longer add duplicate records
+ toggleDivBlock() now uses the code from osC 2.2RC2a
+ Extensive use of tep_get_all_get_params() to preserve parameters - no longer loses sort order on updates
+ Fixed two minor HTML errors that occurred with empty searches and an empty contrib_tracker table
+ Clicking anywhere on a row in the table of contributions will select it
+ Fixed the operation of the manual check button (manualcheckall worked; manualcheck didn't)

+ realigned buttons in insert contribution page

My sql needed quotes around 'LAST_CONFIG_CHECK' from version 1.7.8.

Complete Package + Update Guides

+ Fixed Insert so it works with contributions with apostrophes in their titles

Version 1.7.8
+ Changed config update to use key LAST_CONFIG_CHECK instead of raw configuration_id, which is installation dependent
Removed old step 9 from installation instructions and moved succeeding steps up.
+ Fixed Quick Add so it works with contributions with apostrophes in their titles
+ Rebuilt all tables in body text to ensure correct HTML structure under all conditions
+ Re-created missing Javascript function toggleDivBlk() to make "info" links work in editor
+ Modified logic to suppress search, quick add, and last update boxes in edit and preview modes
+ Escaped a ton of ampersands to "&" for HTML 4.01 Transitional DTD conformance
+ (Note that some modes still generate non-conforming HTML due to minor bugs in osC functions tep_draw_form() and tep_draw_textarea_field() )
+ Cleaned up some text in the English language file

Full package upload (Danish language file will need minor updates)

THANK YOU to mmph for the following bug reports and fixes.
+ catalog/includes/functions/contrib_tracker.php and the catalog/admin/includes/functions/contrib_tracker.php files need to be swapped with each other.
+ fixed the sql file
+ clarified step 9 in install document

thanks to mmph for pointing this out:
+versions 1.7.4 and 1.7.5 used the wrong functions file in admin


Full Package + update guides

+ fixed a problem when editing a contrib, the created date and last updated date was not filling in.
Simple update


Full Package + update guides

+ added a check all contrib pages for updates button. This may take a couple of minutes it is far better to just let contrib tracker monitor the rss feed. But I have a test shop on a local server that doesn't always get updated regularly, thus my contribs don't show when they needed to be updated. Maybe if your server goes down or you move your shop and it is down for awhile, you would need this. I recommend you use this sparingly to avoid bogging the oscommerce server.
+ rename added .txt extension to history, install, and update guides names
+ renamed some update guides to sort correctly


Full Package + update guides

+ FIXED: when editing a contrib, the support url is lost.
+ FIXED: when clicking the contribs name to go to it's page the contrib tracker page wen tto the edit page

+ fixed some some code that was not correctly handling dates when checking for updates when adding a contrib
+ fixed: when editing last updated and added dates were missing

Code was missing in admin/contrib tracker.php

Full Package + update guides

If date status change is now defunct, it should be removed from the sql command:

INSERT INTO contrib_tracker (contr_id, contrib_osc_id, contrib_name,contrib_link, config_comments, status, date_status_change, note_created, contr_last_modified, last_update,contrib_vers) VALUES ('','4815','Contribution Tracker Now Installed','http://addons.oscommerce.com/info/4815', 'Congratulations! Contribution Tracker now installed! You may now delete this Contribution or use it to play around with and get the feel of your new osC contribution.', 1, '0000-00-00 00:00:00', '2005-04-15 12:55:45', '2005-04-15 12:55:45', '2005-04-15','1.6.6e');

Full package with correction.

I fixed the date check boxes and cleaned up some code. date_status_change is now defunct, it is not used by anything anymore

upload admin/contrib_tracker.php

if you added carry_g's fix:
you need to remove `date_status_change` from the contrib tracker table


Full package + update guides

One instruction missing in sql left out the date_status_change, added to sql file, rezipped FULL PACKAGE included. Still has issue reading Who's Online though, where 's throws error.

Here is command to issue if you already installed files below - without this you cannot click Green/Red lights manually.

ALTER TABLE `contrib_tracker` ADD `date_status_change` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `config_comments` ;

I saw another contrib that tracks contributions and liked some of the features. It checks the actual page that the contrib is on by id #. For me I thought that is alot of pages to always be checking, but once in awhile and when you add a contrib it seemed great. You now add the contrib by it's id# and the EXACT title will be retrieved as well as the latest versions date. I also added a new button for a manual update which connects to the pages and checks for updates, in case your shop was down or your server or whatever reason the rss feed was unreachable.


+ fixed a potential bug when entering dates
+ added a today checkbox to date added to store
+ cleaned up some code
+ added success and error messages
+ added a quick add box
+ when updating a contrib the old add-ons URL will be automatically be changed to the new add-ons URL
+ changed some variables that were not clear as to what they were(mostly date related) for easier future identification
+added a check to manually update a contrib from it's oscommerce add ons page. This maybe useful if your server goes down you move shop locations, don't have a way to cron your contribs, the rss feed is probably the better way to go but if you need it it is there. I am not sure but this should probably be used sparingly as it probably eats up osc's bandwidth as where the rss feed is meant for being constantly checked.
+ deleted a useless database table

FULL PACKAGE + update guide

fixed some row over and mouse over routines in admin


full package + update guide

-- enlarged the version number database space...it used to allow only 5 characters now allows 7 characters

-- merged the 1.6.6c changed into the 1.6.6d version. 1.6.6c I think was based on an old version.

Have make some small update:
Make the status and info icon to language.
Have update the admin/languages/danish and english file.
For update, only copy the admin/contrib_tracker.php and you danish or english language file.

Added missing step to instructions, added update guides. Based on Contribution Tracker 1.6.6a.

Full Package.

This step has always been missing: I think everyone will need to do this step:

in catalog/admin/contrib_tracker.php

****FIND:
tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . $HTTP_POST_VARS['lastcheck'] . "', last_modified = now() where configuration_id = PUT YOUR CONFIG ID HERE");

REPLACE:
PUT YOUR CONFIG ID HERE with THE CONFIGURATION ID OF the column 'Last Contrib Check' of the confirguration table from PHPMyAdmin

Email can now be sent only when a new file has been added for a contribution.

Full package

Removed reference to get_http_headers as per pbor1234

Added Version no column on admin page.

Showed no of contributons to update in audit email

Corrected a few spelink mistoikes.

Changed url in sql to http://addons.oscommerce.com/info/4815

Updated the installation instuctions.

Fixed New URL's and made future URL's easier to replace.
If the XML cannot be parsed OR opened an email will be sent to the store, letting them know Contribution Tracker is broken.

This minor upgrade fixes:
errors reported when connecting to the rss feed of contribs.
error generated when the file catalog/rsscache/contrib_rss.html doesn't exist

This minor upgrade fixes links to the new add on server. The links in contrib tracker in admin control panel will now take you to whatever link is added, valid link or not.

-- bug fix an operator.
-- add checkbox to edit/add page to insert date for Last date integrated into store

Complete package.

A few fixes that add php 5 and RC1 compatibility

- sashaben fix: php 5 compatibility.
- fixed a query that failed with RC1
- Fixed a path issue

Major update.

This version uses uses fopen if curl lib is not available. I also fixed a couple of problems with the links in the admin part. if a link was empty or not a url errors were generated. Moved functions to fuctions file. When clicking a contrib name in admin it now opens anew window to load OSCommerce page for that contribution.

Minor Update

- Version 1.5.5 had an incorrect catalog/contrib_tracker.php file included.

- included search bug fix.

This bug fix fixes the link to the edit page of a contrib when you have done a search.


in admin/contrib_tracker.php:


1. ***FIND***
if ($HTTP_GET_VARS['action'] != 'new' || $HTTP_GET_VARS['action'] != 'edit') {
if (htmlspecialchars(StripSlashes(@$HTTP_GET_VARS["search"])) == '')
{$searchquery = 'enter search query'; } else { $searchquery = htmlspecialchars(StripSlashes(@$HTTP_GET_VARS["search"])) ;}
?>


***CHANGE TO***

if ($HTTP_GET_VARS['action'] != 'new' || $HTTP_GET_VARS['action'] != 'edit') {
if (htmlspecialchars(StripSlashes(@$HTTP_GET_VARS["search"])) == '')
{$searchquery = ''; } else { $searchquery = htmlspecialchars(StripSlashes(@$HTTP_GET_VARS["search"])) ;}
?>


2. ***FIND***
if ( (is_object($sInfo)) && ($admin_quer['contr_id'] == $sInfo->contr_id)) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" onclick="document.location.href='' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->contr_id . '&sort=' . $HTTP_GET_VARS['sort'] . '&action=readonly') . ''">' . "n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $admin_quer['contr_id']) . '&sort=' . $HTTP_GET_VARS['sort'] . ''">' . "n"; }


***CHANGE TO***

if ( (is_object($sInfo)) && ($admin_quer['contr_id'] == $sInfo->contr_id)) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" onclick="document.location.href='' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'search=' . $HTTP_GET_VARS['search'] . '&sID=' . $sInfo->contr_id . '&sort=' . $HTTP_GET_VARS['sort'] . '&action=readonly') . ''">' . "n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'search=' . $HTTP_GET_VARS['search'] . '&sID=' . $admin_quer['contr_id']) . '&sort=' . $HTTP_GET_VARS['sort'] . ''">' . "n"; }


3.***FIND***
<td class="dataTableContent" align="right"><?php if ( (is_object($sInfo)) && ($admin_quer['contr_id'] == $sInfo->contr_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $admin_quer['contr_id']) . '&sort=' . $HTTP_GET_VARS['sort'] . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', 'Preview') . '</a>'; } ?>&nbsp;</td>

***CHANGE TO***

<td class="dataTableContent" align="right">
<?php
if (htmlspecialchars(StripSlashes(@$HTTP_GET_VARS["search"])) == ''){
if ( (is_object($sInfo)) && ($admin_quer['contr_id'] == $sInfo->contr_id) ) {
echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', '');
}else{
echo '<a href="' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $admin_quer['contr_id']) . '&sort=' . $HTTP_GET_VARS['sort'] . '">' .tep_image(DIR_WS_IMAGES . 'icon_info.gif', 'Preview') . '</a>';
}
}else{
if ( (is_object($sInfo)) && ($admin_quer['contr_id'] == $sInfo->contr_id) ) {
echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', '');
} else {
echo '<a href="' . tep_href_link(FILENAME_CONTRIB_TRACKER, 'search=' . $HTTP_GET_VARS['search'] . '&sID=' . $admin_quer['contr_id']) . '&sort=' . $HTTP_GET_VARS['sort'] . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', 'Preview') . '</a>';
}
}
?>
</td>

I have replaced the fopen with a curl function. Apparently fopen is a security risk. A few minor corrections to install.This is a complete package. if you are updating from an earlier version, see the upgrade files.

This fixes a problem that generates an error when Contribution tracker can not reach the OSC feed, the errors unnessessarily fill the scripts log.

in catalog/includes/classes/rdf_class.php
AND
in catalog/admin/includes/classes/rdf_class.php

FIND:
if (!($fp = fopen($this->FileName, "r"))) {

REPLACE WITH:
if (!($fp = @fopen($this->FileName, "r"))) {

This minor fix fixes a problem where any contrib with a '&' does not get parsed correctly and therefore does not update correctly.


1. Manually check to see if any contribs with '&' in the title need to be updated.


2. In admin/contrib_tacker.php

change:
$channel = new rdfFile("http://www.oscommerce.com/oscommerce_contributions.rdf");
$channel->parse(true);

to:
$channel = new rdfFile("http://www.oscommerce.com/oscommerce_contributions.rdf");
$channel->parse(false);

1. Fixed a problem when updating a contrib status from the edit page. It was not updating the last integrated date.



STEPS:

1.in catalog/admin/contrib_tracker.php
**** CHANGE****
case 'update':
tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set contr_last_modified = now(), status = '" . $status . "',contrib_name = '" . $contrib_name_new . "', contrib_link = '" . $contrib_link_new . "', config_comments = '" . $config_comments . "', last_update = '" . $last_update . "', contrib_vers= '" . $contrib_vers . "' where contr_id = '" . $HTTP_POST_VARS['contr_id'] . "'");
tep_redirect(tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $contr_id . '&sort=' . $HTTP_GET_VARS['sort']));
break;
****TO:****
case 'update':
if ($old_status!='1' && $status=='1'){
$current_status='1';
}else{
$current_status= $status;
}
tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set contr_last_modified = now(), status = '" . $current_status . "',contrib_name = '" . $contrib_name_new . "', contrib_link = '" . $contrib_link_new . "', config_comments = '" . $config_comments . "', last_update = '" . $last_update . "', contrib_vers= '" . $contrib_vers . "' where contr_id = '" . $HTTP_POST_VARS['contr_id'] . "'");
tep_redirect(tep_href_link(FILENAME_CONTRIB_TRACKER, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $contr_id . '&sort=' . $HTTP_GET_VARS['sort']));
break;


****CHANGE: ****
<td class="dataTableContent"><?php echo tep_draw_input_field('status', $sInfo->status, 'size=2 maxlength=1'); ?> &nbsp;&nbsp;&nbsp;
0 = <?php echo tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', 'New Update Exists', 10, 10); ?> New Update Exists&nbsp;&nbsp;&nbsp;
1 = <?php echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', 'No New Update', 10, 10); ?> No New Update&nbsp;&nbsp;&nbsp;
2 = No status&nbsp;&nbsp;&nbsp;
****TO:****
<td class="dataTableContent"><?php echo tep_draw_input_field('status', $sInfo->status, 'size=2 maxlength=1'); ?> &nbsp;&nbsp;&nbsp;
0 = <?php echo tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', 'New Update Exists', 10, 10); ?> New Update Exists&nbsp;&nbsp;&nbsp;
1 = <?php echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', 'No New Update', 10, 10); ?> No New Update&nbsp;&nbsp;&nbsp;
2 = No status&nbsp;&nbsp;&nbsp;
<td><?php echo tep_draw_hidden_field('old_status', $sInfo->status); ?></td>

COMPLETE PACKAGE

in catalog/admin/contrib_tracker.php

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

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

--added a field to store the last time you actually went to the contribution site, to remember when you last looked for new and cool contribs to add in.
-- removed the code that directed you to the preview page when clicking the info icon in the main page

COMPLETE PACKAGE

just renamed the update instructions so they do not generate a naming error. NO code or fuctionality has been changed or added.

Small typo corrected that prevented version number being entered into database when inserting a contrib name.

line 84 in admin/contrib_tracker.php
From:
tep_db_query("insert into " . TABLE_CONTRIB_TRACKER . " (contr_id, contrib_name, contrib_link, config_comments, note_created, status, last_update, contrib_vers) values ('','" . $HTTP_POST_VARS['contrib_name_new'] . "','" . $HTTP_POST_VARS['contrib_link_new'] . "','" . $HTTP_POST_VARS['config_comments'] . "', '" . $atstamp . "', '1', '" . $utstamp . "', '" . $HTTP_POST_VARS['config_vers'] . "' )");


To:
tep_db_query("insert into " . TABLE_CONTRIB_TRACKER . " (contr_id, contrib_name, contrib_link, config_comments, note_created, status, last_update, contrib_vers) values ('','" . $HTTP_POST_VARS['contrib_name_new'] . "','" . $HTTP_POST_VARS['contrib_link_new'] . "','" . $HTTP_POST_VARS['config_comments'] . "', '" . $atstamp . "', '1', '" . $utstamp . "', '" . $HTTP_POST_VARS['contrib_vers'] . "' )");

small update. Fixes a status problem. The only change is to catalog/admin/contrib_tracker.php

- added a field for contrib version numbers
- show comments in right column on main page
- in right column made tags bold for easier viewing

FULL PACKAGE

This update fixes the time problem. The times were off by -5 hours. Also adds a fix for contribution titles that have quotes in them. Tidied up code a bit and added comments to code.

Complete package.
Added: Support thread: http://forums.oscommerce.com/index.php?showtopic=247157
Added Danish language file
Minor updates.

Translate To Danish

Full Package with screenshots added

I forget to check the contributions site everyday even every week or month. When I do remember to checkback it takes forever to update all my contribs. Contribution tracker checks the oscommerce feed and notes what contributions have been updated so you can easily see what contribution needs to be updated.