Random Smilies in box on New Thread/Reply

Ok first, 100% of the credit for this goes to FireFly aka Chen

I had requested this and he answered. I have tested this on 2.2.0 through 2.2.5 and with vbPortal and it has worked great. This was my original question:

Here's one that I'm not even sure how easy/hard it is. One of my members wanted to have it so when you click to reply to a thread, the smilies box on the left will have random ones from your total collection so that they would be encouraged to use different smilies and not have to click the get more button. I would love this hack as increasing the number of smilies in that box breaks my table border so I had to only allow 18 smilies in that box vs. 30

I posted this here so I could have it on my install list and for anyone else wanting this.

The file you edit is admin/functions.php

Replace:

if ($smtotal > 0) {

		$smilies = $DB_site->query("SELECT title, smilietext, smiliepath FROM smilie");

With this:

if ($smtotal > 0) {

		$smilies = $DB_site->query("SELECT title, smilietext, smiliepath FROM smilie ORDER BY RAND()");

Once again, my thanks to FireFly and all the Hackers!

[Admin]

Yes.

[Mental Stamina]

i have the same error Rose posted

[Mental Stamina]

i removed the code addition from the page
and i still get

Parse error: parse error in /home/lyricoly/public_html/boards/admin/functions.php on line 811

Fatal error: Call to undefined function: vbsetcookie() in /home/lyricoly/public_html/boards/admin/sessions.php on line 181

immediate help needed
thanx

[FleaBag]

Very simple and very effective! Installed on 2.2.5. Encourages my users to use a range of smilies!

[DelusionalMind]

Originally posted by GamerForums
Very simple and very effective! Installed on 2.2.5. Encourages my users to use a range of smilies!

i installed this on 2.2.5 also and it doesn't work. I get a databse error. What gives?? And this has happened for a few hacks now....is 2.2.5 just so incampatible with hacks??

[Admin]

What's the database error, Delusional?

[JTMON]

Originally posted by DelusionalMind

i installed this on 2.2.5 also and it doesn't work. I get a databse error. What gives?? And this has happened for a few hacks now....is 2.2.5 just so incampatible with hacks??

yes what is the error as I have it working on 2.2.5 and actually just updated the first post in this thread cause I tested/used it on 2.2.0-2.2.5 with no problems so far and I also have other hacks

[DelusionalMind]

Database error in vBulletin 2.2.5:

Invalid SQL: SELECT title, smilietext, smiliepath FROM smilie ORDER BY rand()
mysql error: You have an error in your SQL syntax near 'rand()' at line 1

mysql error number: 1064

that's the error...i double clicked on your code box and put it directly in...this even happened after a clean install...

[DelusionalMind]

^bump^

can anyone help?

[FleaBag]

Working on 2.2.6, thanks!