Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

valley

Archived
  • Posts

    258
  • Joined

  • Last visited

Posts posted by valley

  1. The flying image is not part of the original MOD's code. How to modidy the mod is explained earler in this thread

     

    Hello,

     

    I have installed this contribution and got it working except for

    the flying image.(with the wheel and tick followed by updating

    the cart with quantity)

    Despite a couple of requests by others for a clear explanation

    of how to implement the fly effect, the only answer seems to be yours referring

    perhaps to posts 35- 36 where the differences between

    cool version and the contribution version have been highlighted.

     

    But the post has mentioned that swapping the code didn't work.

     

    Reading through the posts and looking at working sites, I have

    seen that your www.thefrenchybee.com is the only other site

    where the flying image effect is working.

     

    Could you please explain, for everyone's benefit if swapping

    the code as in posts 35-36 is way ?

     

    There seems to be some confusion about the division "flyimg"

    which is also reffered as fly_img (in product_info) and flyDiv (to insert in the css)

     

    Are they the same ? ( I mean is there only ONE correct). There is no

    mention of this in the readme file.

     

    There is also no mention if you need to define in the stylesheet a

    div id="divShoppingCard" which appears in the read me file.

     

    It is a nice contribution, but need the flying effect or some other

    strong trick to catch the attention of the customer that the

    cart has been updated.

  2. Hello,

     

    There are several pdf contributions and guess, judging from the

    support threads, it is a big task getting them working.

     

    I have the pdf Invoice and Pdf data sheet installed but get this

    error message trying to print from either

     

    FPDF error: Some data has already been output, can't send PDF file

     

    I have searched the threads and couldn't find a resolution

     

    If someone is familiar or knows how to get rid of this error please help.

     

    Many thanks in advance

    Shred

  3. Hello,

    I did a post a request for some support for the Price Hammer

    contribution which is still included in the contribution section

    though the author has offered no email or forum support

     

    http://www.oscommerce.com/community/contri...ch,price+hammer

     

    For some unexplained reason my request has been deleted from the forum.

    Could someone please explain if this contribution is banned from OSC?

     

    If this is authorised, I have got it sort of working

    at http://affiliatesexcel.com

     

    However though the Auction price is correctly passed on to

    the shopping cart, it appers only as SUB TOTal and the product

    price is still shown as original price . Consequently the order

    process carries the original price and not the Auction Price.

     

    Here is the view of the shopping cxart.

     

    Auction_price.gif

     

    Here is the bit of code inserted in catalog/includes/classes/shopping cart

    by the contribution

    EN: Add following in includes/classes/shopping_cart.php 
    DE: Folgenden Code in includes/classes/shopping_cart.php  einf?gen
    
    Between / zwischen  
    function add_cart
    and / und
    function update_quantity
    
    line 119
    
    // Begin Happy Hours Specials Advanced add
    
    function add_cart_happy($products_id, $qty = '1', $happy , $attributes = '', $notify = true) {
      global $new_products_id_in_cart, $customer_id;
    
      $products_id = tep_get_uprid($products_id, $attributes);
      if ($notify == true) {
    	$new_products_id_in_cart = $products_id;
    	tep_session_register('new_products_id_in_cart');
      }
    
      if ($this->in_cart($products_id)) {
    	$this->update_quantity($products_id, $qty, $attributes);
      } else {
    	$this->contents[] = array($products_id);
    	$this->contents[$products_id] = array('qty' => $qty);
    
    
    // insert into database
    	if (tep_session_is_registered('customer_id')) tep_db_query("insert into " . TABLE_CUSTOMERS_BASKET . " (customers_id, products_id, customers_basket_quantity, customers_basket_date_added, final_price ) values ('" . (int)$customer_id . "', '" . tep_db_input($products_id) . "', '" . $qty . "', '" . date('Ymd') . "', '" . $happy . "')");
    
    	if (is_array($attributes)) {
    	  reset($attributes);
    	  while (list($option, $value) = each($attributes)) {
    		$this->contents[$products_id]['attributes'][$option] = $value;
    // insert into database
    		if (tep_session_is_registered('customer_id')) tep_db_query("insert into " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " (customers_id, products_id, products_options_id, products_options_value_id) values ('" . (int)$customer_id . "', '" . tep_db_input($products_id) . "', '" . (int)$option . "', '" . (int)$value . "')");
    	  }
    	}
      }
      $this->cleanup();
    
    // assign a temporary unique ID to the order contents to prevent hack attempts during the checkout procedure
      $this->cartID = $this->generate_cart_id();
    }
    
    /// End Happy Hours Specials Advanced add
    
    
    EN: Add following in includes/classes/shopping_cart.php
    DE: Folgenden Code in includes/classes/shopping_cart.php  einf?gen
    
    
    Below /unterhalb von  
    
    Between  / zwischen  
    
    line213
    
     function calculate() {
    and / und
    $this->total = 0;
    
    // Begin Happy Hours Specials Advanced add
    global  $customer_country_id, $customer_zone_id, $customer_id;
    // End Happy Hours Specials Advanced add
    
    
    EN: Add following in includes/classes/shopping_cart.php in function calculate
    DE: Folgenden Code in includes/classes/shopping_cart.php  einf?gen in function calculate
    
    
    below/unter 
    
    	  $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'");
    	  if (tep_db_num_rows ($specials_query)) {
    		$specials = tep_db_fetch_array($specials_query);
    		$products_price = $specials['specials_new_products_price'];
    	  }
    line235
    
    // Begin Happy Hours Specials Advanced add
    				if (tep_session_is_registered('customer_id')) {
    	  $happy_query = tep_db_query("SELECT final_price from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $customer_id . "' and products_id = '" . (int)$products_id . "'");
    	  if (tep_db_num_rows($happy_query)) {
    				while($happyerg=tep_db_fetch_array($happy_query)) {
    					   $products_price_happy = $happyerg[final_price];
    					   		if($products_price_happy > 0) {
    			 			 $products_price = $products_price_happy;
    				}
    				}
    				}
    				}
    /// End Happy Hours Specials Advanced add
    
    
    
    
    
    
    EN: Add following in includes/classes/shopping_cart.php in function get_products
    DE: Folgenden Code in includes/classes/shopping_cart.php  einf?gen in function get_products
    
    
    below/unter 
    
    	  $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'");
    	  if (tep_db_num_rows($specials_query)) {
    		$specials = tep_db_fetch_array($specials_query);
    		$products_price = $specials['specials_new_products_price'];
    	  }
    
    line 293 
    
    // ----------- Start Happy Hours Specials Advanced  price
    	$happy_query = tep_db_query("select final_price from " . TABLE_CUSTOMERS_BASKET . " where products_id = '" . (int)$prid . "'");
    	if (tep_db_num_rows($happy_query)) {
    		$happy = tep_db_fetch_array($happy_query);
    		if ($happy['final_price'] > 0) {
    				$products_price = $happy['final_price'];
    		}
    	}
    // ----------- End Happy Hours Specials Advanced price
    
    *****************************************************************************
    EN: Add following in includes/application_top.php
    DE: Folgenden Code in includes/application_top.php einf?gen
    
    below/unter	
    
    
      // customer adds a product from the products page
      case 'add_product' :	if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) {
    							$cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']);
    						  }
    						  tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters)));
    						  break;
    
    line 376
    
    // Begin Happy Hours Specials Advanced add
    
      // performed by the 'add_happy' button in Happy_hours_specials_advanced box
    	  case 'add_happy' :	if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) {
    			   $cart->add_cart_happy($_POST['products_id'], $cart->get_quantity($_POST['products_id'])+1, $_POST['flash'] /(1 + $_POST['products_tax']/100),  $HTTP_POST_VARS['id']);
    
    						  }
    
    						  tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters)));
    						  break;
    
    // End Happy Hours Specials Advanced price
    
    *****************************************************************************

     

    The original codeseems to be suitable for a shop with Prices inclusive of tax

    which I have corrected to suit our shop which excludes tax. The price

    passed on to the cart is correct, however not replacing the entry of

    the original price.

     

    Could someone suggest a solution.

     

    This contribution is really great and meets the trend of Auction sales

    which is very popular on the tele.

     

    Many thanks in advance

     

    Shred

  4. As I have installed this contribution downloaded from

     

    http://www.oscommerce.com/community/contributions,4195

     

    and found that there is no support thread I have started this thread.

     

    ++++++++++

    Hello,

     

    I have installed your contribution Prize ContestV1.02

    in our store http://affiliatesexcel.com

     

    Everything seems to have installed correctly and I can configure the

    admin menue to True

     

    However I get only the Column headers in the Catalog/PromoPrize give away menu.

     

    I can't see any butto, drop downs or anything else to enter a contest.

     

    Do you have a support thread for this contribution.

     

    I can't see your site www.terracomp.ca as well as it seems to be down

     

    Could you please suggest how to get this working ?

     

    Cheers

    Shred

  5. Hello,

     

    I got this contribution installed and working along with

    SID Killer (as instructed in that contribution for Integration)

     

    Idon't see any SIDs in the URL though the.html extention is missing.

     

    However Checking the stats on USER TRACKING contribution I can still see

    Spiders and SIDS. Is this right ?

     

    SIDInUsertrack.jpg

     

    I Have also another contribution with following .htaccess file in the

    root directory which eliminates all previous visits with SID being revisted

     

    # $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $
    
    # Set some options
    Options -Indexes
    DirectoryIndex index.php  /catalog/default.php
    IndexIgnore *
    
    RewriteEngine on
    RewriteBase /
    #
    # Skip the next two rewriterules if NOT a spider
    RewriteCond %{HTTP_USER_AGENT} !(msnbot|slurp|googlebot|Gigabot) [NC]
    RewriteRule .* - [S=2]
    #
    # case: leading and trailing parameters
    RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+&(.+)$ [NC]
    RewriteRule (.*) $1?%1&%2 [R=301,L]
    #
    # case: leading-only, trailing-only or no additional parameters
    RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+$|^osCsid=[0-9a-z]+&?(.*)$ [NC]
    RewriteRule (.*) $1?%1 [R=301,L]
    
    #
    # This is used with Apache WebServers
    #
    # For this to work, you must include the parameter 'Options' to
    # the AllowOverride configuration
    #
    # Example:
    #
    # <Directory "/usr/local/apache/htdocs">
    #   AllowOverride Options
    # </Directory>
    #
    # 'All' with also work. (This configuration is in the
    # apache/conf/httpd.conf file)
    
    # The following makes adjustments to the SSL protocol for Internet
    # Explorer browsers
    
    <IfModule mod_setenvif.c>
     <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
    		 nokeepalive ssl-unclean-shutdown \
    		 downgrade-1.0 force-response-1.0
     </IfDefine>
    </IfModule>
    
    # Fix certain PHP values
    # (commented out by default to prevent errors occuring on certain
    # servers)
    
    #<IfModule mod_php4.c>
    #  php_value session.use_trans_sid 0
    #  php_value register_globals 1
    #</IfModule>

     

    as well as the following .htaccess in the catalog directory as required by

    this contribution.

    # $Id: .htaccess,v 1.1 2002/07/21 23:41:41 hpdl Exp $
    #
    # This is used with Apache WebServers
    #
    # The following makes adjustments to the SSL protocol for Internet
    # Explorer browsers
    #
    # For this to work, you must include the parameter 'Limit' to the
    # AllowOverride configuration
    #
    # Example:
    #
    #<Directory "/usr/local/apache/htdocs">
    #  AllowOverride Limit
    #</Directory>
    #
    # 'All' with also work. (This configuration is in your
    # apache/conf/httpd.conf file)
    
    <IfModule mod_setenvif.c>
     <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
    		 nokeepalive ssl-unclean-shutdown \
    		 downgrade-1.0 force-response-1.0
     </IfDefine>
    </IfModule>
    #Options -indexes
    DirectoryIndex /catalog/default.php
    
    Options +FollowSymLinks
    RewriteEngine On 
    RewriteBase /directory/
    
    RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}

     

    I did observe that the SPIDERS stopped appearing in the USER Tracking report

    when I had put the above (first) .htaccess in the ROOT directory but have

    reappeared after the installation of this contribution which has eliminated

    the SIDs from the URL.

     

    I shall appriciate if some one could comment if this is the way it works

    or if there is something wrong.

     

    It looks like the URLS have been shortened by placing a combined .htaccess file

    in the catalog directory .

    I now have more robots than ever on the site but looking at shorter URLS.

    However the html extentions are missing. Can anyone one who knows

    confirm if this is how it will work.

     

    NEWSEOURL.jpg

  6. Hello,

     

    I got this contribution installed and working along with

    SID Killer (as instructed in that contribution for Integration)

     

    Idon't see any SIDs in the URL though the.html extention is missing.

     

    However Checking the stats on USER TRACKING contribution I can still see

    Spiders and SIDS. Is this right ?

     

    SIDInUsertrack.jpg

     

    I Have also another contribution with following .htaccess file in the

    root directory which eliminates all previous visits with SID being revisted

     

    # $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $
    
    # Set some options
    Options -Indexes
    DirectoryIndex index.php  /catalog/default.php
    IndexIgnore *
    
    RewriteEngine on
    RewriteBase /
    #
    # Skip the next two rewriterules if NOT a spider
    RewriteCond %{HTTP_USER_AGENT} !(msnbot|slurp|googlebot|Gigabot) [NC]
    RewriteRule .* - [S=2]
    #
    # case: leading and trailing parameters
    RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+&(.+)$ [NC]
    RewriteRule (.*) $1?%1&%2 [R=301,L]
    #
    # case: leading-only, trailing-only or no additional parameters
    RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+$|^osCsid=[0-9a-z]+&?(.*)$ [NC]
    RewriteRule (.*) $1?%1 [R=301,L]
    
    #
    # This is used with Apache WebServers
    #
    # For this to work, you must include the parameter 'Options' to
    # the AllowOverride configuration
    #
    # Example:
    #
    # <Directory "/usr/local/apache/htdocs">
    #   AllowOverride Options
    # </Directory>
    #
    # 'All' with also work. (This configuration is in the
    # apache/conf/httpd.conf file)
    
    # The following makes adjustments to the SSL protocol for Internet
    # Explorer browsers
    
    <IfModule mod_setenvif.c>
     <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
    		 nokeepalive ssl-unclean-shutdown \
    		 downgrade-1.0 force-response-1.0
     </IfDefine>
    </IfModule>
    
    # Fix certain PHP values
    # (commented out by default to prevent errors occuring on certain
    # servers)
    
    #<IfModule mod_php4.c>
    #  php_value session.use_trans_sid 0
    #  php_value register_globals 1
    #</IfModule>

     

    as well as the following .htaccess in the catalog directory as required by

    this contribution.

    # $Id: .htaccess,v 1.1 2002/07/21 23:41:41 hpdl Exp $
    #
    # This is used with Apache WebServers
    #
    # The following makes adjustments to the SSL protocol for Internet
    # Explorer browsers
    #
    # For this to work, you must include the parameter 'Limit' to the
    # AllowOverride configuration
    #
    # Example:
    #
    #<Directory "/usr/local/apache/htdocs">
    #  AllowOverride Limit
    #</Directory>
    #
    # 'All' with also work. (This configuration is in your
    # apache/conf/httpd.conf file)
    
    <IfModule mod_setenvif.c>
     <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
    		 nokeepalive ssl-unclean-shutdown \
    		 downgrade-1.0 force-response-1.0
     </IfDefine>
    </IfModule>
    #Options -indexes
    DirectoryIndex /catalog/default.php
    
    Options +FollowSymLinks
    RewriteEngine On 
    RewriteBase /directory/
    
    RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
    RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}

     

    I did observe that the SPIDERS stopped appearing in the USER Tracking report

    when I had put the above (first) .htaccess in the ROOT directory but have

    reappeared after the installation of this contribution which has eliminated

    the SIDs from the URL.

     

    I shall appriciate if some one could comment if this is the way it works

    or if there is something wrong.

  7. Hello

     

    I have installed the Ultimate SEO URLs version 2.2 and intgrated with

    SID Killer which was installed previously. Now I get some pages loading up like

    default.php and a contribution page catalog_products_with_images.php.

     

    However for other pages I keep getting error message like file does not exist

    with a path which just says

     

    directory/product_info.php

    catalog/DIR_WS_FLAGSus.gif

    directory/index.php

    directory/product_reviews.php etc

     

    Actually the files are in catalog/

     

    Somehow "catalog" seems to be written as "directory"

     

    Can anyone help with this ? To see the problem the site link is http://affiliatesexcel.com

  8. Hello,

     

    I have installed the SID Killer on our site http://affiliatesexcel.com

    and

    am trying out your add on to convert button links to forms.

     

    I have followed your instructins in the latest version.

    While I can get it workingin the calls from the product_listing.php

    (except

    when the product has attributes in which case it opens the product

    description rather than the shopping cart) I can't get them to load

    the

    shopping cart with the product and the cart comes up empty.

     

    Below are the code I use for product New (in my case it is in the

    module

    directory and called as an include file)and product_review_info

    ++++++++

    <td align="right" valign="middle" class="main"><?php echo '<form

    name="buy_now_' . $products_new['products_id'] . '" method="post"

    action="'

    . tep_href_link(basename($PHP_SELF),

    tep_get_all_get_params(array('action'))

    . 'action=buy_now', 'NONSSL') . '"><input type="hidden"

    name="products_id"

    value="' . $products_new['products_id'] . '">' .

    tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART);

    ?></form></td>

     

    ++++++++++++++++++++

    <td align="right" class="main"><?php

    // Begin Buy Now button mod

    echo '<form name="buy_now" method="post" action="' .

    tep_href_link(basename($PHP_SELF),

    tep_get_all_get_params(array('action')) .

    'action=buy_now', 'NONSSL') . '"><input type="hidden"

    name="products_id"

    value="' . $review['products_id'] . '">' .

    tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '

    </form>';

    // End Buy Now button mod

    ?></td>

    ++++++++++++++++++++++++++++++++++

     

    Can't understand why the product won't load in the cart for the above

    two,

    obviously the somehow the product id is not passed on to the calls.

     

    Shall be grateful if you can suggest what may be wrong

     

    Shred

  9. If the permissions on the file are correct then your host is blocking it somehow.

     

    Jack

     

    Hello Jack,

    I nearly give up !!

     

    I can't get announce to work at all .

    On trying auto_orders I get

     

     

    Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44
    [Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44
    [Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44

  10. The first release was meant to run as a cron job and could not be accessed via admin. That was completely changed and now works as most other contributions. If you have files from previous versions they should be delteted. Also make sure your cron command is looking at the proper file to execute.

     

    Jack

     

    Can your latest version be run from browser ?

    I try to run from the Browser for trials till I can get them working

     

    Cheers

  11. You're correct. The current version has a problem. I have uploaded a new version that fixes this problem.

     

    Jack

     

    Hello Jack,

     

    Many thanks for the reply and upload of the New version.

    I did try with the new announce file but still has no out put.

    there ae no error message, when you open

    in a browser, the page comes up done but no E mail sent.

     

    I wonder the database link is ever opened.

    (I have noticed that you make the call in auto_emailer.php

    and not in auto_announce.php.)

     

    I thought it was direct from the auto_announce in a previous

    release.

     

    Any ideas please ?

     

    Shred

  12. Hello Jack,

     

     

    Could you please let me know the line number or statement

    that is re written to take the nunber of days ?

    (I couln't find an obvious one . ) I can check if this is re written.

     

    On checking the admin file I see a code section

    else if ($pos_start = strpos($fp[$idx], "// Start Date Difference") !== FALSE)
    	  {
    		 for ($idy = $idx; $idy < count($fp); ++$idy)
    		 {
    			if ($pos_stop = strpos($fp[$idy], "// Stop Date Difference") !== FALSE)
    			{
    			   $new_text[0] = "	  if (\$diff >= 0 && \$diff < ". $ae_array['days'] . ")";
    			   $new_text[1] = "\n";
    			   array_splice($fp, $idx + 1, $idy  - $idx - 1, $new_text);
    			   break;
    			}
    		 }
    	  }

     

    However I can't see a corresponding statement in the auto_announce.php

    between the Date Selection and Subject . Have I got the latest file

    or am I missing something ?

    // Start Date Selection
      $adjDate = sprintf("%s-%s-%s", $adjYr, substr($customer['customers_dob'], 5, 2),substr($customer['customers_dob'], 8, 2));
    // Stop Date Selection
      $diff = DifferenceBetween($currentDate, $adjDate);
    
      if ($diff >= 0 && $diff < 18)
      {
    // Start Subject
    	 $Subject = 'test' . ' ' . $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
    // Stop Subject

  13. If the permissions on the file are correct then your host is blocking it somehow.

     

    Jack

     

    Hello Jack,

     

    I have rechecked the permissions which are set to

    777 both for the autoemailer directory and the files.

     

    I did a trial changing the subject in the subject field

    which has been updated in the file also with new time stamp.

     

    When I change the number of days the time stamp is changed

    showing the file has been accessed but the ield returns empty

    during next refresh of the admin file.

     

    Could you please let me know the line number or statement

    that is re written to take the nunber of days ?

    (I couln't find an obvious one . ) I can check if this is re written.

  14. Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory.

     

    Jack

     

    Hello Jack,

    Many thanks for your reply. I got my host to check out

    and it seems everything was OK> Any way I haven't

    made more trials.

     

    I have a problem with adsmin/auto_emailer_announce.php.

     

    It looks like it is not writing the number of days field to the

    auto_emailer/auto_announce.php file when you update after

    filling in a number for example 2.

     

    All the other fields seems to be writing new data.

     

    When I simply update the fild carry the number inserted but

    if you change menu and come back later it disapperars.

     

    I think due to this the auto_announce.php do not out put

    when you make a trial.

     

    Could you please let me know how this can be fixed ?

     

    Cheers

    Shred

  15. I've uploaded a new version. I added a new products module which will inform your customers of new products added since an entered date, or from todays date if one is not entered. Also corrected a few minor coding problems.

     

    Jack

     

    On testing Aut_customers.php I get the following error

     

    PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

    [sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

    [sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

  16. Hello MaxiDVD!

    Thanks for the feedback. I really only threw this addition together in order to get a links checker working. It does need more work. I agreee that the error checking is basic (non existent!!) - I will do some more work on that in the coming days.

    If you have done some work on the stylesheets, etc, can you forward that to me and i will include it in the next release?

    Thanks

    Graeme

     

    Hello , I know 3 years have passed but I haven't seen any update

     

    Could you please let me know which is the file to modify for your

    instruction No 4 below

     

    4. just above this line:

     

    <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_EXCHANGE_LINKS_LINKS, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_link.gif', IMAGE_NEW_LINK) . '</a>'; ?></td>

     

     

    Add:

     

    <td align="right"><?php echo '<a href="' . tep_href_link('checklinks.php') . '">' . tep_image_button('button_check.gif', 'Check Links') . '</a>'; ?></td>

  17. Yes, it should work at an html editor. There is a support thread for it here somewhere. You might want to ask questions about it there since they would have more experience with it.

     

    Jack

    Hello Jack,

     

    Many thanks for the reply. I will Check it out.

    I use MAVDs WYSIWYG addon in admin catogories

    which work quite well for cut and paste. FCK seems

    more adapted for creating new pages.

     

    However, on further tests it seems that the server

    stops after sending a couple of hundred messages.

    As the script can be called by CRON, is it possible

    to incremently select perhaps 100 messages from the list

    If this can be done then the CRON can be set up for

    every 15 minutes or so to send the messages to a different

    group of people.without creating any SPAM issues (for big lists)

     

    As it is it looks like the script can't send the mail to

    the whole customer list due to the server limitations.

  18. No, it works fine here, and I assume for others that use it since no one has mentioned this before. The instructions mention that you may need to change the path so that is expected. You shouldn't have to move it out of admin though.

     

    Jack

    Hello Jack,

    Many thanks for the reply.

     

    Just one question about the editor.

     

    function tep_draw_fckeditor($name, $width, $height, $text)

     

    Is it supposed to work only as a text editor or also as

    an HTML editor ? Can you cut and paste HTML pages

    which is what I try to do by selecting the source menu first.

     

    However the output is getting distoted and truncated.

     

    Cheers

    Shred

  19. I have now changed to a correct path

    $oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor';

     

    but I still get the default html in the field

     

    HELLO Jack,

     

    I have finally got the FCK editor in the Announce and Product info

    pages in the admin.

     

    Here is what I had to do.

     

    Your instructions asked to upload the FCKeditor directory to the admin

    directory. As this was a password protected directory I had to move the

    FCKediror directory up to the Catalog directory.

     

    I had to change the require statement on line 12 in the

    admin/include/functions/html_output.php

    as below

    require(DIR_FS_CATALOG .'FCKeditor/fckeditor.php');

     

    I had to change the base path as below

    / Output a form textarea field w/ fckeditor
     function tep_draw_fckeditor($name, $width, $height, $text) {
    
     $oFCKeditor = new FCKeditor($name);
     $oFCKeditor -> Width  = $width;
     $oFCKeditor -> Height = $height;
     $oFCKeditor -> BasePath  = '/catalog/FCKeditor/';
     $oFCKeditor -> Value = $text;
    
    $field = $oFCKeditor->Create($name);
    
    return $field;
     }

     

    However all this seems to be enough as the FCK editor removes

    and change the formatting of any html you place in the message field.

     

    Any idea why the editor behaves badly ?

  20. Hello Jack,

     

    Ipresume it is there from your instructions

     

    ///

    // Output a form textarea field w/ fckeditor

    function tep_draw_fckeditor($name, $width, $height, $text) {

     

    $oFCKeditor = new FCKeditor($name);

    $oFCKeditor -> Width = $width;

    $oFCKeditor -> Height = $height;

    $oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/';

    $oFCKeditor -> Value = $text;

     

    $field = $oFCKeditor->Create($name);

     

    return $field;

    }

     

    I have now changed to a correct path

    $oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor';

     

    but I still get the default html in the field

  21. I don't understand what you mean with the image.

     

    Jack

     

     

    Hello Jack,

     

    When I click on the Announce menu in the admin the page that

    opens (http://www.affiliatesexcel.com/catalog/admin/auto_emailer_announce.php)

    has this picture with a web page in the "Message" field.

     

    Ipresume it is there from your instructions

     

    ///

    // Output a form textarea field w/ fckeditor

    function tep_draw_fckeditor($name, $width, $height, $text) {

     

    $oFCKeditor = new FCKeditor($name);

    $oFCKeditor -> Width = $width;

    $oFCKeditor -> Height = $height;

    $oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/';

    $oFCKeditor -> Value = $text;

     

    $field = $oFCKeditor->Create($name);

     

    return $field;

    }

     

    How can I empty it to fill in new info ?

  22. Hello Jack,

    We routinely receive LINK request but have no tme

    to handle manually. This contribution is really a boon.

     

    It installed well but I am stuck with the Notorious

    SPLIT PAGE issue.

     

    Hello Problem sorted thanks to earlier posts in this thread.

     

    I didn't realise that the instal.php added a new LINKS item under

    the store configuration . Great automation, but need some instruction

    in the read me file to go there and set up things.

     

    I simply refreshed the MAX_DISPLY_Links count

    and the database problem disappeared.

     

    The second suggestion is to add a link to this thread

    in the READ ME file.

     

    Great contribution from nice guys ! Many thanks again !!

  23. Hello Jack,

    We routinely receive LINK request but have no tme

    to handle manually. This contribution is really a boon.

     

    It installed well but I am stuck with the Notorious

    SPLIT PAGE issue.

     

    When I open in admin I get

    CODE

    Links AllPendingApprovedDisabledWaiting Search:

     

    Title

    Asc Desc URL

    Asc Desc Clicks

    Asc Desc Status

    Asc Desc Action

    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 '-0, MAX_LINKS_DISPLAY' at line 1

     

    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_status from links l left join links_description ld on l.links_id = ld.links_id where ld.language_id = '1' order by ld.links_title limit -0, MAX_LINKS_DISPLAY

     

     

     

    error messge even though there is one entry in the table.

    I was recently stuck with this issue in CATALOG for another contribution

    which was sorted by oleaving the old version of

    split_page.php and modifying the call in the

    contribution file which was different ( I have a hybrid MS2 version)

     

    However your function call inthe links.php in admin is

    similar to old version (with 4 parameters with MAX_LINKS_DISPLAY

    as the second)

     

    I have tried all the fixes discussed in the fORUMS and official bug report

     

    I spent a week sorting the last one and am really tired of this

    issue. Do you have any info that could be useful to get it working.

     

    The site iis http://affiliatesexcel.com

     

    Best regardds

    Shred

×
×
  • Create New...