Jump to content

pickupman

Members
  • Content count

    41
  • Joined

  • Last visited

  1. Sounds like you have not run the included sql file (User Tracking with Admin Area.sql). The sql file installs the TABLE_USER_TRACKING into your database. CREATE TABLE user_tracking ( customer_id int(11) default NULL, click_id int(11) default NULL, full_name varchar(64) NOT NULL default '', session_id varchar(128) NOT NULL default '', ip_address varchar(15) NOT NULL default '', time_entry varchar(14) NOT NULL default '', time_last_click varchar(14) NOT NULL default '', last_page_url varchar(64) NOT NULL default '', referer_url varchar(255) NOT NULL default '', page_desc varchar(64) NOT NULL default '' ) TYPE=MyISAM;
  2. pickupman

    Shipping problem with usps,ups works ok

    Just did this today myself. As UPS rates increased USPS rates are very competitive. Hopefully you have received your web tools api user id already. Call the toll free number from the email you got when signing up for web tools. Tell them you are integrated shipping rates with a 3rd party shopping cart. Put userid in UserID box. Leave pass blank. Fill in the appropriate box below. Now try. Mine didn't work either until I called the number. Then it worked. I refreshed my checkout_shipping.php page while on the phone, and it was working.
  3. pickupman

    ?Peachtree CSV Export?

    This should work for all version of Peachtree, just compare the file output to how you need to map the data in Peachtree. This will generate a CSV file that can be imported under File-Select Import/Export. In the readme is a example of how the file mapped.
  4. pickupman

    Custom Computer Creator v9 Support

    You add products to your catalog as usual. Then you add those product categories to your build in admin->ccc options.
  5. pickupman

    New UPS XML Shipping Module available

    Already answered....http://forums.oscommerce.com/index.php?sho...82&st=1000#
  6. pickupman

    ?Peachtree CSV Export?

    The line of code commented out was to set all products to have the same g/l sales account. I used this for testing purposes, and kept it in for those who hadn't loaded their own g/l sales account. You don't need to change anything. For those who want the file auto-generated use this below. Download mime_export.zip If you have it working cleanly here is a little added something. It requires cURL to be installed on your server, which is pretty common. In admin go to Tools->Server Info and look for curl support enabled. This goes into the site.com/catalog/includes directory. You need to edit the first three variables of the file to match your installation. When someone checks out you will be emailed the peachtree file. In checkout_process.php below: tep_mail('', , EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); add // email peachtree export include (DIR_WS_INCLUDES.'mime_export.php'); If you use paypal or another payment that doesn't process the order in checkout_process.php, you will need to add the same thing to the below the same line in /catalog/includes/modules/payment/paypal(or_ipn).php
  7. pickupman

    Custom Computer Creator v9 Support

    Here's a working /admin/pending.php pending.zip Also, please note the ccc javascript is broken in Firefox & Opera. Only functions in IE.
  8. pickupman

    Custom Computer Creator v9 Support

    It has been so long since I fixed the pending orders on my install, but if you post your custom_checkout.php I could compare the line using WinMerge. I am running CRELoaded, so my copy may not be of any help. I believe it was in a sql query. The javascript at the top is to pass a complete http content header to the browser first to work in CRELoaded because the original ccc passed content before a header in cre. function popup($vMsg,$vDestination) { echo("<html>\n"); echo("<head>\n"); echo("<title>System Message</title>\n"); echo("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n"); echo("<script language=\"JavaScript\" type=\"text/JavaScript\">\n"); echo("alert('$vMsg');\n"); echo("window.location = ('$vDestination');\n"); echo("</script>\n"); echo("</head>\n"); echo("<body>\n"); echo("</body>\n"); echo("</html>\n"); exit; } // require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CCC); if ($HTTP_POST_VARS['fsb'] ==''){ tep_redirect(tep_href_link(FILENAME_DEFAULT)); } include(DIR_WS_INCLUDES . 'functions/custom_computer.php'); $defines_query = tep_db_query('select config_name, config_value from ccc_config'); while ($defines = tep_db_fetch_array($defines_query)){ define($defines['config_name'],$defines['config_value']); } $breadcrumb->add(NAVBAR_TITLE, tep_href_link('build.php', '', 'NONSSL')); $custom_category_raw = tep_db_query("select products_id from ".TABLE_PRODUCTS." order by products_id desc"); $custom_category_values = tep_db_fetch_array($custom_category_raw); $message = ''; $tax_rate = tep_get_tax_rate(ccc_tax_class); $message .= '<table border="0" width="100%" cellspacing="0" cellpadding="0">'; $i = 0; $edit_prod = ''; $computer_weight = ''; $products_name_query = tep_db_query('select fsb_name from '.TABLE_CCC_FSB_DESCRIPTION.' where fsb_id = "'.$HTTP_POST_VARS['fsb'].'" and language_id = "'.(int)$languages_id.'"'); $products_name_fetch = tep_db_fetch_array($products_name_query); $products_name = $products_name_fetch['fsb_name']; $ccc_count_query = tep_db_query('select c.*, cd.* from '.TABLE_CCC_CAT.' c, '.TABLE_CCC_CAT_DESCRIPTION.' cd where c.fsb_id = "'.$HTTP_POST_VARS['fsb'].'" and c.cat_id = cd.cat_id and cd.language_id = "'.(int)$languages_id.'" and c.status = "1" order by sort_order asc'); while ($count = tep_db_fetch_array($ccc_count_query)){ $i = $i + 1; if ($i == 1){ $edit_prod .= $HTTP_POST_VARS['new' . $i . '_hidden']; }else{ $edit_prod .= '|' . $HTTP_POST_VARS['new' . $i . '_hidden']; } $products_weight_query = tep_db_query('select products_weight from '.TABLE_PRODUCTS.' where products_id = "'.$HTTP_POST_VARS['new' . $i . '_hidden'].'"'); $products_weight = tep_db_fetch_array($products_weight_query); $computer_weight += $products_weight['products_weight']; if ($HTTP_POST_VARS['new' . $i] == "Please Select" || $HTTP_POST_VARS['new' . $i] == ""){ $message .= '<tr><td class="smallText">' . $count['cat_name'] . ':</td><td class="smallText">'.TEXT_NONE_SELECTED.'</td></tr>'; }else{ $message .= '<tr><td class="smallText">' . $count['cat_name'] . ':</td><td class="smallText">' . $HTTP_POST_VARS['new' . $i] .'</td></tr>'; } } $products_warranty = '0'; $products_build = '0'; $products_total = $HTTP_POST_VARS['Total']; if ($HTTP_POST_VARS['warranty'] != '0.00' && $HTTP_POST_VARS['warranty'] != ''){ $message .= '<tr><td class="smallText">'.TEXT_EXTENDED_WARRANTY.'</td><td class="smallText"><b>'.((CCC_WARRANTY_TAXABLE == 'true') ? $currencies->display_price($HTTP_POST_VARS['warranty'], $tax_rate) : $HTTP_POST_VARS['warranty']).'</td></tr>'; $products_warranty = '1'; if (CCC_WARRANTY_TAXABLE == 'true'){ $products_total_tax = tep_calculate_tax($HTTP_POST_VARS['warranty'], $tax_rate); $products_total = ($products_total - $products_total_tax); } } if ($HTTP_POST_VARS['build'] != '0.00' && $HTTP_POST_VARS['build'] != ''){ $message .= '<tr><td class="smallText">'.TEXT_BUILDING_COMPUTER.'</td><td class="smallText"><b>'.((CCC_BUILD_TAXABLE == 'true') ? $currencies->display_price($HTTP_POST_VARS['build'], $tax_rate) : $HTTP_POST_VARS['build']).'</td></tr>'; $products_build = '1'; if (CCC_BUILD_TAXABLE == 'true'){ $products_total_tax = tep_calculate_tax($HTTP_POST_VARS['build'], $tax_rate); $products_total = ($products_total - $products_total_tax); } } $message .= '</table>'; if ($HTTP_GET_VARS['action'] == 'confirm'){ $product_array = array('products_image' => ccc_dpic, 'products_quantity' => quantity, 'products_weight' => $computer_weight, 'products_date_added' => 'now()', 'products_tax_class_id' => ccc_tax_class, 'products_status' => status, 'products_model' => "Custom", 'products_price' => $products_total, 'manufacturers_id' => '0' ); if ($HTTP_GET_VARS['edit'] == '1' && $HTTP_GET_VARS['products_id'] != ''){ $cart->remove($HTTP_GET_VARS['products_id']); tep_db_perform(TABLE_PRODUCTS, $product_array, 'update', 'products_id = "' . $HTTP_GET_VARS['products_id'] . '"'); $edit_prod_array = array('products_included' => $edit_prod, 'products_warranty' => $products_warranty, 'products_build' => $products_build); tep_db_perform('ccc_system_edit', $edit_prod_array, 'update', 'products_id = "' . $HTTP_GET_VARS['products_id'] . '"'); $pd_array = array('products_description' => $message, 'products_name' => $products_name, 'language_id' => (int)$languages_id); tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $pd_array, 'update', 'products_id = "' . $HTTP_GET_VARS['products_id'] . '"'); $cart->add_cart($_GET['products_id']); }else{ tep_db_perform(TABLE_PRODUCTS, $product_array); $ccc_prod_id = tep_db_insert_id(); $edit_prod_array = array('products_id' => $ccc_prod_id, 'products_included' => $edit_prod, 'products_warranty' => $products_warranty, 'products_build' => $products_build, 'products_systype' => $HTTP_POST_VARS['systype'], 'products_fsb' => $HTTP_POST_VARS['fsb']); $pd_array = array('products_description' => $message, 'products_id' => $ccc_prod_id, 'products_name' => $products_name, 'language_id' => (int)$languages_id); tep_db_perform(TABLE_CCC_EDIT, $edit_prod_array); tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $pd_array); } $header_url = tep_href_link(FILENAME_SHOPPING_CART, tep_get_all_get_params(array('action')).'action=buy_now&products_id='.$ccc_prod_id); if ($HTTP_GET_VARS['edit'] == '1'){ //tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'action=update_product')); popup('System has been added to cart.',$header_url); }else{ popup('System has been added to cart.',$header_url); } } if ($HTTP_GET_VARS['edit'] == '1' && $HTTP_GET_VARS['products_id'] != ''){ echo tep_draw_form('cart_update', tep_href_link(FILENAME_CCC_CHECKOUT, tep_get_all_get_params(array('action', 'edit')) . 'action=confirm&edit=1')); }else{ echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_CCC_CHECKOUT, tep_get_all_get_params(array('action')) . 'action=confirm')); } <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="50%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $message; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="right" class="main"> <?php /* Re-Post all POST'ed variables */ reset($HTTP_POST_VARS); while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } } ?> <input type="hidden" name="action" value="buy_now"> <input type="hidden" name="products_id" value="<?php echo $custom_categ; ?>"> <?php if (!$sess_new){ echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); }else{ echo tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); } ?> </td> </tr> </table> </form> </td> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
  9. Are you sure other people have visited your site?
  10. pickupman

    New UPS XML Shipping Module available

    Click the Packingslip button in the Orders admin screen. When you click on an order, the right pane has a packingslip button, and when viewing the order, there is a packingslip button. It's created by /catalog/admin/packingslip.php if you want to edit it's appearance.
  11. pickupman

    Custom Computer Creator v9 Support

    Does anyone know how to use images instead of dropdown menus for attributes? Probably not....Tried coding radio buttons which didn't work well either How can I add extra radio button options? (eg: RAID? NO / STRIPE / MIRROR) Pretty hard to do the way the java, and script is written...more or less a templete for every component How do I add checkbox options? (eg: ADD SOFTWARE? OPTION1 OPTION2 OPTION3) Just create them in your admin. Put all available software in each option. Can I add text options? (eg: What username would you like on administrator account?) I would add these to custom_checkout.php Why does CCC add tax to build and warranty prices twice? Not sure on that Can the custom_checkout.php be skipped as it is redundant? The custom_checkout.php is needed b/c there are no product_ids since they are custom builds. The custom_checkout.php creates a product in the products table as Custom. Why do I get page expired if I use back button from custom_checkout.php? The script is coded to make you use the edit link in the shopping cart. How do I insert linebreaks after components listed in order confirmation email? It's been awhile since I edited this script, but I do remember parsing the text into a table when the build is added to the products_description table. I have yet parsed the html to mime html for the email sent to the customer. Any help would be fantastic as these are the issues that I'm currently facing (I'm sure there will be many more..lol)
  12. That means you are creating the function again. It can only be made once. You shouldn't have the function in any other file except hsphere/local/home/account/site/admin/includes/functions/database.php & hsphere/local/home/account/site/includes/functions/database.php
  13. That means you probably have function user_tracking() on line 16 & 18. You can only create a function once in a script.
  14. pickupman

    Custom Computer Creator v9 Support

    I had this same problem cause i was using CREloaded osc v6.51 with this contribution. The script tried sending the build before the header. I wrote some javascript to send it onclick rather than $_POST. /catalog/custom_checkout.php add to top function popup($vMsg,$vDestination) { echo("<html>\n"); echo("<head>\n"); echo("<title>System Message</title>\n"); echo("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n"); echo("<script language=\"JavaScript\" type=\"text/JavaScript\">\n"); echo("alert('$vMsg');\n"); echo("window.location = ('$vDestination');\n"); echo("</script>\n"); echo("</head>\n"); echo("<body>\n"); echo("</body>\n"); echo("</html>\n"); exit; } around line 133 $header_url = tep_href_link(FILENAME_SHOPPING_CART, tep_get_all_get_params(array('action')).'action=buy_now&products_id='.$ccc_prod_id); if ($HTTP_GET_VARS['edit'] == '1'){ //tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'action=update_product')); popup('System has been added to cart.',$header_url); }else{ popup('System has been added to cart.',$header_url); //echo '<a href="'.tep_href_link(FILENAME_SHOPPING_CART, 'action=buy_now&products_id='.$ccc_prod_id).'"><img src="'.DIR_WS_TEMPLATES . TEMPLATE_NAME.'/images/buttons/english/button_confirm.gif"></a>'; //tep_draw_form('confirm_cart',$header_url .'action='.$header_url); }
  15. pickupman

    Custom Computer Creator v9 Support

    That's right, now you setup your builds under ccc options and add parts to the build. This is done by adding a category->subcategory->parts available method. First create a build(model) name. Then add category (ie Motherboard) then add parts for that category (ie MSI KM4AM-LV). Then when you go to http://www.yoursite/catalog/ccc.php you will see your model listed. Click it, and it will show your model. click it, and you will see the motherboard drop down selection box.
×