Welcome Panel Template Rewrite

[cKat]

Thankies, works great!

[King Kovifor]

I'm not exactly sure how to do that. I never discovered that part. Maybe using forum permissions. I'm not actually on my computer, so I don't have all my resources. I may be able to look at it tomorrow.

[raiderlax]

Wow hey thanks alot it works pretty sweet, but one thing,

How do you get rid of that space under "get new posts, get daily posts, etc..." their is quite alot of space their and it doesn't really look good?

How could you add "YOUR CURRENT SIGNATURE"(with their signature their) to replace that space, under the "get new posts, get daily posts, etc..."

Also importantly when I turn on images for panel rewrite the images are outlined like in the attached pic, how do we fix this?

[King Kovifor]

The outline would probably have to do with your style's CSS. And signature, just got to figure out how to add that.

[raiderlax]

Okay thanks, may I ask where do you edit the stuff that shows their?

[King Kovifor]

Look at how they show it inside the MEMBERINFO template... I wish I could help you more right now.

[Gottcha]

ok just noticed this .... with the default setting i get this:

There have been 83,329 posts and 11,194 threads since your last visit at 07:00 PM, 12-31-1969. The time is currently 10:22 PM, on 07-23-2007. You have 0 unread Private Messages.

i wasnt born in 1969 ... lol ... any ideas how to fix this please

[King Kovifor]

Um. Your last visit time would be off in the database or the plugin would be calling it all wrong. What does the date say in the navigation welcome?

[Naxon]

<a href="http://programs.coders.co.il/forums/" target="_blank">http://programs.coders.co.il/forums/</a>
I activated the mod via the vBulletin Options and it's just do nothing... Why?

Daniel.

[principino1984]

sorry man... probably someone has already asked you this...but.. how do I change the position of this hack in forumhome?

[King Kovifor]

http://programs.coders.co.il/forums/
I activated the mod via the vBulletin Options and it's just do nothing... Why?

Daniel.

Make sure the templates were created... This only shows on your forum home. And if you somehow replaced the $navbar variable this won't work.

sorry man... probably someone has already asked you this...but.. how do I change the position of this hack in forumhome?

You have to mess within the plugin.

[Gottcha]

Um. Your last visit time would be off in the database or the plugin would be calling it all wrong. What does the date say in the navigation welcome?


There have been 83,359 posts and 11,196 threads since your last visit at 07:00 PM, 12-31-1969. The time is currently 09:14 PM, on 07-24-2007. You have 0 unread Private Messages.

[King Kovifor]

There have been 83,359 posts and 11,196 threads since your last visit at 07:00 PM, 12-31-1969. The time is currently 09:14 PM, on 07-24-2007. You have 0 unread Private Messages.

The navigation bar is the one where it says:

Welcome, Gottcha.
You have 0 unread messages.
You last visited: Yesterday at 14:00

Next to where it shows you your current location.

[Gottcha]

Welcome, Gottcha.
You last visited: Today at 06:43 PM
Private Messages: Unread 0, Total 41.

[King Kovifor]

Meaning that your plugin is not pulling the correct last visit time. AH! Have you modified the plugin in any way?

[Gottcha]

no ... id have no idea how to do that ... never touched it

[King Kovifor]

no ... id have no idea how to do that ... never touched it

Not sure what is up, maybe try re-importing the product, or if you would like you can PM me admin details and I can look at it...

[Gottcha]

any luck with it?

[King Kovifor]

Gottcha, I fixed it.

[lasto]

is there a welcome panel that shows avatar that works on vb3.6.8 as ive just tried this and got database error straight away so had to uninstall

[King Kovifor]

What was the database error. I believe there was a patch released for a DB error. The patch was integrated into v3.0.6, but that's no where near ready.

[djdonx]

Hey, I have installed the hack and it all works fine, I was wondering if there is a code to choose where you want to place the info on the page because I have vB shout installed at the top aswell and the Welcome Panel Template is above the shoutbox. I was wondering wether there might be a code so it can be changed in tyhe admin panel to places like below forums or below whats going on, thanks for your help if you can look into this :)

[King Kovifor]

The way the plugin works is it attaches itself to the $navbar variable. If you find another variable to attach it to and modify the plugin is the only way to do it.

[djdonx]

The way the plugin works is it attaches itself to the $navbar variable. If you find another variable to attach it to and modify the plugin is the only way to do it.
How would I go about doing this?

[King Kovifor]

I've never done it but you would have to find a variable in near the very top of the FORUMHOME template (or add one where you want it) and edit the Main plugin.

[BigDog56]

Very nice! Works as stated. Thank you very much!

[lasto]

How many queries does this add to main Page ?

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 07:39 PM, 07-29-2007 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 ':39 PM, 07-29-2007 AND visible = 1' at line 1
Error Number : 1064
Date : ***************
Script : **************
Referrer : ****************************
IP Address : ****************
Username : ***********
Classname : ****************

so cause of the error have to disable it to find a fix but i really need to know how many queries this adds on forumhome.

[djdonx]

I managed to sort out the postion of the welcome panel, I added a variable above the 'Whats Going On?' area. Thanks for the help :)

[King Kovifor]

How many queries does this add to main Page ?

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 07:39 PM, 07-29-2007 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 ':39 PM, 07-29-2007 AND visible = 1' at line 1
Error Number : 1064
Date : ***************
Script : **************
Referrer : ****************************
IP Address : ****************
Username : ***********
Classname : ****************

so cause of the error have to disable it to find a fix but i really need to know how many queries this adds on forumhome.

Let me find the patch. And 5 maybe.

Here's the patch:

https://vborg.vbsupport.ru/showpost.php?p=1249707&postcount=151

