Dear developers, after removal Profile Hover Pro 1.4.0 remain in a field database which creates Profile Hover Pro during the installation. How them to remove from a database now?
Repeated installation gives nothing, but only still in addition creates the same fields.
On a screenshot it is visible that they remain, I have already removed phrases but the code itself remained in a forum database.
http://s018.radikal.ru/i509/1201/dd/38ef6e564432.jpg
Here a code actually from xml a product:
Repeated installation gives nothing, but only still in addition creates the same fields.
On a screenshot it is visible that they remain, I have already removed phrases but the code itself remained in a forum database.
http://s018.radikal.ru/i509/1201/dd/38ef6e564432.jpg
Here a code actually from xml a product:
$max_prof_qry = $vbulletin->db->query_read_slave("SELECT MAX(profilefieldid) AS MaxID FROM " . TABLE_PREFIX . "profilefield");
$max_prof_id = $db->fetch_array($max_prof_qry);
$max_prof_id = $max_prof_id['MaxID'] + 1;
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html, perline, profilefieldcategoryid) VALUES (" . $max_prof_id . ", 3, 1, 100, 25, 20, 1, 'radio', 'a:2:{i:0;s:2:\"No\";i:1;s:3:\"Yes\";}', 0, 1, 0, 0, 0, '', 5, 0, 0, 0)");
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield ADD field" . $max_prof_id . " MEDIUMTEXT NULL");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "userfield SET field" . $max_prof_id . " = 'No'");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "phrase (languageid, varname, text, product, fieldname, username, dateline, version) VALUES
(0, 'field" . $max_prof_id . "_desc', 'Откючить всплывающее окошко, при наведении мышки на ник пользователя?', 'vbulletin', 'cprofilefield', 'Dylan', '0', '1.2.0'),
(0, 'field" . $max_prof_id . "_title', 'Отключить всплывающее окно', 'vbulletin', 'cprofilefield', 'Dylan', '0', '1.2.0')");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "setting SET value = 'field" . $max_prof_id . "' WHERE varname='dbtech_ph_disable_field'");
build_options();
Attachments
Last edited: