osCommerce Community Support Forums

lildog

Jan 21 2007, 09:34 PM

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.

found at:http://www.oscommerce.com/community/contributions,4815

TheExterminator

Jan 22 2007, 07:27 PM

I Love You Contri Mate, I Have Over 60 Contri On My DemoShop, So I Love This Contri, And Made The Danish Translate.

Thanks

sonixtwo

Feb 8 2007, 07:34 PM

Great contribution. This has helped me out tremendously. Wen I loaded up contrib_tracker.php today, I recieved an error. Here is what I got:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'images basic' and last_update < '2007-02-08 08:46:52'' at line 1

UPDATE contrib_tracker SET status ='0', contr_last_modified = '2007-02-08 08:46:52' , date_status_change = now() where contrib_name = 'Infinit'images basic' and last_update < '2007-02-08 08:46:52'

Checking out todays new contributions on http://www.oscommerce.com/community/contributions, there is one called

Infinit'images basic

I believe the single quote in the title of this contribution is causing the sql error. Can anyone hl help with the solution to this?

Thanks

-Mike

Leak-Proof

Feb 8 2007, 09:14 PM

QUOTE (sonixtwo @ Feb 8 2007, 02:34 PM)

Great contribution. This has helped me out tremendously. Wen I loaded up contrib_tracker.php today, I recieved an error. Here is what I got:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'images basic' and last_update < '2007-02-08 08:46:52'' at line 1

UPDATE contrib_tracker SET status ='0', contr_last_modified = '2007-02-08 08:46:52' , date_status_change = now() where contrib_name = 'Infinit'images basic' and last_update < '2007-02-08 08:46:52'

Checking out todays new contributions on http://www.oscommerce.com/community/contributions, there is one called

Infinit'images basic

I believe the single quote in the title of this contribution is causing the sql error. Can anyone hl help with the solution to this?

Thanks

-Mike

I am having a similar error. It's been driving me nuts trying to find the cause.

What if we put another update after the problem contribution. Will the Contribution tracker overlook it?

Leak-Proof

Feb 8 2007, 09:54 PM

QUOTE (Leak-Proof @ Feb 8 2007, 04:14 PM)

What if we put another update after the problem contribution. Will the Contribution tracker overlook it?

I guess that won't work because the feed coming in is the name of the newest contributions.

The problem will likely pass when that contribution gets bumped off the top ten list. It is sure to come around again when it gets an update.

Is there a bit of code to strip out the quote in the name that we can add to the Contribution Tracker code?

West One Hosting

Feb 9 2007, 09:39 AM

Hi

see

http://forums.oscommerce.com/index.php?showtopic=250124

can we all add to this so it may get don??

simon

Leak-Proof

Feb 9 2007, 02:16 PM

QUOTE (West One Hosting @ Feb 9 2007, 04:39 AM)

Hi

see

http://forums.oscommerce.com/index.php?showtopic=250124

can we all add to this so it may get don??

simon

Has anyone emailed the author of the contribution?

sonixtwo

Feb 9 2007, 03:03 PM

QUOTE (Leak-Proof @ Feb 8 2007, 04:54 PM)

I guess that won't work because the feed coming in is the name of the newest contributions.

The problem will likely pass when that contribution gets bumped off the top ten list. It is sure to come around again when it gets an update.

Is there a bit of code to strip out the quote in the name that we can add to the Contribution Tracker code?

I found some info here: http://www.kofler.cc/forum/forumthread.php?rootID=3184

Using the str_replace function (http://us3.php.net/str_replace), i changed line 63 in admin/contrib_tracker.php to

CODE

tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . str_replace("'","\'", $thetitle) . "' and last_update < '" . $pubtimestamp . "'");

It just replaces ' with \' in the contribution title. The problem I could forsee would be any contributions that have " in their name won't be entered correctly.

It seems to work, but t would be great if someone that actually knows php could verify this is ok.

Thanks

-Mike

West One Hosting

Feb 9 2007, 06:49 PM

Thanks

Mike

this worked for me.

simon

Leak-Proof

Feb 9 2007, 08:18 PM

QUOTE (sonixtwo @ Feb 9 2007, 10:03 AM)

I found some info here: http://www.kofler.cc/forum/forumthread.php?rootID=3184

Using the str_replace function (http://us3.php.net/str_replace), i changed line 63 in admin/contrib_tracker.php to

CODE

tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . str_replace("'","\'", $thetitle) . "' and last_update < '" . $pubtimestamp . "'");