[Techno05]

I had it once and it showed up but now it isnt is it because I have a shoutbox or what? Can you help me please...

[errorerror]

I used the patch and i got his db error.

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 12:01, 30-07-07 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 ':01, 30-07-07 AND visible = 1' at line 1
Error Number : 1064
Date : Monday, July 30th 2007 @ 05:25:52 AM
Script : h**p://******/forum/index.php
Referrer :h**p://*******/forum/admincp/index.php?do=head
IP Address : *******
Username :******
Classname : vb_database

[King Kovifor]

I used the patch and i got his db error.

You couldn't have used the patch on that. The patch adds a ' ' around it and stuff so it WON'T give the error.

I had it once and it showed up but now it isnt is it because I have a shoutbox or what? Can you help me please...

I can't see why a shout box would be the problem. Did you disable the product?

[flindersredclaw]

NIce - dropped onto 3.6.8 no issues so far

thank you

[dodgeuk19]

hi
i have installed and it works fine however is there anyway of getting it on my VBAdvance homepage ??

thanks

Dodge

* INSTALLED *

[King Kovifor]

Without hacking this no, with hacking yes. But I'm not sure how to do it / get it to work. Try asking at vBA.com - he may be able to help you.

[dodgeuk19]

thanks for the quick reply,

i think it will be an easy thing like entering something in the global output variables

but will ask them there, thanks

[Techno05]

<a href="http://www.sigrequest.com" target="_blank">www.sigrequest.com</a> is my site do you see anything that can stop it from working? It is turned on and everything...

[King Kovifor]

One I'm a guest and won't see it, two it is saying Javascript isn't enabled on my browser. SO no.

[raiderlax]

Look at how they show it inside the MEMBERINFO template... I wish I could help you more right now.

Like what is this actual template so that I can add more options and features into it?

Thanks. :)

[King Kovifor]

Like what is this actual template so that I can add more options and features into it?

Thanks. :)

If you are talking about the welcome panel, it depends on your "style", but it is forumhome_welcomepanel_STYLE-VAR.

[raiderlax]

How do you uninstall this?

Thanks

[Devil Woman]

I have a problem, after installing I have found that I have a problem with the amount of posts and threads I have it is giving the wrong information, it states I have 1 posts and 2 threads however I have 23 posts and 2 threads, I have tried unistalling and reinstalling and checking all settings are ok but still keep getting the problem, could there be a conflict with another hack?

[King Kovifor]

How do you uninstall this?

Thanks

You just remove the product from the Product Manager.

I have a problem, after installing I have found that I have a problem with the amount of posts and threads I have it is giving the wrong information, it states I have 1 posts and 2 threads however I have 23 posts and 2 threads, I have tried unistalling and reinstalling and checking all settings are ok but still keep getting the problem, could there be a conflict with another hack?


HM... I didn't create the code for post counts. You have 23 posts... Looks like it isn't counting the posts table correctly. Can you post the code to the "Main" plugin that you have, please?

[gforce75]

Works great, installed

[kaptanblack]

Thanks... :cool:

[King Kovifor]

Glad you two liked it. :D

[Devil Woman]

You just remove the product from the Product Manager.




HM... I didn't create the code for post counts. You have 23 posts... Looks like it isn't counting the posts table correctly. Can you post the code to the "Main" plugin that you have, please?

Thanks for the reply where would I find the code for the main plugin?

Thanks

[King Kovifor]

Adminstrators Control Panel -> Plugins & Products -> Manage Plugins -> "Welcome Panel Template Rewrite" -> Main -> Edit. That will open up a browser editor for that, but copy and past into the php tags here.

[MeMySelfNi]

How do u make the no avatar gif show up?

[King Kovifor]

You must upload the image from ZT's package and add the path to noavatar.gif in your ACP.

[Devil Woman]

Adminstrators Control Panel -> Plugins & Products -> Manage Plugins -> "Welcome Panel Template Rewrite" -> Main -> Edit. That will open up a browser editor for that, but copy and past into the php tags here.

Thanks for that I have found it and this is what I have

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']);
}

Thanks alot.

[blue6995]

I am using vBulletin version 3.6 and I am getting the following error message. How can I fix this? Thanks

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM vb3_post WHERE dateline >= 22:11, 16-08-2007 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 ':11, 16-08-2007 AND visible = 1' at line 1
Error Number : 1064
Date : Thursday, August 16th 2007 @ 11:32:12 PM
Script : http://www.rwf-forum.co.uk/vBulletin/index.php
Referrer :
IP Address :
Username : Classname : vb_database

[King Kovifor]

I am using vBulletin version 3.6 and I am getting the following error message. How can I fix this? Thanks

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM vb3_post WHERE dateline >= 22:11, 16-08-2007 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 ':11, 16-08-2007 AND visible = 1' at line 1
Error Number : 1064
Date : Thursday, August 16th 2007 @ 11:32:12 PM
Script : http://www.rwf-forum.co.uk/vBulletin/index.php
Referrer :
IP Address :
Username : Classname : vb_database

There is a Patch a page or too back. It's because of missing { } around the date.

Thanks for that I have found it and this is what I have

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']);
}

Thanks alot.

Everything seems ok...

[LPH2004]

