Installed this ok but when I click a users name in a post, I dont get the dropdown menu but it takes me to there profile page?

Any ideas.

Also just found this Mysql error:

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT COUNT(*) AS threads,
// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
SUM(IF(thread.lastpost>=1087900135 AND open<>10,1,0)) AS newthread
// [END HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
FROM thread AS thread

WHERE forumid = 65
AND sticky = 0
AND visible = 1

AND thread.lastpost >= 1085310715



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 '// [START HACK='Warning System, Automatic Ban, Make Posts Invis

mysql error number: 1064

Date: Tuesday 22nd of June 2004 12:11:55 PM
Script: http://www.tech-tronix.com/forums/forumdisplay.php?f=65
Referer:
Username: Realist
IP Address: xx.xxx.xxx.xxx

You cannot put comments // in the middle of a query. :) That's like putting // comments in the middle of a line of code.

LOL so I should of just used

Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
SUM(IF(thread.lastpost>=1087900135 AND open<>10,1,0)) AS newthread

And not

// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
SUM(IF(thread.lastpost>=1087900135 AND open<>10,1,0)) AS newthread
// [END HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
FROM thread AS thread

Dull bugger :)

Any ideas on this one M8

Infact none of my drop down menu's are working?

All solved but I have a request.

Can this hack be changed so it can do the following.

If a member gets say 3 points they are banned for 24 hours, if they get 7 points they are banned for 7 days and if they get 10 points they are banned for good.

Laters

it says in the title u can make posts invisible, but i don't see that option.

When a person is Emergency or Troll Banned, all their posts disappear automatically from view. Saves you from having to remove the manually.

Problem.

If I click "List all hack at once"

On the very bottom of the screen after current hack it says:

Warning: in_array(): Wrong datatype for second argument in /home/xxxxxxx/public_html/forums/admincp/hackadmin.php on line 2184

Also:

Current warnings on a username dropdown menu only shows the () there is no figure being shown in between the brackets.

And

If I click ban or suspend I get a "blank page?"
Unban or unsuspend it comes back with "Invalid User Specified"

Any ideas?

1) You haven't installed the hack properly - this hack requires careful following of instructions.

2) If current warning is zero, then by default there is nothing between ().