vb.org Archive
Page 16 of 29 « First 61415 16 171826 Last »
Show 40 post(s) from this thread on one page

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)

Steve W. 06-13-2003 06:59 PM
Thanks for the changes Zzed, but after I did them, it all worked fiine until I hit yes to "miserable user?" and it gave me this:

Quote:
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1988-05-04',options='15',usergroupid='2',username='Joe Obsessed',email='yasmin4joe@hotmail.com',styleid=' 0',parentemail='',coppauser=0,homepage='http://teenworld.upperboard.com',icq='',aim='',yahoo='',s ignature='Sometimes, I find myself Struggling to breathe
Without you, You are my air...I love you, Joe. You mean the world to me - you complete me. You\'re the only thing I need in my life at the moment. I think about you first thing in the morning and last thing at night - and I wanna say thank you for making me so happy...You are truely amazing and I don\'t think you realise just how wicked you are. You\'ve had the wicked impact on me that I\'ve never had before, and I love you. For that, and many other things, I wanna say thank you. Love you my babe x x x',adminemail=0,showemail=1,invisible=0,usertitle=' ...So Sexy... ',customtitle=2,joindate=UNIX_TIMESTAMP('2003-05-22 02:45:53'),cookieuser=1,nosessionha
sh=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2003-06-11 12:12:42'),lastactivity=
activity,lastpost=UNIX_TIMESTAMP('2003-06-12 16:07:43'),posts='54',profileview='6',timezoneof
fset='0',emailnotification=0,receivepm='
m',emailonpm='0',ipaddress='62.254.128.4',pmpopup= IF(pmpopup=2 AND 1=1,pmpopup,'1'), miserable=1 WHERE userid=8
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 'sh=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2003-06-11 12:12:

mysql error number: 1064

Date: Friday 13th of June 2003 03:58:50 PM
Script: http://rockpop.goldenpie.com/admin/user.php
Referer: http://rockpop.goldenpie.com/admin/u...=edit&userid=8
Any ideas?

Zzed 06-13-2003 07:52 PM
Your query statement has the word sessionhash broken up in 2 lines where sessionha is on one line and sh is on the next. ;)

Steve W. 06-13-2003 08:46 PM
I changed it, but unfortuantly I got a:

Quote:
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1988-05-04',options='15',usergroupid='2',username='Joe Obsessed',email='yasmin4joe@hotmail.com',styleid=' 0',parentemail='',coppauser=0,homepage='http://teenworld.upperboard.com',icq='',aim='',yahoo='',s ignature='Sometimes, I find myself Struggling to breathe
Without you, You are my air...I love you, Joe. You mean the world to me - you complete me. You\'re the only thing I need in my life at the moment. I think about you first thing in the morning and last thing at night - and I wanna say thank you for making me so happy...You are truely amazing and I don\'t think you realise just how wicked you are. You\'ve had the wicked impact on me that I\'ve never had before, and I love you. For that, and many other things, I wanna say thank you. Love you my babe x x x',adminemail=0,showemail=1,invisible=0,usertitle=' ...So Sexy... ',customtitle=2,joindate=UNIX_TIMESTAMP('2003-05-22 02:45:53'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-06-11 12:12:42'),lastactivity=
activity,lastpost=UNIX_TIMESTAMP('2003-06-12 16:07:43'),posts='54',profileview='6',timezoneof
fset='0',emailnotification=0,receivepm='
m',emailonpm='0',ipaddress='62.254.128.4',pmpopup= IF(pmpopup=2 AND 1=1,pmpopup,'1'), miserable=1 WHERE userid=8
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 'fset='0',emailnotification=0,receivepm='
m',emailonpm='0',ipad

mysql error number: 1064

Date: Friday 13th of June 2003 05:46:45 PM
Script: http://rockpop.goldenpie.com/admin/user.php
Referer: http://rockpop.goldenpie.com/admin/u...=edit&userid=8

Zzed 06-13-2003 08:49 PM
Quote:
Today at 02:46 PM Steve W. said this in Post #153
I changed it, but unfortuantly I got a:
You have a PM from me. ;)

Zzed 06-13-2003 09:51 PM
Quote:
Today at 02:46 PM Steve W. said this in Post #153
I changed it, but unfortuantly I got a:
This time it is the word timezoneoffset. It has been broken up into timezoneof and fset. ;)

PhantomX 06-20-2003 11:48 PM
brilliance! gracias amigo :)

Zzed 06-21-2003 06:00 PM
Thank you kind sir. :)

wolfman 06-27-2003 03:42 PM
Zzed,

I just have to asy thanks again for this hack. This is simply the most usefull hack I have on my board. Just to give a little background on how I am using it currently.

A few months back we had a group that split off and before doiing so had created multiple logins, to make it easier to get back in and cause trouble. Well we got those taken care of before this hack by banning them. Well a ban just added fuel to their fire. They would then use that as a badge or something with the other forum. Well since this hack has been added, they try to say they are banned, but we can honesly say they are not banned and that people can check in the members list to see for themselves.

I also know that they are not going to be offically supporting vb3 hacks on here at this time, which I can understand since it is in beta still. I just hope this is one hack that can make it to vb3 :)

Zzed 06-27-2003 04:12 PM
wolfman,

That is a great story. :) And thank you very much for your kind words. http://www.ls1.com/.zed/hail.gif

P.S. I am always the first victim of all my hacks. I know exactly how it feels to be struck by this hack. :D:D:D

wolfman 06-27-2003 09:28 PM
Well when I installed this my mods were like "Are you sure it works?" I setup a test account so they could try for themselves, though I did warn them that they might pull some of their hair out in the proccess.

The annoyance level of this hack I would have to put almost on the same level as those cardboard inserts in magazines. My first thought was that I wanted to choke you when I tested this hack for myself :) this one really does give the power back to the admin and mods of a forum as with a ban its to clear what has been done, this they do not know :dead:


All times are GMT. The time now is 05:10 PM.
Page 16 of 29 « First 61415 16 171826 Last »
Show 40 post(s) from this thread on one page

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.01394 seconds
  • Memory Usage 1,747KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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