The Arcive of Official vBulletin Modifications Site.

Welcome Panel Template Rewrite · **Released**: 06-11-2006

Introduction:

When I first installed Zero Tolerence's Welcome Panel, I found that it had a lot of mistakes on my computer. I set out to make a new template for the hack - and I succeeded. This template is my rewrite of Zero Tolerence's hack.

This Hack Made Possible By Zero Tolerance

Please Remove Zero Tolerance's Plugins When Upgrading from a Previous Version!

Hack Requirements:
This hack has one requirement:

vBulletin v3.6.0 or higher. (Confirmed working with vB 3.7.0 RC1)

Installation

Installation is a breeze! Follow these simple steps:

Upload Files into folders.
Install Welcome Panel Product
Customize!

Yes, it's that simple.

Feature Lists:
Support for v1.x has been dropped.

v2.2.0

Displays the number of new posts.
It displays the user's avatar & links to the edit avatar page.
Displays your forum stats:
- Posts
- Threads
- Members
The welcome panel is fully phrased.
Displays a link for new posts.
There is a link to edit your profile.
It shows the forum your most active in.
It displays the percent of your posts compared to the total forum posts.
It displays the users posts per day count.
It displays the users number of posts.
The welcome panel is collapsable if the user doesn't want it there.
Completely customizable through a setting group with 13 settings.
Displays users current time (in their time zone)!
Image or Textual links for New Posts, Daily Posts, and Edit Your Profile.
Displays the number of new Private Messages.
Displays the number of new Threads.
Customizable link for forum rules.
Customizable to the latest forum announcement (thread only).
Latest Announcment name is customizable through a setting.
There is an admin editable section for "useful links", HTML required.
Link to forum leaders. (uses vB default phrase so if you change it to something else the welcome panel also changes)
Link to Mark Forums Read. (uses vB default phrase so if you change it to something else the welcome panel also changes)
Link to the announcement forum.
The colors now alternate correctly on your welcome panel.
Show Version
Welcome Panel Style (Second Style by Da Pro)
FAQ Entries

v3.0.0

Displays the number of new posts, threads, and unread private messages.
Displays the current time (using the user?s time settings)
It displays the user's avatar & links to the edit avatar page.
Displays your forum stats:
- Posts
- Threads
- Members
Top Poster Statistics
- Username
- Profile
- Amount of Posts
Fully Phrased
- Re-Phrased from v2.2.0
New Posts Link (Image or Text)
Edit Profile Link (Image or Text)
Daily Posts (Image or Text)
The forum the user is most active in.
How much percentage of the forums total posts does the user own.
How many ?Posts Per Day? the user has.
The Panel is Collapsible
Customizable through 13 settings
- Revamp Settings from v2.2.0
Forum Rules link.
Forums Latest Announcement
- Pulled Dynamically from specified forum.
Admin Set ?useful? links ? BBCode allowed!
Links to Forum Leaders (vBulletin?s Phrase)
Links to the Mark Forums Read system (vBulletin?s Phrase)
Links to the Announcement Forum (optional)
Alternating Colors
Welcome Panel Version (optional)
Welcome Panel Style Improved!
BBCode Parsing
Link to vBulletin.org in ACP?s Product Manager
Version Checking enabled.
Retrieve Latest Version from database, and display in template.
Improved Code: With Zero Tolerance's Permission, code rerelease made this a possibility! Improved!
Optional Plural Checking (New Posts, New Threads) New!
No Avatar Image: Uses the Image Path setting New!
Multiple Templates! New!

Conflicts:
Users have reported that there is a conflict with this modification:
https://vborg.vbsupport.ru/showthread.php?t=122995

Change Log:
v3.0.5: May 16, 2007 - New Features & Improved Code
v3.0.4: March 23, 2007 - Bug Fix - new auto version update.
v3.0.3: Immediately released to replace 3.0.2 to add the correct template.
v3.0.2: Bug Fix, immediately removed from download
v3.0.1: Bug Fix
v3.0.0: Initial Release of 3.0.0

AzH · #**402** 05-09-2008, 07:17 PM

Quote:

(Confirmed working with vB 3.7.0 RC1)

I just tried to install on 3.7 Gold and got a db error.

King Kovifor · #**403** 05-09-2008, 07:24 PM

There is a patch on one of these pages. I really should link to it.

AzH · #**404** 05-09-2008, 07:25 PM

It's here: https://vborg.vbsupport.ru/showpost....&postcount=151

I just tried it and got the same error??

Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 02:07 PM, 9th May 2008 AND visible = 1;

MySQL 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 ':07 PM, 9th May 2008 AND visible = 1' at line 1
Error Number : 1064
Request Date : Friday, May 9th 2008 @ 04:23:48 PM
Error Date : Friday, May 9th 2008 @ 04:23:48 PM
Script : http://devioustyrant.com/index.php
Referrer :
IP Address :
Username : AzH
Classname : vb_database
MySQL Version : 4.1.22-standard

King Kovifor · #**405** 05-09-2008, 07:28 PM

Can you post your Main Plugin?

AzH · #**406** 05-09-2008, 07:34 PM

