An alternative to banning: Miserable Users

This hack is an alternative to banning a user. As the name suggests a user who
gets hit with this hack will become truly miserable while trying to access
your board.

So here is what really happens to a miserable user:

- There is a random 60-120 second delay each time they click on a link.
- 90% of times they have no search engine acccess.
- 75% of the times they get the server too busy error.

If they don't get the server too busy error:
- 50% of the times they may get a blank page
- 30% of the times they may get forwarded to the forum main page
- 20% of the time they may be able to see the page they asked for.

after doing all the math in actuality they have only a 5% chance of seeing the
page they clicked on. What kills them is the time they have to wait before
anything happens.

I actually once tracked a miserable user and watched him suffer for 2 whole
hours before he was able to make a simple post.

This hack is considered one of the most sadistic hacks on my board.

The hack allows you to make your user miserable via the admin CP. It also
allows you to search for all miserable users through the admin CP as well.

Also in showthread.php, it appends a red status that is only visibly to admins
and mods stating that a user is miserable.


Tables affected by this hack: user

Files affected by this hack: global.php, showthread.php, admin/user.php

[Shiekron]

I fixed it, but now I'm getting this:

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='6',username='Shiekro n',email='serafin@eryxma.com',styleid='0',parentem ail='',coppauser=0,homepage='',icq='',aim='',yahoo ='',signature='',adminemail=1,showemail=1,invisibl e=0,usertitle='I\'m so nice. I host this ++++ty site for free.',customtitle=1,joindate=UNIX_TIMESTAMP('2003-08-09 02:02:18'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-08-09 04:11:56'),lastactivity=UNIX_TIMESTAMP('2003-08-09 05:47:42'),lastpost=UNIX_TIMESTAMP('1969-12-31 18:00:00'),posts='0',timezoneoffset='0',emailnotif ication=0,receivepm='0',emailonpm='0',ipaddress='' ,pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0'), miserable=1 WHERE userid=1
mysql error: Unknown column 'miserable' in 'field list'

mysql error number: 1054

Date: Saturday 09th of August 2003 11:01:23 AM
Script: http://talk.dorksnet.org//talk/admin/user.php
Referer: http://www.dorksnet.org/talk/admin/u...=edit&userid=1

[MaDCaT75]

Someone wanna help me please? I cant see anything in admin cp that lets me make a user miserable!

[-Sidekick-]

Today at 10:59 AM Shiekron said this in Post #181
I fixed it, but now I'm getting this:

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='6',username='Shiekro n',email='serafin@eryxma.com',styleid='0',parentem ail='',coppauser=0,homepage='',icq='',aim='',yahoo ='',signature='',adminemail=1,showemail=1,invisibl e=0,usertitle='I\'m so nice. I host this ++++ty site for free.',customtitle=1,joindate=UNIX_TIMESTAMP('2003-08-09 02:02:18'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-08-09 04:11:56'),lastactivity=UNIX_TIMESTAMP('2003-08-09 05:47:42'),lastpost=UNIX_TIMESTAMP('1969-12-31 18:00:00'),posts='0',timezoneoffset='0',emailnotif ication=0,receivepm='0',emailonpm='0',ipaddress='' ,pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0'), miserable=1 WHERE userid=1
mysql error: Unknown column 'miserable' in 'field list'

mysql error number: 1054

Date: Saturday 09th of August 2003 11:01:23 AM
Script: http://talk.dorksnet.org//talk/admin/user.php
Referer: http://www.dorksnet.org/talk/admin/u...=edit&userid=1

Run the queries for the hack again. It looks like you forgot to run the query that alters that table and adds the miserable field.

[MaDCaT75]

Yesterday at 08:36 PM MaDCaT75 said this in Post #182
Someone wanna help me please? I cant see anything in admin cp that lets me make a user miserable!

[Shiekron]

Today at 12:51 AM -Sidekick- said this in Post #183
Run the queries for the hack again. It looks like you forgot to run the query that alters that table and adds the miserable field.

I'm guessing you mean the MySQL prompt execute?

[MaDCaT75]

Will someone for the love of god tell me why mine doesnt work?!

[-Sidekick-]

Today at 02:04 AM Shiekron said this in Post #185
I'm guessing you mean the MySQL prompt execute?

yes. Run this in phpMyAdmin:

alter table user add miserable smallint(5) unsigned DEFAULT 0 NOT NULL;

or however you choose to run the query.

[-Sidekick-]

Today at 02:12 AM MaDCaT75 said this in Post #186
Will someone for the love of god tell me why mine doesnt work?!

Go to find a user in your admin cp. Search for a user and go to Edit User.

If you don't see the option in there, then you did not properly install this hack.

[MaDCaT75]

But I did everything right I dont understand!!!! :cry:

[Zachery]

try making your self a miserable user :P

you do it under user options