vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - microMEMBERS (A much better Memberlist) (https://vborg.vbsupport.ru/showthread.php?t=231688)

MaryTheG(r)eek 01-18-2010 01:46 PM

Quote:

Originally Posted by SSJB_7 (Post 1959180)
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 01-18-2010 02:31 PM

When i turn on Admin Blocks:

Code:

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 01-18-2010 04:49 PM

Quote:

Originally Posted by Tripolis (Post 1959225)
When i turn on Admin Blocks:

Code:

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 01-18-2010 06:20 PM

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 01-18-2010 08:23 PM

thank you very much , worked just perfect

nci 01-19-2010 09:19 AM

Quote:

Originally Posted by Magz (Post 1949453)
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 01-21-2010 07:14 AM

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

Installed and nominated!

angeljs 01-21-2010 02:13 PM

Working great :)

Trek 01-23-2010 07:47 AM

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 01-23-2010 08:24 AM

Quote:

Originally Posted by Magz (Post 1949453)

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


All times are GMT. The time now is 05:00 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01385 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete