Spam Killer Hack v1.0 (includes Lesane's Store Hack Addon)

As requested [ Here ] by Hot Dogg

// ++++++++++++++++++++++++++++++++++++++++++++++
// +++++++ Lesane Store Hack Version +++++++
// ++++++++++++++++++++++++++++++++++++++++++++++
// +++++++ Queries to Run (8) +++++++
// +++++++ File Modification (12) +++++++
// +++++++ storeadmin.php (3) +++++++
// +++++++ newthread.php (1) +++++++
// +++++++ newreply.php (1) +++++++
// +++++++ admin/user.php (5) +++++++
// +++++++ admin/functions.php (2) +++++++
// +++++++ Template Modifications (1) +++++++
// +++++++ postbit template (1) +++++++
// ++++++++++++++++++++++++++++++++++++++++++++++

// ++++++++++++++++++++++++++++++++++++++++++++++
// +++++++ Regular Spam Killer Version +++++++
// ++++++++++++++++++++++++++++++++++++++++++++++
// +++++++ Queries to Run (8) +++++++
// +++++++ File Modification (9) +++++++
// +++++++ newthread.php (1) +++++++
// +++++++ newreply.php (1) +++++++
// +++++++ admin/user.php (5) +++++++
// +++++++ admin/functions.php (2) +++++++
// +++++++ Template Modifications (1) +++++++
// +++++++ postbit template (1) +++++++
// ++++++++++++++++++++++++++++++++++++++++++++++

---------------------
What Does This Hack Do?
---------------------

* Notice: Please read the features and more below. If you have any questions please feel free to find support in the thread or at my forum!
Be sure to read the instructions closely since this is a double deal concerning different versions.
User the Store Hack Instructions if you're using a store and the regular instructions if you're not!

+++++++ Post Killer - What is it? +++++++
Allows you to seperate the spammers from the rest of the forum.
It will create a new post count called spam posts.
You will then be able to change the minimum amount of characters before a post is considered spam from the Admin CP.
Includes configuration for disabling Spam Killer from Administrators and Moderators!
Spam Posts are shown on the postbit right under the post count!
Post Count Deletion has been taken out in the deletion of posts and threads to keep post counts from falling into negatives when pruning or deleting!
Also i know some members were looking for taking out the drop of posts while deleting threads and posts
Another Addition is New Member Spam Killing. You can enable it or disable it from Admin CP as well.
If you enable it you can also configure the amount of posts before Spam Killing Begins on Newer Members.

+++++++ Lesane Store Hack Post Killer - More? Yep +++++++
Some History:
I honestly don't use Lesane's Store Hack. I really like the set up and think its a great hack, but just never used it.
but Hot Dogg requested such an addon so why not right Enough Talk

More Features? :
Not only does the Lesane Store Hack get all of the features of the Regular Post Killer Hack it gets a special feature!
Since it's based off of Points System it allows users to gain posts while posting.
But with the Spam Killer you have the ability to set the Spam Killer to actually take away a specified amount of points from the user rather then them gettig points for spamming
And its also controlled in the Admin CP.

+++++++ Differences? +++++++
The difference between the two hacks is that not only does the Lesane Store Hack get an extra feature but they're also based differently.
Since Lesane's Store Hack already has a set database storeadmin i used that so that the options to be configured are in the storeadmin.php
As for the regular Spam Killer they're in vbulletins setting options
Well i hope that all members... both the Store Users and regular users enjoy this hack and have some fun killing Spammers

Sorry but once again i don't have any screenshots -_- but i did beta test it so enjoy it... If anyone could provide any i would appreciate it

Hot Dogg the only thing i didn't add in was the smileys inclusion wasnt' sure about that but i did and some other features enjoy man

g-force2k2

Edit: quick fix in the lesane store setup thanks to Lovaboye For details on the two fixes view [ Here ]

[Mijae]

I think I figured it out.

[chad777]

Anyway to make a page to list who has the most SPAM POINT like maybe a Wall of Shame page ?

[feldmaresciallo]

Found a bug...

// +++++++ Checking Special Admin And Moderator Options +++++++
$perms=getpermissions();
if ($bbuserinfo[usergroupid] == 6 and $spambyadmins) {
$fpost="posts";
} elseif(($bbuserinfo[usergroupid] == 5 OR $perms[ismoderator]) and $spambymods) {
$fpost="posts";
}

the controls in the table are wrong...
not
$spambyadmins
$spambymods

but
$spambyadmin
$spambymod

if you don't correct this, mods and Admin will count spam post even if option spam admin and mods are selected

[McDohl]

Hey all.

I tried running the queries for the non-store hack edition of this Spam Killer and I got this

You have an error in your SQL syntax near 'INSERT INTO setting VALUES ( NULL , 32, 'Spam Hack Enabled?', 'SPAMenabled',' at line 1

I'm sure I copied everything in right, but to no avail.

Any ideas? If someone could help me i'd appreciate it.

Thanks,
-Scott

[McDohl]

Sorry, posted something wrong. x_x

[GTA3_Mafia]

Error

SQL-query :

ALTER TABLE storeadmin ADD spamenabled int( 2 ) NOT NULL DEFAULT '1' ALTER TABLE storeadmin ADD spambyadmin int( 2 ) NOT NULL DEFAULT '1' ALTER TABLE storeadmin ADD spambymod int( 2 ) NOT NULL DEFAULT '1' ALTER TABLE storeadmin ADD characters int( 10 ) NOT NULL DEFAULT '250' ALTER TABLE storeadmin ADD pdeduction int( 10 ) NOT NULL DEFAULT '5' ALTER TABLE storeadmin ADD spamnewbie int( 2 ) NOT NULL DEFAULT '1' ALTER TABLE storeadmin ADD spamkill int( 10 ) NOT NULL DEFAULT '5' ALTER TABLE user ADD spamposts int( 5 ) unsigned NOT NULL DEFAULT '0'

MySQL said:


#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 'ALTER TABLE storeadmin ADD spambyadmin int( 2 ) NOT NULL DE

?