It just replaces ' with \' in the contribution title. The problem I could forsee would be any contributions that have " in their name won't be entered correctly.

It seems to work, but t would be great if someone that actually knows php could verify this is ok.

Thanks

-Mike

Thanks for your efforts. I will try your suggestions and post the results. I sent the author an email so maybe there might be an update at somepoint; I'll keep watching the Contribution Tracker to see if there is one...

RJ

Leak-Proof

Feb 9 2007, 08:25 PM

QUOTE (Leak-Proof @ Feb 9 2007, 03:18 PM)

Thanks for your efforts. I will try your suggestions and post the results. I sent the author an email so maybe there might be an update at somepoint; I'll keep watching the Contribution Tracker to see if there is one...

RJ

Ka Chow, it's back up...

...until the " comes along.

lildog

Feb 12 2007, 03:17 PM

Hello everyone. I had no idea people were even using this contrib. I thought it would be huge! It is an ongoing problem for me to update my contribs. I have 6 months to go through and install. OOPS!

Anyhow, the string replace should work fine. I am no expert in php but getting better everyday. I will patch it in and also acccount for the inevitable " too.

Thanks all for using my contrib.

if anyone has any info on comparing the dates in the sql database and the oscommerce rss feed leet me know. I believe the calculations are about twelve hours off. I guess also depending on timezone.

lildog

lildog

Feb 26 2007, 06:24 PM

Here is a more comprehensive fix for the error with names that include ' and ". I appologize for taking sooo long to post this. I am going to add an update to the contrib page later,

in admin/contrib_tracker.php:
before
// get database contributions with the name of the current item and last modded in store is less that the pubdate
tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . $thetitle . "' and last_update < '" . $pubtimestamp . "'");
added:
// add backslashes to characters that need escaping
$thetitle=addslashes($thetitle);

26Feb7- in catalog/contrib_tracker.php:
before
// get database contributions with the name of the current item and last modded in store is less that the pubdate
tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . $thetitle . "' and last_update < '" . $pubtimestamp . "'");

add:
// add backslashes to characters that need escaping
$thetitle=addslashes($thetitle);

lildog

Feb 27 2007, 05:10 PM

I have uploaded an update that addresses the time issue and the quote issue.

lildog

TheExterminator

Feb 27 2007, 09:23 PM

Hey lildog
You new update is not working, you can not set status in the admin when you have update at contri.

cDGo IT Consultancy

Feb 27 2007, 09:56 PM

Hi lildog,

Will it work for older contributions to?
I installed the contribution and added a contribution, I'm using, which I know has a newer version.
But yr contribution, doesn't seem to "see it".
Or does it only recognize new aditions when there are updated afteryr contribution is installed, and the contribution is scheduled to run each day with a cron job?

A bit more information how it works would be great.....

wvcrafted

Feb 28 2007, 12:16 PM

Using your version 1.2 which is great. I downloaded the updates and when extracting them my compression program is telling me file contains corrupt or illegal file names. It's all the things having to do with upgrades. It extracts the new files and directions, but not the upgrade stuff you put in. I don't think it likes the 1->2 stuff in the file or folder names.

Going to try and use my examdiff pro and see if I can figure out what changed between each of them.

Thanks again for this great contrib!

lildog

Feb 28 2007, 05:54 PM

I think the problem is I am on a mac I will rename and upload. Please let me know if it works.

cDGo IT Consultancy:
As far as not recognizing old contribs, it recognizes anything that comes throught the rss feed, which is a couple of hours? behind the actual site, It gets gererated every so often. I suspect it was typed in incorrectly. Make sure the name you typed in is EXACTLY like the large title at the top of the contrib page, NOT the title of the most recent version.

lildog

QUOTE (wvcrafted @ Feb 28 2007, 12:16 PM)

Using your version 1.2 which is great. I downloaded the updates and when extracting them my compression program is telling me file contains corrupt or illegal file names. It's all the things having to do with upgrades. It extracts the new files and directions, but not the upgrade stuff you put in. I don't think it likes the 1->2 stuff in the file or folder names.

Going to try and use my examdiff pro and see if I can figure out what changed between each of them.

Thanks again for this great contrib!

baddog

Feb 28 2007, 06:15 PM

I cannot get the Edit, Delete, or Preview buttons to work on Contribution Tracker. Does anyone else have this problem? Has anyone fixed it?

(Ignore similar post outside of this thread)

cDGo IT Consultancy

Feb 28 2007, 09:59 PM

Hi lilboy,

