Log in

View Full Version : Advanced Warning System (AWS)

Pages : 1 [2] 3 4 5
mcyates
12-12-2004, 01:18 PM
where is ther updated file????
sv1cec
12-12-2004, 01:32 PM
where is ther updated file????
In the zip, you will find all updated files and instructions on how to update.

Rgds
mcyates
12-12-2004, 01:37 PM
there is usually something there like a zup file but you only have

Download
Features.txt
Versions.txt

and no zip file
sv1cec
12-12-2004, 01:43 PM
there is usually something there like a zup file but you only have

Download
Features.txt
Versions.txt

and no zip file
OOOOOOOOOOOpppppppsssssssss, OK, here it is.
Shack Networks
12-12-2004, 01:44 PM
OK I have been thinking and had another idea lol

Would it not be able to be adapted to detect duplicate posts and possibly add a warning point to the offending member ?

Just a little idea to keep you busy over xmas lol

Thanks a lot for this hack, I can not start to express my gratitude enough.

H
mcyates
12-12-2004, 02:13 PM
sorry but got a warning:

SQL-query:

ALTER TABLE `warnings` ADD COLUMN `caused_ban` char( 1 ) AFTER warned_warning_id UPDATE `"warning_options` SET version = '2.3.1' WHERE oid =1
MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `"warning_options` SET version='2.3.1' WHERE oid=1' at l
mcyates
12-12-2004, 02:15 PM
ahh i left the " in oops sorry


The first quiery worked, the second didn't


SQL-query:

UPDATE `warning_options` SET version = '2.3.1' WHERE oid =1
MySQL said:

#1054 - Unknown column 'version' in 'field list'
Delphiprogrammi
12-12-2004, 02:52 PM
the query in the lated version upgrade instruction doesn't work for me


ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id
UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.1' WHERE oid=1


reply from the MySQL server


An error occurred while attempting to execute your query. The following information was returned.
error number: 1103
error desc: Incorrect table name '".TABLE_PREFIX."warnings'


sql querries aren't my strongest point ...
Bolas
12-12-2004, 03:46 PM
It's not very difficult to do what you want, AWS is not very far from what you are asking, the main differences are:

- everybody can vote against everybody. This can be considered the same as everybody being capable of issuing warnings.
- in which case, obviously the warning points required for a ban should be much higher.

So, in reality, with some changes at who can vote (warn), some adjustements of the existing parameters and some additional parameters (like for example how many times a member can warn another member), a system like the one you describe is possible.

Or, you can add another level above the whole hack, where users are really voting for a particular warning which the admins have decided to issue against a particular member, and the results of these votes decide if the warning is issued or not. This is getting too "democratic" for my taste, and too much democracy easily leads to anarchy.

I am not sure if the above make sense, too late in the evening and too many things in my mind, so sorry if they sound like a drunk man's words (I swear, no drinks).

Rgds


The idea is the following: anybody can vote the ban proposal and once the quorum has been reached, the ban proposal is sent to the moderator of such forum. This way, the users of a forum can bring up the need for a change towards that person but only one of the moderators can approve it (or an administrator)

Is this true Democracy or a way to prevent unwanted people? :devious:
mcyates
12-12-2004, 03:57 PM
the query in the lated version upgrade instruction doesn't work for me


ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id
UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.1' WHERE oid=1


reply from the MySQL server


An error occurred while attempting to execute your query. The following information was returned.
error number: 1103
error desc: Incorrect table name '".TABLE_PREFIX."warnings'


sql querries aren't my strongest point ...

I got the first quiery working:


ALTER TABLE `warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

by removing the botton query and removing the ".TABLE_PREFIX." which was infront og the warnings.
TRStealth
12-12-2004, 05:16 PM
I'm getting a problem:


Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
warner='1',
automatic_warner='1',
banned_limit='5',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7|11|14|5|6|9|13|15|12|1 0',
aprotected_usergroups='11|14|5|6|9|13|15|12|10',
restore_groupid='',
incr_ban_days='Yes',
max_no_bans='2',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='30'
where oid='1'
mysql error: Unknown column 'automaticpm' in 'field list'

mysql error number: 1054

Date: Sunday 12th of December 2004 07:14:35 PM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx


Also, when I go to Warn.php?do=ViewMyWarnings , it just comes out as a blank page.
sv1cec
12-12-2004, 07:48 PM
OK I have been thinking and had another idea lol

Would it not be able to be adapted to detect duplicate posts and possibly add a warning point to the offending member ?

Just a little idea to keep you busy over xmas lol

Thanks a lot for this hack, I can not start to express my gratitude enough.

H
If I am not mistaken, if you try to enter the same exact post twice, vB is telling you you are not allowed to do that. Maybe I can check that code and see how it is done, and adapt it. The think is, I am quite overbooked for Christmas, Revan just send me his version of this hack, which is using the vboptions for the warning options (I am not exactly sure what the benefits are), and I have a couple of ideas I want to incorporate before Christmas. Oh yes, I also do not know if the nursery schools have Christmas vacations like normal schools do, if they do have, forget me for the duration of the Holidays Season. I'll be too busy taking care of the twins.

LoL
Delphiprogrammi
12-12-2004, 08:27 PM
hi,

allright i got a version number at the upper right corner but not tin the warning template probably i'm doing something wrong gonna leave it alone for a while now before i screw up out of "nervosity"
sv1cec
12-13-2004, 04:05 AM
hi,

allright i got a version number at the upper right corner but not tin the warning template probably i'm doing something wrong gonna leave it alone for a while now before i screw up out of "nervosity"
Just make the start of your template look like this:


<form action="Warn.php" method="post">
<input type="hidden" name="do" value="DoWarnUser">
<input type="hidden" name="id" value="{$_GET['id']}">
<input type="hidden" name="post" value="{$_GET['post']}">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tfoot" colspan="2">Advanced Warning System - Version $warn_opts[version]</td>
</tr>
<tr>
<td class="tcat" colspan="2">Warning User $user[username]<div class="smallfont">All links below, will open a new browser window, close it to return here.</div></td>
</tr>


Mind you the templates changes were in 2.3.1, but that shouldn't make any difference.

Rgds
Delphiprogrammi
12-13-2004, 11:38 AM
it's working :rolleyes:


:D
sv1cec
12-13-2004, 12:09 PM
it's working :rolleyes:


:D
I am glad you got it working.

Rgds
Curzon564
12-13-2004, 09:24 PM
This hack is really great!

Most things seem to work now on my board but there is still one problem I can't fix.


Datenbankfehler in vBulletin 3.0.3:
Ung?ltiger SQL String: insert into vb_warnings values('','1222','1','1102977604','','25841','2',' N','A','','')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136

I can't find any error in my warnings table


wid int(15) Nein auto_increment
warned_user int(15) Nein 0
warned_by int(15) Nein 0
warned_time int(15) Nein 0
warned_reason text Nein
warned_post int(15) Nein 0
warned_warning_id int(15) Nein 0
warned_status char(1) Ja NULL
removed_by int(15) Ja NULL
removed_date int(15) Ja NULL


Any solution for this?
sv1cec
12-14-2004, 03:39 AM
This hack is really great!

Most things seem to work now on my board but there is still one problem I can't fix.



I can't find any error in my warnings table



Any solution for this?
Yes, you have not run the query that adds the "caused_ban" column in your warnings table. Run it now:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Rgds
SamirDarji
12-14-2004, 03:49 AM
Yes, you have not run the query that adds the "caused_ban" column in your warnings table. Run it now:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Rgds
Hey John, wanna start fixing this hack? ;)
sv1cec
12-14-2004, 03:52 AM
Hey John, wanna start fixing this hack? ;)
What you mean "fix this hack"? I am doing my best!!!

Rgds
Curzon564
12-14-2004, 12:08 PM
Yes, you have not run the query that adds the "caused_ban" column in your warnings table. Run it now:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Rgds


Thanks for your help.
This fixed the problem.
SamirDarji
12-14-2004, 01:42 PM
What you mean "fix this hack"? I am doing my best!!!

Rgds
It was a joke! :D I actually thought I was looking at the thread for the vb Articles (too many open windows) and thought this reply was there. My mistake! Please take no offense!

I downloaded the hack today to completely install on my test server before rollout on the live server. I've seen quite a few hacks, and read a lot of the documentation that comes with it. By far, this is most thorough and detailed bit of instructions that I've ever seen. I thought you were awesome from just the quick replys to have to issues with the hack, but your hack has gone above and beyond any hack I've seen. I mean, vb itself doesn't have this detailed documentation, lol. If this doesn't make hack of the year (if there is such a thing), I would think the judges to be crazy.

Any luck on the job? If not, pm me because I need some hacks made for my site. Two of them are very simple. I even have the logic for them laid out. But a third one is killer hard and will require some real thinking and development. I was looking into paying someone to do it, and if you work this way with all your clients, I think you're the man for the job.
SamirDarji
12-14-2004, 02:31 PM
While I was changing the templates for postbit, I ran into the following:

"In the same template, find:

$post[reputationdisplay]</if>"


Mine had:

$post[reputationdisplay]</div></if>


Did you want the additional code put in before the last div tag or did you want it after it? Thank you again John. It's been a smooth install so far.
SamirDarji
12-14-2004, 02:47 PM
Another issue. For some reason when setting the warning options, it won't show the "Banned Users" usergroup in the drop-down box for the Permanent Ban Group. It appears fine in the drop-down box above. This one's stumping me.
SamirDarji
12-14-2004, 02:53 PM
Ok, something's definitely wrong here. I saved the Warning Options and it just gave me a blank screen on the side of the frame. Sometimes my test server does stuff like that, so I didn't pay it any mind. But I went back to check if my options were saved, and none of them were. It also did the blank screen thing when I did the last step on the upgrade_warn.php (I believe I had some version of ZT's hack installed). Something tells me the db didn't get modded. :( Any assistance appreciated.
SamirDarji
12-14-2004, 02:57 PM
Man, I'm just racking these up. When trying to View Warning Logs, get the following error

Warning: Division by zero in e:\wampp13cs\htdocs\vb3\admincp\admin_warn.php on line 283

I know the logs are empty because I haven't warned anyone. Could that be the problem?
SamirDarji
12-14-2004, 03:10 PM
When I went to view warned users, I got the same error:

Warning: Division by zero in e:\wampp13cs\htdocs\vb3\admincp\admin_warn.php on line 463

Again, it could be because there are no warned users.
sv1cec
12-14-2004, 03:12 PM
Let's take your question in the order they came.

- postbit template. Mine (3.0.3) doesn't have any div there, so I can't be sure. I suggest you experiment.

- banned user group not appearing, you are right, I haven't seen that, I'll look it up and post a correction here.

- your last error is a result of not saving the warning options properly. One of the parameters defined there, is the records per page, so if that is not set, the program tries to divide by nothing.

Let's see what we can do to help here:

First of all, try to see if you have the proper tables. Check the following tables by comparing the results of the "describe tablename" command with the columns described in the installation instructions. Second, check to see if the required templates have been added.

We'll take it from there.

Rgds
sv1cec
12-14-2004, 03:31 PM
What was I thinking?????

OK, to fix the issue with the banned users group not appearing in the drop-down menus of the other options, please open your admin_warn.php file and find:


if($usergroup['usergroupid']!=$warn_opts['banned_usergroup_id'] AND $usergroup['usergroupid']!=$warn_opts['troll_usergroup_id'] AND $usergroup['usergroupid']!=$warn_opts['restore_groupid'])
{
$uoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
$tuoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
$restoreoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}


Replace that part of code with:


if($usergroup['usergroupid']!=$warn_opts['banned_usergroup_id'])
{
$uoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}
if($usergroup['usergroupid']!=$warn_opts['troll_usergroup_id'])
{
$tuoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}
if($usergroup['usergroupid']!=$warn_opts['restore_groupid'])
{
$restoreoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}


I'll post a new version in the zip file, in a minute.
beano33
12-14-2004, 03:36 PM
A whole usergroup for yourself!!!

Why didn't you just add yourself in the admins?

Just add that group in the "Protected Usergroups" option, in the Warning Options.

Rgds

Protected Usergroups isn't working on my installation. I have Use Hierarchical Schema set to no and added 13|18 as protected usergroups, but it's having no effect. Any suggestions? Everything else seems to be working as intended.
SamirDarji
12-14-2004, 03:42 PM
As always, thank you for the unreal amount of assistance you have given us with this hack. I feel I can't say it enough times. :D

- postbit template. Mine (3.0.3) doesn't have any div there, so I can't be sure. I suggest you experiment.Interesting. I'm also running 3.0.3. In your template, is your new code inside a div tag? If so, where does the tag start?

- banned user group not appearing, you are right, I haven't seen that, I'll look it up and post a correction here.Let me know where to look and I'll also see if isn't just that I messed up somewhere.

- your last error is a result of not saving the warning options properly. One of the parameters defined there, is the records per page, so if that is not set, the program tries to divide by nothing.Makes sense :)

First of all, try to see if you have the proper tables. Check the following tables by comparing the results of the "describe tablename" command with the columns described in the installation instructions. Second, check to see if the required templates have been added.Where are these listed? I looked through every .txt file.

I just started parsing through the upgrade_warn.php and looking in phpmyadmin to see about the database tables. That's where the problem seems to be. Looks like it never updated the warning_options table, although it did all the other ones. I'm assuming that everything up to this point probably worked. So now how do I fix it?
SamirDarji
12-14-2004, 03:49 PM
What was I thinking?????

OK, to fix the issue with the banned users group not appearing in the drop-down menus of the other options, please open your admin_warn.php file and find:


if($usergroup['usergroupid']!=$warn_opts['banned_usergroup_id'] AND $usergroup['usergroupid']!=$warn_opts['troll_usergroup_id'] AND $usergroup['usergroupid']!=$warn_opts['restore_groupid'])
{
$uoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
$tuoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
$restoreoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}


Replace that part of code with:


if($usergroup['usergroupid']!=$warn_opts['banned_usergroup_id'])
{
$uoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}
if($usergroup['usergroupid']!=$warn_opts['troll_usergroup_id'])
{
$tuoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}
if($usergroup['usergroupid']!=$warn_opts['restore_groupid'])
{
$restoreoption.="<option value='{$usergroup['usergroupid']}'>{$usergroup['title']} (ID: {$usergroup['usergroupid']})</option>";
}


I'll post a new version in the zip file, in a minute.
Yep, that fixed it. :D
sv1cec
12-14-2004, 04:06 PM
Protected Usergroups isn't working on my installation. I have Use Hierarchical Schema set to no and added 13|18 as protected usergroups, but it's having no effect. Any suggestions? Everything else seems to be working as intended.
When you are saying it does not work, do you mean that the members which have groups 13 and 18 as PRIMARY user group, can still be warned? The hack checks only if someone's primary group is in the protected groups, so if someone is a registered user (group 2) and he also belongs in another group (additional user group), this is not checked.

Let me know, because everything seems to be OK here.

Rgds
beano33
12-14-2004, 04:16 PM
When you are saying it does not work, do you mean that the members which have groups 13 and 18 as PRIMARY user group, can still be warned?
Rgds

Yes, that's the case. They're only used as primary groups.
sv1cec
12-14-2004, 04:33 PM
Yes, that's the case. They're only used as primary groups.
I found the problem. When I moved some routines in the functions_warning.php file, I didn't pass along the proper parameters. Have it fixed, but give me a moment to update the zip file.

Then download the zip and upload Warn.php and includes/functions_warning.php files to your server.

Sorry for the inconvenience and thanks for cathing this.
Revan
12-14-2004, 05:25 PM
Btw that "saving options properly" issue... Wouldnt it make more sense to put an if() around the page calculation page, saying summit liek if ($options['warn_perpage'] == 0) { $options['warn_perpage'] = 15; }, to avoid these bugs?
beano33
12-14-2004, 05:32 PM
I found the problem. When I moved some routines in the functions_warning.php file, I didn't pass along the proper parameters. Have it fixed, but give me a moment to update the zip file.

Then download the zip and upload Warn.php and includes/functions_warning.php files to your server.

Sorry for the inconvenience and thanks for cathing this.

Thanks! Working fine now. :)
sv1cec
12-14-2004, 05:33 PM
As always, thank you for the unreal amount of assistance you have given us with this hack. I feel I can't say it enough times. :D

Interesting. I'm also running 3.0.3. In your template, is your new code inside a div tag? If so, where does the tag start?

Let me know where to look and I'll also see if isn't just that I messed up somewhere.

Makes sense :)

Where are these listed? I looked through every .txt file.

I just started parsing through the upgrade_warn.php and looking in phpmyadmin to see about the database tables. That's where the problem seems to be. Looks like it never updated the warning_options table, although it did all the other ones. I'm assuming that everything up to this point probably worked. So now how do I fix it?


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
SamirDarji
12-14-2004, 05:41 PM
Btw that "saving options properly" issue... Wouldnt it make more sense to put an if() around the page calculation page, saying summit liek if ($options['warn_perpage'] == 0) { $options['warn_perpage'] = 15; }, to avoid these bugs?It probably won't happen like it did in my case because I didn't even have the tables. If he would've had the check in there, I might not even have discovered the missing tables, lol.
sv1cec
12-14-2004, 05:43 PM
Btw that "saving options properly" issue... Wouldnt it make more sense to put an if() around the page calculation page, saying summit liek if ($options['warn_perpage'] == 0) { $options['warn_perpage'] = 15; }, to avoid these bugs?
Added that in the latest zip. If I start trapping all those stupid errors, the code will get enormous, after all these are in the admins section, an admin should know better, but you can never count on that, can you?
Revan
12-14-2004, 05:47 PM
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
12-14-2004, 05:49 PM
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
12-14-2004, 05:49 PM
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
12-14-2004, 05:51 PM
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
12-14-2004, 05:54 PM
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
12-14-2004, 05:57 PM
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
12-14-2004, 05:59 PM
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;exactname=1&amp;s earchuser=$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
12-14-2004, 06:21 PM
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
12-14-2004, 06:32 PM
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
12-14-2004, 06:49 PM
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
SamirDarji
12-14-2004, 06:57 PM
My friend, if you had no warnings in ZT's hack, delete everything and start from scratch. Why bother?
I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.

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.
Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.
sv1cec
12-14-2004, 07:32 PM
I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.


Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.
I double-checked (sometimes, you never know what YOU have done), and the uninstaller removes only the templates that the hack adds. Not the ones, which existed and you modified. And of course, it does not change the php files you changed.

Rgds
SamirDarji
12-14-2004, 07:54 PM
Well, here's what I got back from the SQL Query:

Database forum - Table warning_options running on hsvtest.ods.org
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: 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)";

SQL-query :

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)";

MySQL said:


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead

I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?
sv1cec
12-14-2004, 08:42 PM
Well, here's what I got back from the SQL Query:

Database forum - Table warning_options running on hsvtest.ods.org
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: 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)";

SQL-query :

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)";

MySQL said:


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead

I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?
The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
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)

Rgds
SamirDarji
12-14-2004, 09:08 PM
The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
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)

Rgds
Ooops!! I forgot to get the newest zip. It's been a crazy day. Trying to change headlights in my car and it was so cold that my frozen hands couldn't do anything for more than 15 mins. So I was going back and forth between this and the car.
SamirDarji
12-14-2004, 09:11 PM
That worked. Should I go ahead and run the other query that put the default options in the tables or should I just go ahead and set the warning options through admincp?
nubian
12-15-2004, 12:01 AM
can somebody please help me.
i cannot find this...

$post[reputationdisplay]</if>

in my postbit.
the only thing that comes close to that is this:

<div class="smallfont">
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
<if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
<div>
$vbphrase[posts]: $post[posts]
</div>
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
</div>


do i just add it under this line of code?
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>

i have a virgin postbit template from v 3.0.3
i'm very new to coding
thanks in advance
nubian
12-15-2004, 01:34 AM
with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance
SamirDarji
12-15-2004, 02:12 AM
with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance
Sounds like a template issue to me rather than a php one. Check over your template changes and make sure they are correct too.
TRStealth
12-15-2004, 03:15 AM
I'm getting a problem:


Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
warner='1',
automatic_warner='1',
banned_limit='5',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7|11|14|5|6|9|13|15|12|1 0',
aprotected_usergroups='11|14|5|6|9|13|15|12|10',
restore_groupid='',
incr_ban_days='Yes',
max_no_bans='2',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='30'
where oid='1'
mysql error: Unknown column 'automaticpm' in 'field list'

mysql error number: 1054

Date: Sunday 12th of December 2004 07:14:35 PM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx


Also, when I go to Warn.php?do=ViewMyWarnings , it just comes out as a blank page.

I fixed the view warnings thing, but can anyone tell me why I'm getting the SQL Error?
nubian
12-15-2004, 03:16 AM
Sounds like a template issue to me rather than a php one. Check over your template changes and make sure they are correct too.
thank you i fixed it.
hopefully NO PROBLEMS.
first time hacking my board.
:eek:
sv1cec
12-15-2004, 04:03 AM
I fixed the view warnings thing, but can anyone tell me why I'm getting the SQL Error?
Because the database and the code are not of matching versions. In other words, your table hasn't all the columns required by the code. Go create the 'automaticpm' column in your table, by running the following query:

alter table `warning_options` add `automaticpm` char(3) after automatic

But, still you do not have all the columns in the table. What I see missing is the 'version` column.

