Showcase Competition Leaders

Howdy folks!  To celebrate the launch and “rebirth” of the new Shuttertalk site, we have partnered with BlackRapid to offer some giveaways to our supporters!  Entry is open to everyone, so read on to see how your can score your freebie.

1 x BlackRapid RS-Sport camera strap, valued at $69.95 USD
Post a photo in our showcase forum, and the owner of the thread receiving the most replies from other members (excluding own posts) at the close of the competition, wins!

Note that you need to register as a forum member to post.

These are the current leaders in the running to win the prize above.

Current Showcase Leaders

[php useadvancedfilter]
global $wpdb;
$query = $wpdb->prepare(“SELECT t.tid, t.fid, t.subject, ” .
“t.uid, t.username, t.replies, t.dateline, t.lastpost, ” .
“t.lastposter, t.lastposteruid, count(p.pid) as cnt ” .
“FROM mybb_threads t, mybb_posts p ” .
“WHERE p.tid = t.tid ” .
“AND p.uid != t.uid ” .
“AND t.visible = 1 ” .
“AND t.fid in (’21’, ’26’, ’29’, ’38’) ” .
“AND t.dateline > 1329609600 ” .
“GROUP BY t.tid ” .
“ORDER BY cnt DESC LIMIT %d”, 10);
$results = $wpdb->get_results($query);

foreach($results as $entry) {

$username = $entry->username;
$uid = $entry->lastposteruid;
$url = ‘forums/showthread.php?tid=’.$entry->tid;
$subject = $entry->subject;
$replies = $entry->replies;
$lastpost = $entry->lastpost;
$lastposter = $entry->lastposter;
$replies_minus = $entry->cnt;

if ($lastpost > (time() – (1 * 24 * 60 * 60))) {
$lastpostdate = “Today ” . date(“H:i”, $lastpost);
} else if ($lastpost > (time() – (2 * 24 * 60 * 60))) {
$lastpostdate = “Yesterday ” . date(“H:i”, $lastpost);
} else {
$lastpostdate = date(“M j H:i”, $lastpost);
}

echo “

\n”;
}

[/php useadvancedfilter]

SubjectAuthorTotal RepliesNon-Author RepliesLast Post
” . ‘‘ . $subject . “” . $username . “” . $replies . “$replies_minus” . $lastpostdate . ” by ” . $lastposter . “

Note this competition closes at 10pm Australian Eastern Standard Time (GMT+10) on the Sun 26th Feb 2012.  Winners will be announced at midnight and all decisions are at the sole discretion of Shuttertalk, and are final. See the full details of the competition here!

All the best!

Leave a Comment