Miscellaneous Hacks - microMEMBERS (A much better Memberlist)

*** Link Removed ***

[MaryTheG(r)eek]

Originally Posted by SSJB_7

Mine memberlist dissappeared!
http://www.rapidstyle.org/memberlist.php

Have you upgraded vBulletin? If yes, then re-upload memberlist.php from my zip file.

Maria

[Tripolis]

When i turn on Admin Blocks:

Datenbankfehler in vBulletin 4.0.1:

Invalid SQL:

     SELECT user.userid, user.username, user.usertitle
     FROM user
  	 JOIN usergroup AS ugroup
			ON ugroup.usergroupid=user.usergroupid
		 LEFT JOIN usergroup
			ON (FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
 		 WHERE ugroup.usergroupid=6,2,7,5 OR usergroup.usergroupid=6,2,7,5
		 GROUP BY user.userid
     ORDER BY RAND()
     LIMIT 4;

MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2,7,5 OR usergroup.usergroupid=6,2,7,5
		 GROUP BY user.userid
     ORDER BY RAN' at line 7
Fehler-Nr.    : 1064
Fehler-Zeit   : Monday, 18.01.2010 @ 17:29:03
Datum         : Monday, 18.01.2010 @ 17:29:03

Admins Usergoup = 6
Usergoup = all other and 6

When i turn off admin block and usergroup all is ok.
Only ADmin blocks or Usergroups = error

EDIT: I can only change one Group, not more.
Then it goes when i add one group, bu i will change more

EDIT2: Top Posters (Overall) is the Wrong User

[MaryTheG(r)eek]

Originally Posted by Tripolis

When i turn on Admin Blocks:

Datenbankfehler in vBulletin 4.0.1:
 
Invalid SQL:
 
     SELECT user.userid, user.username, user.usertitle
     FROM user
       JOIN usergroup AS ugroup
            ON ugroup.usergroupid=user.usergroupid
         LEFT JOIN usergroup
            ON (FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
          WHERE ugroup.usergroupid=6,2,7,5 OR usergroup.usergroupid=6,2,7,5
         GROUP BY user.userid
     ORDER BY RAND()
     LIMIT 4;
 
MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2,7,5 OR usergroup.usergroupid=6,2,7,5
         GROUP BY user.userid
     ORDER BY RAN' at line 7
Fehler-Nr.    : 1064
Fehler-Zeit   : Monday, 18.01.2010 @ 17:29:03
Datum         : Monday, 18.01.2010 @ 17:29:03

Admins Usergoup = 6
Usergoup = all other and 6

When i turn off admin block and usergroup all is ok.
Only ADmin blocks or Usergroups = error

EDIT: I can only change one Group, not more.
Then it goes when i add one group, bu i will change more

EDIT2: Top Posters (Overall) is the Wrong User

Admingroup = Just ONE number there. No more. If you want to show a second similar block then activate "Special Group" and just below enter the usergroupid, but again just ONE number.

Why Top Posters are wrong?

Maria

[Tripolis]

Ok only one. This is ok.

The Top Poster Overall

I have some User´s that have many more Posts and threads like.

Total Posts
107 out of 1374 (8%)

And for example, i Have 278 and another user 232

So, i think i must stand on first Position.

For Info, it´s a testboard for testing hacks.Not Public

EDIT: For one time i uninstall the hack. And now i have no memberlist.......................................

[SSJB_7]

thank you very much , worked just perfect

[nci]

Originally Posted by Magz

Hi Maria

All is working fine, but, Clicking on the registered users link, does not give a list of registered users. It just shows the default page with admins, top posters ect. So as a members list, how can it be used as intended to actually show the members list?

Thanks

Please someone help,I am having the same problem,I even re upload all the files again.Everthing works except that clicking the registered or any other groups link will still show the same page.

[3DUInc]

Outstanding Maria, Thank you very much for your hard work.

Installed and nominated!

[angeljs]

Working great

[Trek]

Just installed this and have one issue and some suggestions.

First, really nice work, I like this mod a lot!

Second, the issue: The color #6B91AB is hardcoded within the template instead of using a stylevar. On my site, it made the borders look really bad. I edited it for myself, but figured you might want to change this so it looks good for others as well. =)

Third, suggestions:

I'd like to be able to order the usergroups that are displayed in whatever order I want. The reason for this is that I have sub-groups that I want listed and I'd like them to show under their "parent" group.

The usergroups section is also centered and I have about 12 usergroups I want to display. It makes it very hard to locate usergroups. This combined with the being able to sort things as I said, would make it a lot more readable.

All in all, nice job and thank you for the mod. I hope you can include some of my suggestions as well. =)

EDIT:

Actually, the entire table isn't using the stylevars so the border, color and style of the border are all being set. Setting to an existing stylevar like blockhead or something might be good. =)

[Magz]

Originally Posted by Magz

Clicking on the registered users link, does not give a list of registered users. It just shows the default page with admins, top posters ect.

Still cant get this working properly, have double checked, but cannot see anything like what appears in the screen shots, and more importantly, cannot even see any registered users when clicking on the group name