Folks, please download and install always the latest version. Or, make sure you always upgrade to the latest version, or else it is very difficult for me to support you.

Rgds
Delphiprogrammi
12-15-2004, 04:34 AM
all up and running ;)
SamirDarji
12-15-2004, 05:08 AM
Well, I tried the query and ran it--worked fine. Set all the options--set fine. Went to see what it looked like on the board--had 2 copies of "Warn User" and "View Warnings"--no biggie, probably just a template error. Got a blank page when I tried to warn user or view warnings--probably just something was messed up.

I unstalled using the uninstaller.php and then tried to look at the forum--blank page. Now I can't get anything out of my board, but a blank page. I can't even get to admincp. What did I do wrong?
Delphiprogrammi
12-15-2004, 09:07 AM
revert all the modified templates *.php files you do have a copy do you ? and what about a database backup BEFORE you try to install this hack ? always backup when something is "havy" modifying the original code
Goodspeed
12-15-2004, 09:17 AM
I got just a little bug. Everything working fine, but this error allways appears when I'm adding a warning

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/site/public_html/forum/Warn.php(310) : eval()'d code on line 23

Please help. Thank you!
sv1cec
12-15-2004, 09:21 AM
You can't even get in your admincp??? That's odd. You must have messed something up, but I have no idea where. The uninstaller is only removing the templates added by the hack, the tables and the settings. It doesn't touch anything else.

Try reverting your admincp/index.php file to the original and see if that works.

Keep me posted. I'll try to check here often to see how I can help.
jluerken
12-15-2004, 09:49 AM
Hi,

I have one small last error with this hack in version 2.3.1.

If I take a look in the threads I get an display error in the Internet Explorer.
Please take a look at the screenshot.

Can someone send me the correct modified template or post it here please?
sv1cec
12-15-2004, 09:51 AM
I got just a little bug. Everything working fine, but this error allways appears when I'm adding a warning

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/site/public_html/forum/Warn.php(310) : eval()'d code on line 23

Please help. Thank you!
When does it happen? When you hit the "Warn XYZ" link? or after you warn someone? Some template must be wrong, but I can't reproduce it here.
Delphiprogrammi
12-15-2004, 09:52 AM
I got just a little bug. Everything working fine, but this error allways appears when I'm adding a warning

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/site/public_html/forum/Warn.php(310) : eval()'d code on line 23

Please help. Thank you!

this is a typical PHP syntax error basicly it means you forgot a " or ' or } { etc for example


<?php
$test="this is a test"
echo $test;
?>


will generate a parse error because there is no ; at the end of the string $test you should look in the line number (or the lines above it)
sv1cec
12-15-2004, 10:00 AM
Hi,

I have one small last error with this hack in version 2.3.1.

If I take a look in the threads I get an display error in the Internet Explorer.
Please take a look at the screenshot.

Can someone send me the correct modified template or post it here please?
You have left something there, it should be in your postbit template.
jluerken
12-15-2004, 10:10 AM
You have left something there, it should be in your postbit template.

Can you please post yours here like you did with the MEMBERINFO template for me?
sv1cec
12-15-2004, 10:32 AM
Can you please post yours here like you did with the MEMBERINFO template for me?
I could, but mine contains some other hacks as well, so I'd better see yours. Post here the part which starts from the beginning and ends somewhere around where the checks for warning system start.

Rgds
jluerken
12-15-2004, 10:42 AM
I could, but mine contains some other hacks as well, so I'd better see yours. Post here the part which starts from the beginning and ends somewhere around where the checks for warning system start.

Rgds

Here we go


<!-- post #$post[postid] -->
<if condition="$show['spacer']">
<!-- $spacer_open -->
<!-- open content container -->
<if condition="$show['old_explorer']">
<table cellpadding="0" cellspacing="0" border="0" width="$stylevar[outertablewidth]" align="center"><tr><td class="page" style="padding:0px 0px 0px 0px">
<else />
<div align="center">
<div class="page" style="width:$stylevar[outerdivwidth]; text-align:$stylevar[left]">
<div style="padding:0px 0px 0px 0px">

</if>
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']">
<!-- this is not the last post shown on the page --></if>
</if>

<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" $scrolltothis>
<div class="normal" style="float:$stylevar[right]">
&nbsp;

<!-- checks for warning system -->
<if condition="THIS_SCRIPT=='showthread'">
<if condition="$hierarchical=='No'">
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])">
<a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[username]</a> ?
</if>
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND ($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6)">
<a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[username]'s Warnings</a> ?
</if>
<if condition="$post[userid]==$bbuserinfo[userid] AND $post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND $post[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a> ?
</if>
</if>
<if condition="$hierarchical=='Yes'">
<if condition="($post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])) OR ($post[usergroupid]==7 AND can_moderate($forum[forumid], '', $bbuserinfo[userid]) AND $bbuserinfo[usergroupid]==5) OR
($bbuserinfo[usergroupid]==6 AND $post[usergroupid]!=6)">
<a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[username]</a> ?
</if>
<if condition="($post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7 AND ($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5)) OR ($post[usergroupid]==7 AND $bbuserinfo[usergroupid]==5) OR ($bbuserinfo[usergroupid]==6 AND $post[usergroupid]!=6)">
<a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[username]'s Warnings</a> ?
</if>
<if condition="$post[userid]==$bbuserinfo[userid] AND $post[usergroupid]!=6 AND $post[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a> ?
</if>
</if>
</if>

<!-- end of warning system -->
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new"><strong>$post[postcount]</strong></a> &nbsp;</if>
<if condition="$show['reputationlink']"><a href="#" onclick="return reputation($post[postid])"><img class="inlineimg" src="$stylevar[imgdir_button]/reputation.gif" alt="<phrase 1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase>" border="0" /></a> &nbsp;</if>
<if condition="$show['reportlink']"><a href="report.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/report.gif" alt="$vbphrase[report_bad_post]" border="0" /></a> &nbsp;</if>
$post[iplogged]
</div>
<div class="normal">
<!-- status icon and date -->
<a name="post$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif" alt="$post[statustitle]" border="0" /></a>
<if condition="!$show['start_until_end']">
$post[postdate]<if condition="!$show['detailedtime']">, $post[posttime]</if>
<else />
<phrase 1="$post[startdate]" 2="$post[enddate]">$vbphrase[x_until_y]</phrase>
</if>
$post[firstnewinsert]
<!-- / status icon and date -->
</div>
</td>
</tr>
<tr>
<td class="alt2" style="padding:0px">
<!-- user info -->
<table cellpadding="0" cellspacing="$stylevar[cellpadding]" border="0" width="100%">
<tr>
<if condition="$show['avatar']"><td class="alt2"><a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$avatarurl" alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a></td></if>
<td nowrap="nowrap">

<div id="postmenu_$post[postid]">
<if condition="$show['profile']">
<a class="bigusername" href="member.php?$session[sessionurl]u=$post[userid]"><if condition="$post[field5]"><b>$post[field5]</b><else /><b>$post[musername]</b></if></a>
$post[onlinestatus]
<script type="text/javascript"> vbmenu_register("postmenu_$post[postid]", true); </script>
<else />
<if condition="$post[field5]">$post[field5]<else />$post[musername]</if>
</if>
</div>

<if condition="$post['usertitle']"><div class="smallfont">$post[usertitle]</div></if>
<if condition="$post['rank']"><div class="smallfont">$post[rank]</div></if>
$post[arcadeawards]
</td>
<td width="100%">&nbsp;</td>
<td valign="top" nowrap="nowrap">

<div class="smallfont">
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
<if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
<div>
$vbphrase[posts]: $post[posts]
<if condition="$show['reputation']">$post[reputationdisplay]</if>
<if condition="$viewoption=='All'">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='Yes'">
<if condition="($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7)
OR
($bbuserinfo[usergroupid]==5 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5)
OR
($bbuserinfo[usergroupid]==6)
">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[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) OR ($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid]))">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>
</div>
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
</div>

</td>
</tr>
</table>
<!-- / user info -->
</td>
</tr>
<tr>
<td class="alt1">
<!-- message, attachments, sig -->

<if condition="$show['messageicon'] OR $post['title']">
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if condition="$post['title']"><strong><if condition="$forum['allowcategories'] AND $thread['category'] AND $post['postid'] == $thread['firstpostid']">$thread[category] - </if>$post[title]</strong></if>
</div>
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
</if>

<!-- message -->
<div>$post[message]</div>
<!-- / message -->

<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>

<if condition="$post['signature']">
<!-- sig -->
<div>
<br />
<fieldset><legend>$post[username]'s Sig:</legend><table width="100%"><tr><td>
$post[signature]
</td></tr>
</table></fieldset>
</div>
<!-- / sig -->
</if>

<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont"> <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>.
<if condition="$post['edit_reason']">$vbphrase[reason]: $post[edit_reason]</if>
</em>
</div>
<!-- / edit note -->
</if>

<div align="$stylevar[right]">
<!-- controls -->
<if condition="$post['editlink']">
<a href="$post[editlink]"><img src="$stylevar[imgdir_button]/edit.gif" alt="$vbphrase[edit_delete_message]" border="0" /></a>
</if>
<if condition="$post['forwardlink']">
<a href="$post[forwardlink]"><img src="$stylevar[imgdir_button]/forward.gif" alt="$vbphrase[forward_message]" border="0" /></a>
</if>
<if condition="$post['replylink']">
<a href="$post[replylink]"><img src="$stylevar[imgdir_button]/reply_small.gif" alt="$vbphrase[reply_with_quote]" border="0" /></a>
</if>
<if condition="$SHOWQUICKREPLY AND !$show['threadedmode']">
<a href="$post[replylink]" onclick="return qr($post[postid]);"><img src="$stylevar[imgdir_button]/quickreply.gif" alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a>
</if>
<!-- / controls -->
</div>

<!-- message, attachments, sig -->

</td>
</tr>
</table>

<!-- post $post[postid] popup menu -->
<div class="vbmenu_popup" id="postmenu_$post[postid]_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$post[username]</td>
</tr>
<if condition="$show['profile']">
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]userid=$post[userid]" target="_blank">$vbphrase[view_public_profile]</a></td></tr>
</if>
<if condition="$post['arcadesettings'] & 4 AND $post[userid]!=$bbuserinfo[userid] AND $bbuserinfo[userid]!=0">
<tr><td class="vbmenu_option"><a href="arcade.php?$session[sessionurl]do=newchallenge&userid=$post[userid]" target="_self">Challenge $post[username] in the Arcade</a></td></tr>
</if>
<if condition="$show['pmlink']">
<tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]do=newpm&amp;userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[send_private_message_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['emaillink']">
<tr><td class="vbmenu_option"><a href="sendmessage.php?$session[sessionurl]do=mailmember&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[send_email_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['homepage']">
<tr><td class="vbmenu_option"><a href="$post[homepage]"><phrase 1="$post[username]">$vbphrase[visit_xs_homepage]</phrase></a></td></tr>
</if>
<if condition="$show['search']">
<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=finduser&amp;userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[find_all_posts_by_x]</phrase></a></td></tr>
</if>
<if condition="$post['userid']">
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
</if>
</table>
</div>
<!-- / post $post[postid] popup menu -->




<if condition="$show['spacer']">
</div>
$spacer_close
</if>
<!-- / post #$post[postid] -->
sv1cec
12-15-2004, 11:26 AM
Here we go


<!-- post #$post[postid] -->
<if condition="$show['spacer']">
<!-- $spacer_open -->
<!-- open content container -->
<if condition="$show['old_explorer']">
<table cellpadding="0" cellspacing="0" border="0" width="$stylevar[outertablewidth]" align="center"><tr><td class="page" style="padding:0px 0px 0px 0px">
<else />
<div align="center">
<div class="page" style="width:$stylevar[outerdivwidth]; text-align:$stylevar[left]">
<div style="padding:0px 0px 0px 0px">

</if>
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']">
<!-- this is not the last post shown on the page --></if>
</if>

<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" $scrolltothis>
<div class="normal" style="float:$stylevar[right]">
&nbsp;

<!-- checks for warning system -->
<if condition="THIS_SCRIPT=='showthread'">
<if condition="$hierarchical=='No'">
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])">
<a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[username]</a> ?
</if>
<if condition="$post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND ($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6)">
<a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[username]'s Warnings</a> ?
</if>
<if condition="$post[userid]==$bbuserinfo[userid] AND $post[usergroupid]!=6 AND $post[usergroupid]!=7 AND $post[usergroupid]!=5 AND $post[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a> ?
</if>
</if>
<if condition="$hierarchical=='Yes'">
<if condition="($post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7 AND can_moderate($forum[forumid], '', $bbuserinfo[userid])) OR ($post[usergroupid]==7 AND can_moderate($forum[forumid], '', $bbuserinfo[userid]) AND $bbuserinfo[usergroupid]==5) OR
($bbuserinfo[usergroupid]==6 AND $post[usergroupid]!=6)">
<a href='Warn.php?do=WarnUser&id=$post[userid]&post=$post[postid]'>Warn $post[username]</a> ?
</if>
<if condition="($post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7 AND ($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5)) OR ($post[usergroupid]==7 AND $bbuserinfo[usergroupid]==5) OR ($bbuserinfo[usergroupid]==6 AND $post[usergroupid]!=6)">
<a href='Warn.php?do=ViewWarnings&id=$post[userid]'>View $post[username]'s Warnings</a> ?
</if>
<if condition="$post[userid]==$bbuserinfo[userid] AND $post[usergroupid]!=6 AND $post[warning_level]>0">
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a> ?
</if>
</if>
</if>

