Advanced Warning System (AWS)

Advanced Warning System Version 3.5.0

The AWS version for vB 3.5 has been released. You can download it and get support in this thread:

https://vborg.vbsupport.ru/showthread.php?p=770032


Advanced Warning System Version 3.4.16 (latest stable release for vB 3.0.x)


LATEST ANNOUNCEMENT

The AWS has its own Premium Forum here at vBulletin.org, so please use that for questions and discussion on this hack.

The Permium Forum is located at :

https://vborg.vbsupport.ru/forumdisplay.php?f=105





This Warning System owes its existence to Zero Tolerance's Warning Hack (https://vborg.vbsupport.ru/showthread.php?t=65336). I liked the idea, so I installed Zero's hack in my forums site. However, as in most cases, I was not fully satisfied with the way it worked, so I started customizing it. Other people in the thread above, asked questions, which I had already answered by my customizing work, so I answered, giving away those parts of the code, that I had modified.

In the long run, I almost hijacked the thread and the hack from Zero, so I guess I owe him an apology. However, the mods I did have compiled a new, more complete warning system, with much more functionality. Several members from that thread, asked if this could be released as a new hack, so after discussing it with Zero, here it is.

What it does? Well, it is a Warning System, which means it allows you (the administrative team of your site, in other words the admins, the supermods and the mods), to define offences, which the members of your forum should NOT commit. But as we all know, there are instances where members do not follow the rules. In that case, this warning system, allows you to issue a warning to the member who commited the offence. The warning has some points associated with it, as well as a period over which it is valid. When a member gathers enough points, he is banned from your forums, for a predefined period of time. That's mostly it, but below, you can find a short list of features:

Full warning system with:

- post- and non-post-related warnings
- hierarchical warning schema
- hidden or real warners
- customizable maximum warning points
- automatically bans members who reached the maximum warning points
- customizable ban days
- customizable ban user group and permanent ban user group
- customizable restore user group, where users are restored after they get unbanned
- customizable option for who can see the warning level of the members
- automatically issued warnings for posts which contain censored words
- automatically issued warnings for private messages which contain censored words
- supports incremental banning periods
- supports multiple warnings for the same post
- warned members are notified either by Private Message or e-mail when they are warned and when one of the warnings they have received is either deleted or expired
- maintains historical listings of issued warnings (even if deleted or expired)
- customizable warning types
- each warning type has predefined warning points associated with it
- each warning type has predefined maturity period, after which it is automatically deleted
- reports for admin, mods and members
- cron job included to automatically remove matured warnings
- uses vBulletin's cron job, to automatically unban banned users
- all options are setable in your AdminCP
- user warning points and number of bans viewable in your AdminCP User Manager.
- statistics show warning per type, warnings per warner, bans per user.
- Allows you to warn a user from your AdminCP/User Manager.
- Large "Warn" sign, in posts which have received a warning, for mods, supermods and admins, to easily distinguish those posts.
- Ability to remove user's avatar, signature or usage of the Private Messaging system, depending on the warning points he has collected.
- Supports non-standard admins, supermods and mods user groups.
- Allows you to save a copy of the warning send to the warned user, in a predefined forum.
- Allows you to issue "Alerts" (warnings without warning points, for first-time offenders)
- Allows you to add private or public notes for a user, either post-specific or not. Notes appear in the postbit, above each user's message.
- etc.

Admitedly, this is not an easy hack to install. It requires 20 new templates and modifications to some existing ones too. It requires five new tables and modifications to some others. It requires several new phrases. I've tried to make the installation, as easy as I could, by automating certain tasks in an automatic installer. The installer will add the new templates for you, add the new tables required and change the existing ones, and will add the required new phrases. You will have to manually edit the existing templates and the php files though. I also included an upgrade script, which will upgrade those who are using Zero Tolerance's warning hack (version 1.5) to this one. An uninstaller is also included, which removes what the installer installs.

Please keep in mind, that this is a very difficult hack to install. For this reason, I strongly recommend that you back up your database before starting the installation. I also suggest that you keep copies of each file and template you edit, so that you can always revert to a previous stable condition. Finally, I strongly suggest that you always run the latest release.

The zip file always contains both the instructions and the files required to install the latest version. If you have installed a previous version and want to upgrade to the latest, there is a text file attached, in the zip with upgrade instructions. Follow them.

In this thread, you will also find a more detailed document describing the features of this hack, as well as a document describing its version evolution.

