<![CDATA[PunBB Forums - PunBB 1.2 modifications, plugins and integrations]]> 2009-11-21T20:47:33Z PunBB http://punbb.informer.com/forums/ <![CDATA[Feed Aggregator Plugin 1.0]]> ##
##
##        Mod title:  Feed Aggregator
##
##      Mod version:  1.0
##   Works on PunBB:  1.2.4
##     Release date:  2007-04-12
##           Author:  Manuel Ortega (manuel@ortega.cl)
##
##      Description:  Add post automatically via RSS /Atom
##
##   Affected files:  no
##
##       Affects DB:  yes
##
##            Notes:  Use SimplePie (http://simplepie.org) and crontab
##
##    Installation:
##                     - Copy all files to plugins/ folder
##                     - Go to Administration -> Plugins / Feed Aggregator
##                     - Click Install button
##
##       DISCLAIMER:  Please note that "mods" are not officially supported by
##                    PunBB. Installation of this modification is done at your
##                    own risk. Backup your forum database and any and all
##                    applicable files before proceeding.
##
##

Screenshot: http://www.punres.org/files/projects/pr … enshot.png
Demo: http://adi.ing.uchile.cl/~mortega/punbb … m.php?id=2
Download: http://www.punres.org/files.php?pid=373

sorry for my english tongue

]]> http://punbb.informer.com/forums/user/5993/ 2009-11-21T20:47:33Z http://punbb.informer.com/forums/topic/15525/feed-aggregator-plugin-10/new/posts/ <![CDATA[newsbot - post RSS news]]> hey there...
I wanted to have rss news in my forums, one per topic so they can be commented and discussed. I think this is cool cause it allows you to keep a newsarchive on your forums.

ok... originaly i wrote the code to use myself with some settings mixed up inside the code, bad programing practive i know. Also the variable names, wich are very descriptive were writen in portuguese.

i went through the script and adapted it, the original version is working like a charm on my forums. I didnt test the modified version though so its possible that it has some kind of bug, i think not wink

If you need it just try it out, if you get some errors report them and i fix the problem.

You have to create a new table on your database and define some setings. The feed urls should be inserted in that table. The sql to create the table is in the code as a comment


OK, so this is how i put this working:
i created a folder in punbbroot and put this file there, you can name it whatever you feel like. I also put magpie and a modified copy of search_idx.php.
You can dload magpie here.
since this only works with mysql and i didnt had access to the database class, my modified search_idx.php has all the $db->function() replaced by the equivalent nativve mysql function. Like, $db->query() is replaced by mysql_query().

Ok... i know this is bad programing practice, i just wanted to have it working.
Anyway... any questions or trouble reply to this message.

<?php

//configuration=================================================================
//database===========================================
$db_host = '';
$db_name = '';
$db_username = '';
$db_password = '';

//other===============================================
$newstbot_name=''; //name of the user that make the news post
$newsbot_id='';  //id of that user
$newsforum_id=''; //the id of the forum where you wan the news to go
$follow_link_text='Read more at'; //change this if you want to display some other text
//==============================================================================

/*
sql for creating the extra table you need

create table feedsources(
id         int,
feed_url     varchar(255),
updated     int DEFAULT 0
);

*/


require('magpierss/rss_fetch.inc');
define(constantebot,1);
require "search_idx.php";


mysql_connect($db_host, $db_username, $db_password);
mysql_select_db($db_name);


$sql_get_feeds="select id, feed_url, updated from feedsources";
$resultado=mysql_query($sql_get_feeds);

$ii=0;
while ( $row=mysql_fetch_array($resultado) ){
    $feed_array[$ii]["feed"]=$row["feed_url"];
    $feed_array[$ii]["id"]=$row["id"];
    $feed_array[$ii]["updated"]=$row["updated"];
    $ii++;
}

$num_posts=0;

foreach ($feed_array as $feed_array_element){
    
    $feed_last_update        =    $feed_array_element["updated"];
    $url                =    $feed_array_element["feed"];
    $feed_id            =    $feed_array_element["id"];
    $rss                 =    fetch_rss($url);    

    $new_last_update = $feed_last_update;
    
    foreach ( $rss->items as $item ) {
    
                $timenow    = time();
                $date_string     = $item["pubdate"];
                $date_posted     = strtotime($date_string);
                
                if($date_posted > $new_last_update){
                    $new_last_update=$date_posted;
                }
                
                if($date_posted <= $feed_last_update){
                    
                    break;
                }
                
                $num_posts++;
                $topic_subject        =    $item['title'];
                $poster            =     $newstbot_name;
                $topic_forum_id        =    $newsforum_id;
                $poster_id        =    $newsbot_id;;

                $post_message        =     mysql_escape_string($item['description']);
                $post_message        =    $post_message.
                "<br /><br /><a href=\"".$item["link"]."\">$follow_link_text</a>";
                
    
                
                $sql="
                    insert into topics
                        (subject,
                        poster,
                        posted,
                        forum_id,
                        last_post_id,
                        last_poster)
                    values
                        ('$topic_subject',
                        '$poster',
                        $timenow,
                        $topic_forum_id,
                        $timenow,
                        '$poster')";
                        
                mysql_query($sql);
                
                $topic_id = mysql_insert_id();
                
                $sql="
                    insert into posts                
                        (poster,
                        poster_id,
                        message,
                        hide_smilies,
                        posted,
                        topic_id)
                    values
                        ('$poster',
                        $poster_id,'"
                        ."$post_message"
                        ."',
                        1,
                        $timenow,
                        $topic_id)";
                
                mysql_query($sql);
                $last_post_id = mysql_insert_id();
         
                $sql="update topics set last_post_id=$last_post_id, last_post=$date_posted where id=$topic_id";
                echo "$sql <br>";
                mysql_query($sql);
                
                $sql="
                    update forums
                    set
                        num_posts=num_posts+1,
                        num_topics=num_topics+1,
                        last_post=$timenow,
                        last_post_id=$last_post_id,
                        last_poster='$poster'
                        
                    where
                        id=$topic_forum_id";
                
                mysql_query($sql);

                                $post_message=strip_tags($post_message);
                update_search_index('post', $last_post_id, $post_message);
                               
                
                
        }
        
        $sql2="update feedsources set updated=$new_last_update where id=$feed_id";
        mysql_query($sql2);
        echo "$sql2 <br>";
        
    }
    
    $sql3="update users set num_posts=num_posts+$num_posts where id=$newsbot_id";
    mysql_query($sql3);