Thanks for replying.
The thing is that I'm talking about contribs from the past.
Lets say in contrib installed last in 2005 and has an update in 2006.

What I now understand is that your contrib only works for updates that are now spread thrue the rss feeds.
As the update of 2006 won't be spread through the rss feed, your contrib will not alert me for that update.

lildog

Mar 1 2007, 02:44 PM

cDGo IT Consultancy,
Let me see if I have this right. You installed a contrib in say 2005 there was an update in 2006 that you missed or did not install and would like to be notified that you are not using the latest version, right? This is exactly why I wrote this contrib. I am in the same boat. I have about a hundred contribs installed and I forget to update them then I do updates and it takes me a week or more. Unfortunately, the names and versions of contribs are all over the board and I am not sure I would be able to get Contrib tracker to reliably check the site. Is the contrib you are talking about on the oscommerce contrib site? This is a feature I will investigate and try to implement, no promises.

For now update all of your contribs, enter them into contrib tracker and from then on you will get notified of updates.

lildog

candleman

Mar 2 2007, 02:00 PM

I just upgraded from v1.2 to v1.5.2. When i clicked on the Contrib link in admin, I got the following error

[codeParse error: syntax error, unexpected T_REQUIRE in /home/xxxxxxx/public_html/store/admin/contrib_tracker.php on line 1][/code]

Thinking I may have missed something, I reinstalled v1.2 and it worked fine again. I decided to do a fresh install of v1.5.2 and after, got the same problem. I then brought it back to v1.2 and it works. I installed v1.3 and that is where the problem starts. I'm not coder so I'm not sure where to look.

Line 1 is of course the <?php so I assume it means the first line of code which is require('includes/application_top.php'); on mine.

Thanks for any help and a great contrib!

cDGo IT Consultancy

Mar 2 2007, 02:12 PM

Lildog,

You're right, that's just what I meant.
I've got over 150 contribs running in my shops.
So eager to help you with testing!!!!!!!!!!!!!!!!!!!!!

lildog

Mar 6 2007, 03:06 PM

Candleman,
The only thing I can suggest is check the punctuation near line 1 make sure they all have semi colons, etc. Or post the first part of code and i will try to determine the problem.

lildog

Leak-Proof

Mar 13 2007, 08:19 PM

QUOTE (lildog @ Mar 6 2007, 11:06 AM)

Candleman,
The only thing I can suggest is check the punctuation near line 1 make sure they all have semi colons, etc. Or post the first part of code and i will try to determine the problem.

lildog

I tried to install the 1.5.4 version and got the same error. I reinsalled the 1.2 version and it was back to normal. The code is the same code in the 1.5.4 version release on the contribution page. There must be an error in it, but I can't find it.

gojuryu

Apr 13 2007, 01:28 AM

QUOTE (Leak-Proof @ Mar 13 2007, 01:19 PM)

I tried to install the 1.5.4 version and got the same error. I reinsalled the 1.2 version and it was back to normal. The code is the same code in the 1.5.4 version release on the contribution page. There must be an error in it, but I can't find it.

I've searched and come up with the same problem as well. Everything is perfect according to the installation instructions. seems it would be impossible to have such an error in line 1. My code reads as follows

CODE

<?php
/*
  $Id: contrib_tracker.php,v .9 2007/01/08 11:25:32 lildog Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
_________________________________________________________________

Contribution Tracker MODULE for osC Admin
By Admin of www.silvermoon-jewelry.com
Based on:
        Admin_notes: Original Code By: Robert Hellemans of www.RuddlesMills.com
        RSS News for OSC
These are LIVE SHOPS - So please, no TEST accounts etc...
We will report you to your ISP if you abuse our websites!

note_created-              original date added to store
contr_last_modified- last time (an update has been issued) modified at OSC Site
last_update-               last updated in Store.

DATE_STATUS_CHANGE--DITCH, WHO CARES?
*/

  require('includes/application_top.php');
  require(DIR_WS_CLASSES . 'rdf_class.php');
  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CONTRIB_TRACKER);
  $format = '%Y-%m-%d %H:%M:%S';

  function tep_set_contrib_query_status($contr_id, $status,$contr_last_modified) {
// IF THERE IS NO LAST MODIFIED DATE USE NOW ELSE USE THE $contr_last_modified (LAST TIME THE CONTRIB APPEARED IN THE RSS FEED)
    if ($contr_last_modified == NULL){
      $last_update_date= strftime($format,time());
    }else{
      $last_update_date= $contr_last_modified;
    }

    if ($status == '0') {
      return tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set status = '0', date_status_change = NULL where contr_id = '" . $contr_id . "'");
    } elseif ($status == '1') {
      return tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set status = '1', date_status_change =  now(), last_update='" .$contr_last_modified. "' where contr_id = '" . $contr_id . "'");
    } elseif ($status == '2') {
      return tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set status = '3', date_status_change =  now(), last_update='" .$contr_last_modified. "' where contr_id = '" . $contr_id . "'");
    } else {
      return -1;
    }
  }

