Jump to content

PupStar

Members
  • Content count

    946
  • Joined

  • Last visited

  • Days Won

    10

PupStar last won the day on February 5 2017

PupStar had the most liked content!

Profile Information

  • Real Name
    Mark
  • Gender
    Male

Recent Profile Visitors

28,382 profile views
  1. PupStar

    New management and osCommerce v4

    First of all congratulations on the takeover. It has been a long time coming. I hope this does not mean we will see the eventual squeezing out of the dedicated members who kept oscommerce alive in the form of Phoenix. Without their hard work and commitment oscommerce would have gone the way of zencart, cube cart and creloaded. Can I ask does V4 = https://www.trueloaded.co.uk/ Or a slimmed down non commercial version of???
  2. PupStar

    Copy Script Issues

    @ecartz Thanks Matt but I must admit that the logic way over my head lol
  3. PupStar

    Copy Script Issues

    @raiwa Thank you but unfortunately it made no difference
  4. PupStar

    Copy Script Issues

    @Jack_mcs @raiwa Thanks for the help and sorry about the late reply, the day job is taking its toll during this lockdown I have modified the code and now there are no errors or notices however nothing is being copied to the new table. <a href="update_live_categories.php?categories_id=$row[categories_id]"><button class="btn btn-primary" type="submit">Update Categories</button></a> <?php $databaseHost = 'localhost'; //your db host $databaseName = 'tbl_temp_products'; //your db name $databaseUsername = 'root'; //your db username $databasePassword = '';// db password $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); $id = 1; $sql="select parent_id, categories_id from tbl_temp_categories where (categories_id='$id')";// check id is already copied $result=mysqli_query($mysqli,$sql); if (mysqli_num_rows($result) > 0) { // output data of each row $row = mysqli_fetch_assoc($result); if($id==$row['categories_id']) { echo "Already copied"; //error message if already copied }else{ $query = "INSERT INTO categories SELECT parent_id, categories_id FROM tbl_temp_categories WHERE categories_id=$id"; if (mysqli_query($mysqli, $query)) { echo "New record created successfully"; } else { echo "Error: " . $query . "" . mysqli_error($mysqli); } } } ?>
  5. PupStar

    Copy Script Issues

    @raiwaNot sure why it would need a form as once you click the button it should just copy data from one table to another.
  6. PupStar

    Copy Script Issues

    I am having a very boring lockdown sunday afternoon so having a play about. Working locally not specifically on oscommerce but using osc tables. I am trying to copy categories from one table to another. <a href="update_live_categories.php?id=$row[categories_id]"><button class="btn btn-primary" type="submit">Update Categories</button></a> <?php $databaseHost = 'localhost'; //your db host $databaseName = 'tbl_temp_products'; //your db name $databaseUsername = 'root'; //your db username $databasePassword = '';// db password $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); $id = $_GET['categories_id']; $sql="select * from tbl_temp_categories where (categories_id='$id')";// check id is already copied $result=mysqli_query($mysqli,$sql); if (mysqli_num_rows($result) > 0) { // output data of each row $row = mysqli_fetch_assoc($result); if($id==$row['categories_id']) { echo "Already copied"; //error message if already copied } } else{ $query = "INSERT INTO categories SELECT * FROM tbl_temp_categories WHERE categories_id=$id"; if (mysqli_query($mysqli, $query)) { echo "New record created successfully"; } else { echo "Error: " . $query . "" . mysqli_error($mysqli); } } ?> This script is throwing 1 notice and 1 error on this line $id = $_GET['categories_id']; and on this line $query = "INSERT INTO categories SELECT * FROM tbl_temp_categories WHERE categories_id=$id"; Any ideas on a resolve? Thank you
  7. @JcMagpie Just wondering if you have tried this on the latest version of Phoenix, I have but got this error
  8. PupStar

    Customer Orders Tab in Admin Orders (hook)

    @@BrockleyJohn ok did a fresh copy of the files, not sure what happened but its now working spot on :) Thanks
  9. PupStar

    Customer Orders Tab in Admin Orders (hook)

    @@BrockleyJohn, ok grabbed them files and nothing has changed and no errors urgh
  10. PupStar

    Customer Orders Tab in Admin Orders (hook)

    @@BrockleyJohn I am using the latest version of Edge which I downloaded 02/10 I have placed 4 test orders for the same customer and still no 'All Orders' tab
  11. PupStar

    Customer Orders Tab in Admin Orders (hook)

    @@BrockleyJohn I have installed this and I dont seem to have an 'All Orders' tab showing even though there are 3 test orders placed. Am I missing something? Thanks Mark
  12. @@auzStar oh yes the vertical centering is ok.
  13. yes to the above. I found that changing left: 50%; to left: 38%; solved the centralising issue
×