Upgrade script

[TosaInu]

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?

[Marco van Herwaarden]

Add the prefix to the SQL in the script.

[TosaInu]

Add the prefix to the SQL in the script.
Hello MarcoH64,

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.

[Marco van Herwaarden]

in the upgrade script, change the delete from template where into delete from vb_template where

[TosaInu]

in the upgrade script, change the delete from template where into delete from vb_template where
Thanks MarcoH64

lol stupid me.

A field is missing:

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

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.

[sv1cec]

Thanks MarcoH64

lol stupid me.

A field is missing:

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

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.

Rgds

[TosaInu]

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?

My overall impression of this hack: great job!

[sv1cec]

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?

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.

Sorry for the inconvenience.

[TosaInu]

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.

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.

[sv1cec]

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.
Good work man, glad you got it figured out.

Rgds