vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Most Ignored Users (https://vborg.vbsupport.ru/showthread.php?t=44161)

elitetrader 10-01-2002 03:33 PM

Most Ignored Users
 
I think it would be useful to have a script, (either public or just in the admin section) that would give a list of the most ignored users and the users who are on the most number of buddy lists. That would be useful, as it would give an indication of who is the biggest pain in the butt (for possibly banning), and who is liked most by the other members.

Logician 10-01-2002 03:58 PM

good idea but not easy to implement..

Buddy's and ignored users are not saved seperately inside db so there is not a magic SQL command to list/count them all.

A special script should be written and it would go through the entire database (user table) and count the all userid in buddy and ignore lists, then sort them. As this would be server intensive it wouldnt be possible to make it publicly open to all users. Your best bet would be put it inside Admin CP and run it when necessary..

My 2 cents..

elitetrader 10-01-2002 04:05 PM

Quote:

Originally posted by Logician
good idea but not easy to implement..
Buddy's and ignored users are not saved seperately inside db so there is not a magic SQL command to list/count them all.

Exactly. That's the problem I ran into. I could have ran a quick SQL query to get the info I needed if the ignore and buddy lists were in their own tables.

Xenon 10-01-2002 04:05 PM

the other possibility is, you can create two extra fields and store the ammount of users in them which have put this user on a buddylist/ignorelist

you have to change the member2.php to increase the number if someone is added:
disadvantage: this just works for new users which are put on the buddylist, so you have to revert alle lists to NULL and then add the lines into member2.php

but afterwards you can show the ammount to every user with no extra serverload

Another 2 cents, now you have 4 ;)


All times are GMT. The time now is 09:27 PM.

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.00988 seconds
  • Memory Usage 1,713KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete