Log in

View Full Version : Adding a column to owned_adoptables?


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