PDA

View Full Version : Erease all ignored users?

410
09-30-2002, 01:00 AM
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:

UPDATE user SET ignorelist='' WHERE userid != 0

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
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:
UPDATE user SET ignorelist=''
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?
g-force2k2
09-30-2002, 04:28 PM
410 like i said it has nothing to do with your ignore list... the queries ran fine and changed nothing and the file i provided showed that there were no users on any ignore lists... do you have any ban type hacks installed on your forum? and how do you know that they're in fact ignored? regards...

g-force2k2
410
09-30-2002, 04:34 PM
I did install the Warning system hack, and the banned - reason hack....but I don't know if that did anything...? And I know they are ignored because it says "this person is on your ignore list, click here to view message" ... I also have the "nuked post" hack installed...?
g-force2k2
09-30-2002, 04:50 PM
nuked post? banned - reason hack? linkage please...

but when you ran my file nothing showed until you added someone to your ban list correct?

regards...

g-force2k2
410
09-30-2002, 07:26 PM
Banned Users: https://vborg.vbsupport.ru/showthread.php?s=&threadid=35979&highlight=banned+reason
Nuked Posts: https://vborg.vbsupport.ru/showthread.php?s=&threadid=36888&highlight=nuke

And yes, the file was empty untill I added someone to my ignore list...thank you so much for your help so far!
Merjawy
10-01-2002, 06:06 AM
I have a problem like that.. tho its not members just quests.. one day I found all quest posts in ingore.. it say user in your ignore list click here to view his/her post

I have no hack of the kind installed.. last things I did were changin my vbcodes to install toolbox

when I look in my CP theres noone ignored
Logician
10-01-2002, 07:57 AM
I would say: You are using a vb version <2.2.6.

If this is the case the problem you have is related your hosting company's recent PHP upgrade. Latest version of PHP clashes with vb ver <2.2.6 and sometimes these weird problems like displaying some users in ignore lists occurs. In your database they are not in ignore list, it's just vb playing you tricks. Your solution is to upgrade your board to a version >= 2.2.6 and you'll be just fine..
410
10-01-2002, 03:38 PM
Is there any way I can like disable the ignoring of users?
Xenon
10-01-2002, 03:42 PM
the easiest and brute way:
open admin/functions.php
find if (($ignore[$post[userid]] and $post[userid] != 0)) {
eval("\$retval = \"".gettemplate("postbit_ignore")."\";");
} else {
eval("\$retval = \"".gettemplate("postbit")."\";");
}


chage it to eval("\$retval = \"".gettemplate("postbit")."\";");
Logician
10-01-2002, 03:49 PM
Originally posted by 410
Is there any way I can like disable the ignoring of users?
If your problem is related to what I told, this wont help either. Besides you will have other weird issues than ignore user problem..
410
10-01-2002, 05:44 PM
I have the nuked post thing installed...how would I go about chaning this..?

if ($post[nuked]==1) {
eval("\$retval = \"".gettemplate("postnuked")."\";");
} else if ($ignore[$post[userid]]) {
eval("\$retval = \"".gettemplate("postbit_ignore")."\";");
} else {
eval("\$retval = \"".gettemplate("postbit")."\";");
}

return $retval;
}
Xenon
10-01-2002, 05:47 PM
just replace the whole if block with the normal postbit line:eval("\$retval = \"".gettemplate("postbit")."\";");
410
10-01-2002, 05:48 PM
That would disable my nuked posts :) ... I just deleted those 2 ignore'd lines, and it worked out perfectly! Thanks so much Xenon...
Xenon
10-01-2002, 05:49 PM
:)

welcome