Jump to content

Dennisra

Members
  • Content count

    538
  • Joined

  • Last visited

  • Days Won

    1

Reputation Activity

  1. Like
    Dennisra reacted to JcMagpie in Google Adsense and https site   
    If your site is fully ssl compliant then Googe will only serve ssl compliant ads to your site, So mixed content from google ads is not an issue.
    https://support.google.com/adsense/answer/10528?hl=en-GB
  2. Like
    Dennisra reacted to JcMagpie in Google Adsense and https site   
    There you go working on stock CE with https: 😊 just needs a bit of tweeking to mmake google happy. You will find google now shows more ads on mobile than pc.

  3. Like
    Dennisra reacted to MrPhil in Google Adsense and https site   
    If the ads that Google is serving you use http in their addresses, such as for images or Javascript, many browsers will suppress their appearance ("mixed content") due to http (non-SSL) content on an SSL (https) page. You should be able to see this by the icon shown next to your address in the browser address bar. The proper solution is to specify that you want SSL content in your ads, so that everything on the page will be shown by all browsers. I don't use Adsense, so I can't tell you how to do this.
  4. Like
    Dennisra reacted to JcMagpie in Google Adsense and https site   
    Not true! I have ad-sense ruining fine on a number of sites all https. What you will find is that ad-sense is now prioritizing mobile friendly sites.
    I found that after installing new osC I had to make a number of small changes to make google happy with site before it would start showing ads.
    Simply use chrome browser dev tool to review your site and remove all issues it finds. You should then find that ads will just start working.
    Also check your site on mobile device and see if ad’s are showing. I found they appeared mobile devices first.
  5. Like
    Dennisra reacted to JcMagpie in Simple approach to getting data from your data base   
    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. Like
    Dennisra reacted to JcMagpie in Support thread for JcM Product info Delivery Note CE   
    no worries glad you got it sorted. I uploaded a small mod to show the delivery icon 😂 nothing important but as the rest of the code uses font awesome it just makes it fit in.

    you can update by just editing one file. Or unistall and reinstall updated files.
    To edit open
    public_html/includes/modules/content/product_info/templates/tpl_cm_jcm_product_info_delivery_note.php
    find line
    <h3 class="panel-title">' .  constant('MODULE_CONTENT_JCM_PRODUCT_INFO_DELIVERY_NOTE_HEADER_' . $selectedLanguage) . '</h3>
    and replace with
    <i class="fas fa-truck" <pre> </pre>' .  constant('MODULE_CONTENT_JCM_PRODUCT_INFO_DELIVERY_NOTE_HEADER_' . $selectedLanguage) . '</i>
  7. Like
    Dennisra got a reaction from JcMagpie in Lost Admin Password   
    Best to use the current version tutorial of Apache 2.4 as opposed to 2.0: https://httpd.apache.org/docs/current/howto/htaccess.html
  8. Like
    Dennisra reacted to hungryfrank in Ebay manager   
    you have to add the images in your osc shop first. i have assumed that you have your products  ready in Osc 
  9. Like
    Dennisra reacted to Omar_one in Add Specials to main page (index.php)   
    @Dennisra 
    New update  just clean the code  Special Products Content Module(BS)
    Omar
     
  10. Like
    Dennisra reacted to Omar_one in Add Specials to main page (index.php)   
    @Dennisra  the specials.php file no  need for it anymore.
    Do you still have this code in the index.php. 
    <?php include(DIR_WS_MODULES . 'specials.php'); ?> If it is there remove it from there ..
    Omar
  11. Like
    Dennisra reacted to Omar_one in Add Specials to main page (index.php)   
    @burt   @Dennisra @frankl 
    I didn't find the old files so I create new one    Special Products Content Module(BS) 
    and it working well
    Omar
  12. Like
    Dennisra reacted to burt in Add Specials to main page (index.php)   
    You can't use 3 years old blog post exactly...codebase has changed so much since then...and the index page is now modular...so your specials thing needs to be a module.
    Take the idea of that blog post, but not the code.
    You need to make a module.  A module consists of (usually) three files;
    the module itself
    the modules template file
    the modules language file

    So, take the new products module as a base...and by trial and error learn some code from it. 
    It's important that all shopowners know enough code to be dangerous...
    /includes/modules/content/index/cm_i_new_products.php
    /includes/modules/content/index/templates/new_products.php
    /includes/languages/english/modules/content/index/cm_i_new_products.php
    You need to copy each.  Rename each.  Open each, change each appropriately. 
    Save, upload, install.  Forget.
  13. Like
    Dennisra reacted to Omar_one in Add Specials to main page (index.php)   
    @burt  a few months ago  I tried to make it as module and it was shown well but there was no price its show 0
    I will see is I still have the files and post it here if some one can fix it

    Omar
  14. Like
    Dennisra reacted to frankl in Add Specials to main page (index.php)   
    It would be simple to copy the new products module but have it show specials instead. Have a go, if you get stuck I can help.
  15. Like
    Dennisra reacted to Jack_mcs in [CONTRIBUTION] Google XML Sitemap Feed - by Chemo   
    Hmm, I don't know how I got that confused. For this contribution you need to use the alternate setting.
  16. Like
    Dennisra reacted to Jayman11 in NOTICE: USPS is Updating Their APIs Jan. 27th, 2013-Test Servers Available Now.   
    Just as I figured, the First-Class Intl dropped off of the choices on my site this morning because of the name change. Easy fix....change 'First-Class Mail International Parcel**' to 'First-Class Package International Service**' in the includes/modules/shipping/usps.php. The only bad thing is, international rates skyrocketed. For Example, it was costing me $5.75 to ship 1lb into Canada and my cost is now $9.50. I thought it was calculating wrong when it started pulling those rates in the module but I checked my postal software and indeed they did go up that much. There goes my international business.
  17. Like
    Dennisra reacted to mrbyte in Manually processing CC - Split Credit Card E-Mail Address not working   
    You're right, no matter how hard I try to fix you, you're still stupid, Dunweb.
     
    I have the PCI spec in front of me, and 3.2 in it's entirety says:
     
    3.2 Do not store sensitive data after authorization, even if encrypted. Sensitive data includes the data as cited in following Requirements 3.2.1 through 3.2.3
     
    Now, do I need to continue, or are we all following along. Good. Note the note that says sensitive data may be stored if there is a business justification and it is stored securely?
     
    Is it because you make so much money misinterpreting the standards? Or is it really just an inability to read, comprehend and understand basic English and how outlines and such work?
     
    Either way, you are a profiteering blowhard.
     
    As far as "Turning me in" go ahead. Good luck with that...
     
    Cheers
  18. Like
    Dennisra got a reaction from mrbyte in Manually processing CC - Split Credit Card E-Mail Address not working   
    Well said and thank you!!
  19. Like
    Dennisra reacted to satish in an error happened when the purchase checkout by paypal or credit card   
    in application_top.php
     
    error_reporting(E_ALL & ~E_NOTICE);
    replace with
    error_reporting(0);
  20. Like
    Dennisra reacted to satish in Paypal Order Emails Not Being Sent   
    Which Paypal module You are using.
     
    First and foremost make sure IPN is set on in Your Paypal profile and IPNs are reaching Your site.
     
    Satish
  21. Like
    Dennisra reacted to satish in Oscommerce with paypal integration HELP NEEDED...   
    You just need to enable the module and configure for the Zone it should be applicable or set Zone to none.
     
    On the checkout payment page it will be there as an option.
     
    Satish
  22. Like
    Dennisra reacted to satish in PayPal Payments Pro (US) - "Security header is not valid"   
    As You were using the sandbox account is Your certificate also the one that was issued/generated thru sandbox.
     
    Satish
  23. Like
    Dennisra reacted to satish in Issues with Transactions Completing   
    but once they get to paypal it says the transaction was not completed or
    but once they get back to site from paypal it says the transaction was not completed.
     
    This needs to be cleared.
    If You have also paste the screen shot of what gets displaed will make things more clear.
     
    Satish
  24. Like
    Dennisra reacted to sarafina in Official PayPal IPN Support Thread   
    Ok I finally got it working. Can anybody tell me where can I customize the emails that are sent out?
     
    The order process emails that customer gets..
  25. Like
    Dennisra got a reaction from dailce in InternetSecure MerchantLink   
    Anyone who has this integrated with the add-on Reward Bonus Points add-on please contact me by private message.
×