vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Profile Enhancements - Automatically Add Friend (https://vborg.vbsupport.ru/showthread.php?t=177269)

TigerC10 01-19-2009 10:30 PM

Quote:

Originally Posted by Nadavy (Post 1717159)
This mod was actually restricting users from being able to confirm their emails on my forums :(

Quote:

Originally Posted by King Kovifor (Post 1717311)
Odd. I wouldn't know why as I only do so on email verification (after it's been verified) and on the add member process.

Isn't that the widely known bug? It seems obvious to me that Nadavy didn't apply the fixes that I supplied to you, King Kovifor (since you still haven't put the patches in the XML file, I'm sure a lot of people are downloading that without reading through the posts for the fix).

King Kovifor 01-19-2009 11:16 PM

Quote:

Originally Posted by TigerC10 (Post 1718345)
Isn't that the widely known bug? It seems obvious to me that Nadavy didn't apply the fixes that I supplied to you, King Kovifor (since you still haven't put the patches in the XML file, I'm sure a lot of people are downloading that without reading through the posts for the fix).

The bug was email validation not adding friends correctly (or whatever), but it wasn't as he said. I've never had a report of that.

GCC LLC 01-20-2009 12:51 AM

Installed but its not sending a notification to the user when its not mutual...or mutual for that matter. any ideas?

sensimilla 01-20-2009 10:08 AM

Its not working for me on vb 3.8 , any ideas ? TIA

King Kovifor 01-20-2009 08:06 PM

I will try to check this out later.

TigerC10 01-22-2009 04:26 AM

Quote:

Originally Posted by King Kovifor (Post 1718374)
The bug was email validation not adding friends correctly (or whatever), but it wasn't as he said. I've never had a report of that.

Well consider this your second report of that, then. When I had e-mail activation enabled with your original version, I encountered a database error which would not allow someone to validate the e-mail link. Every time the link was clicked, database error. No move from the "awaiting activation" group. When I was coming up with the fix, I encountered this a lot of times. I would click the link again, and it would complain that the activation link wasn't valid. I would have to re-send the activation link and eventually when I finished the fix it worked fine.

Maybe something changed in the error handling code for vB between the version that you developed this on and 3.7.5, but when people were complaining about how this plugin didn't work and when some people complained that it broke their board - I thought you knew about it.


Quote:

Originally Posted by sensimilla (Post 1718831)
Its not working for me on vb 3.8 , any ideas ? TIA

It works for me on 3.8, apply the fixes mentioned on page 17 of this thread and it should work for you too.

MrBig 02-08-2009 01:35 AM

how do i delete friends if its a large amount , i have over 4,000+ since i installed it and i would like to delete them and start fresh , and ideas besides doing it manually?

King Kovifor 02-08-2009 02:10 AM

Not a clue. I don't think you can prune friends. Sadly, that's a disadvantage of this modification.

MrBig 02-09-2009 01:51 AM

Quote:

Originally Posted by King Kovifor (Post 1737469)
Not a clue. I don't think you can prune friends. Sadly, that's a disadvantage of this modification.

thanks for the quick reply , hopefully someone finds this that can help :(

TigerC10 02-09-2009 05:53 AM

MrBig, you can query the database yourself. If you've set your permissions properly (in the config.php file, look for $config['SpecialUsers']['canrunqueries'] and make sure your userID is allowed), then in the AdminCP at the bottom under the "Maintenance" section, go to "Execute Database Query".

It goes without saying that you should make a database back up before doing this, just in case something goes wrong. This code is untested, but should work. Be 100% sure that you get a database backup before trying this.

Reset your friend count
Code:

UPDATE vb_user SET friendcount="0" WHERE userid="1"
Delete all friends from your list
Code:

DELETE FROM vb_userlist WHERE userid="1" AND type="buddy" AND friend="yes"
---------------------------------------------------------------------------

Reduce friend counts from everyone else that lists you as a friend
Code:

UPDATE vb_user LEFT JOIN vb_userlist ON vb_user.userid = vb_userlist.userid SET vb_user.friendcount = vb_user.friendcount-1 WHERE vb_userlist.relationid="1"
Delete yourself from everyone else's friend lists
Code:

DELETE FROM vb_userlist WHERE relationid="1" AND type="buddy" and friend="yes"
Of course, replace "vb_" with your table prefix, or delete it if you don't have a table prefix. And replace the 1 with your userid, assuming you're not userid 1 (don't forget to change the "relationid" variables away from 1). The first two and the last two must be done together as pairs, but you do not have to do all 4 of them. If you just want to clear YOUR friend list, and still let other people list you as a friend, just do the first two.


Then go to your trusty Maintenance section, and open the "Update Counters" page, and "Fix Broken Profiles" (this is just in case - it shouldn't have an effect, I don't think it even resets the friend counts properly).




@King Kovifor - Maybe adding in a friend establisher/resetter feature would be good. I know some people complained when it didn't retroactively make friendships for existing users. And here you see MrBig wants to be able to start fresh on his friend list. You need to update the .xml file because of the e-mail activation bug anyway - might as well just throw in some shiny new features. Using the code I just provided above (assuming it's fully correct - the only query I worry about is the left join one... which I guess is the important one) it shouldn't be too difficult to implement a friendlist resetter, and going backwards to make a friendlist establisher shouldn't be too difficult.


All times are GMT. The time now is 08: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.01330 seconds
  • Memory Usage 1,751KB
  • 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
  • (4)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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