?>
]]> http://punbb.informer.com/forums/user/7146/ 2009-11-21T20:40:28Z http://punbb.informer.com/forums/topic/13529/newsbot-post-rss-news/new/posts/ <![CDATA[Notify moderator of each post]]> Does anybody know how to modify 1.2 so that I can get a copy of each post?

Thanks.

]]> http://punbb.informer.com/forums/user/22735/ 2009-11-21T02:37:53Z http://punbb.informer.com/forums/topic/22537/notify-moderator-of-each-post/new/posts/ <![CDATA[[HOWTO] - Upgrade mod compatibility for 1.2.*]]> Lots of people have been asking for mods to be "upgraded" to work on the current version of PunBB. However in most cases there is not really a need to ask for this. All you need to do is:

1. Open install_mod.php
2. Find line 12
3. Add the version of the forum you are using to the version array
4. Save and upload

That's it.

Your version array should then look something like this...

$punbb_versions    = array('1.2.8', '1.2.9', '1.2.10');
]]> http://punbb.informer.com/forums/user/1862/ 2009-11-16T16:30:41Z http://punbb.informer.com/forums/topic/10518/howto-upgrade-mod-compatibility-for-12/new/posts/ <![CDATA[Adding BBCode]]> Hello,

I'm wanting to add a bbcode of [center][/center], so I can center texts & stuff, to the existing bbcode that I already have, how might I go about doing this?

Here is a screen shot of what my existing code looks like:
http://www.thestkclan.net/bbcode.jpg

I appreciate the help...

Kind Regards,
Juston

]]> http://punbb.informer.com/forums/user/22672/ 2009-11-16T12:26:47Z http://punbb.informer.com/forums/topic/22524/adding-bbcode/new/posts/ <![CDATA[chatbox. question about security.]]> i'm notice that my chatbox allow people to post javascript code.
for example this code.
<BODY onLoad="javascript: alert('On Load event fired!')">
or
<A href="javascript: alert('Clicked on link!')">Click here!</A>
or
<script></script>
for the security reason, how can i disable javascript in chatbox?

here is my chatbox.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_ALT4',1);
if (!defined('PUN_ROOT')) define('PUN_ROOT','./');


require PUN_ROOT.'include/common.php';
require PUN_ROOT.'include/parser.php';

$lang_common['lang_encoding'] = 'utf-8';
header('Content-type: text/html; charset=utf-8');

if (!$pun_config['cb_pbb_version'])
    message('Poki BB Chatbox is not installed correctly. Please make sure you have launch install_mod.php');

if ($pun_user['g_read_board'] == '0')
    message($lang_common['No view']);

// Load the chatbox.php and post.php language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/chatbox.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/post.php';

