Jump to content

svetur

Members
  • Content count

    10
  • Joined

  • Last visited

  1. This module is working fine - i have been using it for 6 months now. And what is MVS??????
  2. svetur

    How to make instant delivery...

    This is url for the contribution forum http://forums.oscommerce.com/index.php?showtopic=186485
  3. svetur

    How to make instant delivery...

    Go to contribution development - > Virtual Unique Products (AKA PIN and phonecard selling), public beta test Download the original contribution + the changes that i made ( forum page 2 ). This is the closest contribution you'll get for instant pin delivery. I'm using it on my site www.svetur.com with oscommerce
  4. Hi, in my case i get 2 Order process ( the same email that customer gets ) and one from paypal. The first one is sent to Send Extra Order Emails To xxx@xxx.com I do not get the one to my main email address for some reason. My site is modified a lot too.
  5. This modification lets you send pin codes to customer email. That's how it looks: ------------------------------------------------------ Order Number: 23 Detailed Invoice: http://www.xxxx.com/catalog/account_histor...php?order_id=23 ------------------------------------------------------ Call access number xxxxxxxxxx Dial - country code + phone number No need for 011 If you have an problems contact us: xxxx@xxxxcom Date Ordered: Friday 02 June, 2006 Products ************************************ $10 Calling Card Pin code - 123455 $10 Calling Card Pin code - 223456 $10 Calling Card Pin code - 345678 $10 Calling Card Pin code - 132456 $20 Calling Card Pin code - 324567 $5 Calling Card Pin code - 123211 ************************************ 4 x $10 Calling Card () = $40.00 1 x $20 Calling Card () = $20.00 1 x $5 Calling Card () = $5.00 Total: $65.00 Billing Address ------------------------------------------------------ and etc..... -------------------------------- This is how it was done. I had to edit checkout_process.php and includes/languages/english/checkout_process.php includes/languages/english/checkout_process.php just add these lines: define('EMAIL_TEXT_PROMOTIONS', 'Call any access number' . "\n" . 'xxxxxxx'. "\n" . 'Dial - country code + phone number' . "\n" . 'No need for 011' . "\n" . 'If you have any problems contact us: xxx@xxxxx.com' . "\n"); define('EMAIL_SEPARATOR_2', '************************************'); catalog/checkout_process.php Find these lines and change the lines in the bold font: (These lines add $10 xxxx, pin code - xxxxx ) if(tep_db_num_rows($pin_query)=='0') { // We have no PIN for this product // insert some error notifying here $pin=PIN_NOT_AVAILABLE; } else { $pin_res=tep_db_fetch_array($pin_query); $pin=$pin_res['products_pin_code']; tep_db_query("UPDATE ".TABLE_PRODUCTS_PINS." SET products_pin_used='".$insert_id."' WHERE products_pin_id = '".$pin_res['products_pin_id']."'"); $products_ordered .= $order->products[$i]['name'] . "\n"; $products_ordered .= 'Pin code - '; $products_ordered .= $pin . "\n"; Find these lines and change $product_add line in the bold font: ( This line cleans up and displays your order summary ) $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']); $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; $products_add .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . "\n"; Find these lines and add lines in the bold font: ( These lines display the dialing instructions and pins for customer's email ) $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . EMAIL_SEPARATOR . "\n\n" . EMAIL_TEXT_PROMOTIONS . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR_2 . "\n" . $products_ordered . EMAIL_SEPARATOR_2 . "\n" . $products_add ; That's is it. Enjoy. Any questions, problems - post it.
  6. Bug!!!!! My Pin loader wasn't deducting pin number so i found a flaw ( i think ) here it is: It was giving all pins because it wasn't checking if they were sold!!!! file : admin/pin_loader.php added twice in this file WHERE products_pin_used='0'. case 'update': $pins_query=tep_db_query("SELECT products_id,COUNT(*) AS pcount FROM ".TABLE_PRODUCTS_PINS." WHERE products_pin_used='0' GROUP BY products_id"); while($pin_res=tep_db_fetch_array($pins_query)) { tep_db_query("UPDATE products SET products_quantity='".$pin_res['pcount']."' WHERE products_id='".$pin_res['products_id']."'"); } $messageStack->add(PINS_QUANTIY_UPDATED,'success'); ------- <?php $pins_query=tep_db_query("SELECT products_id,COUNT(*) AS pcount FROM ".TABLE_PRODUCTS_PINS." WHERE products_pin_used='0' GROUP BY products_id"); while($pin_res=tep_db_fetch_array($pins_query)) {
  7. Hi, still having problems - my pins are not being deducted from the loader. Any ideas?
  8. hHi, disregard the last post, it doesn't let me delete. I fix it, i was missing products_attributes_is_pin in the database. But now i can finish the payment process but i do not get any pins? My pin_loader is full nothing was deducted. Please help. Thank you.
  9. Hi, i'm testing it on sandbox.paypal. After payment has been made and i returned to merchant website ( my osscommerce page ) i got this error 1054 - Unknown column 'pad.products_attributes_is_pin' in 'field list' SELECT products_quantity, pad.products_attributes_filename, pad.products_attributes_is_pin FROM products p LEFT JOIN products_attributes pa ON p.products_id=pa.products_id LEFT JOIN products_attributes_download pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '28' [TEP STOP] I think i followed all the instructions and i uploaded some pins. Unless i have to add more info to upload pins besides the pins themselves??? thanks
×