How can I modify the MemberList table to show Realname

Hangin' Around Joined: Apr 30, 2007 Posts: 41

Hi!

How can I modify the Memberlist table to show Realname and other members info? Realname on the memberlist table is very important for my site than the username.

My site is using rn 2.10 and cnbya 422. I have phpbb and gallery2 integrated also.

Any help will be greatly appreciated.

Thanks!

I am using

registered · Posted: Wed Aug 29, 2007 6:38 am

I have a couple of other Only registered users can see links on this board! Get registered or login! that might point you in the right direction. See if those help you out and if you run into troubles, post back.

Posted: Wed Aug 29, 2007 1:39 pm

Thank you for the reply.

I tried to follow the instructions..but somehow i cannot make it work. I received the error message below:

Could not query users

DEBUG MODE

SQL Error : 1054 Unknown column 'user_name' in 'field list'

SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_name FROM nuke_users WHERE user_id <> 1 ORDER BY user_id ASC LIMIT 0, 50

Line : 160
File : index.php

Below are what I tried:

Files Modified:
- modules/Member_List/index.php
- themes/fisubsilversh/forums/memberlist_body.tpl

replaced lastvisit with realname. i also tried name...but it didn't work either. Any help will be greatly appreciated.

Thanks!
.

registered · Posted: Wed Aug 29, 2007 4:39 pm

I don't think user_name is in standard Nuke. Try removing it altogether.

Posted: Wed Aug 29, 2007 6:47 pm

Hi! I did removed the user_name and used realname instead. another column with dates on the memberlist table appered. No realnames though. Below are the changes that i did:

Changes to: modules/Member_List/index.php

####Find####
$cellcount = "8";

####Replace With####
cannot find this

####Find####
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar

####Replace With####
no change

####Find####
$username = $row['username'];

####After Add####
$realname = $row['user_realname'];
$realname = date("D M j G:i Y", $realname);

####Find####
'USERNAME' => $username,

####After Add####
'REALNAME' => $realname,

Changes to: themes/SubBlack3dBlue/forums/memberlist_body.tpl

####Find####
<th>{L_WEBSITE}</th>

####After Add####
<th class="thCornerR" nowrap="nowrap">{L_REALNAME}</th>

####Find####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.WWW_IMG} </td>

####After Add####
<td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.REALNAME} </td>

Below is what is showing on the Memberlist Table.

Any help will be appreciated.
Thanks again!

Posted: Mon Sep 03, 2007 11:18 pm

Anyone please?

Posted: Tue Sep 04, 2007 5:57 am

find:

$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY $order_by";

Replace with:
$sql = "SELECT name, username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY $order_by";

Find:
$realname = $row['user_realname'];

Replace with
$realname = $row['name'];

Keep all other edits.

Find:
<th class="thCornerR" nowrap="nowrap">{L_REALNAME}</th>

Change to:
<th class="thCornerR" nowrap="nowrap">REAL NAME</th>

This should give you the desired results.