// if it's ajax
if (isset($_GET['ajax']))
{

    // Send no-cache headers
    header('Expires: Thu, 21 Jul 1977 07:30:00 GMT');    // When yours truly first set eyes on this world! :)
    header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT');
    header('Cache-Control: post-check=0, pre-check=0', false);
    header('Pragma: no-cache');        // For HTTP/1.0 compability
    
    if ($_GET['action'] == 'add')
    {
        // Start with a clean slate
        $error = $pun_config['cb_space'].$pun_config['cb_ajax_errors'];
        $error = str_replace('<pun_error>', $lang_chatbox['Error Title'], $error);
        $error = str_replace('<pun_date>', format_time(time()), $error);
        
        //exit('error:chat'.str_replace('<pun_error_text>', parse_message($value, 0), $error));
    
        // Make sure form_user is correct
        if (($pun_user['is_guest'] && $_GET['form_user'] != 'Guest') || (!$pun_user['is_guest'] && $_GET['form_user'] != $pun_user['username']))
            exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_common['Bad request'], 0), $error));
        
        // Do we have permission to post?
        if ($pun_user['g_post_chatbox'] != '1')
            exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_chatbox['No Post Permission'], 0), $error));

        // Flood protection
        if (!$pun_user['is_guest'] && $pun_user['last_post_chatbox'] != '' && (time() - $pun_user['last_post_chatbox']) < $pun_user['g_post_flood_chatbox'])
            exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_post['Flood start'].' '.$pun_user['g_post_flood_chatbox'].' '.$lang_post['flood end'], 0), $error));
    
        if ($pun_user['is_guest'])
        {
$result = $db->query('SELECT u.id, u.group_id, u.num_posts_chatbox, m.id AS m_id, m.poster_id, m.poster, m.poster_ip, m.poster_email, m.message, m.posted, g.g_id, g.g_title_chatbox, g.g_color FROM '.$db->prefix.'chatbox_msg AS m INNER JOIN '.$db->prefix.'users AS u ON u.id=m.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id ORDER BY m.posted DESC LIMIT '.$pun_config['cb_max_msg']) or error('Unable to fetch messages', __FILE__, __LINE__, $db->error());
            $cur_post = $db->fetch_assoc($result);
            
            if ((time() - $cur_post['posted']) < $pun_user['g_post_flood_chatbox'])
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_post['Flood start'].' '.$pun_user['g_post_flood_chatbox'].' '.$lang_post['flood end'], 0), $error));
        }
        
        // If the user is logged in we get the username and e-mail from $pun_user
        if (!$pun_user['is_guest'])
        {
            $username = $pun_user['username'];
            $email = $pun_user['email'];
        }
        // Otherwise it should be in $_GET
        else
        {
            $username = trim($_GET['req_username']);
            $email = strtolower(trim(($pun_config['p_force_guest_email'] == '1') ? $_GET['req_email'] : $_GET['email']));
    
            // Load the register.php/profile.php language files
            require PUN_ROOT.'lang/'.$pun_user['language'].'/prof_reg.php';
            require PUN_ROOT.'lang/'.$pun_user['language'].'/register.php';
    
            // It's a guest, so we have to validate the username
            if (strlen($username) < 2)
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_prof_reg['Username too short'], 0), $error));
            else if (!strcasecmp($username, 'Guest') || !strcasecmp($username, $lang_common['Guest']))
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_prof_reg['Username guest'], 0), $error));
            else if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $username))
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_prof_reg['Username IP'], 0), $error));
    
            if ((strpos($username, '[') !== false || strpos($username, ']') !== false) && strpos($username, '\'') !== false && strpos($username, '"') !== false)
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_prof_reg['Username reserved chars'], 0), $error));
            if (preg_match('#\[b\]|\[/b\]|\[u\]|\[/u\]|\[i\]|\[/i\]|\[color|\[/color\]|\[quote\]|\[quote=|\[/quote\]|\[code\]|\[/code\]|\[img\]|\[/img\]|\[url|\[/url\]|\[email|\[/email\]#i', $username))
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_prof_reg['Username BBCode'], 0), $error));
    
            // Check username for any censored words
            $temp = censor_words($username);
            if ($temp != $username)
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_register['Username censor'], 0), $error));
    
            // Check that the username (or a too similar username) is not already registered
            $result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE username=\''.$db->escape($username).'\' OR username=\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\'') or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());
            if ($db->num_rows($result))
            {
                $busy = $db->result($result);
                exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_register['Username dupe 1'].' '.pun_htmlspecialchars($busy).'. '.$lang_register['Username dupe 2'], 0), $error));
            }
    
            if ($pun_config['p_force_guest_email'] == '1' || $email != '')
            {
                require PUN_ROOT.'include/email.php';
                if (!is_valid_email($email))
                    exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_common['Invalid e-mail'], 0), $error));
            }            
            
        }
    
        // Clean up message from POST
        $message = str_replace('-|-', '+', pun_linebreaks(pun_trim($_GET['req_message'])));
        
        if ($message == '')
            exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_chatbox['Error No message'], 0), $error));
        else if (strlen($message) > $pun_config['cb_msg_maxlength'])
            exit('error:chat'.str_replace('<pun_error_text>', parse_message($lang_chatbox['Error Too long message'], 0), $error));
        else if ($pun_config['p_message_all_caps'] == '0' && strtoupper($message) == $message && $pun_user['g_id'] > PUN_MOD)
            $message = ucwords(strtolower($message));
    
        $errors = '';
        // Validate BBCode syntax
        if ($pun_config['p_message_bbcode'] == '1' && strpos($message, '[') !== false && strpos($message, ']') !== false)
            $message = preparse_bbcode($message, $errors);
            
        if ($errors != '')
        exit('error:chat'.str_replace('<pun_error_text>', parse_message($errors[0], 0), $error));


        $now = time();

        if (!$pun_user['is_guest'])
        {
            // Insert message
            $db->query('INSERT INTO '.$db->prefix.'chatbox_msg (poster, poster_id, poster_ip, message, posted) VALUES(\''.$db->escape($username).'\', '.$pun_user['id'].', \''.get_remote_address().'\', \''.$db->escape($message).'\', '.$now.')') or error('Unable to post message', __FILE__, __LINE__, $db->error());

            // Increment his/her chatbox post count
              $low_prio = ($db_type == 'mysql') ? 'LOW_PRIORITY ' : '';
              $db->query('UPDATE '.$low_prio.$db->prefix.'users SET num_posts_chatbox=num_posts_chatbox+1, last_post_chatbox='.$now.' WHERE id='.$pun_user['id']) or error('Unable to update user', __FILE__, __LINE__, $db->error());

        }
        else
        {
            // Insert message
            $email_sql = ($pun_config['p_force_guest_email'] == '1' || $email != '') ? '\''.$email.'\'' : 'NULL';
            $db->query('INSERT INTO '.$db->prefix.'chatbox_msg (poster, poster_id, poster_ip, poster_email, message, posted) VALUES(\''.$db->escape($username).'\', '.$pun_user['id'].', \''.get_remote_address().'\', '.$email_sql.', \''.$db->escape($message).'\', '.$now.')') or error('Unable to post message', __FILE__, __LINE__, $db->error());
        }

        $count = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'chatbox_msg') or error('Unable to fetch chatbox post count', __FILE__, __LINE__, $db->error());
        $num_post = $db->result($count);
        
        $limit = ($num_post-$pun_config['cb_max_msg'] <= 0) ? 0 : $num_post-$pun_config['cb_max_msg'];
        
        
        $result = $db->query('SELECT id,posted FROM '.$db->prefix.'chatbox_msg ORDER BY posted ASC LIMIT '.$limit) or error('Unable to select post to delete', __FILE__, __LINE__, $db->error());
        while ($del_msg = $db->fetch_assoc($result))
        {
        $db->query('DELETE FROM '.$db->prefix.'chatbox_msg WHERE id = '.$del_msg['id'].' LIMIT 1') or error('Unable to delete post', __FILE__, __LINE__, $db->error());
        }
        
        $_GET['req_message'] = NULL;
    }

        $cur_msg_txt = '';
        $response = '';
        $count_id = array();

        $last_msg_time = intval($_GET['last_msg']);
        //$messages = $db->query('SELECT u.id, u.group_id, u.num_posts_chatbox, m.id AS m_id, m.poster_id, m.poster, m.poster_ip, m.poster_email, m.message, m.posted, g.g_id, g.g_title_chatbox FROM '.$db->prefix.'chatbox_msg AS m INNER JOIN '.$db->prefix.'users AS u ON u.id=m.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE m.posted > '.$last_msg_time.' ORDER BY m.posted DESC LIMIT '.$pun_config['cb_max_msg']) or error('Unable to fetch messages', __FILE__, __LINE__, $db->error());
        $messages = $db->query('SELECT u.id, u.group_id, u.num_posts_chatbox, m.id AS m_id, m.poster_id, m.poster, m.poster_ip, m.poster_email, m.message, m.posted, g.g_id, g.g_title_chatbox FROM '.$db->prefix.'chatbox_msg AS m INNER JOIN '.$db->prefix.'users AS u ON u.id=m.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE m.posted > '.$last_msg_time.' ORDER BY m.posted DESC LIMIT 0,50') or error('Unable to fetch messages', __FILE__, __LINE__, $db->error());

        $i = 0;
        while ($cur_msg = $db->fetch_assoc($messages))
        {    
        $i++;
        if ($i == 1)
        {
            // Get newest timestamp
            $response = $cur_msg['posted'];
        }
        $cur_msg_txt .= $pun_config['cb_space'].$cur_msg['g_title_chatbox'].$pun_config['cb_disposition'];
        
if ($cur_msg['g_id'] != PUN_GUEST)
        $cur_msg_txt = str_replace('<pun_username>', '<a href="profile.php?id='.$cur_msg['id'].'"><span style="color: '.$cur_msg['g_color'].'">'.pun_htmlspecialchars($cur_msg['poster']).'</span></a>', $cur_msg_txt);
    else
        $cur_msg_txt = str_replace('<pun_username>', pun_htmlspecialchars($cur_msg['poster']), $cur_msg_txt);
        
        $cur_msg_txt = str_replace('<pun_date>', format_time($cur_msg['posted']), $cur_msg_txt);
                
            if ($cur_msg['g_id'] != PUN_GUEST)
        $cur_msg_txt = str_replace('<pun_nbpost>', $cur_msg['num_posts_chatbox'], $cur_msg_txt);
        else
        {
        
        if (!isset($count_id[$cur_msg['poster']]))
        {
        $like_command = ($db_type == 'pgsql') ? 'ILIKE' : 'LIKE';
        
        $count = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'chatbox_msg WHERE poster '.$like_command.' \''.$db->escape(str_replace('*', '%', $cur_msg['poster'])).'\'') or error('Unable to fetch user chatbox post count', __FILE__, __LINE__, $db->error());
        $num_post = $db->result($count);
        $count_id[$cur_msg['poster']] = $num_post;
        }
        else
        $num_post = $count_id[$cur_msg['poster']];
        
        $cur_msg_txt = str_replace('<pun_nbpost>', $num_post, $cur_msg_txt);
        }
        
        $cur_msg_txt = str_replace('<pun_nbpost_txt>', $lang_chatbox['Posts'], $cur_msg_txt);
        
            if ($pun_user['g_id'] < PUN_GUEST)
          {
        $cur_msg_admin = ' [ <a href="chatbox.php?del='.$cur_msg['m_id'].'">Delete</a> | <a href="chatbox.php?get_host='.$cur_msg['m_id'].'">'.$cur_msg['poster_ip'].'</a>';
        if ($cur_msg['poster_email'])
                $cur_msg_admin .= ' | <a href="mailto:'.$cur_msg['poster_email'].'">'.$lang_common['E-mail'].'</a> ]';
            else
              $cur_msg_admin .= ' ] ';
            }
        else
        $cur_msg_admin = '';
        
        $cur_msg_txt = str_replace('<pun_admin>', $cur_msg_admin, $cur_msg_txt);
        $cur_msg_txt = str_replace('<pun_message>', parse_message($cur_msg['message'], 0), $cur_msg_txt);
        
        $response .= $cur_msg_txt . "\n";
    }
    if (!$response)
        $response = $last_msg_time;
    
    $response = pun_trim($response);
    
    exit($response);

}

