vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Moderators Functions - One-touch Spam Ban and Cleanup (https://vborg.vbsupport.ru/showthread.php?t=156444)

mfyvie 01-07-2008 07:04 AM

Catching up on some old posts here...

Quote:

Originally Posted by Seiyaboy (Post 1388709)
This looks very nice indeed, but I have a question about this before I install it. Do this modification require admins and mods to be logged into their admin/mod cps in order for the banning and thread/post deleting to take place? Or as long as the usergroup permission matches, no extra login is needed? Thanks in advance.

No, they do not have to be logged into the admincp/modcp first. It's a single-file .xml install, it would have actually been faster to try for yourself than type your question :)

Quote:

Originally Posted by weeno (Post 1400713)
An issue that we've seen.

If you try to "one touch ban" from a user's name in the postbit, it tries to ban the 1st poster in the thread, not the user whose name you've clicked on.

Obviously, it's the wrong variable is being used.

arn

I haven't seen that before, nor had anyone else report this. Is this issue still current, if so please PM me with the details of your setup to see if I can figure out why that might happen.

Quote:

Originally Posted by DssCrazy (Post 1400718)
something needs to be added!

Look at the pic! i pointed it out!

Well I looked at the pic you posted and could see nothing other than the fact you drew a box around the forum name used in the example. I'm afraid you'll have to be more specific about what you are trying to say, because I've no idea.

Quote:

Originally Posted by tekguru (Post 1408540)
Any ideas why we are getting this message when trying to run?

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

                
DELETE FROM vb_pm WHERE pmtextid IN (SELECT pmtextid FROM vb_pmtext WHERE fromuserid 21443);

MySQL Error  Got error 134 from storage engine
Error Number 
1030
Date         
MondayDecember 24th 2007 08:37:24 PM
Script       
http://www.4winmobile.com/forums/misc.php
Referrer     http://www.4winmobile.com/forums/misc.php?do=spamcleanconfirm&u=21443 

It's been running flawlessly for ages...

When I took that error message and put it into google I found people suggesting that this indicates possible problems with your tables, and suggesting running repair / optimise on them. This message has nothing to do with this mod.

Quote:

Originally Posted by telc (Post 1413497)
Can you please fix the addon so it will work with MySQL > 4.0.16 the same as VBulletin requirements?

There is no requirement that mods must be compatible with the same versions of older software that the current version of vbulletin allows. That's why a system of minimum version numbers was built into the plugin system. In fact, starting from vbulletin 4.0 I'd be very surprised if they allow MySQL 4.0 to be used. See this post.

This mod uses sub queries. Sub queries are not possible in 4.0. There are a whole host of things which are possible in 4.1 and not in 4.0, as well as performance issues. In fact, many times when I try to do something useful with mysql I find that it is not possible with 4.0. Very small numbers of people still use 4.0 (since the arguments to upgrade, at least from my perspective, are good ones), so I don't really see the sense in committing the additional time required to rewrite what is essentially a simple query into a larger chunk of code to avoid using sub queries.

If someone else wants to undertake the work to rewrite that code to work in mysql 4.0 then I will include it into a new version, but I have limited resources at the moment, so I didn't ever plan to undertake such work.

Since this question seems to come up over and over I'll add it to a FAQ at the start of this thread.

DjLuv 01-10-2008 05:09 PM

awesome, hack installed and banned 2 members as they requested it

WiseOne38221 01-10-2008 10:47 PM

AWESOME! Installing now and thank GOD (and mfyvie) for this hack, LOL.

:)

AndyPandy 01-15-2008 11:46 PM

hey thanks for the great hack. One problem which has been mentioned: the postbit drop down part is not showing. How do I add my custom template to the hook?
Added: $template_hook[postbit_user_popup]
but still nothing ^

Sorry I am totally new to this*

cmeinck 01-16-2008 10:46 PM

This completely rocks. It saves me so much time and effort each day. Thank you, thank you, thank you!

nyqnzguju 01-18-2008 08:20 PM

Hi. thanks for sharing wonderful hack.

I have installed it but i cant see anything when i click on the user. Please let me out. I followed whatever u said but still didnt see anything.

http://i168.photobucket.com/albums/u...er/nothing.jpg

Please PM or Reply. I want this hack badly. ;) lol thanks in adv.

mfyvie 01-19-2008 10:02 AM

Quote:

Originally Posted by nyqnzguju (Post 1423985)
I have installed it but i cant see anything when i click on the user. Please let me out. I followed whatever u said but still didnt see anything.

Like the others, there is probably something non-standard in your template that is causing this (if you have followed the instructions elsewhere in this thread).

I suggest that if the postbit drop down menu doesn't work for you, then simply click through to the members profile page, then click on the one-touch spam ban and clean option that appears on the profile page to do the same thing.

jbd 01-19-2008 01:37 PM

I'm not convinced that is the issue here. I've tried installing this on a fresh board and I still don't see the link in postbit legacy. Does this work with both postbit and postbit legacy?

Amenadiel 01-19-2008 02:31 PM

I second the motion to add IP banning as an option in the mod configuration.

Thanks for a great hack anyway.

joshbond 01-21-2008 01:52 AM

I really love this mod. Thank you very much.
It makes it so quick and easy to get rid of "unwanted" users.

nyqnzguju 01-21-2008 04:34 PM

