By lurkerfilms on

Very modest site, nothing Earth Shattering (I am not a graphic designer):

http://www.zompire.com

Uses the modules: CCK, SMTP, slightly modified Deco Theme, Five Star, Diggthis.

Drupal is really great for film festivals. I may work on a profile for specifically that. If this was more turnkey it will catch on like fire.

It took about 10 days to setup completely (mostly learning how to use images and which modules to use).

I also plan to use Drupal for http://www.hplfilmfestival.com, http://www.lurkerfilms.com, and http://www.silverkeymedia.com.

I have the religion.

⋅ Categories: Drupal 6.x

Comments

Anonymous’s picture

Anonymous (not verified) commented

Very cool. I like the look and the content of the films was great

lurkerfilms’s picture

lurkerfilms commented

I created a custom node content type tpl file and output the CCK fields and fivestar content for the node view, in the list view I use a smaller version of the thumbnail without all the fields.

I am not sure what state views is in for drupal6... I used it to help generate queries but for now have some places like archives using php (as input type) with the query and a simiple loop outputting the table rows.

I know this is horribly bad (I would rather say use this view and theme it) but there is no practical documentation for drupal6 on how one is suppose to use it. I also want to add tabs based on the list of terms for a particular vocabulary and have the tabs link to the page passing an arguement which is the term.

Anyway great stuff in general (although is wish it was OO and not procedural).

cheers

Andrew Migliore
Lurker Films Inc.
http://www.lurkerfilms.com

robertlam’s picture

robertlam commented

I use a lot of vote five star on mysite too. I notice it uses a lot of the votingapi_vote table.

I am a Drupal Newbie. It takes me more than three weeks to get to where I am.

www.swearpidia.com

joehenriod’s picture

joehenriod commented

SOOOO GREAT !!!!

lurkerfilms’s picture

lurkerfilms commented

Thank you. It i only going to get better.

Andrew Migliore
Lurker Films Inc.
http://www.lurkerfilms.com

luckyer’s picture

luckyer commented

films is cool!!

:---)

___________________________________________________________________________

Msn: luckyer007@hotmail.com

Site: www.luckyer.org www.hnnow.com

wanmatt’s picture

wanmatt commented

very nice setup..
I like the films too

cubicledropout’s picture

cubicledropout commented

Looks good for someone without much graphic design experience.

Check out my blog! blog.cubicledropout.com
or my Drupal test site at drupal.cubicledropout.com

lurkerfilms’s picture

lurkerfilms commented

Added tabs to the film page to sort films by type... currently a single page that uses a param to switch tabs and content.

Used the following to output the films. The SQL looks for all nodes that have a term that represents the current year, and a term that represents the film type ($termid) is determined by the url parameter passed in e,g, ?tab=shorts. I then make sure it is nodes that are the film content typope and that they are published.

    $sql = "SELECT node.nid AS nid FROM node INNER JOIN (term_node AS snode, term_data AS screening) ON (node.nid = snode.nid AND snode.tid = screening.tid AND snode.tid = 9) INNER JOIN (term_node, term_data AS ftype) ON (node.nid = term_node.nid AND term_node.tid = ftype.tid AND term_node.tid = " . $termid . ") WHERE node.type IN ( 'film' ) AND node.status = 1 ORDER BY title";

    $result = pager_query($sql, 50, 0, NULL, '%');
    while ($item = db_fetch_object($result)) {
      echo node_view(node_load($item->nid), TRUE, FALSE, TRUE);
    }

I know that is probably not the most efficent way... but in 6.x. I can not get views to work ... currently trying to figure out how to theme tables.

cheers

Andrew Migliore
Lurker Films Inc.
http://www.lurkerfilms.com