// This particular function doesn't require forum-based moderator access. It can be used
// by all moderators and admins.

if (isset($_GET['del']))
{
    if ($pun_user['g_id'] > PUN_MOD)
        message($lang_common['No permission']);

        $id = intval($_GET['del']);
        if ($id < 1)
            message($lang_common['Bad request']);


$result = $db->query('Delete From '.$db->prefix.'chatbox_msg WHERE id='.$id.'') or error('Unable to fetch post IP address', __FILE__, __LINE__, $db->error()); 
}


if (isset($_GET['get_host']))
{
    if ($pun_user['g_id'] > PUN_MOD)
        message($lang_common['No permission']);

    // Is get_host an IP address or a post ID?
    if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $_GET['get_host']))
        $ip = $_GET['get_host'];
    else
    {
        $get_host = intval($_GET['get_host']);
        if ($get_host < 1)
            message($lang_common['Bad request']);

        $result = $db->query('SELECT poster_ip FROM '.$db->prefix.'chatbox_msg WHERE id='.$get_host) or error('Unable to fetch post IP address', __FILE__, __LINE__, $db->error());
        if (!$db->num_rows($result))
            message($lang_common['Bad request']);

        $ip = $db->result($result);
    }

    message('The IP address is: '.$ip.'<br />The host name is: '.@gethostbyaddr($ip).'<br /><br /><a href="admin_users.php?show_users='.$ip.'">Show more users for this IP</a>');
}

