Status
Not open for further replies.
vBulletin version 4.2.0 + DragonByte Gallery Lite v1.3.2
Trying to play with Galery Lite and find some bugs.
Sorry, but I cannot provide website URL because of internal testing


1. navigation_tab_complete.php:

PHP:
$submenu['prof_image'] = array(
					'root' => $tabname,
					'type' => 'link',
					'url' => $gallink . '&do=add_prof_image',
					'title' => $vbphrase['dbtech_gallery_nav_add_prof_image'],
					'name' => 'dbtech_gallery_prof_image',
					'children' => 0
				);

Phrase dbtech_gallery_nav_add_prof_image does not exists and perhaps it must be dbtech_gallery_nav_add_prof_img

2. After "Add Profile Image" menu item became visible, i see the next:
image01.png


3. Applying rating to images has no effect on sorting at main gallery page when "Highest Rated Images" is selected.
As i understand it, the sorting is made by weight_rate field but it is always 0 and never updated.



Sorry, if my English is bad. :(
 
Possible workaround for rating calculations using database triggers:

Code:
CREATE TRIGGER `dbtech_gallery_image_AfterUpdate` AFTER UPDATE ON dbtech_gallery_rating FOR EACH ROW
BEGIN
 update dbtech_gallery_images
 set
  weight_rate =
   (select sum(cast(rating as signed)-3) from dbtech_gallery_rating where imageid = new.imageid)
 where
  imageid = new.imageid;
END;


CREATE TRIGGER `dbtech_gallery_rating_AfterInsert` AFTER INSERT ON dbtech_gallery_rating FOR EACH ROW
BEGIN
 update dbtech_gallery_images
 set
  weight_rate =
   (select sum(cast(rating as signed)-3) from dbtech_gallery_rating where imageid = new.imageid)
 where
  imageid = new.imageid;
END;


CREATE TRIGGER `dbtech_gallery_image_AfterDelete` AFTER DELETE ON dbtech_gallery_rating FOR EACH ROW
BEGIN
 update dbtech_gallery_images
 set
  weight_rate =
   (select sum(cast(rating as signed)-3) from dbtech_gallery_rating where imageid = old.imageid)
 where
  imageid = old.imageid;
END;

PHP code not affected.
 
Sorry for missing this thread :(

I've added fixes for all 3 issues to the files, if you re-download v1.3.2 and re-upload the files, this should now be fixed :)


PS: If you elect to circumvent our requirement to enter your forum URL, we will be unable to assist you with any support queries you may have. We require your forum URL (even if it's not public) before we are able to assist.
 
Status
Not open for further replies.

Legacy DragonByte Gallery

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
862
Customer rating
0.00 star(s) 0 ratings
Back
Top