Warnings System Hack v2.1

[g-force2k2]

Latest Version Warnings System Hack v2.1 Can be Found [ Here ] (https://vborg.vbsupport.ru/showpost.php?s=&postid=296385)

After a Successful first release i decided to make a more customizeable and more optimizeable Warnings Hack :) well here it is...

For new installers simply run the auto installer (install_warning.php) and then use the installation_txt.php to make template and file modifications.

For members that have used my version 1.0 simply make the changes listed in the warn_upgade.php then delete all custom templates and run one query listed in the upgrade file. Then run the installer.

Thanks as always for GoldKnight's assistance ;)

Version 2.1?
Comes with the Warning System Settings Inserted Directly into the VBulletin Settings to prevent problems...

Features
// ++++++++++++++++++++
Warnings Hack System (version 2.0)
* Easy Installation / Uninstallation with Warning Installer (includes all queries & templates) [new]
* Now instead of based upon a set warning level it includes seperate distict warning points [new]
* Includes new warning customization for different levels of warning [new]
* Includes new Email Warning feature for regular useage or more importantly pm disabled users [new]
* Ban Limit is now activated once a user's Warning Level is over the configured amount of Warning Points (Not Just Single Warnings) [new]
* Includes New Customizeable Templates [new]
* Emailing and Private Messaging Warning [new]
* Emailing Ban Message [new]
* Warnings Listings [new]
* Includes Viewable List of all Admin Created Warnings for reference to know what is not accepted [new]
* In a sense its a rules hack included with the Warning Hack [new]
* Categorized And Ordered According to Admin Preferences [new]
Warn Config (extremely optimizeable)
* Includes Setable Banned by Warnings usergroup
* Includes Setable Warning Level (maximum warning points)
* Includes Easy Usergroup Configuration For [new]
* Usergroups that can Warn [new]
* Usergroups that can View Warnings [new]
* Usergroups that can view their Warning Levels [new]
* Usergroups that are exempt from warning [new]
* Includes New Warning Functions & Optimizes all Permissions [new]
* Includes Emailing Banning Option [new]
Admin CP Based
* Create Custom Warnings [new]
* Includes Customizeable New Configuration for Different Level Warnings [new]
* Create your own Categories of Warning Levels [new]
* Configure Warning Points to each different Warning [new]
* Includes a list of Warning Logs
* Who warned who?
* Date & Warning Type & Warning Comments [new]
* Post from which warning resulted
* Includes List of All Warned Users
* Includes Warning Point Deductor [new]
* Includes Email Notification after Banning [new]

Hope that everyone enjoys this hack as much as the first :p Comments and Suggestions are welcomed...

If you like this hack i'd be greatful if you clicked install :) thanks in advance and Enjoy...

Screenshots are nex :p

[Edit]See link below for more information regarding the upcoming vb3 version
vb3 version coming soon (https://vborg.vbsupport.ru/showpost.php?p=448212&postcount=593)

Note: the file warnconfig.php does not exist anymore instead the configurations are kept and updated in the vbulletin option panel.

For any further questions or help you may address them here or instead pm me.

As requested by Freezerator if you want a link in the pm/email that is sent to the user follow the instructions below.
Warned Post Link In PM Or Email (https://vborg.vbsupport.ru/attachment.php?attachmentid=15095)

g-force2k2

[g-force2k2]

Screenshot A :: The new Add Warning Template Look :)

Includes Email and Private Message Notification...

g-force2k2

[g-force2k2]

Screenshot B :: Add Warning Template where the user doesn't except Private Messages

g-force2k2

[g-force2k2]

Screenshot C :: Postbit Template Look

Notice the different permissions that it'll incorporate...

g-force2k2

[g-force2k2]

Screenshot D :: getinfo template look

Similiar to the postbit except only includes two options...

g-force2k2

[g-force2k2]

Screenshot E :: View Warning Template

g-force2k2

[g-force2k2]

Screenshot F :: The Warnings Listings (for members knowledge)

Kind of like a rules hack :p

g-force22k2

[g-force2k2]

Screenshot G :: Admin CP Modifying Warnings

g-force2k2

[g-force2k2]

Screenshot H :: Admin CP Warned Listing

g-force2k2

[g-force2k2]

Screenshot I :: Admin CP Warning Logs

Notice: This is only a select number of features... install it and get a feel for what yo can do ;) Enjoy..

g-force2k2

[Chris M]

Great!:)

*installs*

Satan

[LOD-squa]

Looks good I might upgrade mines.

[[D]Vincent]

I will definately upgrade mine soon ^^

BTW just wondering but they have to write something down in the comment box right? because I liked that.

[g-force2k2]

[D]Vincent no they don't have to... but it'll just put No Comment in place then... if you want comments to exist i'll show you how to do it... but you do have the reason that is set and the post to view... regards...

g-force2k2

[Okiewan]

This has got to be one of the most useful hacks I've seen! Thanks for the effort!

I installed the first version, everything worked well. Trying to up grade, I'm having difficulty with changing functions.php.

Instructions say:

find: (1)

unset($templatecache);

under it add:

require('warnconfig.php');

I'm using an older version, that line does not exist. This is what I found that comes close:
// cache templates
while ($temp=$DB_site->fetch_array($temps)) {
$templatecache["$temp[title]"]=$temp['template'];
}
unset($temp);
$DB_site->free_result($temps);

}

Any suggestions where to insert the require line?

Thanks in advance!

[g-force2k2]

you're correct Okiewan thats not a change its a new line included so you don't have to make any changes from the installation_txt.php ... should be like the tenth line of the admin/functions.php (its very close to the top) regards...

g-force2k2

[Kmaster]

version 2~~looks more perfect, You'd a good job, thanks for your shared

regards,

[KISS]

thanks upgraded with no problems

[Chris M]

Works like a charm:)

Im just testing the points thingy out...

http://www.darkblazes.com/forums/warn.php

Satan

[Okiewan]

I'm sorry I don't understand your reply???
I need to insert require('warnconfig.php');
in the functions file, but per the upgrade instructions, I can't find
unset($templatecache);

is that more clear?

[Okiewan]

In addition, the templates were not created because my template set is "12" :( (I created them manually from the install file).

[Chris M]

I just noticed something g-force...

In the postbit template, it says "Warning Level"...Shouldnt it say "Warning Points"?

Satan

[Chris M]

If you want to change "Warning Level:" in the Posbit to "Warning Points:", just edit :

template : warn_seelink
Replace :
<b>Warning Level:</b> $post[warninglvl]
with:
<b>Warning Points:</b> $post[warninglvl]

Satan

[Brandon]

I upgraded and now my pages dont load at all, just a white page.

I've gone through and done everything correctly...I'm a little confused :confused:

[g-force2k2]

hellsatan just a matter of preference i guess ;)

Okiewan: can you paste the first twenty lines of admin/functions.php? thanks

BrandonC: what other hacks do you have installed?

g-force2k2

[Okiewan]

<?php
error_reporting(7);

// start prep shutdown function
$noshutdownfunc = 0; // #CHANGE ME IF YOU CAN'T USE register_shutdown_function
$ourtimenow = time(); // Make this available to all files

// Defined constants used for user field.
// Hope to convert all user fields into one integer.
define ("SHOWSIGNATURES", 1);
define ("SHOWAVATARS", 2);
define ("SHOWIMAGES", 4);
define ("SHOWVBCODE", 8);

// ###################### Start getpagenav #######################
// template-based page splitting system from 3dfrontier.com :)
function getpagenav($results,$address) {
global $perpage,$pagenumber,$pagenavpages;

if ($results <= $perpage) {
return "";
}

$totalpages = ceil($results/$perpage);

if ($pagenumber>1) {
$prevpage = $pagenumber-1;
eval("\$prevlink = \"".gettemplate("pagenav_prevlink")."\";");
}
if ($pagenumber<$totalpages) {
$nextpage = $pagenumber+1;
eval("\$nextlink = \"".gettemplate("pagenav_nextlink")."\";");
}
while ($curpage++<$totalpages) {
if ( ( $curpage <= $pagenumber-$pagenavpages || $curpage >= $pagenumber+$pagenavpages ) &&

$pagenavpages!=0 ) {
if ($curpage==1) {
eval("\$firstlink = \"".gettemplate("pagenav_firstlink")."\";");
}
if ($curpage==$totalpages) {
eval("\$lastlink = \"".gettemplate("pagenav_lastlink")."\";");
}
} else {
if ($curpage==$pagenumber) {
eval("\$pagenav .= \"".gettemplate("pagenav_curpage")."\";");
} else {
eval("\$pagenav .= \"".gettemplate("pagenav_pagelink")."\";");
}
}
}
eval("\$pagenav = \"".gettemplate("pagenav")."\";");
return $pagenav;

}

I'm using 2.21

[FFMania]

Does this version run more queries than the first one? ;)

[Chris M]

@Brandon - This shouldnt cause it to happen...

Perhaps you need to make sure you didnt overwrite any templates?

Satan

[Brandon]

Originally posted by g-force2k2
BrandonC: what other hacks do you have installed?

g-force2k2

Oh god this list could go on forever...

