There's also Banners Plus which adds sort order to banners so you don't have to rename your images every time you want to change their order. It also has other features like making banners language specific and individual banner image disabling.
-Ryan
amazing! Thanks for the vqmod fix for ordering by title. Why this isn't as default in opencart is strange.
Webmaster for: http://www.getlaidbeds.co.uk + www.mattressmoose.co.uk + www.pixellounge.co.uk
Thanks!dpfavand wrote: in
/catalog/model/design/banner.php
I added the ORDER BY image ASC at the end of the long line.Code: Select all
<?php class ModelDesignBanner extends Model { public function getBanner($banner_id) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "banner_image bi LEFT JOIN " . DB_PREFIX . "banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '" . (int)$banner_id . "' AND bid.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY image ASC"); return $query->rows; } } ?>
There's also an extension that provides drag and drop ordering of banner images. It also adds in a new image upload manager. You can get it here: http://www.opencart.com/index.php?route ... on_id=6229.
DakotaQ Internet Services
"We Build Websites that Do Something!"
OpenCart Extensions, Installation Support, and Customization
Multi Image Management for 1.5.2+ and 1.5.3.1
Multi Image Management for 1.5.0+
That's normal with numbers. 11 comes before 2, alphabetically. So AD11 will also come before AD2.Web Studio West wrote:To sort by banner title, I modified the code above posted by swazemarket by changing "ORDER BY image ASC" to "ORDER BY title ASC". I also noticed if banner titles are only numeric they don't sort properly. I solved this by naming banner titles: AD1, AD2, AD3, etc. and it works like a charm. Titles that were just numbers (like: 10, 20, 30) didn't work.
Just use 001name, 002name, 003name...
VQmod worked great.
just a question.. we can order it by title.....where is the "title" actually displayed when viewed on a website? contemplating prefixing all banners with letters to make it easier to arrange/rearrange.
ex:
A - Banner 1
B - Banner 2
C - Banner 3
then later on:
A - Banner 2
B - Banner 3
C - Banner 1
thoughts? suggestions?
just a question.. we can order it by title.....where is the "title" actually displayed when viewed on a website? contemplating prefixing all banners with letters to make it easier to arrange/rearrange.
ex:
A - Banner 1
B - Banner 2
C - Banner 3
then later on:
A - Banner 2
B - Banner 3
C - Banner 1
thoughts? suggestions?
Thanks for the question and answers everyone!
New to OC and just ran into the "banner slideshow image order issue". Found this thread and the vQmod solution (using title) works well for me. Thought to register right away to post this THANK YOU!!
New to OC and just ran into the "banner slideshow image order issue". Found this thread and the vQmod solution (using title) works well for me. Thought to register right away to post this THANK YOU!!
I had all but given up on using the slideshow module, you saved the day!
this worked perfectly for me and makes a HUGE difference in what we want to do with the site.
thanks thanks thanks!
Cosmo
this worked perfectly for me and makes a HUGE difference in what we want to do with the site.
thanks thanks thanks!
Cosmo
Your post looks like wonderful. While develop website we maybe face this kind of major banner slide issues. You effective information is enough to solve this problem. Thanks for giving us.
nuski wrote:mwd wrote:This worked for me to.
Thanks for the code dpfavand!
I made it into a vqmod so that you don't have to change the code again after an upgrade.
Hi, thanks for the mod, it works fine with my v.1.5.6.1
I confirm, it works also for 1.5.6 Opencart version.Thanks a lot.
Who is online
Users browsing this forum: No registered users and 1 guest