Welcome Panel - Main

Code:

if ($vbulletin->userinfo['userid'] > 0 && $vbulletin->userinfo['userid'] != '' || !$vbulletin->userinfo['userid'])
{
    require_once(DIR . '/includes/functions_user.php');
    $vbulletin->userinfo['avatar_build'] = fetch_avatar_url($vbulletin->userinfo['userid']);

    if (empty($vbulletin->userinfo['avatar_build']) || !is_array($vbulletin->userinfo['avatar_build']))
    {
        $vbulletin->userinfo['avatar_build'] = array($vbulletin->options['wp_forumimagelink'] . 'noavatar.gif');
    }

    $vbulletin->userinfo['avatar_build'] = '<img src="' . $vbulletin->userinfo['avatar_build'][0] . '"'.iif($vbulletin->userinfo['avatar_build'][1],$vbulletin->userinfo['avatar_build'][1],'').'border="0" alt="Edit Your Avatar" />';

    $postsin = array();
    $gp      = $db->query_read("SELECT p.threadid, t.forumid FROM " . TABLE_PREFIX . "post p LEFT JOIN " . TABLE_PREFIX . "thread t ON(t.threadid = p.threadid) WHERE p.userid = {$vbulletin->userinfo['userid']}");
    while ($gpb = $db->fetch_array($gp))
    {
        if (!$postsin[$gpb['forumid']])
        {
            $postsin[$gpb['forumid']] = 1;
        }
        else
        {
            $postsin[$gpb['forumid']]++;
        }
    }

    $active = array(0);

    if (is_array($postsin) && is_array($vbulletin->forumcache))
    {
        foreach ($postsin as $forumid => $pi)
        {
            if ($pi > $active[0])
            {
                $active = array($pi, $forumid);
            }
        }
    }

    if (!empty($active[1]))
    {
        $vbulletin->userinfo['active'] = array($vbulletin->forumcache[$active[1]], $active[0]);
    }
    else
    {
        $vbulletin->userinfo['active'] = false;
    }

    $exec_totalposts = str_replace(',', '', $totalposts);

    if ($exec_totalposts < 1)
    {
        $exec_totalposts = 1;
    }

    $vbulletin->userinfo['posts'] = vb_number_format($vbulletin->userinfo['posts']);
    $jointime = (TIMENOW - $vbulletin->userinfo['joindate']) / 86400;

    if ($jointime < 1)
    {
        $vbulletin->userinfo['postsperday'] = $vbulletin->userinfo['posts'];
    }
    else
    {
        $vbulletin->userinfo['postsperday'] = vb_number_format(str_replace(',', '', $vbulletin->userinfo['posts']) / $jointime, 2);
    }

    $vbulletin->userinfo['postpercent'] = vb_number_format(((str_replace(',', '', $vbulletin->userinfo['posts']) / $exec_totalposts ) * 100),2);

    $vbulletin->userinfo['newposts'] = $db->query_first("SELECT COUNT(*) AS newposts FROM " . TABLE_PREFIX . "post WHERE dateline >= '{$vbulletin->userinfo['lastvisit']}' AND visible = '1'");
    $vbulletin->userinfo['newposts'] = vb_number_format($vbulletin->userinfo['newposts']['newposts']);

    $vbulletin->userinfo['newthreads'] = $db->query_first("SELECT COUNT(*) AS newthreads FROM " . TABLE_PREFIX . "thread WHERE dateline >= '{$vbulletin->userinfo['lastvisit']}' AND visible = '1' AND sticky in(0,1)");
    $vbulletin->userinfo['newthreads'] = vb_number_format($vbulletin->userinfo['newthreads']['newthreads']);

    $vbulletin->userinfo['lastvisit'] = vbdate($vbulletin->options['timeformat'], $vbulletin->userinfo['lastvisit']) . ', ' . vbdate($vbulletin->options['dateformat'], $vbulletin->userinfo['lastvisit']);

    $exec_lastposts = $db->query_first("SELECT COUNT(*) AS lastposts FROM " . TABLE_PREFIX . "post WHERE visible = 1 AND dateline >= ".(TIMENOW - 86400));
    $exec_lastposts = vb_number_format($exec_lastposts['lastposts']);

    $vbulletin->templatecache['FORUMHOME'] = str_replace('$navbar','$navbar ' . $vbulletin->templatecache['forumhome_welcomepanel_' . $vbulletin->options['wp_style']],$vbulletin->templatecache['FORUMHOME']);
}

King Kovifor · #**407** 05-09-2008, 08:09 PM

Try...