$page_title = pun_htmlspecialchars($lang_chatbox['Page_title']);
define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'header.php';

if ($pun_user['g_read_chatbox'] != '1')
  message($lang_chatbox['No Read Permission']);

// Did someone just hit "Submit"?
if (isset($_POST['form_sent']))
{

    // Make sure form_user is correct
    if (($pun_user['is_guest'] && $_POST['form_user'] != 'Guest') || (!$pun_user['is_guest'] && $_POST['form_user'] != $pun_user['username']))
        message($lang_common['Bad request']);

  // Do we have permission to post?
  if ($pun_user['g_post_chatbox'] != '1')
    message($lang_chatbox['No Post Permission']);

  // Start with a clean slate
  $errors = array();

    // Flood protection
    if (!$pun_user['is_guest'] && $pun_user['last_post_chatbox'] != '' && (time() - $pun_user['last_post_chatbox']) < $pun_user['g_post_flood_chatbox'])
        $errors[] = $lang_post['Flood start'].' '.$pun_user['g_post_flood_chatbox'].' '.$lang_post['flood end'];

  if ($pun_user['is_guest'])
  {
    $result = $db->query('SELECT id, poster_ip, posted FROM '.$db->prefix.'chatbox_msg WHERE poster_ip=\''.get_remote_address().'\' ORDER BY posted DESC LIMIT 1') or error('Unable to fetch messages for flood protection', __FILE__, __LINE__, $db->error());
    $cur_post = $db->fetch_assoc($result);

    if ((time() - $cur_post['posted']) < $pun_user['g_post_flood_chatbox'])
          $errors[] = $lang_post['Flood start'].' '.$pun_user['g_post_flood_chatbox'].' '.$lang_post['flood end'];
  }

  // If the user is logged in we get the username and e-mail from $pun_user
    if (!$pun_user['is_guest'])
    {
        $username = $pun_user['username'];
        $email = $pun_user['email'];
    }

    // Otherwise it should be in $_POST
    else
    {
        $username = trim($_POST['req_username']);
        $email = strtolower(trim(($pun_config['p_force_guest_email'] == '1') ? $_POST['req_email'] : $_POST['email']));

        // Load the register.php/profile.php language files
        require PUN_ROOT.'lang/'.$pun_user['language'].'/prof_reg.php';
        require PUN_ROOT.'lang/'.$pun_user['language'].'/register.php';

        // It's a guest, so we have to validate the username
        if (strlen($username) < 2)
            $errors[] = $lang_prof_reg['Username too short'];
        else if (!strcasecmp($username, 'Guest') || !strcasecmp($username, $lang_common['Guest']))
            $errors[] = $lang_prof_reg['Username guest'];
        else if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $username))
            $errors[] = $lang_prof_reg['Username IP'];

        if ((strpos($username, '[') !== false || strpos($username, ']') !== false) && strpos($username, '\'') !== false && strpos($username, '"') !== false)
            $errors[] = $lang_prof_reg['Username reserved chars'];
        if (preg_match('#\[b\]|\[/b\]|\[u\]|\[/u\]|\[i\]|\[/i\]|\[color|\[/color\]|\[quote\]|\[quote=|\[/quote\]|\[code\]|\[/code\]|\[img\]|\[/img\]|\[url|\[/url\]|\[email|\[/email\]#i', $username))
            $errors[] = $lang_prof_reg['Username BBCode'];

        // Check username for any censored words
        $temp = censor_words($username);
        if ($temp != $username)
            $errors[] = $lang_register['Username censor'];

        // Check that the username (or a too similar username) is not already registered
        $result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE username=\''.$db->escape($username).'\' OR username=\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\'') or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());
        if ($db->num_rows($result))
        {
            $busy = $db->result($result);
            $errors[] = $lang_register['Username dupe 1'].' '.pun_htmlspecialchars($busy).'. '.$lang_register['Username dupe 2'];
        }

        if ($pun_config['p_force_guest_email'] == '1' || $email != '')
        {
            require PUN_ROOT.'include/email.php';
            if (!is_valid_email($email))
                $errors[] = $lang_common['Invalid e-mail'];
        }
    }

    // Clean up message from POST
    $message = pun_linebreaks(pun_trim($_POST['req_message']));

    if ($message == '')
        $errors[] = $lang_chatbox['Error No message'];
    else if (strlen($message) > $pun_config['cb_msg_maxlength'])
        $errors[] = $lang_chatbox['Error Too long message'];
    else if ($pun_config['p_message_all_caps'] == '0' && strtoupper($message) == $message && $pun_user['g_id'] > PUN_MOD)
        $message = ucwords(strtolower($message));

    // Validate BBCode syntax
    if ($pun_config['p_message_bbcode'] == '1' && strpos($message, '[') !== false && strpos($message, ']') !== false)
    {
        $message = preparse_bbcode($message, $errors);
    }

    // Did everything go according to plan?
    if (empty($errors))
    {
    $now = time();

        if (!$pun_user['is_guest'])
        {
            // Insert message
            $db->query('INSERT INTO '.$db->prefix.'chatbox_msg (poster, poster_id, poster_ip, message, posted) VALUES(\''.$db->escape($username).'\', '.$pun_user['id'].', \''.get_remote_address().'\', \''.$db->escape($message).'\', '.$now.')') or error('Unable to post message', __FILE__, __LINE__, $db->error());

          // Increment his/her chatbox post count
              $low_prio = ($db_type == 'mysql') ? 'LOW_PRIORITY ' : '';
              $db->query('UPDATE '.$low_prio.$db->prefix.'users SET num_posts_chatbox=num_posts_chatbox+1, last_post_chatbox='.$now.' WHERE id='.$pun_user['id']) or error('Unable to update user', __FILE__, __LINE__, $db->error());

        }
        else
        {
            // Insert message
            $email_sql = ($pun_config['p_force_guest_email'] == '1' || $email != '') ? '\''.$email.'\'' : 'NULL';
            $db->query('INSERT INTO '.$db->prefix.'chatbox_msg (poster, poster_id, poster_ip, poster_email, message, posted) VALUES(\''.$db->escape($username).'\', '.$pun_user['id'].', \''.get_remote_address().'\', '.$email_sql.', \''.$db->escape($message).'\', '.$now.')') or error('Unable to post message', __FILE__, __LINE__, $db->error());
        }

    $count = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'chatbox_msg') or error('Unable to fetch chatbox post count', __FILE__, __LINE__, $db->error());
    $num_post = $db->result($count);

    $limit = ($num_post-$pun_config['cb_max_msg'] <= 0) ? 0 : $num_post-$pun_config['cb_max_msg'];


    $result = $db->query('SELECT id,posted FROM '.$db->prefix.'chatbox_msg ORDER BY posted ASC LIMIT '.$limit) or error('Unable to select post to delete', __FILE__, __LINE__, $db->error());
    while ($del_msg = $db->fetch_assoc($result))
    {
      $db->query('DELETE FROM '.$db->prefix.'chatbox_msg WHERE id = '.$del_msg['id'].' LIMIT 1') or error('Unable to delete post', __FILE__, __LINE__, $db->error());
    }

      $_POST['req_message'] = NULL;
  }

}

