Page 55 of 57

Re: [2.0.21] User Shield

Posted: Tue Nov 06, 2007 8:47 pm
by will_hough
thecomputergal wrote:I am also having the problem with not being able to delete spammers in the User Shield inactive users window. Has anyone found a fix for this?

Thanks!
Did you run the SQL?

Re: [2.0.21] User Shield

Posted: Mon Nov 12, 2007 4:24 am
by thecomputergal
Thanks for the reply, but I'm not sure exactly what you mean "run the SQL." I installed the User Shield mod to give the guy who deletes the spammers a quick way to do it. Now we can't delete from that window because of a missing group id. The problem started all the sudden about two weeks ago.

Re: [2.0.21] User Shield

Posted: Mon Nov 12, 2007 2:11 pm
by will_hough
thecomputergal wrote:Thanks for the reply, but I'm not sure exactly what you mean "run the SQL." I installed the User Shield mod to give the guy who deletes the spammers a quick way to do it. Now we can't delete from that window because of a missing group id. The problem started all the sudden about two weeks ago.
The MOD was working fine and now it's not?

Re: [2.0.21] User Shield

Posted: Mon Nov 12, 2007 6:35 pm
by thecomputergal
Yes, that's correct. We have been using User Shield for a number of months, and it has been a great tool for dumping spammers. We have our forum set so that folks have to be approved before they can post. But, they were still showing up in the Memberlist before they were approved. User Shield hides them until they are approved.

It's my guess that someone has figured out how to get in the list without a Group ID; so, the delete function fails. I was wondering if anyone had built a patch or found some other solution.

Wolf has always given great responses to questions, but he doesn't seem to be available any more.

Thanks for your response!

Re: [2.0.21] User Shield

Posted: Mon Nov 12, 2007 7:11 pm
by will_hough
Has anyone been messing with files, installing MODs?

Re:

Posted: Mon Nov 12, 2007 11:59 pm
by ChakraGoddess
Wo1f wrote: [*]Using the XML installation file type:
  1. Extract "install_user_shield_v1_x_x.xml" along with "modx.subsilver.en.xsl" into the same folder on your local machine
  2. Launch the XML installation file (double-click on "install_user_shield_v1_x_x.xml"), to display it's content in your default browser
  3. Follow the installation instructions until completion
  4. When done, proceed with #2 (Database update)
  5. You can safely ignore the [SQL] action at the beginning of the installation file (will be taken care of in step #2)
  6. You can safely ignore the TXT installation file type in the zip package
[/list]
hi Wolf,

Got the file unzipped alright (yes!) but the .xml file is reading as an error when I try and open it. Got anything easier? ;-)

Re: [2.0.21] User Shield

Posted: Tue Nov 13, 2007 2:13 pm
by will_hough
There is a text file thats easy to use.

contrib/install_user_shield_v1_2_1.txt

Re: [2.0.21] User Shield

Posted: Fri Nov 16, 2007 4:42 pm
by charmedseed
I'm trying to install with EasyMod, having followed the instructions on the first post of this thread. But I keep getting this error message:
Critical Error

FIND FAILED: In file [memberlist.php] could not find:

WHERE user_id <> " . ANONYMOUS;

MOD script line #281 :: FAQ :: Report
I've made sure to CHMOD to 755 on the folder, what else should I do?

Re: [2.0.21] User Shield

Posted: Sat Nov 17, 2007 1:19 am
by thecomputergal
Will,

Back to not being able to delete new users in the User Shield Mode, no, there were no files changed. In fact, I did a test and registered a test account. I was able to delete that particular account.

It seems that User Shield creates a query ?mode=inactive on the memberlist.php file. When that particular query string is passed in, each member has a checkbox by their name that is supposed to allow choice to delete.

However, those entries that are spammers don't allow for deleting. Also the Select All and Unselect All links don't work. I'm guessing that there is a new programming twist in the programming the spammers are using that bypasses the default group_id field entry, leaving it empty. That causes the query to delete the member to fail, giving this message:
Could not delete group for this user

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM NewForumgroups WHERE group_id =

Line : 429
File : memberlist.php

Unfortunately, I don't know enough about the overall working of phpBB to fix the problem! I checked all my file dates, and no changes have been made to the files. I'm guessing this one will need a hole patched!

Thanks for all your help!

Re: [2.0.21] User Shield

