 |
 |
 |
 |
Registered: 06/13/06
Posts: 155
|
|
|
 |
 |
 |
 |
|
|
|
|
|
|
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
|
|
|
|
|
|
|
|
|
|
|
#221790 - 01/31/09 01:43 PM
Re: 7.5 Discussion
[Re: Rick]
|
Carpal Tunnel
|
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
|
|
Ive been given a script for the most viewed Thread. (From Script keeper) See it here http://www.audiotoolers.com/ubbt/ubbthreads.php/forum_summary.htmlwith a little tweak it could behave as This weeks most viewed Topics. With it being locked down to X days then it wont stand still. 7 days being from the date of creation? $notIn = '6';
$limit = 10;
$orderBy = 't.TOPIC_VIEWS';
$notIn = ($notIn) ? 'WHERE f.FORUM_ID NOT IN ('.$notIn.') ' : 'WHERE 1 ';
$stuff = '<table width="100%" cellspacing="0" cellpadding="1" border="0">';
$query = "
SELECT t.TOPIC_SUBJECT, t.TOPIC_VIEWS, t.POST_ID
FROM {$config['TABLE_PREFIX']}TOPICS t,
{$config['TABLE_PREFIX']}POSTS p,
{$config['TABLE_PREFIX']}FORUMS f,
{$config['TABLE_PREFIX']}USERS u
$notIn
AND t.FORUM_ID = f.FORUM_ID
AND t.TOPIC_IS_APPROVED = 1
AND t.TOPIC_LAST_POST_ID = p.POST_ID
AND t.TOPIC_LAST_POSTER_ID = u.USER_ID
ORDER BY $orderBy DESC
LIMIT $limit
";
$sth = $dbh->do_query($query,__LINE__,__FILE__);
$innerds = '';
$rowNum = 0;
while(list($pSubj,$tViews,$tPostID) = $dbh->fetch_array($sth)) {
$count = $tViews;
$innerds .= '<tr><td align=left style="border-bottom: 1px solid #202020;"><a href="'.$config['FULL_URL'].'/ubbthreads.php?ubb=showflat&Number='.$tPostID.'">'.$pSubj.'</a></td>
<td align=right valign=top style="border-bottom: 1px solid #202020;">'.$count.'</td></tr>';
$rowNum++;
}
$stuff .= $innerds.'</table>';
$body = <<<EOF
$stuff
EOF;
Sir Dude put the above together so credits to him  So that could be a New Stock Custom island ? Just an idea as your looking for something quick.
_________________________
Version v7.5.6 < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#221806 - 01/31/09 07:50 PM
Re: 7.5 Discussion
[Re: Yarp™]
|
enthusiast
|
Registered: 03/26/08
Posts: 339
Loc: North Carolina
|
|
I made a "karma" hack way back in the day... and have been slowly working on one for 7.x. My time is extremely limited nowadays compared to what it used to be, so if you guys want to make it an official feature, I wouldn't complain!  What I'm trying to do with this one is have it so there is a +/- link (of sorts) with each post. One link to say it's a good post, another to say it's garbage. This will build up, or knock down, people's "karma points." The number of points a member's karma click of a post would give or take away would be set by group. Also, a group may only give a karma click to any given post once (first come, first serve) with the exception of administrators and moderators. This could be permissions-based too for any group. Finally, the reason I want to do this at all, this would be tied in to automatic promotions. Once reaching a predetermined number of points, a member will be promoted to the next group, and vice-verse if their points drop. I have never been one to award titles or ranking completely based on post count -- I'm more of a "quality" person, and this is the perfect solution. Anyway, I know it reads like a lot, but it's a simple mod that can be finished in less than a full day's of work I'm sure.
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
you, 
Previous Topic
Index
