The Arcive of Official vBulletin Modifications Site.

Automatically find and remove dupe users through Admin CP · **Released**: 12-28-2002

This hack now moved to the Full Releases forum.

It is located here

Lanigironu · #12 12-29-2002, 11:09 PM

It only takes a minute to install, and the two main queries are pretty fast.

What about you, partang2?

Lanigironu · #13 12-31-2002, 04:19 AM

So I guess this hack doesn't have any bugs. Can this be moved to the full hacks please?

Chris M · #14 12-31-2002, 12:52 PM

Just re-release it, and use the "Admin Options" at the bottom of this page to close this thread

Satan

ixian · #15 12-31-2002, 07:34 PM

YES. THANK YOU.

Maybe no one else is saying it, but that's because they haven't had this problem. I forget the exact combo of hacks I had that did this, but it happened over a year ago and I am STILL finding dupes in my db, out of over 4,000 users. Thank you thank you thank you!

ixian · #16 12-31-2002, 07:51 PM

Hmm.

It installs easily enough, but I'm running into an error - maybe because I'm the only one so far besides the creator who has dupe users

When I click remove dupe users, the following error gets spat back:

PHP Code:


			
Database error in vBulletin Control Panel 2.2.9:



Invalid SQL: DELETE FROM `user` WHERE userid='2514

mysql error: You have an error in your SQL syntax near ''2514' at line 1



mysql error number: 1064

I can assume that my user 2514 is in fact a dupe but it goes no further. Any ideas? This is a great hack, I hope I can get it to work!

Fallout2man · #17 12-31-2002, 11:41 PM

Quote:

Originally posted by ixian
Hmm.

It installs easily enough, but I'm running into an error - maybe because I'm the only one so far besides the creator who has dupe users

When I click remove dupe users, the following error gets spat back:

PHP Code:

Database error in vBulletin Control Panel 2.2.9: Invalid SQL: DELETE FROM `user` WHERE userid='2514 mysql error: You have an error in your SQL syntax near ''2514' at line 1 mysql error number: 1064

I can assume that my user 2514 is in fact a dupe but it goes no further. Any ideas? This is a great hack, I hope I can get it to work!

It's a minor bug, Prince just forgot to put an ending '

Replace this:

PHP Code:


			
        if ($posts == 0){

          $DB_site->query("DELETE FROM `user` WHERE userid='$userid");

With this:

PHP Code:


			
        if ($posts == 0){

          $DB_site->query("DELETE FROM `user` WHERE userid='$userid'");

ixian · #18 01-01-2003, 07:46 PM

Thanks! That worked like a charm!

FYI, it found no less than 82 dupe users. This was a massively usefull hack for me, thanks again.

matthepepe · #19 01-02-2003, 02:01 AM

This hack worked great it deleted about 200 dupe accounts off of my board, but i would suggest to Lanigironu to update teh installation file to fix the changes that were made later on. I got the same error as the other guy until i made that code chage. Now that you know its a consistant bug you should fix that.

Lanigironu · #20 01-02-2003, 05:52 AM

Yes, sorry about that. I discovered it a while ago, and I was sure I fixed the instructions as well.

I also modified the queries to sort by the userid. It didn't seem to affect anything, but I figure it doesn't hurt. I'll just make the thread in full hacks with the new file.

Lanigironu · #21 01-02-2003, 06:04 AM

Ok. The new thread is located here.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07960 seconds Memory Usage 2,307KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!