<!-- end of warning system -->
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new"><strong>$post[postcount]</strong></a> &nbsp;</if>
<if condition="$show['reputationlink']"><a href="#" onclick="return reputation($post[postid])"><img class="inlineimg" src="$stylevar[imgdir_button]/reputation.gif" alt="<phrase 1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase>" border="0" /></a> &nbsp;</if>
<if condition="$show['reportlink']"><a href="report.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/report.gif" alt="$vbphrase[report_bad_post]" border="0" /></a> &nbsp;</if>
$post[iplogged]
</div>
<div class="normal">
<!-- status icon and date -->
<a name="post$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif" alt="$post[statustitle]" border="0" /></a>
<if condition="!$show['start_until_end']">
$post[postdate]<if condition="!$show['detailedtime']">, $post[posttime]</if>
<else />
<phrase 1="$post[startdate]" 2="$post[enddate]">$vbphrase[x_until_y]</phrase>
</if>
$post[firstnewinsert]
<!-- / status icon and date -->
</div>
</td>
</tr>
<tr>
<td class="alt2" style="padding:0px">
<!-- user info -->
<table cellpadding="0" cellspacing="$stylevar[cellpadding]" border="0" width="100%">
<tr>
<if condition="$show['avatar']"><td class="alt2"><a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$avatarurl" alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a></td></if>
<td nowrap="nowrap">

<div id="postmenu_$post[postid]">
<if condition="$show['profile']">
<a class="bigusername" href="member.php?$session[sessionurl]u=$post[userid]"><if condition="$post[field5]"><b>$post[field5]</b><else /><b>$post[musername]</b></if></a>
$post[onlinestatus]
<script type="text/javascript"> vbmenu_register("postmenu_$post[postid]", true); </script>
<else />
<if condition="$post[field5]">$post[field5]<else />$post[musername]</if>
</if>
</div>

<if condition="$post['usertitle']"><div class="smallfont">$post[usertitle]</div></if>
<if condition="$post['rank']"><div class="smallfont">$post[rank]</div></if>
$post[arcadeawards]
</td>
<td width="100%">&nbsp;</td>
<td valign="top" nowrap="nowrap">

<div class="smallfont">
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
<if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
<div>
$vbphrase[posts]: $post[posts]
<if condition="$show['reputation']">$post[reputationdisplay]</if>
<if condition="$viewoption=='All'">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='Yes'">
<if condition="($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7)
OR
($bbuserinfo[usergroupid]==5 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5)
OR
($bbuserinfo[usergroupid]==6)
">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[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) OR ($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid]))">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>
</div>
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
</div>

</td>
</tr>
</table>
<!-- / user info -->
</td>
</tr>
<tr>
<td class="alt1">
<!-- message, attachments, sig -->

<if condition="$show['messageicon'] OR $post['title']">
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if condition="$post['title']"><strong><if condition="$forum['allowcategories'] AND $thread['category'] AND $post['postid'] == $thread['firstpostid']">$thread[category] - </if>$post[title]</strong></if>
</div>
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
</if>

<!-- message -->
<div>$post[message]</div>
<!-- / message -->

<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">

<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>

<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>

<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>

<if condition="$post['signature']">
<!-- sig -->
<div>
<br />
<fieldset><legend>$post[username]'s Sig:</legend><table width="100%"><tr><td>
$post[signature]
</td></tr>
</table></fieldset>
</div>
<!-- / sig -->
</if>

<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont"> <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>.
<if condition="$post['edit_reason']">$vbphrase[reason]: $post[edit_reason]</if>
</em>
</div>
<!-- / edit note -->
</if>

<div align="$stylevar[right]">
<!-- controls -->
<if condition="$post['editlink']">
<a href="$post[editlink]"><img src="$stylevar[imgdir_button]/edit.gif" alt="$vbphrase[edit_delete_message]" border="0" /></a>
</if>
<if condition="$post['forwardlink']">
<a href="$post[forwardlink]"><img src="$stylevar[imgdir_button]/forward.gif" alt="$vbphrase[forward_message]" border="0" /></a>
</if>
<if condition="$post['replylink']">
<a href="$post[replylink]"><img src="$stylevar[imgdir_button]/reply_small.gif" alt="$vbphrase[reply_with_quote]" border="0" /></a>
</if>
<if condition="$SHOWQUICKREPLY AND !$show['threadedmode']">
<a href="$post[replylink]" onclick="return qr($post[postid]);"><img src="$stylevar[imgdir_button]/quickreply.gif" alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a>
</if>
<!-- / controls -->
</div>

<!-- message, attachments, sig -->

</td>
</tr>
</table>

