• [Mod] Mini-Top 5 0 5 1
Currently:  

Author Topic: [Mod] Mini-Top  (Read 198645 times)

0 Members and 1 Guest are viewing this topic.

Offline pwa

  • Pre-Newbie
  • Posts: 8
    • View Profile
Re: [Mod] Mini-Top
« Reply #180 on: November 07, 2011, 09:54:35 PM »
Das würde mich auch sehr interessieren. Hat jemand eine Idee und kann helfen?
MINI TOP of the DAY
MINI TOP of the WEEK
MINI TOP of the MONTH

hi there! no problem. I am willing to share my solution with the world!

I have reworked the entire mini-top mod...

..cut...

I use this solution but it has TRAP :-(
for young gallery, with few images per day it has loop without end:

Code: [Select]
//image 3
$mini_top_images_new .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n"; 
$count = 0;
while (($top_image[2][$count]['image_id'] == $image_r1['image_id']) || ($top_image[2][$count]['image_id'] == $image_r2['image_id'])) {
$count++;
}
$image_r3 = $top_image[2][$count];
show_image($image_r3);
$site_template->register_vars("lang_mini_top_mode", $lang['mini_top_hits']);
$mini_top_images_new .= $site_template->parse_template("mini_top_bit");
$mini_top_images_new .= "\n</td>\n";

Im not php programmer - I just commented out this section.



Offline cabrote

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [Mod] Mini-Top
« Reply #181 on: March 28, 2012, 07:53:28 PM »
Is there a way to show most viewed, most voted, etc. But only for a period of a Week o r a Month maybe?

 Because if not the Most viewd image would be  probably allways the most viewed one cause itīs appears in home and the possibilities that a person clicks on it is very hi.

Offline cabrote

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [Mod] Mini-Top
« Reply #182 on: April 01, 2012, 06:02:25 PM »
Help please, is there support?  :oops:

I canīt modify code for searching only in last 30 days pictures. The code shown in page 12 doesnīt work well. It output wrong information. The original Mini top Mod works perfect but I canīt figure out how to add in database search onlly image with upload date from 30 days.

Tried with variatons of time() - 60 * 60 * 24 but Iīm not a programmer and all ends with php errors  :D

Offline waseem

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [Mod] Mini-Top
« Reply #183 on: July 03, 2017, 07:23:20 PM »
im getting this error plz help me
Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM igdagesmt_images i, igdagesmt_categories c LEFT JOIN igdagesmt_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 2, 3) AND i.cat_id = '1' ORDER BY i.image_comments DESC, i.image_name ASC
Unknown column 'i.user_id' in 'on clause'

Offline nobby

  • 4images Guru
  • *******
  • Posts: 2.863
    • View Profile
Re: [Mod] Mini-Top
« Reply #184 on: July 03, 2017, 08:09:02 PM »
Hello,

Please use the search function.
This has all been discussed several times.

Go to the search field: (Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id,)

Helping people help themselves  :wink:

nobby