vb.org Archive - user favorites smilies

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - user favorites smilies (https://vborg.vbsupport.ru/showthread.php?t=66775)

I just installed this on a 3.0.6. and it works quite nicely once you add the modification amykhar added to it. I did run into one snag though and I was wondering someone out there could help me sort it out.

As it is currently, when I attempt to remove all my selected favorites, rather than go back to the default smiley set, it causes an error and refuses to remove the last smiley. I want people to be able to go back to the default if they decide they don't want to use favorites.

The only way I'm able to reset it back to default currently is to go into the user table and manually take out the data... which is a bit of a pain obviously.

The error I'm getting is:

Warning: implode(): Bad arguments. in /misc.php on line 505

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE user SET smilie= WHERE userid='1'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1

mysql error number: 1064

Line 505 looks like this currently:

PHP Code:


		
			
 $query =$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET smilie=" . implode(",", $nabn) . " WHERE userid='$uid'");

Does anyone have any suggestions? I'd really appreciate any help someone could give. :nervous:

My users would love this...we also have a rather large smilie list...but I'm recieving the same error as Kali...I am recieving a database error when trying to remove all my favourites, which I would like to see fixed.

Also, how can I have it so that the [more] smilies link is still visible even after my members choose favourites? I'd also like to have a favourites link in quick reply, if that's possible. Does anyone know how?

Thanks for the mod Amy :)

Installed this hack and lovin it.

Referring to a response from above about the 600 smilies..

It kinda has to list them all for them to select their favorites doesn't it? ;)

Ok, it works fine in the sense that my Favourites are actually working, BUT how do i get the "more" link back under favourites? im a bit of a n00b :)

Worked fine. But not on smilies on quick reply! :(

is there any way that we can get the more smiliey link back along with the fav smiliey link? Mine disappeared after selecting favorites.

Has anyone figured out how to have it so that the [more] smilies link is still visible even after we chose our favourites? Otherwise, we can't get to the rest of our smilies anymore! This is a great idea for a hack...but we definitely need the [more] smilies link back!

Change "vbcode_smilies_editfav" to the following:

Code:

<tr>

  <td class="smallfont" colspan="$vboptions[smcolumns]" align="center" style="border-width:0px; border-style:inset" title="$vbphrase[favorites_smilies]">[<a target="_blank" href="misc.php?do=getfavsmilie">$vbphrase[favorites]</a>]</td>

  <tr><td></td></tr>

  <td class="smallfont" colspan="$vboptions[smcolumns]" align="center" style="border-width:0px; border-style:inset">[<a href="#" onclick="open_smilie_window(smiliewindow_x, smiliewindow_y, $wysiwyg, '$forumid'); return false" title="<phrase 1="$vboptions[smtotal]" 2="$totalsmilies">$vbphrase[showing_x_smilies_of_y_total]</phrase>">$vbphrase[more]</a>]</td>

</tr>

Replace the table in editor_smiliebox with the following:

Code:

<table cellpadding="4" cellspacing="0" border="0" align="center">

        $smiliebits

        $vbcode_smilies_editfav

        <if condition="$show['moresmilieslink']">

        <tr>

<if condition="$bbuserinfo['smilie']==''">

<td class="smallfont" colspan="$vboptions[smcolumns]" title="$vbphrase[favorites_smilies]">

[<a target="_blank" href="misc.php?do=getfavsmilie">$vbphrase[favorites]</a>]

</td></tr>

<tr><td></td></tr>

<tr>

                <td class="smallfont" colspan="$vboptions[smcolumns]">[<a href="#" onclick="open_smilie_window(smiliewindow_x, smiliewindow_y, $wysiwyg, '$forumid'); return false" title="<phrase 1="$vboptions[smtotal]" 2="$totalsmilies">$vbphrase[showing_x_smilies_of_y_total]</phrase>">$vbphrase[more]</a>]</td>

        </tr>

</if>

        </if>

        </table>

It seems to work for me. YMMV :up:

Quote:

Originally Posted by Melker

It seems to work for me. YMMV :up:

WOOHOO!!! Works for me too!!!

Thanks so much Melker!!! You are awesome!!! :D

I noticed that there was some issues with the option [More] showing up twice if there was more fav smilies selected than was allowed in the smiliebox. I fixed it by moving the following portion in the editor_smilebox inside the second set of <if></if>.

Code:

<tr>

                <td class="smallfont" colspan="$vboptions[smcolumns]">[<a href="#" onclick="open_smilie_window(smiliewindow_x, smiliewindow_y, $wysiwyg, '$forumid'); return false" title="<phrase 1="$vboptions[smtotal]" 2="$totalsmilies">$vbphrase[showing_x_smilies_of_y_total]</phrase>">$vbphrase[more]</a>]</td>

        </tr>

I have tried several ways and it seems to works perfectly now. Please see my earlier post for the updated information.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01194 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: