evolution-cms / evolution

                echo "  $name: " . $_lang['upgraded'] . PHP_EOL;

            } else {

                $q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',$category,$locked,'$input_options','$output_widget','$output_widget_params','$input_default');";

                if (!mysqli_query($sqlParser->conn, $q)) {

                    echo mysqli_error($sqlParser->conn) . PHP_EOL;

                    return;

                }

                echo "  $name: " . $_lang['installed'] . PHP_EOL;

            }

            } else {

                //$q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',(SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE `id` END) `id` FROM $dbase.`" . $table_prefix . "categories` WHERE `category` = '$category'),$locked,'$input_options','$output_widget','$output_widget_params','$input_default');";

                $q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',$category,$locked,'$input_options','$output_widget','$output_widget_params','$input_default');";

                if (!mysqli_query($sqlParser->conn, $q)) {

                    echo "<p>" . mysqli_error($sqlParser->conn) . "</p>";

                    return;

                }

                echo "<p>&nbsp;&nbsp;$name: <span class=\"ok\">" . $_lang['installed'] . "</span></p>";

            }