Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page Erease all ignored users?
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 3 1 23
 
Thread Tools Display Modes
  #1  
Old 09-30-2002, 01:00 AM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Erease all ignored users?
Somehow while hacking my board, some random people were added to peoples ignore lists....is there any possible way I can run a query that will erase all ignored users, and put it back to default...I don't know how to create the query so can someone pleaes help or show me how?

thanks
Reply With Quote
  #2  
Old 09-30-2002, 01:20 AM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
410 try this query:

PHP Code:
UPDATE user SET ignorelist='' WHERE userid != 0 
regards...

g-force2k2
Reply With Quote
  #3  
Old 09-30-2002, 02:26 AM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
nope...the users are still on ignore... ... anything I can look for?
Reply With Quote
  #4  
Old 09-30-2002, 02:36 AM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
410 upload this file to your forum directory and then call it accordingly (ignore.php)

it should display all of the users and who they have ignored... just want to see what it produces (maybe not an ignore problem?)

regards...

g-force2k2
Attached Files
File Type: php ignore.php (343 Bytes, 16 views)
Reply With Quote
  #5  
Old 09-30-2002, 03:37 AM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
comes up as a blank page....??? I tried chmodd to 777..still nothing? ....
Reply With Quote
  #6  
Old 09-30-2002, 03:42 AM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
yeah, but then i added someone to my real ignore list, and it showed my name and everything, but then I deleted that name..and it was blank again...yet, there are some users that are still on ignore for some reason...i do remember doing a hack that like didn't allow people to edit admins profiles...would that have anything to do with this...
Reply With Quote
  #7  
Old 09-30-2002, 09:58 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
g-force i think != didn't work in mysqlqueries

410 try just this query:
[sql]UPDATE user SET ignorelist=''[/sql]
Reply With Quote
  #8  
Old 09-30-2002, 10:44 AM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
hmm... not sure Xenon...

about the '!=' i didn't know it didn't work i use it alot when seleting from the database and such... should i not be using it? or is it a strict mysql aspect?

but i think i suspected right that its something other then the ignore list because the file i gave him would 'echo' each user name and who he/she had on ignore... and it came up with nothing... and when he added a name then it came up solely with that person... any idea Xenon?

only other thing i could think of would be a invisibility issue? or hidden posts? not sure... regards...

g-force2k2
Reply With Quote
  #9  
Old 09-30-2002, 12:14 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
yes, i was wrong i look up in a SQL-language book and have overread a small bit

but the query should do what it should
Reply With Quote
  #10  
Old 09-30-2002, 02:58 PM
410 410 is offline
 
Join Date: Jul 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I ran both of those querys, they both said "rows affected: 0" ... and people are still on ignore ... anything else you guys can think of?
Reply With Quote
Reply
Page 1 of 3 1 23

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 05:10 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05846 seconds
  • Memory Usage 2,262KB
  • Queries Executed 12 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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
  • postbit_attachment
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete