End-User Options - Lucky Button

Lucky Button

This hack redirects the user to a various thread when they click "Lucky" button on the navbar. This is like Google's lucky button. Let's see what is your lucky subject.
install

Go to your admin cp, then:
Plugin System -> Manage Products -> [Add/Import Product] -> Select 'product-lucky.xml' from your computer then press 'Import'

Modifications Info

Plugin : 3
Phrases : 1
Template : 1
Setting : 0

Versions:
v1.0 - 22 Octaber 2007
-First release

v1.1 - 28 Octaber 2007
- Query error fixed
- Setting Added
- Usergroup permisson added
- Disallow forum ID added
- Forum permisson added
- On/Off added

Mark as Installed - Nominate for MOTM


Manuel Template Change

Open navbar template

vbphrase[faq]</a></td>

add below

<td class="vbmenu_control"><a href="misc.php?do=lucky">$vbphrase[lucky]</a></td>

[edytwinky]

Originally Posted by chickadee

Installed, but I keep getting a database error:

Invalid SQL:
SELECT thread.threadid, thread.dateline, thread.visible FROM vbthread WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' ORDER BY RAND() LIMIT 1;

MySQL Error : Unknown column 'thread.threadid' in 'field list'
Error Number : 1054

I get this same error now too

[Peejay]

I'm getting the following error;

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT threadid, dateline, visible FROM vb_thread WHERE NOT ISNULL(threadid) AND visible = '1' AND thread.forumid NOT IN (0) ORDER BY RAND() LIMIT 1;

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Sunday, June 28th 2009 @ 12:51:22 PM
Script : http://clubaristo.net/forums/misc.php?do=lucky
Referrer : http://clubaristo.net/forums/forums.php

Any ideas?

[deadlySniper]

Haha, awesome! Thanks!

[Peejay]

OK, found the issue in the xml file and corrected it.

Look for thread.forumid and edit to read vb_thread.forumid and then reimport the file.