Inserting a template via SQL Query

[Artashes]

Hello

I am trying to insert new templates via SQL from an external application with the vb database as its database.

The template itself is being inserted correctly into the database. I have made it so that if the template name i supply my script with matches a template name in the database it copies the code (template and template_un), otherwise the template is blank.

This is all acting as I want it.

However, when I make modifications to a template which has the same name as a vb default, it does not result in any of the changes being made to the theme. In fact, when I go to the style manager in the admincp, it does not seem to realise that there is a customised version of the template (it is not red). When I make modifications to the one in the style manager it says that there is already a template and any modifications will override it.

Am I missing something here? How do I get vB to realise that there is a customised version of a default template?

Thanks,

[kh99]

Looking at admincp/template.php in the "if ($_POST['do'] == 'updatetemplate')" section (around line 2236), it looks like if you are changing .css templates you need to call build_style() after (in includes/adminfunctions_template.php). Also if you change a template starting with 'bbcode_' you need to truncate the 'postparsed' table (but I'm guessing that's not part of the problem you're having).

[Artashes]

Aye. That's where I've been looking. The templates are neither bbcode nor css, so it doesn't apply

I do everything that template.php does, I think!

This is the data I'm entering:

PHP Code:

            $data = array(
                'templateid'   => '', 
                'styleid'      => $tStyleId,
                'title'        => $name,
                'template'     => $tTemplate,
                'template_un'  => $tTemplateUn,
                'templatetype' => 'template',
                'dateline'     => $tTime,
                'username'     => 'Artashes',
                'version'      => '4.1.5',
                'product'      => 'vbulletin',
                'mergestatus'  => 'none' 
            );

            if($this->db->insert('template', $data)){
                return TRUE;            
            } else {
                return FALSE;
            } 


The app uses CodeIgniter's database driver.

But I don't think this is the problem: everything is entered fine. I'll try entering a row into the adminlog.

[kh99]

I was looking at the wrong section. When you're modifying a template for a style that was inheriting that template, $_POST['do'] is set to 'inserttemplate'. In that section of the code it always calls print_build_style().

Edit: Specifically, it looks like the style table has a list of template ids for all templates in that style. Looks like a serialized array of arrays, so maybe if you don't want to call build_style you could try just updating that field.

[Artashes]

You know what? I just discovered that myself! Coincidence much!? Just trying to get it to work now!

--------------- Added [DATE]1314837575[/DATE] at [TIME]1314837575[/TIME] ---------------

Neither worked for me