Jump to content

thpek

Members
  • Content count

    32
  • Joined

  • Last visited

Profile Information

  • Real Name
    Terry Pek
  1. Dear all, I needed this MOD. At the same time, my store is MOD with the register globals turn off MOD. I installed the Order Editor MOD and did not manage to get it to work. My suspicion tells me it has got something to do with register globals variable being turn off. Wonder if their are any experts here that can advise how to get this MOD work together with register globals turn off. Much appreciated for any help offered.
  2. Hi, I like this MOD very much and will need it to modify one of my order. However, I am not php expert and my store is heavily modified. Therefore, would really appreciate if someone is kind enough to provide the step by step guide for the installation rather then to compare with the original file for what is the difference. Thanks and regards, Terry
  3. thpek

    Recover Cart Sales

    Dear Iane, You are simply marvellous. With the indication of the error and your confirmation that the $custid requires register_global to be activated. I have managed to resolve this issue by reading through the register_global MODs again on the portion teaching people how to modify the MODs to work with register_global off. I hope the solution provided below will assist others who have both recover_cart_sales MOD and register_global MOD installed to get it working. Your MOD is simply marvellous. Solution as follows: Backup Backup if need to. Just modify this file catalog/admin/recover_cart_sales.php. Locate this portion: require(DIR_WS_CLASSES . 'currencies.php'); Add this below the sentence: link_post_variable('custid'); It should look like this now: require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); link_post_variable('custid'); $currencies = new currencies(); ---------------------------------------------------------------- It's just that simple. Add link_post_variable('custid'); and the problem is resolved. Cheers everyone :) I am a happy man once again.
  4. thpek

    Recover Cart Sales

    Hi guys, For my previous posting regarding my email portion doesn't work. I manage to narrow down to the portion of the php file which does not work and hope some expert can assist me. Portion of the admin\recover_cart_sales.php file ------------------------------------------------------------------------------------------ <?php // Are we doing an e-mail to some customers? <?php echo 'test'; ?> - Shows as test on the webpage if (count($custid) > 0 ) { ?> <tr> <td class="pageHeading" align="left" colspan=2 width="50%"><? echo HEADING_TITLE; ?> </td> <td class="pageHeading" align="left" colspan=4 width="50%"><? echo HEADING_EMAIL_SENT; ?> </td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap><?php echo TABLE_HEADING_CUSTOMER; ?></td> <td class="dataTableHeadingContent" align="left" colspan="1" width="30%" nowrap> </td> <td class="dataTableHeadingContent" align="left" colspan="1" width="25%" nowrap> </td> <td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td> <td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td> <td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td> </tr><tr> <br></tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap><?php echo TABLE_HEADING_MODEL; ?></td> <td class="dataTableHeadingContent" align="left" colspan="2" width="55%" nowrap><?php echo TABLE_HEADING_DESCRIPTION; ?></td> <td class="dataTableHeadingContent" align="center" colspan="1" width="10%" nowrap> <?php echo TABLE_HEADING_QUANTY; ?></td> <td class="dataTableHeadingContent" align="right" colspan="1" width="10%" nowrap><?php echo TABLE_HEADING_PRICE; ?></td> <td class="dataTableHeadingContent" align="right" colspan="1" width="10%" nowrap><?php echo TABLE_HEADING_TOTAL; ?></td> </tr> <?php foreach ($custid as $cid) { $query1 = tep_db_query("select cb.products_id pid, cb.customers_basket_quantity qty, cb.customers_basket_date_added bdate, cus.customers_firstname fname, cus.customers_lastname lname, cus.customers_email_address email from " . TABLE_CUSTOMERS_BASKET . " cb, " . TABLE_CUSTOMERS . " cus where cb.customers_id = cus.customers_id and cus.customers_id = '".$cid."' order by cb.customers_basket_date_added desc "); $knt = mysql_num_rows($query1); for ($i = 0; $i < $knt; $i++) { $inrec = tep_db_fetch_array($query1); // set new cline and curcus if ($lastcid != $cid) { if ($lastcid != "") { $cline .= " <tr> <td class='dataTableContent' align='right' colspan='6' nowrap><b>" . TABLE_CART_TOTAL . "</b>" . $currencies->format($tprice) . "</td> </tr> <tr> <td colspan='6' align='right'><a href=" . tep_href_link(FILENAME_RECOVER_CART_SALES, "action=delete&customer_id=" . $cid . "&tdate=" . $tdate) . ">" . tep_image_button('button_delete.gif', IMAGE_DELETE) . "</a></td> </tr>\n"; echo $cline; } $cline = "<tr> <td class='dataTableContent' align='left' colspan='6' nowrap><a href='" . tep_href_link(FILENAME_CUSTOMERS, 'search=' . $inrec['lname'], 'NONSSL') . "'>" . $inrec['fname'] . " " . $inrec['lname'] . "</a>".$customer."</td></tr>"; $tprice = 0; } $lastcid = $cid; // get the shopping cart $query2 = tep_db_query("select p.products_price price, p.products_model model, pd.products_name name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_LANGUAGES . " l where p.products_id = '" . $inrec['pid'] . "' and pd.products_id = p.products_id and pd.language_id = " . (int)$languages_id ); $inrec2 = tep_db_fetch_array($query2); $sprice = tep_get_products_special_price( $inrec['pid'] ); if( $sprice < 1 ) $sprice = $inrec2['price']; $tprice = $tprice + ($inrec['qty'] * $sprice); $pprice_formated = $currencies->format($sprice); $tpprice_formated = $currencies->format(($inrec['qty'] * $sprice)); $cline .= "<tr class='dataTableRow'> <td class='dataTableContent' align='left' width='15%' nowrap>" . $inrec2['model'] . "</td> <td class='dataTableContent' align='left' colspan='2' width='55%'><a href='" . tep_href_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $inrec['pid'] . '&origin=' . FILENAME_RECOVER_CART_SALES . '?page=' . $HTTP_GET_VARS['page'], 'NONSSL') . "'>" . $inrec2['name'] . "</a></td> <td class='dataTableContent' align='center' width='10%' nowrap>" . $inrec['qty'] . "</td> <td class='dataTableContent' align='right' width='10%' nowrap>" . $pprice_formated . "</td> <td class='dataTableContent' align='right' width='10%' nowrap>" . $tpprice_formated . "</td> </tr>"; $mline .= $inrec['qty'] . ' x ' . $inrec2['name'] . "\n"; if( EMAIL_USE_HTML == 'true' ) $mline .= ' <blockquote><a href="' . tep_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id='. $inrec['pid']) . '">' . tep_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id='. $inrec['pid']) . "</a></blockquote>\n\n"; else $mline .= ' (' . tep_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id='. $inrec['pid']).")\n\n"; } $cline .= "</td></tr>"; // E-mail Processing - Requires EMAIL_* defines in the // includes/languages/english/recover_cart_sales.php file $cquery = tep_db_query("select * from orders where customers_id = '".$cid."'" ); $email = EMAIL_TEXT_LOGIN; if( EMAIL_USE_HTML == 'true' ) $email .= ' <a HREF="' . tep_catalog_href_link(FILENAME_CATALOG_LOGIN, '', 'SSL') . '">' . tep_catalog_href_link(FILENAME_CATALOG_LOGIN, '', 'SSL') . '</a>'; else $email .= ' (' . tep_catalog_href_link(FILENAME_CATALOG_LOGIN, '', 'SSL') . ')'; $email .= "\n" . EMAIL_SEPARATOR . "\n\n"; if (RCS_EMAIL_FRIENDLY == 'true') $email .= EMAIL_TEXT_SALUTATION . $inrec['fname'] . ","; else $email .= STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n"; if (mysql_num_rows($cquery) < 1) $email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline); else $email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline); $email .= EMAIL_TEXT_BODY_HEADER . $mline . EMAIL_TEXT_BODY_FOOTER; if( EMAIL_USE_HTML == 'true' ) $email .= '<a HREF="' . tep_catalog_href_link('', '') . '">' . STORE_OWNER . "\n" . tep_catalog_href_link('', '') . '</a>'; else $email .= STORE_OWNER . "\n" . tep_catalog_href_link('', ''); $email .= "\n\n". $_POST['message']; $custname = $inrec['fname']." ".$inrec['lname']; $outEmailAddr = '"' . $custname . '" <' . $inrec['email'] . '>'; if( tep_not_null(RCS_EMAIL_COPIES_TO) ) $outEmailAddr .= ', ' . RCS_EMAIL_COPIES_TO; tep_mail('', $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $mline = ""; // See if a record for this customer already exists; if not create one and if so update it $donequery = tep_db_query("select * from ". TABLE_SCART ." where customers_id = '".$cid."'"); if (mysql_num_rows($donequery) == 0) tep_db_query("insert into " . TABLE_SCART . " (customers_id, dateadded, datemodified ) values ('" . $cid . "', '" . seadate('0') . "', '" . seadate('0') . "')"); else tep_db_query("update " . TABLE_SCART . " set datemodified = '" . seadate('0') . "' where customers_id = " . $cid ); echo $cline; $cline = ""; } echo "<tr><td colspan=8 align='right' class='dataTableContent'><b>" . TABLE_CART_TOTAL . "</b>" . $currencies->format($tprice) . "</td> </tr>"; echo "<tr><td colspan=6 align='right'><a href=" . tep_href_link(FILENAME_RECOVER_CART_SALES, "action=delete&customer_id=" . $cid . "&tdate=" . $tdate) . ">" . tep_image_button('button_delete.gif', IMAGE_DELETE) . "</a></td> </tr>\n"; echo "<tr><td colspan=6 align=center><a href=".$PHP_SELF.">" . TEXT_RETURN . "</a></td></tr>"; } else //we are NOT doing an e-mail to some customers { ?> <?php echo 'test'; ?> - Shows as test on the webpage --------------------------------------------------------------------------- What I did was to try echo test at certain portion of the php file and I did not get the test displayed on website at the portion of the php file shown above. That portion happens to be the part for getting info and sending the mail to the customer. I am not a php programmer and know nothing about php except that I learnt some programming before and know abit of troubleshooting. The history of my problem starts after I installed the MOD "register_globals_v1.3". Before this MOD was installed, I did a trial test and the email was sent to my mailbox. After that MOD was installed, I did not perform any further testing as I presume this MOD will still work. However, I am wrong. I strongly felt the "register_globals_v1.3" MOD somehow affected this MOD. Anyone manage to get this MOD worked with "register_globals_v1.3"? Or what could be the contribution to my problem? Any advise will be good. Thank you for reading this posting.
  5. thpek

    Recover Cart Sales

    Hi guys, I monitor closely on the scart table of my database and notice that it does not get updated eventhough I deleted/added an unfinish cart. Could that be part of the reason why my email does not work? The strange thing is that under the tools-> Recover Cart Sales, I manage to see the unfinished cart items. But I do not see the items under the scart table?? Can anyone advise?
  6. thpek

    Recover Cart Sales

    Hi guys, I still can't figure out why I can't use the email notification feature. I notice the email notification feature failed only after I installed the MOD to enable register_global in php.ini file. Could that be the reason? I would appreciate any advise for this.
  7. thpek

    Recover Cart Sales

    Thanks for the advise. I was testing with my trial account all the while. The email sending portion from the website for eg. newsletter or to send email to customer was alright. Except the recover cart sale MOD. Anyone can suggest what could be the possible problem? Check also the log from the mailserver but found no mail sent from my website. Strange :(
  8. thpek

    Recover Cart Sales

    Hi, Guess no one has the same error as mine. So far no response. Still can't figure out why when I click to send email, it does not show the customer is contacted and no email was sent out. I remember it was working initially when I added this MOD. However, as more MODs are added, I did not try the email portion again until recently I saw customer with outstanding cart items and decided to sent them email. That's when I notice this problem. Hope someone can help.
  9. thpek

    Recover Cart Sales

    Hi guys, I am someone who appreciate this MOD. However, the email portion that contacts the customer at the Admin -> Tools portion is not working. Wonder if anyone can assist?
  10. thpek

    Recover Cart Sales

    Hi guys, need some help. The MOD works in some sense but the email notification don't seems to work for my case. When I am at the admin page under the tools section. I saw that there is outstanding cart items. So, I check the box next to the user and click send email. When I check the email, no such email was sent or received. Can someone pls advise what to check out for that might cause this problem? My website is http://www.blueseatackle.com Thanks and regards.
  11. Hi guys, This MOD is great. Now I can monitor who is visiting my website. however, I notice that when I click on the linck to display the time and the page visited by the visitor, it shows nothing. Wonder if any great soul can help. Thanks and regards, thpek
  12. thpek

    Master Products - MS2

    Dear Matti, I have never been so happy as I am stuck with this problem trying to look for solution since 2-3 weeks ago. Due to lack in knowledge of PHP programming, I am so glad that help has finally arrived. You are really great. Thanks again pal. :thumbsup:
  13. thpek

    Master Products - MS2

    Is there anyone that can help with my query? I still unable to figure out how to link my slave products back to master product webpage. Appreciate if there will be any expert to advise how to go about it.
  14. thpek

    Master Products - MS2

    Hi all, I notice something and cannot find the solution in this forum. I installed Master Products and is working fine. However, I notice that is customer will to click on the slave product which the browser will bring the to webpage of the slave products, is there anyway to create a link for the customer to click to go to it's master product without affecting it's SessionID as if I just create a direct link to the master product, all the customer product records will be gone as the SessionID is gone. I am a novice for php and am trying to figure out how can this be done. Pls help. Thanks in advance.
  15. thpek

    Master Products - MS2

    Hi guys, Not to worry about my problem anymore. I have redone my website and skip some of the MODs which I suspected could be the problem. So far, it is working fine. Thanks for all the efforts to help me resolve my problem :)
×