fun with pics.bbzzdd.com

[notfred]

select
avg(poll.vote) as score,
poll.picture_key,
picture.filename,
picture.filesize,
picture.views,
picture.width,
picture.height,
date_format(picture.date_posted, '%m/%d/%y %r') as date,
member.username
from
poll, picture, member
where
poll.picture_key = picture.picture_key and
member.member_key = picture.member_key and
picture.public = 'Y' and
picture.date_posted > date_sub(now(), interval 7 day)
group by
poll.picture_key
order by
score desc limit 20

Brought to you by the 'pics?' development team 😛.

 

[Chompman]

This folks is how you get 33k+ posts, type random spam. 😀

 

[So]

care to elaborate?

 

[dug777]

is my egg carton still in the latest 25?

 

[notfred]

Originally posted by: So
care to elaborate?

It selects the top 20 best rated images posted in the last 7 days from the database.

 

[Czar]

seems we are getting a voting system 😀

or I think, thats sql way beyond what I know

 

[Chompman]

Originally posted by: notfred

Originally posted by: So
care to elaborate?

It selects the top 20 best rated images posted in the last 7 days from the database.

I prefer this. 😀

 

[DannyBoy]

Originally posted by: Czar
seems we are getting a voting system 😀

or I think, thats sql way beyond what I know

I just finished it last night, working on the new gallery views now.

 

[Czar]

Originally posted by: DnaJ

Originally posted by: Czar
seems we are getting a voting system 😀

or I think, thats sql way beyond what I know

I just finished it last night, working on the new gallery views now.

sweet 😀
great job guys, looking forward to seeing it in action

any other features planned?

 

[So]

Originally posted by: Czar

Originally posted by: DnaJ

Originally posted by: Czar
seems we are getting a voting system 😀

or I think, thats sql way beyond what I know

I just finished it last night, working on the new gallery views now.

sweet 😀
great job guys, looking forward to seeing it in action

any other features planned?

Agreed. :thumbsup:

 

[DannyBoy]

Originally posted by: Czar

Originally posted by: DnaJ

Originally posted by: Czar
seems we are getting a voting system 😀

or I think, thats sql way beyond what I know

I just finished it last night, working on the new gallery views now.

sweet 😀
great job guys, looking forward to seeing it in action

any other features planned?

Just a few..

 

[Czar]

hehe ok, we'll see them when they get here 🙂

 

[Conky]

I'd just like to say that pics.bbzzdd.com is about the coolest thing ever!

Fo shizzle, nizzlez. :thumbsup: