user favorites smilies

Hello Everyone.

hack : user favorites smilies

by All-the-vb

Description:
that's hack allow each member to choose his favorite smiles .. let's discover the other features guyz


Queries to Run: 1
Files to edit: 2
Templates to edit:2
Templates to add:3
new Phrases: 3

if you use this hack don't forgot click

[Kali]

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:

[Moxi]

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?

[Cyricx]

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?

[Bulleh]

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

[Anette]

Worked fine. But not on smilies on quick reply!

[kthlnwrnr]

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

[Pamela]

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!

[Melker]

Change "vbcode_smilies_editfav" to the following:

<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:

<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:

[Pamela]

Originally Posted by Melker

It seems to work for me. YMMV :up:

WOOHOO!!! Works for me too!!!

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

[Melker]

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>.

<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.