End-User Options - Favorite Smilies

This add-on will allow members to create their own favorite smilies list, which can be useful on boards with lots of smilies. If a member creates a list, it will be displayed in place of the normal smilie box.

Maximum number of smilies is based on the 'Smilie Menu Total Smilies' option in 'Message Posting Interface Options'.


Features:

• Edit List in UserCP
• Javascript Enforced Limit
• Ignore Certain Smilie Categories
• Allow/Disallow usage based on usergroup
• Admin CP Help

Installation Overview:
Files to Modify: 1
Templates to Modify: 1
Files to Upload: 2
Product:
-Plug-Ins: 6
-Templates: 5
-vB Options: 4
-Phrases: 29

NOTICE: If you're upgrading to version 1.0.4 from a previous version, please read the 'Upgrade.htm' file. Otherwise, read the 'Install_3.6.0.htm' for vBulletin 3.6.0 installations or 'Install_3.6.1.htm' file for vBulletin 3.6.1 or newer installations for the installation procedure.

Version History:
1.0.5 - Fixed vulnerability.
1.0.4 - Added smilie selection count under smilie selection menu. One less template to edit.
1.0.3 - Added option to hide smilie titles on the selection menu (for boards with a very large number of smilies). Icon link to edit the list on the editor toolbar. Admin CP help text. Improved integration with the UserCP. One less file to edit. Fixed some text that wasn't phrased.
1.0.2 - Added option to limit who can use the Favorite Smilies listed based on usergroup permissions. Changed smilie selection page to include category names. Fixed Missing 'More' link in Smilie dropdown menu.
1.0.1 - Fixed problem with missing table prefixes.
1.0.0 - Initial release.

A version for 3.5 can be found Here
A version for 3.7 can be found Here

[43082448]

$vbulletin->db->query("ALTER TABLE user ADD favsmilies TEXT NOT NULL");

==>

$vbulletin->db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD favsmilies TEXT NOT NULL");

[Darwinist]

Originally Posted by Sooner95

welp, ok.. pretty pissed here.

Hack didnt work..ok NP. Yes, when i remove the steps, now my BBS is hosed. I understand that in the title it days 3.6, but would be nice if it Stated that it worked in ONLY 3.6

When the description states 3.6, best bet is to assume it's for 3.6 only unless told otherwise. You could've asked...

Originally Posted by Sooner95

error



for those that care. I am continuing to find a fix for this, as my board is crap now.

You didn't revert the code in 'functions_editor.php'. Change 'query_read_slave' to 'query_read'.

I've posted a version that will work in 3.5 Here.

Originally Posted by webwench

When I try to install this, I get a database error:

The table of course should be vb_user, but I don't know what to change to make this install. Can anyone help?

Install code fixed.

[webwench]

Originally Posted by 43082448

$vbulletin->db->query("ALTER TABLE user ADD favsmilies TEXT NOT NULL");

==>

$vbulletin->db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD favsmilies TEXT NOT NULL");

And if so, could you please explain? Thanks

[Darwinist]

Originally Posted by webwench

And if so, could you please explain? Thanks

Just download the updated files and reinstall... in contains the fixes.

[kvnband]

Weird. I installed but when I try to set my favorite smilies, I get this error

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET favsmilies='212' WHERE userid='1';

MySQL Error  : Unknown column 'favsmilies' in 'field list'
Error Number : 1054
Date         : Sunday, August 6th 2006 @ 12:07:17 PM
Script       : http://www.secondwivesclub.com/portal/forum/misc.php
Referrer     : http://www.secondwivesclub.com/portal/forum/misc.php?do=editfavsmilies
IP Address   : 70.173.100.38
Username     : admin
Classname    : vB_Database

I checked in phpmyadmin and the column does indeed exist. Any idea what the deal is?

[kvnband]

You have problems in the product.

Line 143 should be changed from

$db->query("UPDATE user SET favsmilies='$favsmilies' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");

to

$db->query("UPDATE " . TABLE_PREFIX . "user SET favsmilies='$favsmilies' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");

and line 126 should be changed from

$db->query("UPDATE user SET favsmilies='' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");

to

$db->query("UPDATE " . TABLE_PREFIX . "user SET favsmilies='' WHERE userid='" . $vbulletin->userinfo['userid'] . "'");

Kevin

[Darwinist]

I fixed it this morning... download the script again and reinstall.

[webwench]

Thanks very much!

[GoNz00]

i think i found a bug related, i removed this and deleted bitfield_user_smiley.xml from the xml folder, now i can save usergroups without the following error.

is this related to your product ?

Database error in vBulletin 3.6.0:
Invalid SQL:
UPDATE vb3_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
 `title` = '(COPPA) Users Awaiting Moderation',
 `description` = '',
 `usertitle` = '',
 `opentag` = '',
 `closetag` = '',
 `passwordexpires` = '0',
 `passwordhistory` = '0',
 `forumpermissions` = '131072',
 `attachlimit` = '0',
 `pmquota` = '50',
 `pmpermissions` = '0',
 `pmsendmax` = '0',
 `calendarpermissions` = '32',
 `wolpermissions` = '0',
 `adminpermissions` = '0',
 `genericpermissions` = '0',
 `genericoptions` = '48',
 `profilepicmaxwidth` = '100',
 `profilepicmaxheight` = '100',
 `profilepicmaxsize` = '65535',
 `avatarmaxwidth` = '80',
 `avatarmaxheight` = '80',
 `avatarmaxsize` = '20000',
 `signaturepermissions` = '139263',
 `sigpicmaxwidth` = '500',
 `sigpicmaxheight` = '100',
 `sigpicmaxsize` = '20000',
 `sigmaxrawchars` = '4000',
 `sigmaxchars` = '2000',
 `sigmaxlines` = '0',
 `sigmaxsizebbcode` = '7',
 `sigmaximages` = '30',
 `usmilie_permissions` = '0'
WHERE usergroupid=4;
MySQL Error  : Unknown column 'usmilie_permissions' in 'field list'
Error Number : 1054
Date         : Tuesday, August 8th 2006 @ 09:08:37 AM
Script       : http://www.clandesertrats.co.uk/foru....php?do=update
Referrer     : http://www.clandesertrats.co.uk/foru...&usergroupid=4
IP Address   : 62.253.128.14
Username     : GoNz0
Classname    : vb_database

i tried your updated version as well to no joy

[GoNz00]

bump?