Jump to content

elcidd

Members
  • Content count

    62
  • Joined

  • Last visited

Everything posted by elcidd

  1. elcidd

    [Contribution] STS v4

    Hey Bill, The workaround did solve the problem, it allows the comment to be made and no errors. Unfortunately, it returns the customer to the exact entry screen, making them unsure if the comment registered (thus creating multiple entries when the customer hits submit a few times). It is a situation I am OK with for now. I wish I knew php (I am a novice hacker at best and not a programmer) so I could update the code. I pm'ed the maintainer. Hopefully he will have an opportunity at some point to update the code. Thanks again for helping me with this!!
  2. elcidd

    [Contribution] STS v4

    Hello, I've added Customer Testamonials 3 to my store and added the the box info to sts_user_code as well as put the placeholder in my template. However, it works until someone tries to submit a testamonial. Then it returns the following code once they press the submit button. Fatal error: Call to a member function on a non-object in /homepages/21/d202393536/htdocs/wii/catalog/includes/classes/sts.php on line 185 The store is located at http://www.buynintendowiiconsoleonline.com Can anyone help me figure this out? Thanks Lionel
  3. elcidd

    Automatic Store Feeds Contribution

    Hello, Can you tell me how and where you hardcoded the location in the feeders.php file. I have the same errors (google error: "We didn't understand this location", and "This attribute is no longer supported. Please use a supported attribute. - help shipping:" ,and "This attribute is no longer supported. Please use a supported attribute. - help label:" ). I would like to get the location, label and shipping errors cleaned up so I can successfully upload my feed. Thanks for any help you can give me!!
  4. elcidd

    Recover Cart Sales

    Thanks so much for the reply. I must have been really sleepy when I checked the configuration box, I swear I did not see that option. Thanks for showing me!! I changed the settings to allow Preparing [Paypal IPN] and now those abandoned carts appear in the list. Thanks again!! Lionel
  5. elcidd

    Recover Cart Sales

    First off, thanks for this great contribution. I can see this recovering alot of loss revenue as well as helping me tweak my site. I am not sure if this was discussed before, however I have abandoned carts that were abandoned AFTER CHECKOUT. THe customer checked out via paypal_IPN as their payment process. However, they never completed the sale at paypal. How do I get the Recover Cart module to recognize this (or maybe manually add it)?
  6. elcidd

    Get 1 Free

    OK, I hink I figured out that problem. Since I have a moderately modded shop I installed this contribution by merging the included .php files into mine. I just copied and pasted the code for this particular shopping_cart.php into this area and I resolved the issue with the error code but I get another one: Parse error: parse error, unexpected $ in /homepages/21/d202393536/htdocs/wii/Backup/ includes/classes/shopping_cart.php on line 492 I do not have anything in line 492. Here is a copy of the code (474 to 491 (end of file)): $products_free = tep_db_fetch_array($products_free_query); // Return an array of free product values $output = array ( 'id' => $get_1_free['products_free_id'], 'quantity' => $free_quantity, 'name' => $products_free['products_name'], 'model' => $products_free['products_model'], 'image' => $products_free['products_image'], 'weight' => $products_free['products_weight'] ); return $output; } //if ($products_quantity } //else }//if (tep_db_num_rows // offer was not valid (disabled or expired) return false; }//function // end Get 1 Free ?> Did I miss something?
  7. elcidd

    Get 1 Free

    Hey, thanks for this terrific contribution. I've installed it on an OSC 2.2 rc1 shop but when I try to go to my shop (catalog side) I get the following error: Parse error: parse error, unexpected T_ECHO in /homepages/21/d202393536/htdocs/wii/Backup/includes/classes/shopping_cart.php on line 439 The code referenced is: echo tep_db_num_rows($get_1_free_query) ; This is the code in question in its context (snippet starts on line 427): // start Get 1 Free function get1free ($products_id) { global $languages_id; $get_1_free_query = tep_db_query("select products_free_id, products_free_quantity, products_qualify_quantity, products_multiple, get_1_free_expires_date from " . TABLE_GET_1_FREE . " where products_id = '" . (int)$products_id . "' and status = '1'" echo tep_db_num_rows($get_1_free_query) ; ); if (tep_db_num_rows($get_1_free_query) > 0) { $get_1_free = tep_db_fetch_array($get_1_free_query); //Check that the offer has not expired //MNK bugfix 13.08.2007 Any Ideas? Thanks Lionel
  8. I am not sure if this is the cause of my problem, however, once I removed the other languages from my store the Quick Price update as well as Easy Populate started working together. I don't use the other languages so it is not a problem for me.
  9. Guest account contribution can be found here
  10. Is this compatible with the Guest Account contribution? I keep getting a Parse error: parse error, unexpected $ in /homepages/21/d202393536/htdocs/wii/Backup/create_account.php on line 711 error when I try to checkout withgout registration.
  11. Hello, I am currently getting this error message on my Quick Prices Update module: 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 '' at line 1 select manufacturers_name from manufacturers where manufacturers_id= This only happens when I try to sort by manufacturer. I applied the split_page_result fix but nothing seemed to change. Does anyone have any idea what the problem is (and how I can fix it?). Thanks Lionel P.S. This issues started happening after I installed Easy Populate 2.76f r1 (here) ) and imported some new products.
  12. Hey, Thanks for your input, I can't believe I made that bonehead mistake! :blush: I've since fixed that but I got another error after I tried to upload a file: 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 'and scenes. Ultimate Battle Z mode uses the ladder type tournam UPDATE products SET products_price=' you can unlock new characters', products_image=' the story can and will change to match the outcome of your fighters. If you can collect enough wins in a given portion of the story', products_weight=' players fight one match after another as they climb the ladder of increasingly difficult foes. Each selectable ladder of bouts has a different condition or theme. Once a player completes a ladder', products_tax_class_id='', products_date_available='1969-12-31 18:59:59', products_date_added='2007-10-03 10:48:43', products_last_modified='2007-10-03 10:48:43', products_quantity = and scenes. Ultimate Battle Z mode uses the ladder type tournament system of fighting made popular by the fighting game Mortal Kombat. In this system, products_retail_price = ' powers', manufacturers_id = 40, products_status = 1 WHERE (products_id = 50) LIMIT 1 However, I found a workaround that is good enough for me. I turned off EP_EXCEL_SAFE_OUTPUT and EP_PRESERVE_TABS_CR_LF . I then saved the file as a tab delimited file and ftp'd it to the /temp folder. I imported it in with EP and everything uploaded fine, with no issues. I think one of the problems was the html language in my product descriptions that was throwing things off. Anyway, thanks for the help, I still can't believe I made that mistake... Cheers Lionel
  13. Hello, Thanks for the above, I've followed the directions as best I could and I can download a file just fine, however, when I upload the file, that is when I get the: File uploaded. Temporary filename: /tmp/phpyzn1e9 User filename: EP2007Oct03-0505.csv Size: 167887 1054 - Unknown column 'p.product_retail_price' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, p.product_retail_price as v_product_retail_price, subc.categories_id as v_categories_id, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'wiiclassic' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1 [TEP STOP] error message. I don't know what I left out of the code. What do you think (you meaning anyone who can help) Thanks Lionel
  14. OK, I figured it out. I added "v_products_retail_price to almost every location where v_product_price was. It seems to work with the items I already have in my store. However, now I have a different problem now. I tried to upload a file with new items in it and I get the following error in easypopulate.php: 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 'and scenes. Ultimate Battle Z mode uses the ladder type tournam UPDATE products SET products_price=' you can unlock new characters', products_image=' the story can and will change to match the outcome of your fighters. If you can collect enough wins in a given portion of the story', products_weight=' players fight one match after another as they climb the ladder of increasingly difficult foes. Each selectable ladder of bouts has a different condition or theme. Once a player completes a ladder', products_tax_class_id='', products_date_available='1969-12-31 18:59:59', products_date_added='2007-10-02 18:36:17', products_last_modified='2007-10-02 18:36:17', products_quantity = and scenes. Ultimate Battle Z mode uses the ladder type tournament system of fighting made popular by the fighting game Mortal Kombat. In this system, products_retail_price=' powers', manufacturers_id = 13, products_status = 1 WHERE (products_id = 50) LIMIT 1 I also get a new category on the catalog side called 32.99 . Does anyone have any ideas?
  15. elcidd

    Contribution Tracker

    What I did in contrib_tracker.php was completely remove DIR_WS_CATALOG. 'rsscache/contrib_rss.html and replace it with the full path (which, by the way, is defined in DIR_FS_CATALOG). That worked perfect. However, when I came back here and read Mark's post, I tried it to see if that would work and yes it did work also. Using DIR_FS_CATALOG also solved the problem for me. So all three methods resolve this issue.
  16. Sorry, forgot to include the code that is tripping me up. In David's instructions, he wants me to Find the line, approx 991: $filelayout = array_merge($filelayout , array( 'v_tax_class_title' => $iii++, 'v_status' => $iii++, This line does not exsist in my /admin/easypopulate.php file
  17. Hello I have installed the latest version of Easy Populate into my store. I already had EZ New Fields installed and I want to find out how I can integrate the retail price field into Easy Populate. I've downloaded Dave Case's instructions (here) on how I can integrate them, however, the code that dave refers to is not in the version of EP that I have. Can someone show me how to do this? Below is the pertinent data: 1) PHP Version: 4.4.7 (Zend: 1.3.0) Server Type & version Linux 2.6.16.33-20070131a-areca-filemon-3ware-e1000 2) Set EP_SHOW_EP_SETTINGS to true in the EP settings and then copy the settings that are displayed on the EP main page into your post. Settings EP vers: 2.76e Temp Dir: /homepages/21/d202393536/htdocs/wii/Backup/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: true SPPC: false Extra Fields: true 3) Copy of any error message you are receiving. No error messages, just not seeing the retail price field 4) Post a link to a sample of any upload file you are trying. I don't have a sample file 5) Place all information in your post. Done. I am running a moderately modified OSC 2.2 rc1 Any help would be greatly appreciated. Lionel
  18. elcidd

    Contribution Tracker

    I still can't get it to work. I don't know what you did to get the paths correct. I am running OSC 2.2 rc1. I don't have a catalog/configure.php file. I do have a catalog/includes/configure.php file. Can you clue me in to what you did to correct this? Thanks Lionel
  19. elcidd

    Contribution Tracker

    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: 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 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] osCommerce, Open Source E-Commerce Solutions Copyright © 2007 osCommerce hpdl@oscommerce.com [url="http://www.oscommerce.com/images/oscommerce_88x31.gif"]http://www.oscommerce.com/images/oscommerce_88x31.gif[/url] [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] [url="http://addons.oscommerce.com/info/1484"]http://addons.oscommerce.com/info/1484[/url] 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 [url="http://addons.oscommerce.com/info/1558"]http://addons.oscommerce.com/info/1558[/url] Sat, 29 Sep 2007 16:13:30 -0400 [url="http://addons.oscommerce.com/info/2896"]http://addons.oscommerce.com/info/2896[/url] =============================== 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 [url="http://addons.oscommerce.com/info/1077"]http://addons.oscommerce.com/info/1077[/url] I've attached an updated CGIF class which is available from [url="http://sourceforge.net/tracker/index.php?func=detail&aid=1537502&group_id=114602&atid=668888"]http://sourceforge.net/tracker/index.php?f...amp;atid=668888[/url]]]> Sat, 29 Sep 2007 10:50:20 -0400 [url="http://addons.oscommerce.com/info/5272"]http://addons.oscommerce.com/info/5272[/url] 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 [url="http://addons.oscommerce.com/info/3904"]http://addons.oscommerce.com/info/3904[/url] Sat, 29 Sep 2007 06:42:45 -0400 [url="http://addons.oscommerce.com/info/5229"]http://addons.oscommerce.com/info/5229[/url] Fri, 28 Sep 2007 20:20:59 -0400 [url="http://addons.oscommerce.com/info/4815"]http://addons.oscommerce.com/info/4815[/url] 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 [url="http://addons.oscommerce.com/info/5448"]http://addons.oscommerce.com/info/5448[/url] Fri, 28 Sep 2007 13:54:43 -0400 [url="http://addons.oscommerce.com/info/5422"]http://addons.oscommerce.com/info/5422[/url] Fri, 28 Sep 2007 13:43:20 -0400 [url="http://addons.oscommerce.com/info/4397"]http://addons.oscommerce.com/info/4397[/url] 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 [url="http://addons.oscommerce.com/info/5241"]http://addons.oscommerce.com/info/5241[/url] 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 [url="http://addons.oscommerce.com/info/5300"]http://addons.oscommerce.com/info/5300[/url] Thu, 27 Sep 2007 22:56:09 -0400 [url="http://addons.oscommerce.com/info/4269"]http://addons.oscommerce.com/info/4269[/url] This is a full package. Upgrade instructions assume version 3.2 is installed.]]> Thu, 27 Sep 2007 21:12:48 -0400 [url="http://addons.oscommerce.com/info/4715"]http://addons.oscommerce.com/info/4715[/url] 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
  20. OK, I got it resolved (thanks Chris!!). The cause of the problem still eludes me, however, I think it has something to do with the osCommerce 2.2 rc1 checkout_confirmation script. Chris emailed me his copy that was working. I compared the two and they seemed to have the same coding but in different areas. I uploaded Chris' file (after backing up my file of course ;) ) and it seemed to resolve the issue. My right column is now still on the right!! Thanks again Chris for looking into this. You can check out the site at Http://www.buynintendowiiconsoleonline.com
  21. elcidd

    OSC-Affiliate

    Hello, I had the same problem. I found the answer in another thread, but briefly, I opened affiliate_affiliate.php and relplaced require('includes/functions/affiliate_functions.php'); (around line 18) with the require_once version -- require_once('includes/functions/affiliate_functions.php'); -- Actually, this step has resolved most of the Cannot redeclare... error messages I got with this module. I just went to the .php file reference in the address bar and replaced the "require" line with the "require_once" line. I am not a programmer and am a newbie at php, but it worked for me without issue. You can check it out at my store: Http://www.buynintendowiiconsoleonline.com
  22. elcidd

    OSC-Affiliate

    Yes, I am having a similar problem, in that the download I got did not have instructions. The contribution was from http://www.oscommerce.com/community/contributions,158 Titled: ========================================== BUG Fixes OSC Affiliate v2.62 nourah 1 Apr 2007 it works now! This is a complete English package. I didn't update the German Files. See BUG_FIXES.txt for the fixes. =========================================== I opened the previous contribution and was following those instructions in the hopes that it would help me install the contribution, however, in the section where I have to modify the admin\index.php file, the below instructions cannot be completed because the code referenced to add after is not found in my index.php file ( I have osCommerce 2.2 rc1). Can someone let me know how I need to continue so I can implement this? Thanks!! Lionel In index.php in the admin directory find line 50 approx array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))), and on a new line add the following code after it: array('title' => BOX_HEADING_AFFILIATE, 'image' => 'affiliate.gif', 'href' => tep_href_link(FILENAME_AFFILIATE_SUMMARY, 'selected_box=affiliate'), 'children' => array(array('title' => BOX_AFFILIATE, 'link' => tep_href_link(FILENAME_AFFILIATE, 'selected_box=affiliate')), array('title' => BOX_AFFILIATE_BANNERS, 'link' => tep_href_link(FILENAME_AFFILIATE_BANNERS, 'selected_box=affiliate')))), In index.php in the admin directory find line 106 approx <td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2"> and replace that line with the following code : <td width="160" valign="top"><table border="0" width="160" height="390" cellspacing="0" cellpadding="2"> In index.php in the admin directory find lines 167 to 173 approx $contents[] = array('params' => 'class="infoBox"', 'text' => BOX_ENTRY_CUSTOMERS . ' ' . $customers['count'] . '<br>' . BOX_ENTRY_PRODUCTS . ' ' . $products['count'] . '<br>' . BOX_ENTRY_REVIEWS . ' ' . $reviews['count']); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; and on a new line add the following code after it: $affiliate_sales_raw = "select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from " . TABLE_AFFILIATE_SALES . " "; $affiliate_sales_query= tep_db_query($affiliate_sales_raw); $affiliate_sales= tep_db_fetch_array($affiliate_sales_query); $affiliate_clickthroughs_raw = "select count(*) as count from " . TABLE_AFFILIATE_CLICKTHROUGHS . " "; $affiliate_clickthroughs_query=tep_db_query($affiliate_clickthroughs_raw); $affiliate_clickthroughs= tep_db_fetch_array($affiliate_clickthroughs_query); $affiliate_clickthroughs=$affiliate_clickthroughs['count']; $affiliate_transactions=$affiliate_sales['count']; if ($affiliate_transactions>0) { $affiliate_conversions = tep_round($affiliate_transactions/$affiliate_clickthroughs,6)."%"; } else $affiliate_conversions="n/a"; $affiliate_amount=$affiliate_sales['total']; if ($affiliate_transactions>0) { $affiliate_average=tep_round($affiliate_amount/$affiliate_transactions,2); } else { $affiliate_average="n/a"; } $affiliate_commission=$affiliate_sales['payment']; $affiliates_raw = "select count(*) as count from " . TABLE_AFFILIATE . ""; $affiliates_raw_query=tep_db_query($affiliates_raw); $affiliates_raw = tep_db_fetch_array($affiliates_raw_query); $affiliate_number= $affiliates_raw['count']; $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_AFFILIATES); $contents[] = array('params' => 'class="infoBox"', 'text' => BOX_ENTRY_AFFILIATES . ' ' . $affiliate_number . '<br>' . BOX_ENTRY_CONVERSION . ' ' . $affiliate_conversions . '<br>' . BOX_ENTRY_COMMISSION . ' ' . $currencies->display_price($affiliate_commission, '')); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>';
  23. Hey Chris, It's me again. I don't know what happened but the checkout_confirmation page is not displaying correctly again. Although I can see the buySafe button and everything works, the right column is now again at the bottom of the screen, on the left hand side of the page. When Buysafe is turned off, everything is fine. I'm thinking it may be something to do with the button size maybe? Anyway, below is the code to my checkout_confirmation page. Thanks for checking into this!! <?php /* $Id: checkout_confirmation.php,v 1.139 2003/06/11 17:34:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(array('mode' => 'SSL', 'page' => FILENAME_CHECKOUT_PAYMENT)); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } // if there is nothing in the customers cart, redirect them to the shopping cart page if ($cart->count_contents() < 1) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } // avoid hack attempts during the checkout procedure by checking the internal cartID if (isset($cart->cartID) && tep_session_is_registered('cartID')) { if ($cart->cartID != $cartID) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } } // if no shipping method has been selected, redirect the customer to the shipping method selection page if (!tep_session_is_registered('shipping')) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } if (!tep_session_is_registered('payment')) tep_session_register('payment'); if (isset($HTTP_POST_VARS['payment'])) $payment = $HTTP_POST_VARS['payment']; if (!tep_session_is_registered('comments')) tep_session_register('comments'); if (tep_not_null($HTTP_POST_VARS['comments'])) { $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); } // load the selected payment module require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment($payment); require(DIR_WS_CLASSES . 'order.php'); $order = new order; $payment_modules->update_status(); if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL')); } if (is_array($payment_modules->modules)) { $payment_modules->pre_confirmation_check(); } // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping); require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; $order_total_modules->process(); // Stock Check $any_out_of_stock = false; if (STOCK_CHECK == 'true') { for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { if (tep_check_stock($order->products[$i]['id'], $order->products[$i]['qty'])) { $any_out_of_stock = true; } } // Out of Stock if ( (STOCK_ALLOW_CHECKOUT != 'true') && ($any_out_of_stock == true) ) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_CONFIRMATION); $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <?php if (isset($$payment->form_action_url)) { $form_action_url = $$payment->form_action_url; } else { $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } echo tep_draw_form('checkout_confirmation', $form_action_url, 'post'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_confirmation.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <?php if ($sendto != false) { ?> <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo '<b>' . HEADING_DELIVERY_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td> </tr> <?php if ($order->info['shipping_method']) { ?> <tr> <td class="main"><?php echo '<b>' . HEADING_SHIPPING_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo $order->info['shipping_method']; ?></td> </tr> <?php } ?> </table></td> <?php } ?> <td width="<?php echo (($sendto != false) ? '70%' : '100%'); ?>" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if (sizeof($order->info['tax_groups']) > 1) { ?> <tr> <td class="main" colspan="2"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> <td class="smallText" align="right"><b><?php echo HEADING_TAX; ?></b></td> <td class="smallText" align="right"><b><?php echo HEADING_TOTAL; ?></b></td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <?php } for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { echo ' <tr>' . "n" . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "n" . ' <td class="main" valign="top">' . $order->products[$i]['name']; if (STOCK_CHECK == 'true') { echo tep_check_stock($order->products[$i]['id'], $order->products[$i]['qty']); } if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) { for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>'; } } echo '</td>' . "n"; if (sizeof($order->info['tax_groups']) > 1) echo ' <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n"; echo ' <td class="main" align="right" valign="top">' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . '</td>' . "n" . ' </tr>' . "n"; } ?> </table></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_BILLING_INFORMATION; ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo '<b>' . HEADING_BILLING_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br>'); ?></td> </tr> <tr> <td class="main"><?php echo '<b>' . HEADING_PAYMENT_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> </table></td> <td width="70%" valign="top" align="right"><table border="0" cellspacing="0" cellpadding="2"> <?php if (MODULE_ORDER_TOTAL_INSTALLED) { echo $order_total_modules->output(); } ?> </table></td> <?php // {{ buySAFE Module if (is_array($buysafe_result) && $buysafe_result['IsBuySafeEnabled'] == 'true') { ?> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><a href="<?php echo $buysafe_result['CartDetailsUrl']; ?>" target="_blank" style="text-decoration:underline"><?php echo $buysafe_result['CartDetailsDisplayText']; ?></a></td> </tr> </table> <?php } // end if (is_array($buysafe_result)) // }} ?> </tr> </table></td> </tr> <?php if (is_array($payment_modules->modules)) { if ($confirmation = $payment_modules->confirmation()) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_PAYMENT_INFORMATION; ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="4"><?php echo $confirmation['title']; ?></td> </tr> <?php for ($i=0, $n=sizeof($confirmation['fields']); $i<$n; $i++) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $confirmation['fields'][$i]['title']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $confirmation['fields'][$i]['field']; ?></td> </tr> <?php } ?> </table></td> </tr> </table></td> </tr> <?php } } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if (tep_not_null($order->info['comments'])) { ?> <tr> <td class="main"><?php echo '<b>' . HEADING_ORDER_COMMENTS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo nl2br(tep_output_string_protected($order->info['comments'])) . tep_draw_hidden_field('comments', $order->info['comments']); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td align="right" class="main"> <?php if (is_array($payment_modules->modules)) { echo $payment_modules->process_button(); } echo tep_image_submit('button_confirm_order.gif', IMAGE_BUTTON_CONFIRM_ORDER) . "n"; ?> </td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_DELIVERY . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_PAYMENT . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> "25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  24. elcidd

    [Contribution] STS v4

    Hello, I have STS 4.5.2 and HTC 2.6.3 installed with several other mods. The site is running fine, however I have this annoying  in the upper left hand corner of all my pages when accessing the site from any other browser except MS Internet Explorer. I'm sure this is a simple fix, but can anyone tell me how to get rid of it? Thanks Lionel Site is: Http://www.buynintendowiiconsoleonline.com
×