query($sql); $t2 = str_replace("%%T2_TABLE_NAME%%", $table_prefix.STARRATING_TPLT2_TABLE, $t2); $wpdb->query($t2); } function import_templates_own($t2) { global $wpdb, $table_prefix; $templates = array(); foreach ($t2 as $tpl) { $parts = explode("|", $tpl, 4); $sql = sprintf("insert into %s%s (`section`, `name`, `description`, `elements`, `preinstalled`, `default`) values ('%s', '%s', '%s', '%s', '0', '0')", $table_prefix, STARRATING_TPLT2_TABLE, $parts[0], $parts[1], $parts[2], $parts[3]); $wpdb->query($sql); $tpl_id = $wpdb->insert_id; $templates[] = array("section" => $parts[0], "tpl_id" => sprintf("%s", $tpl_id)); } if (count($templates) > 0) { include(STARRATING_PATH.'code/t2/templates.php'); $depend = array(); foreach ($tpls->tpls as $tpl) { $section = $tpl->code; $sql = sprintf("select template_id from %s%s where section = '%s' and preinstalled = '1'", $table_prefix, STARRATING_TPLT2_TABLE, $section); $tpl_id = intval($wpdb->get_var($sql)); $depend[$section] = $tpl_id; } foreach ($templates as $tpl) { $dep = array(); $t = $tpls->get_list($tpl["section"]); foreach ($t->tpls as $tag) { $s = $tag->code; $dep[$s] = sprintf("%s", $depend[$s]); } if (count($dep) > 0) { $sql = sprintf("update %s%s set dependencies = '%s' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, serialize($dep), $tpl["tpl_id"]); $wpdb->query($sql); } } } } function rewrite_dependencies($section, $id) { global $wpdb, $table_prefix; include($this->plugin_path.'code/t2/templates.php'); $sections = $tpls->find_sections_depending($section); $sql = sprintf("select template_id, dependencies from %s%s where section in ('%s')", $table_prefix, STARRATING_TPLT2_TABLE, join("', '", $sections)); $rows = $wpdb->get_results($sql); foreach ($rows as $row) { $dep = unserialize($row->dependencies); $dep[$section] = $id; $sql = sprintf("update %s%s set dependencies = '%s' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, serialize($dep), $row->template_id); $wpdb->query($sql); } } function rewrite_defaults($code, $id) { global $wpdb, $table_prefix; $sql = sprintf("update %s%s set `default` = '0' where section = '%s'", $table_prefix, STARRATING_TPLT2_TABLE, $code); $wpdb->query($sql); $sql = sprintf("update %s%s set `default` = '1' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, $id); $wpdb->query($sql); } function get_templates($section = '', $default_sort = false, $only_default = false) { global $wpdb, $table_prefix; if ($section != '') $section = sprintf(" WHERE section = '%s'", $section); $default_sort = $default_sort ? "`default` desc, preinstalled desc, " : ""; $default_limit = $only_default ? " LIMIT 0, 1" : ""; $sql = sprintf("select * from %s%s%s order by %stemplate_id asc%s", $table_prefix, STARRATING_TPLT2_TABLE, $section, $default_sort, $default_limit); if ($only_default) return $wpdb->get_row($sql); return $wpdb->get_results($sql); } function get_template($id) { global $wpdb, $table_prefix; $sql = sprintf("SELECT * FROM %s%s WHERE `template_id` = %s", $table_prefix, STARRATING_TPLT2_TABLE, $id); return $wpdb->get_row($sql); } function get_templates_dep() { global $wpdb, $table_prefix; $sql = sprintf("select * from %s%s order by template_id", $table_prefix, STARRATING_TPLT2_TABLE); return $wpdb->get_results($sql); } function get_templates_paged($section = '', $start = 0, $limit = 20) { global $wpdb, $table_prefix; if ($section != '') $section = sprintf(" WHERE section = '%s'", $section); $sql = sprintf("select * from %s%s%s limit %s, %s", $table_prefix, STARRATING_TPLT2_TABLE, $section, $start, $limit); return $wpdb->get_results($sql); } function get_templates_count($section = '') { global $wpdb, $table_prefix; if ($section != '') $section = sprintf(" WHERE section = '%s'", $section); $sql = sprintf("select count(*) from %s%s%s", $table_prefix, STARRATING_TPLT2_TABLE, $section); return $wpdb->get_var($sql); } function set_templates_dependes($post) { global $wpdb, $table_prefix; foreach ($post as $id => $dep) { $sql = sprintf("update %s%s set dependencies = '%s' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, serialize($dep), $id); $wpdb->query($sql); } } function set_templates_defaults($post) { global $wpdb, $table_prefix; foreach ($post as $code => $value) { $sql = sprintf("update %s%s set `default` = '0' where section = '%s'", $table_prefix, STARRATING_TPLT2_TABLE, $code); $wpdb->query($sql); $sql = sprintf("update %s%s set `default` = '1' where template_id = %s", $table_prefix, STARRATING_TPLT2_TABLE, $value); $wpdb->query($sql); } } function edit_template($general, $elements) { global $wpdb, $table_prefix; $sql = sprintf("UPDATE %s%s SET `section` = '%s', `name` = '%s', `description` = '%s', `elements` = '%s', `dependencies` = '%s', `preinstalled` = '%s' WHERE `template_id` = %s", $table_prefix, STARRATING_TPLT2_TABLE, $general["section"], $general["name"], $general["description"], serialize($elements), serialize($general["dependencies"]), $general["preinstalled"], $general["id"]); $wpdb->query($sql); return $general["id"]; } function delete_template($id) { global $wpdb, $table_prefix; $sql = sprintf("DELETE FROM %s%s WHERE `template_id` = %s", $table_prefix, STARRATING_TPLT2_TABLE, $id); return $wpdb->query($sql); } function add_template($general, $elements) { global $wpdb, $table_prefix; $sql = sprintf("INSERT INTO %s%s (`section`, `name`, `description`, `elements`, `dependencies`, `preinstalled`, `default`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '0')", $table_prefix, STARRATING_TPLT2_TABLE, $general["section"], $general["name"], isset($general["description"]) ? $general["description"] : "", serialize($elements), serialize($general["dependencies"]), $general["preinstalled"]); $wpdb->query($sql); return $wpdb->insert_id; } } class gdTemplateHelper { function render_templates_section($section, $name, $selected = "0", $width = 205) { $templates = gdTemplateDB::get_templates($section, true); ?>