Contribution Tracker

for osCommerce Online Merchant v2.2

View Files

Updated by surfalot on 24th July 2014

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.

Files

Uploaded by surfalot

Contribution Tracker for osCommerce v2.2ms2 (all releases) After working with it for a while, I found some changes and conveniences that made sense to me and my clients including some input database handling rewrites for safety and security. Hope everyone likes this update. See the changelog for full details. Some highlights: + fulfilled the wish list item of a more friendly date display. + Added support for retrieving support topic IDs from the new style forum links + You may now simply enter a topic ID into the support link field and the code will build the full link. + added optional date columns to the main page list display. Simply check the box of the date you want to show (and/or sort by), and voila! + added &view=getlastpost to the support links to save some time by jumping to the end of the support topics + added #tabs-hist to contribution link to jump directly to the list of contributions on its page. + Added osCommerce 2.2ms2's date picker to date input fields. Support thread: http://forums.oscommerce.com/index.php?showtopic=247157 this is a full package for osCommerce v2.2ms2 (all releases) Contribution Tracker v1.8.0 for osCommerce v2.3.x can be found here: http://addons.oscommerce.com/info/9106

Uploaded by SteveDallas

Contribution Tracker for osCommerce 2.2 v1.7.19 This version incorporates some fixes to handle a broken RSS feed. It also incorporates the German language translation from amaische. osC 2.3.x users should use http://addons.oscommerce.com/info/9030 , which incorporates the v2.3 fixes by amaische and an installation guide specific to v2.3. Support thread: http://forums.oscommerce.com/index.php?showtopic=247157

Uploaded by amaische

This package is based on version 1.7.18. The only difference is, that the modification for osc2.3.1 and the translation in the german language file has been done. ----- only delta

Uploaded by SteveDallas

Version 1.7.18 Changes to catalog/contrib_tracker.php: + Fixes bug in notification that occurs if contribution name is not unique + No longer loads application_top.php + Produces no HTML output when run from shell (usually via crontab) Full package upload Support link: http://forums.oscommerce.com/index.php?showtopic=247157

Uploaded by SteveDallas

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

Uploaded by eFFeKt

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.

Uploaded by SteveDallas

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

Uploaded by SteveDallas

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

Uploaded by TheExterminator

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

Uploaded by lildog

+ 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

Uploaded by SteveDallas

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

Uploaded by lildog

+ realigned buttons in insert contribution page

Uploaded by lildog

My sql needed quotes around 'LAST_CONFIG_CHECK' from version 1.7.8. Complete Package + Update Guides

Uploaded by lildog

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

Uploaded by SteveDallas

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)

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

+ 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

Uploaded by lildog

+ 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

Uploaded by lildog

+ 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

Uploaded by lildog

Code was missing in admin/contrib tracker.php Full Package + update guides

Uploaded by carryG

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.

Uploaded by lildog

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

Uploaded by carryG

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

Uploaded by lildog

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

Uploaded by lildog

fixed some row over and mouse over routines in admin full package + update guide

Uploaded by lildog

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

Uploaded by TheExterminator

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.

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by ♥geoffreywalton

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

Uploaded by ♥geoffreywalton

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.

Uploaded by lildog

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.

Uploaded by lildog

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

Uploaded by lildog

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.

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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.

Uploaded by lildog

Minor Update - Version 1.5.5 had an incorrect catalog/contrib_tracker.php file included. - included search bug fix.

Uploaded by lildog

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>

Uploaded by lildog

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.

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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>

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

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

Uploaded by lildog

- 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

Uploaded by lildog

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.

Uploaded by lildog

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

Uploaded by TheExterminator

Translate To Danish

Uploaded by lildog

Full Package with screenshots added

Uploaded by lildog

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.