Member Number

[[Unknown]]

Is there a way to change the member number for people?

Not without causing a large number of unpreventable problems.

Also, is there a way to make the default view on the members page to show them in order of registration?

This is already the default order, by virtue of the inherent and very often used properties of auto incrementing fields.

-[Unknown]

[cheesenub]

Is there a way to change the member number for people?

Not without causing a large number of unpreventable problems.

Also, is there a way to make the default view on the members page to show them in order of registration?

This is already the default order, by virtue of the inherent and very often used properties of auto incrementing fields.

-[Unknown]

Hmm, my view defaults by username, not by registration date.

[[Unknown]]

Hmm, my view defaults by username, not by registration date.

Darn, I guess that's right.  I was thinking of something else, but I swear there was a member list that did...

Well, you can change that in Memberlist.php... find:

Code Select Expand

$_REQUEST['sort'] = 'realName';

Replace:

Code Select Expand

$_REQUEST['sort'] = 'ID_MEMBER';

-[Unknown]

[BigMike]

Hey listen,

I dont know why this is being overlooked. You guys dont understand why people think their member number is important, BUT WE DO. Both of the major competing boards in our business have member numbers listed below each member in their posts. I think this is GREAT and I wish my SMF could do it. It's very simple to see who the newbies are and to compare their post counts with their member number, very easy to monitor his/her activity. My forum is rather small, we only have around 2,500 members, but when it gets bigger, like 10,000 members, its gonna be so sweet to be like member #134. "Wow! You've been here since the beginning!!"
This really is a nice feature and it helps people give respect. Easy to see the elders of the board.

Now, with all of that said, I understand where you guys are coming from about the member id field and how it is not designed nor intended to be a chronological member number.

So my request is for someone who is willing to make a script that can populate a list of dates registered and sort them in order of date. And there should be an option in the Maintenance section of the admin to re-populate this list in case their is some order and it would go through the members again and recheck that they are in the correct order.

I am not suggesting to use the Member Id field as the chronological member order number, but instead create an entirely new array/variable/whatever, like $message['member']['registration_order'], that is the actual member id #.

Is this so hard to make ? I'm sorry that I am not a programmer, but you guys have built one hell of a forum system so I'm sure you are more than capable of doing this, it just seems like you guys think there is no support for it and no one wants it..........whatever.

Please let me know what you think about this. [Unknown]?

[Alexandre P.]

So, from what I understand, there is no 'member number'.  This doesn't exist.
But there is something in the database which is the Member ID, an unique identifier automatically attributed when a user registers itself.  And those IDs are not meant to be modified, in any way.

I believe it is not that hard to understand.

Personaly, I don't see too the real trip to be "Member #1", "Member #2", "Member #137" in a forum with 10000 members.  You say it helps to give people respect ; I say you're wrong.  Respect is based on what a user says in his posts, not on his seniority.  It is based on how a person acts, not on his smallest number.

You say showing the "member number" would help to distinguish who's a newbie and who has been here since the begining: if it is really important to you to see which one is the oldest member, why don't you just show the registration date ?!

Just a thought...

[diplomat.]

well i have member nmbers for my members shown on display.template and the profile.template and i basically put it there not to distinguish n00bs from oldys, but because it was possible and it looks cool

[BigMike]

Thanks for your opinion, but I really wish I could see how members were added and in what order directly from the threads.

I agree that people show their character (on BBS) by what they say. I wasnt referring to the comparison of, for instance, member #3,456 with #3,457, but rather I want to see member #20 out of 20,000 still posting on my forum daily. It shows that he's been here for a long time and he must really love the place. Guests can see that and think, why these people have been here for over 2 years, this must be a great place.........................somewhere along these lines.

I could show the registration date, like "Registered: Nov, 2004" and that would work also, but you just cant grasp where in the history time-line of the forum that occurred in comparison to other members, which is the whole idea of a member id #.

Also it's more interesting to refer a friend to my forum by saying "Hey you should check out this forum! I'm the 456th member!"
That sounds better than "Hey you should check out this forum! I registered on this date"

My members agree that by having a member number, they feel like they are more a part of the forum. "I'm number 1,345."

Actually in my business, every singe dual case adapter and gear set that we've sold in the 9 years of business has gotten its own unique id number. For instance, the MC08 adapter on my pickup is #122T, the MC08R10 is #001T, and my 4.70:1 gear set is #1444T. So our members/customers are already involved with identifying numbers from our company so they like the idea of having a member number on our company forum.

BigMike

[Anguz]

It's really easy to show the member's ID next to messages. It's available in Display.template.php's template_main(), under $message['member']['id'].

You could do something like

Code Select Expand


<edit file>
$themedir/Display.template.php
</edit file>