Also keep in mind that the installer, will add the AWS templates only to your default style. If you want to use them in another one, you may try this Zero Tolerance's hack, which copies the templates to other styles you may have.

Another thing, the installation instructions were written when vB was at release 3.0.3, so you may expect to find some differences, with the latest files and templates. As far as I can tell, I haven't faced any such case, but I post this reservation here, since I do not have the time to recheck all the instructions for compliance with the latest vB release. The hack has been installed and is working fine with the vBulletin version shown at the top of this thread.

Finally, if you are using more than one style, the installer will install the templates only in the default one. If you want to use the rest of your styles, here is a hack, that will do this for you.

This hack can also be integrated with Zero Tolerance's vBChat. However, since I am using a heavily-modified version of vBChat, I haven't included instructions, on how to patch the original vBChat files, in the documentation. If you are interested in having AWS issue automatic warnings when one of your user enters a censored word in a vBChat message, or if you want your moderators to be able to warn a user, who misbehaves in vBChat, please post a thread in this forum and I'll help you through.

This is my first officially released hack, so please don't be to harsh with me, if I broke any rules or made any mistakes. The mods have been tested extensively, both by me and two volunteers (thank you gentlemen), but I am only human.

Closing, let me thank Zero Tolerance, who got me started in this, and who owns a big part of the code of this hack. I definnitely couldn't have done it, without his code.

Special Note
For those who upgrade from Zero Tolerance's hack to my AWS, even though I have included a script which will do some of the work automatically, not everything is done by that script. Read the installation instructions carefully. You have to run the upgrade script first and then do several things manually. If you just run the upgrade script and just upload the files, the AWS will not work properly. If you have any questions, please do not hesitate to post here.

Also, let me add here, that version 3.3.0 wouldn't have been possible without the contribution of Revan.

And a couple of warnings:

PLEASE DOWNLOAD THE LATEST ZIP FILE FROM HERE, BEFORE YOU START INSTALLING THIS HACK. JUST BECAUSE YOU DOWNLOADED IT A COUPLE OF DAYS AGO, THAT DOES NOT MEAN IT IS THE LATEST VERSION. MAKE SURE YOU DOWNLOAD THE ZIP, JUST BEFORE YOU START INSTALLING THIS HACK.


LATEST VERSION

Version 3.4.16 (released Thursday August 25th, 2005 GMT 18:18)

A couple of bugs fixed in this version. One is related to the Notes feature, and it allowed plain users to see the notes entered, if the "Who can view warning points" setting was set to "All".

Features.txt a new version of this file has been uploaded on April 4th2 005 GMT 09:30, which covers the latest additions to the hack. The original Features.txt file hasn't been updated since the first release of this hack, so it was time for an update.

John

[Revan]

Hehe.
Well a way to educate the admins then would be to add this instead of "$options['warn_perpage']" in the above example: "standard_error('You are too stupid to add proper values, so unless you fix this, the hack will not work.')"


