How to change the displayed name of last poster?

[ungureanuliviu]

Hi all,

For every user, I added a new field in database: preferred_name. I want as this name to be displayed in FORUMHOME template on forumlastpost details div.

Now, the forumlastpost details div display something like:

"Name of last thread",
by "Username",
"11-04-2011, 03:19 PM"

In place of "Username" I want to display the "preferred_name" value.
For this I did the following:
1. Locate the the template which contains this div: forumhome_forumbit_level2_post
2. The variable which contains these details is {vb:raw forum.lastpostinfo} in template
3. The php file which create this variable is forum.php and the variable is $forumbits
4. $forumbits = construct_forum_bit($forumid);
5. construct_forum_bit($forumid) is located in /includes/functions_forumlists.php
6. Here I found how the last post details are set: $lastpostforum = (empty($lastpostarray[$forumid]) ? array() : $vbulletin->forumcache["$lastpostarray[$forumid]"]);

The main problem is that I don't know where the $vbulletin->forumcache is created. I want to change the query such as the lastpostforum to contains the "preferred_name".

Do you know how to change that query? Where I can find the code which select all details about a forum?

Thank you,
Liviu

p.s : I'm sorry for my english, it is not my native language :)