Administrative and Maintenance Tools - Template Modification System

Template Modification System
Description
This modification allows easy management of template modifications.
Hack authors can define the necessary template modifications for their products.
When exporting a product, all template modifications assigned to this product
in MASTER style will be embedded into the product XML and imported on the
end-user vBulletin installation automatically if TMS is available.
Alternatively, it is also possible to create separate XML files for template modifications.
This way, 3rd parties can provide Template-Modification XML files for existing hacks.
Hack authors can also export standard template modification instructions as
textfiles to package them with their hacks, which allows users that do not
have TMS to also install them

In case the author defined modifications do not work (eg. the user uses a custom style),
the users can easily customize the modifications for their style(s).

TMS modified templates transparently, e.g. all Templates can still be modified
manually in style manager - they will appear unchanged there.


System Requirements
This Modification requires MySQL 4.1 or higher - it does not work with MySQL 4.0!
If you use MySQL 4.1 series, MySQL 4.1.10 or higher is required
If you use MySQL 5.0 series, MySQL 5.0.3 or higher is required
TMS 1.2.0 Beta 1 or higher requires vBulletin 4.1.5 or higher

vBulletin Compatibility
Versions up to and including 1.1.5 are compatible with vBulletin 3.6.X, 3.7.X and 3.8.X
Version 1.1.5 is partly compatible with vBulletin 4.0.X and 4.1.X
Version 1.2.0 Beta 1 or higher is compatible with vBulletin 4.1.5 or higher
vBulletin 4.1.11 or higher is currently not fully supported by TMS. If you use this version please apply the following patch: tms_patch120b4.zip

Branding:
Please note that TMS puts a small branding/copyright notice in footer - see readme.txt for further details.

Version History
1.2.0 Beta 4

• Bugfix: Database error when trying to add a template modification (this bug was introduced in TMS 1.2.0 Beta 3)

1.2.0 Beta 3

• Changed: Converted hardcoded text to phrases
• New Feature: Added doubleclick for editing style variables
• Bugfix: Database error when trying to add a template modification with an existing varname to a different style
• Changed: Fixed formatting of templateedits.php
• Bugfix: Fixed erors when manually modifying a template with template modifications

1.2.0 Beta 2

• Bugfix: Fixed errors in style variable editing code

1.2.0 Beta 1

• Changed: Ported to vBulletin 4.1
• New Feature: If an error occurs while trying to compile a template this error is now being disaplayed when trying to save the template modification
• New Feature: Styles variables used in templates can be edited via AJAX from the modify template screen

1.1.5

• Fixed Bug: Fixed incorrect variable type
• New Feature: Box 'Template-Modifications' (shown on editing a template) can now be collapsed/expanded

1.1.4

• Fixed Bug: Fixed HTML error/XSS in Template Modifications Manager

1.1.3

• Fixed Bug: Added missing phrase on ACP home

1.1.1

• Fixed Bug: Fixed Error with conflicting Template Modifications when importing a product
• Fixed Bug: Removed Pre-Selection of processing mode when adding new modifications
• Fixed Bug: Fixed Bug with zlib.output_compression AND vBulletin internal gzip being both turned on
• Fixed Bug: Display search results correctly
• Fixed Bug: Added missing phrase 'varname_x_already_exists'
• New Feature: Automatically rebuild template modifications after vBulletin Upgrade

1.0.0

• Changed: Several files renamed
• Fixed Bug: Fixed incorrect handling of product ids that contain only numbers
• New Feature: Search text can be search in template when editing a Template-Modification in Style Manager
• Changed: Multiple Template-Modifications can be loaded via AJAX
• First Release on vBulletin.org

1.0.0 RC 1

• Fixed Bug: All Bugs reported for Beta 4 have been fixed
• Changed: Display of modified Templates with HTML comments has been modified
• Changed: Debug-Mode is no longer required
• New Feature: It is now possible to export/import style-specific Template-Modifications

1.0.0 Beta 4

• Fixed Bug: All Bugs reported for Beta 3 have been fixed
• Changed: Sorting in Template Modifications Manager has been changed
• New Feature: When adding or editing a Template-Modification, the Template can now be displayed and searched via AJAX
• Changed: When exporting as Text, the original instructions (eg. insert below/above) are retained
• New Feature: It is now possible to test each Template-Modification
• New Feature: Testing improved. It is now being display if a Template is OK after applying a Template Modification
• New Feature: When editing a Template, it is possible to activate/deactvate multiple Template-Modifications
• New Feature: Template-Modifications can now also be exported and tested from withing Product Manager
• New Feature: Function to display a template with all Modifications applied.
  This function can also display embedded comments to make it easier to identify changed parts

1.0.0 Beta 3