(the above should be taken with an open mind, as it was a joke and in no way an attempt to insult Samir, since it wasn't even his fault )

[xoor]

correct me if i'm wrong but when you set the "Allow Off-Post Warnings?" to yes, isnt the 'warn x' and view x's warnings links suppose to show in the users profile, like they do in posts...

[SamirDarji]

Originally Posted by sv1cec

OK, the description of each table is (more or less) shown inside the install_warn.php file, found inside the admincp directory in the upload directory of the zip.

Check them out and let me know where you stand.

Or you may try the uninstaller and start from scratch. It will remove the additional template, tables and phrases, and then you can run install_warn.php from scratch.


Rgds

The upgrade installer upgrade_warn.php completed everything up to line 188. For some reason, it just didn't finish the last part of the upgrade. So how do I make it complete the last part? Is there a way to just run some queries manually or is there some more stuff to it than that?

[SamirDarji]

Originally Posted by xoor

correct me if i'm wrong but when you set the "Allow Off-Post Warnings?" to yes, isnt the 'warn x' and view x's warnings links suppose to show in the users profile, like they do in posts...

Yes, I believe it should. Check your template mods and make sure you're not missing anything.

[sv1cec]

Originally Posted by xoor

correct me if i'm wrong but when you set the "Allow Off-Post Warnings?" to yes, isnt the 'warn x' and view x's warnings links suppose to show in the users profile, like they do in posts...

Yes, they should.

[sv1cec]

Originally Posted by SamirDarji

The upgrade installer upgrade_warn.php completed everything up to line 188. For some reason, it just didn't finish the last part of the upgrade. So how do I make it complete the last part? Is there a way to just run some queries manually or is there some more stuff to it than that?

You can certainly run some queries manually, but if you are not know what you are doing, it might be a problem. I suggest you uninstall and re-install from scratch. How many warnings did you have with Zero's hack?

Rgds

[xoor]

If its not too much of a problem, would someone be so kind to check my MEMBERINFO for the problem...

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $vbphrase[view_profile]: $userinfo[username]</title>
$headinclude
</head>
<body>
$header
$navbar

<!-- main info - avatar, profilepic etc. -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead">
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr>
<td class="thead">$vbphrase[view_profile]<span class="normal">: $userinfo[username]</span></td>
<!-- checks for warning system -->
<td class="thead" align="right">
<div class="smallfont" style="float:$stylevar[right]">
<if condition="THIS_SCRIPT=='member' AND $warn_options[allowoffpost]=='Yes'">
<if condition="$hierarchical=='No'">
<if condition="($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7">
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related)</a> ? <a href='Warn.php?do=ViewWarnings&id=$userinfo[userid]'>View $userinfo[username]'s Warnings</a>
</if>
<if condition="$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
<if condition="$hierarchical=='Yes'">
<if condition="($userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7 AND ($bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7)) OR ($userinfo[usergroupid]==7 AND $bbuserinfo[usergroupid]==5) OR ($bbuserinfo[usergroupid]==6 AND $userinfo[usergroupid]!=6)">
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related)</a> ? <a href='Warn.php?do=ViewWarnings&id=$userinfo[userid]'>View $userinfo[username]'s Warnings</a>
</if>
<if condition="$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
</if>
<!-- end of warning system -->
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="alt2">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td style="border-bottom:1px solid $stylevar[tborder_bgcolor]" colspan="3">
<if condition="$userinfo['rank'] OR $userinfo['reputationdisplay']">
<div style="float:$stylevar[right]; padding:4px">
<if condition="$userinfo['rank']"><div align="center">$userinfo[rank]</div></if>
<if condition="$userinfo['reputationdisplay']"><div align="center">$userinfo[reputationdisplay]</div></if>
</div>
</if>
<div style="font-size:18pt">$userinfo[musername]</div>
<if condition="$userinfo['usertitle']"><div class="smallfont">$userinfo[usertitle]</div></if>
</td>
<td style="border-bottom:1px solid $stylevar[tborder_bgcolor]" align="$stylevar[right]">
<div class="smallfont">
<b>User ID :</b> $userid
<if condition="$viewoption=='All'">
<if condition="$userinfo[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $userinfo[warning_level]
<font color="#000000">
</if>
<if condition="$userinfo[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $userinfo[warning_bans]
<font color="#000000">
</if>
</if>
</div>
<if condition="$viewoption=='Mgm' AND $hierarchical=='Yes'">
<if condition="($bbuserinfo[usergroupid]==7 AND $userinfo[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7)
OR
($bbuserinfo[usergroupid]==5 AND $userinfo[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==5 AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5)
OR
($bbuserinfo[usergroupid]==6)
">
<if condition="$userinfo[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $userinfo[warning_level]
<font color="#000000">
</if>
<if condition="$userinfo[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $userinfo[warning_bans]
<font color="#000000">
</if>
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='No' AND
(
$bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR
$bbuserinfo[usergroupid]==6
)">
<if condition="$userinfo[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $userinfo[warning_level]
<font color="#000000">
</if>
<if condition="$userinfo[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $userinfo[warning_bans]
<font color="#000000">
</if>
</if>
</td>
<if condition="$show['profilepic']">
<td valign="middle" align="$stylevar[right]" rowspan="2" width="160">
<center><img src="image.php?u=$userinfo[userid]&amp;type=profile&amp;dateline=$userinfo[profilepicdateline]" alt="<phrase 1="$userinfo[username]">$vbphrase[xs_picture]</phrase>" border="0" style="border:1px solid $stylevar[tborder_bgcolor]" /></center>
</td>
</if>
</tr>
<tr valign="top">
<if condition="$show['avatar']">
<td colspan="3"><img src="$userinfo[avatarurl]" alt="<phrase 1="$userinfo[username]">$vbphrase[xs_avatar]</phrase>" border="0" style="border:1px solid $stylevar[tborder_bgcolor]; border-top:none" /></td>
<else />
<td colspan="3">&nbsp;</td>
</if>
<td class="smallfont" valign="bottom" align="$stylevar[right]">
<if condition="$show['lastactivity']">
<div>$vbphrase[last_activity]: $userinfo[lastactivitydate] <span class="time">$userinfo[lastactivitytime]</span>&nbsp;</div>
</if>
<if condition="$show['currentlocation']">
<div><if condition="$userinfo['action']">$userinfo[action] $userinfo[where]<if condition="$show['detailedtime']"> - <else /> @ </if> $userinfo[time]<else />$vbphrase[offline]</if>&nbsp;</div>
</if>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- / main info - avatar, profilepic etc. -->

<!-- button row -->
<if condition="$show['profilelinks']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
<tr align="center">
<if condition="$userinfo['showvcard']">
<td class="vbmenu_control"><a href="member.php?$session[sessionurl]do=vcard&amp;u=$userinfo[userid]">$vbphrase[download_vcard]</a></td>
</if>
<if condition="$show['member']">
<td class="vbmenu_control">
<if condition="$show['addbuddylist']">
<a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[add_x_to_buddy_list]</phrase></a>
<else />
<a href="profile.php?$session[sessionurl]do=removelist&amp;userlist=buddy&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[remove_x_from_your_buddylist]</phrase></a>
</if>
</td>
<td class="vbmenu_control">
<if condition="$show['addignorelist']">
<a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=ignore&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[add_x_to_ignore_list]</phrase></a>
<else />
<a href="profile.php?$session[sessionurl]do=removelist&amp;userlist=ignore&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[remove_x_from_your_ignorelist]</phrase></a>
</if>
</td>
</if>
<if condition="can_moderate()">
<td class="vbmenu_control"><a href="moderator.php?$session[sessionurl]do=useroptions&amp;u=$userinfo[userid]">$vbphrase[user_options]</a></td>
</if>
</tr>
</table>
</if>
<!-- / button row -->

<br />

<if condition="$show['signature']">
<!-- signature row -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead">$vbphrase[signature]</td>
</tr>
<tr>
<td class="alt1" title="$vbphrase[signature]">$userinfo[signature]</td>
</tr>
</table>
<!-- / signature row -->
<br />
</if>


<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" width="50%">$vbphrase[forum_info]</td>
<td class="tcat" width="50%">$vbphrase[contact_info]</td>
</tr>
<tr valign="top">

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<div style="padding:$stylevar[formspacer]px">
$vbphrase[join_date]: <strong>$userinfo[datejoined]</strong>
</div>
</div>

<fieldset class="fieldset">
<legend>$vbphrase[posts]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>
$vbphrase[total_posts]: <strong>$userinfo[posts]</strong> (<phrase 1="$postsperday">$vbphrase[x_posts_per_day]</phrase>)
</td>
</tr>
<if condition="$vboptions['profilelastpost']">
<tr>
<td>
$vbphrase[last_post]:<br />
<a href="$userinfo[lastposturl]">$userinfo[lastposttitle]</a><br />
$userinfo[lastpostdate] <span class="time">$userinfo[lastposttime]</span>
</td>
</tr>
</if>
<tr>
<td><a href="search.php?$session[sessionurl]do=finduser&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[find_all_posts_by_x]</phrase></a></td>
</tr>
<tr>
<td><a href="search.php?$session[sessionurl]do=process&amp;showposts=0&amp;starteronly=1&amp;e xactname=1&amp;searchuser=$userinfo[urlusername]"><phrase 1="$userinfo[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></td>
</tr>
</table>
</fieldset>

<if condition="$vboptions['usereferrer']">
<div class="fieldset">
<div style="padding:$stylevar[formspacer]px">
$vbphrase[referrals]: <strong>$referrals</strong>
</div>
</div>
</if>

<if condition="$show['usernotes']">
<div class="fieldset">
<div style="padding:$stylevar[formspacer]px">
$vbphrase[user_notes]: <strong>$usernote[total]</strong> [<a href="usernote.php?$session[sessionurl]u=$userinfo[userid]">$vbphrase[view]</a>]
<if condition="$show['usernotetotal']">
<br />($vbphrase[last]: $usernote[lastpostdate] <span class="time">$usernote[lastposttime]</span>)
</if>
</div>
</div>
</if>

</div>
</div>
</td>

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<if condition="$show['homepage']">
<tr>
<td>
$vbphrase[home_page]:<br />
<a href="$userinfo[homepage]" target="_blank">$userinfo[homepage]</a>
</td>
</tr>
</if>
<tr>
<td>
$vbphrase[email]:<br />
<a href="sendmessage.php?$session[sessionurl]do=mailmember&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[send_message_via_email_to_x]</phrase></a>
</td>
</tr>
<if condition="$userinfo['pm']">
<tr>
<td>
$vbphrase[private_message]:<br />
<a href="private.php?$session[sessionurl]do=newpm&amp;u=$userinfo[userid]"><phrase 1="$userinfo[username]">$vbphrase[send_private_message_to_x]</phrase></a>
</td>
</tr>
</if>
</table>
</div>

<if condition="$show['hasimicons']">
<fieldset class="fieldset">
<legend>$vbphrase[instant_messaging]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<if condition="$userinfo['showicq']">
<tr>
<td>$userinfo[icqicon]</td>
<td><a href="#" onclick="return imwindow('icq', '$userinfo[userid]', 500, 450)">$userinfo[icq]</a></td>
</tr>
</if>
<if condition="$userinfo['showaim']">
<tr>
<td>$userinfo[aimicon]</td>
<td><a href="#" onclick="return imwindow('aim', '$userinfo[userid]', 400, 200)">$userinfo[aim]</a></td>
</tr>
</if>
<if condition="$userinfo['showmsn']">
<tr>
<td>$userinfo[msnicon]</td>
<td><a href="#" onclick="return imwindow('msn', '$userinfo[userid]', 400, 200)">$userinfo[msn]</a></td>
</tr>
</if>
<if condition="$userinfo['showyahoo']">
<tr>
<td>$userinfo[yahooicon]</td>
<td><a href="#" onclick="return imwindow('yahoo', '$userinfo[userid]', 400, 200)">$userinfo[yahoo]</a></td>
</tr>
</if>
</table>
</fieldset>
</if>

</div>
</div>
</td>

</tr>
<tr>
<td class="tcat" width="50%">$vbphrase[additional_information]</td>
<td class="tcat" width="50%">$vbphrase[group_memberships]</td>
</tr>
<tr valign="top">

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<if condition="$userinfo['birthday'] OR $customfields">
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<if condition="$userinfo['birthday']">
<tr>
<td>
<strong>$vbphrase[birthday]</strong>:<br />
$userinfo[birthday]
</td>
</tr>
</if>
$customfields
</table>
<else />
<em>$vbphrase[n_a]</em>
</if>
</div>

</div>
</div>
</td>

<td class="panelsurround" align="center">
<div class="panel">
<div align="$stylevar[left]">

<div class="fieldset">
<table cellpadding="0" cellspacing="$stylevar[formspacer]px" border="0">
<tr>
<if condition="$show['membergroups']">
<td><strong><phrase 1="$userinfo[username]">$vbphrase[x_is_a_member_of_the_following_groups]</phrase></strong>:</td>
<else />
<td><strong><phrase 1="$userinfo[username]">$vbphrase[x_is_not_a_member_of_any_public_groups]</phrase></strong></td>
</if>
</tr>
$membergroupbits
</table>
</div>

</div>
</div>
</td>

</tr>
</table>

$footer

</body>
</html>

[nubian]

i'm very new to vb.
i need something like this because i have quite a few +++++++s on my board.
i'm about to install it.
wish me luck! :nervous:

[SamirDarji]

Originally Posted by sv1cec

You can certainly run some queries manually, but if you are not know what you are doing, it might be a problem. I suggest you uninstall and re-install from scratch. How many warnings did you have with Zero's hack?

Rgds

I didn't have any warnings at all with ZT's hack. I just installed it and was going to start modding it with your additions.

Logically, I can follow code quite well. It's kinda wierd that the last 2 queries didn't run since it was all in an array.

I'm pretty familiar with queries, but I don't know the exact format (especially when taking them out from php). If you could just let me know if this query is right, then I think I've got the query part down (I have no table prefix):

alter table warning_options 
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

[sv1cec]

Originally Posted by SamirDarji

I didn't have any warnings at all with ZT's hack. I just installed it and was going to start modding it with your additions.

Logically, I can follow code quite well. It's kinda wierd that the last 2 queries didn't run since it was all in an array.

I'm pretty familiar with queries, but I don't know the exact format (especially when taking them out from php). If you could just let me know if this query is right, then I think I've got the query part down (I have no table prefix):

alter table warning_options 
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

My friend, if you had no warnings in ZT's hack, delete everything and start from scratch. Why bother?

The query above is the one which modifies ZT's table to mine, but it is an older version, it does not have the 'version' column, download the last zip and get it from the upgrade_warn.php file.

Rgds