vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Erease all ignored users? (https://vborg.vbsupport.ru/showthread.php?t=44111)

410 09-30-2002 01:00 AM

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

g-force2k2 09-30-2002 01:20 AM

410 try this query:

PHP Code:

UPDATE user SET ignorelist='' WHERE userid != 

regards...

g-force2k2

410 09-30-2002 02:26 AM

nope...the users are still on ignore... :( ... anything I can look for?

g-force2k2 09-30-2002 02:36 AM

1 Attachment(s)
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

410 09-30-2002 03:37 AM

comes up as a blank page....??? I tried chmodd to 777..still nothing? ....

410 09-30-2002 03:42 AM

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...

Xenon 09-30-2002 09:58 AM

g-force i think != didn't work in mysqlqueries

410 try just this query:
[sql]UPDATE user SET ignorelist=''[/sql]

g-force2k2 09-30-2002 10:44 AM

hmm... not sure Xenon...

about the '!=' i didn't know it didn't work :p 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

Xenon 09-30-2002 12:14 PM

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

410 09-30-2002 02:58 PM

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?


All times are GMT. The time now is 01:41 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.01051 seconds
  • Memory Usage 1,726KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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