Jump to content

valley

Members
  • Content count

    258
  • Joined

  • Last visited

Everything posted by valley

  1. 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
  2. valley

    Ajax Buy Now

    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.
  3. 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
  4. valley

    Yahoo Tree Menu With AJAX

    Hello Andrew, Is there a revised version of this contribution where the sub catogories work properly yet ? You have included a catogories.php in the catalog directory with the package. Where does this go ? No mention in your readme file. Cheers Shred
  5. 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. 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
  6. 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.
  7. 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 ? 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.
  8. 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
  9. 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
  10. valley

    AutoEmailer

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

    AutoEmailer

    Can your latest version be run from browser ? I try to run from the Browser for trials till I can get them working Cheers
  12. valley

    AutoEmailer

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

    AutoEmailer

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

    AutoEmailer

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

    AutoEmailer

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

    AutoEmailer

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

    Reciprocal links checker

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

    AutoEmailer

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

    AutoEmailer

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

    AutoEmailer

    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 ?
  21. valley

    AutoEmailer

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

    AutoEmailer

    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 ?
  23. valley

    AutoEmailer

    Hello Jack , Many thanks for the link. How can I get rid of the Message field which is defaulting to in both admin/announce and admin/new products. Many thaanks in advance
  24. 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 !!
  25. 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
×