PDA

View Full Version : Mike's Warning System 1.0


Beorn
05-30-2003, 10:00 PM
Hello all. This is a sort of alternative to g-force2k2's Warnings System Hack (http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=638). He gets all credit for the idea.

Before anyone starts to accuse me of trying to steal his glory, let me explain. The admin of a well sized board that I super-mod asked me to revise g-force2k2's warning system (it was already installed). I downloaded it, looked through it, and decided that I couldn't: he requested that people respect his hack, and not modify it. So, I didn't, and decided to take a swing at it. Since people don't like change, I made it look the same as the original, but work differently.

Features:
Expireable warnings. Each warning type has a default length and value. (can turn this off too)
Warning values can be selected by issuer as per severity of the offense. This can be disabled by the administrator; the default value of warning will be used.
Warning lengths can be selected by issuer as per severity of the offense. This can be disabled by the administrator; the default length of warning will be used.
Relatively quick install: a few file mods, template mods, and then running a script.
Email on warning option (Never, Issuer's choice, Always)
PM on warning option (Never, Issuer's choice, Always)
Email on banning option (yes, no)
Changeable banning threshold
Which usergroups can warn, which can view the sum, which can view all the warnings
Mostly template driven
Add, remove, edit warnings
Add, remove, edit warning types
Stronger admin interface.


That's all I can think of now....

Stats:
Queries added per page: 0
Queries modified: 3 (indirectly: $templatesused needs to be modified)
Queries extra per day: 3+ceil(TheNumberOfUsersWithPointsExpiringToday/10)
Files to modify: 3
Files to add: 3
Install time: 10-15 minutes


Stipulations
Support requests will take a bit (a day or two) to reply due to a somewhat tight schedule.
Please click Install if you use it
DO NOT install this if you have g-force2k2's hack in place. USE THE UPGRADE if you have g-force2k2's hack installed

The package is attached. Screenshots are zipped next. Please click install if you use it.

If you are upgrading from g-force2k2's verison, use MWS-Upgrade.txt, and warn-upgrade.php.

Beorn
05-31-2003, 02:53 AM
Screenshots:

Showthread admin or mod view (may change as per your settings)
Add warning
View User warnings
Warning list
ACP Options
ACP Add Warning Type
ACP View Warnings
ACP View Warning List

MentaL
05-31-2003, 11:55 AM
looks good. may use it in future

TomokiG
05-31-2003, 02:57 PM
Today at 01:55 PM mentalrz said this in Post #3 (https://vborg.vbsupport.ru/showthread.php?postid=402280#post402280)
looks good. may use it in future

Same here... just now I got g-force2k2's hack installed... perhaps I'll patch it myself ^^

?TomokiG?

Oblivion Knight
05-31-2003, 05:22 PM
This has a GREAT amount of potential, I love the expiry idea.
I may well revert to this from g-force2k2's version.

Today at 04:50 AM Beorn said this in Post #1 (https://vborg.vbsupport.ru/showthread.php?postid=402201#post402201)
If there are enough requests, I'll make a conversion script.


* Oblivion Knight requests a conversion script.

Koutaru
05-31-2003, 05:57 PM
The expiry idea is great! I was going to install the original warnings system but it wasn't quite like what I was looking for. I think this is though -- as long as it's proved stable ;)

TomokiG
05-31-2003, 10:40 PM
Just now I've finished translating and integrating the hack after deinstalling the old one ^^... although I had to retype the old warnings...

And I've to admit... this hack ist much better than the "original" one... Big THX...

°TomokiG°

N9ne
05-31-2003, 11:52 PM
This looks great, I thought about doing the same thing.

However I'll do the same thing with more for vB3 when its out if I have enough time :D

I've put all my hacking on hold now until vB3, I just can't wait for it...so I can hack it to pieces :D

Link14716
06-01-2003, 12:14 AM
I have installed this, however, the warn link is not showing up anywhere. Yes, I have followed the instructions to a T, but it is still not working correctly...

EDIT: Damn all these master switches that default to off! ;)

Link14716
06-01-2003, 12:29 AM
I found one error. In getinfo, the link to view warnings is wrong (the userid is missing) since it uses $post[userid]. To fix this, and have it work in both the postbit and in getinfo, open up member.php.
Find: if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsView)) {
Add Under: $post['userid'] = $userinfo['userid'];

Thanks for this great hack, Beorn!

EDIT: Also, you forgot to add the header to the new warning page, making it look terrible. To fix this, edit your warn_newwarn template.
Find:<body>
Add Under:$header

Erwin
06-01-2003, 06:03 AM
Looks good. I've got gforce2k's one installed too, but this one looks nice. :) Well done.

PixelFx
06-01-2003, 08:20 AM
sounds great, thanks for sharing :) I've currently got geforce2k's install. I'll prob stick with that for now. However great work non the less :)

dapence
06-01-2003, 08:28 AM
Mike did indeed do great job at the task of what I thought was a much needed replacement for g-force2k2's warning system we installed on our site. Thanks Again, Mike. :D

Beorn
06-01-2003, 04:28 PM
Yesterday at 09:29 PM Link14716 said this in Post #10 (https://vborg.vbsupport.ru/showthread.php?postid=402647#post402647)
I found one error. In getinfo, the link to view warnings is wrong (the userid is missing) since it uses $post[userid]. To fix this, and have it work in both the postbit and in getinfo, open up member.php.
Find: if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsView)) {
Add Under: $post['userid'] = $userinfo['userid'];
Eeep...I made that fix to the beta site (see 'dapence' above ;)), but I forgot to add it into the install file...I'll update it in a minute...

Thanks for this great hack, Beorn!
Thanks!

EDIT: Also, you forgot to add the header to the new warning page, making it look terrible. To fix this, edit your warn_newwarn template.
Find:<body>
Add Under:$header
Actually, I meant to leave it out...IMO it looks better....But you can put/leave it in if it so pleases you....

A conversion script will take a few days not only because I need to set up both hacks, but also because I need time to...I'm guessing about a week....

Link14716
06-01-2003, 04:55 PM
Today at 01:28 PM Beorn said this in Post #14 (https://vborg.vbsupport.ru/showthread.php?postid=402958#post402958)
Actually, I meant to leave it out...IMO it looks better....But you can put/leave it in if it so pleases you....

Trust me, the style that I use doesn't look right without the header. ;) Oh well, I added it anyways. :)

Oblivion Knight
06-03-2003, 02:19 PM
06-01-03 at 06:28 PM Beorn said this in Post #14 (https://vborg.vbsupport.ru/showthread.php?postid=402958#post402958)
A conversion script will take a few days not only because I need to set up both hacks, but also because I need time to...I'm guessing about a week....

Looking forward to it.. :)

Beorn
06-04-2003, 09:59 PM
It would help if I had the data and structure to the warnings and warnings_log table with g-force2k2's hack installed for a conversion....