Posted: Sun Nov 18, 2007 3:40 am
by will_hough
charmedseed wrote:I'm trying to install with EasyMod, having followed the instructions on the first post of this thread. But I keep getting this error message:
Critical Error

FIND FAILED: In file [memberlist.php] could not find:

WHERE user_id <> " . ANONYMOUS;

MOD script line #281 :: FAQ :: Report
I've made sure to CHMOD to 755 on the folder, what else should I do?
You may need to install this by hand. Your file structure may have been altered by another mod. The error is telling you that Easy MOD can not find the code in memberlist.php

Code: Select all

		WHERE user_id <> " . ANONYMOUS;

Re: [2.0.21] User Shield...NEED HELP

Posted: Sun Mar 30, 2008 9:44 am
by JustForMilitary
I need help....I installed this MOD manually, but do not understand what to do about the DIY instructions. Yes, I am fairly new to all of this. I do not have an install folder, not sure how to "update" the config file, nor do I know how to get the update file in the files to even run it....I need help. I have completed all the other functions of the MOD manually.

Here is the DIY part I do not understand:

IMPORTANT ***** If you are NOT using EasyMOD to install User Shield, you MUST update the CONFIG table by following these instructions ***** IMPORTANT
IMPORTANT ***** Remember to change the default TABLE PREFIX in file "update_config_v1_2_1.php" if your board does not use " phpbb_ ". ***** IMPORTANT

1] Run this file: update_config_v1_2_1.php - located in the install folder off the root of your forum ( eg. In your browser URL field, type the following: http://yoursite.com/yourforumroot/insta ... v1_2_1.php )

Once done a message confirming a successful update will be displayed along with a reminder to delete the "install" folder including it's content, before returning to your forum.

Also, the SQL part in the beginning....what do I need to do here...not understanding where exactly or what exactly I need to do with this:
INSERT INTO `phpbb_config` (`config_name`, `config_value`)
VALUES ('username_hide_inac', '1');

Help please??

Re: [2.0.21] User Shield

Posted: Sun Mar 30, 2008 10:01 am
by JustForMilitary
update.....OK, I got the DIY install part completed, ran sucessfully and then deletd install file. I can not get th SQL part though in the beginning of the MOD??? When I log into my board and try to view the memberlist I get this:
Parse error: syntax error, unexpected '"' in /home/jejainc/public_html/forum/memberlist.php on line 367

help???

Re: [2.0.21] User Shield

Posted: Tue Apr 01, 2008 2:16 am
by aosfyc
Has anyone else experienced problems after updating to 2.0.23? I have had this running for a while now, and haven't had any problems, but just yesterday after upgrading to 2.0.23, the Who Is Online data in the index.php page is coming up with incorrect data.
Our users have posted a total of 2896 articles
We have 509 registered users and non-active registered users
Whereas before where the "non-active" verbiage is I had the number of inactive users.

Any ideas?

Thanks!!

Re: [2.0.21] User Shield

Posted: Tue Apr 01, 2008 10:16 am
by RMcGirr83
charmedseed wrote:I'm trying to install with EasyMod, having followed the instructions on the first post of this thread. But I keep getting this error message:
Critical Error

FIND FAILED: In file [memberlist.php] could not find:

WHERE user_id <> " . ANONYMOUS;

MOD script line #281 :: FAQ :: Report
I've made sure to CHMOD to 755 on the folder, what else should I do?
find this in memberlist.php

Code: Select all

	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS;
and change it to this

Code: Select all

	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS . " $hide_inactive_on";
// User Stealth mod - added  $hide_inactive_on above

Re: [2.0.21] User Shield

Posted: Tue Apr 01, 2008 10:22 am
by RMcGirr83
empressamermaids wrote:Critical Error

FIND FAILED: In file [includes/functions.php] could not find:

WHERE user_id <> " . ANONYMOUS;

MOD script line #517 :: FAQ :: Report

This is the error message I get after trying to install User Shield with EasyMod. Is the syntax wrong?
Find this in functions.php

Code: Select all

		case 'usercount':
			$sql = "SELECT COUNT(user_id) AS total
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS;
			break;
and change it to this

Code: Select all


		case 'usercount':
// User Stealth mod - start
	$hide_inactive_on = ( $board_config['username_hide_inac'] ) ? 'AND user_active = 1' : 'AND user_active >= 0';
// User Stealth mod - end
			$sql = "SELECT COUNT(user_id) AS total
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS . " $hide_inactive_on ";
// User Stealth mod - added $hide_inactive_on above
			break;