Sorry to bother but this works well on Harry Potter Chat (http://www.harrypotterchat.org) but I cannot get it to show up on Technology Questions (http://www.tabletquestions.com). I installed this on HPC months ago and cannot figure out why the install I'm trying today on TQ doesn't show. Where in the templates do I look to figure out where and how this is to show? I've read through the posts from other people but do not see a solution or answer to the direct question. Maybe the template being used is so tweaked that a manual install is best.

Thank you for this excellent mod and I look forward to a solution.

[King Kovifor]

Are you sure that you have uploaded the product, turned it on, and that the plugin is active?

[LPH2004]

Are you sure that you have uploaded the product, turned it on, and that the plugin is active?

If you are addressing my request for support .. Yes, the product functions in other templates on the site but not the default template.

Where are the template edits being made so I can do this manually?

[King Kovifor]

The templates are being added through the plugin. Does your default template use $navbar?

[andreamarucci]

My compliments, everything works fine except Activate Plural Checking. I've checked this just to try but it's useless for me since I'm in Italy, so I unchecked it.

Problem is that the mod keep adding th "s" after the words.

How can I disable it definitely?

[andreamarucci]

Also, How can I reduce the dimensions of the characters in the welcome panel? I suppose I've to mod the css but I really don't know where.

Thanks again

[King Kovifor]

My compliments, everything works fine except Activate Plural Checking. I've checked this just to try but it's useless for me since I'm in Italy, so I unchecked it.

Problem is that the mod keep adding th "s" after the words.

How can I disable it definitely?

The check for plural is used so that if it is 5 posts, it says posts. But if it is 1 post, it doesn't say 1 posts. And I think editing the prhase and removing some of the {} can get rid of it. I don't know off the top of my head.

Also, How can I reduce the dimensions of the characters in the welcome panel? I suppose I've to mod the css but I really don't know where.

Thanks again

What do you mean the characters? And you could use the Style Manager to add CSS to this mod.

[andreamarucci]

Thanks King, solved my problems!!! :)

[andreamarucci]

Another glitch...

Everything works excepts the messages per day that is always 0,00. I've translated the frontend phrases in italian but the variable {3} is at his place. Following is what I see

69764

What could be?

Thanks in advance...

[King Kovifor]

I looked into that, But I never ever could figure out why that never worked... I'm sorry, but I don't have an answer.

[andreamarucci]

Ok King. I've tried to uninstall the mod and reinstall the original one just to be sure that my translation doesn't affect the mod itself. Uninstallation was successful but when I've reinstalled it I've found that the new one is translated instead of in english.

Do you know why? How can uninstall it completely and reinstall it?

Thanks

[periphrastic]

thank you - "installed"

now time for a terrible question: the images (for the user links) are turning up as boxes with red x's. any advisement?

[King Kovifor]

Make sure you set the /image/ path and uploaded them.

And I'm not sure. Uninstalling a product should remove all the phrases.

[periphrastic]

Make sure you set the /image/ path and uploaded them.

okay & thank you

now i'm really new at this stuff...i downloaded the file, and uploaded each individual image to the images folder - was this what i was supposed to do? how should the path be reading?

[King Kovifor]

Right now, it is reading from your root directory. In you Welcome Panel Template Rewrite options you have to set /images/ as your Image Path setting.

[lasto]

be careful with this hack as it adds 11 queries to your forumhomepage

[wtrk]

how do i move the location of the welcome panel?

[PurpleButterfly]

This is wonderful - thank you so much! :D

Can you tell me how to change the wording of "rules" to "community guidelines" in this sentence:

Don't forget to read the rules.

I looked through all the templates but can't find anything....

[King Kovifor]

This is wonderful - thank you so much! :D

Can you tell me how to change the wording of "rules" to "community guidelines" in this sentence:



I looked through all the templates but can't find anything....

It is inside one of the phrases (global). I forget the prefix.

how do i move the location of the welcome panel?

It is fixed to the $navbar variable in the forum home template.

be careful with this hack as it adds 11 queries to your forumhomepage

Why do people care so much about queries...

[MixMakers]

is it possible to resize the avatar only for the welcome panel?

Would like to know this as well

[King Kovifor]

I would have to mess with the templates. I really am not sure how it's coded anymore. Guess that is what happens when you put it aside for a couple of months.

[Traxdata]

Removed old ZT's panel /reverted old forumhome_welcomepanel / uploaded images to images folder, like in "install" txt, added product-welcomepanelv305 as product, edited welcomepanel main (because of date bug) and still getting DB error 1064. what else should I do, please?
Btw, what to do with .DS-store file?
Thank you...
running vb3.6.5

[King Kovifor]

THe .ds files are harmless and do nothing to your web server (or computer). They are just Macintosh datafiles that are hidden within finder.

What is the exact DB Error?

[Traxdata]

This one:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 17:30, 17th October 2007 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 ':30, 17th October 2007 AND visible = 1' at line 1
Error Number : 1064



:(

[Traxdata]

OK... seems to work now :)

[Traxdata]

I tried a little... couldn't come up with it. Any ideas?

find wp_unread phrase (and then other welcomepanel phrases) and add in english filed or wherever you want:

<span class="smallfont"> + text ("there have been...")+ </span>
should look like:
<span class="smallfont"> There have been [...] unread Private Messages. </span>

-> save.
...and so on...

[Jason Black]

mannnnnn it's corrupt

[Jason Black]

ok nevermind

[Jason Black]

where do all these files go damn it? lol

[King Kovifor]

The image files can go anywhere relative to your forum root. The system is set up to use a setting. I think that's the only files.

[Jason Black]

The image files can go anywhere relative to your forum root. The system is set up to use a setting. I think that's the only files.

where does the ds.store file go?

[King Kovifor]

The ds.store files can be ignored. Sorry missed the post. They are Mac generated files.

[NeoAntrax]

I would like to place the panel it(he,she) arrives completely, between(among) home (principally) and 2 big icons that are seen

http://img528.imageshack.us/img528/1415/snap1cw1.gif (http://imageshack.us)
http://img528.imageshack.us/img528/1415/snap1cw1.9d78d8c7fa.jpg (http://g.imageshack.us/g.php?h=528&i=snap1cw1.gif)