<search for>
// Show how many posts they have made.
echo '
', $txt[26], ': ', $message['member']['posts'], '<br />
<br />';
</search for>

<add before>
// Show the member's ID.
echo '
', $txt['who_member'], ' #', $message['member']['id'], '<br />';

</add before>


[BigMike]

[Anguz]

I'm afraid I don't understand what that means...

Edit: I just read the whole topic again and understood. Sorry, it's such an old topic that I forgot about those replies.

[Ben_S]

This really is a nice feature and it helps people give respect. Easy to see the elders of the board.

You think? Personally I judge people on the quality of their posts, not how long they have been a member.

[Anguz]

This really is a nice feature and it helps people give respect. Easy to see the elders of the board.

You think? Personally I judge people on the quality of their posts, not how long they have been a member.

Agreed.

[Anguz]

So my request is for someone who is willing to make a script that can populate a list of dates registered and sort them in order of date. And there should be an option in the Maintenance section of the admin to re-populate this list in case their is some order and it would go through the members again and recheck that they are in the correct order.

Let's see if this helps you... (remember to backup first, this is provided
"as is" without warranty of any kind)

Add the new column for member number to your members table

Code Select Expand


ALTER TABLE `smf_members` ADD `MemberNumber` MEDIUMINT( 8 ) UNSIGNED NOT NULL ;


Put the attached script in your forum's dir and load it in your web browser to update the new column's values. Remove the file after you're done.

Do the following modification

Code Select Expand


<edit file>
$sourcedir/Load.php
</edit file>

<search for>
);

$select_columns = "
IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, mem.signature,
</search for>

<add after>
mem.memberNumber,
</add after>

<search for>
'id' => &$profile['ID_MEMBER'],
</search for>

<add after>
'number' => &$profile['memberNumber'],
</add after>


Now do what I wrote in my other reply, but instead of 'id', use 'number'.

I'm not giving any interface to handle this, nor am making it auto-update. If you need to fix the member number for the new ones, just repeat the part with the script.

If somebody wants to improve this, be my guest.

[Grudge]

If I get *really really* bored in the next few weeks I *may* attempt to write a little sorting script. However, it really is a hell of a script to write as ID_MEMBER is god damn everywhere, so means altering a tonne of tables and then altering them back - can I be bothered is the question (And will I find time!)

[BigMike]

Especially to Anguz, and for Grudge, thankyou guys for checking this out for me (us). I'm sure I'll have some free time during turkey weekend to take a stab at Anguz's code and I'll let you know how it goes 
Grudge, if it takes ya a long time, then you dont need to do it on my behalf. Maybe if there is more interest then you would feel better coding it? Yes I really want it done, but damnit I wish I could code half of what you guys have forgotten! Then I could help do some work! All I learned was html, c++, and javascript.. MySQL is another world to me. I've only learned what I know from reading your guys' forum software

Anguz- I was just sifting through your coding. Correct me if Im wrong, but this is just to copy the member id over to a new variable, right?

Hopefully my backup feature will start working. I used to make weekly backups, but now the page takes like 10 mins and then it says something like "the referring url is not responding or is unavailable." I think its something with my host because it does the same thing when I try to make a manual backup through the phpMyAdmin as well..

You think? Personally I judge people on the quality of their posts, not how long they have been a member.

Please read reply #26 on Page 2.

[BigMike]

Oh yeah, Grudge I almost forgot..

If you are going to code this, then if its possible, then try to sort based on $context['member']['registered']. Don't base it off of ['member']['id'] since that's the whole reason its not working (my ['id'] numbers are no longer in order and Unknown says we shouldnt alter that variable).

But the $context['member']['registered'] value of course is in order on everyone's board unless they went into their sql admin and manually changed it. And the registered date is the perfect way to organize the member # by

[Oldiesmann]

The reason [Unknown] told you not to change the member ID number is because you would have to update a bunch of other tables as well (PMs, messages, boards, topics, polls) and unless you do it just right, you could end up messing things up. I did this on my site when I switched from a custom site with YaBB SE to LSP Enigma (also uses YaBB SE), and it was a pain even with YaBB SE. I didn't update PMs or anything, and there really weren't many polls, but still it was a pain in the rear to do it.

[Anguz]

Anguz- I was just sifting through your coding. Correct me if Im wrong, but this is just to copy the member id over to a new variable, right?

No. I get all the members from the db sorted by date registered and then number them in that order and save it in the new table column. I don't modify the IDs at all, which makes it simpler.

[admactanium]

Add the new column for member number to your members table

Code Select Expand


ALTER TABLE `smf_members` ADD `MemberNumber` MEDIUMINT( 8 ) UNSIGNED NOT NULL ;


which file is this in again anguz?

[BigMike]

I think its the direct phpMyAdmin script that needs to be ran from within your MySQL.