Site Points on Members List

Posted: Sun Jan 29, 2006 6:05 am

You know in the YourAccount module where it says "Points you have by participating on the site's content: #", is there a way to get this points value on the members list?

Posted: Sun Jan 29, 2006 6:19 am

If you want to put it directly on the Members List it can be done - butI have seen several other 'points' lists before (including point blocks for the top 10, etc) out there that would keep you from having to tweak the member list code.

-sting

Posted: Sun Jan 29, 2006 6:29 am

ummm....im a noob so could you tell me how? (id prefer to tweak memberlist)

Posted: Sun Jan 29, 2006 1:40 pm

Ok - I have posted my current development on this on the Premium Side of my website - once I have it finished in a way that I am comfy with releasing, I will post here.

I can tell you that it is theme dependent - if you have a ton of themes, you are going to have to make a ton of edits.

If you just can't wait on this one, head over to my site at
http://www.nukehaven.net -registration is free, but access to the development forums and downloads cost 2 bucks.

-sting

Posted: Tue Jan 31, 2006 7:00 am

ohhh its theme dependant... that helps alot thank you ^^ I will try again now.

Posted: Tue Jan 31, 2006 7:42 am

Ok, so I never got around to going back to change the Points constant, but it may not matter for you -

Disclaimer - back up your files first Smile

From http://www.nukehaven.net:

The trouble with this is that it is THEME DEPENDENT. Theme templates for the memberlist have to be edited individually to allow for this to work.

To add points to the Member List:

in the Memberlist module's index.php

Find

Code:

$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";

Change to

Code:

$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, points
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY $order_by";

Find

Code:

$posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;

After and on a new line insert

Code:

$points = ($row['points']);

Find

Code:

'POSTS' => $posts,

After on a new line insert

Code:

'POINTS' => $points,

Find

Code:

$template->assign_vars(array(
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_EMAIL' => $lang['Email'],
'L_WEBSITE' => $lang['Website'],
'L_FROM' => $lang['Location'],
'L_ORDER' => $lang['Order'],
'L_PRIVATE_MESSAGE' => $lang['Private_Message'],
'L_SORT' => $lang['Sort'],
'L_SUBMIT' => $lang['Sort'],
'L_AIM' => $lang['AIM'],
'L_YIM' => $lang['YIM'],
'L_MSNM' => $lang['MSNM'],
'L_ICQ' => $lang['ICQ'],
'L_JOINED' => $lang['Joined'],
'L_POSTS' => $lang['Posts'],
'L_PM' => $lang['Private_Message'],

And Change to

Code:

$template->assign_vars(array(
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_EMAIL' => $lang['Email'],
'L_WEBSITE' => $lang['Website'],
'L_FROM' => $lang['Location'],
'L_ORDER' => $lang['Order'],
'L_PRIVATE_MESSAGE' => $lang['Private_Message'],
'L_SORT' => $lang['Sort'],
'L_SUBMIT' => $lang['Sort'],
'L_AIM' => $lang['AIM'],
'L_YIM' => $lang['YIM'],
'L_MSNM' => $lang['MSNM'],
'L_ICQ' => $lang['ICQ'],
'L_JOINED' => $lang['Joined'],
'L_POSTS' => $lang['Posts'],
'L_POINTS' =>"Points",
'L_PM' => $lang['Private_Message'],

Still working on finding the "Points" area where $lang['Points'] is supposed to go, but setting it to "Points" hardwires it for now. . .

In your theme template (memberlist.tpl or memberlistbody.tpl)

Find

Code:

<th class="thTop" nowrap="nowrap">{L_POSTS}</th>

After and on a new line type

Code:

<th class="thTop" nowrap="nowrap">{L_POINTS}</th>

Find

Code:

<td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.POSTS}</span></td>

AFter and on a new line insert

Code:

<td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.POINTS}</span></td>

Find

Code:

and change to

Code:

Note: colspan is the key here - if your theme has 7, make it 8 (just add 1 for the new column that was added)

It works, and its not too problematic to change the files.

-sting