Major Additions - MySmilies vB (v3.8.0)

Please click Mark as Installed if you are using this hack, and Nominate For MOTM or Support Developer if you enjoy this hack and would like to support it's development.
.

Please read the entire thread before posting your problem, chances are it's been fixed.

Those who have "Mark As Installed" will receive priority support


NOTE: I have marked this hack as Re-usable Code - This means that code from this hack may be used in other hacks, which can ONLY be released on official vB sites that use Jelsoft's verification system to verify your vBulletin license status, and as long as Kentaurus, Mosh, and I (SecondV) are credited in your hack.

This is a port of Mosh's MySmilies VB for v3.7.x to work with vBulletin v3.8.0.
Mosh's was a port of Kentaurus's MySmilies VB for v3.6.x (version 1.03) to work with vBulletin v3.7.0.


vBulletin Version Compatibility & Permission Info

This hack was tested on vB 3.8.x - but it should work on vB 3.7.0 and later.

Permission for me to port his hack is granted here:

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

And here:

NOTE: I have marked this hack as Re-usable Code - This means that code from this hack may be used in other hacks, which can ONLY be released on official vB sites that use Jelsoft's verification system to verify your vBulletin license status, and as long as Kentaurus and I are credited in your hack.

What Does This Hack Do?

This hack puts the control of the smilies on the users. It lets any user (that you give permission to) upload or modify the smilies that he can use.

These are not the smilies that vb uses, these are user-customized smilies. The smilies that you already have in place are preserved and are still used. But users may upload their own smilies for their use, and they are kept separate from the standard forum smilies.

For users:

• Users can keep a library of their own smilies (they can upload them from their computer or web)
• Users enter their replacement text, for example, :iamhappy: would be changed to their own user happy smilie
• The custom smilies are parsed in any post, signature, or pm
• If they have enabled the WYSIWYG editor, smilies are shown there

For administrators:

• Usergroup control of who may upload custom smilies
• Usergroup control of the size (width, height, size in bytes) of the smilie
• Smilie quota, both for max number of smilies and max number of bytes or hard disk space
• The administrator can choose where to save the smilies (the directory, default: mysmiliesvb)
• Auto-template Injection - if the appropriate template hooks are available, you will not need to make any template edits at all, if edits needed you only need to paste a single variable where you need it

Installation Instructions

See the included Installation Instructions.txt file in the sv_mysmiliesvb.zip zip file.

ADDITIONAL NOTE:
A limitation exists with the fix that rectifies the problem of attachments showing when also posting them inline within the same post; when applied, all attachments will need to be displayed inline, if they have not been, then the ones that have not been posted inline will be hidden along with the ones that have been posted inline. Read Post #106 for more information on this. -- I'm working on this



Uninstall Instructions

1. Delete mysmiliesvb.php from your forum's root directory.
2. Delete the mysmiliesvb directory from your forum's root directory.
3. Delete class_dm_mysmiliesvb.php from your forum's /includes directory.
4. Delete bitfield_mysmiliesvb.xml from your forum's /includes/xml directory.
5. Delete delete.gif from your forum's /images/misc directory (if more than one style remember to delete it from all misc directories).
6. Optional Step: This step is only if the auto template injection does not work, and you did the optional template edits.
   
   In the USERCP_SHELL template, find and delete:
   
   PHP Code:

   $mysmilie_usercp 

   In the navbar template, find and delete:
   
   PHP Code:

   $mysmilie_navbar 

7. Uninstall the product in vB using the AdminCP Product Manager.

To Do List

Features are being done in the order that they appear on the list.

1. Admin Control Panel utility to view/delete one, some or all custom smilies
2. Add custom user smilies to the misc.php?do=showsmilies page and to the "More Smilies" popup.

Version History
v3.8.005 - June 23rd, 2011
-- Fixed: "Warning: Invalid argument supplied for foreach()" errors.
-- Changed: how the smilie datastore cache is generated/accessed.
-- Added: Option to pull all user smilies for the editor or just the current user id's smilies.

v3.8.004 - January 15th, 2010
-- Changed: query() calls were being used instead of query_read()
-- Changed: Smilies are now built and added to datastore cache
-- Changed: Since smilies are stored in the datastore, smilies are no longer queried/parsed by userid.
-- Fixed: Custom smilies not parsed when quoted by other users.
-- Added: /includes/functions_mysmiliesvb.php - build_mysmilies_datastore() function.