Oblivion Knight
06-11-2003, 12:01 PM
06-04-03 at 11:59 PM Beorn said this in Post #17 (https://vborg.vbsupport.ru/showthread.php?postid=404515#post404515)
It would help if I had the data and structure to the warnings and warnings_log table with g-force2k2's hack installed for a conversion....

* Oblivion Knight thinks you'll need g-force2k2's permission for the data and structure to those tables..

I could be wrong.. :speechless:

ernestdefoe
06-13-2003, 08:31 PM
Is there a way to change the font and size of the text for the hack?

Reoplex
06-18-2003, 12:41 AM
this is a great hack, thanks man :)

sajjid
06-18-2003, 12:57 AM
Sajjid requests a conversion script.
:)

sonic3d
06-19-2003, 07:32 PM
is this hack stable enuff to use?

l8er
sonic

sajjid
06-23-2003, 04:04 PM
in your instruction step 1 you state OPEN global.php
which one ? one in forum dir or admin dir

Beorn
06-25-2003, 04:44 PM
06-23-03 at 01:04 PM sajjid said this in Post #23 (https://vborg.vbsupport.ru/showthread.php?postid=411947#post411947)
in your instruction step 1 you state OPEN global.php
which one ? one in forum dir or admin dir
All the paths are from the forum root, so that refers to the forum one.

is this hack stable enuff to use?
As far as I know, it is. The only

I'm going to send in an update in a minute. What you need to do is replace the files, and go to 'Resum' in the admin panel. That's all.

Now, the conversion script:
After (seemingly) everything that could possibly go wrong in my life, I think I'll have time for that conversion. I'll try to get it out by Friday (I hope).

Mike

Beorn
06-28-2003, 01:26 AM
Hello all,

I finally finished that upgrade script. If you have g-force2k2's Warning System (v. 2.0 or higher), you can use the upgrade instructions included in the package posted in the first post of this thread. If you are upgrading, use MWS-Upgrade.txt, and warn-upgrade.php.

I'll ask a mod to move this to the 'Full Releases' forum :).

Thank you everyone for beta testing. Please spread the word, and click Install if you install it. By clicking Install, you will receive updates when I do update it.

Oblivion Knight
06-28-2003, 09:15 AM
I've just upgraded from g-force2k2's mod, and so far everything seems to be running well.. :)

Just a little thing i picked up on with the upgrade instructions:
FIND:
---------------------------------
<BR>
$post[warnlink]
---------------------------------
ADD AFTER IT:
---------------------------------
$post[warnlink]
---------------------------------
CLOSE postbitI'm expecting that should be replace instead of add after, since there'd be no reason for wanting 2 instances of warnlink, and your code seems to add a <br> already.

Also.. I wouldn't recommend doing this step:
1. OPEN admin/template.php
FIND AND REMOVE:
---------------------------------
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
$only['warn'] = 'Warning System Hack';
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
---------------------------------
CLOSE admin/template.phpSince it leaves the templates without a category in the Default templates.. ;)

* Oblivion Knight clicks install.

Beorn
06-29-2003, 02:43 AM
Today at 06:15 AM Oblivion Knight said this in Post #26 (https://vborg.vbsupport.ru/showthread.php?postid=413648#post413648)
I'm expecting that should be replace instead of add after, since there'd be no reason for wanting 2 instances of warnlink, and your code seems to add a <br> already.
Yearh, it should be...fixed it...

Also.. I wouldn't recommend doing this step:
1. OPEN admin/template.php
FIND AND REMOVE:
---------------------------------
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
$only['warn'] = 'Warning System Hack';
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
---------------------------------
CLOSE admin/template.phpSince it leaves the templates without a category in the Default templates.. ;)

Again, my preferences seem different than those of others...I like it without...so I added a note saying that part is optional.

Finally, anyone who ran the upgrade before this post, please run this query, which I seemed didn't paste into the final upgrade file....but I'll do that now.

DELETE FROM template WHERE title IN('warn_warnlink','warn_viewlink','warn_userinfo' ,'warn_show_warn','warn_show','warn_seelink','warn _redirect_warnsuccess','warn_redirect_userban','wa rn_pmyes','warn_pmno','warn_pmemail_subject','warn _pmemail_notify','warn_listing','warn_list','warn_ Getinfo_warning','warn_error_whywarnself','warn_er ror_noexist','warn_error_nowarnings','warn_error_n oaccess','warn_error_maxwarnlimit','warn_error_emp tyreason','warn_error_cantwarngroup','warn_banemai l_subject','warn_banemail_notify','warn_add');

*sigh* Screw the wicked...there is no peace unto me...

Oblivion Knight
06-29-2003, 04:54 AM
Fair point to make I guess..
Ran the extra query, thanks for your support with this modification :)

sonic3d
06-29-2003, 03:51 PM
upgraded flawlessly. thanx.

l8er
sonic

Paris Holley
07-04-2003, 04:23 AM
when i add the code


$WarnUserGroups = explode(",",$WarnUserGroups);
$WarnUserGroupsView = explode(",",$WarnUserGroupsView);
$WarnUserGroupsSum = explode(",",$WarnUserGroupsSum);
$WarnUserGroupsUnwarnable = explode(",",$WarnUserGroupsUnwarnable);


while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {
if($WarnOnOff) {
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsSum)) {
eval("\$post['warninglvlwords'] = \"".gettemplate("warn_postbitsum")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsView)) {
eval("\$post['viewwarnings'] = \"".gettemplate("warn_postbitview")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroups) && !in_array($post['usergroupid'],$WarnUserGroupsUnwarnable)) {
eval("\$post['addwarning'] = \"".gettemplate("warn_postbitadd")."\";");
}

if($post['warninglvlwords'] || $post['viewwarnings'] || $post['addwarning']) {
eval("\$post[warnlink] = \"".gettemplate("warn_postbitaddin")."\";");
}
}


iget unexcept $ on the very last line.......which is after ?> which doesn't exsist

Soundr
07-05-2003, 01:23 PM
Hey, I just installed your hack, I have some questions though.

1. When you set a warning, lets say 3 points, and a expiry of 5 days, after 5 days will those warning points go? If this happens, how can I set unlimited days?
2. When you add a warning to teh user, you cannot see the header any more, how can I add the header and footer?

- Devnull

xpguy
07-05-2003, 08:49 PM
i cant find the get info template bit :S

4thgenresource
07-06-2003, 10:04 PM
07-05-03 at 10:49 PM xpguy said this in Post #32 (https://vborg.vbsupport.ru/showthread.php?postid=415555#post415555)
i cant find the get info template bit :S

It's under "User Info Display Templates"

4thgenresource
07-06-2003, 10:35 PM
Is there anyway to have, instead of days, also have a certain length of time, like 1 hour, 3 hours, etc..?

4thgenresource
07-07-2003, 02:10 AM
Okay I need help now....Whenever I anyone click's on a user's name, or the profile button, we're getting this error:

