Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture

[Erwin]

Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture - Version 1.1

Okay, this is my private forum's custom warning/ suspension/ banning system and postbit moderator system. This is a fairly involved hack, so it is crucial that you follow the instructions closely. :) It would benefit experienced hackers the most. The following instructions are for an unhacked board. If you have hacked your board, or use different moderator usergroups, just make the appropriate changes.


With this hack, your staff and you will be able to:

1) Add/ Substract/ Reset Warning Points for a Member from a Popup Window in Postbit.

2) When the Member has Warning Points that reach a set level (up to you), the Member will be Automatically Banned.

3) Easily View a Member's Warning Points in the Postbit.

4) Have the ability to easily Edit a Member's Avatar/ Profile Pic/ Sig/ Reputation comments from a Popup Window in Postbit.

5) Suspend temporarily or Ban permanently a Member from a Popup Window in Postbit.

6) Have 2 categories of Banned Members -

..... a) Normal Banned members where the posts all remain, and

..... b) Troll Banned members, where all the posts in this usergroup

.......... i) Automatically becomes Invisible from all other members! You no longer have to manually search and delete their posts. They virtually disappear from your forums when they get put in this usergroup. Also, Troll Banned members get

.......... ii) Fake 404 errors and can no longer access your site. ;)


Please be aware that this hack is designed for my private forums. If you want additional features, or customization, you have permission to do this yourself. Please do not expect me to customize this hack for your site. :)

FWIW, I've had this system running for 2 years now (obviously with different code). Time for me to share... ;)

The installation instructions are in the HTML file in the ZIP file below. The warn.php is also in the ZIP file.


Screenshots:

1. Options available with the dropdown menu for staff.

https://vborg.vbsupport.ru/attachment.php?attachmentid=15463


2. Popup window from postbit to warn members.

https://vborg.vbsupport.ru/attachment.php?attachmentid=15466


3. Popup window from postbit to suspend or ban members.

https://vborg.vbsupport.ru/attachment.php?attachmentid=15465


4. Popup window from postbit to edit signature.

https://vborg.vbsupport.ru/attachment.php?attachmentid=15468


5. Popup window from postbit to edit avatar.

https://vborg.vbsupport.ru/attachment.php?attachmentid=15469


NOTE: You can also edit profile pictures, reputation comments, etc. but I can't be bothered making screenshots of all the features. ;)

Enjoy! :)

With Erwin's Permision I've made an HTL Version of this hack.

HTL version (thanks to Dan) here:

Attached Fileshttps://vborg.vbsupport.ru/Warning_System_Automatic_Ban_Make_Posts_Invisible_ Edit_Signature_Avatar.htl (https://vborg.vbsupport.ru/attachment.php?attachmentid=16653)

Normal version here:

[Link14716]

Think you have a long enough title?

And you should attach it to a .txt, remember? Bad Erwin. ;)

Looks like a nice hack, I'll give it a shot later. :)

[Erwin]

How to use this hack:

You control your members via the vB3 dropdown menu by clicking on a member's Username.

You then basically choose what to do, and a Popup Window will come up. Just choose what you want to do. Easy.

When you Troll Ban a member, ALL of the member's threads and posts disappear. They disappear from Forumdisplay, Showthread, even in Newreply (where the posts are quoted). This is a quick way of removing offensive posts by trolls.

As a bonus, Troll Banned members get fake 404 errors when they try to access your site. ;)

Anyway, install it, and let me know what you think.

A screenshot of the Postbit Moderator Dropdown Menu Controls, Popup Warning Window, Popup Banning Window, Popup Edit Avatar Window... I won't post screenshots of the rest of the Popup Windows, it's fairly common sense. ;)

[Chris Gwynne]

Great hack, I need something like this! I'll install when vB goes Gold.

Erwin, all the extra options you have in that screenshot like "Edit xx's Avatar" etc, is that another hack??

[speedway]

Excellent! Thanks Erwin

My mods have been asking about the warning system from VB2. This one will blow them away. I'll install it the instant I upgrade to RC1!

Cheers

[Erwin]

Think you have a long enough title?

And you should attach it to a .txt, remember? Bad Erwin. ;)

Looks like a nice hack, I'll give it a shot later. :)
I'm too lazy to make a text file. ;) Releasing my hacks have taken me a few hours already, documenting all my changes. LOL!

[Koutaru]

Wow, nice hack Erwin! I could definately be using this ;)

* Koutaru clicks install

[Erwin]

Great hack, I need something like this! I'll install when vB goes Gold.

Erwin, all the extra options you have in that screenshot like "Edit xx's Avatar" etc, is that another hack??
It's all part of this hack. ;)

[Chris Gwynne]

It's all part of this hack. ;)
Nice!! :D

[obiwan8472]

Nice one, Ill install as soon as I upgrade in about 1 week.

[Dean C]

How about a log on what the mods do?

[nuke]

Hi, I included the Hack, but I use the postbit_lagancy. What should I do to get the windows like they were posted? Thank for any help

[Chris Gwynne]

Hi, I included the Hack, but I use the postbit_lagancy. What should I do to get the windows like they were posted? Thank for any help
Edit the postbit_legacy template instead of the postbit one. :)

[magnus]

Great hack, but there's a few things I noticed:

1. In my default RC1 installation, I do not have the line


<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>


So, instead I added it after:


<if condition="$show['search']">
<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=finduser&amp;userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[find_more_posts_by_x]</phrase></a></td></tr>
</if>


2. You have references to "*****", I believe this should be "modcp".

3. "banning.php" does not exist in admincp, it does in modcp though. Might want to mention that. ;)

4. When a call is made to warn.php, all I get is a blank screen. I'm working on tracking that down as we speak.

[minder]

hi m8 i cant seem to get this to work
i followed all the install instructions and i am geting the extra options when i ckick on the user name only problem is when i chose any of the new options i get a pop up and it says HTTP 404 - File not found
Internet Explorer

what can i have done wrong?

thanks for any help given

rob

[Aceman]

I have a question or two..

1. Does this warning system allow warning 'reasons' to be entered? So that a record can be kept as to why the warning was issued. Also does it send a message to the user alerting them to their warning.. and indicating why they were warned?

2. Does the system allow ME to create warning types (with different values) so that if a user spams the site I can "Spam Warn" +7 warning points, or if they are just disrespectful to others "Disrespect Warn" +2.. this allows me to instantly apply warning to members based on WARNINGS that I've setup?

Thanks
Aceman

[orca]

Nice hack. Will install it later.

[snyx]

beauty!

[paratek]

Hi Erwin,

in the template mod for 'postbit',

this:

<if condition="($bbuserinfo[usergroupid]==5 || $bbuserinfo[usergroupid]==6 || $bbuserinfo[usergroupid]==7)">
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('warn.php?$session[sessionurl]newuser=$post[userid]&username=$userinfo[username]&warnings=$post[field40]','warn','width=500,height=350')"><b>Warn $post[username] - Current Warnings: ($post[field40])</b></span></td></tr>

needs to have the field40 changed to the "hack Installers" field for warnings or it won't display.

Also, the template "warning" that you had us create is called from the program as "warn"

Once i made the changes above, and the "***" changes to "modcp" it works great

Paratek Smacks the install!

[Erwin]

First post updated to correct mistakes. :sorry:

1. Change "*****" to "modcp" in your postbit template (or whatever your moderator cp directory is).

2. Change "field40" in your postbit template to your "Warning" profilefieldid.

3. Change the name of the new template "warning" to "warn".

Sorry about this. I have updated the first post to Version 1.1 to signify the changes. It should work fine now. :)

[paratek]

This is fantastic Erwin....

[TheAnt]

Nice one

*install

[minder]

works 100% now thanks :)

[paratek]

Erwin, not sure if anyone else has come across this. If i select on a users postbit to activate the drop down box, it will display Warnings ( ). If I click to either add or subtract a warning, then it will display the number as Warnings(0) or whatever. Also, it wont display in the users profile unless you have actually warned a user. Even if it is Warnings (0) it will display. I guess what I am asking, is there a way to have it default and start every one at (0) instead of nothing at all?

also, which choice should this be set at?

Field Required Yes No No, but display at registration

[Erwin]

