Administrative and Maintenance Tools - ChilaxinMS Staff Comments

ChilaxinMS Staff Comments v1.3


Allows staff members and predefined users to converse about a thread without normal user's seeing it. Displays above the thread and allows a "Auto Post" function on the posting of a staff comment.

I have personally tested it on vBulletin version 4.0.8, but I can't see it having any problems with any 4.x.x versions, but if there is an error please tell me and I will fix right away!


Features:
-Allows usergroups to see staff notes
-Allows specific users to see staff notes
-Supports BB Code


Version Releases:

1.0.0
- Initial Release (only for Beta testers)

1.0.1
- Fixed some users not being able to see the staff comments due to user ID.
- Fixed the Forum/Thread "updater" to actually show the auto comment as the latest reply.
- Added prefix support.
- Added MySQL injection checking (You never know when your staff will get mad!)

1.2
- Compatible with 4.2 (Sorry for the delay, never got a notification!)

1.3
- Fixed an issue with vBulletin usergroup HTML markup causing SQL errors.
(If your usergroup markup had single quotes ( ' ) it would cause SQL errors
- Added more security measures.

1.3.1
- Fixed an issue with upgrading from previous versions.

Please let me know of any bugs/errors/requests and I will fix right away!

[vauge]

Any chance to get this working in 4.2?

Thanks!

[ChilaxinC]

Originally Posted by vauge

This does not appear to be working with 4.2

Originally Posted by vauge

Any chance to get this working in 4.2?

Thanks!

Hey sorry for the delay, never got the email notification that this wasn't working!

It is fixed now,
Thanks.

If you notice any bugs just drop of a reply/PM and I will fix it ASAP

[Faskis]

For those of you who updated to vB 4.2.2 and are getting the following error:

Warning: Function split() is deprecated in ..../displaystaff.php on line 23
Warning: Function split() is deprecated in ..../displaystaff.php on line 29

Change the split() functions in all three files (addstaff.php, deletestaff.php, displaystaff.php) to explode().




Also, upgrading from 1.2 to 1.3 yields these errors:

Database error in vBulletin 4.2.2:

Invalid SQL:

CREATE TABLE `threadcomment` (
`threadcommentid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`threadid` INT(10) UNSIGNED NOT NULL,
`userid` INT(10) UNSIGNED NOT NULL,
`username` VARCHAR(100) NOT NULL,
`dateline` INT(10) UNSIGNED NOT NULL,
`comment` TEXT NOT NULL
);

MySQL Error : Table 'threadcomment' already exists
Error Number : 1050
Request Date : Sunday, October 27th 2013 @ 01:25:46 PM
Error Date : Sunday, October 27th 2013 @ 01:25:47 PM
Script : http://--/forums/admincp/plugin.php?do=productimport
Referrer : http://--/forums/admincp/plugin.php?do=productadd
IP Address : --
Username : --
Classname : vB_Database
MySQL Version : 5.1.70-cll

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE `thread` ADD `threadcomments` INT( 10 ) UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'threadcomments'
Error Number : 1060
Request Date : Sunday, October 27th 2013 @ 01:28:15 PM
Error Date : Sunday, October 27th 2013 @ 01:28:16 PM
Script : http://--/forums/admincp/plugin.php?do=productimport
Referrer : http://--/forums/admincp/plugin.php?do=productadd
IP Address : --
Username : --
Classname : vB_Database
MySQL Version : 5.1.70-cll

Simple checks to see if they exist should suffice here. I simply deleted the table and column and had the script recreate it to finish the updates.

[ChilaxinC]

Originally Posted by GrandTheftGamer

For those of you who updated to vB 4.2.2 and are getting the following error:

Warning: Function split() is deprecated in ..../displaystaff.php on line 23
Warning: Function split() is deprecated in ..../displaystaff.php on line 29

Change the split() functions in all three files (addstaff.php, deletestaff.php, displaystaff.php) to explode().




Also, upgrading from 1.2 to 1.3 yields these errors:




Simple checks to see if they exist should suffice here. I simply deleted the table and column and had the script recreate it to finish the updates.

Fixed the above, let me know if everything works well, I notice no errors.

Thanks

[Faskis]

I noticed recently that php's error_log has been getting filled up with the following error:

PHP Deprecated:  mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in displaystaff.php on line 40

I know that this can generally be ignored, but the forums do utilize mysqli. Any possibility this could get adjusted, either directly in the code for this mod or utilize vB's connection functions?