vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   An alternative to banning: Miserable Users (https://vborg.vbsupport.ru/showthread.php?t=49810)

Shiekron 08-09-2003 02:59 PM

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 08-09-2003 06:36 PM

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

-Sidekick- 08-09-2003 10:51 PM

Quote:

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 08-10-2003 05:50 AM

Quote:

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 08-10-2003 06:04 AM

Quote:

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 08-10-2003 06:12 AM

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

-Sidekick- 08-10-2003 12:05 PM

Quote:

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- 08-10-2003 12:08 PM

Quote:

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 08-10-2003 05:51 PM

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

Zachery 08-10-2003 06:11 PM

try making your self a miserable user :P

you do it under user options


All times are GMT. The time now is 09:43 AM.

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.01296 seconds
  • Memory Usage 1,741KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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