Status
Not open for further replies.

paradox

Customer
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:

$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

  • 38ef6e564432.jpg
    38ef6e564432.jpg
    37 KB · Views: 5
Last edited:
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:

It is a user profile field, you can remove it through the ACP

ACP->User Profile Fields->User Profile Field Manager
Delete the fields with no title since you deleted the phrases.
 
Status
Not open for further replies.

Legacy Profile Hover

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
391
Customer rating
0.00 star(s) 0 ratings
Back
Top