"Fatal error: Call to undefined function: checkwarnlink() in C:\Sites\BS Forums\member.php on line 1405"

:(

Beorn
07-07-2003, 04:26 PM
Paris Holley - It sounds like you added that code, not replaced it.

Soundr - Yeah, the points are eliminated (but the warning remains so you have a rap sheet on the user). For an infinite one, set the default length to -1. As to the header: open the warn_newwarning template. Find <body>, and add after it $header

4thgenresource - Yeah, it's possible to have < 1 day warnings, but there would be a few modifications involved. Also, it sounds like you didn't remove all of g-force2k2's old warning system. Open the upgrade instruction file, and go to step 5. Make sure you've done everything listed.

EWorld
07-08-2003, 05:14 AM
Mr. Mike .. umm how would I put

Warning Points: 13 (orwhatever they have) in the postbit?

Like under

POSTS:
POINTS:
WARING POITNS:

- Speedy

Beorn
07-08-2003, 02:31 PM
Well, Points and Warning Points are the same thing. To make the change (that I think) you would like, open the postbit template, remove the following (if it is there...it may or may not be depending on how far you got through the installation...)

| $post[warnlink]


Scroll up a bit in the postbit template, and find

Posts: $post[posts]


Add after that:

<br>$post[warnlink]


Additionally, you may want to edit warn_postbitaddin and add a <br> (line break) between each of $post[warninglvlwords] and $post[viewwarnings] and $post[addwarning].

Mike

kimbers
07-10-2003, 09:15 PM
I have a problem and i feel like a dork posting this but, when i add the $post[warnlink] nothing shows up in my templates and i set the warning system to on.

Beorn
07-10-2003, 11:29 PM
Did you modify showthread.php as per the instructions?

proxyMX
07-11-2003, 02:06 AM
i love this hack
used it to ban a hacker. not a vb hacker a bad guy "mess up your site" hacker

Tenpit
07-11-2003, 07:01 AM
With this hack installed it is now possible to warn a user more than once for the same post.

Would it be possible for the Add Warning link not to be displayed once a warning has already been added for that post? or at least make it not possible to warn for the same post more than once, with multiple moderators a single post can rack up the points when everyone warns for it.

Also, everytime a warning is issued, in the notification message it shows the warning will expire on Never, no matter what duration is entered, it allways says Never. This is only in the message, the actual warning does expire when it is supposed to.

Any suggestions?

Beorn
07-11-2003, 02:27 PM
Yesterday at 11:06 PM proxyMX said this in Post #41 (https://vborg.vbsupport.ru/showthread.php?postid=416844#post416844)
i love this hack
used it to ban a hacker. not a vb hacker a bad guy "mess up your site" hacker

Then you're using it for something far beyond the scope of it's purpose.

With this hack installed it is now possible to warn a user more than once for the same post.
That's intended. Occasionally someone may go back and make it more offensive. Some people also like to split up the warnings: i.e. one for 'racial slurs' and one for 'vulgar language'...

Would it be possible for the Add Warning link not to be displayed once a warning has already been added for that post? or at least make it not possible to warn for the same post more than once, with multiple moderators a single post can rack up the points when everyone warns for it.

Yes, however, it would require editting the query that gets the post, as well as the code added in for showthread.

Also, everytime a warning is issued, in the notification message it shows the warning will expire on Never, no matter what duration is entered, it allways says Never. This is only in the message, the actual warning does expire when it is supposed to.
Any suggestions?

One of two things I can think of:

Go to the options, go to Warning Expiration, and make sure "Always Expire" or "Issuer's Choice" is selected. If they already are, go to step 2...
Go to each warning, and see if they're all set to expire never. If they are, or most are, go to the options, and make sure Moderator Overide defaults is set to yes, or change the default length of the warnings.

kimbers
07-11-2003, 02:49 PM
Yesterday at 08:29 PM Beorn said this in Post #40 (https://vborg.vbsupport.ru/showthread.php?postid=416830#post416830)
Did you modify showthread.php as per the instructions?

Yes i did i followed the instructions to the letter.

Im wondering if i should just place a link there instead of useing the templates?

Tenpit
07-12-2003, 06:47 AM
Tenpit wrote:
Also, everytime a warning is issued, in the notification message it shows the warning will expire on Never, no matter what duration is entered, it allways says Never. This is only in the message, the actual warning does expire when it is supposed to.
Any suggestions?

--------------------------------------------------------------

Yesterday at 04:27 PM Beorn said this in Post #43 (https://vborg.vbsupport.ru/showthread.php?postid=416941#post416941)
One of two things I can think of:

Go to the options, go to Warning Expiration, and make sure "Always Expire" or "Issuer's Choice" is selected. If they already are, go to step 2...
Go to each warning, and see if they're all set to expire never. If they are, or most are, go to the options, and make sure Moderator Overide defaults is set to yes, or change the default length of the warnings.

Found the problem in warn.php

Find
if($length = -1) {
$end_date = "never";
}

Replace with
if($length == -1) {
$end_date = "never";
}

So must be affecting everyone else that has installed this hack.

Nice work btw, i like it a lot.

Beorn
07-12-2003, 01:08 PM
Harumph....another bug! :(

Yeah....I'm gonna update the files in a second....

Tenpit
07-12-2003, 01:21 PM
Yesterday at 04:27 PM Beorn said this in Post #43 (https://vborg.vbsupport.ru/showthread.php?postid=416941#post416941)
That's intended. Occasionally someone may go back and make it more offensive. Some people also like to split up the warnings: i.e. one for 'racial slurs' and one for 'vulgar language'...
With multiple mods i really didn't want them warning the same user for the same post because they hadn't checked to see if there was already a warning.

So i did the following.

In warn.php find:
} elseif($towarn['warninglvl'] >= $WarnBanThreshold) {
standarderror("Sorry, but that user already has $WarnBanThreshold points or more.");
}

Add the following after it:
$checkwarn = $DB_site->query_first("SELECT postid FROM warning WHERE postid='$postid'");
if($checkwarn[postid] != "" && $confirmwarn != 1) {
eval("standarderror(\"".gettemplate('warn_alreadywarned')."\");");
exit;
}
$confirmwarn = 0;


Create a new template called warn_alreadywarned with the following contents:
This user has already has a current warning for this post.

Do you <B>really</b> want to warn this user again for the same post?
<br><br>
<table border="0" cellspacing="0" cellpadding="0" width="100%"><tr>
<td align="left"><smallfont>
<a href="warn.php?s=$session[sessionhash]&action=new_warning&confirmwarn=1&postid=$post[postid]">[Continue with Warning] </a></smallfont></td>
<td align="right"><smallfont>
<a href="javascript:history.back(1)"> [Back to Thread]</a></smallfont></td></tr></table>

This checks to see if a post has already been warned when you click new warning. If it has, it presents you the option to continue with a new warning for the same post, or not.

Oblivion Knight
07-12-2003, 01:42 PM
Nice little addon Tenpit..
I may give it a whirl. I have staff that are eager to press the warn button, and ocasionally a user ends up warned twice for the same post.. ;)