[King Kovifor]

The panel is based off of the $navbar variable...

[NeoAntrax]

explain more please :confused:

[King Kovifor]

Inside the templates there is a $navbar variable, the code auto attaches the panel template to the end of that variable.

[NeoAntrax]

Thank you very much :)

[edge23]

King Kovifor:

This mod is Killer Thanks a Ton m8 :)

/installed

[triplemoons]

Okie okie...

Firstly I tried adding this just to my regular index.php forum page. Didn't work.
Now, if this WILL work, I would like to add it to my portal page (which is now titled index.php).

Is their some sort of code I need to input into the code to make it show up?

[King Kovifor]

Well, I didn't write the original code. I is attached to the $navbar variable in the forum home template on the forum index page... I haven't tried or gotten this to work else where. You could mess with the code to try to get it to work.

[Mudvayne]

I don't want to be shown the forum statistics in welcome panel. So an option for disabling the forum statistics in welcome panel would be fine.

[King Kovifor]

That is just an easy template edit removing them. :D

[Mudvayne]

How many queries do this mod use?

[King Kovifor]

How many queries do this mod use?

I am not sure. Looking through the code would tell you.

[AWJunkies]

I am getting the same issue that the posts and the % are not displaying correct. I have 8185 posts and it says i have 8 and % is blank and should be 6.135. My file is same as the lady posted 2 pages back. Not sure what deal is.

[AWJunkies]

I figured it out there is a conflict with this MOD and https://vborg.vbsupport.ru/showthread.php?t=122995
So you need to choose one or the other.

Not sure why but I disabled that mod and now yours works perfect.

[King Kovifor]

I figured it out there is a conflict with this MOD and https://vborg.vbsupport.ru/showthread.php?t=122995
So you need to choose one or the other.

Not sure why but I disabled that mod and now yours works perfect.

Thanks for that. :( Hopefully this can be resolved sooner or later.

[Endurer]

Installed, rated 5, and nominated. Gosh, how did I miss one of the most useful mods here?

Thanks man, really appreciate that.

[Tikibird]

This is a great hack, thanks King Kovifor!

Just one question, I have a private archive where I moved some heated topics that turned nasty earlier this year as I didn't want new members to be exposed to the nastiness. Some of my members are now reporting that they are shown as being most active in "Archives". How do I exclude the Archive forum from being included in the stats? No one can see this forum except me as sole Admin on my board.

[King Kovifor]

No, not that I know of. Since I didn't write that part of code, I couldn't help you out there...

[blue6995]

I'm getting the same error as trax:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 17:30, 17th October 2007 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 ':30, 17th October 2007 AND visible = 1' at line 1
Error Number : 1064

[King Kovifor]

I'm getting the same error as trax:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 17:30, 17th October 2007 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 ':30, 17th October 2007 AND visible = 1' at line 1
Error Number : 1064

I believe I supplied a patch for that, but I will go back and look for you.

[LouiseWilson]

hi is there anyway to add other information to the template like

<br />$usermoods

and which template would it be put in ?

edit sorry i forgot to say please how ignorant of me

thanks :)

[blue6995]

I believe I supplied a patch for that, but I will go back and look for you.

I found the patch and the mod is working except that:

There have been 14,389 posts and 2,420 threads since your last visit at 01:00, 01-01-1970. The time is currently 22:18, on 07-12-2007. You have 1 unread Private Messages.

Obviously, my last visit was today 071207. How do I fix this? Thanks

[King Kovifor]

OK. It seems to be something else inside the code that isn't using the right setting. Mind posting the Plugin for Welcome Panel Template Main... Sorry I didn't find it for you. We went out and didn't get back till about 10 minutes ago...

[LouiseWilson]

don't suppose you could get back to me on my question could you ?

hi is there anyway to add other information to the template like

<br />$usermoods

and which template would it be put in ?

[King Kovifor]

don't suppose you could get back to me on my question could you ?

I thought the edit meant you figured it out sorry. Depending on what style you have (if you didn't change it from default) it would be forumhome_welcomepanel_def, and I believe you must set that variable in the "Main" plugin.

[Jdm Ej1 Coupe]

Nice! Installed with no Problems on 3.64! Thanks for this!

[LouiseWilson]

main plugin ??
explain please

[King Kovifor]

main plugin ??
explain please

I'm sorry for the long reply. I didn't receive an e-mail saying that there was a reply. There should be a plugin called "Main" in your Plugins Manager under the Welcome Panel Template Rewrite product.

[AWJunkies]

Thanks so much for this mod I changed over form an old welcome panel and this works perfect. I have totally recoded the inside of the box however to match my needs and my network of sites. A++

[aftermath29]

I have this installed and looks great thanks for the mod.I have one thing I cant seem to do and that is move the mod.I want to move it over top the shout box im new to this type of board and would like some help please on how to move it around.

[Jdm Ej1 Coupe]

any word on if this will work on 3.7 b3?

[thefullmaza]

"forumhome_welcomepanel" it's not sow my template plz help and full details and thanks =========================
Installation Steps
=========================
#1. Go to AdminCP
#2. .......
#3. .......
#4. chose page - e.g "Homepage"
#5. put in ........

ftp......? details

[Jdm Ej1 Coupe]

Working on 3.7 B3

[King Kovifor]

I have this installed and looks great thanks for the mod.I have one thing I cant seem to do and that is move the mod.I want to move it over top the shout box im new to this type of board and would like some help please on how to move it around.

I'm sorry for the late reply. I haven't been on home since Christmas really... But it is attached to the bottom of your navbar by the plugin. So it's in a fixed location...

"forumhome_welcomepanel" it's not sow my template plz help and full details and thanks =========================
Installation Steps
=========================
#1. Go to AdminCP
#2. .......
#3. .......
#4. chose page - e.g "Homepage"
#5. put in ........


ftp......? details

What do you mean? I do not get the install steps that you posted. Uploaded the .xml file to your products, if you want to use the images (which is a setting) you must upload them to your server. After that, it should be showing. Make sure the product is enabled in both the Products Manager, and in the options.

Working on 3.7 B3

Thanks for the confirmation.

[newbe_haselina]

Thanks for this hack ... my users and me love it ...

But ... I also have the issue with "0 Posts per Day". As I read in this thread, there is no solution for this :( ... so can you tell me, where I can delete this point? I'm not very firm to that stuff, so I need a "blond" explanation :D

Thanks in advance :)

[King Kovifor]

I don't have access to my test cases, but it should be within one of the wptr_ phrases (I believe). Do a phrase search for Posts per day.

[newbe_haselina]

Hi King,

thanks for your fast reply ... I found that phrase "wp_infotext_post" ... sorry for my stupid question ... what do I have to do now?

I'm sure I have to delete "something"... the variable $vbphrase[wp_infotext_post] maybe? But where do I find it?

Thanks in advance for your support. :-)