• Fixed Bug: All Bugs reported for Beta 2 have been fixed
• New Feature: Simplified adding Template-Modifications by allowing to select how to handle replacement text (eg. replace or insert above/below)
• New Feature: Each Template-Modification can now be disabled
• Changed: Testing Template-Modifications has been reworked:
  Column ordering can now be set through vBulletin Options; column headers are clickable to sort results
  Output has been separated by styles
  It is now possible to test only selcted products
• New Feature: TMS now integrates with 'Style Manager' and 'Product Manager'
• New Feature: The language can be selected when exporting Template-Modifications
• New Feature: Weh TMS gets deactivated, all Template-Modifications will be deactivated too
• New Feature: Display of Template-Modifications while editing a Template in Style Manager has been improved:
  It is now being display if a Template-Modification could be applied
  Template-Modifications can be edited via AJAX

1.0.0 Beta 2
First public Beta

[Videx]

When you search this mod for "illegal collations", what do you see? Obviously your post is at the top, but surely you must see mine below that?

I agonized over that problem for weeks. I'm still a little pissed about it I guess, sorry. Especially if people are going to keep posting the problem even after I posted a solution for it.

[PGAmerica]

There is no reason to get angry. I saw your post. Your solution requires that I backup my 450MB database, run a "search and replace" and then re-upload the 450MB database. This is an impossible solution for me. There is just no way to do that on such a large, large, large database.

[dartho]

Look here: http://www.phpwact.org/php/i18n/utf-8/mysql

[PGAmerica]

Thank you dartho. That was very helpful. I also found that I can change the overall characterset in phpMyAdmin using the "operations" tab.

[TheLastSuperman]

wtf... out of line a bit I might be but rest assured your sanity is safe with me...

Originally Posted by Videx

How can anyone with 314 posts not read back before posting a question like that? Did you just dive into this mod and try to install it without bothering to read the earlier posts?

How can someone w/ 500+ not understand the need for tact on here in regards to coders simply not understanding the inner workings of every aspect of every coding language nor the need to read 500 posts or 800 pages to find an answer that should be in the first post to begin with? - We all are trying, even the most experienced

Originally Posted by PGAmerica

35 pages. I did a search in this thread and read through many posts stating the same thing. Instead of just chewing me out, how about telling me which post you are referring too? I read about people being told to fix their database over and over again, but I saw nothing about how to do it. My forums have been working perfectly. I find it hard to believe that the database is screwed up.

Videx is not saying your db is messed up, from the admin panel disable the mod. What he should of said is your DB's collation is not the same, just like the error reads:

MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Error Number : 1267

Note the red.

Now you can try changing the collation via phpmyadmin if you have that or another alternative. Backup your DB before doing anything in any editor etc. If it works fine then uninstall the currently disabled mod, leave any files if present but install it again via the product etc, then it should work.

S-MAN

[Videx]

Originally Posted by PGAmerica

This is an impossible solution for me. There is just no way to do that on such a large, large, large database.

I'm not sure why you feel there's no way to restore your db (I assume you're backing it up regardless).

But if that's the case, I also gave a link to a programmatic solution. However, that was taking forever for me as it would fail every few lines, and taking the time to make the corrections manually got onerous really fast.

[Andreas]

Erm ... you don't have to dump the whole database just to fix a couple illegal collations.

just take a look at your DB, find out which collation is being used most often, adjust the new tables/fields that generate error accordingly and you're done.

[Videx]

Originally Posted by Andreas

adjust the new tables/fields that generate error accordingly and you're done.

You almost make that sound easy. But where were you when I was trying to fix mine? I would have gladly given you access to adjust these fields for me.

Fact is, in my case about 80 tables were different collations, and after sitting down one day and manually changing each one in PHPMyAdmin, I discovered that only changes the tables, not the fields within! A real PITA that hadn't bothered me at all until I tried to install this mod.

[TaMpE]

am I limited to editing only these templates?



I'm trying to edit showthread through TMS.

EDIT: I just read that I can onyl use TMS on templates I already edit so if I already manually edit the template I want why am I also adding that edits in TMS? I'm confused.

and do I always have to edit manually first to make it appear in the drop down list of TMS then change the one I manually edited back to the default and then add the edits in TMS? Someone share me how you do it.

[slyreptile]

Originally Posted by TaMpE

am I limited to editing only these templates?



I'm trying to edit showthread through TMS.

EDIT: I just read that I can onyl use TMS on templates I already edit so if I already manually edit the template I want why am I also adding that edits in TMS? I'm confused.

and do I always have to edit manually first to make it appear in the drop down list of TMS then change the one I manually edited back to the default and then add the edits in TMS? Someone share me how you do it.

In your Template Modifications Manager, select Add Template-Modification under the MASTER STYLE dropdown box. This allows you to create the template edit for all styles without actually manually editing any template beforehand.