I tried again and had the error:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT threadid, dateline, visible FROM xxxthread WHERE NOT ISNULL(threadid) AND visible = '1' AND thread.forumid NOT IN (9,10,12,16,17,18,22,25,29,30,32,34,37,39,43,46,55 ,17,18,29,30) ORDER BY RAND() LIMIT 1;
MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Request Date : Friday, June 12th 2009 @ 09:59:38 PM
Error Date : Friday, June 12th 2009 @ 09:59:38 PM
Script : http://forums.xxx.com/misc.php?do=lucky
Referrer :
IP Address : 68.102.23.100
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.77-community
In the new xml file I edited it to add my forumid and usergroupid numbers:
<?xml version="1.0" encoding="ISO-8859-1"?>
<product productid="lucky" active="1">
<title>Lucky Thread</title>
<description>http://www.tvpano.com/</description>
<version>2.0.0</version>
<url>http://www.tvpano.com/</url>
<versioncheckurl />
<apm_releasedate>1223787600</apm_releasedate>
<apm_author>H.Atakan KOC</apm_author>
<apm_relatedurl />
<apm_extrainfo>http://www.tvpano.com/</apm_extrainfo>
<apm_extraedit />
<dependencies>
</dependencies>
<codes>
</codes>
<templates>
<template name="lucky" templatetype="template" date="1223831611" username="admin" version=""><![CDATA[<td class="vbmenu_control"><a href="misc.php?do=lucky">$vbphrase[lucky]</a></td>]]></template>
</templates>
<plugins>
<plugin active="1" executionorder="5">
<title>Lucky</title>
<hookname>admin_options_processing</hookname>
<phpcode><![CDATA[if (is_array($vbulletin->GPC['setting']['lucky_group']))
{
$vbulletin->GPC['setting']['lucky_group'] = implode(',', $vbulletin->GPC['setting']['lucky_group']);
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>luck</title>
<hookname>cache_templates</hookname>
<phpcode><![CDATA[$globaltemplates[] = 'lucky';]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>lucky</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[if ($vbulletin->options['lucky_onoff'])
{
$wol_can_view = is_member_of($vbulletin->userinfo,explode(',',$vbulletin->options['lucky_group'])) ? true : false;
if ($wol_can_view)
{
$search_text = "vbphrase[faq]</a></td>";
$vbulletin->templatecache['navbar'] = str_replace($search_text,$search_text.fetch_templa te('lucky'),$vbulletin->templatecache['navbar']);
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Lucky</title>
<hookname>misc_start</hookname>
<phpcode><![CDATA[if ($_REQUEST['do'] == 'lucky')
{
if ($vbulletin->options['lucky_onoff'])
{
$wol_can_view = is_member_of($vbulletin->userinfo,explode(',',$vbulletin->options['lucky_group'])) ? true : false;
if ($wol_can_view)
{
$excludedforums = '';
if ($vbulletin->options['lucky_forum'] !== '') {
$excludedforums = ',' . $vbulletin->options['lucky_forum'];
}
$forumpermissions = array();
foreach($vbulletin->forumcache AS $forum) {
$forumpermissions[$forum["forumid"]] = fetch_permissions($forum['forumid']);
if (!($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) {
$excludedforums = $excludedforums . ',' . $forum['forumid'];
}
}
unset($forum);
// get rid of initial comma
$excludedforums = substr($excludedforums, 1);
if ($excludedforums != "9,10,12,16,17,18,22,25,29,30,32,34,37,39,43,46,55") {
$excludedforums = "AND thread.forumid NOT IN ($excludedforums)";
}
$lucky_threads = $db->query_first("SELECT threadid, dateline, visible FROM " . TABLE_PREFIX . "thread WHERE NOT ISNULL(threadid) AND visible = '1' $excludedforums ORDER BY RAND() LIMIT 1");
header('Location: showthread.php?t='.$lucky_threads['threadid']);
}
}
}]]></phpcode>
</plugin>
<plugin active="1">
<title>save our multiselect values</title>
<hookname>admin_options_processing</hookname>
<phpcode><![CDATA[
if (preg_match ('/checkbox/i', $oldsetting['optioncode']))
{
if (is_array ($settings["$oldsetting[varname]"])) $settings["$oldsetting[varname]"] = implode (',', $settings["$oldsetting[varname]"]);
}]]></phpcode>
</plugin>
</plugins>
<phrases>
<phrasetype name="GLOBAL" fieldname="global">
<phrase name="lucky" date="1198165457" username="Administrator" version=""><![CDATA[Lucky Thread]]></phrase>
</phrasetype>
<phrasetype name="vBulletin Settings" fieldname="vbsettings">
<phrase name="setting_lucky_forum_desc" date="1198165624" username="Administrator" version="1.2.0"><![CDATA[Sparate Forum ID by Comma]]></phrase>
<phrase name="setting_lucky_forum_title" date="1198165624" username="Administrator" version="1.2.0"><![CDATA[Disallow Forum ID]]></phrase>
<phrase name="setting_lucky_group_desc" date="1198165624" username="Administrator" version="1.2.0"><![CDATA[Select The Usergroups]]></phrase>
<phrase name="setting_lucky_group_title" date="1198165624" username="Administrator" version="1.2.0"><![CDATA[Display UserGroup IDs]]></phrase>
<phrase name="setting_lucky_onoff_desc" date="1198165646" username="Administrator" version="1.2.0"><![CDATA[This setting allows you to enable/disable the Lucky Thread.]]></phrase>
<phrase name="setting_lucky_onoff_title" date="1198165646" username="Administrator" version="1.2.0"><![CDATA[Enable the Lucky Thread]]></phrase>
<phrase name="settinggroup_luckyset" date="1198165624" username="Administrator" version="1.2.0"><![CDATA[Lucky Thread]]></phrase>
</phrasetype>
</phrases>
<options>
<settinggroup name="luckyset" displayorder="65535">
<setting varname="lucky_onoff" displayorder="10">
<datatype>boolean</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="lucky_group" displayorder="20">
<datatype>free</datatype>
<optioncode><![CDATA[" . eval('$options = "";
foreach($vbulletin->usergroupcache AS $usergroupid => $usergroup)
{
$options .= "\\t\\t<label for=\\"setting[$setting[varname]]$usergroupid\\" title=\\"usergroupid: $usergroupid\\"><input type=\\"checkbox\\" tabindex=\\"1\\" name=\\"setting[$setting[varname]]"."[]\\" id=\\"setting[$setting[varname]]$usergroupid\\" value=\\"$usergroupid\\"" . iif(strpos(",$setting[value],", ",$usergroupid,") !== false, \' checked="checked"\') . iif($vbulletin->debug, " title=\\"name="setting[$setting[varname]]"\\"") . " />$usergroup[title]</label><br />\\n";
}
return "<span class=\\"smallfont\\">\\n$options\\t</span>";') . "]]></optioncode>
<defaultvalue>6,28,29,32</defaultvalue>
</setting>
<setting varname="lucky_forum" displayorder="30">
<datatype>free</datatype>
<defaultvalue>0</defaultvalue>
</setting>
</settinggroup>
</options>
<helptopics>
</helptopics>
<cronentries>
</cronentries>
<faqentries>
</faqentries>
</product>