[list=a]
[RELEASE v2] Run a SQL query directly from your admin contorl panel
Welcome Panel
Away Message
Blink PM Bar On New PM!
Users Browsing Forum (like vB.org)
Who Downloaded this Attachment?
vBStats
vBProArcade
vBMoods
Buddy Messenger v1.1
vbMicroStats: page load time, queries, GZIP and PHP version
[/list=a]

Im sure there are more, but I forget to push the install button sometimes. Those were the major ones though...

@Brandon - This shouldnt cause it to happen...

Yes, but it didnt do this until I upgraded, thats why I posted it :) ...

[g-force2k2]

Okiewan:

find:

define ("SHOWIMAGES", 4);
define ("SHOWVBCODE", 8);

under that add:

require('warnconfig.php');

BrandonC i know it has to do with the require... i will look into it... maybe conficts with the proarcade but im not sure...

FFMania not really no ;) regards...

g-force2k2

[Okiewan]

Seems that no matter what... if "require warnconfig.php" is inserted in admin/functions.php , I get a blank screen when going to the forums :(

[Chris M]

Have you uploaded "warnconfig.php" to the /admin directory?

Satan

[Okiewan]

yup...

[Goldknight]

Umm I have same problem that Okiewan had....

I tried last night and today, it got me blank page when I go to forum..

[g-force2k2]

okay i did a quick update and made the hack v2.1 to prevent all of this stuff attaching now :p

g-force2k2

[Goldknight]

But I test it on my local forum with clean forum and it s no problem. Until I add to hacked forum and it pop up and give me blank page ever since.

[Okiewan]

Cool :)

[g-force2k2]

Okay here's the new version... with the fixes... shouldn't have any trouble now... regards... instructions in the warn_upgrade2.php for upgrading to v2.0 to v2.1 regards...

g-force2k2

[The Realist]

Downloaded ver 2.1 and following the instructions it says to edit the warnconfig.php??? were is this warnconfig.php cos it aint in the zip?

Thanks.

[Okiewan]

2.1 Does not require it, in fact says to remove it from /admin .

2.1 took care of the blank screen issue... but odd that the warnlink will not show-up in postbit now :( I looked at the permissions written into admin/functions in this new version, but can't figure-out how it's defined (who can see the warning link in postbit. I'm assuming that's the problem with not being able to see it?

[Chris M]

Is it necessary to upgrade to 2.1 if we have 2.0 working?

Satan

[Brandon]

Yeah, the links show up for me, but they dont have the options like shown in the screenshots :eek: ... 2.1 fixed the blank-screen issue I had though :)

[N9ne]

OMMMMMMMMMFG G-FORCE!!!! TOO MANY FEATURES, FEATURE OVERLOAD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

WOW, This is DEFINITELY getting my vote for HOTM [unless you release something god-like again lol]

Simply AWESOME work!

[Okiewan]

"can warn" or whatever the permissions are for who can see and post warnings, has nothing to do with my problem... I logged-in as every usergroup... the "warn user" (and other warn links) do not show-up in postpit. ( I added "$post[warnlink]" to postbit )

[The Realist]

Im getting the following DB error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 07th of September 2002 08:41:41 PM

Any help!

[Buddha]

same here.
no white screen anymore, but no warnlink either.
???

[Okiewan]

You are getting that error when trying to view the logs from the CP, correct? Same thing here.

[The Realist]

Also I have put in place in the postbit template the following:

<p align="right"><smallfont><a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged]<br>$post[warnlink]</smallfont></p>

But the warnlink is not showing on the forum?

[Buddha]

when i ran the install_warning.php again (as per upgrade instructions), got this error

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: ALTER TABLE user ADD warninglvl int(10) NOT NULL DEFAULT '0'
mysql error: Duplicate column name 'warninglvl'

mysql error number: 1060

Date: Saturday 07th of September 2002 02:04:41 PM
Script: http://www.fulldvdreview.com/admin/install_warning.php?step=2
Referer: http://www.fulldvdreview.com/admin/install_warning.php


don't know enough about this stuff to know if the script will continue even if there is an error, or just stop.
the duplicate column wouldn't be a big deal, but if the script stops when an error occurs, then there may be a problem.

[Okiewan]

Originally posted by Buddha
when i ran the install_warning.php again (as per upgrade instructions), got this error



Because it was already there from your previous install... if you delete that in the user table, you won't get the error. It will continue to make duplicate templates though.

[Buddha]

well, hopefully this will be fixed, as it looks fantastic and would be useful... but i can't even see it in the admin cp right now, let alone the warn link.

*fixed part of the problem... can at least see it in admin cp now*

[Buddha]

i'm curious... installation text says to change warnconfig and upload.... upgrade install says delete it.
is it needed?

[Okiewan]

Originally posted by Buddha
i'm curious... installation text says to change warnconfig and upload.... upgrade install says delete it.
is it needed? Not if you upgrade to 2.1, the permissions are written directly in the admin/functions.php file with 2.1, where it was in warnconfig.php in 2.0. The problem is with 2.1, I can't figure-out where to set the various usergroup permissions now, pretty sure that's why it's (the warn link) not showing-up in postbit, but that's just a guess.

[snyx]

intense bro. nice.

[Chris M]

Warnconfig.php is needed for 2.0...

I dunno about 2.1...

Satan

[g-force2k2]

Notice: you must submit the vbulletin options update for everthing to become active... that will fix all the problems as stated in the thread... regards...

Edit: hellsatan is correct... hellsatan if 2.0 works good then cool :) no probs... bu 2.1 requires no warnconfig.php and requires you to UPDATE your VBULLETIN OPTIONS... regards... hope this solves all the issue :)

g-force2k2

[Okiewan]

Uhhhhh ? There's supposed to be something about this hack in vBulletin Options? Maybe I shouldn't be trying to install a hack today, because I'm seriously lost at this point :ermm:

If I simply open vB options and submit it... still nothing.
Where does someone set usergroup permissions in 2.1? ie; which can warn, seen warnings, etc., etc.

[g-force2k2]

In the Admin CP you need to update the vBulletin Options... regards...

g-force2k2

[Okiewan]

Been there, done that. Nada.

[g-force2k2]

The new v2.1 install automatically inserts all of the settings into the vBulletin Options and that's where all of the options are... That's why you need to configure and update the vBulletin Options... Have to go to work... If problems persist I will support tonight when I get home... regards...

g-force2k2

[Buddha]

Originally posted by Okiewan
Been there, done that. Nada.

same.
still get the error when viewing the logs, and no link.

[Buddha]

the new install btw, gives errors... as i mentioned in a prior post... do you have a workaround for that?

[Okiewan]

Originally posted by Buddha
the new install btw, gives errors... as i mentioned in a prior post... do you have a workaround for that?

Yes... remove the warnlvl line from the user table.

Odd, the new install inserted nothing in the vB options. Oh well, will try later I guess :(

[Vivi Ornitier]

well i seem to have installed the hack fine cause all my pages are working and the install problem went out without a glitch. Now, it wouldn't display the warning links and level in the postbit.

In the old version it was this:

$post[warnings]

The new one is:

$post[warnlink]

But in the forum, it doesn't show up anything at all. Can u add the links and warning level manually??

So instead of putting $post[warnlink] u can add the links and all the code in the postbit template?

[Chris M]

I havent tested it, but this file below should insert the stuff into the settings...

Disclaimer: - I have just modified a file, in order to help out g-force on this occasion...I take no credit for any of the work...

Please Note: This file is ONLY to be used if you have not got the settings installed to your vB Options, AND are running Version 2.1 of this hack...

Satan

[Buddha]

booyeah.
thank you hellsatan!
everything seems to work now.
much appreciated!

*clicks installed*

[Buddha]

well, played around with everything, and it works great.

excellent hack... thanks for all the hard work.

[Chris M]

Lol...

@g-force - If you keep getting reports of this problem, I recommend adding the "install_settings.php" file to your .zip file:)

It seems to have worked for Buddha:)

@Okiewan - I think you should try it:) See if it helps you:)

Satan

[The Realist]

Found problem with below. There was a , at the end of the query when there should not have been.

Still looking into the warning link and why it will not show.

L8tr

Originally posted by The Realist
Im getting the following DB error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 07th of September 2002 08:41:41 PM

Any help!

[The Realist]

Found problem with warning link not showing as well :)

Go to VB options and setup what usergroups have access to what and all is fine.

The reason I could not see it was that I did not have admin usergroup ID listed as one of the groups who can see the link.

Do that and all is fine :)

L8tr

[hypedave]

dude you rock !!!!! you installed the email feature woo hoooo
thanks man keep up the good additions

[g-force2k2]

yeah thanks hellsatan... in my upgrade directions it does say to uninstall and then rerun the installer... but either way is fine ;) regards... thanks for the help btw...

g-force2k2

[wooolF[RM]]

]everything works except I can't see $post[warnlink] ... it just give me blank space... :(

yes, i have edited all files, runned all queries and edited all templates... :/

and I have edited settings in the admin panel and saved them

[Erwin]

One tip - for those with many hacks that uses the settingid's, you may want to use a higher settingid than 40 - otherwise you get a db error. You don't actually have to set a settingid - the variables are auto-incremental. If people are getting errors, replace all the 40 with 140 which shouldn't interfere with other hacks that uses settingids.

Otherwise, the hack is brilliant. I just had to tidy up the profile a bit, but it works great. Thanks!

[wooolF[RM]]

]good tip, lemme try :D