Thanks for the bugfix too!

Shepski
07-15-2003, 08:36 AM
great hack. installed with no problems. just one point tho, when the system emails out the user to tell them they have been naughty the subject line is empty. this causes a problem for me as my mail server blocks any mail with a blank subject line. can I hardcode a subject line in and if so where as its obviously not picking up the template for subj?

Tenpit
07-15-2003, 01:18 PM
Today at 10:36 AM Shepski said this in Post #49 (https://vborg.vbsupport.ru/showthread.php?postid=417888#post417888)
great hack. installed with no problems. just one point tho, when the system emails out the user to tell them they have been naughty the subject line is empty. this causes a problem for me as my mail server blocks any mail with a blank subject line. can I hardcode a subject line in and if so where as its obviously not picking up the template for subj?

In warn.php find 2 occurrences of:
eval("\$mailed = vbmail(\"".addslashes($towarn['email'])."\",\"".addslashes($subject)."\",\"".addslashes($msg)."\");");

Replace both, with:
eval("\$mailed = vbmail(\"".addslashes($towarn['email'])."\",\"".addslashes($subj)."\",\"".addslashes($msg)."\");");

Blizzb
07-17-2003, 01:58 PM
I have this warning system installed and I set warnings to never expire. So after I warn someone, it said "forever" but the next day, it expired. For example: I warned someone on June 15. The next day I find that the warning was to be expired on June 14. And I set it to no expiration. So can anyone help me?

Xyphen
07-17-2003, 09:47 PM
this is pretty nice, mind telling us how to install the expiry stuff into g-forces hack? cuz i already got that installed and don't feel like uninstalling and installing urs over again.

drumsy
07-17-2003, 10:45 PM
Installed!! Great hack! :)

Oblivion Knight
07-18-2003, 06:15 AM
Yesterday at 11:47 PM AViO 07 said this in Post #52 (https://vborg.vbsupport.ru/showthread.php?postid=418568#post418568)
this is pretty nice, mind telling us how to install the expiry stuff into g-forces hack? cuz i already got that installed and don't feel like uninstalling and installing urs over again. Wrong thread to get support for g-force's hack.. ;)
I think that was pretty much the main point of releasing a new version - for the expiry timing, and to clean a few things up template and coding wise.

Blizzb
07-18-2003, 01:40 PM
Can anyone answer my question?

Blizzb
07-19-2003, 10:33 PM
Somebody please answer my question!!!!

Beorn
07-20-2003, 12:57 AM
Please post the warning config in the vBulletin options, as well as the information about the specific warning type you used....

Oblivion Knight
07-20-2003, 09:30 AM
Hi again Beorn,
It would appear I've stumbled upon another bug..

When giving someone a warning (in the add new warning window), the "Send a PM" and "Send an e-mail" checkboxes can't be checked.. :eek:

Note that I followed the UPGRADE instructions, and I haven't noticed this bug until now because I haven't needed to warn anyone until now.

Beorn
07-20-2003, 12:25 PM
Are you sure it's a bug? Go to the options, and make sure Send E-mail on Warning and Send PM on Warning are set to something other than "Don't Send"

Oblivion Knight
07-21-2003, 07:29 AM
Oh right, so because I have them set on "Always Send", they're blanked out, but will always send.. Cool, sorry for the confusion.. :o

Blizzb
07-21-2003, 02:12 PM
Here is what happened. In vBulletin options, I checked "Never Expire" for warning points. And I set all warnings length to 0, which means forever. Then I gave someone warning points and it said "forever" in warning length. Then the next day, I found that the warning had expired and the expiration date was the day before the warnings were issued. And when I prolonged the length into 2000 days, and after a day, the warning value decreased. I think this is abug.

partang2
07-26-2003, 07:19 PM
Ok, I tried to install this one today, but I'm having some serious trouble here.... The installation did go ok, but the links in the adminpanel and in postbit will not show up at all..!?

I have trippel checked that I have done everything by the book.

Please help me with this one!

Blizzb
08-06-2003, 12:49 PM
/me clicks uninstall

Link14716
08-06-2003, 02:08 PM
There are bugs. It's a beta. Live with it.

0 doesn't mean forever. Set it to 99999 or something if you want that.

partang2
08-06-2003, 04:03 PM
*partang2 clicks uninstall too...

Blizzb
08-06-2003, 04:23 PM
Even if you set it to 99999 the warning value decreases. And it's not beta. It's a full release. And this hacker has agreed to provide support for this hack.

Oblivion Knight
08-06-2003, 05:04 PM
Today at 06:23 PM Blizzb said this in Post #66 (https://vborg.vbsupport.ru/showthread.php?postid=423849#post423849)
And this hacker has agreed to provide support for this hack. Which doesn't mean they have agreed to sit in front of a monitor all day and keep a watch over the topic 24/7. People do have other commitments than providing support for us at vB.org, please appreciate that.

Be patient and I'm sure your question will be answered in time once somebody finds a fix for your problem.

Beorn
08-06-2003, 06:00 PM
Blizzb: -1 means forever, 0 means nothing.

I'm sorry I can't provide instantaneous support. I even wrote in the first post that it may take a few days, or even a week to reply.

partang2: did you go to the options and make sure to turn the warning system on? It's set to off by default in the case you have a weird usergroup setup...

Mike

volitaire
08-08-2003, 05:11 PM
for some reason all my mods can change the values of the warnings / times even tho in the admin cp i have it set so they cant overide the defaults.. any ideas?

Beorn
08-08-2003, 05:18 PM
:-\

Are they in the normal mod user groups (5 and 7)?

volitaire
08-09-2003, 07:31 PM
no.. theyre like 21/24/36/37 etc.. i have like 10 mod groups to seperate different types of mods / users

is there a place somewhere where i can change it? if you have it set to not give full powers to?

Beorn
08-10-2003, 03:12 AM
Around line 39, find this:

