Search found 25 matches

Search found 25 matches

Re: [v3.0.2.0 - Concept] - Most / All models containing the date_added without date_modified field

I've been working on a fork of the project - much narrower in scope that OC. But wanted to offer a suggestion for future versions: Use date_added and date_modified columns in ALL tables, and rely on MySQL to update them (in the table definition), rather than having PHP do the same work. It's much si...

Jump to post
  • Sun Oct 15, 2017 1:34 am
  • Replies 4
  • Views 3309
Re: Can I make images in the Admin / Product List larger?

Doesn't straight lines solution give you thumbnails on the backend the same size as the front end? They should be different.

Jump to post
  • Sat Oct 14, 2017 7:20 am
  • Replies 5
  • Views 1789
Re: Opencart install on MAMP

Step is database credentials, right? The only address that are asked for on that screen are for the location of the database server. If should just be an IP Address or a valid name. No protocol is needed. Your Mac needs to be able to resolve that address.

Jump to post
  • Sun Jun 04, 2017 3:25 am
  • Replies 1
  • Views 1183
[RELEASED] Show SEO URLs in lists -VQMOD

For smaller stores, 10,20 products, figuring out which products have SEO URL's and which don't isn't too much of a pain. Doesn't take too long to figure it out. For larger stores, though, when you're talking 1000-2000+ products, it can be a real challenge, and randomly clicking product after product...

Jump to post
  • Tue May 30, 2017 7:57 pm
  • Replies 0
  • Views 3037
Re: Adding "Current Password" field to password change page

I don't have OC2.0 installed, the earliest I have is 2.2 - in that version, you should take a look at /system/library/cart/customer.php In the login function, there is: $customer_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE LOWER(email) = '" . $this->db...

Jump to post
  • Sat May 27, 2017 11:11 pm
  • Replies 1
  • Views 1456
Re: Fatal Error

@MrPhil - the error doesnt' appear related to the SQL Syntax at all, but rather that the extension didn't create the column it needs in the database. To OP - I would examine the module a little bit and see if you can determine what column type it wants `oc_product_option_value.,image_product_option_...

Jump to post
  • Sat May 27, 2017 11:04 pm
  • Replies 3
  • Views 35560
Re: Setting up site for developer / programmer, need tips

Going back to the original post on this thread: If deleting the CONTENTS of the customer* and order* tables caused your site to break, then there was something wrong with how your site was setup in the first place. Now, if you deleted the tables themselves, that could cause major issues. So my first...

Jump to post
  • Sat May 27, 2017 11:00 pm
  • Replies 25
  • Views 2208
A free extension/SEO tool for managing redirects in Opencart 2.2

I wrote an extension for a client of mine to let the store administrator mange page redirects. For instance, he's got some products in his store that have some great search rankings, but those products are unfortunately being discontinued. While new products will be arriving, it will be necessary fo...

Jump to post
  • Sun May 21, 2017 8:37 am
  • Replies 0
  • Views 1100
Re: Could not move on installing due to permisson

Windows doesn't have 777 permissions.

Can you be more specific about your setup?

Jump to post
  • Tue May 02, 2017 2:37 am
  • Replies 3
  • Views 377
Re: Looking for feedback on a module I'm working on

Yes - I have a new table that records each time a banner is loaded and each time it is clicked, saves each record along with IP Address, Useragent, etc. So all of the data is there to be accessed.

A dashboard module is a great idea though! Just need to figure out how best to visualize it.

Jump to post
  • Fri Apr 28, 2017 2:45 am
  • Replies 3
  • Views 622
Looking for feedback on a module I'm working on

It's a "banner analytics" module, which hopes to track loads and clicks of banners throughout an Opencart Site. It's all functioning minimally right now (stores every click to a database, along with a variety of other information). Now I'm trying to figure out the best way to display it. R...

Jump to post
  • Fri Apr 28, 2017 2:01 am
  • Replies 3
  • Views 622
Free VQMOD to convert "container" to "container-fluid" in all default .tpl files

Was working with a theme which uses "container-fluid" div's in order to have a full width appearance. It didn't provide new .tpl files for all of Opencart's default template files though, meaning that if you visited a page that the theme hadn't provided a substitution for, it would look a ...

Jump to post
  • Fri Apr 28, 2017 1:10 am
  • Replies 0
  • Views 1775
Re: google analytic real time visit is different from the People online in the admin page

Opencart deletes records from the customer_online table if they haven't been active for an hour. (see /catalog/model/tool/online.php), while google only looks back 30 minutes. There will always be a discrepancy.

Jump to post
  • Wed Apr 26, 2017 1:32 am
  • Replies 1
  • Views 292
Re: Remove "---Please Select---" from dropdown menu.

I repeat - just make the option required on the admin side. 99% certain that's the solution you're looking for! No need to touch strings or templates.

Jump to post
  • Sun Apr 23, 2017 1:35 am
  • Replies 22
  • Views 2943
Re: editing product options price markup via database

oc_product_option_value You can write a query to set the price to 0 matching against either the option_id (to change it for ALL batteries) or option_id and product_id (if you're only changing the battery price for a few products). If it's just one of the battery options you're changing, you have to ...

Jump to post
  • Sat Apr 22, 2017 3:45 am
  • Replies 2
  • Views 666
Re: Remove "---Please Select---" from dropdown menu.

What do you want there in its place?

If they have to select, just make the option "required" - no more "please select", users will have to make a selection

Jump to post
  • Sat Apr 22, 2017 3:41 am
  • Replies 22
  • Views 2943
For developers only: VQMOD for logging all queries and execution times

Posted this on the wrong thread (extensions), posting here and deleting there... I'm not sure if anyone has done anything similar, so I went ahead and did it myself - created VQMOD that logs the execution times of each query that runs ($this->db->query). I found it extremely helpful for optimizing m...

Jump to post
  • Thu Apr 20, 2017 7:31 am
  • Replies 0
  • Views 1587
Re: Please Encrypt Sensitive Data

Correct me if I'm wrong, but if you encrypt the data in the database, but opencart can decrypt it whenever it needs, that means the decrypt key is accessible and therefore a hacker who's gotten into the server will still have access to everything they need to decrypt those credentials, no?

Jump to post
  • Sat Dec 24, 2016 3:53 am
  • Replies 5
  • Views 3900
Re: Database transfer

I did the same when upgrading from opencart 1.5 to 2.3; made a copy of the 1.5 database and compared that the a fresh 2.3 install, and modified 1.5's field definitions to match. There was also quite a bit of cruft (extra columns and tables) from the previous install, either from extensions that were...

Jump to post
  • Sat Dec 24, 2016 3:45 am
  • Replies 2
  • Views 586
Re: Cannot view Customers Page

Have you made any edits to any of the files in /admin/ ? I know for myself, when I've experimented with making changes (before rolling those changes into a separate VQMOD so as to not actually modify any of open carts files), apache's error logs are very helpful in figuring out where something broke...

Jump to post
  • Sat Dec 24, 2016 3:40 am
  • Replies 2
  • Views 419

Search found 25 matches