Lottery gives a random amount of cash depending on how many people have played the lottery to someone
1 2007-07-19 08:24
Re: Cash Mod 1.0.0 (63 replies, posted in PunBB 1.2 modifications, plugins and integrations)
2 2007-06-25 19:55
Re: Subforums Mod (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)
3 2007-06-24 17:06
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
p0Wer wrote:Connorhd wrote:<?php define('PUN_ROOT', './'); define('PUN_QUIET_VISIT', 1); require PUN_ROOT.'include/common.php'; $page_title = pun_htmlspecialchars($pun_config['o_board_title']); define('PUN_ALLOW_INDEX', 1); require PUN_ROOT.'header.php'; require PUN_ROOT.'include/parser.php'; function pun_news($fid=1, $show=15, $truncate=1) { global $lang_common, $db, $pun_config, $db_prefix; $max_subject_length = 30; $show_max_topics = 50; $order_by = 't.posted'; $forum_sql = ''; // Was a forum ID supplied? if ( $fid ) $forum_sql = 'f.id='.$fid.' AND '; $show = intval($show); if ($show < 1 || $show > $show_max_topics) $show = 15; $saveddate=""; // Fetch $show topics if (is_array($fid)) $result = $db->query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM '.$db_prefix.'topics AS t INNER JOIN '.$db_prefix.'forums AS f ON t.forum_id=f.id WHERE f.id IN ('.implode(",",$fid).') AND t.moved_to IS NULL ORDER BY '.$order_by.' DESC') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error()); else { $fid = intval($fid); $result = $db->query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM '.$db_prefix.'topics AS t INNER JOIN '.$db_prefix.'forums AS f ON t.forum_id=f.id WHERE f.id='.$fid.' AND t.moved_to IS NULL ORDER BY '.$order_by.' DESC') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error()); } $show_count = 0; if ( !$db->num_rows($result) ) return $output; while ( ($show_count < $show) && ($cur_topic = $db->fetch_assoc($result)) ) { $temp = ''; if ($pun_config['o_censoring'] == '1') $cur_topic['subject'] = censor_words($cur_topic['subject']); if (pun_strlen($cur_topic['subject']) > $max_subject_length) $subject_truncated = trim(substr($cur_topic['subject'], 0, ($max_subject_length-5))).' ...'; else $subject_truncated = $cur_topic['subject']; $newsheading = '<a href="'.$pun_config['o_base_url'].'/viewtopic.php?id='.$cur_topic['id'].'&action=new" title="'.pun_htmlspecialchars($cur_topic['subject']).'">'.pun_htmlspecialchars($subject_truncated).'</a> - <em>Posted by '.$cur_topic['poster'].' at '.date('h:i A', $cur_topic['posted']).'</em><br>'; // Group posts by date $thisdate = date('l, d F Y', $cur_topic['posted']); if ($thisdate != $saveddate) { if ($saveddate) { $temp .= "</div></div>"; } $temp .= '<div class="block"><h2><span>'.$thisdate.'</span></h2><div class="box"><div class="inbox"><p>'; $saveddate = $thisdate; } else { $temp .= '<div class="inbox"><p>'; } $temp .= $newsheading.'</p><p>'; $id = $cur_topic['id']; $msg = $db->query('SELECT id, poster, poster_id, poster_ip, poster_email, message, posted, edited, edited_by FROM '.$db_prefix.'posts WHERE topic_id='.$id.' LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); if ( !$db->num_rows($msg) ) continue; $cur_post = $db->fetch_assoc($msg); // Display first paragraph only (comment out next four lines to turn off) if ($truncate == 1) { $paragraph = preg_split("/s*n+/", $cur_post['message']); if (isset($paragraph[1])) { $cur_post['message'] = $paragraph[0] . "..."; } } $cur_post['message'] = parse_message($cur_post['message'], 0); $temp .= $cur_post['message']; $temp .= "</p></div>"; if (isset($output)) { $output .= $temp; } else { $output = $temp; } ++$show_count; } // end of while $output .= "</div></div>"; return $output; } ?> <div class="block"> <h2><span>Welcome</span></h2> <div class="box"> <div class="inbox"> <p> Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent augue. Nulla facilisi. Fusce bibendum accumsan erat. Quisque sollicitudin mattis neque. Sed dapibus. Integer a lectus eu sem consequat pellentesque. Morbi rhoncus nulla. Duis adipiscing interdum velit. Fusce ante. Ut vitae enim sit amet magna sodales hendrerit. In sed tortor at sapien convallis eleifend. Proin mauris. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Ut metus. Cras ac arcu et arcu porttitor blandit. Nam vitae lectus eget mauris sollicitudin placerat. Suspendisse vestibulum. Donec varius libero. Duis velit tellus, euismod vitae, consequat sed, consectetuer ut, purus. </p> <p> Praesent viverra venenatis magna. Etiam in dolor. Ut in justo ac nibh malesuada cursus. Duis urna arcu, aliquam vitae, consequat nec, tincidunt non, mi. Nunc lobortis. Nunc pharetra. Sed porttitor. Maecenas turpis tortor, blandit nec, dignissim in, porttitor eu, odio. In hac habitasse platea dictumst. Suspendisse augue odio, ornare a, elementum ac, tincidunt varius, orci. Nulla libero ante, hendrerit ac, consectetuer eu, sollicitudin et, eros. Duis sapien. Suspendisse ornare enim sit amet dui. Donec ullamcorper diam. </p> </div> </div> </div> <?php echo pun_news(1, 5, 0); require PUN_ROOT.'footer.php';
instead of 1 for the forum id put array(1,2,3,4) with a list of the forums you want :)
I've done that now, but the index only shows the text at the bottom of the file, it doesn't show any topics :(
What do you mean? it shows the php code? in which case did you delete a <?php
No, it only showed: <p>
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent augue. Nulla facilisi. Fusce bibendum accumsan erat. Quisque sollicitudin mattis neque. Sed dapibus. Integer a lectus eu sem consequat pellentesque. Morbi rhoncus nulla. Duis adipiscing interdum velit. Fusce ante. Ut vitae enim sit amet magna sodales hendrerit. In sed tortor at sapien convallis eleifend. Proin mauris. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Ut metus. Cras ac arcu et arcu porttitor blandit. Nam vitae lectus eget mauris sollicitudin placerat. Suspendisse vestibulum. Donec varius libero. Duis velit tellus, euismod vitae, consequat sed, consectetuer ut, purus.
</p>
<p>
Praesent viverra venenatis magna. Etiam in dolor. Ut in justo ac nibh malesuada cursus. Duis urna arcu, aliquam vitae, consequat nec, tincidunt non, mi. Nunc lobortis. Nunc pharetra. Sed porttitor. Maecenas turpis tortor, blandit nec, dignissim in, porttitor eu, odio. In hac habitasse platea dictumst. Suspendisse augue odio, ornare a, elementum ac, tincidunt varius, orci. Nulla libero ante, hendrerit ac, consectetuer eu, sollicitudin et, eros. Duis sapien. Suspendisse ornare enim sit amet dui. Donec ullamcorper diam.
Didn't show any topics from any forums :/
4 2007-06-24 17:05
Re: Subforums (4 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Stop bumping your threads, or you will be banned, and stop being generally annoying, i.e. stuff like REWARD in the topic.
Jeeze, calm down, it was a joke .
Anyway, I have it all sorted now, thanks.
5 2007-06-24 08:18
Re: Subforums (4 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Please help.
6 2007-06-24 00:04
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
power we have been working on a new index.php for a while at this threat maybe this will help you!
http://punbb.org/forums/viewtopic.php?id=16296&p=5Q
I'll wait until it's completed, thanks!
7 2007-06-24 00:02
Topic: Subforums (4 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Hiya all.
Got a small problem here.
As you can see, the subforum is being repeated (yes it happens in all parent forums):
Can someone please remove the code from what is circled in red? Yes, that includes the two "Index >Chat" links I want to keep the other sub forum how it is (the one that is not hilighted
Here is my viewforum.php code:
<?php
/***********************************************************************
Copyright (C) 2002-2005 Rickard Andersson (rickard@punbb.org)
This file is part of PunBB.
PunBB is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published
by the Free Software Foundation; either version 2 of the License,
or (at your option) any later version.
PunBB is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston,
MA 02111-1307 USA
************************************************************************/
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';
if ($pun_user['g_read_board'] == '0')
message($lang_common['No view']);
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
if ($id < 1)
message($lang_common['Bad request']);
// Load the viewforum.php language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/index.php';// Load poll language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/forum.php';// Load poll language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/polls.php';
// Fetch some info about the forum
$result = $db->query('SELECT f.forum_name, pf.forum_name AS parent_forum, f.redirect_url, f.moderators, f.num_topics, f.sort_by, f.parent_forum_id, fp.post_topics FROM '.$db->prefix.'forums AS f LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') LEFT JOIN '.$db->prefix.'forums AS pf ON f.parent_forum_id=pf.id WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id='.$id) or error('Unable to fetch forum info', __FILE__, __LINE__, $db->error());
if (!$db->num_rows($result))
message($lang_common['Bad request']);
$cur_forum = $db->fetch_assoc($result);
// Is this a redirect forum? In that case, redirect!
if ($cur_forum['redirect_url'] != '')
{
header('Location: '.$cur_forum['redirect_url']);
exit;
}
// Sort out who the moderators are and if we are currently a moderator (or an admin)
$mods_array = array();
if ($cur_forum['moderators'] != '')
$mods_array = unserialize($cur_forum['moderators']);
$is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false;
//=========================
//=====RATE TOPIC CODE=====
//=========================
//Eric Subach (kha0s@comcast.net)
//=========================
$rate_topic = 0;
//Make sure Rate Topic is installed, enabled, and the user is not a guest.
if (isset ($pun_config['o_rt_cur_version']) && $pun_config['o_rt_enabled'] && !$pun_user['is_guest'])
{
$rate_topic = 1;
//Check for a language pack.
if (file_exists (PUN_ROOT . 'lang/' . $pun_user['language'] . '/rate_topic.php'))
require PUN_ROOT . 'lang/' . $pun_user['language'] . '/rate_topic.php';
else if (file_exists (PUN_ROOT . 'lang/' . $pun_config['o_rt_default_lang'] . '/rate_topic.php'))
require PUN_ROOT . 'lang/' . $pun_config['o_rt_default_lang'] . '/rate_topic.php';
else
$rate_topic = 0;
}
//If it's enabled, create the link to rate the topic.
if ($rate_topic)
$pre_link = '<a href="rate.php?r_id=' . $id . '">' . $lang_rt['Rate topic'] . '</a> / ';
//==================
//=====END CODE=====
//==================
// Can we or can we not post new topics?
if (($cur_forum['post_topics'] == '' && $pun_user['g_post_topics'] == '1') || $cur_forum['post_topics'] == '1' || $is_admmod)
$post_link = "\t\t".'<p class="postlink conr"><a href="post.php?fid='.$id.'">'.$lang_forum['Post topic'].'</a> <BR /> <a href="poll.php?fid='.$id.'">'.$lang_polls['New poll'].'</a></p>'."\n";
else
$post_link = '';
// Determine the topic offset (based on $_GET['p'])
$num_pages = ceil($cur_forum['num_topics'] / $pun_user['disp_topics']);
$p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p'];
$start_from = $pun_user['disp_topics'] * ($p - 1);
// Generate paging links
$paging_links = $lang_common['Pages'].': '.paginate($num_pages, $p, 'viewforum.php?id='.$id);
$page_title = pun_htmlspecialchars($pun_config['o_board_title'].' / '.$cur_forum['forum_name']);
define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'header.php';
# Option Note: if you do not want the subforums displaying at the top
# when you go into the main forum topic
# then in the following $sub_forum_result query change
# - ORDER BY disp_position') - to
# - ORDER BY disp_position', true) - (without the dashes)
#
$subforum_result = $db->query('SELECT forum_desc, forum_name, id, last_post, last_post_id, last_poster, moderators, num_posts, num_topics, redirect_url FROM '.$db->prefix.'forums WHERE parent_forum_id='.$id.' ORDER BY disp_position') or error('Unable to fetch sub forum info',__FILE__,__LINE__,$db->error());
if($db->num_rows($subforum_result))
{
?>
<div class="linkst">
<div class="inbox">
<ul><li><a href="index.php"><?php echo $lang_common['Index'] ?></a> </li><li>» <?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></li></ul>
<div class="clearer"></div>
</div>
</div>
<div id="vf" class="blocktable">
<h2><span>Sub forums</span></h2>
<div class="box">
<div class="inbox">
<table cellspacing="0">
<thead>
<tr>
<th class="tcl" scope="col"><?php echo $lang_common['Forum'] ?></th>
<th class="tc2" scope="col"><?php echo $lang_index['Topics'] ?></th>
<th class="tc3" scope="col"><?php echo $lang_common['Posts'] ?></th>
<th class="tcr" scope="col"><?php echo $lang_common['Last post'] ?></th>
</tr>
</thead>
<tbody>
<?php
while($cur_subforum = $db->fetch_assoc($subforum_result))
{
$item_status = '';
$icon_text = $lang_common['Normal icon'];
$icon_type = 'icon';
// Are there new posts?
if (!$pun_user['is_guest'] && $cur_subforum['last_post'] > $pun_user['last_visit'])
{
$item_status = 'inew';
$icon_text = $lang_common['New icon'];
$icon_type = 'icon inew';
}
// Is this a redirect forum?
if ($cur_forum['redirect_url'] != '')
{
$forum_field = '<h3><a href="'.pun_htmlspecialchars($cur_subforum['redirect_url']).'" title="'.$lang_index['Link to'].' '.pun_htmlspecialchars($cur_subforum['redirect_url']).'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
$num_topics = $num_posts = ' ';
$item_status = 'iredirect';
$icon_text = $lang_common['Redirect icon'];
$icon_type = 'icon';
}
else
{
$forum_field = '<h3><a href="viewforum.php?id='.$cur_subforum['id'].'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
$num_topics = $cur_subforum['num_topics'];
$num_posts = $cur_subforum['num_posts'];
}
if ($cur_subforum['forum_desc'] != '')
$forum_field .= "\n\t\t\t\t\t\t\t\t".$cur_subforum['forum_desc'];
// If there is a last_post/last_poster.
if ($cur_subforum['last_post'] != '')
$last_post = '<a href="viewtopic.php?pid='.$cur_subforum['last_post_id'].'#p'.$cur_subforum['last_post_id'].'">'.format_time($cur_subforum['last_post']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_subforum['last_poster']).'</span>';
else
$last_post = ' ';
if ($cur_subforum['moderators'] != '')
{
$mods_array = unserialize($cur_subforum['moderators']);
$moderators = array();
while (list($mod_username, $mod_id) = @each($mods_array))
$moderators[] = '<a href="profile.php?id='.$mod_id.'">'.pun_htmlspecialchars($mod_username).'</a>';
$moderators = "\t\t\t\t\t\t\t\t".'<p><em>('.$lang_common['Moderated by'].'</em> '.implode(', ', $moderators).')</p>'."\n";
}
?>
<tr<?php if ($item_status != '') echo ' class="'.$item_status.'"'; ?>>
<td class="tcl">
<div class="intd">
<div class="<?php echo $icon_type ?>"><div class="nosize"><?php echo $icon_text ?></div></div>
<div class="tclcon">
<?php echo $forum_field;
if ($cur_subforum['moderators'] != '') {
echo "\n".$moderators;
}
?>
</div>
</div>
</td>
<td class="tc2"><?php echo $num_topics ?></td>
<td class="tc3"><?php echo $num_posts ?></td>
<td class="tcr"><?php echo $last_post ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
<?php
}
$subforum_result = $db->query('SELECT forum_desc, forum_name, id, last_post, last_post_id, last_poster, moderators, num_posts, num_topics, redirect_url FROM '.$db->prefix.'forums WHERE parent_forum_id='.$id.' ORDER BY disp_position') or error('Unable to fetch sub forum info',__FILE__,__LINE__,$db->error());
if($db->num_rows($subforum_result))
{
?>
<div class="linkst">
<div class="inbox">
<ul><li><a href="index.php"><?php echo $lang_common['Index'] ?></a> </li><li>» <?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></li></ul>
<div class="clearer"></div>
</div>
</div>
<div id="vf" class="blocktable">
<h2><span>Sub forums</span></h2>
<div class="box">
<div class="inbox">
<table cellspacing="0">
<thead>
<tr>
<th class="tcl" scope="col"><?php echo $lang_common['Forum'] ?></th>
<th class="tc2" scope="col"><?php echo $lang_index['Topics'] ?></th>
<th class="tc3" scope="col"><?php echo $lang_common['Posts'] ?></th>
<th class="tcr" scope="col"><?php echo $lang_common['Last post'] ?></th>
</tr>
</thead>
<tbody>
<?php
while($cur_subforum = $db->fetch_assoc($subforum_result))
{
$item_status = '';
$icon_text = $lang_common['Normal icon'];
$icon_type = 'icon';
// Are there new posts?
if (!$pun_user['is_guest'] && $cur_subforum['last_post'] > $pun_user['last_visit'])
{
$item_status = 'inew';
$icon_text = $lang_common['New icon'];
$icon_type = 'icon inew';
}
// Is this a redirect forum?
if ($cur_forum['redirect_url'] != '')
{
$forum_field = '<h3><a href="'.pun_htmlspecialchars($cur_subforum['redirect_url']).'" title="'.$lang_index['Link to'].' '.pun_htmlspecialchars($cur_subforum['redirect_url']).'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
$num_topics = $num_posts = ' ';
$item_status = 'iredirect';
$icon_text = $lang_common['Redirect icon'];
$icon_type = 'icon';
}
else
{
$forum_field = '<h3><a href="viewforum.php?id='.$cur_subforum['id'].'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
$num_topics = $cur_subforum['num_topics'];
$num_posts = $cur_subforum['num_posts'];
}
if ($cur_subforum['forum_desc'] != '')
$forum_field .= "\n\t\t\t\t\t\t\t\t".$cur_subforum['forum_desc'];
// If there is a last_post/last_poster.
if ($cur_subforum['last_post'] != '')
$last_post = '<a href="viewtopic.php?pid='.$cur_subforum['last_post_id'].'#p'.$cur_subforum['last_post_id'].'">'.format_time($cur_subforum['last_post']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_subforum['last_poster']).'</span>';
else
$last_post = ' ';
if ($cur_subforum['moderators'] != '')
{
$mods_array = unserialize($cur_subforum['moderators']);
$moderators = array();
while (list($mod_username, $mod_id) = @each($mods_array))
$moderators[] = '<a href="profile.php?id='.$mod_id.'">'.pun_htmlspecialchars($mod_username).'</a>';
$moderators = "\t\t\t\t\t\t\t\t".'<p><em>('.$lang_common['Moderated by'].'</em> '.implode(', ', $moderators).')</p>'."\n";
}
?>
<tr<?php if ($item_status != '') echo ' class="'.$item_status.'"'; ?>>
<td class="tcl">
<div class="intd">
<div class="<?php echo $icon_type ?>"><div class="nosize"><?php echo $icon_text ?></div></div>
<div class="tclcon">
<?php echo $forum_field;
?>
</div>
</div>
</td>
<td class="tc2"><?php echo $num_topics ?></td>
<td class="tc3"><?php echo $num_posts ?></td>
<td class="tcr"><?php echo $last_post ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
<?php
}
//=========================
//=====RATE TOPIC CODE=====
//=========================
//Eric Subach (kha0s@comcast.net)
//=========================
$rate_topic = 0;
$rate_stars = 0;
//Check if Rate Topic is installed and enabled.
if (isset ($pun_config['o_rt_cur_version']) && $pun_config['o_rt_enabled'])
{
$rate_topic = 1;
//Check for language pack.
if (file_exists (PUN_ROOT . 'lang/' . $pun_user['language'] . '/rate_topic.php'))
require PUN_ROOT . 'lang/' . $pun_user['language'] . '/rate_topic.php';
else if (file_exists (PUN_ROOT . 'lang/' . $pun_config['o_rt_default_lang'] . '/rate_topic.php'))
require PUN_ROOT . 'lang/' . $pun_config['o_rt_default_lang'] . '/rate_topic.php';
else
$rate_topic = 0;
//Check if using stars or numbers.
if ($pun_config['o_rt_use_stars'])
if (file_exists (PUN_ROOT . 'img/rate_stars/' . $pun_config['o_rt_cur_stars']))
$rate_stars = 1;
}
//==================
//=====END CODE=====
//==================
?>
<div class="linkst">
<div class="inbox">
<p class="pagelink conl"><?php echo $paging_links ?></p>
<?php
echo $post_link;
if($cur_forum['parent_forum'])
echo "\t\t".'<ul><li><a href="index.php">'.$lang_common['Index'].'</a> </li><li>» <a href="viewforum.php?id='.$cur_forum['parent_forum_id'].'">'.pun_htmlspecialchars($cur_forum['parent_forum']).'</a> </li><li>» '.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
else
echo "\t\t".'<ul><li><a href="index.php">'.$lang_common['Index'].' </a> </li><li>» '.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
?>
<div class="clearer"></div>
</div>
</div>
<div id="vf" class="blocktable">
<h2><span><?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></span></h2>
<div class="box">
<div class="inbox">
<table cellspacing="0">
<thead>
<tr>
<th class="tcl" scope="col"><?php echo $lang_common['Topic'] ?></th>
<!-- MOD AUTHOR COLUMN 1 line folowing added -->
<th class="tc2" scope="col" style="WIDTH: 12%"><?php echo $lang_common['Author'] ?></th>
<th class="tc2" scope="col"><?php echo $lang_common['Replies'] ?></th>
<th class="tc3" scope="col"><?php echo $lang_forum['Views'] ?></th>
<th class="tcr" scope="col"><?php echo $lang_common['Last post'] ?></th>
</tr>
</thead>
<tbody>
<?php
// Fetch list of topics to display on this page
// <!-- MOD AUTHOR COLUMN - SWITCH BLOCK -->
switch ($db_type)
{
case 'mysql':
case 'mysqli':
$sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, sum(r.rate) AS rate, count(r.user_id) AS num_ratings FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id LEFT JOIN '.$db->prefix.'Ratings AS r ON t.id=r.topic_id WHERE t.forum_id='.$id.' GROUP BY t.id ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
break;
case 'sqlite':
$sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, sum(r.rate) AS rate, count(r.user_id) AS num_ratings FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id WHERE t.id IN(SELECT id FROM '.$db->prefix.'topics WHERE forum_id='.$id.' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'].') GROUP BY t.id ORDER BY t.sticky DESC, t.last_post DESC';
break;
default:
$sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, sum(r.rate) AS rate, count(r.user_id) AS num_ratings FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id LEFT JOIN '.$db->prefix.'Ratings AS r ON t.id=r.topic_id WHERE t.forum_id='.$id.' GROUP BY t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
break;
}
$result = $db->query($sql) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
// If there are topics in this forum.
if ($db->num_rows($result))
{
while ($cur_topic = $db->fetch_assoc($result))
{
$icon_text = $lang_common['Normal icon'];
$item_status = '';
$icon_type = 'icon';
// MOD AUTHOR COLUMN 1 following line added
$author = '<a href="profile.php?id='.$cur_topic['has_posted'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a>';
if ($cur_topic['moved_to'] == null)
$last_post = '<a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'">'.format_time($cur_topic['last_post']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['last_poster']).'</span>';
else
$last_post = ' ';
if ($pun_config['o_censoring'] == '1')
$cur_topic['subject'] = censor_words($cur_topic['subject']);
if ($cur_topic['question'] != '') {
if ($pun_config['o_censoring'] == '1')
$cur_topic['question'] = censor_words($cur_topic['question']);
if ($cur_topic['moved_to'] != 0)
$subject = $lang_forum['Moved'].': '.$lang_polls['Poll'].': <a href="viewpoll.php?id='.$cur_topic['moved_to'].'">'.pun_htmlspecialchars($cur_topic['question']).'</a><br /> <span class="byuser"><b>'.pun_htmlspecialchars($cur_topic['subject']).'</b> '.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
else if ($cur_topic['closed'] == '0')
$subject = $lang_polls['Poll'].': <a href="viewpoll.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($cur_topic['question']).'</a><br \> <span class="byuser"><b>'.pun_htmlspecialchars($cur_topic['subject']).'</b> '.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
else
{
$subject = $lang_polls['Poll'].': <a href="viewpoll.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($cur_topic['question']).'</a><br /> <span class="byuser"><b>'.pun_htmlspecialchars($cur_topic['subject']).'</b> '.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
$icon_text = $lang_common['Closed icon'];
$item_status = 'iclosed';
}
if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'] && $cur_topic['moved_to'] == null)
{
$icon_text .= ' '.$lang_common['New icon'];
$item_status .= ' inew';
$icon_type = 'icon inew';
$subject = '<strong>'.$subject.'</strong>';
$subject_new_posts = '<span class="newtext">[ <a href="viewpoll.php?id='.$cur_topic['id'].'&action=new" title="'.$lang_common['New posts info'].'">'.$lang_common['New posts'].'</a> ]</span>';
}
else
$subject_new_posts = null;
// Should we display the dot or not? :)
if (!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1')
{
if ($cur_topic['has_posted'] == $pun_user['id'])
$subject = '<strong>·</strong> '.$subject;
else
$subject = ' '.$subject;
}
// MOD AUTHOR COLUMN 2 following lines added
else
$subject = ' '.$subject;
} else {
if ($cur_topic['moved_to'] != 0)
// <!-- MOD AUTHOR COLUMN 1 line folowing modified -->
$subject = $lang_forum['Moved'].': <a href="viewtopic.php?id='.$cur_topic['moved_to'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a>';
else if ($cur_topic['closed'] == '0')
// <!-- MOD AUTHOR COLUMN 1 line folowing modified -->
$subject = '<a href="viewtopic.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a>';
else
{
// <!-- MOD AUTHOR COLUMN 1 line folowing modified -->
$subject = '<a href="viewtopic.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a>';
$icon_text = $lang_common['Closed icon'];
$item_status = 'iclosed';
}
if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'] && $cur_topic['moved_to'] == null)
{
$icon_text .= ' '.$lang_common['New icon'];
$item_status .= ' inew';
$icon_type = 'icon inew';
$subject = '<strong>'.$subject.'</strong>';
$subject_new_posts = '<span class="newtext">[ <a href="viewtopic.php?id='.$cur_topic['id'].'&action=new" title="'.$lang_common['New posts info'].'">'.$lang_common['New posts'].'</a> ]</span>';
}
else
$subject_new_posts = null;
// Should we display the dot or not? :)
if (!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1')
{
if ($cur_topic['has_posted'] == $pun_user['id'])
$subject = '<strong>·</strong> '.$subject;
else
$subject = ' '.$subject;
}
}
if ($cur_topic['sticky'] == '1')
{
$subject = '<span class="stickytext">'.$lang_forum['Sticky'].': </span>'.$subject;
$item_status .= ' isticky';
$icon_text .= ' '.$lang_forum['Sticky'];
}
$num_pages_topic = ceil(($cur_topic['num_replies'] + 1) / $pun_user['disp_posts']);
if ($num_pages_topic > 1)
{
if ($cur_topic['question'] != '')
$subject_multipage = '[ '.paginate($num_pages_topic, -1, 'viewpoll.php?id='.$cur_topic['id']).' ]';
else
$subject_multipage = '[ '.paginate($num_pages_topic, -1, 'viewtopic.php?id='.$cur_topic['id']).' ]';
}
else
$subject_multipage = null;
// Should we show the "New posts" and/or the multipage links?
if (!empty($subject_new_posts) || !empty($subject_multipage))
{
$subject .= ' '.(!empty($subject_new_posts) ? $subject_new_posts : '');
$subject .= !empty($subject_multipage) ? ' '.$subject_multipage : '';
}
//=========================
//=====RATE TOPIC CODE=====
//=========================
//Eric Subach (kha0s@comcast.net)
//=========================
if ($rate_topic)
{
//If any ratings, calculate the overall rating.
if ($cur_topic['num_ratings'] > 0)
{
$rating = $cur_topic['rate'] / $cur_topic['num_ratings'];
$rating = round ($rating, 2);
$subject .= ' ';
//If the user is not a guest, make the rating clickable to view who voted.
if (!$pun_user['is_guest'])
$subject .= '<a href="rate.php?v_id=' . $cur_topic['id'] . '">';
//Rating is rounded to the closest star or half-star.
//If stars are enabled, find what image file to load.
if ($rate_stars)
{
if ($rating >= 0.0 && $rating < 0.25)
$file_name = 'Star_0';
else if ($rating >= 0.25 && $rating < 0.75)
$file_name = 'Star_0_Half';
else if ($rating >= 0.75 && $rating < 1.25)
$file_name = 'Star_1';
else if ($rating >= 1.25 && $rating < 1.75)
$file_name = 'Star_1_Half';
else if ($rating >= 1.75 && $rating < 2.25)
$file_name = 'Star_2';
else if ($rating >= 2.25 && $rating < 2.75)
$file_name = 'Star_2_Half';
else if ($rating >= 2.75 && $rating < 3.25)
$file_name = 'Star_3';
else if ($rating >= 3.25 && $rating < 3.75)
$file_name = 'Star_3_Half';
else if ($rating >= 3.75 && $rating < 4.25)
$file_name = 'Star_4';
else if ($rating >= 4.25 && $rating < 4.75)
$file_name = 'Star_4_Half';
else
$file_name = 'Star_5';
$subject .= '<img src="' . PUN_ROOT . 'img/rate_stars/' . $pun_config['o_rt_cur_stars'] . '/' . $file_name . '.gif" />';
}
//Otherwise, use numbers.
else
{
$decimal = ($rating - floor ($rating)) * 100;
$rating = floor ($rating);
if ($decimal >= 25 && $decimal < 75)
$rating += 0.5;
if ($decimal >= 75)
$rating += 1;
$subject .= '<strong><small>' . $rating . ' / 5</small></strong>';
}
//If the link was made clickable, end the tag.
if (!$pun_user['is_guest'])
$subject .= '</a>';
}
}
//==================
//=====END CODE=====
//==================
?>
<tr<?php if ($item_status != '') echo ' class="'.trim($item_status).'"'; ?>>
<td class="tcl">
<div class="intd">
<div class="<?php echo $icon_type ?>"><div class="nosize"><?php echo trim($icon_text) ?></div></div>
<div class="tclcon">
<?php echo $subject."\n" ?>
</div>
</div>
</td>
<!-- MOD AUTHOR COLUMN 1 line folowing added -->
<td class="tc2" style="WIDTH: 12%"><?php echo ($cur_topic['moved_to'] == null) ? $author : ' ' ?></td>
<td class="tc2"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_replies'] : ' ' ?></td>
<td class="tc3"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_views'] : ' ' ?></td>
<td class="tcr"><?php echo $last_post ?></td>
</tr>
<?php
}
}
else
{
?>
<tr>
<td class="tcl" colspan="4"><?php echo $lang_forum['Empty forum'] ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
<div class="linksb">
<div class="inbox">
<p class="pagelink conl"><?php echo $paging_links ?></p>
<?php
echo $post_link;
if($cur_forum['parent_forum'])
echo "\t\t".'<ul><li><a href="index.php">'.$lang_common['Index'].'</a> </li><li>» <a href="viewforum.php?id='.$cur_forum['parent_forum_id'].'">'.pun_htmlspecialchars($cur_forum['parent_forum']).'</a> </li><li>» '.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
else
echo "\t\t".'<ul><li><a href="index.php">'.$lang_common['Index'].' </a> </li><li>» '.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
?>
<div class="clearer"></div>
</div>
</div>
<?php
$forum_id = $id;
$footer_style = 'viewforum';
require PUN_ROOT.'footer.php';
Thanks VER MUCH.
Did the "reward" grab your attantion? If so, there's no reward I'm afaraid, but if you're desperate, I can offer you something at my forums
Thanks,
p0Wer~
8 2007-06-23 23:52
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
<?php define('PUN_ROOT', './'); define('PUN_QUIET_VISIT', 1); require PUN_ROOT.'include/common.php'; $page_title = pun_htmlspecialchars($pun_config['o_board_title']); define('PUN_ALLOW_INDEX', 1); require PUN_ROOT.'header.php'; require PUN_ROOT.'include/parser.php'; function pun_news($fid=1, $show=15, $truncate=1) { global $lang_common, $db, $pun_config, $db_prefix; $max_subject_length = 30; $show_max_topics = 50; $order_by = 't.posted'; $forum_sql = ''; // Was a forum ID supplied? if ( $fid ) $forum_sql = 'f.id='.$fid.' AND '; $show = intval($show); if ($show < 1 || $show > $show_max_topics) $show = 15; $saveddate=""; // Fetch $show topics if (is_array($fid)) $result = $db->query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM '.$db_prefix.'topics AS t INNER JOIN '.$db_prefix.'forums AS f ON t.forum_id=f.id WHERE f.id IN ('.implode(",",$fid).') AND t.moved_to IS NULL ORDER BY '.$order_by.' DESC') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error()); else { $fid = intval($fid); $result = $db->query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM '.$db_prefix.'topics AS t INNER JOIN '.$db_prefix.'forums AS f ON t.forum_id=f.id WHERE f.id='.$fid.' AND t.moved_to IS NULL ORDER BY '.$order_by.' DESC') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error()); } $show_count = 0; if ( !$db->num_rows($result) ) return $output; while ( ($show_count < $show) && ($cur_topic = $db->fetch_assoc($result)) ) { $temp = ''; if ($pun_config['o_censoring'] == '1') $cur_topic['subject'] = censor_words($cur_topic['subject']); if (pun_strlen($cur_topic['subject']) > $max_subject_length) $subject_truncated = trim(substr($cur_topic['subject'], 0, ($max_subject_length-5))).' ...'; else $subject_truncated = $cur_topic['subject']; $newsheading = '<a href="'.$pun_config['o_base_url'].'/viewtopic.php?id='.$cur_topic['id'].'&action=new" title="'.pun_htmlspecialchars($cur_topic['subject']).'">'.pun_htmlspecialchars($subject_truncated).'</a> - <em>Posted by '.$cur_topic['poster'].' at '.date('h:i A', $cur_topic['posted']).'</em><br>'; // Group posts by date $thisdate = date('l, d F Y', $cur_topic['posted']); if ($thisdate != $saveddate) { if ($saveddate) { $temp .= "</div></div>"; } $temp .= '<div class="block"><h2><span>'.$thisdate.'</span></h2><div class="box"><div class="inbox"><p>'; $saveddate = $thisdate; } else { $temp .= '<div class="inbox"><p>'; } $temp .= $newsheading.'</p><p>'; $id = $cur_topic['id']; $msg = $db->query('SELECT id, poster, poster_id, poster_ip, poster_email, message, posted, edited, edited_by FROM '.$db_prefix.'posts WHERE topic_id='.$id.' LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); if ( !$db->num_rows($msg) ) continue; $cur_post = $db->fetch_assoc($msg); // Display first paragraph only (comment out next four lines to turn off) if ($truncate == 1) { $paragraph = preg_split("/s*n+/", $cur_post['message']); if (isset($paragraph[1])) { $cur_post['message'] = $paragraph[0] . "..."; } } $cur_post['message'] = parse_message($cur_post['message'], 0); $temp .= $cur_post['message']; $temp .= "</p></div>"; if (isset($output)) { $output .= $temp; } else { $output = $temp; } ++$show_count; } // end of while $output .= "</div></div>"; return $output; } ?> <div class="block"> <h2><span>Welcome</span></h2> <div class="box"> <div class="inbox"> <p> Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent augue. Nulla facilisi. Fusce bibendum accumsan erat. Quisque sollicitudin mattis neque. Sed dapibus. Integer a lectus eu sem consequat pellentesque. Morbi rhoncus nulla. Duis adipiscing interdum velit. Fusce ante. Ut vitae enim sit amet magna sodales hendrerit. In sed tortor at sapien convallis eleifend. Proin mauris. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Ut metus. Cras ac arcu et arcu porttitor blandit. Nam vitae lectus eget mauris sollicitudin placerat. Suspendisse vestibulum. Donec varius libero. Duis velit tellus, euismod vitae, consequat sed, consectetuer ut, purus. </p> <p> Praesent viverra venenatis magna. Etiam in dolor. Ut in justo ac nibh malesuada cursus. Duis urna arcu, aliquam vitae, consequat nec, tincidunt non, mi. Nunc lobortis. Nunc pharetra. Sed porttitor. Maecenas turpis tortor, blandit nec, dignissim in, porttitor eu, odio. In hac habitasse platea dictumst. Suspendisse augue odio, ornare a, elementum ac, tincidunt varius, orci. Nulla libero ante, hendrerit ac, consectetuer eu, sollicitudin et, eros. Duis sapien. Suspendisse ornare enim sit amet dui. Donec ullamcorper diam. </p> </div> </div> </div> <?php echo pun_news(1, 5, 0); require PUN_ROOT.'footer.php';
instead of 1 for the forum id put array(1,2,3,4) with a list of the forums you want
I've done that now, but the index only shows the text at the bottom of the file, it doesn't show any topics
9 2007-06-23 13:47
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Sorry smartys
10 2007-06-23 00:03
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Yeah, I really want this.
I want it for "forum hilights" so it takes hilights of the forums and displays it on the portal if you get what I mean
[There's no need to bump your topics after an hour -Smartys]
11 2007-06-22 23:55
Topic: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Can anyone tell me/help me to get the miniportal to show topics from more than one forum id please?
Thanks a lot.
p0Wer~
12 2007-06-22 18:42
Re: Domain Name Leasing? (3 replies, posted in General discussion)
Why don't you buy it off him
13 2007-06-13 21:24
Re: need to find a code, cant find please help (3 replies, posted in General discussion)
Try looking for part of the line
14 2007-06-13 21:20
Re: www.Game-Warp.com/forums Consoles: PSP, PS3, 360, Wii & More! (9 replies, posted in PunBB 1.2 show off)
Oh.
16 2007-06-11 21:19
Re: need hide mod (1 replies, posted in General discussion)
Never heard of this mod, but I'm sure it'll be creatable
17 2007-06-11 21:15
Re: Sticky Topics (9 replies, posted in General discussion)
i'm digging those vids for sure.
What program did you use for the vids?
I may need to use them in the PSP community
18 2007-06-11 21:14
Re: need help with navigation thing (3 replies, posted in General discussion)
thanks -_- i shoulda looked there but i was so into thinking that i could do it from the php files and that was the only way
Ah well, doesn't hurt to ask
19 2007-06-10 13:56
Re: www.Game-Warp.com/forums Consoles: PSP, PS3, 360, Wii & More! (9 replies, posted in PunBB 1.2 show off)
I know this sounds geeky, but might be worth ditching the W3C Xhtml icon/link at the bottom of the page.
The what?
20 2007-06-10 12:04
Re: www.Game-Warp.com/forums Consoles: PSP, PS3, 360, Wii & More! (9 replies, posted in PunBB 1.2 show off)
Thanks very much guys!
I've just added a sidebar onto the forum too, makes the forum look real good
Check it out
21 2007-05-20 14:17
Re: HOW TO: When new member registers, they recieve an auto PM? (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Finally got it working, thanks.
22 2007-05-20 10:14
Re: HOW TO: When new member registers, they recieve an auto PM? (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
p0Wer wrote:MattF wrote:Look through the thread for the PM mod. It's in there.
I searched the whole thread... It's not there
The thread on PunRes?
Oh, I'll check that now...
You definatly sure what I'm on about?
I want every newly registered people to have 1 unread PM in their inbox that that recieve upon registration, NOT THEIR EMAIL.
23 2007-05-20 01:22
Re: HOW TO: When new member registers, they recieve an auto PM? (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Look through the thread for the PM mod. It's in there.
I searched the whole thread... It's not there
24 2007-05-20 00:54
Re: HOW TO: When new member registers, they recieve an auto PM? (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Look through the thread for the PM mod. It's in there.
Ok
25 2007-05-20 00:24
Topic: www.Game-Warp.com/forums Consoles: PSP, PS3, 360, Wii & More! (9 replies, posted in PunBB 1.2 show off)
Well, this site used to be www.psp-downgrades.com, but it changed to www.game-warp.com for all console discussion/help/hacks/downloads not just the PSP
We have over 4300 members
You may have noticed, it's a HIGHLY modified version of PunBB, here a few things installed:
* PunArcade
* Broadcast Email
* Style installer
* EasySmiles
* Private messaging
* Reputation
* Found
* Cash Mod
* Merge Forums
* Polls
* Image Awards
* AdminLogs
* Rate Topic
* DB management
* Shop
* How did you find us?
* AJAX Chat
* Top 20 posters
* Subforums
* Digg It
* Admin HTML
* Forum Stats
* Forum history
* Legend
* [youtube] tags
* [googlevid] tags
& much much more!
Check it out and please let me know what you think