[River_rush]

Originally Posted by pargoff

i'm trying to troubleshoot an existing vbgarage where no one can create or edit their cars in the garage. is there a control panel for vbgarage somewhere or do you have to do everyting from phpmyadmin?

yes you can add extra questions in, I have added engine type to a test forum after editing the xml and the php file. but it only shows the new field on a fresh install or after uninstalling then reinstalling again, or i can install the xml file with the old database still installed and then manually edit in the "engine" field through mysqladmin and it will work.
What it wont do, is add the field in via the xml when upgrading an existing installation.

I assume this is because its looking for the table exists statement and then as it already exists leaves it alone without inserting the extra field.
I have no idea how to re-write the sql statement to check if the extra fields exist and then if not to create them


$db->query("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "vbgarage_users (
`userid` int(10) unsigned NOT NULL default '0',
`year` varchar(20) NOT NULL default '',
`make` varchar(30) NOT NULL default '',
`model` varchar(40) NOT NULL default '',
`engine` varchar(50) NOT NULL default '',
`text` mediumtext NOT NULL,
`lastactivity` int(60) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) TYPE=MyISAM"
);


I hope this makes sense!

The screenshots below are of the standard tweaked install and not the install with the extra fields