if(!$WarnModOverrideDefault && in_array($bbuserinfo['usergroupid'],array(5,7))) {
Change the array to hold the correct user groups for mods...

volitaire
08-10-2003, 03:26 AM
thanks!, i was looking for that but for some reason coudln't see it

Morgalis
08-15-2003, 08:40 AM
alright.. i've done some hacking and this crosses over into it

i don't know enough about php to make the confident edits to make this hack work alongside the others

this replacement in showthread.php

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {


is this according to the hack

// Copyright ? 2003 Michael Benza. All Rights Reserved
// http://www.benza.us

$WarnUserGroups = explode(",",$WarnUserGroups);
$WarnUserGroupsView = explode(",",$WarnUserGroupsView);
$WarnUserGroupsSum = explode(",",$WarnUserGroupsSum);
$WarnUserGroupsUnwarnable = explode(",",$WarnUserGroupsUnwarnable);


while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {
if($WarnOnOff) {
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsSum)) {
eval("\$post['warninglvlwords'] = \"".gettemplate("warn_postbitsum")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsView)) {
eval("\$post['viewwarnings'] = \"".gettemplate("warn_postbitview")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroups) && !in_array($post['usergroupid'],$WarnUserGroupsUnwarnable)) {
eval("\$post['addwarning'] = \"".gettemplate("warn_postbitadd")."\";");
}

if($post['warninglvlwords'] || $post['viewwarnings'] || $post['addwarning']) {
eval("\$post[warnlink] = \"".gettemplate("warn_postbitaddin")."\";");
}
}
// END WARNING SYSTEM!


what mine really looks like is this

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

if ($postdone[$post[postid]]) {
$counter--;
continue;
} else {
$postdone[$post[postid]]=1;
}

$onlinestat = "";
if(($post[miserable] == 1) || ($post[stunned] & 4)){
if(($bbuserinfo[usergroupid] == 5) or ($bbuserinfo[usergroupid] == 6) or ($bbuserinfo[usergroupid] == 7)) {
$onlinestat = "$onlinestat<br><font color=\"red\"><b>Miserable User</b></font>";
}
}
$post[posts]="$post[posts]$onlinestat";


how do i encorporate the two hacks? i am forgoing this part of miserable users [i LOVE that hack] while i am waiting for some help in this thread

Morgalis
08-15-2003, 09:40 AM
youch.. ran into another major problem! o.O

i have commented it all out as i can do without the expiring for the time being

when i add this in following
$header='';
$footer='';

// ###################### Start Decrease Warning Points ######################


i lose my forum style!!

I have vbportal hacked in so this must tie in somewhere.. imagine my surprise when my forums are reverted to the default and no header

i can live without expiring warnings, but i would rather have them

thanks in advance and cheers!

* Morgalis installs.. well most of it anyway ;)

Beorn
08-15-2003, 11:20 AM
Today at 05:40 AM Morgalis said this in Post #74 (https://vborg.vbsupport.ru/showthread.php?postid=426156#post426156)
alright.. i've done some hacking and this crosses over into it

i don't know enough about php to make the confident edits to make this hack work alongside the others

how do i encorporate the two hacks? i am forgoing this part of miserable users [i LOVE that hack] while i am waiting for some help in this thread


I'm not sure what the problem is. Change the while line to the about 20 lines provided in the hacking instructions...

