Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  1. Redmanmike

    OrderCheck v 1.3 Released

    TTstitches, I remember seeing this error and I noticed just as you did it comes from the fact that there is no check to see if attributes are empty for that order. If they are you get and error because it is trying to pass an empty query to the string. A partial way around it is to change the $order_total_modules->process(); from being invoked in checkout_conformation.php to being in ordercheck_functions.php. Most likely you commented it out in ordercheck_functions.php in order to get rid of the doubble vision totals :) checkout_conformation.php <?php if (MODULE_ORDER_TOTAL_INSTALLED) { // $order_total_modules->process(); echo $order_total_modules->output(); } ordercheck_functions.php // ------------------------------------------------------------------------------------------ // data insert functions below. $order_totals = $order_total_modules->process(); // ------------------------------------------------------------------------------------------
  2. Redmanmike

    OrderCheck v 1.3 Released

    Follow up, For who has installed this and think that the orders have dissapeared, when the order gets moved it retains the order id. After looking at the way the admin page displays orders (orders.php) it displays by orders_id in decending order so if you new orders have a lower id then past orders they will show up a few pages back. In my case that turned out to be the first page. You have to options at this point look for them or modify the SQL in orders.php to order by date_purchased :ph34r: Mike S
  3. Redmanmike

    OrderCheck v 1.3 Released

    Ok folks, I think I found a way around the duplicate key material. From what I can tell ordercheck never bothers to find the max value of the oder_id in the orders table, so when it puts an order in the holding table it just increments from 0 instead of the amount of orders already processed in orders. When doing a move the code just dumps the contents of the holding tables row into the orders table order_id and all, which if the order_id aldready exists you get the dup error and you are stuck I went into phpMyadmin and set the autoincrement value of the oredr_id on the holding table to match that of the orders table. In theory holding should always be = > orders so we should be set. Comments welcome, I only spent 30min looking at this but had a successfuly 4 trial runs in which it worked. Mike
  4. The reason why the referrer url is gone when the session expires is because it is never stored in the user_tracking table , instead it is pulled from the sessions table. Once the session is over the it is deleted from the sessions table. I have been trying to change the code so that the referrer is grabbed and stored in the user tracking table, but I am haveing problems figureing out how to use the $HTTP_REFERRER var. Greg did a killer job on the current version, but he really ment it to be used for short time period tracking, less then a day. If anyone out there has a little time to help we could build it out to act as a real user reporting tool for longer periods of tracking. It wouldn't take much just adding some key items to initial data store and then just a few diffrent queries. Cheers, Mike
  5. Redmanmike

    User Tracking with Admin 1.31 Released

    I would also be interested in this mod to the code :D I have also been working on doing a rollup report so that you can see at a glance the number of sessions with page totals, and also one that show that sessions by country break down. I am doing this for so AD tracking reasons I have the SQL correct but am haveing a hard time getting the temp table to work. I get "1044 - Access denied for user: '@localhost' to database 'test-pro'" here is the code so far <?php require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); require(DIR_WS_INCLUDES . 'geoip.inc'); $gi = geoip_open(DIR_WS_INCLUDES . 'GeoIP.dat',GEOIP_STANDARD); ?> <!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> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- 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="2"> <tr> <td><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_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td class="smallText"> </td> <?php $whos_online_query = tep_db_query("select ip_address , count( distinct session_id ) as sessions, count( page_desc ) as pages from user_tracking group by ip_address order by sessions desc , pages desc"); $temptable = ("create temporary table temp1 ( ip_address varchar(15), country varchar(15), sessions int(11), pages int(11) )"); tep_db_query ($temptable); while ($whos_online = tep_db_fetch_array($whos_online_query)) { $pages = $whos_online['pages']; $sessions = $whos_online['sessions']; $countrry = geoip_country_name_by_addr($gi, $whos_online['ip_address']); } $insert_query = ("insert into tempory table temp1 values ip_address, country, sessions, pages ) values ('" . $ipaddress . "', '" . $country . "', '" . $sessions . "', '" . $pages . "')"); tep_db_query($insert_query); $rollup_query = tep_db_query("select country, count ( ip_address ), sum ( sessions ) as sess_count, sum ( pages ) as pg_count from temp1 group by country; " ); while ($rollup = tep_db_fetch_array($rollup_query)) { $page_cnt = $rollup['pg_count']; $sess_cnt = $rollup['sess_count']; $country_name = $rollup['country']; }; ?> <td class="dataTableContent"><?php echo $conutry_name; ?></td> <td class="dataTableContent"><?php echo $sess_cnt; ?></td> <td class="dataTableContent" align="center"><?php echo $page_cnt; ?></td> </tr> </table></td> <!-- body_text_eof //--> </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'); ?> If I can get this to work I will add it as an extra contribution for reporting
  6. I guess thats what I get for looking to close LOL I was looking for 2 lines because thats the way it wraped in the first message..... I just need to step back and put on some sunscreen and aloe to protect form the radiation off the monitor. Cheers,
  7. Ian, DO you have two versions of the 5.0.3 going around I just downloaded the version here http://www.oscommerce.com/community/contributions,282 and the code in that file reads diffrent : function tep_gv_account_update($customer_id, $gv_id) { $customer_gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . "'"); $coupon_gv_query = tep_db_query("select coupon_amount from " . TABLE_COUPONS . " where coupon_id = '" . $gv_id . "'"); $coupon_gv = tep_db_fetch_array($coupon_gv_query); if (tep_db_num_rows($customer_gv_query) > 0) { $customer_gv = tep_db_fetch_array($customer_gv_query); $new_gv_amount = $customer_gv['amount'] + $coupon_gv['coupon_amount']; $gv_query = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . "'"); } else { $gv_query = tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $coupon_gv['coupon_amount'] . "'"); } } And if so which is the most recent? Thank for the wonderful work. It's a piece of art :lol:
  8. Ian, I did the changes by had using beyound compare to compare files, since I also have some other contributions installed. I think part of my problem is the sort order. After reading your docs on your site I checked my sort orders and they were off. I will test it now to see if it works, Thanks
  9. Does anyone know of a way to allow for a gift cert to be used for the whole purchase price. What seems to be happening is that the customer proceeds to the checkout area and enters the coupon code and then try to checkout. The message box comes up telling them to choose a payment method. The same also happens even after they redeem the voucher. The click here to use box comes up but they still can't checkout with out entering info into one of the payment methods. I am not sure what to tweek. Cheers, Mike
  10. Ian, Is there a way to allow the gift voucher/certifcate to be the only form of payment. When I redeem I get credit but am still asked to put in a CC number or use one of the payment methodsevne when the voucher is clicked and there is more then enough credit on it. I am trying to use gift cert to redeem frre gift with certain order amounts.In other words you get a frre gift with your order in the form a of a gift certifcate good for etc.... you all get the idea! I am useing the 20030509 snap shot w/ lots of add ons Luckly I we work out of one of the few states that don't charge taxes so I don't have to worry about that end of things. Also is there an easy way to put back the seperate boxes? I have a site where a lot of customers are useing both coupons and gift certs at the purchase time. Any comments welcome Cheers, Mike
  11. Redmanmike

    OrderCheck v 1.3 Released

    I love this contribe so far but I seem the be have a problem with it causeing this behavior to show up : Sub-Total: $58.20 Sub-Total: $58.20 Table Rate (Fixed Rate): $10.00 Table Rate (Fixed Rate): $10.00 Total: $68.20 Total: $68.20 I am useing loaded5 and when I added <?php //BEGIN -- OrderCheck require(DIR_WS_INCLUDES . FILENAME_ORDERCHECK_FUNCTIONS); //END -- OrderCheck ?> It broke completely untill I removed the <?php & ?> other then that it works great Any Idea where the dups are getting produced?? Cheers
  12. Ok I finally got it to work. It turns out that downloads will fail to show if there is a duplicate attribute for the product in the attribute section. Also for some reason trying to update a product to a downloadable product by editing the existing attribute will not work either. you have to delete the attribute and create it again. I am not sure why but for some reason if the attribute does not already contain the Expiry days: and Download count: you cannot update it. Its all trivial in the end 8) considering the work around is to just delete the existing attribute and create a new one vs. just editing. Cheers, Mike
  13. I am so glad I got your attention Linda. :D Here is what I get: If I buy the unreal game(downloadable) and I have the purchase kick back anything but delievered, there is no download link as expected. When I go under orders and switch the status to delievered the link shows up under view order. BUT this only seems to happen for the unreal game. If I create a new product I never get the link no matter what status the order is. Here is how I enter a new product: 1.Fill out the new product screen with 0 for weight and check the attrribute box for downloadable -windows version 2. I go to the attributes screen and enter the file name in the file box for that product. Is that all the needs to be done? Where is the download info stored in the database? or is it a check outside the database. Also I added the download controlller mod directly over the loaded5 install.When I did a compare the files were not that diffrent. The loaded 5 looked like it had some more checks for stuff but I did not want to muck up the code by combining the files. Thanks Mike
  14. I am useing: L5-CRE (or also known as loaded5 version) w/osc test data + DOWNLOADS_CONTROLLER_MS1_v5_3 When I run with the test data the unreal product will show the download but if I change another product to have the download capibility it does not seem to work. Question: How do you set up a product to be downloadable? To me it seems that you have to do 3 steps. 1. Create an attribute like Option:Download Value:Download: Windows - English 2. Create the product and add the attribute 3.edit the attribute to add the file name ect. But I think I am missing something :roll: because it doesn't seem to work for new products or even if I edit an existing product. Cheers, Mike
  15. Redmanmike

    Downloads Controller

    Sorry to have forgotten the simple question but the download link should show up on the Home ? Catalog ? My Account ? History ? Order Information and also on the checkout success page I believe. Cheers, Mike