Nice, one of the best I've seen
52 2007-06-26 00:37
Re: is sbdy working on backport of 1.3 extension system (4 replies, posted in General discussion)
Connorhd wrote:if you backport this why not just go straight to 1.3?
Oh do you say it'll be a beta version tomorrow ?
Oh sarcasm? Very helpful.
53 2007-06-26 00:35
Re: Any feedback on InnoDB? (1 replies, posted in PunBB 1.2 discussion)
I switched MyPunBB to innodb, and its been very good, no more randomly broken tables but yeh fulltext in 1.3 is going to be a pain, but that Sphinx thing might fix that
54 2007-06-26 00:34
Re: Sphinx search (1 replies, posted in PunBB 1.2 discussion)
Looks very interesting, wonder what the advantages of it are over just mysql fulltext indexing
55 2007-06-26 00:31
Re: Punbb command line tool (1 replies, posted in Feature requests)
Command line indexing is being discussed, as for the other stuff maybe someone would like to take it on as a nice little project?
56 2007-06-25 16:27
Re: [1.3] Multilanguage board (6 replies, posted in Feature requests)
for 1.3 it could be an extension, but it might not be possible to code it that way so yes you might have to edit files by hand.
its not difficult to code, difficult to run and therefore not useful to many people.
57 2007-06-25 11:12
Re: Urgent help required lost - Replies Views Last post (4 replies, posted in PunBB 1.2 troubleshooting)
I'm guessing when you moved the data the ID numbers got messed up, not really sure what to suggest to fix it though...
58 2007-06-25 11:09
Re: [1.3] Multilanguage board (6 replies, posted in Feature requests)
A plugin might be able to be created, if not a mod could, I doubt many people actually have the amount of time required to make something like this work well though.
59 2007-06-25 11:07
Re: REGISREING PROBLEM (4 replies, posted in General discussion)
Moved, not a bug.
60 2007-06-24 15:57
Re: Adding my site menu to main.tpl (3 replies, posted in Programming)
well just move the header and footer parts of main.tpl after adding the miniportal stuff?
61 2007-06-24 15:56
Re: [1.2.15] One Punbb for multiple users. (31 replies, posted in Feature requests)
I doubt it'll ever become a "feature" but there are a number of threads discussing how (and i think a mod) to do exactly this.
62 2007-06-24 12:15
Re: SEO Plugin (3 replies, posted in PunBB 1.2 discussion)
Moved, not a feature request, and there are some SEF URL type mods around if you search for them look on www.punres.org
63 2007-06-24 12:14
Re: is sbdy working on backport of 1.3 extension system (4 replies, posted in General discussion)
This would just lead to much more confusion, as extensions for 1.2 would not work in 1.3 as the code is very different in places, plus why would you backport features, if you backport this why not just go straight to 1.3?
64 2007-06-24 12:12
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.
65 2007-06-24 12:11
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
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
66 2007-06-23 22:11
Re: New frontpage index mod! (188 replies, posted in PunBB 1.2 modifications, plugins and integrations)
bingiman wrote:hmm..Maybe MattF can look into that. I also found a problem. If I set for example 2 forums to display then the max setting which is (5) really has no effect. It displays way more than that. If however I remove the second forum, then it displays the correct amount of posts. Any solution for this issue and the one Connorhd mentioned.
Cheers!
Right. We'll start afresh. What do you want the script to do? Rather than adding bits that you want to the script you had, what exactly do you want the script to achieve, working from a blank start? Btw, the max setting is per forum, not overall.
Well it might make sense, but i don't think it was intended, and its actually more efficient to do one query and order it using that (a similar query using an array of ids is here http://punbb.org/forums/viewtopic.php?pid=96967#p96967)
67 2007-06-23 21:43
Re: New frontpage index mod! (188 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Won't that order posts by the forum they are in rather than the order they were posted though?
68 2007-06-23 19:05
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
yeh it would need a similar edit
69 2007-06-23 19:04
Re: MySQL problem (2 replies, posted in PunBB 1.2 troubleshooting)
edit your config.php, change mysqli to mysql and it should work
70 2007-06-23 17:54
Re: Miniportal (15 replies, posted in PunBB 1.2 modifications, plugins and integrations)
thats an alternative version to the index.php in the miniportal mod, if this is easier...
find
$fid = intval($fid);
delete line
find
// Fetch $show topics
$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());
replace with
// 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());
}
71 2007-06-23 17:37
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
72 2007-06-23 15:32
Re: Powerful antispam in punbb1.3 (18 replies, posted in Feature requests)
There has been lots of discussion about this before, 1.3 will be released with a number of anti-spam extensions allowing the user to decide what protection to add for themselves, any built in protection will just become quickly outdated and if everyone has the same it will be easier to get around.
73 2007-04-02 20:43
Re: Strange needs? (11 replies, posted in Feature requests)
thats rather ridiculous imo
74 2007-04-02 20:08
Re: Strange needs? (11 replies, posted in Feature requests)
if you can decrypt it, then without being more complicated, so can anyone else.
75 2007-04-02 17:02
Re: Forum first page - Show latest topics under every category (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Moved, feature requests is not mod requests.