evolution-cms / evolution

                            $errorData = true;

                            break;

                        }

                        if (!is_null($save_sql_id_as)) {

                            $sql_id = @mysqli_insert_id($sqlParser->conn);

                            if (!$sql_id) {

                                $query = "SELECT id FROM $dbase.`" . $table_prefix . "site_templates` WHERE templatename='$name' LIMIT 1;";

                                $idQuery = mysqli_fetch_assoc(mysqli_query($sqlParser->conn, $query));

                                $sql_id = $idQuery['id'];

                            }

                            $custom_placeholders[$save_sql_id_as] = $sql_id;

                        }

                    } else {

                        $installDataLevel['templates'][$moduleTemplate[0]]['type'] = 'create';

                        $query = "INSERT INTO $dbase.`" . $table_prefix . "site_templates` (templatename,description,content,category,locked) VALUES('$name','$desc','$template',$category_id,'$locked');";

            $category = mysqli_real_escape_string($sqlParser->conn, $category);

            $rs = mysqli_query($sqlParser->conn,

                "SELECT id FROM $dbase.`" . $table_prefix . "categories` WHERE category = '" . $category . "'");

            if (mysqli_num_rows($rs) && ($row = mysqli_fetch_assoc($rs))) {

                $category_id = $row['id'];

            } else {

                $q = "INSERT INTO $dbase.`" . $table_prefix . "categories` (`category`) VALUES ('{$category}');";

                $rs = mysqli_query($sqlParser->conn, $q);

                if ($rs) {

                    $category_id = mysqli_insert_id($sqlParser->conn);

                }

            }

        }

        return $category_id;