drumsy
08-19-2003, 10:58 PM
Is there any problems with 2.3.2? I'm trying to install it and it's just bogging my server down!! :(

Oblivion Knight
08-19-2003, 11:37 PM
Today at 12:58 AM drumsy said this in Post #77 (https://vborg.vbsupport.ru/showthread.php?postid=427207#post427207)
Is there any problems with 2.3.2? I'm trying to install it and it's just bogging my server down!! :( No problems here on 2.3.2.! :classic:

DeadGaze
08-20-2003, 03:05 PM
well done m8...this will come in to very good use

Thank you

drumsy
08-20-2003, 04:31 PM
Yesterday at 08:37 PM Oblivion Knight said this in Post #78 (https://vborg.vbsupport.ru/showthread.php?postid=427224#post427224)
No problems here on 2.3.2.! :classic:

Very very weird. It spikes my server load up to an insane load when I get it all installed! :(

Beorn
08-20-2003, 10:49 PM
The only thing that I can think may be causing it is a few queries running that shouldn't be.

Open global.php. Find:
if($today > $last_warn_update && $WarnOnOff) {
Add after it, but put in your e-mail address:
mail("my@emailaddress.com","Updating","Updating warnings at timestamp: ".time());

Upload the file, browse your forums for 5 minutes, then reupload the file without that line. If that is where the problem is, you should get a bunch of e-mails. If not, you won't. Let me know what the result is.

Morgalis
08-22-2003, 05:40 AM
08-15-03 at 01:20 PM Beorn said this in Post #76 (https://vborg.vbsupport.ru/showthread.php?postid=426167#post426167)
I'm not sure what the problem is. Change the while line to the about 20 lines provided in the hacking instructions...

if i am to understand correctly i would change this code


while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

if ($postdone[$post[postid]]) {
$counter--;
continue;
} else {
$postdone[$post[postid]]=1;
}

$onlinestat = "";
if(($post[miserable] == 1) || ($post[stunned] & 4)){
if(($bbuserinfo[usergroupid] == 5) or ($bbuserinfo[usergroupid] == 6) or ($bbuserinfo[usergroupid] == 7)) {
$onlinestat = "$onlinestat<br><font color=\"red\"><b>Miserable User</b></font>";
}
}
$post[posts]="$post[posts]$onlinestat";


to this code?

// Copyright ? 2003 Michael Benza. All Rights Reserved
// <a href="http://www.benza.us" target="_blank">http://www.benza.us</a>

$WarnUserGroups = explode(",",$WarnUserGroups);
$WarnUserGroupsView = explode(",",$WarnUserGroupsView);
$WarnUserGroupsSum = explode(",",$WarnUserGroupsSum);
$WarnUserGroupsUnwarnable = explode(",",$WarnUserGroupsUnwarnable);

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

if($WarnOnOff) {
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsSum)) {
eval("\$post['warninglvlwords'] = \"".gettemplate("warn_postbitsum")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroupsView)) {
eval("\$post['viewwarnings'] = \"".gettemplate("warn_postbitview")."\";");
}
if(in_array($bbuserinfo['usergroupid'],$WarnUserGroups) && !in_array($post['usergroupid'],$WarnUserGroupsUnwarnable)) {
eval("\$post['addwarning'] = \"".gettemplate("warn_postbitadd")."\";");
}

if($post['warninglvlwords'] || $post['viewwarnings'] || $post['addwarning']) {
eval("\$post[warnlink] = \"".gettemplate("warn_postbitaddin")."\";");
}

if ($postdone[$post[postid]]) {
$counter--;
continue;
} else {
$postdone[$post[postid]]=1;
}

$onlinestat = "";
if(($post[miserable] == 1) || ($post[stunned] & 4)){
if(($bbuserinfo[usergroupid] == 5) or ($bbuserinfo[usergroupid] == 6) or ($bbuserinfo[usergroupid] == 7)) {
$onlinestat = "$onlinestat<br><font color=\"red\"><b>Miserable User</b></font>";
}
}
$post[posts]="$post[posts]$onlinestat";
// END WARNING SYSTEM!


one bracket can mess everything up, i want to be certain i am doing this correct

Morgalis
08-22-2003, 05:41 AM
08-15-03 at 11:40 AM Morgalis said this in Post #75 (https://vborg.vbsupport.ru/showthread.php?postid=426159#post426159)
youch.. ran into another major problem! o.O

i have commented it all out as i can do without the expiring for the time being

when i add this in following
$header='';
$footer='';

// ###################### Start Decrease Warning Points ######################


i lose my forum style!!

I have vbportal hacked in so this must tie in somewhere.. imagine my surprise when my forums are reverted to the default and no header

i can live without expiring warnings, but i would rather have them

thanks in advance and cheers!

* Morgalis installs.. well most of it anyway ;)


this is still an issue which does not allow me to fully use this back

can you comment on it?

Beorn
08-22-2003, 12:42 PM
Today at 02:40 AM Morgalis said this in Post #82 (https://vborg.vbsupport.ru/showthread.php?postid=427829#post427829)


one bracket can mess everything up, i want to be certain i am doing this correct [/B]


No, that is not correct. Start with the code you have BEFORE installing the hack. REPLACE the line
while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

with the code provided in the instructions.

this is still an issue which does not allow me to fully use this back

can you comment on it?
The instructions do not say to add $header='';
$footer=''; anywhere. You want to add code after that.

Morgalis
08-23-2003, 03:01 PM
maybe i have not made myself clear, let me try again :)

i NEED to keep this code in, as it is part of another hack


$onlinestat = "";
if(($post[miserable] == 1) || ($post[stunned] & 4)){
if(($bbuserinfo[usergroupid] == 5) or ($bbuserinfo[usergroupid] == 6) or ($bbuserinfo[usergroupid] == 7)) {
$onlinestat = "$onlinestat<br><font color=\"red\"><b>Miserable User</b></font>";
}


I cannot just leave that out or the functionality of another hack will not work

are you saying that all of your code should go before that if statement and to only keep that if statement there?

in respect to adding the code in after this

$header='';
$footer='';


when i do that, i lose my forum style.. i am not adding that in, i am referring to when i add in the code that is provided

again, i use vbPortal and wonder if that has affected this hack

i'm trying to understand this, it's just a little tricky once you have other hacks involved

Beorn
08-24-2003, 10:54 PM
Please PM me your showthread.php. My e-mail address will be in your inbox...

Exo
08-26-2003, 11:34 PM
when will the next version released?

ciaranirl
09-06-2003, 08:51 PM
How do you change the text size in it?

Beorn
09-06-2003, 09:48 PM
Today at 05:51 PM ciaranirl said this in Post #88 (https://vborg.vbsupport.ru/showthread.php?postid=431830#post431830)
How do you change the text size in it?


Use <smallfont></smallfont> and <normalfont></normalfont> in the templates...

lasto
09-06-2003, 09:53 PM
can we choose any usergroup to ban em to ?

say i never wanted em to go to total ban but had certain bits of board restricted is this possible

ciaranirl
09-06-2003, 10:59 PM
Yesterday at 11:48 PM Beorn said this in Post #89 (https://vborg.vbsupport.ru/showthread.php?postid=431839#post431839)
Use <smallfont></smallfont> and <normalfont></normalfont> in the templates...


Where abouts in the template. Just giving a code and saying in the templates isnt very helpful :speechless:

What I mean is this "Warning Level: 0" I want to change that to small. I have done everything I can think off. But it is still large. Kinda like 12 or 10 point

Beorn
09-06-2003, 11:47 PM
can we choose any usergroup to ban em to ?

say i never wanted em to go to total ban but had certain bits of board restricted is this possible

Yes, set Banned Usergroupid in the options to the user group you want banned members to be moved to. If you so please, you could even move them to administrative positions, but somehow I don't think you'd like that. ;)


Where abouts in the template.

Sorry. Go to the warn_postbitaddin template. Add <smallfont> on the front of it, and </smallfont> on the end. If that's not what you're looking for, remove those, and add <normalfont> to the front and </normalfont> to the end. If that still isn't what you're looking for, add this to the front of warn_postbitaddin:
<span style="font-size: 10pt">

And add this to the end:

</span>

TutorialForums
09-16-2003, 05:12 AM
I noticed a few minor problems that may have caused some issues for some users...

In the MWS-Upgrade.txt, it instructs at the end to upload...
The modified versions of:
admin/index.php
admin/functions.php
admin/template.php
global.php

... but member.php & showthread.php were left out. To the tired hack-installer who just wants to get finished installing and on with life, and thus follows the exact instructions he reads, it may slip his mind that not all the needed files are listed.
I believe the absence of member.php is what caused drumsy's insane server load (https://vborg.vbsupport.ru/showpost.php?p=427373&postcount=80) problem (the same happened to me, and the problem was gone the moment I uploaded member.php).... before I uploaded it, my load on my finely tuned dedicated server (with dual scsi drives, 1gb ram, dual-xeon 2ghz processors)... was instantly over 25 points.

The absence of showthread.php makes the warnings/options not show up in posts, potentially causing a wild goose chase to figure out what's gone wrong hehe


Anyhow on another note.... would it be possible to have the Warning Level: 0 be automatically masked out on the posts of moderators/admins? It's not an especially big deal, though it would be an improvement, as having it shown implies to members that the forum staff can be warned, which could potentially degrade their awe/respect for them a bit (well, hypothetically).

Thanks!

Jakor Sevel
10-25-2003, 12:37 AM
I installed it and it works fine.

But when i modify the member.php i get a blank member profile page and the Warning Options give me "The requested URL /forums/admin/admin_warning.php was not found on this server."

and in the pm when it says The post for which you were warned is located at:
the link shows an empty page.
http://www.nemxx.net/forums/showthread.php?s=&action=showpost&postid=4949


someone please try to help.

And thanx so much for this hack. It's great

Burley
10-25-2003, 10:48 PM
FIrst of a great hack, install went flawless and i'm a incredible noob!

but i can't find the numbers of the usergroups my forum uses. Can someone tell me how & where to find em?

Beorn
10-26-2003, 12:14 AM
Jakor Sevel, are you sure you followed the instructions in the install file correctly? Did you try again? I can't quite remember exactly what the modifications were, so I'd just like you to make sure before I start off an official investigation...

Burley: go to http://www.yoursite.com/forums/admin/usergroup.php?action=modify. Maximize your broswer window. Hover over the 'edit' link for each group to find it's id -- the id is on the 'usergroupid=x' part of the URL.

Jakor Sevel
10-26-2003, 04:06 AM
Yes, i have checked and everything in the instructions have been done except member.php, since it gives me a blank page. I'm not too worried about that coz if i'm not wrong, that just add a place for the warning amount in member profile.

About the warning options, i'm sorry i think that is from a previous hack that i installed but didnt work.

And the PM still doesnt work.

Burley
10-28-2003, 12:07 PM
okay, thanks!

PranK
11-03-2003, 05:51 AM
i dig it. nice work Mike.

*clicks install*

exTracT
11-04-2003, 01:33 AM
great hack, one of the best additions we've made yet. one small question. when a user gets banned by points and is moved into the "banned by moderaters" group, their user title stays the same. it doesnt show banned.

exTracT
11-04-2003, 01:45 AM
I did some testing.

When i goto the banned by warnings user and save settings his account it changes his user title to banned.

when i update the counters for user titles it also changes the users name to banned.

but it does not change the user group automatically after the user has been banned

Spiro
11-06-2003, 12:12 AM
hey man, im getting this error in the top of all my threads, and in alot of em i cant get in, any idea

ERROR:
Warning: Cannot modify header information - headers already sent by (output started at /home/ffx2com/public_html/global.php:435) in /home/ffx2com/public_html/admin/functions.php on line 1881

C.Birch
11-11-2003, 08:54 PM
i get a database error when i try to edit someones usergroup that as been banned by the system, also can it be made so when a warning runs out that puts them back under the banning total there auto unbanned?

the error i get is below btw:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1983-03-24',options='15',usergroupid='2',username='~*~Vick y_Bob~*~',email='psychadelicwildchild@hotmail.com' ,styleid='1',parentemail='',coppauser=0,homepage=' http://',icq='',aim='',yahoo='',signature=':angel: See my halo,bright \'n\' shiney,mess wiv me, \'n\' I\'ll kick you\'re hiney :bum:
:bum:\"We are the Cheeky Girls-Touch My Bum\":bum:

Bah! As if you\'d wanna touch their asses! :p
~~~~~~~~~~~~~~~~~~~~~~~~
:wave: To Lil Miss No Pea\'s :augh:[sig=954]

[sig=874]
:banana: Nev \'n\' Norma,Fab \'n\' groovy,The only narna\'s that can boogie!:banana:',adminemail=1,showemail=0,invisibl e=0,usertitle='<img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\"> Northern Nutter! <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\">',customtitle=1,joindate=UNIX_TIMESTAMP('2003-05-15 05:32:23'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-11 21:44:05'),lastactivity=UNIX_TIMESTAMP('2003-11-11 22:22:48'),lastpost=UNIX_TIMESTAMP('2003-11-11 20:41:05'),posts='4170',timezoneoffset='0',emailno tification=0,receivepm='1',emailonpm='0',ipaddress ='80.194.33.204',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=1997
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 '=1,pmpopup,'') WHERE userid=1997' at line 1

mysql error number: 1064

Date: Tuesday 11th of November 2003 10:35:36 PM
Script: http://forums.lisascottlee.com/admin/user.php
Referer:

mcyates
11-15-2003, 09:47 PM
everything works EXCEPT the link it the postbit.

drumsy
11-24-2003, 05:36 PM
I noticed a few minor problems that may have caused some issues for some users...

In the MWS-Upgrade.txt, it instructs at the end to upload...
The modified versions of:
admin/index.php
admin/functions.php
admin/template.php
global.php

... but member.php & showthread.php were left out. To the tired hack-installer who just wants to get finished installing and on with life, and thus follows the exact instructions he reads, it may slip his mind that not all the needed files are listed.
I believe the absence of member.php is what caused drumsy's insane server load (https://vborg.vbsupport.ru/showpost.php?p=427373&postcount=80) problem (the same happened to me, and the problem was gone the moment I uploaded member.php).... before I uploaded it, my load on my finely tuned dedicated server (with dual scsi drives, 1gb ram, dual-xeon 2ghz processors)... was instantly over 25 points.

The absence of showthread.php makes the warnings/options not show up in posts, potentially causing a wild goose chase to figure out what's gone wrong hehe


Anyhow on another note.... would it be possible to have the Warning Level: 0 be automatically masked out on the posts of moderators/admins? It's not an especially big deal, though it would be an improvement, as having it shown implies to members that the forum staff can be warned, which could potentially degrade their awe/respect for them a bit (well, hypothetically).

Thanks!

Hmmm, good call. I'll see if I can set this back up tonight! :thumbup:

Jakor Sevel
12-13-2003, 01:57 AM
Someone has informed me that the Warning Level = 0 remains at 0 even after a person has been warned. I checked all the instructions and its all in order. how can i fix that?

etones
12-18-2003, 10:37 PM
really great hack. Im also using geforces but this looks to have alot, if not more potential.

Any chance of an updated for version 3? :)


Cheers
Taz

msimplay
01-17-2004, 04:11 PM
I'd like this version made for Vbulletin 3 i currently am using erwins version but none of the new versions are as good as this one

that i used for ages for vb2.x.x

Kaelon
01-20-2004, 12:32 PM
This is a great hack. I've enjoyed it immensely. Does anyone know how to enable users to see their own warning system?

msimplay
01-20-2004, 05:27 PM
This is a great hack. I've enjoyed it immensely. Does anyone know how to enable users to see their own warning system?
its in ur admin cp settings

Kaelon
01-20-2004, 07:05 PM
Thanks, but this option allows users to see all warnings, not just their own. I did fix this manually, however, and people interested in the fix can do the following:

Change line 111 in warn.php to:

if((!in_array($bbuserinfo['usergroupid'],$canview)) AND ($bbuserinfo['userid'] != $userid)) {

Question -- does anyone know of a modification that will allow "generic" warnings, unrelated to posts? (For example, to assign warning based upon conduct over IMs or IRC?)

msimplay
01-20-2004, 08:27 PM
this is one of the hacks that makes me wanna go back to vb2 :(

Kaelon
01-26-2004, 07:47 PM
I'm getting the same error that C.Birch described below. Can anyone comment on how this is fixed?

More importantly, I removed the warning that had put someone in banning range, in an attempt to move them away from that usergroup onto a standard usergroup so that I could edit some user details - but I was still getting the error. Any thoughts?

Thanks,
Kaelon

i get a database error when i try to edit someones usergroup that as been banned by the system, also can it be made so when a warning runs out that puts them back under the banning total there auto unbanned?

the error i get is below btw:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1983-03-24',options='15',usergroupid='2',username='~*~Vick y_Bob~*~',email='psychadelicwildchild@hotmail.com' ,styleid='1',parentemail='',coppauser=0,homepage=' http://',icq='',aim='',yahoo='',signature=':angel: See my halo,bright \'n\' shiney,mess wiv me, \'n\' I\'ll kick you\'re hiney :bum:
:bum:\"We are the Cheeky Girls-Touch My Bum\":bum:

Bah! As if you\'d wanna touch their asses! :p
~~~~~~~~~~~~~~~~~~~~~~~~
:wave: To Lil Miss No Pea\'s :augh:[sig=954]

[sig=874]
:banana: Nev \'n\' Norma,Fab \'n\' groovy,The only narna\'s that can boogie!:banana:',adminemail=1,showemail=0,invisibl e=0,usertitle='<img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\"> Northern Nutter! <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\">',customtitle=1,joindate=UNIX_TIMESTAMP('2003-05-15 05:32:23'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-11 21:44:05'),lastactivity=UNIX_TIMESTAMP('2003-11-11 22:22:48'),lastpost=UNIX_TIMESTAMP('2003-11-11 20:41:05'),posts='4170',timezoneoffset='0',emailno tification=0,receivepm='1',emailonpm='0',ipaddress ='80.194.33.204',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=1997
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 '=1,pmpopup,'') WHERE userid=1997' at line 1

mysql error number: 1064

Date: Tuesday 11th of November 2003 10:35:36 PM
Script: http://forums.lisascottlee.com/admin/user.php
Referer:

Kaelon
01-26-2004, 07:57 PM
This appears to be a malformed query:

Invalid SQL: UPDATE user SET birthday='1971-05-23',options='15',usergroupid='10',username='Melega unt Tanthul',email='Bevin_van_liempt@hotmail.com',styl eid='0',parentemail='',coppauser=0,homepage='http://s3.invisionfree.com/The_Grand_Realms/',icq='309268104',aim='Whiterose1234321',yahoo='', signature='White pants, white shirt , white gloves, white boots, white hair, and white eyes (glowing). His beloved warlord sword, \"Demonslayer\" is elven steel, white, glittering, and bears the likeness of a whiterose. It\'s sheath is white elven steel. Its hilt is sweat absorbant.',adminemail=1,showemail=1,invisible=0,u sertitle='The Noble Elf of Trelore',customtitle=2,joindate=UNIX_TIMESTAMP('20 03-12-24 03:18:11'),cookieuser=1,nosessionhash=1,daysprune= '1000',lastvisit=UNIX_TIMESTAMP('2004-01-25 20:15:18'),lastactivity=UNIX_TIMESTAMP('2004-01-25 20:43:15'),lastpost=UNIX_TIMESTAMP('2004-01-25 15:22:19'),posts='97',timezoneoffset='-8',emailnotification=0,receivepm='1',emailonpm='1' ,ipaddress='206.116.243.178',pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE userid=12221
mysql error: You have an error in your SQL syntax near '=1,pmpopup,'') WHERE userid=12221' at line 1

Any thoughts?

Meirion
02-02-2004, 11:04 AM
Hi, firstly thanks for these wicked ammendments Mike, that makes a near perfect warnings hack!

However I'm having a few problems after having it installed for a few weeks.

Someone was warned on our forum and recieved 12 points (automatic ban) for a post. However a week later it shows their points has dropped down to 0 and the warning expiry date has set itself to 31/12/1969!?
Their warning list is here... http://www.gurn.net/forums/warn.php?s=&action=view_user&userid=7885
Another mod has since re-added the points to this user.
It is only on people who've received a 12 point automatic-ban that it's happened to. another one - http://www.gurn.net/forums/warn.php?s=&action=view_user&userid=10880

Any ideas?

One thing is that our instant ban (12 points) warning we set an expiry date of 99999 days - because "-1" was confusing people. I noticed this had changed to 32767, presumablably because of the column size in mySQL, so I changed them to 9999 days.

Additional features...
would it be possible to make the 'View Warnings' list in the admin section be sortable by the column headings? In-particular by date.

automatically CC another email address every time a warnings email is sent to a board member?

Barto
02-02-2004, 11:12 AM
I have the same problem whit the version 2.3.4.
Please help me.

I get a database error when i try to edit someones usergroup that as been banned by the system, also can it be made so when a warning runs out that puts them back under the banning total there auto unbanned?

the error i get is below btw:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1983-03-24',options='15',usergroupid='2',username='~*~Vick y_Bob~*~',email='psychadelicwi ldchild@hotmail.com',styleid='1',parentemail='',co ppauser=0,homepage='http://',icq='',aim='',yahoo='',signature=':angel: See my halo,bright \'n\' shiney,mess wiv me, \'n\' I\'ll kick you\'re hiney :bum:
:bum:\"We are the Cheeky Girls-Touch My Bum\":bum:

Bah! As if you\'d wanna touch their asses!
~~~~~~~~~~~~~~~~~~~~~~~~
:wave: To Lil Miss No Pea\'s :augh:[sig=954]

[sig=874]
Nev \'n\' Norma,Fab \'n\' groovy,The only narna\'s that can boogie!',adminemail=1,showemail=0,invisible=0,user title='<img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\"> Northern Nutter! <img src=\"images/smilies/pinkie.gif\" border=\"0\" alt=\"\">',customtitle=1,joindate=UNIX_TIMESTAMP('2003-05-15 05:32:23'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2003-11-11 21:44:05'),lastactivity=UNIX_TIMESTAMP('2003-11-11 22:22:48'),lastpost=UNIX_TIMESTAMP('2003-11-11 20:41:05'),posts='4170',timezoneoffset='0',emailno tification=0,receivepm='1',ema ilonpm='0',ipaddress='80.194.33.204',pmpopup=IF(pm popup=2 AND =1,pmpopup,'') WHERE userid=1997
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 '=1,pmpopup,'') WHERE userid=1997' at line 1

mysql error number: 1064

Date: Tuesday 11th of November 2003 10:35:36 PM
Script: http://forums.lisascottlee.com/admin/user.php
Referer:

Meirion
02-02-2004, 11:24 AM
I forgot to mention, I am using VB version 2.3.2

Barto
02-05-2004, 04:27 PM
Someone to help us?????

Barto
02-14-2004, 03:06 PM
Up

Please it's important

Meirion
02-15-2004, 11:59 AM
The Author agreed to give support for this hack!

C'mon Mike!

Ferghal
02-29-2004, 09:33 AM
Will this hack be released for vb3?

joeychgo
03-08-2004, 10:20 PM
good question.........is there a 3.0 version of this hack?

]|fre$h-LoRd|[
03-12-2004, 11:10 AM
A great hack, thx!

drumsy
03-15-2004, 05:17 PM
I need this for vB3 please! :)

Beorn
06-29-2004, 02:58 AM
That is certainly a malformed query. I've looked through the hack just to refresh my memory, and there are no references to admin/user.php, so I'm not quite sure how my hack affects that.

I'm going to be writing an updated version for vB3 this week. Should I research the DB error people have encountered, or should I merely continue with the vB3 version?

I sincerely apologize for not being able to tend to this hack as I said I would. vB hacking isn't something I do often, so consequently I rarely visit the site, and I forgot to subscribe to the thread. In the future, I will support it to the best of my ability.

- Mike Benza

jamesk
07-15-2004, 03:09 AM
Not to beat a dead horse. But somebody pleeease do this for VB3.

LancerForums
07-22-2004, 12:46 AM
Not to beat a dead horse. But somebody pleeease do this for VB3.
I'll second that... we could really use a system like this as it manages things fairly (expiring warnings, etc).

Mark

yahoooh
07-31-2004, 06:50 PM
i need this hack to my forum 2.3.4
is it work correctly ?
if not plz fix it for us

Tom1234
08-02-2004, 02:48 PM
In the warn_notifymsg template, $warningtype[title] is used, but I would also like the warning type "description" available to use here. Is it available? If so, what is the variable name? Thanks.