Jump to content
Latest News: (loading..)

Leaderboard


Popular Content

Showing content with the highest reputation since 09/18/2018 in all areas

  1. 2 points
    burt

    PayPal App v5.010 for v2.3.4BS

    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 😕
  2. 1 point
    raiwa

    SPPC - for 2.3.4

    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
  3. 1 point
    Tsimi

    Horizontal Categories Menu BS

    @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.
  4. 1 point
    lucsangel

    Jssor Slider

    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.
  5. 1 point
    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.
  6. 1 point
    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.
  7. 1 point
    lucsangel

    QTPro BS

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

    QTPro BS

    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
  9. 1 point
    raiwa

    PHP 7.2.

    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.
  10. 1 point
    raiwa

    QTPro BS

    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.
  11. 1 point
    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
  12. 1 point
    Yes, for 2.4, a nice api to optimize the images on the fly without quality lost !
  13. 1 point
    Jack_mcs

    admin/includes/boxes/

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

    Frozen

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

    Named anchor tags don't work?

    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
×