New Posting Features - Default Editor Messages

About DEM:
Default Editor Messages (what a name) allows forum specific messages to populate the editor when users create newthreads. This, originally custom modification, has been converted into a proper vB product for vB.org users. DEM uses instances and messages in combination to allow for very specific message display and order.

Uses:
Have you or your moderators ever had to clean up messes in your community because your users simply ignore or forget the rules? Or maybe you have a specific forum where you want all new posts to follow a template and you find that no matter how much you ask it still isn't followed correctly?

Then this mod is for you! When a user makes a new thread they're most likely not going to go around reading all the rules before they do so (we can still hope, can't we?) but if a chunk of text appears right where they're typing they're bound to stop their fingers and open their eyes!

Features:

• Fully phrased allowing for translations and multiple languages.
• Instances! Allows for simple configuration amongst multiple forums with the same message(s).
• Robust! If you delete a message any instances that used it will default to no bound message. Prevents errors without hindering usage.
• An "override" setting allows for your message to populate the editor even if other text already exists in there.
• Auto-delete / replace message(s) on post creation or, with javascript, in the editor itself with your own custom content.
• Extensive message customization. Specify additional customizable content before and / or after message(s).

-----

Installation requires FTP access for the ACP options and navigation. Upload all files first then import the product.

Support:
Support will not be provided for vBulletin 4 Alpha, Beta or RC versions.
Low priority will be given to posters who do not have this marked as installed
In some cases, support can only be provided if I have an admin login and ftp access.

Changelog:

• v1.0.0
  • Initial Release
• v1.1.0
  • Feature: Auto-delete messages on post creation. Both text before and after the message(s) will remain.
  • Feature: Setting and phrase to replace deleted messages with specific text. BBCode is allowed and, if your settings allow it, HTML is allowed.
  • Feature: Phrase-able text on message quote tag. Let's your users know what exactly this message is.
  • Feature: Settings link added in the ACP navigation tab for easy access.
    
  • Change: Submit button text changed from edit to save when editing an instance or message.
• v1.2.0
  • Feature: Auto-delete messages using javascript (immediately on editor focus).
    
  • Feature: Phrase-able text before and after notices without disrupting auto-delete / replace.
    
  • Feature: Expanded options for auto-delete / replace. Allows for never, always, only with javascript, only with post submission.

Notes:
See Mr. Running's post for screenshots on how to remove message wrap-arounds.

[GKPet]

Originally Posted by Pandemikk

Three requests for the same feature just hours after release? How can I say no now?

Looking forward to the update, rated 5 stars ;D

[In Omnibus]

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT messageid, title, active FROM vb_pan_dem_messages
ORDER BY dateline DESC;

MySQL Error : Table 'rhens1.vb_pan_dem_messages' doesn't exist
Error Number : 1146
Request Date : Thursday, April 5th 2012 @ 07:36:02 AM
Error Date : Thursday, April 5th 2012 @ 07:36:02 AM
Script : http://www.prosportsinteractive.net/...=modifymessage
Referrer : http://www.prosportsinteractive.net/...dex.php?do=nav
IP Address : 24.94.41.199
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.92-log

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT
instance.instanceid, instance.title, instance.messageid, instance.displayorder,
message.title AS message_title, message.active,
forum.title AS forum_title
FROM vb_pan_dem_instances AS instance
LEFT JOIN vb_pan_dem_messages AS message USING(messageid)
LEFT JOIN vb_forum AS forum USING(forumid)
ORDER BY instance.displayorder ASC;

MySQL Error : Table 'rhens1.vb_pan_dem_instances' doesn't exist
Error Number : 1146
Request Date : Thursday, April 5th 2012 @ 07:33:46 AM
Error Date : Thursday, April 5th 2012 @ 07:33:47 AM
Script : http://www.prosportsinteractive.net/...modifyinstance
Referrer : http://www.prosportsinteractive.net/...dex.php?do=nav
IP Address : 24.94.41.199
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.92-log

[Pandemikk]

Originally Posted by ProSportsForums

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT messageid, title, active FROM vb_pan_dem_messages
ORDER BY dateline DESC;

