* upgrading but freshly installing. we would then end up running * version 0 -> 1 upgrade code which would fail */ $version = get_option('SV_HOVER_VERSION', HOVER_VERSION); if (FALSE === $version) { sv_hover_die("Could not determine Database version"); } if (0 == $version) { $alter = "ALTER table " . HOVER_TABLE . " add type tinytext NOT NULL"; $result = $wpdb->query($alter); if ($result === FALSE) { sv_hover_die("Could not update table", $alter); } $update = "UPDATE " . HOVER_TABLE . " set type='link'"; $result = $wpdb->query($update); if ($result === FALSE) { sv_hover_die("Could not update table", $update); } update_option('SV_HOVER_VERSION', 1); } if (1 == $version) { delete_option('SV_HOVER_PATH_BEHAVIOUR'); delete_option('SV_HOVER_PATH_DOMTT'); update_option('SV_HOVER_VERSION', 2); } if (2 == $version) { update_option('SV_HOVER_VERSION', 3); } if (3 == $version) { $sv_hover_options = array(version => 4, usecss => get_option('SV_HOVER_USECSS'), usejs => get_option('SV_HOVER_USEJS'), usefile => get_option('SV_HOVER_USEFILE'), move => get_option('SV_HOVER_MOVE'), blank => get_option('SV_HOVER_BLANK'), size_search => get_option('SV_HOVER_SIZESEARCH'), size_link => get_option('SV_HOVER_SIZELINK'), size_desc => get_option('SV_HOVER_SIZEDESCRIPTION'), fade => get_option('SV_HOVER_FADE'), fademax => get_option('SV_HOVER_FADEMAX'), replace => get_option('SV_HOVER_REPLACETITLES'), websnapr_link => get_option('SV_HOVER_WEBSNAPR_LINK'), websnapr_acronym => get_option('SV_HOVER_WEBSNAPR_ACRONYM'), maxreplace_abbr => get_option('SV_HOVER_MAXREPLACE_ABBR'), maxreplace_acronym => get_option('SV_HOVER_MAXREPLACE_ACRONYM'), maxreplace_link => get_option('SV_HOVER_MAXREPLACE_LINK')); update_option('SV_HOVER', $sv_hover_options, "Hover's options", 'no'); foreach (array('SV_HOVER_VERSION', 'SV_HOVER_USECSS', 'SV_HOVER_USEJS', 'SV_HOVER_USEFILE', 'SV_HOVER_MOVE', 'SV_HOVER_BLANK', 'SV_HOVER_SIZESEARCH', 'SV_HOVER_SIZELINK', 'SV_HOVER_SIZEDESCRIPTION', 'SV_HOVER_FADE', 'SV_HOVER_FADE_MAX', 'SV_HOVER_REPLACETITLES', 'SV_HOVER_WEBSNAPR_LINK', 'SV_HOVER_WEBSNAPR_ACRONYM', 'SV_HOVER_MAXREPLACE_ABBR', 'SV_HOVER_MAXREPLACE_ACRONYM', 'SV_HOVER_MAXREPLACE_LINK') as $option) {
function sv_hover_new_image() { global $wpdb; $result = $wpdb->query("INSERT INTO " . HOVER_IMAGES . " (src, text)" . " VALUES (" . "'" . $_POST['src0'] . "'," . "'" . $_POST['text0'] . "'" . ")"); if ($result === FALSE) { sv_hover_die('insert'); } }