// If there are errors, we display them
if (!empty($errors))
{

?>
<div id="posterror" class="block">
    <h2><span><?php echo $lang_post['Post errors'] ?></span></h2>
    <div class="box">
        <div class="inbox">
            <p><?php echo $lang_post['Post errors info'] ?></p>
            <ul>
<?php

    while (list(, $cur_error) = each($errors))
        echo "\t\t\t\t".'<li><strong>'.$cur_error.'</strong></li>'."\n";
?>
            </ul>
        </div>
    </div>
</div>

<?php

}

?>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/chatbox.js"></script>
<div class="block">
  <h2>
    <span>
<span class="conr" ><img alt="" style="display:none;" id="loading" src="img/loading.gif" /></span>
    
<?php echo $lang_chatbox['Chatbox'] ?></span>
  </h2>
    <div class="box">
        <div id="chatbox" class="inbox" style="overflow:auto;height:<?php echo $pun_config['cb_height'] ?>px;">
<?php

$cur_msg_txt = '';
$last_msg_time = '';
$count_id = array();

$result = $db->query('SELECT u.id, u.group_id, u.num_posts_chatbox, m.id AS m_id, m.poster_id, m.poster, m.poster_ip, m.poster_email, m.message, m.posted, g.g_id, g.g_title_chatbox, g.g_color FROM '.$db->prefix.'chatbox_msg AS m INNER JOIN '.$db->prefix.'users AS u ON u.id=m.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id ORDER BY m.posted DESC LIMIT '.$pun_config['cb_max_msg']) or error('Unable to fetch messages', __FILE__, __LINE__, $db->error());
$i = 0;
while ($cur_msg = $db->fetch_assoc($result))
  {
    $i++;
    if ($i == 1)
    {
        // Get newest timestamp
        $last_msg_time = $cur_msg['posted'];
    }
    $cur_msg_txt = $pun_config['cb_space'].$cur_msg['g_title_chatbox'].$pun_config['cb_disposition'].$cur_msg_txt;

if ($cur_msg['g_id'] != PUN_GUEST)
        $cur_msg_txt = str_replace('<pun_username>', '<a href="profile.php?id='.$cur_msg['id'].'"><span style="color: '.$cur_msg['g_color'].'">'.pun_htmlspecialchars($cur_msg['poster']).'</span></a>', $cur_msg_txt);
    else
      $cur_msg_txt = str_replace('<pun_username>', pun_htmlspecialchars($cur_msg['poster']), $cur_msg_txt);

    $cur_msg_txt = str_replace('<pun_date>', format_time($cur_msg['posted']), $cur_msg_txt);
    
        if ($cur_msg['g_id'] != PUN_GUEST)
      $cur_msg_txt = str_replace('<pun_nbpost>', $cur_msg['num_posts_chatbox'], $cur_msg_txt);
    else
    {

      if (!isset($count_id[$cur_msg['poster']]))
      {
        $like_command = ($db_type == 'pgsql') ? 'ILIKE' : 'LIKE';
        
        $count = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'chatbox_msg WHERE poster '.$like_command.' \''.$db->escape(str_replace('*', '%', $cur_msg['poster'])).'\'') or error('Unable to fetch user chatbox post count', __FILE__, __LINE__, $db->error());
        $num_post = $db->result($count);
        $count_id[$cur_msg['poster']] = $num_post;
      }
      else
        $num_post = $count_id[$cur_msg['poster']];

      $cur_msg_txt = str_replace('<pun_nbpost>', $num_post, $cur_msg_txt);
    }

    $cur_msg_txt = str_replace('<pun_nbpost_txt>', $lang_chatbox['Posts'], $cur_msg_txt);

        if ($pun_user['g_id'] < PUN_GUEST)
      {
      $cur_msg_admin = ' [ <a href="chatbox.php?del='.$cur_msg['m_id'].'">Delete</a> | <a href="chatbox.php?get_host='.$cur_msg['m_id'].'">'.$cur_msg['poster_ip'].'</a>';
      if ($cur_msg['poster_email'])
              $cur_msg_admin .= ' | <a href="mailto:'.$cur_msg['poster_email'].'">'.$lang_common['E-mail'].'</a> ]';
          else
            $cur_msg_admin .= ' ] ';
        }
    else
      $cur_msg_admin = '';

      $cur_msg_txt = str_replace('<pun_admin>', $cur_msg_admin, $cur_msg_txt);
      $cur_msg_txt = str_replace('<pun_message>', parse_message($cur_msg['message'], 0), $cur_msg_txt);

  }