[wooolF[RM]]

]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO setting VALUES (NULL,240, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that can\'t be warned! (seperate each usergroupid by a comma)', '', 5,)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064


:(((((((((((((((((((((((((

[wooolF[RM]]

I have changed all "40" to "140"... error...
then changed to "240" ... same error...

I have updated my admin cp, tried hellsatan's install_settings.php + tried to do it with mysqladmin...

<-- LOST

[wooolF[RM]]

]now I have deleted all values that have been imported in the DB in setting and settinggroup tables...

tried file by hellsatan again... no luck ...

argh... :(

[wooolF[RM]]

]script DOES insert these values into DB (checked)


200 140 Warning Logs Per Page WLOGSpp 20 The number of warning logs to show per page! 1
Edit Delete 201 140 Register Group REGgroup 2 The usergroupid for the registered usergroup! 2
Edit Delete 202 140 Maximum Ban Limit BANtot 25 The total amount of warning points before user is ... 3
Edit Delete 203 140 Banned by Warnings Group BANgroup 16 The usergroupid for the banned by warnings usergro... 4


+ it makes group in settinggropu table as
140 Warnings System 140

after this I get error in the script :

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO setting VALUES (NULL,140, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that cant be warned! (seperate each usergroupid by a comma)', '', 5,)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064


:(

[Chris M]

Hmmm...

Erwin has found out why you have got errors - Conflicting Setting Ids...

Im not sure how to help:(

Satan

[Larz]

Has anybody had this running on 2.2.6 with the Lesane Store Hack?

[wooolF[RM]]

]right now under table "setting" under settinggroup 40 I have Chan's hack called vbPad ( think so )


Edit Delete 171 40 Maximum Characters per note maxpadsize 250 The maximum number of characters that you want to ... 1
Edit Delete 172 40 Maximum Notes maxpadnum 10 Enter the maximum number of notes a user can keep.... 2
Edit Delete 173 40 Allow vB IMG code in notes? padimgcode 1 yesno 3
Edit Delete 174 40 Allow vB code in notes? padvbcode 1 yesno 4
Edit Delete 175 40 Allow smilies in notes? padsmilies 1 yesno 5
Edit Delete 176 40 Allow HTML in notes? padhtml 0 yesno 6
Edit Delete


removed it as I don't use it anyway... :) trying to import setting again...

[wooolF[RM]]

]same sh*t... :/

something wrong with query
INSERT INTO setting VALUES (NULL,140, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that cant be warned! (seperate each usergroupid by a comma)', '', 5,)

cause all queries BEFORE this query works and they are imported in the database

weird...

[TECK]

the query should be like that:
$DB_site->query("INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,32,'No Warning Usergroups','NOwarn','6','The usergroupids for the usergroups that cannot be warned! (seperate each usergroupid by a comma)','','5')");
but.. dont use the group 40!!!!!!! but 32 or whatever is your next number up after the last groupid, as it suppose to follow one after the other...
to check what is ur last group, just go to admin/setting.php and look at the last groupid.

[wooolF[RM]]

]mmkay...

now everything is imported, all templates edited, all files edited, admin panel visited and settings saved and...

still nothing... empty place...

:( :( :( :( :( :( :( :( :(

[TECK]

i will look on your board when i wakeup.. as you see i'm still awake. :)

[wooolF[RM]]

]LOL, go to bed!!! NOOOOOOOOOOW! :p

[TECK]

Originally posted by Erwin
One tip - for those with many hacks that uses the settingid's, you may want to use a higher settingid than 40 - otherwise you get a db error. You don't actually have to set a settingid - the variables are auto-incremental. If people are getting errors, replace all the 40 with 140 which shouldn't interfere with other hacks that uses settingids.

Otherwise, the hack is brilliant. I just had to tidy up the profile a bit, but it works great. Thanks! Erwin, you must use it in order. just go to admin/setting.php and check what is your last group ID, then use the next value up. dont give some wierd values just like that. if you check is alot easier and better...
i installed on wooolf's board everything and it worked ok with my method of queries listed above...

[Mephisteus]

Using 2.2.6, had an db error when i viewed the logs but when I created the usergroup Banned by Warnings and set it in vb options to the right usergroup id no probs at all.

This will definetly get my vote for HoTM

[wooolF[RM]]

Thanx to TECK I got it fixed...

I think g-force2k should really think of how to put queries for execution in the installer...

And the file with installer is not so easy to read cause it's kinda big... Try to make another format next time or make it morevisible

The idea itself is great!

Thanx to g-force2k and TECK

[g-force2k2]

yeah thanks TECK for the support i will rewrite a better set of instructions as well as a better installer later when i get the free time... regards...

g-force2k2

[Chris M]

Perhaps you could use vBhackmaker:)

Satan

[TECK]

Originally posted by hellsatan
Perhaps you could use vBhackmaker:)

Satan yep is a great idea... however i still believe the old school way is better... no fancy stuff and u'll be ok always... like i did with wooolf's board.
imo, manual way is the best way. you are always in control and if you make a query code error then you know wich one is it and check the syntax rightaway...

i use chen's query hack, and i never had a prob... it does the job great...

[wooolF[RM]]

]it's wooolF , not wooolf :p

[Erwin]

Originally posted by TECK
Erwin, you must use it in order. just go to admin/setting.php and check what is your last group ID, then use the next value up. dont give some wierd values just like that. if you check is alot easier and better...
i installed on wooolf's board everything and it worked ok with my method of queries listed above...

Well, you don't have to. That table has columns that auto-increment, so you don't have to even specify a number - just put NULL and the next number will be automatically used. And I've been adding settingid's in all sorts of places manually for a long time with no problem now. :)

[Dado]

awesome hack! Got it installed in just couple minutes. I used everything from the first post that G Force did and it worked. I ran the install_warning.php as last and then went to vbulletin options and made the changes to the usergroups for the warning stuff. When I submitted that it started working at once :)

One question though, where do you change the color of the view warning list. I am getting a black font and can't find where to change that. Thanks

http://www.dtmpower.net/forum/warn.php?s=

[g-force2k2]

thats great to hear Dado :) as for you request in the warn_list & warn_listing templates you can just change the:

<smallfont color="{pagetextcolor}">

to:

<smallfont>

see if that helps ;) regards...

g-force2k2

[Dado]

thank you. I didn't even notice the templates were all the way at the bottom :) Sorry :D

[DFX]

Best hack i've seen in quite some time, *Clicks Install*

[Capt PPRuNe]

Well... I've read through this whole thread and i am still stumped. I had v1.0 installed and running with no problems, Went through the upgrade for v2.1 and ran the installer which set everything up but couldn't see the links in the threads and kept getting a DB error when trying to view the logs from the CP. I hadn't seen the bit about running the setup from the Vb Settings.

Decided to uninstall it and ran the uninstaller and removed all the add ons in the files and templates and then proceeded to do a complete install from scratch.

Now when I run the installer it hangs in step 2 at: Inserting Warning System Settings Into VBulletin Options


and I get this sql error:

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Sunday 08th of September 2002 09:10:08 PM
Script: http://www.pprune.org/forums
Referer:

As I am not so au fait with sql I am stumped.

Anyone care to advise what to do next?

[Capt PPRuNe]

Ignore everything after "good morning!". I just ran the installer into step 3 and voila! All working hunkydory.

Pity it wiped my previous warned user list though. With 54,000 members I have to keep this list current and now all the mods will have to start again.

Nice hack. Could possibly be a little bit clearer with the instructions ref the vB settings in the CP and deletion of the warnings config file.

[Erwin]

Originally posted by Capt PPRuNe
With 54,000 members I have to keep this list current and now all the mods will have to start again...

54,000 member... I'm impressed. How old are the forums?

[Okiewan]

Question... if there any way to limit the number of warnings a particular post can get? The mods know to look at the warnings before issuing one, but... I can see it happening, someone getting warned 5 times by 5 mods for the same post. Just a thought.

[g-force2k2]

Okiewan:

open warn.php (2)

find: (1)

require('./global.php');

above it add:

$temlatesused.= ",warn_error_postwarned";

find: (2)

if(empty($info[postid])) {
eval("standarderror(\"".gettemplate('warn_error_postnoexist')."\");");
exit;
}

Under it add:

$getwarn = $DB_site->query_first("
SELECT postid, type
FROM warnings_log
WHERE postid='$info[postid]'");
if($getwarn[postid] != "") {
eval("standarderror(\"".gettemplate('warn_error_postwarned')."\");");
exit;
}

Create a new template called:

warn_error_postwarned
-------
Sorry $bbuserinfo[username], but $info[username] was already wanred on this post for $getwarn[type]. Please select a different post to warn.

And that should do the trick Okiewan... sorry i didn't test it yet... just made it up ;)

Capt Prrune sorry to hear ;\ i thought the instrucstions stated that... besides the systems aren't compatible at all... last system was based on pure warnings no matter what the reason.... this one has a warning points system... regards...

g-force2k2

[Okiewan]

g-force2k2,
Thanks for trying but she no work :(
Multiple warnings on the same post still works.

[C.Birch]

right i have installed the hack and it all works apart from in the admin cp for its settings look at the screen shot to see what i mean.

[g-force2k2]

C.Birch try uninstalling and then reinstalling... if that doesn't work then i will make you an installer to fit your needs... can you tell me what the last settinggroupid is that you've used? regards...
try opening the install_warning.php

find:

$DB_site->query("INSERT INTO settinggroup VALUES (NULL, 'Warnings System', 40)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Warning Logs Per Page', 'WLOGSpp', '20', 'The number of warning logs to show per page!', '', 1)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Register Group', 'REGgroup', '2', 'The usergroupid for the registered usergroup!', '', 2)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Maximum Ban Limit', 'BANtot', '25', 'The total amount of warning points before user is banned!', '', 3)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Banned by Warnings Group', 'BANgroup', '8', 'The usergroupid for the banned by warnings usergroup', '', 4)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that can\'t be warned! (seperate each usergroupid by a comma)', '', 5)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Can See Warnings Levels', 'CANseewarn', '2,5,6,7', 'The usergroupids for the usergroups that can see the warning levels! (seperate each usergroupid by a comma!', '', 6)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Can View Warnings', 'CANview', '5,6,7', 'The usergroupids for the usergroups that can view user warnings! (seperate each usergroupid by a comma)', '', 7)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Can Issue Warnings', 'CANwarn', '5,6,7', 'The usergroupids for the usergroups tat can warn users! (seperate each usergroupid by a comma)', '', 8)");
$DB_site->query("INSERT INTO setting VALUES (NULL,40, 'Email Ban User', 'BANemail', '1', 'Emails the user when they\'re banned by exceeding the ban limit!', 'yesno', 9)");

and all of the '40' change to the number of the next settinggroupid... you can check the last settinggroupid by going to admin/setting.php in your browser... regards...

g-force2k2

[C.Birch]

its working now before i tryed it how someone said before to do it turn 40 in to 140 and that never worked but i just turned them in to 42 and that worked because last one was 41. thanx and cool hack :)

[lynda]

I installed the hack with no problems at all - absolutely everything was working (I ended up uninstalling it because it doesn't look like we really need it yet)

The only two changes I made were I changed 40 to another number...

The other thing looks like it might be an error and might be what's causing the blank pages?

The install.txt file says this:

open member.php (2)

find: (1)

$templatesused = "getinfo_sendpm,aol,icq,yahoo,getinfo_birthday,geti nfo_customfields,getinfo";

under it add:

// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
$templatesused = ",warn_getinfo_warning,warn_userinfo";
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++

If that's done, if the new $templatesused is added UNDER the current one as the instructions suggest, won't that just overwrite the $templatesused variable nullifying the first one?

I just added warn_getinfo_warning,warn_userinfo to the end of my current templatesused variable, but I think this also would work if you placed it under the first $templatesused variable.. perhaps this is what it's supposed to say?:
$templatesused = $templatesused . ",warn_getinfo_warning,warn_userinfo";

[g-force2k2]

lynda: thanks for the bug exploit :p

it won't really effect the hack no... but just change:


$templatesused = ",warn_getinfo_warning,warn_userinfo";


to this:


$templatesused.= ",warn_getinfo_warning,warn_userinfo";


regards...

g-force2k2

[410]

Mines not showing up in my Postbit...can you look at this??

<p align="right"><smallfont><a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged] $post[warnlink] <br><a href='timeonline.php?s=$session[sessionhash]&action=view_leader'>Time Online:</a> $post[onlinetime] </smallfont></p>

[g-force2k2]

410 did you submit the options in the vbulletin options in the admin cp? regards... make sure that the usergroupids are configured correctly according to your needs...

g-force2k2

[410]

Yep got it to work..gr8 hack thx!

[g-force2k2]

glad to hear 410 :)

Okiewan...

i just tested the code that i gave you and it worked fine? are you sure you tried a post that you had already warned? regards...

g-force2k2

[Dado]

Originally posted by g-force2k2
Okiewan...

i just tested the code that i gave you and it worked fine? are you sure you tried a post that you had already warned? regards...

g-force2k2

It worked for me too :) Thanks!

[Sc0rp]

awesome hack m8! installed it right away:D

one question.. after how many warning points does a user get banned and can I customize this? thanx!!!!:)

sorry one other question.. I noticed the warning wasnt displaying in the postbit.. so I went looking in the install and I found this:


// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++
$post[warnlink] = "";
$warntype = checkwarnlink($bbuserinfo[usergroupid], 0);
if($warntype == 1) {
eval("\$post[warnlink].= \"".gettemplate('warn_seelink')."\";");
} else {
$post[warnlink].= "";
}
$warntype2 = checkwarnlink($bbuserinfo[usergroupid], 1);
if($warntype2 == 1) {
eval("\$post[warnlink].= \"".gettemplate('warn_viewlink')."\";");
} else {
$post[warnlink].= "";
}
$warntype3 = checkwarnlink($bbuserinfo[usergroupid], 2);
if($warntype3 == 1) {
eval("\$post[warnlink].= \"".gettemplate('warn_warnlink')."\";");
} else {
$post[warnlink].= "";
}
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++


so my question is.. what would this warnlink have 2 be???

[Erwin]

Originally posted by Sc0rp
awesome hack m8! installed it right away:D

one question.. after how many warning points does a user get banned and can I customize this? thanx!!!!:)

Look in your Admin CP under vBulletin Options, Warnings.

[g-force2k2]

yep like Erwin stated it is all customizeable in the vbulletin options in the admin cp... you can update the usergroupids there as well... hope that helps you... regards...

g-force2k2

[Sc0rp]

yeah I customized that but the $post[warnlink] is still not showing when I look in a post (postbit is filled in correct..!) should I have installed a older version first and updated from there?

[Dean C]

deleted all my templates and ran the installer....

this is what it showed:


Creating Warning Logs Table.

Warning Logs Table Successfully Created!

Creating Warnings Table.

Warnings Table Successfully Created!

Inserting Defualt Warnings Into Warnings Table

Defualt Warning Values Successfully Inserted!

Altering User Table: Adding Warning Level.

User Table Successfully Altered!

Inserting Warning System Settings Into VBulletin Options


then just below this it says:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Tuesday 10th of September 2002 09:49:11 AM
Script: http://www.battleboards.com/boards/boards/admin/install_warning.php?step=2
Referer:


:( - any ideas???

- Mist

[g-force2k2]

Mist go in your admin browser to setting.php and the find out what the next settinggroupid is... and replace all of the 40's with whatever the next number should be... see post#107 for references... regards...

g-force2k2

[Dean C]

ok ... but what do i do bout runing the installer again :(???

it will get errors as some of the queries were executed...

- Mist

[Parker Clack]

g-force2k2

This script works great. My moderators love it.

Thanks for all the hard work in putting this together.

Parker

[g-force2k2]

Mist just uninstall it then... and then rerun the installer... regards...

And thanks Parker... means alot :)

g-force2k2

[Sc0rp]

ge-force could u plzzzzzz take a look at my previous post.. still isnt working..:(

[Mephisteus]

I'll take an look at it sc0rp.

[g-force2k2]

Scorp did you update the vbulletin options and make sure that the usergroupids for the staff(admins, mods and smods) were configured correctly with your forum? regards...

g-force2k2

[Dean C]

this is a pain in the ass....

/me goes off to reinstall...

- Mist

[Sc0rp]

Originally posted by g-force2k2
Scorp did you update the vbulletin options and make sure that the usergroupids for the staff(admins, mods and smods) were configured correctly with your forum? regards...

g-force2k2

yep.. but $post[warnlink].= ""; is still empty and not visible in the postbit.. :(

[edit]

oh.. darkssj fixed it :) thanx darkie.. and thanx geforce2k2!:D

[Parker Clack]

g-force2k2:

Is there anyway of making this so that the comments are added to the message that gets sent out too?

Parker

[g-force2k2]

good to hear Scorp :)

Parker Clack just edit the warn_pmemail templates and add where you want:

Comments: $comment

i believe that should do the trick... regards...

g-force2k2

[Parker Clack]

g-force2k2:

Thanks.

Parker

[Dean C]

well i had to teach myself sql to revers the queries of the original hack... lol (probably wasn't needed but it was worth it)

then i changed a few things and did a complete re-install and got this working

Very nice system g-force...

- Mist

[Tetchu]

I must say, it's a good Hack, and the first one to make it onto my boards to.

I have one question though, how do i find out what the User group number is for each user group? Just so i can make sure that the right users can see the right stuff.

Also, how do i set it so that the banned user switched to a new user group? I saw it mentioned earlier but you needed to edit a warnconfig.php file that 2.1 didn't need. so any help would be nice.

Thanks again, and great hack.

[g-force2k2]

Tetchu you have to right click the edit button for the usergroup in the admin cp while editing the usergroups... and for all of the configurations... its now intergrated into the vbulletin options... regards...

g-force2k2

[NuclioN]

--- never mind--- fixed it trough phpadmin

Only one thing remains and that is a double notition of the warnfunctions in the vb options. (??)

[a43079]

please help when i click on view warning logs i get


Warning: Division by zero in /home/www/eroweb/admin/admin_warning.php on line 87



There seems to have been a slight problem with the Ero Web Services database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

this is line 87 what is wrong with it i cant figure it out.
$totalpages = ceil($totalwarns[0] / $perpage);

[Apok2002]

I didn't see it...forgive me if it is already here...but is it possible to put a graphic in the postbit of someone who has been warned? That way all members can see that this person has recieved a warning, and why they did?

The above is simliar to the card hack from Lesane for his Store Hack. I like yours in that it is more professional and detailed. But Lesane's is great because of the postbit issue.

Again, sorry if this is already brought up...I'm blind if it's here.

[g-force2k2]

a43079 you have to submit your vbulletin options ;)

Apok2002... open admin/functions.php

find:

$post[warnlink].= "";
}
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++

replace it with:

$post[warnlink].= "";
}
if($post[warninglvl] > 0) {
$post[warnimg] = "<img src='{imagesfolder}/warn.gif' border='0' alt='$post[username] currently has $post[warninglvl] Warn Points!'>";
} else {
$post[warnimg] = "";
}
// +++++++ Warning Hack 2.0 [ g-force2k2 ] +++++++

then place your image in the images folder of your forum... and place $post[warnimg] where ever you would like it to show on the postbit...

sorry i haven't tested it but it should work :) regards...

g-force2k2

[a43079]

THankyou it works great..

[neocorteqz]

Do I have to install one of the older versions of this? or can i use this one? If I can use this without installing any other version, Then where do I put the user groupid as stated here.


// ++++++++++++++++++++
Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)

or can I skip this step?

Thanks.


edit:
Warning Hack v2.1
Copyright g-force2k2
Created on Saturday Semptember 3rd 2002
Please respect my hacks and don't edit (includeds adding on) them unless otherwise permission gained.
Thanks in advance.

[MPM.com]

Hi Everyone

I am VERY new to PHP, but trying to install this brilliant feature on my forum.

I keep getting the following error message. I dont think it is to do with this script, as it has happened with another script I tried.

Fatal error: Call to undefined function: cpheader() in E:\webspace\resadmin\markquayle\mobilephonemadness .com\www\forums\install_warnin g.php on line 7

Anyone Help?

[drives fast]

this is a great hack....I like it a lot and it installs easily.

However I noticed a little possible bug if you can call it that. When I warn a member the last time and his points total enough for the hack to ban the member....it does drop him into the banned usergroup (8) but it does not update the usertitle....it stays as "member" instead of changing to "banned by moderators". Is there an "uptade usertitle" or something missing in there?

[MPM.com]

I was running install script from the wrong directory... it Seems to install this time, but is playing up.

The file warnconfig.php is not in the zip. where do i find this?

Also, should there be a "warn user" option next to report this post to a moderator? coz there isnt.

Sorry for being thick.

Mark

[g-force2k2]

User_001 the 2.1 installer will fully install the warnings hack...

drives fast just edit the update query... its not a bug but it just doesn't update the usertitle... i'll give you the code for that in a few if you'd like....

MPM.com just update the vbulletin options...

regards...

g-force2k2

[MPM.com]

Sorted!!

Thanks for a great hack, and for the help.

[drives fast]

g-force2k2,

thank you for your reply.....I would like the code if it is not too much trouble.....I really don't know what do add in

thanks

[g-force2k2]

open warn.php

find ths code:

$DB_site->query("UPDATE user SET usergroupid='$BANgroup' WHERE userid='$userid'");

replace with:

$DB_site->query("UPDATE user SET usergroupid='$BANgroup', usertitle='Banned by Warnings' WHERE userid='$userid'");

Also if you have any banned users you can run this query to update the banned titles...

UPDATE user SET title='Banned by Warnings' WHERE usergroupid=8

This is considering that your banned usergroupid is 8 regards...

g-force2k2

[neocorteqz]

Thanks for the help. I'm gonna install this after a Fresh Backup of the DB.;) :)

[drives fast]

now all of a sudden I am getting this err or when I try to view a thread:
Parse error: parse error, expecting `']'' in /home/xxxxxxxx/xxxxxxxx/xxxxxx/admin/functions.php(278) : eval()'d code on line 46

thsi is line 46:
eval("\$pagenav .= \"".gettemplate("pagenav_curpage")."\";");

this happened while I was customizing the templates and the only change I made was to warn.php as g-force2k2 showed me above.

I have tried uploading an un-hacked functions.php and the same error exists and it won't allow the postbit template to show up on the page

any ideas?

[g-force2k2]

hmm... drives fast that is definately weird... there is somethign wrong with the eval code... but i dont' see anything wrong with that one... im not positive probably better of checking up with the support forum... regards...

g-force2k2

[Dave-ahfb]

I must be totally missing something

....like the config file, not included in the zip, any clues?
Dave

[g-force2k2]

yeah its not included in the zip file sorry Dave-ahfb... the Warnings Hack v2.1 doesn't need a warnconfig.php anymore instead the options are in the vbulletin options... i have to update the instructions... just been busy regards... but the hack works fine itself ;) just my instructions are shady...

g-force2k2

[Dave-ahfb]

Sorry I got it now.

I attempted this install the other day and gave up, thought a fresh mind might help today.

I see the question has been answered earlier in the thread so I apologize for not reading through the entire thread.

It took some work but it looks like a great script.

thanks,

Dave Bailey

[Neo]

I got so many errors when I tryed to install this on my forum. The big one was that my site no longer showed since the code edit in the admin/functions.php casued a error. And all the admin files did not parse they just displayed the code... also when I took a look at the code on my computer it was very distorted since it had been text formated which you dont do when coding.

[NuclioN]

Working fine so far but we get this: Fatal error: Call to undefined function: checkwarnlink() in /home/domain/www.oursite.com/HTML/member.php on line 1746

[g-force2k2]

Nuclion did you make the file modification to the admin/functions.php yet? regards...

neo what do you mean text formatted? regards...

g-force2k2

[NuclioN]

Yes g-force i've made those modifications. I've checked it twice.
Maybe it conflicts with another hack, i shall attach admin/functions.php so maybe you can see the source of the error.

[g-force2k2]

definately weird Nuclion...

first remove the file so that you don't get in trouble ;) can't post full vb files here...

second can you show me what is on line 1746 of the member.php? regards...

g-force2k2

[NuclioN]

It's in this...but i've removed that and the error shoots to another line:

// Number of time a profile has been viewed by Pierre-Luc "Fuitad" Brunet
if ($userinfo[profileview]=="") {
$userinfo[profileview]=0;
} <--------------------------------------------- line 1746
$userinfo[profileview]++;

// Update the DB with new count
$updateviews=$DB_site->query("UPDATE user SET profileview=$userinfo[profileview] WHERE userid=$userinfo[userid]");

// End Number of time a profile has been viewed by Pierre-Luc "Fuitad" Brunet

[g-force2k2]

okay Nuclion :p try changing the whole code that you just posted into one line ;)

$DB_site->query("UPDATE user SET profileview=profileview+1 WHERE userid='$userinfo[userid]'");

that should do the entire trick ;) for that at least... then reapply my code and see what happens regards...

g-force2k2

[NuclioN]

error is moving to line 1737 after doing that.

// Store hack By Lesane

$storeadmin = $DB_site->query_first("SELECT * FROM <--- line 1737
storeadmin");
$pointname=$storeadmin[pointname];
$storename=$storeadmin[storename];

$store=$DB_site->query_first("SELECT storep FROM user WHERE userid='$userinfo[userid]'");
$storepoints=$store[storep];

[g-force2k2]

if you want you can pm me the member.php and i will take a look for you... if you remove my code is this still a produced error? regards...

g-force2k2

[NuclioN]

Yep, error is gone when i remove the code out of the member.php!
I've send a pm with the member.php
;)

[Neo]

Originally posted by g-force2k2
Nuclion did you make the file modification to the admin/functions.php yet? regards...

neo what do you mean text formatted? regards...

g-force2k2

Yup but I am more concerned about the the error in admin/functions.php

[g-force2k2]

neo what error did you get in admin/functions.php?

regards...

g-foce2k2

[alpha2503]

i'm sorry for asking you again with this old problem, but when i klick on the links in the postbit template, there will only show up a blank popup and if i open the warn.php?s=... directly via the link in the forumhome template it's blank, too... i use version 2.1 of this hack... does anyone can help me ? maybe with my bad english,too ;) !

[Apok2002]

How about a master log that is viewable by the public? So that they can see all the warnings ever given out to everyone, by any admin/mod? Just like what we see in the admin cp?

I thought that is what the warn.php would do. But I guess that just displays the warning levels and points?

Also, in the template set that I have, I need to change the font color. It is currently white, which is difficult to see on my light blue background. Check it out here:

www.ez-company.net/forums/warn.php

What is the easiest way to do that?


Also, I installed this w/o a single glitch. No errors whatsoever. I think a few of these errors people are getting, are due to not setting the vBulletin Options - Warning System settings. But it really is a nice hack. I just need to work on the postbit icon addition...and somehow get a warning list of all users who have been given a warning, on a public page for all to see.

[drives fast]

Okay....I have put this through some paces on my test forum and here is some interesting stuff:

First install:
1) Install when flawlessly
2) Noticed that it didn't update usertitle when the hack banned a member. **Fix posted by g-force2k2**
3) After doing some editing in the templates...all of a sudden I started getting a parse error when trying to view posts and the postbit template would not show. un-installing the hack completely did not solve th4e parse error and the database had to be overwritten to get it to go away.

Second Install:
1) Install went flawlessly
2) While customizing templates I noticed that a few of my hacks had stopped working: Moderator graphic and donator hack and site supporter hack......all had stuff to display in postbit.
3) un-installed hack in this order checking to see when the others would appear again,,,first un-installed the database parts.....my other hacks still did not show.....un-installed the script modifications.....my other hacks still did not show......un-installed the 3 template modifications....my other hacks showed back up again.
4) Also before I un-installed I tried some features and found that when you use the system to un-ban someone after the points system banned then their usertitle didn't change back to "member" but I think I can fix that.

Third install:
1) tried to run the installer but it kept telling me "duplicate value and referenced the number 40 so I changed all the 40's to 140 like was suggested in a post and it installed.
2) I had modified the installer with the template modifications of mine and the warnings list additions I wanted so it would install them first shot and I wouldn't have to go in a update all that again but I noticed that the templates (that I modified in the installer) showed up in the templates list as already edited instead of originals (started to think)
3) I then noticed that there was two sets of options in the vb options now but if I looked in the database....there was no settinggroup entries for the warnings system and a couple more that were there before were not present either.
4) I ran the un-installer again...it said successful just like every time. I also un-installed the template and script mods.
5) No matter how much I looked I couldn't find evidence that the hack still existed but it still showed 2 sets of setting groups in the admin panel.
6) I had to overwrite the settinggroup table to get that to go away. (thinking some more)

Fourth Install:
1) Changed the values to 33 (since that was next in line in my database) and installed fine once more.
2) everything seems fine...no problems like before....my other hacks still worked so I started using the functions again.
3) after asessing points to a member...I went to the admin panel and took them back and it said that there were no members warned......seemed correct.
4) I then asessed points to that member again and in the admin panel...took them back....seemed correct.
5) I then asessed enough points for that member to be banned and then went to the admin panel and through the warnings system unbanned that member and it said like it should that it was done, so I then went to the post I was testing all this in and clicked on the "[View Warnings]" link and the three warnings that should have been deleted showed up. A quick look in the database shows that they in fact had not been deleted.

So....it would apear that the uninstall doesn't work corectly and causes some strange stuff to happen in the database.

The templates showing up as already edited instead of original after modifying the install script suggests that some data was still in the database (although invisible) from the original install and edit.

the remove and delete warnings function isn't working even though it says it is from the admin panel

Would it be possible for you to look into these issues?

I love this hack and want to use it

[Neo]

Originally posted by g-force2k2
neo what error did you get in admin/functions.php?

regards...

g-foce2k2

I wasnt able to see... but what happend was the entire site turned to a white blank page.

[g-force2k2]

Originally posted by Neo


I wasnt able to see... but what happend was the entire site turned to a white blank page.

not sure O_o maybe there was a cross over of required files... thats really the only thing i can think of :p sorry to hear man ;) regards...

g-foce2k2

[squawell]

first this is a useful hack to me...thankz ur hard work...

sencond i have a little question.....

how can i add if user's posts over XX(what u want it to be)posts

also have permission use the warning member system??

[Mike11212]

I get the following error when i click the email button in a users profile
Fatal error: Call to undefined function: checkwarnlink() in /home3/mike1121/public_html/board/member.php on line 1418

[marocnl]

Jo pIEpAl,

All works well accept for 1 issue. When i remove a warning for a user it doesn't update de warning points shown in each post of the user. Please let me know what necessary changes i need to make in admin_warning.php. I think it all happens there, not? ;)

The other request to have a php-file that shows all the warnings of your board on in a listing. Please make this happen.

HELP!! Just to emphasize how fast i want this :D

Great hack btw :smoke:

[squawell]

so strange.....

i complete install....and no error

but...i cant see it show up in postbit and getinfo......

why??and where can set if user warning points have to baned

which usergroup that user will be there??because i dont have usergroupid 8.....

how to fixed that?

[g-force2k2]

Originally posted by marocnl
All works well accept for 1 issue. When i remove a warning for a user it doesn't update de warning points shown in each post of the user. Please let me know what necessary changes i need to make in admin_warning.php. I think it all happens there, not? ;)


macocnl worked fine for me... what exactly is wrong?

Squawell:

you have to submit you vbulletin options... all of your configurations are in the vbulletin options under the warnings section...

as for the other suggestion i will work on it when i get any time... right now i have serious personal problems that need attention... regards...

g-force2k2

[marocnl]

Originally posted by g-force2k2


macocnl worked fine for me... what exactly is wrong?


g-force2k2
For example when i remove 1 warning, let's say worth 7 points, and the user had 17 points. After i remove the 7 points, by removing a warning worth that much, it still says 17 points in the posts of the users. I hope u understand what i mean.

Thnx 4 ur answer btw

[g-force2k2]

marocnl what do you do remove the warning from the warning logs? thats just for viewing purposes... try the 'view warned' link... should be on the admin cp options panel of the admin cp... that'll allow you to reduce the points... regards... hope that helps...

g-force2k2

[squawell]

Originally posted by g-force2k2


macocnl worked fine for me... what exactly is wrong?

Squawell:

you have to submit you vbulletin options... all of your configurations are in the vbulletin options under the warnings section...

as for the other suggestion i will work on it when i get any time... right now i have serious personal problems that need attention... regards...

g-force2k2
sorry about that g-force2k2...

i finally find the problem just like u say...... :nervous:

and thankz ur hard work i will waiting for ur new function.....

[marocnl]

Originally posted by g-force2k2
marocnl what do you do remove the warning from the warning logs? thats just for viewing purposes... try the 'view warned' link... should be on the admin cp options panel of the admin cp... that'll allow you to reduce the points... regards... hope that helps...

g-force2k2

I know one can reduce points there, but when i reduce points it will still show the warnings. So when you add the points of the warnings it will not be same as the points he has after you reduce them from the Admin CP. So to reduce them correctly, one should undertake three steps. First is to tsjek which warning you want to remove and the amount of points that warnings is worth. Then you should go to the Admin CP and remove the warning through warning log. Finally one should reduce the points through the option in Admin CP 'view warned'.

My idea is to make it so that when i remove a warning from the log it will automatically do the other steps. Tell me if i am mistaking.

[g-force2k2]

yeah squallwell i'll try and set on it today ;p just the usual things to do ;)

as for the warning log idea marocnl... i believe that the warning log is a way to check on who has been warned in the past... i don't think that it should be used to remove points in any manner... thats just my opinion... also because the warnings aren't actually stored to that user... so unless you view the warnings or logs you won't know why they were warned... don't get me wrong... your idea is possible... but i personally would stick to the 'view warned' step... regards...

g-force2k2

[marocnl]

Originally posted by g-force2k2
yeah squallwell i'll try and set on it today ;p just the usual things to do ;)

as for the warning log idea marocnl... i believe that the warning log is a way to check on who has been warned in the past... i don't think that it should be used to remove points in any manner... thats just my opinion... also because the warnings aren't actually stored to that user... so unless you view the warnings or logs you won't know why they were warned... don't get me wrong... your idea is possible... but i personally would stick to the 'view warned' step... regards...

g-force2k2

Hmmmm, maybe i don't completely understand how ur hack works, but it seems to me that you don't wanna keep track of warnings when you 'forgive' the warned person and let him/her start with a clean sheet. Because if you keep the logs just the way they are and just remove the warning points, it will not give you the correct listing when you click on the [ view warnings for this person ] link in the messages.

I appreciate your answers, but try to understand what i mean. I honestly don't think this can be the meaning of your hack. If you're tired of answering i understand :knockedout: . It's not like this is such a BIG deal as i found a way to work around it. But being lasy i like things to be automated. I have some experience with php/mysql, mostly by implenting and carefully reading the hacks posted here. So i could do it my self, but as you probably make it much faster than i, iasked you 4 it. But i mainly want you now to understand what i mean.

Fell asleep yet? :sleep: :)


P.S.: I really wonder whether i am the only one with this question? Anybody else wanna back me up? :lick:

[squawell]

g-force2k2 i have a question

if someone have been warned can we have a namelist in main

page can see and do not goto member's profile to see his

static......

and another function.....

thread starter can warning who reply his thread??

can u also do that?? :bunny:

[Gohan]

Something Different?
// ++++++++++++++++++++
Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)

==============================================

I don't understand *still confused yet*

I must add new usergroup and name of usergroup = "Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!"

Right?

[g-force2k2]

yeah Gohan thats correct ;) i have to update the instructions though because there is no more warnconfig.php the modifications are in the vbulletin options under warning options... regards...

And marocnl i understand exactly what you're looking for it just doesn't make any sense... a log is a log... just like your adminlog... why would you want to delete the logs of who has been warned...? regards...

g-force2k2

[marocnl]

Originally posted by g-force2k2

And marocnl i understand exactly what you're looking for it just doesn't make any sense... a log is a log... just like your adminlog... why would you want to delete the logs of who has been warned...? regards...

g-force2k2

Hi there g-force2k2,

Hahahahaa.........i'm just laughing because this is getting very lame, don't ya think? :)

Many thnx 4 this great hack btw :rolleyes: :laugh:

[Mike11212]

i think you would want to delete a log when it gets to large to conserve disk space

[cklaszlo]

I downloaded the .ZIP and there isn't a warnconfig.php file in the zip. Am I missing something?

[g-force2k2]

no cklaszlo... no warnconfig.php needed... when i switched to the warnings hack v2.1 i accidently forgot to change that instruction... i should update the instructions soon... but lately personally problems have been overwhelming... regards...

g-forc2k2

[dapence]

This is a great hack, though I did need to uninstall it to deal with some other issues, and i noticed that it would not remove the entries in the settinggroup and setting tables. I examined install_warning.php, and noticed that the group id when installed is set to 40, but the group id is set to 44 in the uninstall section. I'm not a MySQL guru, so I may be wrong, but should this not be 40 as well.

Like I said, great hack, just thought I'd point this out ... unless it already has, in which case, I'm sorry. :)

[thesteveco]

Excellent hack, g-force2k2... it's exactly what I needed for my forum!

I have been experimenting with a number of 'fixes' for problems people have been having, but I think my particular issue is a bit different:

I can only see the 'View User Warnings' and 'Warn This User' link for my own posts! Odd, no?

Sound familiar? Make any sense? I have tweaked the settings in Options numerous times and been able to make the link beneath my own name appear and disappear, but can't seem to do so for the other users.

Fortunately this is on a test board so my problems are not too urgent, but could you ponder this and throw any ideas my way?

(I think this may be my first post on this board - LOL)

[g-force2k2]

dapence if you can't delete them from the installer (because it just doesn't work)

then delete them manually

ie: go to this url in your browser...

.../admin/setting.php?s=$session[sessionhash]

thesteveco do you have any screenshots? definately sounds weird... regards...

g-force2k2

[dapence]

No, I meant that the uninstall routine works find, except it will not remove the entries added to the settinggroup and setting tables.

code inserting ...

$DB_site->query("INSERT INTO settinggroup VALUES (40, ...
$DB_site->query("INSERT INTO setting VALUES (NULL,40, ...

code deleting

$DB_site->query("DELETE FROM settinggroup WHERE displayorder=44 ...
$DB_site->query("DELETE FROM setting WHERE settinggroupid=44 ...

So, the code removing the entries from the database won't work, because the typo in the setting order, and settinggroupid are set to 44, not 40.

So, if you reinstall it, there are duplicate entries in these tables.

Like I said, I'm not a MySQL guru, but I think I'm correct. Just thought you'd like to know. :)

[thesteveco]

g-force2k2,

I'm not sure what the problem was, but after taking things step by step, checking everything into CVS as I went, it worked on my secondary backup. I installed it on my production box and all is quite well!

Props to you - I look forward to seeing how effective this tool can be.

One other point... I intend to write a script (simple PHP page activated by a cron job) that will automatically decrement the warning level one point per day. When the points against a user drop below the banning threshold the user's account will be re-enabled.

This won't modify any of your scripts or templates, but I thought I'd throw it past you for your blessing just in case it was appropriate.

[thesteveco]

g-force2k2,

So I've written and tested that script - it works like a charm with one exception... I'd prefer to make the ban_limit variable dynamic but don't want to make too many assumptions when retrieving it from the setting table. For the time being it's a static value. If you want a copy of it and its associated cron job just let me know.

As for the hack I am seeing three problems currently.

The first is that some Registered users see only their own Warning Level and others see all.

The second, and similar, is that for Moderators, Super Moderators, and Administrators we occassionally do not have the Warning links at the bottom of posts.

For both of the above problems I have checked the HTML source to see if there was some sort of commenting problem but there is not... the link is not written into the page and so I'm assuming it has to do with the $post[warnlink] variable in the postbit template (set in member.php). I'll do some logic tests to see if I can help you further in diagnostics.

The third problem is with one of the hacks of your hack. :D I added the "Comment: $comment" to the warn_pmemail_notify and warn_banemail_notify templates to be a bit more verbose in the message to the offending users. The inclusion of an apostrophe generates a MySQL error as it is not escaped. It's an easy enough problem to solve, just thought I'd let you know.

Thanks again - I'm realy enjoying the hack - it's going to be an excellent addition to my board.

[nbb]

Just an idea...

What about setting the Warning Levels printed in the post to different colors, f example green (<33%) orange (>33<66%) and red (>66%) ??

[g-force2k2]

look forward to what you come up with thesteveco... the scripts not displaying right im not really sure about... as for the warning point decrementor thats fine... you can add that... thanks for the reply...

nbb i will see what i can do for you ;)

regards...

g-force2k2

[g-force2k2]

there nbb... test that out ;) i haven't tested it yet sorry... but it should work...

g-force2k2

[mewgood]

where is the warnconfig.php goes?
It is not in the zip file..

[thesteveco]

OMG - I'm totally going to regret this, but I have to be forthcoming and share my findings...

<--- laughing at self

After spending hours working through your PHP and setting the indenting, commenting, and spacing in a manner in which I can read it more quickly an thoroughly (you KNOW every coder is unique in their style) I found the stupidest little error that immediately explained everything...

I inserted the $post[warnlink] info in functions.php BEFORE the end of the $onlinestatus condition, not AFTER. Thus, all the people who were not online had the warnlink info, those who were did not. Super duh!

At least you know what to tell the next guy!! LOL!

[thesteveco]

Oh... I did add one tiny tweak... I don't display Warning Levels to anyone unless it's greater than zero...

REPLACED:

if ($warntype == 1) {
eval("\$post[warnlink] .= \"".gettemplate('warn_seelink')."\";");
} else {
$post[warnlink] .= "";
}

WITH:

if ($warntype == 1) {
if ($post[warninglvl] > 0) {
eval("\$post[warnlink] .= \"".gettemplate('warn_seelink')."\";");
}
// (removed the following as it seems extraneous)
// } else {
// $post[warnlink] .= "";
}

Hope ya don't mind :D

[g-force2k2]

thesteveco no i don't mind ;) glad to see you got the problem resolved :)

btw mewgood there is no warnconfig.php anymore... i think i've answered that question at least ten times now ;) regards...

g-force2k2

[mewgood]

?
so HOw I gonna install it?
you didn't change the txt file..

[thesteveco]

mewgood - the warnconfig file is no longer necessary. You need to go to the Admin Control Panel and save the vBulletin Options. Down at the bottom of the page you'll notice some new data - that is the information that was previously stored in the file you're looking for.

I think that g-force2k2 was trying to encourage you to read the previous answers to the same question.

[mewgood]

oh
ok
sry
thx for your answer:D

[mewgood]

error
when I try to click on the View warning log in the admin cp it has an error. As well where do I set the limit?


Warning: Division by zero in /usr/local/psa/home/vhosts/wcgalaxy.com/httpdocs/vbb/admin/admin_warning.php on line 87
Database error in vBulletin Control Panel 2.2.6:

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Wednesday 09th of October 2002 09:26:51 PM
Script: http://www.wcgalaxy.com/vbb/vbb/admin/admin_warning.php?action=view_logs
Referer: http://www.wcgalaxy.com/vbb/admin/index.php?action=nav&cpnavjs=

[Devil-GOD]

Great!

*installs*

[g-force2k2]

mewgood you get that error because thesteveco stated you must submit your vbulletin options... regards...

g-force2k2

[StevenTN]

Hi,

I work with cklaszlo on our website. After fumbling with all the stuff, and almost having to use clear eyes in reading this thread, we got it up and running.

Good hack!

[mewgood]

Originally posted by g-force2k2
mewgood you get that error because thesteveco stated you must submit your vbulletin options... regards...

g-force2k2
dont understand/???

[StevenTN]

He means go to your vBulletin Options in the admin control panel, then toward the bottom, modify the necessary settings, and "submit" them (or save them, or whatever terminology you want to use).

[Dean C]

i upgraded my board and a lot of my templates were lost... can u please write a script wich will only install the templates for me g-force :D

Regards

- miSt

[Chris M]

Here is just the Templates:)

Satan

[Dean C]

thankyou ^ :D

- miSt

[etones]

WOW - I think geforce needs to be complimented for creating what is one of the most unique and best hacks ever!!

Its #?$%&# amazing! :) Love it...

Works perfect, however hit one snag. Im trying out your alteration that colours the postbig output (green, red and orange)

It keeps trying to divide by 0, ive narrowed the problem down to $BANtot variable. Its not referencing the correct data. Help :) With this fix, you'll have the BEST hack ever,

Taz

[etones]

Also having another problem.

In the vB control panel, ;ve set it so that EVERY usergroup can view the warning levels, however the unregisterd/unlogged in users can't see them.

Anything wrong? Could have this one being fixed (i think its happening on everyones boards).

Taz

[etones]

g-force2k2.. any chance of a quick fix at all? Really appreciate it.

Thanks,
Taz

[N9ne]

g-force, I've noticed a problem with the getinfo template and the warning level display! I warned a member, it says warning level: 2 in the postbit for him, however in his profile it is like this:

Warning Level: Warning Level: | [ View User Warnings ]

It shows no number and shows Warning Level: aswell, it should be:

Warning Level: 5 Points | [View User Warnings]

or something like that :(

[Apok2002]

I posted this about a month ago, still haven't got a response. Can someone take a look? 2 issues here...

-------------------------------------------------------------------------------
1) How about a master log that is viewable by the public? So that they can see all the warnings ever given out to everyone, by any admin/mod? Just like what we see in the admin cp?

I thought that is what the warn.php would do. But I guess that just displays the warning levels and points?

2) Also, in the template set that I have, I need to change the font color. It is currently white, which is difficult to see on my light blue background. Check it out here:

www.ez-company.net/forums/warn.php

What is the easiest way to do that?
-------------------------------------------------------------------------------

Thanks for the help...it's a great hack. Didn't have any troubles installing it.

[\ \ - Speedy - / /]

I am trying to install this on 228, and everything went fine up untill the txt file :S It says

Something Different?
// ++++++++++++++++++++
Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)


Well I did that, but I dont know what file to edit b/c warncongig.php isnt there, and well I looked at the other files, I am going tpo go to bed right now so if someone could reply to this I would be happy, I want to finish this hack ;)


\\- Speedy -//

[etones]

Originally posted by \ \ - Speedy - / /
I am trying to install this on 228, and everything went fine up untill the txt file :S It says

Something Different?
// ++++++++++++++++++++
Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)


Well I did that, but I dont know what file to edit b/c warncongig.php isnt there, and well I looked at the other files, I am going tpo go to bed right now so if someone could reply to this I would be happy, I want to finish this hack ;)


\\- Speedy -//

You set it in the admin control panel now,

[Emuman]

umm i cant find the warnconfig.php file.

[groovesalad]

Where do I find the warnconfig.php file? This hack doesn't seem to work without it.

[Erwin]

Looks like he forgot to include it in his new ZIP file.

Here is a copy of mine - just upload it into your ADMIN directory. Make sure you modify the variables to suit your site.

[groovesalad]

Do you know if this works on 2.2.8? I do'nt get a link to the warnings in the Postbit nor does it link correctly on the Index page.

http://www.groove-salad.com/forum

[Erwin]

It works for 2.2.8 - you may have installed the hack wrongly, or you may have the wrong settings in warnconfig.php (for the forum directory).

[g-force2k2]

im sorry for my awayness as of late... but i don't know when i will be back... im sorry to everyone that i have let down but i have other priorities at the moment...

as for the warnconfig.php i don't know how many times in my thread that i have stated there isn't one ;P its been replaced by the vbulletin options in version 2.0...

etones im not sure but i will take a look...

Apok if you look back i did answer your second question... you have to find the <smallfont color="{pagetextcolor}" and replace it with <smallfont

regards... again im sorry...

g-force2k2

[bejita]

g-force, i modify your scripts specialy on warn.php
if this hack exist please delete it, if no please review it.
i made this for :
- admin can warn all except admin :) ( your default )
- sm can warn all except admin and sm
- mod can warn only to user except admin,sm and mod

this what i change

checkwarngroup($admin);

change/replace with

if (($bbuserinfo[usergroupid]==5) and ($admin==6)){
checkwarngroup($admin);
}
if (($bbuserinfo[usergroupid]==7) and ($admin==6)){
checkwarngroup($admin);
}
if (($bbuserinfo[usergroupid]==7) and ($admin==5)){
checkwarngroup($admin);
}
else {}


please check again my code

[Erwin]

Originally posted by g-force2k2
as for the warnconfig.php i don't know how many times in my thread that i have stated there isn't one ;P its been replaced by the vbulletin options in version 2.0...

g-force2k2

Really? I'm using version 2.0... I should probably delete my warnconfig.php then. :)

[Miztah]

How can I get the Warning Level/Points to appear in the welcome panel?

[WoodiE]

I just upgraded to 2.2.8, how do i reinstall this?

I have ran the uninstall and it runs without a single problem, but if i run the install i get a database error:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Saturday 26th of October 2002 10:55:29 AM
Script: http://www.rcnitrotalk.com/forum/forum/admin/install_warning.php?step=2
Referer: http://www.rcnitrotalk.com/forum/admin/install_warning.php


How do i fix this?


-WoodiE

[Link14716]

Change all occurences of '40' in the install file to '99'.

Do this at your own peril, but it should work :)

[X-Fan]

Originally posted by g-force2k2
as for the warnconfig.php i don't know how many times in my thread that i have stated there isn't one ;P its been replaced by the vbulletin options in version 2.0...

Then why does it still state in the installation instructions for v2.1:


Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)

Notice ::
Open warnconfig.php and configure this according to your forum!


?!

The hack isn't working any more after I upgraded my forums to v2.2.8 I no longer see the warn link in postbit, even though the correct code is in the template. Also, clicking the Modify Warning link (indeed any of the warnings hack links) in my site's admin take me to a blank page.

Any help is appreciated, as this is an invaluable hack!

[Erwin]

X-fan, when you upgraded you must have accidentally removed some code from your functions.php and members.php - you need to reinstall the hack carefully.

[X-Fan]

Okay, I sussed it out. For some reason, the rows had gone from the settinggroup and settings tables in my site's database. I went to add them back in manually, but the vBPad hack had id 40 so I set the warnings hack to id 50.

However, clicking "Modify Warnings" in my Admin CP still brings up a blank page, even after I've set all the configurations via vBulletin Options.

[Erwin]

A blank page usually means a missing template - make sure when the required templates are in all your templateset, not just default.

[X-Fan]

Erwin, I'd added all the code back into the files and templates, but for some reason there were fields missing from my site's DB as I explained above.

I worked out the problem with Modify Warnings giving me a blank screen too - I was still using the old version of admin_warnings.php! LOL ;)

[Erwin]

There you go! All fixed, all by yourself. ;) Well done! Your site is looking good - 25 queries on your home page, and 27 on forumhome! I'm sure that's only 25% of what it was with vBPortal. :)

[X-Fan]

Thanks Erwin! I appreciate the kind words. As well as being my full-time job, my site is a labor of love for me :) It's almost like my third child! ;)

[WoodiE]

Thanks Link14716 that fixed the problem, but now when I log in the admin control panel under:

vBulletin Options -> I have two [Warnings System] links listed. How do i remove the old one?

-WoodiE

[John]

I don't see any link in postbit :(

Perhaps someone should make clear that warnconfig.php is no longer needed...

When I click on "View Warning Logs", I get:

Warning: Division by zero in c:\program files\apache group\apache\htdocs\forums\admin\admin_warning.php on line 87

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Help? :(

[John]

Weird. I went into vBulletin options, saved them, and it started to work.

Still a few minor niggles though - sometimes, when I warn a user I get this on the redirect page:

Warning: Failed to Receive in c:\program files\apache group\apache\htdocs\forums\warn.php on line 165

Any ideas? Not a real problem, just annoying ;)

Apart from that small thing, an absolutely fantastic hack. We're going to be using this a lot!

[Erwin]

Originally posted by WoodiE
Thanks Link14716 that fixed the problem, but now when I log in the admin control panel under:

vBulletin Options -> I have two [Warnings System] links listed. How do i remove the old one?

-WoodiE

Open up phpMyAdmin, go to the "setting" table, and scroll down to the end of the table, and just drop the extra columns. :)

[WoodiE]

Erwin - your a good man...thanks!

-WoodiE

[Erwin]

No problems. :)

[desi]

awesome hack...... installed without any problems .

thankx g-force2k2 :)

[Miztah]

I need help in having the forums display your current warning points in the welcome panel... how can I go about doing this?

[Mr_P]

Latest Version Warnings System Hack v2.1 Can be Found [ Here ]

After a Successful first release i decided to make a more customizeable and more optimizeable Warnings Hack well here it is...

For new installers simply run the auto installer (install_warning.php) and then use the installation_txt.php to make template and file modifications.

Ok is this the complete hack if we download the new version as im a bit confused.
As in the Install Instructions it says :

Notice ::
Open warnconfig.php and configure this according to your forum!

Yet this file is not included in the new zip so does this mean just grab this from the orginal zip or what ?

[Kuipo]

Workd Great, Using 2.2.8 and i did the folowing. Didn't deal with this part of the read me at all
Something Different?
// ++++++++++++++++++++
Go to the Admin CP and create a new usergroup.
Call the group Banned by Warnings :: And be sure to restrict all access to the forum from this usergroup!
Then Submit and right click the edit link to that new usergroup. Remember the Usergroupid for the config of the warnconfig.php!
(ie. 8)

Notice ::
Open warnconfig.php and configure this according to your forum!

i made the rest of the changes that the "installation_txt.php" says to make. then i put the files in the dir and used the "install_warning.php" (i had an error here, dunno why i just had to deleate 2 lines from "installation_txt.php": cpheader(); and cpfooter(); they kept giving me problems.)

after that the auto installer did the rest and i went into the CP and set up the options. It's just what i was thinking of earlier today... I wanted a warning script, and this is all i wanted and more.
GREAT JOB g-force2k2. btw, you might want to update the "installation_txt.php" so people dont have to dig through 17 pages of posts to figure out that there doesnt need to be a warnconfig.php ;) anyways.. good job!! *clicks install*

[Mr_P]

hmm so if no warnconfig then how do u select which usergroup is affected by this hack ?

Even in the readme it says the following :
Files to Upload (4)
// ++++++++++++++++++++
install_warning.php (admin directory - auto_installer)
warnconfig.php (admin directory)
admin_warning.php (admin directory)
warn.php (forum directory)

and cheers for quick reply m8

so something aint right or im looking at it different.I did install the old version before and it worked well but i since cleared the board and lost everything.So would like to know for sure that warn config aint needed before going ahead.

also as a final note does anyone know what queries this adds to the board ?