Tkrules
01-22-2010, 06:09 PM
Hello all. I recently installed the adoptable script on our site. I need to add a column to 'owned_adoptables' but I cannot find it and have no idea where it could be or how to edit it. If anyone could help I'd be grateful.
powerchaos
01-22-2010, 10:02 PM
doesnt the script does it for you ?? the installer ??
els open install.sql and find that rule in there , copy that rule and edit a little so it fits your database
then enter it into your database (dont forget to take the first lines to , to inport the file manual then it looks like this )
NOTE : THIS IS A EXAMPLE AND CAN NOT BE USED
--
-- table structures for table `styles`
--
DROP TABLE IF EXISTS `styles`;
CREATE TABLE IF NOT EXISTS `styles` (
`id` int(100) NOT NULL auto_increment,
`active` char(1) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`dir` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- data get executed for table `styles`
--
INSERT INTO `styles` (`id`, `active`, `name`, `dir`) VALUES
(1, '1', 'Elite Ladders Default', 'default');
-- --------------------------------------------------------
now , get that second part and change it to the right value's so you see like it is
if it got a table prefix , make it then like this
INSERT INTO `PREFIX_styles` (`id`, `active`, `name`, `dir`) VALUES
(1, '1', 'Elite Ladders Default', 'default');
and it will be fine :D
Greets From PowerChaos
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.