[For 1.8] DVZ Integrity Tools 1.1.1

[Serpius]

1.1.0:

• added HTML escaping for unified differential
  
• enabled fetching custom checksums files
  
• fixed missing language string issues
  
• minor visual corrections
  
• minor code quality corrections
  

-----BEGIN PGP SIGNATURE-----

iQEzBAABCgAdFiEE346WhYk6su6vogTe4v2sXM44p30FAluAgh8ACgkQ4v2sXM44
p33NQAf+LbiivQK0foB1Dc5pLGNFbbyDl/319mWsh5gVbCZEXzfqpZjYhuKftb8O
34gFLSXQ5wwL7Eu9ZbzLrIUEgcl+W9f6UCdXIy0S7D7zlCCDe8HyTS9bpfN593F1
sufiCIe/C8HuqxLp+IEBYiQNSlqkvu/yqwgKRMcLQivj083pHybQUjhnROVpuytO
YIeXcHzJYh0lzld3fk4kHnWiMSPrdJYiJLfSv2YrHmBmkGofV0If9Tm6rcMgRjRs
gmZ8097u4CPmZPGN0ODAFrFt0NHPlhCnttu5unUNAgNRVdxYRP5CzJ8bgzhta/jc
OhqdVerYOxMlwqXI6CE2xQ6txJHKVA==
=8OVI
-----END PGP SIGNATURE-----

https://community.mybb.com/mods.php?acti...0&bid=3321

I've installed the plugin and it runs great.

Except for one issue. I don't know if I can call it a bug or something else.

Is the Integrity Tools limited to ONE Super Admin? 

I have a 2nd Admin for my website and he is designated as Super Admin (in config.php), but he has no permissions for the Integrity Tools plugin in the Tools & Maintenance section.

You can clearly see he's in as 0xB9, but he's denied due to the permissions issue because the AdminCP does not see him as a Super Admin, even though he is.

[Devilshakerz]

Is the Integrity Tools limited to ONE Super Admin? 

I have a 2nd Admin for my website and he is designated as Super Admin (in config.php), but he has no permissions for the Integrity Tools plugin in the Tools & Maintenance section.

The plugin uses the same logic as the core - you can check if user IDs have been added correctly by looking at Users & Groups → Admin Permissions, where the Set Permissions Option should be hidden for their account.

[canadacommunity]

Thanks for sharing & making this awesome plugin @Devilshakerz.
Thanks to @vintagedaddyo who noticed and pointed out to me that my mybb default template is a bit outdated, even though im using the latest mybb version since the default template and css was modified by me (i did not know this until today) but I must update this manually so maybe by using this tool, i will be able to update things one thing at a time. wish me luck! 

[ahmedwaill]

that's a great plugin but i'm getting this error
is there any solution ?
PS: if i go to Dashboard and click CheckForUpdates of MyBB i get error too hope that can help you to identify the issue.
nvm fixed it by changing the URL of the mybb release from https to http.

[Dr_The_One]

Thanks for suggestion of changing on ACP Checksum files box url from https to HTTP.

But error on clicking check for updates for mybb, persist.
Any solution.

[HLFadmin]

But error on clicking check for updates for mybb, persist.
Any solution.

PHP directive allow_url_fopen needs to be enabled for fetching the comparison files.
How you do this is dependent on your server environment.
Essentially, your php.ini file establishes the directives settings.

[Devilshakerz]

Version 1.1.1

• fixed PHP compatibility issues
  
• improved database table declaration parsing
  
• improved repository file checks
  

[noyle]

I'm not sure but it looks like MySQL 8 adds COLLATE for text fields. There's an example of results of running the integrity tools on MySQL 8, table mybb_searchlog:

`sid` varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
`threads` longTEXT COLLATE utf8mb4_general_ci NOT NULL

And also with MySQL 8, it will remove the integer display from the SQL show create table XXX.

And in PostgreSQL database, the following lines appears in the result (the same from the show_create_table results) for the attachments table:

string(858) "CREATE TABLE mybb_attachments (
  aid int4 DEFAULT nextval('mybb_attachments_aid_seq'::regclass) NOT NULL,
  pid int4 NOT NULL,
  posthash varchar(50) DEFAULT ''::character varying NOT NULL,
  uid int4 NOT NULL,
  filename varchar(255) DEFAULT ''::character varying NOT NULL,
  filetype varchar(120) DEFAULT ''::character varying NOT NULL,
  filesize int4 NOT NULL,
  attachname varchar(255) DEFAULT ''::character varying NOT NULL,
  downloads int4 NOT NULL,
  dateuploaded int4 NOT NULL,
  visible int2 DEFAULT '0'::smallint NOT NULL,
  thumbnail varchar(120) DEFAULT ''::character varying NOT NULL,
  ........pg.dropped.13........ ,
  ........pg.dropped.14........ ,
  ........pg.dropped.15........ ,
  ........pg.dropped.16........ ,
  CONSTRAINT mybb_attachments_pkey PRIMARY KEY (aid),
  CONSTRAINT mybb_attachments_pkey UNIQUE (aid)
)

The dropped columns.