Leaderboard

And for the third problem, the link which @14steve14 links to has a solution, but again it's something that needs to be updated by HPDL. As well as updating HTTP_*_VARS to _* as well 😕

Hello Lyn, This version is already very outdated. It was updated from the old version for 2.3.4. BS Gold and may have more issues to wget it working weell with the latest EDGE versions and PHP 7. I know that you spent already time in the installation, but if you do not need more than one wholesale group, it might be worth to start over with my Wholesale (SPPC) light add-on which is complete new coded, up to date for latest EDGE and CE Frozen and much easier and less job to install. https://apps.oscommerce.com/VWUpG&wholesale-sppc-lite

@puggybelle Open your template_top.php file FIND <script defer src="https://use.fontawesome.com/releases/v5.0.6/js/all.js"></script> REPLACE WITH <!--<script defer src="https://use.fontawesome.com/releases/v5.0.6/js/all.js"></script>//--> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.3.1/css/all.css" integrity="sha384-mzrmE5qonljUremFsqc01SB46JvROS7bZs3IO2EmfFsd15uHvIt+Y8vEf7N7fWAU" crossorigin="anonymous"> That should fix it.

Hi Jack ! Just to say thanks for this add-on as Nivo Slider has always had hiccups. In comparison, this is so easy to install and has so many different transitions AND is truly responsive so forget the others !!! As always we can count on you to come up with the best solutions. Thanks again, Jack.

There are times when you need to get information about products or customers that is not shown in the admin side of the store. If you are happy to use phpAdmin then its easy to get it direct from the database by running a sql query. If your not keen on doing that then a simple alternative is to simply use a php file to display the data on screen. Using stock CE lets assume we want to see all customers who purchased a particular product. The code below looks in the database tables “orders” and “orders_products” for a product with the ID of 34 and prints onto the display all customers who purchased that product. The code can show much more depending on how you set the filters. <?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'username' password'database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Attempt select query execution $sql = "SELECT * FROM orders_products,orders where orders_products.products_id = 34 AND orders.orders_id Group by orders.orders_id "; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>id</th>"; echo "<th>name</th>"; echo "<th>email</th>"; echo "<th>telephone</th>"; echo "<th>orders-ID</th>"; echo "<th>company name</th>"; echo "<th>country</th>"; echo "<th>product ID</th>"; echo "<th>Model</th>"; echo "<th>Name</th>"; echo "<th>quantity</th>"; echo "<th>Price</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['customers_id'] . "</td>"; echo "<td>" . $row['customers_name'] . "</td>"; echo "<td>" . $row['customers_email_address'] . "</td>"; echo "<td>" . $row['customers_telephone'] . "</td>"; echo "<td>" . $row['orders_id'] . "</td>"; echo "<td>" . $row['customers_company'] . "</td>"; echo "<td>" . $row['customers_country'] . "</td>"; echo "<td>" . $row['products_id'] . "</td>"; echo "<td>" . $row['products_model'] . "</td>"; echo "<td>" . $row['products_name'] . "</td>"; echo "<td>" . $row['products_quantity'] . "</td>"; echo "<td>" . $row['products_price'] . "</td>"; echo "</tr>"; } echo "</table>"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?> Here we see what is shown on the screen, As you can see all orders for product with ID 34 are listed with customers info. Using the same code with a small change we can list all order placed by each customer. The only chnage in the code is this line, All we are doing is geting data from 2 tables and sorting it with a filter for orders_id and orders_products_id common to a customers_id. $sql = "SELECT * FROM orders,orders_products where orders.orders_id = orders_products.orders_products_id"; The whole code is, <?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'username' password' database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Attempt select query execution $sql = "SELECT * FROM orders,orders_products where orders.orders_id = orders_products.orders_products_id"; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>id</th>"; echo "<th>name</th>"; echo "<th>email</th>"; echo "<th>telephone</th>"; echo "<th>orders-ID</th>"; echo "<th>company name</th>"; echo "<th>country</th>"; echo "<th>product ID</th>"; echo "<th>Model</th>"; echo "<th>Name</th>"; echo "<th>quantity</th>"; echo "<th>Price</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['customers_id'] . "</td>"; echo "<td>" . $row['customers_name'] . "</td>"; echo "<td>" . $row['customers_email_address'] . "</td>"; echo "<td>" . $row['customers_telephone'] . "</td>"; echo "<td>" . $row['orders_id'] . "</td>"; echo "<td>" . $row['customers_company'] . "</td>"; echo "<td>" . $row['customers_country'] . "</td>"; echo "<td>" . $row['products_id'] . "</td>"; echo "<td>" . $row['products_model'] . "</td>"; echo "<td>" . $row['products_name'] . "</td>"; echo "<td>" . $row['products_quantity'] . "</td>"; echo "<td>" . $row['products_price'] . "</td>"; echo "</tr>"; } echo "</table>"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?> To use simply save the required code as say get_product_info.php, I would save it in your admin directory to keep it secure! Don't for get you need to enter you own details at the head of the file to connect to your database. /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'root' password'database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); We are only reading from the db so should not have any problems but as allways to be safe backup first.