and the error reads as follows

CODE

Parse error: syntax error, unexpected T_STRING in /home/gojuryun/public_html/osCommerce/catalog/admin/includes/languages/english/contrib_tracker.php on line 1

Leak-Proof

Apr 16 2007, 07:17 PM

Maybe it's the question mark in the comments!

QUOTE

These are LIVE SHOPS - So please, no TEST accounts etc...
We will report you to your ISP if you abuse our websites!

note_created- original date added to store
contr_last_modified- last time (an update has been issued) modified at OSC Site
last_update- last updated in Store.

DATE_STATUS_CHANGE--DITCH, WHO CARES?
*/

Just a thought.

candleman

Apr 16 2007, 07:49 PM

It's the format that it was uploaded on. The author uses a MAC. Tyr uploading it in Binary and that may solve your problem. It worked for me.

Maureen

Apr 17 2007, 10:40 PM

QUOTE (gojuryu @ Apr 12 2007, 09:28 PM)

and the error reads as follows

CODE

Parse error: syntax error, unexpected T_STRING in /home/gojuryun/public_html/osCommerce/catalog/admin/includes/languages/english/contrib_tracker.php on line 1

The code you posted is from admin/contrib_tracker but your error message is for admin/includes/languages/english/contrib_tracker -- so if you tried to upload the admin/contrib_tracker in binary format and that did not work, try doing the same with ..english/contrib_tracker or checking that file for errors (blank line before the first < ?php or semicolon missing after first define statement, etc)

Maureen

Apr 17 2007, 10:44 PM

My problem is with the Edit function. When I edit the information for an installed contribution all fields are re-saved empty.

Leak-Proof

May 2 2007, 08:38 PM

QUOTE (candleman @ Apr 16 2007, 03:49 PM)

It's the format that it was uploaded on. The author uses a MAC. Tyr uploading it in Binary and that may solve your problem. It worked for me.

Switching to binary worked for me too, Thank-you.

RJ

Maureen

May 21 2007, 04:51 PM

QUOTE (Maureen @ Apr 17 2007, 06:44 PM)

My problem is with the Edit function. When I edit the information for an installed contribution all fields are re-saved empty.

I made changes to the update query in admin/contrib_tracker.php to allow the Edit function to work, these changes have not affected any other function, so far

From

CODE

    case 'update':
      if ($old_status!='1' && $status=='1'){
        $last_update=date("Y-m-d H:M:S");
      }
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'] . "'");

To

CODE

    case 'update':
      if ($old_status!='1' && $status=='1'){
        $last_update=date("Y-m-d H:M:S");
      }
      tep_db_query("update " . TABLE_CONTRIB_TRACKER . " set contr_last_modified = now(), status =  '" . $HTTP_POST_VARS['status'] . "',contrib_name =  '" . $HTTP_POST_VARS['contrib_name_new'] . "', contrib_link =  '" . $HTTP_POST_VARS['contrib_link_new'] . "', config_comments = '" . $HTTP_POST_VARS['config_comments'] . "', last_update = '" . $HTTP_POST_VARS['last_update'] . "', note_created = '" . $HTTP_POST_VARS['note_created'] . "',contrib_vers= '" . $HTTP_POST_VARS['contrib_vers'] . "'  where contr_id = '" . $HTTP_POST_VARS['contr_id'] . "'");
      //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'] . "'");

mrcrowley

Aug 8 2007, 02:37 AM

I just attempted to install Contrib Tracker 1.5.4 and get the following errors.

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in C:\Program Files\xampp\htdocs\catalog\admin\contrib_tracker.php on line 336

Warning: reset() [function.reset]: Passed variable is not an array or object in C:\Program Files\xampp\htdocs\catalog\admin\includes\classes\object_info.php on line 17

Warning: Variable passed to each() is not an array or object in C:\Program Files\xampp\htdocs\catalog\admin\includes\classes\object_info.php on line 18

Can anyone help?

golfman2006

Aug 9 2007, 07:02 PM

First off, thanks for this great contribution. This is one of the most used contributions we have in our shop.

