sorry posted by mistake editing the post

Seems to have installed fine. Tested it on a regular member account, and it allowed me to select favorite smilies. However, after submitting my favorites, when I hit the reply button it returns the VB database error. Went back in and cleared the list of favorites, and no database error. Did everything by the book and had no errors on install. Where did I go wrong?

EDIT: OK either I did something wrong (which is more likely), or it doesn't like the Order By rand line, that is what returned the DB error. Used your original code and it works fine. Where might I have gone wrong?

I figured our where I went wrong...typing on one computer while reading from the other...LOL I had a space between rand and ()... I had:

rand ()

Instead of:

rand()

One little space...LMAO.

*Gripemaster clicks Install and says Thank You*

anyone else getting an ncwoodworker.net login prompt when the 1st page of this thread loads?

Thanks for the update. I like the added smilie on the new post/reply... very nice.

I'm being dumb here, I can see the smilies when replying to a post but cant work out how to select them in the control panel, any ideas?

Thanks

Just click on 'edit favorite smilies' and then click the check boxes next to the smilies you want added to your favorites list and click 'save'.

I dont seem to have that in the control panel, as I said I've done something dumb, first time of trying hack though so I thought I'd do two at once :confused:

Confirm you completed step #2 in the install instructions (editing the 'USERCP_SHELL' template). Also confirm that your usergroup permissions have the favorite smilies option set to 'on' (it's on by default, but may have been changed).

All seems to be done but it still isnt there, cant see an option in the user group manager either though?