Alright I made some headway but I'm having problems with the $vbphrase. Here's what I did to correct my problem. I couldn't get rid of the old XML file because the SQL wouldn't let it finish. The problem was that it was trying to remove a table that wasnt there. So I simply took the lines out.
Everything highlighted is what I deleted from the XML and then I saved the file and re-uploaded it.
Code:
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile (
userid INT UNSIGNED NOT NULL DEFAULT '0',
filedata MEDIUMTEXT NOT NULL,
dateline INT UNSIGNED NOT NULL DEFAULT '0',
filename VARCHAR(100) NOT NULL DEFAULT '',
visible SMALLINT NOT NULL DEFAULT '1',
filesize INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (userid))");
]]>
</installcode>
- <uninstallcode>
- <![CDATA[
$db->query_write("DROP TABLE " . TABLE_PREFIX . "customfile");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` DROP `tdban` ");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '50' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '51' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '52' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '53' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '54' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '55' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '56' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '57' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '58' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '59' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '60' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '61' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '62' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '63' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '64' LIMIT 1");
$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '65' LIMIT 1");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` DROP `field51` ,
DROP `field52` ,
DROP `field53` ,
DROP `field54` ,
DROP `field55` ,
DROP `field56` ,
DROP `field57` ,
DROP `field58` ,
DROP `field59` ,
DROP `field60` ,
DROP `field61` ,
DROP `field62` ,
DROP `field63` ,
DROP `field64` ,
DROP `field65`");
I had to change "field51" to "field52" and then delete the whole line that has "field52". This may or may not apply to zincpony it just depends on what tables and fields were created for him.
After I re-uploaded it I was able to do a clean uninstallation of the product. After that I uploaded the new product-timeslips1.2.xml and everything worked fine except for the $vbphrase function. For some reason some of them were giving me problems. I couldn't get the following to show up at all:
Code:
$vbphrase[timeslips]
$vbphrase[edit_timeslips]
$vbphrase[yes]
$vbphrase[no]
$vbphrase[timeslips_keep_current_timeslip]
$vbphrase[timeslips_keep_current_timeslip_define]
$vbphrase[timeslips_upload_timeslip_from_computer]