[VietPirates]

Thank you, Krofh!

But got this error:

Invalid SQL:
UPDATE TABLE profilefield SET title='Quote Notification' where profilefieldid='[insert profilefieldid here]';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE profilefield SET title='Quote Notification' where profilefieldid='[insert ' at line 1
Error Number : 1064

Tried again:

Invalid SQL:
ALTER TABLE profilefield ADD title VARCHAR (255);

MySQL Error  : Duplicate column name 'title'
Error Number : 1060

Uninstall Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield ADD title VARCHAR (255)");
$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='[insert profilefieldid here]'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");