Erwin, not sure if anyone else has come across this. If i select on a users postbit to activate the drop down box, it will display Warnings ( ). If I click to either add or subtract a warning, then it will display the number as Warnings(0) or whatever. Also, it wont display in the users profile unless you have actually warned a user. Even if it is Warnings (0) it will display. I guess what I am asking, is there a way to have it default and start every one at (0) instead of nothing at all?

also, which choice should this be set at?

Field Required Yes No No, but display at registration
That happens to me too. You can add a line of code to showthread.php to make it 0 but why bother? :) Blank means zero.

As for that option, choose No.

[paratek]

That happens to me too. You can add a line of code to showthread.php to make it 0 but why bother? :) Blank means zero.

As for that option, choose No.

Ok, Thanks. You may want to Update that part in your instructions, because you have all three displayed yes, no no but display...of course i chose the wrong one..lol

[Erwin]

Ok, Thanks. You may want to Update that part in your instructions, because you have all three displayed yes, no no but display...of course i chose the wrong one..lol
I didn't notice that! Thanks. :) Updated first post.

[ENZcom]

This is a great hack, but not worth installing now, because vB still isn't stable.

[Zachery]

erwin doesnt part of your hack sort of do the tatchy trick?

[Erwin]

erwin doesnt part of your hack sort of do the tatchy trick?
Yes. But mine's better because it is based on a usergroup. Tachy relies on you manually putting the userid in your Admin CP. Here, it's all automated and usergroup based. ;)

[Zachery]

ah ok, i was just asking :) nice job, i wont be adding it to my live boards till down the road, but very nice work :)

[shadowbreed]

One question i have..
I tried logging in as one of my moderators, and they now have this option in ALL the forums, even the ones they're not moderator of, how can i prevent this?

I know it's all useroptions, but because of my forum setup i'd need them to be able to do this only to the users that visit the forums they're moderating.

[shadowbreed]

Erwin, not sure if anyone else has come across this. If i select on a users postbit to activate the drop down box, it will display Warnings ( ). If I click to either add or subtract a warning, then it will display the number as Warnings(0) or whatever. Also, it wont display in the users profile unless you have actually warned a user. Even if it is Warnings (0) it will display. I guess what I am asking, is there a way to have it default and start every one at (0) instead of nothing at all?

also, which choice should this be set at?

Field Required Yes No No, but display at registration

If you haven't warned anybody yet run this query:

UPDATE userfield SET field# = 0;

(replace field# with the custom profilefield for warning points)

[Hialls]

Installed except it doesn't seem to work when i add to users warning points?

[Hialls]

Solved the problem with adding an auto refresh to post, as it was updating just needed to be refreshed :P.
Ignore previous post

[magnus]

This is a great hack, but not worth installing now, because vB still isn't stable.

Erm.. "still isn't stable"? It's been "stable" since Beta 5 or so. Now that it's in RC1, it doesn't really get any more "stable". To each their own though.

Great hack, Erwin. :D

[msimplay]

lol my only question is why wasn't it made a standard :P

[ap0c]

simply amazing, will install once vb goes gold

[magnus]

Quick modification I made, if anyone is interested:

In POSTBIT (or POSTBIT_LEGACY) template -

Replace:

<if condition="($bbuserinfo[usergroupid]==5 || $bbuserinfo[usergroupid]==6 || $bbuserinfo[usergroupid]==7)">


With

<if condition="$post[usergroupid]!=6 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])">


This will allow your moderators the ability to only warn people in their forums. Plus, it will disallow the warning/banning/etc.. of Administrators.

[minder]

Quick modification I made, if anyone is interested:

In POSTBIT (or POSTBIT_LEGACY) template -

Replace:

<if condition="($bbuserinfo[usergroupid]==5 || $bbuserinfo[usergroupid]==6 || $bbuserinfo[usergroupid]==7)">


With

<if condition="$post[usergroupid]!=6 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])">


This will allow your moderators the ability to only warn people in their forums. Plus, it will disallow the warning/banning/etc.. of Administrators.



nice addition well done :)


rob
:)

[Erwin]

Good job. :) I will add that to the first post giving credit to you.

[Zachery]

only problem with that is its still hard coded via usergroups

[magnus]

Good job. :) I will add that to the first post giving credit to you.

Thanks! :)

only problem with that is its still hard coded via usergroups

Eh? I read your first post in this thread, but I'm afraid I don't know what "tatchy" is. You mean you want it as a definable option in the AdminCP? I plan to tinker with this hack quite a bit, so if that's what you mean I could do the code for that (if Erwin doesn't mind, of course).

[Erwin]

I don't mind. :) Just post it here, and I will include it in the first post.

[Zachery]

no i was refering to the fact that you were still using usergroup id's which arnt always a good idea anymore :) (or so i keep being told)

[magnus]

Erm.. if there's another way to do it, I'm all ears. Sure, I used can_moderate() for moderators.. but is there a can_admin(), too? Heh..

[Zachery]

can_moderate()

$permissions['adminpermissions'] & CANCONTROLPANEL

at least i think so? what i pulled outta beta 7 :)

[magnus]

can_moderate()

$permissions['adminpermissions'] & CANCONTROLPANEL

at least i think so? what i pulled outta beta 7 :)

$perm['adminpermissions'] & CONTROLPANEL pull info from the currently logged in user, not the selected user -- so those won't work. I've been digging on vB.com and I can't seem to find anything relating to this. I was also digging through the default templates for a clue, but apparently they removed Administrator distinctive traits such as italics in Who's Online and Memberlist.

So.. until I can find how they want me to do it, usergroupid will have to do. :D

[Zachery]

if you use

<if condition="$permission['adminpermissions'] & CANCONTROLPANEL"> it will only show to admins

[magnus]

It's $perm['adminpermissions'] and yes, you're right.. that will work if I want to show to admins, but that's not what I'm trying to accomplish sadly.

I need to display warning options on a per user basis, if the selected user is an admin then the warning options will NOT be displayed for them when clicked -- which is why the usergroupid is being used.

$permisson[] gets the permissions of the logged in user, not the selected user.

[shadowbreed]

Great that moderator addon was exactly what i needed :) great hack and great addon, thnx guys

[Erwin]

Think you have a long enough title?

And you should attach it to a .txt, remember? Bad Erwin. ;)

Looks like a nice hack, I'll give it a shot later. :)
Finally got off my butt and made a ZIP file. :)

[Vile]

Excellent hack Erwin :)

Thanks for sharing

[Tenpit]

Great Hack

Just a question.
When you give someone a warning, does it send them any form of notification, PM or Email? Is it possible to set a reason for the warning?

Thanks
Tenpit

[magnus]

Great Hack

Just a question.
When you give someone a warning, does it send them any form of notification, PM or Email? Is it possible to set a reason for the warning?

Thanks
Tenpit

At the moment, no, it does neither. I'm working on a mod at the moment that will add that functionality. :)

[gmarik]

A good one - could be more strucutrized.

[Erwin]

Great Hack

Just a question.
When you give someone a warning, does it send them any form of notification, PM or Email? Is it possible to set a reason for the warning?

Thanks
Tenpit
That would be quite easy to add to warn.php. :) I've never needed to as I get my moderators to manually PM the member.

[corsacrazy]

i really dont like the idea of having a new custom field and mr erwin isit possible to create an install script for all the lazy ones?

[Erwin]

i really dont like the idea of having a new custom field and mr erwin isit possible to create an install script for all the lazy ones?
New custom profile field is the best way to add new fields, since you don't need to run extra queries to get the information. :) Running an install script won't work with custom profile fields since the custom profile fieldid would be different for each person depending on how many of these you have added.

[corsacrazy]

understood but i mean for editing the php files .. remember vb hacker and vb hback maker , i mean install file that sort of way and profile bit is manually done

[Erwin]

understood but i mean for editing the php files .. remember vb hacker and vb hback maker , i mean install file that sort of way and profile bit is manually done
You want a file that manually edits your PHP files for you?

Firstly, you would have to have all your PHP files CHMOD 777 first of all. Secondly, it is much safer to do it manually, since you know where the code has gone, and can troubleshoot better. Thirdly, it means you learn about how PHP works if you do it manually. Fourthly, vBHacker doesn't work for vB3. :)

I can understand an install file to put in new tables and columns, templates and phrases, but not editing actual PHP files - that should be done by the installer manually.

[corsacrazy]