MySQL Error : Table 'rhens1.vb_pan_dem_messages' doesn't exist
Error Number : 1146
Request Date : Thursday, April 5th 2012 @ 07:36:02 AM
Error Date : Thursday, April 5th 2012 @ 07:36:02 AM
Script : http://www.prosportsinteractive.net/...=modifymessage
Referrer : http://www.prosportsinteractive.net/...dex.php?do=nav
IP Address : 24.94.41.199
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.92-log

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT
instance.instanceid, instance.title, instance.messageid, instance.displayorder,
message.title AS message_title, message.active,
forum.title AS forum_title
FROM vb_pan_dem_instances AS instance
LEFT JOIN vb_pan_dem_messages AS message USING(messageid)
LEFT JOIN vb_forum AS forum USING(forumid)
ORDER BY instance.displayorder ASC;

MySQL Error : Table 'rhens1.vb_pan_dem_instances' doesn't exist
Error Number : 1146
Request Date : Thursday, April 5th 2012 @ 07:33:46 AM
Error Date : Thursday, April 5th 2012 @ 07:33:47 AM
Script : http://www.prosportsinteractive.net/...modifyinstance
Referrer : http://www.prosportsinteractive.net/...dex.php?do=nav
IP Address : 24.94.41.199
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.92-log

Looks like the install file didn't create the tables. Verify you have create access to your database then uninstall and reinstall the product. If that fails, you can run the query directly yourself. Sadly, I am unable to do anything about this because I cannot control your database permissions.

[Pandemikk]

v1.1.0 Released! Addresses all requests made so far. Included is the surprisingly popular auto-deleted message setting. I've decided to take it a step further and also given the ability to replace the message with your own custom text!

Thanks for all those who've rated and installed.

[Mr_Running]

Originally Posted by Pandemikk

Not sure what you mean by this. You mean the message is showing not in the editor but in the title? That makes no sense. What version of vB are you using and do you have any other products / plugins enabled that may be interfering with this?

Yes, it was in the title...It was kind of neat...do people still say neat. LOL

I am on 4.1.11 p1
I thought it might have been dbtech Post Template

I think it's sorted I have cleared caches and it appears my host may have been updating stuff on their end.

Request: Display without BBcode

[Quote]

and maybe when you start typing the message disappears.

[Pandemikk]

Originally Posted by Mr_Running

Yes, it was in the title...It was kind of neat...do people still say neat. LOL

I am on 4.1.11 p1
I thought it might have been dbtech Post Template

I think it's sorted I have cleared caches and it appears my host may have been updating stuff on their end.

Request: Display without BBcode [ quote ]and maybe when you start typing the message disappears.

That's one patch level away from my dev. Glad you have got it sorted.

The problem with removing the BBCode is it becomes much harder to find out which text to delete / replace. I suppose I could query the database for the message(s) and do it that way, though. I'll look into it.

As for typing and the message disappears, that's going to be difficult methinks (beat you on things people don't say anymore) but, again, I'll look into it.

[Mr_Running]

Okay, Looking forward to what comes up...
Yes, I was kind of thinking of having it as a act as placeholder but on key down / mouse click cursor appears and message disappears.

Cursor in place and then we start typing like a mad man.

[GKPet]

Originally Posted by Pandemikk

v1.1.0 Released! Addresses all requests made so far. Included is the surprisingly popular auto-deleted message setting. I've decided to take it a step further and also given the ability to replace the message with your own custom text!

Thanks for all those who've rated and installed.

This is by far the most useful mod that I've seen during the entire month xD

[In Omnibus]

Originally Posted by Pandemikk

Looks like the install file didn't create the tables. Verify you have create access to your database then uninstall and reinstall the product. If that fails, you can run the query directly yourself. Sadly, I am unable to do anything about this because I cannot control your database permissions.

The tables were created in the database. It simply isn't reading them.

Could be a compatibility issue with vBSEO ... I'll do some digging.
I like this mod and hope to get it working.

[Pandemikk]

Originally Posted by ProSportsForums

The tables were created in the database. It simply isn't reading them.

Could be a compatibility issue with vBSEO ... I'll do some digging.
I like this mod and hope to get it working.

That makes zero sense. Have you tried using that query directly in phpmyadmin or some sort?