11-26-08 10:22 AM - Post#2832    

Modification / Version: Newbie Notice v1

Description: This puts a notice box on the top of their first post so that new readers don't flame them for something obvious, but to cut them slack and provide them more care, and give them a warm welcome.

Working Under: Fusion 3.0

Modification Status: Beta

Pre-requisites:

Author(s): Stephen

Date: 11/26/08

Credits:

Files Altered: showtopic.php, templates/fusionbb/showto pic_p_row.ph

New Files:

Datebase Altered: no

Instructions / Other Info: in showtopic.php FIND:

Code:



 
$template->loadTemplate("showtopic_p_row");
 

ADD AFTER:

Code:



 
    if ($post_data[$i]['info_total_posts'] == 1  ) {
            $template->setTemplateVar("NEWBIE","<div align='center' class='color3'><b>This is a new member, and their 1st post!</b></div>");
    }
 

in templates/fusionbb/showto pic_p_row.php FIND:

Code:



 
<td width='90%' valign='top'>
<!--EVENT-->
 

REPLACE WITH

Code:



 
<!--NEWBIE-->
<td width='90%' valign='top'>
<!--EVENT-->
 

Disclaimer:
Please backup every file that you intend to modify. If the modification modifies the database, it's a good idea to backup your database before doing so.

Note: If you modify your Fusion code, you may be giving up your right for 'official' support from InteractivePHP, Inc..If you need official support, you'll need to restore unmodified files.

Attachment

Attachment: Picture_3.jpg (24.47 KB) 127 View(s)

Edited by Stephen on 11-26-08 10:23 AM. Reason for edit: No reason given.

11-27-08 01:12 AM - Post#2833    

    In response to Stephen

Optionally shows up with five or less posts

Code:



 
 if ($post_data[$i]['info_total_posts'] <= 5  ) {
            $template->setTemplateVar("NEWBIE","<div align='center' class='color3'><b>This is a new member, and their first five posts!</b></div>");
    }
 

Edited by Stephen on 11-27-08 01:13 AM. Reason for edit: No reason given.

12-08-08 01:51 PM - Post#2835    

    In response to Stephen

Thanx

Part Time Code Monkey for FusionBB

12-18-08 11:49 PM - Post#2838    

    In response to couchtomatoe

This will count the post (1-5) and remain on every members first five posts.

Use this instead of the code i posted above.

You will want to put this into several areas showtopic showtopicforreply recent_activity (when FULL)

Code:



 
// --------------------------------------------------------------------------------------------------
    //    NEWBIE NOTICE COUNT THE FIRST 5 POSTS
    // --------------------------------------------------------------------------------------------------
        $sql = "
            SELECT p.post_id
            FROM ". TABLE_PREFIX ."posts AS p
            WHERE p.user_id = ". $post_data[$i]['user_id']. "
            ORDER BY p.post_posted ASC
            LIMIT 5
        ";
    
        if(!$results=$db->executeQuery($sql)) {
            dieHere(1,$lang_str['BAD_QUERY'],__LINE__,__FILE__,$sql);
        }
        
        $upid = $db->fetchArray($results);
        $db->clearResults($results);
        
        $upid_array = NULL;
        
        foreach ($upid as $key => $value) {
            $upid_array .= $value['post_id'] .",";
        }
        
        $upid_array = explode (",",$upid_array);
    
        $post_num = '';
        $post_name = $post_data[$i]['info_display_name'];
        
        if($upid_array[0] == $post_data[$i]['post_id'] ){ $post_num = "Welcome $post_name's first post!"; }
        if($upid_array[1] == $post_data[$i]['post_id'] ){ $post_num = "This is $post_name's second post."; }
        if($upid_array[2] == $post_data[$i]['post_id'] ){ $post_num = "This is $post_name's third post."; }
        if($upid_array[3] == $post_data[$i]['post_id'] ){ $post_num = "This is $post_name's fourth post."; }
        if($upid_array[4] == $post_data[$i]['post_id'] ){ $post_num = "This is $post_name's fifth post."; }
    
        if (in_array( $post_data[$i]['post_id'] , $upid_array ) ) {
            $template->setTemplateVar("NEWBIE","<div align='center' class='color3'><b>$post_num</b></div>");
        } else {
            $template->setTemplateVar("NEWBIE","");
        }
        
 

Edited by Stephen on 12-18-08 11:51 PM. Reason for edit: No reason given.

01-06-09 09:01 PM - Post#2839    

    In response to Stephen

Neat one

www.fordmondeo.org www.stdrivers.co.uk

01-15-09 04:51 PM - Post#2840    

    In response to Monkeyra

That's an excellent idea, Stephen. Thanks!

07-25-10 02:09 PM - Post#2969    

    In response to ldraper

Does this work on 3.1?

I tried & got a db error:

Code:



 Invalid QueryFile: /home/spiritb1/public_html/fusion/showtopic.php
Line: 3041
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.post_posted ASC LIMIT 5' at line 4
SQL Error #: 1064
SQL Query: SELECT p.post_id FROM fbb_posts AS p WHERE p.user_id = ORDER BY p.post_posted ASC LIMIT 5  

Does this need to go into the template files as well?