Page 2 of 2
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Fri Mar 30, 2012 6:17 am
by rph
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.
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Thu Apr 05, 2012 10:21 pm
by tophat
amazing! Thanks for the vqmod fix for ordering by title. Why this isn't as default in opencart is strange.
Re: Banner Slideshow Image Order Issue
Posted: Sat May 26, 2012 4:14 am
by Meshach
dpfavand wrote:
in
/catalog/model/design/banner.php
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;
}
}
?>
I added the ORDER BY image ASC at the end of the long line.
Thanks!
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Wed Jul 04, 2012 3:58 pm
by glennjamo
Worked like a charm!
Thanks a lot
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Thu Aug 23, 2012 1:18 am
by fpdesign
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.
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Wed Oct 10, 2012 7:07 am
by slingeraap
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.
That's normal with numbers. 11 comes before 2, alphabetically. So AD11 will also come before AD2.
Just use 001name, 002name, 003name...
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Mon Dec 10, 2012 8:11 am
by eleven28
Woot! Thanks for the vqmod - made things so much easier. No more random slideshow orders for me!
v 1.5.3.1
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Mon Feb 25, 2013 9:58 am
by tgulley
tobychin wrote:Changed "image" to "title" and now I don't have to rename images, just edit the title for re-arranging.
Thank you, much appreciated!
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Sat Mar 02, 2013 5:00 am
by hebiki
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?
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Wed Jun 12, 2013 11:53 pm
by jsw
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!!
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Wed Jul 10, 2013 2:29 am
by emilmoldovan
This worked for me too, thank you all the guys that solved it!
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Sun Aug 25, 2013 11:52 pm
by sari622
Worked like a charm @Web Studio West! The sort by title change did the trick.
Re: Banner Slideshow Image Order Issue [SOLVED]
Posted: Tue Dec 17, 2013 12:59 am
by cosmosolano
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
Re: Banner Slideshow Image Order Issue
Posted: Sun Mar 23, 2014 2:14 pm
by nuski
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
Re: Banner Slideshow Image Order Issue
Posted: Tue Sep 16, 2014 4:02 pm
by jamiefoxx
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.
Re: Banner Slideshow Image Order Issue
Posted: Fri Nov 07, 2014 10:57 pm
by Agathon
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.