Author Topic: Sortierung in Top-Liste  (Read 3329 times)

0 Members and 1 Guest are viewing this topic.

Offline Biggi

  • Jr. Member
  • **
  • Posts: 74
    • View Profile
    • http://www.bibodia.de/
Sortierung in Top-Liste
« on: April 13, 2003, 01:10:25 PM »
Hallo zusammen,

gibt es eigentlich die Möglichkeit, in der Top-Liste nur die Bilder anzeigen zu lassen, die MINDESTENS drei Stimmen erhalten haben? Meine User würden es gern sehen, wenn ein Bild, das einen Bewertungs-Durchschnitt von 9,8 mit drei abgegebenen Stimmen einen höheren Stellenwert hat, als ein Bild mit 10 Punkten aus nur einer Stimme.

Kann man das so vorgeben?

Was müßte man ändern?

Schon jetzt vielen Dank für Eure Mühe!

LG, Biggi

----------------------------------------------------------------------------

How could I change the code for the top-list in that way, that there are only pictures shown that have at least 3 votes? If there are only 2 votes it should'nt be shown. Any idea?

Thx, Biggi

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Sortierung in Top-Liste
« Reply #1 on: April 13, 2003, 01:20:58 PM »
in top.php under VOTE section change
Code: [Select]
       WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id to:
Code: [Select]
       WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id AND i.image_votes >= 3
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Biggi

  • Jr. Member
  • **
  • Posts: 74
    • View Profile
    • http://www.bibodia.de/
Sortierung in Top-Liste
« Reply #2 on: April 13, 2003, 01:35:25 PM »
GREAT V@no!
First I changed it unter VOTES-Section and it didn't show any changes, but when I also changed the same line unter RATINGS-Section it worked!

Now we have exactly the toplist we wanted.

Thanks again and again  :D

Biggi