Version: , by TosaInu
Developer Last Online: Nov 2023
Version: Unknown
Rating:
Released: 02-09-2005
Last Update: Never
Installs: 0
No support by the author.
Hello,
I'm running the upgrade script (already have Zero Tolerances hack). There's an SQL error right away
Invalid SQL: delete from template where (title>='warn' AND title<'warn_z')
mysql error: Table 'test.template' doesn't exist
test is the database name. It doesn't mention the used prefix vb_ . The table vb_template is definately there. The script works on a copy of vb_template called template.
A typo in the upgrade script?
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Yes, that's my thought. Problem is that I know near to nothing about PHP. I can see how the prefix is called in plain queries, but this deletion thing got me confused.
Also Invalid SQL: insert into vb_warnings (wid, warned_user, warned_by, warned_time, warned_reason, warned_post, warned_warning_id, caused_ban, warned_status, removed_by, removed_date) values('','4','1','1107975903','test','44','4','N' ,'A','','')
mysql error: Unknown column 'caused_ban' in 'field list'
and
Database error in vBulletin 3.0.3:
Invalid SQL: update vb_post set warn_flag=warn_flag+1 where postid='44'
mysql error: Unknown column 'warn_flag' in 'field list'
When a moderator issues a warning which hits Warning Points Limit, reason:
Invalid SQL:
INSERT INTO vb_userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
(4, 4, 0, 0, 'test', 1, 1107979673, 1108152473, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'
It's possible to warn again for the same post even when this is set to no.
Also Invalid SQL: insert into vb_warnings (wid, warned_user, warned_by, warned_time, warned_reason, warned_post, warned_warning_id, caused_ban, warned_status, removed_by, removed_date) values('','4','1','1107975903','test','44','4','N' ,'A','','')
mysql error: Unknown column 'caused_ban' in 'field list'
and
Database error in vBulletin 3.0.3:
Invalid SQL: update vb_post set warn_flag=warn_flag+1 where postid='44'
mysql error: Unknown column 'warn_flag' in 'field list'
When a moderator issues a warning which hits Warning Points Limit, reason:
Invalid SQL:
INSERT INTO vb_userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
(4, 4, 0, 0, 'test', 1, 1107979673, 1108152473, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'
It's possible to warn again for the same post even when this is set to no.
Run the following queries to add the missing fields in your table (remember to change them to use your prefix):
ALTER TABLE `warning_options` ADD COLUMN textbutoption char(10)
ALTER TABLE `warnings` ADD COLUMN caused_ban char(1)
ALTER TABLE `post` ADD COLUMN warn_flag int(5) default 0
ALTER TABLE `userban` ADD COLUMN reason mediumtext
Run these and see if everything goes OK. I'll be uploading a new upgrade_warn.php script in a while.
Run the following queries to add the missing fields in your table (remember to change them to use your prefix):
ALTER TABLE `warning_options` ADD COLUMN textbutoption char(10)
ALTER TABLE `warnings` ADD COLUMN caused_ban char(1)
ALTER TABLE `post` ADD COLUMN warn_flag int(5) default 0
ALTER TABLE `userban` ADD COLUMN reason mediumtext
Run these and see if everything goes OK. I'll be uploading a new upgrade_warn.php script in a while.
Rgds
Thanks sv1cec,
I had already added the missing tables in the testboard (usually prefer to test hacks first), I've some different datatypes, but it seems to work though.
It's possible to warn again for the same post even when this is set to no. Is this related to wrong datatypes or is it another glitch?
I had already added the missing tables in the testboard (usually prefer to test hacks first), I've some different datatypes, but it seems to work though.
It's possible to warn again for the same post even when this is set to no. Is this related to wrong datatypes or is it another glitch?
My overall impression of this hack: great job!
You are again right, another bug, darn!!!
OK, download the latest version of the zip and upload Warn.php and includes/functions_warning.php to your server.
OK, download the latest version of the zip and upload Warn.php and includes/functions_warning.php to your server.
Sorry for the inconvenience.
Hello sv1cec,
No inconvenience at all. I'm using this hack (any hack for that matter) on a testforum first. Often it's me making mistakes with installing hacks or I want tiny tweaks and try to code them.
No inconvenience at all. I'm using this hack (any hack for that matter) on a testforum first. Often it's me making mistakes with installing hacks or I want tiny tweaks and try to code them.
Upgrade script Details »»
About Developer
Visit Web Site
No support by the author.
02-09-2005, 12:40 PM