Problem is that our hosting company went and changed a couple settings on our server which they intend to keep. These changes now affect this contribution. When we try to access the Contrib Tracker page on the admin side, we get this error "could not open XML input".

Here are the comments we received from our hosting company after they made the changes:

QUOTE

In addition to disabling register_globals, we are also disabling allow_url_fopen global, which cannot be re-enabled unless done globally. You will need to find another solution that does not require allow_url_fopen to work.

Is there a fix or workaround that someone can recommend to help resolve this issue? This only seems to affect this contribution as the rest of the site os working properly since changes were made by the host.

We have applied all updates to this contribution up through the fix posted 8/7/07, and still the error "could not open XML input" is issued when trying to pull up this page in admin.

lildog

Sep 5 2007, 02:24 PM

Golfman,
It appears there is an alternative, using the cURL library. I will work on it after I finish my current project. Give me a couple of days. If you know php moderately, which is all I know. google allow_url_fopen alternative and a number of references will come up. It is probably a good thing, it appears it is a minor security issue and my server will probably follow suit soon.

lildog

lildog

Sep 6 2007, 03:38 PM

I have updated this contrib for those that have fopen turned off.

Todd

apeofgod

Sep 6 2007, 10:45 PM

I have the 1.5.5 version here (in my machine, not a web server), installed it correctly, but when i try to run i get that error:

CODE

Warning: fopen(/www/shop/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in E:\WORK\xampp\htdocs\www\shop\admin\includes\functions\contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in E:\WORK\xampp\htdocs\www\shop\admin\includes\functions\contrib_tracker.php on line 24
en http://www.oscommerce.com osCommerce, Open Source E-Commerce Solutions Copyright © 2006 osCommerce hpdl@oscommerce.com http://www.oscommerce.com/images/oscommerce_88x31.gif http://www.oscommerce.com http://www.oscommerce.com/community/contributions,3009 Thu, 06 Sep 2007 15:42:58 -0400 http://www.oscommerce.com/community/contributions,2146 Thu, 06 Sep 2007 14:21:51 -0400 http://www.oscommerce.com/community/contributions,5272 $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

und ersetze durch:
$where = ' where ';
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']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order]]> Thu, 06 Sep 2007 13:43:51 -0400 http://www.oscommerce.com/community/contributions,1642 $new_image = $product_info['products_image_med'];
$image_width = MEDIUM_IMAGE_WIDTH;
$image_height = MEDIUM_IMAGE_HEIGHT;
} else {
$new_image = $product_info['products_image'];
$image_width = SMALL_IMAGE_WIDTH;
$image_height = SMALL_IMAGE_HEIGHT;}?>
&lt;script language="javascript"><!--
document.write('<?php echo '<a href="java script:popupWindow(\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . '&image=0') . '\')">' . tep_image(DIR_WS_IMAGES . $new_image, addslashes($product_info['products_name']), $image_width, $image_height, 'hspace="5" vspace="5"') . '<br>' . tep_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a>'; ?>');
//--></script>
<noscript>
<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image_med']) . '">' . tep_image(DIR_WS_IMAGES . $new_image . '&image=0', addslashes($product_info['products_name']), $image_width, $image_height, 'hspace="5" vspace="5"') . '<br>' . tep_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a>'; ?>
</noscript>
<!-- // EOF MaxiDVD: Modified For Ultimate Images Pack! //-->








3 -Finished!

Note: use squre image proportion for best result.

Please email for your question: osi@osicommerce.com


Forum topic for UF: http://forums.oscommerce.com/index.php?showtopic=275418


Demo : http://osicommerce.com/demo1/product_info....p;products_id=6


(if you want to customize this to your store please email us. -size, color & buttons-)

osicommerce]]> Thu, 06 Sep 2007 13:04:25 -0400 http://www.oscommerce.com/community/contributions,3398 Thu, 06 Sep 2007 11:50:32 -0400 http://www.oscommerce.com/community/contributions,4815 Thu, 06 Sep 2007 11:34:05 -0400 http://www.oscommerce.com/community/contributions,160 Thu, 06 Sep 2007 09:17:02 -0400 http://www.oscommerce.com/community/contributions,4061 Thu, 06 Sep 2007 08:57:57 -0400 http://www.oscommerce.com/community/contributions,2991 Thu, 06 Sep 2007 07:56:52 -0400 http://www.oscommerce.com/community/contributions,4067 Thu, 06 Sep 2007 06:47:01 -0400 http://www.oscommerce.com/community/contributions,5402 Thu, 06 Sep 2007 05:03:02 -0400 http://www.oscommerce.com/community/contributions,4789 Thu, 06 Sep 2007 03:40:15 -0400 http://www.oscommerce.com/community/contributions,5370 Thu, 06 Sep 2007 01:59:08 -0400 http://www.oscommerce.com/community/contributions,5308 Thu, 06 Sep 2007 00:28:04 -0400 http://www.oscommerce.com/community/contributions,5403 Wed, 05 Sep 2007 13:07:49 -0400
Warning: fclose(): supplied argument is not a valid stream resource in E:\WORK\xampp\htdocs\www\shop\admin\includes\functions\contrib_tracker.php on line 29
could not open XML input