<!-- post $post[postid] popup menu -->
<div class="vbmenu_popup" id="postmenu_$post[postid]_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$post[username]</td>
</tr>
<if condition="$show['profile']">
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]userid=$post[userid]" target="_blank">$vbphrase[view_public_profile]</a></td></tr>
</if>
<if condition="$post['arcadesettings'] & 4 AND $post[userid]!=$bbuserinfo[userid] AND $bbuserinfo[userid]!=0">
<tr><td class="vbmenu_option"><a href="arcade.php?$session[sessionurl]do=newchallenge&userid=$post[userid]" target="_self">Challenge $post[username] in the Arcade</a></td></tr>
</if>
<if condition="$show['pmlink']">
<tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]do=newpm&amp;userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[send_private_message_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['emaillink']">
<tr><td class="vbmenu_option"><a href="sendmessage.php?$session[sessionurl]do=mailmember&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[send_email_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['homepage']">
<tr><td class="vbmenu_option"><a href="$post[homepage]"><phrase 1="$post[username]">$vbphrase[visit_xs_homepage]</phrase></a></td></tr>
</if>
<if condition="$show['search']">
<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=finduser&amp;userid=$post[userid]"><phrase 1="$post[username]">$vbphrase[find_all_posts_by_x]</phrase></a></td></tr>
</if>
<if condition="$post['userid']">
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
</if>
</table>
</div>
<!-- / post $post[postid] popup menu -->




<if condition="$show['spacer']">
</div>
$spacer_close
</if>
<!-- / post #$post[postid] -->

Here is what mine looks up there, at the top of the template.


<!-- post #$post[postid] -->
<if condition="$show['spacer']">
$spacer_open
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']"><!-- this is not the last post shown on the page --></if>
</if>


<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" $scrolltothis>
<div class="normal" style="float:$stylevar[right]">
&nbsp;



I am not sure why there is a difference, maybe I didn't upgrade that template to the latest version when I upgraded the vB software. I think that the comments which exist there, have some bad effect, try removing those comments first and see if this fixes your problem.

Rgds
SamirDarji
12-15-2004, 12:43 PM
revert all the modified templates *.php files you do have a copy do you ? and what about a database backup BEFORE you try to install this hack ? always backup when something is "havy" modifying the original code
I'll try the templates, that's not a bad place to start. It's a test server, so there's all sorts of crap on it. I usually don't backup php files or the db. Now, the live board--that's a whole different story.
SamirDarji
12-15-2004, 12:47 PM
You can't even get in your admincp??? That's odd. You must have messed something up, but I have no idea where. The uninstaller is only removing the templates added by the hack, the tables and the settings. It doesn't touch anything else.

Try reverting your admincp/index.php file to the original and see if that works.

Keep me posted. I'll try to check here often to see how I can help.
I was thinking to run the uninstaller, which would get rid of the new templates, tables, and phrases, and then just reinstall. I wasn't going to revert the template changes (a pain) or change the php files, but that may be necessary. I'm glad I didn't try all this on the live board even though I'm 2 days behind schedule on deployment.

I'll completely undo everything and see what happens. This has been a time consuming process, but I guess I should've removed ZT's and installed yours from the beginning. :(
jluerken
12-15-2004, 12:49 PM
Deleting this part fixed it for me:


<if condition="$show['spacer']">
$spacer_open
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']"><!-- this is not the last post shown on the page --></if>
</if>
SamirDarji
12-15-2004, 01:26 PM
I reverted the php files by commenting out little changes and deleting large changes. That got the board back. Now I'm going to attempt to install 2.3.3 from scratch. Hope this works!
SamirDarji
12-15-2004, 02:19 PM
Seemed to have worked. Only problem I've run across is that the ability to warn is missing from the member profile. Where is the problem, template or php file? I'm thinking template, but I could be wrong.
mcyates
12-15-2004, 03:25 PM
I keep getting this error:


Invalid SQL:
INSERT INTO userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
(1033, 8, 0, 0, 'Ball boy', 1, 1103129995, 1103734795, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

mysql error number: 1054


It obviouslyt because i haven't got the column reason added. What is the SQL query to add this? The warning points are still given to the user when you select which warning but this error comes up when you submit it.
sv1cec
12-15-2004, 03:46 PM
I keep getting this error:


Invalid SQL:
INSERT INTO userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
(1033, 8, 0, 0, 'Ball boy', 1, 1103129995, 1103734795, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

mysql error number: 1054


It obviouslyt because i haven't got the column reason added. What is the SQL query to add this? The warning points are still given to the user when you select which warning but this error comes up when you submit it.
ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

Sorry about that, that's what happens when one doesn't keep notes of all the changes.
mcyates
12-15-2004, 03:51 PM
ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

Sorry about that, that's what happens when one doesn't keep notes of all the changes.
thansks. Its pretty hard work keeping up with this hack. Everytime i return to the page its been updated. Last time it was 2.3.1 now its 2.3.3. Madness. ok thanks for the help.
sv1cec
12-15-2004, 04:18 PM
thansks. Its pretty hard work keeping up with this hack. Everytime i return to the page its been updated. Last time it was 2.3.1 now its 2.3.3. Madness. ok thanks for the help.
I know, don't you want it improved?

Ah and a correction, it will be in 2.3.4 in a minute, I haven't noted down the changes required in the file modcp/banning.php. I 've added a column in the userban table, where the hack stores a special message, when it bans a user.

Give me 5 minutes to upload the instructions.
mcyates
12-15-2004, 04:28 PM
Yeah i'm just saying its hard work. lol
sv1cec
12-15-2004, 04:50 PM
Yeah i'm just saying its hard work. lol
I know and I really feel bad about it. I keep doing small things, here and there, adding some more functionality etc. and it grows and it grows.

What you want me to do? Do you folks are overwhelmed with it? Do you want me to stop adding things for a while?

Just let me know.

For the time being, I have one more thing I want to do, in the admin_warn.php, and then I'll be ... looking for new ideas.

Rgds and sorry if I cause you trouble.
jluerken
12-15-2004, 05:30 PM
I've found two smaller errors in 2.3.4

1. In the upgrade instructions youve forgotten a small line


UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.4' WHERE oid=1


:D

2. In the AdminCP the colspan has to be increased somewhere. (see attachment!)

and btw. you have to update the version numbers in the files also :nervous:
sv1cec
12-15-2004, 06:13 PM
I've found two smaller errors in 2.3.4

1. In the upgrade instructions youve forgotten a small line


UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.4' WHERE oid=1


:D

2. In the AdminCP the colspan has to be increased somewhere. (see attachment!)

and btw. you have to update the version numbers in the files also :nervous:
You are right. I've updated the instructions, if you do not mind, please download and apply the section which is marked with :

// COMMENT: CHANGES BELOW AFFECT THE COLSPAN IN THE BANNED USERS REPORT //

in the UpgradeToLatestVersion.txt file.

Don't forget to run that query as well.

Rgds and tnx
jluerken
12-15-2004, 06:32 PM
You are right. I've updated the instructions, if you do not mind, please download and apply the section which is marked with :

// COMMENT: CHANGES BELOW AFFECT THE COLSPAN IN THE BANNED USERS REPORT //

in the UpgradeToLatestVersion.txt file.

Don't forget to run that query as well.

Rgds and tnx
I updated everything.
This seems to be the most-supported Hack here on vb.org :D

Hopefully we come to a final state within the next days or do you have already more plans for future releases? haha
SamirDarji
12-16-2004, 12:51 AM
I still can't find out why the warning options aren't appearing the member profile. I checked the template and member.php and they're both correct. This is the only thing I have left to test before I install on the live server (which will go much smoother since that setup is cleaner). Any assistance appreciated.
TRStealth
12-16-2004, 02:52 AM
Because the database and the code are not of matching versions. In other words, your table hasn't all the columns required by the code. Go create the 'automaticpm' column in your table, by running the following query:

alter table `warning_options` add `automaticpm` char(3) after automatic

But, still you do not have all the columns in the table. What I see missing is the 'version` column.

Folks, please download and install always the latest version. Or, make sure you always upgrade to the latest version, or else it is very difficult for me to support you.

Rgds

Even though it was a clean install of the latest zip you have up?

k.
sv1cec
12-16-2004, 04:57 AM
Even though it was a clean install of the latest zip you have up?

k.
Well, sometimes, even the best intentions fail :-)

However, keep in mind, that the automaticpm was added in version 2.0 while the version was added in 2.3. And neither of them was in your table.

Rgds
nubian
12-16-2004, 01:36 PM
I still can't find out why the warning options aren't appearing the member profile. I checked the template and member.php and they're both correct. This is the only thing I have left to test before I install on the live server (which will go much smoother since that setup is cleaner). Any assistance appreciated.
bump this question....i don't see this as well
SamirDarji
12-16-2004, 01:49 PM
bump this question....i don't see this as well
I know someone had this problem in the past, but I searched the thread up and down and can't find where it was posted and if there was a solution.
sv1cec
12-16-2004, 02:32 PM
I know someone had this problem in the past, but I searched the thread up and down and can't find where it was posted and if there was a solution.
In order to see those links, you should have activate the "Allow Non-Post-related" warnings. If that is not set to "Yes", there are no links in the UserCP.

Please tell me if you have set that to yes, or not, so that I can see what your problem is.

Rgds
nubian
12-16-2004, 02:42 PM
In order to see those links, you should have activate the "Allow Non-Post-related" warnings. If that is not set to "Yes", there are no links in the UserCP.

Please tell me if you have set that to yes, or not, so that I can see what your problem is.

Rgds if you mean where it says under the admincp > manage warning options:

Allow Off-Post Warnings? If set to Yes, warnings can also be issued from the user profile, when you want to warn a user for a non-post related offence.
that option is set to yes and i still don't see the option to warn in the members public profile

because i don't see this, "Allow Non-Post-related" option
sv1cec
12-16-2004, 03:09 PM
if you mean where it says under the admincp > manage warning options:
that option is set to yes and i still don't see the option to warn in the members public profile

because i don't see this, "Allow Non-Post-related" option
Yeah, these are the same thing, I just changed the wording to better express the meaning, in the latest version.

IF that is set to yes and you can't see the links, two things can happen:

1. your template is not edited properly.
2. the user is not authorised to issue warnings. Assuming that the user is authorised, I would suggest that you check your template.

One more question, if the user you are checking his CP has warning points, do you see his points?

Here is what my memberinfo template looks like:


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

<!-- 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_opts[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>


rgds
T3MEDIA
12-16-2004, 05:50 PM
has all the bugs in this hack been cleared out?

since its a long hack I want to ask first.
nubian
12-16-2004, 06:59 PM
Yeah, these are the same thing, I just changed the wording to better express the meaning, in the latest version.

IF that is set to yes and you can't see the links, two things can happen:

1. your template is not edited properly.
2. the user is not authorised to issue warnings. Assuming that the user is authorised, I would suggest that you check your template.

One more question, if the user you are checking his CP has warning points, do you see his points?

Here is what my memberinfo template looks like:


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

<!-- 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_opts[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>


rgds
i have the WarningSystem_v2_3_2
i have no idea what updates you've done since .4 and .5
am i missing something here?
because the necessary coding that i do have are correct from the 2.3.2.
please help

i'm not saying hot to do your updates but there should be
sv1cec
12-16-2004, 07:02 PM
i have the WarningSystem_v2_3_2
i have no idea what updates you've done since .4 and .5
am i missing something here?
because the necessary coding that i do have are correct from the 2.3.2.
please help

i'm not saying hot to do your updates but there should be
In the zip file, there is a file called "UpdateToLatestVersion.txt". In that file, if you scroll down a little, you will find a heading saying "Upgrade from 2.3.2 to 2.3.3. Do that, then go back up and find the update from 2.3.3. to 2.3.4, apply the changes etc. until you are at the last version.

Rgds
nubian
12-16-2004, 09:08 PM
nothing major but in your 2.3.5 upgrade from 2.3.3 to 2.3.4

find:
$DB_site->query("
UPDATE " . TABLE_PREFIX . "userban SET
adminid = $bbuserinfo[userid],
bandate = " . TIMENOW . ",
liftdate = $liftdate
WHERE userid = $user[userid]
");


it doesn't find this because vb3 comes stock like this:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "userban SET
adminid = $bbuserinfo[userid],
bandate = " . TIMENOW . ",
liftdate = $liftdate,
adminid = $bbuserinfo[userid]
WHERE userid = $user[userid]
");
which i believe to be unmodified from your previous 2.3.2.
again nothing major just in case somebody else who's trying to install this doesn't think something is wrong.....or is there? :ermm:
nubian
12-16-2004, 10:11 PM
i updated to 2.3.5 and i still don't see the option under users profiles.
no one has been warned because i'm doing this under a test site before updatding my live site
SamirDarji
12-17-2004, 12:52 AM
In order to see those links, you should have activate the "Allow Non-Post-related" warnings. If that is not set to "Yes", there are no links in the UserCP.

Please tell me if you have set that to yes, or not, so that I can see what your problem is.

Rgds
It's set to yes. That was one of the first things I checked and double checked. The only thing I can make of it is that for some reason the test in the template is failing, so it doesn't show the options. Which php file besides member.php has code relating to this and about where is it (beginning, middle, end)? I've been checking things as I think of them, but I don't know the exact structure of the hack, so I really don't know where to look besides the basics. :(
SamirDarji
12-17-2004, 01:11 AM
One more question, if the user you are checking his CP has warning points, do you see his points?
I can see my user's warning points. I wonder one thing, if the user is banned, will the options to warn still be there? I loaded up this test user with points (hehe) and got him banned. I would think you should be still able to see the options.
nubian
12-17-2004, 03:06 AM
One more question, if the user you are checking his CP has warning points, do you see his points?

i have warned one of my test users and i can see the points i've warned him with ...but again not able to see this option to warn him off post related.
sv1cec
12-17-2004, 03:18 AM
Nubian,

You are right, when I was writing the patch instructions, I saw that and I thought I have made a mistake there, because the code is entering the same info in the same column twice. So I removed the last insert. I'll update the instructions, thanks.
sv1cec
12-17-2004, 03:27 AM
i have warned one of my test users and i can see the points i've warned him with ...but again not able to see this option to warn him off post related.
OK gentlemen, for all those who can't see the Warn XYZ and View XYZ's Warnings in the UserCP.

1. Make sure that your member.php file has the following lines in the beginning:


require_once('./global.php');
require_once('./includes/functions_showthread.php');
require_once('./includes/functions_user.php');
require_once('./includes/functions_warning.php');


What you need to have is the last one, with the functions_warning.php.

2. Make sure you have uploaded the latest realease of the functions_warning.php file in your includes directory. Check that the file has the following lines at the beginning:


$warnopts = array();
global $warn_opts;

$warn_opts=$DB_site->query_first("select * from ".TABLE_PREFIX."warning_options where oid='1'");


3. Make sure your MEMBERINFO template has the following code:


<!-- checks for warning system -->
<td class="thead" align="right">
<div class="smallfont" style="float:$stylevar[right]">
<if condition="THIS_SCRIPT=='member' AND $warn_opts[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 -->


In order for them to appear, you have to have the Allow off-post warnings equal to Yes, and have a Yes or No value in the hierarchical.

Make sure you try it as an admin, and let me know what your results are.

Rgds
sv1cec
12-17-2004, 03:29 AM
I can see my user's warning points. I wonder one thing, if the user is banned, will the options to warn still be there? I loaded up this test user with points (hehe) and got him banned. I would think you should be still able to see the options.
The Warn XYZ and View XYZ's links will still be there, because later, after you ban him, you may find that he has somewhere left another post, which should be warned again. And of course, because, you should be able to see his warrnings.

Rgds
SamirDarji
12-17-2004, 06:40 AM
OK gentlemen, for all those who can't see the Warn XYZ and View XYZ's Warnings in the UserCP.

1. Make sure that your member.php file has the following lines in the beginning:


require_once('./global.php');
require_once('./includes/functions_showthread.php');
require_once('./includes/functions_user.php');
require_once('./includes/functions_warning.php');


What you need to have is the last one, with the functions_warning.php.

2. Make sure you have uploaded the latest realease of the functions_warning.php file in your includes directory. Check that the file has the following lines at the beginning:


$warnopts = array();
global $warn_opts;

$warn_opts=$DB_site->query_first("select * from ".TABLE_PREFIX."warning_options where oid='1'");


3. Make sure your MEMBERINFO template has the following code:


<!-- checks for warning system -->
<td class="thead" align="right">
<div class="smallfont" style="float:$stylevar[right]">
<if condition="THIS_SCRIPT=='member' AND $warn_opts[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 -->


In order for them to appear, you have to have the Allow off-post warnings equal to Yes, and have a Yes or No value in the hierarchical.

Make sure you try it as an admin, and let me know what your results are.

Rgds
I got it! After checking everything, I decided to completely cut and paste the template code you posted and replace what came from the install file--that did it.

The only problem I ran across so far is when issueing a warning, it will go to a blank page after issueing it. It will actually issue the warning, but it doesn't return to any page.
sv1cec
12-17-2004, 06:55 AM
I got it! After checking everything, I decided to completely cut and paste the template code you posted and replace what came from the install file--that did it.

The only problem I ran across so far is when issueing a warning, it will go to a blank page after issueing it. It will actually issue the warning, but it doesn't return to any page.
Check that you have the warn_redirect template in your system. That's what should come up after you issue the warning.

I also changed the installation instructions for the MEMBERINFO template, so that it is easier to patch the original template. One replace operation and you are done.

Rgds
SamirDarji
12-17-2004, 03:11 PM
Check that you have the warn_redirect template in your system. That's what should come up after you issue the warning.
The template is present, and works when issueing post-related warnings. How does the template get called after the non-post related warning? That's the area I think I need to look into for a problem.
bigdaddybryce
12-17-2004, 06:58 PM
In the same template, find:

$post[reputationdisplay]</if>

This entry is not present in my postbit or postbit_legacy template...

Any ideas...I am using the Grassy Knoll template
nubian
12-17-2004, 08:40 PM
OK gentlemen, for all those who can't see the Warn XYZ and View XYZ's Warnings in the UserCP.

1. Make sure that your member.php file has the following lines in the beginning:


require_once('./global.php');
require_once('./includes/functions_showthread.php');
require_once('./includes/functions_user.php');
require_once('./includes/functions_warning.php');


What you need to have is the last one, with the functions_warning.php.

2. Make sure you have uploaded the latest realease of the functions_warning.php file in your includes directory. Check that the file has the following lines at the beginning:


$warnopts = array();
global $warn_opts;

$warn_opts=$DB_site->query_first(&quot;select * from &quot;.TABLE_PREFIX.&quot;warning_options where oid='1'&quot;);


3. Make sure your MEMBERINFO template has the following code:


<!-- checks for warning system -->
<td class=&quot;thead&quot; align=&quot;right&quot;>
<div class=&quot;smallfont&quot; style=&quot;float:$stylevar[right]&quot;>
<if condition=&quot;THIS_SCRIPT=='member' AND $warn_opts[allowoffpost]=='Yes'&quot;>
<if condition=&quot;$hierarchical=='No'&quot;>
<if condition=&quot;($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
<if condition=&quot;$hierarchical=='Yes'&quot;>
<if condition=&quot;($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)&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
</if>
<!-- end of warning system -->


In order for them to appear, you have to have the Allow off-post warnings equal to Yes, and have a Yes or No value in the hierarchical.

Make sure you try it as an admin, and let me know what your results are.

Rgds 1. check
2. check
3. well...i don't have that. so what i did was reverted my memberinfo template and coded the way it wanted me to do it in the WarningSystemInstallationInstructions.txt directions from 2.3.5 not the updatetothelatestversion.txt

maybe i'm lost but the code that you told me to find in memberinfo in the past threads:

<!-- checks for warning system -->
<td class=&quot;thead&quot; align=&quot;right&quot;>
<div class=&quot;smallfont&quot; style=&quot;float:$stylevar[right]&quot;>
<if condition=&quot;THIS_SCRIPT=='member' AND $warn_opts[allowoffpost]=='Yes'&quot;>
<if condition=&quot;$hierarchical=='No'&quot;>
<if condition=&quot;($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
<if condition=&quot;$hierarchical=='Yes'&quot;>
<if condition=&quot;($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)&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
</if>
<!-- end of warning system -->

cannot even be found in your latest 2.3.5 install.txt file which has this:

<!-- main info - avatar, profilepic etc. -->
<table class=&quot;tborder&quot; cellpadding=&quot;$stylevar[cellpadding]&quot; cellspacing=&quot;$stylevar[cellspacing]&quot; border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot;>
<tr>
<td class=&quot;thead&quot;>
<table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot;>
<tr>
<td class=&quot;thead&quot;>$vbphrase[view_profile]: $userinfo[username]
<!-- checks for warning system -->
<td class=&quot;thead&quot; align=&quot;right&quot;>
<div class=&quot;smallfont&quot; style=&quot;float:$stylevar[right]&quot;>
<if condition=&quot;THIS_SCRIPT=='member' AND $warn_options[allowoffpost]=='Yes'&quot;>
<if condition=&quot;$hierarchical=='No'&quot;>
<if condition=&quot;($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7&quot;>
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related) ? View $userinfo[username]'s Warnings (http://Warn.php?do=ViewWarnings&id=$userinfo%5Buserid%5D)
</if>
<if condition=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings
</if>
</if>
<if condition=&quot;$hierarchical=='Yes'&quot;>
<if condition=&quot;($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)&quot;>
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related) ? View $userinfo[username]'s Warnings (http://Warn.php?do=ViewWarnings&id=$userinfo%5Buserid%5D)
</if>
<if condition=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings
</if>
</if>
</if>
<!-- end of warning system -->
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=&quot;alt2&quot;>
<table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td style=&quot;border-bottom:1px solid $stylevar[tborder_bgcolor]&quot; colspan=&quot;3&quot;>
<if condition=&quot;$userinfo['rank'] OR $userinfo['reputationdisplay']&quot;>
<div style=&quot;float:$stylevar[right]; padding:4px&quot;>
<if condition=&quot;$userinfo['rank']&quot;>$userinfo[rank]

<if condition=&quot;$userinfo['reputationdisplay']&quot;>$userinfo[reputationdisplay]

</div>
</if>
<div style=&quot;font-size:18pt&quot;>$userinfo[musername]
<if condition=&quot;$userinfo['usertitle']&quot;>$userinfo[usertitle]

</td>
<td style=&quot;border-bottom:1px solid $stylevar[tborder_bgcolor]&quot; align=&quot;$stylevar[right]&quot;>
<div class=&quot;smallfont&quot;>
<b>User ID : $userid
<if condition=&quot;$viewoption=='All'&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</div>
<if condition=&quot;$viewoption=='Mgm' AND $hierarchical=='Yes'&quot;>
<if condition=&quot;($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)
&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</if>

<if condition=&quot;$viewoption=='Mgm' AND $hierarchical=='No' AND
(
$bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR
$bbuserinfo[usergroupid]==6
)&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</td>
<if condition=&quot;$show['profilepic']&quot;>
<td valign=&quot;middle&quot; align=&quot;$stylevar[right]&quot; rowspan=&quot;2&quot; width=&quot;160&quot;>
<center>https://vborg.vbsupport.ru/$vbphrase[xs_picture]&quot; border=&quot;0&quot; style=&quot;border:1px solid $stylevar[tborder_bgcolor]&quot; />
</td>
</if>
</tr>



mind you i reverted my memberinfo template and did exactly what was said to do in the latest 2.3.5
i went into my test users public profile and i still don't see the options to warn them. https://vborg.vbsupport.ru/
i'm completely lost.
nubian
12-17-2004, 08:44 PM
In the same template, find:

$post[reputationdisplay]</if>

This entry is not present in my postbit or postbit_legacy template...

Any ideas...I am using the Grassy Knoll template it's there...just find it like this:

$post[reputationdisplay]
SamirDarji
12-17-2004, 09:15 PM
1. check
2. check
3. well...i don't have that. so what i did was reverted my memberinfo template and coded the way it wanted me to do it in the WarningSystemInstallationInstructions.txt directions from 2.3.5 not the updatetothelatestversion.txt

maybe i'm lost but the code that you told me to find in memberinfo in the past threads:

<!-- checks for warning system -->
<td class=&quot;thead&quot; align=&quot;right&quot;>
<div class=&quot;smallfont&quot; style=&quot;float:$stylevar[right]&quot;>
<if condition=&quot;THIS_SCRIPT=='member' AND $warn_opts[allowoffpost]=='Yes'&quot;>
<if condition=&quot;$hierarchical=='No'&quot;>
<if condition=&quot;($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
<if condition=&quot;$hierarchical=='Yes'&quot;>
<if condition=&quot;($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)&quot;>
<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=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings</a>
</if>
</if>
</if>
<!-- end of warning system -->

cannot even be found in your latest 2.3.5 install.txt file which has this:

<!-- main info - avatar, profilepic etc. -->
<table class=&quot;tborder&quot; cellpadding=&quot;$stylevar[cellpadding]&quot; cellspacing=&quot;$stylevar[cellspacing]&quot; border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot;>
<tr>
<td class=&quot;thead&quot;>
<table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot;>
<tr>
<td class=&quot;thead&quot;>$vbphrase[view_profile]: $userinfo[username]
<!-- checks for warning system -->
<td class=&quot;thead&quot; align=&quot;right&quot;>
<div class=&quot;smallfont&quot; style=&quot;float:$stylevar[right]&quot;>
<if condition=&quot;THIS_SCRIPT=='member' AND $warn_options[allowoffpost]=='Yes'&quot;>
<if condition=&quot;$hierarchical=='No'&quot;>
<if condition=&quot;($bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==5) AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=5 AND $userinfo[usergroupid]!=7&quot;>
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related) ? View $userinfo[username]'s Warnings (http://Warn.php?do=ViewWarnings&id=$userinfo%5Buserid%5D)
</if>
<if condition=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[usergroupid]!=7 AND $userinfo[usergroupid]!=5 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings
</if>
</if>
<if condition=&quot;$hierarchical=='Yes'&quot;>
<if condition=&quot;($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)&quot;>
<a href='Warn.php?do=WarnUserNoPost&id=$userid'>Warn $userinfo[username] (non-post related) ? View $userinfo[username]'s Warnings (http://Warn.php?do=ViewWarnings&id=$userinfo%5Buserid%5D)
</if>
<if condition=&quot;$userinfo[userid]==$bbuserinfo[userid] AND $userinfo[usergroupid]!=6 AND $userinfo[warning_level]>0&quot;>
<a href='Warn.php?do=ViewMyWarnings'>View your Warnings
</if>
</if>
</if>
<!-- end of warning system -->
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=&quot;alt2&quot;>
<table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td style=&quot;border-bottom:1px solid $stylevar[tborder_bgcolor]&quot; colspan=&quot;3&quot;>
<if condition=&quot;$userinfo['rank'] OR $userinfo['reputationdisplay']&quot;>
<div style=&quot;float:$stylevar[right]; padding:4px&quot;>
<if condition=&quot;$userinfo['rank']&quot;>$userinfo[rank]

<if condition=&quot;$userinfo['reputationdisplay']&quot;>$userinfo[reputationdisplay]

</div>
</if>
<div style=&quot;font-size:18pt&quot;>$userinfo[musername]
<if condition=&quot;$userinfo['usertitle']&quot;>$userinfo[usertitle]

</td>
<td style=&quot;border-bottom:1px solid $stylevar[tborder_bgcolor]&quot; align=&quot;$stylevar[right]&quot;>
<div class=&quot;smallfont&quot;>
<b>User ID : $userid
<if condition=&quot;$viewoption=='All'&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</div>
<if condition=&quot;$viewoption=='Mgm' AND $hierarchical=='Yes'&quot;>
<if condition=&quot;($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)
&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</if>

<if condition=&quot;$viewoption=='Mgm' AND $hierarchical=='No' AND
(
$bbuserinfo[usergroupid]==7 OR $bbuserinfo[usergroupid]==5 OR
$bbuserinfo[usergroupid]==6
)&quot;>
<if condition=&quot;$userinfo[warning_level]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Warnings Level: $userinfo[warning_level]
<font color=&quot;#000000&quot;>
</if>
<if condition=&quot;$userinfo[warning_bans]>0&quot;>
<font color=&quot;#ff0000&quot;>
<BR>Number of bans: $userinfo[warning_bans]
<font color=&quot;#000000&quot;>
</if>
</if>
</td>
<if condition=&quot;$show['profilepic']&quot;>
<td valign=&quot;middle&quot; align=&quot;$stylevar[right]&quot; rowspan=&quot;2&quot; width=&quot;160&quot;>
<center>%22image.php?u=$userinfo%5Buserid%5D&type=profile&dateline=$userinfo%5Bprofilepicdateline%5D%22$vbph rase[xs_picture]&quot; border=&quot;0&quot; style=&quot;border:1px solid $stylevar[tborder_bgcolor]&quot; />
</td>
</if>
</tr>



mind you i reverted my memberinfo template and did exactly what was said to do in the latest 2.3.5
i went into my test users public profile and i still don't see the options to warn them. images/newsm/depressed.gif
i'm completely lost.
He only gave a piece of the member template. If you look at the member template from the 2.3.5 instructions, there is a comment called that matches the first line of the code he posted from his own member template. That's what I used and got the options to show. I'll do a comparison later to find the differences between the two.
SamirDarji
12-17-2004, 09:27 PM
Ok, I found the difference. Make sure in your memberinfo template, there is $warn_options instead of $warn_opts. Apparently that's what was wrong in my case and could be in your case as well.
bigdaddybryce
12-17-2004, 09:30 PM
it's there...just find it like this:

$post[reputationdisplay]

searched again...notta
nubian
12-17-2004, 10:00 PM
searched again...notta that field has to be there unless you've edited it before
if it were the stock temlate you should be able to find it....at least on vb 3.0.3
nubian
12-17-2004, 10:01 PM
Ok, I found the difference. Make sure in your memberinfo template, there is $warn_options instead of $warn_opts. Apparently that's what was wrong in my case and could be in your case as well.
i have options instead of opts
bigdaddybryce
12-18-2004, 03:30 AM
Any ideas...I am using the Grassy Knoll template

I am not using the stock template but another one that I found of VB Templates
sv1cec
12-18-2004, 02:47 PM
Nubian and Samir,

If you have some where warn_options, instead of warn_opts, that means that somewhere along your upgrades you haven't followed the instructions properly. The change to warn_opts was done back in version 2.2, when I moved the query for the options in the global.php file. It now resides in functions_warning.php, but the warn_opts parameter has not been changed, since then. If you check the upgrade instructions there, you will see that it says to replace all warn_options with warn_opts.

Check your member.php file There should be the following line somewhere:

require_once('./includes/functions_warning.php');

From there on, make sure that warn_options is replaced in the file, with warn_opts. That's the proper parameter and that is what should be checked wherever it is checked.
sv1cec
12-18-2004, 02:49 PM
I am not using the stock template but another one that I found of VB Templates
For whoever is using a different template set than the standard, it is obvious that the installation or the upgrade instructions would not match. You need to compare the standard template with the one you are using and find out the most appropriate place to insert the different code pieces from my hack.

Rgds
sv1cec
12-18-2004, 02:51 PM
One more thing, gentlemen, for some reasons I am not receiving e-mail notifications from this forums, whenever you post something. This is the reason I am late at responding some times. The funny thing is that I do receive notes about hacks I've participated in their threads months ago, but not from this one, at least not regularly.

Apologies, and I would appreciate if an admin can look at this problem, I am reporting this post right now, to see what can be done.
sv1cec
12-18-2004, 03:06 PM
The template is present, and works when issueing post-related warnings. How does the template get called after the non-post related warning? That's the area I think I need to look into for a problem.
The redirect template is called from the Warn.php file. Go in the file and find the following code:


$url="member.php?u={$_POST['id']}";
eval('$warn_page .= "' . fetch_template('warn_redirect') . '";');

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
// Warn [User] ~ do
// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
}
//************************************************** *************************************


if($_GET['do']=="ViewMyWarnings"){
// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
// Warn [View Your Own]
// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
// Navigation
$navbits= array("Warn.php?$session[sessionurl]&do=ViewMyWarnings" => "Your Warnings");
$navbits[""]= "Viewing Your Warnings";


Right there, at the top, it is where the redirect is called. Make sure this exist in your file.
SamirDarji
12-18-2004, 04:20 PM
I originally started with 2.3.1. The only changes I've made since then is the member template cut and paste. For the live board, I'll be starting fresh with the latest version.

The piece of code is there. I'm thinking that during a db query something isn't returning right. I've seen this happen with other hacks as well installed on the test server. I just wanted to make sure that was the case, but it doesn't seem like I'll be able to pinpoint it. I'll be installing the warning system on the live board next week.
sv1cec
12-18-2004, 06:24 PM
I originally started with 2.3.1. The only changes I've made since then is the member template cut and paste. For the live board, I'll be starting fresh with the latest version.

The piece of code is there. I'm thinking that during a db query something isn't returning right. I've seen this happen with other hacks as well installed on the test server. I just wanted to make sure that was the case, but it doesn't seem like I'll be able to pinpoint it. I'll be installing the warning system on the live board next week.

If you haven't done every upgrade, exactly as described, it is normal to run into troubles, and this is what's happening to your test environment, because of the queries that some of them are working with warn_opts, others with warn_options etc. Start from scratch in your live site.

Just download the latest zip, the day you start the installation, and work with it.

Don't cut any corners, do everything as it is in the instructions. To the best of my knowledge, they are correct 100%.

Rds
wez
12-18-2004, 07:23 PM
1 word........... fantastic!!

closed the forum... applied the installation step by step, took a while - double checked EVERYTHING - opened forum...... and booya! works a treat! fantastic stuff...

Thanks :D !
sv1cec
12-18-2004, 08:21 PM
1 word........... fantastic!!

closed the forum... applied the installation step by step, took a while - double checked EVERYTHING - opened forum...... and booya! works a treat! fantastic stuff...

Thanks :D !
Most welcome Sir!
SamirDarji
12-18-2004, 10:35 PM
If you haven't done every upgrade, exactly as described, it is normal to run into troubles, and this is what's happening to your test environment, because of the queries that some of them are working with warn_opts, others with warn_options etc.
That makes sense. In your opinion, do you think everything otherwise is working fine and this is the only issue left?

Start from scratch in your live site. Just download the latest zip, the day you start the installation, and work with it.

Don't cut any corners, do everything as it is in the instructions. To the best of my knowledge, they are correct 100%.
Will do. My methodolgy for the live site is rigorous compared to the test server. Every template change is documented, every php file revision is documented, and even changes in any options are documented. It's really time consuming, but it works. If I have a problem, I'm able to easily back up and see at what step it started at.
nubian
12-19-2004, 01:59 AM
Nubian and Samir,

If you have some where warn_options, instead of warn_opts, that means that somewhere along your upgrades you haven't followed the instructions properly. The change to warn_opts was done back in version 2.2, when I moved the query for the options in the global.php file. It now resides in functions_warning.php, but the warn_opts parameter has not been changed, since then. If you check the upgrade instructions there, you will see that it says to replace all warn_options with warn_opts.

Check your member.php file There should be the following line somewhere:

require_once('./includes/functions_warning.php');

From there on, make sure that warn_options is replaced in the file, with warn_opts. That's the proper parameter and that is what should be checked wherever it is checked. i finally got it to work.

there is nothing stating that i had to change all of my warn_options to warn_opts.

now the thing is that i initially started with 2.3.2 and upgraded to the latest insequential order
3.2 to 3.3 to 3.4 to 3.5
the only place from the 2.3.5 "UpgradeToLatestVersion.txt"t is where it starts from versions 2.1 to 2.2
but more enough...it's working now.
thank you for the great support
DS MrSinister
12-19-2004, 06:01 AM
When I run this i get a error..

how would i get this to work right?

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN `version` char(10) AFTER oid
sv1cec
12-19-2004, 06:29 AM
When I run this i get a error..

how would i get this to work right?

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN `version` char(10) AFTER oid
If you are not using a special TABLE_PREFIX in your database, delete the part saying ".TABLE_PREFIX." . I have to assume that this is the error you are getting, because you didn't say what it was.

Rgds
hello
12-19-2004, 06:55 AM
just try this ALTER TABLE `warning_options` ADD COLUMN `version` char(10) AFTER oid
Delphiprogrammi
12-19-2004, 10:33 AM
hi,

open up config.php and look for


/ Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = '';


if this setting is empty do not worry about it if it isn't then replace the "TABLE_PREFIX" with the setting you have in $tableprefix


note DO NOT EDIT THIS SETTING unless vbulletin tells you todo it your vbulletin installing will stop to work !
DS MrSinister
12-19-2004, 03:58 PM
THanks but i have another problem here....


this what i get when i click on View Warned Users in the admin Panel.


Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS users FROM user AS user where warnings>0
mysql error: Unknown column 'warnings' in 'where clause'

mysql error number: 1054


Maybe i miss adding a table or something!.. any ideas...
mcyates
12-20-2004, 10:13 AM
Is it possible to remove the logging of bans after say 6 months? I'm just thinking if a member gets banned and the first ban is 7 day the 2nd ban is permanent. Say he got a ban within 1 months of joining, then he becomes a quality member and 2 years later gets banned again (due to multiple warnings) he'll be banned permanently and i think theis might be a little harsh. Could you add an option like:

Delete ban history if older than 6 months? YES / NO

Tell me what you think?
ArAb4NoKiA
12-20-2004, 12:41 PM
ThAnXxXxX
SamirDarji
12-20-2004, 04:42 PM
Is it possible to remove the logging of bans after say 6 months? I'm just thinking if a member gets banned and the first ban is 7 day the 2nd ban is permanent. Say he got a ban within 1 months of joining, then he becomes a quality member and 2 years later gets banned again (due to multiple warnings) he'll be banned permanently and i think theis might be a little harsh. Could you add an option like:

Delete ban history if older than 6 months? YES / NO

Tell me what you think?
Not a bad idea. I like. :D
sv1cec
12-20-2004, 05:21 PM
Gentlemen,

please forgive my absence, but yesterday, rain got through an open window, into my PC's monitor.

At this time, my Internet access is done through an old Sun server, with a very old
version of Netscape browser. Unfortunatelly, this version crashes, every
time I go into a message composition screen. I just downloaded and installed a beta
version of Mozilla, hoping,that I'll be able to send this message to you.

As you understand, I am unable to provide support, until my normal access is restored
hopefully tomorrow. Until then:

1. DR MrSinister's problem originates from the fact that he has not added the three new
columns, in his user table, during one of the upgrades (I do not have access to the
Versions file, so I do not remember in which version they were added). Check the
UpgradeToLatestVersion.txt file and fine the query that adds these in the table.
2. Deleting the bans is more troublesome that it initially appears, because I do
not store the ban date anywhere, at this time. If this feature is to be included,
I'll have to have at least the date of the last ban, stored in the user table, so that
a cron job can then remove it. Also, a parameter has to be added in the warning_options
table, to specify after how many days the bans will be erased.

I assume you will have to wait for after the Holidays for this.

Sorry for not being here yesterday or today, but I was trying to have my monitor fixed.
I didn't, so I have to get a new one, and this is not the best of times for such
expenditure.

Rgds

just to see if that would allow me to
rh2004
12-21-2004, 12:58 AM
I don't know what version I have lol you are creating them so fast..

Anyway I got a suggestion, when I warned someone and then disactived it (removed)
just removed not completely, how can I re-active it... without having to send out a
nother warning to the user... I think that would be a good add-on :)
sv1cec
12-21-2004, 12:30 PM
I don't know what version I have lol you are creating them so fast..

Anyway I got a suggestion, when I warned someone and then disactived it (removed)
just removed not completely, how can I re-active it... without having to send out a
nother warning to the user... I think that would be a good add-on :)

Oh come on, it's hardly worth the coding effort. Just go into your warnings table, find that particular warning and change the status from "I" to "A", it 's a simple SQL query.

Anyway, I am back on-line (and 325 Euros poorer), so I have to catch up with all the things that got left behind these two days.

Rgds
Viol8or
12-21-2004, 03:09 PM
This is a wonderfull hack! Took me some time to install from scratch (mostly because of the different styles that I've done manually, but it works nice).
This really helps out my moderators on my board!!!! VERY VERY nice work. Keep it up!
DS MrSinister
12-21-2004, 06:24 PM
Gentlemen,

please forgive my absence, but yesterday, rain got through an open window, into my PC's monitor.

At this time, my Internet access is done through an old Sun server, with a very old
version of Netscape browser. Unfortunatelly, this version crashes, every
time I go into a message composition screen. I just downloaded and installed a beta
version of Mozilla, hoping,that I'll be able to send this message to you.

As you understand, I am unable to provide support, until my normal access is restored
hopefully tomorrow. Until then:

1. DR MrSinister's problem originates from the fact that he has not added the three new
columns, in his user table, during one of the upgrades (I do not have access to the
Versions file, so I do not remember in which version they were added). Check the
UpgradeToLatestVersion.txt file and fine the query that adds these in the table.
2. Deleting the bans is more troublesome that it initially appears, because I do
not store the ban date anywhere, at this time. If this feature is to be included,
I'll have to have at least the date of the last ban, stored in the user table, so that
a cron job can then remove it. Also, a parameter has to be added in the warning_options
table, to specify after how many days the bans will be erased.

I assume you will have to wait for after the Holidays for this.

Sorry for not being here yesterday or today, but I was trying to have my monitor fixed.
I didn't, so I have to get a new one, and this is not the best of times for such
expenditure.

Rgds

just to see if that would allow me to


sorry to hear about U stuff there.. That sucks..

Thanks for the help... Got it working now.. :)
bigcurt
12-23-2004, 02:31 AM
For some reason it is like I can see the warning points in the postbit for a minute or so then it DISAPEARS..does ANYONE have any idea about this??
bigcurt
12-23-2004, 02:34 AM
Also, I have a person helping me install this and he cannot see The "View [USER] Warnings" but I can? What is this..It is going crazy lol. I think it has a mind of its own.

Would apreciate ANY help.
Thanks
Big Curt
Delphiprogrammi
12-23-2004, 01:11 PM
did you enabled the cron job ? if so admincp =>scheduled tasks => cron log and see what's in there

also only users who have rights to warn others can do that (administrator super moderator) if you view your memberlist click the username (other then yours cause an admin can't be warned) then you should see a link called "warnings" in the uper right corner

also if that person who is helping you to install AWS is using a different style then yours it is pretty normal he won't see it cause those templates aren't edited for it
sv1cec
12-23-2004, 02:43 PM
For some reason it is like I can see the warning points in the postbit for a minute or so then it DISAPEARS..does ANYONE have any idea about this??
Are you using a different style or something? I can't understand why it appears for a moment and vanishes afterwards. As for who can see the "View USERXYZ warnings" link, there are some issues to consider.

For example, a moderator can see that link in all forums, but he can see the "Warn USERXYZ" link only in the forums he moderates.

And a Supermoderator can see the corresponding links for the users AND the moderators. What is the usergroup you are in, and what the one of the person who is helping you?

Rgds
Viol8or
12-23-2004, 05:46 PM
Hey sv1cec ... I have a request/suggestions for future version.
I would be very nice if we could get some warning stats out of your system.
This doens't have to be very extensive, just basic: how many warnings are written out by a mod(s), how many warnings were issued of a certain warning type, what are the top warned users (in addition to the warned user section that is), etc...
I don't know how hard this is to include, but would really appreciate it if you would consider it!
Keep up the good work!!!!
sv1cec
12-23-2004, 08:23 PM
Hey sv1cec ... I have a request/suggestions for future version.
I would be very nice if we could get some warning stats out of your system.
This doens't have to be very extensive, just basic: how many warnings are written out by a mod(s), how many warnings were issued of a certain warning type, what are the top warned users (in addition to the warned user section that is), etc...
I don't know how hard this is to include, but would really appreciate it if you would consider it!
Keep up the good work!!!!
Stay tuned, version 3.0 is being cooked at the moment, lots of interesting new things, stats included.

Rgds and Merry Christmas to all those who celebrate Christmas.
bold
12-24-2004, 01:46 AM
Stay tuned, version 3.0 is being cooked at the moment, lots of interesting new things, stats included.

Rgds and Merry Christmas to all those who celebrate Christmas.

Cool can't wait!

Merry Christmas to you too my brother. :)
Viol8or
12-24-2004, 06:23 AM
Best wishes to all of you.
Can't wait to see version 3 showing up :)
BlackxRam
12-26-2004, 03:03 AM
I really think this hack would be more complete with a defined offense like (Uber Spammer) that will automatically set a user and all IPS gathered under their name and set to the IP BAN list. I have not ONCE seen a hack that would allow this... and I think it would be a PERFECT addition to your hack.

So what do you say? You think it can be done?
sv1cec
12-26-2004, 07:07 AM
I really think this hack would be more complete with a defined offense like (Uber Spammer) that will automatically set a user and all IPS gathered under their name and set to the IP BAN list. I have not ONCE seen a hack that would allow this... and I think it would be a PERFECT addition to your hack.

So what do you say? You think it can be done?
Well, it already has .... half of what you want.

In other words, it does allow you to define a warning type, which is characterized as "Permanent Ban". In other words, when this type of offence is commited and warned, the member is send directly to the banned members with a "permanent" ban duration.

As for the IP addresses, don't you think it's kind of dangerous? I mean an IP is not (unfortunatelly) always associated with one particular user. So, if you ban the IPs that that member has used in the past, it is quite possible, that you might be banning other legit members, who will try to visit the site in the future. Remote, indeed, but possible. Also, I spend some time this morning trying to find out if vB allows you to ban an IP address, I think I remember seeing something like that, but couldn't find it. Cosnidering that I went to bed at 5 am this morning, I am not very sure if my eyes could see what I was looking at. I'll check again later today.

For the time being, I am stuck with an issue which I can't understand. I have added the feature of sorting the Logs list, by the various columns presented there, in ascending or descending order (I thought that would be a useful feature). But for the life of me, I can't pass a certain sorting string to a parameter used in the select query. All other strings are passed find, but a string that asks the query to do an addition of two columns and sort on the result, doesn't work. If someone can help, please jump in or PM, or email me.

Rgds
BlackxRam
12-26-2004, 07:12 AM
Well Vbulletin does have the ability to ban IP addresses, however moderators and super moderators don't have the ability to access that part of the forum to do so. Whch is why when the situation arises to be able to do it automatically instead of manually adding in the ipaddresses i figured why not ask.

Are you considering adding a feature like Erwins hack that makes all posts by certain banned members invisible? Like perhaps putting them into the Mass Ignore feature in Vbulletin? That would be great as well.
deb0
12-26-2004, 12:02 PM
I didn't get any errors installing this mod. But IN the legacy postbit, when I click Warn UserX or View UserX's Warning, I get a blank page with this url:

warnuserX-
http://www.afrochat.net/forums/Warn.php?do=WarnUser&id=108&post=9590

View UserX's warnings-
http://www.afrochat.net/forums/Warn.php?do=ViewWarnings&id=108

So many changes were made, I don' thave a clue where to start digging.

My board seriously needs this mod.

Plz help.
deb0
12-26-2004, 01:57 PM
Nevermind, I fixed. Apparently rerunning the installer after all the changes and file uploads fixed it.

I haven't found any errors so far. Testing. This was an extensive hack, so I just wanna say "excellent job" so far.
deb0
12-26-2004, 06:08 PM
Is there a way to remove a given warning from a member? This is important.
sv1cec
12-26-2004, 06:32 PM
Is there a way to remove a given warning from a member? This is important.
Two ways, one is to use the Remove link in the View XYZ's Warnings, and the other is to use the Complete Removal from the View Warning Logs in AdminCP.

The second method removes not only the related warning and its points, but also any bans associated with it (it does not unban the member if he is banned, you will have to do that manually, but reduces his bans number by one).

Rgds
sv1cec
12-27-2004, 05:05 PM
Two ways, one is to use the Remove link in the View XYZ's Warnings, and the other is to use the Complete Removal from the View Warning Logs in AdminCP.

The second method removes not only the related warning and its points, but also any bans associated with it (it does not unban the member if he is banned, you will have to do that manually, but reduces his bans number by one).

Rgds
Just to wet your appetite, here is a list of the things you can expect in Version 3.0:

In a few words, I've managed to move a big chunk of code, from the various files which issue warnings (Warn.php, editpost.php, newreply.php, newthread.php, private.php), to the functions_warning.php file. This makes the hack much easier to install, in the first place. It also makes the automatic warning feature, much easier to implement, in other parts of vBulletin, thus allowing me to easily expand its functionality in the future. Finally additional features can be added more easily.

I also altered the way the banning worked. In other words, until version 2.3.5, when a member was banned, his total warning points remained into his account. If he received one more point, he was banned again, a second time. This (I think) was wrong, because:

a. Obviously, since the member is already banned, he can't commit more offences, which would lead to another warning. Obviously if a moderator ends up warning a post, posted by a banned user, this offence was commited before he was banned, but the warning for it, is coming after he was banned.

b. Let's take this example:

A member commits the following offences:

offence A : 5 points
offence B : 6 points
offence C : 3 points

The warning limit is 10 points. As the admin issues the first two warnings, the ban limit is reached and the member is banned. The member's total points are 11 at this moment. But the admin still has to add another warning, worth 3 points. The moment he does that, with the old system, the total points the member has, would go to 14, but he would also receive another ban (remember, that he was banned the moment the admin issued the second warning).

To avoid this problem, a member who is banned, can of course still be warned and his points increase accordingly, but he does not receive another ban, while his first is still in effect . In the example above, the last warning is issued and the user points reach 14, but his ban count remains at one. When he is unbanned, and if we suppose that none of his warnings have expired, he still has 14 points and if he receives one more then he will then receive his second ban.

Other functionality added:

It's just natural to add the option of e-mailing those users who get banned, to let them know that they got banned. A PM in this case, is useless, as they cannot log in the forums to read it, so an e-mail has to be used. Some admins however might not want to alert bad members with such an e-mail, so I added an option, with which you can define if you want e-mails send to the members who get banned or not. That required a new template to be added.

Some one suggested that a member might get a ban, but then learn his lesson and behave. Why should that ban be in his account for ever? Wouldn't it be logical to remove it, after a certain period passes? I think it would, or at least it sounds reasonable, so what I did, was to add an option, where you can define the duration that a ban will stay in a user's account. After that period, the ban will automatically be removed from the user's account. In other words, if that period is 6 months (which is entered as days in the program, i.e. 180 days), and he was banned on January 3rd, this ban will be shown in his account until July 3rd. If you check the User Manager page, in your AdminCP, before July 3rd, you will see that ban. If you check it after the above date, the user will appear as if he had never been banned. This required a new table to be added to the system.

Although this feature sounds reasonable, there might be others who will not consider it useful, so again, an option was added to control it. Finally, since maybe some admins want to have old bans expire, but want to see if their users were banned at some time, the above mentionned table can be checked to see if a member has ever been banned.

To see the contents of this table, you should use the "View Bans Per User" selection in the AWS Menu, in your Admincp. The table structure is self- explanatory, each record you see there, represents a warning which caused a ban. The Ban Rank is the order of bans that this user has received, in other words, if this is 1, this was his first ban, if this is 2, this was his second ban etc. . The Ban Status column has the following meanings:

"IUA" (In User's Account) : The ban is still active, so it is included in the Bans number shown in your User Management page.
"NAUA" (Not Affecting User's Account) : The ban has matured (in other words the user has been good for the time you specified and the cron job removed this ban from the user Bans number, shown in the User Management page.
"Permanent" : This warning caused a permanent ban, so this cannot be removed or rendered inactive.

If you do not use the Bans Maturity feature, you should not see any Inactive bans here, the records should either be Active or Permanent.

If you want to be able to see the expired bans, even though your user account bans have been reduced after he was good for quite some time, all you have to do, is to turn on the historical records option. If the Historical Records is set to Yes, the ban records will remain in that new table, but will be marked as Inactive.

The other columns of this table, show the details of the warning that caused the ban (like type of warning etc).

So, by checking this menu option, you can immediately see the bans history of your members.

Some clarification is in order here:

In the View Warning Logs menu option, there are two alternatives, one is to Remove a warning, and the other is to do a Complete Removal of a warning. The difference between these two actions, is not very clear, so here is the clarification.

The Remove action, is sort of a manual maturing of a warning. It removes the warning points from the user's account, it marks the warning as inactive, but does not reduce the number of warnings a user has received in his career in the forum, and it does not remove any bans that the warning might have caused, from the user's account.

The Complete Removal, is like undoing the warning. The warning points will be removed from the user's account, his warnings will be reduced by one, any associated ban that the warning has caused will be removed from the user's account (his bans will be reduced by one). The only thing that the Complete Removal will not do, is to unban the user and the reason for this, is because the program cannot be sure if the user is still banned, and if he is, if the user was banned because of the warning you are removing or because of another warning. As a result, if the user is banned, you will have to unban him manually.

If this is still not clear, do use the hack's thread for your questions.

Another feature that was added, was the sorting of the Log File. When you select to see the Warning Logs now, you will see a set of buttons, at the top row of the list, saying "Asce" and "Desc". You may click on those buttons to sort the list, according to that column, in ascending or descending order. I think this will help the admins, in better evaluate their members actions.

Finally, another feature that I added, was the ability to select if a moderator can enter a comment, when he is warning a member, or if the Warning Type Description will be send instead of a comment. If you want to make your moderators life easier, then set this option to Yes. Keep in mind that this option affects only, post-related warnings. The Non-Post-Related ones still allow the warner to add a comment.

Oh yes, I also added some statistics, warnings per warning type and warnings per moderator (well, per warner shall we say?).

The code is pretty stable at the moment, but since it involved several major changes I'll have a test environment set up tomorrow, where I'll be able to test the installation scripts and the functionality before releasing it. I guess you will have it before New Year.

Rgds
Viol8or
12-27-2004, 05:31 PM
Very nice :) Happy to see the stats are in there.
Maybe one more suggestion, coming from my users. It would be nice if we could set a level of when the warning indicator changes colour. Now it is always displayed in red in the post bit. But why not black or blue up to a warning level of ex. 7 and from then on in red?
sv1cec
12-27-2004, 07:57 PM
Very nice :) Happy to see the stats are in there.
Maybe one more suggestion, coming from my users. It would be nice if we could set a level of when the warning indicator changes colour. Now it is always displayed in red in the post bit. But why not black or blue up to a warning level of ex. 7 and from then on in red?
No particular reason why this can't be done. The issue is that since I have no idea what limits the admins who use this hack use in this forum, I'll have to code it so that in the first 1/3 the color is black, the next 1/3 is blue (or whatever) and the next 1/3 it is red (or something). And of course, the fact that each admin would have his own color preferences, means that the colors should be selectable.

All this means a lot of coding, I'll keep it in mind for when I have some more spare time (but don't be surprised if it is included in V. 3.0, if the twins give me some time to work with it).
deb0
12-27-2004, 08:18 PM
Sv1,
when I select view XYZ's warnings, there is no remove link. Matter of fact, under the Remove column, it says the warning is "Non-removable Warning". I don't see an option where I can chose that.
Vixion
12-27-2004, 10:47 PM
Hello,

I just installed this add-on to my forums, and I am using 2 different kind of languages (Dutch and English). Now the people that have installed Dutch as there main-language will also see the English text.

I can't find the text of the AWS in the Language / Phrase editor. Which 'prefix' do I need to edit?
SamirDarji
12-28-2004, 06:25 AM
Well, I guess it was a good thing I didn't get around to installing this on the live forum, lol.
sv1cec
12-28-2004, 10:45 AM
Sv1,
when I select view XYZ's warnings, there is no remove link. Matter of fact, under the Remove column, it says the warning is "Non-removable Warning". I don't see an option where I can chose that.
No removable warning, means this was a warning which caused a permanent ban, or that this warning has matured and is now inactive. In that case, you cannot remove it from Warn.php. The only way to remove it is from AdminCP, View Warning Logs, Complete Removal.
sv1cec
12-28-2004, 10:49 AM
Hello,

I just installed this add-on to my forums, and I am using 2 different kind of languages (Dutch and English). Now the people that have installed Dutch as there main-language will also see the English text.

I can't find the text of the AWS in the Language / Phrase editor. Which 'prefix' do I need to edit?
The templates are all starting with 'warn_'. The phrases are listed in the install_warn.php file towards the bottom. They do not all start with the same word, but most of them start with 'warning_', check that file out and you will find them. But there is some text also in the files, so I am not sure if the hack can be fully translated without touching the code.

If you do translate it, send me the files and I'll add the "Dutch Version".

Rgds

Rgds
sv1cec
12-28-2004, 10:50 AM
Yeap, version 3.0 is out in a few moments, so it was a good thing you didn't bother installing it. You will be my first ... guinea pig (if you pardon the expression).

Rgds
j_86
12-28-2004, 11:51 AM
Good job :) Installing now.

=====

Problem with the instructions:

CREATE TABLE `ban_dates` (
`banned_serno` int(15) NOT NULL auto_increment,
`banned_user` int(15) NOT NULL default '0',
`banned_ban` int(2) default '0',
`banned_warning` int(15) NOT NULL,
`banned_by` int(15) NOT NULL default '0',
`banned_dateline` int(15) NOT NULL default '0',
`banned_status` char(1).
`banned_reason` mediumtext,
PRIMARY KEY (`banned_serno`)
) TYPE=MyISAM




`banned_status` char(1).

should be

`banned_status` char(1),
sv1cec
12-28-2004, 12:02 PM
Good job :) Installing now.

=====

Problem with the instructions:

CREATE TABLE `ban_dates` (
`banned_serno` int(15) NOT NULL auto_increment,
`banned_user` int(15) NOT NULL default '0',
`banned_ban` int(2) default '0',
`banned_warning` int(15) NOT NULL,
`banned_by` int(15) NOT NULL default '0',
`banned_dateline` int(15) NOT NULL default '0',
`banned_status` char(1).
`banned_reason` mediumtext,
PRIMARY KEY (`banned_serno`)
) TYPE=MyISAM




`banned_status` char(1).

should be

`banned_status` char(1),


Darn you are right, the two are so close together on this keyboard.

Let me correct that.

Rgds and tnx
j_86
12-28-2004, 12:06 PM
Upgrade time: 3minutes
Working: Perfectly so far :)

