vb.org Archive - Welcome Panel [Final]

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Welcome Panel [Final] (https://vborg.vbsupport.ru/showthread.php?t=33477)

Hey, I installed this hack a while ago and it worked perfectly.I recently upgraded to 2.2.4, had a few problems but got it working in the end.Now I have another problem with it, it used to say something like 'There have been XX of new posts since your last visit' but now that part does not show up.I have checked the index.php file and the templates and they are all fine, can anybody help?

:disappointed:

Never mind, fixed it.

Think I am going mental, need more sleep. :confused:

@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

PHP Code:


		
			
ALTER TABLE `thread` ADD INDEX(`lastpost`); 

ALTER TABLE `post` ADD INDEX(`dateline`);

[QUOTE]Originally posted by Airwaves
@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

PHP Code:

ALTER TABLE `thread` ADD INDEX(`lastpost`); ALTER TABLE `post` ADD INDEX(`dateline`);

Which kind of index table size increment should generate adding those two or three index upon dates ?
And how a search on could be measured faster ?

Thnx

My "post" table size before creating the index:

Data 30,022 KB
Index 3,482 KB +
=============
Total 33,504 KB

After creating the index on dateline:

Data 30,022 KB
Index 4,276 KB +
=============
Total 34,298 KB

In my case the table has grown about 2.3698663% :)

Thank you very much for these numbers. What about speed increase performances ? Are they appreciable ?
(for example on lastpost searches or today's posts)
:)

If you took time to take a look @ a post of me... a little higer...

Ow well lets cut & paste...

before:

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.3487149477005
Time after: 1.9500440120697

as you can see, the query needs about 1.6 seconds to complete.
(about 100.000 posts in the forum)

after:

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.41155600547791
Time after: 0.41288495063782

Wel.. I really like the result... Just 0.001328 seconds for the query to complete.

I think this result is really worth the 2.3698663% growing :classic:

Very cool!
I added index on dateline fields in post, thread and user (join & lastvisit) ...
Now, with a small space occupied more, I have the fastest forumhome ever... :) :) :)

What is the URL to your forum? I want to have a looksy!

i have the avatar as link 2 hack installed, then it never shows your personal avatar in the welcome screen, only the "no avatar" image. (yet i do have a offsite avatar)

Anyone know how to fix this?

Ok, i fixed it myself (dont know if already it was fixed by someone).

To let this hack work properly with Avatar as Link 2 Hack (show real avatar on welcome box):

Before:

PHP Code:


		
			
  if ($avatarurl=='') {

of the added script

add:

PHP Code:


		
			
$avatarlink=$DB_site->query_first("SELECT avatar2 FROM avatarlink WHERE userid=$bbuserinfo[userid]");

$avatarurl=$avatarlink[avatar2];

Hope this helps some of u.

I just got a problem, how do i add a link to the left bar of the thing, where it says "Log out" or "Mark forums read" etc. i would like to add another link there, where could i find that code, under which part of the template?

u mean right side :rambo:

anyway, check your modifyavatar_link template

that is the whole table with the vars.. edit it..

could you please direct me to as where i would find that?

Just installed this hack.

Toot sweet Trilobyte and all the rest.

My forum is only a month old so it's a little rough.

But you can check it out here, running vbPortal and vB 2.2.5:

http://digitalfumes.com/tus/

Man I need help correcting this...I am trying to running the 'Yet another RPG Stats' and the RPG Limit Breaks on my Welcome Panel but it does show and my user post count doesn't show either. www.fg-forums.com

Code:

<table border="0"cellpadding="{tableouterborderwidth }" cellspacing="0" border="0" bgcolor="{tablebordercolor }" 



{tableouterextra } width="{contenttablewidth }" align="center" width="100%"> 

<tr> 

<td width="100%" bgcolor="#606096" colspan="3"><font face="Verdana"> 

<b>Welcome to Fusion Gods Forums</b></font></td> 

</tr> 

<tr> 

<td width="33%" bgcolor="{secondaltcolor }" border="1" style="border: 1px solid #000000"><font face="Tahoma" 



size="2"><b>User 



Information</b></font><br> 

<smallfont>Your general User Information can be found 

here.</smallfont></td> 

<td width="33%" bgcolor="{secondaltcolor }" border="1" style="border: 1px solid #000000"><font size="2" 



face="Tahoma"><b>Forum 

Statistics<b></font><br> 

<span style="font-weight: 400"><smallfont>Current Standings for Our Forum's Records.</smallfont></td> 

<td width="34%" bgcolor="{secondaltcolor }" border="1" style="border: 1px solid #000000"><font size="2" 



face="Tahoma"><b>Your 



Statistics</b></font><br> 

<smallfont>Your Health and Wealth so far.</smallfont></td> 

</tr> 

<tr> 

<td width="33%" bgcolor="{firstaltcolor }" border="1" style="border: 1px solid #000000"> 

<div align="left"> 

<table border="0" bgcolor="{firstaltcolor }" cellpadding="0" cellspacing="0" width="260"> 

<tr> 

<td width="90"><smallfont>$avatarimage</td> 

<td><b>User:</b> $username<br> 

<b>Posts:</b> $bbuserinfo[posts]<br> 

<b>ID:</b> $userid<br> 

<b>Gils:</b> $bbuserinfo[field5]</smallfont></td> 

</tr> 

</table> 

</div> 

</td> 

<td width="33%" bgcolor="{firstaltcolor }" border="1" style="border: 1px solid #000000"> 

<div align="left"> 

<table border="0" cellpadding="0" cellspacing="0" width="260"> 

<tr> 

<td><smallfont><b>Members:</b> $numbermembers (Since April 13, 2002)<br> 

<b>Newest Member:</b> <a 



href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid">$newusername</a><br> 

<b>Threads:</b> $totalthreads<br> 

<b>Posts:</b> $totalposts</smallfont></td> 

</tr> 

</table> 

</div> 

</td> 

<td width="34%" bgcolor="{firstaltcolor }" border="1" style="border: 1px solid #000000"> 

<div align="left"> 

<table border="0" bgcolor="{firstaltcolor }" cellpadding="0" cellspacing="0" width="260"> 

<tr> 

<td><smallfont><b>Limit:</b> $bbuserinfo[limit]<br> 

<b>Level:</b> $bbuserinfo[showlevel]<br> 

<b>HP:</b> $bbuserinfo[hp] / $bbuserinfo[maxhp] <br> 

<b>MP:</b> $bbuserinfo[mp] / $bbuserinfo[maxmp] </smallfont></td> 

</tr> 

</table> 

</div> 

</td> 

</tr> 

</table>

[high]* s o r o k a confused...
[/high]
Please help me?

Nice hack Trilobyte - installed with no problems :)