I followed the "Install Contribution Track" file and it's all ok. Could you help me?

lildog

Sep 6 2007, 11:00 PM

Assuming the problem is in your admin page I would say go into admin/contrib_tracker.php and adjust these lines to match your store.

vWritePageToFile('http://feeds.feedburner.com/osCommerce_Contributions?format=xml', DIR_WS_CATALOG. 'rsscache/contrib_rss.html');

$channel = new rdfFile(DIR_WS_CATALOG. 'rsscache/contrib_rss.html'); //rss cached file path

for some reason, the curl function is not writting the file. Also be sure there is a folder rsscache with write permissions (777) in your catalog folder, check to see that DIR_WS_CATALOG points to your store root in configure.php.

lildog

TheExterminator

Sep 11 2007, 09:08 PM

Hey lildog.

I have drive with this contri since the first version from you.
I have update to 1.5.6 but get this error now.
Fatal error: Call to undefined function: curl_init() in "MY URL/admin/includes/functions/contrib_tracker.php" on line 22

Line 22 is : $sh=curl_init($sHTMLpage);

Hope you can help me

mrcrowley

Sep 12 2007, 12:02 AM

Here are the new errors I get with 1.5.6.

Warning: fopen(/catalog/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 24

Warning: fclose(): supplied argument is not a valid stream resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 29

could not open XML input

lildog

Sep 12 2007, 02:03 PM

Exterminator,
You should revert back to version 1.5.5. It seems like curl is not enabled on your server. I will update the contrib with curl versions and no curl versions. i appologize for any inconvenience. I would guess you could go to admin/server_info and see if curl is enabled. You could also ask your server to turn curl on as from what I read is more secure than fopen.

lildog

lildog

Sep 12 2007, 02:05 PM

QUOTE (mrcrowley @ Sep 12 2007, 12:02 AM)

Here are the new errors I get with 1.5.6.

Warning: fopen(/catalog/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 24

Warning: fclose(): supplied argument is not a valid stream resource in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\contrib_tracker.php on line 29

could not open XML input

WOW. I will look into those errors later today.

TheExterminator

Sep 12 2007, 02:44 PM

I have my own server. I take a look on curl is enabled

QUOTE (lildog @ Sep 12 2007, 04:03 PM)

Exterminator,
You should revert back to version 1.5.5. It seems like curl is not enabled on your server. I will update the contrib with curl versions and no curl versions. i appologize for any inconvenience. I would guess you could go to admin/server_info and see if curl is enabled. You could also ask your server to turn curl on as from what I read is more secure than fopen.

lildog

TheExterminator

Sep 12 2007, 03:41 PM

QUOTE (TheExterminator @ Sep 12 2007, 04:44 PM)

I have my own server. and curl is disebelet

lildog

Sep 28 2007, 11:29 PM

I have uploaded a new version that uses curl OR fopen depending on what is available. I am sorry for the confusion.

lildog

mark27uk3

Sep 29 2007, 12:58 PM

I have tried to install the 2 latest versions of this contribution but both are producing this:

QUOTE

Warning: fopen(/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in /home/*****/public_html/*****/admin/includes/functions/contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /home/oscommer/public_html/new/admin/includes/functions/contrib_tracker.php on line 24
en http://www.oscommerce.com osCommerce, Open Source E-Commerce Solutions Copyright © 2007 osCommerce hpdl@oscommerce.com http://www.oscommerce.com/images/oscommerce_88x31.gif http://www.oscommerce.com http://addons.oscommerce.com/info/5198 Sat, 29 Sep 2007 07:42:47 -0400 http://addons.oscommerce.com/info/5272
habe diese tolle constrib mal installiert und bin echt begeistert

die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen

ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php

finde:
$where = '';
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']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

und ersetze durch:
$where = ' where ';
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']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;

]]> Sat, 29 Sep 2007 06:58:33 -0400 http://addons.oscommerce.com/info/3904 Sat, 29 Sep 2007 06:42:45 -0400 http://addons.oscommerce.com/info/5229 Fri, 28 Sep 2007 20:20:59 -0400 http://addons.oscommerce.com/info/4815
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.
]]> Fri, 28 Sep 2007 19:25:02 -0400 http://addons.oscommerce.com/info/5448 Fri, 28 Sep 2007 13:54:43 -0400 http://addons.oscommerce.com/info/5422 Fri, 28 Sep 2007 13:43:20 -0400 http://addons.oscommerce.com/info/4397 The email received to admin had no subject and message. The reason was with "require (file name)".
I have just moved the line 76 to the top and uploaded the file "product_reviews_write.php" under catalog.
All credit goes to the original contributor.
Great work! Thanks,
]]> Fri, 28 Sep 2007 03:31:46 -0400 http://addons.oscommerce.com/info/5241 It will bring every new register member to the confirmation page along with the code,
this open the system for new member using a false email.

