[BeasTboyz]

Originally Posted by sv1cec

To use my modification for this hack, you have to add some more fields in the tables. For example, I have a field which says if the warning relates to an offence which deserves a permanent ban (such as for a troll). I'll try to help you, if you give me the exact error you get in my code and the line of the code it generates it (the line is not only the part you show above, give me the whole code statement).

Rgds
------------
John

Thanks for the offer to help, John.

I have attached my Warn.php file so you can see exactly what it says.

When I change Warn.php so that it adds a user to the normal vB banned usergroup I get this error and this error only when attempting to warn a user or view their warning level:

Parse error: parse error, unexpected T_VARIABLE in /home/observed/public_html/vb/Warn.php on line 250

Here are some lines from my Warn.php file

243: if($warn_type['warn_permban']=="Yes") 
244:             {$liftdate=0; 
245:              } 
246:            else 
247:             {$liftdate=$time_unban; 
248:             } 
249:                 $usergroupid=8 
250:        $DB_site->query(" 
251:            INSERT INTO " . TABLE_PREFIX . "userban 
252:            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate) 
253:            VALUES 
254:             ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . addslashes($user['usertitle']) . "', $bbuserinfo[userid], " . TIMENOW . ", $liftdate)"); 
255:         $DB_site->query(" 
256:                UPDATE " . TABLE_PREFIX . "user SET 
257:                usergroupid = $usergroupid, 
258:                displaygroupid = $usergroupid 
259:                WHERE userid = $user[userid] 
260:            ");

When I change the private message function so that it uses the template instead of the stock way it notifies a user of a warning I get this mySQL error:

Database error in vBulletin 3.0.3:

Invalid SQL: insert into vb3_pmtext values ('','1','Matt','You have been warned','Dear BeasTboyz,

You have been warned for one of your posts, which violated the Forums Rules.

The reason you have been warned is because  Other reasons not listed (Warning Type = Miscellaneous), for which you have been given  2  point(s).

The post for which you are warned can be seen here.

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

=======================================
test
=======================================

Your total Warning Level at the moment is:  5  point(s).

If you reach the maximum of 5, you will be banned from the Forums, for 3 days.

To see details about all the warnings you have received, until now, please click here.

Please reply back if you have a dispute.','a:1:{i:5;s:9:\"BeasTboyz\";}','4','1096188731','1','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Sunday 26th of September 2004 03:52:11 AM
Script: http://www.observedtrials.net/vb/Warn.php
Referer: http://www.observedtrials.net/vb/War...d=5&post=73439
Username: Matt
IP Address: xx.xx.xx.xx

Thanks again for any help,

Matt