if (!$cur_msg_txt)
  echo $lang_chatbox['No Message'];
else
  echo "\t\t\t".$cur_msg_txt."\n";
?>
        </div>
    </div>

    
<?php
if ($pun_user['g_post_chatbox'] == '1')
  {
    $cur_index = 1;
  ?>
            <form id="post" method="post" name="post" action="chatbox.php">

         <input type="hidden" name="form_sent" value="1" />
         <input type="hidden" name="form_user" id="form_user" value="<?php echo (!$pun_user['is_guest']) ? pun_htmlspecialchars($pun_user['username']) : 'Guest'; ?>" />
<?php

if ($pun_user['is_guest'])
{
    $email_label = ($pun_config['p_force_guest_email'] == '1') ? '<strong>'.$lang_common['E-mail'].':</strong>' : $lang_common['E-mail'];
    $email_form_name = ($pun_config['p_force_guest_email'] == '1') ? 'req_email' : 'email';

    if($email_form_name = 'req_email')
        echo "\t".'<input type="hidden" name="email" id="email" value="" />'."\n";
    else
        echo "\t".'<input type="hidden" name="req_email" id="req_email" value="" />'."\n";

?>
          <strong><?php echo $lang_post['Guest name'] ?>:</strong><br /><input class="textbox" type="text" name="req_username" id="req_username" value="<?php if (isset($_POST['req_username'])) echo pun_htmlspecialchars($username); ?>" size="20" maxlength="25" tabindex="<?php echo $cur_index++ ?>" /> 
          <?php echo $email_label ?> <input class="textbox" type="text" name="<?php echo $email_form_name ?>" id="<?php echo $email_form_name ?>" value="<?php if (isset($_POST[$email_form_name])) echo pun_htmlspecialchars($email); ?>" size="20" maxlength="50" tabindex="<?php echo $cur_index++ ?>" /><br /> 
<?php

}
else
{
?>
          <input type="hidden" name="req_username" id="req_username" value="" /> 
          <input type="hidden" name="email" id="email" value="" /> 
          <input type="hidden" name="req_email" id="req_email" value="" />

<?php

}

?><br />
<div id="posterror2" class="block">
    <h2><span><?php echo $lang_common['Message'] ?></span></h2>
    <div class="box">
        <div style="padding: 10px 15px 10px 10px;" class="inbox">
                        <textarea name="req_message" id="req_message" class="textbox" rows="20" style="width: 100%;" tabindex="<?php echo $cur_index++ ?>"><?php echo isset($_POST['req_message']) ? pun_htmlspecialchars($message) : (isset($quote) ? $quote : ''); ?></textarea><br />
<?php /* punToolBar */
if (file_exists(PUN_ROOT.'cache/cache_puntoolbar.php')) {
    include PUN_ROOT.'cache/cache_puntoolbar.php';
} else {
    require_once PUN_ROOT.'include/cache_puntoolbar.php';
    generate_ptb_cache();
    require PUN_ROOT.'cache/cache_puntoolbar.php';
}
?>
             <br /><strong><?php echo $lang_chatbox['Message'] ?>:</strong> 

             <input class="button" type="submit" name="submit" value="<?php echo $lang_chatbox['Btn Send'] ?>" accesskey="s" tabindex="<?php echo $cur_index++ ?>" />
<br />
Be Smart. Don't post personal information about yourself, your phone number, or your address in Chat.

</div></div></div>
    <div style="padding: 5px;" class="box">
<script type="text/javascript">
    <!--
    // This button is utterly useless, unless we have javascript enabled. As such, we won't display it until then.
    document.write('<?php echo $lang_chatbox['Autoscroll'] ?>: <input type="checkbox" id="autoscroll" value="" checked  tabindex="<?php echo $cur_index++ ?>" />');

document.getElementById("post").req_message.focus();

    // -->
    </script></div>
    </form>
  <?php
  }