Very nice work!
sv1cec
12-28-2004, 12:49 PM
Very nice :) Happy to see the stats are in there.
Maybe one more suggestion, coming from my users. It would be nice if we could set a level of when the warning indicator changes colour. Now it is always displayed in red in the post bit. But why not black or blue up to a warning level of ex. 7 and from then on in red?
OK, here is a patch for the postbit template which will do what you want. It's not perfect, but I think it should work.

Go into your postbit or postbit_legacy templates and find the part that shows the Warnings Level and Number of Bans.

In that part of the code, you will find something like:


<font color="#ff0000">


Try replacing that thing with:


<if condition="$post[warning_level]<$limit">
<font color="#0000ff">
<else />
<font color="#ff0000">
</if>


Be careful, the font color is changed several times, so replace it as many times as needed.

Then open your showthread.php file and find:


$viewoption=$warn_opts['viewoption'];


Below that add:


$limit=floor($warn_opts['points_before_banned']*2/3);


Then open your includes/functions_showthread.php and find:


global $bbuserinfo, $session, $ignore, $permissions, $hierarchical, $viewoption, $_REQUEST;


Replace that with:


global $bbuserinfo, $session, $ignore, $permissions, $hierarchical, $viewoption, $limit, $_REQUEST;


Blue up to 6 and from then on red, if your warnings limit is 10.

