"Random Post Icon" possible?

[Dorign]

Hmm, maybe I did something wrong, but..

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT iconid FROM icon;

MySQL Error  : Table doesn't exist
Error Number : 1146

EDIT: Oh, I got that because I'm a n00b and didn't even read the code. :P Fixed it, and it's working great! Thanks a ton, sunilvarma!

What would be the benefits of waiting for a code that doesn't use a query? A better load time of .002 seconds, or better than that? I don't really notice any slow down, but my server is kinda slow anyway.

--------------- Added [DATE]1205449134[/DATE] at [TIME]1205449134[/TIME] ---------------

Ah, crap, found a bug.

ALL the icons are random. Even if I pick one, it still is a random icon.

[sunilvarma]

Sorry Dorign, was in a hurry and couldn't really test it.

Now I fixed it and it should work. Just use the updated code in my first post.

Let me know if you have any issues.

[Dorign]

Worked like a charm. I don't know how many people would use this, but I'd click "Install" if you made it a release.

Thank you a million times over!

[sunilvarma]

I am looking at how to turn this into a plugin and if it materializes I would definitely release it!

[Dismounted]

Just hook into a newthread hook and change the values dynamically.