Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

About MDBA

  • Birthday 12/01/1950

Profile Information

  1. Ok, thank you for your patience AND assistance George. As it turns out, I discovered the reason for my initial failure at this. I stumbled across it as I was implementing your suggestions. I had another Jscript in my <head> that was conflicting with Shadowbox. By putting the Shadowbox init BELOW the existing script, everything worked. So, on that, I reverted back to my original installation and all is good. So….long story short, here’s what I did. Download contribution 5852, (Shadowbox Product_Info/Product Description Functionality) I used the src files and ignored the instructions for product_info etc. All I wanted were the source codes. I have no idea what the differences are between these and the Build 3.0 versions from the shadowbox site but file size differences are huge. When I have time I’ll do a file compare but for now, I’m happy to leave well enough alone and get on with other work. So, instructions to have SB in STS are as follows. From contribution 5852, copy the src directory to your template folder in its entirety. Copy the flvplayer file to the root of your template directory if you plan to use SB for flash files. (I believe that is its purpose) In the head of your template file, whether sts_template.html or index.php.html or any other, copy the following……….. <link rel="stylesheet" type="text/css" href="$templatedir/src/css/shadowbox.css"> <script type="text/javascript" src="$templatedir/src/js/lib/yui-utilities.js"></script> <script type="text/javascript" src="$templatedir/src/js/adapter/shadowbox-yui.js"></script> <script type="text/javascript" src="$templatedir/src/js/shadowbox.js"></script> <script type="text/javascript"> window.onload = function(){ Shadowbox.init(); }; </script> The link code I used to open another site was …… <a rel="shadowbox;width=850;" class="headerNavigation" title="Whatever You want" href="http://www.domain.com/">LINK</a> Class obviously is specific to your site. I found no need to alter the page type in either index.php (The osc file) or index-php.html Below works <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" However, if you have issues with ie7, use <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> I did use it. Just to be safe I think that’s it. The contribution has instructions for using SB in product_info if you wish. Not sure how it would work with a content template. Only one issue I can see after testing in IE, Firefox, Opera, Safari and Chrome.(all current versions) In IE7 (Some versions only) and IE8, (It happens with me and I’m using IE8 8.0.6001.18702) the SB will open at the top of the window, not the viewing port. So if the link is at the top of your viewing port after scrolling down the page, and you open SB, you have to scroll back up to see it. In all other browsers, it opens in the centre of the viewing port. I found a supposed fix in the SB forum but I’ll be buggered if I understand it. Maybe someone else can explain it. I repeat it here exactly as written Now, only thing left for me on this job is work out how to have 2 scripts on the one page so they don't conflict. Here's what I have at present. <link rel="stylesheet" type="text/css" href="$templatedir/stylesheet.css"> <link rel="stylesheet" type="text/css" href="$templatedir/gallerystyle.css"> <script type="text/javascript" src="$templatedir/js/motiongallery.js"> </script> <link rel="stylesheet" type="text/css" href="$templatedir/src/css/shadowbox.css"> <script type="text/javascript" src="$templatedir/src/js/lib/yui-utilities.js"></script> <script type="text/javascript" src="$templatedir/src/js/adapter/shadowbox-yui.js"></script> <script type="text/javascript" src="$templatedir/src/js/shadowbox.js"></script> <script type="text/javascript"> window.onload = function(){ Shadowbox.init(); }; </script> Only the last one will work, regardless of which script that is. Any ideas?
  2. Hi Bill, No content templates being used. I'm actually trying to open Shadow box from index.php_0.html Thanks George, I'm posting just to let you know I saw your post. Bit pushed for time but I'm working my way through your post and trying to apply what you've written. I'll come back here when I have some news. Cheers Jim
  3. Hi guys, I'm kindof tearing my hair out here. Need some help. I'm having a ball with STS. Can't imagine how people get along without it. I used a well known contribution to also use Lightbox with STS and ultrapics. All works well, as designed to do. But I NEED to use Shadowbox instead because I have to open non-image targets into it. Only Shadowbox allows me to do that. Should be easy enough. Just copy how the guy who integrated Lightbox into STS did it and substitute Shadowbox files instead. Nup....No good. Shadow box works fine with templates turned off. Turn them on however and no go. I've done a file compare of the View Source codes to see where the difference is. There isn't any. I've put the usual <script> code at the top of my template file. Browser is finding the actual source files (According to View Source) I've scoured various STS files to find some reference to Lightbox to see if I'm supposed to define it somewhere but no luck. No luck in searching these forums or Addons site. Can anybody point me in the right direction please?
  4. MDBA

    Multi_Vendor_Shipping new thread

    This appears to be a bug caused by newer versions of PHP. It was originally reported in THIS POST and responded to in THIS POST. This was all only a few weeks ago. I'm sure in time a solutions will be found. Any assistance towards this goal is always welcome. I'm afraid my own skills don't stretch that far. Being open source means inevitably, solutions are found, but often, patience is required.
  5. MDBA

    Multi_Vendor_Shipping new thread

    Purely for the benefit of any future users of MVS that find the same formating issue with their vendor emails I offer the following solution. Its not a bug at all, merely an over sight. Turn on HTML emails in Configure>Email Options and its all good. By default, this is turned off in a virgin osC install. An easy thing to overlook but this may prevent another user scratching their heads wondering what they've done wrong.
  6. MDBA

    Multi_Vendor_Shipping new thread

    MDBA wrote...... kymation replied...... I have both vendors set to receive e-mails at 'pending' Both e-mails sent and received ok. Everything working A-OK in that regard. This is merely a discrepency in the admin in so much as it is being reported that emails have NOT been sent when in fact they have. Below is a screen shot. In looking at the coding for orders.php, it appears to be querying vendor_order_sent in TABLE orders_shipping to determine what to put in the page for this section. default = no In my DB the entry is in fact still 'no', therefore this page is reporting correctly. The information itself in the DB is incorrect. I would assume the DB entry is supposed to be updated in the front end when the order is processed so the error must be there. Presumably. The only other thing I can fault, apart from the vendor_email_send.php which you have already explained you are aware of, is the packing slips for each vendor. The stock osC packing slip function is working correctly. The individual vendor ones produced by vendor_packingslip.php however are blank in the area where product information is supposed to be. The header with shipping address etc is fine. I hadn't noticed this earlier. This individual packing slip for each vendor function does however raise a question in my mind as to exactly how it was intended it be used. In a live shop in a true drop shipping scenario, the outside vendor would need to be sent this packing slip to enclose with their part of the order. Have you ever considered looking at a way of doing this via email? For example, converting it to a pdf that could be attached to an email. It's just a thought, or suggestion. So in summary, its just the send vendor email function that remain unresolved. All other problems I reported are now functional and I thank you most sincerely for your prompt attention. Its a huge load off my mind. Cheers Jim
  7. MDBA

    Multi_Vendor_Shipping new thread

    That is fantastic news on my part. It appears there may be a light at the end of the tunnel. I look forward to further news. Thank you Jim
  8. MDBA

    Multi_Vendor_Shipping new thread

    I’m having some issues with my installation of MVS that I could really do with some help on. This is not my first OsC site and I consider myself reasonably competent, but I’m a hacker, not a coder. Please bear that in mind. Because MVS is a critical part of the site I am working on and wanting to adapt the Aust Post modules to it, I decided to start with MVS on a virgin install of 2.2rc2a. Once I was confident everything was working correctly, then I could have a go a modding the Aust Post modules. If they didn’t work, then I knew the problem was with my mods only. But I got stuck getting MVS to work. I have now spent many, many days searching this forum and following leads but all to no avail. The only other references to anything resembling my problem has been in conjunction with other shipping modules and a PayPal module. Nothing on a clean install. Which leads me to believe there isn’t a bug, but that I’ve stuffed up somewhere. But where? I’m working on a global register off server for the first time, but I understand RC2 will work. Just in case though, I applied the patches. No good, so I re-installed again without the patches. I tried comparing files instead of overwriting. No differences spotted. Now, this certainly isn’t the first time I’ve installed a contribution unsuccessfully. But in the past, it merely meant I had stuffed up the instructions somewhere and going back through the task carefully usually found the problem. If that failed, a search of the forum usually found someone with a similar problem and the solution is found. But in this case, I’m stumped. I have a long list of other contributions to install for this site and I cannot start until I know MVS is ok. So, I offer the following info. OsC version is 2.2rc2a Contribution version is 1.2.1 (Dated 8th June 2009) PHP version 5.2.9 Database: MySQL 5.0.81-community Zones are disabled in Admin (Have tried both ways.) Vendors installed: Default My Store & Test Vendor Shipping modules installed. Flat rate for My Store and Per Item for Test Vendor. (I figured these two would be bullet proof and neither needs zones.) Obviously Enable Vendor Shipping is set to “true” Admin……. prods_by_vendor.php shows “My Store’s” products only when accessed from the left column vendors box. Select test vendor from drop down list and page refreshes but still shows only My Store. Actual product list seems correct. Change a product from My Store to Test Vendor in categories.php and that product no longer appears in My Store list. Access the same page from the link in vendors.php where it says “Click here for Products Report” and it works fine. As a work around, I could remove the link in the vendors box in the left column but I’d rather see if we can find out what’s wrong as this may be a symptom of something affecting other areas. In orders_by_vendor.php, when accessed from the left column link, nothing shows in the area where orders are supposed to be regardless of which vendor is chosen. If you hover over either the “Filter By Email: YES/NO” or “change to ascending or descending” the target URL = http://www.mysite.au/admin/orders_by_vendo...sc&sent=yes Note vendor ID. The only item showing in the table is the link to send email, but it is not a link as it should be. However, if you access the same page via the button on vendors.php, the name of the vendors appears on the left hand side. Otherwise, the table is blank as before. Sorry, I cannot provide any more clues here. move_vendor_prods.php doesn’t work, but I’m not concerned. This client has no need for it. I mention it only if there is a further clue there. Two test orders made on front end. One for My Store and one for Test Vendor. In orders.php, both orders state Order email sent to My Store (or Test Vendor) = No But both emails sent ok at front end. Both packing slip and invoice appear correct. In edit form, the notification of whether an e-mail has been sent always states “no”, regardless of whether its been sent or not. Clicking on the link to vendor_email_send.php produces a blank email. Attempting to send just returns you to the email page. No email is sent. The link produced to enter this page is…. http://www.mysite.net.au/admin/vendor_emai...ID=8&vOS=no In the front end…… Shipping estimate From product_info.php, not logged in, single item from vendor #1 (My Store) or vendor #2 (Test Vendor) = ok URL = http://www.mysite.net.au/products_ship_estimator.php?pid=22 (Product id 22 = Unreal Tournament in virgin install) From shopping cart info box and shopping cart page, same product, same vendors. Initial quote ok because script remembers previous postcode, but once change of address requested = no go. URL = http://www.mysite.net.au/ship_estimator.php?pid=0 Resultant URL (After change of address = http://www.mysite.net.au/ship_estimator.ph...tion=ship_error In cases where URL indicates error, the close window gif doesn’t appear either, but shows when everything works ok. Coincidence? A clue to problem? I have no idea. But clearly, it’s not picking up the product id. Once logged in, all works ok, but there’s no “Change Address” button. Is there supposed to be? Close window gif doesn’t show again. All else in the front end works. Both vendors are set to receive email at Pending and both arrive ok. Formatting of vendors email a bit messed up but I think I can deal with that. Seems to need some <br> tags here and there. Not a priority yet. Please somebody. I could really do with some help here because the project is dead in the water until I solve these issues and I have no idea where to look next. My apologies for the long post. I wanted to make sure I covered everything and offered any info that might be needed. Cheers Jim
  9. MDBA

    Multi_Vendor_Shipping new thread

    Well, thanks for trying to help anyway. I'll just soldier on I think. I reckon we can live without the automatic email. Just have to remember to send them one manually in Admin. Now I'm off to try to integrate your module code changes in the Australia Post shipping module. Wish me luck. Cheers Jim
  10. MDBA

    Multi_Vendor_Shipping new thread

    Jim, thankyou for taking the time to try and help. This is a virgin install of oscommerce-2.2ms2. There are no other mods. This is a developement site I use whenever trialing one of the more involved contributions such as MVS. The ONLY changes from dead standard are the files provided in this contribution, vers 1.1 The second oldest section on the contribution page. So.....There is no other code to interfere. Ok...down to business. I tried your suggestion and then purchased an item I'd allocated to a fictional vendor. Instead of the success message after confirming the order I received the following error message..... Mail sent! Warning: Cannot modify header information - headers already sent by (output started at /home/mdbanet/public_html/osc2ms2/checkout_process.php:273) in /home/mdbanet/public_html/osc2ms2/includes/functions/general.php on line 33 I received the email delivered to the purchaser, and the one normally sent from admin in a standard OsC installation to let the shop owner know an order has been received, but no email to the vendor. The relevant section of checkout_process.php is as follows. (With your suggested Print mail sent line still intact) //MVS begin if (SELECT_VENDOR_EMAIL_OPTION == 'false') { $products_ordered .= $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']) . $products_ordered_attributes . "\n"; } } if (SELECT_VENDOR_EMAIL_OPTION == 'true') { $order_id = $insert_id; require(DIR_WS_INCLUDES . 'vendor_order_data.php'); } function vendors_email($vendors_id, $oID, $status, $vendor_order_sent) { print 'Mail sent!'; $vendor_order_sent = false; $debug='no'; $vendor_order_sent = 'no'; $index2 = 0; //let's get the Vendors $vendor_data_query = tep_db_query("select v.vendors_id, v.vendors_name, v.vendors_email, v.vendors_contact, v.vendor_add_info, v.vendor_street, v.vendor_city, v.vendor_state, v.vendors_zipcode, v.vendor_country, v.account_number, v.vendors_status_send, os.shipping_module, os.shipping_method, os.shipping_cost, os.shipping_tax, os.vendor_order_sent from " . TABLE_VENDORS . " v, " . TABLE_ORDERS_SHIPPING . " os where v.vendors_id=os.vendors_id and v.vendors_id='" . $vendors_id . "' and os.orders_id='" . (int)$oID . "' and v.vendors_status_send='" . $status . "'"); while ($vendor_order = tep_db_fetch_array($vendor_data_query)) { $vendor_products[$index2] = array('Vid' => $vendor_order['vendors_id'], 'Vname' => $vendor_order['vendors_name'], 'Vemail' => $vendor_order['vendors_email'], 'Vcontact' => $vendor_order['vendors_contact'], 'Vaccount' => $vendor_order['account_number'], 'Vstreet' => $vendor_order['vendor_street'], 'Vcity' => $vendor_order['vendor_city'], 'Vstate' => $vendor_order['vendor_state'], 'Vzipcode' => $vendor_order['vendors_zipcode'], 'Vcountry' => $vendor_order['vendor_country'], 'Vaccount' => $vendor_order['account_number'], 'Vinstructions' => $vendor_order['vendor_add_info'], 'Vmodule' => $vendor_order['shipping_module'], 'Vmethod' => $vendor_order['shipping_method']); if ($debug == 'yes') { echo 'The vendor query: ' . $vendor_order['vendors_id'] . '<br>'; } $index = 0; $vendor_orders_products_query = tep_db_query("select o.orders_id, o.orders_products_id, o.products_model, o.products_id, o.products_quantity, o.products_name, p.vendors_id, p.vendors_prod_comments, p.vendors_prod_id, p.vendors_product_price from " . TABLE_ORDERS_PRODUCTS . " o, " . TABLE_PRODUCTS . " p where p.vendors_id='" . (int)$vendor_order['vendors_id'] . "' and o.products_id=p.products_id and o.orders_id='" . $oID . "' order by o.products_name"); while ($vendor_orders_products = tep_db_fetch_array($vendor_orders_products_query)) { $vendor_products[$index2]['vendor_orders_products'][$index] = array( 'Pqty' => $vendor_orders_products['products_quantity'], 'Pname' => $vendor_orders_products['products_name'], 'Pmodel' => $vendor_orders_products['products_model'], 'Pprice' => $vendor_orders_products['products_price'], 'Pvendor_name' => $vendor_orders_products['vendors_name'], 'Pcomments' => $vendor_orders_products['vendors_prod_comments'], 'PVprod_id' => $vendor_orders_products['vendors_prod_id'], 'PVprod_price' => $vendor_orders_products['vendors_product_price'], 'spacer' => '-'); //MVS end if ($debug == 'yes') { echo 'The products query: ' . $vendor_orders_products['products_name'] . '<br>'; } $subindex = 0; $vendor_attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$oID . "' and orders_products_id = '" . (int)$vendor_orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($vendor_attributes_query)) { while ($vendor_attributes = tep_db_fetch_array($vendor_attributes_query)) { $vendor_products[$index2]['vendor_orders_products'][$index]['vendor_attributes'][$subindex] = array('option' => $vendor_attributes['products_options'], 'value' => $vendor_attributes['products_options_values'], 'prefix' => $vendor_attributes['price_prefix'], 'price' => $vendor_attributes['options_values_price']); $subindex++; } } $index++; } $index2++; // let's build the email // Get the delivery address $delivery_address_query = tep_db_query("select distinct delivery_company, delivery_name, delivery_street_address, delivery_city, delivery_state, delivery_postcode from " . TABLE_ORDERS . " where orders_id='" . $oID ."'"); $vendor_delivery_address_list = tep_db_fetch_array($delivery_address_query); if ($debug == 'yes') { echo 'The number of vendors: ' . sizeof($vendor_products) . '<br>'; } $email=''; for ($l=0, $m=sizeof($vendor_products); $l<$m; $l++) { $vendor_country = tep_get_country_name($vendor_products[$l]['Vcountry']); $order_number= $oID; $vendors_id=$vendor_products[$l]['Vid']; $the_email=$vendor_products[$l]['Vemail']; $the_name=$vendor_products[$l]['Vname']; $the_contact=$vendor_products[$l]['Vcontact']; $email= '<b>To: ' . $the_contact . ' <br>' . $the_name . '<br>' . $the_email . '<br>' . $vendor_products[$l]['Vstreet'] .'<br>' . $vendor_products[$l]['Vcity'] .', ' . $vendor_products[$l]['Vstate'] .' ' . $vendor_products[$l]['Vzipcode'] . ' ' . $vendor_country . '<br>' . '<br>' . EMAIL_SEPARATOR . '<br>' . 'Special Comments or Instructions: ' . $vendor_products[$l]['Vinstructions'] .'<br>' . '<br>' . EMAIL_SEPARATOR . '<br>' . 'From: ' . STORE_OWNER . '<br>' . STORE_NAME_ADDRESS . '<br>' . 'Accnt #: ' . $vendor_products[$l]['Vaccount'] . '<br>' . EMAIL_SEPARATOR . '<br>' . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . '<br>' . EMAIL_SEPARATOR . '<br>' . '<br> Shipping Method: ' . $vendor_products[$l]['Vmodule'] . ' -- ' . $vendor_products[$l]['Vmethod'] . '<br>' . EMAIL_SEPARATOR . '<br>' . '<br>Dropship deliver to:<br>' . $vendor_delivery_address_list['delivery_company'] .'<br>' . $vendor_delivery_address_list['delivery_name'] .'<br>' . $vendor_delivery_address_list['delivery_street_address'] .'<br>' . $vendor_delivery_address_list['delivery_city'] .', ' . $vendor_delivery_address_list['delivery_state'] . ' ' . $vendor_delivery_address_list['delivery_postcode'] . '<br><br>'; $email = $email . '<table width="75%" border=1 cellspacing="0" cellpadding="3"> <tr><td>Qty:</td><td>Product Name:</td><td>Item Code/Number:</td><td>Product Model:</td><td>Per Unit Price:</td><td>Item Comments: </td></tr>'; for ($i=0, $n=sizeof($vendor_products[$l]['vendor_orders_products']); $i<$n; $i++) { $product_attribs =''; if (isset($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) && (sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']) > 0)) { for ($j = 0, $k = sizeof($vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes']); $j < $k; $j++) { $product_attribs .= ' ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['option'] . ': ' . $vendor_products[$l]['vendor_orders_products'][$i]['vendor_attributes'][$j]['value'] . '<br>'; } } $email = $email . '<tr><td> ' . $vendor_products[$l]['vendor_orders_products'][$i]['Pqty'] . '</td><td> ' . $vendor_products[$l]['vendor_orders_products'][$i]['Pname'] . '<br> <i>Option<br> ' . $product_attribs . '</td><td> ' . $vendor_products[$l]['vendor_orders_products'][$i]['PVprod_id'] . '</td><td> ' . $vendor_products[$l]['vendor_orders_products'][$i]['Pmodel'] . '</td><td> ' . $vendor_products[$l]['vendor_orders_products'][$i]['PVprod_price'] . '</td><td>' . $vendor_products[$l]['vendor_orders_products'][$i]['Pcomments'] . '</b></td></tr>'; } } $email = $email . '</table><br><HR><br>'; tep_mail($the_name, $the_email, EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID , $email . '<br>', STORE_NAME, STORE_OWNER_EMAIL_ADDRESS) ; $vendor_order_sent = 'yes'; tep_db_query("update " . TABLE_ORDERS_SHIPPING . " set vendor_order_sent = '" . tep_db_input($vendor_order_sent) . "' where orders_id = '" . (int)$oID . "' and vendors_id = '" . (int)$vendors_id . "'"); if ($debug == 'yes') { echo 'The $email(including headers:<br>Vendor Email Addy' . $the_email . '<br>Vendor Name' . $the_name . '<br>Vendor Contact' . $the_contact . '<br>Body--<br>' . $email . '<br>'; } } return true; } //MVS end Does anything jump out at you here? Cheers Jim
  11. MDBA

    Multi_Vendor_Shipping new thread

    Anwered by Craig It looks like there's at least 2 instances now of the auto email not working. We never heard back from mithereal so I don't know if he ever found the answer. This thing has me bugged. I've been working on an OsC site for over 2 years now and although I'm definitely no programmer I've had reasonable success in installing numerous contributions. The list in my signature is WAY out of date. When I start one as involved as MVS I always start with a bare bones original copy of OsC. In my case thats osc2 ms2 Once I see the contrib working correctly, I then re-install the existing contribs on the affected pages. I have merely FTP'ed the provided pages in MVS 1.1 to my server. And the auto emails don't work. I've entered "true" to "Enable Vendor Shipping" & "Use optional confirmation Email" "When to send the vendor email" is Both It works if I do it manually in Admin. What have I forgotten? It's clearly not a bug otherwise many more would have asked here. There has been no patching so no dumb mistakes there. Where else do I look? It HAS to be something dumb I've forgotten, but what?
  12. Thanks Alex, I'll give it a go. In our case, I think it's going to be a necessity. Cheers Jim
  13. You replied Purely to let you know....Your contribution and Member Approval work together beautifully and with no modification required Everything now installed, and first impressions are that everything is working as it should. I've had a couple of issues but the first rule of installing contributions got me out of trouble. "If all else fails, re-read the instructions" Works 99 times out of 100. Alex....just a couple of questions please. Am I missing something? or is there no way to edit the forum username? Its not in account_edit or profile.php. I realise its not usually an option in a standard PhpBB installation but I was wondering if you knew of any reason for this? How hard would it be to add it into catalog/account_edit? Also, it would be very useful to have at least a read-only field for username in admin/customers.php Before I go hacking in my usual manner, can you assist in any way?
  14. Fair enough. I'll suck it and see. This suggests to me that what I have in mind is not the ideal. What would a better way to set it up be, if any? Thankyou I read all 10 pages of this thread prior to posting but I must admit by page 7 I was skimming. I missed it. Got it now. Thank you for your time.
  15. Alex….. First may I say, after 2 years of working with OsC and investigating more contributions than I care to remember….NEVER, have I seen a better presented installation guide. You seem to have put almost as much effort into this aspect as you have the contribution itself. Congratulations on a job well done. With so much info made available I’m embarrassed to admit I still have a question or two. Our site is membership based. I have used Contribution Member_Approval_v1.5_1 (http://www.oscommerce.com/community/contributions,1339/category,all/search,Member_Approval_v1.5_1) to enable us to approve of all applications before they can purchase or view selected “Members Only” pages. We also have phpBB 2.0.18 installed and have configured it so that only registered members can view any forum. I’ve done this via the groups function. All new member applicants must apply via the OsC create_account.php page first. Once approved, we then ask them to apply to join our forum. Approval is automatic of course but in our control. Quite obviously, this is not a very satisfactory method. Your contribution almost has our name on it as just what the doctor ordered. But….. At the bottom of your instructions you write….. ” Visual confirmation is of little interest but account activation is vital. I fail to see how your other contribution, “mail validation” will assist us. I’m trying to visualise the result of your contribution. Do you see any conflict with our member approval process? If no, would approval in OsC automatically approve them for phpBB? It’s imperative that members of the public cannot follow a link to the forum so only registered members can view the forums. Would this function still work? Lastly, how important is the relative path between OsC and phpBB? Our main site is mydomain.net.au Our forum is mydomain.net.au/forum/ I have created a subdomain of test.mydomain.net.au The test forum is therefore test.mydomain.net.au/forum This sub domain uses two separate databases from the main site. I install all new contributions here first and once they work, copy entire files across to the main site. Can you see any possible hiccups using this procedure with your contribution? Lastly…since both phpBB and Osc now share one database, how do I transfer existing info from our current phpBB database into the new one or will we have to start from scratch and lose all 3300 existing articles? I think our members would be decidedly unimpressed if this were the case. There’s a lot of info in those forums. Can we discuss these issues please? Help me to understand? I’m really looking forward to getting started in installing your contrib.. I’d just like to dot the I’s first and make sure it’s what we need.