In your Admin Area there is a setting that allows the redirect to cart to be turned off. You can try that, it still refreshes but stays on the page the buy button is on. As an alternative, as @Tsimi rightly says, you could try Ajax. I experimented with something, you can try it http://template.me.uk/234bs3/index.php - this is just to prove it is do-able, it is not currently available as an addon.

Never mind, I uninstalled and réinstalled QT Pro Options and they work. Sorry

Yes, after moving server etc it works. Yipee! Strangely again the OSCommerce v2.3.4.1 CE I'd installed from a zip file and during the installation it had indicated the old version of php was fine, showing a thumbs up by the PHP version during the installation screens. For some reason doesn't pick up on this in the install screens correctly! Sorry I had missed this on your QTPro version Raiwa. So all good now and thanks for the help. Raiwa - just a small note on your QTPro 2.3.4.1. CE Frozen installation documentation (word file). Install point 5: 5. [mandatory] In Admin =>Product Attributes => Header Tags install and configure the module "QT Pro Stock Check". needs to say in Admin / Modules / Header Tags - install QT Pro Stock Check i.e. not in Product Attributes. A typo I think but it may be worth changing this for the next update. many thanks

https://github.com/gburton/Responsive-osCommerce/archive/master.zip Was besseres gibt bisher meines wissens nicht. Ein paar PHP 7.2 notice/warning errors sind glaub ich noch dabei. Aber funktioniert problemlos.

For the qtpro error, please check if you have the file admin/includes/functions/qtpro_functions.php in place. For the SEO errors please check your SEO add-on installation. You probably forgot to copy the function files where these functions are defined. Otherwise please post in the support thread for the SEO add-on you are using. These functions are not part of core.

I know this is an old post, but I would like to thank gary for this post. It took some finding, but I was glad that it showed up. I wanted to disable all payments methods aparet from payPal for all non UK customers and this worked. Thanks @burt

Yes, for 2.4, a nice api to optimize the images on the fly without quality lost !

Use a standard html link as mentioned previously being sure to include the target="_blank" parameter.

Dead? It's at a place I am mostly happy with; php7, a bit modular, responsive etc. Good Luck to all Shopowners.

Hmm.. stil not sure what the BASE HREF is good for, never used it before I entered the oscommerce world, but it might be there for a good reason. You can also work around this problem by using this: <a href="<?php echo $_SERVER['REQUEST_URI']; ?>#top">Top</a> Works like a normal anchor tag (so without reloading the whole page), the session is retained, and you can keep the BASE HREF. @Jeremy: using the tep_href the whole page is reloaded after every click, or isn't it? @Amanda: You remind me, I have got to work on my languages switch :D