[Areku]

My top poster's welcome panel say "0.01 posts per day", which seems not logic.

And a low poster welcome panel states he has 42% of the posts of the whole board which is also false.

Running 3.0.5 on 3.6.8.PL2

Ideas?

Thanks!

[xxshatteredsoul]

Keep getting this error when I try to upload the .xml product

vBulletin Message

No file uploaded and no local file found.

???

[King Kovifor]

My top poster's welcome panel say "0.01 posts per day", which seems not logic.

And a low poster welcome panel states he has 42% of the posts of the whole board which is also false.


Running 3.0.5 on 3.6.8.PL2

Ideas?

Thanks!

It depends on how often you post and how long you have been a member.

Keep getting this error when I try to upload the .xml product

vBulletin Message

No file uploaded and no local file found.


???

Have you tried redownloading? Because I would pin vBulletin for that.

[Areku]

It depends on how often you post and how long you have been a member.


Well I can guarantee you he is also the DAILY TOP POSTER on my forum, so again it makes no sense...

Also it makes no sense to claim a user has 42% of the posts in the whole forum when he has barely 10 posts against 5000 of the top poster...

Is this normal then?

[xxshatteredsoul]

It depends on how often you post and how long you have been a member.



Have you tried redownloading? Because I would pin vBulletin for that.

Found out it was a problem with my host for some reason my TMP folder was not CHMOD for everyone to use works fine now :).

[Areku]

I guess I must give up and uninstall this one :(

[King Kovifor]

I guess I must give up and uninstall this one :(

If you are talking about that one little thing, it is the right functionality. Say you have been a member for 200 days. If you only post 2 times during that time, your equation would like like this:

posts/days = posts per day or 2/200 = .01 posts per day. It is a mathematical equation.

[Areku]

Its not only about the posts per day, but the fact he owns very little posts on the whole forum, and one of the lowest posters' welcome panel say he has 44% of the whole forum posts...

[King Kovifor]

Its not only about the posts per day, but the fact he owns very little posts on the whole forum, and one of the lowest posters' welcome panel say he has 44% of the whole forum posts...

OK. I hate that part of the code. I didn't code it but I need to find a way to change it. It should be removable through the phrases if you want...

[montsa007]

Nize Modd :)

[Veteranich]

Hello! We like your hack and we translated it into Russian and published here (http://vbulletin.su/forum/forum83/thread58.html). If you mind, post here please. If you interested what russian people like your hack and you want to develop your hack in Russia then should come our community of vbulletin developers more frequency and you'll find people that will suggest you ideas for improve your hack.

Thanks, Veteran.

[rob4448585]

Hi,

I have this hack installed in on my forum, i have 4 themes/styles

it shows up for 3 of the 4 themes.
Why would it not show up on the 4th theme?

http://www.norcal1320.com/forums/?styleid=5 does not show up

but
http://www.norcal1320.com/forums/?styleid=1
http://www.norcal1320.com/forums/?styleid=3
http://www.norcal1320.com/forums/?styleid=4

All show up

Any suggestions?

If you need to log in the account is
anonymous
aaaaaa



Thanks
Rob

[King Kovifor]

Most likely, the fourth style does not have template hooks. You would have to add all template hooks that this mod uses (which I can't even remember right now. I haven't touched this code in quite a while).

[Koroku]

Just to note that I installed this on 3.7 RC1 and it works like a charm still :)

[King Kovifor]

Just to note that I installed this on 3.7 RC1 and it works like a charm still :)

Thanks for the confirmation. :)

[EagleNick]

Nice MOD.
Easy to install, and very neat.

Two thumbs up! :D

[NeoAntrax]

Why no refresh "Last published"??

[King Kovifor]

Why no refresh "Last published"??

What do you mean?

[NeoAntrax]

What do you mean?
Attach

[King Kovifor]

Empty your cache. That should refresh once you post a new thread. It should be automatic (unless you are using a version that requires you to do it manually. Try checking the options.

[OS Master]

I just installed it on my 3.7 RC3 forum. It works great; thanks for making such a wonderful mod!

[JimLink]

Has anyone figured out how to add this to all pages not just the forum home yet?

[optrex]

I'm getting a 1064 database error on RC4

***forget it I found a patch.

[Mrdby]

3.7.0 final release?

[King Kovifor]

It should work.

[MSheraz86]

Thanks for the mod, works great on 3.7.0 GOLD :)