This update will fix so they could only use the link in their email.

Run this update AFTER you have Auto Fill Activation Code Installed!]]> Fri, 28 Sep 2007 03:23:24 -0400 http://addons.oscommerce.com/info/5300 Thu, 27 Sep 2007 22:56:09 -0400 http://addons.oscommerce.com/info/4269
This is a full package. Upgrade instructions assume version 3.2 is installed.]]> Thu, 27 Sep 2007 21:12:48 -0400 http://addons.oscommerce.com/info/4715
1) Acceso al admin del TPV desde el mismo modulo de pago.

2) Ya no se perderan mas los pedidos, ya que el proceso de notificación funciona perfectamente. Aunque no vuelvan a la tienda este pedido se guardará.

3) Nuevo campo de terminal para poder aceptar los dos terminales por excelencia el 1 y el 2 que segun la sucursal puede cambiar. Esto permitirá a la vez trabajar con casi cualquier modulo de servired, con terminal 1 y 2 exceptuando los que trabajen con la firma antigua que cada vez son menos...

Para dudas, errores o informacion, mi mail/msn (atencion_clientes@hotmail.com)

Saludos desde Barcelona España.]]> Thu, 27 Sep 2007 20:48:35 -0400 http://addons.oscommerce.com/info/3998
Change in..
Admin/configure.php and html_output.php. It works for me anyway.

It is just a small txt file inside zip.

Thanks to previous guys.]]> Thu, 27 Sep 2007 18:35:38 -0400 http://addons.oscommerce.com/info/5350
If upgrading from a previous version, the column products_abfs_class in the products table needs to be modified to store up to 6 characters.]]> Thu, 27 Sep 2007 17:04:15 -0400 http://addons.oscommerce.com/info/3661 Thu, 27 Sep 2007 01:09:56 -0400
Warning: fclose(): supplied argument is not a valid stream resource in /home/*****/public_html/*****/admin/includes/functions/contrib_tracker.php on line 29
could not open XML input

anu ideas???

Thanks

Mark

andes1

Sep 29 2007, 02:53 PM

same problem as above

lildog

Sep 30 2007, 03:45 AM

try deleting any existing file in the rsscache folder then try loading the contrib again. Somewhere I omitted the delete function and the file was not getting deleted and generating an error.

Let me know if this works.

lildog

elcidd

Sep 30 2007, 04:33 AM

QUOTE (lildog @ Sep 30 2007, 03:45 AM)

try deleting any existing file in the rsscache folder then try loading the contrib again. Somewhere I omitted the delete function and the file was not getting deleted and generating an error.

Let me know if this works.

lildog

I am getting the same problem as above:

Warning: fopen(/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in /homepages/21/d202393536/htdocs/wii/Backup/includes/functions/contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /homepages/21/d202393536/htdocs/wii/Backup/includes/functions/contrib_tracker.php on line 24

There is nothing in my rsscache folder. Here is the full code:

CODE

Warning: fopen(/rsscache/contrib_rss.html) [function.fopen]: failed to open stream: No such file or directory in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 23

Warning: curl_setopt(): supplied argument is not a valid File-Handle resource in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 24
en http://www.oscommerce.com osCommerce, Open Source E-Commerce Solutions Copyright © 2007 osCommerce hpdl@oscommerce.com  http://www.oscommerce.com/images/oscommerce_88x31.gif http://www.oscommerce.com http://addons.oscommerce.com/info/1484 
this contribution messes up OSC in unexpected ways.
all pages displaying thumbnails will generate a HTTP error 500 (Internal Server Error) on machines running the latest PHP (5.2.4)
you won't get the error in a browser, but all robots will be snubbed.
test before using!]]> Sat, 29 Sep 2007 18:17:46 -0400 http://addons.oscommerce.com/info/1558 Sat, 29 Sep 2007 16:13:30 -0400 http://addons.oscommerce.com/info/2896 
===============================

