[TyleR]

thanks for that, but it couldnt be added by a hook, i actually had to add it to includes/class_dm_forum.php

But, everything else is sorted, now i get this:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT userid FROM lockdown_install WHERE threadid=1 AND userid=Array[userid];

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '[userid]' at line 1
Error Number : 1064
Date         : Monday, November 28th 2005 @ 01:59:14 PM
Script       : /dev/showthread.php?p=1
Referrer     : /dev/index.php?
IP Address   : xx.xx.xx.xx
Username     : TwiSteD
Classname    : vb_database

this is the plugin code thats causing the error:

PHP Code:

if ($foruminfo['hack_poster'] == 1)
    {
        // lets get all the lockdown information from the database for that thread
        $hacks = $db->query_read("
                SELECT *
                FROM " . TABLE_PREFIX . "lockdown
                WHERE threadid = '" . $threadinfo['threadid'] . "'
        ");

        $install_check = '';
        $install_button = '';
        $hack_options = '';

        $verif = $db->query_read("SELECT userid FROM ". TABLE_PREFIX ."lockdown_install WHERE threadid=$threadinfo[threadid] AND userid=$vbulletin->userinfo[userid]");

        if ($verif)
        {
            $install_check = true;
        }
        else
        {
            $install_check = false;
        }

        if (($foruminfo['hack_poster_private'] == 1) AND ($verif))
        {
            eval('$install_button = "' . fetch_template('hack_uninstall') . '";');
        }
        else if (($foruminfo['hack_poster_private'] ==1) AND (!$verif))
        {
            eval('$install_button = "' . fetch_template('hack_install') . '";');
        }
        else if ((!$foruminfo['hack_poster_private'] ==1) AND ($verif))
        {
            $install_button = '';
        }
        else
        {
            eval('$install_button = "' . fetch_template('hack_install') . '";');
        }

        if(!$hacks['dateline'])
        {
            $hacks['postdate'] = '';
            $hacks['posttime'] = '';
        }
        else
        {
            $hacks['postdate'] = vbdate($vboptions['dateformat'], $hacks['dateline'], true);
            $hacks['posttime'] = vbdate($vboptions['timeformat'], $hacks['dateline']);
        }

        if(!$hacks['updated'])
        {
            $hacks['update'] = '';
            $hacks['updatetime'] = '';
        }
        else
        {
            $hacks['update'] = vbdate($vboptions['dateformat'], $hacks['updated'], true);
            $hacks['updatetime'] = vbdate($vboptions['timeformat'], $hacks['updated']);
        }

        if (($vbulletin->userinfo['usergroupid'] == 6) || ($vbulletin->userinfo['usergroupid'] == 7) || ($vbulletin->userinfo['usergroupid'] == 5))
        {
            $hack_options = true;
            eval('$hack_options = "' . fetch_template('hack_moderator_options') . '";');
        }
        else
        {
            $hack_options = '';
        } 

    }