Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules
Author Message
salongaopm
Hangin' Around


Joined: Apr 30, 2007
Posts: 41

PostPosted: Wed Aug 29, 2007 12:44 am Reply with quote

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
 
View user's profile Send private message
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Wed Aug 29, 2007 6:38 am Reply with quote

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.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
salongaopm
PostPosted: Wed Aug 29, 2007 1:39 pm Reply with quote

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!
.
 
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Wed Aug 29, 2007 4:39 pm Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
salongaopm
PostPosted: Wed Aug 29, 2007 6:47 pm Reply with quote

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">&nbsp;{memberrow.REALNAME}&nbsp;</td>

Below is what is showing on the Memberlist Table.

Image


Any help will be appreciated.
Thanks again!
 
salongaopm
PostPosted: Mon Sep 03, 2007 11:18 pm Reply with quote

Anyone please?
 
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Tue Sep 04, 2007 5:57 am Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©