Jump to content

RobAnderson

Members
  • Content count

    58
  • Joined

  • Last visited

Everything posted by RobAnderson

  1. RobAnderson

    Article Manager v1.0

    Hi sparks, in response to: No admin or user control of sorting has been built in (yet...). However, there are three separate listings that can be modified if you wish to change from the default sort option of most recent first. The New Articles listing is set by the query in the articles_new.php page, line 65. At the end of the line, you can modify the order by code and specify a different field to sort by, e.g. order by a.articles_date_added desc, ad.articles_name could be changed to order by ad.articles_name to sort by name instead of the most recent article first (that's what the default a.articles_date_added desc does). Similar modifications could be applied to the All Articles listing in the articles.php page, line 309 or to the Authors/Topics listings in the articles.php page on lines 175, 178, 184 and 187. Hope this helps ;-) Rob
  2. RobAnderson

    Article Manager v1.0

    Hi Dave (again ;-), in response to: This sounds like an install or version problem as I can't think why the article content would not display, nor why there would be no date display. Just curious, but what version of OSC are you using (as some functions may have changed)? This contribution has been written for the 2.2MS2 release (Jul 03), so it may not work properly with earlier versions (MS1) or later snapshots. Rob
  3. RobAnderson

    Article Manager v1.0

    Hi Dave, in response to: TEXT_EMAIL_LINK_ARTICLE should have been added as part of the install, i.e. In includes/languages/english/tell_a_friend.php: Look for: define('TEXT_EMAIL_LINK', 'To view the product click on the link below or copy and paste the link into your web browser:' . "\n\n" . '%s'); Add this immediately below: define('TEXT_EMAIL_LINK_ARTICLE', 'To view the article click on the link below or copy and paste the link into your web browser:' . "\n\n" . '%s'); This should fix the e-mail problem (unless it's something else!). Regards, Rob
  4. RobAnderson

    Article Manager v1.0

    Hi Dave, in response to: This is by design for a couple of reasons. Firstly, the meta-description should be a succinct description of the article and therefore well suited as an article abstract. Whereas, if I just took the frist few hundred characters or so of the article content (articles_description) as the abstract, it might not mean much as a summary of the entire article. Secondly, because the article content (articles_description) might contain images added in using the WYSIWYG editor, I didn't want these appearing in the abstract (kinda ruined the look!). Hence the need to use a different field and so I decided to use the meta-description one (articles_head_desc_tag). Hope this makes sense? Cheers, Rob
  5. RobAnderson

    Article Manager v1.0

    Thanks daithi, my pleasure ;-)
  6. RobAnderson

    Article Manager v1.0

    Hi langers, sorry no live site yet. If you go back to the Article Manager v1.0 Contribution page, you'll find a link to download screen captures of my test site. It shows you how the articles look as well as the admin section. This should help ;-) Rob
  7. RobAnderson

    Article Manager v1.0

    Hi Les, thanks for your favourable comments ;-) About your problem with the Tell a Friend feature, the link that appears in the e-mail you received appears correct, i.e. article_info.php?articles_id=X would be the correct way to reference Article X. So I'm not sure why it might be taking you back to the Tell a Friend page (which is tell_a_friend.php). My suggestion would be to go back through the installation instructions for the Tell a Friend page and check that you got them all. The irony is that this page is the most lengthy to modify in the whole contribution and it's only one small aspect of the Article Manager <grrr>. Also, when testing your Tell a Friend link, make sure you close all browser windows first (might help?). Let me know how you get on, someone else may have some ideas too. Rob ;-)
  8. RobAnderson

    User Tracking with Admin 1.31 Released

    Hi Khim, regarding question 2: This contribution is Admin only, so no box will appear in your shop page. However, I've seen a couple of separate contributions that do display who is online. Try Number of visitors online or Whos Online (maybe a bit old). I haven't tried any of them so I can't vouch for them. Regards, Rob
  9. RobAnderson

    has anyone tried Articles Module v1.0?

    Great contribution! Not sure if this helps, but I recently installed the following mod to approve/reject product reviews: http://www.oscommerce.com/community/contributions,76 It has been recently updated for MS2 and works brilliantly. I imagine it could be adapted for use in the Articles contribution. Good luck, Rob
  10. BTW, here's a small modification I made to the catalog/product_info.php page to show only the number of "approved" reviews. Otherwise, it may be a bit confusing if they see there is a review, but can't read it and don't know the reason is that it hasn't been approved yet. About line 165, find the following code: $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); Replace with $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and approved = '1'"); That simple! Cheers, Rob P.S. Another thing I intend to add is a note to the reviewer that their review won't be displayed until after it has been vetted. Unless someone beats me to it!
  11. Yes, many thanks Lonnie ;-)
  12. For anybody (including myself!) who experienced the following little bug, please find a fix below: In admin/products_availability.php: Replace (about line 29) $sql_data_array = array('products_availability_name' => tep_db_prepare_input($products_availability_array[$language_id]), 'products_availability_id' => $products_availability_id, 'languages_id' => $language_id); if ($action == 'insert') { $insert_sql_data = array('date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS_AVAILABILITY, $sql_data_array); $products_availability_id = tep_db_insert_id(); } elseif ($action == 'save') { $update_sql_data = array('last_modified' => 'now()'); with $sql_data_array = array('languages_id' => $language_id); if ($action == 'insert') { $insert_sql_data = array('products_availability_name' => tep_db_prepare_input($HTTP_POST_VARS['products_availability_name']), 'date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS_AVAILABILITY, $sql_data_array); $products_availability_id = tep_db_insert_id(); } elseif ($action == 'save') { $update_sql_data = array('products_availability_name' => tep_db_prepare_input($products_availability_array[$language_id]), 'last_modified' => 'now()'); Not sure why this fix is necessary (for some), but it works for me! Cheers, Rob
  13. Hi Steve, I've installed your mod and it is working for the most part (Milestone 2.2), although seemed to be missing an entry in product_availability.sql script to add products_availability_id to the Products Table ;-) (unless I missed something in your instructions). I added it manually and it now works. Also, phpmyAdmin which I used to add the SQL script, doesn't seem to like varchar(256) so I changed to varchar(255). One final thing you might be able to help me on. In the Products Availibility admin page whenever I Insert another entry, it only accepts the second character of whatever I type when I Save. When I go back and edit the entry, it accepts whatever I type and saves succesfully that time. It still works OK once I've gone back and edited it, just weird. Not sure if this is related to the mod or my customised OSC site. Any ideas? Cheers, Rob P.S. Thanks for your work on this, a very useful contribution. P.P.S. Small suggestion for others, I added some code to product_info.php to hide the additional products availability row if there is no entry against the product (saves on space). See below: <?php ? ?if (tep_not_null($products_availability_info['products_availability_name'])) { ?> ? ? ? ? ?<tr> ? ? ? ? ? ?<td class="main" align="right" valign="top"></td> ? ? ? ? ? ?<td class="main" align="right" valign="top"><?php echo TEXT_AVAILABILITY; ?>: <?php echo $products_availability_name; ?></td> ? ? ? ? ?</tr> <?php ? ?} ?>
  14. RobAnderson

    User Tracking with Admin 1.31 Released

    This may not affect everyone, but I have noted a few posts about links to recorded hits not working in the User Tracking page, i.e. the links from hits in the left hand-column go nowhere and the right hand column of the table is blank (no URL). Well, it appears this may be due to IIS servers not recognising the REQUEST_URI environment variable (not sure why, but apparently it works on Apache). Either that, or there is some server configuration tweak I am blithely ignorant of (quite likely). In any case, if are using IIS and experiencing this problem, try the following: In includes/functions/user_tracking.php about line 37, replace with Worked for me! Cheers, Rob P.S. This fix has nothing to do with Originating URLs/Referer URLs (that one is an entirely different fix - see Alverman 19th Sep 03) P.P.S. It almost goes without saying, but this is an awesome mod! Many thanks Robert et al ;-)
  15. RobAnderson

    [Contribution] NZ Bank Transfer

    Not sure if anybody has struck this, but I noticed that my NZ Bank Transfer option was not displaying if a customer chose only downloadable products. By comparing this module with the Money Order one (which was displaying) I traced the problem to the use of a delivery address as opposed a billing address as the determinant for whther it showed up or not. By changing all instances of delivery to billing, it now works, e.g. look for $order->delivery ['country']['id'] or $order->delivery['zone_id'] and change to $order->billing['country']['id'] or $order->billing['zone_id'] In any case, I think the use of billing over delivery makes more sense because you would normally only want to offer a payment option of Cheque/Money Order or local Bank Transfer if the payor lives in your own country. In contrast, the delivery address could presumably be outside of your country. Hope this helps ;-) Cheers, Rob
  16. RobAnderson

    Downloads Contoller error!

    Addendum... When I mentioned the "Credit Card" payment type in my previous post, I meant it in the most generic way, i.e. through gateway payment systems like PayPal, Authorize.net, iPayment, 2Checkout, SECPay, WorldPay, etc. These all take credit cards and therefore the funds are "clear", hence downloads would become available immediately (default order status reset to Processing = 2). The basic Credit Card payment system module in OSC is a manual system whereby you take their details securely and process them manually offline. In this case, you would leave the default order status to "default". i.e. normally Pending, until such time as you had been able to process them manually (and confirm valid card/funds etc). Sorry for any confusion! Rob (still v.much a noobie)
  17. RobAnderson

    Downloads Contoller error!

    Hi Brandon, hmmm...I hope I haven't mislead you about PayPal. As far as I know there are some contributions that extend the default Paymet Module for PayPal to include IPN, e.g. http://www.oscommerce.com/community/contributions,1352 There's also a forum topic about this if that helps: http://forums.oscommerce.com/index.php?showtopic=51005 As I don't use this mod, that's about all I can help with sorry ;-( Perhaps someone else can help here who has some experience using this add-on? As for helping out, it's the least I can do. I've only been at this a couple of months and am still very much a noob. But when you're helped by others, you naturally want to do the same ;-) Keep at it! Rob
  18. RobAnderson

    Downloads Contoller error!

    Hi Brandon, glad to be of help ;-) Regarding your questions: If you go into your Admin console, look for Localization and then Orders Status. This where you can insert a new one. As there are normally three by default, the new Status would automatically have a value of 4 (see further down for an explanation of how this is used, but first...) If you go into your Admin console, look for Modules and then Payment. Now for certain payment methods, e.g. Cash on Delivery, Cheque/Money Order or Bank Transfers you do not want to enable downloads until you have received payment. And because the default Set Order Status for each of these is "default", i.e. Order Status value = 1 (normally Pending), then you don't need to do anything. Provided you have installed the Downloads Controller correctly, and left the Downloads Controller Order Status Value in Configuration -> Download set to 2, then you should find that anyone purchasing downloadable products will not able able to download them until the Order Status is set to 2 or higher. This is done manually by the store admin in Customers -> Orders -> Edit once the payment has been received. Now, for other payment methods where money is received instantaneously, e.g. Credit Cards or PayPal, you need to make sure that the Set Order Status is not set to default, i.e. set it to Processing or any other Status that has a value higher than or equal to 2. This way, when someone makes a purchase, downloads are immediately available (and no additional action is required by the store admin). Finally, in case you're not sure what the Downloads Controller Update Status Value in Configuration -> Download does, basically it allows you to reset someone's downloads once their download period has expired or perhaps the've gone past the maximum download attempts. Again, this would be made in Customers -> Orders -> Edit and you would have to select a status that corresponds to the value of this setting (the default is 4). I hope this all makes sense! Once you get your head around it and see it working then you'll be away. Best of luck, Rob P.S. Not sure if you've struck this one yet, but... to make a product downloadable, you have to have a filename entry in a Product Attribute corresponding to your product and a corresponding file in the downloads directory. Come back to me if you can't get this working.
  19. RobAnderson

    Downloads Contoller error!

    Hi there, faced the same problem and managed to nut it out. Basically there was some missing sort fields (atleast from my version). Please find below the code I used to sort it out. Use at your own risk ;-) I know it looks daunting, but just take your time... NOTE: I have taken the opportunity to make some other minor modifications, e.g. removed preview image (because you can click on the row instead), added in the Order ID column, changed some of the sort options and basically rearranged how the sort buttons were arranged. Hope it works for you - IT IS GREAT MOD and worth perservering with! (tx Linda ;-) In /admin/orders.php About line 20 Replace $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'"); with $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "' order by orders_status_id"); About line 387 replace <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><a href="<?php echo "$PHP_SELF?listing=customers"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_CUSTOMERS . ' --> A-B-C From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=customers-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_CUSTOMERS . ' --> Z-X-Y From Top '); ?></a><br><?php echo TABLE_HEADING_CUSTOMERS; ?></td> <td class="dataTableHeadingContent"><a href="<?php echo "$PHP_SELF?listing=ottotal"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_ORDER_TOTAL . ' --> 1-2-3 From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=ottotal-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_ORDER_TOTAL . ' --> 3-2-1 From Top '); ?></a><br><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td> <td class="dataTableHeadingContent" align="right"><a href="<?php echo "$PHP_SELF?listing=id-asc"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_DATE_PURCHASED . ' --> 1-2-3 From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=id-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_DATE_PURCHASED . ' --> 3-2-1 From Top '); ?></a><br><?php echo TABLE_HEADING_DATE_PURCHASED; ?> <td class="dataTableHeadingContent" align="right"><a href="<?php echo "$PHP_SELF?listing=status-asc"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_STATUS . ' --> 1-2-3 From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=status-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_STATUS . ' --> 3-2-1 From Top '); ?></a><br><?php echo TABLE_HEADING_STATUS; ?> </td><td class="dataTableHeadingContent" align="right"><br><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> with <tr class="dataTableHeadingRow"> //Missing sort fields <?php switch ($listing) { case "orders": $order = "o.orders_id"; break; case "orders": $order = "o.orders_id DESC"; break; case "customers": $order = "o.customers_name, o.orders_id DESC"; break; case "customers-desc": $order = "o.customers_name DESC, o.orders_id DESC"; break; case "order_total": $order = "ot.value"; break; case "order_total-desc": $order = "ot.value DESC"; break; case "date_purchased": $order = "o.date_purchased, o.customers_name"; break; case "date_purchased-desc": $order = "o.date_purchased DESC, o.customers_name"; break; case "order_status": $order = "s.orders_status_id, o.customers_name"; break; case "order_status-desc": $order = "s.orders_status_id DESC, o.customers_name"; break; default: $order = "o.orders_id DESC, o.customers_name"; } ?> <td class="dataTableHeadingContent" align="center"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="2" align="center" class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ORDERS; ?> </td> <td align="right" valign="bottom"> <a href="<?php echo "$PHP_SELF?listing=orders"; ?>"><?php echo tep_image_button('ic_up.gif', 'Sort ' . TABLE_HEADING_ORDERS . ' Ascending', 'hspace="3"'); ?></a><br><a href="<?php echo "$PHP_SELF?listing=orders-desc"; ?>"><?php echo tep_image_button('ic_down.gif', 'Sort ' . TABLE_HEADING_ORDERS . ' Descending', 'hspace="3"'); ?></a> </td> <tr> </table> </td> <td class="dataTableHeadingContent" align="center"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="2" align="left" class="dataTableHeadingContent"> <?php echo TABLE_HEADING_CUSTOMERS; ?> </td> <td align="right" valign="bottom"> <a href="<?php echo "$PHP_SELF?listing=customers"; ?>"><?php echo tep_image_button('ic_up.gif', 'Sort ' . TABLE_HEADING_CUSTOMERS . ' Ascending', 'hspace="3"'); ?></a><br><a href="<?php echo "$PHP_SELF?listing=customers-desc"; ?>"><?php echo tep_image_button('ic_down.gif', 'Sort ' . TABLE_HEADING_CUSTOMERS . ' Descending', 'hspace="3"'); ?></a> </td> <tr> </table> </td> <td class="dataTableHeadingContent" align="center"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="2" align="right" class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ORDER_TOTAL; ?> </td> <td align="right" valign="bottom"> <a href="<?php echo "$PHP_SELF?listing=order_total"; ?>"><?php echo tep_image_button('ic_up.gif', 'Sort ' . TABLE_HEADING_ORDER_TOTAL . ' Ascending', 'hspace="3"'); ?></a><br><a href="<?php echo "$PHP_SELF?listing=order_total-desc"; ?>"><?php echo tep_image_button('ic_down.gif', 'Sort ' . TABLE_HEADING_ORDER_TOTAL . ' Descending', 'hspace="3"'); ?></a> </td> <tr> </table> </td> <td class="dataTableHeadingContent" align="center"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="2" align="center" class="dataTableHeadingContent"> <?php echo TABLE_HEADING_DATE_PURCHASED; ?> </td> <td align="right" valign="bottom"> <a href="<?php echo "$PHP_SELF?listing=date_purchased"; ?>"><?php echo tep_image_button('ic_up.gif', 'Sort ' . TABLE_HEADING_DATE_PURCHASED . ' Ascending', 'hspace="3"'); ?></a><br><a href="<?php echo "$PHP_SELF?listing=date_purchased-desc"; ?>"><?php echo tep_image_button('ic_down.gif', 'Sort ' . TABLE_HEADING_DATE_PURCHASED . ' Descending', 'hspace="3"'); ?></a> </td> <tr> </table> </td> <td class="dataTableHeadingContent" align="center"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="2" align="left" class="dataTableHeadingContent"> <?php echo TABLE_HEADING_STATUS; ?> </td> <td align="right" valign="bottom"> <a href="<?php echo "$PHP_SELF?listing=order_status"; ?>"><?php echo tep_image_button('ic_up.gif', 'Sort ' . TABLE_HEADING_STATUS . ' Ascending', 'hspace="3"'); ?></a><br><a href="<?php echo "$PHP_SELF?listing=order_status-desc"; ?>"><?php echo tep_image_button('ic_down.gif', 'Sort ' . TABLE_HEADING_STATUS . ' Descending', 'hspace="3"'); ?></a> </td> <tr> </table> </td> <td class="dataTableHeadingContent" align="right"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> About line 394 Replace <?php if (isset($HTTP_GET_VARS['cID'])) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } elseif (isset($HTTP_GET_VARS['status'])) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by $order"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } with <?php if (isset($HTTP_GET_VARS['cID'])) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, s.orders_status_id, ot.value, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } elseif (isset($HTTP_GET_VARS['status'])) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, s.orders_status_id, ot.value, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by $order"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, s.orders_status_id, ot.value, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } About line 417 Replace <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td> <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td> <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td> <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td> <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> with <td class="dataTableContent" align="center"><?php echo strip_tags($orders['orders_id']); ?></td> <td class="dataTableContent" align="left"><?php echo strip_tags($orders['customers_name']); ?></td> <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td> <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td> <td class="dataTableContent" align="left"><?php echo $orders['orders_status_name']; ?></td> <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> Also, add to /admin/includes/languages/english/orders.php the following line: define('TABLE_HEADING_ORDERS', 'Order'); Finally, I couldn't find any ic_up.gif and ic_down.gif images in the Download Controller contribution so made my own (store in /admin/includes/languages/english/images/buttons/) Regards, Rob
  20. RobAnderson

    Invision Power Board Intergration Into OSC

    Hi, the iframe solution is nice, but horizontal and vertical scrollbars are a bit of a pain (especially when threads get long). Any thoughts on the feasibility of wrapping the Invision Board within the OSC Header and Footers (I am not too interested in the side columns). This way you could display the forums without scrollbars, yet retain the same look & feel with your site's headers and footers (and perhaps breadcrumbs/navigation tabs, etc). I briefly tried to to this from the Invision Control Panel (Skins & Templates > HTML Templates > Mange HTML > Global HTML Elements > Board Headers), but it doesn't seem to execute php commands in the code, e.g. to include OSC headers. Am I missing something??? Any ideas about this approach appreciated ;-)
  21. RobAnderson

    [Contribution] NZ Bank Transfer

    Well, seeing as I started this whole thread, about time I pitched in again! Thanks to Sandy for the suggestion to remove the line below: $this->enabled = ((MODULE_PAYMENT_AUS_BANK_STATUS == 'True') ? true : false); I did this and it now works OK. I now see the NZ Bank Transfer option in the payment options and it delivers e-mails fine. Not sure why...but I aint complaining. Thanks a heap to all who have given their time and contributed to this thread. Cheers, Rob
  22. RobAnderson

    Event Calender

    Yay, managed to fix my earlier problem relating to installing the Event Calendar on MS2.2: Fatal error: Cannot pass parameter 3 by reference in .../catalog/events_calendar.php on line 323 Basically, I replaced one of the files modified (/catalog/includes/classes/split_page_results.php) in the Event Calendar contribution with it's unmodifed version from an earlier backup. Not sure exactly what part of the code wasn't working, but am happy now that my Calendar works ;-) Hope this helps someone else...Rob
  23. RobAnderson

    Event Calender

    Thanks Matt, I tried your fix and it bunny-hopped the problem along a few pages and lines of code. I don't want to waste your time with this, there must be something fundamentally wrong with my setup. Perhaps other contributions I've installed are conflicting. I guess that 's what you get when you're a noob. Cheers anyway, Rob P.S. I'm trying to get the Event Calendar contribution working with MS2.2. http://www.oscommerce.com/community/contributions,1061
  24. RobAnderson

    Event Calender

    I too am having the following problem, would appreciate any suggestions (running 2.2) This error appears whenever I try to view a month's worth of events (the go button) or click on the Events Calendar link at the top of the control. I can, however view the full year page and individually loaded events. It appears to relate to this function: $events_split = new splitPageResults($events_query_raw, MAX_DISPLAY_NUMBER_EVENTS, 'DAYOFMONTH(start_date)'); I feel I am so close! Any suggestions greatly appreciated ;-) Regards, Rob
  25. RobAnderson

    [Contribution] NZ Bank Transfer

    Sounds like a useful contribution. I've installed it and configured it in the admin section (2.2MS2) but when I test it in Catalog no extra payment option appears at the Payment Information stage. The customer I am using has New Zealand as the countryand I have a New Zealand Zone assigned in the NZ Bank Transfer details. (The zone works OK with my NZ GST option). Any ideas why this payment option does not appear? Any help greatly appreciated :) Rob P.S. I am a noobie at oscommerce, so hope I'm not forgetting something really stupid.
×