Those who get the 1064 database error need to disable 'Welcome Panel - Main' plugin to overcome the database error. I dunno if I should disable the 'Welcome Panel - Template Cache'??? I mean it works so far with it enabled...

[russbo]

Works great for me on 3.7 gold as is. Awesome work!

[King Kovifor]

Thanks for the mod, works great on 3.7.0 GOLD :)

Those who get the 1064 database error need to disable 'Welcome Panel - Main' plugin to overcome the database error. I dunno if I should disable the 'Welcome Panel - Template Cache'??? I mean it works so far with it enabled...

There is a patch for that in one of these posts... I should find that...

[AzH]

(Confirmed working with vB 3.7.0 RC1)

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

[King Kovifor]

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

[AzH]

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

I just tried it and got the same error??

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]

Can you post your Main Plugin?

[AzH]

Welcome Panel - Main

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]

Try...
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]

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]

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]

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]

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

[Tikibird]

This mod works great on 3.7.0 Gold. However I can't get the new Notices feature to work and I think I have to revert the Navbar template to the one that 3.7.0 updated. I am wondering if this mod has altered my Navbar template as I don't want to lose it.

[King Kovifor]

I add this at run time. It shouldn't matter if you revert.

[ronitdeep]

gr8 to encourage members..seen on many forums but eating about 7-8 queries..

[ronitdeep]

can we make it collapsed by default???

[King Kovifor]

can we make it collapsed by default???

Actually not sure. But I believe vBulletin remembers collapsed states so you could have members collapse them it themselves.

[Harley D]

If it is possible, how would I get the New posts and New threads numbers to be a color of my choosing?

[King Kovifor]

One of the settings... It would be a wp_* phrase and would have {X} where X is a number in there... I hope that is right... LOL. Haven't touched this is a long time.

[Harley D]

Thanks for the quick reply.

I have it modified and working.
Heres the code in case anyone else wants to do it.

The changes are in RED
There have been <span style="color:red"><b>{1}</b></span> post{7} and <span style="color:red"><b>{2}</b></span> thread{8} since your last visit at {3}. The time is currently {4}, on {5}. You have <a href="private.php">{6}</a> unread Private Messages.

[King Kovifor]

Thanks for posting that up. :)

[King Kovifor]

There are plans for a new major 3.7 version that may be ported back to 3.6 depending on whether or not I want feel like doing substantial code changes. This will also reduce the amount of queries (at least for a bit).

[vitrag24]

any such mod or plan to release same for vb 3.7.1?

[King Kovifor]

any such mod or plan to release same for vb 3.7.1?

This version should work fine, but the planned version will be designed for vB 3.7.x...

[vitrag24]

This version should work fine, but the planned version will be designed for vB 3.7.x...

expected date of release so i can decide whether i shd install this or wait for update.
Thanks.

[King Kovifor]

I am going to stop giving ETA's as I seem to never come through with them anymore. :( But it will probably be a while due to the immensity of the update.

[vitrag24]

I am going to stop giving ETA's as I seem to never come through with them anymore. :( But it will probably be a while due to the immensity of the update.

mean?
what does eta mean?

[King Kovifor]

mean?
what does eta mean?

Estimated Time of Arrival.

[Aligator21]