sory for being so lazy :)

[webrats]

im not seeing the ip or the warnign points in the post bit

[Erwin]

im not seeing the ip or the warnign points in the post bit
Try reinstalling the hack again. :) Something didn't go right. Make sure also you are allowing mods to see IPs in the first place. And that you have given out the warning point.

[M1th]

Hmm, I just installed this on my test board.. everything is working except the automatic Ban when warning level is above 7. It wont put the member in the banned usergroup for some reason. :/

[Amiga-uk]

Hi, i tried this and got:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: UPDATE userfield SET 5=5-1 WHERE userid='98'
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 '5=5-1 WHERE userid='98'' at line 1

mysql error number: 1064

Date: Saturday 10th of January 2004 10:56:15 PM
Script: http://forum.inspiregfx.co.uk/warn.php?action=dominus&newuser=98&amount=Substract+-1
Referer: http://forum.inspiregfx.co.uk/warn.php?newuser=98&username=kupo&warnings=
Username: Amiga
IP Address: **.***.**.**

What've i done wrong? :(

EDIT: Whoops, i got this when trying to add/subtract/reset warnings. Everything else works perfectly.

[Erwin]

Hi, i tried this and got:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: UPDATE userfield SET 5=5-1 WHERE userid='98'
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 '5=5-1 WHERE userid='98'' at line 1

mysql error number: 1064

Date: Saturday 10th of January 2004 10:56:15 PM
Script: http://forum.inspiregfx.co.uk/warn.php?action=dominus&newuser=98&amount=Substract+-1
Referer: http://forum.inspiregfx.co.uk/warn.php?newuser=98&username=kupo&warnings=
Username: Amiga
IP Address: **.***.**.**

What've i done wrong? :(

EDIT: Whoops, i got this when trying to add/subtract/reset warnings. Everything else works perfectly.
You haven't got the custom profile field id correct there. It should be field10 or something like that.

[Erwin]

Hmm, I just installed this on my test board.. everything is working except the automatic Ban when warning level is above 7. It wont put the member in the banned usergroup for some reason. :/
Mmm... did you specify the banned usergroup id in the warn.php file correctly?

[M1th]

Mmm... did you specify the banned usergroup id in the warn.php file correctly?
Yep.

[SnowBot]

Got round to installing it and went without any problems, all seems to work well.

Nice, THANKS :)

[Amiga-uk]

You haven't got the custom profile field id correct there. It should be field10 or something like that.
hah, yeah.. i didnt realise something =P

Thanks, its all sorted now. Works perfectly ^^;

[Zelda-King]

Installed!

Seems to be working fine so far. :)

[Erwin]

Glad to know it's working. :) Hope it's helping you run your forums.

[Zelda-King]

Yes thanks! Even the more hack-skeptic staff are impressed.

[cirisme]

Wow, that is quite an involved hack. Good work!

[ranger2kxlt]

quick question, if you add a warning point can you have a reason for the warn as well???

Thanks

[Erwin]

quick question, if you add a warning point can you have a reason for the warn as well???

Thanks
No, I haven't done that for this hack. I may add this as a feature in the future.

[FastAttack]

I've installed it but sometimes it wierds out on me.. when I put my mouse over on the postbit it won't generate the menus.. but if I click the username go to their userinfo and come back it works again..

did I miss something here?

[Erwin]

I've installed it but sometimes it wierds out on me.. when I put my mouse over on the postbit it won't generate the menus.. but if I click the username go to their userinfo and come back it works again..

did I miss something here?
The dropdown menu thing has nothing to do with my hack - that's an intrinsic vB3 issue that is related to different browsers. :) My hack just makes use of the dropdown menus.

[FastAttack]

The dropdown menu thing has nothing to do with my hack - that's an intrinsic vB3 issue that is related to different browsers. :) My hack just makes use of the dropdown menus.
ah k.. didn't they fix that "bug" or is it still around RC2 ?

[Erwin]

ah k.. didn't they fix that "bug" or is it still around RC2 ?
It's not a bug. You need to complain to Jelsoft at vBulletin.com if your browser has problems with it, not in this thread, which is for the support of this hack.

[ranger2kxlt]

quick question, if you add a warning point can you have a reason for the warn as well???

Thanks


i should add more detail to this, having a reason means that any other mod or admin (who ever has access to add warn points) can see these messages before they add there point as they maybe warning the person for the same thing almost at the same time, make sense??

[msimplay]

Its a great hack but it doesn't have any kind of notification as to why the person got a warning
ie with Mikes Warning System on Vb2
u could tell the people a list of preset warnings and add and subtract warning points up2 a maximum set by u and also
it would tell them via email or pm (ur choice) why they have got the warning
and when u click in the post bit on their warnings it had a record of why they were warned

[!!!cyr0n_k0r]

what do I need to change so that when I place a user in the "banned" usergorup.. all their posts are NOT deleted.

this system will be used to suspend users mostly.. so I still want their posts there.
I want the mods to delete the posts manually.

what do I need to change?

[Fi_InCogNiTo]

I get this:

mysql error: Unknown table 'user' in field list

I have a prefix of vb3_

Where in the code would I fix this to work with my prefix?

[TheEDIGuy]

Love it, Erwin (as with most of your mods). One thing I'm running into, though. I can warn just about everyone, but I have a user with a name of "aMaZiN'RaCeGuY>", and the warn pop-up won't pop up for him. I'm sure it's the > that's stopping it, but have no idea how to fix it.

Clicking "install".

[Zelda-King]

The only thing I don't get is... this warning system doesn't actually 'warn' the offender, does it?

[john43202]

Great hack.

One problem... When I try to warn a user I get the error
Fatal error: Call to undefined function: gettemplate() in /home/xxxxxx/public_html/forums/warn.php on line 38

Any ideas? :ermm:

John

[Fi_InCogNiTo]

I uninstalled this hack but after clicking a membername, the drop down still gives the option to warn the member. I went through the uninstall a few times, but can't see how to get rid of that.....

Can someone post how to delete that from the drop down plz?

[msimplay]

Its a great hack but it doesn't have any kind of notification as to why the person got a warning
ie with Mikes Warning System on Vb2
u could tell the people a list of preset warnings and add and subtract warning points up2 a maximum set by u and also
it would tell them via email or pm (ur choice) why they have got the warning
and when u click in the post bit on their warnings it had a record of why they were warned
sorry i quoted my own post but it would be great if you would update this hack to include some kind of real warning to the people coz all they will know is that they have been warned but they wont know why
and on the admin side some kind of record as to why the warning is there
because when a moderator makes a warning and the administrator looks it would be good to know why
and warnings dont have an option to expire

heres a webpage of the old warnings hack i used to have on vb2
and yes i know this is Mikes warning hack based on Gforce2k2's warning hack

however i would much rather have these on you hack as it has better options like signature editing and avatar editing

but the warnings side is a bit lacking :disappointed:

http://wambam.net/Updates/Warnings.html

[Dan]

With Erwin's Permision I've made an HTL Version of this hack.

Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar
Version: 1.1
vB-version: 3.0.0 Release Candidate 3
Developer: Dr. Erwin Loh
Install-difficulty: Medium
File-edits: 8
Template-edits: 2

Description of the Hack:
Okay, this is my private forum's custom warning/ suspension/ banning system and postbit moderator system. This is a fairly involved hack, so it is crucial that you follow the instructions closely. It would benefit experienced hackers the most. The following instructions are for an unhacked board. If you have hacked your board, or use different moderator usergroups, just make the appropriate changes.

[dano]

If all I want to do is make it so that I have a Troll banned members group, what sections of this code would I have to use? I dont really need the rest, but I do want to be able to ban people and make their posts invisable etc.

[Dan]

[b]
[color=yellow]HTL version (thanks to Dano) here:

Attached Fileshttps://vborg.vbsupport.ru/Warning_System_Automatic_Ban_Make_Posts_Invisible_ Edit_Signature_Avatar.htl (https://vborg.vbsupport.ru/attachment.php?attachmentid=16653)


*cough* dan *cough*

[kernel16]

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb3_thread AS thread
LEFT JOIN vb3_user ON user.userid = postuserid
WHERE forumid = 147
AND sticky = 0
AND visible = 1
AND usergroupid<>14

AND thread.lastpost >= 1073937141


ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 10