Installed on 2.2.5, working like a dream! :D

Can someone pls clarify that this amazing hack is 2.2.6 compatible and works 100% with it?

It still says 2.2.2 on the hack title! :s

Thanks

I just installed 2.2.6, and it no longer shows the avatar in the welcome window. Any ideas?

Never mind - I'm just dumb. I forgot to make one of the changes to index.php. I fixed that, and now it works fine!

Mickey

I'm using it with 2.2.6 and it works just fine.

I'm a newbie and I just installed it on 2.2.6.

Very easy to install.

It works great and looks great :)

Thanks!

Working great on 2.2.6, thanks!

[QUOTE]Originally posted by Bimma Boy
Can someone pls clarify that this amazing hack is 2.2.6 compatible and works 100% with it?

It still says 2.2.2 on the hack title! :s

Thanks

Is there anyway to include this hack directly on a page prior to loading forums ? (i.e : including it on a index.html page, for example).
To be more clear... How can I put this hack on my main page like on this site (www.vbulletin.org) please ?

Thanks in advance.

Great Hack !!

No Problemo !!

Does not work on 226 for me

[QUOTE]Originally posted by mrdave
Does not work on 226 for me

It was the first hack installed, I am having the same thing happen in posts also with any custom avatar, just the missing image icon. This is on php 4.2.1 btw. It all works with avatar.php from 2.2.5

I'm utterly puzzled. You are saying that if you upoad avatar.php from 2.2.5 to your 2.2.6 install it works fine, but not otherwise?

Given that many people have it working fine with the default avatar.php from 2.2.6, then you may have a corrupt file. Extract the original avatar.php from your 2.2.6 zip file and re-upload it.

hi i wanted some help with this problem...

---

Ive installed the hack to split up the forum catagories and it has messed up the hack (welcome panel one) it hasnt any borders anymore... how can i fix this?

here is a screenshot...

http://www.lcdmod.co.uk/board.jpg

---

Could you please email me the solution and what i have to do to crocket2k@hotmail.com please im a php newbie and dont know much...

thank you

Anyway it works now.

great hack, thanks!! works fine on v2.2.6 !!

but has somebody the two pics in german ??? that would be great!!

regards,
Schorsch

Working fine on 2.2.6 apart from one small annoying problem.Although this might not be related to the hack.

On my board,in the welcome panel where it says "there have been # threads and # posts since your last visit" the threads count always goes up even if a new thread hasn't been created.

e.g If someone posts one reply in a thread,the welcome panel
says "there have been 1 thread and 1 post since your last visit."

Should it not say "there have been 0 threads and 1 post since your last visit."

And yes i do click "mark all forums read",before revisiting.

Any ideas.

hi,

in root/index.php find "lastpost" in the follow text:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]'");

Replace "lastpost" with "dateline".

Now it should work.......

thx @ Pogo (vB Germany Support)

Thanks ghost.That fixed it.

Has the welcome panel hack been edited since it was first released,to replace "lastpost" with "dateline".

Just wondering.

no prob. I wondering too, has nobody found this problem since releasing this hack? I found this problem 5 Minutes after Installation......

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01725 seconds Memory Usage 1,828KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: