Ok i get this error when running a hack.. finally got the other thing to work but this is the error..


Database error in vBulletin 3.0.1:

Invalid SQL: INSERT INTO hacklog (hacklogid, hackid, modname, modtype, linenumber, changetype, userid, oldcode, newcode, dateline, lastmodified, notes) VALUES ('', 3, 'includes/adminfunctions_template.php', 0, 3079, 2, 1, ');', 'if ($_SERVER[\'PHP_SELF\'] == \"/$admincpdir/template.php\")
{
require_once(\'./includes/config_htl.php\');
if ($vboptions[\'htl_use_auto_tgroups\'] == 1)
{
$hack_tgroups = $DB_site->query(\"SELECT groupname, title FROM \" . TABLE_PREFIX . \"hack WHERE (options & \" . HTLSETTING_SHOWTEMPLATEGROUP . \") AND atstep = -1 AND groupname != \'\'\");

while ($tgroup = $DB_site->fetch_array($hack_tgroups))
{
$name = preg_replace(\'/[^a-z]/\', \'\', strtolower($tgroup[\'groupname\']));
$only[$name] = $tgroup[\'title\'];
}
}
}', 1064508412, 1075038411, 'This is all the way at the VERY END of the adminfunctions_template.php file! You just basically add the code at the bottom :)'), ('', 3, 'admincp/index.php', 0, 497, 2, 1, ' // cache nav prefs
can_administer();

construct_nav_spacer();', ' // first we get the config_htl.php file that we need for some of this..
require_once(\'./includes/config_htl.php\');

$thisnav = (!isset($_GET[\'hacksnav\'])) ? \'vb\' : \'hacks\';

construct_nav_option2($vbphrase[\'htl_cphome_refresh_current_menu\'], \'index.php?do=nav\' . iif($thisnav!=\'vb\' AND $vboptions[\'htl_use_dual_nav\'], \'&amp;hacksnav=1\'), \'<br />\');

if ($vboptions[\'htl_use_dual_nav\'])
{
if ($_REQUEST[\'hacksnav\'] == 1)
{
define(\'QUICKSTOP\', true);
$thisnav = \'hacks\';
}
construct_nav_option2(iif($thisnav==\'vb\', $vbphrase[\'htl_cphome_hacks_menu\'], $vbphrase[\'htl_cphome_standard_vb_menu\']),
\'index.php?do=nav\' . iif($thisnav==\'vb\', \'&amp;hacksnav=1\'), \'<br />\');
}

construct_nav_group($vbphrase[\'htl_cphome_menu_navigation\']);
construct_nav_spacer();

if (!$vboptions[\'htl_use_dual_nav\'])
{
// place this line lower in this section to have the hack menu items appear elsewhere
build_hacknavs();
}

if (defined(\'QUICKSTOP\'))
{
build_hacknavs();

print_nav_panel();

echo \"</div>\\n\";
// *************************************************

define(\'NO_CP_COPYRIGHT\', true);
unset($DEVDEBUG);
print_cp_footer();
exit;
}', 0, 1075038411, 'In the new code below, the first occurance of <b><u>build_hacknavs();</u></b> reflects the position in the navpanel where the Hack menu items will appear. If you want them elsewhere, shift the code to your desired location. NOTE: this is only applicable if you <i>don\'t</i> use Dual Navigation.'), ('', 3, 'includes/adminfunctions_navpanel.php', 0, 264, 2, 1, ' <?php

echo $controls . $_NAV . $_controls;
}
', '// ###################### Start makenavoption 2#######################
// similar to the normal one, except it doesn\'t send you to the main frame.
// function granted to the HTL by trafix, copyright (C) trafix
function construct_nav_option2($title, $url, $extra = \'\')
{
global $session, $options;
static $sessionlink;

if (!isset($options))
{
$options = array();
if ($session[\'sessionurl\'] == \'\')
{
$sessionlink = \'\';
}
else
{
$sessionlink = \"&amp;s=$session[sessionhash]\";
}
}

$options[] = \"\\t\\t<div class=\\\"navlink-normal\\\" onclick=\\\"location=\'$url$sessionlink\';\\\" onmouseover=\\\"this.className=\'navlink-hover\';\\\" onmouseout=\\\"this.className=\'navlink-normal\'\\\"><a href=\\\"$url$sessionlink\\\" target=\\\"_self\\\" onclick=\\\"window.event.cancelBubble = true;\\\">$title</a>$_extra</div>\\n\";
}


// ###################### Start build_hacknavs ######################
// creates navpanel menu blocks for all hacks in the HTL that have this enabled
function build_hacknavs()
{
global $DB_site;
static $hackmenu;

$get_hack_navs = $DB_site->query(\"SELECT menubits FROM \" . TABLE_PREFIX . \"hack WHERE (options & \" . HTLSETTING_SHOWMENU . \") AND atstep=-1\");

while ($hackmenu = $DB_site->fetch_array($get_hack_navs))
{
construct_hack_nav($hackmenu[\'menubits\']);
}
}


// ###################### Start construct_hack_nav ##################
// takes $ser_data, which is a serialized array with info, and creates
// a whole menu block item out of it :)
function construct_hack_nav($ser_data)
{
global $vboptions;

$prefix = ($vboptions[\'htl_prefix_titles\']) ? $vboptions[\'htl_prefix_what\'] : \'\';

$data = unserialize($ser_data);

if (sizeof($data) > 1)
{
$title = $data[0];
unset($data[0]);
foreach($data as $displayorder=>$arry)
{
construct_nav_option($arry[\'text\'], $arry[\'url\'], \'<br />\');
}

construct_nav_group($prefix . $title, \'<hr />\');
construct_nav_spacer();
}
}', 1065286318, 1075038411, 'The file edit below adds some important functions for the navpanel.')
mysql error: Unknown column 'changetype' in 'field list'

mysql error number: 1054

Date: Saturday 08th of May 2004 12:14:38 PM

installed and working but when i try to view the hacks i installed i see nothing
http://www.monstergamer.net/vb/hacklog.php

please help

i have this issue myself I cant advance past step 2....it does step one and then when i tell it to continue it wont...it doenst show me the continue button or ne thing.....ne help here......

Just upgraded to vB 3.0.1 and installed the HTL - beauty! Great work.

Yes, all phrases are added - I now also found that I don't have access-right to modify any hack :surprised:

What is going on there ?

Where can I setup the rights for my admin-account that I can access and modify the hacks ?

Thanks for the hack. Installing it now.

Hi!

I have the same problem! :(
No menuitems and no descriptions.....
i think it is the german language.....


I install the "Multiple Profile Pictures" hack and i see only the selections but no descriptions or menuitems... (have a look to my attachments...)


thx

under the hack in question, you'd select edit hack details, then from there you add the userid of the admins you'd like access to install.

at least that's how its supposed to work.

Hi,
Just wantet to share that I did some research and found out what needed to be done to make the installation work past the step 2- missing button thing.

Here's the intructions I followed:
http://www.everythingvb.com/showpost...68&postcount=2

Is this useful for when you upgrade vBulletin?