cool little mod thx!

rjg wrote:

All,

  I figured I would let you guys know that I modded this a little bit and actually have it show the sidebar on the "Portal" page and left the sidebar off in the actual forums.  If anyone is interested, I can post the changes, it is actually very easy..

yes, please do explain.

scottywz wrote:
Ataxy wrote:

ok well i got it to work
so any way just a stupid error in the code of my previous code
the line to be added are the following it only gives two table but one may easly mod it to have more then two

'#\[table\](.*?),(.*?)\[/table\]#',

and

'<table><tr><td>$1</td><td>$2</td></tr></table>',

as i understood since xhtml is strict i had forgoten to close the <table> tag to </table>
and the result is the following
http://d-vault.peerforces.com/table2.png

EDIT:
ok to get 3 table just add this

'#\[table3\](.*?),(.*?),(.*?)\[/table3\]#',

and this

'<table><tr><td>$1</td><td>$2</td><td>$3</td></tr></table>',

I guess this is just a newbie question, but what is the # for? I know the \ escapes things.

i dont have any idea i just copyed the pattern in the parser file to figure how to make it

oh yeah sorry mod my error

but can it be corrected in 1.2.x

is it in the /* 3. BORDER COLOURS */ section of the xxx_cs.css file

why dont you just use the attachment plugin and limit it to image file only

i remember having seen someone post about it but sorry about posting about it again did not find the thread

so here is my problem i can seem to get the space in between the username+avatar and the online status to be the same color if you want an image ask me ill post one or if you know where is the thread about the guy who ask the same thing ounce post me the link please

wow connorhd that one is realli good

Connorhd wrote:
<?php
/***********************************************************************

  Copyright (C) 2005  Connor Dunn (Connorhd@mypunbb.com)

  This software 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.

  This software 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

************************************************************************/
// Make sure no one attempts to run this script "directly"
if (!defined('PUN'))
    exit;

// Tell admin_loader.php that this is indeed a plugin and that it is loaded
define('PUN_PLUGIN_LOADED', 1);

    generate_admin_menu($plugin);
?>
    <div class="block"> 
        <h2><span>User Subscriptions</span></h2> 
        <div class="box"> 
            <div class="inbox"> 
                <p>Shows you what topics users are subscribed to, grouped by username</p>
            </div> 
        </div> 
    </div> 
    <div class="block">
        <h2 class="block2"><span>User Subscriptions</span></h2>
        <div class="box">
            <div class="inbox">
                <table class="aligntop" cellspacing="0">
                    <?php
$result = $db->query('SELECT u.username, t.subject FROM '.$db->prefix.'subscriptions AS s LEFT JOIN '.$db->prefix.'users AS u ON s.user_id=u.id LEFT JOIN '.$db->prefix.'topics AS t ON s.topic_id=t.id ORDER BY u.username;');

while ($row = $db->fetch_assoc($result))
{
    if (!isset($last_user)) {
        echo "<tr>\n\t\t\t\t\t\t<th scope=\"row\">\n\t\t\t\t\t\t\t".$row['username']."\n\t\t\t\t\t\t</th>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span>";
        echo $row['subject'];
    }
    elseif ($last_user == $row['username']) {
        echo ', '.$row['subject'];
    }
    else
    {
        echo "</span>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th scope=\"row\">\n\t\t\t\t\t\t\t".$row['username']."\n\t\t\t\t\t\t</th>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span>";
        echo $row['subject'];
    }
    $last_user = $row['username'];
}
echo "\n"
?></span>
                        </td>
                    </tr>
                </table>
            </div>
        </div>
    </div>

much better, it displays properly, it doesn't use the db plugin so its not full of all the stuff from that, and it groups by username

hey connorhd what do i do save that script as  AMP_User_subscriptions.php and upload it to my plugin folder

scottywz wrote:

Inspired by this post, this admin/moderator plugin allows you to see what posts users are subscribed to. It is based on the DB Management plugin by Connorhd.

Download instructions (if you don't want to go to the PunBB downloads page):
1. Go to http://phpxplorer.scottywz.com
2. You are already logged in as guest. Don't try to login as me or root (the passwords here are not the default ones).
3. Click on dloads.
4. Click on PunBB.
5. Click the arrow next to AMP_User_subscriptions.zip.
6. Extract and upload like a regular plugin.

I can't give you a direct link to the download due to its location in my Web hosting account.

Enjoy!

i get this
SELECT u.username, t.subject FROM punbb_subscriptions AS s LEFT JOIN punbb_users AS u ON s.user_id=u.id LEFT JOIN punbb_topics AS t ON s.topic_id=t.id;

but the plugin is working its just that this appears at the top of the list of subscribe post

could be

heu i need some clarification here isnt this going to be the same icon nomather if the thread is read or not

does not work for me all i get is two drop down box with nothing to choose from

39

(67 replies, posted in News)

Rickard wrote:

Ataxy: I've completely forgot about that. I'll get on it.

`

thx i appreciate

looks fine here to

41

(67 replies, posted in News)

ok were is the last change log with fix to 1.2.5 to go from 1.2.4 to 1.2.5

oh theis seem to have done the trick connorhd

for your info in case you want to see it here is my index.php

<?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='', $show=15, $truncate=1)
{
    global $lang_common, $db, $pun_config, $db_prefix;
    $max_subject_length = 60;
    $show_max_topics = 50;
    $fid = intval($fid);
    $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
    $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.' ORDER BY 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>D-Vault Info</span></h2>
            <div class="box">
                <div class="inbox">
                    <p>
                     <center><b>Welcome to D-Vault and thank you for your participation in the different part of our com.
                     <br>
                     Bienvenue sur D-Vault et merci pour votre participation dans les differente partie de notre com.</b></center>
                    </p>
                </div>
            </div>
        </div>
<?php
echo pun_news(44, 12, 0);
 
require PUN_ROOT.'footer.php';
Connorhd wrote:

Ataxy: huh? it doesn't display replies for me, surely if it just suddenly started its something you have done?

shinko_metsuo: whats wrong with my page?

actualy no all i did was recently change the amount of news been shown from 5 to 12 as news where going away to fast also the weird part is that it stopped showing the reply after the second reply

Connorhd wrote:

#1: In one of the category i made a forum called news section wich is the one i am linking to my miniportal how can i make it so only the first post of each thread is shown in the miniportal and not the reply.

it only displays the first post anyway

well it seem that it does now it suddently started to display the reply of user

45

(3 replies, posted in PunBB 1.2 troubleshooting)

well i dont think that you can use them in a url correct me if i am wrong

thx Giz it works wonder

would it work in 1.2.4

48

(27 replies, posted in Feature requests)

wow thats cool paul how did you do it

Paul wrote:

You already have it.

tr.isticky td {background-color: whatever}

You can do the same with closed and new topics as well.  How you cope with something that is both sticky and new is upto you.

Moved to PunBB discussions.

in what file will i find this line

wow cool mod
merci ju!