PHP Code:


			
if ($vbulletin->userinfo['userid'] > 0 && $vbulletin->userinfo['userid'] != '' || !$vbulletin->userinfo['userid'])
{
    require_once(DIR . '/includes/functions_user.php');
    $vbulletin->userinfo['avatar_build'] = fetch_avatar_url($vbulletin->userinfo['userid']);

    if (empty($vbulletin->userinfo['avatar_build']) || !is_array($vbulletin->userinfo['avatar_build']))
    {
        $vbulletin->userinfo['avatar_build'] = array($vbulletin->options['wp_forumimagelink'] . 'noavatar.gif');
    }

    $vbulletin->userinfo['avatar_build'] = '<img src="' . $vbulletin->userinfo['avatar_build'][0] . '"'.iif($vbulletin->userinfo['avatar_build'][1],$vbulletin->userinfo['avatar_build'][1],'').'border="0" alt="Edit Your Avatar" />';

    $postsin = array();
    $gp      = $db->query_read("SELECT p.threadid, t.forumid FROM " . TABLE_PREFIX . "post p LEFT JOIN " . TABLE_PREFIX . "thread t ON(t.threadid = p.threadid) WHERE p.userid = {$vbulletin->userinfo['userid']}");
    while ($gpb = $db->fetch_array($gp))
    {
        if (!$postsin[$gpb['forumid']])
        {
            $postsin[$gpb['forumid']] = 1;
        }
        else
        {
            $postsin[$gpb['forumid']]++;
        }
    }

    $active = array(0);

    if (is_array($postsin) && is_array($vbulletin->forumcache))
    {
        foreach ($postsin as $forumid => $pi)
        {
            if ($pi > $active[0])
            {
                $active = array($pi, $forumid);
            }
        }
    }

    if (!empty($active[1]))
    {
        $vbulletin->userinfo['active'] = array($vbulletin->forumcache[$active[1]], $active[0]);
    }
    else
    {
        $vbulletin->userinfo['active'] = false;
    }

    $exec_totalposts = str_replace(',', '', $totalposts);

    if ($exec_totalposts < 1)
    {
        $exec_totalposts = 1;
    }

    $vbulletin->userinfo['posts'] = vb_number_format($vbulletin->userinfo['posts']);
    $jointime = (TIMENOW - $vbulletin->userinfo['joindate']) / 86400;

    if ($jointime < 1)
    {
        $vbulletin->userinfo['postsperday'] = $vbulletin->userinfo['posts'];
    }
    else
    {
        $vbulletin->userinfo['postsperday'] = vb_number_format(str_replace(',', '', $vbulletin->userinfo['posts']) / $jointime, 2);
    }

    $vbulletin->userinfo['postpercent'] = vb_number_format(((str_replace(',', '', $vbulletin->userinfo['posts']) / $exec_totalposts ) * 100),2);

    $vbulletin->userinfo['newposts'] = $db->query_first("SELECT COUNT(*) AS newposts FROM " . TABLE_PREFIX . "post WHERE dateline >= '" . $vbulletin->userinfo['lastvisit'] ."' AND visible = '1'");
    $vbulletin->userinfo['newposts'] = vb_number_format($vbulletin->userinfo['newposts']['newposts']);

    $vbulletin->userinfo['newthreads'] = $db->query_first("SELECT COUNT(*) AS newthreads FROM " . TABLE_PREFIX . "thread WHERE dateline >= '" . $vbulletin->userinfo['lastvisit'] ."' AND visible = '1' AND sticky in(0,1)");
    $vbulletin->userinfo['newthreads'] = vb_number_format($vbulletin->userinfo['newthreads']['newthreads']);

    $vbulletin->userinfo['lastvisit'] = vbdate($vbulletin->options['timeformat'], $vbulletin->userinfo['lastvisit']) . ', ' . vbdate($vbulletin->options['dateformat'], $vbulletin->userinfo['lastvisit']);

    $exec_lastposts = $db->query_first("SELECT COUNT(*) AS lastposts FROM " . TABLE_PREFIX . "post WHERE visible = 1 AND dateline >= ".(TIMENOW - 86400));
    $exec_lastposts = vb_number_format($exec_lastposts['lastposts']);

    $vbulletin->templatecache['FORUMHOME'] = str_replace('$navbar','$navbar ' . $vbulletin->templatecache['forumhome_welcomepanel_' . $vbulletin->options['wp_style']],$vbulletin->templatecache['FORUMHOME']);
}

AzH · #**408** 05-09-2008, 08:14 PM

Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 02:07 PM, 9th May 2008 AND visible = 1;

MySQL 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 ':07 PM, 9th May 2008 AND visible = 1' at line 1
Error Number : 1064
Request Date : Friday, May 9th 2008 @ 05:13:41 PM
Error Date : Friday, May 9th 2008 @ 05:13:42 PM
Script : http://devioustyrant.com/index.php
Referrer :
IP Address :
Username : AzH
Classname : vb_database
MySQL Version : 4.1.22-standard

No luck. :/

It's good of you to care enough to help out.

King Kovifor · #**409** 05-09-2008, 08:21 PM

This may sound stupid, but are you SURE that you have update the code? As the error is because of not adding a ' ' around the date.

AzH · #**410** 05-09-2008, 08:27 PM

Sorry, I'm a clutz. I updated the wrong welcome panel. I did vBulletins rather than the WPTR plugin. So now it's displaying twice.

Woo, go me!!

King Kovifor · #**411** 05-09-2008, 10:42 PM

Ah. That's cool. My tip off was the same exact error message. :P

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05582 seconds Memory Usage 2,384KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (1)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!