mysql error: Unknown table 'user' in field list

mysql error number: 1109


k what could have i done wrong?

[dano]

If all I want to do is make it so that I have a Troll banned members group, what sections of this code would I have to use? I dont really need the rest, but I do want to be able to ban people and make their posts invisable etc.
Anyone?

[Erwin]

k what could have i done wrong?
You didn't make all the modifications in the instructions.

[Sonic625]

Adding a suggesstion, Is there anyway to get the warning level incorporated in the postbit without viewing the profile like by the "report" and "IP" buttons?
Like someone else said its a great hack but doesn't really warn people unless you manually warn them.
Thanks

[Zelda-King]

Well he did say he wouldn't customise the hack for us. It doesn't look like he's interested in having it that way for whatever reason. Actually I really don't mind the manual warnings as automated ones don't really get to the point of the individual occasion anyway unless an input field is applied. Replace the word 'warning' with the word 'strike' perhaps...

[mOdEtWo]

Erwin, thanks for a great hack.

I'm having a problem tho. Whenever I try to access a forum, I get a MySQL error message (however, the forum home (index.php) is fine).

Database error in vBulletin 3.0.0 Release Candidate 4:

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>=1077102501 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 = 4
AND sticky = 0
AND visible = 1





mysql error: You have an error in your SQL syntax near '// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signat' at line 3

mysql error number: 1064


What have I done?

[Zelda-King]

That's because you've used the HTL. It automatically puts in that "START HACK/END HACK" lark and it's INSIDE the query. Remove those lines.

[mOdEtWo]

That's because you've used the HTL. It automatically puts in that "START HACK/END HACK" lark and it's INSIDE the query. Remove those lines.

Uh huh.

Excactly where do I find these lines? I've got access to phpmyadmin, but I can't seem to find these lines. Any ideas? Never mind, found them in the php code, duh!

Oh, and isn't it pretty stupid that the htl adds such lines? I thought it was developed for making things easier, not the other way around. ;)

[Zelda-King]

Oops! I should have clarified about it being a PHP script matter. :/

[ImportPassion]

I just found that out the hard way too.
But if you want to keep the comments, just put a # in front of the line. THat is a MySQL comment

[ImportPassion]

Ok, I added a "reason" and the "auto PM".
Now, that being said, I coded it for my own use, so I have hardcoded my id in there to send a PM to me when someone is warned and/or banned. It also sends it to the warned user of course.

In postbit and postbit_legacy find the line that resembles this

<tr><td class="vbmenu_option"><span onClick="window.open('warn.php?$session[sessionurl]newuser=$post[userid]&username=$userinfo[username]&warnings=$post[field60]','warn','width=500,height=350')"><b>Warn $post[username] - Current Warnings: ($post[field60])</b></span></td></tr>


right after
$post[field60] <--- yours will prolly be a different field number than mine

add
&amp;postid=$post[postid]

replace your warn template with the contents of this warn.txt
Upload this new warn.php to the forums dir.

Please make sure you go through the files first and change field60 to your warning points field.

I will try to provide support, but no guarantees.

D

[ImportPassion]

one more thing, for those of you that do not want it to say:
Current Warnings: ()

Run this SQL query. Make sure to change field60 to your warning points field


UPDATE userfield
set field60 = '0'
where field60 = ''

[PET]

I have 2 problems :

When i click WARN [username] ... the browser opens a new page (warn.php......) but i get a white page. And i have uploaded warn.php in my forum root.

And the seccond problem. When i click BAN A USER a new window appear. I only see :

Move User to Usergroup and here ONLY Normal Banned. How can i ban the member as a TROLL BANNED ?

thanx. I'm a bit in a hurry now so i cudn't read all the topics.

[PET]

The first problem was solved. I didn't add the new template, bechoze the HTL file didn't tell me do to that. However, the seccond is still a problem. How can i directly ban a user to be a TROLL BANNED ?

[Natch]

From another thread ...
My Warning System hack released here uses a similar system, but it is based on a banned usergroup, so it can be time-based, and all posts automatically disappear. :)
Can you specify how to make the ban apply from a certain date onwards ? cos I have some users that used to be good, then were turned to the dark side ...

Any thoughts ?

[Osterling]

i guess first off is this hack rc4 compatible and second if it is..

http://www.exasko.info/forum_tester

try to click a forum to view.. did i mess up? *this forum is a tester so i don't screw up my main forum untill i know what i am doing*

[Osterling]

going to reinstall.. so right now everythin workds

[Sonic625]

Ok, I added a "reason" and the "auto PM".
Now, that being said, I coded it for my own use, so I have hardcoded my id in there to send a PM to me when someone is warned and/or banned. It also sends it to the warned user of course.

In postbit and postbit_legacy find the line that resembles this

<tr><td class="vbmenu_option"><span onClick="window.open('warn.php?$session[sessionurl]newuser=$post[userid]&username=$userinfo[username]&warnings=$post[field60]','warn','width=500,height=350')"><b>Warn $post[username] - Current Warnings: ($post[field60])</b></span></td></tr>


right after
$post[field60] <--- yours will prolly be a different field number than mine

add
&amp;postid=$post[postid]

replace your warn template with the contents of this warn.txt
Upload this new warn.php to the forums dir.

Please make sure you go through the files first and change field60 to your warning points field.

I will try to provide support, but no guarantees.

D
Just FYI with your warn.php only admins and Smods can warn members I replaced:

if (!($permissions['adminpermissions'] & CANCONTROLPANEL) AND (!can_moderate(0, 'canbanusers')))

with Erwin's

if ($bbuserinfo['userid'] == 0 OR $bbuserinfo['usergroupid'] == 2 OR $bbuserinfo['usergroupid'] == 1 OR $bbuserinfo['usergroupid'] == 3 OR $bbuserinfo['usergroupid'] == 4 OR $bbuserinfo['usergroupid'] == 8 OR $bbuserinfo['usergroupid'] == 17)

and they can now warn again.
Thanks,
S

[Osterling]

alright...

hey guys.. i am new to asking for help like this, but a mod said i go.. so please don't be mean..

i want the hack.. Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture ..now when installed it, it didn't work.. so i restore everything and tried again and still got errors..

i run with rc4.. and i would give you the files, you make the code additions then i will upload them throught FTP....

since i am 17 with a non-profit teen support site, i cannot offer money.. so please anyone who has some time and wants to help me out please..

reply here if you are intersested and then I PM you.. or you could just PM.. whatever floats your boat....

also i been getting spammed lately by kids who attack my memebers for being depressed and opening up.. and i am not talking on or two spammers.. i am talking 15 at a time... :( so this hack could give me a edge of these spamemrs...

please note: i posted this in the lounge but felt it might be better here.. sorry if this is against the rules.. i just really need help

[Holidazed]

7thgenCivic.Com, thanks for the update. It is nice feature to be able to add a reason for the warning and have it pm the user. However, I added this according to your instructions and it does not send a pm at all.

Erwin, setup to 7 points and then change to Usergroup 8 (the banned group). In testing, I gave an account 7 warnings and it never changed their usergroup to the "Banned" one. It simply left them where it was?

Ideas?

Overall, let me say that I am really looking forward to having this hack installed and working. It looks awesome and Erwin does some really great hacks.

[Osterling]

anyone.. can some one pleeeeeeeeease help me

[Zero Tolerance]

Someone else has had this error, and im getting it too

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb3_thread AS thread
LEFT JOIN vb3_user ON user.userid = postuserid
WHERE forumid = 5
AND sticky = 0
AND visible = 1
AND usergroupid&lt;&gt;17

AND thread.lastpost &gt;= 1075634033


ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

Ive redone edits for all files, still didn't work, maybe if you could point out the exact edit that fixes this that might help, but i dont see any ive missed and ive gone through them all

Edit:

I fixed it, in the code i changed user. (2 times) to
" . TABLE_PREFIX . "user.

Seems those with a prefix may have trouble with this ;)

[Holidazed]

Well, disregard my previous message. It seems that when the instructions are followed properly, the hack will often work.

Awesome hack guys. Thanks

[Holidazed]

I came across the need to publically display the current amount of warning points a user had on the postbit. This was in addition to what was displayed when you clicked on thier username.

I just modified the postbit or postbit_legacy template and searched for:

<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>

Then after that I added

