Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by Simpel

  1. Download the vanilla version and compare. Oscommerce vanilla
  2. Simpel

    Error With Ccgv5.19

    I got the same problem. Is there a solution?
  3. Hi, i got some problems with old code //DANS AUCTION SCRIPT -REFRESH $cquery="select products_id from ".TABLE_AUCTIONS_PRODUCTS." where products_id =".(int)$_GET['products_id']; $cresult=mysqli_query($cquery, $q); $cnum=mysqli_num_rows($cresult); $z=0; while ($z < $cnum) { $casprodid=mysqli_result($cresult,$z,"products_id"); //echo $casprodid; $z++; } if ($casprodid==(int)$_GET['products_id']) { header('Refresh: 90');} else { echo '';} //end DANS AUCTION SCRIPT this gives the error after update the database.php file tot oscommerce 2.3.4: Warning: mysqli_query() expects parameter 1 to be mysqli, string given in /com_oscommerce/product_info.php on line 112 Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /product_info.php on line 114
  4. Is it possible to pick items from a list (Category of items) and this picked list becomes the order? In stead of doing item by item from the front end? Is there a add-on which doing this?
  5. Simpel

    Request Product Reviews

    "There is an email sent to the store admin with the number of emails sent that day." ------ The ... review reminder script finished execution on 28 Nov 2015 16:15:44 3 email messages were sent. ------ Every customer gets this email also and see each other. it seems the script search the database for the right time range and then send all the customers in that range the same email. instead of separated, the script send to all of them., so they automatic see each other.
  6. Simpel

    Request Product Reviews

    But not separated. The first who make an order that day get the email. But the rest of the people who make an order get the first mail as a CC. So when 10 people make an order the same day. The see the email addresses of each other.
  7. Is it save? I get Regular expression match = [symlink\\s*\\(]: in /download.php’ // BOF Super Download Store v2.3.x mod symlink(DIR_FS_DOWNLOAD . $downloads['orders_products_filename'], DIR_FS_DOWNLOAD_PUBLIC . $tempdir . '/' . $file_name); tep_redirect(DIR_WS_DOWNLOAD_PUBLIC . $tempdir . '/' . $file_name); } else { // This will work on all systems, but will need considerable resources // We could also loop with fread($fp, 4096) to save memory set_time_limit(0); // Prevent the script from timing out for large files tep_download_buffered(DIR_FS_DOWNLOAD . $downloads['orders_products_filename']); // EOF Super Download Store v2.3.x mod
  8. I use MarvikShop for this. The base of Oscommerce and the advatages of Joomla. You can't see that my shop is a real Oscommerce ;)
  9. Simpel

    Joomla osCommerce Bridge

    You could try MarvikShop. That's a Oscommerce component for Joomla. That's not a bridge, but a real component for Joomla. You can reuse all your old Oscommerce database tables.
  10. Simpel

    Request Product Reviews

    For me the add-on gives a problem that everybody who buy that the same day in my shop, get an email after a week. like cc, so they see each other how come?
  11. Simpel

    Request Product Reviews

    Just wondering. Will it be possible when a customer order only above the 25 dollar. To give him automatic an discount over the email after a few days?
  12. I use this super-download-store for my shop and discover something weird. When a customer got 3 order in account_history _info. The file download of the latest order can be downloaded. So the last order shows everything fine. But the 2 order before gives the same download file as the latest order. It seems somehting to do with if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php'); In the file I see $last_order. And not a download connection to the right order. Has anyone else got this problem? Example The downloadlink of order 157 gives the lastest downloadlink domain.com.....order=158&id=179 instead of order=157&id=179
  13. get this error at the search code in order_handler.php : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_p' at line 1 select count(*) as total SELECT o.orders_id, o.customers_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, osh.comments FROM mcyuk_orders o JOIN mcyuk_orders_status_history osh LEFT JOIN mcyuk_orders_total ot ON (o.orders_id = ot.orders_id), orders_status s WHERE o.orders_status = s.orders_status_id AND s.language_id = ? AND o.orders_id = osh.orders_id AND osh.orders_status_id = '1' AND ot.class = 'ot_total' GROUP BY o.orders_id ORDER BY orders_id DESC
  14. just put in the checkout_payment after $payment_modules = new payment; if ( $order->info['subtotal']+$order->info['shipping_cost']==0 ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_CONFIRMATION, 'payment=freeofcharge', 'SSL')); you can change freeofcharge in anything
  15. Simpel

    NEW! Complete Order Editing Tool!

    wrong call to database edit_orders_ajax =? change this if (EMAIL_USE_HTML == 'true'){ $text_query = tep_db_query("SELECT * FROM " . TABLE_EORDER_TEXT. " where eorder_text_id = '2' and language_id = '" . $languages_id . "'"); } else{ $text_query = tep_db_query("SELECT * FROM ". TABLE_EORDER_TEXT." where eorder_text_id = '1' and language_id = '" . $languages_id . "'"); }
  16. I got a problem with update my order. With order_editor. After I change the quantity and push update. The following was put in the orders_total table title text value class sort_order Sub-Totaal: 0.00EUR 0.00 ot_subtotal 1 PostNL (Pakket) 4.75EUR 4.75 ot_shipping 2 Gebruikte spaarpunten: -2.68EUR -2.68 ot_redemptions 3 Totaal: 587.07EUR 587.07 ot_total 4 The problem is the ot_subtotal. That gets into zero. I just wondering how the ot_subtotal calculates his price? What is the code? where do I have to look.
  17. Query: insert into osc_orders_total (orders_id, title, text, value, class, sort_order) values ('1875', 'Sub-Totaal:', '0', '', 'ot_subtotal', '1') something should be wrong...
  18. Simpel

    NEW! Complete Order Editing Tool!

    Test again. I got now the following. subtotal : 10 shippingcosts: 5 credit points: 5 total: 10 When I add quantity of the product 2 and push the update button. Then... subtotal: 0 shippingcosts:5 creditpoints:5 total: 20 What I want: subtotal: 20 shippingcosts:5 creditpoints: -5 total: 20 Where did order_editor calculate after update the subtotal? and where can I change credit points 5 to -5?
  19. Simpel

    NEW! Complete Order Editing Tool!

    After update with the update-button. In the order, the sub_total get to zero. Also when update the sum total does not update. In which file should I have to look?
  20. Simpel

    ULTIMATE Seo Urls 5 - by FWR Media

    When I use path_rewrite. The .html disappear after coming up a new page. public function createLinkString( $page, $text, $seperator, $value ) { return usu5_multi_language( $separator = 'right' ) . $text . $seperator . $value . '.html'; } When I go with my mouse over the link everything seems right. But when I click, the ".html" disappear. When I type the .html after the url. The page show up. What could be wrong?
  21. Simpel

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi there I am trying to install the contribution. But I got some problems. The first one is multi language for manufacturer in table manufacturers_info In ultimate_seo_urls5/page_modules/index.php I got this but the code seems not right. 'manufacturers_id' => array( 'marker' => '-m-', 'query' => "SELECT manufacturers_name FROM :TABLE_MANUFACTURERS_INFO WHERE manufacturers_id=':manufacturers_id' AND languages_id=':languages_id' LIMIT 1", 'to_replace' => array( ':TABLE_MANUFACTURERS_INFO', ':manufacturers_id', ':languages_id' ) ) ); Hope someone knows the code...
  22. Simpel

    Mvs - Error_no_shipping_selected_selected

    Change in checkout_payment.php tep_redirect (tep_href_link (FILENAME_CHECKOUT_SHIPPING, 'error_message=' . ERROR_NO_SHIPPING_SELECTED_SELECTED, 'SSL')); to tep_redirect (tep_href_link (FILENAME_CHECKOUT_SHIPPING, 'error_message=' . ERROR_NO_SHIPPING_SELECTED, 'SSL'));
  23. Simpel

    CONTRIBUTION Product Quick Edit

    for those who want to split also if (!tep_db_num_rows($product_query)) { ?> <tr> <td colspan="8" align="center" class="messageStackWarning"><big><?php echo TEXT_NO_MATCH; ?></big></td> </tr> <?php } elseif (isset($_GET['pSearch'])) { $products_query_raw = "select distinct pd.products_name, p.products_id, p.products_status, p.products_quantity, p.products_price, p.products_model, p.products_model_2, p.products_image, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and (pd.products_name like '%".$prod_search."%' or p.products_id like '%".$prod_search."%' " ." ) order by pd.products_name ASC"; $products_split = new splitPageResults_list($_REQUEST['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows); $product_query = tep_db_query($products_query_raw); while ($product = tep_db_fetch_array($product_query)) { $products_count++; $rows++; echo '<tr valign="top"' . ($pID == $product['products_id'] ? 'bgcolor="#9999ff"' : (((int)($i/2)*2) == $i ? 'bgcolor="#ffffff"' : '')) . '>'; ?> <td align="center" class="main"><?php echo $product['products_model'];?></td> <td align="center"><?php echo tep_image(DIR_EXT_HTTP . $product['products_image'], $product['products_name'], 40, 40); ?></td> <td align="center" class="main"><?php echo $products_name=$product['products_name']; ?> <td align="center" class="main"><?php echo $product['products_model_2']; ?> <td align="center" class="main"><?php echo $currencies->display_price($product['products_price'], tep_get_tax_rate($product['products_tax_class_id'])) ; ?></td> <td align="center" class="main"><?php echo $product['products_weight'];?></td> <td align="center" class="main"><?php echo $product['products_quantity']; ?></td> <td align="right" class="main"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_QUICKEDIT_INFO, 'action=edit&pID='. $product['products_id'] . '&prod_search=' . $prod_search) ?>"><b><?php echo TEXT_EDIT; ?></b></a></td> </tr> <?php } ?> </table> </form> <tr> <td colspan="8"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $products_split->display_count_list($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS , $_REQUEST['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php echo $products_split->display_links_list($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS , TEXT_RESULT_PAGE, $_REQUEST['page'],'option=com_oscommerce&osMod=product_list', 'pSearch=' .$prod_search .'&page'.$page); ?></td> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table></td> </table> </td> </table> </td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table>