Hi.. i would like to know what is cron & where to set it automatically? i've search in the forum regarding this great contribution but i couldnt find it.. pls help
thanx

no file attached!]]> Sat, 29 Sep 2007 13:04:01 -0400 http://addons.oscommerce.com/info/1077 
I've attached an updated CGIF class which is available from http://sourceforge.net/tracker/index.php?f...amp;atid=668888]]> Sat, 29 Sep 2007 10:50:20 -0400 http://addons.oscommerce.com/info/5272 
habe diese tolle constrib mal installiert und bin echt begeistert

die Sprachdateien sind teilweise unvollständig gewesen. Ich habe versucht diese zu ergänzen

ein kleiner Bug in adminbereich behoben wenn Fehlermeldung
"1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '-20, 20' at line 1"
in admin/link.php

finde:
$where = '';
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']));
$where = ' where ';
$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

und ersetze durch:
$where = ' where ';
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']));
$where = ' where ';
$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";
}
else if ($showLinkStatus == 'All')
$where = '';

if ($showLinkStatus == 'All')
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;
else
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;

]]> Sat, 29 Sep 2007 06:58:33 -0400 http://addons.oscommerce.com/info/3904 Sat, 29 Sep 2007 06:42:45 -0400 http://addons.oscommerce.com/info/5229 Fri, 28 Sep 2007 20:20:59 -0400 http://addons.oscommerce.com/info/4815 
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.
]]> Fri, 28 Sep 2007 19:25:02 -0400 http://addons.oscommerce.com/info/5448 Fri, 28 Sep 2007 13:54:43 -0400 http://addons.oscommerce.com/info/5422 Fri, 28 Sep 2007 13:43:20 -0400 http://addons.oscommerce.com/info/4397 The email received to admin had no subject and message. The reason was with "require (file name)".
I have just moved the line 76 to the top and uploaded the file "product_reviews_write.php" under catalog.
All credit goes to the original contributor.
Great work! Thanks,
]]> Fri, 28 Sep 2007 03:31:46 -0400 http://addons.oscommerce.com/info/5241 It will bring every new register member to the confirmation page along with the code,
this open the system for new member using a false email.

This update will fix so they could only use the link in their email.

Run this update AFTER you have Auto Fill Activation Code Installed!]]> Fri, 28 Sep 2007 03:23:24 -0400 http://addons.oscommerce.com/info/5300 Thu, 27 Sep 2007 22:56:09 -0400 http://addons.oscommerce.com/info/4269 
This is a full package. Upgrade instructions assume version 3.2 is installed.]]> Thu, 27 Sep 2007 21:12:48 -0400 http://addons.oscommerce.com/info/4715 
1) Acceso al admin del TPV desde el mismo modulo de pago.

2) Ya no se perderan mas los pedidos, ya que el proceso de notificación funciona perfectamente. Aunque no vuelvan a la tienda este pedido se guardará.

3) Nuevo campo de terminal para poder aceptar los dos terminales por excelencia el 1 y el 2 que segun la sucursal puede cambiar. Esto permitirá a la vez trabajar con casi cualquier modulo de servired, con terminal 1 y 2 exceptuando los que trabajen con la firma antigua que cada vez son menos...

Para dudas, errores o informacion, mi mail/msn (atencion_clientes@hotmail.com)

Saludos desde Barcelona España.]]> Thu, 27 Sep 2007 20:48:35 -0400 
Warning: fclose(): supplied argument is not a valid stream resource in /homepages/21/d202393536/htdocs/wii/Backup/admin/includes/functions/contrib_tracker.php on line 29
could not open XML input

mark27uk3

Sep 30 2007, 10:54 AM

QUOTE (lildog @ Sep 30 2007, 04:45 AM)

try deleting any existing file in the rsscache folder then try loading the contrib again. Somewhere I omitted the delete function and the file was not getting deleted and generating an error.

Let me know if this works.

lildog

No file is being created in the rsscache folder, the permissions are set to 777.

Mark

OSCOMMERCE SUPPORT CALL 702-453-3332