vb.org Archive - Administrative and Maintenance Tools

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Template Modification System (https://vborg.vbsupport.ru/showthread.php?t=152931)

hi
what is this mean pls
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT IF(templateedit.product='vbulletin', 1, product.active) AS productactive, templateedit.active AS editactive, templateedit.version AS editversion, template.version AS templateversion, templateeditlocation.product, templateeditid, templateedit.styleid AS tstyleid, template.styleid, template.title AS template, templateeditlocation.title, template.template_un, searchstrregex, IF(templateeditlocation.product='vbulletin', 'vBulletin', product.title) AS product, templateedit.replacestr
FROM templateedit AS templateedit
INNER JOIN templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname )
INNER JOIN template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN product AS product ON (product.productid=templateeditlocation.product)
WHERE (NOT ISNULL(style.styleid) OR (templateedit.styleid = -1 AND template.styleid = -1))
AND (templateedit.product = 'vbulletin' OR product.active = 1)
AND templateedit.active = 1
AND templateeditlocation.varname != 'tmsbranding'

AND templateeditlocation.product = 'tms'
ORDER BY style.displayorder ASC, style.styleid ASC, template.title ASC, product.title ASC, templateeditlocation.title ASC;

MySQL Error : Unknown column 'searchstrregex' in 'field list'
Error Number : 1054
Date : Thursday, August 16th 2007 @ 08:05:49 AM
Script : http://xxx.com/vb/admincp/templateed...oductid=tms&s=
Referrer : http://xxx.com/vb/admincp/index.php
IP Address : ............
Username : ...........
Classname : vb_database

now evrything is stop
cant remove any thing
help pls

Quote:

Originally Posted by Alfa1 (Post 1318508)

I just noted that the TMS adds branding to my BFO vbulletin. How can this be removed?

you can't ....

Quote:

This work is Copyright (C) 2005-2007 by Andreas Kirbach.
The license holder is allowed to use and modify the script for his own use.
However, removing or editing the branding is NOT allowed!

also read readme.txt there is some info that migt become usefull ...

Suggestions:
- Option to don't specify a "Search for Text" in selected template; instead, another two options to "put at the very top" and "put at the very bottom" of the selected template. Just to be lazy, really (and not put the part of the html in certain template that belongs to the very top, and then select "insert text above".
- Search in template modifications. With a lot of TMS installed, would be nice to search like if that modifications are actually templates; similar (a clone) of the search in templates.

Thanks... again... Andreas, for this every-day-more-really-awesome-upgrade-pain-saver mod!
TC

Hey Andreas, how could I get this to work with your advanced plugin manager?

Like the dropdown doesnt show how to export the txt files?

Thanks in advanced.

@TCAttitude
Search is already planned.
Inserting at the top/end probably would need some significatin changes to the design and I don't think it is that important?

@whitemike
open advplugins.php and search for

Code:

case 'productexport': page = "plugin.php?do=productexport&productid="; break;

Add below:

Code:

                case 'tmsdeleteedits': page = "templateedits.php?do=deleteall&productid="; break;

                case 'tmstestproduct': page = "templateedits.php?do=test&productid="; break;

                case 'tmsexport': page = "templateedits.php?do=files&productid="; break;

Search for

Code:

$options['productexport'] = $vbphrase['export'];

Replace with:

Code:

        if ($vbulletin->products['tms'])

        {

            $options['productexport'] = $vbphrase['export'] . '<optgroup label="' . $vbphrase[templateedits] . '"><option value="tmstestproduct">' . $vbphrase[test] . '</option><option value="tmsdeleteedits">' . $vbphrase[delete] . '</option><option value="tmsexport">' . $vbphrase[export] . '</option></optgroup>';

        }

        else

        {

            $options['productexport'] = $vbphrase['export'];

        }

Kind Regards,

Stoebi

Quote:

Originally Posted by Stoebi (Post 1321125)

@whitemike
open advplugins.php and search for

Code:

case 'productexport': page = "plugin.php?do=productexport&productid="; break;

Add below:

Code:

                case 'tmsdeleteedits': page = "templateedits.php?do=deleteall&productid="; break;

                case 'tmstestproduct': page = "templateedits.php?do=test&productid="; break;

                case 'tmsexport': page = "templateedits.php?do=files&productid="; break;

Search for

Code:

$options['productexport'] = $vbphrase['export'];

Replace with:

Code:

        if ($vbulletin->products['tms'])

        {

            $options['productexport'] = $vbphrase['export'] . '<optgroup label="' . $vbphrase[templateedits] . '"><option value="tmstestproduct">' . $vbphrase[test] . '</option><option value="tmsdeleteedits">' . $vbphrase[delete] . '</option><option value="tmsexport">' . $vbphrase[export] . '</option></optgroup>';

        }

        else

        {

            $options['productexport'] = $vbphrase['export'];

        }

Kind Regards,

Stoebi

Awesome, Thanks bro

neeeeeeeeeed help pls
my database is ++++t up
cant remove or add any products
it keep giveing me
this

https://vborg.vbsupport.ru/showpost....1&postcount=91

come on my forum is stop
pls help

gibt es diesen HAck auch in german ????

J.

Quote:

Originally Posted by saininja (Post 1325304)

gibt es diesen HAck auch in german ????

J.

[ot]ja, gibt es!sobald das neue offizielle deutsche hackboard online geht, "bin ich mir sicher"/(wissen kann mans ja nie) das andreas den dort auch wieder reinstellt[/ot]

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01857 seconds Memory Usage 1,753KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: