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