v3.8.003 - August 5th, 2009
-- Fixed: Ok, should finally be fixed on upgrade - no more parse errors.
-- Fixed: Those upgrading from Mosh's version should be fine now.

v3.8.002 - August 4th, 2009
-- Fixed: errors when upgrading from previous versions of MySMilies should be fixed.

v3.8.001 - August 4th, 2009
-- Initial v3.8.0 release - mod taken over by Eric Sizemore (SecondV)
-- Fixed: standard_error calls were not using eval() as they should be
-- Fixed: Some queries were not using TABLE_PREFIX
-- Fixed: Even though phrases were in place, some parts of the mod used hardcoded langauge strings.
-- Fixed: Some errors in templates, missing ending tags, etc.
-- Fixed: Upload - the upload source didn't appear to be detected properly.
-- Changed: "maxversion" in the product XML increased.
-- Changed: "hard delete" option no longer on by default.
-- Changed: The "mysmiliesvb" table was altered to have KEY's on the "userid" and "dateline" columns. Hopefully this will increase performance/smilie lookups.



Thanks

My thanks go out to Kentaurus (who originally created this fantastic hack), Mosh who updated the hack to v3.7, and Paul M who gave permission to use some of his install code.



Show Your Appreciation

Although not required, if you have enjoyed the benefits of this hack, and would like to show your appreciation for my efforts, then please feel free to click on the Support Developer link and donate any amount you feel is appropriate. This would go a long way in encouraging me to continue to develop this project, as I'm currently unemployed.

----

Because of the limitations on screenshots in place by vBulletin.org (can only upload 10) - you can view the screenshots here:

... coming again soon ...

[mrpaint]

Originally Posted by SecondV

Updated to 3.8.004:

v3.8.004 - January 15th, 2010
...
-- Fixed: Custom smilies not parsed when quoted by other users.
...

You mean smilies are now being parsed in quotes?

[Eric]

Originally Posted by mrpaint

You mean smilies are now being parsed in quotes?

Yes.

[mrpaint]

Originally Posted by SecondV

Yes.

Very cool. Thank you

[Jman423]

Thank you for updating this. I will be updating my installation shortly.

[choccyclaire]

Thanks for the update.

[choccyclaire]

I receive this db error when trying to upgrade. (I have uploaded and overwritten all other files)

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE mysmiliesvb ADD KEY userid (userid);

MySQL Error   : Duplicate key name 'userid'
Error Number  : 1061
Request Date  : Friday, January 15th 2010 @ 07:26:08 PM
Error Date    : Friday, January 15th 2010 @ 07:26:08 PM
Script        : http://www.xxx/admincp/plugin.php?do=productimport
Referrer      : http://www.xxx/admincp/plugin.php?do=productadd
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.87-community-log

[Megatr0n]

Great upgrade but why do the user's personal smilies now appear under the custom row of smilies?

Any way of avoiding this?

[Eric]

Originally Posted by Megatr0n

Great upgrade but why do the user's personal smilies now appear under the custom row of smilies?

Any way of avoiding this?

Screenshot?

As the changelog states, when parsing/pulling smilies, it no longer checks by userid. So it now parses smilies that have been quoted/etc. One downside to this (if you see it that way), is that if another user knows the smiley code, they can use the smiley (which IMHO, should be the way this mod works - why not let a user add a smilie that they can use, but others can as well if they like it? )

Originally Posted by choccyclaire

I receive this db error when trying to upgrade. (I have uploaded and overwritten all other files)

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE mysmiliesvb ADD KEY userid (userid);

MySQL Error   : Duplicate key name 'userid'
Error Number  : 1061
Request Date  : Friday, January 15th 2010 @ 07:26:08 PM
Error Date    : Friday, January 15th 2010 @ 07:26:08 PM
Script        : http://www.xxx/admincp/plugin.php?do=productimport
Referrer      : http://www.xxx/admincp/plugin.php?do=productadd
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.87-community-log

What version of the mod were you using before the upgrade? The only reason that code should run during install is if you're using a version prior to 3.8.001, in which case, there should not be a KEY on userid for the mysmiliesvb table.

[Megatr0n]

See attachment.

It sort of stretches our editor and I don't like it doing that.

Anyway arounnd this?

[choccyclaire]

Originally Posted by SecondV

What version of the mod were you using before the upgrade? The only reason that code should run during install is if you're using a version prior to 3.8.001, in which case, there should not be a KEY on userid for the mysmiliesvb table.

Yes, I have that version. Is there a solution for me?