I hope you like it.
sv1cec
12-28-2004, 12:57 PM
For those who just installed Version 3.0, please download the zip again, and upload the files includes/functions_warning.php and modcp/mod_warn.php to your web server again. Some debug information was left behind, which caused some messages to be displayed on the top of the warning screen. Nothing detrimental, but bothering. And the mod report was not correct.

Thanks and apologies.
Torqued
12-28-2004, 01:08 PM
oh man.. I've been busy and still am on 1.3! lol! poor me! I know what I'm going to be doing this afternoon!
sv1cec
12-28-2004, 01:12 PM
oh man.. I've been busy and still am on 1.3! lol! poor me! I know what I'm going to be doing this afternoon!
I would suggest that you just use the uninstaller to remove the whole thing and install the latest version. If you have warnings you want to maintain, then just comment out the parts of the uninstaller which remove the tables and apply the database changes only.

Sorry!!! :-(
Torqued
12-28-2004, 02:13 PM
I would suggest that you just use the uninstaller to remove the whole thing and install the latest version. If you have warnings you want to maintain, then just comment out the parts of the uninstaller which remove the tables and apply the database changes only.

Sorry!!! :-(

Nah. No problem. I hadn't thought about the uninstaller.. i was gonna do it all manually! My board is still in early beta, so my only warnings are test ones. :) I'll try the uninstaller. Thanks!
Fibe
12-28-2004, 03:08 PM
Get the following error when trying to save changed in warning options:


Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
autocomments='Yes',
warner='261',
automatic_warner='261',
banned_limit='5',
points_before_banned='20',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7',
aprotected_usergroups='',
restore_groupid='2',
incr_ban_days='Yes',
max_no_bans='3',
bans_mature='0',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='Yes',
email_on_ban='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
where oid='1'
mysql error: Unknown column 'autocomments' in 'field list'

mysql error number: 1054


Damn :(
Any idea what I could have done wrong?

And thanks ! Amazing hack.
Delphiprogrammi
12-28-2004, 03:51 PM
hi John,

the upgrade went fine only if i choose the "view banned users" link i get a database crash


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM vb_3user AS user
LEFT JOIN vb_3userban AS userban ON(userban.userid = user.userid)
LEFT JOIN vb_3user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: Unknown column 'userban.reason' in 'field list'

mysql error number: 1054

Date: Tuesday 28th of December 2004 07:00:22 PM
Script: /admincp/admin_warn.php?act=viewbannedusers
Username: ****************
IP Address: ********


i did all the queries you told us to do in the upgradetolatestversion.txt file mmmm i'm lost i had to lock my forums :speechless:

there is a 'userban' table in my database but no userban.reason look at the image and you'll see what i mean
Delphiprogrammi
12-28-2004, 04:41 PM
hi,

it's me again :D i managed to fix the database crash by running the follwwing SQL query


ALTER TABLE vb_3userban add column 'reason' char(3) after bandate


but i'm not sure if it's correct can you tell me ?????? :speechless:
Curzon564
12-28-2004, 04:55 PM
The new sort feature rocks.
Thanks for the new version of this hack.

Everything works fine so far.
sv1cec
12-28-2004, 06:19 PM
Get the following error when trying to save changed in warning options:



Damn :(
Any idea what I could have done wrong?

And thanks ! Amazing hack.
You didn't add the autocomments column in the warning_options table.

Run this query:

ALTER TABLE `".TABLE_PREFIX."warning_options` add column `autocomments` char(3) after automaticpm

Rgds
sv1cec
12-28-2004, 06:24 PM
hi,

it's me again :D i managed to fix the database crash by running the follwwing SQL query


ALTER TABLE vb_3userban add column 'reason' char(3) after bandate


but i'm not sure if it's correct can you tell me ?????? :speechless:

That's because you were not running the latest version before version 3.0.

In version 2.3.4, there was a query:

ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

So, now drop the reason you have inserted and add the proper reason, char(3) is not enough.

Rgds
sv1cec
12-28-2004, 06:25 PM
The new sort feature rocks.
Thanks for the new version of this hack.

Everything works fine so far.


Thank you Sir!

I have to admit, it gave me some headache to implement it, but thanks to a helpful soul here, Dean C, I got it working fine. And yes, I think that it is a cool feature too, it can provide you with so much information, just with the click of a button.

One other thing that the new version has, and which I really like, is that the routines which do the warning and then send the messages, are in one place now. So, if I want to add an automatic warning somewhere else, all I have to do, is call the routines (now they are ... functions), with the proper parameters. That was the reason why you had to remove the large chunk of code from editpost.php, newreply.php, private.php etc. It makes the code so much easier to maintain.

Rgds
TRStealth
12-28-2004, 07:23 PM
I keep getting this error when I try to run the query to update from 2.5 -> 3.0

An error occurred while attempting to execute your query. The following information was returned.
error number: 1103
error desc: Incorrect table name '".TABLE_PREFIX."warning_options'
Delphiprogrammi
12-28-2004, 07:58 PM
That's because you were not running the latest version before version 3.0.

In version 2.3.4, there was a query:

ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

So, now drop the reason you have inserted and add the proper reason, char(3) is not enough.

Rgds

that worked fine thank you !! allis working now except the automatic pm feature if a user posts something and that post contains censored words (a pm is not sended althrough i enabled this) and i have cencored words defined but that isn't so bad i always can do this myself

happy holidays John !! :smoke:
Fibe
12-28-2004, 08:16 PM
Something has gone wrong or i missed something.

I had Zero Tolerance warning hack 1.5. So I only followed the instructions from WarningSystemInstallationInstructions.txt and the upgrade_warn.php file ran without any error now though:

In admincp I have 2 tabs: Warning Systems and the old warning Options.
Clicking on "View Warning Logs" results in: Could not find phrase 'no_warnings_found'.
"View Banned users" results in: Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: Unknown column 'userban.reason' in 'field list'

mysql error number: 1054
And finally when clicking on "view warnings" inside someones posts I get an empty white screen.


So did i miss anything? or just messed up hardcore and should retry ?
Torqued
12-28-2004, 11:06 PM
John,

I had v1.3 installed. I ran the uninstaller, and removed the file changes manually. When trying to run the installer for 3.0, I'm getting the following:

Parse error: parse error, unexpected T_STRING in /home/mydomain/public_html/forums/admincp/install_warn.php on line 285

edited to add:

I think I fixed it:

I found this in the install_warn.php file:

$DB_site->query("
INSERT INTO `".TABLE_PREFIX."phrase` (languageid, varname, text, phrasetypeid) VALUES (0, 'warning_nremoved', 'The selected warning was not totally removed.', 9000)");
INSERT INTO `".TABLE_PREFIX."phrase` (languageid, varname, text, phrasetypeid) VALUES (0, 'warning_banliftcancelled', 'Unban User Cancelled.', 9000)");

and changed it to this:

$DB_site->query("
INSERT INTO `".TABLE_PREFIX."phrase` (languageid, varname, text, phrasetypeid) VALUES (0, 'warning_nremoved', 'The selected warning was not totally removed.', 9000)");
$DB_site->query("
INSERT INTO `".TABLE_PREFIX."phrase` (languageid, varname, text, phrasetypeid) VALUES (0, 'warning_banliftcancelled', 'Unban User Cancelled.', 9000)");

It looks like the $DB_site->query(" was missing. After making that change, the install_warn.php completed successfully. Just have to do the file/template edits now.
Curzon564
12-28-2004, 11:18 PM
"View Banned users" results in:
Quote:
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: Unknown column 'userban.reason' in 'field list'

mysql error number: 1054

Check if there is a "reason" field in the userban table. If it isn't there look here (https://vborg.vbsupport.ru/showpost.php?p=586984&postcount=431) . That should fix it.

And finally when clicking on "view warnings" inside someones posts I get an empty white screen.

Seems as if there are one ore more templates missing.
Torqued
12-28-2004, 11:24 PM
Also, in the current .zip file, it looks like the functions_warning.php, install_warn.php, and mod_warn.php are not in the correct directories in the zip file. There are no files in the /uploads/modcp folder in the zip.

edited to add:

John,

I got AWS v3.0 installed and it seems to be working so far... still have to work through testing a few more things..
Torqued
12-29-2004, 01:05 AM
A question for those using this hack:

What sorts of things are you guys setting up warnings for?
skinny
12-29-2004, 02:07 AM
I want to install this tonight, from fresh. Can we have confirmation that the files are correct in he latest zip. Having mod_warn outside the modcp folder seems wrong.
sv1cec
12-29-2004, 04:11 AM
Something has gone wrong or i missed something.

I had Zero Tolerance warning hack 1.5. So I only followed the instructions from WarningSystemInstallationInstructions.txt and the upgrade_warn.php file ran without any error now though:

In admincp I have 2 tabs: Warning Systems and the old warning Options.
Clicking on "View Warning Logs" results in: Could not find phrase 'no_warnings_found'.
"View Banned users" results in:
And finally when clicking on "view warnings" inside someones posts I get an empty white screen.


So did i miss anything? or just messed up hardcore and should retry ?
You haven't add the 'reason' column in the userban table.

The query is in the install_warn.php file, so I do not understand why it didn't get created.

Run this query manually:

ALTER TABLE `".TABLE_PREFIX."userban` add `reason` mediumtext

One more thing, after you run the upgrade_warn.php script, did you do all the mods that are described?

Rgds
sv1cec
12-29-2004, 04:17 AM
John,

I had v1.3 installed. I ran the uninstaller, and removed the file changes manually. When trying to run the installer for 3.0, I'm getting the following:

Parse error: parse error, unexpected T_STRING in /home/mydomain/public_html/forums/admincp/install_warn.php on line 285

edited to add:

I think I fixed it:

I found this in the install_warn.php file:



and changed it to this:



It looks like the $DB_site->query(" was missing. After making that change, the install_warn.php completed successfully. Just have to do the file/template edits now.
Thanks for spotting this, you are right.
sv1cec
12-29-2004, 04:20 AM
I want to install this tonight, from fresh. Can we have confirmation that the files are correct in he latest zip. Having mod_warn outside the modcp folder seems wrong.
Strange, it looks as if the zipper screwed something up. In my directory structure, the mod_warn.php is in the modcp directory. Functions_warn.php is in the includes etc. I also have the kill_bans.php file in the includes/cron directory and I noticed it does not exist in the zip I uploaded.

I uploaded a new zip file, which should be OK, please let me know if it is.

Rgds
sv1cec
12-29-2004, 05:55 AM
A question for those using this hack:

What sorts of things are you guys setting up warnings for?
There is a picture in the thumbnails, the last one I think, which shows my warning types. You can start there, and move along.

Rgds
sv1cec
12-29-2004, 06:05 AM
On Wednesday December 29th, at GMT 12:15, I just uploaded a new zip file, with the updated upgrade_warn.php, the file used to upgrade from Zero Tolerance's ver. 1.5 hack to the latest version of AWS.

It should upgrade ZT's hack directly to the specs of AWS V.3.0.

Let me know if you have any problems.
Fibe
12-29-2004, 12:06 PM
Ok I managed to fix a few things, but it seems that not all phrases were installed and not all tables were added to database.

I tried uninstall and using install_warn.php and upgrade_warn.php
but both give me errors like:

Does not excist
Duplicate
etc

Which means I am unable to install the phrases. So what i'd like to know is what i should manually remove from the database. So I can actually finish the scripts.

Once that ahs been done I run install_warn ? or upgrade_warn? Or both...

Thanks !
sv1cec
12-29-2004, 02:00 PM
Ok I managed to fix a few things, but it seems that not all phrases were installed and not all tables were added to database.

I tried uninstall and using install_warn.php and upgrade_warn.php
but both give me errors like:

Does not excist
Duplicate
etc

Which means I am unable to install the phrases. So what i'd like to know is what i should manually remove from the database. So I can actually finish the scripts.

Once that ahs been done I run install_warn ? or upgrade_warn? Or both...

Thanks !
Run uninstaller.php from the latest zip file (download it again). Then run install_warn.php, that should do everything for you.

Rgds
Fibe
12-29-2004, 02:10 PM
Ok managed to fix it. I removed the wrong table. Readded it and now all seems to work fine!

Thanks for all your help and now I can finally enjoy this AMAZING hack.

Thanks again.
sv1cec
12-29-2004, 02:49 PM
Ok managed to fix it. I removed the wrong table. Readded it and now all seems to work fine!

Thanks for all your help and now I can finally enjoy this AMAZING hack.

Thanks again.

I was checking the install script just in case I 've screwed something up, and I just came back to answer. Glad you made it.

Rgds
TRStealth
12-29-2004, 04:36 PM
Any idea why I'm getting my error?


I keep getting this error when I try to run the query to update from 2.5 -> 3.0

An error occurred while attempting to execute your query. The following information was returned.
error number: 1103
error desc: Incorrect table name '".TABLE_PREFIX."warning_options'
sv1cec
12-29-2004, 08:04 PM
Any idea why I'm getting my error?
Are you using a table prefix? If not, try running the query without the ".TABLE_PREFIX." part.
Acido
12-29-2004, 09:18 PM
Hi

My only problem, is that the variable $_POST[comment] is not working. Both email and PM, are sent wiht a empty space for the moderator commentslike this:

The admin/moderator who warned you, entered this comment:

=======================================
(nothing here)
=======================================
May you help?
skinny
12-30-2004, 12:37 AM
I uploaded a new zip file, which should be OK, please let me know if it is.
Yes, the zip seems to have maintained its dir structure. Thanks, I can get to work on installing now.
skinny
12-30-2004, 04:25 AM
Installed very smoothly indeed. Now, I'm going to sit back and watch the bans flood in :) Thankyou for a great add-on.
sv1cec
12-30-2004, 07:05 AM
Ooops, good one Acido, thanks for catching that. I forgot to copy an <if> thingy.

Please download the zip again, and upload the Warn.php file and the include/functions_warning.php file to your server.

Apologies for any inconvenience.
sv1cec
12-30-2004, 07:15 AM
One word of caution please, if you allow me.

If you do use the automatic warning functions of this hack, make sure that you set up everything properly. For example, use your common sense when setting up your censorship options. Words have to be selected very carefully, or else expect complains from your users who get warned for calling another member by his name (like the short name for Richard).

Also, if you use the Automatic Warning for PMs, please understand that each PM which is caught containing censored words, is kept in a log, which you can see. This may be in violation of your user's privacy, since a PM is a private message from one member to another. You may receive complains about it.

Don't shoot the pianist for the above!

Rgds
jluerken
12-30-2004, 09:05 AM
One word of caution please, if you allow me.

If you do use the automatic warning functions of this hack, make sure that you set up everything properly. For example, use your common sense when setting up your censorship options. Words have to be selected very carefully, or else expect complains from your users who get warned for calling another member by his name (like the short name for Richard).

Also, if you use the Automatic Warning for PMs, please understand that each PM which is caught containing censored words, is kept in a log, which you can see. This may be in violation of your user's privacy, since a PM is a private message from one member to another. You may receive complains about it.

Don't shoot the pianist for the above!

Rgds
Hi Sv1cec,

I updated to v. 3.0.1 but two functions are not working for me now:
- automatically issued warnings for posts which contain censored words
- automatically issued warnings for private messages which contain censored words

I entered censored words but If I use them in a post I will never get warned.
I created a normal 'registered user' testaccount to test this.

Can you give a helping hand?
sv1cec
12-30-2004, 11:27 AM
Hi Sv1cec,

I updated to v. 3.0.1 but two functions are not working for me now:
- automatically issued warnings for posts which contain censored words
- automatically issued warnings for private messages which contain censored words

I entered censored words but If I use them in a post I will never get warned.
I created a normal 'registered user' testaccount to test this.

Can you give a helping hand?
I sure can.

First of all, from which version did you upgrade to 3.0.1? Have you installed V.3.0 first? Did the automatic warning worked with that version?

The automatic warning was first implemented in version 2.0. If you have installed that version, and followed all the upgrades, you shouldn't have a problem.

Make sure that you have the proper code changed in the files newreply.php, newthread.php and private.php. Also, please make sure you have done the appropriate changes in includes/functions_newpost.php.

Let me have that info, and we'll make it work for you.

Rgds
jluerken
12-30-2004, 11:59 AM
I sure can.

First of all, from which version did you upgrade to 3.0.1? Have you installed V.3.0 first? Did the automatic warning worked with that version?

The automatic warning was first implemented in version 2.0. If you have installed that version, and followed all the upgrades, you shouldn't have a problem.

Make sure that you have the proper code changed in the files newreply.php, newthread.php and private.php. Also, please make sure you have done the appropriate changes in includes/functions_newpost.php.

Let me have that info, and we'll make it work for you.

Rgds
I upgraded from version 3.0 and no the automatic warning if a user uses a censored word was never working for me.


I'll recheck the changed in newreply.php, newthread.php, private.php and includes/functions_newpost.php and will then come back to you.
Viol8or
12-30-2004, 07:15 PM
Hey, sv1cec
thanks for the solution on the colour for warning levels. I'll update the system and try your scripts this weekend. I'll let you know how it went!
Have a good end of the year and see you all next year!!!!
nubian
12-30-2004, 07:35 PM
if i go into admincp > warning logs > complete removal
i get this:
The requested URL /forums/admincp/admin_warn.php was not found on this server.
my admincp directory is not named admincp
it's named something else.

how can i fix this?
btw this is a lovely mod.
thank you so much
nubian
12-30-2004, 07:43 PM
another...

when i go into admincp > view banned users
and click on the "No users are banned from MyForum.com Forums - To ban a user, click here
i get a blank white page.
but if i were to go to admincp > users > ban users
it will come up just fine.
any idea?
thanks
T3MEDIA
12-30-2004, 09:01 PM
I am looking for some one to install this for me Please PM so we can make arangements.
sv1cec
12-30-2004, 09:22 PM
if i go into admincp > warning logs > complete removal
i get this:
The requested URL /forums/admincp/admin_warn.php was not found on this server.
my admincp directory is not named admincp
it's named something else.

how can i fix this?
btw this is a lovely mod.
thank you so much
I guess I should fix it, by using the appropriate parameter, I'll try to find it tomorrow. In the mean time, you can always go into the admin_warn.php file and find the following line:


$cy="<a href='{$vboptions[bburl]}/admincp/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal</a>";


Replace the admincp in the path with whatever your admincp directory is.

As for the link, at the No users were banned etc., there shouldn't be a link there. Please find this code in admincp/admin_warn.php:


print_stop_message('no_users_banned_from_x_board', "<b>$vboptions[bbtitle]</b>", "admin_warn.php?$session[sessionurl]?act=viewbannedusers");


replace it with:


print_cp_message('No users were banned from these forums.', "admin_warn.php?$session[sessionurl]?act=viewbannedusers", 7);



The reason I do not want that link there, is because in AWS, you are not suppose to ban users. Banning inside AWS is the result of warnings accumulated in a users account. AWS manages the warnings and the ban comes as a by-product, associated with the warnings. If you want to ban a user outside AWS, use the other link you suggested.

Rgds
sv1cec
12-30-2004, 10:37 PM
if i go into admincp > warning logs > complete removal
i get this:
The requested URL /forums/admincp/admin_warn.php was not found on this server.
my admincp directory is not named admincp
it's named something else.

how can i fix this?
btw this is a lovely mod.
thank you so much
The problem you had with the Complete Removal should be now resolved, in the admin_warn.php file included in the 3.0.2 zip file. Please let me know if it works.

Rgds
nubian
12-31-2004, 12:31 AM
The problem you had with the Complete Removal should be now resolved, in the admin_warn.php file included in the 3.0.2 zip file. Please let me know if it works.

Rgds was i only suppose to simply upgrade to 3.0.2 and not do what you said in your second to last post?
i upgraded to 3.0.2 and uploaded the new admin_warn.php and now i got this when i try the complete removal error:

The requested URL /forums/admincontrolpanelnamehere/admincontrolpanelnamehere/admin_warn.php was not found on this server.

it displays the admincp twice
sv1cec
12-31-2004, 01:16 AM
Either you upgrade the admin_warn.php included in the 3.0.2 release or you do the change I wrote to you before. Not both.

Rgds
nubian
12-31-2004, 01:21 AM
i didn't do both at all.
i upgrade.
i got that double admincp directory thng i posted prior to this.
sv1cec
12-31-2004, 01:28 AM
i didn't do both at all.
i upgrade.
i got that double admincp directory thng i posted prior to this.
What does it shows you if you click on the link which has the warned user name? Does it come up with the proper page for that user?
nubian
12-31-2004, 02:08 AM
when i clicked on the "View Warned Users " link, that page comes up just fine.
sv1cec
12-31-2004, 02:46 AM
when i clicked on the "View Warned Users " link, that page comes up just fine.
OK, open your admin_warn.php file and find the two lines which start with :

$x="<a href='

and

$cy="<a href='

Copy these lines from your file, here so that I can see what's going on. The two should be pointing to the same directory, only the first one has the forums URL in the front, which is redundant.

Waiting
nubian
12-31-2004, 02:51 AM
$x="<a href='{$vboptions[bburl]}/$admincpdir/user.php?$session[sessionurl]do=edit&userid={$warn[warned_userid_v]}'>{$warn[warned_userid_v]}
{$warn['warned_username_v']}";

$cy="<a href='$admincpdir/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal";
sv1cec
12-31-2004, 03:10 AM
$x="<a href='{$vboptions[bburl]}/$admincpdir/user.php?$session[sessionurl]do=edit&userid={$warn[warned_userid_v]}'>{$warn[warned_userid_v]}
{$warn['warned_username_v']}";

$cy="<a href='$admincpdir/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal";
Darn if I understand why this happens, but here is your solution:

Change those two lines with the lines below:


$x="<a href='/$admincpdir/user.php?$session[sessionurl]do=edit&amp;userid={$warn[warned_userid_v]}'>{$warn[warned_userid_v]}<br><b>{$warn['warned_username_v']}</b>";


and


$cy="<a href='/$admincpdir/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal</a>";


If there is no / in front of $admincpdir or no bburl, it uses the admincp directory twice!!! Go figure!

Sorry for that, I'll change it in the install file.
nubian
12-31-2004, 04:30 AM
i'm getting this now:

Not Found

The requested URL /admincontrolpanelnamehere/admin_warn.php was not found on this server.

funny thing is that admin_warn.php does exist in that that directory :ermm:
sv1cec
12-31-2004, 04:51 AM
That is crazy!!!

OK, convert both lines to:


$x="<a href='{$vboptions[bburl]}/$admincpdir/user.php?$session[sessionurl]do=edit&amp;userid={$warn[warned_userid_v]}'>{$warn[warned_userid_v]}<br><b>{$warn['warned_username_v']}</a></b>";


and


$cy="<a href='{$vboptions[bburl]}/$admincpdir/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal</a>";


Let's see if that works.
nubian
12-31-2004, 05:14 AM
That is crazy!!!

OK, convert both lines to:


$x="<a href='{$vboptions[bburl]}/$admincpdir/user.php?$session[sessionurl]do=edit&amp;userid={$warn[warned_userid_v]}'>{$warn[warned_userid_v]}<br><b>{$warn['warned_username_v']}</a></b>";


and


$cy="<a href='{$vboptions[bburl]}/$admincpdir/admin_warn.php?act=completeremove&id={$warn[wid]}&userid={$warn[warned_userid_v]}&uname={$warn[warned_username_v]}&wname={$warn[warn_name]}&postid={$warn[warned_post]}&orderstring={$order}'>Complete Removal</a>";


Let's see if that works.
i'm smiling so you know what that means! ;)
sv1cec
12-31-2004, 05:27 AM
i'm smiling so you know what that means! ;)
Glad you made it. I would be happier if I knew why it was not working in the other two ways, but anyway.

Happy New Year and Happy Warnings
nubian
01-01-2005, 12:02 AM
when i tried going running the 3.0.2 on my REAL LIVE forum i got this error when running the install_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE `vb3_userban`
add `reason` mediumtext;
mysql error: Duplicate column name 'reason'

mysql error number: 1060
bahawolf
01-01-2005, 07:23 AM
How would I go about that if the user doesn't have any warning points, it'd appear as "0" for the value because a div in my postbit is being unused when their not warned and it looks bad.
nubian
01-01-2005, 07:54 AM
something is wrong with your 3.0.2 install_warn.php file.
it won't do what it's suppose to do.
instead i've reloaded my db and used the install_warn.php from 2.3.5 and it altered what it was suppose to alter in the db.
sv1cec
01-01-2005, 09:42 AM
when i tried going running the 3.0.2 on my REAL LIVE forum i got this error when running the install_warn.php

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE `vb3_userban`
add `reason` mediumtext;
mysql error: Duplicate column name 'reason'

mysql error number: 1060
Nubian,

Please do not say that the install script does not work, just because it didn't work in your case. I just installed vB 3.0.3 on my test site, from scratch, and did the hack installation. The install script did everything it is supposed to do.

I would appreciate if you can tell me what your problems were, so that I can assist you.

As for your issue with the 'reason' column in the userban table, it just means it is already there. Maybe it was added by another hack, or by your installation attempts, but that column is not there in a new database, and it should be created by the hack.

If you loaded 2.3.5, and want to use 3.0.2 you have to do all the steps described in UpgradeToLatestVersion.txt, from 2.3.5 to 3.0 then to 3.0.1 then to 3.0.2.

Rgds
sv1cec
01-01-2005, 09:46 AM
How would I go about that if the user doesn't have any warning points, it'd appear as "0" for the value because a div in my postbit is being unused when their not warned and it looks bad.
If this is something you have changed from the standard hack code, I can't help unless I know what you have changed. Also, typically in the postbit templates the things which show the points and the bans should not appear if there are no points in the user's account.

This is accomplished by the:


<if condition="$post[warning_level]>0">


statement, which allows the warning points to be viewable only if they exist.

Show me that part of your template and I'll try to adapt it to your needs.

Rgds and HAPPY NEW YEAR to all
bahawolf
01-01-2005, 03:19 PM
<-- Points System -->
<if condition="$bbuserinfo['usergroupid'] == '6'"><div class="info"><a href="ushop.php?do=a&shortname=admindonate&userid=$post[userid]" target="_blank">$vbphrase[ucs_points]</a><else />$vbphrase[ucs_points]</if>: $points (<a href="ushop.php?do=a&shortname=donate&userid=$post[userid]" target="_blank">Donate</a>)
< / -- Points System -- \ >

<div class="info"><if condition="$viewoption=='All'">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if>

<if condition="$viewoption=='Mgm' AND $hierarchical=='Yes'">
<if condition="($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==5 AND $post[userid]==$bbuserinfo[userid])
OR
($bbuserinfo[usergroupid]==7 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5 AND $post[usergroupid]!=7)
OR
($bbuserinfo[usergroupid]==5 AND $post[usergroupid]!=6 AND $post[usergroupid]!=5)
OR
($bbuserinfo[usergroupid]==6)
">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[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) OR ($bbuserinfo[usergroupid]!=7 AND $bbuserinfo[usergroupid]!=6 AND $bbuserinfo[usergroupid]!=5 AND $post[userid]==$bbuserinfo[userid]))">
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
<if condition="$post[warning_bans]>0">
<font color="#ff0000">
<BR>Number of bans: $post[warning_bans]
<font color="#000000">
</if>
</if></div>


Here it is.. I didn't have reputation display, so I put that as the points value is the last in the postbit.
sv1cec
01-01-2005, 03:36 PM
Here it is.. I didn't have reputation display, so I put that as the points value is the last in the postbit.
The only thing I can see missing is an </if> right after < / -- Points System -- \ >

The code for AWS is OK, so it shouldn't display any info if the user has no warning points.

Rgds
bahawolf
01-01-2005, 03:42 PM
Do you know of any way I could go about fixing this..? Even giving you AdminCP access?
sv1cec
01-01-2005, 04:10 PM
E-mail me with the details of your forum, I want to see what it's doing. Because, as it is in the code you posted above, it should NOT show anything for users with no warning points.

Rgds
bahawolf
01-01-2005, 04:13 PM
Oh I think you've taken my question wrong..

Say a user is warned with 1 point and it says:
Warning Points: 1

I want it so if they have none, it says:
Warning Points: 0
nubian
01-01-2005, 04:16 PM
Nubian,

Please do not say that the install script does not work, just because it didn't work in your case. I just installed vB 3.0.3 on my test site, from scratch, and did the hack installation. The install script did everything it is supposed to do.

I would appreciate if you can tell me what your problems were, so that I can assist you.

As for your issue with the 'reason' column in the userban table, it just means it is already there. Maybe it was added by another hack, or by your installation attempts, but that column is not there in a new database, and it should be created by the hack.

If you loaded 2.3.5, and want to use 3.0.2 you have to do all the steps described in UpgradeToLatestVersion.txt, from 2.3.5 to 3.0 then to 3.0.1 then to 3.0.2.

Rgds i'm deeply sorry.
i didn't want it to come out like that.
it was the new years liquor talking. :)
i'm not saying this out of frustration.

i have one hack installed on my board and that's a portal.
the portal did altered a few tables in the db.
if i were to reload a db that i have backed up and run the install_warn.php file it gives me this after the 2nd step:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `vb3_warning_options` values ('1','3.0', 'Yes', 'Yes','No','Yes','','0','7','10','8','6','6','8',' 0','Yes','3','0','All','Yes','Yes','No','Yes','Yes ','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

prior to running your install_warn.php script there was never a vb3_warning_options table. :ermm:
sv1cec
01-01-2005, 05:59 PM
i'm deeply sorry.
i didn't want it to come out like that.
it was the new years liquor talking. :)
i'm not saying this out of frustration.

i have one hack installed on my board and that's a portal.
the portal did altered a few tables in the db.
if i were to reload a db that i have backed up and run the install_warn.php file it gives me this after the 2nd step:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO `vb3_warning_options` values ('1','3.0', 'Yes', 'Yes','No','Yes','','0','7','10','8','6','6','8',' 0','Yes','3','0','All','Yes','Yes','No','Yes','Yes ','Yes','15')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

prior to running your install_warn.php script there was never a vb3_warning_options table. :ermm:
Please download the latest zip file. Run the uninstaller, and then re-install from scratch.

I tried it this morning and it works fine.

Rgds
nubian
01-01-2005, 07:17 PM
weird....
that one works just fine.
thanks!
jonnerd154
01-01-2005, 09:48 PM
I need a little help. I followed the install directions perfectly (I think, I may have made a mistake.) Everything LOOKS ok in the mod and admincp's and the warn [user] links are at the top of all posts, etc. When I click on the Ban [user] links I am directed to (EG) http://mahplace.com/forums/Warn.php?do=WarnUser&id=2128&post=769427 but the output of that page is just <html><body></body></html>

Any ideas why the page is not parsing?

EDIT: Note that I am using an installer package I downloaded yesterday.
mojo8850
01-01-2005, 11:20 PM
Ok.. Here's Wat I've Done.. :ermm:

I Installed The Warning HACK 1.0 Then Upgraded To 1.5.
And Then Installed The AWS v3.0.2.!

Now When I Click On Warning Systems > View Ban User's I Get Database Error..!

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: Unknown column 'userban.reason' in 'field list'

mysql error number: 1054

Date: Sunday 02nd of January 2005 02:14:47 AM

Can Some One Help Me Please..! :tired: :tired: :tired:
Delphiprogrammi
01-02-2005, 04:45 AM
hi ,

yeah we can help you there is a column missing in your userban database table goto PhpMyAdmin or whatever you use to run SQL queries and run

ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext


drop the TABELE_PRFIX part if MySQL complains about it (give your table name instead then)
sv1cec
01-02-2005, 06:19 AM
I need a little help. I followed the install directions perfectly (I think, I may have made a mistake.) Everything LOOKS ok in the mod and admincp's and the warn [user] links are at the top of all posts, etc. When I click on the Ban [user] links I am directed to (EG) http://mahplace.com/forums/Warn.php?do=WarnUser&id=2128&post=769427 but the output of that page is just <html><body></body></html>

Any ideas why the page is not parsing?

EDIT: Note that I am using an installer package I downloaded yesterday.
Ban User links??? There should be no "Ban User" links. Where are these links found?
sv1cec
01-02-2005, 06:23 AM
Bahawolf,

Find the following code


<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>


Replace that with:


<if condition="$post[warning_level]=='' OR $post[warning_level]=='0'">
<BR>Warning Level: 0
<else />
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>


Careful that code exists twice in postbit. Replace both instances.

Rgds
Delphiprogrammi
01-02-2005, 06:33 AM
hi sv1cec ,

i run into a little problem with the latest version installed.if you choose "view banned users" (and you don't have any) that page is redirected to a blank page after a while just a blank white browser window it must be in admin_warn.php but i'm to scared to screw up
jonnerd154
01-02-2005, 07:46 AM
Ban User links??? There should be no "Ban User" links. Where are these links found?

Ack, sorry...I meant Warn User links.
bold
01-03-2005, 05:07 AM
hey i'm getting a error when i try to send a pm.

Database error in vBulletin 3.0.3:

Invalid SQL: select username from vb3_user where userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Monday 03rd of January 2005 01:06:50 AM
Script: http://www.xxxxx.com/forums/private.php
Referer: http://www.xxxxx.com/forums/private.php?do=newpm&u=122
Username: bold
IP Address: 172.137.2.235


any ideas?
sv1cec
01-03-2005, 05:51 AM
hi sv1cec ,

i run into a little problem with the latest version installed.if you choose "view banned users" (and you don't have any) that page is redirected to a blank page after a while just a blank white browser window it must be in admin_warn.php but i'm to scared to screw up
This issue has been dealt with. Please download the latest zip and upload admin_warn.php to your server.

Rgds
sv1cec
01-03-2005, 05:52 AM
hey i'm getting a error when i try to send a pm.

Database error in vBulletin 3.0.3:

Invalid SQL: select username from vb3_user where userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Monday 03rd of January 2005 01:06:50 AM
Script: http://www.xxxxx.com/forums/private.php
Referer: http://www.xxxxx.com/forums/private.php?do=newpm&u=122
Username: bold
IP Address: 172.137.2.235


any ideas?
Check your modifications in private.php, you must have missed something.

Rgds