$result = db_query_range("SELECT n.nid FROM {node} n INNER JOIN {term_node} tn ON (tn.nid = n.nid) WHERE tn.tid = %d AND n.type='forum' AND n.status = 1 ORDER by n.changed DESC", $forum->tid, 0, 1);
hi, first up its a really nice site, like the design and the concept of the site, really cool!
i noticed you have mobile interaction (http://www.gimme20.com/mobile), i was wondering how you set this up (modules and service provider??)?? i want to add the ability for users to text images to galleries on my site but i don't know where to begin looking so any help would be brilliant.
I cant beleive that nobody
I cant beleive that nobody has shown interest in this website. It is a really nice setup and I am impressed.
I agree
It's nicely designed, the interface is clean with a good attention to details.
Nice site
I have already spotted that site and it's in my del.icio.us bookmarks in the drupal tag.
I think it's very well designed and very intuitive. :)
ahh shucks....
Thanks you guys! Any other feedback you can give us is more than appretiated! I love showing that drupal can shine.
Jordan | Gimme20.com
Your forums look great. How
Your forums look great. How did you display the last post made in one of the columns on the forum index page?
little custom job
Basically, I made a themeing function that renders a row (an inline forum category as I called it in my code)
function theme_inline_forum($forum)
{
$new_topics = _forum_topics_unread($forum->tid, $user->uid);
$forum->old_topics = $forum->num_topics - $new_topics ;
if (!$user->uid)
{
$new_topics = 0;
}
$result = db_query_range("SELECT n.nid FROM {node} n INNER JOIN {term_node} tn ON (tn.nid = n.nid) WHERE tn.tid = %d AND n.type='forum' AND n.status = 1 ORDER by n.changed DESC", $forum->tid, 0, 1);
if ( db_num_rows($result)>0 )
{
$row = db_fetch_object($result);
$nodeLoad = node_load($row->nid);
$last_post['link'] = l(limit_length($nodeLoad->title,20,'..'), 'node/' . $nodeLoad->nid);
$last_post['userlink'] = l($nodeLoad->name, 'node/' . $nodeLoad->uid);
$last_post['time'] = format_interval(time() - $nodeLoad->created);
}
Then I go on rendering it as I would like to. Anyways -- it is a totally custom job. Want the whole chunk of code?
jordan
This site is fantastic! Love
This site is fantastic! Love it!
mobile content
hi, first up its a really nice site, like the design and the concept of the site, really cool!
i noticed you have mobile interaction (http://www.gimme20.com/mobile), i was wondering how you set this up (modules and service provider??)?? i want to add the ability for users to text images to galleries on my site but i don't know where to begin looking so any help would be brilliant.
thanks
Tom
www.adrenalinehub.com
drupal mobile theme
Actually, it is just the standard drupal mobile theme that is publically available.
Check these out:
http://drupal.org/node/26357
http://drupal.org/project/mobile
Enjoy!
J
Forum
That is a very nice site. I like the forum layout. Is that Drupal's forum or did you use VBulletin? The integration is very sweet.