I'll try explain...
Im little rewrite news module (vbadvanced), for last posts:
PHP Code:
$getnews = $db->query_read("
SELECT $ratingsql user.*, thread.threadid, post.title, thread.title, thread.replycount, post.username AS puname, post.userid AS puid, postusername, postuserid, post.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
$vba_news_fields
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.lastpostid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
$vba_news_join
WHERE thread.threadid IN(" . implode(',', $newstids) . ")
" . iif(!$threadsqueried AND $mod_options['portal_news_cutoffdate'], 'AND thread.dateline > ' . (TIMENOW - ($mod_options['portal_news_cutoffdate'] * 86400))) . "
" . iif($ignusers, 'AND thread.postuserid NOT IN(' . $ignusers . ')') . "
" . iif($mod_options['portal_applypermissions'], $forumperms_query) . "
AND rel_yn = 1
ORDER BY " . iif($mod_options['portal_news_sticky'], 'sticky DESC, ') . $mod_options['portal_news_orderby'] . " $mod_options[portal_news_direction]
" . iif($limitapplied, 'LIMIT ' . ($mod_options['portal_news_maxposts'] + $mod_options['portal_news_enablearchive']), $newslimit) . "
");
Where "rel_yn" is custom added cell of "post" table, with values 0 and 1. So, if post have value = 1 message showing on main page, else not showing.
The case for small, add checkbox in posting form, where you can choose send message on main page or not (check or uncheck checkbox).
So, how did this?
Checkbox in template:
HTML Code:
<label for="cb_rel_yn"><input type="checkbox" name="rel_yn" value="1" id="cb_rel_yn" tabindex="1" $checked[rel_yn] />Send this message on main page?</label>
In attach screenshot how it will be look and product where i was trying realise this...
Pls help.
11-27-2008, 02:41 PM
Hybrid Mode