<if condition="$post['field6']"><div class="smallfont">Current Warnings: $post[field6]</div></if>

How can I modify this statement to be if "field6" does NOT =0, then display the text??

Ideas?

[msimplay]

Ok, I added a "reason" and the "auto PM".
Now, that being said, I coded it for my own use, so I have hardcoded my id in there to send a PM to me when someone is warned and/or banned. It also sends it to the warned user of course.

In postbit and postbit_legacy find the line that resembles this

<tr><td class="vbmenu_option"><span onClick="window.open('warn.php?$session[sessionurl]newuser=$post[userid]&username=$userinfo[username]&warnings=$post[field60]','warn','width=500,height=350')"><b>Warn $post[username] - Current Warnings: ($post[field60])</b></span></td></tr>


right after
$post[field60] <--- yours will prolly be a different field number than mine

add
&amp;postid=$post[postid]

replace your warn template with the contents of this warn.txt
Upload this new warn.php to the forums dir.

Please make sure you go through the files first and change field60 to your warning points field.

I will try to provide support, but no guarantees.

D
just wondering if the warning id could be the person actually making the warning instead of one id
because then one admin would be thought of as the bad guy
i would say everyone that has the ability to warn should get the credit for it

[ron176]

Right I done this hack and it appears to work correctly for the most part. The only problem I am having is that the drop down menu options are only present in some forums and not in others. I am an admin and have the super mod option but it is not appearing in forums where I am assigned as mod and is appearing in forums that have other mods assigned to them.
Any ideas. I redone the hack and it is still happening and there are no other hacks installed.

Thanks

Edit: Never mind, It was working and I broke it and I was looking at a cached version of the menu. Works now.

[Osterling]

has the PM notifciation of being warned been set up yet?

[TRStealth]

Does the hack work in RC4?

[trainer]

yes was also wondering if it worked with RC4

[TRStealth]

Trainer, I went ahead and installed it on my RC4, worked just fine except that my moderators get an 'unauthorized' message when they try to edit sigs, avs, etc.

[Holidazed]

I have this hack working in my vb3 RC4 just fine. Did not have any issues at all.

[TRStealth]

Trainer, I went ahead and installed it on my RC4, worked just fine except that my moderators get an 'unauthorized' message when they try to edit sigs, avs, etc.
Anyone have an an answer to my problem? I also have another problem, for some reason, it's not showing the amount of warnings a user has, and it's not warning them at all if a moderator gives them a warning.

[acrimony]

One thing I did notice in this hack was the main page still lists the person has posted in a forum, yet when u click the link to go to that post, you get a runtime error....

[Flashinblue]

d) Find:

PHP:
SUM(IF(lastpost>=$lastread AND open<>10,1,0)) AS newthread


Replace with:

PHP:
SUM(IF(thread.lastpost>=$lastread AND open<>10,1,0)) AS newthread



had a bit of problem with this as it gave me a database error. Swapped this part and it now works fine.

Will now try to add something to the warn.php file so that it sends an automatic pm to the guy that has be warned. Also, will show it under the poster's name... will try, i am everything but a good coder

[lasto]

Anyone have an an answer to my problem? I also have another problem, for some reason, it's not showing the amount of warnings a user has, and it's not warning them at all if a moderator gives them a warning.

RC4 - i installed on
i found everything worked on this except the warning bit

u could give em as many warning as u wanted but it never banned em etc

besides that it does what it says on the tin :)

opps

* lasto click installs

[PranK]

Erwin,

I had this installed on RC3/4 with no problems, now I have installed it on Gold and I can't get the drop-down menus to appear... any ideas?

Thanks.

Christian

[poetic]

hey im geting a error i installed use the hack file thing and i get this error:

Parse error: parse error in /home/elitexga/public_html/forum/forumdisplay.php on line 523

[lasto]

hey im geting a error i installed use the hack file thing and i get this error:

Parse error: parse error in /home/elitexga/public_html/forum/forumdisplay.php on line 523


parse error is usually user fault m8 check your files to make sure u done the edit fine as this hack does work.

U proberly missed a , out somewhere or overwrote one


revert to orginal forumdisplay.php and do the changes again but this time double check em

[Flashinblue]

it works on mine

[poetic]

ya reverted but now i gotta install my other hacks over again :-/

[lasto]

just look at line 523 Parse error: parse error in /home/elitexga/public_html/forum/forumdisplay.php

and see where exactly the error is

[Zilvia]

Does this work with the final release of vB 3.0.0?

[TRStealth]

I have it installed on my vB Gold, and it works perfectly. You should have no problems. :)

[msimplay]

to anyone that wants this warn.php i have set it to use user id 1
and the pms are set so that they get sent to user id1
and the person getting warned

i take no credit for this coz the hack was done by Erwin and the modification by 7thgenCivic.Com

ps in the warn.php change wambam to your own username it occurs 3 times
Ctrl + F to search

also use the install instructions found in this post

https://vborg.vbsupport.ru/showpost.php?p=478482&postcount=104

and replace your warning template found with the one in that post

[TRStealth]

Sweet, thanks :D

[lasto]

u know in the drop donw menu where the options appear mine appears in black - anyone know how to leave the color alone so it matches the rest of the box ?

[jeoworks]

msimplay,

Alot more has to be edited in that file before it will work with other installs.

For instance, you have different fieldsets, and it causes database problems because you use a scale of 10, where as the original uses 7.

Just wanted to let everyone know that the file you posted takes PHP knowledge to get it to work.

[msimplay]

msimplay,

Alot more has to be edited in that file before it will work with other installs.

For instance, you have different fieldsets, and it causes database problems because you use a scale of 10, where as the original uses 7.

Just wanted to let everyone know that the file you posted takes PHP knowledge to get it to work. sorry but it doesn't take anymore php knowledge then that of whats already said in
Erwins original hack ie change the warning points to whatever you would want and i'm sure its simpler then what 7thgenCivic.Com
had already posted
the reason i can say that is because i'm not a coder i just tested and changed a few variables that 7thgenCivic.Com had already said about


however one amendment would be to change 'wambam' which occurs 3 times to your own username

sorry i wasn't clear but i have made amendments to the other post to include extra instructions :o

[TRStealth]

sorry but it doesn't take anymore php knowledge then that of whats already said in
Erwins original hack ie change the warning points to whatever you would want and i'm sure its simpler then what 7thgenCivic.Com
had already posted
the reason i can say that is because i'm not a coder i just tested and changed a few variables that 7thgenCivic.Com had already said about


however one amendment would be to change 'wambam' which occurs 3 times to your own username

sorry i wasn't clear but i have made amendments to the other post to include extra instructions :o
Ah, ok. I wasn't quite sure what it was. However, I made a small modification to only allow Admins to subtract and reset the points, if anyone wants it, I can post it.

[lasto]

if the modification allows us to warn people then im for u posting it m8