else
  echo $lang_chatbox['No Post Permission'];
?>
</div>

<script type="text/javascript">
    // Begin getting messages
    var LastMsg = '<?php echo $last_msg_time; ?>';
    $('autoscroll').value = 'true';
    get_messages();
    checker = new PeriodicalExecuter(get_messages, <?php echo $pun_config['cb_ajax_refresh']; ?>);
</script>

<?php

require PUN_ROOT.'footer.php';
]]> http://punbb.informer.com/forums/user/18694/ 2009-11-14T07:40:37Z http://punbb.informer.com/forums/topic/22516/chatbox-question-about-security/new/posts/ <![CDATA[BBcode question]]> i want to ask is there have someone know how to make a private bbcode?
for example [private]text[/private]. with this bbcode, only registered user can read it.

]]> http://punbb.informer.com/forums/user/18694/ 2009-10-30T11:07:40Z http://punbb.informer.com/forums/topic/22424/bbcode-question/new/posts/ <![CDATA[How do I get this template onto my punbb forums?]]> It's called "php subsilver"

It's really nice... I want it on my punbb forums

My version is 1.2.17

can someone link me to a DL? D;

And tell me how to download or link me to a tut?

]]> http://punbb.informer.com/forums/user/13088/ 2009-10-29T17:32:45Z http://punbb.informer.com/forums/topic/22375/how-do-i-get-this-template-onto-my-punbb-forums/new/posts/ <![CDATA[[ASK] Adding Image To Header PunBB 1.2.x]]> How i can change the header?

Thx...

]]> http://punbb.informer.com/forums/user/15575/ 2009-10-29T14:33:12Z http://punbb.informer.com/forums/topic/22391/ask-adding-image-to-header-punbb-12x/new/posts/ <![CDATA[Integrating logins]]> I'm trying to integrate punBB into my own site, and it is going well, howver I do not wish to have two seperate registrations and logins.  I was wondering if anyone else out there has had experience with integrating their own registrations and logins with punBB.  Has anyone developed a mod for something like this?

Thanks!
-Geoff

]]> http://punbb.informer.com/forums/user/2042/ 2009-10-24T10:09:45Z http://punbb.informer.com/forums/topic/4932/integrating-logins/new/posts/ <![CDATA[Change button style]]> I have made a class for all the buttons, but I'm having problem with the "Go" button for Jump To forum in the footer.  I have inserted a class in the cache.php, but the class still does not come up.  I'm wondering if there is another place that I need to insert the class.  Thanks for you help

]]> http://punbb.informer.com/forums/user/13185/ 2009-10-15T02:17:38Z http://punbb.informer.com/forums/topic/19254/change-button-style/new/posts/ <![CDATA[nice urls / mod_rewrite / seo]]> Hello,
i want to release my first mod to the community.
Search Engines like Google don't like URLs like:
viewtopic.php?id=123
With my mod the URLs look like:
heading-of-the-topic-vt123.php

Profiles are flx-vp123.php

To avoid duplicate content lots of things are disallowed in robots.txt.

You can see this mod in action on http://www.html-forum.net (german)
robots.txt is here.

Installation will probably take ~5 minutes.

It will be released tomorrow.

I'd like some feedback wink

Greetz,
flx

]]> http://punbb.informer.com/forums/user/3466/ 2009-10-15T01:16:39Z http://punbb.informer.com/forums/topic/7340/nice-urls-modrewrite-seo/new/posts/ <![CDATA[multilanguage forum and category names and forum descriptions]]> multilanguage forum and category names and forum descriptions: http://www.punres.org/viewtopic.php?id=4876

see also http://punbb.informer.com/forums/topic/ … uage-pack/

also here one more related mod made by me:
http://www.punres.org/viewtopic.php?id=4858 "guest language change"

you can see them both at http://tmforum.awardspace.com

]]> http://punbb.informer.com/forums/user/13314/ 2009-10-15T01:14:04Z http://punbb.informer.com/forums/topic/19456/multilanguage-forum-and-category-names-and-forum-descriptions/new/posts/ <![CDATA[Thank You MOD]]> I want to kindly request a ThankYou MOD for PunBB. There should be a html "Thank you" link below each post. Guests, Members, Mods and Admins (all) should be able to click those thank you links below each post if they like the post and want to show their appreciation. If Guests click the link for a post, it should show below that post: "X Guest(s) say(s): Thank you." X is the number of guests who have clicked thanks for that particular post. And if members or mods or admin click the Thank you link, it should show their names, "Username1, Username2... say(s): Thank you." where username1, username2 etc. are the usernames of the logged in members who click thank you for that post.

Both vBulletin and Phpbb have a Thank You mod and I found previously that it is greatly used by the forum members. It was one of the most popular MODs I had. They normally don't want to type a reply to a post but still they say thank you on so many posts. It is very encouraging to the posters also and promotes more participation and gives a community feeling. Can anyone kindly design this MOD? Thank you.

]]> http://punbb.informer.com/forums/user/11629/ 2009-10-12T23:00:53Z http://punbb.informer.com/forums/topic/17714/thank-you-mod/new/posts/ <![CDATA[Request style "Crystal Blue"]]> Request style "Crystal Blue"!

Thanks!

]]> http://punbb.informer.com/forums/user/21824/ 2009-10-06T17:36:46Z http://punbb.informer.com/forums/topic/22344/request-style-crystal-blue/new/posts/