For me it doesnt work :(
If i install it, it brings SQL error

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM vb3_post WHERE dateline >= 08:30, 12-06-08 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 ':30, 12-06-08 AND visible = 1' at line 1
Error Number : 1064
Request Date : Thursday, June 12th 2008 @ 09:36:40 AM
Error Date : Thursday, June 12th 2008 @ 09:36:41 AM
Script : **********************
Referrer :
IP Address : *************
Username : *************
Classname : vB_Database
MySQL Version : 4.0.26-standard

[Aligator21]

I managed to get it worked but i have it twice now! :S :S :S

If i disable the :
1. Welcome Panel Main
2. Welcome Panel Template Cache

it shows me only once but... it shows me

? 0,00 posts per day.



and in the admincp, i cant find the options to customize it :(

[King Kovifor]

I managed to get it worked but i have it twice now! :S :S :S

If i disable the :
1. Welcome Panel Main
2. Welcome Panel Template Cache

it shows me only once but... it shows me

? 0,00 posts per day.



and in the admincp, i cant find the options to customize it :(

Did you happen to upgrade from Zero Tolerance's plugins?

[GuaRRand]

i've seen a very nifty one on another site.

http://www.crapforum.nl/index.php?s=

It also shows top posters of the day, the avatar of the top poster, top threads etc..
I asked the admin how he did that but he wouldnt tell....any chance you could fit this in your mod??

[bitbender]

King, I been looking.. whar in tarnation does the .DS_file upload go?

I got the same 0.0 crud as well as it's saying I have 300K posts tto read since It thinks I haven't been online since 1969 :D

Yea, I probably missed removing the older plugins during my upgrade, as I was looking for a product and it appears it was a plug in...

So, uninstall and reinstall?

THx :D

i've seen a very nifty one on another site.

http://www.crapforum.nl/index.php?s=

It also shows top posters of the day, the avatar of the top poster, top threads etc..
I asked the admin how he did that but he wouldnt tell....any chance you could fit this in your mod??ACtually, this mod is cool since they broke it into multiple templates. I have modded the heck outa mine to show site life stats, newest member, etc..

It's a fine piece of work, working on 3.7.1 for me, minus the stat errors, but I think I made that happen cause I can't find whar to put the .DS_Store in da thread... The search here doesnt find any hits on .DS_Store

[King Kovifor]

King, I been looking.. whar in tarnation does the .DS_file upload go?

I got the same 0.0 crud as well as it's saying I have 300K posts tto read since It thinks I haven't been online since 1969 :D

Yea, I probably missed removing the older plugins during my upgrade, as I was looking for a product and it appears it was a plug in...

So, uninstall and reinstall?

THx :D

ACtually, this mod is cool since they broke it into multiple templates. I have modded the heck outa mine to show site life stats, newest member, etc..

It's a fine piece of work, working on 3.7.1 for me, minus the stat errors, but I think I made that happen cause I can't find whar to put the .DS_Store in da thread... The search here doesnt find any hits on .DS_Store

Yeah, that doesn't actually go any where. That is how Mac OS X stores folder information. :)

And multiple templates will be gone in 4.0.0... Based on how the hack will handle things. :p But you will still be able to include things.

[bitbender]

KingK - I am an such an ID10T sometimes - *jeesh*

You SAID delete the old welcome panel plugins.. It just DAWNED on me where they were! They were up under the Vbulletin Plugin section(in my world any way), thas why I didn't see them b4.

Once I 'whacked" them, all is good.

Cheers - I will await the new release

[King Kovifor]

KingK - I am an such an ID10T sometimes - *jeesh*

You SAID delete the old welcome panel plugins.. It just DAWNED on me where they were! They were up under the Vbulletin Plugin section(in my world any way), thas why I didn't see them b4.

Once I 'whacked" them, all is good.

Cheers - I will await the new release

That's cool. But the next release is a good time away. I have a few projects that come before this one.

[Aligator21]

I'm not sure if i understand well.
What will i have to do?

Do i have to install both Welcome Panel Template & Welcome Panel Template Rewrite? or i must install only your hack?

[edit]
I have uninstall Zero Tolerance's plugin and install only your product.
See the screenshot to see how it displayed :(

[King Kovifor]

It appears that your hack isn't correctly reading / installing the phrases. Can you try uninstalling and reinstalling?

[Aligator21]

I've allready done that more than one times, with the same results :(
Can you please tell me witch phrases are so i will delete them?

[King Kovifor]

Any phrases I install are listed as wp_ I believe.

[Aligator21]

If i delete all these phrases and re-install the product, will i have any problem?

[Aligator21]

OK i've delete all the phrases and re-installed the hack. It works just fine now, except one problem.

It shows me the "0,00 posts per day."

Any ideas to solve this error?

[King Kovifor]

I have never actually figured that problem out. Do you happen to have translated the panel?

[Darkstarproject]

I have it installed and working perfect on vb 3.7.1pl2

[Darkstarproject]

Only problem I see, is that when you are NOT logged in, it doesnt show anything on the front page to be able to login.

[King Kovifor]

Only problem I see, is that when you are NOT logged in, it doesnt show anything on the front page to be able to login.

This isn't meant to show to guests...

[Darkstarproject]

Gotcha... I thought that is how it is supposed to work. I got a 'work around' with it though, and it is working as it should.

Very Nice Hack BTW. Can't wait for the next version.

[virus9112002]

How can I Display It in usercp
Not in FORUMHOME

[King Kovifor]

How can I Display It in usercp
Not in FORUMHOME

The plugin only runs on the forum home, so it would require plugin edits.

[Rs06 Ant]

Anyone have any idea how i could get similar information onto a html page?

[King Kovifor]

Anyone have any idea how i could get similar information onto a html page?

Without manual updating it, no.

[mA|tRiX]

Is there any one who have translate it into german?

[King Kovifor]

If someone translates, I would be willing to post it up here (and give permission to post at http://www.vbulletin-germany.org).

[EagleNick]

Does this work with 3.7.2?

[vitrag24]

Hello king, plz update your mod for vb 3.7.x too. :)

[King Kovifor]

Does this work with 3.7.2?

Hello king, plz update your mod for vb 3.7.x too. :)

What doesn't work with it?

[hotwheels]

I just upgraded from your older version and i now get this error: Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM vb3post WHERE dateline >= 08:19 PM, 07-28-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 ':19 PM, 07-28-2008 AND visible = 1' at line 1
Error Number : 1064
Request Date : Tuesday, July 29th 2008 @ 12:27:16 PM
Error Date : Tuesday, July 29th 2008 @ 12:27:17 PM
Script : http://www.insanemustangs.com/forums/index.php
Referrer : http://www.insanemustangs.com/modules/Jig/index.php
IP Address : ............
Username : .........
Classname : vb_database
MySQL Version : 5.0.51a-community

[hotwheels]

I reuploaded the older Version: 2.1.1 and this one works fine.........I try the newer version and i get the above error...

[King Kovifor]

I reuploaded the older Version: 2.1.1 and this one works fine.........I try the newer version and i get the above error...

THere is a patch somewhere for v3.0.5, ZT (the original coder) didn't surround a variable with ' and it screwed up the Query... I guess I should go find that then. :P

[macc]

hello!

how to get this welcome panel under or above of navybar or on another place on forumhome ?

regards

macc

[King Kovifor]

hello!

how to get this welcome panel under or above of navybar or on another place on forumhome ?

regards

macc

It should be under the navbar by default and it is added on the fly using plugins. I have never moved it or attempted to move it.

[macc]

Thanks for reply ...will attach picture and you can see ... i will get this some more up!

is it possibly to get this on vba cmps page?
regards

macc

[King Kovifor]

As said, the code is done on the fly with a plugin that is only run on the forum home.

[Mrdby]

will their be an update for 3.7.3?

[King Kovifor]

It should work on 3.7.3 but an update is planned for everything.

[KevinL]

Call me stupid...but where exactly do I edit the templates? They're not in my template list :confused:

[KevinL]

Hate to bump this so soon...but does anyone have any idea?

[Netunt]

Do you offer a branding free version and if so, how much would it be.

[King Kovifor]

Call me stupid...but where exactly do I edit the templates? They're not in my template list :confused:

They should be located within the forumhome template group if I remember correctly.

Do you offer a branding free version and if so, how much would it be.

vBulletin options. There is one in there under this option group that allows you to turn the branding on / off.

[KevinL]

Thank you. I will give it another look :)

[King Kovifor]

Well over a year and a half later I'm announcing that I'll be rewriting this for vB 3.6+ including new features and improved usability.

[Blue91]

When I go to install this... I put images in my images folder... When I go to load the xml file, I get an error... "Invalid File Specified" Any ideas? Running 3.8.0.

Thanks.

[King Kovifor]

When I go to install this... I put images in my images folder... When I go to load the xml file, I get an error... "Invalid File Specified" Any ideas? Running 3.8.0.

Thanks.

Um, not at all. Try uploading it to the server (under, includes/xml) and using the server file method. That might work for you.

[Blue91]

Still no luck. I uploaded it to that folder and tried to install from this path "./includes/xml/product-welcomepanel-v305.xml"

Still get the error... I'll try deleting/reinstalling the entire thing, from the zip download forward.

[Blue91]

Do I have to upload the .DS_Store files? If so, where? To the same directory as the img files and the xml file respectively?

I feel like an idiot b/c this won't work. I just tried it a second time with the same results.

I uploaded the img files (and .DS_Store file just in case) to the images folder. I then tried to run the xml file from my computer. No go. I uploaded it to includes/xml folder (again, with the .DS_Store file just in case) and it did the same thing.

Oh well. This sucks b/c all of my users want the welcome panel back (had smasher master's hack on my previous 3.03 board version).

[Blue91]

Got it. I was trying to install the xml into the wrong area. I'm new to the "xml" game since I just came from 3.03.

Now to see how to go about moving it above the nav bar. Thanks.

[Medina]

Hello K_K

I would like to ask you if its possible to integrate this mod. https://vborg.vbsupport.ru/showthread.php?t=88474 into the welcomepanel.

So when receiving a pm, or a vistor message it should blink.

I hope that you can take a look at it.

Thank you very much.

[King Kovifor]

Since they have template edits, just apply them to this template and it should work fine.

[Medina]

Thank you for your reply.

Uhm, im a bit of a noob. Can you please give me instructions. :o

[Medina]

May i ask someone for support please. (if possible)

[King Kovifor]

May i ask someone for support please. (if possible)

You need to edit the template set for your style:

forumhome_welcomepanel_

Then you need to follow the instructions for that mod.

[perfphysio]

Hi guys

I have updated my navbar successfully to add the ending to the search.php query as shown below so that threads from those categories don't appear in my list. i.e. adding &exclude=212,220 at the end where 212 and 220 are the forum ID's I don't want included in the results

I have done the same in your forumhome_welcomepanel (see below) but it does not seem to work in there. Any ideas?

<!-- Start Image Links -->
<if condition="$vbulletin->options['images'] == 'imgs'">
<a href="search.php?{$session[sessionurl]}do=getnew&exclude=212,220"> <img src="$vboptions[wp_forumimagelink]newposts.png" alt="New Posts"></a> <a href="search.php?{$session[sessionurl]}do=getdaily&exclude=212,220"><img src="$vboptions[wp_forumimagelink]24hours.png" alt="Get Daily Posts"></a>

[Medtech]

Working on Vbulletin 3.8.1 patch level1

[rob4448585]

Working on Vbulletin 3.8.1 patch level1

this works just fine for me in 3.8.1 but cool!

[ahamkaara]

It seems like I can edit the vBPhrases for "You are most active in" "with" and "posts" but I can't find where to edit which forum and how many posts. Basically what I'm trying to center them and have them all on the same line because right now it looks like this.

You are most active in
This forum
with
6
posts

[LieuR]

Can someone explain to me how i can change the colour off the names that are topposters on this mod ?

[King Kovifor]

It seems like I can edit the vBPhrases for "You are most active in" "with" and "posts" but I can't find where to edit which forum and how many posts. Basically what I'm trying to center them and have them all on the same line because right now it looks like this.

You are most active in
This forum
with
6
posts

how wide is your box?

[ahamkaara]

It's standard size. I haven't edited anything size-wise on my board.

[Feanor_87]

Works great on vB 3.8.3

Thanks!! :)

[nectons]

It seams to work perfect at vb3.8.3

THANKS!

[Invisigoth]

It works fine with vBulletin v3.8.4. thanks a lot

[compact123]

Hi there :)

I'm sure that along with many other fans of this modification, I was wondering if you would be updating this plugin for the new version 4 of vBulletin? It would be great to have such a nice mod continue. thanks sir :O

[King Kovifor]

Hi there :)

I'm sure that along with many other fans of this modification, I was wondering if you would be updating this plugin for the new version 4 of vBulletin? It would be great to have such a nice mod continue. thanks sir :O

This should be an easy upgrade. :)

[Christie]

Really hope this will be made available for vb4

[cykelmyggen]

I was having trouble with this on on 3.8.5. therefore uninstalled.
Edit: Reinstalled and now running smoothly on 3.8.5.

[bitbender]

KingK - I hope you do not mind, but I am going to try and take this mod on as my first attempt at making a plugin for VB 4 - It's been some years since I did this, but my community is threatening a "Walk Like an Egyptian" revolt if I deliver 4.1.2 w/o it... :)

I will post back my progress and frustrations... If you would rather I didn't do this, please say so.

[DarkGizmo]

i goet an error on line 126 in functions.php in my header running on 3.8.7 PL2.

Any ideas why? Here is what is at 126:
case 'userpic_profilepic':


No idea why