but the hack does work fine - maybe i messed up making that profile field im unsure :(

[TRStealth]

Yes, anyone can add warning points, but only admins are able to reset/subtract them. I was having trouble with some of my mods removing members' warning points for them to qualify for special access. (Warned members are disqualified)

[lasto]

Yes, anyone can add warning points, but only admins are able to reset/subtract them. I was having trouble with some of my mods removing members' warning points for them to qualify for special access. (Warned members are disqualified)


i have this hack installed installed already and only problem i found with it was even if i warned someone over the allocated points (say 7) they still were`nt moved to the banned group - how did u solve this one ?

also i like your idea on only admins being able to remove points cause people even mods will eventually abuse power.

Post your update m8 and i will try it cheers

[msimplay]

Ah, ok. I wasn't quite sure what it was. However, I made a small modification to only allow Admins to subtract and reset the points, if anyone wants it, I can post it.
i think i would prefer my moderators to act responsibily with the warnings else why have them as moderators
however post the modification am still thinking :p

ps i love the design on your site :D

[TRStealth]

i think i would prefer my moderators to act responsibily with the warnings else why have them as moderators
however post the modification am still thinking :p

ps i love the design on your site :D

Thanks :p

ok, in Warn.php find:


if ($action == "dominus") {
$DB_site->query("UPDATE userfield SET $warnfield=$warnfield-1 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
$show['closewindow'] = true;

}


Replace With:

if ($action == "dominus") {
if ($bbuserinfo['usergroupid']==6) {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield-1 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have lowered this members warnings.";
$show['closewindow'] = true;
} else {
$error = "<b>Message:</b> Only Administrators can remove warnings.";
$show['closewindow'] = true;
}
}


Next find:

if ($action == "doreset") {
$DB_site->query("UPDATE userfield SET $warnfield=0 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
$show['closewindow'] = true;
}


Replace with:

if ($action == "doreset") {
if ($bbuserinfo['usergroupid']==6) {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=0 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have reset this members warnings.";
$show['closewindow'] = true;
} else {
$error = "<b>Message:</b> Only Administrators can reset warnings.";
$show['closewindow'] = true;
}
}


I'm no PHP expert, but I haven't heard that anything's wrong with the code.

[msimplay]

Thanks :p

ok, in Warn.php find:

I'm no PHP expert, but I haven't heard that anything's wrong with the code. thanks for that :p

[obiwan8472]

Hi, just installed this for the 2nd time... but can not whatever i do.. get the things to appear in the dropdown menu box!! Any ideas?

[magnus]

Hi, just installed this for the 2nd time... but can not whatever i do.. get the things to appear in the dropdown menu box!! Any ideas?
Are you sure you're editing the correct postbit? If you're using the new postbit (with the poster's information ABOVE the post) then you need to edit "postbit", otherwise, if you're using the layout with the poster's information on the LEFT, you need to make the changes in postbit_legacy.

[BamaStangGuy]

<if condition="$post['userid']">
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
<if condition="($bbuserinfo[usergroupid]==5 || $bbuserinfo[usergroupid]==6 || $bbuserinfo[usergroupid]==7)">
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('warn.php?$session[sessionurl]newuser=$post[userid]&username=$userinfo[username]&warnings=$post[field7]','warn','width=500,height=350')"><b>Warn $post[username] - Current Warnings: ($post[field7])</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/banning.php?do=banuser&userid=$post[userid]','ban','width=500,height=350,scrollbars=yes')"><b>Ban or Suspend $post[username]</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/banning.php?do=liftban&userid=$post[userid]','ban','width=500,height=350,scrollbars=yes')"><b>Unban or Unsuspend $post[username]</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/user.php?do=editsig&userid=$post[userid]','edit','width=500,height=350,scrollbars=yes')"><b>Edit $post[username]'s Signature</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/user.php?do=avatar&userid=$post[userid]','edit','width=500,height=350,scrollbars=yes')"><b>Edit $post[username]'s Avatar</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/user.php?do=profilepic&userid=$post[userid]','edit','width=500,height=350,scrollbars=yes')"><b>Edit $post[username]'s Profile Picture</b></span></td></tr>
<tr><td class="vbmenu_option"><span onmouseover="this.style.cursor='hand';" onClick="window.open('modcp/user.php?do=reputation&userid=$post[userid]','edit','width=500,height=350,scrollbars=yes')"><b>Edit $post[username]'s Reputation Comments</b></span></td></tr>
<tr><td class="vbmenu_option"><b>$vbphrase[ip] : $post[ip]</b></td></tr>
</if>

</if>

</table>

I am not seeing the options in post bit and this is what I have

[dsotmoon]

when you click on ban or suspend from the drop down should it show the "troll banned" as an option, it only shows the 2 banned groups I already had set up

[Brahm]

Thanks, I needed this one. Installed and looks great!

[Corvette]

Is there any way to add a graphical meter showing the members warn status (That staff can see every members warn count and the member can see himselves warn only)

[cerebro]

i have some question.

Ban option, Edit Signature...only Moderators whit access to that thing can use it? or all moderator?

Only mods or admin can Warn users?

Like Corvette say, some way to show every member the warn lvl?

[Skyline_GT]

I don't know why when a member is already over the ban limit.
it didn't ban them automaticlly...
why??
also I did everything correctly..

[Zelda-King]

I have it installed on my vB Gold, and it works perfectly. You should have no problems. :)Hmm, can you verify that troll banned members get the fake 404 error still? Since I upgraded to vB3 Gold all they see is a blank page, and yes I do still have the code in phpinclude_start.

But it's late at night here. I guess I'll examine this closer tomorrow.

[Skyline_GT]

I have a question..
Is it possible when it sutomatic ban a person, can it only move their usegroup to the ban group but not delete their posts?

[Zelda-King]

Their posts aren't deleted anyway. If you have it send them to the banned group they're just banned. If you have them set to Troll Banned their posts are on ignore, but admins can see them (I forget if mods can).

[Skyline_GT]

hm.. I tried it..
.but after he is moved to the Troll Banned.. I can't see his post ..
and I am an admin..

[Zelda-King]

I just had a look. I can't either. I'm not sure that's not by design though, but I thought I remembered seeing it before Gold.

[cerebro]

I just had a look. I can't either. I'm not sure that's not by design though, but I thought I remembered seeing it before Gold.
When release gold?

[Zelda-King]

I don't quite follow the question but vB3 Gold has been out since March 25th.

[cerebro]

lol...i think u was talking about a Gold version of the hack! jajaj Sorry! :P

[Majik?]

Had to fix a few queries to work with table prefixes, but other than that.. Installe with no problems.

[dano]

I have a problem. When I troll ban everyone, it now says:

"The administrator has decided that XXXXXXXX should be quiet for a while." then gives the member the option to take this person off their ignore list.

How can I fix this so that it doesnt say that as I dont want the member or other members to know that I have banned this person.

[dano]

Bump

Can anyone help me fix this??

[Majik?]

Bump

Can anyone help me fix this??
Why would you bump a thread not even 30mins after making your last post? Especially when it's still the top thread in this forum? You might want to wait at least 12hrs before doing so. ;)

[dano]

Why would you bump a thread not even 30mins after making your last post? Especially when it's still the top thread in this forum? You might want to wait at least 12hrs before doing so. ;)

Actually it was like 2 1/2 hours, but no big deal. Gee thanks for the leason, there was no reason for you to even post. :rolleyes:

[Majik?]

Actually it was like 2 1/2 hours, but no big deal. Gee thanks for the leason, there was no reason for you to even post. :rolleyes:Actually I'd meant to type the hours in before it (i.e. 2hrs 30mins), but was coding something at the time and apparently missed that part.. But, you should wait a little longer though when it's still the top thread in the forum. And actually, I was going to hepl you with it after I finished what I was doing.

[dano]

Actually I'd meant to type the hours in before it (i.e. 2hrs 30mins), but was coding something at the time and apparently missed that part.. But, you should wait a little longer though when it's still the top thread in the forum. And actually, I was going to hepl you with it after I finished what I was doing.
Well if you can help, that would be great. Your post to me seemed rude, but now it appears that you simply made a typo. The reason I am trying so hard is that its really messing with me. I average about 400-500 members online and the all have to +++++ and ask questions every time someone gets banned. Its hurting me a lot and I have spent all day trying to figure it out. If I bumped it to early and seemed anxious, thats why.

If you really can help me, it would be appreciated.

[Majik?]

Well if you can help, that would be great. Your post to me seemed rude, but now it appears that you simply made a typo. The reason I am trying so hard is that its really messing with me. I average about 400-500 members online and the all have to +++++ and ask questions every time someone gets banned. Its hurting me a lot and I have spent all day trying to figure it out. If I bumped it to early and seemed anxious, thats why.

If you really can help me, it would be appreciated.I'll have a look tonight or tomorrow and see what i can come up with for ya. Off the top of my head I don't thikn it'd be hard to do what you want. I should have time to look tomorrow, but maybe someone else can in the meantime.

[PranK]

Erwin,

I had this installed on RC3/4 with no problems, now I have installed it on Gold and I can't get the drop-down menus to appear... any ideas?

Thanks.

Christian


anyone?

Thanks.

[dano]

anyone?

Thanks.
Strange. I have it on Gold and other than my one issue everything is fine. Maybe re-do the postbit edit?

[sabret00the]

has anybody added functionality to this so that mods can ban from their own areas?

[DA Master]

:up:

Love it, thanks for a great hack.

[NexVision]

installs fukin awesome

[NexVision]

ok 2 prob I notice on the pm that gets sent with the link from the reffering post is not valid anyway to correct this.

also is there anyway to make a usergroup or user a exception to the warn function.

[BigJohnson]

ok 2 prob I notice on the pm that gets sent with the link from the reffering post is not valid anyway to correct this.

also is there anyway to make a usergroup or user a exception to the warn function.
Ya the the link is dead. I was going to report this but u beat me hehe. I hope that can get fixed.

[Erwin]

I have a problem. When I troll ban everyone, it now says:

"The administrator has decided that XXXXXXXX should be quiet for a while." then gives the member the option to take this person off their ignore list.

How can I fix this so that it doesnt say that as I dont want the member or other members to know that I have banned this person.
You did not edit one of the templates I set out in the instructions. Do that please - you need to empty the ignore template.

[Erwin]

ok 2 prob I notice on the pm that gets sent with the link from the reffering post is not valid anyway to correct this.

also is there anyway to make a usergroup or user a exception to the warn function.
Really? Is this a Gold thing? I'll check.

[NexVision]

Really? Is this a Gold thing? I'll check.
cool whenever u figure it out i would appreciate it I know ur busy so do yo ++++..

[JaNa]

(evil laugh) Now this is what I call authority :D

[SmasherMaster]

wonderful, now I can threaten my users. :)

* SmasherMaster hits install

[poetic]

Yes I am having the same problem with gold that the page comes up blank when i try to warn someone please try and fix this

[Majik?]

Yes I am having the same problem with gold that the page comes up blank when i try to warn someone please try and fix thisWorks fine with Gold. Other than having to fix a few queries to use table prefixes, there were (and are) no problems so far. Olny other changes I've made are to customize it a bit. But, never had to do anyhting to make it work with Gold (except for the minor prefixes part).

[WebTechTalk]

Very Nice Hack! Im working on installing it now.

[NexVision]

I noticed another problem whenever I edit a users profile I get this in the postbit (below)

Also I did edit the postbit to show the warning points cause I think it makes for good convo

below is the code i have in the posbit I am also using legacy postbit if it matters.

<if condition="$post['field5']"><div>Warning Points: $post[field5]</div></if></br>

click for image for some reason I cant use attachments
http://www.nextelmodz.com/downloads/Capture_054.gif

and copy and paste the url and it worx fine sheesh

[WebTechTalk]

Interesting..I installed the hack..however I cant tell any diffrence..

[juanmalaga9]

d) Find:

PHP:
SUM(IF(lastpost>=$lastread AND open<>10,1,0)) AS newthread


Replace with:

PHP:
SUM(IF(thread.lastpost>=$lastread AND open<>10,1,0)) AS newthread

had a bit of problem with this as it gave me a database error. Swapped this part and it now works fine.

I got this same error!
I hack the file four times already, but the same error :(

I'm using vb3.0.1

I try to Swap, like Flashinblue says, but the error don't stop.
Any ideas? :disappointed:

[NexVision]

Interesting..I installed the hack..however I cant tell any diffrence..


male sure if you have your postbit on the left the template mod u make is ib postbit_legacy if its up top then do the postbit

[juanmalaga9]

I have an error with this line now:


5. In newreply.php:

a) Find:

PHP:
post.pagetext, post.allowsmilie, post.userid, post.dateline


Replace with:

PHP:
post.pagetext, post.allowsmilie, post.userid, post.dateline, user.usergroupid AS usergroupid


This give me an error when i try to reply or quote a post in my forum.
And stil have the other error with the forumdisplay part of the hack (Step D)

Any idea? :disappointed:

Another hack i installed maybe?
I have installed:
Arcade Hack 1.0.2
Prevent Doubleposting 1.2b
Only this two hacks... and now this... but with problems :(

[Natch]

A while back, I asked if it would be possible to have this hack (specifically the part with relation to the Global Ignore/Tachy of all Troll Banned users) apply only after a certain date ... the reason I asked for it was to deal with the scenario of a Good User (or even a ex-Mod) having gone bad and needing to have their posts, or the content of them, hidden from the general public ...

[kind of a specific request you say? damn straight ... with Erwin so busy, no wonder he said " Ummm ... nah ... too busy " and I don't blame him :D]

So I wrote my own (https://vborg.vbsupport.ru/showthread.php?t=64735) - hope it is helpful to some of you ... it aint perfect (as it's got the date hardcoded, like the usergroup is) but for my requirements it's good enough as the group of Mod's who have gone over to the dark side went off at the same time (approximately) so I hardcoded it from the start of a certain year ...

Please ask in the Addon thread if I can help with altering it to your needs ...

[AN-net]

does this work with vb 3.0.0?

[msimplay]

does this work with vb 3.0.0?
yep i have this hack on vb3.0.0

[NexVision]

ok the problem im having is whenever you go to ban or warn someone it inputs the username of the person doing the banning or warning..

screens attached

I have repeated the install for this 5 times and reverted twice please help.


www.nextelmodz.com/downloads/Capture_207.gif

www.nextelmodz.com/downloads/Capture_208.gif

Still cant use attachments can someone please help with that at least.

[Mobo]

Great hack!! Worked the first time on 3.0.1 with out any problems!! Thanks!!

[Mobo]

Opps, I seemed to have found a problem. I've Warned a member twice (just for testing) and neither one of them show up in his warning level.

I'm running vB 3.0.1 and the install went perfect. Any thoghts on why they are not showing up?

Thanks.

[ImportPassion]

in the title it says "make posts invisible". WHere is that?

[ImportPassion]

ok the problem im having is whenever you go to ban or warn someone it inputs the username of the person doing the banning or warning..

screens attached

I have repeated the install for this 5 times and reverted twice please help.


www.nextelmodz.com/downloads/Capture_207.gif

www.nextelmodz.com/downloads/Capture_208.gif

Still cant use attachments can someone please help with that at least.

nice screen shots
68.209.xxx.xxx SORRY BUDDY NOT HERE NOW BEAT IT!!! Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2; .NET CLR 1.0.3705)

[Natch]

The posts become invisible when you delete the contents of the global_ignore template ...

[sabret00the]

does this send a pm to the person who got warned to tell them?

and does it log who warned who and what for?

[msimplay]

does this send a pm to the person who got warned to tell them?

and does it log who warned who and what for?
well it doesn't by standard

but i suggest u use this (https://vborg.vbsupport.ru/showthread.php?t=65336) warning system and its more comprehensive

however i did use the postbit modifications from Erwins hack
except for the warning bit of course

i used it coz i like the ability to edit signatures , avatars etc

[sabret00the]

well it doesn't by standard

but i suggest u use this (https://vborg.vbsupport.ru/showthread.php?t=65336) warning system and its more comprehensive

however i did use the postbit modifications from Erwins hack
except for the warning bit of course

i used it coz i like the ability to edit signatures , avatars etc
what are the pluses of the version you pointed out over this one?

[msimplay]

what are the pluses of the version you pointed out over this one? ok the main pluses are
pms users on warning
you can set warning types via admin cp
logs all warnings so you can check them at a later date
and u can check by who they were done and why

and biggest plus is that its very supported with regards to updates
i was posting my suggestions in that thread not long ago

but with regards to the hack in this thread Erwin has already started he doesn't want to work on this hack

also check the thread i posted in my last post it has some screenshots of it aswell

[Mr. HillBilly]

ok the main pluses are
pms users on warning
you can set warning types via admin cp
logs all warnings so you can check them at a later date
and u can check by who they were done and why

and biggest plus is that its very supported with regards to updates
i was posting my suggestions in that thread not long ago

but with regards to the hack in this thread Erwin has already started he doesn't want to work on this hack

also check the thread i posted in my last post it has some screenshots of it aswell

ZT's hack is ok, but not coded verywell.

[msimplay]

ZT's hack is ok, but not coded verywell.

not coded very well in what way ?
works perfect for me and its definitely better then Erwins version
which doesn't have the same functionality as ZT's either

[Fanboys Suck]

4. When a call is made to warn.php, all I get is a blank screen. I'm working on tracking that down as we speak.

I'm having the same problem. Anyone know how to fix this?

[Erwin]

I'm having the same problem. Anyone know how to fix this?
Was the warn template added?

[Fanboys Suck]

Yeah, the template is there. I guess I'll just go through everything again. I must be missing something...

[The Realist]

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.

[The Realist]

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

[Erwin]

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


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

[The Realist]

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 :)

[The Realist]

Any ideas on this one M8

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.

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

[The Realist]

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

Any ideas on this one M8



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

[ImportPassion]

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

[Erwin]

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.

[The Realist]

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?

[Erwin]

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 ().

[The Realist]

1) I have twice
2) I was refuring to a member that has been banned and no figure shows.

[bad-dvir]

i have a problam
i installed this hack but i don"t have the dropdown username
i have the 3 options on my control panel but not in the dropdown username?
what i can do?

[The Realist]

Do all other dropdown menu's work?

[bad-dvir]

the dropdown in the navbar work but not in the username!

[Erwin]

1) I have twice
2) I was refuring to a member that has been banned and no figure shows.
I can't understand why it wouldn't since many more members have installed it and it does work.

[Natch]

One thing I have noticed recently - the /modcp/ and /admincp/ directory names are hardcoded into the templates - shouldn't this pull the variables from the includes/config.php ?

[The Realist]

I'll have another go.

I can't understand why it wouldn't since many more members
have installed it and it does work.

[The Realist]

Re installed this hack and now I have points showing between the brackets. But I still have the "Ban or Suspend user" I get a blank page "404 error"?

Also

If I click "Unban or Unsuspend" I get "Invalid User Specified"

Any ideas?

[SnowBot]

I have just upgraded to 3.0.3 and all is working fine apart from the warning points. They do not seem to increase when you add a point, any ideas as i have checked the code and the templates were from before the upgrade so are ok.?

[Erwin]

Don't know why it wouldn't work.

Anyway, I'm going to update this hack to add a proper warning system, with automatic PM, automatic notification of which rule is broken, a warning list page... I'm doing this for my site, and will release it once it's finished. :)

[SnowBot]

aahh that sounds great. Any idea on time scale. I am only asking as i will ununistall this and install the new one when its out.

[HuangA]

I installed this on a 3.0.3 installation; after following all the instructions etc, I was able to get the menu to appear; but when I click warn user, the new window comes out blank! Is this hack compatiable with 3.0.3? Did I do something wrong?

Ok, here's what I found out after some reading...

The code is looking for "warn" template, which I did not add because it was NOT included in the package. Can someone please kindly post the warn/warning template that we're suppose to add?

[Bro_Joey_Gowdy]

clicks install

[johngdk]

I have had the excact samt problem. But was a little confused about the post from "Zero Tolerance". Here the hole edited code-section. I hope this can help others:


$getthreadids = $DB_site->query("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, " . TABLE_PREFIX . "user.usergroupid AS usergroupid
FROM " . TABLE_PREFIX . "thread AS thread
$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON " . TABLE_PREFIX . "user.userid = postuserid
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
AND visible = 1
AND usergroupid<>24
$globalignore
$datecut
$limitothers
$delthreadlimit
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");






Someone else has had this error, and im getting it too

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb3_thread AS thread
LEFT JOIN vb3_user ON user.userid = postuserid
WHERE forumid = 5
AND sticky = 0
AND visible = 1
AND usergroupid&lt;&gt;17

AND thread.lastpost &gt;= 1075634033


ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

Ive redone edits for all files, still didn't work, maybe if you could point out the exact edit that fixes this that might help, but i dont see any ive missed and ive gone through them all

Edit:

I fixed it, in the code i changed user. (2 times) to
" . TABLE_PREFIX . "user.

Seems those with a prefix may have trouble with this ;)

[johngdk]

There are missing som "TABLE_PREFIX" lines ind the file warn.php

Here are my code-section (that works for me)

if ($action == "doadd") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield+1 WHERE userid='$newuser'");
if ($warnings >= $warnpoints) {
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid=$banusergroupid, usertitle='Banned' WHERE userid='$newuser'");

}
$error = "<b>Message:</b> You have warned this member!";
$show['closewindow'] = true;
}
if ($action == "dominus") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield-1 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
$show['closewindow'] = true;

}
if ($action == "doreset") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=0 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
$show['closewindow'] = true;

[ImportPassion]

for some reason I am getting a 500 error on this now. i think it was the 3.02 upgrade, but not sure when it happened

[Seekers]

This was my first attempt at installing a hack and I apparantly blew it. When I click on a users name I only get the default option instead of the hack options to ban, warn, etc.

Anyone have any idea what I did wrong. I was very careful and deliberate as I went through the instructions but must have missed something.

Thanks,

[Dennis Olson]

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!

[Erwin]

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!
It works for 3.0.3 - actually, I installed integrated my hack with the other warning hack, and added a whole bunch of stuff including PM user on thread delete/ closure/ move, email user on ban, a whole lot of stuff. :) This hack is actually redundant. I can't release my current system as I'm using code from the other warning hack.

[SnowBot]

It works for 3.0.3 - actually, I installed integrated my hack with the other warning hack, and added a whole bunch of stuff including PM user on thread delete/ closure/ move, email user on ban, a whole lot of stuff. :) This hack is actually redundant. I can't release my current system as I'm using code from the other warning hack.
I know you can not release the whole hack as like you said you used some code from it, but anychance you may release add-ons for it :) So we have the best of both? I love this hack but i was hanging around for the updates.

[Erwin]

I know you can not release the whole hack as like you said you used some code from it, but anychance you may release add-ons for it :) So we have the best of both? I love this hack but i was hanging around for the updates.
I would love to release the integrated hack - the ultimate vB moderating system hack. :) Everything is automated - from one-click thread moves to a trash bin forum, to one-click post split and moves, with automatic PMs/ emails to the member on all moderator actions, automatic thread creations of moderator actions in separate staff forums etc. Like I said, this hack has been quite redundant. The only problem in releasing it is that it's quite complex, and builds on this original hack and the other warning hack quite extensively - writing the instructions would be a nightmare. :) Not to mention the template mods involved in postbit and showthread, and the moderator php files!

[pcalloway]

Am in the midst of applying this hack and on the step where I'm to edit the "postbit" template and replace this code:

<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>

Problem is, I cant find anything like that. The postbit does appear to have been edited by a prior hack. Anywhere else I can put the code?

[pcalloway]

Am in the midst of applying this hack and on the step where I'm to edit the "postbit" template and replace this code:

<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>

Problem is, I cant find anything like that. The postbit does appear to have been edited by a prior hack. Anywhere else I can put the code?


Got that plugged in somewhere and it seems to be working with the notable exception that when I pull up the drop-menu, no 'Warning Score' is showing up between the parantheses. I presume whatever score they've accumulated (1-7) should show up there. I can go into the User Profile in the admincp and see it there... how do i get it reflecting in the vbmenu in the postbit?

[68 Z-28]

Just installed the hack and so far so good.

Only thing I ask is: Do the moderators have the ability to subtract points or are the admins the only ones allowed to do so. Also, is there any way that we can see who warned the user?

[the wiz]

I don't have time to look through 17 pages, so I don't know if this has already been discussed.

My vBulletin tables start with vb_ and when I go to the warning points thing, it is looking for vb.

How can I change this?

[the wiz]

Also, when I edit the forumdisplay.php file, the following lines:

SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, user.usergroupid AS usergroupid

$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON user.userid = postuserid

AND usergroupid<>17

give me the following SQL Error when someone tries to view one of the forums:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb_thread AS thread
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') LEFT JOIN vb_user ON user.userid = postuserid
WHERE forumid = 16
AND sticky = 0
AND visible = 1
AND usergroupid<>8



AND deletionlog.primaryid IS NULL
ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Friday 03rd of September 2004 05:50:45 PM

[AnhTuanCool]

Works perfectly :D

One more thing I want to make sure, if I edit my member in that pop-up to modcp/user.php, would I be logged in Moderator Logs or in any logs? ;)

[Erwin]

Works perfectly :D

One more thing I want to make sure, if I edit my member in that pop-up to modcp/user.php, would I be logged in Moderator Logs or in any logs? ;)
Yes. :)

Glad to hear it still works.

[AnhTuanCool]

Oh thanks, Erwin, that's great ;) Keep up with great work

[68 Z-28]

What would it take to add a log file of who warned who? Perhaps something in the admin CP that's listed, much like the banned users. What would be included for each entry? User warned, Moderator, link to post, amount of warning points issued, ammount of warning points total for the warned user. Would that be very hard to do?

Also, is there a way to limit the removal of points to solely the admins?

Thanks for the wonderful hack Erwin, works great so far.