Still it doesnt work.:(

mfyvie 01-21-2008 04:48 PM

Quote:

Originally Posted by nyqnzguju (Post 1425974)
Still it doesnt work.:(

Right, so you are telling me that the link doesn't appear in the member profile page (see 3rd screenshot) - as per my suggestion as well.

If what you are saying is that you don't see the link in *either* place (though hard to tell since "still doesn't work" doesn't actually tell me whether you followed my suggestion or not), then you would be the first person ever to have that issue.

In other words - are you sure? Did you follow my suggestion (all of it)?

nyqnzguju 01-21-2008 05:13 PM

The links doesn't apprear in the member profile also. I did. I followed your all suggestions.

I told you before that i did whatever u said in the suggestion.

SBlueman 01-26-2008 07:08 AM

Would it be possible to add an option of omitting certain things from being deleted? I know this might sound odd but say someone is banned....but started a legit thread before being banned. Now it's deleted and the discussion thread seems out of context.

mfyvie 01-26-2008 07:15 AM

Quote:

Originally Posted by SBlueman (Post 1429148)
Would it be possible to add an option of omitting certain things from being deleted? I know this might sound odd but say someone is banned....but started a legit thread before being banned. Now it's deleted and the discussion thread seems out of context.

This tool is only intended to clean up after hard-core spammers. These people will never start a legitimate thread. If you really do have a case like you described, then clean it up the old way, without using this tool.

Dingo14 02-03-2008 10:03 PM

I get this error anyway know how to fix thanks

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT forumid, allowpostdecrease
FROM forum
WHERE forumid =;

MySQL Error : 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 3
Error Number : 1064

kartik786 02-03-2008 11:34 PM

did not get integrated in the templates properly..to be specific.. did not have the one click link in postbit.. please explain the template edits :)

Dingo14 02-04-2008 12:21 AM

Quote:

Originally Posted by kartik786 (Post 1435701)
did not get integrated in the templates properly..to be specific.. did not have the one click link in postbit.. please explain the template edits :)

sorry bit new to this not sure what you mean

please explain the template edits

mfyvie 02-04-2008 05:15 AM

Quote:

Originally Posted by Dingo14 (Post 1435657)
I get this error anyway know how to fix thanks

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT forumid, allowpostdecrease
FROM forum
WHERE forumid =;

MySQL Error : 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 3
Error Number : 1064

This database query does not come from this mod. I would guess that it is being generated by a different mod.

Dingo14 02-04-2008 05:33 AM

i get links that take me to smilies page on site plus back to the page that ask if you want to proceed these are being generated by email from vbulletin about the error as well, i have disabled quiet a few mods and still get the same thing

mfyvie 02-04-2008 05:47 AM

Quote:

Originally Posted by Dingo14 (Post 1435850)
i get links that take me to smilies page on site plus back to the page that ask if you want to proceed these are being generated by email from vbulletin about the error as well, i have disabled quiet a few mods and still get the same thing

Nonetheless - that error message is not being generated by this mod. It's impossible because it doesn't have the code listed in the error message. You will have to continue to disable mods one by one until you find the mod that is using the code that is generating that error message. I can't help you further than that.

kartik786 02-05-2008 11:24 AM

Quote:

sorry bit new to this not sure what you mean

please explain the template edits
The one click ban link doesnt show up in the popup once you click the member name.

I'm assuming you need to tweak the postbit_legacy template?

Dr.NoTime 02-05-2008 05:06 PM

Really useful hack. Thank You.

tanujdude91 02-08-2008 11:18 AM

One of the best mods seen . Nominated for MOTM .
Thanks bro....

SoftDux 02-10-2008 03:53 PM

where do I change the default wording when I want to ban someone?

rwoscott 02-12-2008 01:24 AM

Installed thanks.

sparky5693 02-18-2008 02:35 AM

Anyone tried this on 3.7?

adwade 02-20-2008 07:17 AM

Just installed and utilized this fine MOD, it saved me an hour's worth of frustration in removing 100+ msgs left by a wayward user. Many Thanxx! PayPal Donation sent.:up:

atcspaul 02-23-2008 10:55 AM

best mod i have ever seen. nice job vbulletin.org

midlandi 02-24-2008 06:46 PM

Bloody Brilliant!!!!!!

A real time saver.:D

dreads 02-25-2008 01:08 AM

Installed -
Thanks!

RedGTiVR6 02-27-2008 05:35 PM

Quote:

Originally Posted by sparky5693 (Post 1445647)
Anyone tried this on 3.7?

I'd like to know the results here too!

bigcurt 02-29-2008 07:55 PM

Quote:

Originally Posted by weeno (Post 1400713)
An issue that we've seen.

If you try to "one touch ban" from a user's name in the postbit, it tries to ban the 1st poster in the thread, not the user whose name you've clicked on.

Obviously, it's the wrong variable is being used.

arn

I have the EXACT same problem for some odd reason.

atcspaul 02-29-2008 11:11 PM

i also nominated this for motm. great job everyone. what a time saver!

kenc 03-03-2008 01:40 AM

this kicks some serious ass - thanks! much easier than having to go all over the place within the admin cp to delete/take care of posts by hand etc.. great mod, thanks!

-kenc

AcidX 03-04-2008 05:06 PM

Installed. Thanks.

Raptor 03-04-2008 05:41 PM

any way to get this working with mysql 4.027 ?

csalbuchi 03-05-2008 02:32 AM

I´m using vbulletin 3.6.8 and my template is basically "oumar", but cannot see the dropdown menu option for this wonderfull addon. I´m going to use it from the profile view.

Anyway, my fellows will be very happy when they see it installed at my forum. Thanx! Great job!!! I´ve clicked "installed"

Powerofdreams 03-20-2008 01:29 PM

Its working very good :) Installed! Thank you

jmurrayhead 03-20-2008 08:49 PM

Very nice, would be nice to have a 'Cancel' button on the confirm page to bring users back to the previous page.


All times are GMT. The time now is 04:17 PM.

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.02629 seconds
  • Memory Usage 1,833KB
  • 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
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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