vb.org Archive - Miscellaneous Hacks

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - Memberlist (https://vborg.vbsupport.ru/showthread.php?t=319321)

It installed without any issues however I am running into some issues:

I don't see the TABS as shown above in the details.
The user avatars are huge for some users. Way more as the 100 pixels. even setting them to 50 or so won't change anything.

I must say I am running vB 4.2.0
Any suggestions what could be wrong?
Thanks

Quote:

Originally Posted by qpurser (Post 2551603)

Please give me the installation URL or check your page's output code to see if there are multiple instances of jquery there. Most probably this causes also the avatar problem as it messes the screen.

I'm using vbulletin 4.2.3. I got it to work. Thank you for the Mod :)
I thought it didn't work at the start, but then I realised you must enable it from usergroups (this isn't in the screenshots in the original post).

These are my settings:
https://vborg.vbsupport.ru/external/2015/08/54.png
^ I honestly don't have a clue what that setting does. Mind telling me Nick?
https://vborg.vbsupport.ru/external/2015/08/55.png

AdminCP -> Usergroups -> Usergroup Manger -> [Select Group]
Right at the bottom:
https://vborg.vbsupport.ru/external/2015/08/56.png

Once installed, 'Members' Navtab didn't appear. It only appeared after I changed the setting to yes from usergroup (^administrator) & pressed saved on 'Members' from the Navigation Manger:
https://vborg.vbsupport.ru/external/2015/08/57.png
https://vborg.vbsupport.ru/external/2015/08/58.png
^ That's the default settings. If you don't see some of the fields, then you still need to change your usergroup permissions to yes.

If you can't make it work, I suggest doing exactly as I've done (same settings) in this post.

@Nick
P.S= I suggest having a installation guide either as a installation text file OR written down in the original post.
Also include a screenshot of the this in the original post.

I made an unsuccessful installation and did not install the mod but the tables were, how can I remove them?

Quote:

Database error in vBulletin 4.2.3:

Invalid SQL:
ALTER TABLE usergroup ADD memberindex INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'memberindex'
Error Number : 1060
Request Date : Tuesday, August 4th 2015 @ 07:57:21 PM
Error Date : Tuesday, August 4th 2015 @ 07:57:21 PM
Script : http://www.../admincp/plugin.php?do=productimport
Referrer : http://www..../admincp/plugin.php?do=productadd
IP Address : ...
Username : ...
Classname : vB_Database_MySQLi
MySQL Version : 5.5.42-cll-lve

Quote:

Originally Posted by louva-a-Deus (Post 2552101)

I made an unsuccessful installation and did not install the mod but the tables were, how can I remove them?

If you're familiar using phpMyAdmin you must connect to your database and remove from table usergroup the field memberindex. Normally must be the last.

Another way is to modify the product-memberindex.xml and remove:

Code:

        <codes>

                <code version="1.0.0">

                        <installcode><![CDATA[

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD memberindex INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD ismemberindex INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");

                           $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_facebook VARCHAR( 255 ) DEFAULT '' NOT NULL");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_twitter VARCHAR( 255 ) DEFAULT '' NOT NULL");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_google VARCHAR( 255 ) DEFAULT '' NOT NULL");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user ADD mi_linkedin VARCHAR( 255 ) DEFAULT '' NOT NULL");

                        ]]></installcode>

                        <uninstallcode><![CDATA[

            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP memberindex");

            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP ismemberindex");

            $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_facebook");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_twitter");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_google");

                        $vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."user DROP mi_linkedin");

            ]]></uninstallcode>

                </code>

        </codes>

Then save file and import it.

Most probably is not only that field but all. Don't know why the fields didn't removed during uninstall.

Hi NickTheGreek,

I sent him a private message

Awesome Mod. Installed it on 4.2.2 without issue. Thanks for your hard work.

Quote:

Originally Posted by NickTheGreek (Post 2551629)

Please give me the installation URL or check your page's output code to see if there are multiple instances of jquery there. Most probably this causes also the avatar problem as it messes the screen.

Just PM'd you the link.
Thanks for looking into it

Just can't get this working! I do not see the Member Index option in an Usergroup so can not grant permission to see the member list

another great addon, thank you very much :up:

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01290 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 (1)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
Messages: